Changes between Version 5 and Version 6 of TeamCalendarPlugin


Ignore:
Timestamp:
May 12, 2010 9:41:18 PM (4 years ago)
Author:
Chris.Nelson@…
Comment:

CREATE TABLE for PostgreSQL

Legend:

Unmodified
Added
Removed
Modified
  • TeamCalendarPlugin

    v5 v6  
    3434 
    3535{{{ 
    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 
     37CREATE 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); 
    4243}}} 
    4344 
     45For PostgreSQL 8.3, we created the table with: 
     46 
     47{{{ 
     48#!sql 
     49CREATE 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}}} 
    4456== Under the hood == 
    4557