create table "REGISTRATIONDB".REGISTRY
(
	ID INTEGER not null GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
	FIRSTNAME VARCHAR(35) not null,
	LASTNAME VARCHAR(35) not null,
	ADDRESS1 VARCHAR(45) not null,
	ADRESS2 VARCHAR(45),
	CITY VARCHAR(35) not null,
	STATE VARCHAR(2) not null,
	ZIPCODE NUMERIC(5) not null,
	COUNTRY VARCHAR(35) not null,
	DATEREGISTERED TIMESTAMP default CURRENT_TIMESTAMP not null,
	PRIMARY KEY (ID)
)