systables(177): nkeys=2, recsize=177, idxsize=1024, nrecords=23
sys2table(561): nkeys=3, recsize=561, idxsize=1024, nrecords=23
Alter Indexes for bkdetail          
drop index tbvenkey;
Alter Columns for bkdetail          
Alter Columns for bkdetail          
1) Alter Columns for bkdetail          
2) Alter Columns for bkdetail          
3) Alter Columns for salamount          type=8 (tabid=112)
alter table bkdetail
    add(salamount money)2) Alter Columns for bkdetail          
3) Alter Columns for descript           type=0 (tabid=112)
,
    add(descript char(20) before salamount)2) Alter Columns for bkdetail          
3) Alter Columns for departdate         type=7 (tabid=112)
,
    add(departdate date before descript)2) Alter Columns for bkdetail          
3) Alter Columns for ship               type=0 (tabid=112)
,
    add(ship char(6) before departdate)2) Alter Columns for bkdetail          
3) Alter Columns for supplier           type=0 (tabid=112)
,
    add(supplier char(6) before ship)2) Alter Columns for bkdetail          
3) Alter Columns for bookdate           type=7 (tabid=112)
,
    add(bookdate date before supplier)2) Alter Columns for bkdetail          
3) Alter Columns for bkno               type=2 (tabid=112)
,
    add(bkno integer before bookdate)2) Alter Columns for bkdetail          
3) Alter Columns for recno              type=6 (tabid=112)
,
    add(recno serial before bkno)2) Alter Columns for bkdetail          
6) Alter Columns for bkdetail          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for bkdetail          
10) Alter Columns for bkdetail          
Alter Indexes for bkdetail          
create unique index bkdbkno on bkdetail (bkno, recno);
create unique index bkdtest on bkdetail (supplier, ship, departdate, recno);
create  index bkdtrip on bkdetail (supplier, ship, departdate);
create  index bkdsupdepart on bkdetail (supplier, departdate);
create  index bkdsupbook on bkdetail (supplier, bookdate);
Alter Indexes for bkmaster          
drop index tbvenkey;
Alter Columns for bkmaster          
Alter Columns for bkmaster          
1) Alter Columns for bkmaster          
2) Alter Columns for bkmaster          
3) Alter Columns for salamount          type=8 (tabid=112)
alter table bkmaster
    add(salamount money)2) Alter Columns for bkmaster          
3) Alter Columns for agent              type=0 (tabid=112)
,
    add(agent char(4) before salamount)2) Alter Columns for bkmaster          
3) Alter Columns for bookdate           type=7 (tabid=112)
,
    add(bookdate date before agent)2) Alter Columns for bkmaster          
3) Alter Columns for name               type=0 (tabid=112)
5a) Alter Columns for bkmaster          
2) Alter Columns for bkmaster          
3) Alter Columns for bkno               type=6 (tabid=112)
,
    add(bkno serial before name)2) Alter Columns for bkmaster          
6) Alter Columns for bkmaster          
,
    drop(code),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for bkmaster          
10) Alter Columns for bkmaster          
Alter Indexes for bkmaster          
create unique index bkmbkno on bkmaster (bkno);
create unique index bkmname on bkmaster (name, bkno);
create  index bkmagent on bkmaster (agent, bookdate, bkno);
create  index bkmbookdate on bkmaster (bookdate, bkno);
Alter Indexes for bknote            
drop index tbvenkey;
Alter Columns for bknote            
Alter Columns for bknote            
1) Alter Columns for bknote            
2) Alter Columns for bknote            
3) Alter Columns for note               type=0 (tabid=112)
alter table bknote
    add(note char(45))2) Alter Columns for bknote            
3) Alter Columns for seqno              type=2 (tabid=112)
,
    add(seqno integer before note)2) Alter Columns for bknote            
3) Alter Columns for recno              type=2 (tabid=112)
,
    add(recno integer before seqno)2) Alter Columns for bknote            
3) Alter Columns for bkno               type=2 (tabid=112)
,
    add(bkno integer before recno)2) Alter Columns for bknote            
