E9Hp7JDN

1ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS pk_users_id CASCADE;
2ALTER TABLE IF EXISTS ONLY public.boards DROP CONSTRAINT IF EXISTS pk_boards_id CASCADE;
3ALTER TABLE IF EXISTS ONLY public.columns DROP CONSTRAINT IF EXISTS pk_columns_id CASCADE;
4ALTER TABLE IF EXISTS ONLY public.cards DROP CONSTRAINT IF EXISTS pk_cards_id CASCADE;
5
6
7DROP TABLE IF EXISTS public.users;
8CREATE TABLE users (
9    id serial NOT NULL,
10	email text,
11    name text,
12    password text
13);
14
15
16DROP TABLE IF EXISTS public.boards;
17CREATE TABLE boards (
18    id serial NOT NULL,
19	user_id integer,
20	title text,
21	description text
22);
23
24
25DROP TABLE IF EXISTS public.columns;
26CREATE TABLE columns (
27    id serial NOT NULL,
28	board_id integer,
29	title text
30);
31
32
33DROP TABLE IF EXISTS public.cards;
34CREATE TABLE cards (
35    id serial NOT NULL,
36    column_id integer,
37    title text,
38	order_num integer
39);
40
41
42ALTER TABLE ONLY users ADD CONSTRAINT pk_users_id PRIMARY KEY (id);
43ALTER TABLE ONLY boards ADD CONSTRAINT pk_boards_id PRIMARY KEY (id);
44ALTER TABLE ONLY columns ADD CONSTRAINT pk_columns_id PRIMARY KEY (id);
45ALTER TABLE ONLY cards ADD CONSTRAINT pk_cards_id PRIMARY KEY (id);
46
47
48INSERT INTO users VALUES (1, 'admin@planit.com', 'admin', 'admin');
49
50INSERT INTO boards VALUES (1, 1, 'Board 1', 'test board');
51
52INSERT INTO columns VALUES(1, 1, 'TODO');
53
54INSERT INTO cards VALUES (1, 1, 'new card 1', 1);
55INSERT INTO cards VALUES (2, 1, 'new card 2', 2);
56
57
58SELECT pg_catalog.setval('users_id_seq', 1, true);
59SELECT pg_catalog.setval('boards_id_seq', 1, true);
60SELECT pg_catalog.setval('columns_id_seq', 1, true);
61SELECT pg_catalog.setval('cards_id_seq', 2, true);