2 ALTER TABLE customer ADD (customernumber VARCHAR2(40));
3 UPDATE customer SET customernumber = businessnumber;
4 ALTER TABLE customer DROP COLUMN businessnumber;
5 CREATE INDEX customer_customernumber_key ON customer (customernumber);
7 ALTER TABLE vendor ADD (vendornumber VARCHAR2(40));
8 UPDATE vendor SET vendornumber = businessnumber;
9 ALTER TABLE vendor DROP COLUMN businessnumber;
10 CREATE INDEX vendor_vendornumber_key ON vendor (vendornumber);
12 CREATE TABLE employee (
20 workphone VARCHAR2(20),
21 homephone VARCHAR2(20),
22 startdate DATE DEFAULT SYSDATE,
27 CREATE OR REPLACE TRIGGER employeeid BEFORE INSERT ON employee FOR EACH ROW
34 CREATE INDEX employee_id_key ON employee (id);
35 CREATE UNIQUE INDEX employee_login_key ON employee (login);
36 CREATE INDEX employee_name_key ON employee (name);
38 ALTER TABLE gl ADD (employee_id INTEGER);
39 CREATE INDEX gl_employee_id_key ON gl (employee_id);
40 ALTER TABLE ar ADD (employee_id INTEGER);
41 CREATE INDEX ar_employee_id_key ON ar (employee_id);
42 ALTER TABLE ap ADD (employee_id INTEGER);
43 CREATE INDEX ap_employee_id_key ON ap (employee_id);
44 ALTER TABLE oe ADD (employee_id INTEGER);
45 CREATE INDEX oe_employee_id_key ON oe (employee_id);
47 ALTER TABLE invoice ADD (unit VARCHAR2(5));
48 ALTER TABLE orderitems ADD (unit VARCHAR2(5));
50 UPDATE chart SET gifi_accno = '' WHERE gifi_accno = NULL;
51 ALTER TABLE chart RENAME TO chartold;
54 accno VARCHAR2(20) NOT NULL,
55 description VARCHAR2(100),
56 charttype CHAR(1) DEFAULT 'A',
59 gifi_accno VARCHAR2(20)
61 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno) SELECT id, accno, description, charttype, category, link, gifi_accno from chartold;
63 CREATE INDEX chart_id_key ON chart (id);
64 CREATE UNIQUE INDEX chart_accno_key ON chart (accno);
65 CREATE INDEX chart_category_key ON chart (category);
66 CREATE INDEX chart_link_key ON chart (link);
67 CREATE INDEX chart_gifi_accno_key ON chart (gifi_accno);
69 ALTER TABLE parts MODIFY inventory_accno_id;
71 ALTER TABLE defaults ADD (sonumber VARCHAR2(30));
72 UPDATE defaults SET sonumber = ordnumber;
73 ALTER TABLE defaults DROP COLUMN ordnumber;
74 ALTER TABLE defaults ADD (ponumber VARCHAR2(30));
76 UPDATE defaults SET version = '1.8.5';