6) Alter Columns for bknote            
,
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for bknote            
{ !!! OUT OF ORDER !!! bknote.code (bkno              )}
{ !!! OUT OF ORDER !!! bknote.bkno (recno             )}
{ !!! OUT OF ORDER !!! bknote.recno (seqno             )}
{ !!! OUT OF ORDER !!! bknote.seqno (note              )}
10) Alter Columns for bknote            
Alter Indexes for bknote            
create unique index bknotekey on bknote (bkno, recno, seqno);
Alter Indexes for emailmsg          
drop index tbvenkey;
Alter Columns for emailmsg          
Alter Columns for emailmsg          
1) Alter Columns for emailmsg          
2) Alter Columns for emailmsg          
3) Alter Columns for msg8               type=0 (tabid=112)
alter table emailmsg
    add(msg8 char(75))2) Alter Columns for emailmsg          
3) Alter Columns for msg7               type=0 (tabid=112)
,
    add(msg7 char(75) before msg8)2) Alter Columns for emailmsg          
3) Alter Columns for msg6               type=0 (tabid=112)
,
    add(msg6 char(75) before msg7)2) Alter Columns for emailmsg          
3) Alter Columns for msg5               type=0 (tabid=112)
,
    add(msg5 char(75) before msg6)2) Alter Columns for emailmsg          
3) Alter Columns for msg4               type=0 (tabid=112)
,
    add(msg4 char(75) before msg5)2) Alter Columns for emailmsg          
3) Alter Columns for msg3               type=0 (tabid=112)
,
    add(msg3 char(75) before msg4)2) Alter Columns for emailmsg          
3) Alter Columns for msg2               type=0 (tabid=112)
,
    add(msg2 char(75) before msg3)2) Alter Columns for emailmsg          
3) Alter Columns for msg1               type=0 (tabid=112)
,
    add(msg1 char(75) before msg2)2) Alter Columns for emailmsg          
3) Alter Columns for msgcode            type=0 (tabid=112)
,
    add(msgcode char(8) before msg1)2) Alter Columns for emailmsg          
6) Alter Columns for emailmsg          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for emailmsg          
10) Alter Columns for emailmsg          
Alter Indexes for emailmsg          
create unique index emailmsgkey on emailmsg (msgcode);
Alter Indexes for emailuser         
drop index tbvenkey;
Alter Columns for emailuser         
Alter Columns for emailuser         
1) Alter Columns for emailuser         
2) Alter Columns for emailuser         
3) Alter Columns for msg8               type=0 (tabid=112)
alter table emailuser
    add(msg8 char(75))2) Alter Columns for emailuser         
3) Alter Columns for msg7               type=0 (tabid=112)
,
    add(msg7 char(75) before msg8)2) Alter Columns for emailuser         
3) Alter Columns for msg6               type=0 (tabid=112)
,
    add(msg6 char(75) before msg7)2) Alter Columns for emailuser         
3) Alter Columns for msg5               type=0 (tabid=112)
,
    add(msg5 char(75) before msg6)2) Alter Columns for emailuser         
3) Alter Columns for msg4               type=0 (tabid=112)
,
    add(msg4 char(75) before msg5)2) Alter Columns for emailuser         
3) Alter Columns for msg3               type=0 (tabid=112)
,
    add(msg3 char(75) before msg4)2) Alter Columns for emailuser         
3) Alter Columns for msg2               type=0 (tabid=112)
,
    add(msg2 char(75) before msg3)2) Alter Columns for emailuser         
3) Alter Columns for msg1               type=0 (tabid=112)
,
    add(msg1 char(75) before msg2)2) Alter Columns for emailuser         
3) Alter Columns for email              type=0 (tabid=112)
,
    add(email char(60) before msg1)2) Alter Columns for emailuser         
3) Alter Columns for msgcode            type=0 (tabid=112)
,
    add(msgcode char(8) before email)2) Alter Columns for emailuser         
3) Alter Columns for usercode           type=0 (tabid=112)
,
    add(usercode char(10) before msgcode)2) Alter Columns for emailuser         
