<!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>[15732] CalendarServer/branches/users/cdaboo/better-next-job/txdav/common/datastore/sql_schema/current-oracle-dialect.sql</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/15732">15732</a></dd>
<dt>Author</dt> <dd>cdaboo@apple.com</dd>
<dt>Date</dt> <dd>2016-07-01 06:55:11 -0700 (Fri, 01 Jul 2016)</dd>
</dl>

<h3>Log Message</h3>
<pre>Whitespace.</pre>

<h3>Modified Paths</h3>
<ul>
<li><a href="#CalendarServerbranchesuserscdaboobetternextjobtxdavcommondatastoresql_schemacurrentoracledialectsql">CalendarServer/branches/users/cdaboo/better-next-job/txdav/common/datastore/sql_schema/current-oracle-dialect.sql</a></li>
</ul>

</div>
<div id="patch">
<h3>Diff</h3>
<a id="CalendarServerbranchesuserscdaboobetternextjobtxdavcommondatastoresql_schemacurrentoracledialectsql"></a>
<div class="modfile"><h4>Modified: CalendarServer/branches/users/cdaboo/better-next-job/txdav/common/datastore/sql_schema/current-oracle-dialect.sql (15731 => 15732)</h4>
<pre class="diff"><span>
<span class="info">--- CalendarServer/branches/users/cdaboo/better-next-job/txdav/common/datastore/sql_schema/current-oracle-dialect.sql        2016-07-01 13:52:32 UTC (rev 15731)
+++ CalendarServer/branches/users/cdaboo/better-next-job/txdav/common/datastore/sql_schema/current-oracle-dialect.sql        2016-07-01 13:55:11 UTC (rev 15732)
</span><span class="lines">@@ -4,10 +4,13 @@
</span><span class="cx"> create sequence ATTACHMENT_ID_SEQ;
</span><span class="cx"> create sequence REVISION_SEQ;
</span><span class="cx"> create sequence WORKITEM_SEQ;
</span><ins>+
+
</ins><span class="cx"> create table NAMED_LOCK (
</span><span class="cx">     &quot;LOCK_NAME&quot; nvarchar2(255) primary key
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table JOB (
</span><span class="cx">     &quot;JOB_ID&quot; integer primary key,
</span><span class="cx">     &quot;WORK_TYPE&quot; nvarchar2(255),
</span><span class="lines">@@ -21,6 +24,7 @@
</span><span class="cx">     &quot;PAUSE&quot; integer default 0 not null
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_HOME (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;OWNER_UID&quot; nvarchar2(255),
</span><span class="lines">@@ -29,6 +33,7 @@
</span><span class="cx">     unique (&quot;OWNER_UID&quot;, &quot;STATUS&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table HOME_STATUS (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -39,10 +44,13 @@
</span><span class="cx"> insert into HOME_STATUS (DESCRIPTION, ID) values ('purging', 2);
</span><span class="cx"> insert into HOME_STATUS (DESCRIPTION, ID) values ('migrating', 3);
</span><span class="cx"> insert into HOME_STATUS (DESCRIPTION, ID) values ('disabled', 4);
</span><ins>+
+
</ins><span class="cx"> create table CALENDAR (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_HOME_METADATA (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key references CALENDAR_HOME on delete cascade,
</span><span class="cx">     &quot;QUOTA_USED_BYTES&quot; integer default 0 not null,
</span><span class="lines">@@ -59,6 +67,7 @@
</span><span class="cx">     &quot;MODIFIED&quot; timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_METADATA (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key references CALENDAR on delete cascade,
</span><span class="cx">     &quot;SUPPORTED_COMPONENTS&quot; nvarchar2(255) default null,
</span><span class="lines">@@ -69,6 +78,7 @@
</span><span class="cx">     &quot;MODIFIED&quot; timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CHILD_TYPE (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -77,6 +87,8 @@
</span><span class="cx"> insert into CHILD_TYPE (DESCRIPTION, ID) values ('normal', 0);
</span><span class="cx"> insert into CHILD_TYPE (DESCRIPTION, ID) values ('inbox', 1);
</span><span class="cx"> insert into CHILD_TYPE (DESCRIPTION, ID) values ('trash', 2);
</span><ins>+
+
</ins><span class="cx"> create table CALENDAR_MIGRATION (
</span><span class="cx">     &quot;CALENDAR_HOME_RESOURCE_ID&quot; integer references CALENDAR_HOME on delete cascade,
</span><span class="cx">     &quot;REMOTE_RESOURCE_ID&quot; integer not null,
</span><span class="lines">@@ -85,6 +97,7 @@
</span><span class="cx">     primary key (&quot;CALENDAR_HOME_RESOURCE_ID&quot;, &quot;REMOTE_RESOURCE_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table NOTIFICATION_HOME (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;OWNER_UID&quot; nvarchar2(255),
</span><span class="lines">@@ -93,6 +106,7 @@
</span><span class="cx">     unique (&quot;OWNER_UID&quot;, &quot;STATUS&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table NOTIFICATION (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;NOTIFICATION_HOME_RESOURCE_ID&quot; integer not null references NOTIFICATION_HOME,
</span><span class="lines">@@ -105,6 +119,7 @@
</span><span class="cx">     unique (&quot;NOTIFICATION_UID&quot;, &quot;NOTIFICATION_HOME_RESOURCE_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_BIND (
</span><span class="cx">     &quot;CALENDAR_HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME,
</span><span class="cx">     &quot;CALENDAR_RESOURCE_ID&quot; integer not null references CALENDAR on delete cascade,
</span><span class="lines">@@ -124,6 +139,7 @@
</span><span class="cx">     unique (&quot;CALENDAR_HOME_RESOURCE_ID&quot;, &quot;CALENDAR_RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_BIND_MODE (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -137,6 +153,8 @@
</span><span class="cx"> insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('group', 5);
</span><span class="cx"> insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('group_read', 6);
</span><span class="cx"> insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('group_write', 7);
</span><ins>+
+
</ins><span class="cx"> create table CALENDAR_BIND_STATUS (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -147,6 +165,8 @@
</span><span class="cx"> insert into CALENDAR_BIND_STATUS (DESCRIPTION, ID) values ('declined', 2);
</span><span class="cx"> insert into CALENDAR_BIND_STATUS (DESCRIPTION, ID) values ('invalid', 3);
</span><span class="cx"> insert into CALENDAR_BIND_STATUS (DESCRIPTION, ID) values ('deleted', 4);
</span><ins>+
+
</ins><span class="cx"> create table CALENDAR_TRANSP (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -154,6 +174,8 @@
</span><span class="cx"> 
</span><span class="cx"> insert into CALENDAR_TRANSP (DESCRIPTION, ID) values ('opaque', 0);
</span><span class="cx"> insert into CALENDAR_TRANSP (DESCRIPTION, ID) values ('transparent', 1);
</span><ins>+
+
</ins><span class="cx"> create table CALENDAR_OBJECT (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;CALENDAR_RESOURCE_ID&quot; integer not null references CALENDAR on delete cascade,
</span><span class="lines">@@ -180,6 +202,7 @@
</span><span class="cx">     unique (&quot;CALENDAR_RESOURCE_ID&quot;, &quot;RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_OBJ_ATTACHMENTS_MODE (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -188,6 +211,8 @@
</span><span class="cx"> insert into CALENDAR_OBJ_ATTACHMENTS_MODE (DESCRIPTION, ID) values ('none', 0);
</span><span class="cx"> insert into CALENDAR_OBJ_ATTACHMENTS_MODE (DESCRIPTION, ID) values ('read', 1);
</span><span class="cx"> insert into CALENDAR_OBJ_ATTACHMENTS_MODE (DESCRIPTION, ID) values ('write', 2);
</span><ins>+
+
</ins><span class="cx"> create table CALENDAR_ACCESS_TYPE (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(32) unique
</span><span class="lines">@@ -198,6 +223,8 @@
</span><span class="cx"> insert into CALENDAR_ACCESS_TYPE (DESCRIPTION, ID) values ('private', 2);
</span><span class="cx"> insert into CALENDAR_ACCESS_TYPE (DESCRIPTION, ID) values ('confidential', 3);
</span><span class="cx"> insert into CALENDAR_ACCESS_TYPE (DESCRIPTION, ID) values ('restricted', 4);
</span><ins>+
+
</ins><span class="cx"> create table TIME_RANGE (
</span><span class="cx">     &quot;INSTANCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;CALENDAR_RESOURCE_ID&quot; integer not null references CALENDAR on delete cascade,
</span><span class="lines">@@ -209,6 +236,7 @@
</span><span class="cx">     &quot;TRANSPARENT&quot; integer not null
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table FREE_BUSY_TYPE (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -219,6 +247,8 @@
</span><span class="cx"> insert into FREE_BUSY_TYPE (DESCRIPTION, ID) values ('busy', 2);
</span><span class="cx"> insert into FREE_BUSY_TYPE (DESCRIPTION, ID) values ('busy-unavailable', 3);
</span><span class="cx"> insert into FREE_BUSY_TYPE (DESCRIPTION, ID) values ('busy-tentative', 4);
</span><ins>+
+
</ins><span class="cx"> create table PERUSER (
</span><span class="cx">     &quot;TIME_RANGE_INSTANCE_ID&quot; integer not null references TIME_RANGE on delete cascade,
</span><span class="cx">     &quot;USER_ID&quot; nvarchar2(255),
</span><span class="lines">@@ -228,6 +258,7 @@
</span><span class="cx">     primary key (&quot;TIME_RANGE_INSTANCE_ID&quot;, &quot;USER_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_OBJECT_MIGRATION (
</span><span class="cx">     &quot;CALENDAR_HOME_RESOURCE_ID&quot; integer references CALENDAR_HOME on delete cascade,
</span><span class="cx">     &quot;REMOTE_RESOURCE_ID&quot; integer not null,
</span><span class="lines">@@ -235,6 +266,7 @@
</span><span class="cx">     primary key (&quot;CALENDAR_HOME_RESOURCE_ID&quot;, &quot;REMOTE_RESOURCE_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ATTACHMENT (
</span><span class="cx">     &quot;ATTACHMENT_ID&quot; integer primary key,
</span><span class="cx">     &quot;CALENDAR_HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME,
</span><span class="lines">@@ -247,6 +279,7 @@
</span><span class="cx">     &quot;PATH&quot; nvarchar2(1024)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ATTACHMENT_CALENDAR_OBJECT (
</span><span class="cx">     &quot;ATTACHMENT_ID&quot; integer not null references ATTACHMENT on delete cascade,
</span><span class="cx">     &quot;MANAGED_ID&quot; nvarchar2(255),
</span><span class="lines">@@ -255,6 +288,7 @@
</span><span class="cx">     unique (&quot;MANAGED_ID&quot;, &quot;CALENDAR_OBJECT_RESOURCE_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ATTACHMENT_MIGRATION (
</span><span class="cx">     &quot;CALENDAR_HOME_RESOURCE_ID&quot; integer references CALENDAR_HOME on delete cascade,
</span><span class="cx">     &quot;REMOTE_RESOURCE_ID&quot; integer not null,
</span><span class="lines">@@ -262,6 +296,7 @@
</span><span class="cx">     primary key (&quot;CALENDAR_HOME_RESOURCE_ID&quot;, &quot;REMOTE_RESOURCE_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table RESOURCE_PROPERTY (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer not null,
</span><span class="cx">     &quot;NAME&quot; nvarchar2(255),
</span><span class="lines">@@ -270,6 +305,7 @@
</span><span class="cx">     primary key (&quot;RESOURCE_ID&quot;, &quot;NAME&quot;, &quot;VIEWER_UID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ADDRESSBOOK_HOME (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;ADDRESSBOOK_PROPERTY_STORE_ID&quot; integer not null,
</span><span class="lines">@@ -279,6 +315,7 @@
</span><span class="cx">     unique (&quot;OWNER_UID&quot;, &quot;STATUS&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ADDRESSBOOK_HOME_METADATA (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key references ADDRESSBOOK_HOME on delete cascade,
</span><span class="cx">     &quot;QUOTA_USED_BYTES&quot; integer default 0 not null,
</span><span class="lines">@@ -286,6 +323,7 @@
</span><span class="cx">     &quot;MODIFIED&quot; timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SHARED_ADDRESSBOOK_BIND (
</span><span class="cx">     &quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot; integer not null references ADDRESSBOOK_HOME,
</span><span class="cx">     &quot;OWNER_HOME_RESOURCE_ID&quot; integer not null references ADDRESSBOOK_HOME on delete cascade,
</span><span class="lines">@@ -299,6 +337,7 @@
</span><span class="cx">     unique (&quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot;, &quot;ADDRESSBOOK_RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ADDRESSBOOK_OBJECT (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer primary key,
</span><span class="cx">     &quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot; integer not null references ADDRESSBOOK_HOME on delete cascade,
</span><span class="lines">@@ -316,6 +355,7 @@
</span><span class="cx">     unique (&quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot;, &quot;VCARD_UID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ADDRESSBOOK_OBJECT_KIND (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -325,6 +365,8 @@
</span><span class="cx"> insert into ADDRESSBOOK_OBJECT_KIND (DESCRIPTION, ID) values ('group', 1);
</span><span class="cx"> insert into ADDRESSBOOK_OBJECT_KIND (DESCRIPTION, ID) values ('resource', 2);
</span><span class="cx"> insert into ADDRESSBOOK_OBJECT_KIND (DESCRIPTION, ID) values ('location', 3);
</span><ins>+
+
</ins><span class="cx"> create table ABO_MEMBERS (
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null,
</span><span class="cx">     &quot;ADDRESSBOOK_ID&quot; integer not null references ADDRESSBOOK_HOME on delete cascade,
</span><span class="lines">@@ -335,6 +377,7 @@
</span><span class="cx">     primary key (&quot;GROUP_ID&quot;, &quot;MEMBER_ID&quot;, &quot;REVISION&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ABO_FOREIGN_MEMBERS (
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references ADDRESSBOOK_OBJECT on delete cascade,
</span><span class="cx">     &quot;ADDRESSBOOK_ID&quot; integer not null references ADDRESSBOOK_HOME on delete cascade,
</span><span class="lines">@@ -342,6 +385,7 @@
</span><span class="cx">     primary key (&quot;GROUP_ID&quot;, &quot;MEMBER_ADDRESS&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SHARED_GROUP_BIND (
</span><span class="cx">     &quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot; integer not null references ADDRESSBOOK_HOME,
</span><span class="cx">     &quot;GROUP_RESOURCE_ID&quot; integer not null references ADDRESSBOOK_OBJECT on delete cascade,
</span><span class="lines">@@ -355,6 +399,7 @@
</span><span class="cx">     unique (&quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot;, &quot;GROUP_ADDRESSBOOK_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_OBJECT_REVISIONS (
</span><span class="cx">     &quot;CALENDAR_HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME,
</span><span class="cx">     &quot;CALENDAR_RESOURCE_ID&quot; integer references CALENDAR,
</span><span class="lines">@@ -366,6 +411,7 @@
</span><span class="cx">     unique (&quot;CALENDAR_HOME_RESOURCE_ID&quot;, &quot;CALENDAR_RESOURCE_ID&quot;, &quot;CALENDAR_NAME&quot;, &quot;RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table ADDRESSBOOK_OBJECT_REVISIONS (
</span><span class="cx">     &quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot; integer not null references ADDRESSBOOK_HOME,
</span><span class="cx">     &quot;OWNER_HOME_RESOURCE_ID&quot; integer references ADDRESSBOOK_HOME,
</span><span class="lines">@@ -378,6 +424,7 @@
</span><span class="cx">     unique (&quot;ADDRESSBOOK_HOME_RESOURCE_ID&quot;, &quot;OWNER_HOME_RESOURCE_ID&quot;, &quot;ADDRESSBOOK_NAME&quot;, &quot;RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table NOTIFICATION_OBJECT_REVISIONS (
</span><span class="cx">     &quot;NOTIFICATION_HOME_RESOURCE_ID&quot; integer not null references NOTIFICATION_HOME on delete cascade,
</span><span class="cx">     &quot;RESOURCE_NAME&quot; nvarchar2(255),
</span><span class="lines">@@ -387,6 +434,7 @@
</span><span class="cx">     unique (&quot;NOTIFICATION_HOME_RESOURCE_ID&quot;, &quot;RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table APN_SUBSCRIPTIONS (
</span><span class="cx">     &quot;TOKEN&quot; nvarchar2(255),
</span><span class="cx">     &quot;RESOURCE_KEY&quot; nvarchar2(255),
</span><span class="lines">@@ -397,6 +445,7 @@
</span><span class="cx">     primary key (&quot;TOKEN&quot;, &quot;RESOURCE_KEY&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table IMIP_TOKENS (
</span><span class="cx">     &quot;TOKEN&quot; nvarchar2(255),
</span><span class="cx">     &quot;ORGANIZER&quot; nvarchar2(255),
</span><span class="lines">@@ -406,17 +455,20 @@
</span><span class="cx">     primary key (&quot;ORGANIZER&quot;, &quot;ATTENDEE&quot;, &quot;ICALUID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table TEST_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;DELAY&quot; integer
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table APN_PURGING_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table IMIP_INVITATION_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -425,11 +477,13 @@
</span><span class="cx">     &quot;ICALENDAR_TEXT&quot; nclob
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table IMIP_POLLING_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table IMIP_REPLY_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -438,6 +492,7 @@
</span><span class="cx">     &quot;ICALENDAR_TEXT&quot; nclob
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table PUSH_NOTIFICATION_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -445,17 +500,20 @@
</span><span class="cx">     &quot;PUSH_PRIORITY&quot; integer not null
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_CACHER_POLLING_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_REFRESH_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;GROUP_UID&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_DELEGATE_CHANGES_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -464,6 +522,7 @@
</span><span class="cx">     &quot;WRITE_DELEGATE_UID&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUPS (
</span><span class="cx">     &quot;GROUP_ID&quot; integer primary key,
</span><span class="cx">     &quot;NAME&quot; nvarchar2(255),
</span><span class="lines">@@ -474,12 +533,14 @@
</span><span class="cx">     &quot;MODIFIED&quot; timestamp default CURRENT_TIMESTAMP at time zone 'UTC'
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_MEMBERSHIP (
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references GROUPS on delete cascade,
</span><span class="cx">     &quot;MEMBER_UID&quot; nvarchar2(255), 
</span><span class="cx">     primary key (&quot;GROUP_ID&quot;, &quot;MEMBER_UID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_ATTENDEE_RECONCILE_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -487,6 +548,7 @@
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references GROUPS on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_ATTENDEE (
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references GROUPS on delete cascade,
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer not null references CALENDAR_OBJECT on delete cascade,
</span><span class="lines">@@ -494,6 +556,7 @@
</span><span class="cx">     primary key (&quot;GROUP_ID&quot;, &quot;RESOURCE_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_SHAREE_RECONCILE_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -501,6 +564,7 @@
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references GROUPS on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table GROUP_SHAREE (
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references GROUPS on delete cascade,
</span><span class="cx">     &quot;CALENDAR_ID&quot; integer not null references CALENDAR on delete cascade,
</span><span class="lines">@@ -509,6 +573,7 @@
</span><span class="cx">     primary key (&quot;GROUP_ID&quot;, &quot;CALENDAR_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table DELEGATES (
</span><span class="cx">     &quot;DELEGATOR&quot; nvarchar2(255),
</span><span class="cx">     &quot;DELEGATE&quot; nvarchar2(255),
</span><span class="lines">@@ -516,6 +581,7 @@
</span><span class="cx">     primary key (&quot;DELEGATOR&quot;, &quot;READ_WRITE&quot;, &quot;DELEGATE&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table DELEGATE_GROUPS (
</span><span class="cx">     &quot;DELEGATOR&quot; nvarchar2(255),
</span><span class="cx">     &quot;GROUP_ID&quot; integer not null references GROUPS on delete cascade,
</span><span class="lines">@@ -524,45 +590,53 @@
</span><span class="cx">     primary key (&quot;DELEGATOR&quot;, &quot;READ_WRITE&quot;, &quot;GROUP_ID&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table EXTERNAL_DELEGATE_GROUPS (
</span><span class="cx">     &quot;DELEGATOR&quot; nvarchar2(255) primary key,
</span><span class="cx">     &quot;GROUP_UID_READ&quot; nvarchar2(255),
</span><span class="cx">     &quot;GROUP_UID_WRITE&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_OBJECT_SPLITTER_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer not null references CALENDAR_OBJECT on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDAR_OBJECT_UPGRADE_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer not null references CALENDAR_OBJECT on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table FIND_MIN_VALID_REVISION_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table REVISION_CLEANUP_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table INBOX_CLEANUP_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CLEANUP_ONE_INBOX_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;HOME_ID&quot; integer not null unique references CALENDAR_HOME on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table INBOX_REMOVE_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -571,6 +645,7 @@
</span><span class="cx">     unique (&quot;HOME_ID&quot;, &quot;RESOURCE_NAME&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="lines">@@ -578,6 +653,7 @@
</span><span class="cx">     &quot;WORK_TYPE&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_REFRESH_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key references SCHEDULE_WORK on delete cascade,
</span><span class="cx">     &quot;HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME on delete cascade,
</span><span class="lines">@@ -585,12 +661,14 @@
</span><span class="cx">     &quot;ATTENDEE_COUNT&quot; integer
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_REFRESH_ATTENDEES (
</span><span class="cx">     &quot;RESOURCE_ID&quot; integer not null references CALENDAR_OBJECT on delete cascade,
</span><span class="cx">     &quot;ATTENDEE&quot; nvarchar2(255), 
</span><span class="cx">     primary key (&quot;RESOURCE_ID&quot;, &quot;ATTENDEE&quot;)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_AUTO_REPLY_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key references SCHEDULE_WORK on delete cascade,
</span><span class="cx">     &quot;HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME on delete cascade,
</span><span class="lines">@@ -598,6 +676,7 @@
</span><span class="cx">     &quot;PARTSTAT&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_ORGANIZER_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key references SCHEDULE_WORK on delete cascade,
</span><span class="cx">     &quot;SCHEDULE_ACTION&quot; integer not null,
</span><span class="lines">@@ -609,6 +688,7 @@
</span><span class="cx">     &quot;SMART_MERGE&quot; integer
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_ACTION (
</span><span class="cx">     &quot;ID&quot; integer primary key,
</span><span class="cx">     &quot;DESCRIPTION&quot; nvarchar2(16) unique
</span><span class="lines">@@ -618,6 +698,8 @@
</span><span class="cx"> insert into SCHEDULE_ACTION (DESCRIPTION, ID) values ('modify', 1);
</span><span class="cx"> insert into SCHEDULE_ACTION (DESCRIPTION, ID) values ('modify-cancelled', 2);
</span><span class="cx"> insert into SCHEDULE_ACTION (DESCRIPTION, ID) values ('remove', 3);
</span><ins>+
+
</ins><span class="cx"> create table SCHEDULE_ORGANIZER_SEND_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key references SCHEDULE_WORK on delete cascade,
</span><span class="cx">     &quot;SCHEDULE_ACTION&quot; integer not null,
</span><span class="lines">@@ -628,6 +710,7 @@
</span><span class="cx">     &quot;NO_REFRESH&quot; integer
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table SCHEDULE_REPLY_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key references SCHEDULE_WORK on delete cascade,
</span><span class="cx">     &quot;HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME on delete cascade,
</span><span class="lines">@@ -635,47 +718,55 @@
</span><span class="cx">     &quot;ITIP_MSG&quot; nclob
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table PRINCIPAL_PURGE_POLLING_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table PRINCIPAL_PURGE_CHECK_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;UID&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table PRINCIPAL_PURGE_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;UID&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table PRINCIPAL_PURGE_HOME_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table MIGRATION_CLEANUP_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;HOME_RESOURCE_ID&quot; integer not null references CALENDAR_HOME on delete cascade
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table HOME_CLEANUP_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;OWNER_UID&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table MIGRATED_HOME_CLEANUP_WORK (
</span><span class="cx">     &quot;WORK_ID&quot; integer primary key,
</span><span class="cx">     &quot;JOB_ID&quot; integer not null references JOB,
</span><span class="cx">     &quot;OWNER_UID&quot; nvarchar2(255)
</span><span class="cx"> );
</span><span class="cx"> 
</span><ins>+
</ins><span class="cx"> create table CALENDARSERVER (
</span><span class="cx">     &quot;NAME&quot; nvarchar2(255) primary key,
</span><span class="cx">     &quot;VALUE&quot; nvarchar2(255)
</span><span class="lines">@@ -686,6 +777,8 @@
</span><span class="cx"> insert into CALENDARSERVER (NAME, VALUE) values ('ADDRESSBOOK-DATAVERSION', '2');
</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><ins>+
+
</ins><span class="cx"> create index JOB_PRIORITY_IS_ASSIG_48985bfd on JOB (
</span><span class="cx">     &quot;PRIORITY&quot;,
</span><span class="cx">     &quot;IS_ASSIGNED&quot;,
</span></span></pre>
</div>
</div>

</body>
</html>