-
Notifications
You must be signed in to change notification settings - Fork 0
/
populate.sql
84 lines (67 loc) · 4.65 KB
/
populate.sql
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
INSERT INTO account (account_tag, password, name, age, birthday, is_private, email, university, course, is_verified, description, location, pronouns, is_admin, is_blocked)
VALUES
('AvilaAndre', 'pg!password', 'André Ávila', 20, '2002-07-01', false, 'up202006767@edu.fe.up.pt', 'Faculdade de Engenharia da Universidade do Porto', 'Engenharia Informática e Computação', true, 'Olá, bem-vindo à minha página!', 'Porto', 'He/Him', true, false),
('rspencock0', '3MYlqie', 'Rickert Spencock', 16, '1983-06-03', false, 'rspencock0@java.com', 'Tarim University', 'Dakota', false, 'Peritoneal suture', 'Santa Catalina', 'Diablo', false, false),
('fo1', 'IKYukrzIy', 'Felike O'' Liddy', 20, '1977-03-25', true, 'fo1@wikia.com', 'Wenzhou University', 'PT Cruiser', false, 'Anterior chamber op NEC', 'Qianhong', 'Avalon', false, false),
('gwhilder2', 'RHgQE5FU', 'Ginny Whilder', 23, '1972-09-13', true, 'gwhilder2@technorati.com', 'Hirosaki University', 'Yukon XL 1500', true, 'Lacrimal punctum probe', 'Cipatujah', 'Rondo', true, false),
('nratt3', 'OWZlLLjIz', 'Nedda Ratt', 24, '1983-07-05', true, 'nratt3@weebly.com', 'Hogeschool Rotterdam', 'Pathfinder', false, 'Opn rep umb hrn-grft NEC', 'Asprángeloi', 'Fox', false, false),
('aroache4', 'HKBpHqT5', 'Alano Roache', 25, '1998-09-27', true, 'aroache4@redcross.org', 'Pacific College of Oriental Medicine', 'Z8', true, 'Lap bi dr/ind ing hrn-gr', 'Muaralembu', 'Sequoia', false, true),
('svidineev5', 'JodahnBzO9', 'Stephannie Vidineev', 26, '1973-10-12', false, 'svidineev5@pbs.org', 'Korea University', 'Grand Prix', true, 'Colostomy NOS', 'Saransk', 'Lumina', false, false),
('babbatini6', 'GJs0uHzo', 'Bartholomeo Abbatini', 17, '1996-03-02', false, 'babbatini6@yelp.com', 'Colgate University', 'Stratus', true, 'Injct/infus glucarpidase', 'Humaitá', 'Minx Magnificent', false, false),
('alongdon7', 'MCglkP3hH', 'Aluino Longdon', 18, '1980-04-29', true, 'alongdon7@usgs.gov', 'Indiana Institute of Technologyy', 'Milan', false, 'Thorac var v lig-strip', 'Luxi', '300SE', false, false),
('vingleson8', '9bdWxT', 'Vivi Ingleson', 19, '1993-01-21', true, 'vingleson8@ow.ly', 'NTI University', 'Intrepid', true, 'Vasc proc revision NEC', 'Xiaoshi', 'TL', false, true),
('efarnaby9', 'zFMGF4WFl6Wq', 'Everett Farnaby', 19, '1986-04-11', false, 'efarnaby9@51.la', 'Kosin University', 'Expo LRV', false, 'Perianal biopsy', 'Besançon', 'S60', false, true);
INSERT INTO community (name, description, is_public)
VALUES
('LBAW22/23', 'Grupo dedicado a Laboratório de Bases de Dados e Aplicações Web.', true),
('Grupo3RCOM', 'Grupo 3 para o projeto de RCOM.', true);
INSERT INTO post (id_post, parent_post, owner_id, group_id, description, has_images, publication_date, edited_date, comments_count, is_visible)
VALUES
(1, null, 5, null, 'Occ of rail trn/veh injured by fall in rail trn/veh, init', false, '2021-06-26', '2022-08-29', 0, true),
(2, null, 1, null, 'Nondisp Maisonneuve''s fx r leg, subs for clos fx w nonunion', true, '2021-12-13', '2022-09-24', 0, false),
(3, 1, 1, 1, 'Corrosion of third degree of back of left hand, sequela', false, '2021-07-01', '2022-01-25', 0, true),
(4, null, 6, null, 'Lobar pneumonia, unspecified organism', false, '2022-06-01', '2022-09-22', 0, false);
INSERT INTO account_report (reason, description, id_account_reporting, id_account_reported)
VALUES
(3, 'They wouldn''t stop spamming my posts', 1, 6);
INSERT INTO friend_request (id_sender, id_receiver)
VALUES
(1, 4),
(1, 5),
(6, 5),
(4, 7);
INSERT INTO notification (id_receiver, url, description, is_read)
VALUES
(1, 'https:/youtube.com', 'Diogo sent you a friend request.', false),
(6, 'https:/youtube.com', 'Manuel promoted your post.', false),
(5, 'https:/youtube.com', 'Francisco accepted your friend request', false);
INSERT INTO recovery_code (id_account, code, valid_until)
VALUES
(8, 'hfKJsdjHJASas', '2022-11-29 21:50:50');
INSERT INTO post_report (id_post, reason, description)
VALUES
(4, 2, 'The coment was just inappropriate.');
INSERT INTO relationship (id_community, id_account, status)
VALUES
(1, 5, 'member'),
(1, 6, 'admin'),
(2, 7, 'admin'),
(2, 8, 'pending');
INSERT INTO post_promotion (id_account, id_post, promotion_date)
VALUES
(1, 4, '2022-10-18 21:54:34');
INSERT INTO post_promotion (id_account, id_post)
VALUES
(5, 4);
INSERT INTO post_reaction (id_account, id_post, react_date, up_vote)
VALUES
(1, 4, '2022-10-18 20:54:34', true),
(4, 4, '2022-10-18 21:54:34', true),
(6, 2, '2022-10-18 21:56:34', true);
INSERT INTO friendship (account1_id, account2_id)
VALUES
(1, 4),
(5, 4),
(6, 8);
-- CREATE INDEX user_work ON "user" USING btree (id);
-- CLUSTER "user" USING user_work;