[CalendarServer-changes] [8797] CalendarServer/branches/users/glyph/case-insensitive-uid

[source_changes at macosforge.org]

Revision: 8797
          http://trac.macosforge.org/projects/calendarserver/changeset/8797
Author:   glyph at apple.com
Date:     2012-02-29 10:16:21 -0800 (Wed, 29 Feb 2012)
Log Message:
-----------
add a constraint to enforce lower-case-ness of calendar and addressbook homes

Modified Paths:
--------------
    CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/current.sql

Property Changed:
----------------
    CalendarServer/branches/users/glyph/case-insensitive-uid/

Modified: CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/current.sql
===================================================================
--- CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/current.sql	2012-02-29 18:16:18 UTC (rev 8796)
+++ CalendarServer/branches/users/glyph/case-insensitive-uid/txdav/common/datastore/sql_schema/current.sql	2012-02-29 18:16:21 UTC (rev 8797)
@@ -30,7 +30,8 @@
 create table CALENDAR_HOME (
   RESOURCE_ID      integer      primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
   OWNER_UID        varchar(255) not null unique,                                 -- implicit index
-  DATAVERSION	   integer      default 0 not null
+  DATAVERSION	   integer      default 0 not null,
+  constraint CALENDAR_HOME_CASE check(OWNER_UID = lower(OWNER_UID))
 );
 
 ----------------------------
@@ -326,7 +327,8 @@
 create table ADDRESSBOOK_HOME (
   RESOURCE_ID      integer      primary key default nextval('RESOURCE_ID_SEQ'), -- implicit index
   OWNER_UID        varchar(255) not null unique,                                -- implicit index
-  DATAVERSION	   integer      default 0 not null
+  DATAVERSION	   integer      default 0 not null,
+  constraint ADDRESSBOOK_HOME_CASE check(OWNER_UID = lower(OWNER_UID))
 );
 
 -------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20120229/2b94a8bd/attachment-0001.html>