[CalendarServer-changes] [11937] CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades

[source_changes at macosforge.org]

Revision: 11937
          http://trac.calendarserver.org//changeset/11937
Author:   sagen at apple.com
Date:     2013-11-13 09:51:23 -0800 (Wed, 13 Nov 2013)
Log Message:
-----------
When upgrading, add "not null" to the priority column

Modified Paths:
--------------
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_27_to_28.sql
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_27_to_28.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_27_to_28.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_27_to_28.sql	2013-11-13 17:43:02 UTC (rev 11936)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_27_to_28.sql	2013-11-13 17:51:23 UTC (rev 11937)
@@ -21,7 +21,7 @@
 -- Push notification work related updates
 
 alter table PUSH_NOTIFICATION_WORK
- add ("PRIORITY" integer default 10);
+ add ("PRIORITY" integer default 10 not null);
 
 update PUSH_NOTIFICATION_WORK set PRIORITY = 10;
 

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_27_to_28.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_27_to_28.sql	2013-11-13 17:43:02 UTC (rev 11936)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_27_to_28.sql	2013-11-13 17:51:23 UTC (rev 11937)
@@ -21,7 +21,7 @@
 -- Push notification work related updates
 
 alter table PUSH_NOTIFICATION_WORK
- add column PRIORITY integer default 10;
+ add column PRIORITY integer default 10 not null;
 
 update PUSH_NOTIFICATION_WORK set PRIORITY = 10;
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140312/06ed17bb/attachment.html>