[CalendarServer-changes] [12183] CalendarServer/branches/users/gaya/cleanrevisions/txdav/common/ datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_30_to_31.sql
source_changes at macosforge.org
source_changes at macosforge.org
Wed Mar 12 11:22:44 PDT 2014
Revision: 12183
http://trac.calendarserver.org//changeset/12183
Author: gaya at apple.com
Date: 2013-12-20 21:25:27 -0800 (Fri, 20 Dec 2013)
Log Message:
-----------
fix REVISION_CLEANUP_WORK
Modified Paths:
--------------
CalendarServer/branches/users/gaya/cleanrevisions/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_30_to_31.sql
Modified: CalendarServer/branches/users/gaya/cleanrevisions/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_30_to_31.sql
===================================================================
--- CalendarServer/branches/users/gaya/cleanrevisions/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_30_to_31.sql 2013-12-21 04:32:24 UTC (rev 12182)
+++ CalendarServer/branches/users/gaya/cleanrevisions/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_30_to_31.sql 2013-12-21 05:25:27 UTC (rev 12183)
@@ -32,8 +32,8 @@
-- Add cleanup work table --
create table REVISION_CLEANUP_WORK (
- "WORK_ID" integer primary key not null,
- "NOT_BEFORE" timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
+ WORK_ID integer primary key default nextval('WORKITEM_SEQ') not null,
+ NOT_BEFORE timestamp default timezone('UTC', CURRENT_TIMESTAMP)
);
-- Update version --
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140312/37f9dc2e/attachment.html>
More information about the calendarserver-changes
mailing list