<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>[14581] CalendarServer/trunk/txdav/common/datastore</title>
</head>
<body>
<style type="text/css"><!--
#msg dl.meta { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; }
#msg dl.meta dt { float: left; width: 6em; font-weight: bold; }
#msg dt:after { content:':';}
#msg dl, #msg dt, #msg ul, #msg li, #header, #footer, #logmsg { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; }
#msg dl a { font-weight: bold}
#msg dl a:link { color:#fc3; }
#msg dl a:active { color:#ff0; }
#msg dl a:visited { color:#cc6; }
h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; }
#msg pre { overflow: auto; background: #ffc; border: 1px #fa0 solid; padding: 6px; }
#logmsg { background: #ffc; border: 1px #fa0 solid; padding: 1em 1em 0 1em; }
#logmsg p, #logmsg pre, #logmsg blockquote { margin: 0 0 1em 0; }
#logmsg p, #logmsg li, #logmsg dt, #logmsg dd { line-height: 14pt; }
#logmsg h1, #logmsg h2, #logmsg h3, #logmsg h4, #logmsg h5, #logmsg h6 { margin: .5em 0; }
#logmsg h1:first-child, #logmsg h2:first-child, #logmsg h3:first-child, #logmsg h4:first-child, #logmsg h5:first-child, #logmsg h6:first-child { margin-top: 0; }
#logmsg ul, #logmsg ol { padding: 0; list-style-position: inside; margin: 0 0 0 1em; }
#logmsg ul { text-indent: -1em; padding-left: 1em; }#logmsg ol { text-indent: -1.5em; padding-left: 1.5em; }
#logmsg > ul, #logmsg > ol { margin: 0 0 1em 0; }
#logmsg pre { background: #eee; padding: 1em; }
#logmsg blockquote { border: 1px solid #fa0; border-left-width: 10px; padding: 1em 1em 0 1em; background: white;}
#logmsg dl { margin: 0; }
#logmsg dt { font-weight: bold; }
#logmsg dd { margin: 0; padding: 0 0 0.5em 0; }
#logmsg dd:before { content:'\00bb';}
#logmsg table { border-spacing: 0px; border-collapse: collapse; border-top: 4px solid #fa0; border-bottom: 1px solid #fa0; background: #fff; }
#logmsg table th { text-align: left; font-weight: normal; padding: 0.2em 0.5em; border-top: 1px dotted #fa0; }
#logmsg table td { text-align: right; border-top: 1px dotted #fa0; padding: 0.2em 0.5em; }
#logmsg table thead th { text-align: center; border-bottom: 1px solid #fa0; }
#logmsg table th.Corner { text-align: left; }
#logmsg hr { border: none 0; border-top: 2px dashed #fa0; height: 1px; }
#header, #footer { color: #fff; background: #636; border: 1px #300 solid; padding: 6px; }
#patch { width: 100%; }
#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;}
#patch .propset h4, #patch .binary h4 {margin:0;}
#patch pre {padding:0;line-height:1.2em;margin:0;}
#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;}
#patch .propset .diff, #patch .binary .diff {padding:10px 0;}
#patch span {display:block;padding:0 10px;}
#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;}
#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;}
#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;}
#patch .lines, .info {color:#888;background:#fff;}
--></style>
<div id="msg">
<dl class="meta">
<dt>Revision</dt> <dd><a href="http://trac.calendarserver.org//changeset/14581">14581</a></dd>
<dt>Author</dt> <dd>cdaboo@apple.com</dd>
<dt>Date</dt> <dd>2015-03-12 12:58:18 -0700 (Thu, 12 Mar 2015)</dd>
</dl>
<h3>Log Message</h3>
<pre>Fix Oracle schema issues.</pre>
<h3>Modified Paths</h3>
<ul>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemacurrentoracledialectsql">CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemacurrentsql">CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv40sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v40.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv41sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v41.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv42sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v42.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv43sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v43.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv44sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v44.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv45sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v45.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv46sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v46.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv47sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v47.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv48sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v48.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv49sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v49.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv50sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v50.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv51sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v51.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv52sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v52.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv40sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v40.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv41sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v41.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv42sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v42.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv43sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v43.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv44sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v44.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv45sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v45.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv46sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v46.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv47sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v47.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv48sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v48.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv49sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v49.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv50sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v50.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv51sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v51.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv52sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v52.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaupgradesoracledialectupgrade_from_39_to_40sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_39_to_40.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaupgradesoracledialectupgrade_from_46_to_47sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_46_to_47.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaupgradespostgresdialectupgrade_from_39_to_40sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_39_to_40.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_schemaupgradespostgresdialectupgrade_from_46_to_47sql">CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_46_to_47.sql</a></li>
<li><a href="#CalendarServertrunktxdavcommondatastoresql_tablespy">CalendarServer/trunk/txdav/common/datastore/sql_tables.py</a></li>
</ul>
</div>
<div id="patch">
<h3>Diff</h3>
<a id="CalendarServertrunktxdavcommondatastoresql_schemacurrentoracledialectsql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/current-oracle-dialect.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -656,353 +656,344 @@
</span><span class="cx"> insert into CALENDARSERVER (NAME, VALUE) values ('NOTIFICATION-DATAVERSION', '1');
</span><span class="cx"> insert into CALENDARSERVER (NAME, VALUE) values ('MIN-VALID-REVISION', '1');
</span><span class="cx"> create index CALENDAR_HOME_METADAT_475de898 on CALENDAR_HOME_METADATA (
</span><del>- TRASH
</del><ins>+ "TRASH"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_HOME_METADAT_3cb9049e on CALENDAR_HOME_METADATA (
</span><del>- DEFAULT_EVENTS
</del><ins>+ "DEFAULT_EVENTS"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_HOME_METADAT_d55e5548 on CALENDAR_HOME_METADATA (
</span><del>- DEFAULT_TASKS
</del><ins>+ "DEFAULT_TASKS"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_HOME_METADAT_910264ce on CALENDAR_HOME_METADATA (
</span><del>- DEFAULT_POLLS
</del><ins>+ "DEFAULT_POLLS"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_MIGRATION_LO_0525c72b on CALENDAR_MIGRATION (
</span><del>- LOCAL_RESOURCE_ID
</del><ins>+ "LOCAL_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index NOTIFICATION_NOTIFICA_f891f5f9 on NOTIFICATION (
</span><del>- NOTIFICATION_HOME_RESOURCE_ID
</del><ins>+ "NOTIFICATION_HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_BIND_RESOURC_e57964d4 on CALENDAR_BIND (
</span><del>- CALENDAR_RESOURCE_ID
</del><ins>+ "CALENDAR_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_CALEN_a9a453a9 on CALENDAR_OBJECT (
</span><del>- CALENDAR_RESOURCE_ID,
- ICALENDAR_UID
</del><ins>+ "CALENDAR_RESOURCE_ID",
+ "ICALENDAR_UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_CALEN_c4dc619c on CALENDAR_OBJECT (
</span><del>- CALENDAR_RESOURCE_ID,
- RECURRANCE_MAX,
- RECURRANCE_MIN
</del><ins>+ "CALENDAR_RESOURCE_ID",
+ "RECURRANCE_MAX",
+ "RECURRANCE_MIN"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_ICALE_82e731d5 on CALENDAR_OBJECT (
</span><del>- ICALENDAR_UID
</del><ins>+ "ICALENDAR_UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_DROPB_de041d80 on CALENDAR_OBJECT (
</span><del>- DROPBOX_ID
</del><ins>+ "DROPBOX_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index TIME_RANGE_CALENDAR_R_beb6e7eb on TIME_RANGE (
</span><del>- CALENDAR_RESOURCE_ID
</del><ins>+ "CALENDAR_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index TIME_RANGE_CALENDAR_O_acf37bd1 on TIME_RANGE (
</span><del>- CALENDAR_OBJECT_RESOURCE_ID
</del><ins>+ "CALENDAR_OBJECT_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_MIGRA_0502cbef on CALENDAR_OBJECT_MIGRATION (
</span><del>- CALENDAR_HOME_RESOURCE_ID,
- LOCAL_RESOURCE_ID
</del><ins>+ "CALENDAR_HOME_RESOURCE_ID",
+ "LOCAL_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_MIGRA_3577efd9 on CALENDAR_OBJECT_MIGRATION (
</span><del>- LOCAL_RESOURCE_ID
</del><ins>+ "LOCAL_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ATTACHMENT_CALENDAR_H_0078845c on ATTACHMENT (
</span><del>- CALENDAR_HOME_RESOURCE_ID
</del><ins>+ "CALENDAR_HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ATTACHMENT_DROPBOX_ID_5073cf23 on ATTACHMENT (
</span><del>- DROPBOX_ID
</del><ins>+ "DROPBOX_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ATTACHMENT_CALENDAR_O_81508484 on ATTACHMENT_CALENDAR_OBJECT (
</span><del>- CALENDAR_OBJECT_RESOURCE_ID
</del><ins>+ "CALENDAR_OBJECT_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ATTACHMENT_MIGRATION__804bf85e on ATTACHMENT_MIGRATION (
</span><del>- CALENDAR_HOME_RESOURCE_ID,
- LOCAL_RESOURCE_ID
</del><ins>+ "CALENDAR_HOME_RESOURCE_ID",
+ "LOCAL_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ATTACHMENT_MIGRATION__816947fe on ATTACHMENT_MIGRATION (
</span><del>- LOCAL_RESOURCE_ID
</del><ins>+ "LOCAL_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SHARED_ADDRESSBOOK_BI_e9a2e6d4 on SHARED_ADDRESSBOOK_BIND (
</span><del>- OWNER_HOME_RESOURCE_ID
</del><ins>+ "OWNER_HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ABO_MEMBERS_ADDRESSBO_4effa879 on ABO_MEMBERS (
</span><del>- ADDRESSBOOK_ID
</del><ins>+ "ADDRESSBOOK_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ABO_MEMBERS_MEMBER_ID_8d66adcf on ABO_MEMBERS (
</span><del>- MEMBER_ID
</del><ins>+ "MEMBER_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ABO_FOREIGN_MEMBERS_A_1fd2c5e9 on ABO_FOREIGN_MEMBERS (
</span><del>- ADDRESSBOOK_ID
</del><ins>+ "ADDRESSBOOK_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SHARED_GROUP_BIND_RES_cf52f95d on SHARED_GROUP_BIND (
</span><del>- GROUP_RESOURCE_ID
</del><ins>+ "GROUP_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_REVIS_6d9d929c on CALENDAR_OBJECT_REVISIONS (
</span><del>- CALENDAR_RESOURCE_ID,
- RESOURCE_NAME,
- DELETED,
- REVISION
</del><ins>+ "CALENDAR_RESOURCE_ID",
+ "RESOURCE_NAME",
+ "DELETED",
+ "REVISION"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_REVIS_265c8acf on CALENDAR_OBJECT_REVISIONS (
</span><del>- CALENDAR_RESOURCE_ID,
- REVISION
</del><ins>+ "CALENDAR_RESOURCE_ID",
+ "REVISION"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_REVIS_550b1c56 on CALENDAR_OBJECT_REVISIONS (
</span><del>- CALENDAR_HOME_RESOURCE_ID,
- REVISION
</del><ins>+ "CALENDAR_HOME_RESOURCE_ID",
+ "REVISION"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ADDRESSBOOK_OBJECT_RE_00fe8288 on ADDRESSBOOK_OBJECT_REVISIONS (
</span><del>- OWNER_HOME_RESOURCE_ID,
- RESOURCE_NAME,
- DELETED,
- REVISION
</del><ins>+ "OWNER_HOME_RESOURCE_ID",
+ "RESOURCE_NAME",
+ "DELETED",
+ "REVISION"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index ADDRESSBOOK_OBJECT_RE_45004780 on ADDRESSBOOK_OBJECT_REVISIONS (
</span><del>- OWNER_HOME_RESOURCE_ID,
- REVISION
</del><ins>+ "OWNER_HOME_RESOURCE_ID",
+ "REVISION"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index NOTIFICATION_OBJECT_R_036a9cee on NOTIFICATION_OBJECT_REVISIONS (
</span><del>- NOTIFICATION_HOME_RESOURCE_ID,
- REVISION
</del><ins>+ "NOTIFICATION_HOME_RESOURCE_ID",
+ "REVISION"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index APN_SUBSCRIPTIONS_RES_9610d78e on APN_SUBSCRIPTIONS (
</span><del>- RESOURCE_KEY
</del><ins>+ "RESOURCE_KEY"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index IMIP_TOKENS_TOKEN_e94b918f on IMIP_TOKENS (
</span><del>- TOKEN
</del><ins>+ "TOKEN"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index IMIP_INVITATION_WORK__586d064c on IMIP_INVITATION_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index IMIP_POLLING_WORK_JOB_d5535891 on IMIP_POLLING_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index IMIP_REPLY_WORK_JOB_I_bf4ae73e on IMIP_REPLY_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PUSH_NOTIFICATION_WOR_8bbab117 on PUSH_NOTIFICATION_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PUSH_NOTIFICATION_WOR_3a3ee588 on PUSH_NOTIFICATION_WORK (
</span><del>- PUSH_ID
</del><ins>+ "PUSH_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_CACHER_POLLING__6eb3151c on GROUP_CACHER_POLLING_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_REFRESH_WORK_JO_717ede20 on GROUP_REFRESH_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_REFRESH_WORK_GR_0325f3a8 on GROUP_REFRESH_WORK (
</span><del>- GROUP_UID
</del><ins>+ "GROUP_UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_DELEGATE_CHANGE_8bf9e6d8 on GROUP_DELEGATE_CHANGES_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_DELEGATE_CHANGE_d8f7af69 on GROUP_DELEGATE_CHANGES_WORK (
</span><del>- DELEGATOR_UID
</del><ins>+ "DELEGATOR_UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><del>- MEMBER_UID
</del><ins>+ "MEMBER_UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_ATTENDEE_RECONC_da73d3c2 on GROUP_ATTENDEE_RECONCILE_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_ATTENDEE_RECONC_b894ee7a on GROUP_ATTENDEE_RECONCILE_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_ATTENDEE_RECONC_5eabc549 on GROUP_ATTENDEE_RECONCILE_WORK (
</span><del>- GROUP_ID
</del><ins>+ "GROUP_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_ATTENDEE_RESOUR_855124dc on GROUP_ATTENDEE (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_SHAREE_RECONCIL_9aad0858 on GROUP_SHAREE_RECONCILE_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_SHAREE_RECONCIL_4dc60f78 on GROUP_SHAREE_RECONCILE_WORK (
</span><del>- CALENDAR_ID
</del><ins>+ "CALENDAR_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_SHAREE_RECONCIL_1d14c921 on GROUP_SHAREE_RECONCILE_WORK (
</span><del>- GROUP_ID
</del><ins>+ "GROUP_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index GROUP_SHAREE_CALENDAR_28a88850 on GROUP_SHAREE (
</span><del>- CALENDAR_ID
</del><ins>+ "CALENDAR_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index DELEGATE_TO_DELEGATOR_5e149b11 on DELEGATES (
</span><del>- DELEGATE,
- READ_WRITE,
- DELEGATOR
</del><ins>+ "DELEGATE",
+ "READ_WRITE",
+ "DELEGATOR"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index DELEGATE_GROUPS_GROUP_25117446 on DELEGATE_GROUPS (
</span><del>- GROUP_ID
</del><ins>+ "GROUP_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_SPLIT_af71dcda on CALENDAR_OBJECT_SPLITTER_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_SPLIT_33603b72 on CALENDAR_OBJECT_SPLITTER_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_UPGRA_a5c181eb on CALENDAR_OBJECT_UPGRADE_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CALENDAR_OBJECT_UPGRA_39d6f8f9 on CALENDAR_OBJECT_UPGRADE_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index FIND_MIN_VALID_REVISI_78d17400 on FIND_MIN_VALID_REVISION_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index REVISION_CLEANUP_WORK_eb062686 on REVISION_CLEANUP_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index INBOX_CLEANUP_WORK_JO_799132bd on INBOX_CLEANUP_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index CLEANUP_ONE_INBOX_WOR_375dac36 on CLEANUP_ONE_INBOX_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_WORK_JOB_ID_65e810ee on SCHEDULE_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_WORK_ICALEND_089f33dc on SCHEDULE_WORK (
</span><del>- ICALENDAR_UID
</del><ins>+ "ICALENDAR_UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_REFRESH_WORK_26084c7b on SCHEDULE_REFRESH_WORK (
</span><del>- HOME_RESOURCE_ID
</del><ins>+ "HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_REFRESH_WORK_989efe54 on SCHEDULE_REFRESH_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><del>- HOME_RESOURCE_ID
</del><ins>+ "HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0755e754 on SCHEDULE_AUTO_REPLY_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_ORGANIZER_WO_18ce4edd on SCHEDULE_ORGANIZER_WORK (
</span><del>- HOME_RESOURCE_ID
</del><ins>+ "HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_ORGANIZER_WO_14702035 on SCHEDULE_ORGANIZER_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_ORGANIZER_SE_9ec9f827 on SCHEDULE_ORGANIZER_SEND_WORK (
</span><del>- HOME_RESOURCE_ID
</del><ins>+ "HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_ORGANIZER_SE_699fefc4 on SCHEDULE_ORGANIZER_SEND_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_REPLY_WORK_H_745af8cf on SCHEDULE_REPLY_WORK (
</span><del>- HOME_RESOURCE_ID
</del><ins>+ "HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index SCHEDULE_REPLY_WORK_R_11bd3fbb on SCHEDULE_REPLY_WORK (
</span><del>- RESOURCE_ID
</del><ins>+ "RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_POLLI_6383e68a on PRINCIPAL_PURGE_POLLING_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_CHECK_b0c024c1 on PRINCIPAL_PURGE_CHECK_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_CHECK_198388a5 on PRINCIPAL_PURGE_CHECK_WORK (
</span><del>- UID
</del><ins>+ "UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_WORK__7a8141a3 on PRINCIPAL_PURGE_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_WORK__db35cfdc on PRINCIPAL_PURGE_WORK (
</span><del>- UID
</del><ins>+ "UID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_HOME__f35eea7a on PRINCIPAL_PURGE_HOME_WORK (
</span><del>- JOB_ID
</del><ins>+ "JOB_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> create index PRINCIPAL_PURGE_HOME__967e4480 on PRINCIPAL_PURGE_HOME_WORK (
</span><del>- HOME_RESOURCE_ID
</del><ins>+ "HOME_RESOURCE_ID"
</ins><span class="cx"> );
</span><span class="cx">
</span><span class="cx"> -- Extra schema to add to current-oracle-dialect.sql
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemacurrentsql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/current.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -864,14 +864,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -1078,9 +1076,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv40sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v40.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v40.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v40.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -780,11 +780,6 @@
</span><span class="cx"> JOB_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv41sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v41.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v41.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v41.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -787,11 +787,6 @@
</span><span class="cx"> JOB_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv42sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v42.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v42.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v42.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -788,11 +788,6 @@
</span><span class="cx"> JOB_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv43sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v43.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v43.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v43.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -789,11 +789,6 @@
</span><span class="cx"> JOB_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv44sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v44.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v44.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v44.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -800,11 +800,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv45sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v45.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v45.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v45.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -802,11 +802,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv46sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v46.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v46.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v46.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -844,11 +844,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv47sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v47.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v47.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v47.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -766,10 +766,6 @@
</span><span class="cx"> JOB_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><span class="cx"> MEMBER_UID
</span><span class="cx"> );
</span><span class="lines">@@ -856,11 +852,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv48sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v48.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v48.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v48.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -755,10 +755,6 @@
</span><span class="cx"> JOB_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><span class="cx"> MEMBER_UID
</span><span class="cx"> );
</span><span class="lines">@@ -845,11 +841,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv49sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v49.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v49.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v49.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -773,10 +773,6 @@
</span><span class="cx"> DELEGATOR_UID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><span class="cx"> MEMBER_UID
</span><span class="cx"> );
</span><span class="lines">@@ -863,11 +859,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv50sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v50.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v50.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v50.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -767,10 +767,6 @@
</span><span class="cx"> DELEGATOR_UID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><span class="cx"> MEMBER_UID
</span><span class="cx"> );
</span><span class="lines">@@ -857,11 +853,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv51sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v51.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v51.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v51.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -773,10 +773,6 @@
</span><span class="cx"> DELEGATOR_UID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><span class="cx"> MEMBER_UID
</span><span class="cx"> );
</span><span class="lines">@@ -871,11 +867,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldoracledialectv52sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v52.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v52.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/oracle-dialect/v52.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -822,10 +822,6 @@
</span><span class="cx"> DELEGATOR_UID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
- GROUP_UID
-);
-
</del><span class="cx"> create index GROUP_MEMBERSHIP_MEMB_0ca508e8 on GROUP_MEMBERSHIP (
</span><span class="cx"> MEMBER_UID
</span><span class="cx"> );
</span><span class="lines">@@ -920,11 +916,6 @@
</span><span class="cx"> RESOURCE_ID
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTE_83053b91 on SCHEDULE_REFRESH_ATTENDEES (
- RESOURCE_ID,
- ATTENDEE
-);
-
</del><span class="cx"> create index SCHEDULE_AUTO_REPLY_W_0256478d on SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx"> HOME_RESOURCE_ID
</span><span class="cx"> );
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv40sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v40.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v40.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v40.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -920,9 +920,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv41sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v41.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v41.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v41.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -921,9 +921,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv42sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v42.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v42.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v42.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -922,9 +922,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv43sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v43.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v43.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v43.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -923,9 +923,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv44sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v44.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v44.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v44.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -926,9 +926,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv45sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v45.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v45.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v45.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -928,9 +928,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv46sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v46.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v46.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v46.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -964,9 +964,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv47sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v47.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v47.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v47.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -776,14 +776,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -975,9 +973,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv48sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v48.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v48.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v48.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -773,14 +773,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -972,9 +970,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv49sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v49.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v49.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v49.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -782,14 +782,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -981,9 +979,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv50sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v50.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v50.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v50.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -782,14 +782,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -981,9 +979,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv51sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v51.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v51.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v51.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -782,14 +782,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -996,9 +994,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaoldpostgresdialectv52sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v52.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v52.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/old/postgres-dialect/v52.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -843,14 +843,12 @@
</span><span class="cx"> create table GROUPS (
</span><span class="cx"> GROUP_ID integer primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
</span><span class="cx"> NAME varchar(255) not null,
</span><del>- GROUP_UID varchar(255) not null unique,
</del><ins>+ GROUP_UID varchar(255) not null unique, -- implicit index
</ins><span class="cx"> MEMBERSHIP_HASH varchar(255) not null,
</span><span class="cx"> EXTANT integer default 1,
</span><span class="cx"> CREATED timestamp default timezone('UTC', CURRENT_TIMESTAMP),
</span><span class="cx"> MODIFIED timestamp default timezone('UTC', CURRENT_TIMESTAMP)
</span><span class="cx"> );
</span><del>-create index GROUPS_GROUP_UID on
- GROUPS(GROUP_UID);
</del><span class="cx">
</span><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx"> GROUP_ID integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -1057,9 +1055,6 @@
</span><span class="cx"> primary key (RESOURCE_ID, ATTENDEE)
</span><span class="cx"> );
</span><span class="cx">
</span><del>-create index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE on
- SCHEDULE_REFRESH_ATTENDEES(RESOURCE_ID, ATTENDEE);
-
</del><span class="cx"> ------------------------------
</span><span class="cx"> -- Schedule Auto Reply Work --
</span><span class="cx"> ------------------------------
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaupgradesoracledialectupgrade_from_39_to_40sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_39_to_40.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_39_to_40.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_39_to_40.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -37,6 +37,7 @@
</span><span class="cx"> GROUP_ID
</span><span class="cx"> );
</span><span class="cx">
</span><ins>+drop index SCHEDULE_REFRESH_ATTE_83053b91;
</ins><span class="cx"> alter table SCHEDULE_REFRESH_ATTENDEES add
</span><span class="cx"> primary key ("RESOURCE_ID", "ATTENDEE");
</span><span class="cx">
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaupgradesoracledialectupgrade_from_46_to_47sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_46_to_47.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_46_to_47.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_46_to_47.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -33,6 +33,7 @@
</span><span class="cx">
</span><span class="cx">
</span><span class="cx"> -- Add "unique" to GROUPS.GROUP_UID
</span><ins>+drop index GROUPS_GROUP_UID_b35cce23;
</ins><span class="cx"> alter table GROUPS add unique (GROUP_UID);
</span><span class="cx">
</span><span class="cx">
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaupgradespostgresdialectupgrade_from_39_to_40sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_39_to_40.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_39_to_40.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_39_to_40.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -35,6 +35,7 @@
</span><span class="cx"> create index DELEGATE_GROUPS_GROUP_ID on
</span><span class="cx"> DELEGATE_GROUPS(GROUP_ID);
</span><span class="cx">
</span><ins>+drop index SCHEDULE_REFRESH_ATTENDEES_RESOURCE_ID_ATTENDEE;
</ins><span class="cx"> alter table SCHEDULE_REFRESH_ATTENDEES add
</span><span class="cx"> primary key(RESOURCE_ID, ATTENDEE);
</span><span class="cx">
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_schemaupgradespostgresdialectupgrade_from_46_to_47sql"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_46_to_47.sql (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_46_to_47.sql 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/postgres-dialect/upgrade_from_46_to_47.sql 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -33,6 +33,7 @@
</span><span class="cx">
</span><span class="cx">
</span><span class="cx"> -- Add "unique" to GROUPS.GROUP_UID
</span><ins>+drop index GROUPS_GROUP_UID;
</ins><span class="cx"> alter table GROUPS add unique (GROUP_UID);
</span><span class="cx">
</span><span class="cx">
</span></span></pre></div>
<a id="CalendarServertrunktxdavcommondatastoresql_tablespy"></a>
<div class="modfile"><h4>Modified: CalendarServer/trunk/txdav/common/datastore/sql_tables.py (14580 => 14581)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/trunk/txdav/common/datastore/sql_tables.py 2015-03-12 19:50:10 UTC (rev 14580)
+++ CalendarServer/trunk/txdav/common/datastore/sql_tables.py 2015-03-12 19:58:18 UTC (rev 14581)
</span><span class="lines">@@ -435,7 +435,7 @@
</span><span class="cx"> out.write(
</span><span class="cx"> 'create index %s on %s (\n ' % (shortIndexName, shortTableName)
</span><span class="cx"> )
</span><del>- out.write(',\n '.join([column.name for column in index.columns]))
</del><ins>+ out.write(',\n '.join(["\"{}\"".format(column.name) for column in index.columns]))
</ins><span class="cx"> out.write('\n);\n\n')
</span><span class="cx">
</span><span class="cx"> # Functions are skipped as they likely use dialect specific syntax. Instead, functions
</span></span></pre>
</div>
</div>
</body>
</html>