A0pq6cdr

1	drop table if exists comment CASCADE
2    drop table if exists post CASCADE 
3    drop table if exists subreddit CASCADE 
4    drop table if exists subreddit_posts CASCADE     
5    drop table if exists user CASCADE 
6    drop table if exists vote CASCADE 
7
8    create table comment (
9       id bigint generated by default as identity,
10        created_date timestamp,
11        text varchar(255),
12        post_id bigint,
13        user_id bigint,
14        primary key (id)
15    )
16
17    create table post (
18       post_id bigint generated by default as identity,
19        created_date timestamp,
20        description clob,
21        post_name varchar(255),
22        url varchar(255),
23        vote_count integer,
24        id bigint,
25        user_id bigint,
26        primary key (post_id)
27    )
28
29    create table subreddit (
30       id bigint generated by default as identity,
31        created_date timestamp,
32        description varchar(255),
33        name varchar(255),
34        user_user_id bigint,
35        primary key (id)
36    )
37
38    create table subreddit_posts (
39       subreddit_id bigint not null,
40        posts_post_id bigint not null
41    )
42
43    create table user (
44       user_id bigint generated by default as identity,
45        email varchar(255),
46        password varchar(255),
47        username varchar(255),
48        primary key (user_id)
49    )
50
51    create table vote (
52       vote_id bigint generated by default as identity,
53        vote_type integer,
54        post_id bigint not null,
55        user_id bigint,
56        primary key (vote_id)
57    )
58
59    alter table subreddit_posts 
60       add constraint UK_ih17w4fa2em7w3u1tt8gqv2wh unique (posts_post_id)
61
62    alter table comment 
63       add constraint FKs1slvnkuemjsq2kj4h3vhx7i1 
64       foreign key (post_id) 
65       references post
66
67    alter table comment 
68       add constraint FK8kcum44fvpupyw6f5baccx25c 
69       foreign key (user_id) 
70       references user
71
72    alter table post 
73       add constraint FK7dhm40vytolqggids4vc9ykvt 
74       foreign key (id) 
75       references subreddit
76    
77    alter table post 
78       add constraint FK72mt33dhhs48hf9gcqrq4fxte 
79       foreign key (user_id) 
80       references user
81    
82    alter table subreddit 
83       add constraint FKqye4s0ll7xwj74d7irovyhbvg 
84       foreign key (user_user_id) 
85       references user
86    
87    alter table subreddit_posts 
88       add constraint FKl27wc8sin3rt45ayge7fanx10 
89       foreign key (posts_post_id) 
90       references post
91
92    alter table subreddit_posts 
93       add constraint FK1plpyiqs72shw84g90q0fes5r 
94       foreign key (subreddit_id) 
95       references subreddit
96
97    alter table vote 
98       add constraint FKl3c067ewaw5xktl5cjvniv3e9 
99       foreign key (post_id) 
100       references post
101    
102    alter table vote 
103       add constraint FKcsaksoe2iepaj8birrmithwve 
104       foreign key (user_id) 
105       references user