-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathc3_demo_data.sql
More file actions
70 lines (60 loc) · 6.32 KB
/
c3_demo_data.sql
File metadata and controls
70 lines (60 loc) · 6.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
\connect c3;
SET search_path TO api,gis,public;
INSERT INTO owner_parents VALUES (DEFAULT, 'user'),
(DEFAULT, 'user'),
(DEFAULT, 'org');
INSERT INTO users (id, username, password, first_name, last_name, email, is_admin, is_active) VALUES
(1, 'admin','*4ACFE3202A5FF5CF467898FC58AAB1D615029441', 'C3 DEMO', 'Administrator', 'nock@nocko.se', TRUE, TRUE),
(2, 'slee', '*4ACFE3202A5FF5CF467898FC58AAB1D615029441', 'Soo-Yeong', 'Lee', 'slee@fakenet.com', FALSE, TRUE);
INSERT INTO orgs (id, name, uuid) VALUES (3, 'Shulman and Associates', '1b47b8c9d30d4af8a8c3e3876f69eac5');
INSERT INTO users_orgs (id, user_id, org_id, permissions) VALUES (DEFAULT, 2, 3, 'MANAGE');
INSERT INTO beacon_groups VALUES (DEFAULT,'Doctors','Physicians and Surgeons', NULL, 3),
(DEFAULT,'Patients','', NULL, 3),
(DEFAULT,'Admin Staff','All non-physician staff', NULL, 3),
(DEFAULT,'Equipment','', NULL, 3);
INSERT INTO event_parents values (DEFAULT, 'beacon'),
(DEFAULT, 'beacon'),
(DEFAULT, 'beacon'),
(DEFAULT, 'beacon'),
(DEFAULT, 'beacon'),
(DEFAULT, 'beacon'),
(DEFAULT, 'zone'),
(DEFAULT, 'zone'),
(DEFAULT, 'zone'),
(DEFAULT, 'zone'),
(DEFAULT, 'zone'),
(DEFAULT, 'zone'),
(DEFAULT, 'zone'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener'),
(DEFAULT, 'listener');
INSERT INTO beacons (id, state, name, geom, group_id, major, minor, description, battery, zone_id, uuid, owner_id) VALUES
(1,'','Scott White',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),3,0,0,'Receptionist',NULL,NULL,'6a4f50cb-091a-4c88-abad-5f83a362471f',3),
(2,'','Imari Jackson',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),1,0,1,'Surgeon',NULL,NULL, '6a4f50cb-091a-4c88-abad-5f83a362471f',3),
(3,'','Lee Soo-Yeon',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),1,0,2,'Anesthesiologist',NULL,NULL,'6a4f50cb-091a-4c88-abad-5f83a362471f',3),
(4,'','Patient #7483',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),2,0,3,'Deidentified Patient',NULL,NULL,'6a4f50cb-091a-4c88-abad-5f83a362471f',3),
(5,'','Patient #2340',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),2,0,4,'Deidentified Patient',NULL,NULL,'6a4f50cb-091a-4c88-abad-5f83a362471f',3),
(6,'','Gurney #1',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),4,0,5,'Transport gurney',NULL,NULL,'6a4f50cb-091a-4c88-abad-5f83a362471f',3);
INSERT INTO zones (id, name, geom, color, owner_id) VALUES
(7,'Dr. Jackson''s Office',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973251.68169310875237 3259654.920269325375557,-8973248.74199733696878 3259654.927857941016555,-8973248.782730346545577 3259651.918079070281237,-8973251.711043195798993 3259651.884934675879776,-8973251.68169310875237 3259654.920269325375557))'),'#ef0a0a',3),
(8,'Dr. Lee''s Office',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973251.792118625715375 3259649.591387203894556,-8973248.689267616719007 3259649.591387203894556,-8973248.702090287581086 3259645.984981685876846,-8973251.780060609802604 3259645.997039701789618,-8973251.792118625715375 3259649.591387203894556))'),'#efe613',3),
(9,'Surgery',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973251.789736431092024 3259645.777348533272743,-8973248.690826335921884 3259645.765290517359972,-8973248.678768320009112 3259641.930841448716819,-8973251.789736431092024 3259641.894667400978506,-8973251.789736431092024 3259645.777348533272743))'),'#fcc710',3),
(10,'Recovery Room',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973228.312779400497675 3259648.357763944659382,-8973234.40207744948566 3259648.381879976484925,-8973234.341787369921803 3259654.85703453514725,-8973231.351399417966604 3259654.85703453514725,-8973228.312779400497675 3259648.357763944659382))'),'#17e0ee',3),
(11,'Washrooms',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973225.346507478505373 3259642.389046055264771,-8973234.35384538397193 3259642.340813991613686,-8973234.414135463535786 3259648.15277767367661,-8973228.168083207681775 3259648.116603625938296,-8973225.346507478505373 3259642.389046055264771))'),'#5d1111',3),
(12,'Lobby',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973248.554798530414701 3259654.838186255190521,-8973234.568160727620125 3259654.838186255190521,-8973234.585731880739331 3259645.982325133867562,-8973248.466942764818668 3259645.964753980748355,-8973248.554798530414701 3259654.838186255190521))'),'#2138d5',3),
(13,'Equipment Storage',ST_GeomFromEWKT('SRID=900913;POLYGON((-8973234.568160727620125 3259636.739898646716028,-8973248.484513917937875 3259636.722327493596822,-8973248.484513917937875 3259645.789042451418936,-8973234.603303033858538 3259645.77147129829973,-8973234.568160727620125 3259636.739898646716028))'),'#32f01b',3);
INSERT INTO listeners (id, state, name, mac, description, geom, zone_id, owner_id) VALUES
(14,'','Lobby','40cc397a-29a2-4c2c-9dbd-83da0f7b93d6','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),12,3),
(15,'','Dr. Jackson''s Office','d53ed36f-6c7d-4ab1-a909-3b7ecbf05893','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),7,3),
(16,'','Dr. Lee''s Office','99aefcbd-d0a0-499e-9e9d-760b32c2c01a','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),8,3),
(17,'','Recovery Room #1','d9d96070-fa45-4700-9368-6c89bcb74705','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),10,3),
(18,'','Recovery Room #2','2e8eb88b-bde7-4eb2-bca9-8b547b5a0528','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),10,3),
(19,'','Surgery','acadc6c5-cdc8-4213-b8cf-81fbe9a16a5e','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),9,3),
(20,'','Storage Room','107c8b7a-6d05-4747-b29f-ee95eaf0c634','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),13,3),
(21,'','Washroom','a7975000-4ab8-4528-93c9-e2da4ec1cb27','',ST_GeomFromEWKT('SRID=900913;POINT(-8973281.8 3259609.4)'),11,3);
INSERT INTO roi (name, geom, owner_id) VALUES ('Shulman', ST_GeomFromEWKT('SRID=900913;POLYGON((-8973250.93055791 3259669.10420089,-8973236.66150438 3259669.10420089,-8973216.72530901 3259623.96946418,-8973216.42171213 3259621.43949015,-8973249.21017557 3259621.23709223,-8973252.44854233 3259628.6246164,-8973250.93055791 3259669.10420089))'), 3);