BEGIN TRANSACTION;
CREATE TABLE dd_table (
     data_source varchar NOT NULL,
     owner varchar,
     table_name varchar NOT NULL,
     table_type varchar NOT NULL,
     er_type varchar NOT NULL,
     last_ddl_time timestamp,
     last_object_revision timestamp NOT NULL,
     remarks varchar,
     PRIMARY KEY(data_source, owner, table_name)
);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'TABLE', 'entity', NULL, '2007-04-16 19:35:06', NULL);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'TABLE', 'entity', NULL, '2007-04-16 19:35:06', NULL);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'TABLE', 'entity', NULL, '2007-04-16 19:35:07', NULL);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'TABLE', 'entity', NULL, '2007-04-16 19:35:07', NULL);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'TABLE', 'entity', NULL, '2007-04-16 19:35:07', NULL);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'TABLE', 'entity', NULL, '2007-04-16 19:35:07', NULL);
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'TABLE', 'entity', NULL, '2007-04-16 19:35:06', NULL);
CREATE TABLE dd_bitmap_index (
    data_source varchar NOT NULL,
    owner varchar,
    table_name varchar NOT NULL,
    bitmap_index_name varchar NOT NULL,
    PRIMARY KEY (data_source, owner, table_name, bitmap_index_name)
);
CREATE TABLE dd_table_column (
    data_source varchar NOT NULL,
    owner varchar,
    table_name varchar NOT NULL,
    column_name varchar NOT NULL,
    data_type varchar NOT NULL,
    data_length varchar,
    nullable varchar NOT NULL,
    last_object_revision timestamp NOT NULL,
    remarks varchar,
    PRIMARY KEY(data_source, owner, table_name, column_name)
);
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'last_object_revision', 'timestamp', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'rank', 'integer', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'owner', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'er_type', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'constraint_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'data_length', 'varchar', NULL, 'Y', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'column_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'last_object_revision', 'timestamp', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'bitmap_index_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'last_ddl_time', 'timestamp', NULL, 'Y', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'fk_constraint_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'nullable', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'data_type', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'r_table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'remarks', 'varchar', NULL, 'Y', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'column_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'table_type', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'remarks', 'varchar', NULL, 'Y', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'r_table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'r_owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'r_column_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'column_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'fk_constraint_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'column_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'data_source', 'varchar', NULL, 'N', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'owner', 'varchar', NULL, 'Y', '2007-04-16 19:35:06', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'last_object_revision', 'timestamp', NULL, 'N', '2007-04-16 19:35:07', '');
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'table_name', 'varchar', NULL, 'N', '2007-04-16 19:35:07', '');
CREATE TABLE dd_pk_constraint_column (
    data_source varchar NOT NULL,
    owner varchar,
    table_name varchar NOT NULL,
    column_name varchar NOT NULL,
    rank integer NOT NULL,
    PRIMARY KEY (data_source,owner,table_name,column_name,rank)
);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'column_name', 5);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'table_name', 3);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'table_name', 4);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'table_name', 3);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'r_owner', 3);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'table_name', 3);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'column_name', 5);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'rank', 5);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'column_name', 4);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'constraint_name', 4);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'fk_constraint_name', 6);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'fk_constraint_name', 4);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'table_name', 3);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_unique_constraint_column', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_pk_constraint_column', 'column_name', 4);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_bitmap_index', 'bitmap_index_name', 4);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'table_name', 3);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table_column', 'data_source', 1);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_table', 'owner', 2);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint', 'r_table_name', 5);
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta', NULL, 'dd_fk_constraint_column', 'table_name', 3);
CREATE TABLE dd_unique_constraint_column (
    data_source varchar NOT NULL,
    owner varchar,
    table_name varchar NOT NULL,
    constraint_name varchar NOT NULL,
    column_name varchar NOT NULL,
    PRIMARY KEY (data_source,owner,table_name,constraint_name,column_name)
);
CREATE TABLE dd_fk_constraint (
    data_source varchar NOT NULL,
    owner varchar,
    r_owner varchar,
    table_name varchar NOT NULL,
    r_table_name varchar NOT NULL,
    fk_constraint_name varchar NOT NULL,
    last_object_revision timestamp NOT NULL,
    PRIMARY KEY(data_source, owner, r_owner, table_name, r_table_name, fk_constraint_name)
);
CREATE TABLE dd_fk_constraint_column (
    fk_constraint_name varchar NOT NULL,
    data_source varchar NOT NULL,
    owner varchar NOT NULL,
    table_name varchar NOT NULL,
    r_table_name varchar NOT NULL,
    column_name varchar NOT NULL,
    r_column_name varchar NOT NULL,
      
    PRIMARY KEY(data_source, owner, table_name, fk_constraint_name, column_name)
);
COMMIT;