Changes between Version 5 and Version 6 of TeamCalendarPlugin
- Timestamp:
- May 12, 2010, 7:41:18 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TeamCalendarPlugin
v5 v6 34 34 35 35 {{{ 36 CREATE TABLE `team_availability` ( 37 `username` varchar(255) NOT NULL DEFAULT '', 38 `ondate` date NOT NULL DEFAULT '0000-00-00', 39 `availability` float unsigned DEFAULT NULL, 40 PRIMARY KEY (`username`,`ondate`) 41 ); 36 #!sql 37 CREATE TABLE `team_availability` ( 38 `username` varchar(255) NOT NULL DEFAULT '', 39 `ondate` date NOT NULL DEFAULT '0000-00-00', 40 `availability` float unsigned DEFAULT NULL, 41 PRIMARY KEY (`username`,`ondate`) 42 ); 42 43 }}} 43 44 45 For PostgreSQL 8.3, we created the table with: 46 47 {{{ 48 #!sql 49 CREATE TABLE team_availability ( 50 username varchar(255) NOT NULL DEFAULT '', 51 ondate date NOT NULL, 52 availability float DEFAULT NULL, 53 PRIMARY KEY (username,ondate) 54 ); 55 }}} 44 56 == Under the hood == 45 57