create table "EMPLOYEE"
(
	"ID" VARCHAR(50) not null primary key,
	"PWORD" VARCHAR(50),
	"SSN" VARCHAR(50),
	"FNAME" VARCHAR(50),
	"LNAME" VARCHAR(50),
	"SNAME" VARCHAR(50),
	"ADDRESS" VARCHAR(50),
	"PNUMBER" VARCHAR(50),
	"CITY" VARCHAR(50),
	"STATE" VARCHAR(50),
	"ZIP" INTEGER,
	"DOB" VARCHAR(50),
	"ACTIVE" INTEGER,
	"SHIFT" VARCHAR(50),
	"HDATE" VARCHAR(50),
	"MANAGER" VARCHAR(50)
);

insert into EMPLOYEE (ID, PWORD)
values ('12345', '12345');