6) Alter Columns for emailuser         
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for emailuser         
10) Alter Columns for emailuser         
Alter Indexes for emailuser         
create unique index emailuserkey on emailuser (usercode);
Alter Indexes for invoice           
drop index tbvenkey;
Alter Columns for invoice           
Alter Columns for invoice           
1) Alter Columns for invoice           
2) Alter Columns for invoice           
3) Alter Columns for amount             type=8 (tabid=112)
alter table invoice
    add(amount money)2) Alter Columns for invoice           
3) Alter Columns for invoicedate        type=7 (tabid=112)
,
    add(invoicedate date before amount)2) Alter Columns for invoice           
3) Alter Columns for invoiceno          type=0 (tabid=112)
5a) Alter Columns for invoice           
2) Alter Columns for invoice           
6) Alter Columns for invoice           
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for invoice           
{ !!! OUT OF ORDER !!! invoice.invoicedate (invoiceno         )}
{ !!! OUT OF ORDER !!! invoice.amount (invoicedate       )}
{ !!! OUT OF ORDER !!! invoice.amount (signature         )}
10) Alter Columns for invoice           
Alter Indexes for invoice           
create unique index invoicekey on invoice (invoiceno);
Alter Indexes for menufield         
drop index tbvenkey;
Alter Columns for menufield         
Alter Columns for menufield         
1) Alter Columns for menufield         
2) Alter Columns for menufield         
3) Alter Columns for endcr              type=0 (tabid=112)
alter table menufield
    add(endcr char(1))2) Alter Columns for menufield         
3) Alter Columns for startcr            type=0 (tabid=112)
,
    add(startcr char(1) before endcr)2) Alter Columns for menufield         
3) Alter Columns for clearscr           type=0 (tabid=112)
,
    add(clearscr char(1) before startcr)2) Alter Columns for menufield         
3) Alter Columns for password           type=0 (tabid=112)
,
    add(password char(8) before clearscr)2) Alter Columns for menufield         
3) Alter Columns for execline           type=0 (tabid=112)
,
    add(execline char(80) before password)2) Alter Columns for menufield         
3) Alter Columns for exectype           type=0 (tabid=112)
,
    add(exectype char(1) before execline)2) Alter Columns for menufield         
3) Alter Columns for menufieldid        type=6 (tabid=112)
,
    add(menufieldid serial before exectype)2) Alter Columns for menufield         
3) Alter Columns for itemdesc           type=0 (tabid=112)
,
    add(itemdesc char(60) before menufieldid)2) Alter Columns for menufield         
3) Alter Columns for itemnum            type=1 (tabid=112)
,
    add(itemnum smallint before itemdesc)2) Alter Columns for menufield         
3) Alter Columns for menuname           type=0 (tabid=112)
,
    add(menuname char(10) before itemnum)2) Alter Columns for menufield         
6) Alter Columns for menufield         
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for menufield         
10) Alter Columns for menufield         
Alter Indexes for menufield         
create unique index mfmenukey on menufield (menuname, itemnum);
Alter Indexes for menuhead          
drop index tbvenkey;
Alter Columns for menuhead          
Alter Columns for menuhead          
1) Alter Columns for menuhead          
2) Alter Columns for menuhead          
3) Alter Columns for lcol               type=1 (tabid=112)
alter table menuhead
    add(lcol smallint)2) Alter Columns for menuhead          
3) Alter Columns for lrow               type=1 (tabid=112)
,
    add(lrow smallint before lcol)2) Alter Columns for menuhead          
3) Alter Columns for ucol               type=1 (tabid=112)
,
    add(ucol smallint before lrow)2) Alter Columns for menuhead          
3) Alter Columns for urow               type=1 (tabid=112)
,
    add(urow smallint before ucol)2) Alter Columns for menuhead          
3) Alter Columns for format             type=0 (tabid=112)
,
    add(format char(1) before urow)2) Alter Columns for menuhead          
3) Alter Columns for nmenufields        type=1 (tabid=112)
,
    add(nmenufields smallint before format)2) Alter Columns for menuhead          
