Changes between Version 5 and Version 6 of TeamCalendarPlugin


Ignore:
Timestamp:
May 12, 2010, 9:41:18 PM (5 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