SF.net SVN: ledger-smb:[3961] branches/1.3

[..hidden..]

Revision: 3961
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3961&view=rev
Author:   einhverfr
Date:     2011-11-05 11:41:28 +0000 (Sat, 05 Nov 2011)
Log Message:
-----------
Adding 1.3-1.2 script to back out of failed db upgrades

Modified Paths:
--------------
    branches/1.3/Changelog

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

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2011-11-05 09:48:18 UTC (rev 3960)
+++ branches/1.3/Changelog	2011-11-05 11:41:28 UTC (rev 3961)
@@ -10,6 +10,7 @@
 * Corrected display issues with numbers (Herman V)
 * Updated Ubuntu notes (Frans S)
 * Corrected a couple of menu items (David B)
+* Added 1.3-1.2 downgrade script to recover from failed upgrades (Chris T)
 
 Chris T is Chris Travers
 David B is David Bandel

Added: branches/1.3/sql/upgrade/1.3-1.2.sql
===================================================================
--- branches/1.3/sql/upgrade/1.3-1.2.sql	                        (rev 0)
+++ branches/1.3/sql/upgrade/1.3-1.2.sql	2011-11-05 11:41:28 UTC (rev 3961)
@@ -0,0 +1,16 @@
+
+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 lsmb12.customer DROP COLUMN entity_id;
+ALTER TABLE lsmb12.customer DROP COLUMN company_id;
+ALTER TABLE lsmb12.customer DROP COLUMN credit_id;
+
+ALTER TABLE lsmb12.employee DROP COLUMN entity_id;

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