3_Create.WDAUTHEN.Table.sql
999 Bytes
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
-- DROP SEQUENCE public.wd_user_id_seq;
CREATE SEQUENCE public.wd_user_id_seq
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 198;
CREATE TABLE public.wd_user (
username varchar(40) NULL,
password varchar(254) NULL,
retry_count INTEGER,
status character varying(20),
created_date TIMESTAMP WITHOUT TIME ZONE,
updated_date TIMESTAMP WITHOUT TIME ZONE,
id int4 NOT NULL DEFAULT nextval('wd_user_id_seq'::regclass),
CONSTRAINT wd_user_pk PRIMARY KEY (id),
CONSTRAINT wd_user_uni01 UNIQUE (username)
)
WITH (
OIDS=FALSE
) ;
-- add table
-- DROP SEQUENCE public.wd_admin_user_id_seq;
CREATE SEQUENCE public.wd_admin_user_id_seq
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 2;
CREATE TABLE public.wd_admin_user (
id int4 NOT NULL DEFAULT nextval('wd_admin_user_id_seq'::regclass),
username varchar(40) NULL,
password varchar(254) NULL,
CONSTRAINT wd_admin_user_pk PRIMARY KEY (id),
CONSTRAINT wd_admin_user_uni01 UNIQUE (username)
)
WITH (
OIDS=FALSE
) ;