Patch_304_20171128_psql_WDAUTHEN.sql
436 Bytes
Drop Table IF EXISTS public.wd_user;
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
) ;