• Home
• org.deephacks.tools4j
• tools4j-config-provider-jpa20
• 0.15.0
• source code
• install_config_derby.ddl

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

META-INF.install_config_derby.ddl Maven / Gradle / Ivy

-- no semicolon allowed for derby

-- CREATE TABLES
create table CONFIG_BEAN (
  BEAN_ID varchar(40) not null, 
  BEAN_SCHEMA_NAME varchar(60) not null, 
  primary key (BEAN_ID, BEAN_SCHEMA_NAME)
);

create table CONFIG_BEAN_SINGLETON (
  BEAN_SCHEMA_NAME varchar(60) not null, 
  primary key (BEAN_SCHEMA_NAME)
);

create table CONFIG_BEAN_REF (
  UUID varchar(40) not null, 
  FK_SOURCE_BEAN_SCHEMA_NAME varchar(60) not null, 
  FK_SOURCE_BEAN_ID varchar(40) not null, 
  PROP_NAME varchar(40) not null, 
  FK_TARGET_BEAN_ID varchar(40) not null, 
  FK_TARGET_BEAN_SCHEMA_NAME varchar(60) not null, 
  primary key (UUID)
);

create table CONFIG_PROPERTY (
  UUID varchar(40) not null, 
  FK_BEAN_ID varchar(40) not null, 
  PROP_NAME varchar(40) not null, 
  FK_BEAN_SCHEMA_NAME varchar(60) not null, 
  PROP_VALUE varchar(255), 
  primary key (UUID)
);

-- FOREIGN KEY CONSTRAINTS
alter table CONFIG_BEAN_REF 
  add constraint FK_CONFIG_REF_BEAN 
    foreign key (FK_SOURCE_BEAN_ID, FK_SOURCE_BEAN_SCHEMA_NAME) 
      references CONFIG_BEAN (BEAN_ID, BEAN_SCHEMA_NAME) ON DELETE RESTRICT;
    
alter table CONFIG_BEAN_REF 
  add constraint FK_CONFIG_REF_FK_BEAN 
    foreign key (FK_TARGET_BEAN_ID, FK_TARGET_BEAN_SCHEMA_NAME)
      references CONFIG_BEAN (BEAN_ID, BEAN_SCHEMA_NAME) ON DELETE RESTRICT;
    
alter table CONFIG_PROPERTY 
  add constraint FK_CONFIG_BEAN_PROPERTY 
    foreign key (FK_BEAN_ID, FK_BEAN_SCHEMA_NAME) 
      references CONFIG_BEAN (BEAN_ID, BEAN_SCHEMA_NAME);