text: ----
  -- Copyright (c) 2012-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 from VERSION 30 to 31 --
  ---------------------------------------------------
  
  ----------------------------------------
  -- Change Address Book Object Members --
  ----------------------------------------
  
  alter table ABO_MEMBERS
  	 drop primary key;
  begin
      for i in (select constraint_name
                from   user_cons_columns
                where  table_name = 'ABO_MEMBERS'
                       and ( column_name = 'MEMBER_ID'
                              or column_name = 'GROUP_ID' )) loop
          execute immediate 'alter table ABO_MEMBERS drop constraint '|| i.constraint_name;
      end loop;
  end;
  
  alter table ABO_MEMBERS
  	add ("REVISION" integer not null);
  alter table ABO_MEMBERS
  	add ("REMOVED" integer default 0 not null);
  alter table ABO_MEMBERS
  	 add primary key ("GROUP_ID", "MEMBER_ID", "REVISION");
  
  ------------------------------------------
  -- Change Address Book Object Revisions --
  ------------------------------------------
  	
  alter table ADDRESSBOOK_OBJECT_REVISIONS
  	add ("OBJECT_RESOURCE_ID" integer default 0);
  
  --------------------
  -- Update version --
  --------------------
  
  update CALENDARSERVER set VALUE = '31' where NAME = 'VERSION';
  