Debian Codegraph @

t/alternate_namespace_layout/data_source/URTAlternate/DataSource/Meta.sqlite3-dump

raw
1 BEGIN TRANSACTION;
2 CREATE TABLE dd_bitmap_index (
3 data_source varchar NOT NULL,
4 owner varchar,
5 table_name varchar NOT NULL,
6 bitmap_index_name varchar NOT NULL,
7 PRIMARY KEY (data_source, owner, table_name, bitmap_index_name)
8 );
9 CREATE TABLE dd_fk_constraint (
10 data_source varchar NOT NULL,
11 owner varchar,
12 r_owner varchar,
13 table_name varchar NOT NULL,
14 r_table_name varchar NOT NULL,
15 fk_constraint_name varchar NOT NULL,
16 last_object_revision timestamp NOT NULL,
17 PRIMARY KEY(data_source, owner, r_owner, table_name, r_table_name, fk_constraint_name)
18 );
19 CREATE TABLE dd_fk_constraint_column (
20 fk_constraint_name varchar NOT NULL,
21 data_source varchar NOT NULL,
22 owner varchar,
23 table_name varchar NOT NULL,
24 r_table_name varchar NOT NULL,
25 column_name varchar NOT NULL,
26 r_column_name varchar NOT NULL,
27
28 PRIMARY KEY(data_source, owner, table_name, fk_constraint_name, column_name)
29 );
30 CREATE TABLE dd_pk_constraint_column (
31 data_source varchar NOT NULL,
32 owner varchar,
33 table_name varchar NOT NULL,
34 column_name varchar NOT NULL,
35 rank integer NOT NULL,
36 PRIMARY KEY (data_source,owner,table_name,column_name,rank)
37 );
38 INSERT INTO "dd_pk_constraint_column" VALUES('URTAlternate::DataSource::TheDB','main','car','car_id',1);
39 INSERT INTO "dd_pk_constraint_column" VALUES('URTAlternate::DataSource::TheDB','main','person','person_id',1);
40 CREATE TABLE dd_table (
41 data_source varchar NOT NULL,
42 owner varchar,
43 table_name varchar NOT NULL,
44 table_type varchar NOT NULL,
45 er_type varchar NOT NULL,
46 last_ddl_time timestamp,
47 last_object_revision timestamp NOT NULL,
48 remarks varchar,
49 PRIMARY KEY(data_source, owner, table_name)
50 );
51 INSERT INTO "dd_table" VALUES('URTAlternate::DataSource::TheDB','main','car','TABLE','entity',NULL,'2011-04-20 17:07:18',NULL);
52 INSERT INTO "dd_table" VALUES('URTAlternate::DataSource::TheDB','main','person','TABLE','entity',NULL,'2011-04-20 17:07:18',NULL);
53 CREATE TABLE dd_table_column (
54 data_source varchar NOT NULL,
55 owner varchar,
56 table_name varchar NOT NULL,
57 column_name varchar NOT NULL,
58 data_type varchar NOT NULL,
59 data_length varchar,
60 nullable varchar NOT NULL,
61 last_object_revision timestamp NOT NULL,
62 remarks varchar,
63 PRIMARY KEY(data_source, owner, table_name, column_name)
64 );
65 INSERT INTO "dd_table_column" VALUES('URTAlternate::DataSource::TheDB','main','car','model','varchar',NULL,'N','2011-04-20 17:07:18','');
66 INSERT INTO "dd_table_column" VALUES('URTAlternate::DataSource::TheDB','main','person','name','varchar',NULL,'N','2011-04-20 17:07:18','');
67 INSERT INTO "dd_table_column" VALUES('URTAlternate::DataSource::TheDB','main','car','car_id','integer',NULL,'N','2011-04-20 17:07:18','');
68 INSERT INTO "dd_table_column" VALUES('URTAlternate::DataSource::TheDB','main','person','person_id','integer',NULL,'N','2011-04-20 17:07:18','');
69 INSERT INTO "dd_table_column" VALUES('URTAlternate::DataSource::TheDB','main','car','make','varchar',NULL,'N','2011-04-20 17:07:18','');
70 CREATE TABLE dd_unique_constraint_column (
71 data_source varchar NOT NULL,
72 owner varchar,
73 table_name varchar NOT NULL,
74 constraint_name varchar NOT NULL,
75 column_name varchar NOT NULL,
76 PRIMARY KEY (data_source,owner,table_name,constraint_name,column_name)
77 );
78 COMMIT;