Debian Codegraph @

lib/UR/DataSource/Meta.sqlite3-dump

raw
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;