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