category.sql

/*L
  Copyright Washington University in St. Louis, SemanticBits, Persistent Systems, Krishagni.

  Distributed under the OSI-approved BSD 3-Clause License.
  See http://ncip.github.com/wustl-common-package/LICENSE.txt for details.
L*/

alter table CATEGORIAL_CLASS drop foreign key FK9651EF324E097CB9;
alter table CATEGORIAL_CLASS drop foreign key FK9651EF32DBFCB7FC;
alter table CATEGORIAL_CLASS drop foreign key FK9651EF32D8D56A33;
alter table CATEGORIAL_ATTRIBUTE drop foreign key FK31F77B565830D1AB;
alter table CATEGORIAL_ATTRIBUTE drop foreign key FK31F77B56886C9E21;
alter table CATEGORIAL_ATTRIBUTE drop foreign key FK31F77B56E8CBD948;
alter table CATEGORY drop foreign key FK31A8ACFE2D0F63E7;
alter table CATEGORY drop foreign key FK31A8ACFE4E097CB9;
alter table CATEGORY drop foreign key FK31A8ACFE211D9A6B;

drop table if exists CATEGORIAL_CLASS;
drop table if exists CATEGORIAL_ATTRIBUTE;
drop table if exists CATEGORY;

create table CATEGORIAL_CLASS (
   ID bigint not null auto_increment,
   CATEGORY_ID bigint not null,
   DE_ENTITY_ID bigint not null,
   PATH_FROM_PARENT_ID bigint,
   PARENT_CATEGORIAL_CLASS_ID bigint,
   primary key (ID)
);

create table CATEGORIAL_ATTRIBUTE (
   ID bigint not null auto_increment,
   CATEGORIAL_CLASS_ID bigint not null,
   DE_CATEGORY_ATTRIBUTE_ID bigint not null,
   DE_SOURCE_CLASS_ATTRIBUTE_ID bigint not null,
   primary key (ID)
);

create table CATEGORY (
   ID bigint not null auto_increment,
   DE_ENTITY_ID bigint not null,
   PARENT_CATEGORY_ID bigint,
   ROOT_CATEGORIAL_CLASS_ID bigint not null,
   primary key (ID)
);

alter table CATEGORIAL_CLASS add index FK9651EF324E097CB9 (DE_ENTITY_ID), add constraint FK9651EF324E097CB9 foreign key (DE_ENTITY_ID) references DYEXTN_ENTITY (IDENTIFIER);
alter table CATEGORIAL_CLASS add index FK9651EF32DBFCB7FC (CATEGORY_ID), add constraint FK9651EF32DBFCB7FC foreign key (CATEGORY_ID) references CATEGORY (ID);
alter table CATEGORIAL_CLASS add index FK9651EF32D8D56A33 (PARENT_CATEGORIAL_CLASS_ID), add constraint FK9651EF32D8D56A33 foreign key (PARENT_CATEGORIAL_CLASS_ID) references CATEGORIAL_CLASS (ID);
alter table CATEGORIAL_ATTRIBUTE add index FK31F77B565830D1AB (DE_SOURCE_CLASS_ATTRIBUTE_ID), add constraint FK31F77B565830D1AB foreign key (DE_SOURCE_CLASS_ATTRIBUTE_ID) references DYEXTN_PRIMITIVE_ATTRIBUTE (IDENTIFIER);
alter table CATEGORIAL_ATTRIBUTE add index FK31F77B56886C9E21 (DE_CATEGORY_ATTRIBUTE_ID), add constraint FK31F77B56886C9E21 foreign key (DE_CATEGORY_ATTRIBUTE_ID) references DYEXTN_PRIMITIVE_ATTRIBUTE (IDENTIFIER);
alter table CATEGORIAL_ATTRIBUTE add index FK31F77B56E8CBD948 (CATEGORIAL_CLASS_ID), add constraint FK31F77B56E8CBD948 foreign key (CATEGORIAL_CLASS_ID) references CATEGORIAL_CLASS (ID);
alter table CATEGORY add index FK31A8ACFE2D0F63E7 (PARENT_CATEGORY_ID), add constraint FK31A8ACFE2D0F63E7 foreign key (PARENT_CATEGORY_ID) references CATEGORY (ID);
alter table CATEGORY add index FK31A8ACFE4E097CB9 (DE_ENTITY_ID), add constraint FK31A8ACFE4E097CB9 foreign key (DE_ENTITY_ID) references DYEXTN_ENTITY (IDENTIFIER);
alter table CATEGORY add index FK31A8ACFE211D9A6B (ROOT_CATEGORIAL_CLASS_ID), add constraint FK31A8ACFE211D9A6B foreign key (ROOT_CATEGORIAL_CLASS_ID) references CATEGORIAL_CLASS (ID);