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