Revision: 1077
http://mrbs.svn.sourceforge.net/mrbs/?rev=1077&view=rev
Author: jberanek
Date: 2009-03-26 21:23:13 +0000 (Thu, 26 Mar 2009)
Log Message:
-----------
* Added missing schema updates for clean installations.
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 2009-03-26 00:35:30 UTC (rev 1076)
+++ mrbs/trunk/tables.my.sql 2009-03-26 21:23:13 UTC (rev 1077)
@@ -49,6 +49,7 @@
name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
+ private BOOL NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY idxStartTime (start_time),
@@ -70,6 +71,7 @@
type char DEFAULT 'E' NOT NULL,
description text,
rep_num_weeks smallint NULL,
+ private BOOL NOT NULL DEFAULT '0',
PRIMARY KEY (id)
);
@@ -84,4 +86,6 @@
);
INSERT INTO mrbs_variables (variable_name, variable_content)
- VALUES ( 'db_version', '1');
+ VALUES ( 'db_version', '3');
+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 2009-03-26 00:35:30 UTC (rev
1076)
+++ mrbs/trunk/tables.pg.73and_above.sql 2009-03-26 21:23:13 UTC (rev
1077)
@@ -25,9 +25,15 @@
CREATE TABLE mrbs_area
(
- id serial primary key,
- area_name varchar(30),
- area_admin_email text
+ id serial primary key,
+ area_name varchar(30),
+ area_admin_email text,
+ resolution int,
+ default_duration int,
+ morningstarts int,
+ morningstarts_minutes int,
+ eveningends int,
+ eveningends_minutes int
);
CREATE TABLE mrbs_room
@@ -52,7 +58,8 @@
create_by varchar(80) NOT NULL,
name varchar(80) NOT NULL,
type char DEFAULT 'E' NOT NULL,
- description text
+ description text,
+ private private BOOL NOT NULL DEFAULT '0'
);
create index idxStartTime on mrbs_entry(start_time);
create index idxEndTime on mrbs_entry(end_time);
@@ -71,7 +78,8 @@
name varchar(80) NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
- rep_num_weeks smallint DEFAULT 0 NULL
+ rep_num_weeks smallint DEFAULT 0 NULL,
+ private private BOOL NOT NULL DEFAULT '0'
);
CREATE TABLE mrbs_variables
@@ -81,4 +89,6 @@
variable_content text
);
INSERT INTO mrbs_variables (variable_name, variable_content)
- VALUES ('db_version', '1');
+ VALUES ('db_version', '3');
+INSERT INTO mrbs_variables (variable_name, variable_content)
+ VALUES ('local_db_version', '1');
Modified: mrbs/trunk/tables.pg.sql
===================================================================
--- mrbs/trunk/tables.pg.sql 2009-03-26 00:35:30 UTC (rev 1076)
+++ mrbs/trunk/tables.pg.sql 2009-03-26 21:23:13 UTC (rev 1077)
@@ -13,9 +13,15 @@
CREATE TABLE mrbs_area
(
- id serial primary key,
- area_name varchar(30),
- area_admin_email text
+ id serial primary key,
+ area_name varchar(30),
+ area_admin_email text,
+ resolution int,
+ default_duration int,
+ morningstarts int,
+ morningstarts_minutes int,
+ eveningends int,
+ eveningends_minutes int
);
CREATE TABLE mrbs_room
@@ -40,7 +46,8 @@
create_by varchar(80) DEFAULT '' NOT NULL,
name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,
- description text
+ description text,
+ private private BOOL NOT NULL DEFAULT '0'
);
create index idxStartTime on mrbs_entry(start_time);
create index idxEndTime on mrbs_entry(end_time);
@@ -59,7 +66,8 @@
name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
- rep_num_weeks smallint DEFAULT NULL NULL
+ rep_num_weeks smallint DEFAULT NULL NULL,
+ private private BOOL NOT NULL DEFAULT '0'
);
CREATE TABLE mrbs_variables
@@ -69,4 +77,6 @@
variable_content text
);
INSERT INTO mrbs_variables (variable_name, variable_content)
- VALUES ('db_version', '1');
+ VALUES ('db_version', '3');
+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.
------------------------------------------------------------------------------
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
