| 250 |
kaklik |
1 |
<?php |
|
|
2 |
/* $Id: information_schema_relations.lib.php,v 2.0 2005/03/27 23:23:39 rabus Exp $ */ |
|
|
3 |
// vim: expandtab sw=4 ts=4 sts=4: |
|
|
4 |
|
|
|
5 |
$GLOBALS['information_schema_relations'] = array( |
|
|
6 |
'CHARACTER_SETS' => array( |
|
|
7 |
'DEFAULT_COLLATE_NAME' => array( |
|
|
8 |
'foreign_db' => 'information_schema', |
|
|
9 |
'foreign_table' => 'COLLATIONS', |
|
|
10 |
'foreign_field' => 'COLLATION_NAME' |
|
|
11 |
) |
|
|
12 |
), |
|
|
13 |
'COLLATIONS' => array( |
|
|
14 |
'CHARACTER_SET_NAME' => array( |
|
|
15 |
'foreign_db' => 'information_schema', |
|
|
16 |
'foreign_table' => 'CHARACTER_SETS', |
|
|
17 |
'foreign_field' => 'CHARACTER_SET_NAME' |
|
|
18 |
) |
|
|
19 |
), |
|
|
20 |
'COLLATION_CHARACTER_SET_APPLICABILITY' => array( |
|
|
21 |
'CHARACTER_SET_NAME' => array( |
|
|
22 |
'foreign_db' => 'information_schema', |
|
|
23 |
'foreign_table' => 'CHARACTER_SETS', |
|
|
24 |
'foreign_field' => 'CHARACTER_SET_NAME' |
|
|
25 |
), |
|
|
26 |
'COLLATION_NAME' => array( |
|
|
27 |
'foreign_db' => 'information_schema', |
|
|
28 |
'foreign_table' => 'COLLATIONS', |
|
|
29 |
'foreign_field' => 'COLLATION_NAME' |
|
|
30 |
) |
|
|
31 |
), |
|
|
32 |
'COLUMNS' => array( |
|
|
33 |
'TABLE_SCHEMA' => array( |
|
|
34 |
'foreign_db' => 'information_schema', |
|
|
35 |
'foreign_table' => 'SCHEMATA', |
|
|
36 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
37 |
), |
|
|
38 |
'CHARACTER_SET_NAME' => array( |
|
|
39 |
'foreign_db' => 'information_schema', |
|
|
40 |
'foreign_table' => 'CHARACTER_SETS', |
|
|
41 |
'foreign_field' => 'CHARACTER_SET_NAME' |
|
|
42 |
), |
|
|
43 |
'COLLATION_NAME' => array( |
|
|
44 |
'foreign_db' => 'information_schema', |
|
|
45 |
'foreign_table' => 'COLLATIONS', |
|
|
46 |
'foreign_field' => 'COLLATION_NAME' |
|
|
47 |
) |
|
|
48 |
), |
|
|
49 |
'COLUMN_PRIVILEGES' => array( |
|
|
50 |
'TABLE_SCHEMA' => array( |
|
|
51 |
'foreign_db' => 'information_schema', |
|
|
52 |
'foreign_table' => 'SCHEMATA', |
|
|
53 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
54 |
) |
|
|
55 |
), |
|
|
56 |
'KEY_COLUMN_USAGE' => array( |
|
|
57 |
'CONSTRAINT_SCHEMA' => array( |
|
|
58 |
'foreign_db' => 'information_schema', |
|
|
59 |
'foreign_table' => 'SCHEMATA', |
|
|
60 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
61 |
), |
|
|
62 |
'TABLE_SCHEMA' => array( |
|
|
63 |
'foreign_db' => 'information_schema', |
|
|
64 |
'foreign_table' => 'SCHEMATA', |
|
|
65 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
66 |
) |
|
|
67 |
), |
|
|
68 |
'ROUTINES' => array( |
|
|
69 |
'ROUTINE_SCHEMA' => array( |
|
|
70 |
'foreign_db' => 'information_schema', |
|
|
71 |
'foreign_table' => 'SCHEMATA', |
|
|
72 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
73 |
) |
|
|
74 |
), |
|
|
75 |
'SCHEMATA' => array( |
|
|
76 |
'DEFAULT_CHARACTER_SET_NAME' => array( |
|
|
77 |
'foreign_db' => 'information_schema', |
|
|
78 |
'foreign_table' => 'CHARACTER_SETS', |
|
|
79 |
'foreign_field' => 'CHARACTER_SET_NAME' |
|
|
80 |
) |
|
|
81 |
), |
|
|
82 |
'SCHEMA_PRIVILEGES' => array( |
|
|
83 |
'TABLE_SCHEMA' => array( |
|
|
84 |
'foreign_db' => 'information_schema', |
|
|
85 |
'foreign_table' => 'SCHEMATA', |
|
|
86 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
87 |
) |
|
|
88 |
), |
|
|
89 |
'TABLES' => array( |
|
|
90 |
'TABLE_SCHEMA' => array( |
|
|
91 |
'foreign_db' => 'information_schema', |
|
|
92 |
'foreign_table' => 'SCHEMATA', |
|
|
93 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
94 |
), |
|
|
95 |
'TABLE_COLLATION' => array( |
|
|
96 |
'foreign_db' => 'information_schema', |
|
|
97 |
'foreign_table' => 'COLLATIONS', |
|
|
98 |
'foreign_field' => 'COLLATION_NAME' |
|
|
99 |
) |
|
|
100 |
), |
|
|
101 |
'TABLE_CONSTRAINTS' => array( |
|
|
102 |
'CONSTRAINT_SCHEMA' => array( |
|
|
103 |
'foreign_db' => 'information_schema', |
|
|
104 |
'foreign_table' => 'SCHEMATA', |
|
|
105 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
106 |
), |
|
|
107 |
'TABLE_SCHEMA' => array( |
|
|
108 |
'foreign_db' => 'information_schema', |
|
|
109 |
'foreign_table' => 'SCHEMATA', |
|
|
110 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
111 |
) |
|
|
112 |
), |
|
|
113 |
'TABLE_PRIVILEGES' => array( |
|
|
114 |
'TABLE_SCHEMA' => array( |
|
|
115 |
'foreign_db' => 'information_schema', |
|
|
116 |
'foreign_table' => 'SCHEMATA', |
|
|
117 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
118 |
) |
|
|
119 |
), |
|
|
120 |
'VIEWS' => array( |
|
|
121 |
'TABLE_SCHEMA' => array( |
|
|
122 |
'foreign_db' => 'information_schema', |
|
|
123 |
'foreign_table' => 'SCHEMATA', |
|
|
124 |
'foreign_field' => 'SCHEMA_NAME' |
|
|
125 |
) |
|
|
126 |
) |
|
|
127 |
); |
|
|
128 |
|
|
|
129 |
?> |