[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[3962] branches/1.3/sql/upgrade/1.3-1.2.sql



Revision: 3962
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3962&view=rev
Author:   einhverfr
Date:     2011-11-05 12:24:36 +0000 (Sat, 05 Nov 2011)
Log Message:
-----------
Correcting transactional stuff for downgrade script

Modified Paths:
--------------
    branches/1.3/sql/upgrade/1.3-1.2.sql

Modified: branches/1.3/sql/upgrade/1.3-1.2.sql
===================================================================
--- branches/1.3/sql/upgrade/1.3-1.2.sql	2011-11-05 11:41:28 UTC (rev 3961)
+++ branches/1.3/sql/upgrade/1.3-1.2.sql	2011-11-05 12:24:36 UTC (rev 3962)
@@ -2,15 +2,15 @@
 BEGIN;
 ALTER SCHEMA public RENAME TO lsmb_13fail;
 ALTER SCHEMA lsmb12 RENAME TO public;
-COMMIT;
 
 
-ALTER TABLE lsmb12.vendor DROP COLUMN entity_id;
-ALTER TABLE lsmb12.vendor DROP COLUMN company_id;
-ALTER TABLE lsmb12.vendor DROP COLUMN credit_id;
+ALTER TABLE vendor DROP COLUMN entity_id;
+ALTER TABLE vendor DROP COLUMN company_id;
+ALTER TABLE vendor DROP COLUMN credit_id;
 
-ALTER TABLE lsmb12.customer DROP COLUMN entity_id;
-ALTER TABLE lsmb12.customer DROP COLUMN company_id;
-ALTER TABLE lsmb12.customer DROP COLUMN credit_id;
+ALTER TABLE customer DROP COLUMN entity_id;
+ALTER TABLE customer DROP COLUMN company_id;
+ALTER TABLE customer DROP COLUMN credit_id;
 
-ALTER TABLE lsmb12.employee DROP COLUMN entity_id;
+ALTER TABLE employee DROP COLUMN entity_id;
+COMMIT;

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