| 1 |
BEGIN TRANSACTION; |
| 2 |
CREATE TABLE dd_table ( |
| 3 |
data_source varchar NOT NULL, |
| 4 |
owner varchar, |
| 5 |
table_name varchar NOT NULL, |
| 6 |
table_type varchar NOT NULL, |
| 7 |
er_type varchar NOT NULL, |
| 8 |
last_ddl_time timestamp, |
| 9 |
last_object_revision timestamp NOT NULL, |
| 10 |
remarks varchar, |
| 11 |
PRIMARY KEY(data_source, table_name) |
| 12 |
); |
| 13 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_table_column','TABLE','entity',NULL,'2007-04-16 19:35:06',NULL); |
| 14 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','TABLE','entity',NULL,'2007-04-16 19:35:06',NULL); |
| 15 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','TABLE','entity',NULL,'2007-04-16 19:35:07',NULL); |
| 16 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','TABLE','entity',NULL,'2007-04-16 19:35:07',NULL); |
| 17 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','TABLE','entity',NULL,'2007-04-16 19:35:07',NULL); |
| 18 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_table','TABLE','entity',NULL,'2007-04-16 19:35:07',NULL); |
| 19 |
INSERT INTO "dd_table" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','TABLE','entity',NULL,'2007-04-16 19:35:06',NULL); |
| 20 |
CREATE TABLE dd_bitmap_index ( |
| 21 |
data_source varchar NOT NULL, |
| 22 |
owner varchar, |
| 23 |
table_name varchar NOT NULL, |
| 24 |
bitmap_index_name varchar NOT NULL, |
| 25 |
PRIMARY KEY (data_source, table_name, bitmap_index_name) |
| 26 |
); |
| 27 |
CREATE TABLE dd_table_column ( |
| 28 |
data_source varchar NOT NULL, |
| 29 |
owner varchar, |
| 30 |
table_name varchar NOT NULL, |
| 31 |
column_name varchar NOT NULL, |
| 32 |
data_type varchar NOT NULL, |
| 33 |
data_length varchar, |
| 34 |
nullable varchar NOT NULL, |
| 35 |
last_object_revision timestamp NOT NULL, |
| 36 |
remarks varchar, |
| 37 |
PRIMARY KEY(data_source, table_name, column_name) |
| 38 |
); |
| 39 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','last_object_revision','timestamp',NULL,'N','2007-04-16 19:35:07',''); |
| 40 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','table_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 41 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','data_source','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 42 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','owner','varchar',NULL,'Y','2007-04-16 19:35:07',''); |
| 43 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','rank','integer',NULL,'N','2007-04-16 19:35:07',''); |
| 44 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','owner','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 45 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','er_type','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 46 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','constraint_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 47 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','data_length','varchar',NULL,'Y','2007-04-16 19:35:06',''); |
| 48 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','column_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 49 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','table_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 50 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','last_object_revision','timestamp',NULL,'N','2007-04-16 19:35:06',''); |
| 51 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','bitmap_index_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 52 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','table_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 53 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','last_ddl_time','timestamp',NULL,'Y','2007-04-16 19:35:07',''); |
| 54 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','fk_constraint_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 55 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','nullable','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 56 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','data_source','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 57 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','data_type','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 58 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','table_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 59 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','owner','varchar',NULL,'Y','2007-04-16 19:35:06',''); |
| 60 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','owner','varchar',NULL,'Y','2007-04-16 19:35:07',''); |
| 61 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','data_source','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 62 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','r_table_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 63 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','remarks','varchar',NULL,'Y','2007-04-16 19:35:06',''); |
| 64 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','data_source','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 65 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','column_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 66 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','table_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 67 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','table_type','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 68 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','remarks','varchar',NULL,'Y','2007-04-16 19:35:07',''); |
| 69 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','r_table_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 70 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','owner','varchar',NULL,'Y','2007-04-16 19:35:06',''); |
| 71 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','data_source','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 72 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','r_owner','varchar',NULL,'Y','2007-04-16 19:35:07',''); |
| 73 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','table_name','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 74 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table','data_source','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 75 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','r_column_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 76 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','column_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 77 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','fk_constraint_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 78 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','column_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 79 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','owner','varchar',NULL,'Y','2007-04-16 19:35:07',''); |
| 80 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','data_source','varchar',NULL,'N','2007-04-16 19:35:06',''); |
| 81 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_table_column','owner','varchar',NULL,'Y','2007-04-16 19:35:06',''); |
| 82 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','last_object_revision','timestamp',NULL,'N','2007-04-16 19:35:07',''); |
| 83 |
INSERT INTO "dd_table_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','table_name','varchar',NULL,'N','2007-04-16 19:35:07',''); |
| 84 |
CREATE TABLE dd_pk_constraint_column ( |
| 85 |
data_source varchar NOT NULL, |
| 86 |
owner varchar, |
| 87 |
table_name varchar NOT NULL, |
| 88 |
column_name varchar NOT NULL, |
| 89 |
rank integer NOT NULL, |
| 90 |
PRIMARY KEY (data_source,table_name,column_name,rank) |
| 91 |
); |
| 92 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','column_name',4); |
| 93 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','data_source',1); |
| 94 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_table_column','table_name',2); |
| 95 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','table_name',2); |
| 96 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','table_name',2); |
| 97 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','table_name',2); |
| 98 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','column_name',4); |
| 99 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','rank',4); |
| 100 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','data_source',1); |
| 101 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_table_column','column_name',3); |
| 102 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','data_source',1); |
| 103 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','data_source',1); |
| 104 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','constraint_name',3); |
| 105 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','fk_constraint_name',4); |
| 106 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','fk_constraint_name',3); |
| 107 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_unique_constraint_column','table_name',2); |
| 108 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_pk_constraint_column','column_name',3); |
| 109 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','data_source',1); |
| 110 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_table','data_source',1); |
| 111 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_bitmap_index','bitmap_index_name',3); |
| 112 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_table','table_name',2); |
| 113 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_table_column','data_source',1); |
| 114 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint','r_table_name',3); |
| 115 |
INSERT INTO "dd_pk_constraint_column" VALUES('UR::DataSource::Meta','main','dd_fk_constraint_column','table_name',2); |
| 116 |
CREATE TABLE dd_unique_constraint_column ( |
| 117 |
data_source varchar NOT NULL, |
| 118 |
owner varchar, |
| 119 |
table_name varchar NOT NULL, |
| 120 |
constraint_name varchar NOT NULL, |
| 121 |
column_name varchar NOT NULL, |
| 122 |
PRIMARY KEY (data_source,table_name,constraint_name,column_name) |
| 123 |
); |
| 124 |
CREATE TABLE dd_fk_constraint ( |
| 125 |
data_source varchar NOT NULL, |
| 126 |
owner varchar, |
| 127 |
r_owner varchar, |
| 128 |
table_name varchar NOT NULL, |
| 129 |
r_table_name varchar NOT NULL, |
| 130 |
fk_constraint_name varchar NOT NULL, |
| 131 |
last_object_revision timestamp NOT NULL, |
| 132 |
PRIMARY KEY(data_source, table_name, r_table_name, fk_constraint_name) |
| 133 |
); |
| 134 |
CREATE TABLE dd_fk_constraint_column ( |
| 135 |
fk_constraint_name varchar NOT NULL, |
| 136 |
data_source varchar NOT NULL, |
| 137 |
owner varchar, |
| 138 |
table_name varchar NOT NULL, |
| 139 |
r_table_name varchar NOT NULL, |
| 140 |
column_name varchar NOT NULL, |
| 141 |
r_column_name varchar NOT NULL, |
| 142 |
|
| 143 |
PRIMARY KEY(data_source, table_name, fk_constraint_name, column_name) |
| 144 |
); |
| 145 |
COMMIT; |