-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathusers.sql
51 lines (42 loc) · 1.72 KB
/
users.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
/*
Navicat PGSQL Data Transfer
Source Server : myprogress
Source Server Version : 90309
Source Host : localhost:5432
Source Database : STUDENT_DB
Source Schema : public
Target Server Type : PGSQL
Target Server Version : 90309
File Encoding : 65001
Date: 2017-06-27 08:33:12
*/
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS "public"."users";
CREATE TABLE "public"."users" (
"id" int4 DEFAULT nextval('users_id_seq'::regclass) NOT NULL,
"username" varchar(100) COLLATE "default",
"email" varchar(100) COLLATE "default",
"gender" varchar(1) COLLATE "default",
"phonenumber" varchar(100) COLLATE "default",
"status" varchar(1) COLLATE "default",
"user_hash" varchar(100) COLLATE "default",
"created_date" timestamp(6)
)
WITH (OIDS=FALSE)
;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO "public"."users" VALUES ('1', 'Pheng', '[email protected]', 'M', '069659998', '1', 'sahkfhkfkashflh-dsgsd-gssd', '2017-06-23 00:00:00');
INSERT INTO "public"."users" VALUES ('2', 'Sokheang', '[email protected]', 'M', '022121332', '0', 'sdggsdgsdgs-dssggsgs-sfgsg', '2017-06-23 00:00:00');
INSERT INTO "public"."users" VALUES ('3', 'Mouy Kea', '[email protected]', 'F', '023435255', '1', 'saafsfafafsaf-egehehggf-esfsgf', '2017-06-23 00:00:00');
INSERT INTO "public"."users" VALUES ('9', 'sss', 'sss', 'F', '4', '0', 'dsdfsfdsgsg', '2017-06-23 16:32:19.669');
-- ----------------------------
-- Alter Sequences Owned By
-- ----------------------------
-- ----------------------------
-- Primary Key structure for table users
-- ----------------------------
ALTER TABLE "public"."users" ADD PRIMARY KEY ("id");