2 alter table customer rename column businessnumber to customernumber;
3 create index customer_customernumber_key on customer (customernumber);
4 alter table vendor rename column businessnumber to vendornumber;
5 create index vendor_vendornumber_key on vendor (vendornumber);
7 CREATE TABLE employee (
8 id int DEFAULT nextval ('id'),
15 workphone varchar(20),
16 homephone varchar(20),
17 startdate date default current_date,
22 create index employee_id_key on employee (id);
23 create unique index employee_login_key on employee (login);
24 create index employee_name_key on employee (name);
26 alter table gl add column employee_id int;
27 create index gl_employee_id_key on gl (employee_id);
28 alter table ar add column employee_id int;
29 create index ar_employee_id_key on ar (employee_id);
30 alter table ap add column employee_id int;
31 create index ap_employee_id_key on ap (employee_id);
32 alter table oe add column employee_id int;
33 create index oe_employee_id_key on oe (employee_id);
35 alter table invoice add column unit varchar(5);
36 alter table orderitems add column unit varchar(5);
38 update chart set gifi_accno = '' where gifi_accno = NULL;
39 alter table chart rename to chartold;
41 id int DEFAULT nextval ('id'),
44 charttype char(1) DEFAULT 'A',
49 insert into chart (id, accno, description, charttype, category, link, gifi_accno) select id, accno, description, charttype, category, link, gifi_accno from chartold;
51 create index chart_id_key on chart (id);
52 create unique index chart_accno_key on chart (accno);
53 create index chart_category_key on chart (category);
54 create index chart_link_key on chart (link);
55 create index chart_gifi_accno_key on chart (gifi_accno);
57 alter table parts alter column inventory_accno_id drop default;
59 alter table defaults rename ordnumber to sonumber;
60 alter table defaults add column ponumber text;
62 update defaults set version = '1.8.5', ponumber = sonumber;