Revision: 1316
          http://mrbs.svn.sourceforge.net/mrbs/?rev=1316&view=rev
Author:   cimorrison
Date:     2010-03-28 17:03:31 +0000 (Sun, 28 Mar 2010)

Log Message:
-----------
Updated installation SQL to reflect the recent addition of the custom_html field

Modified Paths:
--------------
    mrbs/trunk/tables.my.sql
    mrbs/trunk/tables.pg.73and_above.sql
    mrbs/trunk/tables.pg.sql

Modified: mrbs/trunk/tables.my.sql
===================================================================
--- mrbs/trunk/tables.my.sql    2010-03-28 12:42:33 UTC (rev 1315)
+++ mrbs/trunk/tables.my.sql    2010-03-28 17:03:31 UTC (rev 1316)
@@ -31,6 +31,7 @@
   min_book_ahead_secs    int,
   max_book_ahead_enabled tinyint(1),
   max_book_ahead_secs    int,
+  custom_html            text,
 
   PRIMARY KEY (id)
 );
@@ -44,6 +45,7 @@
   description      varchar(60),
   capacity         int DEFAULT '0' NOT NULL,
   room_admin_email text,
+  custom_html      text,
 
   PRIMARY KEY (id),
   KEY idxSortKey (sort_key)
@@ -114,6 +116,6 @@
 );
 
 INSERT INTO mrbs_variables (variable_name, variable_content)
-  VALUES ( 'db_version', '11');
+  VALUES ( 'db_version', '12');
 INSERT INTO mrbs_variables (variable_name, variable_content)
   VALUES ( 'local_db_version', '1');

Modified: mrbs/trunk/tables.pg.73and_above.sql
===================================================================
--- mrbs/trunk/tables.pg.73and_above.sql        2010-03-28 12:42:33 UTC (rev 
1315)
+++ mrbs/trunk/tables.pg.73and_above.sql        2010-03-28 17:03:31 UTC (rev 
1316)
@@ -46,7 +46,8 @@
   min_book_ahead_enabled smallint,
   min_book_ahead_secs    int,
   max_book_ahead_enabled smallint,
-  max_book_ahead_secs    int
+  max_book_ahead_secs    int,
+  custom_html            text
 );
 
 CREATE TABLE mrbs_room
@@ -57,7 +58,8 @@
   sort_key          varchar(25) NOT NULL,
   description       varchar(60),
   capacity          int DEFAULT 0 NOT NULL,
-  room_admin_email  text
+  room_admin_email  text,
+  custom_html       text
 );
 create index idxSortKey on mrbs_room(sort_key);
 
@@ -118,6 +120,6 @@
 );
 
 INSERT INTO mrbs_variables (variable_name, variable_content)
-  VALUES ('db_version', '11');
+  VALUES ('db_version', '12');
 INSERT INTO mrbs_variables (variable_name, variable_content)
   VALUES ('local_db_version', '1');

Modified: mrbs/trunk/tables.pg.sql
===================================================================
--- mrbs/trunk/tables.pg.sql    2010-03-28 12:42:33 UTC (rev 1315)
+++ mrbs/trunk/tables.pg.sql    2010-03-28 17:03:31 UTC (rev 1316)
@@ -34,7 +34,8 @@
   min_book_ahead_enabled smallint,
   min_book_ahead_secs    int,
   max_book_ahead_enabled smallint,
-  max_book_ahead_secs    int
+  max_book_ahead_secs    int,
+  custom_html            text
 );
 
 CREATE TABLE mrbs_room
@@ -45,7 +46,8 @@
   sort_key          varchar(25) DEFAULT '' NOT NULL,
   description       varchar(60),
   capacity          int DEFAULT 0 NOT NULL,
-  room_admin_email  text
+  room_admin_email  text,
+  custom_html       text
 );
 create index idxSortKey on mrbs_room(sort_key);
 
@@ -106,6 +108,6 @@
 );
 
 INSERT INTO mrbs_variables (variable_name, variable_content)
-  VALUES ('db_version', '11');
+  VALUES ('db_version', '12');
 INSERT INTO mrbs_variables (variable_name, variable_content)
   VALUES ('local_db_version', '1');


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

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits

Reply via email to