CREATE TABLE USERS ( ID INTEGER IDENTITY, USERNAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(255) NOT NULL, CHANGE_PASSWORD CHAR(1) DEFAULT 'N', VALID_FROM TIMESTAMP, VALID_TO TIMESTAMP, ACTIVE CHAR(1) DEFAULT 'Y', FIRST_NAME VARCHAR(20), LAST_NAME VARCHAR(20), EMAIL VARCHAR(255), PHONE VARCHAR(20), CONSTRAINT USR_PK PRIMARY KEY(ID), CONSTRAINT USR_NAME_UK UNIQUE(USERNAME) )