-- setup Customers database for JPA sample;

-- connect 'SystemDatabase';

-- drop table JPACUSTOMER;

CREATE TABLE JPACUSTOMER (
	ID 		INTEGER NOT NULL PRIMARY KEY,
	NAME	 	VARCHAR(255),
	BIRTHDAY	DATE,
	SSS_NO	 	VARCHAR(255),
	ADDRESS		VARCHAR(255),
	ANNUAL_SALARY	DOUBLE,
	LOAN_AMOUNT	DOUBLE
	);

-- disconnect;