Repository navigation
Expand file tree
/
Copy pathdatabase_script.sql
More file actions
140 lines (123 loc) · 5.21 KB
/
Copy pathdatabase_script.sql
File metadata and controls
140 lines (123 loc) · 5.21 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
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
/*
Navicat PGSQL Data Transfer
Source Server : postgres
Source Server Version : 90303
Source Host : localhost:5432
Source Database : articledb
Source Schema : public
Target Server Type : PGSQL
Target Server Version : 90303
File Encoding : 65001
Date: 2015-11-13 08:29:52
*/
-- ----------------------------
-- Sequence structure for tbarticle_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "tbarticle_id_seq" CASCADE;
CREATE SEQUENCE "tbarticle_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 14
CACHE 1;
SELECT setval('"public"."tbarticle_id_seq"', 14, true);
-- ----------------------------
-- Sequence structure for tbuser_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "tbuser_id_seq" CASCADE;
CREATE SEQUENCE "tbuser_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 12
CACHE 1;
SELECT setval('"public"."tbuser_id_seq"', 12, true);
-- ----------------------------
-- Table structure for tbarticle
-- ----------------------------
DROP TABLE IF EXISTS "tbarticle" CASCADE;
CREATE TABLE "tbarticle" (
"id" int8 DEFAULT nextval('tbarticle_id_seq'::regclass) NOT NULL,
"title" varchar COLLATE "default" NOT NULL,
"userid" int4 NOT NULL,
"content" text COLLATE "default",
"publish_date" date,
"enable" bool NOT NULL
)
WITH (OIDS=FALSE)
;
-- ----------------------------
-- Records of tbarticle
-- ----------------------------
BEGIN;
INSERT INTO "tbarticle" VALUES ('1', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('2', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('3', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('4', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('5', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('6', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('7', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('8', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('9', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('10', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('11', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('12', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('13', 'sdf', '1', 'sdf', '2010-02-01', 't');
INSERT INTO "tbarticle" VALUES ('14', 'sdf', '1', 'sdf', '2010-02-01', 't');
COMMIT;
-- ----------------------------
-- Table structure for tbuser
-- ----------------------------
DROP TABLE IF EXISTS "tbuser" CASCADE;
CREATE TABLE "tbuser" (
"id" int4 DEFAULT nextval('tbuser_id_seq'::regclass) NOT NULL,
"username" varchar COLLATE "default" NOT NULL,
"password" varchar COLLATE "default" NOT NULL,
"role" varchar COLLATE "default" NOT NULL,
"enable" bool NOT NULL,
"email" varchar COLLATE "default",
"address" varchar COLLATE "default",
"phone" varchar COLLATE "default",
"name" varchar COLLATE "default",
"gender" varchar COLLATE "default"
)
WITH (OIDS=FALSE)
;
-- ----------------------------
-- Records of tbuser
-- ----------------------------
BEGIN;
INSERT INTO "tbuser" VALUES ('1', 'admin1', '1', 'ROLE_ADMIN', 't', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('2', 'author1', '1', 'ROLE_AUTHOR', 't', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('3', 'derp1', '1234', 'ROLE_AUTHOR', 'f', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('4', 'derp2', '1234', 'ROLE_ADMIN', 'f', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('5', 'derp3', '1234', 'ROLE_AUTHOR', 't', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('6', 'derp4', '1234', 'ROLE_ADMIN', 't', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('7', 'derp5', '1234', 'ROLE_AUTHOR', 't', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('8', 'derp6', '1234', 'ROLE_ADMIN', 'f', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('9', 'derp7', '1234', 'ROLE_AUTHOR', 'f', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('10', 'derp8', '1234', 'ROLE_ADMIN', 'f', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('11', 'derp9', '1234', 'ROLE_AUTHOR', 't', null, null, null, null, null);
INSERT INTO "tbuser" VALUES ('12', 'asdf', 'asdf', 'ROLE_ADMIN', 't', null, null, null, null, null);
COMMIT;
-- ----------------------------
-- Alter Sequences Owned By
-- ----------------------------
ALTER SEQUENCE "tbarticle_id_seq" OWNED BY "tbarticle"."id";
ALTER SEQUENCE "tbuser_id_seq" OWNED BY "tbuser"."id";
-- ----------------------------
-- Primary Key structure for table tbarticle
-- ----------------------------
ALTER TABLE "tbarticle" ADD PRIMARY KEY ("id");
-- ----------------------------
-- Uniques structure for table tbuser
-- ----------------------------
ALTER TABLE "tbuser" ADD UNIQUE ("username");
-- ----------------------------
-- Primary Key structure for table tbuser
-- ----------------------------
ALTER TABLE "tbuser" ADD PRIMARY KEY ("id");
-- ----------------------------
-- Foreign Key structure for table "tbarticle"
-- ----------------------------
ALTER TABLE "tbarticle" ADD FOREIGN KEY ("userid") REFERENCES "tbuser" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;