3) Alter Columns for ncolumns           type=1 (tabid=112)
,
    add(ncolumns smallint before nmenufields)2) Alter Columns for menuhead          
3) Alter Columns for template           type=0 (tabid=112)
,
    add(template char(18) before ncolumns)2) Alter Columns for menuhead          
3) Alter Columns for prevmenu           type=0 (tabid=112)
,
    add(prevmenu char(10) before template)2) Alter Columns for menuhead          
3) Alter Columns for title2             type=0 (tabid=112)
,
    add(title2 char(76) before prevmenu)2) Alter Columns for menuhead          
3) Alter Columns for title1             type=0 (tabid=112)
,
    add(title1 char(76) before title2)2) Alter Columns for menuhead          
3) Alter Columns for menuname           type=0 (tabid=112)
,
    add(menuname char(10) before title1)2) Alter Columns for menuhead          
6) Alter Columns for menuhead          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for menuhead          
10) Alter Columns for menuhead          
Alter Indexes for menuhead          
create unique index mhmenukey on menuhead (menuname);
Alter Indexes for menuperm          
drop index tbvenkey;
Alter Columns for menuperm          
Alter Columns for menuperm          
1) Alter Columns for menuperm          
2) Alter Columns for menuperm          
3) Alter Columns for password           type=0 (tabid=112)
alter table menuperm
    add(password char(10))2) Alter Columns for menuperm          
3) Alter Columns for execline           type=0 (tabid=112)
,
    add(execline char(30) before password)2) Alter Columns for menuperm          
3) Alter Columns for permlist           type=0 (tabid=112)
,
    add(permlist char(30) before execline)2) Alter Columns for menuperm          
3) Alter Columns for permtype           type=0 (tabid=112)
,
    add(permtype char(1) before permlist)2) Alter Columns for menuperm          
3) Alter Columns for menufieldid        type=2 (tabid=112)
,
    add(menufieldid integer before permtype)2) Alter Columns for menuperm          
3) Alter Columns for usertype           type=0 (tabid=112)
,
    add(usertype char(10) before menufieldid)2) Alter Columns for menuperm          
6) Alter Columns for menuperm          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for menuperm          
10) Alter Columns for menuperm          
Alter Indexes for menuperm          
create unique index menupermkey on menuperm (usertype, menufieldid);
Alter Indexes for menuuser          
drop index tbvenkey;
Alter Columns for menuuser          
Alter Columns for menuuser          
1) Alter Columns for menuuser          
2) Alter Columns for menuuser          
3) Alter Columns for description        type=0 (tabid=112)
alter table menuuser
    add(description char(25))2) Alter Columns for menuuser          
3) Alter Columns for flag3              type=0 (tabid=112)
,
    add(flag3 char(1) before description)2) Alter Columns for menuuser          
3) Alter Columns for flag2              type=0 (tabid=112)
,
    add(flag2 char(1) before flag3)2) Alter Columns for menuuser          
3) Alter Columns for flag1              type=0 (tabid=112)
,
    add(flag1 char(1) before flag2)2) Alter Columns for menuuser          
3) Alter Columns for password           type=0 (tabid=112)
,
    add(password char(10) before flag1)2) Alter Columns for menuuser          
3) Alter Columns for usertype           type=0 (tabid=112)
,
    add(usertype char(10) before password)2) Alter Columns for menuuser          
3) Alter Columns for usercode           type=0 (tabid=112)
,
    add(usercode char(10) before usertype)2) Alter Columns for menuuser          
6) Alter Columns for menuuser          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for menuuser          
10) Alter Columns for menuuser          
Alter Indexes for menuuser          
create unique index menuuserkey on menuuser (usercode);
Alter Indexes for menuusty          
drop index tbvenkey;
Alter Columns for menuusty          
Alter Columns for menuusty          
1) Alter Columns for menuusty          
2) Alter Columns for menuusty          
3) Alter Columns for description        type=0 (tabid=112)
alter table menuusty
    add(description char(25))2) Alter Columns for menuusty          
3) Alter Columns for flag3              type=0 (tabid=112)
,
    add(flag3 char(1) before description)2) Alter Columns for menuusty          
