· 8 years ago · Mar 11, 2018, 12:22 PM
1DROP TABLE IF EXISTS study_messages CASCADE;
2CREATE TABLE study_messages (
3 id SERIAL,
4 title VARCHAR NOT NULL,
5 message TEXT NOT NULL,
6
7 PRIMARY KEY (id)
8);
9
10DROP TABLE IF EXISTS studies CASCADE;
11CREATE TABLE studies (
12 id SERIAL,
13 title VARCHAR,
14 in_use BOOLEAN NOT NULL,
15 creation_timestamp TIMESTAMP NOT NULL,
16-- latest_edit_timestamp TIMESTAMP NOT NULL,
17
18 message_welcome_id INT REFERENCES study_messages (id) NOT NULL,
19 message_instruction_id INT REFERENCES study_messages (id) NOT NULL,
20 message_task_completion_id INT REFERENCES study_messages (id) NOT NULL,
21 message_thank_you_id INT REFERENCES study_messages (id) NOT NULL,
22
23 PRIMARY KEY (id)
24);
25
26DROP TABLE IF EXISTS study_tasks CASCADE;
27CREATE TABLE study_tasks (
28 id SERIAL,
29 title VARCHAR NOT NULL,
30 message TEXT NOT NULL,
31 in_use BOOLEAN NOT NULL,
32 study_id INT REFERENCES studies (id) NOT NULL,
33 PRIMARY KEY (id)
34);
35
36DROP TABLE IF EXISTS study_task_statuses CASCADE;
37CREATE TABLE study_task_statuses (
38 id INTEGER,
39 title VARCHAR,
40 PRIMARY KEY (id)
41);
42
43INSERT INTO study_task_statuses (id, title) VALUES (0, 'Undefined');
44INSERT INTO study_task_statuses (id, title) VALUES (1, 'Completed');
45INSERT INTO study_task_statuses (id, title) VALUES (2, 'Skipped');
46INSERT INTO study_task_statuses (id, title) VALUES (3, 'Cancelled');
47
48INSERT INTO study_messages (id, title, message) VALUES (5, 'gdfgdfh', 'ghgfdh');
49INSERT INTO study_messages (id, title, message) VALUES (6, 'f', 'gftntfyn');
50INSERT INTO study_messages (id, title, message) VALUES (7, 'tn', 'ntfynt');
51INSERT INTO study_messages (id, title, message) VALUES (8, 'nfghn', 'ngf');
52INSERT INTO study_messages (id, title, message) VALUES (9, 'fas', 'g');
53INSERT INTO study_messages (id, title, message) VALUES (10, 'fr', '');
54INSERT INTO study_messages (id, title, message) VALUES (11, '', '');
55INSERT INTO study_messages (id, title, message) VALUES (12, '', '');
56INSERT INTO study_messages (id, title, message) VALUES (16, '', '');
57INSERT INTO study_messages (id, title, message) VALUES (17, '', '');
58INSERT INTO study_messages (id, title, message) VALUES (18, '', '');
59INSERT INTO study_messages (id, title, message) VALUES (19, '', '');
60INSERT INTO study_messages (id, title, message) VALUES (1, '', '');
61INSERT INTO study_messages (id, title, message) VALUES (2, '', '');
62INSERT INTO study_messages (id, title, message) VALUES (3, '', '');
63INSERT INTO study_messages (id, title, message) VALUES (4, '', '');
64
65INSERT INTO studies (id, title, in_use, creation_timestamp, message_welcome_id, message_instruction_id, message_task_completion_id, message_thank_you_id) VALUES (2, 'fdbdfrehb', true, '2018-03-08 22:29:11', 5, 6, 7, 8);
66INSERT INTO studies (id, title, in_use, creation_timestamp, message_welcome_id, message_instruction_id, message_task_completion_id, message_thank_you_id) VALUES (3, 'preco to nejde', true, '2018-03-08 23:14:38', 9, 10, 11, 12);
67INSERT INTO studies (id, title, in_use, creation_timestamp, message_welcome_id, message_instruction_id, message_task_completion_id, message_thank_you_id) VALUES (4, 'test', true, '2018-03-09 23:26:18', 16, 17, 18, 19);
68INSERT INTO studies (id, title, in_use, creation_timestamp, message_welcome_id, message_instruction_id, message_task_completion_id, message_thank_you_id) VALUES (1, 'supis studia', true, '2018-03-08 22:28:46', 1, 2, 3, 4);
69
70INSERT INTO study_tasks (id, title, message, in_use, study_id) VALUES (2, 'fdg', 'fdg', true, 2);
71INSERT INTO study_tasks (id, title, message, in_use, study_id) VALUES (3, 'hdfh', 'hdfhfd', true, 2);
72INSERT INTO study_tasks (id, title, message, in_use, study_id) VALUES (4, 'ghsfgf', 'dafcs', true, 2);
73INSERT INTO study_tasks (id, title, message, in_use, study_id) VALUES (5, 'este lepsi title', 'lepsi mesidz', false, 1);
74INSERT INTO study_tasks (id, title, message, in_use, study_id) VALUES (1, 'dobry title', 'fedsfsaf', true, 1);
75INSERT INTO study_tasks (id, title, message, in_use, study_id) VALUES (6, 'deadsfa', 'dsagadsa', true, 1);