forked from coocood/qbs
-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_test_postgres.sql
179 lines (120 loc) · 3.75 KB
/
db_test_postgres.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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
ALTER TABLE ONLY public."user" DROP CONSTRAINT unique_name;
ALTER TABLE ONLY public."user" DROP CONSTRAINT unique_email;
ALTER TABLE ONLY public."user" DROP CONSTRAINT pk_user;
ALTER TABLE ONLY public.post DROP CONSTRAINT pk_post;
ALTER TABLE public."user" ALTER COLUMN id DROP DEFAULT;
ALTER TABLE public.post ALTER COLUMN id DROP DEFAULT;
DROP SEQUENCE public.user_id_seq;
DROP TABLE public."user";
DROP SEQUENCE public.post_id_seq;
DROP TABLE public.post;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: post; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE post (
id bigint NOT NULL,
title character varying(255) NOT NULL,
permalink character varying(255) NOT NULL,
body text,
views integer DEFAULT 1 NOT NULL
);
ALTER TABLE public.post OWNER TO postgres;
--
-- Name: post_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE post_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.post_id_seq OWNER TO postgres;
--
-- Name: post_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE post_id_seq OWNED BY post.id;
--
-- Name: user; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE "user" (
id bigint NOT NULL,
email character varying(255) NOT NULL,
password character varying(255) NOT NULL,
story text,
image bytea,
name character varying(255) NOT NULL
);
ALTER TABLE public."user" OWNER TO postgres;
--
-- Name: user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE user_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.user_id_seq OWNER TO postgres;
--
-- Name: user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE user_id_seq OWNED BY "user".id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY post ALTER COLUMN id SET DEFAULT nextval('post_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY "user" ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);
--
-- Data for Name: post; Type: TABLE DATA; Schema: public; Owner: postgres
--
INSERT INTO post VALUES (1, 'First Post', 'first_post', 'This is the first post', 1);
INSERT INTO post VALUES (2, 'Second Post', 'second_post', 'Hey must be committed to this, I wrote a second post', 1);
--
-- Name: post_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('post_id_seq', 1, false);
--
-- Data for Name: user; Type: TABLE DATA; Schema: public; Owner: postgres
--
--
-- Name: user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('user_id_seq', 1, false);
--
-- Name: pk_post; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY post
ADD CONSTRAINT pk_post PRIMARY KEY (id);
--
-- Name: pk_user; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY "user"
ADD CONSTRAINT pk_user PRIMARY KEY (id);
--
-- Name: unique_email; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY "user"
ADD CONSTRAINT unique_email UNIQUE (email);
--
-- Name: unique_name; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY "user"
ADD CONSTRAINT unique_name UNIQUE (name);
--
-- PostgreSQL database dump complete
--