source: mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll @ 8064

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll@8064
Revision 8064, 21.4 KB checked in by mnagni, 8 years ago (diff)

Now generate the inner class attributes and table relations which manage the attribute subtyping (at least for no more than the same subtyping attribute for each class)

Line 
1 SELECT   
2 'DROP TABLE IF EXISTS '||c.relname ||' CASCADE;' 
3 FROM pg_catalog.pg_class c 
4 JOIN pg_catalog.pg_roles r ON r.oid = c.relowner 
5 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace 
6 WHERE c.relkind IN ('r','') 
7 AND n.nspname NOT IN ('pg_catalog', 'pg_toast') 
8 AND pg_catalog.pg_table_is_visible(c.oid) 
9 ORDER BY 1; 
10
11SELECT   
12 'DROP SEQUENCE IF EXISTS '||c.relname ||' CASCADE;' 
13 FROM pg_catalog.pg_class c 
14 JOIN pg_catalog.pg_roles r ON r.oid = c.relowner 
15 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace 
16 WHERE c.relkind IN ('S','') 
17 AND n.nspname NOT IN ('pg_catalog', 'pg_toast') 
18 AND pg_catalog.pg_table_is_visible(c.oid) 
19 ORDER BY 1; 
20
21"DROP SEQUENCE IF EXISTS any_id_seq CASCADE;"
22"DROP SEQUENCE IF EXISTS cc_concatenatedoperation_id_seq CASCADE;"
23"DROP SEQUENCE IF EXISTS cc_conversion_id_seq CASCADE;"
24"DROP SEQUENCE IF EXISTS cc_coordinateoperation_id_seq CASCADE;"
25"DROP SEQUENCE IF EXISTS cc_formula_id_seq CASCADE;"
26"DROP SEQUENCE IF EXISTS cc_generaloperationparameter_id_seq CASCADE;"
27"DROP SEQUENCE IF EXISTS cc_generalparametervalue_id_seq CASCADE;"
28"DROP SEQUENCE IF EXISTS cc_operationmethod_id_seq CASCADE;"
29"DROP SEQUENCE IF EXISTS cc_operationparametergroup_id_seq CASCADE;"
30"DROP SEQUENCE IF EXISTS cc_parametervaluegroup_id_seq CASCADE;"
31"DROP SEQUENCE IF EXISTS cc_passthroughoperation_id_seq CASCADE;"
32"DROP SEQUENCE IF EXISTS cc_singleoperation_id_seq CASCADE;"
33"DROP SEQUENCE IF EXISTS cd_datum_id_seq CASCADE;"
34"DROP SEQUENCE IF EXISTS cd_verticaldatum_id_seq CASCADE;"
35"DROP SEQUENCE IF EXISTS ceda_acquisition_id_seq CASCADE;"
36"DROP SEQUENCE IF EXISTS ceda_citation_id_seq CASCADE;"
37"DROP SEQUENCE IF EXISTS ceda_compositeprocess_id_seq CASCADE;"
38"DROP SEQUENCE IF EXISTS ceda_instrument_id_seq CASCADE;"
39"DROP SEQUENCE IF EXISTS ceda_notes_id_seq CASCADE;"
40"DROP SEQUENCE IF EXISTS ceda_observationcollection_id_seq CASCADE;"
41"DROP SEQUENCE IF EXISTS ceda_observation_id_seq CASCADE;"
42"DROP SEQUENCE IF EXISTS ceda_operation_id_seq CASCADE;"
43"DROP SEQUENCE IF EXISTS ceda_platform_id_seq CASCADE;"
44"DROP SEQUENCE IF EXISTS ceda_process_id_seq CASCADE;"
45"DROP SEQUENCE IF EXISTS ceda_processing_id_seq CASCADE;"
46"DROP SEQUENCE IF EXISTS ceda_project_id_seq CASCADE;"
47"DROP SEQUENCE IF EXISTS ceda_result_id_seq CASCADE;"
48"DROP SEQUENCE IF EXISTS ceda_review_id_seq CASCADE;"
49"DROP SEQUENCE IF EXISTS ci_address_id_seq CASCADE;"
50"DROP SEQUENCE IF EXISTS ci_citation_id_seq CASCADE;"
51"DROP SEQUENCE IF EXISTS ci_contact_id_seq CASCADE;"
52"DROP SEQUENCE IF EXISTS ci_date_id_seq CASCADE;"
53"DROP SEQUENCE IF EXISTS ci_individual_id_seq CASCADE;"
54"DROP SEQUENCE IF EXISTS ci_onlineresource_id_seq CASCADE;"
55"DROP SEQUENCE IF EXISTS ci_organisation_id_seq CASCADE;"
56"DROP SEQUENCE IF EXISTS ci_party_id_seq CASCADE;"
57"DROP SEQUENCE IF EXISTS ci_responsibility_id_seq CASCADE;"
58"DROP SEQUENCE IF EXISTS ci_responsibleparty_id_seq CASCADE;"
59"DROP SEQUENCE IF EXISTS ci_responsiblepartyinfo_id_seq CASCADE;"
60"DROP SEQUENCE IF EXISTS ci_series_id_seq CASCADE;"
61"DROP SEQUENCE IF EXISTS ci_telephone_id_seq CASCADE;"
62"DROP SEQUENCE IF EXISTS class13_0_id_seq CASCADE;"
63"DROP SEQUENCE IF EXISTS class13_1_id_seq CASCADE;"
64"DROP SEQUENCE IF EXISTS class13_2_id_seq CASCADE;"
65"DROP SEQUENCE IF EXISTS class13_3_id_seq CASCADE;"
66"DROP SEQUENCE IF EXISTS cl_dataset_id_seq CASCADE;"
67"DROP SEQUENCE IF EXISTS clocktime_id_seq CASCADE;"
68"DROP SEQUENCE IF EXISTS cs_coordinatesystemaxis_id_seq CASCADE;"
69"DROP SEQUENCE IF EXISTS cs_coordinatesystem_id_seq CASCADE;"
70"DROP SEQUENCE IF EXISTS cs_verticalcs_id_seq CASCADE;"
71"DROP SEQUENCE IF EXISTS cv_attributevalues_id_seq CASCADE;"
72"DROP SEQUENCE IF EXISTS cv_coverage_id_seq CASCADE;"
73"DROP SEQUENCE IF EXISTS cv_domainobject_id_seq CASCADE;"
74"DROP SEQUENCE IF EXISTS cv_footprint_id_seq CASCADE;"
75"DROP SEQUENCE IF EXISTS cv_gridcell_id_seq CASCADE;"
76"DROP SEQUENCE IF EXISTS cv_gridcoordinate_id_seq CASCADE;"
77"DROP SEQUENCE IF EXISTS cv_gridenvelope_id_seq CASCADE;"
78"DROP SEQUENCE IF EXISTS cv_grid_id_seq CASCADE;"
79"DROP SEQUENCE IF EXISTS cv_gridpoint_id_seq CASCADE;"
80"DROP SEQUENCE IF EXISTS cv_referenceablegrid_id_seq CASCADE;"
81"DROP SEQUENCE IF EXISTS date_id_seq CASCADE;"
82"DROP SEQUENCE IF EXISTS dateprecision_id_seq CASCADE;"
83"DROP SEQUENCE IF EXISTS datetime_id_seq CASCADE;"
84"DROP SEQUENCE IF EXISTS directposition_id_seq CASCADE;"
85"DROP SEQUENCE IF EXISTS distance_id_seq CASCADE;"
86"DROP SEQUENCE IF EXISTS dq_dataquality_id_seq CASCADE;"
87"DROP SEQUENCE IF EXISTS dq_element_id_seq CASCADE;"
88"DROP SEQUENCE IF EXISTS dq_positionalaccuracy_id_seq CASCADE;"
89"DROP SEQUENCE IF EXISTS dq_result_id_seq CASCADE;"
90"DROP SEQUENCE IF EXISTS dq_scope_id_seq CASCADE;"
91"DROP SEQUENCE IF EXISTS ds_aggregate_id_seq CASCADE;"
92"DROP SEQUENCE IF EXISTS ds_dataset_id_seq CASCADE;"
93"DROP SEQUENCE IF EXISTS earootclass_id_seq CASCADE;"
94"DROP SEQUENCE IF EXISTS ex_extent_id_seq CASCADE;"
95"DROP SEQUENCE IF EXISTS ex_geographicdescription_id_seq CASCADE;"
96"DROP SEQUENCE IF EXISTS ex_geographicextent_id_seq CASCADE;"
97"DROP SEQUENCE IF EXISTS ex_temporalextent_id_seq CASCADE;"
98"DROP SEQUENCE IF EXISTS ex_verticalextent_id_seq CASCADE;"
99"DROP SEQUENCE IF EXISTS genericname_id_seq CASCADE;"
100"DROP SEQUENCE IF EXISTS gf_associationrole_id_seq CASCADE;"
101"DROP SEQUENCE IF EXISTS gf_associationtype_id_seq CASCADE;"
102"DROP SEQUENCE IF EXISTS gf_attributetype_id_seq CASCADE;"
103"DROP SEQUENCE IF EXISTS gf_constraint_id_seq CASCADE;"
104"DROP SEQUENCE IF EXISTS gf_featuretype_id_seq CASCADE;"
105"DROP SEQUENCE IF EXISTS gfi_feature_id_seq CASCADE;"
106"DROP SEQUENCE IF EXISTS gf_inheritancerelation_id_seq CASCADE;"
107"DROP SEQUENCE IF EXISTS gf_operation_id_seq CASCADE;"
108"DROP SEQUENCE IF EXISTS gf_propertytype_id_seq CASCADE;"
109"DROP SEQUENCE IF EXISTS gm_complex_id_seq CASCADE;"
110"DROP SEQUENCE IF EXISTS gm_composite_id_seq CASCADE;"
111"DROP SEQUENCE IF EXISTS gm_compositepoint_id_seq CASCADE;"
112"DROP SEQUENCE IF EXISTS gm_object_id_seq CASCADE;"
113"DROP SEQUENCE IF EXISTS gm_orientableprimitive_id_seq CASCADE;"
114"DROP SEQUENCE IF EXISTS gm_point_id_seq CASCADE;"
115"DROP SEQUENCE IF EXISTS gm_primitive_id_seq CASCADE;"
116"DROP SEQUENCE IF EXISTS io_identifiedobjectbase_id_seq CASCADE;"
117"DROP SEQUENCE IF EXISTS io_identifiedobject_id_seq CASCADE;"
118"DROP SEQUENCE IF EXISTS le_algorithm_id_seq CASCADE;"
119"DROP SEQUENCE IF EXISTS length_id_seq CASCADE;"
120"DROP SEQUENCE IF EXISTS le_nominalresolution_id_seq CASCADE;"
121"DROP SEQUENCE IF EXISTS le_source_id_seq CASCADE;"
122"DROP SEQUENCE IF EXISTS li_lineage_id_seq CASCADE;"
123"DROP SEQUENCE IF EXISTS li_processstep_id_seq CASCADE;"
124"DROP SEQUENCE IF EXISTS li_source_id_seq CASCADE;"
125"DROP SEQUENCE IF EXISTS localname_id_seq CASCADE;"
126"DROP SEQUENCE IF EXISTS md_aggregateinformation_id_seq CASCADE;"
127"DROP SEQUENCE IF EXISTS md_applicationschemainformation_id_seq CASCADE;"
128"DROP SEQUENCE IF EXISTS md_browsegraphic_id_seq CASCADE;"
129"DROP SEQUENCE IF EXISTS md_constraints_id_seq CASCADE;"
130"DROP SEQUENCE IF EXISTS md_contentinformation_id_seq CASCADE;"
131"DROP SEQUENCE IF EXISTS md_digitaltransferoptions_id_seq CASCADE;"
132"DROP SEQUENCE IF EXISTS md_distribution_id_seq CASCADE;"
133"DROP SEQUENCE IF EXISTS md_distributor_id_seq CASCADE;"
134"DROP SEQUENCE IF EXISTS md_extendedelementinformation_id_seq CASCADE;"
135"DROP SEQUENCE IF EXISTS md_format_id_seq CASCADE;"
136"DROP SEQUENCE IF EXISTS md_identification_id_seq CASCADE;"
137"DROP SEQUENCE IF EXISTS md_identifier_id_seq CASCADE;"
138"DROP SEQUENCE IF EXISTS md_keywords_id_seq CASCADE;"
139"DROP SEQUENCE IF EXISTS md_maintenanceinformation_id_seq CASCADE;"
140"DROP SEQUENCE IF EXISTS md_medium_id_seq CASCADE;"
141"DROP SEQUENCE IF EXISTS md_metadataextensioninformation_id_seq CASCADE;"
142"DROP SEQUENCE IF EXISTS md_metadata_id_seq CASCADE;"
143"DROP SEQUENCE IF EXISTS md_portrayalcataloguereference_id_seq CASCADE;"
144"DROP SEQUENCE IF EXISTS md_referencesystem_id_seq CASCADE;"
145"DROP SEQUENCE IF EXISTS md_representativefraction_id_seq CASCADE;"
146"DROP SEQUENCE IF EXISTS md_scopedescription_id_seq CASCADE;"
147"DROP SEQUENCE IF EXISTS md_spatialrepresentation_id_seq CASCADE;"
148"DROP SEQUENCE IF EXISTS md_standardorderprocess_id_seq CASCADE;"
149"DROP SEQUENCE IF EXISTS md_usage_id_seq CASCADE;"
150"DROP SEQUENCE IF EXISTS measure_id_seq CASCADE;"
151"DROP SEQUENCE IF EXISTS mo_acquisition_id_seq CASCADE;"
152"DROP SEQUENCE IF EXISTS mo_compositeprocess_id_seq CASCADE;"
153"DROP SEQUENCE IF EXISTS mo_computation_id_seq CASCADE;"
154"DROP SEQUENCE IF EXISTS mo_inputoutput_id_seq CASCADE;"
155"DROP SEQUENCE IF EXISTS mo_instrument_id_seq CASCADE;"
156"DROP SEQUENCE IF EXISTS mo_instrumentplatformpair_id_seq CASCADE;"
157"DROP SEQUENCE IF EXISTS mo_location_id_seq CASCADE;"
158"DROP SEQUENCE IF EXISTS mo_observationcollection_id_seq CASCADE;"
159"DROP SEQUENCE IF EXISTS mo_observation_id_seq CASCADE;"
160"DROP SEQUENCE IF EXISTS mo_onlineresource_id_seq CASCADE;"
161"DROP SEQUENCE IF EXISTS mo_operation_id_seq CASCADE;"
162"DROP SEQUENCE IF EXISTS mo_organization_id_seq CASCADE;"
163"DROP SEQUENCE IF EXISTS mo_platform_id_seq CASCADE;"
164"DROP SEQUENCE IF EXISTS mo_process_id_seq CASCADE;"
165"DROP SEQUENCE IF EXISTS mo_processing_id_seq CASCADE;"
166"DROP SEQUENCE IF EXISTS mo_project_id_seq CASCADE;"
167"DROP SEQUENCE IF EXISTS mo_responsiblepartyinfo_id_seq CASCADE;"
168"DROP SEQUENCE IF EXISTS mo_result_id_seq CASCADE;"
169"DROP SEQUENCE IF EXISTS multiplicity_id_seq CASCADE;"
170"DROP SEQUENCE IF EXISTS multiplicityrange_id_seq CASCADE;"
171"DROP SEQUENCE IF EXISTS namedvalue_id_seq CASCADE;"
172"DROP SEQUENCE IF EXISTS namespace_id_seq CASCADE;"
173"DROP SEQUENCE IF EXISTS om_observation_id_seq CASCADE;"
174"DROP SEQUENCE IF EXISTS om_process_id_seq CASCADE;"
175"DROP SEQUENCE IF EXISTS record_id_seq CASCADE;"
176"DROP SEQUENCE IF EXISTS recordtype_id_seq CASCADE;"
177"DROP SEQUENCE IF EXISTS rs_identifier_id_seq CASCADE;"
178"DROP SEQUENCE IF EXISTS rs_referencesystem_id_seq CASCADE;"
179"DROP SEQUENCE IF EXISTS scale_id_seq CASCADE;"
180"DROP SEQUENCE IF EXISTS sc_compoundcrs_id_seq CASCADE;"
181"DROP SEQUENCE IF EXISTS sc_crs_id_seq CASCADE;"
182"DROP SEQUENCE IF EXISTS sc_derivedcrs_id_seq CASCADE;"
183"DROP SEQUENCE IF EXISTS sc_generalderivedcrs_id_seq CASCADE;"
184"DROP SEQUENCE IF EXISTS schema_id_seq CASCADE;"
185"DROP SEQUENCE IF EXISTS scopedname_id_seq CASCADE;"
186"DROP SEQUENCE IF EXISTS sc_singlecrs_id_seq CASCADE;"
187"DROP SEQUENCE IF EXISTS sc_verticalcrs_id_seq CASCADE;"
188"DROP SEQUENCE IF EXISTS time_id_seq CASCADE;"
189"DROP SEQUENCE IF EXISTS tm_complex_id_seq CASCADE;"
190"DROP SEQUENCE IF EXISTS tm_duration_id_seq CASCADE;"
191"DROP SEQUENCE IF EXISTS tm_edge_id_seq CASCADE;"
192"DROP SEQUENCE IF EXISTS tm_geometricprimitive_id_seq CASCADE;"
193"DROP SEQUENCE IF EXISTS tm_instant_id_seq CASCADE;"
194"DROP SEQUENCE IF EXISTS tm_node_id_seq CASCADE;"
195"DROP SEQUENCE IF EXISTS tm_object_id_seq CASCADE;"
196"DROP SEQUENCE IF EXISTS tm_periodduration_id_seq CASCADE;"
197"DROP SEQUENCE IF EXISTS tm_period_id_seq CASCADE;"
198"DROP SEQUENCE IF EXISTS tm_position_id_seq CASCADE;"
199"DROP SEQUENCE IF EXISTS tm_primitive_id_seq CASCADE;"
200"DROP SEQUENCE IF EXISTS tm_referencesystem_id_seq CASCADE;"
201"DROP SEQUENCE IF EXISTS tm_temporalposition_id_seq CASCADE;"
202"DROP SEQUENCE IF EXISTS tm_topologicalcomplex_id_seq CASCADE;"
203"DROP SEQUENCE IF EXISTS tm_topologicalprimitive_id_seq CASCADE;"
204"DROP SEQUENCE IF EXISTS tp_complex_id_seq CASCADE;"
205"DROP SEQUENCE IF EXISTS tp_directedtopo_id_seq CASCADE;"
206"DROP SEQUENCE IF EXISTS tp_expression_id_seq CASCADE;"
207"DROP SEQUENCE IF EXISTS tp_expressionterm_id_seq CASCADE;"
208"DROP SEQUENCE IF EXISTS tp_primitive_id_seq CASCADE;"
209"DROP SEQUENCE IF EXISTS type_id_seq CASCADE;"
210"DROP SEQUENCE IF EXISTS typename_id_seq CASCADE;"
211"DROP SEQUENCE IF EXISTS unitofmeasure_id_seq CASCADE;"
212"DROP SEQUENCE IF EXISTS unlimitedinteger_id_seq CASCADE;"
213"DROP SEQUENCE IF EXISTS uomlength_id_seq CASCADE;"
214"DROP SEQUENCE IF EXISTS uomscale_id_seq CASCADE;"
215"DROP SEQUENCE IF EXISTS url_id_seq CASCADE;"
216
217
218"DROP TABLE IF EXISTS any CASCADE;"
219"DROP TABLE IF EXISTS cc_concatenatedoperation CASCADE;"
220"DROP TABLE IF EXISTS cc_conversion CASCADE;"
221"DROP TABLE IF EXISTS cc_coordinateoperation CASCADE;"
222"DROP TABLE IF EXISTS cc_formula CASCADE;"
223"DROP TABLE IF EXISTS cc_generaloperationparameter CASCADE;"
224"DROP TABLE IF EXISTS cc_generalparametervalue CASCADE;"
225"DROP TABLE IF EXISTS cc_operationmethod CASCADE;"
226"DROP TABLE IF EXISTS cc_operationparametergroup CASCADE;"
227"DROP TABLE IF EXISTS cc_parametervaluegroup CASCADE;"
228"DROP TABLE IF EXISTS cc_passthroughoperation CASCADE;"
229"DROP TABLE IF EXISTS cc_singleoperation CASCADE;"
230"DROP TABLE IF EXISTS cd_datum CASCADE;"
231"DROP TABLE IF EXISTS cd_verticaldatum CASCADE;"
232"DROP TABLE IF EXISTS ceda_acquisition CASCADE;"
233"DROP TABLE IF EXISTS ceda_citation CASCADE;"
234"DROP TABLE IF EXISTS ceda_compositeprocess CASCADE;"
235"DROP TABLE IF EXISTS ceda_instrument CASCADE;"
236"DROP TABLE IF EXISTS ceda_notes CASCADE;"
237"DROP TABLE IF EXISTS ceda_observation CASCADE;"
238"DROP TABLE IF EXISTS ceda_observationcollection CASCADE;"
239"DROP TABLE IF EXISTS ceda_operation CASCADE;"
240"DROP TABLE IF EXISTS ceda_platform CASCADE;"
241"DROP TABLE IF EXISTS ceda_process CASCADE;"
242"DROP TABLE IF EXISTS ceda_processing CASCADE;"
243"DROP TABLE IF EXISTS ceda_project CASCADE;"
244"DROP TABLE IF EXISTS ceda_result CASCADE;"
245"DROP TABLE IF EXISTS ceda_review CASCADE;"
246"DROP TABLE IF EXISTS ci_address CASCADE;"
247"DROP TABLE IF EXISTS ci_citation CASCADE;"
248"DROP TABLE IF EXISTS ci_contact CASCADE;"
249"DROP TABLE IF EXISTS ci_date CASCADE;"
250"DROP TABLE IF EXISTS ci_individual CASCADE;"
251"DROP TABLE IF EXISTS ci_onlineresource CASCADE;"
252"DROP TABLE IF EXISTS ci_organisation CASCADE;"
253"DROP TABLE IF EXISTS ci_party CASCADE;"
254"DROP TABLE IF EXISTS ci_responsibility CASCADE;"
255"DROP TABLE IF EXISTS ci_responsibleparty CASCADE;"
256"DROP TABLE IF EXISTS ci_responsiblepartyinfo CASCADE;"
257"DROP TABLE IF EXISTS ci_series CASCADE;"
258"DROP TABLE IF EXISTS ci_telephone CASCADE;"
259"DROP TABLE IF EXISTS class13_0 CASCADE;"
260"DROP TABLE IF EXISTS class13_1 CASCADE;"
261"DROP TABLE IF EXISTS class13_2 CASCADE;"
262"DROP TABLE IF EXISTS class13_3 CASCADE;"
263"DROP TABLE IF EXISTS cl_dataset CASCADE;"
264"DROP TABLE IF EXISTS clocktime CASCADE;"
265"DROP TABLE IF EXISTS cs_coordinatesystemaxis CASCADE;"
266"DROP TABLE IF EXISTS cs_coordinatesystem CASCADE;"
267"DROP TABLE IF EXISTS cs_verticalcs CASCADE;"
268"DROP TABLE IF EXISTS cv_attributevalues CASCADE;"
269"DROP TABLE IF EXISTS cv_coverage CASCADE;"
270"DROP TABLE IF EXISTS cv_domainobject CASCADE;"
271"DROP TABLE IF EXISTS cv_footprint CASCADE;"
272"DROP TABLE IF EXISTS cv_grid CASCADE;"
273"DROP TABLE IF EXISTS cv_gridcell CASCADE;"
274"DROP TABLE IF EXISTS cv_gridcoordinate CASCADE;"
275"DROP TABLE IF EXISTS cv_gridenvelope CASCADE;"
276"DROP TABLE IF EXISTS cv_gridpoint CASCADE;"
277"DROP TABLE IF EXISTS cv_referenceablegrid CASCADE;"
278"DROP TABLE IF EXISTS date CASCADE;"
279"DROP TABLE IF EXISTS dateprecision CASCADE;"
280"DROP TABLE IF EXISTS datetime CASCADE;"
281"DROP TABLE IF EXISTS directposition CASCADE;"
282"DROP TABLE IF EXISTS distance CASCADE;"
283"DROP TABLE IF EXISTS dq_dataquality CASCADE;"
284"DROP TABLE IF EXISTS dq_element CASCADE;"
285"DROP TABLE IF EXISTS dq_positionalaccuracy CASCADE;"
286"DROP TABLE IF EXISTS dq_result CASCADE;"
287"DROP TABLE IF EXISTS dq_scope CASCADE;"
288"DROP TABLE IF EXISTS ds_aggregate CASCADE;"
289"DROP TABLE IF EXISTS ds_aggregate_ds_aggregate CASCADE;"
290"DROP TABLE IF EXISTS ds_dataset CASCADE;"
291"DROP TABLE IF EXISTS earootclass CASCADE;"
292"DROP TABLE IF EXISTS ex_extent CASCADE;"
293"DROP TABLE IF EXISTS ex_geographicdescription CASCADE;"
294"DROP TABLE IF EXISTS ex_geographicextent CASCADE;"
295"DROP TABLE IF EXISTS ex_temporalextent CASCADE;"
296"DROP TABLE IF EXISTS ex_verticalextent CASCADE;"
297"DROP TABLE IF EXISTS genericname CASCADE;"
298"DROP TABLE IF EXISTS gf_associationrole CASCADE;"
299"DROP TABLE IF EXISTS gf_associationtype CASCADE;"
300"DROP TABLE IF EXISTS gf_attributetype CASCADE;"
301"DROP TABLE IF EXISTS gf_attributetype_gf_attributetype CASCADE;"
302"DROP TABLE IF EXISTS gf_constraint CASCADE;"
303"DROP TABLE IF EXISTS gf_featuretype CASCADE;"
304"DROP TABLE IF EXISTS gfi_feature CASCADE;"
305"DROP TABLE IF EXISTS gf_inheritancerelation CASCADE;"
306"DROP TABLE IF EXISTS gf_operation CASCADE;"
307"DROP TABLE IF EXISTS gf_propertytype CASCADE;"
308"DROP TABLE IF EXISTS gm_complex CASCADE;"
309"DROP TABLE IF EXISTS gm_complex_gm_complex CASCADE;"
310"DROP TABLE IF EXISTS gm_composite CASCADE;"
311"DROP TABLE IF EXISTS gm_compositepoint CASCADE;"
312"DROP TABLE IF EXISTS gm_object CASCADE;"
313"DROP TABLE IF EXISTS gm_orientableprimitive CASCADE;"
314"DROP TABLE IF EXISTS gm_point CASCADE;"
315"DROP TABLE IF EXISTS gm_primitive CASCADE;"
316"DROP TABLE IF EXISTS gm_primitive_gm_primitive CASCADE;"
317"DROP TABLE IF EXISTS io_identifiedobjectbase CASCADE;"
318"DROP TABLE IF EXISTS io_identifiedobject CASCADE;"
319"DROP TABLE IF EXISTS le_algorithm CASCADE;"
320"DROP TABLE IF EXISTS length CASCADE;"
321"DROP TABLE IF EXISTS le_nominalresolution CASCADE;"
322"DROP TABLE IF EXISTS le_source CASCADE;"
323"DROP TABLE IF EXISTS li_lineage CASCADE;"
324"DROP TABLE IF EXISTS li_processstep CASCADE;"
325"DROP TABLE IF EXISTS li_source CASCADE;"
326"DROP TABLE IF EXISTS localname CASCADE;"
327"DROP TABLE IF EXISTS md_aggregateinformation CASCADE;"
328"DROP TABLE IF EXISTS md_applicationschemainformation CASCADE;"
329"DROP TABLE IF EXISTS md_browsegraphic CASCADE;"
330"DROP TABLE IF EXISTS md_constraints CASCADE;"
331"DROP TABLE IF EXISTS md_contentinformation CASCADE;"
332"DROP TABLE IF EXISTS md_digitaltransferoptions CASCADE;"
333"DROP TABLE IF EXISTS md_distribution CASCADE;"
334"DROP TABLE IF EXISTS md_distributor CASCADE;"
335"DROP TABLE IF EXISTS md_extendedelementinformation CASCADE;"
336"DROP TABLE IF EXISTS md_format CASCADE;"
337"DROP TABLE IF EXISTS md_identification CASCADE;"
338"DROP TABLE IF EXISTS md_identifier CASCADE;"
339"DROP TABLE IF EXISTS md_keywords CASCADE;"
340"DROP TABLE IF EXISTS md_maintenanceinformation CASCADE;"
341"DROP TABLE IF EXISTS md_medium CASCADE;"
342"DROP TABLE IF EXISTS md_metadata CASCADE;"
343"DROP TABLE IF EXISTS md_metadataextensioninformation CASCADE;"
344"DROP TABLE IF EXISTS md_portrayalcataloguereference CASCADE;"
345"DROP TABLE IF EXISTS md_referencesystem CASCADE;"
346"DROP TABLE IF EXISTS md_representativefraction CASCADE;"
347"DROP TABLE IF EXISTS md_scopedescription CASCADE;"
348"DROP TABLE IF EXISTS md_spatialrepresentation CASCADE;"
349"DROP TABLE IF EXISTS md_standardorderprocess CASCADE;"
350"DROP TABLE IF EXISTS md_usage CASCADE;"
351"DROP TABLE IF EXISTS measure CASCADE;"
352"DROP TABLE IF EXISTS mo_acquisition CASCADE;"
353"DROP TABLE IF EXISTS mo_compositeprocess CASCADE;"
354"DROP TABLE IF EXISTS mo_computation CASCADE;"
355"DROP TABLE IF EXISTS mo_inputoutput CASCADE;"
356"DROP TABLE IF EXISTS mo_instrument CASCADE;"
357"DROP TABLE IF EXISTS mo_instrument_mo_instrument CASCADE;"
358"DROP TABLE IF EXISTS mo_instrumentplatformpair CASCADE;"
359"DROP TABLE IF EXISTS mo_location CASCADE;"
360"DROP TABLE IF EXISTS mo_observation CASCADE;"
361"DROP TABLE IF EXISTS mo_observationcollection CASCADE;"
362"DROP TABLE IF EXISTS mo_observationcollection_mo_observationcollection CASCADE;"
363"DROP TABLE IF EXISTS mo_onlineresource CASCADE;"
364"DROP TABLE IF EXISTS mo_operation CASCADE;"
365"DROP TABLE IF EXISTS mo_operation_mo_operation CASCADE;"
366"DROP TABLE IF EXISTS mo_organization CASCADE;"
367"DROP TABLE IF EXISTS mo_platform CASCADE;"
368"DROP TABLE IF EXISTS mo_platform_mo_platform CASCADE;"
369"DROP TABLE IF EXISTS mo_process CASCADE;"
370"DROP TABLE IF EXISTS mo_processing CASCADE;"
371"DROP TABLE IF EXISTS mo_project CASCADE;"
372"DROP TABLE IF EXISTS mo_project_mo_project CASCADE;"
373"DROP TABLE IF EXISTS mo_responsiblepartyinfo CASCADE;"
374"DROP TABLE IF EXISTS mo_result CASCADE;"
375"DROP TABLE IF EXISTS mo_result_mo_result CASCADE;"
376"DROP TABLE IF EXISTS multiplicity CASCADE;"
377"DROP TABLE IF EXISTS multiplicityrange CASCADE;"
378"DROP TABLE IF EXISTS namedvalue CASCADE;"
379"DROP TABLE IF EXISTS namespace CASCADE;"
380"DROP TABLE IF EXISTS obs_coll_migration CASCADE;"
381"DROP TABLE IF EXISTS observation_migration CASCADE;"
382"DROP TABLE IF EXISTS om_observation CASCADE;"
383"DROP TABLE IF EXISTS om_observation_om_observation CASCADE;"
384"DROP TABLE IF EXISTS om_process CASCADE;"
385"DROP TABLE IF EXISTS record CASCADE;"
386"DROP TABLE IF EXISTS recordtype CASCADE;"
387"DROP TABLE IF EXISTS rs_identifier CASCADE;"
388"DROP TABLE IF EXISTS rs_referencesystem CASCADE;"
389"DROP TABLE IF EXISTS scale CASCADE;"
390"DROP TABLE IF EXISTS sc_compoundcrs CASCADE;"
391"DROP TABLE IF EXISTS sc_crs CASCADE;"
392"DROP TABLE IF EXISTS sc_derivedcrs CASCADE;"
393"DROP TABLE IF EXISTS sc_generalderivedcrs CASCADE;"
394"DROP TABLE IF EXISTS schema CASCADE;"
395"DROP TABLE IF EXISTS scopedname CASCADE;"
396"DROP TABLE IF EXISTS sc_singlecrs CASCADE;"
397"DROP TABLE IF EXISTS sc_verticalcrs CASCADE;"
398"DROP TABLE IF EXISTS time CASCADE;"
399"DROP TABLE IF EXISTS tm_complex CASCADE;"
400"DROP TABLE IF EXISTS tm_duration CASCADE;"
401"DROP TABLE IF EXISTS tm_edge CASCADE;"
402"DROP TABLE IF EXISTS tm_geometricprimitive CASCADE;"
403"DROP TABLE IF EXISTS tm_instant CASCADE;"
404"DROP TABLE IF EXISTS tm_node CASCADE;"
405"DROP TABLE IF EXISTS tm_object CASCADE;"
406"DROP TABLE IF EXISTS tm_period CASCADE;"
407"DROP TABLE IF EXISTS tm_periodduration CASCADE;"
408"DROP TABLE IF EXISTS tm_position CASCADE;"
409"DROP TABLE IF EXISTS tm_primitive CASCADE;"
410"DROP TABLE IF EXISTS tm_referencesystem CASCADE;"
411"DROP TABLE IF EXISTS tm_temporalposition CASCADE;"
412"DROP TABLE IF EXISTS tm_topologicalcomplex CASCADE;"
413"DROP TABLE IF EXISTS tm_topologicalprimitive CASCADE;"
414"DROP TABLE IF EXISTS tp_complex CASCADE;"
415"DROP TABLE IF EXISTS tp_complex_tp_complex CASCADE;"
416"DROP TABLE IF EXISTS tp_directedtopo CASCADE;"
417"DROP TABLE IF EXISTS tp_expression CASCADE;"
418"DROP TABLE IF EXISTS tp_expressionterm CASCADE;"
419"DROP TABLE IF EXISTS tp_primitive CASCADE;"
420"DROP TABLE IF EXISTS tp_primitive_tp_primitive CASCADE;"
421"DROP TABLE IF EXISTS type CASCADE;"
422"DROP TABLE IF EXISTS typename CASCADE;"
423"DROP TABLE IF EXISTS unitofmeasure CASCADE;"
424"DROP TABLE IF EXISTS unlimitedinteger CASCADE;"
425"DROP TABLE IF EXISTS uomlength CASCADE;"
426"DROP TABLE IF EXISTS uomscale CASCADE;"
427"DROP TABLE IF EXISTS url CASCADE;"
428
429
Note: See TracBrowser for help on using the repository browser.