diff options
| -rw-r--r-- | sql/Pg-upgrade-2.6.18-2.6.19.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/sql/Pg-upgrade-2.6.18-2.6.19.sql b/sql/Pg-upgrade-2.6.18-2.6.19.sql index 1c3493be..07541bde 100644 --- a/sql/Pg-upgrade-2.6.18-2.6.19.sql +++ b/sql/Pg-upgrade-2.6.18-2.6.19.sql @@ -1,4 +1,4 @@ -ALTER TABLE acc_trans ADD FOREIGN KEY trans_id REFERENCES transactions (id); +ALTER TABLE acc_trans ADD FOREIGN KEY (trans_id) REFERENCES transactions (id); ALTER TABLE ap ADD PRIMARY KEY (id); @@ -65,7 +65,7 @@ ALTER TABLE translation ADD PRIMARY KEY (trans_id, language_code); ALTER TABLE vendor ADD PRIMARY KEY (id); -ALTER TABLE vendor_tax ADD PRIMARY KEY (vendor_id, chart_id); +ALTER TABLE vendortax ADD PRIMARY KEY (vendor_id, chart_id); ALTER TABLE warehouse ADD PRIMARY KEY (id); @@ -101,15 +101,15 @@ SET DEFAULT nextval('partsvendor_entry_id_seq'); UPDATE partsvendor SET entry_id = nextval('partsvendor_entry_id_seq'); ALTER TABLE partsvendor ADD PRIMARY KEY (entry_id); -LOCK audit_trail IN EXCLUSIVE MODE; -ALTER TABLE audit_trail ADD COLUMN entry_id int; -CREATE SEQUENCE audit_trail_entry_id_seq ; +LOCK audittrail IN EXCLUSIVE MODE; +ALTER TABLE audittrail ADD COLUMN entry_id int; +CREATE SEQUENCE audittrail_entry_id_seq ; -ALTER TABLE audit_trail ALTER COLUMN entry_id -SET DEFAULT nextval('audit_trail_entry_id_seq'); +ALTER TABLE audittrail ALTER COLUMN entry_id +SET DEFAULT nextval('audittrail_entry_id_seq'); -UPDATE audit_trail SET entry_id = nextval('audit_trail_entry_id_seq'); -ALTER TABLE audit_trail ADD PRIMARY KEY (entry_id); +UPDATE audittrail SET entry_id = nextval('audittrail_entry_id_seq'); +ALTER TABLE audittrail ADD PRIMARY KEY (entry_id); LOCK shipto IN EXCLUSIVE MODE; ALTER TABLE shipto ADD COLUMN entry_id int; |