3) Alter Columns for flag2              type=0 (tabid=112)
,
    add(flag2 char(1) before flag3)2) Alter Columns for menuusty          
3) Alter Columns for flag1              type=0 (tabid=112)
,
    add(flag1 char(1) before flag2)2) Alter Columns for menuusty          
3) Alter Columns for osflag             type=0 (tabid=112)
,
    add(osflag char(1) before flag1)2) Alter Columns for menuusty          
3) Alter Columns for password           type=0 (tabid=112)
,
    add(password char(10) before osflag)2) Alter Columns for menuusty          
3) Alter Columns for menuname           type=0 (tabid=112)
,
    add(menuname char(10) before password)2) Alter Columns for menuusty          
3) Alter Columns for usertype           type=0 (tabid=112)
,
    add(usertype char(10) before menuname)2) Alter Columns for menuusty          
6) Alter Columns for menuusty          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for menuusty          
10) Alter Columns for menuusty          
Alter Indexes for menuusty          
create unique index menuustykey on menuusty (usertype);
Alter Indexes for syscolauth        
drop index tbvenkey;
Alter Columns for syscolauth        
Alter Columns for syscolauth        
1) Alter Columns for syscolauth        
2) Alter Columns for syscolauth        
3) Alter Columns for colauth            type=0 (tabid=112)
alter table syscolauth
    add(colauth char(3))2) Alter Columns for syscolauth        
3) Alter Columns for colno              type=1 (tabid=112)
,
    add(colno smallint before colauth)2) Alter Columns for syscolauth        
3) Alter Columns for tabid              type=2 (tabid=112)
,
    add(tabid integer before colno)2) Alter Columns for syscolauth        
3) Alter Columns for grantee            type=0 (tabid=112)
,
    add(grantee char(8) before tabid)2) Alter Columns for syscolauth        
3) Alter Columns for grantor            type=0 (tabid=112)
,
    add(grantor char(8) before grantee)2) Alter Columns for syscolauth        
6) Alter Columns for syscolauth        
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for syscolauth        
10) Alter Columns for syscolauth        
Alter Indexes for syscolauth        
create unique index colgtor on syscolauth (tabid, grantor, grantee, colno);
create  index colgtee on syscolauth (tabid, grantee);
Alter Indexes for syscolumns        
drop index tbvenkey;
Alter Columns for syscolumns        
Alter Columns for syscolumns        
1) Alter Columns for syscolumns        
2) Alter Columns for syscolumns        
3) Alter Columns for collength          type=1 (tabid=112)
alter table syscolumns
    add(collength smallint)2) Alter Columns for syscolumns        
3) Alter Columns for coltype            type=1 (tabid=112)
,
    add(coltype smallint before collength)2) Alter Columns for syscolumns        
3) Alter Columns for colno              type=1 (tabid=112)
,
    add(colno smallint before coltype)2) Alter Columns for syscolumns        
3) Alter Columns for tabid              type=2 (tabid=112)
,
    add(tabid integer before colno)2) Alter Columns for syscolumns        
3) Alter Columns for colname            type=0 (tabid=112)
,
    add(colname char(18) before tabid)2) Alter Columns for syscolumns        
6) Alter Columns for syscolumns        
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for syscolumns        
10) Alter Columns for syscolumns        
Alter Indexes for syscolumns        
create unique index column on syscolumns (tabid, colno);
Alter Indexes for sysdepend         
drop index tbvenkey;
Alter Columns for sysdepend         
Alter Columns for sysdepend         
1) Alter Columns for sysdepend         
2) Alter Columns for sysdepend         
3) Alter Columns for dtype              type=0 (tabid=112)
alter table sysdepend
    add(dtype char(1))2) Alter Columns for sysdepend         
3) Alter Columns for dtabid             type=2 (tabid=112)
,
    add(dtabid integer before dtype)2) Alter Columns for sysdepend         
3) Alter Columns for btype              type=0 (tabid=112)
,
    add(btype char(1) before dtabid)2) Alter Columns for sysdepend         
