2 ALTER TABLE chart ADD gifi_accno VARCHAR2(20);
6 description VARCHAR2(100)
9 CREATE UNIQUE INDEX chart_accno_key ON chart (accno);
15 INSERT INTO mtemp SELECT parts_id, name FROM makemodel;
17 ALTER TABLE mtemp RENAME TO makemodel;
19 ALTER TABLE defaults ADD closedto DATE;
20 ALTER TABLE defaults ADD revtrans CHAR(1);
22 ALTER TABLE ap ADD notes VARCHAR2(4000);
24 ALTER TABLE customer ADD businessnumber VARCHAR2(40);
25 ALTER TABLE vendor ADD businessnumber VARCHAR2(40);
27 UPDATE defaults SET version = '1.8.4', revtrans = '0';