[CalendarServer-changes] [15638] CalendarServer/trunk/txdav/common/datastore/sql_schema

[source_changes at macosforge.org]

Revision: 15638
          http://trac.calendarserver.org//changeset/15638
Author:   sagen at apple.com
Date:     2016-05-25 13:09:28 -0700 (Wed, 25 May 2016)
Log Message:
-----------
Add index on APN_SUBSCRIPTIONS MODIFIED

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

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql	2016-05-25 19:14:41 UTC (rev 15637)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql	2016-05-25 20:09:28 UTC (rev 15638)
@@ -858,6 +858,10 @@
     "RESOURCE_KEY"
 );
 
+create index APN_SUBSCRIPTIONS_MOD_69027430 on APN_SUBSCRIPTIONS (
+    "MODIFIED"
+);
+
 create index IMIP_TOKENS_TOKEN_e94b918f on IMIP_TOKENS (
     "TOKEN"
 );

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql	2016-05-25 19:14:41 UTC (rev 15637)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql	2016-05-25 20:09:28 UTC (rev 15638)
@@ -742,6 +742,8 @@
 create index APN_SUBSCRIPTIONS_RESOURCE_KEY
   on APN_SUBSCRIPTIONS(RESOURCE_KEY);
 
+create index APN_SUBSCRIPTIONS_MODIFIED
+  on APN_SUBSCRIPTIONS(MODIFIED);
 
 -----------------
 -- IMIP Tokens --

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_61_to_62.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_61_to_62.sql	2016-05-25 19:14:41 UTC (rev 15637)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_61_to_62.sql	2016-05-25 20:09:28 UTC (rev 15638)
@@ -18,6 +18,11 @@
 -- Upgrade database schema from VERSION 61 to 62 --
 ---------------------------------------------------
 
+create index APN_SUBSCRIPTIONS_MOD_69027430 on APN_SUBSCRIPTIONS (
+    "MODIFIED"
+);
+
+
 create table APN_PURGING_WORK (
     "WORK_ID" integer primary key,
     "JOB_ID" integer not null references JOB

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_61_to_62.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_61_to_62.sql	2016-05-25 19:14:41 UTC (rev 15637)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_61_to_62.sql	2016-05-25 20:09:28 UTC (rev 15638)
@@ -18,6 +18,9 @@
 -- Upgrade database schema from VERSION 61 to 62 --
 ---------------------------------------------------
 
+create index APN_SUBSCRIPTIONS_MODIFIED
+  on APN_SUBSCRIPTIONS(MODIFIED);
+
 -------------------------------------
 -- Apple Push Notification Purging --
 -------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20160525/ff6d65d8/attachment.html>