[3733] | 1 | -- Some sample data to prime the database... |
---|
| 2 | |
---|
| 3 | -- FIXME: Only insert the rows if they are not there already. |
---|
| 4 | INSERT INTO roles ( role_no, role_name ) VALUES( 1, 'Admin'); |
---|
| 5 | INSERT INTO roles ( role_no, role_name ) VALUES( 2, 'Group'); |
---|
| 6 | INSERT INTO roles ( role_no, role_name ) VALUES( 3, 'Public'); |
---|
| 7 | INSERT INTO roles ( role_no, role_name ) VALUES( 4, 'Resource'); |
---|
| 8 | |
---|
| 9 | -- Set the insert sequence to the next number, with a minimum of 10 |
---|
| 10 | SELECT setval('roles_role_no_seq', (SELECT 10 UNION SELECT role_no FROM roles ORDER BY 1 DESC LIMIT 1) ); |
---|
| 11 | |
---|
| 12 | INSERT INTO usr ( user_no, active, email_ok, updated, username, password, fullname, email ) |
---|
| 13 | VALUES ( 1, TRUE, current_date, current_date, 'admin', '**nimda', 'DAViCal Administrator', 'calendars@example.net' ); |
---|
| 14 | |
---|
| 15 | INSERT INTO role_member (user_no, role_no) VALUES(1, 1); |
---|
| 16 | |
---|
| 17 | -- Set the insert sequence to the next number, with a minimum of 1000 |
---|
| 18 | SELECT setval('usr_user_no_seq', (SELECT 1000 UNION SELECT user_no FROM usr ORDER BY 1 DESC LIMIT 1) ); |
---|
| 19 | |
---|
| 20 | INSERT INTO relationship_type ( rt_id, rt_name, confers, bit_confers ) |
---|
| 21 | VALUES( 1, 'Administers', 'A', privilege_to_bits('DAV::all') ); |
---|
| 22 | |
---|
| 23 | INSERT INTO relationship_type ( rt_id, rt_name, confers, bit_confers ) |
---|
| 24 | VALUES( 2, 'Can read/write to', 'RW', privilege_to_bits( ARRAY['DAV::read','DAV::write']) ); |
---|
| 25 | |
---|
| 26 | INSERT INTO relationship_type ( rt_id, rt_name, confers, bit_confers ) |
---|
| 27 | VALUES( 3, 'Can read from', 'R', privilege_to_bits( 'DAV::read') ); |
---|
| 28 | |
---|
| 29 | INSERT INTO relationship_type ( rt_id, rt_name, confers, bit_confers ) |
---|
| 30 | VALUES( 4, 'Can see free/busy time of', 'F', privilege_to_bits( 'caldav:read-free-busy') ); |
---|
| 31 | |
---|
| 32 | INSERT INTO principal_type (principal_type_id, principal_type_desc) VALUES( 1, 'Person' ); |
---|
| 33 | INSERT INTO principal_type (principal_type_id, principal_type_desc) VALUES( 2, 'Resource' ); |
---|
| 34 | INSERT INTO principal_type (principal_type_id, principal_type_desc) VALUES( 3, 'Group' ); |
---|
| 35 | |
---|
| 36 | INSERT INTO principal ( type_id, user_no, displayname, default_privileges ) |
---|
| 37 | VALUES ( 1, 1, 'DAViCal Administrator', 0::BIT(24) ); |
---|
| 38 | |
---|
| 39 | -- Set the insert sequence to the next number, with a minimum of 1000 |
---|
| 40 | SELECT setval('relationship_type_rt_id_seq', (SELECT 10 UNION SELECT rt_id FROM relationship_type ORDER BY 1 DESC LIMIT 1) ); |
---|
| 41 | |
---|