Changes between Version 5 and Version 6 of TeamCalendarPlugin

Timestamp:

May 12, 2010, 7:41:18 PM (14 years ago)

Author:

Chris.Nelson@…

Comment:

CREATE TABLE for PostgreSQL

TeamCalendarPlugin

@@ -34 +34 @@
 
 {{{
-        CREATE TABLE `team_availability` (
-          `username` varchar(255) NOT NULL DEFAULT '',
-          `ondate` date NOT NULL DEFAULT '0000-00-00',
-          `availability` float unsigned DEFAULT NULL,
-          PRIMARY KEY (`username`,`ondate`)
-        );
+#!sql
+CREATE TABLE `team_availability` (
+  `username` varchar(255) NOT NULL DEFAULT '',
+  `ondate` date NOT NULL DEFAULT '0000-00-00',
+  `availability` float unsigned DEFAULT NULL,
+  PRIMARY KEY (`username`,`ondate`)
+);
 }}}
 
+For PostgreSQL 8.3, we created the table with:
+
+{{{
+#!sql
+CREATE TABLE team_availability (
+   username varchar(255) NOT NULL DEFAULT '',
+   ondate date NOT NULL,
+   availability float DEFAULT NULL,
+   PRIMARY KEY (username,ondate)
+);
+}}}
 == Under the hood ==