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
) ;