alter table HISTOGRAMS drop constraint FK9096178FDBFCB7FC; alter table RI_DATASET drop constraint FK946ACA509ED02E0C; alter table RI_DATASET drop constraint FK946ACA5087DA7C85; alter table TASK drop constraint FK272D855ACB66C5; alter table DSINSTANCE drop constraint FK456E8E2490C01319; alter table DSINSTANCE drop constraint FK456E8E249ED02E0C; alter table SYSTEM_TESTS drop constraint FKAC2C7FF1E2D4894F; alter table DATASET drop constraint FK80D14058CF2B95BF; alter table DATASET drop constraint FK80D14058821EC7B; alter table DATASET drop constraint FK80D1405834D56AFF; alter table RI_TASK drop constraint FK73B2A68DCF2B95BF; alter table RI_TASK drop constraint FK73B2A68D87DA7C85; alter table RECORDINFO drop constraint FK48C12C7FA6E94FBC; alter table RI_TASKPROCESS drop constraint FKB284FB22FFB837FA; alter table RI_TASKPROCESS drop constraint FKB284FB2287DA7C85; alter table TPI_DSI drop constraint FKE8400FA8188AD; alter table TPI_DSI drop constraint FKE8400FA8AD8BF4B3; alter table RUN drop constraint FK13E6BCF2B95BF; alter table TASKPROCESS drop constraint FK7B312D2ACF2B95BF; alter table TP_DS drop constraint FK4C581329ED02E0C; alter table TP_DS drop constraint FK4C58132FFB837FA; alter table USER_ROLE drop constraint FKBC16F46A188AD; alter table USER_ROLE drop constraint FKBC16F46AA6E94FBC; alter table TPINSTANCE drop constraint FKCD385311FFB837FA; alter table TPINSTANCE drop constraint FKCD38531190C01319; alter table CATEGORIES drop constraint FK6A31321C217F38D0; drop table HISTOGRAMS cascade constraints; drop table RI_DATASET cascade constraints; drop table TASK cascade constraints; drop table DSFILETYPE cascade constraints; drop table DSINSTANCE cascade constraints; drop table SYSTEM_TESTS cascade constraints; drop table DATASET cascade constraints; drop table RI_TASK cascade constraints; drop table RECORDINFO cascade constraints; drop table RI_TASKPROCESS cascade constraints; drop table TPI_DSI cascade constraints; drop table PROCESSINGSTATUS cascade constraints; drop table RUN cascade constraints; drop table TASKPROCESS cascade constraints; drop table TP_DS cascade constraints; drop table TASKTYPE cascade constraints; drop table USER_ROLE cascade constraints; drop table TPINSTANCE cascade constraints; drop table GLASTUSER cascade constraints; drop table CATEGORIES cascade constraints; drop table RELEASE_TESTS cascade constraints; drop table DSTYPE cascade constraints; drop table ROLE cascade constraints; drop sequence hibernate_sequence; create table HISTOGRAMS ( ID NUMBER(19,0) not null, NAME VARCHAR2(255), DESCRIPTION VARCHAR2(2000), CATEGORY_ID NUMBER(19,0), primary key (ID) ); create table RI_DATASET ( DATASET_FK NUMBER(19,0) not null, RECORDINFO_FK NUMBER(19,0) not null, primary key (DATASET_FK, RECORDINFO_FK) ); create table TASK ( TASK_PK NUMBER(19,0) not null, TASKTYPE_FK NUMBER(19,0) not null, TASKNAME VARCHAR2(20) not null, primary key (TASK_PK) ); create table DSFILETYPE ( DSFILETYPE_PK NUMBER(19,0) not null, DSFILETYPENAME VARCHAR2(10) not null, primary key (DSFILETYPE_PK) ); create table DSINSTANCE ( DSINSTANCE_PK NUMBER(19,0) not null, FILEPATH VARCHAR2(120) not null, FILENAME VARCHAR2(50) not null, DATASET_FK NUMBER(19,0) not null, RUN_FK NUMBER(19,0) not null, BYTES NUMBER(19,0), ARCHIVED VARCHAR2(1), primary key (DSINSTANCE_PK) ); create table SYSTEM_TESTS ( SYSTEST_ID NUMBER(19,0) not null, TEST_NAME VARCHAR2(30) not null, VERSION VARCHAR2(10) not null, REVISION VARCHAR2(2) not null, TEST_TYPE VARCHAR2(25) not null, RELTEST_ID NUMBER(19,0) not null, TEST_RESULT VARCHAR2(50), HISTOGRAM_FILE VARCHAR2(200), primary key (SYSTEST_ID) ); create table DATASET ( DATASET_PK NUMBER(19,0) not null, TASK_FK NUMBER(19,0) not null, DATASETNAME VARCHAR2(20) not null, DSTYPE_FK NUMBER(19,0) not null, DSFILETYPE_FK NUMBER(19,0) not null, primary key (DATASET_PK) ); create table RI_TASK ( TASK_FK NUMBER(19,0) not null, RECORDINFO_FK NUMBER(19,0) not null, primary key (TASK_FK, RECORDINFO_FK) ); create table RECORDINFO ( RECORDINFO_PK NUMBER(19,0) not null, NOTATION VARCHAR2(200) not null, ENTERED DATE not null, GLASTUSER_FK NUMBER(19,0) not null, primary key (RECORDINFO_PK) ); create table RI_TASKPROCESS ( TASKPROCESS_FK NUMBER(19,0) not null, RECORDINFO_FK NUMBER(19,0) not null, primary key (TASKPROCESS_FK, RECORDINFO_FK) ); create table TPI_DSI ( TPINSTANCE_FK NUMBER(19,0) not null, elt NUMBER(19,0) not null, primary key (TPINSTANCE_FK, elt) ); create table PROCESSINGSTATUS ( PROCESSINGSTATUS_PK NUMBER(19,0) not null, PROCESSINGSTATUSNAME VARCHAR2(20) not null, primary key (PROCESSINGSTATUS_PK) ); create table RUN ( RUN_PK NUMBER(19,0) not null, TASK_FK NUMBER(19,0) not null, RUNNAME VARCHAR2(40) not null, primary key (RUN_PK) ); create table TASKPROCESS ( TASKPROCESS_PK NUMBER(19,0) not null, TASK_FK NUMBER(19,0) not null, TASKPROCESSNAME VARCHAR2(20) not null, SEQUENCE NUMBER(19,0) not null, APPNAME VARCHAR2(20) not null, APPVERSION VARCHAR2(20) not null, primary key (TASKPROCESS_PK) ); create table TP_DS ( TASKPROCESS_FK NUMBER(19,0) not null, DATASET_FK NUMBER(19,0) not null, primary key (TASKPROCESS_FK, DATASET_FK) ); create table TASKTYPE ( TASKTYPE_PK NUMBER(19,0) not null, TASKTYPENAME VARCHAR2(20) not null, primary key (TASKTYPE_PK) ); create table USER_ROLE ( ROLE_FK NUMBER(19,0) not null, elt NUMBER(19,0) not null, GLASTUSER_FK NUMBER(19,0) not null, primary key (GLASTUSER_FK, elt) ); create table TPINSTANCE ( TPINSTANCE_PK NUMBER(19,0) not null, TASKPROCESS_FK NUMBER(19,0) not null, RUN_FK NUMBER(19,0) not null, primary key (TPINSTANCE_PK) ); create table GLASTUSER ( GLASTUSER_PK NUMBER(19,0) not null, GLASTUSERNAME VARCHAR2(20) not null, PASSWORD VARCHAR2(20) not null, primary key (GLASTUSER_PK) ); create table CATEGORIES ( ID NUMBER(19,0) not null, NAME VARCHAR2(255), PARENT_ID NUMBER(19,0), primary key (ID) ); create table RELEASE_TESTS ( RELTEST_ID NUMBER(19,0) not null, PKG_NAME VARCHAR2(25) not null, VERSION VARCHAR2(10), primary key (RELTEST_ID) ); create table DSTYPE ( DSTYPE_PK NUMBER(19,0) not null, DSTYPENAME VARCHAR2(10) not null, primary key (DSTYPE_PK) ); create table ROLE ( ROLE_PK NUMBER(19,0) not null, ROLENAME VARCHAR2(20) not null, primary key (ROLE_PK) ); alter table HISTOGRAMS add constraint FK9096178FDBFCB7FC foreign key (CATEGORY_ID) references CATEGORIES; alter table RI_DATASET add constraint FK946ACA509ED02E0C foreign key (DATASET_FK) references DATASET; alter table RI_DATASET add constraint FK946ACA5087DA7C85 foreign key (RECORDINFO_FK) references RECORDINFO; alter table TASK add constraint FK272D855ACB66C5 foreign key (TASKTYPE_FK) references TASKTYPE; alter table DSINSTANCE add constraint FK456E8E2490C01319 foreign key (RUN_FK) references RUN; alter table DSINSTANCE add constraint FK456E8E249ED02E0C foreign key (DATASET_FK) references DATASET; alter table SYSTEM_TESTS add constraint FKAC2C7FF1E2D4894F foreign key (RELTEST_ID) references RELEASE_TESTS; alter table DATASET add constraint FK80D14058CF2B95BF foreign key (TASK_FK) references TASK; alter table DATASET add constraint FK80D14058821EC7B foreign key (DSTYPE_FK) references DSTYPE; alter table DATASET add constraint FK80D1405834D56AFF foreign key (DSFILETYPE_FK) references DSFILETYPE; alter table RI_TASK add constraint FK73B2A68DCF2B95BF foreign key (TASK_FK) references TASK; alter table RI_TASK add constraint FK73B2A68D87DA7C85 foreign key (RECORDINFO_FK) references RECORDINFO; alter table RECORDINFO add constraint FK48C12C7FA6E94FBC foreign key (GLASTUSER_FK) references GLASTUSER; alter table RI_TASKPROCESS add constraint FKB284FB22FFB837FA foreign key (TASKPROCESS_FK) references TASKPROCESS; alter table RI_TASKPROCESS add constraint FKB284FB2287DA7C85 foreign key (RECORDINFO_FK) references RECORDINFO; alter table TPI_DSI add constraint FKE8400FA8188AD foreign key (elt) references DSINSTANCE; alter table TPI_DSI add constraint FKE8400FA8AD8BF4B3 foreign key (TPINSTANCE_FK) references TPINSTANCE; alter table RUN add constraint FK13E6BCF2B95BF foreign key (TASK_FK) references TASK; alter table TASKPROCESS add constraint FK7B312D2ACF2B95BF foreign key (TASK_FK) references TASK; alter table TP_DS add constraint FK4C581329ED02E0C foreign key (DATASET_FK) references DATASET; alter table TP_DS add constraint FK4C58132FFB837FA foreign key (TASKPROCESS_FK) references TASKPROCESS; alter table USER_ROLE add constraint FKBC16F46A188AD foreign key (elt) references ROLE; alter table USER_ROLE add constraint FKBC16F46AA6E94FBC foreign key (GLASTUSER_FK) references GLASTUSER; alter table TPINSTANCE add constraint FKCD385311FFB837FA foreign key (TASKPROCESS_FK) references TASKPROCESS; alter table TPINSTANCE add constraint FKCD38531190C01319 foreign key (RUN_FK) references RUN; alter table CATEGORIES add constraint FK6A31321C217F38D0 foreign key (PARENT_ID) references CATEGORIES; create sequence hibernate_sequence;