elections.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-)
New commits: commit d57818a7586bcefc25ee66a9d43ce1d389570fdc Author: Nigel Jones dev@nigelj.com Date: Mon Oct 6 23:42:42 2008 +1300
Fix SQL for timestamps...
MySQL was creating start_date as: '`start_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,'
This is said to be a feature, but I don't like it... http://dev.mysql.com/doc/refman/5.1/en/timestamp.html for more info
diff --git a/elections.sql b/elections.sql index f3c129a..9b29f60 100644 --- a/elections.sql +++ b/elections.sql @@ -19,8 +19,8 @@ shortdesc text NOT NULL, description text NOT NULL,
url text, -start_date timestamp NOT NULL, -end_date timestamp NOT NULL, +start_date timestamp DEFAULT 0 NOT NULL, +end_date timestamp DEFAULT 0 NOT NULL, -- Are results currently embargoed? embargoed boolean NOT NULL, -- Number of seats elected @@ -28,7 +28,7 @@ seats_elected integer NOT NULL, -- Does this election support nominations? allow_nominations boolean NOT NULL, -- If so, when do they have to be in by? -nomination_end timestamp, +nomination_end timestamp DEFAULT 0,
UNIQUE (alias), PRIMARY KEY (id)
elections-devel@lists.stg.fedorahosted.org