| 32565 |
tejbeer |
1 |
<?xml version="1.0" encoding="UTF-8"?>
|
|
|
2 |
<project version="4">
|
|
|
3 |
<component name="DBNavigator.Project.DataEditorManager">
|
|
|
4 |
<record-view-column-sorting-type value="BY_INDEX" />
|
|
|
5 |
<value-preview-text-wrapping value="false" />
|
|
|
6 |
<value-preview-pinned value="false" />
|
|
|
7 |
</component>
|
|
|
8 |
<component name="DBNavigator.Project.DatabaseBrowserManager">
|
|
|
9 |
<autoscroll-to-editor value="false" />
|
|
|
10 |
<autoscroll-from-editor value="true" />
|
|
|
11 |
<show-object-properties value="true" />
|
|
|
12 |
<loaded-nodes />
|
|
|
13 |
</component>
|
|
|
14 |
<component name="DBNavigator.Project.DatabaseConsoleManager">
|
|
|
15 |
<connection id="75e7e43c-2a8c-4fe8-8263-0b4209f1feec">
|
|
|
16 |
<console name="Connection" type="STANDARD" schema="" session="Main"><![CDATA[select * from warehouse.supplier where id=430;
|
|
|
17 |
|
|
|
18 |
alter table warehouse.supplier add column internalWarehouseId int not null default 0;
|
|
|
19 |
|
|
|
20 |
select * from warehouse.supplier where id=433;]]></console>
|
|
|
21 |
<console name="Connection 1" type="STANDARD" schema="warehouse" session="Main" />
|
|
|
22 |
</connection>
|
|
|
23 |
<connection id="4ab7ca23-3ffe-4d27-a312-6778c5c9c8d0">
|
|
|
24 |
<console name="Connection 1" type="STANDARD" schema="" session="Main"><![CDATA[mysql -uroot -pshop2020
|
|
|
25 |
select * from warehouse.supplier]]></console>
|
|
|
26 |
</connection>
|
|
|
27 |
</component>
|
|
|
28 |
<component name="DBNavigator.Project.DatabaseEditorStateManager">
|
|
|
29 |
<last-used-providers />
|
|
|
30 |
</component>
|
|
|
31 |
<component name="DBNavigator.Project.DatabaseFileManager">
|
|
|
32 |
<open-files />
|
|
|
33 |
</component>
|
|
|
34 |
<component name="DBNavigator.Project.ExecutionManager">
|
|
|
35 |
<retain-sticky-names value="false" />
|
|
|
36 |
</component>
|
|
|
37 |
<component name="DBNavigator.Project.FileConnectionMappingManager">
|
|
|
38 |
<mapping file-url="file://$APPLICATION_CONFIG_DIR$/scratches/scratch.sql" connection-id="75e7e43c-2a8c-4fe8-8263-0b4209f1feec" session-id="MAIN" current-schema="auth" />
|
|
|
39 |
</component>
|
|
|
40 |
<component name="DBNavigator.Project.ObjectQuickFilterManager">
|
|
|
41 |
<last-used-operator value="EQUAL" />
|
|
|
42 |
<filters />
|
|
|
43 |
</component>
|
|
|
44 |
<component name="DBNavigator.Project.ParserDiagnosticsManager">
|
|
|
45 |
<diagnostics-history />
|
|
|
46 |
</component>
|
|
|
47 |
<component name="DBNavigator.Project.ScriptExecutionManager" clear-outputs="false">
|
|
|
48 |
<recently-used-interfaces>
|
|
|
49 |
<mapping database-type="MYSQL" interface-id="DEFAULT" />
|
|
|
50 |
</recently-used-interfaces>
|
|
|
51 |
</component>
|
|
|
52 |
<component name="DBNavigator.Project.Settings">
|
|
|
53 |
<connections>
|
|
|
54 |
<connection id="75e7e43c-2a8c-4fe8-8263-0b4209f1feec" active="true" signed="true">
|
|
|
55 |
<database>
|
|
|
56 |
<name value="Connection" />
|
|
|
57 |
<description value="" />
|
|
|
58 |
<database-type value="MYSQL" />
|
|
|
59 |
<config-type value="BASIC" />
|
|
|
60 |
<database-version value="8.0" />
|
|
|
61 |
<driver-source value="BUNDLED" />
|
|
|
62 |
<driver-library value="" />
|
|
|
63 |
<driver value="" />
|
|
|
64 |
<url-type value="DATABASE" />
|
|
|
65 |
<host value="localhost" />
|
|
|
66 |
<port value="3306" />
|
|
|
67 |
<database value="mysql" />
|
|
|
68 |
<tns-folder value="" />
|
|
|
69 |
<tns-profile value="" />
|
|
|
70 |
<type value="USER_PASSWORD" />
|
|
|
71 |
<user value="root" />
|
|
|
72 |
<deprecated-pwd value="c2hvcDIwMjA=" />
|
|
|
73 |
</database>
|
|
|
74 |
<properties>
|
|
|
75 |
<auto-commit value="true" />
|
|
|
76 |
</properties>
|
|
|
77 |
<ssh-settings>
|
|
|
78 |
<active value="false" />
|
|
|
79 |
<proxy-host value="" />
|
|
|
80 |
<proxy-port value="22" />
|
|
|
81 |
<proxy-user value="" />
|
|
|
82 |
<deprecated-proxy-pwd value="" />
|
|
|
83 |
<auth-type value="PASSWORD" />
|
|
|
84 |
<key-file value="" />
|
|
|
85 |
<key-passphrase value="" />
|
|
|
86 |
</ssh-settings>
|
|
|
87 |
<ssl-settings>
|
|
|
88 |
<active value="false" />
|
|
|
89 |
<certificate-authority-file value="" />
|
|
|
90 |
<client-certificate-file value="" />
|
|
|
91 |
<client-key-file value="" />
|
|
|
92 |
</ssl-settings>
|
|
|
93 |
<details>
|
|
|
94 |
<charset value="UTF-8" />
|
|
|
95 |
<session-management value="true" />
|
|
|
96 |
<ddl-file-binding value="true" />
|
|
|
97 |
<database-logging value="true" />
|
|
|
98 |
<connect-automatically value="true" />
|
|
|
99 |
<restore-workspace value="true" />
|
|
|
100 |
<restore-workspace-deep value="false" />
|
|
|
101 |
<environment-type value="default" />
|
|
|
102 |
<connectivity-timeout value="30" />
|
|
|
103 |
<idle-time-to-disconnect value="30" />
|
|
|
104 |
<idle-time-to-disconnect-pool value="5" />
|
|
|
105 |
<credential-expiry-time value="10" />
|
|
|
106 |
<max-connection-pool-size value="7" />
|
|
|
107 |
<alternative-statement-delimiter value="" />
|
|
|
108 |
</details>
|
|
|
109 |
<debugger>
|
|
|
110 |
<compile-dependencies value="true" />
|
|
|
111 |
<tcp-driver-tunneling value="false" />
|
|
|
112 |
<tcp-host-address value="" />
|
|
|
113 |
<tcp-port-from value="4000" />
|
|
|
114 |
<tcp-port-to value="4999" />
|
|
|
115 |
</debugger>
|
|
|
116 |
<object-filters hide-empty-schemas="false" hide-pseudo-columns="false">
|
|
|
117 |
<object-type-filter>
|
|
|
118 |
<object-type name="SCHEMA" enabled="true" />
|
|
|
119 |
<object-type name="USER" enabled="true" />
|
|
|
120 |
<object-type name="ROLE" enabled="true" />
|
|
|
121 |
<object-type name="PRIVILEGE" enabled="true" />
|
|
|
122 |
<object-type name="CHARSET" enabled="true" />
|
|
|
123 |
<object-type name="TABLE" enabled="true" />
|
|
|
124 |
<object-type name="VIEW" enabled="true" />
|
|
|
125 |
<object-type name="MATERIALIZED_VIEW" enabled="true" />
|
|
|
126 |
<object-type name="NESTED_TABLE" enabled="true" />
|
|
|
127 |
<object-type name="COLUMN" enabled="true" />
|
|
|
128 |
<object-type name="INDEX" enabled="true" />
|
|
|
129 |
<object-type name="CONSTRAINT" enabled="true" />
|
|
|
130 |
<object-type name="DATASET_TRIGGER" enabled="true" />
|
|
|
131 |
<object-type name="DATABASE_TRIGGER" enabled="true" />
|
|
|
132 |
<object-type name="SYNONYM" enabled="true" />
|
|
|
133 |
<object-type name="SEQUENCE" enabled="true" />
|
|
|
134 |
<object-type name="PROCEDURE" enabled="true" />
|
|
|
135 |
<object-type name="FUNCTION" enabled="true" />
|
|
|
136 |
<object-type name="PACKAGE" enabled="true" />
|
|
|
137 |
<object-type name="TYPE" enabled="true" />
|
|
|
138 |
<object-type name="TYPE_ATTRIBUTE" enabled="true" />
|
|
|
139 |
<object-type name="ARGUMENT" enabled="true" />
|
|
|
140 |
<object-type name="DIMENSION" enabled="true" />
|
|
|
141 |
<object-type name="CLUSTER" enabled="true" />
|
|
|
142 |
<object-type name="DBLINK" enabled="true" />
|
|
|
143 |
</object-type-filter>
|
|
|
144 |
<object-name-filters />
|
|
|
145 |
</object-filters>
|
|
|
146 |
</connection>
|
|
|
147 |
<connection id="4ab7ca23-3ffe-4d27-a312-6778c5c9c8d0" active="true" signed="true">
|
|
|
148 |
<database>
|
|
|
149 |
<name value="Connection 1" />
|
|
|
150 |
<description value="" />
|
|
|
151 |
<database-type value="MYSQL" />
|
|
|
152 |
<config-type value="BASIC" />
|
|
|
153 |
<database-version value="9999.0" />
|
|
|
154 |
<driver-source value="BUNDLED" />
|
|
|
155 |
<driver-library value="" />
|
|
|
156 |
<driver value="" />
|
|
|
157 |
<url-type value="DATABASE" />
|
|
|
158 |
<host value="localhost" />
|
|
|
159 |
<port value="3306" />
|
|
|
160 |
<database value="mysql" />
|
|
|
161 |
<tns-folder value="" />
|
|
|
162 |
<tns-profile value="" />
|
|
|
163 |
<type value="USER_PASSWORD" />
|
|
|
164 |
<user value="root" />
|
|
|
165 |
<deprecated-pwd value="cHNob3AyMDIw" />
|
|
|
166 |
</database>
|
|
|
167 |
<properties>
|
|
|
168 |
<auto-commit value="false" />
|
|
|
169 |
</properties>
|
|
|
170 |
<ssh-settings>
|
|
|
171 |
<active value="false" />
|
|
|
172 |
<proxy-host value="" />
|
|
|
173 |
<proxy-port value="22" />
|
|
|
174 |
<proxy-user value="" />
|
|
|
175 |
<deprecated-proxy-pwd value="" />
|
|
|
176 |
<auth-type value="PASSWORD" />
|
|
|
177 |
<key-file value="" />
|
|
|
178 |
<key-passphrase value="" />
|
|
|
179 |
</ssh-settings>
|
|
|
180 |
<ssl-settings>
|
|
|
181 |
<active value="false" />
|
|
|
182 |
<certificate-authority-file value="" />
|
|
|
183 |
<client-certificate-file value="" />
|
|
|
184 |
<client-key-file value="" />
|
|
|
185 |
</ssl-settings>
|
|
|
186 |
<details>
|
|
|
187 |
<charset value="UTF-8" />
|
|
|
188 |
<session-management value="true" />
|
|
|
189 |
<ddl-file-binding value="true" />
|
|
|
190 |
<database-logging value="true" />
|
|
|
191 |
<connect-automatically value="true" />
|
|
|
192 |
<restore-workspace value="true" />
|
|
|
193 |
<restore-workspace-deep value="false" />
|
|
|
194 |
<environment-type value="default" />
|
|
|
195 |
<connectivity-timeout value="30" />
|
|
|
196 |
<idle-time-to-disconnect value="30" />
|
|
|
197 |
<idle-time-to-disconnect-pool value="5" />
|
|
|
198 |
<credential-expiry-time value="10" />
|
|
|
199 |
<max-connection-pool-size value="7" />
|
|
|
200 |
<alternative-statement-delimiter value="" />
|
|
|
201 |
</details>
|
|
|
202 |
<debugger>
|
|
|
203 |
<compile-dependencies value="true" />
|
|
|
204 |
<tcp-driver-tunneling value="false" />
|
|
|
205 |
<tcp-host-address value="" />
|
|
|
206 |
<tcp-port-from value="4000" />
|
|
|
207 |
<tcp-port-to value="4999" />
|
|
|
208 |
</debugger>
|
|
|
209 |
<object-filters hide-empty-schemas="false" hide-pseudo-columns="false">
|
|
|
210 |
<object-type-filter>
|
|
|
211 |
<object-type name="SCHEMA" enabled="true" />
|
|
|
212 |
<object-type name="USER" enabled="true" />
|
|
|
213 |
<object-type name="ROLE" enabled="true" />
|
|
|
214 |
<object-type name="PRIVILEGE" enabled="true" />
|
|
|
215 |
<object-type name="CHARSET" enabled="true" />
|
|
|
216 |
<object-type name="TABLE" enabled="true" />
|
|
|
217 |
<object-type name="VIEW" enabled="true" />
|
|
|
218 |
<object-type name="MATERIALIZED_VIEW" enabled="true" />
|
|
|
219 |
<object-type name="NESTED_TABLE" enabled="true" />
|
|
|
220 |
<object-type name="COLUMN" enabled="true" />
|
|
|
221 |
<object-type name="INDEX" enabled="true" />
|
|
|
222 |
<object-type name="CONSTRAINT" enabled="true" />
|
|
|
223 |
<object-type name="DATASET_TRIGGER" enabled="true" />
|
|
|
224 |
<object-type name="DATABASE_TRIGGER" enabled="true" />
|
|
|
225 |
<object-type name="SYNONYM" enabled="true" />
|
|
|
226 |
<object-type name="SEQUENCE" enabled="true" />
|
|
|
227 |
<object-type name="PROCEDURE" enabled="true" />
|
|
|
228 |
<object-type name="FUNCTION" enabled="true" />
|
|
|
229 |
<object-type name="PACKAGE" enabled="true" />
|
|
|
230 |
<object-type name="TYPE" enabled="true" />
|
|
|
231 |
<object-type name="TYPE_ATTRIBUTE" enabled="true" />
|
|
|
232 |
<object-type name="ARGUMENT" enabled="true" />
|
|
|
233 |
<object-type name="DIMENSION" enabled="true" />
|
|
|
234 |
<object-type name="CLUSTER" enabled="true" />
|
|
|
235 |
<object-type name="DBLINK" enabled="true" />
|
|
|
236 |
</object-type-filter>
|
|
|
237 |
<object-name-filters />
|
|
|
238 |
</object-filters>
|
|
|
239 |
</connection>
|
|
|
240 |
</connections>
|
|
|
241 |
<browser-settings>
|
|
|
242 |
<general>
|
|
|
243 |
<display-mode value="TABBED" />
|
|
|
244 |
<navigation-history-size value="100" />
|
|
|
245 |
<show-object-details value="false" />
|
|
|
246 |
</general>
|
|
|
247 |
<filters>
|
|
|
248 |
<object-type-filter>
|
|
|
249 |
<object-type name="SCHEMA" enabled="true" />
|
|
|
250 |
<object-type name="USER" enabled="true" />
|
|
|
251 |
<object-type name="ROLE" enabled="true" />
|
|
|
252 |
<object-type name="PRIVILEGE" enabled="true" />
|
|
|
253 |
<object-type name="CHARSET" enabled="true" />
|
|
|
254 |
<object-type name="TABLE" enabled="true" />
|
|
|
255 |
<object-type name="VIEW" enabled="true" />
|
|
|
256 |
<object-type name="MATERIALIZED_VIEW" enabled="true" />
|
|
|
257 |
<object-type name="NESTED_TABLE" enabled="true" />
|
|
|
258 |
<object-type name="COLUMN" enabled="true" />
|
|
|
259 |
<object-type name="INDEX" enabled="true" />
|
|
|
260 |
<object-type name="CONSTRAINT" enabled="true" />
|
|
|
261 |
<object-type name="DATASET_TRIGGER" enabled="true" />
|
|
|
262 |
<object-type name="DATABASE_TRIGGER" enabled="true" />
|
|
|
263 |
<object-type name="SYNONYM" enabled="true" />
|
|
|
264 |
<object-type name="SEQUENCE" enabled="true" />
|
|
|
265 |
<object-type name="PROCEDURE" enabled="true" />
|
|
|
266 |
<object-type name="FUNCTION" enabled="true" />
|
|
|
267 |
<object-type name="PACKAGE" enabled="true" />
|
|
|
268 |
<object-type name="TYPE" enabled="true" />
|
|
|
269 |
<object-type name="TYPE_ATTRIBUTE" enabled="true" />
|
|
|
270 |
<object-type name="ARGUMENT" enabled="true" />
|
|
|
271 |
<object-type name="DIMENSION" enabled="true" />
|
|
|
272 |
<object-type name="CLUSTER" enabled="true" />
|
|
|
273 |
<object-type name="DBLINK" enabled="true" />
|
|
|
274 |
</object-type-filter>
|
|
|
275 |
</filters>
|
|
|
276 |
<sorting>
|
|
|
277 |
<object-type name="COLUMN" sorting-type="NAME" />
|
|
|
278 |
<object-type name="FUNCTION" sorting-type="NAME" />
|
|
|
279 |
<object-type name="PROCEDURE" sorting-type="NAME" />
|
|
|
280 |
<object-type name="ARGUMENT" sorting-type="POSITION" />
|
|
|
281 |
<object-type name="TYPE ATTRIBUTE" sorting-type="POSITION" />
|
|
|
282 |
</sorting>
|
|
|
283 |
<default-editors>
|
|
|
284 |
<object-type name="VIEW" editor-type="SELECTION" />
|
|
|
285 |
<object-type name="PACKAGE" editor-type="SELECTION" />
|
|
|
286 |
<object-type name="TYPE" editor-type="SELECTION" />
|
|
|
287 |
</default-editors>
|
|
|
288 |
</browser-settings>
|
|
|
289 |
<navigation-settings>
|
|
|
290 |
<lookup-filters>
|
|
|
291 |
<lookup-objects>
|
|
|
292 |
<object-type name="SCHEMA" enabled="true" />
|
|
|
293 |
<object-type name="USER" enabled="false" />
|
|
|
294 |
<object-type name="ROLE" enabled="false" />
|
|
|
295 |
<object-type name="PRIVILEGE" enabled="false" />
|
|
|
296 |
<object-type name="CHARSET" enabled="false" />
|
|
|
297 |
<object-type name="TABLE" enabled="true" />
|
|
|
298 |
<object-type name="VIEW" enabled="true" />
|
|
|
299 |
<object-type name="MATERIALIZED VIEW" enabled="true" />
|
|
|
300 |
<object-type name="INDEX" enabled="true" />
|
|
|
301 |
<object-type name="CONSTRAINT" enabled="true" />
|
|
|
302 |
<object-type name="DATASET TRIGGER" enabled="true" />
|
|
|
303 |
<object-type name="DATABASE TRIGGER" enabled="true" />
|
|
|
304 |
<object-type name="SYNONYM" enabled="false" />
|
|
|
305 |
<object-type name="SEQUENCE" enabled="true" />
|
|
|
306 |
<object-type name="PROCEDURE" enabled="true" />
|
|
|
307 |
<object-type name="FUNCTION" enabled="true" />
|
|
|
308 |
<object-type name="PACKAGE" enabled="true" />
|
|
|
309 |
<object-type name="TYPE" enabled="true" />
|
|
|
310 |
<object-type name="DIMENSION" enabled="false" />
|
|
|
311 |
<object-type name="CLUSTER" enabled="false" />
|
|
|
312 |
<object-type name="DBLINK" enabled="true" />
|
|
|
313 |
</lookup-objects>
|
|
|
314 |
<force-database-load value="false" />
|
|
|
315 |
<prompt-connection-selection value="false" />
|
|
|
316 |
<prompt-schema-selection value="true" />
|
|
|
317 |
</lookup-filters>
|
|
|
318 |
</navigation-settings>
|
|
|
319 |
<dataset-grid-settings>
|
|
|
320 |
<general>
|
|
|
321 |
<enable-zooming value="true" />
|
|
|
322 |
<enable-column-tooltip value="true" />
|
|
|
323 |
</general>
|
|
|
324 |
<sorting>
|
|
|
325 |
<nulls-first value="true" />
|
|
|
326 |
<max-sorting-columns value="4" />
|
|
|
327 |
</sorting>
|
|
|
328 |
<audit-columns>
|
|
|
329 |
<column-names value="" />
|
|
|
330 |
<visible value="true" />
|
|
|
331 |
<editable value="false" />
|
|
|
332 |
</audit-columns>
|
|
|
333 |
</dataset-grid-settings>
|
|
|
334 |
<dataset-editor-settings>
|
|
|
335 |
<text-editor-popup>
|
|
|
336 |
<active value="false" />
|
|
|
337 |
<active-if-empty value="false" />
|
|
|
338 |
<data-length-threshold value="100" />
|
|
|
339 |
<popup-delay value="1000" />
|
|
|
340 |
</text-editor-popup>
|
|
|
341 |
<values-actions-popup>
|
|
|
342 |
<show-popup-button value="true" />
|
|
|
343 |
<element-count-threshold value="1000" />
|
|
|
344 |
<data-length-threshold value="250" />
|
|
|
345 |
</values-actions-popup>
|
|
|
346 |
<general>
|
|
|
347 |
<fetch-block-size value="100" />
|
|
|
348 |
<fetch-timeout value="30" />
|
|
|
349 |
<trim-whitespaces value="true" />
|
|
|
350 |
<convert-empty-strings-to-null value="true" />
|
|
|
351 |
<select-content-on-cell-edit value="true" />
|
|
|
352 |
<large-value-preview-active value="true" />
|
|
|
353 |
</general>
|
|
|
354 |
<filters>
|
|
|
355 |
<prompt-filter-dialog value="true" />
|
|
|
356 |
<default-filter-type value="BASIC" />
|
|
|
357 |
</filters>
|
|
|
358 |
<qualified-text-editor text-length-threshold="300">
|
|
|
359 |
<content-types>
|
|
|
360 |
<content-type name="Text" enabled="true" />
|
|
|
361 |
<content-type name="Properties" enabled="true" />
|
|
|
362 |
<content-type name="XML" enabled="true" />
|
|
|
363 |
<content-type name="DTD" enabled="true" />
|
|
|
364 |
<content-type name="HTML" enabled="true" />
|
|
|
365 |
<content-type name="XHTML" enabled="true" />
|
|
|
366 |
<content-type name="Java" enabled="true" />
|
|
|
367 |
<content-type name="SQL" enabled="true" />
|
|
|
368 |
<content-type name="PL/SQL" enabled="true" />
|
|
|
369 |
<content-type name="JSON" enabled="true" />
|
|
|
370 |
<content-type name="JSON5" enabled="true" />
|
|
|
371 |
<content-type name="Groovy" enabled="true" />
|
|
|
372 |
<content-type name="AIDL" enabled="true" />
|
|
|
373 |
<content-type name="YAML" enabled="true" />
|
|
|
374 |
<content-type name="Manifest" enabled="true" />
|
|
|
375 |
</content-types>
|
|
|
376 |
</qualified-text-editor>
|
|
|
377 |
<record-navigation>
|
|
|
378 |
<navigation-target value="VIEWER" />
|
|
|
379 |
</record-navigation>
|
|
|
380 |
</dataset-editor-settings>
|
|
|
381 |
<code-editor-settings>
|
|
|
382 |
<general>
|
|
|
383 |
<show-object-navigation-gutter value="false" />
|
|
|
384 |
<show-spec-declaration-navigation-gutter value="true" />
|
|
|
385 |
<enable-spellchecking value="true" />
|
|
|
386 |
<enable-reference-spellchecking value="false" />
|
|
|
387 |
</general>
|
|
|
388 |
<confirmations>
|
|
|
389 |
<save-changes value="false" />
|
|
|
390 |
<revert-changes value="true" />
|
|
|
391 |
</confirmations>
|
|
|
392 |
</code-editor-settings>
|
|
|
393 |
<code-completion-settings>
|
|
|
394 |
<filters>
|
|
|
395 |
<basic-filter>
|
|
|
396 |
<filter-element type="RESERVED_WORD" id="keyword" selected="true" />
|
|
|
397 |
<filter-element type="RESERVED_WORD" id="function" selected="true" />
|
|
|
398 |
<filter-element type="RESERVED_WORD" id="parameter" selected="true" />
|
|
|
399 |
<filter-element type="RESERVED_WORD" id="datatype" selected="true" />
|
|
|
400 |
<filter-element type="RESERVED_WORD" id="exception" selected="true" />
|
|
|
401 |
<filter-element type="OBJECT" id="schema" selected="true" />
|
|
|
402 |
<filter-element type="OBJECT" id="role" selected="true" />
|
|
|
403 |
<filter-element type="OBJECT" id="user" selected="true" />
|
|
|
404 |
<filter-element type="OBJECT" id="privilege" selected="true" />
|
|
|
405 |
<user-schema>
|
|
|
406 |
<filter-element type="OBJECT" id="table" selected="true" />
|
|
|
407 |
<filter-element type="OBJECT" id="view" selected="true" />
|
|
|
408 |
<filter-element type="OBJECT" id="materialized view" selected="true" />
|
|
|
409 |
<filter-element type="OBJECT" id="index" selected="true" />
|
|
|
410 |
<filter-element type="OBJECT" id="constraint" selected="true" />
|
|
|
411 |
<filter-element type="OBJECT" id="trigger" selected="true" />
|
|
|
412 |
<filter-element type="OBJECT" id="synonym" selected="false" />
|
|
|
413 |
<filter-element type="OBJECT" id="sequence" selected="true" />
|
|
|
414 |
<filter-element type="OBJECT" id="procedure" selected="true" />
|
|
|
415 |
<filter-element type="OBJECT" id="function" selected="true" />
|
|
|
416 |
<filter-element type="OBJECT" id="package" selected="true" />
|
|
|
417 |
<filter-element type="OBJECT" id="type" selected="true" />
|
|
|
418 |
<filter-element type="OBJECT" id="dimension" selected="true" />
|
|
|
419 |
<filter-element type="OBJECT" id="cluster" selected="true" />
|
|
|
420 |
<filter-element type="OBJECT" id="dblink" selected="true" />
|
|
|
421 |
</user-schema>
|
|
|
422 |
<public-schema>
|
|
|
423 |
<filter-element type="OBJECT" id="table" selected="false" />
|
|
|
424 |
<filter-element type="OBJECT" id="view" selected="false" />
|
|
|
425 |
<filter-element type="OBJECT" id="materialized view" selected="false" />
|
|
|
426 |
<filter-element type="OBJECT" id="index" selected="false" />
|
|
|
427 |
<filter-element type="OBJECT" id="constraint" selected="false" />
|
|
|
428 |
<filter-element type="OBJECT" id="trigger" selected="false" />
|
|
|
429 |
<filter-element type="OBJECT" id="synonym" selected="false" />
|
|
|
430 |
<filter-element type="OBJECT" id="sequence" selected="false" />
|
|
|
431 |
<filter-element type="OBJECT" id="procedure" selected="false" />
|
|
|
432 |
<filter-element type="OBJECT" id="function" selected="false" />
|
|
|
433 |
<filter-element type="OBJECT" id="package" selected="false" />
|
|
|
434 |
<filter-element type="OBJECT" id="type" selected="false" />
|
|
|
435 |
<filter-element type="OBJECT" id="dimension" selected="false" />
|
|
|
436 |
<filter-element type="OBJECT" id="cluster" selected="false" />
|
|
|
437 |
<filter-element type="OBJECT" id="dblink" selected="false" />
|
|
|
438 |
</public-schema>
|
|
|
439 |
<any-schema>
|
|
|
440 |
<filter-element type="OBJECT" id="table" selected="true" />
|
|
|
441 |
<filter-element type="OBJECT" id="view" selected="true" />
|
|
|
442 |
<filter-element type="OBJECT" id="materialized view" selected="true" />
|
|
|
443 |
<filter-element type="OBJECT" id="index" selected="true" />
|
|
|
444 |
<filter-element type="OBJECT" id="constraint" selected="true" />
|
|
|
445 |
<filter-element type="OBJECT" id="trigger" selected="true" />
|
|
|
446 |
<filter-element type="OBJECT" id="synonym" selected="true" />
|
|
|
447 |
<filter-element type="OBJECT" id="sequence" selected="true" />
|
|
|
448 |
<filter-element type="OBJECT" id="procedure" selected="true" />
|
|
|
449 |
<filter-element type="OBJECT" id="function" selected="true" />
|
|
|
450 |
<filter-element type="OBJECT" id="package" selected="true" />
|
|
|
451 |
<filter-element type="OBJECT" id="type" selected="true" />
|
|
|
452 |
<filter-element type="OBJECT" id="dimension" selected="true" />
|
|
|
453 |
<filter-element type="OBJECT" id="cluster" selected="true" />
|
|
|
454 |
<filter-element type="OBJECT" id="dblink" selected="true" />
|
|
|
455 |
</any-schema>
|
|
|
456 |
</basic-filter>
|
|
|
457 |
<extended-filter>
|
|
|
458 |
<filter-element type="RESERVED_WORD" id="keyword" selected="true" />
|
|
|
459 |
<filter-element type="RESERVED_WORD" id="function" selected="true" />
|
|
|
460 |
<filter-element type="RESERVED_WORD" id="parameter" selected="true" />
|
|
|
461 |
<filter-element type="RESERVED_WORD" id="datatype" selected="true" />
|
|
|
462 |
<filter-element type="RESERVED_WORD" id="exception" selected="true" />
|
|
|
463 |
<filter-element type="OBJECT" id="schema" selected="true" />
|
|
|
464 |
<filter-element type="OBJECT" id="user" selected="true" />
|
|
|
465 |
<filter-element type="OBJECT" id="role" selected="true" />
|
|
|
466 |
<filter-element type="OBJECT" id="privilege" selected="true" />
|
|
|
467 |
<user-schema>
|
|
|
468 |
<filter-element type="OBJECT" id="table" selected="true" />
|
|
|
469 |
<filter-element type="OBJECT" id="view" selected="true" />
|
|
|
470 |
<filter-element type="OBJECT" id="materialized view" selected="true" />
|
|
|
471 |
<filter-element type="OBJECT" id="index" selected="true" />
|
|
|
472 |
<filter-element type="OBJECT" id="constraint" selected="true" />
|
|
|
473 |
<filter-element type="OBJECT" id="trigger" selected="true" />
|
|
|
474 |
<filter-element type="OBJECT" id="synonym" selected="true" />
|
|
|
475 |
<filter-element type="OBJECT" id="sequence" selected="true" />
|
|
|
476 |
<filter-element type="OBJECT" id="procedure" selected="true" />
|
|
|
477 |
<filter-element type="OBJECT" id="function" selected="true" />
|
|
|
478 |
<filter-element type="OBJECT" id="package" selected="true" />
|
|
|
479 |
<filter-element type="OBJECT" id="type" selected="true" />
|
|
|
480 |
<filter-element type="OBJECT" id="dimension" selected="true" />
|
|
|
481 |
<filter-element type="OBJECT" id="cluster" selected="true" />
|
|
|
482 |
<filter-element type="OBJECT" id="dblink" selected="true" />
|
|
|
483 |
</user-schema>
|
|
|
484 |
<public-schema>
|
|
|
485 |
<filter-element type="OBJECT" id="table" selected="true" />
|
|
|
486 |
<filter-element type="OBJECT" id="view" selected="true" />
|
|
|
487 |
<filter-element type="OBJECT" id="materialized view" selected="true" />
|
|
|
488 |
<filter-element type="OBJECT" id="index" selected="true" />
|
|
|
489 |
<filter-element type="OBJECT" id="constraint" selected="true" />
|
|
|
490 |
<filter-element type="OBJECT" id="trigger" selected="true" />
|
|
|
491 |
<filter-element type="OBJECT" id="synonym" selected="true" />
|
|
|
492 |
<filter-element type="OBJECT" id="sequence" selected="true" />
|
|
|
493 |
<filter-element type="OBJECT" id="procedure" selected="true" />
|
|
|
494 |
<filter-element type="OBJECT" id="function" selected="true" />
|
|
|
495 |
<filter-element type="OBJECT" id="package" selected="true" />
|
|
|
496 |
<filter-element type="OBJECT" id="type" selected="true" />
|
|
|
497 |
<filter-element type="OBJECT" id="dimension" selected="true" />
|
|
|
498 |
<filter-element type="OBJECT" id="cluster" selected="true" />
|
|
|
499 |
<filter-element type="OBJECT" id="dblink" selected="true" />
|
|
|
500 |
</public-schema>
|
|
|
501 |
<any-schema>
|
|
|
502 |
<filter-element type="OBJECT" id="table" selected="true" />
|
|
|
503 |
<filter-element type="OBJECT" id="view" selected="true" />
|
|
|
504 |
<filter-element type="OBJECT" id="materialized view" selected="true" />
|
|
|
505 |
<filter-element type="OBJECT" id="index" selected="true" />
|
|
|
506 |
<filter-element type="OBJECT" id="constraint" selected="true" />
|
|
|
507 |
<filter-element type="OBJECT" id="trigger" selected="true" />
|
|
|
508 |
<filter-element type="OBJECT" id="synonym" selected="true" />
|
|
|
509 |
<filter-element type="OBJECT" id="sequence" selected="true" />
|
|
|
510 |
<filter-element type="OBJECT" id="procedure" selected="true" />
|
|
|
511 |
<filter-element type="OBJECT" id="function" selected="true" />
|
|
|
512 |
<filter-element type="OBJECT" id="package" selected="true" />
|
|
|
513 |
<filter-element type="OBJECT" id="type" selected="true" />
|
|
|
514 |
<filter-element type="OBJECT" id="dimension" selected="true" />
|
|
|
515 |
<filter-element type="OBJECT" id="cluster" selected="true" />
|
|
|
516 |
<filter-element type="OBJECT" id="dblink" selected="true" />
|
|
|
517 |
</any-schema>
|
|
|
518 |
</extended-filter>
|
|
|
519 |
</filters>
|
|
|
520 |
<sorting enabled="true">
|
|
|
521 |
<sorting-element type="RESERVED_WORD" id="keyword" />
|
|
|
522 |
<sorting-element type="RESERVED_WORD" id="datatype" />
|
|
|
523 |
<sorting-element type="OBJECT" id="column" />
|
|
|
524 |
<sorting-element type="OBJECT" id="table" />
|
|
|
525 |
<sorting-element type="OBJECT" id="view" />
|
|
|
526 |
<sorting-element type="OBJECT" id="materialized view" />
|
|
|
527 |
<sorting-element type="OBJECT" id="index" />
|
|
|
528 |
<sorting-element type="OBJECT" id="constraint" />
|
|
|
529 |
<sorting-element type="OBJECT" id="trigger" />
|
|
|
530 |
<sorting-element type="OBJECT" id="synonym" />
|
|
|
531 |
<sorting-element type="OBJECT" id="sequence" />
|
|
|
532 |
<sorting-element type="OBJECT" id="procedure" />
|
|
|
533 |
<sorting-element type="OBJECT" id="function" />
|
|
|
534 |
<sorting-element type="OBJECT" id="package" />
|
|
|
535 |
<sorting-element type="OBJECT" id="type" />
|
|
|
536 |
<sorting-element type="OBJECT" id="dimension" />
|
|
|
537 |
<sorting-element type="OBJECT" id="cluster" />
|
|
|
538 |
<sorting-element type="OBJECT" id="dblink" />
|
|
|
539 |
<sorting-element type="OBJECT" id="schema" />
|
|
|
540 |
<sorting-element type="OBJECT" id="role" />
|
|
|
541 |
<sorting-element type="OBJECT" id="user" />
|
|
|
542 |
<sorting-element type="RESERVED_WORD" id="function" />
|
|
|
543 |
<sorting-element type="RESERVED_WORD" id="parameter" />
|
|
|
544 |
</sorting>
|
|
|
545 |
<format>
|
|
|
546 |
<enforce-code-style-case value="true" />
|
|
|
547 |
</format>
|
|
|
548 |
</code-completion-settings>
|
|
|
549 |
<execution-engine-settings>
|
|
|
550 |
<statement-execution>
|
|
|
551 |
<fetch-block-size value="100" />
|
|
|
552 |
<execution-timeout value="20" />
|
|
|
553 |
<debug-execution-timeout value="600" />
|
|
|
554 |
<focus-result value="false" />
|
|
|
555 |
<prompt-execution value="false" />
|
|
|
556 |
</statement-execution>
|
|
|
557 |
<script-execution>
|
|
|
558 |
<command-line-interfaces />
|
|
|
559 |
<execution-timeout value="300" />
|
|
|
560 |
</script-execution>
|
|
|
561 |
<method-execution>
|
|
|
562 |
<execution-timeout value="30" />
|
|
|
563 |
<debug-execution-timeout value="600" />
|
|
|
564 |
<parameter-history-size value="10" />
|
|
|
565 |
</method-execution>
|
|
|
566 |
</execution-engine-settings>
|
|
|
567 |
<operation-settings>
|
|
|
568 |
<transactions>
|
|
|
569 |
<uncommitted-changes>
|
|
|
570 |
<on-project-close value="ASK" />
|
|
|
571 |
<on-disconnect value="ASK" />
|
|
|
572 |
<on-autocommit-toggle value="ASK" />
|
|
|
573 |
</uncommitted-changes>
|
|
|
574 |
<multiple-uncommitted-changes>
|
|
|
575 |
<on-commit value="ASK" />
|
|
|
576 |
<on-rollback value="ASK" />
|
|
|
577 |
</multiple-uncommitted-changes>
|
|
|
578 |
</transactions>
|
|
|
579 |
<session-browser>
|
|
|
580 |
<disconnect-session value="ASK" />
|
|
|
581 |
<kill-session value="ASK" />
|
|
|
582 |
<reload-on-filter-change value="false" />
|
|
|
583 |
</session-browser>
|
|
|
584 |
<compiler>
|
|
|
585 |
<compile-type value="KEEP" />
|
|
|
586 |
<compile-dependencies value="ASK" />
|
|
|
587 |
<always-show-controls value="false" />
|
|
|
588 |
</compiler>
|
|
|
589 |
<debugger>
|
|
|
590 |
<debugger-type value="ASK" />
|
|
|
591 |
</debugger>
|
|
|
592 |
</operation-settings>
|
|
|
593 |
<ddl-file-settings>
|
|
|
594 |
<extensions>
|
|
|
595 |
<mapping file-type-id="VIEW" extensions="vw" />
|
|
|
596 |
<mapping file-type-id="TRIGGER" extensions="trg" />
|
|
|
597 |
<mapping file-type-id="PROCEDURE" extensions="prc" />
|
|
|
598 |
<mapping file-type-id="FUNCTION" extensions="fnc" />
|
|
|
599 |
<mapping file-type-id="PACKAGE" extensions="pkg" />
|
|
|
600 |
<mapping file-type-id="PACKAGE_SPEC" extensions="pks" />
|
|
|
601 |
<mapping file-type-id="PACKAGE_BODY" extensions="pkb" />
|
|
|
602 |
<mapping file-type-id="TYPE" extensions="tpe" />
|
|
|
603 |
<mapping file-type-id="TYPE_SPEC" extensions="tps" />
|
|
|
604 |
<mapping file-type-id="TYPE_BODY" extensions="tpb" />
|
|
|
605 |
</extensions>
|
|
|
606 |
<general>
|
|
|
607 |
<lookup-ddl-files value="true" />
|
|
|
608 |
<create-ddl-files value="false" />
|
|
|
609 |
<synchronize-ddl-files value="true" />
|
|
|
610 |
<use-qualified-names value="false" />
|
|
|
611 |
<make-scripts-rerunnable value="true" />
|
|
|
612 |
</general>
|
|
|
613 |
</ddl-file-settings>
|
|
|
614 |
<general-settings>
|
|
|
615 |
<regional-settings>
|
|
|
616 |
<date-format value="MEDIUM" />
|
|
|
617 |
<number-format value="UNGROUPED" />
|
|
|
618 |
<locale value="SYSTEM_DEFAULT" />
|
|
|
619 |
<use-custom-formats value="false" />
|
|
|
620 |
</regional-settings>
|
|
|
621 |
<environment>
|
|
|
622 |
<environment-types>
|
|
|
623 |
<environment-type id="development" name="Development" description="Development environment" color="-2430209/-12296320" readonly-code="false" readonly-data="false" />
|
|
|
624 |
<environment-type id="integration" name="Integration" description="Integration environment" color="-2621494/-12163514" readonly-code="true" readonly-data="false" />
|
|
|
625 |
<environment-type id="production" name="Production" description="Productive environment" color="-11574/-10271420" readonly-code="true" readonly-data="true" />
|
|
|
626 |
<environment-type id="other" name="Other" description="" color="-1576/-10724543" readonly-code="false" readonly-data="false" />
|
|
|
627 |
</environment-types>
|
|
|
628 |
<visibility-settings>
|
|
|
629 |
<connection-tabs value="true" />
|
|
|
630 |
<dialog-headers value="true" />
|
|
|
631 |
<object-editor-tabs value="true" />
|
|
|
632 |
<script-editor-tabs value="false" />
|
|
|
633 |
<execution-result-tabs value="true" />
|
|
|
634 |
</visibility-settings>
|
|
|
635 |
</environment>
|
|
|
636 |
</general-settings>
|
|
|
637 |
</component>
|
|
|
638 |
<component name="DBNavigator.Project.StatementExecutionManager">
|
|
|
639 |
<execution-variables />
|
|
|
640 |
<execution-variable-types />
|
|
|
641 |
</component>
|
|
|
642 |
</project>
|