text: DROP TABLE MANUAL;
  DROP TABLE LEGO_SET;
  
  DROP TABLE Child_No_Id;
  DROP TABLE ONE_TO_ONE_PARENT;
  
  DROP TABLE ELEMENT_NO_ID;
  DROP TABLE LIST_PARENT;
  
  DROP TABLE BYTE_ARRAY_OWNER;
  
  DROP TABLE CHAIN0;
  DROP TABLE CHAIN1;
  DROP TABLE CHAIN2;
  DROP TABLE CHAIN3;
  DROP TABLE CHAIN4;
  
  DROP TABLE NO_ID_CHAIN0;
  DROP TABLE NO_ID_CHAIN1;
  DROP TABLE NO_ID_CHAIN2;
  DROP TABLE NO_ID_CHAIN3;
  DROP TABLE NO_ID_CHAIN4;
  
  DROP TABLE NO_ID_MAP_CHAIN0;
  DROP TABLE NO_ID_MAP_CHAIN1;
  DROP TABLE NO_ID_MAP_CHAIN2;
  DROP TABLE NO_ID_MAP_CHAIN3;
  DROP TABLE NO_ID_MAP_CHAIN4;
  
  DROP TABLE NO_ID_LIST_CHAIN0;
  DROP TABLE NO_ID_LIST_CHAIN1;
  DROP TABLE NO_ID_LIST_CHAIN2;
  DROP TABLE NO_ID_LIST_CHAIN3;
  DROP TABLE NO_ID_LIST_CHAIN4;
  
  DROP TABLE WITH_READ_ONLY;
  DROP TABLE VERSIONED_AGGREGATE;
  DROP TABLE WITH_LOCAL_DATE_TIME;
  
  DROP TABLE WITH_ID_ONLY;
  
  CREATE TABLE LEGO_SET
  (
    "id1"  BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
    NAME VARCHAR(30)
  );
  CREATE TABLE MANUAL
  (
    "id2"         BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
    LEGO_SET    BIGINT,
    "alternative" BIGINT,
    CONTENT     VARCHAR(2000)
  );
  
  ALTER TABLE MANUAL
    ADD FOREIGN KEY (LEGO_SET)
      REFERENCES LEGO_SET ("id1");
  
  CREATE TABLE ONE_TO_ONE_PARENT
  (
    "id3"     BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
    content VARCHAR(30)
  );
  CREATE TABLE Child_No_Id
  (
    ONE_TO_ONE_PARENT INTEGER NOT NULL PRIMARY KEY,
    content           VARCHAR(30)
  );
  
  CREATE TABLE LIST_PARENT
  (
    "id4"  BIGINT GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 ) PRIMARY KEY,
    NAME VARCHAR(100)
  );
  CREATE TABLE ELEMENT_NO_ID
  (
    CONTENT         VARCHAR(100),
    LIST_PARENT_KEY BIGINT,
    LIST_PARENT     BIGINT
  );
  ALTER TABLE ELEMENT_NO_ID
    ADD FOREIGN KEY (LIST_PARENT)
      REFERENCES LIST_PARENT ("id4");
  --
  -- CREATE TABLE ARRAY_OWNER
  -- (
  --   ID               BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
  --   DIGITS           VARCHAR(20) ARRAY[10] NOT NULL,
  --   MULTIDIMENSIONAL VARCHAR(20) ARRAY[10] NULL
  -- );
  
  CREATE TABLE BYTE_ARRAY_OWNER
  (
    ID          BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
    BINARY_DATA VARBINARY(20) NOT NULL
  );
  
  CREATE TABLE CHAIN4
  (
    FOUR       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 40) PRIMARY KEY,
    FOUR_VALUE VARCHAR(20)
  );
  
  CREATE TABLE CHAIN3
  (
    THREE       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 30) PRIMARY KEY,
    THREE_VALUE VARCHAR(20),
    CHAIN4      BIGINT,
    FOREIGN KEY (CHAIN4) REFERENCES CHAIN4 (FOUR)
  );
  
  CREATE TABLE CHAIN2
  (
    TWO       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 20) PRIMARY KEY,
    TWO_VALUE VARCHAR(20),
    CHAIN3    BIGINT,
    FOREIGN KEY (CHAIN3) REFERENCES CHAIN3 (THREE)
  );
  
  CREATE TABLE CHAIN1
  (
    ONE       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 10) PRIMARY KEY,
    ONE_VALUE VARCHAR(20),
    CHAIN2    BIGINT,
    FOREIGN KEY (CHAIN2) REFERENCES CHAIN2 (TWO)
  );
  
  CREATE TABLE CHAIN0
  (
    ZERO       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 0) PRIMARY KEY,
    ZERO_VALUE VARCHAR(20),
    CHAIN1     BIGINT,
    FOREIGN KEY (CHAIN1) REFERENCES CHAIN1 (ONE)
  );
  
  CREATE TABLE NO_ID_CHAIN4
  (
    FOUR       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 40) PRIMARY KEY,
    FOUR_VALUE VARCHAR(20)
  );
  
  CREATE TABLE NO_ID_CHAIN3
  (
    THREE_VALUE  VARCHAR(20),
    NO_ID_CHAIN4 BIGINT,
    FOREIGN KEY (NO_ID_CHAIN4) REFERENCES NO_ID_CHAIN4 (FOUR)
  );
  
  CREATE TABLE NO_ID_CHAIN2
  (
    TWO_VALUE    VARCHAR(20),
    NO_ID_CHAIN4 BIGINT,
    FOREIGN KEY (NO_ID_CHAIN4) REFERENCES NO_ID_CHAIN4 (FOUR)
  );
  
  CREATE TABLE NO_ID_CHAIN1
  (
    ONE_VALUE    VARCHAR(20),
    NO_ID_CHAIN4 BIGINT,
    FOREIGN KEY (NO_ID_CHAIN4) REFERENCES NO_ID_CHAIN4 (FOUR)
  );
  
  CREATE TABLE NO_ID_CHAIN0
  (
    ZERO_VALUE   VARCHAR(20),
    NO_ID_CHAIN4 BIGINT,
    FOREIGN KEY (NO_ID_CHAIN4) REFERENCES NO_ID_CHAIN4 (FOUR)
  );
  
  
  CREATE TABLE NO_ID_LIST_CHAIN4
  (
    FOUR       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 40) PRIMARY KEY,
    FOUR_VALUE VARCHAR(20)
  );
  
  CREATE TABLE NO_ID_LIST_CHAIN3
  (
    THREE_VALUE           VARCHAR(20),
    NO_ID_LIST_CHAIN4     BIGINT NOT NULL,
    NO_ID_LIST_CHAIN4_KEY BIGINT NOT NULL,
    PRIMARY KEY (NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY),
    FOREIGN KEY (NO_ID_LIST_CHAIN4) REFERENCES NO_ID_LIST_CHAIN4 (FOUR)
  );
  
  CREATE TABLE NO_ID_LIST_CHAIN2
  (
    TWO_VALUE             VARCHAR(20),
    NO_ID_LIST_CHAIN4     BIGINT NOT NULL,
    NO_ID_LIST_CHAIN4_KEY BIGINT NOT NULL,
    NO_ID_LIST_CHAIN3_KEY BIGINT NOT NULL,
    PRIMARY KEY (NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY,
                 NO_ID_LIST_CHAIN3_KEY),
    FOREIGN KEY (
                 NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY
      ) REFERENCES NO_ID_LIST_CHAIN3 (
                                      NO_ID_LIST_CHAIN4,
                                      NO_ID_LIST_CHAIN4_KEY
      )
  );
  
  CREATE TABLE NO_ID_LIST_CHAIN1
  (
    ONE_VALUE             VARCHAR(20),
    NO_ID_LIST_CHAIN4     BIGINT NOT NULL,
    NO_ID_LIST_CHAIN4_KEY BIGINT NOT NULL,
    NO_ID_LIST_CHAIN3_KEY BIGINT NOT NULL,
    NO_ID_LIST_CHAIN2_KEY BIGINT NOT NULL,
    PRIMARY KEY (NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY,
                 NO_ID_LIST_CHAIN3_KEY,
                 NO_ID_LIST_CHAIN2_KEY),
    FOREIGN KEY (
                 NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY,
                 NO_ID_LIST_CHAIN3_KEY
      ) REFERENCES NO_ID_LIST_CHAIN2 (
                                      NO_ID_LIST_CHAIN4,
                                      NO_ID_LIST_CHAIN4_KEY,
                                      NO_ID_LIST_CHAIN3_KEY
      )
  );
  
  CREATE TABLE NO_ID_LIST_CHAIN0
  (
    ZERO_VALUE            VARCHAR(20),
    NO_ID_LIST_CHAIN4     BIGINT NOT NULL,
    NO_ID_LIST_CHAIN4_KEY BIGINT NOT NULL,
    NO_ID_LIST_CHAIN3_KEY BIGINT NOT NULL,
    NO_ID_LIST_CHAIN2_KEY BIGINT NOT NULL,
    NO_ID_LIST_CHAIN1_KEY BIGINT NOT NULL,
    PRIMARY KEY (NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY,
                 NO_ID_LIST_CHAIN3_KEY,
                 NO_ID_LIST_CHAIN2_KEY,
                 NO_ID_LIST_CHAIN1_KEY),
    FOREIGN KEY (
                 NO_ID_LIST_CHAIN4,
                 NO_ID_LIST_CHAIN4_KEY,
                 NO_ID_LIST_CHAIN3_KEY,
                 NO_ID_LIST_CHAIN2_KEY
      ) REFERENCES NO_ID_LIST_CHAIN1 (
                                      NO_ID_LIST_CHAIN4,
                                      NO_ID_LIST_CHAIN4_KEY,
                                      NO_ID_LIST_CHAIN3_KEY,
                                      NO_ID_LIST_CHAIN2_KEY
      )
  );
  
  
  
  
  CREATE TABLE NO_ID_MAP_CHAIN4
  (
    FOUR       BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 40) PRIMARY KEY,
    FOUR_VALUE VARCHAR(20)
  );
  
  CREATE TABLE NO_ID_MAP_CHAIN3
  (
    THREE_VALUE           VARCHAR(20),
    NO_ID_MAP_CHAIN4     BIGINT NOT NULL,
    NO_ID_MAP_CHAIN4_KEY VARCHAR(20) NOT NULL,
    PRIMARY KEY (NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY),
    FOREIGN KEY (NO_ID_MAP_CHAIN4) REFERENCES NO_ID_MAP_CHAIN4 (FOUR)
  );
  
  CREATE TABLE NO_ID_MAP_CHAIN2
  (
    TWO_VALUE             VARCHAR(20),
    NO_ID_MAP_CHAIN4     BIGINT NOT NULL,
    NO_ID_MAP_CHAIN4_KEY VARCHAR(20) NOT NULL,
    NO_ID_MAP_CHAIN3_KEY VARCHAR(20) NOT NULL,
    PRIMARY KEY (NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY,
                 NO_ID_MAP_CHAIN3_KEY),
    FOREIGN KEY (
                 NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY
      ) REFERENCES NO_ID_MAP_CHAIN3 (
                                      NO_ID_MAP_CHAIN4,
                                      NO_ID_MAP_CHAIN4_KEY
      )
  );
  
  CREATE TABLE NO_ID_MAP_CHAIN1
  (
    ONE_VALUE             VARCHAR(20),
    NO_ID_MAP_CHAIN4     BIGINT NOT NULL,
    NO_ID_MAP_CHAIN4_KEY VARCHAR(20) NOT NULL,
    NO_ID_MAP_CHAIN3_KEY VARCHAR(20) NOT NULL,
    NO_ID_MAP_CHAIN2_KEY VARCHAR(20) NOT NULL,
    PRIMARY KEY (NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY,
                 NO_ID_MAP_CHAIN3_KEY,
                 NO_ID_MAP_CHAIN2_KEY),
    FOREIGN KEY (
                 NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY,
                 NO_ID_MAP_CHAIN3_KEY
      ) REFERENCES NO_ID_MAP_CHAIN2 (
                                      NO_ID_MAP_CHAIN4,
                                      NO_ID_MAP_CHAIN4_KEY,
                                      NO_ID_MAP_CHAIN3_KEY
      )
  );
  
  CREATE TABLE NO_ID_MAP_CHAIN0
  (
    ZERO_VALUE            VARCHAR(20),
    NO_ID_MAP_CHAIN4     BIGINT NOT NULL,
    NO_ID_MAP_CHAIN4_KEY VARCHAR(20) NOT NULL,
    NO_ID_MAP_CHAIN3_KEY VARCHAR(20) NOT NULL,
    NO_ID_MAP_CHAIN2_KEY VARCHAR(20) NOT NULL,
    NO_ID_MAP_CHAIN1_KEY VARCHAR(20) NOT NULL,
    PRIMARY KEY (NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY,
                 NO_ID_MAP_CHAIN3_KEY,
                 NO_ID_MAP_CHAIN2_KEY,
                 NO_ID_MAP_CHAIN1_KEY),
    FOREIGN KEY (
                 NO_ID_MAP_CHAIN4,
                 NO_ID_MAP_CHAIN4_KEY,
                 NO_ID_MAP_CHAIN3_KEY,
                 NO_ID_MAP_CHAIN2_KEY
      ) REFERENCES NO_ID_MAP_CHAIN1 (
                                      NO_ID_MAP_CHAIN4,
                                      NO_ID_MAP_CHAIN4_KEY,
                                      NO_ID_MAP_CHAIN3_KEY,
                                      NO_ID_MAP_CHAIN2_KEY
      )
  );
  
  CREATE TABLE WITH_READ_ONLY (
      ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 40) PRIMARY KEY,
      NAME VARCHAR(200),
      READ_ONLY VARCHAR(200) DEFAULT 'from-db'
  );
  
  CREATE TABLE VERSIONED_AGGREGATE
  (
    ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,
    VERSION BIGINT
  );
  
  
  CREATE TABLE WITH_LOCAL_DATE_TIME
  (
    ID BIGINT NOT NULL PRIMARY KEY,
    TEST_TIME TIMESTAMP(9)
  );
  
  CREATE TABLE WITH_ID_ONLY
  (
    ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY
  );