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;