-----------------------------
-- Modified create_Db2z sql script to define DBB schema
--  including explicit definitions for tablespaces and primary keys
--   - tablespaces are prefixed with DBBZ*
--   - primary keys carry suffix _PK
-- 
-- DBB database schema 1.1.3 / 2.0
--
-- Last updated 2022-12-19 19:40
-----------------------------
-- Please review definitions before submitting
-----------------------------
 

--SET CURRENT SQLID = 'DBEHM';
SET SCHEMA DBBZ;

CREATE DATABASE DBBZ001 STOGROUP DBBSTG BUFFERPOOL BP16K0 CCSID UNICODE;

CREATE
  TABLESPACE DBBZ100
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE LOGICAL_FILE
  (
     C_ID     BIGINT NOT NULL,
     LF_FILE  VARCHAR(1024) NOT NULL,
     LF_LNAME CHARACTER(32) NOT NULL,
     LANG_ID  BIGINT,
     LF_CICS  CHAR(1) NOT NULL,
     LF_SQL   CHAR(1) NOT NULL,
     LF_DLI   CHAR(1) NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ100;

CREATE INDEX LF_FILE_NDX
  ON LOGICAL_FILE (LF_FILE ASC);

CREATE UNIQUE INDEX LOGICAL_FILE_PK
  ON LOGICAL_FILE (C_ID);

ALTER TABLE LOGICAL_FILE
  ADD CONSTRAINT LF_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ101
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE LOGICAL_DEPENDENCY
  (
     C_ID        BIGINT NOT NULL,
     C_LNAME     CHARACTER(32) NOT NULL,
     CATEGORY_ID BIGINT,
     LIBRARY_ID  BIGINT
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ101;

CREATE INDEX LD_C_LNAME_NDX
  ON LOGICAL_DEPENDENCY (C_LNAME ASC);

CREATE INDEX LD_ALL_NDX
  ON LOGICAL_DEPENDENCY
  (C_LNAME ASC, CATEGORY_ID ASC, LIBRARY_ID ASC);

CREATE UNIQUE INDEX LOGICAL_DEPENDENCY_PK
  ON LOGICAL_DEPENDENCY (C_ID);

ALTER TABLE LOGICAL_DEPENDENCY
  ADD CONSTRAINT LD_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ102
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE "COLLECTION"
  (
     C_ID              BIGINT NOT NULL,
     C_CREATED         TIMESTAMP NOT NULL WITH DEFAULT,
     C_CREATED_BY      CHARACTER(30),
     C_LAST_UPDATED    TIMESTAMP NOT NULL WITH DEFAULT,
     C_LAST_UPDATED_BY CHARACTER(30),
     C_NAME            CHARACTER(128) NOT NULL,
     PERMISSIONS_C_ID  BIGINT
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ102;

CREATE UNIQUE INDEX COLLECTION_PK
  ON "COLLECTION" (C_ID);

ALTER TABLE "COLLECTION"
  ADD CONSTRAINT COL_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ103
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE LF_LANGUAGES
  (
     C_ID       BIGINT NOT NULL,
     C_LANGUAGE CHARACTER(32) NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ103;

CREATE INDEX LANG_LANGUAGE_NDX
  ON LF_LANGUAGES (C_LANGUAGE ASC);

CREATE UNIQUE INDEX LF_LANGUAGES_PK
  ON LF_LANGUAGES (C_ID);

ALTER TABLE LF_LANGUAGES
  ADD CONSTRAINT LANG_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ104
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE LD_LIBRARIES
  (
     C_ID      BIGINT NOT NULL,
     C_LIBRARY CHARACTER(44) NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ104;

CREATE INDEX LIB_LIBRARY_NDX
  ON LD_LIBRARIES (C_LIBRARY ASC);

CREATE UNIQUE INDEX LD_LIBRARIES_PK
  ON LD_LIBRARIES (C_ID);

ALTER TABLE LD_LIBRARIES
  ADD CONSTRAINT LIB_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ105
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE LD_CATEGORIES
  (
     C_ID       BIGINT NOT NULL,
     C_CATEGORY CHARACTER(32) NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ105;

CREATE INDEX CAT_CATEGORY_NDX
  ON LD_CATEGORIES (C_CATEGORY ASC);

CREATE UNIQUE INDEX LD_CATEGORIES_PK
  ON LD_CATEGORIES (C_ID);

ALTER TABLE LD_CATEGORIES
  ADD CONSTRAINT CAT_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ106
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE DBB_TABLE_VERSIONS
  (
     DBB_TBL_NAME    VARCHAR(50) NOT NULL,
     DBB_TBL_VERSION INT
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ106;

CREATE UNIQUE INDEX DBB_TBL_NAME_NDX
  ON DBB_TABLE_VERSIONS (DBB_TBL_NAME ASC);

ALTER TABLE DBB_TABLE_VERSIONS
  ADD CONSTRAINT DBB_TBL_NAME_NDX
  PRIMARY KEY (DBB_TBL_NAME);

CREATE
   TABLESPACE DBBZ107
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE BUILD_RESULT
  (
     C_ID              BIGINT NOT NULL,
     C_CREATED         TIMESTAMP NOT NULL WITH DEFAULT,
     C_CREATED_BY      CHARACTER(30),
     BR_GROUP          CHARACTER(128) NOT NULL,
     BR_LABEL          CHARACTER(128) NOT NULL,
     BR_STATUS         SMALLINT,
     BR_STATE          SMALLINT,
     C_LAST_UPDATED    TIMESTAMP NOT NULL WITH DEFAULT,
     C_LAST_UPDATED_BY CHARACTER(30),
     PERMISSIONS_C_ID  BIGINT
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ107;

CREATE INDEX BR_GROUP_NDX
  ON BUILD_RESULT (BR_GROUP ASC);

CREATE UNIQUE INDEX BUILD_RESULT_PK
  ON BUILD_RESULT (C_ID);

ALTER TABLE BUILD_RESULT
  ADD CONSTRAINT BR_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ108
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE BUILD_RESULT_PROPERTY
  (
     C_ID           BIGINT NOT NULL,
     PROPERTY_NAME  CHARACTER(128) NOT NULL,
     PROPERTY_VALUE VARCHAR(1024) NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ108;

CREATE INDEX PROPERTY_NAME_NDX
  ON BUILD_RESULT_PROPERTY (PROPERTY_NAME ASC);

CREATE INDEX PROPERTY_VALUE_NDX
  ON BUILD_RESULT_PROPERTY (PROPERTY_VALUE ASC);

CREATE UNIQUE INDEX BUILD_RESULT_PROPERTY_PK
  ON BUILD_RESULT_PROPERTY (C_ID);

ALTER TABLE BUILD_RESULT_PROPERTY
  ADD CONSTRAINT PROPERTY_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ109
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE ARTIFACT
  (
     C_ID       BIGINT NOT NULL,
     A_CHECKSUM BIGINT,
     A_TYPE     VARCHAR(256) NOT NULL,
     A_NAME     CHARACTER(128) NOT NULL,
     A_SIZE     BIGINT
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ109;

CREATE INDEX A_NAME_TYPE_NDX
  ON ARTIFACT (A_NAME ASC, A_TYPE ASC);

CREATE INDEX A_NAME_NDX
  ON ARTIFACT (A_NAME ASC);

CREATE UNIQUE INDEX ARTIFACT_PK
  ON ARTIFACT (C_ID);

ALTER TABLE ARTIFACT
  ADD CONSTRAINT A_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ110
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE ARTIFACT_CONTENT
  (
     C_ID         BIGINT NOT NULL,
     CONTENT_DATA BLOB(100M)
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ110;

CREATE UNIQUE INDEX ARTIFACT_CONTENT_PK
  ON ARTIFACT_CONTENT (C_ID);

ALTER TABLE ARTIFACT_CONTENT
  ADD CONSTRAINT CONTENT_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ111
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE PERMISSIONS
  (
     C_ID         BIGINT NOT NULL,
     P_MANAGED_ID BIGINT NOT NULL,
     P_OWNER      CHARACTER(30) NOT NULL,
     P_PERMISSION INT,
     P_TEAM       CHARACTER(30)
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ111;

CREATE UNIQUE INDEX PERMISSIONS_PK
  ON PERMISSIONS (C_ID);

ALTER TABLE PERMISSIONS
  ADD CONSTRAINT P_CID_NDX PRIMARY KEY (C_ID);

CREATE
   TABLESPACE DBBZ112
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE LF_DEP_MAPPING
  (
     LF_ID  BIGINT NOT NULL,
     DEP_ID BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ112;

CREATE INDEX LF_DEP_MAP_LFID_NDX
  ON LF_DEP_MAPPING (LF_ID ASC);

CREATE INDEX LF_DEP_MAP_DEPID_NDX
  ON LF_DEP_MAPPING (DEP_ID ASC);

CREATE UNIQUE INDEX LF_DEP_MAPPING_PK
  ON LF_DEP_MAPPING (LF_ID, DEP_ID);

ALTER TABLE LF_DEP_MAPPING
  ADD CONSTRAINT LF_DEP_MAP_NDX
  PRIMARY KEY (LF_ID, DEP_ID);

CREATE
   TABLESPACE DBBZ113
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE COL_LF_MAPPING
  (
     COLLECTION_ID BIGINT NOT NULL,
     LF_ID         BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ113;

CREATE INDEX COL_LF_MAP_COLID_NDX
  ON COL_LF_MAPPING (COLLECTION_ID ASC);

CREATE INDEX COL_LF_MAP_LFID_NDX
  ON COL_LF_MAPPING (LF_ID ASC);

CREATE UNIQUE INDEX COL_LF_MAPPING_PK
  ON COL_LF_MAPPING (COLLECTION_ID, LF_ID);

ALTER TABLE COL_LF_MAPPING
  ADD CONSTRAINT COL_LF_MAP_NDX
  PRIMARY KEY (COLLECTION_ID, LF_ID);

CREATE
   TABLESPACE DBBZ114
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE BR_REPORT_MAPPING
  (
     BR_ID  BIGINT NOT NULL,
     REP_ID BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ114;

CREATE INDEX BR_REP_MAP_BRID_NDX
  ON BR_REPORT_MAPPING (BR_ID ASC);

CREATE INDEX BR_REP_MAP_REPID_NDX
  ON BR_REPORT_MAPPING (REP_ID ASC);

CREATE UNIQUE INDEX BR_REPORT_MAPPING_PK
  ON BR_REPORT_MAPPING (BR_ID, REP_ID);

ALTER TABLE BR_REPORT_MAPPING
  ADD CONSTRAINT BR_REP_MAP_NDX
  PRIMARY KEY (BR_ID, REP_ID);

CREATE
   TABLESPACE DBBZ115
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE BR_REPORT_DATA_MAPPING
  (
     BR_ID    BIGINT NOT NULL,
     REP_D_ID BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ115;

CREATE INDEX BR_REP_D_MAP_BRID_NDX
  ON BR_REPORT_DATA_MAPPING (BR_ID ASC);

CREATE INDEX BR_REP_D_MAP_REPDID_NDX
  ON BR_REPORT_DATA_MAPPING (REP_D_ID ASC);

CREATE UNIQUE INDEX BR_REPORT_DATA_MAPPING_PK
  ON BR_REPORT_DATA_MAPPING (BR_ID, REP_D_ID);

ALTER TABLE BR_REPORT_DATA_MAPPING
  ADD CONSTRAINT BR_REP_D_MAP_NDX
  PRIMARY KEY (BR_ID, REP_D_ID);

CREATE
   TABLESPACE DBBZ116
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE BR_ATTACHMENT_MAPPING
  (
     BR_ID         BIGINT NOT NULL,
     ATTACHMENT_ID BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ116;

CREATE INDEX BR_ATTACHMENT_MAP_BRID_NDX
  ON BR_ATTACHMENT_MAPPING (BR_ID ASC);

CREATE INDEX BR_ATTACHMENT_MAP_ATTACHMENTID_NDX
  ON BR_ATTACHMENT_MAPPING (ATTACHMENT_ID ASC);

CREATE UNIQUE INDEX BR_ATTACHMENT_MAPPING_PK
  ON BR_ATTACHMENT_MAPPING (BR_ID, ATTACHMENT_ID);

ALTER TABLE BR_ATTACHMENT_MAPPING
  ADD CONSTRAINT BR_ATTACHMENT_MAP_NDX
  PRIMARY KEY (BR_ID, ATTACHMENT_ID);

CREATE
   TABLESPACE DBBZ117
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE BR_PROP_MAPPING
  (
     BR_ID   BIGINT NOT NULL,
     PROP_ID BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ117;

CREATE INDEX BR_PROP_MAP_BRID_NDX
  ON BR_PROP_MAPPING (BR_ID ASC);

CREATE INDEX BR_PROP_MAP_PROPID_NDX
  ON BR_PROP_MAPPING (PROP_ID ASC);

CREATE UNIQUE INDEX BR_PROP_MAPPING_PK
  ON BR_PROP_MAPPING (BR_ID, PROP_ID);

ALTER TABLE BR_PROP_MAPPING
  ADD CONSTRAINT BR_PROP_MAP_NDX
  PRIMARY KEY (BR_ID, PROP_ID);

CREATE
   TABLESPACE DBBZ118
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE A_CONTENT_MAPPING
  (
     A_ID       BIGINT NOT NULL,
     CONTENT_ID BIGINT NOT NULL
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ118;

CREATE INDEX A_CONTENT_MAP_AID_NDX
  ON A_CONTENT_MAPPING (A_ID ASC);

CREATE INDEX A_CONTENT_MAP_CONTENTID_NDX
  ON A_CONTENT_MAPPING (CONTENT_ID ASC);

CREATE UNIQUE INDEX A_CONTENT_MAPPING_PK
  ON A_CONTENT_MAPPING (A_ID, CONTENT_ID);

ALTER TABLE A_CONTENT_MAPPING
  ADD CONSTRAINT A_CONTENT_MAP_NDX
  PRIMARY KEY (A_ID, CONTENT_ID);

CREATE UNIQUE INDEX COLLECTION_CNAME_PK
  ON "COLLECTION" (C_NAME);

ALTER TABLE "COLLECTION"
  ADD CONSTRAINT UNQ_COLLECTION_0 UNIQUE (C_NAME);

CREATE UNIQUE INDEX BUILD_RESULT_GROUP_LABEL_PK
  ON BUILD_RESULT (BR_GROUP, BR_LABEL);

ALTER TABLE BUILD_RESULT
  ADD CONSTRAINT UNQ_BUILD_RESULT_0
  UNIQUE (BR_GROUP, BR_LABEL);

CREATE UNIQUE INDEX PERMISSIONS_GROUP_MG_ID_PK
  ON PERMISSIONS (P_MANAGED_ID);

ALTER TABLE PERMISSIONS
  ADD CONSTRAINT UNQ_PERMISSIONS_0
  UNIQUE (P_MANAGED_ID);

ALTER TABLE "COLLECTION"
  ADD CONSTRAINT CLLCTONPRMSSONSCID
  FOREIGN KEY (PERMISSIONS_C_ID)
  REFERENCES PERMISSIONS (C_ID);

ALTER TABLE BUILD_RESULT
  ADD CONSTRAINT BLDRSLTPRMSSONSCID
  FOREIGN KEY (PERMISSIONS_C_ID)
  REFERENCES PERMISSIONS (C_ID);

ALTER TABLE LOGICAL_FILE
  ADD CONSTRAINT LOGICALFILELANG_ID
  FOREIGN KEY (LANG_ID) REFERENCES
  LF_LANGUAGES (C_ID);

ALTER TABLE LOGICAL_DEPENDENCY
  ADD CONSTRAINT LGCLDPNDENCYLBRRYD
  FOREIGN KEY (LIBRARY_ID) REFERENCES
  LD_LIBRARIES (C_ID);

ALTER TABLE LOGICAL_DEPENDENCY
  ADD CONSTRAINT LGCLDPNDENCYCTGRYD
  FOREIGN KEY (CATEGORY_ID) REFERENCES
  LD_CATEGORIES (C_ID);

ALTER TABLE LF_DEP_MAPPING
  ADD CONSTRAINT LFDEPMAPPINGDEP_ID
  FOREIGN KEY (DEP_ID) REFERENCES
  LOGICAL_DEPENDENCY (C_ID);

ALTER TABLE LF_DEP_MAPPING
  ADD CONSTRAINT LFDEP_MAPPINGLF_ID
  FOREIGN KEY (LF_ID) REFERENCES
  LOGICAL_FILE (C_ID);

ALTER TABLE COL_LF_MAPPING
  ADD CONSTRAINT CLLFMPPINGCLLCTNID
  FOREIGN KEY (COLLECTION_ID)
  REFERENCES "COLLECTION" (C_ID);

ALTER TABLE COL_LF_MAPPING
  ADD CONSTRAINT COLLF_MAPPINGLF_ID
  FOREIGN KEY (LF_ID) REFERENCES
  LOGICAL_FILE (C_ID);

ALTER TABLE BR_REPORT_MAPPING
  ADD CONSTRAINT BRRPORTMAPPINGRPID
  FOREIGN KEY (REP_ID) REFERENCES
  ARTIFACT (C_ID);

ALTER TABLE BR_REPORT_MAPPING
  ADD CONSTRAINT BRREPORTMAPPINGBRD
  FOREIGN KEY (BR_ID) REFERENCES
  BUILD_RESULT (C_ID);

ALTER TABLE BR_REPORT_DATA_MAPPING
  ADD CONSTRAINT BRRPRTDTMPPINGRPDD
  FOREIGN KEY (REP_D_ID) REFERENCES
  ARTIFACT (C_ID);

ALTER TABLE BR_REPORT_DATA_MAPPING
  ADD CONSTRAINT BRRPRTDTMAPPINGBRD
  FOREIGN KEY (BR_ID) REFERENCES
  BUILD_RESULT (C_ID);

ALTER TABLE BR_ATTACHMENT_MAPPING
  ADD CONSTRAINT BRATTACHMENTMAPPINGATTACHMENT_ID
  FOREIGN KEY (ATTACHMENT_ID) REFERENCES ARTIFACT (C_ID);

ALTER TABLE BR_ATTACHMENT_MAPPING
  ADD CONSTRAINT BRATTACHMENT_MAPPINGBR_ID
  FOREIGN KEY (BR_ID)
  REFERENCES BUILD_RESULT (C_ID);

ALTER TABLE BR_PROP_MAPPING
  ADD CONSTRAINT BRPROPMAPPINGPRPID
  FOREIGN KEY (PROP_ID) REFERENCES
  BUILD_RESULT_PROPERTY (C_ID);

ALTER TABLE BR_PROP_MAPPING
  ADD CONSTRAINT BRPROPMAPPINGBR_ID
  FOREIGN KEY (BR_ID) REFERENCES
  BUILD_RESULT (C_ID);

ALTER TABLE A_CONTENT_MAPPING
  ADD CONSTRAINT CNTNTMAPPINGCNTNTD
  FOREIGN KEY (CONTENT_ID) REFERENCES
  ARTIFACT_CONTENT (C_ID);

ALTER TABLE A_CONTENT_MAPPING
  ADD CONSTRAINT ACONTENTMAPPINGAID
  FOREIGN KEY (A_ID) REFERENCES
  ARTIFACT (C_ID);

CREATE
   TABLESPACE DBBZ119
      IN DBBZ001
      USING STOGROUP DBBSTG
      PRIQTY -1
      SECQTY -1
      ERASE NO
      FREEPAGE 0
      PCTFREE 10
      GBPCACHE CHANGED
      COMPRESS NO
      LOGGED
      DSSIZE 4 G
      SEGSIZE 64
      MAXPARTITIONS 16
      BUFFERPOOL BP16K0
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE NO
      CCSID UNICODE
      MAXROWS 255
      INSERT ALGORITHM 0;

CREATE TABLE DBB_SEQ_TABLE
  (
     DBB_SEQ_NAME  VARCHAR(50) NOT NULL,
     DBB_SEQ_VALUE DECIMAL(15),
     PRIMARY KEY (DBB_SEQ_NAME)
  ) DATA CAPTURE NONE IN DBBZ001.DBBZ119;

CREATE UNIQUE INDEX DBB_SEQ_TABLE_PK
  ON DBB_SEQ_TABLE (DBB_SEQ_NAME);

INSERT INTO DBB_SEQ_TABLE (DBB_SEQ_NAME, DBB_SEQ_VALUE)
  VALUES ('DBB_ID_SEQ', 0);

INSERT INTO DBB_TABLE_VERSIONS (DBB_TBL_NAME, DBB_TBL_VERSION)
  VALUES ('COLLECTION', 2);

INSERT INTO DBB_TABLE_VERSIONS (DBB_TBL_NAME, DBB_TBL_VERSION)
  VALUES ('LOGICAL_FILE', 1);

INSERT INTO DBB_TABLE_VERSIONS (DBB_TBL_NAME, DBB_TBL_VERSION)
  VALUES ('LOGICAL_DEPENDENCY', 1);

INSERT INTO DBB_TABLE_VERSIONS (DBB_TBL_NAME, DBB_TBL_VERSION)
  VALUES ('ARTIFACT', 2);

INSERT INTO DBB_TABLE_VERSIONS (DBB_TBL_NAME, DBB_TBL_VERSION)
  VALUES ('BUILD_RESULT', 2);

INSERT INTO DBB_TABLE_VERSIONS (DBB_TBL_NAME, DBB_TBL_VERSION)
  VALUES ('PERMISSIONS', 2);