Revision: 1105
http://mrbs.svn.sourceforge.net/mrbs/?rev=1105&view=rev
Author: jberanek
Date: 2009-05-05 20:52:42 +0000 (Tue, 05 May 2009)
Log Message:
-----------
* Fixed database schemas for DB schema 3: MySQL schema updated to retain
MySQL 3 support (MySQL 3 doesn't have a BOOL type). Syntax errors
in Postgresql tables (SF tracker #2786678) and upgrade SQL fixed.
Modified Paths:
--------------
mrbs/trunk/tables.my.sql
mrbs/trunk/tables.pg.73and_above.sql
mrbs/trunk/tables.pg.sql
mrbs/trunk/web/upgrade/3/mysql.sql
mrbs/trunk/web/upgrade/3/pgsql.sql
Modified: mrbs/trunk/tables.my.sql
===================================================================
--- mrbs/trunk/tables.my.sql 2009-04-29 23:16:16 UTC (rev 1104)
+++ mrbs/trunk/tables.my.sql 2009-05-05 20:52:42 UTC (rev 1105)
@@ -49,7 +49,7 @@
name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
- private BOOL NOT NULL DEFAULT '0',
+ private TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id),
KEY idxStartTime (start_time),
@@ -70,8 +70,8 @@
name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
- rep_num_weeks smallint NULL,
- private BOOL NOT NULL DEFAULT '0',
+ rep_num_weeks smallint NULL,
+ private TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
Modified: mrbs/trunk/tables.pg.73and_above.sql
===================================================================
--- mrbs/trunk/tables.pg.73and_above.sql 2009-04-29 23:16:16 UTC (rev
1104)
+++ mrbs/trunk/tables.pg.73and_above.sql 2009-05-05 20:52:42 UTC (rev
1105)
@@ -59,7 +59,7 @@
name varchar(80) NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
- private private BOOL NOT NULL DEFAULT '0'
+ private BOOLEAN NOT NULL DEFAULT FALSE
);
create index idxStartTime on mrbs_entry(start_time);
create index idxEndTime on mrbs_entry(end_time);
@@ -79,7 +79,7 @@
type char DEFAULT 'E' NOT NULL,
description text,
rep_num_weeks smallint DEFAULT 0 NULL,
- private private BOOL NOT NULL DEFAULT '0'
+ private BOOLEAN NOT NULL DEFAULT FALSE
);
CREATE TABLE mrbs_variables
Modified: mrbs/trunk/tables.pg.sql
===================================================================
--- mrbs/trunk/tables.pg.sql 2009-04-29 23:16:16 UTC (rev 1104)
+++ mrbs/trunk/tables.pg.sql 2009-05-05 20:52:42 UTC (rev 1105)
@@ -47,7 +47,7 @@
name varchar(80) DEFAULT '' NOT NULL,
type char DEFAULT 'E' NOT NULL,
description text,
- private private BOOL NOT NULL DEFAULT '0'
+ private BOOLEAN NOT NULL DEFAULT FALSE
);
create index idxStartTime on mrbs_entry(start_time);
create index idxEndTime on mrbs_entry(end_time);
@@ -67,7 +67,7 @@
type char DEFAULT 'E' NOT NULL,
description text,
rep_num_weeks smallint DEFAULT NULL NULL,
- private private BOOL NOT NULL DEFAULT '0'
+ private BOOLEAN NOT NULL DEFAULT FALSE
);
CREATE TABLE mrbs_variables
Modified: mrbs/trunk/web/upgrade/3/mysql.sql
===================================================================
--- mrbs/trunk/web/upgrade/3/mysql.sql 2009-04-29 23:16:16 UTC (rev 1104)
+++ mrbs/trunk/web/upgrade/3/mysql.sql 2009-05-05 20:52:42 UTC (rev 1105)
@@ -5,6 +5,6 @@
-- for private bookings handling
ALTER TABLE %DB_TBL_PREFIX%repeat
- ADD private BOOL NOT NULL DEFAULT '0';
+ ADD private TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE %DB_TBL_PREFIX%entry
- ADD private BOOL NOT NULL DEFAULT '0';
+ ADD private TINYINT(1) NOT NULL DEFAULT 0;
Modified: mrbs/trunk/web/upgrade/3/pgsql.sql
===================================================================
--- mrbs/trunk/web/upgrade/3/pgsql.sql 2009-04-29 23:16:16 UTC (rev 1104)
+++ mrbs/trunk/web/upgrade/3/pgsql.sql 2009-05-05 20:52:42 UTC (rev 1105)
@@ -5,6 +5,6 @@
-- for private bookings handling
ALTER TABLE %DB_TBL_PREFIX%repeat
- ADD private BOOL NOT NULL DEFAULT '0';
+ ADD private BOOLEAN NOT NULL DEFAULT FALSE;
ALTER TABLE %DB_TBL_PREFIX%entry
- ADD private BOOL NOT NULL DEFAULT '0';
+ ADD private BOOLEAN NOT NULL DEFAULT FALSE;
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
