Changeset 3213

Timestamp:

07/31/13 09:42:56 (11 years ago)

Author:

olhsha

Message:

permissions added to the DB creation script

File:

• DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/sql/DashishAnnotatorCreate.sql (modified) (2 diffs)

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/sql/DashishAnnotatorCreate.sql

@@ -65 +65 @@
 
 
+
 ------------------------------------------------------------------------
 -- <xs:complexType name="Annotation">
@@ -191 +192 @@
 );
 
+-------------------------------------------------------------------------------
+--------------------------------------------------------------------------------------------
+--  <xs:simpleType name="Permission">
+--         <xs:restriction base="xs:string">
+--             <xs:enumeration value="owner"/>
+--             <xs:enumeration value="reader"/>
+--             <xs:enumeration value="writer"/>
+--         </xs:restriction>
+--     </xs:simpleType>
+
+
+--     <xs:complexType name="UserWithPermission">
+--         <xs:complexContent>
+--             <xs:extension base="ResourceREF">
+--                 <xs:attribute name="permission" type="Permission" use="required"/>
+--             </xs:extension>
+--         </xs:complexContent>
+--     </xs:complexType>
+
+
+--     <xs:complexType name="PermissionList">
+--         <xs:sequence>
+--             <xs:element name="user" type="UserWithPermission" minOccurs="1" maxOccurs="unbounded"/>
+--         </xs:sequence>
+--         <xs:attribute name="URI" type="xs:anyURI" use="required"/>
+--     </xs:complexType>
+
+CREATE TABLE annotations_users_permissions (
+annotation_id integer REFERENCES annotation(annotation_id),
+principal_id integer REFERENCES principal(principal_id),
+permission_  text,
+unique(annotation_id, principal_id),
+CHECK(permission_ = 'reader' OR permission_='writer' OR permission_='owner')
+)
 
 ---------------------------------------------------------------------------------------------