CREATE TABLE DTO_TEST_PARENT (ID VARCHAR(255) NOT NULL, STRING VARCHAR(255), VERSION BIGINT, BEANX_FOO VARCHAR(255), BEANX_CROSSREFCHILD VARCHAR(255), CROSS_REF_CHILD_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE DTO_TEST_CHILD_CONTAINMENT (ID VARCHAR(255) NOT NULL, VERSION BIGINT, CONTAINER_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE DTO_TEST_CHILD_CROSS_REF (ID VARCHAR(255) NOT NULL, VERSION BIGINT, CONTAINER_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE MCUSTOMER (ID INTEGER NOT NULL, ACCOUNT_NUM BIGINT, ADDRESS1 VARCHAR(255), ADDRESS2 VARCHAR(255), ADDRESS3 VARCHAR(255), ADDRESS4 VARCHAR(255), BIRTHDATE DATE, CITY VARCHAR(255), COUNTRY VARCHAR(255), DATE_ACCNT_OPENED VARCHAR(255), EDUCATION VARCHAR(255), FNAME VARCHAR(255), FULLNAME VARCHAR(255), GENDER VARCHAR(255), HOUSEOWNER VARCHAR(255), LNAME VARCHAR(255), MARITAL_STATUS VARCHAR(255), MEMBER_CARD VARCHAR(255), MI VARCHAR(255), NUM_CARS_OWNED INTEGER, NUM_CHILDREN_AT_HOME INTEGER, OCCUPATION VARCHAR(255), PHONE1 VARCHAR(255), PHONE2 VARCHAR(255), POSTAL_CODE VARCHAR(255), STATE_PROVINCE VARCHAR(255), TEST VARCHAR(255), TOTAL_CHILDREN INTEGER, VERSION BIGINT, YEARLY_INCOME VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE CASH_REGISTER (ID VARCHAR(255) NOT NULL, CURRENT_DAY VARCHAR(255), IP VARCHAR(255), LOCATION VARCHAR(255), NUM VARCHAR(255), VERSION BIGINT, PRIMARY KEY (ID))
CREATE UNIQUE INDEX CASH_IP_INDEX ON CASH_REGISTER (IP)
CREATE UNIQUE INDEX CASH_NUM_INDEX ON CASH_REGISTER (NUM)
CREATE TABLE CASH_SLIP (ID VARCHAR(255) NOT NULL, CASHIER VARCHAR(255), CURRENT_DAY VARCHAR(255), NOW TIMESTAMP, PAYED SMALLINT DEFAULT 0, SERIAL BIGINT, TOTAL FLOAT, VERSION BIGINT, CUSTOMER_ID INTEGER, REGISTER_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE INDEX CURRENT_DAY_INDEX ON CASH_SLIP (CURRENT_DAY)
CREATE INDEX SERIAL_INDEX ON CASH_SLIP (CURRENT_DAY, SERIAL)
CREATE TABLE CASH_POSITION (ID VARCHAR(255) NOT NULL, AMOUNT FLOAT, NOW TIMESTAMP, PRICE FLOAT, QUANTITY FLOAT, VERSION BIGINT, SLIP_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE CASH_SUB_POSITION (ID VARCHAR(255) NOT NULL, PRICE FLOAT, QUANTITY FLOAT, VERSION BIGINT, PARENT_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE CASH_PAYMENT (ID VARCHAR(255) NOT NULL, NOW TIMESTAMP, PAYED FLOAT, VERSION BIGINT, METHOD_OF_PAYMENT_ID VARCHAR(255), SLIP_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE CASH_PAYMENT_METHOD (ID VARCHAR(255) NOT NULL, CREDIT SMALLINT DEFAULT 0, IMAGE_NAME VARCHAR(255), LOWER_LIMIT FLOAT, NAME VARCHAR(255), NUM VARCHAR(255), VERSION BIGINT, PRIMARY KEY (ID))
CREATE UNIQUE INDEX PAYMENT_NUM_INDEX ON CASH_PAYMENT_METHOD (NUM)
CREATE TABLE COMPANY_RELATION_TYPE (ID VARCHAR(255) NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), VERSION BIGINT, PRIMARY KEY (ID))
CREATE TABLE COMPANY_GROUP (ID VARCHAR(255) NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), VERSION BIGINT, MAIN_COMPANY_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE COMPANY (ID VARCHAR(255) NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), VERSION BIGINT, COMPANY_GROUP_ID VARCHAR(255), RELATION_TYPE_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE ADDRESS (ID VARCHAR(255) NOT NULL, ADDRESS1 VARCHAR(255), ADDRESS2 VARCHAR(255), CITY VARCHAR(255), COUNTRY VARCHAR(255), EMAIL VARCHAR(255), LANDLINE VARCHAR(255), MOBILE VARCHAR(255), POSTAL_CODE VARCHAR(255), STATE_PROVINCE VARCHAR(255), VERSION BIGINT, COMPANY_ID VARCHAR(255), DEPARTMENT_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE DEPARTMENT (ID VARCHAR(255) NOT NULL, DEFAULT_YEARLY_INCOME FLOAT, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), VERSION BIGINT, COMPANY_ID VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE CAR (UUID VARCHAR(255) NOT NULL, FINISHING_DATE DATE, NUMBER VARCHAR(255), VERSION BIGINT, OWNER_ID VARCHAR(255), PRIMARY KEY (UUID))
CREATE TABLE ADDON (UUID VARCHAR(255) NOT NULL, DESCRIPTION VARCHAR(255), VERSION BIGINT, CAR_ID VARCHAR(255), PRIMARY KEY (UUID))
CREATE TABLE TO_CYCLE1 (UUID VARCHAR(255) NOT NULL, VERSION BIGINT, CAR_ID VARCHAR(255), PRIMARY KEY (UUID))
CREATE TABLE TO_CYCLE2 (UUID VARCHAR(255) NOT NULL, VERSION BIGINT, CAR_ID VARCHAR(255), PARENT_ID VARCHAR(255), PRIMARY KEY (UUID))
CREATE TABLE PERSON (UUID VARCHAR(255) NOT NULL, FIRSTNAME VARCHAR(255), LASTNAME VARCHAR(255), VERSION BIGINT, HOMEADDRESS_POSTALCODE VARCHAR(255), HOMEADDRESS_STREETNAME VARCHAR(255), WORKADDRESS_POSTALCODE VARCHAR(255), WORKADDRESS_STREETNAME VARCHAR(255), PRIMARY KEY (UUID))
ALTER TABLE DTO_TEST_PARENT ADD CONSTRAINT DTTSTBNXCRSSRFCHLD FOREIGN KEY (BEANX_CROSSREFCHILD) REFERENCES DTO_TEST_CHILD_CROSS_REF (ID)
ALTER TABLE DTO_TEST_PARENT ADD CONSTRAINT DTTSTPRCRSSRFCHLDD FOREIGN KEY (CROSS_REF_CHILD_ID) REFERENCES DTO_TEST_CHILD_CROSS_REF (ID)
ALTER TABLE DTO_TEST_CHILD_CONTAINMENT ADD CONSTRAINT DTTSTCHLDCNTCNTNRD FOREIGN KEY (CONTAINER_ID) REFERENCES DTO_TEST_PARENT (ID)
ALTER TABLE DTO_TEST_CHILD_CROSS_REF ADD CONSTRAINT DTTSTCHLDCRSCNTNRD FOREIGN KEY (CONTAINER_ID) REFERENCES DTO_TEST_PARENT (ID)
ALTER TABLE CASH_SLIP ADD CONSTRAINT CASHSLIPREGISTERID FOREIGN KEY (REGISTER_ID) REFERENCES CASH_REGISTER (ID)
ALTER TABLE CASH_SLIP ADD CONSTRAINT CASHSLIPCUSTOMERID FOREIGN KEY (CUSTOMER_ID) REFERENCES MCUSTOMER (ID)
ALTER TABLE CASH_POSITION ADD CONSTRAINT CASHPOSITIONSLIPID FOREIGN KEY (SLIP_ID) REFERENCES CASH_SLIP (ID)
ALTER TABLE CASH_SUB_POSITION ADD CONSTRAINT CSHSBPOSITIONPRNTD FOREIGN KEY (PARENT_ID) REFERENCES CASH_POSITION (ID)
ALTER TABLE CASH_PAYMENT ADD CONSTRAINT CSHPYMNMTHDFPYMNTD FOREIGN KEY (METHOD_OF_PAYMENT_ID) REFERENCES CASH_PAYMENT_METHOD (ID)
ALTER TABLE CASH_PAYMENT ADD CONSTRAINT CASHPAYMENTSLIP_ID FOREIGN KEY (SLIP_ID) REFERENCES CASH_SLIP (ID)
ALTER TABLE COMPANY_GROUP ADD CONSTRAINT CMPNYGRUPMNCMPNYID FOREIGN KEY (MAIN_COMPANY_ID) REFERENCES COMPANY (ID)
ALTER TABLE COMPANY ADD CONSTRAINT CMPNYCMPANYGROUPID FOREIGN KEY (COMPANY_GROUP_ID) REFERENCES COMPANY_GROUP (ID)
ALTER TABLE COMPANY ADD CONSTRAINT CMPANYRLTIONTYPEID FOREIGN KEY (RELATION_TYPE_ID) REFERENCES COMPANY_RELATION_TYPE (ID)
ALTER TABLE ADDRESS ADD CONSTRAINT ADDRESS_COMPANY_ID FOREIGN KEY (COMPANY_ID) REFERENCES COMPANY (ID)
ALTER TABLE ADDRESS ADD CONSTRAINT DDRESSDEPARTMENTID FOREIGN KEY (DEPARTMENT_ID) REFERENCES DEPARTMENT (ID)
ALTER TABLE DEPARTMENT ADD CONSTRAINT DPARTMENTCOMPANYID FOREIGN KEY (COMPANY_ID) REFERENCES COMPANY (ID)
ALTER TABLE CAR ADD CONSTRAINT FK_CAR_OWNER_ID FOREIGN KEY (OWNER_ID) REFERENCES PERSON (UUID)
ALTER TABLE ADDON ADD CONSTRAINT FK_ADDON_CAR_ID FOREIGN KEY (CAR_ID) REFERENCES CAR (UUID)
ALTER TABLE TO_CYCLE1 ADD CONSTRAINT TO_CYCLE1_CAR_ID FOREIGN KEY (CAR_ID) REFERENCES CAR (UUID)
ALTER TABLE TO_CYCLE2 ADD CONSTRAINT TO_CYCLE2PARENT_ID FOREIGN KEY (PARENT_ID) REFERENCES TO_CYCLE1 (UUID)
ALTER TABLE TO_CYCLE2 ADD CONSTRAINT TO_CYCLE2_CAR_ID FOREIGN KEY (CAR_ID) REFERENCES CAR (UUID)
CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(15), PRIMARY KEY (SEQ_NAME))
INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)