Changeset 5838 for DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/test/resources/test-data/InsertTestData.sql
- Timestamp:
- 11/19/14 17:21:25 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/test/resources/test-data/InsertTestData.sql
r5393 r5838 25 25 INSERT INTO access(access_mode) VALUES ('read'); 26 26 INSERT INTO access(access_mode) VALUES ('none'); 27 INSERT INTO access(access_mode) VALUES ('all'); 27 28 28 29 INSERT INTO principal (principal_name, external_id, remote_id, e_mail, account) VALUES ('Twan', '00000000-0000-0000-0000-000000000111', 'twagoo@mpi.nl', 'Twan.Goosen@mpi.nl', 'developer'); --1 … … 46 47 INSERT INTO annotation (owner_id, headline,body_text, body_mimetype, external_id, last_modified, is_xml, public_) VALUES (1, 'Sagrada Famiglia','<html><body>some html 1</body></html>', 'text/html' , '00000000-0000-0000-0000-000000000021', '2013-08-12 09:25:00.383', false, 'write'); --1 47 48 INSERT INTO annotation (owner_id, headline,body_text, body_mimetype, external_id, last_modified, is_xml, public_) VALUES (2, 'Gaudi','<html><body>some html 2</body></html>', 'text/html' , '00000000-0000-0000-0000-000000000022', '2013-08-12 10:30:00.383', false, 'read'); --2 48 INSERT INTO annotation (owner_id, headline,body_text, body_mimetype, external_id, last_modified, is_xml ) VALUES (3, 'Art Nuveau','some plain text', 'text/plain' , '00000000-0000-0000-0000-000000000023', '2013-08-12 11:30:00.383', false); --349 INSERT INTO annotation (owner_id, headline,body_text, body_mimetype, external_id, last_modified, is_xml, public_) VALUES (3, 'Art Nuveau','some plain text', 'text/plain' , '00000000-0000-0000-0000-000000000023', '2013-08-12 11:30:00.383', false, 'all'); --3 49 50 INSERT INTO annotation (owner_id, headline,body_text, body_mimetype, external_id, is_xml) VALUES (3, 'Annotation to delete','<html><body>some html 4</body></html>', 'text/html' , '00000000-0000-0000-0000-000000000024',false); --4 50 51 … … 119 120 120 121 INSERT INTO annotations_principals_accesses (annotation_id, principal_id, access_) VALUES (4, 2, 'write'); 121 INSERT INTO annotations_principals_accesses (annotation_id, principal_id, access_) VALUES (4, 1, 'write'); 122 INSERT INTO annotations_principals_accesses (annotation_id, principal_id, access_) VALUES (4, 1, 'all'); 123 INSERT INTO annotations_principals_accesses (annotation_id, principal_id, access_) VALUES (4, 3, 'none'); 124 INSERT INTO annotations_principals_accesses (annotation_id, principal_id, access_) VALUES (4, 11, 'none'); 122 125 -- checking integrity control: 123 126 -- INSERT INTO annotations_principals_accesses (annotation_id, principal_id, access_) VALUES (5, 5, 'read');
Note: See TracChangeset
for help on using the changeset viewer.