3) Alter Columns for btabid             type=2 (tabid=112)
,
    add(btabid integer before btype)2) Alter Columns for sysdepend         
6) Alter Columns for sysdepend         
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for sysdepend         
10) Alter Columns for sysdepend         
Alter Indexes for sysdepend         
create  index btabid on sysdepend (btabid);
create  index dtabid on sysdepend (dtabid);
Alter Indexes for sysfile           
drop index tbvenkey;
Alter Columns for sysfile           
Alter Columns for sysfile           
1) Alter Columns for sysfile           
2) Alter Columns for sysfile           
3) Alter Columns for company            type=0 (tabid=112)
alter table sysfile
    add(company char(40))2) Alter Columns for sysfile           
3) Alter Columns for sysname            type=0 (tabid=112)
,
    add(sysname char(10) before company)2) Alter Columns for sysfile           
6) Alter Columns for sysfile           
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for sysfile           
10) Alter Columns for sysfile           
Alter Indexes for sysfile           
create unique index sysfilekey on sysfile (sysname);
Alter Indexes for sysindexes        
drop index tbvenkey;
Alter Columns for sysindexes        
Alter Columns for sysindexes        
1) Alter Columns for sysindexes        
2) Alter Columns for sysindexes        
3) Alter Columns for part8              type=1 (tabid=112)
alter table sysindexes
    add(part8 smallint)2) Alter Columns for sysindexes        
3) Alter Columns for part7              type=1 (tabid=112)
,
    add(part7 smallint before part8)2) Alter Columns for sysindexes        
3) Alter Columns for part6              type=1 (tabid=112)
,
    add(part6 smallint before part7)2) Alter Columns for sysindexes        
3) Alter Columns for part5              type=1 (tabid=112)
,
    add(part5 smallint before part6)2) Alter Columns for sysindexes        
3) Alter Columns for part4              type=1 (tabid=112)
,
    add(part4 smallint before part5)2) Alter Columns for sysindexes        
3) Alter Columns for part3              type=1 (tabid=112)
,
    add(part3 smallint before part4)2) Alter Columns for sysindexes        
3) Alter Columns for part2              type=1 (tabid=112)
,
    add(part2 smallint before part3)2) Alter Columns for sysindexes        
3) Alter Columns for part1              type=1 (tabid=112)
,
    add(part1 smallint before part2)2) Alter Columns for sysindexes        
3) Alter Columns for clustered          type=0 (tabid=112)
,
    add(clustered char(1) before part1)2) Alter Columns for sysindexes        
3) Alter Columns for idxtype            type=0 (tabid=112)
,
    add(idxtype char(1) before clustered)2) Alter Columns for sysindexes        
3) Alter Columns for tabid              type=2 (tabid=112)
,
    add(tabid integer before idxtype)2) Alter Columns for sysindexes        
3) Alter Columns for owner              type=0 (tabid=112)
,
    add(owner char(8) before tabid)2) Alter Columns for sysindexes        
3) Alter Columns for idxname            type=0 (tabid=112)
,
    add(idxname char(18) before owner)2) Alter Columns for sysindexes        
6) Alter Columns for sysindexes        
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for sysindexes        
10) Alter Columns for sysindexes        
Alter Indexes for sysindexes        
create  index idxtab on sysindexes (tabid);
create unique index idxname on sysindexes (idxname, tabid);
Alter Indexes for syssynonyms       
drop index tbvenkey;
Alter Columns for syssynonyms       
Alter Columns for syssynonyms       
1) Alter Columns for syssynonyms       
2) Alter Columns for syssynonyms       
3) Alter Columns for tabid              type=2 (tabid=112)
alter table syssynonyms
    add(tabid integer)2) Alter Columns for syssynonyms       
3) Alter Columns for created            type=7 (tabid=112)
,
    add(created date before tabid)2) Alter Columns for syssynonyms       
3) Alter Columns for synonym            type=0 (tabid=112)
,
    add(synonym char(18) before created)2) Alter Columns for syssynonyms       
3) Alter Columns for owner              type=0 (tabid=112)
,
    add(owner char(8) before synonym)2) Alter Columns for syssynonyms       
