source: mauRepo/MolesManager/trunk/src/libs/migration/tests/dropAllTables.sql @ 8358

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/mauRepo/MolesManager/trunk/src/libs/migration/tests/dropAllTables.sql@8358
Revision 8358, 49.5 KB checked in by mnagni, 7 years ago (diff)

Major refactoring about migration (now handles better create/update, even if the single updates have to be quite fully implemented)
Added the connection pool from SQLAlchemy

RevLine 
[8358]1DROP TABLE IF EXISTS angle CASCADE;
[8147]2DROP TABLE IF EXISTS "any" CASCADE;
3DROP TABLE IF EXISTS cc_concatenatedoperation CASCADE;
4DROP TABLE IF EXISTS cc_concatenatedoperation_cc_concatenatedoperation CASCADE;
5DROP TABLE IF EXISTS cc_conversion CASCADE;
6DROP TABLE IF EXISTS cc_coordinateoperation CASCADE;
7DROP TABLE IF EXISTS cc_formula CASCADE;
8DROP TABLE IF EXISTS cc_generaloperationparameter CASCADE;
9DROP TABLE IF EXISTS cc_generalparametervalue CASCADE;
10DROP TABLE IF EXISTS cc_operationmethod CASCADE;
11DROP TABLE IF EXISTS cc_operationparameter CASCADE;
12DROP TABLE IF EXISTS cc_operationparametergroup CASCADE;
13DROP TABLE IF EXISTS cc_operationparametergroup_cc_operationparametergroup CASCADE;
14DROP TABLE IF EXISTS cc_operationparametervalue CASCADE;
15DROP TABLE IF EXISTS cc_parametervalue CASCADE;
16DROP TABLE IF EXISTS cc_parametervaluegroup CASCADE;
17DROP TABLE IF EXISTS cc_parametervaluegroup_cc_parametervaluegroup CASCADE;
18DROP TABLE IF EXISTS cc_passthroughoperation CASCADE;
19DROP TABLE IF EXISTS cc_singleoperation CASCADE;
20DROP TABLE IF EXISTS cc_transformation CASCADE;
21DROP TABLE IF EXISTS cd_datum CASCADE;
22DROP TABLE IF EXISTS cd_ellipsoid CASCADE;
23DROP TABLE IF EXISTS cd_engineeringdatum CASCADE;
24DROP TABLE IF EXISTS cd_geodeticdatum CASCADE;
25DROP TABLE IF EXISTS cd_imagedatum CASCADE;
26DROP TABLE IF EXISTS cd_primemeridian CASCADE;
27DROP TABLE IF EXISTS cd_seconddefiningparameter CASCADE;
28DROP TABLE IF EXISTS cd_verticaldatum CASCADE;
29DROP TABLE IF EXISTS ceda_acquisition CASCADE;
30DROP TABLE IF EXISTS ceda_citation CASCADE;
31DROP TABLE IF EXISTS ceda_compositeprocess CASCADE;
32DROP TABLE IF EXISTS ceda_instrument CASCADE;
33DROP TABLE IF EXISTS ceda_notes CASCADE;
34DROP TABLE IF EXISTS ceda_observation CASCADE;
35DROP TABLE IF EXISTS ceda_observationcollection CASCADE;
36DROP TABLE IF EXISTS ceda_operation CASCADE;
37DROP TABLE IF EXISTS ceda_platform CASCADE;
38DROP TABLE IF EXISTS ceda_process CASCADE;
39DROP TABLE IF EXISTS ceda_processing CASCADE;
40DROP TABLE IF EXISTS ceda_project CASCADE;
41DROP TABLE IF EXISTS ceda_result CASCADE;
42DROP TABLE IF EXISTS ceda_review CASCADE;
43DROP TABLE IF EXISTS ci_address CASCADE;
44DROP TABLE IF EXISTS ci_citation CASCADE;
45DROP TABLE IF EXISTS ci_contact CASCADE;
46DROP TABLE IF EXISTS ci_date CASCADE;
47DROP TABLE IF EXISTS ci_individual CASCADE;
48DROP TABLE IF EXISTS ci_onlineresource CASCADE;
49DROP TABLE IF EXISTS ci_organisation CASCADE;
50DROP TABLE IF EXISTS ci_party CASCADE;
51DROP TABLE IF EXISTS ci_responsibility CASCADE;
52DROP TABLE IF EXISTS ci_responsibleparty CASCADE;
53DROP TABLE IF EXISTS ci_responsiblepartyinfo CASCADE;
54DROP TABLE IF EXISTS ci_series CASCADE;
55DROP TABLE IF EXISTS ci_telephone CASCADE;
56DROP TABLE IF EXISTS cl_classificationcollection CASCADE;
57DROP TABLE IF EXISTS cl_classificationcollection_cv_surfacevaluepair CASCADE;
58DROP TABLE IF EXISTS cl_dataset CASCADE;
59DROP TABLE IF EXISTS cl_dataset_md_metadata CASCADE;
60DROP TABLE IF EXISTS clocktime CASCADE;
61DROP TABLE IF EXISTS cs_affinecs CASCADE;
62DROP TABLE IF EXISTS cs_cartesiancs CASCADE;
63DROP TABLE IF EXISTS cs_coordinatesystemaxis CASCADE;
64DROP TABLE IF EXISTS cs_coordinatesystem CASCADE;
65DROP TABLE IF EXISTS cs_cylindricalcs CASCADE;
66DROP TABLE IF EXISTS cs_ellipsoidalcs CASCADE;
67DROP TABLE IF EXISTS cs_engineeringcs CASCADE;
68DROP TABLE IF EXISTS cs_geodeticcs CASCADE;
69DROP TABLE IF EXISTS cs_imagecs CASCADE;
70DROP TABLE IF EXISTS cs_linearcs CASCADE;
71DROP TABLE IF EXISTS cs_polarcs CASCADE;
72DROP TABLE IF EXISTS cs_sphericalcs CASCADE;
73DROP TABLE IF EXISTS cs_userdefinedcs CASCADE;
74DROP TABLE IF EXISTS cs_verticalcs CASCADE;
75DROP TABLE IF EXISTS cv_attributevalues CASCADE;
76DROP TABLE IF EXISTS cv_continuouscoverage CASCADE;
77DROP TABLE IF EXISTS cv_continuousquadrilateralgridcoverage CASCADE;
78DROP TABLE IF EXISTS cv_continuousquadrilateralgridcoverage_cv_gridvaluecell CASCADE;
79DROP TABLE IF EXISTS cv_continuousquadrilateralgridcoverage_cv_valueobject CASCADE;
80DROP TABLE IF EXISTS cv_coverage CASCADE;
81DROP TABLE IF EXISTS cv_curvevaluepair CASCADE;
82DROP TABLE IF EXISTS cv_curvevaluepair_cv_discretecoverage CASCADE;
83DROP TABLE IF EXISTS cv_curvevaluepair_cv_discretecurvecoverage CASCADE;
84DROP TABLE IF EXISTS cv_curvevaluepair_cv_valueobject CASCADE;
85DROP TABLE IF EXISTS cv_discretecoverage CASCADE;
86DROP TABLE IF EXISTS cv_discretecurvecoverage CASCADE;
87DROP TABLE IF EXISTS cv_discretecurvecoverage_cv_curvevaluepair CASCADE;
88DROP TABLE IF EXISTS cv_discretecurvecoverage_cv_geometryvaluepair CASCADE;
89DROP TABLE IF EXISTS cv_discretegridpointcoverage CASCADE;
90DROP TABLE IF EXISTS cv_discretegridpointcoverage_cv_geometryvaluepair CASCADE;
91DROP TABLE IF EXISTS cv_discretegridpointcoverage_cv_gridpointvaluepair CASCADE;
92DROP TABLE IF EXISTS cv_discretepointcoverage CASCADE;
93DROP TABLE IF EXISTS cv_discretepointcoverage_cv_geometryvaluepair CASCADE;
94DROP TABLE IF EXISTS cv_discretepointcoverage_cv_gridpointvaluepair CASCADE;
95DROP TABLE IF EXISTS cv_discretepointcoverage_cv_pointvaluepair CASCADE;
96DROP TABLE IF EXISTS cv_discretesolidcoverage CASCADE;
97DROP TABLE IF EXISTS cv_discretesolidcoverage_cv_geometryvaluepair CASCADE;
98DROP TABLE IF EXISTS cv_discretesolidcoverage_cv_solidvaluepair CASCADE;
99DROP TABLE IF EXISTS cv_discretesurfacecoverage CASCADE;
100DROP TABLE IF EXISTS cv_discretesurfacecoverage_cv_geometryvaluepair CASCADE;
101DROP TABLE IF EXISTS cv_discretesurfacecoverage_cv_surfacevaluepair CASCADE;
102DROP TABLE IF EXISTS cv_domainobject CASCADE;
103DROP TABLE IF EXISTS cv_domainobject_cv_coverage CASCADE;
104DROP TABLE IF EXISTS cv_footprint CASCADE;
105DROP TABLE IF EXISTS cv_footprint_cv_gridpoint CASCADE;
106DROP TABLE IF EXISTS cv_geometryvaluepair CASCADE;
107DROP TABLE IF EXISTS cv_grid CASCADE;
108DROP TABLE IF EXISTS cv_gridcell CASCADE;
109DROP TABLE IF EXISTS cv_gridcell_cv_grid CASCADE;
110DROP TABLE IF EXISTS cv_gridcell_cv_gridpoint CASCADE;
111DROP TABLE IF EXISTS cv_gridcoordinate CASCADE;
112DROP TABLE IF EXISTS cv_gridenvelope CASCADE;
113DROP TABLE IF EXISTS cv_gridpoint CASCADE;
114DROP TABLE IF EXISTS cv_gridpoint_cv_footprint CASCADE;
115DROP TABLE IF EXISTS cv_gridpoint_cv_grid CASCADE;
116DROP TABLE IF EXISTS cv_gridpoint_cv_gridcell CASCADE;
117DROP TABLE IF EXISTS cv_gridpoint_gm_point CASCADE;
118DROP TABLE IF EXISTS cv_gridpointvaluepair CASCADE;
119DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_discretecoverage CASCADE;
120DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_discretegridpointcoverage CASCADE;
121DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_discretepointcoverage CASCADE;
122DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_gridvaluecell CASCADE;
123DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_valuehexagon CASCADE;
124DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_valueobject CASCADE;
125DROP TABLE IF EXISTS cv_gridvaluecell CASCADE;
126DROP TABLE IF EXISTS cv_gridvaluecell_cv_continuouscoverage CASCADE;
127DROP TABLE IF EXISTS cv_gridvaluecell_cv_continuousquadrilateralgridcoverage CASCADE;
128DROP TABLE IF EXISTS cv_gridvaluecell_cv_geometryvaluepair CASCADE;
129DROP TABLE IF EXISTS cv_gridvaluecell_cv_gridpointvaluepair CASCADE;
130DROP TABLE IF EXISTS cv_gridvaluesmatrix CASCADE;
131DROP TABLE IF EXISTS cv_hexagonalgridcoverage CASCADE;
132DROP TABLE IF EXISTS cv_hexagonalgridcoverage_cv_gridvaluesmatrix CASCADE;
133DROP TABLE IF EXISTS cv_hexagonalgridcoverage_cv_valuehexagon CASCADE;
134DROP TABLE IF EXISTS cv_hexagonalgridcoverage_cv_valueobject CASCADE;
135DROP TABLE IF EXISTS cv_pointvaluepair CASCADE;
136DROP TABLE IF EXISTS cv_pointvaluepair_cv_discretecoverage CASCADE;
137DROP TABLE IF EXISTS cv_pointvaluepair_cv_discretepointcoverage CASCADE;
138DROP TABLE IF EXISTS cv_pointvaluepair_cv_thiessenvaluepolygon CASCADE;
139DROP TABLE IF EXISTS cv_pointvaluepair_cv_valuecurve CASCADE;
140DROP TABLE IF EXISTS cv_pointvaluepair_cv_valueobject CASCADE;
141DROP TABLE IF EXISTS cv_rectifiedgrid CASCADE;
142DROP TABLE IF EXISTS cv_referenceablegrid CASCADE;
143DROP TABLE IF EXISTS cv_segmentedcurvecoverage CASCADE;
144DROP TABLE IF EXISTS cv_segmentedcurvecoverage_cv_valuecurve CASCADE;
145DROP TABLE IF EXISTS cv_segmentedcurvecoverage_cv_valueobject CASCADE;
146DROP TABLE IF EXISTS cv_sequencerule CASCADE;
147DROP TABLE IF EXISTS cv_solidvaluepair CASCADE;
148DROP TABLE IF EXISTS cv_solidvaluepair_cv_discretesolidcoverage CASCADE;
149DROP TABLE IF EXISTS cv_solidvaluepair_cv_valueobject CASCADE;
150DROP TABLE IF EXISTS cv_surfacevaluepair CASCADE;
151DROP TABLE IF EXISTS cv_surfacevaluepair_cl_classificationcollection CASCADE;
152DROP TABLE IF EXISTS cv_surfacevaluepair_cv_discretecoverage CASCADE;
153DROP TABLE IF EXISTS cv_surfacevaluepair_cv_discretesurfacecoverage CASCADE;
154DROP TABLE IF EXISTS cv_surfacevaluepair_cv_valueobject CASCADE;
155DROP TABLE IF EXISTS cvt_discretetimeinstantcoverage CASCADE;
156DROP TABLE IF EXISTS cvt_discretetimeinstantcoverage_cv_geometryvaluepair CASCADE;
157DROP TABLE IF EXISTS cvt_discretetimeinstantcoverage_cvt_timeinstantvaluepair CASCADE;
158DROP TABLE IF EXISTS cv_thiessenpolygoncoverage CASCADE;
159DROP TABLE IF EXISTS cv_thiessenpolygoncoverage_cv_thiessenvaluepolygon CASCADE;
160DROP TABLE IF EXISTS cv_thiessenpolygoncoverage_cv_valueobject CASCADE;
161DROP TABLE IF EXISTS cv_thiessenvaluepolygon CASCADE;
162DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_continuouscoverage CASCADE;
163DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_geometryvaluepair CASCADE;
164DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_pointvaluepair CASCADE;
165DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_thiessenpolygoncoverage CASCADE;
166DROP TABLE IF EXISTS cv_tincoverage CASCADE;
167DROP TABLE IF EXISTS cvt_timeinstantvaluepair CASCADE;
168DROP TABLE IF EXISTS cvt_timeinstantvaluepair_cv_discretecoverage CASCADE;
169DROP TABLE IF EXISTS cvt_timeinstantvaluepair_cvt_discretetimeinstantcoverage CASCADE;
170DROP TABLE IF EXISTS cvt_timeinstantvaluepair_cv_valueobject CASCADE;
171DROP TABLE IF EXISTS cv_valuecurve CASCADE;
172DROP TABLE IF EXISTS cv_valuecurve_cv_continuouscoverage CASCADE;
173DROP TABLE IF EXISTS cv_valuecurve_cv_geometryvaluepair CASCADE;
174DROP TABLE IF EXISTS cv_valuecurve_cv_pointvaluepair CASCADE;
175DROP TABLE IF EXISTS cv_valuecurve_cv_segmentedcurvecoverage CASCADE;
176DROP TABLE IF EXISTS cv_valuecurve_cv_valuesegment CASCADE;
177DROP TABLE IF EXISTS cv_valuehexagon CASCADE;
178DROP TABLE IF EXISTS cv_valuehexagon_cv_continuouscoverage CASCADE;
179DROP TABLE IF EXISTS cv_valuehexagon_cv_geometryvaluepair CASCADE;
180DROP TABLE IF EXISTS cv_valuehexagon_cv_gridpointvaluepair CASCADE;
181DROP TABLE IF EXISTS cv_valuehexagon_cv_hexagonalgridcoverage CASCADE;
182DROP TABLE IF EXISTS cv_valueobject CASCADE;
183DROP TABLE IF EXISTS cv_valuesegment CASCADE;
184DROP TABLE IF EXISTS cv_valuesegment_cv_valuecurve CASCADE;
185DROP TABLE IF EXISTS cv_valuetriangle CASCADE;
186DROP TABLE IF EXISTS date CASCADE;
187DROP TABLE IF EXISTS dateprecision CASCADE;
188DROP TABLE IF EXISTS datetime CASCADE;
189DROP TABLE IF EXISTS decimal CASCADE;
190DROP TABLE IF EXISTS directposition CASCADE;
191DROP TABLE IF EXISTS distance CASCADE;
192DROP TABLE IF EXISTS dq_absoluteexternalpositionalaccuracy CASCADE;
193DROP TABLE IF EXISTS dq_completeness CASCADE;
194DROP TABLE IF EXISTS dq_conformanceresult CASCADE;
195DROP TABLE IF EXISTS dq_dataquality CASCADE;
196DROP TABLE IF EXISTS dq_element CASCADE;
197DROP TABLE IF EXISTS dq_griddeddatapositionalaccuracy CASCADE;
198DROP TABLE IF EXISTS dq_logicalconsistency CASCADE;
199DROP TABLE IF EXISTS dq_positionalaccuracy CASCADE;
200DROP TABLE IF EXISTS dq_quantitativeresult CASCADE;
201DROP TABLE IF EXISTS dq_relativeinternalpositionalaccuracy CASCADE;
202DROP TABLE IF EXISTS dq_result CASCADE;
203DROP TABLE IF EXISTS dq_scope CASCADE;
204DROP TABLE IF EXISTS dq_temporalaccuracy CASCADE;
205DROP TABLE IF EXISTS dq_thematicaccuracy CASCADE;
206DROP TABLE IF EXISTS ds_aggregate CASCADE;
207DROP TABLE IF EXISTS ds_dataset CASCADE;
208DROP TABLE IF EXISTS ds_dataset_ds_aggregate CASCADE;
209DROP TABLE IF EXISTS ds_dataset_md_metadata CASCADE;
210DROP TABLE IF EXISTS ds_initiative CASCADE;
211DROP TABLE IF EXISTS ds_otheraggregate CASCADE;
212DROP TABLE IF EXISTS ds_series CASCADE;
213DROP TABLE IF EXISTS earootclass CASCADE;
214DROP TABLE IF EXISTS ex_boundingpolygon CASCADE;
215DROP TABLE IF EXISTS ex_boundingpolygon_ex_extent CASCADE;
216DROP TABLE IF EXISTS ex_boundingpolygon_mo_observation CASCADE;
217DROP TABLE IF EXISTS ex_boundingpolygon_mo_observationcollection CASCADE;
218DROP TABLE IF EXISTS ex_extent CASCADE;
219DROP TABLE IF EXISTS ex_extent_ci_responsiblepartyinfo CASCADE;
220DROP TABLE IF EXISTS ex_extent_cv_coverage CASCADE;
221DROP TABLE IF EXISTS ex_extent_li_source CASCADE;
222DROP TABLE IF EXISTS ex_extent_tm_referencesystem CASCADE;
223DROP TABLE IF EXISTS ex_geographicboundingbox CASCADE;
224DROP TABLE IF EXISTS ex_geographicdescription CASCADE;
225DROP TABLE IF EXISTS ex_geographicextent CASCADE;
226DROP TABLE IF EXISTS ex_temporalextent CASCADE;
227DROP TABLE IF EXISTS ex_verticalextent CASCADE;
228DROP TABLE IF EXISTS genericname CASCADE;
229DROP TABLE IF EXISTS gf_aggregationtype CASCADE;
230DROP TABLE IF EXISTS gf_associationrole CASCADE;
231DROP TABLE IF EXISTS gf_associationtype CASCADE;
232DROP TABLE IF EXISTS gf_attributetype CASCADE;
233DROP TABLE IF EXISTS gf_attributetype_gf_featuretype CASCADE;
234DROP TABLE IF EXISTS gf_attributetype_md_metadata CASCADE;
235DROP TABLE IF EXISTS gf_attributetype_md_scopedescription CASCADE;
236DROP TABLE IF EXISTS gf_constraint CASCADE;
237DROP TABLE IF EXISTS gf_featuretype CASCADE;
238DROP TABLE IF EXISTS gf_featuretype_gf_associationtype CASCADE;
239DROP TABLE IF EXISTS gf_featuretype_md_metadata CASCADE;
240DROP TABLE IF EXISTS gf_featuretype_md_scopedescription CASCADE;
241DROP TABLE IF EXISTS gfi_domainfeature CASCADE;
242DROP TABLE IF EXISTS gfi_feature CASCADE;
243DROP TABLE IF EXISTS gf_inheritancerelation CASCADE;
244DROP TABLE IF EXISTS gf_locationalattributetype CASCADE;
245DROP TABLE IF EXISTS gf_metadataattributetype CASCADE;
246DROP TABLE IF EXISTS gf_operation CASCADE;
247DROP TABLE IF EXISTS gf_propertytype CASCADE;
248DROP TABLE IF EXISTS gf_spatialassociationtype CASCADE;
249DROP TABLE IF EXISTS gf_spatialattributetype CASCADE;
250DROP TABLE IF EXISTS gf_temporalassociationtype CASCADE;
251DROP TABLE IF EXISTS gf_temporalattributetype CASCADE;
252DROP TABLE IF EXISTS gf_thematicattributetype CASCADE;
253DROP TABLE IF EXISTS gm_affineplacement CASCADE;
254DROP TABLE IF EXISTS gm_aggregate CASCADE;
255DROP TABLE IF EXISTS gm_aggregate_cv_domainobject CASCADE;
256DROP TABLE IF EXISTS gm_aggregate_ex_boundingpolygon CASCADE;
257DROP TABLE IF EXISTS gm_aggregate_gm_aggregate CASCADE;
258DROP TABLE IF EXISTS gm_aggregate_sc_crs CASCADE;
259DROP TABLE IF EXISTS gm_arcstringbybulge CASCADE;
260DROP TABLE IF EXISTS gm_arcstring CASCADE;
261DROP TABLE IF EXISTS gm_boundary CASCADE;
262DROP TABLE IF EXISTS gm_clothoid CASCADE;
263DROP TABLE IF EXISTS gm_complex CASCADE;
264DROP TABLE IF EXISTS gm_complex_cv_domainobject CASCADE;
265DROP TABLE IF EXISTS gm_complex_ex_boundingpolygon CASCADE;
266DROP TABLE IF EXISTS gm_complex_gm_aggregate CASCADE;
267DROP TABLE IF EXISTS gm_complex_gm_complex CASCADE;
268DROP TABLE IF EXISTS gm_complex_gm_primitive CASCADE;
269DROP TABLE IF EXISTS gm_complex_sc_crs CASCADE;
270DROP TABLE IF EXISTS gm_composite CASCADE;
271DROP TABLE IF EXISTS gm_compositecurve CASCADE;
272DROP TABLE IF EXISTS gm_compositecurve_gm_compositecurve CASCADE;
273DROP TABLE IF EXISTS gm_compositepoint CASCADE;
274DROP TABLE IF EXISTS gm_compositesolid CASCADE;
275DROP TABLE IF EXISTS gm_compositesolid_gm_primitive CASCADE;
276DROP TABLE IF EXISTS gm_compositesolid_gm_solid CASCADE;
277DROP TABLE IF EXISTS gm_compositesurface CASCADE;
278DROP TABLE IF EXISTS gm_compositesurface_gm_compositesurface CASCADE;
279DROP TABLE IF EXISTS gm_conic CASCADE;
280DROP TABLE IF EXISTS gm_curve CASCADE;
281DROP TABLE IF EXISTS gm_curvesegment CASCADE;
282DROP TABLE IF EXISTS gm_geodesicstring CASCADE;
283DROP TABLE IF EXISTS gm_knot CASCADE;
284DROP TABLE IF EXISTS gm_linestring CASCADE;
285DROP TABLE IF EXISTS gm_object CASCADE;
286DROP TABLE IF EXISTS gm_offsetcurve CASCADE;
287DROP TABLE IF EXISTS gm_orientablecurve CASCADE;
288DROP TABLE IF EXISTS gm_orientableprimitive CASCADE;
289DROP TABLE IF EXISTS gm_orientablesurface CASCADE;
290DROP TABLE IF EXISTS gm_parametriccurvesurface CASCADE;
291DROP TABLE IF EXISTS gm_pointarray CASCADE;
292DROP TABLE IF EXISTS gm_point CASCADE;
293DROP TABLE IF EXISTS gm_point_cv_gridpoint CASCADE;
294DROP TABLE IF EXISTS gm_point_gm_complex CASCADE;
295DROP TABLE IF EXISTS gm_point_gm_composite CASCADE;
296DROP TABLE IF EXISTS gm_point_gm_primitive CASCADE;
297DROP TABLE IF EXISTS gm_pointref CASCADE;
298DROP TABLE IF EXISTS gm_polygon CASCADE;
299DROP TABLE IF EXISTS gm_polyhedralsurface CASCADE;
300DROP TABLE IF EXISTS gm_position CASCADE;
301DROP TABLE IF EXISTS gm_primitiveboundary CASCADE;
302DROP TABLE IF EXISTS gm_primitive CASCADE;
303DROP TABLE IF EXISTS gm_primitive_cv_domainobject CASCADE;
304DROP TABLE IF EXISTS gm_primitive_ex_boundingpolygon CASCADE;
305DROP TABLE IF EXISTS gm_primitive_gm_aggregate CASCADE;
306DROP TABLE IF EXISTS gm_primitive_sc_crs CASCADE;
307DROP TABLE IF EXISTS gm_ring CASCADE;
308DROP TABLE IF EXISTS gm_solid CASCADE;
309DROP TABLE IF EXISTS gm_solid_gm_complex CASCADE;
310DROP TABLE IF EXISTS gm_solid_gm_composite CASCADE;
311DROP TABLE IF EXISTS gm_solid_gm_compositesolid CASCADE;
312DROP TABLE IF EXISTS gm_solid_gm_primitive CASCADE;
313DROP TABLE IF EXISTS gm_splinecurve CASCADE;
314DROP TABLE IF EXISTS gm_surfaceboundary CASCADE;
315DROP TABLE IF EXISTS gm_surface CASCADE;
316DROP TABLE IF EXISTS gm_surfacepatch CASCADE;
317DROP TABLE IF EXISTS gm_tin CASCADE;
318DROP TABLE IF EXISTS gm_triangle CASCADE;
319DROP TABLE IF EXISTS gm_triangulatedsurface CASCADE;
320DROP TABLE IF EXISTS if_classificationattributetype CASCADE;
321DROP TABLE IF EXISTS io_identifiedobjectbase CASCADE;
322DROP TABLE IF EXISTS io_identifiedobject CASCADE;
323DROP TABLE IF EXISTS juliandate CASCADE;
324DROP TABLE IF EXISTS le_algorithm CASCADE;
325DROP TABLE IF EXISTS length CASCADE;
326DROP TABLE IF EXISTS le_nominalresolution CASCADE;
327DROP TABLE IF EXISTS le_source CASCADE;
328DROP TABLE IF EXISTS li_lineage CASCADE;
329DROP TABLE IF EXISTS li_processstep CASCADE;
330DROP TABLE IF EXISTS li_processstep_li_lineage CASCADE;
331DROP TABLE IF EXISTS li_processstep_li_source CASCADE;
332DROP TABLE IF EXISTS li_source CASCADE;
333DROP TABLE IF EXISTS li_source_li_lineage CASCADE;
334DROP TABLE IF EXISTS li_source_li_processstep CASCADE;
335DROP TABLE IF EXISTS localname CASCADE;
336DROP TABLE IF EXISTS location CASCADE;
337DROP TABLE IF EXISTS md_aggregateinformation CASCADE;
338DROP TABLE IF EXISTS md_applicationschemainformation CASCADE;
339DROP TABLE IF EXISTS md_browsegraphic CASCADE;
340DROP TABLE IF EXISTS md_constraints CASCADE;
341DROP TABLE IF EXISTS md_contentinformation CASCADE;
342DROP TABLE IF EXISTS md_coveragedescription CASCADE;
343DROP TABLE IF EXISTS md_digitaltransferoptions CASCADE;
344DROP TABLE IF EXISTS md_dimension CASCADE;
345DROP TABLE IF EXISTS md_distribution CASCADE;
346DROP TABLE IF EXISTS md_distributor CASCADE;
347DROP TABLE IF EXISTS md_distributor_md_distribution CASCADE;
348DROP TABLE IF EXISTS md_distributor_md_format CASCADE;
349DROP TABLE IF EXISTS md_extendedelementinformation CASCADE;
350DROP TABLE IF EXISTS md_featurecataloguedescription CASCADE;
351DROP TABLE IF EXISTS md_format CASCADE;
352DROP TABLE IF EXISTS md_format_md_distribution CASCADE;
353DROP TABLE IF EXISTS md_format_md_distributor CASCADE;
354DROP TABLE IF EXISTS md_format_md_identification CASCADE;
355DROP TABLE IF EXISTS md_geometricobjects CASCADE;
356DROP TABLE IF EXISTS md_gridspatialrepresentation CASCADE;
357DROP TABLE IF EXISTS md_identification CASCADE;
358DROP TABLE IF EXISTS md_identification_md_metadata CASCADE;
359DROP TABLE IF EXISTS md_identifier CASCADE;
360DROP TABLE IF EXISTS md_imagedescription CASCADE;
361DROP TABLE IF EXISTS md_keywords CASCADE;
362DROP TABLE IF EXISTS md_legalconstraints CASCADE;
363DROP TABLE IF EXISTS md_maintenanceinformation CASCADE;
364DROP TABLE IF EXISTS md_maintenanceinformation_md_identification CASCADE;
365DROP TABLE IF EXISTS md_medium CASCADE;
366DROP TABLE IF EXISTS md_metadata CASCADE;
367DROP TABLE IF EXISTS md_metadata_cl_dataset CASCADE;
368DROP TABLE IF EXISTS md_metadata_ds_aggregate CASCADE;
369DROP TABLE IF EXISTS md_metadata_ds_dataset CASCADE;
370DROP TABLE IF EXISTS md_metadataextensioninformation CASCADE;
371DROP TABLE IF EXISTS md_metadata_gf_attributetype CASCADE;
372DROP TABLE IF EXISTS md_metadata_gf_featuretype CASCADE;
373DROP TABLE IF EXISTS md_metadata_gf_propertytype CASCADE;
374DROP TABLE IF EXISTS md_metadata_mo_observationcollection CASCADE;
375DROP TABLE IF EXISTS md_portrayalcataloguereference CASCADE;
376DROP TABLE IF EXISTS md_rangedimension CASCADE;
377DROP TABLE IF EXISTS md_referencesystem CASCADE;
378DROP TABLE IF EXISTS md_representativefraction CASCADE;
379DROP TABLE IF EXISTS md_scopedescription CASCADE;
380DROP TABLE IF EXISTS md_scopedescription_dq_scope CASCADE;
381DROP TABLE IF EXISTS md_scopedescription_md_maintenanceinformation CASCADE;
382DROP TABLE IF EXISTS md_securityconstraints CASCADE;
383DROP TABLE IF EXISTS md_spatialrepresentation CASCADE;
384DROP TABLE IF EXISTS md_standardorderprocess CASCADE;
385DROP TABLE IF EXISTS md_usage CASCADE;
386DROP TABLE IF EXISTS md_vectorspatialrepresentation CASCADE;
387DROP TABLE IF EXISTS measure CASCADE;
388DROP TABLE IF EXISTS membername CASCADE;
389DROP TABLE IF EXISTS mi_coveragedescription CASCADE;
390DROP TABLE IF EXISTS mi_rangeelementdescription CASCADE;
391DROP TABLE IF EXISTS mo_acquisition CASCADE;
392DROP TABLE IF EXISTS mo_compositeprocess CASCADE;
393DROP TABLE IF EXISTS mo_computation CASCADE;
394DROP TABLE IF EXISTS mo_featureofinterest CASCADE;
395DROP TABLE IF EXISTS mo_inputoutput CASCADE;
396DROP TABLE IF EXISTS mo_instrument CASCADE;
397DROP TABLE IF EXISTS mo_instrument_mo_instrument CASCADE;
398DROP TABLE IF EXISTS mo_instrumentplatformpair CASCADE;
399DROP TABLE IF EXISTS mo_location CASCADE;
400DROP TABLE IF EXISTS mo_observation CASCADE;
401DROP TABLE IF EXISTS mo_observationcollection CASCADE;
402DROP TABLE IF EXISTS mo_observationcollection_mo_observationcollection CASCADE;
403DROP TABLE IF EXISTS mo_observationcollection_mo_project CASCADE;
404DROP TABLE IF EXISTS mo_observation_gfi_feature CASCADE;
405DROP TABLE IF EXISTS mo_observation_mo_observationcollection CASCADE;
406DROP TABLE IF EXISTS mo_observation_om_observation CASCADE;
407DROP TABLE IF EXISTS mo_observation_om_process CASCADE;
408DROP TABLE IF EXISTS mo_observation_sf_samplingfeature CASCADE;
409DROP TABLE IF EXISTS mo_onlineresource CASCADE;
410DROP TABLE IF EXISTS mo_operation CASCADE;
411DROP TABLE IF EXISTS mo_operation_mo_operation CASCADE;
412DROP TABLE IF EXISTS mo_organization CASCADE;
413DROP TABLE IF EXISTS mo_platform CASCADE;
414DROP TABLE IF EXISTS mo_platform_mo_platform CASCADE;
415DROP TABLE IF EXISTS mo_process CASCADE;
416DROP TABLE IF EXISTS mo_processing CASCADE;
417DROP TABLE IF EXISTS mo_project CASCADE;
418DROP TABLE IF EXISTS mo_project_mo_project CASCADE;
419DROP TABLE IF EXISTS mo_responsiblepartyinfo CASCADE;
420DROP TABLE IF EXISTS mo_result CASCADE;
421DROP TABLE IF EXISTS mo_result_mo_result CASCADE;
422DROP TABLE IF EXISTS multiplicity CASCADE;
423DROP TABLE IF EXISTS multiplicityrange CASCADE;
424DROP TABLE IF EXISTS mx_datafile CASCADE;
425DROP TABLE IF EXISTS namedvalue CASCADE;
426DROP TABLE IF EXISTS namespace CASCADE;
427DROP TABLE IF EXISTS obs_coll_migration CASCADE;
428DROP TABLE IF EXISTS observation_migration CASCADE;
429DROP TABLE IF EXISTS om_categoryobservation CASCADE;
430DROP TABLE IF EXISTS om_complexobservation CASCADE;
431DROP TABLE IF EXISTS om_countobservation CASCADE;
432DROP TABLE IF EXISTS om_discretecoverageobservation CASCADE;
433DROP TABLE IF EXISTS om_geometryobservation CASCADE;
434DROP TABLE IF EXISTS om_measurement CASCADE;
435DROP TABLE IF EXISTS om_observation CASCADE;
436DROP TABLE IF EXISTS om_process CASCADE;
437DROP TABLE IF EXISTS om_process_sf_spatialsamplingfeature CASCADE;
438DROP TABLE IF EXISTS om_temporalobservation CASCADE;
439DROP TABLE IF EXISTS om_truthobservation CASCADE;
440DROP TABLE IF EXISTS qe_coverageresult CASCADE;
441DROP TABLE IF EXISTS qe_usability CASCADE;
442DROP TABLE IF EXISTS record CASCADE;
443DROP TABLE IF EXISTS recordtype CASCADE;
444DROP TABLE IF EXISTS rs_identifier CASCADE;
445DROP TABLE IF EXISTS rs_referencesystem CASCADE;
446DROP TABLE IF EXISTS scale CASCADE;
447DROP TABLE IF EXISTS sc_compoundcrs CASCADE;
448DROP TABLE IF EXISTS sc_crs CASCADE;
449DROP TABLE IF EXISTS sc_derivedcrs CASCADE;
450DROP TABLE IF EXISTS sc_engineeringcrs CASCADE;
451DROP TABLE IF EXISTS sc_generalderivedcrs CASCADE;
452DROP TABLE IF EXISTS sc_geodeticcrs CASCADE;
453DROP TABLE IF EXISTS schema CASCADE;
454DROP TABLE IF EXISTS sc_imagecrs CASCADE;
455DROP TABLE IF EXISTS scopedname CASCADE;
456DROP TABLE IF EXISTS sc_projectedcrs CASCADE;
457DROP TABLE IF EXISTS sc_singlecrs CASCADE;
458DROP TABLE IF EXISTS sc_verticalcrs CASCADE;
459DROP TABLE IF EXISTS sf_process CASCADE;
460DROP TABLE IF EXISTS sf_samplingfeature CASCADE;
461DROP TABLE IF EXISTS sf_samplingfeature_sf_samplingfeature CASCADE;
462DROP TABLE IF EXISTS sf_spatialsamplingfeature CASCADE;
463DROP TABLE IF EXISTS sf_spatialsamplingfeature_sf_samplingfeature CASCADE;
464DROP TABLE IF EXISTS sf_specimen CASCADE;
465DROP TABLE IF EXISTS time CASCADE;
466DROP TABLE IF EXISTS tm_caldate CASCADE;
467DROP TABLE IF EXISTS tm_calendar CASCADE;
468DROP TABLE IF EXISTS tm_calendarera CASCADE;
469DROP TABLE IF EXISTS tm_calendarera_tm_calendar CASCADE;
470DROP TABLE IF EXISTS tm_calendar_tm_calendarera CASCADE;
471DROP TABLE IF EXISTS tm_calendar_tm_clock CASCADE;
472DROP TABLE IF EXISTS tm_clock CASCADE;
473DROP TABLE IF EXISTS tm_clocktime CASCADE;
474DROP TABLE IF EXISTS tm_complex CASCADE;
475DROP TABLE IF EXISTS tm_coordinate CASCADE;
476DROP TABLE IF EXISTS tm_coordinatesystem CASCADE;
477DROP TABLE IF EXISTS tm_duration CASCADE;
478DROP TABLE IF EXISTS tm_edge CASCADE;
479DROP TABLE IF EXISTS tm_geometricprimitive CASCADE;
480DROP TABLE IF EXISTS tm_instant CASCADE;
481DROP TABLE IF EXISTS tm_node CASCADE;
482DROP TABLE IF EXISTS tm_object CASCADE;
483DROP TABLE IF EXISTS tm_ordinalera CASCADE;
484DROP TABLE IF EXISTS tm_ordinalera_tm_ordinalera CASCADE;
485DROP TABLE IF EXISTS tm_ordinalposition CASCADE;
486DROP TABLE IF EXISTS tm_ordinalreferencesystem CASCADE;
487DROP TABLE IF EXISTS tm_period CASCADE;
488DROP TABLE IF EXISTS tm_periodduration CASCADE;
489DROP TABLE IF EXISTS tm_position CASCADE;
490DROP TABLE IF EXISTS tm_primitive CASCADE;
491DROP TABLE IF EXISTS tm_referencesystem CASCADE;
492DROP TABLE IF EXISTS tm_temporalcrs CASCADE;
493DROP TABLE IF EXISTS tm_temporalposition CASCADE;
494DROP TABLE IF EXISTS tm_topologicalcomplex CASCADE;
495DROP TABLE IF EXISTS tm_topologicalprimitive CASCADE;
496DROP TABLE IF EXISTS tp_boundary CASCADE;
497DROP TABLE IF EXISTS tp_complex CASCADE;
498DROP TABLE IF EXISTS tp_complex_tp_complex CASCADE;
499DROP TABLE IF EXISTS tp_complex_tp_primitive CASCADE;
500DROP TABLE IF EXISTS tp_directededge CASCADE;
501DROP TABLE IF EXISTS tp_directededge_tp_face CASCADE;
502DROP TABLE IF EXISTS tp_directededge_tp_node CASCADE;
503DROP TABLE IF EXISTS tp_directedface CASCADE;
504DROP TABLE IF EXISTS tp_directedface_tp_edge CASCADE;
505DROP TABLE IF EXISTS tp_directedface_tp_solid CASCADE;
506DROP TABLE IF EXISTS tp_directednode CASCADE;
507DROP TABLE IF EXISTS tp_directedsolid CASCADE;
508DROP TABLE IF EXISTS tp_directedsolid_tp_face CASCADE;
509DROP TABLE IF EXISTS tp_directedtopo CASCADE;
510DROP TABLE IF EXISTS tp_edge CASCADE;
511DROP TABLE IF EXISTS tp_edge_gm_primitive CASCADE;
512DROP TABLE IF EXISTS tp_edge_tp_complex CASCADE;
513DROP TABLE IF EXISTS tp_edge_tp_directedface CASCADE;
514DROP TABLE IF EXISTS tp_edge_tp_directednode CASCADE;
515DROP TABLE IF EXISTS tp_edge_tp_primitive CASCADE;
516DROP TABLE IF EXISTS tp_expression CASCADE;
517DROP TABLE IF EXISTS tp_expressionterm CASCADE;
518DROP TABLE IF EXISTS tp_face CASCADE;
519DROP TABLE IF EXISTS tp_face_gm_primitive CASCADE;
520DROP TABLE IF EXISTS tp_face_tp_complex CASCADE;
521DROP TABLE IF EXISTS tp_face_tp_directededge CASCADE;
522DROP TABLE IF EXISTS tp_face_tp_directedsolid CASCADE;
523DROP TABLE IF EXISTS tp_face_tp_primitive CASCADE;
524DROP TABLE IF EXISTS tp_node CASCADE;
525DROP TABLE IF EXISTS tp_node_gm_primitive CASCADE;
526DROP TABLE IF EXISTS tp_node_tp_complex CASCADE;
527DROP TABLE IF EXISTS tp_node_tp_primitive CASCADE;
528DROP TABLE IF EXISTS tp_primitive CASCADE;
529DROP TABLE IF EXISTS tp_ring CASCADE;
530DROP TABLE IF EXISTS tp_shell CASCADE;
531DROP TABLE IF EXISTS tp_solid CASCADE;
532DROP TABLE IF EXISTS tp_solid_gm_primitive CASCADE;
533DROP TABLE IF EXISTS tp_solid_tp_complex CASCADE;
534DROP TABLE IF EXISTS tp_solid_tp_directedface CASCADE;
535DROP TABLE IF EXISTS tp_solid_tp_primitive CASCADE;
536DROP TABLE IF EXISTS type CASCADE;
537DROP TABLE IF EXISTS typename CASCADE;
538DROP TABLE IF EXISTS unitofmeasure CASCADE;
539DROP TABLE IF EXISTS unlimitedinteger CASCADE;
540DROP TABLE IF EXISTS uomangle CASCADE;
541DROP TABLE IF EXISTS uomlength CASCADE;
542DROP TABLE IF EXISTS uomscale CASCADE;
543DROP TABLE IF EXISTS url CASCADE;
544DROP TABLE IF EXISTS cv_solidvaluepair_cv_discretecoverage CASCADE;
[8358]545DROP TABLE IF EXISTS geometries CASCADE;
546DROP TABLE IF EXISTS geometry_columns CASCADE;
547DROP TABLE IF EXISTS spatial_ref_sys CASCADE;
548
549
[8323]550DROP TABLE IF EXISTS ceda_guid CASCADE;
[8358]551UPDATE data_entity_migration
552        set ceda_observation_coll_id = NULL, doc_hash = NULL;
[8147]553
[8358]554UPDATE deployments_migration
555        set ceda_observation_id = NULL, doc_hash = NULL;
556       
557UPDATE deployment_data_migration
558        set ceda_processing_id = NULL, ceda_instrument_id = NULL,
559        ceda_compositeprocess_id = NULL, ceda_acquisition_id = NULL,
560        ceda_project_id = NULL, doc_hash = NULL;
[8323]561
562
[8147]563DROP SEQUENCE IF EXISTS angle_id_seq CASCADE;
564DROP SEQUENCE IF EXISTS any_id_seq CASCADE;
565DROP SEQUENCE IF EXISTS cc_concatenatedoperation_id_seq CASCADE;
566DROP SEQUENCE IF EXISTS cc_conversion_id_seq CASCADE;
567DROP SEQUENCE IF EXISTS cc_coordinateoperation_id_seq CASCADE;
568DROP SEQUENCE IF EXISTS cc_formula_id_seq CASCADE;
569DROP SEQUENCE IF EXISTS cc_generaloperationparameter_id_seq CASCADE;
570DROP SEQUENCE IF EXISTS cc_generalparametervalue_id_seq CASCADE;
571DROP SEQUENCE IF EXISTS cc_operationmethod_id_seq CASCADE;
572DROP SEQUENCE IF EXISTS cc_operationparametergroup_id_seq CASCADE;
573DROP SEQUENCE IF EXISTS cc_operationparameter_id_seq CASCADE;
574DROP SEQUENCE IF EXISTS cc_operationparametervalue_id_seq CASCADE;
575DROP SEQUENCE IF EXISTS cc_parametervaluegroup_id_seq CASCADE;
576DROP SEQUENCE IF EXISTS cc_parametervalue_id_seq CASCADE;
577DROP SEQUENCE IF EXISTS cc_passthroughoperation_id_seq CASCADE;
578DROP SEQUENCE IF EXISTS cc_singleoperation_id_seq CASCADE;
579DROP SEQUENCE IF EXISTS cc_transformation_id_seq CASCADE;
580DROP SEQUENCE IF EXISTS cd_datum_id_seq CASCADE;
581DROP SEQUENCE IF EXISTS cd_ellipsoid_id_seq CASCADE;
582DROP SEQUENCE IF EXISTS cd_engineeringdatum_id_seq CASCADE;
583DROP SEQUENCE IF EXISTS cd_geodeticdatum_id_seq CASCADE;
584DROP SEQUENCE IF EXISTS cd_imagedatum_id_seq CASCADE;
585DROP SEQUENCE IF EXISTS cd_primemeridian_id_seq CASCADE;
586DROP SEQUENCE IF EXISTS cd_seconddefiningparameter_id_seq CASCADE;
587DROP SEQUENCE IF EXISTS cd_verticaldatum_id_seq CASCADE;
588DROP SEQUENCE IF EXISTS ceda_acquisition_id_seq CASCADE;
589DROP SEQUENCE IF EXISTS ceda_citation_id_seq CASCADE;
590DROP SEQUENCE IF EXISTS ceda_compositeprocess_id_seq CASCADE;
591DROP SEQUENCE IF EXISTS ceda_instrument_id_seq CASCADE;
592DROP SEQUENCE IF EXISTS ceda_notes_id_seq CASCADE;
593DROP SEQUENCE IF EXISTS ceda_observationcollection_id_seq CASCADE;
594DROP SEQUENCE IF EXISTS ceda_observation_id_seq CASCADE;
595DROP SEQUENCE IF EXISTS ceda_operation_id_seq CASCADE;
596DROP SEQUENCE IF EXISTS ceda_platform_id_seq CASCADE;
597DROP SEQUENCE IF EXISTS ceda_process_id_seq CASCADE;
598DROP SEQUENCE IF EXISTS ceda_processing_id_seq CASCADE;
599DROP SEQUENCE IF EXISTS ceda_project_id_seq CASCADE;
600DROP SEQUENCE IF EXISTS ceda_result_id_seq CASCADE;
601DROP SEQUENCE IF EXISTS ceda_review_id_seq CASCADE;
602DROP SEQUENCE IF EXISTS ci_address_id_seq CASCADE;
603DROP SEQUENCE IF EXISTS ci_citation_id_seq CASCADE;
604DROP SEQUENCE IF EXISTS ci_contact_id_seq CASCADE;
605DROP SEQUENCE IF EXISTS ci_date_id_seq CASCADE;
606DROP SEQUENCE IF EXISTS ci_individual_id_seq CASCADE;
607DROP SEQUENCE IF EXISTS ci_onlineresource_id_seq CASCADE;
608DROP SEQUENCE IF EXISTS ci_organisation_id_seq CASCADE;
609DROP SEQUENCE IF EXISTS ci_party_id_seq CASCADE;
610DROP SEQUENCE IF EXISTS ci_responsibility_id_seq CASCADE;
611DROP SEQUENCE IF EXISTS ci_responsibleparty_id_seq CASCADE;
612DROP SEQUENCE IF EXISTS ci_responsiblepartyinfo_id_seq CASCADE;
613DROP SEQUENCE IF EXISTS ci_series_id_seq CASCADE;
614DROP SEQUENCE IF EXISTS ci_telephone_id_seq CASCADE;
615DROP SEQUENCE IF EXISTS class01_id_seq CASCADE;
616DROP SEQUENCE IF EXISTS class02_id_seq CASCADE;
617DROP SEQUENCE IF EXISTS class03_1_id_seq CASCADE;
618DROP SEQUENCE IF EXISTS class03_2_id_seq CASCADE;
619DROP SEQUENCE IF EXISTS class04_1_id_seq CASCADE;
620DROP SEQUENCE IF EXISTS class04_2_id_seq CASCADE;
621DROP SEQUENCE IF EXISTS class05_1_id_seq CASCADE;
622DROP SEQUENCE IF EXISTS class05_2_id_seq CASCADE;
623DROP SEQUENCE IF EXISTS class06_1_id_seq CASCADE;
624DROP SEQUENCE IF EXISTS class06_2_id_seq CASCADE;
625DROP SEQUENCE IF EXISTS class07_1_id_seq CASCADE;
626DROP SEQUENCE IF EXISTS class07_2_id_seq CASCADE;
627DROP SEQUENCE IF EXISTS class07_3_id_seq CASCADE;
628DROP SEQUENCE IF EXISTS class08_1_id_seq CASCADE;
629DROP SEQUENCE IF EXISTS class08_2_id_seq CASCADE;
630DROP SEQUENCE IF EXISTS class08_3_id_seq CASCADE;
631DROP SEQUENCE IF EXISTS class08_4_id_seq CASCADE;
632DROP SEQUENCE IF EXISTS class09_1_id_seq CASCADE;
633DROP SEQUENCE IF EXISTS class09_2_id_seq CASCADE;
634DROP SEQUENCE IF EXISTS class09_3_id_seq CASCADE;
635DROP SEQUENCE IF EXISTS class09_4_id_seq CASCADE;
636DROP SEQUENCE IF EXISTS class10_1_id_seq CASCADE;
637DROP SEQUENCE IF EXISTS class12_1_id_seq CASCADE;
638DROP SEQUENCE IF EXISTS class12_2_id_seq CASCADE;
639DROP SEQUENCE IF EXISTS class12_3_id_seq CASCADE;
640DROP SEQUENCE IF EXISTS class12_4_id_seq CASCADE;
641DROP SEQUENCE IF EXISTS cl_classificationcollection_id_seq CASCADE;
642DROP SEQUENCE IF EXISTS cl_dataset_id_seq CASCADE;
643DROP SEQUENCE IF EXISTS clocktime_id_seq CASCADE;
644DROP SEQUENCE IF EXISTS cs_affinecs_id_seq CASCADE;
645DROP SEQUENCE IF EXISTS cs_cartesiancs_id_seq CASCADE;
646DROP SEQUENCE IF EXISTS cs_coordinatesystemaxis_id_seq CASCADE;
647DROP SEQUENCE IF EXISTS cs_coordinatesystem_id_seq CASCADE;
648DROP SEQUENCE IF EXISTS cs_cylindricalcs_id_seq CASCADE;
649DROP SEQUENCE IF EXISTS cs_ellipsoidalcs_id_seq CASCADE;
650DROP SEQUENCE IF EXISTS cs_engineeringcs_id_seq CASCADE;
651DROP SEQUENCE IF EXISTS cs_geodeticcs_id_seq CASCADE;
652DROP SEQUENCE IF EXISTS cs_imagecs_id_seq CASCADE;
653DROP SEQUENCE IF EXISTS cs_linearcs_id_seq CASCADE;
654DROP SEQUENCE IF EXISTS cs_polarcs_id_seq CASCADE;
655DROP SEQUENCE IF EXISTS cs_sphericalcs_id_seq CASCADE;
656DROP SEQUENCE IF EXISTS cs_userdefinedcs_id_seq CASCADE;
657DROP SEQUENCE IF EXISTS cs_verticalcs_id_seq CASCADE;
658DROP SEQUENCE IF EXISTS cv_attributevalues_id_seq CASCADE;
659DROP SEQUENCE IF EXISTS cv_continuouscoverage_id_seq CASCADE;
660DROP SEQUENCE IF EXISTS cv_continuousquadrilateralgridcoverage_id_seq CASCADE;
661DROP SEQUENCE IF EXISTS cv_coverage_id_seq CASCADE;
662DROP SEQUENCE IF EXISTS cv_curvevaluepair_id_seq CASCADE;
663DROP SEQUENCE IF EXISTS cv_discretecoverage_id_seq CASCADE;
664DROP SEQUENCE IF EXISTS cv_discretecurvecoverage_id_seq CASCADE;
665DROP SEQUENCE IF EXISTS cv_discretegridpointcoverage_id_seq CASCADE;
666DROP SEQUENCE IF EXISTS cv_discretepointcoverage_id_seq CASCADE;
667DROP SEQUENCE IF EXISTS cv_discretesolidcoverage_id_seq CASCADE;
668DROP SEQUENCE IF EXISTS cv_discretesurfacecoverage_id_seq CASCADE;
669DROP SEQUENCE IF EXISTS cv_domainobject_id_seq CASCADE;
670DROP SEQUENCE IF EXISTS cv_footprint_id_seq CASCADE;
671DROP SEQUENCE IF EXISTS cv_geometryvaluepair_id_seq CASCADE;
672DROP SEQUENCE IF EXISTS cv_gridcell_id_seq CASCADE;
673DROP SEQUENCE IF EXISTS cv_gridcoordinate_id_seq CASCADE;
674DROP SEQUENCE IF EXISTS cv_gridenvelope_id_seq CASCADE;
675DROP SEQUENCE IF EXISTS cv_grid_id_seq CASCADE;
676DROP SEQUENCE IF EXISTS cv_gridpoint_id_seq CASCADE;
677DROP SEQUENCE IF EXISTS cv_gridpointvaluepair_id_seq CASCADE;
678DROP SEQUENCE IF EXISTS cv_gridvaluecell_id_seq CASCADE;
679DROP SEQUENCE IF EXISTS cv_gridvaluesmatrix_id_seq CASCADE;
680DROP SEQUENCE IF EXISTS cv_hexagonalgridcoverage_id_seq CASCADE;
681DROP SEQUENCE IF EXISTS cv_pointvaluepair_id_seq CASCADE;
682DROP SEQUENCE IF EXISTS cv_rectifiedgrid_id_seq CASCADE;
683DROP SEQUENCE IF EXISTS cv_referenceablegrid_id_seq CASCADE;
684DROP SEQUENCE IF EXISTS cv_segmentedcurvecoverage_id_seq CASCADE;
685DROP SEQUENCE IF EXISTS cv_sequencerule_id_seq CASCADE;
686DROP SEQUENCE IF EXISTS cv_solidvaluepair_id_seq CASCADE;
687DROP SEQUENCE IF EXISTS cv_surfacevaluepair_id_seq CASCADE;
688DROP SEQUENCE IF EXISTS cvt_discretetimeinstantcoverage_id_seq CASCADE;
689DROP SEQUENCE IF EXISTS cv_thiessenpolygoncoverage_id_seq CASCADE;
690DROP SEQUENCE IF EXISTS cv_thiessenvaluepolygon_id_seq CASCADE;
691DROP SEQUENCE IF EXISTS cv_tincoverage_id_seq CASCADE;
692DROP SEQUENCE IF EXISTS cvt_timeinstantvaluepair_id_seq CASCADE;
693DROP SEQUENCE IF EXISTS cv_valuecurve_id_seq CASCADE;
694DROP SEQUENCE IF EXISTS cv_valuehexagon_id_seq CASCADE;
695DROP SEQUENCE IF EXISTS cv_valueobject_id_seq CASCADE;
696DROP SEQUENCE IF EXISTS cv_valuesegment_id_seq CASCADE;
697DROP SEQUENCE IF EXISTS cv_valuetriangle_id_seq CASCADE;
698DROP SEQUENCE IF EXISTS date_id_seq CASCADE;
699DROP SEQUENCE IF EXISTS dateprecision_id_seq CASCADE;
700DROP SEQUENCE IF EXISTS datetime_id_seq CASCADE;
701DROP SEQUENCE IF EXISTS decimal_id_seq CASCADE;
702DROP SEQUENCE IF EXISTS directposition_id_seq CASCADE;
703DROP SEQUENCE IF EXISTS distance_id_seq CASCADE;
704DROP SEQUENCE IF EXISTS dq_absoluteexternalpositionalaccuracy_id_seq CASCADE;
705DROP SEQUENCE IF EXISTS dq_completeness_id_seq CASCADE;
706DROP SEQUENCE IF EXISTS dq_conformanceresult_id_seq CASCADE;
707DROP SEQUENCE IF EXISTS dq_dataquality_id_seq CASCADE;
708DROP SEQUENCE IF EXISTS dq_element_id_seq CASCADE;
709DROP SEQUENCE IF EXISTS dq_griddeddatapositionalaccuracy_id_seq CASCADE;
710DROP SEQUENCE IF EXISTS dq_logicalconsistency_id_seq CASCADE;
711DROP SEQUENCE IF EXISTS dq_positionalaccuracy_id_seq CASCADE;
712DROP SEQUENCE IF EXISTS dq_quantitativeresult_id_seq CASCADE;
713DROP SEQUENCE IF EXISTS dq_relativeinternalpositionalaccuracy_id_seq CASCADE;
714DROP SEQUENCE IF EXISTS dq_result_id_seq CASCADE;
715DROP SEQUENCE IF EXISTS dq_scope_id_seq CASCADE;
716DROP SEQUENCE IF EXISTS dq_temporalaccuracy_id_seq CASCADE;
717DROP SEQUENCE IF EXISTS dq_thematicaccuracy_id_seq CASCADE;
718DROP SEQUENCE IF EXISTS ds_aggregate_id_seq CASCADE;
719DROP SEQUENCE IF EXISTS ds_dataset_id_seq CASCADE;
720DROP SEQUENCE IF EXISTS ds_initiative_id_seq CASCADE;
721DROP SEQUENCE IF EXISTS ds_otheraggregate_id_seq CASCADE;
722DROP SEQUENCE IF EXISTS ds_series_id_seq CASCADE;
723DROP SEQUENCE IF EXISTS earootclass_id_seq CASCADE;
724DROP SEQUENCE IF EXISTS ex_boundingpolygon_id_seq CASCADE;
725DROP SEQUENCE IF EXISTS ex_extent_id_seq CASCADE;
726DROP SEQUENCE IF EXISTS ex_geographicboundingbox_id_seq CASCADE;
727DROP SEQUENCE IF EXISTS ex_geographicdescription_id_seq CASCADE;
728DROP SEQUENCE IF EXISTS ex_geographicextent_id_seq CASCADE;
729DROP SEQUENCE IF EXISTS ex_temporalextent_id_seq CASCADE;
730DROP SEQUENCE IF EXISTS ex_verticalextent_id_seq CASCADE;
731DROP SEQUENCE IF EXISTS genericname_id_seq CASCADE;
732DROP SEQUENCE IF EXISTS gf_aggregationtype_id_seq CASCADE;
733DROP SEQUENCE IF EXISTS gf_associationrole_id_seq CASCADE;
734DROP SEQUENCE IF EXISTS gf_associationtype_id_seq CASCADE;
735DROP SEQUENCE IF EXISTS gf_attributetype_id_seq CASCADE;
736DROP SEQUENCE IF EXISTS gf_constraint_id_seq CASCADE;
737DROP SEQUENCE IF EXISTS gf_featuretype_id_seq CASCADE;
738DROP SEQUENCE IF EXISTS gfi_domainfeature_id_seq CASCADE;
739DROP SEQUENCE IF EXISTS gfi_feature_id_seq CASCADE;
740DROP SEQUENCE IF EXISTS gf_inheritancerelation_id_seq CASCADE;
741DROP SEQUENCE IF EXISTS gf_locationalattributetype_id_seq CASCADE;
742DROP SEQUENCE IF EXISTS gf_metadataattributetype_id_seq CASCADE;
743DROP SEQUENCE IF EXISTS gf_operation_id_seq CASCADE;
744DROP SEQUENCE IF EXISTS gf_propertytype_id_seq CASCADE;
745DROP SEQUENCE IF EXISTS gf_spatialassociationtype_id_seq CASCADE;
746DROP SEQUENCE IF EXISTS gf_spatialattributetype_id_seq CASCADE;
747DROP SEQUENCE IF EXISTS gf_temporalassociationtype_id_seq CASCADE;
748DROP SEQUENCE IF EXISTS gf_temporalattributetype_id_seq CASCADE;
749DROP SEQUENCE IF EXISTS gf_thematicattributetype_id_seq CASCADE;
750DROP SEQUENCE IF EXISTS gm_affineplacement_id_seq CASCADE;
751DROP SEQUENCE IF EXISTS gm_aggregate_id_seq CASCADE;
752DROP SEQUENCE IF EXISTS gm_arcstringbybulge_id_seq CASCADE;
753DROP SEQUENCE IF EXISTS gm_arcstring_id_seq CASCADE;
754DROP SEQUENCE IF EXISTS gm_boundary_id_seq CASCADE;
755DROP SEQUENCE IF EXISTS gm_clothoid_id_seq CASCADE;
756DROP SEQUENCE IF EXISTS gm_complex_id_seq CASCADE;
757DROP SEQUENCE IF EXISTS gm_compositecurve_id_seq CASCADE;
758DROP SEQUENCE IF EXISTS gm_composite_id_seq CASCADE;
759DROP SEQUENCE IF EXISTS gm_compositepoint_id_seq CASCADE;
760DROP SEQUENCE IF EXISTS gm_compositesolid_id_seq CASCADE;
761DROP SEQUENCE IF EXISTS gm_compositesurface_id_seq CASCADE;
762DROP SEQUENCE IF EXISTS gm_conic_id_seq CASCADE;
763DROP SEQUENCE IF EXISTS gm_curve_id_seq CASCADE;
764DROP SEQUENCE IF EXISTS gm_curvesegment_id_seq CASCADE;
765DROP SEQUENCE IF EXISTS gm_geodesicstring_id_seq CASCADE;
766DROP SEQUENCE IF EXISTS gm_knot_id_seq CASCADE;
767DROP SEQUENCE IF EXISTS gm_linestring_id_seq CASCADE;
768DROP SEQUENCE IF EXISTS gm_object_id_seq CASCADE;
769DROP SEQUENCE IF EXISTS gm_offsetcurve_id_seq CASCADE;
770DROP SEQUENCE IF EXISTS gm_orientablecurve_id_seq CASCADE;
771DROP SEQUENCE IF EXISTS gm_orientableprimitive_id_seq CASCADE;
772DROP SEQUENCE IF EXISTS gm_orientablesurface_id_seq CASCADE;
773DROP SEQUENCE IF EXISTS gm_parametriccurvesurface_id_seq CASCADE;
774DROP SEQUENCE IF EXISTS gm_pointarray_id_seq CASCADE;
775DROP SEQUENCE IF EXISTS gm_point_id_seq CASCADE;
776DROP SEQUENCE IF EXISTS gm_pointref_id_seq CASCADE;
777DROP SEQUENCE IF EXISTS gm_polygon_id_seq CASCADE;
778DROP SEQUENCE IF EXISTS gm_polyhedralsurface_id_seq CASCADE;
779DROP SEQUENCE IF EXISTS gm_position_id_seq CASCADE;
780DROP SEQUENCE IF EXISTS gm_primitiveboundary_id_seq CASCADE;
781DROP SEQUENCE IF EXISTS gm_primitive_id_seq CASCADE;
782DROP SEQUENCE IF EXISTS gm_ring_id_seq CASCADE;
783DROP SEQUENCE IF EXISTS gm_solid_id_seq CASCADE;
784DROP SEQUENCE IF EXISTS gm_splinecurve_id_seq CASCADE;
785DROP SEQUENCE IF EXISTS gm_surfaceboundary_id_seq CASCADE;
786DROP SEQUENCE IF EXISTS gm_surface_id_seq CASCADE;
787DROP SEQUENCE IF EXISTS gm_surfacepatch_id_seq CASCADE;
788DROP SEQUENCE IF EXISTS gm_tin_id_seq CASCADE;
789DROP SEQUENCE IF EXISTS gm_triangle_id_seq CASCADE;
790DROP SEQUENCE IF EXISTS gm_triangulatedsurface_id_seq CASCADE;
791DROP SEQUENCE IF EXISTS if_classificationattributetype_id_seq CASCADE;
792DROP SEQUENCE IF EXISTS io_identifiedobjectbase_id_seq CASCADE;
793DROP SEQUENCE IF EXISTS io_identifiedobject_id_seq CASCADE;
794DROP SEQUENCE IF EXISTS juliandate_id_seq CASCADE;
795DROP SEQUENCE IF EXISTS le_algorithm_id_seq CASCADE;
796DROP SEQUENCE IF EXISTS length_id_seq CASCADE;
797DROP SEQUENCE IF EXISTS le_nominalresolution_id_seq CASCADE;
798DROP SEQUENCE IF EXISTS le_source_id_seq CASCADE;
799DROP SEQUENCE IF EXISTS li_lineage_id_seq CASCADE;
800DROP SEQUENCE IF EXISTS li_processstep_id_seq CASCADE;
801DROP SEQUENCE IF EXISTS li_source_id_seq CASCADE;
802DROP SEQUENCE IF EXISTS localname_id_seq CASCADE;
803DROP SEQUENCE IF EXISTS location_id_seq CASCADE;
804DROP SEQUENCE IF EXISTS md_aggregateinformation_id_seq CASCADE;
805DROP SEQUENCE IF EXISTS md_applicationschemainformation_id_seq CASCADE;
806DROP SEQUENCE IF EXISTS md_browsegraphic_id_seq CASCADE;
807DROP SEQUENCE IF EXISTS md_constraints_id_seq CASCADE;
808DROP SEQUENCE IF EXISTS md_contentinformation_id_seq CASCADE;
809DROP SEQUENCE IF EXISTS md_coveragedescription_id_seq CASCADE;
810DROP SEQUENCE IF EXISTS md_digitaltransferoptions_id_seq CASCADE;
811DROP SEQUENCE IF EXISTS md_dimension_id_seq CASCADE;
812DROP SEQUENCE IF EXISTS md_distribution_id_seq CASCADE;
813DROP SEQUENCE IF EXISTS md_distributor_id_seq CASCADE;
814DROP SEQUENCE IF EXISTS md_extendedelementinformation_id_seq CASCADE;
815DROP SEQUENCE IF EXISTS md_featurecataloguedescription_id_seq CASCADE;
816DROP SEQUENCE IF EXISTS md_format_id_seq CASCADE;
817DROP SEQUENCE IF EXISTS md_geometricobjects_id_seq CASCADE;
818DROP SEQUENCE IF EXISTS md_gridspatialrepresentation_id_seq CASCADE;
819DROP SEQUENCE IF EXISTS md_identification_id_seq CASCADE;
820DROP SEQUENCE IF EXISTS md_identifier_id_seq CASCADE;
821DROP SEQUENCE IF EXISTS md_imagedescription_id_seq CASCADE;
822DROP SEQUENCE IF EXISTS md_keywords_id_seq CASCADE;
823DROP SEQUENCE IF EXISTS md_legalconstraints_id_seq CASCADE;
824DROP SEQUENCE IF EXISTS md_maintenanceinformation_id_seq CASCADE;
825DROP SEQUENCE IF EXISTS md_medium_id_seq CASCADE;
826DROP SEQUENCE IF EXISTS md_metadataextensioninformation_id_seq CASCADE;
827DROP SEQUENCE IF EXISTS md_metadata_id_seq CASCADE;
828DROP SEQUENCE IF EXISTS md_portrayalcataloguereference_id_seq CASCADE;
829DROP SEQUENCE IF EXISTS md_rangedimension_id_seq CASCADE;
830DROP SEQUENCE IF EXISTS md_referencesystem_id_seq CASCADE;
831DROP SEQUENCE IF EXISTS md_representativefraction_id_seq CASCADE;
832DROP SEQUENCE IF EXISTS md_scopedescription_id_seq CASCADE;
833DROP SEQUENCE IF EXISTS md_securityconstraints_id_seq CASCADE;
834DROP SEQUENCE IF EXISTS md_spatialrepresentation_id_seq CASCADE;
835DROP SEQUENCE IF EXISTS md_standardorderprocess_id_seq CASCADE;
836DROP SEQUENCE IF EXISTS md_usage_id_seq CASCADE;
837DROP SEQUENCE IF EXISTS md_vectorspatialrepresentation_id_seq CASCADE;
838DROP SEQUENCE IF EXISTS measure_id_seq CASCADE;
839DROP SEQUENCE IF EXISTS membername_id_seq CASCADE;
840DROP SEQUENCE IF EXISTS mi_coveragedescription_id_seq CASCADE;
841DROP SEQUENCE IF EXISTS mi_rangeelementdescription_id_seq CASCADE;
842DROP SEQUENCE IF EXISTS mo_acquisition_id_seq CASCADE;
843DROP SEQUENCE IF EXISTS mo_compositeprocess_id_seq CASCADE;
844DROP SEQUENCE IF EXISTS mo_computation_id_seq CASCADE;
845DROP SEQUENCE IF EXISTS mo_featureofinterest_id_seq CASCADE;
846DROP SEQUENCE IF EXISTS mo_inputoutput_id_seq CASCADE;
847DROP SEQUENCE IF EXISTS mo_instrument_id_seq CASCADE;
848DROP SEQUENCE IF EXISTS mo_instrumentplatformpair_id_seq CASCADE;
849DROP SEQUENCE IF EXISTS mo_location_id_seq CASCADE;
850DROP SEQUENCE IF EXISTS mo_observationcollection_id_seq CASCADE;
851DROP SEQUENCE IF EXISTS mo_observation_id_seq CASCADE;
852DROP SEQUENCE IF EXISTS mo_onlineresource_id_seq CASCADE;
853DROP SEQUENCE IF EXISTS mo_operation_id_seq CASCADE;
854DROP SEQUENCE IF EXISTS mo_organization_id_seq CASCADE;
855DROP SEQUENCE IF EXISTS mo_platform_id_seq CASCADE;
856DROP SEQUENCE IF EXISTS mo_process_id_seq CASCADE;
857DROP SEQUENCE IF EXISTS mo_processing_id_seq CASCADE;
858DROP SEQUENCE IF EXISTS mo_project_id_seq CASCADE;
859DROP SEQUENCE IF EXISTS mo_responsiblepartyinfo_id_seq CASCADE;
860DROP SEQUENCE IF EXISTS mo_result_id_seq CASCADE;
861DROP SEQUENCE IF EXISTS multiplicity_id_seq CASCADE;
862DROP SEQUENCE IF EXISTS multiplicityrange_id_seq CASCADE;
863DROP SEQUENCE IF EXISTS mx_datafile_id_seq CASCADE;
864DROP SEQUENCE IF EXISTS namedvalue_id_seq CASCADE;
865DROP SEQUENCE IF EXISTS namespace_id_seq CASCADE;
866DROP SEQUENCE IF EXISTS om_categoryobservation_id_seq CASCADE;
867DROP SEQUENCE IF EXISTS om_complexobservation_id_seq CASCADE;
868DROP SEQUENCE IF EXISTS om_countobservation_id_seq CASCADE;
869DROP SEQUENCE IF EXISTS om_discretecoverageobservation_id_seq CASCADE;
870DROP SEQUENCE IF EXISTS om_geometryobservation_id_seq CASCADE;
871DROP SEQUENCE IF EXISTS om_measurement_id_seq CASCADE;
872DROP SEQUENCE IF EXISTS om_observation_id_seq CASCADE;
873DROP SEQUENCE IF EXISTS om_process_id_seq CASCADE;
874DROP SEQUENCE IF EXISTS om_temporalobservation_id_seq CASCADE;
875DROP SEQUENCE IF EXISTS om_truthobservation_id_seq CASCADE;
876DROP SEQUENCE IF EXISTS qe_coverageresult_id_seq CASCADE;
877DROP SEQUENCE IF EXISTS qe_usability_id_seq CASCADE;
878DROP SEQUENCE IF EXISTS record_id_seq CASCADE;
879DROP SEQUENCE IF EXISTS recordtype_id_seq CASCADE;
880DROP SEQUENCE IF EXISTS rs_identifier_id_seq CASCADE;
881DROP SEQUENCE IF EXISTS rs_referencesystem_id_seq CASCADE;
882DROP SEQUENCE IF EXISTS scale_id_seq CASCADE;
883DROP SEQUENCE IF EXISTS sc_compoundcrs_id_seq CASCADE;
884DROP SEQUENCE IF EXISTS sc_crs_id_seq CASCADE;
885DROP SEQUENCE IF EXISTS sc_derivedcrs_id_seq CASCADE;
886DROP SEQUENCE IF EXISTS sc_engineeringcrs_id_seq CASCADE;
887DROP SEQUENCE IF EXISTS sc_generalderivedcrs_id_seq CASCADE;
888DROP SEQUENCE IF EXISTS sc_geodeticcrs_id_seq CASCADE;
889DROP SEQUENCE IF EXISTS schema_id_seq CASCADE;
890DROP SEQUENCE IF EXISTS sc_imagecrs_id_seq CASCADE;
891DROP SEQUENCE IF EXISTS scopedname_id_seq CASCADE;
892DROP SEQUENCE IF EXISTS sc_projectedcrs_id_seq CASCADE;
893DROP SEQUENCE IF EXISTS sc_singlecrs_id_seq CASCADE;
894DROP SEQUENCE IF EXISTS sc_verticalcrs_id_seq CASCADE;
895DROP SEQUENCE IF EXISTS sf_process_id_seq CASCADE;
896DROP SEQUENCE IF EXISTS sf_samplingfeature_id_seq CASCADE;
897DROP SEQUENCE IF EXISTS sf_spatialsamplingfeature_id_seq CASCADE;
898DROP SEQUENCE IF EXISTS sf_specimen_id_seq CASCADE;
899DROP SEQUENCE IF EXISTS time_id_seq CASCADE;
900DROP SEQUENCE IF EXISTS tm_caldate_id_seq CASCADE;
901DROP SEQUENCE IF EXISTS tm_calendarera_id_seq CASCADE;
902DROP SEQUENCE IF EXISTS tm_calendar_id_seq CASCADE;
903DROP SEQUENCE IF EXISTS tm_clock_id_seq CASCADE;
904DROP SEQUENCE IF EXISTS tm_clocktime_id_seq CASCADE;
905DROP SEQUENCE IF EXISTS tm_complex_id_seq CASCADE;
906DROP SEQUENCE IF EXISTS tm_coordinate_id_seq CASCADE;
907DROP SEQUENCE IF EXISTS tm_coordinatesystem_id_seq CASCADE;
908DROP SEQUENCE IF EXISTS tm_duration_id_seq CASCADE;
909DROP SEQUENCE IF EXISTS tm_edge_id_seq CASCADE;
910DROP SEQUENCE IF EXISTS tm_geometricprimitive_id_seq CASCADE;
911DROP SEQUENCE IF EXISTS tm_instant_id_seq CASCADE;
912DROP SEQUENCE IF EXISTS tm_node_id_seq CASCADE;
913DROP SEQUENCE IF EXISTS tm_object_id_seq CASCADE;
914DROP SEQUENCE IF EXISTS tm_ordinalera_id_seq CASCADE;
915DROP SEQUENCE IF EXISTS tm_ordinalposition_id_seq CASCADE;
916DROP SEQUENCE IF EXISTS tm_ordinalreferencesystem_id_seq CASCADE;
917DROP SEQUENCE IF EXISTS tm_periodduration_id_seq CASCADE;
918DROP SEQUENCE IF EXISTS tm_period_id_seq CASCADE;
919DROP SEQUENCE IF EXISTS tm_position_id_seq CASCADE;
920DROP SEQUENCE IF EXISTS tm_primitive_id_seq CASCADE;
921DROP SEQUENCE IF EXISTS tm_referencesystem_id_seq CASCADE;
922DROP SEQUENCE IF EXISTS tm_temporalcrs_id_seq CASCADE;
923DROP SEQUENCE IF EXISTS tm_temporalposition_id_seq CASCADE;
924DROP SEQUENCE IF EXISTS tm_topologicalcomplex_id_seq CASCADE;
925DROP SEQUENCE IF EXISTS tm_topologicalprimitive_id_seq CASCADE;
926DROP SEQUENCE IF EXISTS tp_boundary_id_seq CASCADE;
927DROP SEQUENCE IF EXISTS tp_complex_id_seq CASCADE;
928DROP SEQUENCE IF EXISTS tp_directededge_id_seq CASCADE;
929DROP SEQUENCE IF EXISTS tp_directedface_id_seq CASCADE;
930DROP SEQUENCE IF EXISTS tp_directednode_id_seq CASCADE;
931DROP SEQUENCE IF EXISTS tp_directedsolid_id_seq CASCADE;
932DROP SEQUENCE IF EXISTS tp_directedtopo_id_seq CASCADE;
933DROP SEQUENCE IF EXISTS tp_edge_id_seq CASCADE;
934DROP SEQUENCE IF EXISTS tp_expression_id_seq CASCADE;
935DROP SEQUENCE IF EXISTS tp_expressionterm_id_seq CASCADE;
936DROP SEQUENCE IF EXISTS tp_face_id_seq CASCADE;
937DROP SEQUENCE IF EXISTS tp_node_id_seq CASCADE;
938DROP SEQUENCE IF EXISTS tp_primitive_id_seq CASCADE;
939DROP SEQUENCE IF EXISTS tp_ring_id_seq CASCADE;
940DROP SEQUENCE IF EXISTS tp_shell_id_seq CASCADE;
941DROP SEQUENCE IF EXISTS tp_solid_id_seq CASCADE;
942DROP SEQUENCE IF EXISTS type_id_seq CASCADE;
943DROP SEQUENCE IF EXISTS typename_id_seq CASCADE;
944DROP SEQUENCE IF EXISTS unitofmeasure_id_seq CASCADE;
945DROP SEQUENCE IF EXISTS unlimitedinteger_id_seq CASCADE;
946DROP SEQUENCE IF EXISTS uomangle_id_seq CASCADE;
947DROP SEQUENCE IF EXISTS uomlength_id_seq CASCADE;
948DROP SEQUENCE IF EXISTS uomscale_id_seq CASCADE;
[8358]949DROP SEQUENCE IF EXISTS url_id_seq CASCADE;
Note: See TracBrowser for help on using the repository browser.