[CalendarServer-changes] [13733] CalendarServer/branches/users/gaya/groupsharee2/txdav/common/ datastore/sql_schema/current-oracle-dialect.sql
source_changes at macosforge.org
source_changes at macosforge.org
Tue Jul 8 02:09:07 PDT 2014
Revision: 13733
http://trac.calendarserver.org//changeset/13733
Author: gaya at apple.com
Date: 2014-07-08 02:09:07 -0700 (Tue, 08 Jul 2014)
Log Message:
-----------
run txdav/common/datastore/sql_tables.py
Modified Paths:
--------------
CalendarServer/branches/users/gaya/groupsharee2/txdav/common/datastore/sql_schema/current-oracle-dialect.sql
Modified: CalendarServer/branches/users/gaya/groupsharee2/txdav/common/datastore/sql_schema/current-oracle-dialect.sql
===================================================================
--- CalendarServer/branches/users/gaya/groupsharee2/txdav/common/datastore/sql_schema/current-oracle-dialect.sql 2014-07-08 07:05:29 UTC (rev 13732)
+++ CalendarServer/branches/users/gaya/groupsharee2/txdav/common/datastore/sql_schema/current-oracle-dialect.sql 2014-07-08 09:09:07 UTC (rev 13733)
@@ -116,6 +116,7 @@
insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('write', 2);
insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('direct', 3);
insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('indirect', 4);
+insert into CALENDAR_BIND_MODE (DESCRIPTION, ID) values ('group', 5);
create table CALENDAR_BIND_STATUS (
"ID" integer primary key,
"DESCRIPTION" nvarchar2(16) unique
@@ -402,13 +403,6 @@
"GROUP_UID" nvarchar2(255)
);
-create table GROUP_ATTENDEE_RECONCILE_WORK (
- "WORK_ID" integer primary key not null,
- "JOB_ID" integer not null references JOB,
- "RESOURCE_ID" integer,
- "GROUP_ID" integer
-);
-
create table GROUPS (
"GROUP_ID" integer primary key,
"NAME" nvarchar2(255),
@@ -425,6 +419,13 @@
primary key ("GROUP_ID", "MEMBER_UID")
);
+create table GROUP_ATTENDEE_RECONCILE_WORK (
+ "WORK_ID" integer primary key not null,
+ "JOB_ID" integer not null references JOB,
+ "RESOURCE_ID" integer,
+ "GROUP_ID" integer
+);
+
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,
@@ -432,6 +433,22 @@
primary key ("GROUP_ID", "RESOURCE_ID")
);
+create table GROUP_SHAREE_RECONCILE_WORK (
+ "WORK_ID" integer primary key not null,
+ "JOB_ID" integer not null references JOB,
+ "CALENDAR_ID" integer not null references CALENDAR on delete cascade,
+ "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_HOME_ID" integer not null references CALENDAR_HOME on delete cascade,
+ "CALENDAR_ID" integer not null references CALENDAR on delete cascade,
+ "GROUP_BIND_MODE" integer not null,
+ "MEMBERSHIP_HASH" nvarchar2(255),
+ primary key ("GROUP_ID", "CALENDAR_HOME_ID", "CALENDAR_ID")
+);
+
create table DELEGATES (
"DELEGATOR" nvarchar2(255),
"DELEGATE" nvarchar2(255),
@@ -736,10 +753,6 @@
JOB_ID
);
-create index GROUP_ATTENDEE_RECONC_da73d3c2 on GROUP_ATTENDEE_RECONCILE_WORK (
- JOB_ID
-);
-
create index GROUPS_GROUP_UID_b35cce23 on GROUPS (
GROUP_UID
);
@@ -748,10 +761,22 @@
MEMBER_UID
);
-create index GROUP_ATTENDEE_RESOUR_855124dc on GROUP_ATTENDEE (
+create index GROUP_ATTENDEE_RECONC_da73d3c2 on GROUP_ATTENDEE_RECONCILE_WORK (
+ JOB_ID
+);
+
+create index GROUP_ATTENDEE_ID_d497ffdb on GROUP_ATTENDEE (
RESOURCE_ID
);
+create index GROUP_SHAREE_RECONCIL_9aad0858 on GROUP_SHAREE_RECONCILE_WORK (
+ JOB_ID
+);
+
+create index GROUP_SHAREE_CALENDAR_28a88850 on GROUP_SHAREE (
+ CALENDAR_ID
+);
+
create index DELEGATE_TO_DELEGATOR_5e149b11 on DELEGATES (
DELEGATE,
READ_WRITE,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140708/de51491e/attachment.html>
More information about the calendarserver-changes
mailing list