-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreate.sql
More file actions
42 lines (42 loc) · 6.02 KB
/
create.sql
File metadata and controls
42 lines (42 loc) · 6.02 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
create table tb_post (id int8 generated by default as identity, post_date TIMESTAMP WITHOUT TIME ZONE, text TEXT, user_id int8, primary key (id));
create table tb_reply (id int8 generated by default as identity, text TEXT, post_id int8, primary key (id));
create table tb_role (id int8 generated by default as identity, authority varchar(255), primary key (id));
create table tb_user (id int8 generated by default as identity, email varchar(255), nickname varchar(255), password varchar(255), primary key (id));
create table tb_user_role (user_id int8 not null, role_id int8 not null, primary key (user_id, role_id));
alter table if exists tb_post add constraint FKhx7a7k3pf66vpddqg5pr12anw foreign key (user_id) references tb_user;
alter table if exists tb_reply add constraint FKji1ew0yh0liviiwfl5jyb7oc5 foreign key (post_id) references tb_post;
alter table if exists tb_user_role add constraint FKea2ootw6b6bb0xt3ptl28bymv foreign key (role_id) references tb_role;
alter table if exists tb_user_role add constraint FK7vn3h53d0tqdimm8cp45gc0kl foreign key (user_id) references tb_user;
create table tb_post (id int8 generated by default as identity, post_date TIMESTAMP WITHOUT TIME ZONE, text TEXT, user_id int8, primary key (id));
create table tb_reply (id int8 generated by default as identity, text TEXT, post_id int8, primary key (id));
create table tb_role (id int8 generated by default as identity, authority varchar(255), primary key (id));
create table tb_user (id int8 generated by default as identity, email varchar(255), nickname varchar(255), password varchar(255), primary key (id));
create table tb_user_role (user_id int8 not null, role_id int8 not null, primary key (user_id, role_id));
alter table if exists tb_post add constraint FKhx7a7k3pf66vpddqg5pr12anw foreign key (user_id) references tb_user;
alter table if exists tb_reply add constraint FKji1ew0yh0liviiwfl5jyb7oc5 foreign key (post_id) references tb_post;
alter table if exists tb_user_role add constraint FKea2ootw6b6bb0xt3ptl28bymv foreign key (role_id) references tb_role;
alter table if exists tb_user_role add constraint FK7vn3h53d0tqdimm8cp45gc0kl foreign key (user_id) references tb_user;
INSERT INTO tb_user (nickname, email, password) VALUES ('Gilese Silva', 'gilese@gmail.com', '$2a$10$eACCYoNOHEqXve8aIWT8Nu3PkMXWBaOxJ9aORUYzfMQCbVBIhZ8tG');
INSERT INTO tb_user (nickname, email, password) VALUES ('João Molenga', 'molenga@gmail.com', '$2a$10$eACCYoNOHEqXve8aIWT8Nu3PkMXWBaOxJ9aORUYzfMQCbVBIhZ8tG');
INSERT INTO tb_user (nickname, email, password) VALUES ('Hugo Abaporu', 'abaporu@gmail.com', '$2a$10$eACCYoNOHEqXve8aIWT8Nu3PkMXWBaOxJ9aORUYzfMQCbVBIhZ8tG');
INSERT INTO tb_user (nickname, email, password) VALUES ('Germano Cano', 'germano@gmail.com', '$2a$10$eACCYoNOHEqXve8aIWT8Nu3PkMXWBaOxJ9aORUYzfMQCbVBIhZ8tG');
INSERT INTO tb_role (authority) VALUES ('ROLE_MEMBER');
INSERT INTO tb_role (authority) VALUES ('ROLE_ADMIN');
INSERT INTO tb_user_role (user_id, role_id) VALUES (1, 1);
INSERT INTO tb_user_role (user_id, role_id) VALUES (2, 1);
INSERT INTO tb_user_role (user_id, role_id) VALUES (2, 2);
INSERT INTO tb_user_role (user_id, role_id) VALUES (3, 1);
INSERT INTO tb_user_role (user_id, role_id) VALUES (4, 1);
INSERT INTO tb_post (text, post_date, user_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat. ', TIMESTAMP WITH TIME ZONE '2022-01-15T13:00:00Z', 1);
INSERT INTO tb_post (text, post_date, user_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat. ', TIMESTAMP WITH TIME ZONE '2022-01-15T13:00:00Z', 2);
INSERT INTO tb_post (text, post_date, user_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat. ', TIMESTAMP WITH TIME ZONE '2022-01-15T13:00:00Z', 3);
INSERT INTO tb_post (text, post_date, user_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat. ', TIMESTAMP WITH TIME ZONE '2022-01-15T13:00:00Z', 4);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 1);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 1);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 2);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 2);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 2);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 2);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 3);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 4);
INSERT INTO tb_reply (text, post_id) VALUES ('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse egestas lobortis tortor, in mollis enim. Aliquam erat volutpat. Aliquam erat volutpat.', 3);