2 alter table chart add column gifi_accno text;
4 create table gifi (accno text, description text);
5 create unique index gifi_accno_key on gifi (accno);
7 create table mtemp (parts_id int, name text);
8 insert into mtemp select parts_id, name from makemodel;
10 alter table mtemp rename to makemodel;
12 alter table defaults add column closedto date;
13 alter table defaults add column revtrans bool;
15 alter table ap add column notes text;
17 alter table customer add column businessnumber text;
18 alter table vendor add column businessnumber text;
20 update defaults set version = '1.8.4', revtrans = 'f';