6) Alter Columns for syssynonyms       
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for syssynonyms       
10) Alter Columns for syssynonyms       
Alter Indexes for syssynonyms       
create unique index sysnonym on syssynonyms (owner, synonym);
create  index syntabid on syssynonyms (tabid);
Alter Indexes for systabauth        
drop index tbvenkey;
Alter Columns for systabauth        
Alter Columns for systabauth        
1) Alter Columns for systabauth        
2) Alter Columns for systabauth        
3) Alter Columns for tabauth            type=0 (tabid=112)
alter table systabauth
    add(tabauth char(8))2) Alter Columns for systabauth        
3) Alter Columns for tabid              type=2 (tabid=112)
,
    add(tabid integer before tabauth)2) Alter Columns for systabauth        
3) Alter Columns for grantee            type=0 (tabid=112)
,
    add(grantee char(8) before tabid)2) Alter Columns for systabauth        
3) Alter Columns for grantor            type=0 (tabid=112)
,
    add(grantor char(8) before grantee)2) Alter Columns for systabauth        
6) Alter Columns for systabauth        
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for systabauth        
10) Alter Columns for systabauth        
Alter Indexes for systabauth        
create unique index tabgtor on systabauth (tabid, grantor, grantee);
create  index tabgtee on systabauth (tabid, grantee);
Alter Indexes for systables         
drop index tbvenkey;
Alter Columns for systables         
Alter Columns for systables         
1) Alter Columns for systables         
2) Alter Columns for systables         
3) Alter Columns for audpath            type=0 (tabid=112)
alter table systables
    add(audpath char(256))2) Alter Columns for systables         
3) Alter Columns for tabtype            type=0 (tabid=112)
,
    add(tabtype char(1) before audpath)2) Alter Columns for systables         
3) Alter Columns for version            type=2 (tabid=112)
,
    add(version integer before tabtype)2) Alter Columns for systables         
3) Alter Columns for created            type=7 (tabid=112)
,
    add(created date before version)2) Alter Columns for systables         
3) Alter Columns for nrows              type=2 (tabid=112)
,
    add(nrows integer before created)2) Alter Columns for systables         
3) Alter Columns for nindexes           type=1 (tabid=112)
,
    add(nindexes smallint before nrows)2) Alter Columns for systables         
3) Alter Columns for ncols              type=1 (tabid=112)
,
    add(ncols smallint before nindexes)2) Alter Columns for systables         
3) Alter Columns for rowsize            type=1 (tabid=112)
,
    add(rowsize smallint before ncols)2) Alter Columns for systables         
3) Alter Columns for tabid              type=6 (tabid=112)
,
    add(tabid serial before rowsize)2) Alter Columns for systables         
3) Alter Columns for dirpath            type=0 (tabid=112)
,
    add(dirpath char(256) before tabid)2) Alter Columns for systables         
3) Alter Columns for owner              type=0 (tabid=112)
,
    add(owner char(8) before dirpath)2) Alter Columns for systables         
3) Alter Columns for tabname            type=0 (tabid=112)
,
    add(tabname char(18) before owner)2) Alter Columns for systables         
6) Alter Columns for systables         
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for systables         
10) Alter Columns for systables         
Alter Indexes for systables         
create unique index tabname on systables (tabname, owner);
create unique index tabid on systables (tabid);
Alter Indexes for sysusers          
drop index tbvenkey;
Alter Columns for sysusers          
Alter Columns for sysusers          
1) Alter Columns for sysusers          
2) Alter Columns for sysusers          
3) Alter Columns for password           type=0 (tabid=112)
alter table sysusers
    add(password char(8))2) Alter Columns for sysusers          
3) Alter Columns for priority           type=1 (tabid=112)
,
    add(priority smallint before password)2) Alter Columns for sysusers          
3) Alter Columns for usertype           type=0 (tabid=112)
,
    add(usertype char(1) before priority)2) Alter Columns for sysusers          
3) Alter Columns for username           type=0 (tabid=112)
,
    add(username char(8) before usertype)2) Alter Columns for sysusers          
