-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschema.sql
More file actions
30 lines (27 loc) · 2.09 KB
/
Copy pathschema.sql
File metadata and controls
30 lines (27 loc) · 2.09 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
drop table survey;
create table survey(
survey_id SERIAL PRIMARY KEY,
time_stamp TIMESTAMP NOT NULL DEFAULT(NOW()),
student_major varchar(64),
student_year varchar(64),
student_reason varchar(124),
student_suggestion varchar(1024)
);
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '4 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '4 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '4 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '4 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '4 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '3 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '2 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '2 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '2 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');
INSERT INTO survey (student_major, time_stamp) values ('Computer Science', NOW() - interval '1 day');