text: DROP SCHEMA IF EXISTS bss_test CASCADE;
  
  CREATE SCHEMA bss_test;
  
  CREATE TABLE bss_test.integration_test (
    test_key    BIGSERIAL PRIMARY KEY,
    some_long   BIGINT           NOT NULL,
    some_int    INTEGER          NOT NULL,
    some_short  SMALLINT         NOT NULL,
    some_double DOUBLE PRECISION NOT NULL,
    some_float  REAL             NOT NULL,
    some_bool   BOOLEAN          NOT NULL,
    some_string VARCHAR,
    some_bd     NUMERIC,
    some_time   TIME,
    some_date   DATE,
    some_dtm    TIMESTAMP
  );
  
  CREATE TABLE bss_test.composite_key_test (
    key_a       BIGSERIAL,
    key_b       BIGSERIAL,
    some_long   BIGINT  NOT NULL,
    some_int    INTEGER NOT NULL,
    some_string VARCHAR,
    PRIMARY KEY (key_a, key_b)
  );
  