Скрипт для генерации тестовой базы Fluent NHibernate

DROP TABLE STOREPRODUCT;
DROP TABLE EMPLOYEE;
DROP TABLE STORE;
DROP TABLE PRODUCT;

DROP SEQUENCE EMPLOYEE_SEQ;
DROP SEQUENCE STORE_SEQ;
DROP SEQUENCE PRODUCT_SEQ;

CREATE SEQUENCE EMPLOYEE_SEQ
    INCREMENT BY 1 START WITH 0 MINVALUE 0 NOCACHE;

CREATE SEQUENCE STORE_SEQ
    INCREMENT BY 1 START WITH 0 MINVALUE 0 NOCACHE;

CREATE SEQUENCE PRODUCT_SEQ
    INCREMENT BY 1 START WITH 0 MINVALUE 0 NOCACHE;

CREATE TABLE STORE
(
  ID NUMBER NOT NULL,
  NAME VARCHAR2(50) NOT NULL,
  CONSTRAINT STORE_PK PRIMARY KEY (ID) ENABLE
);

CREATE TABLE EMPLOYEE
(
  ID NUMBER NOT NULL,
  FIRSTNAME VARCHAR2(50) NOT NULL,
  LASTNAME VARCHAR2(50) NOT NULL,
  STORE_ID NUMBER NOT NULL,
  CONSTRAINT EMPLOYEE_PK PRIMARY KEY (ID) ENABLE
);

ALTER TABLE EMPLOYEE
ADD CONSTRAINT EMPLOYEE_STORE_FK1 FOREIGN KEY (STORE_ID) REFERENCES STORE (ID) ON DELETE CASCADE ENABLE;

CREATE TABLE PRODUCT
(
  ID NUMBER NOT NULL,
  NAME VARCHAR2(50) NOT NULL,
  PRICE NUMBER NOT NULL,
  CONSTRAINT TABLE1_PK PRIMARY KEY (ID) ENABLE
);

CREATE TABLE STOREPRODUCT
(
  PRODUCT_ID NUMBER NOT NULL,
  STORE_ID NUMBER NOT NULL
);

ALTER TABLE STOREPRODUCT
ADD CONSTRAINT STOREPRODUCT_PRODUCT_FK1 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT (ID) ENABLE;

ALTER TABLE STOREPRODUCT
ADD CONSTRAINT STOREPRODUCT_STORE_FK1 FOREIGN KEY (STORE_ID) REFERENCES STORE (ID) ENABLE;