Revision: 1066
          http://mrbs.svn.sourceforge.net/mrbs/?rev=1066&view=rev
Author:   dceschools
Date:     2009-03-23 20:13:13 +0000 (Mon, 23 Mar 2009)

Log Message:
-----------
Corrected DB upgrade for private bookings to use configured DB prefix instead 
of default mrbs_ prefix.

Modified Paths:
--------------
    mrbs/trunk/web/upgrade/3/mysql.sql
    mrbs/trunk/web/upgrade/3/pgsql.sql

Modified: mrbs/trunk/web/upgrade/3/mysql.sql
===================================================================
--- mrbs/trunk/web/upgrade/3/mysql.sql  2009-03-23 19:20:50 UTC (rev 1065)
+++ mrbs/trunk/web/upgrade/3/mysql.sql  2009-03-23 20:13:13 UTC (rev 1066)
@@ -3,7 +3,7 @@
 -- Add an extra column to the mrbs_entry and mrbs_repeat table 
 -- for private bookings handling
 
-ALTER TABLE mrbs_repeat 
+ALTER TABLE %DB_TBL_PREFIX%repeat 
  ADD private BOOL NOT NULL DEFAULT '0';
-ALTER TABLE mrbs_entry 
+ALTER TABLE %DB_TBL_PREFIX%entry 
  ADD private BOOL NOT NULL DEFAULT '0';

Modified: mrbs/trunk/web/upgrade/3/pgsql.sql
===================================================================
--- mrbs/trunk/web/upgrade/3/pgsql.sql  2009-03-23 19:20:50 UTC (rev 1065)
+++ mrbs/trunk/web/upgrade/3/pgsql.sql  2009-03-23 20:13:13 UTC (rev 1066)
@@ -3,7 +3,7 @@
 -- Add an extra column to the mrbs_entry and mrbs_repeat table 
 -- for private bookings handling
 
-ALTER TABLE mrbs_repeat 
+ALTER TABLE %DB_TBL_PREFIX%repeat 
  ADD private BOOL NOT NULL DEFAULT '0';
-ALTER TABLE mrbs_entry 
+ALTER TABLE %DB_TBL_PREFIX%entry 
  ADD private BOOL NOT NULL DEFAULT '0';


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

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits

Reply via email to