SF.net SVN: ledger-smb: [194] trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql

[..hidden..]

Revision: 194
          http://svn.sourceforge.net/ledger-smb/?rev=194&view=rev
Author:   tetragon
Date:     2006-10-08 13:31:42 -0700 (Sun, 08 Oct 2006)

Log Message:
-----------
Fix syntax and table names to match schema

Modified Paths:
--------------
    trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql

Modified: trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql
===================================================================
--- trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql	2006-10-08 20:25:45 UTC (rev 193)
+++ trunk/sql/Pg-upgrade-2.6.18-2.6.19.sql	2006-10-08 20:31:42 UTC (rev 194)
@@ -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 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 @@
 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;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.