6) Alter Columns for sysusers          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for sysusers          
10) Alter Columns for sysusers          
Alter Indexes for sysusers          
create unique index users on sysusers (username);
Alter Indexes for sysviews          
drop index tbvenkey;
Alter Columns for sysviews          
Alter Columns for sysviews          
1) Alter Columns for sysviews          
2) Alter Columns for sysviews          
3) Alter Columns for viewtext           type=0 (tabid=112)
alter table sysviews
    add(viewtext char(64))2) Alter Columns for sysviews          
3) Alter Columns for seqno              type=1 (tabid=112)
,
    add(seqno smallint before viewtext)2) Alter Columns for sysviews          
3) Alter Columns for tabid              type=2 (tabid=112)
,
    add(tabid integer before seqno)2) Alter Columns for sysviews          
6) Alter Columns for sysviews          
,
    drop(code),
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for sysviews          
10) Alter Columns for sysviews          
Alter Indexes for sysviews          
create unique index view on sysviews (tabid, seqno);
Alter Indexes for tbagent           
drop index tbvenkey;
Alter Columns for tbagent           
Alter Columns for tbagent           
1) Alter Columns for tbagent           
2) Alter Columns for tbagent           
3) Alter Columns for commission         type=3 (tabid=112)
alter table tbagent
    add(commission float)2) Alter Columns for tbagent           
3) Alter Columns for salary             type=8 (tabid=112)
,
    add(salary money before commission)2) Alter Columns for tbagent           
3) Alter Columns for paymethod          type=2 (tabid=112)
,
    add(paymethod integer before salary)2) Alter Columns for tbagent           
3) Alter Columns for raise_date         type=7 (tabid=112)
,
    add(raise_date date before paymethod)2) Alter Columns for tbagent           
3) Alter Columns for socno              type=0 (tabid=112)
,
    add(socno char(13) before raise_date)2) Alter Columns for tbagent           
3) Alter Columns for hire_date          type=7 (tabid=112)
,
    add(hire_date date before socno)2) Alter Columns for tbagent           
3) Alter Columns for fname              type=0 (tabid=112)
,
    add(fname char(10) before hire_date)2) Alter Columns for tbagent           
3) Alter Columns for lname              type=0 (tabid=112)
,
    add(lname char(15) before fname)2) Alter Columns for tbagent           
3) Alter Columns for code               type=0 (tabid=112)
5a) Alter Columns for tbagent           
5b) Alter Columns for type(0 - 0) len(6 - 4)
5c) Alter Columns for tbagent           
,
    modify(code char(4))2) Alter Columns for tbagent           
6) Alter Columns for tbagent           
,
    drop(name),
    drop(contact),
    drop(phone),
    drop(saleflag),
    drop(type);
6) Alter Columns for tbagent           
10) Alter Columns for tbagent           
Alter Indexes for tbagent           
create unique index tbagentkey on tbagent (code);
create unique index tbagent2key on tbagent (lname, code);
Alter Indexes for tbven             
Alter Columns for tbven             
Alter Columns for tbven             
1) Alter Columns for tbven             
2) Alter Columns for tbven             
3) Alter Columns for type               type=0 (tabid=112)
5a) Alter Columns for tbven             
2) Alter Columns for tbven             
3) Alter Columns for saleflag           type=0 (tabid=112)
5a) Alter Columns for tbven             
2) Alter Columns for tbven             
3) Alter Columns for phone              type=0 (tabid=112)
5a) Alter Columns for tbven             
2) Alter Columns for tbven             
3) Alter Columns for contact            type=0 (tabid=112)
5a) Alter Columns for tbven             
2) Alter Columns for tbven             
3) Alter Columns for name               type=0 (tabid=112)
5a) Alter Columns for tbven             
2) Alter Columns for tbven             
3) Alter Columns for code               type=0 (tabid=112)
5a) Alter Columns for tbven             
2) Alter Columns for tbven             
6) Alter Columns for tbven             
6) Alter Columns for tbven             
10) Alter Columns for tbven             
Alter Indexes for tbven             
