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

[source_changes at macosforge.org]

Revision: 14780
          http://trac.calendarserver.org//changeset/14780
Author:   cdaboo at apple.com
Date:     2015-05-12 09:34:21 -0700 (Tue, 12 May 2015)
Log Message:
-----------
Fix missing index.

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_54_to_55.sql
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_54_to_55.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql	2015-05-12 15:15:17 UTC (rev 14779)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql	2015-05-12 16:34:21 UTC (rev 14780)
@@ -1007,4 +1007,8 @@
     "JOB_ID"
 );
 
+create index MIGRATION_CLEANUP_WOR_86181cb8 on MIGRATION_CLEANUP_WORK (
+    "HOME_RESOURCE_ID"
+);
+
 -- Extra schema to add to current-oracle-dialect.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql	2015-05-12 15:15:17 UTC (rev 14779)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql	2015-05-12 16:34:21 UTC (rev 14780)
@@ -1231,6 +1231,8 @@
 
 create index MIGRATION_CLEANUP_WORK_JOB_ID on
   MIGRATION_CLEANUP_WORK(JOB_ID);
+create index MIGRATION_CLEANUP_WORK_HOME_RESOURCE_ID on
+  MIGRATION_CLEANUP_WORK(HOME_RESOURCE_ID);
 
 --------------------
 -- Schema Version --

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_54_to_55.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_54_to_55.sql	2015-05-12 15:15:17 UTC (rev 14779)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_54_to_55.sql	2015-05-12 16:34:21 UTC (rev 14780)
@@ -32,6 +32,9 @@
 create index MIGRATION_CLEANUP_WOR_8c23cc35 on MIGRATION_CLEANUP_WORK (
     "JOB_ID"
 );
+create index MIGRATION_CLEANUP_WOR_86181cb8 on MIGRATION_CLEANUP_WORK (
+    "HOME_RESOURCE_ID"
+);
 
 -- update the version
 update CALENDARSERVER set VALUE = '55' where NAME = 'VERSION';

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_54_to_55.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_54_to_55.sql	2015-05-12 15:15:17 UTC (rev 14779)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_54_to_55.sql	2015-05-12 16:34:21 UTC (rev 14780)
@@ -31,6 +31,8 @@
 
 create index MIGRATION_CLEANUP_WORK_JOB_ID on
   MIGRATION_CLEANUP_WORK(JOB_ID);
+create index MIGRATION_CLEANUP_WORK_HOME_RESOURCE_ID on
+  MIGRATION_CLEANUP_WORK(HOME_RESOURCE_ID);
 
 -- update the version
 update CALENDARSERVER set VALUE = '55' where NAME = 'VERSION';
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20150512/3249fcae/attachment.html>