create table USERS
(
  ID              NUMBER(16) not null,
  USERNAME        VARCHAR2(200) not null,
  PASSWORD        VARCHAR2(200),
  CHANGE_PASSWORD CHAR(1) default 'N' not null,
  ACTIVE          CHAR(1) default 'Y' not null,
  VALID_FROM      DATE,
  VALID_TO        DATE,
  CREATED_BY      VARCHAR2(200) not null,
  CREATED_ON      DATE default sysdate not null,
  CHANGED_BY      VARCHAR2(200),
  CHANGED_ON      DATE,
  TITLE           VARCHAR2(64),
  FIRST_NAME      VARCHAR2(200),
  LAST_NAME       VARCHAR2(200),
  EMAIL           VARCHAR2(200),
  PHONE           VARCHAR2(200),
  MOBILE          VARCHAR2(200)
);

-- Create/Recreate primary, unique and foreign key constraints 
alter table USERS
  add constraint USER_PK primary key (ID);
  
alter table USERS
  add constraint USER_UK unique (USERNAME);