Revision: 2954
https://sourceforge.net/p/mrbs/code/2954/
Author: cimorrison
Date: 2015-01-18 12:05:57 +0000 (Sun, 18 Jan 2015)
Log Message:
-----------
Updated table creation SQL
Modified Paths:
--------------
mrbs/branches/repeat_id_fk/tables.my.sql
mrbs/branches/repeat_id_fk/tables.pg.sql
Modified: mrbs/branches/repeat_id_fk/tables.my.sql
===================================================================
--- mrbs/branches/repeat_id_fk/tables.my.sql 2015-01-18 11:55:43 UTC (rev
2953)
+++ mrbs/branches/repeat_id_fk/tables.my.sql 2015-01-18 12:05:57 UTC (rev
2954)
@@ -137,7 +137,7 @@
info_text text CHARACTER SET utf8 COLLATE utf8_general_ci,
ical_uid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT '' NOT NULL,
ical_sequence smallint DEFAULT 0 NOT NULL,
- ical_recur_id varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT '' NOT NULL,
+ ical_recur_id varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT NULL,
PRIMARY KEY (id),
FOREIGN KEY (room_id)
Modified: mrbs/branches/repeat_id_fk/tables.pg.sql
===================================================================
--- mrbs/branches/repeat_id_fk/tables.pg.sql 2015-01-18 11:55:43 UTC (rev
2953)
+++ mrbs/branches/repeat_id_fk/tables.pg.sql 2015-01-18 12:05:57 UTC (rev
2954)
@@ -130,7 +130,7 @@
start_time int DEFAULT 0 NOT NULL,
end_time int DEFAULT 0 NOT NULL,
entry_type int DEFAULT 0 NOT NULL,
- repeat_id int DEFAULT 0 NOT NULL,
+ repeat_id int DEFAULT NULL,
room_id int DEFAULT 1 NOT NULL
REFERENCES mrbs_room(id)
ON UPDATE CASCADE
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
