ProPeler
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
opt
/
cpanel-ccs
/
txdav
/
common
/
datastore
/
sql_schema
/
manual_upgrades
/
Filename :
oracle_ssical_final.sql
back
Copy
---- -- Copyright (c) 2015-2017 Apple Inc. All rights reserved. -- -- Licensed under the Apache License, Version 2.0 (the "License"); -- you may not use this file except in compliance with the License. -- You may obtain a copy of the License at -- -- http://www.apache.org/licenses/LICENSE-2.0 -- -- Unless required by applicable law or agreed to in writing, software -- distributed under the License is distributed on an "AS IS" BASIS, -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. ---- ------------------------------------------- -- Upgrade database schema at VERSION 60 -- ------------------------------------------- -- These are items we removed from the upgrade files for calendar.apple.com, but are still -- needed for ssical.apple.com -- Upgrade 47 to 48 alter table CALENDAR_OBJECT_REVISIONS add unique (CALENDAR_HOME_RESOURCE_ID, CALENDAR_RESOURCE_ID, CALENDAR_NAME, RESOURCE_NAME); drop index CALENDAR_OBJECT_REVIS_3a3956c4; alter table ADDRESSBOOK_OBJECT_REVISIONS add unique (ADDRESSBOOK_HOME_RESOURCE_ID, OWNER_HOME_RESOURCE_ID, ADDRESSBOOK_NAME, RESOURCE_NAME); -- Remove a constraint alter table APN_SUBSCRIPTIONS modify ("SUBSCRIBER_GUID" null);