|
1 package com.daffodilwoods.daffodildb.server.datadictionarysystem;
2
3 import com.daffodilwoods.daffodildb.server.datasystem.interfaces.*;
4 import com.daffodilwoods.database.general.*;
5 import com.daffodilwoods.database.resource.*;
6 import com.daffodilwoods.database.utility.*;
7
8
16
17 public class SystemIndexInformation {
18 private SystemIndexInformation(){
19 }
20
21 public static void createAllSystemTableIndexes(_IndexDatabase database) throws DException {
22 _DatabaseUser user = database.getDatabaseUser();
23 try {
24 database.createPermanantIndex(SystemTables.users_TableName, "SYSTEM_INDEX_1", new IndexInformation(SystemTables.users_TableName, "SYSTEM_INDEX_1", "SYSTEM_INDEX_1_Index", new String  [] {"USER_NAME", SystemFields.systemFields[SystemFields.rowId]}
25 , new int[] {5, 0}
26 , new boolean[] {true, true}
27 , 0, 0, 0, 0, true, true), user);
28 database.createPermanantIndex(SystemTables.roles_TableName, "SYSTEM_INDEX_3", new IndexInformation(SystemTables.roles_TableName, "SYSTEM_INDEX_3", "SYSTEM_INDEX_3_Index", new String [] {"ROLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
29 , new int[] {5, 0}
30 , new boolean[] {true, true}
31 , 0, 0, 0, 0, true, true), user);
32 database.createPermanantIndex(SystemTables.role_authorization_TableName, "SYSTEM_INDEX_5", new IndexInformation(SystemTables.role_authorization_TableName, "SYSTEM_INDEX_5", "SYSTEM_INDEX_5_Index", new String [] {"ROLE_NAME", "GRANTEE", SystemFields.systemFields[SystemFields.rowId]}
33 , new int[] {5, 6, 0}
34 , new boolean[] {true, true, true}
35 , 0, 0, 0, 0, true, true), user);
36 database.createPermanantIndex(SystemTables.schema_TableName, "SYSTEM_INDEX_7", new IndexInformation(SystemTables.schema_TableName, "SYSTEM_INDEX_7", "SYSTEM_INDEX_7_Index", new String [] {"CATALOG_NAME", "SCHEMA_NAME", SystemFields.systemFields[SystemFields.rowId]}
37 , new int[] {5, 6, 0}
38 , new boolean[] {true, true, true}
39 , 0, 0, 0, 0, true, true), user);
40 database.createPermanantIndex(SystemTables.characterSets_TableName, "SYSTEM_INDEX_9", new IndexInformation(SystemTables.characterSets_TableName, "SYSTEM_INDEX_9", "SYSTEM_INDEX_9_Index", new String [] {"CHARACTER_SET_CATALOG", "CHARACTER_SET_SCHEMA", "CHARACTER_SET_NAME", SystemFields.systemFields[SystemFields.rowId]}
41 , new int[] {5, 6, 7, 0}
42 , new boolean[] {true, true, true, true}
43 , 0, 0, 0, 0, true, true), user);
44 database.createPermanantIndex(SystemTables.collations_TableName, "SYSTEM_INDEX_11", new IndexInformation(SystemTables.collations_TableName, "SYSTEM_INDEX_11", "SYSTEM_INDEX_11_Index", new String [] {"COLLATION_CATALOG", "COLLATION_SCHEMA", "COLLATION_NAME", SystemFields.systemFields[SystemFields.rowId]}
45 , new int[] {5, 6, 7, 0}
46 , new boolean[] {true, true, true, true}
47 , 0, 0, 0, 0, true, true), user);
48 database.createPermanantIndex(SystemTables.domains_TableName, "SYSTEM_INDEX_13", new IndexInformation(SystemTables.domains_TableName, "SYSTEM_INDEX_13", "SYSTEM_INDEX_13_Index", new String [] {"DOMAIN_CATALOG", "DOMAIN_SCHEMA", "DOMAIN_NAME", SystemFields.systemFields[SystemFields.rowId]}
49 , new int[] {5, 6, 7, 0}
50 , new boolean[] {true, true, true, true}
51 , 0, 0, 0, 0, true, true), user);
52 database.createPermanantIndex(SystemTables.tables_TableName, "SYSTEM_INDEX_15", new IndexInformation(SystemTables.tables_TableName, "SYSTEM_INDEX_15", "SYSTEM_INDEX_15_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
53 , new int[] {5, 6, 7, 0}
54 , new boolean[] {true, true, true, true}
55 , 0, 0, 0, 0, true, true), user);
56 database.createPermanantIndex(SystemTables.columns_TableName, "SYSTEM_INDEX_17", new IndexInformation(SystemTables.columns_TableName, "SYSTEM_INDEX_17", "SYSTEM_INDEX_17_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
57 , new int[] {5, 6, 7, 8, 0}
58 , new boolean[] {true, true, true, true, true}
59 , 0, 0, 0, 0, true, true), user);
60 database.createPermanantIndex(SystemTables.columns_TableName, "SYSTEM_INDEX_18", new IndexInformation(SystemTables.columns_TableName, "SYSTEM_INDEX_18", "SYSTEM_INDEX_18_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "ORDINAL_POSITION", SystemFields.systemFields[SystemFields.rowId]}
61 , new int[] {5, 6, 7, 9, 0}
62 , new boolean[] {true, true, true, true, true}
63 , 0, 0, 0, 0, true, true), user);
64 database.createPermanantIndex(SystemTables.dataTypeDescriptor_TableName, "SYSTEM_INDEX_20", new IndexInformation(SystemTables.dataTypeDescriptor_TableName, "SYSTEM_INDEX_20", "SYSTEM_INDEX_20_Index", new String [] {"OBJECT_CATALOG", "OBJECT_SCHEMA", "OBJECT_NAME", "OBJECT_TYPE", "DTD_IDENTIFIER", SystemFields.systemFields[SystemFields.rowId]}
65 , new int[] {5, 6, 7, 8, 9, 0}
66 , new boolean[] {true, true, true, true, true, true}
67 , 0, 0, 0, 0, true, true), user);
68 database.createPermanantIndex(SystemTables.table_constraints_TableName, "SYSTEM_INDEX_22", new IndexInformation(SystemTables.table_constraints_TableName, "SYSTEM_INDEX_22", "SYSTEM_INDEX_22_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", SystemFields.systemFields[SystemFields.rowId]}
69 , new int[] {5, 6, 7, 0}
70 , new boolean[] {true, true, true, true}
71 , 0, 0, 0, 0, true, true), user);
72 database.createPermanantIndex(SystemTables.key_column_usage_TableName, "SYSTEM_INDEX_24", new IndexInformation(SystemTables.key_column_usage_TableName, "SYSTEM_INDEX_24", "SYSTEM_INDEX_24_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
73 , new int[] {5, 6, 7, 11, 0}
74 , new boolean[] {true, true, true, true, true}
75 , 0, 0, 0, 0, true, true), user);
76 database.createPermanantIndex(SystemTables.key_column_usage_TableName, "SYSTEM_INDEX_25", new IndexInformation(SystemTables.key_column_usage_TableName, "SYSTEM_INDEX_25", "SYSTEM_INDEX_25_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "ORDINAL_POSITION", SystemFields.systemFields[SystemFields.rowId]}
77 , new int[] {5, 6, 7, 12, 0}
78 , new boolean[] {true, true, true, true, true}
79 , 0, 0, 0, 0, true, true), user);
80 database.createPermanantIndex(SystemTables.referential_constraints_TableName, "SYSTEM_INDEX_27", new IndexInformation(SystemTables.referential_constraints_TableName, "SYSTEM_INDEX_27", "SYSTEM_INDEX_27_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", SystemFields.systemFields[SystemFields.rowId]}
81 , new int[] {5, 6, 7, 0}
82 , new boolean[] {true, true, true, true}
83 , 0, 0, 0, 0, true, true), user);
84 database.createPermanantIndex(SystemTables.check_constraints_TableName, "SYSTEM_INDEX_29", new IndexInformation(SystemTables.check_constraints_TableName, "SYSTEM_INDEX_29", "SYSTEM_INDEX_29_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", SystemFields.systemFields[SystemFields.rowId]}
85 , new int[] {5, 6, 7, 0}
86 , new boolean[] {true, true, true, true}
87 , 0, 0, 0, 0, true, true), user);
88 database.createPermanantIndex(SystemTables.check_column_usage_TableName, "SYSTEM_INDEX_31", new IndexInformation(SystemTables.check_column_usage_TableName, "SYSTEM_INDEX_31", "SYSTEM_INDEX_31_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
89 , new int[] {5, 6, 7, 8, 9, 10, 11, 0}
90 , new boolean[] {true, true, true, true, true, true, true, true}
91 , 0, 0, 0, 0, true, true), user);
92 database.createPermanantIndex(SystemTables.check_table_usage_TableName, "SYSTEM_INDEX_33", new IndexInformation(SystemTables.check_table_usage_TableName, "SYSTEM_INDEX_33", "SYSTEM_INDEX_33_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
93 , new int[] {5, 6, 7, 8, 9, 10, 0}
94 , new boolean[] {true, true, true, true, true, true, true}
95 , 0, 0, 0, 0, true, true), user);
96 database.createPermanantIndex(SystemTables.triggers_TableName, "SYSTEM_INDEX_35", new IndexInformation(SystemTables.triggers_TableName, "SYSTEM_INDEX_35", "SYSTEM_INDEX_35_Index", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", SystemFields.systemFields[SystemFields.rowId]}
97 , new int[] {5, 6, 7, 0}
98 , new boolean[] {true, true, true, true}
99 , 0, 0, 0, 0, true, true), user);
100 database.createPermanantIndex(SystemTables.trigger_table_usage_TableName, "SYSTEM_INDEX_37", new IndexInformation(SystemTables.trigger_table_usage_TableName, "SYSTEM_INDEX_37", "SYSTEM_INDEX_37_Index", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
101 , new int[] {5, 6, 7, 8, 9, 10, 0}
102 , new boolean[] {true, true, true, true, true, true, true}
103 , 0, 0, 0, 0, true, true), user);
104 database.createPermanantIndex(SystemTables.trigger_column_usage_TableName, "SYSTEM_INDEX_39", new IndexInformation(SystemTables.trigger_column_usage_TableName, "SYSTEM_INDEX_39", "SYSTEM_INDEX_39_Index", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
105 , new int[] {5, 6, 7, 8, 9, 10, 11, 0}
106 , new boolean[] {true, true, true, true, true, true, true, true}
107 , 0, 0, 0, 0, true, true), user);
108 database.createPermanantIndex(SystemTables.triggered_update_columns_TableName, "SYSTEM_INDEX_41", new IndexInformation(SystemTables.triggered_update_columns_TableName, "SYSTEM_INDEX_41", "SYSTEM_INDEX_41_Index", new String [] {"TRIGGER_CATALOG", "TRIGGER_SCHEMA", "TRIGGER_NAME", "EVENT_OBJECT_COLUMN", SystemFields.systemFields[SystemFields.rowId]}
109 , new int[] {5, 6, 7, 11, 0}
110 , new boolean[] {true, true, true, true, true}
111 , 0, 0, 0, 0, true, true), user);
112 database.createPermanantIndex(SystemTables.views_TableName, "SYSTEM_INDEX_43", new IndexInformation(SystemTables.views_TableName, "SYSTEM_INDEX_43", "SYSTEM_INDEX_43_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
113 , new int[] {5, 6, 7, 0}
114 , new boolean[] {true, true, true, true}
115 , 0, 0, 0, 0, true, true), user);
116 database.createPermanantIndex(SystemTables.view_colum_usage_TableName, "SYSTEM_INDEX_45", new IndexInformation(SystemTables.view_colum_usage_TableName, "SYSTEM_INDEX_45", "SYSTEM_INDEX_45_Index", new String [] {"VIEW_CATALOG", "VIEW_SCHEMA", "VIEW_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
117 , new int[] {5, 6, 7, 8, 9, 10, 11, 0}
118 , new boolean[] {true, true, true, true, true, true, true, true}
119 , 0, 0, 0, 0, true, true), user);
120 database.createPermanantIndex(SystemTables.view_table_usage_TableName, "SYSTEM_INDEX_47", new IndexInformation(SystemTables.view_table_usage_TableName, "SYSTEM_INDEX_47", "SYSTEM_INDEX_47_Index", new String [] {"VIEW_CATALOG", "VIEW_SCHEMA", "VIEW_NAME", "TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
121 , new int[] {5, 6, 7, 8, 9, 10, 0}
122 , new boolean[] {true, true, true, true, true, true, true}
123 , 0, 0, 0, 0, true, true), user);
124 database.createPermanantIndex(SystemTables.domain_constraints_TableName, "SYSTEM_INDEX_49", new IndexInformation(SystemTables.domain_constraints_TableName, "SYSTEM_INDEX_49", "SYSTEM_INDEX_49_Index", new String [] {"CONSTRAINT_CATALOG", "CONSTRAINT_SCHEMA", "CONSTRAINT_NAME", SystemFields.systemFields[SystemFields.rowId]}
125 , new int[] {5, 6, 7, 0}
126 , new boolean[] {true, true, true, true}
127 , 0, 0, 0, 0, true, true), user);
128 database.createPermanantIndex(SystemTables.column_privileges_TableName, "SYSTEM_INDEX_51", new IndexInformation(SystemTables.column_privileges_TableName, "SYSTEM_INDEX_51", "SYSTEM_INDEX_51_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "PRIVILEGE_TYPE", "COLUMN_NAME", "GRANTOR", "GRANTEE", SystemFields.systemFields[SystemFields.rowId]}
129 , new int[] {7, 8, 9, 11, 10, 5, 6, 0}
130 , new boolean[] {true, true, true, true, true, true, true, true}
131 , 0, 0, 0, 0, true, true), user);
132 database.createPermanantIndex(SystemTables.table_privileges_TableName, "SYSTEM_INDEX_53", new IndexInformation(SystemTables.table_privileges_TableName, "SYSTEM_INDEX_53", "SYSTEM_INDEX_53_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "PRIVILEGE_TYPE", "GRANTOR", "GRANTEE", SystemFields.systemFields[SystemFields.rowId]}
133 , new int[] {7, 8, 9, 10, 5, 6, 0}
134 , new boolean[] {true, true, true, true, true, true, true}
135 , 0, 0, 0, 0, true, true), user);
136 database.createPermanantIndex(SystemTables.usage_privileges_TableName, "SYSTEM_INDEX_55", new IndexInformation(SystemTables.usage_privileges_TableName, "SYSTEM_INDEX_55", "SYSTEM_INDEX_55_Index", new String [] {"OBJECT_CATALOG", "OBJECT_SCHEMA", "OBJECT_NAME", "OBJECT_TYPE", "GRANTOR", "GRANTEE", SystemFields.systemFields[SystemFields.rowId]}
137 , new int[] {7, 8, 9, 10, 5, 6, 0}
138 , new boolean[] {true, true, true, true, true, true, true}
139 , 0, 0, 0, 0, true, true), user);
140 database.createPermanantIndex(SystemTables.routines_TableName, "SYSTEM_INDEX_57", new IndexInformation(SystemTables.routines_TableName, "SYSTEM_INDEX_57", "SYSTEM_INDEX_57_Index", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", SystemFields.systemFields[SystemFields.rowId]}
141 , new int[] {5, 6, 7, 0}
142 , new boolean[] {true, true, true, true}
143 , 0, 0, 0, 0, true, true), user);
144 database.createPermanantIndex(SystemTables.parameters_TableName, "SYSTEM_INDEX_59", new IndexInformation(SystemTables.parameters_TableName, "SYSTEM_INDEX_59", "SYSTEM_INDEX_59_Index", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "ORDINAL_POSITION", SystemFields.systemFields[SystemFields.rowId]}
145 , new int[] {5, 6, 7, 8, 0}
146 , new boolean[] {true, true, true, true, true}
147 , 0, 0, 0, 0, true, true), user);
148 database.createPermanantIndex(SystemTables.routine_privileges_TableName, "SYSTEM_INDEX_61", new IndexInformation(SystemTables.routine_privileges_TableName, "SYSTEM_INDEX_61", "SYSTEM_INDEX_61_Index", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "PRIVILEGE_TYPE", "GRANTOR", "GRANTEE", SystemFields.systemFields[SystemFields.rowId]}
149 , new int[] {7, 8, 9, 10, 5, 6, 0}
150 , new boolean[] {true, true, true, true, true, true, true}
151 , 0, 0, 0, 0, true, true), user);
152 database.createPermanantIndex(SystemTables.INDEXINFO, "SYSTEM_INDEX_63", new IndexInformation(SystemTables.INDEXINFO, "SYSTEM_INDEX_63", "SYSTEM_INDEX_63_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME", SystemFields.systemFields[SystemFields.rowId]}
153 , new int[] {5, 6, 7, 8, 0}
154 , new boolean[] {true, true, true, true, true}
155 , 0, 0, 0, 0, true, true), user);
156 database.createPermanantIndex(SystemTables.INDEXCOLUMNS, "SYSTEM_INDEX_65", new IndexInformation(SystemTables.INDEXCOLUMNS, "SYSTEM_INDEX_65", "SYSTEM_INDEX_65_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
157 , new int[] {5, 6, 7, 8, 9, 0}
158 , new boolean[] {true, true, true, true, true, true}
159 , 0, 0, 0, 0, true, true), user);
160 database.createPermanantIndex(SystemTables.FULLTEXTINFO, "SYSTEM_INDEX_67", new IndexInformation(SystemTables.FULLTEXTINFO, "SYSTEM_INDEX_67", "SYSTEM_INDEX_67_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME", SystemFields.systemFields[SystemFields.rowId]}
161 , new int[] {5, 6, 7, 8, 0}
162 , new boolean[] {true, true, true, true, true}
163 , 0, 0, 0, 0, true, true), user);
164 database.createPermanantIndex(SystemTables.FULLTEXTCOLUMNINFO, "SYSTEM_INDEX_69", new IndexInformation(SystemTables.FULLTEXTCOLUMNINFO, "SYSTEM_INDEX_69", "SYSTEM_INDEX_69_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "TABLE_NAME", "INDEXNAME", "COLUMN_NAME", SystemFields.systemFields[SystemFields.rowId]}
165 , new int[] {5, 6, 7, 8, 9, 0}
166 , new boolean[] {true, true, true, true, true, true}
167 , 0, 0, 0, 0, true, true), user);
168 database.createPermanantIndex(SystemTables.userDefinedTypes_TableName, "SYSTEM_INDEX_71", new IndexInformation(SystemTables.userDefinedTypes_TableName, "SYSTEM_INDEX_71", "SYSTEM_INDEX_71_Index", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME", SystemFields.systemFields[SystemFields.rowId]}
169 , new int[] {5, 6, 7, 0}
170 , new boolean[] {true, true, true, true}
171 , 0, 0, 0, 0, true, true), user);
172 database.createPermanantIndex(SystemTables.user_defined_type_privileges_TableName, "SYSTEM_INDEX_73", new IndexInformation(SystemTables.user_defined_type_privileges_TableName, "SYSTEM_INDEX_73", "SYSTEM_INDEX_73_Index", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME", "PRIVILEGE_TYPE", "GRANTOR", "GRANTEE", SystemFields.systemFields[SystemFields.rowId]}
173 , new int[] {7, 8, 9, 10, 5, 6, 0}
174 , new boolean[] {true, true, true, true, true, true, true}
175 , 0, 0, 0, 0, true, true), user);
176 database.createPermanantIndex(SystemTables.transforms_TableName, "SYSTEM_INDEX_75", new IndexInformation(SystemTables.transforms_TableName, "SYSTEM_INDEX_75", "SYSTEM_INDEX_75_Index", new String [] {"USER_DEFINED_TYPE_CATALOG", "USER_DEFINED_TYPE_SCHEMA", "USER_DEFINED_TYPE_NAME", "GROUP_NAME", "TRANSFORM_TYPE", SystemFields.systemFields[SystemFields.rowId]}
177 , new int[] {5, 6, 7, 11, 12, 0}
178 , new boolean[] {true, true, true, true, true, true}
179 , 0, 0, 0, 0, true, true), user);
180 database.createPermanantIndex(SystemTables.method_specifications_TableName, "SYSTEM_INDEX_77", new IndexInformation(SystemTables.method_specifications_TableName, "SYSTEM_INDEX_77", "SYSTEM_INDEX_77_Index", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", SystemFields.systemFields[SystemFields.rowId]}
181 , new int[] {5, 6, 7, 0}
182 , new boolean[] {true, true, true, true}
183 , 0, 0, 0, 0, true, true), user);
184 database.createPermanantIndex(SystemTables.method_specification_parameters_TableName, "SYSTEM_INDEX_79", new IndexInformation(SystemTables.method_specification_parameters_TableName, "SYSTEM_INDEX_79", "SYSTEM_INDEX_79_Index", new String [] {"SPECIFIC_CATALOG", "SPECIFIC_SCHEMA", "SPECIFIC_NAME", "METHOD_CATALOG", "METHOD_SCHEMA", "METHOD_NAME", "METHOD_SPECIFICATION_IDENTIFIER", "ORDINAL_POSITION", SystemFields.systemFields[SystemFields.rowId]}
185 , new int[] {5, 6, 7, 8, 9, 10, 11, 12, 0}
186 , new boolean[] {true, true, true, true, true, true, true, true, true}
187 , 0, 0, 0, 0, true, true), user);
188 database.createPermanantIndex(SystemTables.sequence_number_TableName, "SYSTEM_INDEX_81", new IndexInformation(SystemTables.sequence_number_TableName, "SYSTEM_INDEX_81", "SYSTEM_INDEX_81_Index", new String [] {"SEQUENCE_CATALOG", "SEQUENCE_SCHEMA", "SEQUENCE_NAME", SystemFields.systemFields[SystemFields.rowId]}
189 , new int[] {5, 6, 7, 0}
190 , new boolean[] {true, true, true, true}
191 , 0, 0, 0, 0, true, true), user);
192 database.createPermanantIndex(SystemTables.table_constraints_TableName, "SYSTEM_psg_table_constraint_1", new IndexInformation(SystemTables.table_constraints_TableName, "SYSTEM_psg_table_constraint_1", "SYSTEM_psg_table_constraint_1_Index", new String [] {"table_catalog", "table_schema", "table_name", "constraint_type", "is_deferrable", SystemFields.systemFields[SystemFields.rowId]}
193 , new int[] {9, 10, 11, 8, 12, 0}
194 , new boolean[] {true, true, true, true, true, true}
195 , 0, 0, 0, 0, true, false), user);
196 database.createPermanantIndex(SystemTables.key_column_usage_TableName, "SYSTEM_psg_key_column_usage_1", new IndexInformation(SystemTables.key_column_usage_TableName, "SYSTEM_psg_key_column_usage_1", "SYSTEM_psg_key_column_usage_1_Index", new String [] {"table_catalog", "table_schema", "table_name", "column_name", SystemFields.systemFields[SystemFields.rowId]}
197 , new int[] {8, 9, 10, 11, 0}
198 , new boolean[] {true, true, true, true, true}
199 , 0, 0, 0, 0, true, false), user);
200 database.createPermanantIndex(SystemTables.domain_constraints_TableName, "SYSTEM_psg_domain_constraint_1", new IndexInformation(SystemTables.domain_constraints_TableName, "SYSTEM_psg_domain_constraint_1", "SYSTEM_psg_domain_constraint_1_Index", new String [] {"domain_catalog", "domain_schema", "domain_name", SystemFields.systemFields[SystemFields.rowId]}
201 , new int[] {8, 9, 10, 0}
202 , new boolean[] {true, true, true, true}
203 , 0, 0, 0, 0, true, false), user);
204 database.createPermanantIndex(SystemTables.referential_constraints_TableName, "SYSTEM_psg_referential_constraint_1", new IndexInformation(SystemTables.referential_constraints_TableName, "SYSTEM_psg_referential_constraint_1", "SYSTEM_psg_referential_constraint_1_Index", new String [] {"unique_constraint_catalog", "unique_constraint_schema", "unique_constraint_name", SystemFields.systemFields[SystemFields.rowId]}
205 , new int[] {8, 9, 10, 0}
206 , new boolean[] {true, true, true, true}
207 , 0, 0, 0, 0, true, false), user);
208 database.createPermanantIndex(SystemTables.triggers_TableName, "SYSTEM_psg_triggers_1", new IndexInformation(SystemTables.triggers_TableName, "SYSTEM_psg_triggers_1", "SYSTEM_psg_triggers_1_Index", new String [] {"event_object_catalog", "event_object_schema", "event_object_table", "event_manipulation", "action_orientation", "condition_timing", SystemFields.systemFields[SystemFields.rowId]}
209 , new int[] {9, 10, 11, 8, 15, 16, 0}
210 , new boolean[] {true, true, true, true, true, true, true}
211 , 0, 0, 0, 0, true, false), user);
212 database.createPermanantIndex(SystemTables.triggered_update_columns_TableName, "SYSTEM_psg_triggered_update_columns_1", new IndexInformation(SystemTables.triggered_update_columns_TableName, "SYSTEM_psg_triggered_update_columns_1", "SYSTEM_psg_triggered_update_columns_1_Index", new String [] {"event_object_catalog", "event_object_schema", "event_object_table", SystemFields.systemFields[SystemFields.rowId]}
213 , new int[] {8, 9, 10, 0}
214 , new boolean[] {true, true, true, true}
215 , 0, 0, 0, 0, true, false), user);
216 database.createPermanantIndex(SystemTables.schema_TableName, "SYSTEM_psg_schemata_1", new IndexInformation(SystemTables.schema_TableName, "SYSTEM_psg_schemata_1", "SYSTEM_psg_schemata_1_Index", new String [] {"SCHEMA_OWNER", SystemFields.systemFields[SystemFields.rowId]}
217 , new int[] {7, 0}
218 , new boolean[] {true, true}
219 , 0, 0, 0, 0, true, false), user);
220 database.createPermanantIndex(SystemTables.views_TableName, "SYSTEM_psg_views_1", new IndexInformation(SystemTables.views_TableName, "SYSTEM_psg_views_1", "SYSTEM_psg_views_1_Index", new String [] {"TABLE_CATALOG", "TABLE_SCHEMA", "MATERIALIZED_TABLE_NAME", SystemFields.systemFields[SystemFields.rowId]}
221 , new int[] {5, 6, 12, 0}
222 , new boolean[] {true, true, true, true}
223 , 0, 0, 0, 0, true, false), user);
224 user.writeToFile();
225 } catch (Exception e) {
226 e.printStackTrace();
227 user.rollback();
228 }
229 }
230 }
231 |
Popular Tags |
Java API By Example, From Geeks To Geeks.