[CalendarServer-changes] [6731] CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql

[source_changes at macosforge.org]

Revision: 6731
          http://trac.macosforge.org/projects/calendarserver/changeset/6731
Author:   glyph at apple.com
Date:     2011-01-11 14:25:49 -0800 (Tue, 11 Jan 2011)
Log Message:
-----------
a few more indexes - revisions, addressbooks, notifications.

Modified Paths:
--------------
    CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql	2011-01-11 22:17:30 UTC (rev 6730)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema_v1.sql	2011-01-11 22:25:49 UTC (rev 6731)
@@ -335,6 +335,7 @@
   OWNER_UID        varchar(255) not null unique
 );
 
+create index ADDRESSBOOK_HOME_OWNER_UID on ADDRESSBOOK_HOME(OWNER_UID);
 
 --------------------------------
 -- AddressBook Home Meta-data --
@@ -345,6 +346,8 @@
   QUOTA_USED_BYTES integer      default 0 not null
 );
 
+create index ADDRESSBOOK_HOME_METADATA_RESOURCE_ID
+    on ADDRESSBOOK_HOME_METADATA(RESOURCE_ID);
 
 -----------------
 -- AddressBook --
@@ -381,6 +384,10 @@
   unique(ADDRESSBOOK_HOME_RESOURCE_ID, ADDRESSBOOK_RESOURCE_NAME)
 );
 
+create index ADDRESSBOOK_BIND_HOME_RESOURCE_ID on
+  ADDRESSBOOK_BIND(ADDRESSBOOK_HOME_RESOURCE_ID);
+create index ADDRESSBOOK_BIND_RESOURCE_ID on
+  ADDRESSBOOK_BIND(ADDRESSBOOK_RESOURCE_ID);
 
 create table ADDRESSBOOK_OBJECT (
   RESOURCE_ID             integer      primary key default nextval('RESOURCE_ID_SEQ'),
@@ -396,6 +403,9 @@
   unique(ADDRESSBOOK_RESOURCE_ID, VCARD_UID)
 );
 
+create index ADDRESSBOOK_OBJECT_ADDRESSBOOK_RESOURCE_ID on
+  ADDRESSBOOK_OBJECT(ADDRESSBOOK_RESOURCE_ID);
+
 ---------------
 -- Revisions --
 ---------------
@@ -419,6 +429,13 @@
 );
 
 
+create index CALENDAR_OBJECT_REVISIONS_HOME_RESOURCE_ID
+  on CALENDAR_OBJECT_REVISIONS(CALENDAR_HOME_RESOURCE_ID);
+
+create index CALENDAR_OBJECT_REVISIONS_RESOURCE_ID
+  on CALENDAR_OBJECT_REVISIONS(CALENDAR_RESOURCE_ID);
+
+
 -------------------------------
 -- AddressBook Object Revisions --
 -------------------------------
@@ -434,7 +451,12 @@
   unique(ADDRESSBOOK_RESOURCE_ID, RESOURCE_NAME)
 );
 
+create index ADDRESSBOOK_OBJECT_REVISIONS_HOME_RESOURCE_ID
+  on ADDRESSBOOK_OBJECT_REVISIONS(ADDRESSBOOK_HOME_RESOURCE_ID);
 
+create index ADDRESSBOOK_OBJECT_REVISIONS_RESOURCE_ID
+  on ADDRESSBOOK_OBJECT_REVISIONS(ADDRESSBOOK_RESOURCE_ID);
+
 -----------------------------------
 -- Notification Object Revisions --
 -----------------------------------
@@ -449,3 +471,6 @@
 );
 
 
+create index NOTIFICATION_OBJECT_REVISIONS_HOME_RESOURCE_ID
+  on NOTIFICATION_OBJECT_REVISIONS(NOTIFICATION_HOME_RESOURCE_ID);
+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20110111/a95c0578/attachment.html>