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

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

Complete - # 22486: CEDA Observation Collection - Title
 http://team.ceda.ac.uk/trac/ceda/ticket/22486

Line 
1DROP SEQUENCE IF EXISTS ad_abstractaddress_id_seq CASCADE;
2DROP SEQUENCE IF EXISTS arcbycenterpoint_id_seq CASCADE;
3DROP SEQUENCE IF EXISTS cell_id_seq CASCADE;
4DROP SEQUENCE IF EXISTS cellularcomplex_id_seq CASCADE;
5DROP SEQUENCE IF EXISTS eg_pointestimate_id_seq CASCADE;
6DROP SEQUENCE IF EXISTS fd_featurecollection_id_seq CASCADE;
7DROP SEQUENCE IF EXISTS fd_feature_id_seq CASCADE;
8DROP SEQUENCE IF EXISTS fd_featurename_id_seq CASCADE;
9DROP SEQUENCE IF EXISTS lr_element_id_seq CASCADE;
10DROP SEQUENCE IF EXISTS lr_feature_id_seq CASCADE;
11DROP SEQUENCE IF EXISTS lr_linearreferencemethod_id_seq CASCADE;
12DROP SEQUENCE IF EXISTS lr_offsetexpression_id_seq CASCADE;
13DROP SEQUENCE IF EXISTS lr_positionexpression_id_seq CASCADE;
14DROP SEQUENCE IF EXISTS lr_referencemarker_id_seq CASCADE;
15DROP SEQUENCE IF EXISTS mo_citation_id_seq CASCADE;
16DROP SEQUENCE IF EXISTS mo_individual_id_seq CASCADE;
17DROP SEQUENCE IF EXISTS mo_organisation_id_seq CASCADE;
18DROP SEQUENCE IF EXISTS mo_party_id_seq CASCADE;
19DROP SEQUENCE IF EXISTS nl_compositecurve_id_seq CASCADE;
20DROP SEQUENCE IF EXISTS nl_composite_id_seq CASCADE;
21DROP SEQUENCE IF EXISTS nl_compositepoint_id_seq CASCADE;
22DROP SEQUENCE IF EXISTS nl_compsitesurface_id_seq CASCADE;
23DROP SEQUENCE IF EXISTS nl_curve_id_seq CASCADE;
24DROP SEQUENCE IF EXISTS nl_curvesegment_id_seq CASCADE;
25DROP SEQUENCE IF EXISTS nl_map_id_seq CASCADE;
26DROP SEQUENCE IF EXISTS nl_orientablecurve_id_seq CASCADE;
27DROP SEQUENCE IF EXISTS nl_orientablesurface_id_seq CASCADE;
28DROP SEQUENCE IF EXISTS nl_point_id_seq CASCADE;
29DROP SEQUENCE IF EXISTS nl_primitve_id_seq CASCADE;
30DROP SEQUENCE IF EXISTS nl_ring_id_seq CASCADE;
31DROP SEQUENCE IF EXISTS nl_surfaceboundary_id_seq CASCADE;
32DROP SEQUENCE IF EXISTS nl_surface_id_seq CASCADE;
33DROP SEQUENCE IF EXISTS nl_surfacepatch_id_seq CASCADE;
34DROP SEQUENCE IF EXISTS ns_avoidlist_id_seq CASCADE;
35DROP SEQUENCE IF EXISTS ns_costedlink_id_seq CASCADE;
36DROP SEQUENCE IF EXISTS ns_costedturn_id_seq CASCADE;
37DROP SEQUENCE IF EXISTS ns_costfunction_id_seq CASCADE;
38DROP SEQUENCE IF EXISTS ns_routerequest_id_seq CASCADE;
39DROP SEQUENCE IF EXISTS nt_advisorydirection_id_seq CASCADE;
40DROP SEQUENCE IF EXISTS nt_advisorydistance_id_seq CASCADE;
41DROP SEQUENCE IF EXISTS nt_advisoryelement_id_seq CASCADE;
42DROP SEQUENCE IF EXISTS nt_advisory_id_seq CASCADE;
43DROP SEQUENCE IF EXISTS nt_advisoryspatialrelation_id_seq CASCADE;
44DROP SEQUENCE IF EXISTS nt_combinednetwork_id_seq CASCADE;
45DROP SEQUENCE IF EXISTS nt_constraint_id_seq CASCADE;
46DROP SEQUENCE IF EXISTS nt_exitassociation_id_seq CASCADE;
47DROP SEQUENCE IF EXISTS nt_junction_id_seq CASCADE;
48DROP TABLE IF EXISTS angle CASCADE;
49DROP TABLE IF EXISTS "any" CASCADE;
50DROP TABLE IF EXISTS cc_concatenatedoperation CASCADE;
51DROP TABLE IF EXISTS cc_concatenatedoperation_cc_concatenatedoperation CASCADE;
52DROP TABLE IF EXISTS cc_conversion CASCADE;
53DROP TABLE IF EXISTS cc_coordinateoperation CASCADE;
54DROP TABLE IF EXISTS cc_formula CASCADE;
55DROP TABLE IF EXISTS cc_generaloperationparameter CASCADE;
56DROP TABLE IF EXISTS cc_generalparametervalue CASCADE;
57DROP TABLE IF EXISTS cc_operationmethod CASCADE;
58DROP TABLE IF EXISTS cc_operationparameter CASCADE;
59DROP TABLE IF EXISTS cc_operationparametergroup CASCADE;
60DROP TABLE IF EXISTS cc_operationparametergroup_cc_operationparametergroup CASCADE;
61DROP TABLE IF EXISTS cc_operationparametervalue CASCADE;
62DROP TABLE IF EXISTS cc_parametervalue CASCADE;
63DROP TABLE IF EXISTS cc_parametervaluegroup CASCADE;
64DROP TABLE IF EXISTS cc_parametervaluegroup_cc_parametervaluegroup CASCADE;
65DROP TABLE IF EXISTS cc_passthroughoperation CASCADE;
66DROP TABLE IF EXISTS cc_singleoperation CASCADE;
67DROP TABLE IF EXISTS cc_transformation CASCADE;
68DROP TABLE IF EXISTS cd_datum CASCADE;
69DROP TABLE IF EXISTS cd_ellipsoid CASCADE;
70DROP TABLE IF EXISTS cd_engineeringdatum CASCADE;
71DROP TABLE IF EXISTS cd_geodeticdatum CASCADE;
72DROP TABLE IF EXISTS cd_imagedatum CASCADE;
73DROP TABLE IF EXISTS cd_primemeridian CASCADE;
74DROP TABLE IF EXISTS cd_seconddefiningparameter CASCADE;
75DROP TABLE IF EXISTS cd_verticaldatum CASCADE;
76DROP TABLE IF EXISTS ceda_acquisition CASCADE;
77DROP TABLE IF EXISTS ceda_citation CASCADE;
78DROP TABLE IF EXISTS ceda_compositeprocess CASCADE;
79DROP TABLE IF EXISTS ceda_instrument CASCADE;
80DROP TABLE IF EXISTS ceda_notes CASCADE;
81DROP TABLE IF EXISTS ceda_observation CASCADE;
82DROP TABLE IF EXISTS ceda_observationcollection CASCADE;
83DROP TABLE IF EXISTS ceda_operation CASCADE;
84DROP TABLE IF EXISTS ceda_platform CASCADE;
85DROP TABLE IF EXISTS ceda_process CASCADE;
86DROP TABLE IF EXISTS ceda_processing CASCADE;
87DROP TABLE IF EXISTS ceda_project CASCADE;
88DROP TABLE IF EXISTS ceda_result CASCADE;
89DROP TABLE IF EXISTS ceda_review CASCADE;
90DROP TABLE IF EXISTS ci_address CASCADE;
91DROP TABLE IF EXISTS ci_citation CASCADE;
92DROP TABLE IF EXISTS ci_contact CASCADE;
93DROP TABLE IF EXISTS ci_date CASCADE;
94DROP TABLE IF EXISTS ci_individual CASCADE;
95DROP TABLE IF EXISTS ci_onlineresource CASCADE;
96DROP TABLE IF EXISTS ci_organisation CASCADE;
97DROP TABLE IF EXISTS ci_party CASCADE;
98DROP TABLE IF EXISTS ci_responsibility CASCADE;
99DROP TABLE IF EXISTS ci_responsibleparty CASCADE;
100DROP TABLE IF EXISTS ci_responsiblepartyinfo CASCADE;
101DROP TABLE IF EXISTS ci_series CASCADE;
102DROP TABLE IF EXISTS ci_telephone CASCADE;
103DROP TABLE IF EXISTS cl_classificationcollection CASCADE;
104DROP TABLE IF EXISTS cl_classificationcollection_cv_surfacevaluepair CASCADE;
105DROP TABLE IF EXISTS cl_dataset CASCADE;
106DROP TABLE IF EXISTS cl_dataset_md_metadata CASCADE;
107DROP TABLE IF EXISTS clocktime CASCADE;
108DROP TABLE IF EXISTS cs_affinecs CASCADE;
109DROP TABLE IF EXISTS cs_cartesiancs CASCADE;
110DROP TABLE IF EXISTS cs_coordinatesystemaxis CASCADE;
111DROP TABLE IF EXISTS cs_coordinatesystem CASCADE;
112DROP TABLE IF EXISTS cs_cylindricalcs CASCADE;
113DROP TABLE IF EXISTS cs_ellipsoidalcs CASCADE;
114DROP TABLE IF EXISTS cs_engineeringcs CASCADE;
115DROP TABLE IF EXISTS cs_geodeticcs CASCADE;
116DROP TABLE IF EXISTS cs_imagecs CASCADE;
117DROP TABLE IF EXISTS cs_linearcs CASCADE;
118DROP TABLE IF EXISTS cs_polarcs CASCADE;
119DROP TABLE IF EXISTS cs_sphericalcs CASCADE;
120DROP TABLE IF EXISTS cs_userdefinedcs CASCADE;
121DROP TABLE IF EXISTS cs_verticalcs CASCADE;
122DROP TABLE IF EXISTS cv_attributevalues CASCADE;
123DROP TABLE IF EXISTS cv_continuouscoverage CASCADE;
124DROP TABLE IF EXISTS cv_continuousquadrilateralgridcoverage CASCADE;
125DROP TABLE IF EXISTS cv_continuousquadrilateralgridcoverage_cv_gridvaluecell CASCADE;
126DROP TABLE IF EXISTS cv_continuousquadrilateralgridcoverage_cv_valueobject CASCADE;
127DROP TABLE IF EXISTS cv_coverage CASCADE;
128DROP TABLE IF EXISTS cv_curvevaluepair CASCADE;
129DROP TABLE IF EXISTS cv_curvevaluepair_cv_discretecoverage CASCADE;
130DROP TABLE IF EXISTS cv_curvevaluepair_cv_discretecurvecoverage CASCADE;
131DROP TABLE IF EXISTS cv_curvevaluepair_cv_valueobject CASCADE;
132DROP TABLE IF EXISTS cv_discretecoverage CASCADE;
133DROP TABLE IF EXISTS cv_discretecurvecoverage CASCADE;
134DROP TABLE IF EXISTS cv_discretecurvecoverage_cv_curvevaluepair CASCADE;
135DROP TABLE IF EXISTS cv_discretecurvecoverage_cv_geometryvaluepair CASCADE;
136DROP TABLE IF EXISTS cv_discretegridpointcoverage CASCADE;
137DROP TABLE IF EXISTS cv_discretegridpointcoverage_cv_geometryvaluepair CASCADE;
138DROP TABLE IF EXISTS cv_discretegridpointcoverage_cv_gridpointvaluepair CASCADE;
139DROP TABLE IF EXISTS cv_discretepointcoverage CASCADE;
140DROP TABLE IF EXISTS cv_discretepointcoverage_cv_geometryvaluepair CASCADE;
141DROP TABLE IF EXISTS cv_discretepointcoverage_cv_gridpointvaluepair CASCADE;
142DROP TABLE IF EXISTS cv_discretepointcoverage_cv_pointvaluepair CASCADE;
143DROP TABLE IF EXISTS cv_discretesolidcoverage CASCADE;
144DROP TABLE IF EXISTS cv_discretesolidcoverage_cv_geometryvaluepair CASCADE;
145DROP TABLE IF EXISTS cv_discretesolidcoverage_cv_solidvaluepair CASCADE;
146DROP TABLE IF EXISTS cv_discretesurfacecoverage CASCADE;
147DROP TABLE IF EXISTS cv_discretesurfacecoverage_cv_geometryvaluepair CASCADE;
148DROP TABLE IF EXISTS cv_discretesurfacecoverage_cv_surfacevaluepair CASCADE;
149DROP TABLE IF EXISTS cv_domainobject CASCADE;
150DROP TABLE IF EXISTS cv_domainobject_cv_coverage CASCADE;
151DROP TABLE IF EXISTS cv_footprint CASCADE;
152DROP TABLE IF EXISTS cv_footprint_cv_gridpoint CASCADE;
153DROP TABLE IF EXISTS cv_geometryvaluepair CASCADE;
154DROP TABLE IF EXISTS cv_grid CASCADE;
155DROP TABLE IF EXISTS cv_gridcell CASCADE;
156DROP TABLE IF EXISTS cv_gridcell_cv_grid CASCADE;
157DROP TABLE IF EXISTS cv_gridcell_cv_gridpoint CASCADE;
158DROP TABLE IF EXISTS cv_gridcoordinate CASCADE;
159DROP TABLE IF EXISTS cv_gridenvelope CASCADE;
160DROP TABLE IF EXISTS cv_gridpoint CASCADE;
161DROP TABLE IF EXISTS cv_gridpoint_cv_footprint CASCADE;
162DROP TABLE IF EXISTS cv_gridpoint_cv_grid CASCADE;
163DROP TABLE IF EXISTS cv_gridpoint_cv_gridcell CASCADE;
164DROP TABLE IF EXISTS cv_gridpoint_gm_point CASCADE;
165DROP TABLE IF EXISTS cv_gridpointvaluepair CASCADE;
166DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_discretecoverage CASCADE;
167DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_discretegridpointcoverage CASCADE;
168DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_discretepointcoverage CASCADE;
169DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_gridvaluecell CASCADE;
170DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_valuehexagon CASCADE;
171DROP TABLE IF EXISTS cv_gridpointvaluepair_cv_valueobject CASCADE;
172DROP TABLE IF EXISTS cv_gridvaluecell CASCADE;
173DROP TABLE IF EXISTS cv_gridvaluecell_cv_continuouscoverage CASCADE;
174DROP TABLE IF EXISTS cv_gridvaluecell_cv_continuousquadrilateralgridcoverage CASCADE;
175DROP TABLE IF EXISTS cv_gridvaluecell_cv_geometryvaluepair CASCADE;
176DROP TABLE IF EXISTS cv_gridvaluecell_cv_gridpointvaluepair CASCADE;
177DROP TABLE IF EXISTS cv_gridvaluesmatrix CASCADE;
178DROP TABLE IF EXISTS cv_hexagonalgridcoverage CASCADE;
179DROP TABLE IF EXISTS cv_hexagonalgridcoverage_cv_gridvaluesmatrix CASCADE;
180DROP TABLE IF EXISTS cv_hexagonalgridcoverage_cv_valuehexagon CASCADE;
181DROP TABLE IF EXISTS cv_hexagonalgridcoverage_cv_valueobject CASCADE;
182DROP TABLE IF EXISTS cv_pointvaluepair CASCADE;
183DROP TABLE IF EXISTS cv_pointvaluepair_cv_discretecoverage CASCADE;
184DROP TABLE IF EXISTS cv_pointvaluepair_cv_discretepointcoverage CASCADE;
185DROP TABLE IF EXISTS cv_pointvaluepair_cv_thiessenvaluepolygon CASCADE;
186DROP TABLE IF EXISTS cv_pointvaluepair_cv_valuecurve CASCADE;
187DROP TABLE IF EXISTS cv_pointvaluepair_cv_valueobject CASCADE;
188DROP TABLE IF EXISTS cv_rectifiedgrid CASCADE;
189DROP TABLE IF EXISTS cv_referenceablegrid CASCADE;
190DROP TABLE IF EXISTS cv_segmentedcurvecoverage CASCADE;
191DROP TABLE IF EXISTS cv_segmentedcurvecoverage_cv_valuecurve CASCADE;
192DROP TABLE IF EXISTS cv_segmentedcurvecoverage_cv_valueobject CASCADE;
193DROP TABLE IF EXISTS cv_sequencerule CASCADE;
194DROP TABLE IF EXISTS cv_solidvaluepair CASCADE;
195DROP TABLE IF EXISTS cv_solidvaluepair_cv_discretesolidcoverage CASCADE;
196DROP TABLE IF EXISTS cv_solidvaluepair_cv_valueobject CASCADE;
197DROP TABLE IF EXISTS cv_surfacevaluepair CASCADE;
198DROP TABLE IF EXISTS cv_surfacevaluepair_cl_classificationcollection CASCADE;
199DROP TABLE IF EXISTS cv_surfacevaluepair_cv_discretecoverage CASCADE;
200DROP TABLE IF EXISTS cv_surfacevaluepair_cv_discretesurfacecoverage CASCADE;
201DROP TABLE IF EXISTS cv_surfacevaluepair_cv_valueobject CASCADE;
202DROP TABLE IF EXISTS cvt_discretetimeinstantcoverage CASCADE;
203DROP TABLE IF EXISTS cvt_discretetimeinstantcoverage_cv_geometryvaluepair CASCADE;
204DROP TABLE IF EXISTS cvt_discretetimeinstantcoverage_cvt_timeinstantvaluepair CASCADE;
205DROP TABLE IF EXISTS cv_thiessenpolygoncoverage CASCADE;
206DROP TABLE IF EXISTS cv_thiessenpolygoncoverage_cv_thiessenvaluepolygon CASCADE;
207DROP TABLE IF EXISTS cv_thiessenpolygoncoverage_cv_valueobject CASCADE;
208DROP TABLE IF EXISTS cv_thiessenvaluepolygon CASCADE;
209DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_continuouscoverage CASCADE;
210DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_geometryvaluepair CASCADE;
211DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_pointvaluepair CASCADE;
212DROP TABLE IF EXISTS cv_thiessenvaluepolygon_cv_thiessenpolygoncoverage CASCADE;
213DROP TABLE IF EXISTS cv_tincoverage CASCADE;
214DROP TABLE IF EXISTS cvt_timeinstantvaluepair CASCADE;
215DROP TABLE IF EXISTS cvt_timeinstantvaluepair_cv_discretecoverage CASCADE;
216DROP TABLE IF EXISTS cvt_timeinstantvaluepair_cvt_discretetimeinstantcoverage CASCADE;
217DROP TABLE IF EXISTS cvt_timeinstantvaluepair_cv_valueobject CASCADE;
218DROP TABLE IF EXISTS cv_valuecurve CASCADE;
219DROP TABLE IF EXISTS cv_valuecurve_cv_continuouscoverage CASCADE;
220DROP TABLE IF EXISTS cv_valuecurve_cv_geometryvaluepair CASCADE;
221DROP TABLE IF EXISTS cv_valuecurve_cv_pointvaluepair CASCADE;
222DROP TABLE IF EXISTS cv_valuecurve_cv_segmentedcurvecoverage CASCADE;
223DROP TABLE IF EXISTS cv_valuecurve_cv_valuesegment CASCADE;
224DROP TABLE IF EXISTS cv_valuehexagon CASCADE;
225DROP TABLE IF EXISTS cv_valuehexagon_cv_continuouscoverage CASCADE;
226DROP TABLE IF EXISTS cv_valuehexagon_cv_geometryvaluepair CASCADE;
227DROP TABLE IF EXISTS cv_valuehexagon_cv_gridpointvaluepair CASCADE;
228DROP TABLE IF EXISTS cv_valuehexagon_cv_hexagonalgridcoverage CASCADE;
229DROP TABLE IF EXISTS cv_valueobject CASCADE;
230DROP TABLE IF EXISTS cv_valuesegment CASCADE;
231DROP TABLE IF EXISTS cv_valuesegment_cv_valuecurve CASCADE;
232DROP TABLE IF EXISTS cv_valuetriangle CASCADE;
233DROP TABLE IF EXISTS date CASCADE;
234DROP TABLE IF EXISTS dateprecision CASCADE;
235DROP TABLE IF EXISTS datetime CASCADE;
236DROP TABLE IF EXISTS decimal CASCADE;
237DROP TABLE IF EXISTS directposition CASCADE;
238DROP TABLE IF EXISTS distance CASCADE;
239DROP TABLE IF EXISTS dq_absoluteexternalpositionalaccuracy CASCADE;
240DROP TABLE IF EXISTS dq_completeness CASCADE;
241DROP TABLE IF EXISTS dq_conformanceresult CASCADE;
242DROP TABLE IF EXISTS dq_dataquality CASCADE;
243DROP TABLE IF EXISTS dq_element CASCADE;
244DROP TABLE IF EXISTS dq_griddeddatapositionalaccuracy CASCADE;
245DROP TABLE IF EXISTS dq_logicalconsistency CASCADE;
246DROP TABLE IF EXISTS dq_positionalaccuracy CASCADE;
247DROP TABLE IF EXISTS dq_quantitativeresult CASCADE;
248DROP TABLE IF EXISTS dq_relativeinternalpositionalaccuracy CASCADE;
249DROP TABLE IF EXISTS dq_result CASCADE;
250DROP TABLE IF EXISTS dq_scope CASCADE;
251DROP TABLE IF EXISTS dq_temporalaccuracy CASCADE;
252DROP TABLE IF EXISTS dq_thematicaccuracy CASCADE;
253DROP TABLE IF EXISTS ds_aggregate CASCADE;
254DROP TABLE IF EXISTS ds_dataset CASCADE;
255DROP TABLE IF EXISTS ds_dataset_ds_aggregate CASCADE;
256DROP TABLE IF EXISTS ds_dataset_md_metadata CASCADE;
257DROP TABLE IF EXISTS ds_initiative CASCADE;
258DROP TABLE IF EXISTS ds_otheraggregate CASCADE;
259DROP TABLE IF EXISTS ds_series CASCADE;
260DROP TABLE IF EXISTS earootclass CASCADE;
261DROP TABLE IF EXISTS ex_boundingpolygon CASCADE;
262DROP TABLE IF EXISTS ex_boundingpolygon_ex_extent CASCADE;
263DROP TABLE IF EXISTS ex_boundingpolygon_mo_observation CASCADE;
264DROP TABLE IF EXISTS ex_boundingpolygon_mo_observationcollection CASCADE;
265DROP TABLE IF EXISTS ex_extent CASCADE;
266DROP TABLE IF EXISTS ex_extent_ci_responsiblepartyinfo CASCADE;
267DROP TABLE IF EXISTS ex_extent_cv_coverage CASCADE;
268DROP TABLE IF EXISTS ex_extent_li_source CASCADE;
269DROP TABLE IF EXISTS ex_extent_tm_referencesystem CASCADE;
270DROP TABLE IF EXISTS ex_geographicboundingbox CASCADE;
271DROP TABLE IF EXISTS ex_geographicdescription CASCADE;
272DROP TABLE IF EXISTS ex_geographicextent CASCADE;
273DROP TABLE IF EXISTS ex_temporalextent CASCADE;
274DROP TABLE IF EXISTS ex_verticalextent CASCADE;
275DROP TABLE IF EXISTS genericname CASCADE;
276DROP TABLE IF EXISTS gf_aggregationtype CASCADE;
277DROP TABLE IF EXISTS gf_associationrole CASCADE;
278DROP TABLE IF EXISTS gf_associationtype CASCADE;
279DROP TABLE IF EXISTS gf_attributetype CASCADE;
280DROP TABLE IF EXISTS gf_attributetype_gf_featuretype CASCADE;
281DROP TABLE IF EXISTS gf_attributetype_md_metadata CASCADE;
282DROP TABLE IF EXISTS gf_attributetype_md_scopedescription CASCADE;
283DROP TABLE IF EXISTS gf_constraint CASCADE;
284DROP TABLE IF EXISTS gf_featuretype CASCADE;
285DROP TABLE IF EXISTS gf_featuretype_gf_associationtype CASCADE;
286DROP TABLE IF EXISTS gf_featuretype_md_metadata CASCADE;
287DROP TABLE IF EXISTS gf_featuretype_md_scopedescription CASCADE;
288DROP TABLE IF EXISTS gfi_domainfeature CASCADE;
289DROP TABLE IF EXISTS gfi_feature CASCADE;
290DROP TABLE IF EXISTS gf_inheritancerelation CASCADE;
291DROP TABLE IF EXISTS gf_locationalattributetype CASCADE;
292DROP TABLE IF EXISTS gf_metadataattributetype CASCADE;
293DROP TABLE IF EXISTS gf_operation CASCADE;
294DROP TABLE IF EXISTS gf_propertytype CASCADE;
295DROP TABLE IF EXISTS gf_spatialassociationtype CASCADE;
296DROP TABLE IF EXISTS gf_spatialattributetype CASCADE;
297DROP TABLE IF EXISTS gf_temporalassociationtype CASCADE;
298DROP TABLE IF EXISTS gf_temporalattributetype CASCADE;
299DROP TABLE IF EXISTS gf_thematicattributetype CASCADE;
300DROP TABLE IF EXISTS gm_affineplacement CASCADE;
301DROP TABLE IF EXISTS gm_aggregate CASCADE;
302DROP TABLE IF EXISTS gm_aggregate_cv_domainobject CASCADE;
303DROP TABLE IF EXISTS gm_aggregate_ex_boundingpolygon CASCADE;
304DROP TABLE IF EXISTS gm_aggregate_gm_aggregate CASCADE;
305DROP TABLE IF EXISTS gm_aggregate_sc_crs CASCADE;
306DROP TABLE IF EXISTS gm_arcstringbybulge CASCADE;
307DROP TABLE IF EXISTS gm_arcstring CASCADE;
308DROP TABLE IF EXISTS gm_boundary CASCADE;
309DROP TABLE IF EXISTS gm_clothoid CASCADE;
310DROP TABLE IF EXISTS gm_complex CASCADE;
311DROP TABLE IF EXISTS gm_complex_cv_domainobject CASCADE;
312DROP TABLE IF EXISTS gm_complex_ex_boundingpolygon CASCADE;
313DROP TABLE IF EXISTS gm_complex_gm_aggregate CASCADE;
314DROP TABLE IF EXISTS gm_complex_gm_complex CASCADE;
315DROP TABLE IF EXISTS gm_complex_gm_primitive CASCADE;
316DROP TABLE IF EXISTS gm_complex_sc_crs CASCADE;
317DROP TABLE IF EXISTS gm_composite CASCADE;
318DROP TABLE IF EXISTS gm_compositecurve CASCADE;
319DROP TABLE IF EXISTS gm_compositecurve_gm_compositecurve CASCADE;
320DROP TABLE IF EXISTS gm_compositepoint CASCADE;
321DROP TABLE IF EXISTS gm_compositesolid CASCADE;
322DROP TABLE IF EXISTS gm_compositesolid_gm_primitive CASCADE;
323DROP TABLE IF EXISTS gm_compositesolid_gm_solid CASCADE;
324DROP TABLE IF EXISTS gm_compositesurface CASCADE;
325DROP TABLE IF EXISTS gm_compositesurface_gm_compositesurface CASCADE;
326DROP TABLE IF EXISTS gm_conic CASCADE;
327DROP TABLE IF EXISTS gm_curve CASCADE;
328DROP TABLE IF EXISTS gm_curvesegment CASCADE;
329DROP TABLE IF EXISTS gm_geodesicstring CASCADE;
330DROP TABLE IF EXISTS gm_knot CASCADE;
331DROP TABLE IF EXISTS gm_linestring CASCADE;
332DROP TABLE IF EXISTS gm_object CASCADE;
333DROP TABLE IF EXISTS gm_offsetcurve CASCADE;
334DROP TABLE IF EXISTS gm_orientablecurve CASCADE;
335DROP TABLE IF EXISTS gm_orientableprimitive CASCADE;
336DROP TABLE IF EXISTS gm_orientablesurface CASCADE;
337DROP TABLE IF EXISTS gm_parametriccurvesurface CASCADE;
338DROP TABLE IF EXISTS gm_pointarray CASCADE;
339DROP TABLE IF EXISTS gm_point CASCADE;
340DROP TABLE IF EXISTS gm_point_cv_gridpoint CASCADE;
341DROP TABLE IF EXISTS gm_point_gm_complex CASCADE;
342DROP TABLE IF EXISTS gm_point_gm_composite CASCADE;
343DROP TABLE IF EXISTS gm_point_gm_primitive CASCADE;
344DROP TABLE IF EXISTS gm_pointref CASCADE;
345DROP TABLE IF EXISTS gm_polygon CASCADE;
346DROP TABLE IF EXISTS gm_polyhedralsurface CASCADE;
347DROP TABLE IF EXISTS gm_position CASCADE;
348DROP TABLE IF EXISTS gm_primitiveboundary CASCADE;
349DROP TABLE IF EXISTS gm_primitive CASCADE;
350DROP TABLE IF EXISTS gm_primitive_cv_domainobject CASCADE;
351DROP TABLE IF EXISTS gm_primitive_ex_boundingpolygon CASCADE;
352DROP TABLE IF EXISTS gm_primitive_gm_aggregate CASCADE;
353DROP TABLE IF EXISTS gm_primitive_sc_crs CASCADE;
354DROP TABLE IF EXISTS gm_ring CASCADE;
355DROP TABLE IF EXISTS gm_solid CASCADE;
356DROP TABLE IF EXISTS gm_solid_gm_complex CASCADE;
357DROP TABLE IF EXISTS gm_solid_gm_composite CASCADE;
358DROP TABLE IF EXISTS gm_solid_gm_compositesolid CASCADE;
359DROP TABLE IF EXISTS gm_solid_gm_primitive CASCADE;
360DROP TABLE IF EXISTS gm_splinecurve CASCADE;
361DROP TABLE IF EXISTS gm_surfaceboundary CASCADE;
362DROP TABLE IF EXISTS gm_surface CASCADE;
363DROP TABLE IF EXISTS gm_surfacepatch CASCADE;
364DROP TABLE IF EXISTS gm_tin CASCADE;
365DROP TABLE IF EXISTS gm_triangle CASCADE;
366DROP TABLE IF EXISTS gm_triangulatedsurface CASCADE;
367DROP TABLE IF EXISTS if_classificationattributetype CASCADE;
368DROP TABLE IF EXISTS io_identifiedobjectbase CASCADE;
369DROP TABLE IF EXISTS io_identifiedobject CASCADE;
370DROP TABLE IF EXISTS juliandate CASCADE;
371DROP TABLE IF EXISTS le_algorithm CASCADE;
372DROP TABLE IF EXISTS length CASCADE;
373DROP TABLE IF EXISTS le_nominalresolution CASCADE;
374DROP TABLE IF EXISTS le_source CASCADE;
375DROP TABLE IF EXISTS li_lineage CASCADE;
376DROP TABLE IF EXISTS li_processstep CASCADE;
377DROP TABLE IF EXISTS li_processstep_li_lineage CASCADE;
378DROP TABLE IF EXISTS li_processstep_li_source CASCADE;
379DROP TABLE IF EXISTS li_source CASCADE;
380DROP TABLE IF EXISTS li_source_li_lineage CASCADE;
381DROP TABLE IF EXISTS li_source_li_processstep CASCADE;
382DROP TABLE IF EXISTS localname CASCADE;
383DROP TABLE IF EXISTS location CASCADE;
384DROP TABLE IF EXISTS md_aggregateinformation CASCADE;
385DROP TABLE IF EXISTS md_applicationschemainformation CASCADE;
386DROP TABLE IF EXISTS md_browsegraphic CASCADE;
387DROP TABLE IF EXISTS md_constraints CASCADE;
388DROP TABLE IF EXISTS md_contentinformation CASCADE;
389DROP TABLE IF EXISTS md_coveragedescription CASCADE;
390DROP TABLE IF EXISTS md_digitaltransferoptions CASCADE;
391DROP TABLE IF EXISTS md_dimension CASCADE;
392DROP TABLE IF EXISTS md_distribution CASCADE;
393DROP TABLE IF EXISTS md_distributor CASCADE;
394DROP TABLE IF EXISTS md_distributor_md_distribution CASCADE;
395DROP TABLE IF EXISTS md_distributor_md_format CASCADE;
396DROP TABLE IF EXISTS md_extendedelementinformation CASCADE;
397DROP TABLE IF EXISTS md_featurecataloguedescription CASCADE;
398DROP TABLE IF EXISTS md_format CASCADE;
399DROP TABLE IF EXISTS md_format_md_distribution CASCADE;
400DROP TABLE IF EXISTS md_format_md_distributor CASCADE;
401DROP TABLE IF EXISTS md_format_md_identification CASCADE;
402DROP TABLE IF EXISTS md_geometricobjects CASCADE;
403DROP TABLE IF EXISTS md_gridspatialrepresentation CASCADE;
404DROP TABLE IF EXISTS md_identification CASCADE;
405DROP TABLE IF EXISTS md_identification_md_metadata CASCADE;
406DROP TABLE IF EXISTS md_identifier CASCADE;
407DROP TABLE IF EXISTS md_imagedescription CASCADE;
408DROP TABLE IF EXISTS md_keywords CASCADE;
409DROP TABLE IF EXISTS md_legalconstraints CASCADE;
410DROP TABLE IF EXISTS md_maintenanceinformation CASCADE;
411DROP TABLE IF EXISTS md_maintenanceinformation_md_identification CASCADE;
412DROP TABLE IF EXISTS md_medium CASCADE;
413DROP TABLE IF EXISTS md_metadata CASCADE;
414DROP TABLE IF EXISTS md_metadata_cl_dataset CASCADE;
415DROP TABLE IF EXISTS md_metadata_ds_aggregate CASCADE;
416DROP TABLE IF EXISTS md_metadata_ds_dataset CASCADE;
417DROP TABLE IF EXISTS md_metadataextensioninformation CASCADE;
418DROP TABLE IF EXISTS md_metadata_gf_attributetype CASCADE;
419DROP TABLE IF EXISTS md_metadata_gf_featuretype CASCADE;
420DROP TABLE IF EXISTS md_metadata_gf_propertytype CASCADE;
421DROP TABLE IF EXISTS md_metadata_mo_observationcollection CASCADE;
422DROP TABLE IF EXISTS md_portrayalcataloguereference CASCADE;
423DROP TABLE IF EXISTS md_rangedimension CASCADE;
424DROP TABLE IF EXISTS md_referencesystem CASCADE;
425DROP TABLE IF EXISTS md_representativefraction CASCADE;
426DROP TABLE IF EXISTS md_scopedescription CASCADE;
427DROP TABLE IF EXISTS md_scopedescription_dq_scope CASCADE;
428DROP TABLE IF EXISTS md_scopedescription_md_maintenanceinformation CASCADE;
429DROP TABLE IF EXISTS md_securityconstraints CASCADE;
430DROP TABLE IF EXISTS md_spatialrepresentation CASCADE;
431DROP TABLE IF EXISTS md_standardorderprocess CASCADE;
432DROP TABLE IF EXISTS md_usage CASCADE;
433DROP TABLE IF EXISTS md_vectorspatialrepresentation CASCADE;
434DROP TABLE IF EXISTS measure CASCADE;
435DROP TABLE IF EXISTS membername CASCADE;
436DROP TABLE IF EXISTS mi_coveragedescription CASCADE;
437DROP TABLE IF EXISTS mi_rangeelementdescription CASCADE;
438DROP TABLE IF EXISTS mo_acquisition CASCADE;
439DROP TABLE IF EXISTS mo_compositeprocess CASCADE;
440DROP TABLE IF EXISTS mo_computation CASCADE;
441DROP TABLE IF EXISTS mo_featureofinterest CASCADE;
442DROP TABLE IF EXISTS mo_inputoutput CASCADE;
443DROP TABLE IF EXISTS mo_instrument CASCADE;
444DROP TABLE IF EXISTS mo_instrument_mo_instrument CASCADE;
445DROP TABLE IF EXISTS mo_instrumentplatformpair CASCADE;
446DROP TABLE IF EXISTS mo_location CASCADE;
447DROP TABLE IF EXISTS mo_observation CASCADE;
448DROP TABLE IF EXISTS mo_observationcollection CASCADE;
449DROP TABLE IF EXISTS mo_observationcollection_mo_observationcollection CASCADE;
450DROP TABLE IF EXISTS mo_observationcollection_mo_project CASCADE;
451DROP TABLE IF EXISTS mo_observation_gfi_feature CASCADE;
452DROP TABLE IF EXISTS mo_observation_mo_observationcollection CASCADE;
453DROP TABLE IF EXISTS mo_observation_om_observation CASCADE;
454DROP TABLE IF EXISTS mo_observation_om_process CASCADE;
455DROP TABLE IF EXISTS mo_observation_sf_samplingfeature CASCADE;
456DROP TABLE IF EXISTS mo_onlineresource CASCADE;
457DROP TABLE IF EXISTS mo_operation CASCADE;
458DROP TABLE IF EXISTS mo_operation_mo_operation CASCADE;
459DROP TABLE IF EXISTS mo_organization CASCADE;
460DROP TABLE IF EXISTS mo_platform CASCADE;
461DROP TABLE IF EXISTS mo_platform_mo_platform CASCADE;
462DROP TABLE IF EXISTS mo_process CASCADE;
463DROP TABLE IF EXISTS mo_processing CASCADE;
464DROP TABLE IF EXISTS mo_project CASCADE;
465DROP TABLE IF EXISTS mo_project_mo_project CASCADE;
466DROP TABLE IF EXISTS mo_responsiblepartyinfo CASCADE;
467DROP TABLE IF EXISTS mo_result CASCADE;
468DROP TABLE IF EXISTS mo_result_mo_result CASCADE;
469DROP TABLE IF EXISTS multiplicity CASCADE;
470DROP TABLE IF EXISTS multiplicityrange CASCADE;
471DROP TABLE IF EXISTS mx_datafile CASCADE;
472DROP TABLE IF EXISTS namedvalue CASCADE;
473DROP TABLE IF EXISTS namespace CASCADE;
474DROP TABLE IF EXISTS obs_coll_migration CASCADE;
475DROP TABLE IF EXISTS observation_migration CASCADE;
476DROP TABLE IF EXISTS om_categoryobservation CASCADE;
477DROP TABLE IF EXISTS om_complexobservation CASCADE;
478DROP TABLE IF EXISTS om_countobservation CASCADE;
479DROP TABLE IF EXISTS om_discretecoverageobservation CASCADE;
480DROP TABLE IF EXISTS om_geometryobservation CASCADE;
481DROP TABLE IF EXISTS om_measurement CASCADE;
482DROP TABLE IF EXISTS om_observation CASCADE;
483DROP TABLE IF EXISTS om_process CASCADE;
484DROP TABLE IF EXISTS om_process_sf_spatialsamplingfeature CASCADE;
485DROP TABLE IF EXISTS om_temporalobservation CASCADE;
486DROP TABLE IF EXISTS om_truthobservation CASCADE;
487DROP TABLE IF EXISTS qe_coverageresult CASCADE;
488DROP TABLE IF EXISTS qe_usability CASCADE;
489DROP TABLE IF EXISTS record CASCADE;
490DROP TABLE IF EXISTS recordtype CASCADE;
491DROP TABLE IF EXISTS rs_identifier CASCADE;
492DROP TABLE IF EXISTS rs_referencesystem CASCADE;
493DROP TABLE IF EXISTS scale CASCADE;
494DROP TABLE IF EXISTS sc_compoundcrs CASCADE;
495DROP TABLE IF EXISTS sc_crs CASCADE;
496DROP TABLE IF EXISTS sc_derivedcrs CASCADE;
497DROP TABLE IF EXISTS sc_engineeringcrs CASCADE;
498DROP TABLE IF EXISTS sc_generalderivedcrs CASCADE;
499DROP TABLE IF EXISTS sc_geodeticcrs CASCADE;
500DROP TABLE IF EXISTS schema CASCADE;
501DROP TABLE IF EXISTS sc_imagecrs CASCADE;
502DROP TABLE IF EXISTS scopedname CASCADE;
503DROP TABLE IF EXISTS sc_projectedcrs CASCADE;
504DROP TABLE IF EXISTS sc_singlecrs CASCADE;
505DROP TABLE IF EXISTS sc_verticalcrs CASCADE;
506DROP TABLE IF EXISTS sf_process CASCADE;
507DROP TABLE IF EXISTS sf_samplingfeature CASCADE;
508DROP TABLE IF EXISTS sf_samplingfeature_sf_samplingfeature CASCADE;
509DROP TABLE IF EXISTS sf_spatialsamplingfeature CASCADE;
510DROP TABLE IF EXISTS sf_spatialsamplingfeature_sf_samplingfeature CASCADE;
511DROP TABLE IF EXISTS sf_specimen CASCADE;
512DROP TABLE IF EXISTS time CASCADE;
513DROP TABLE IF EXISTS tm_caldate CASCADE;
514DROP TABLE IF EXISTS tm_calendar CASCADE;
515DROP TABLE IF EXISTS tm_calendarera CASCADE;
516DROP TABLE IF EXISTS tm_calendarera_tm_calendar CASCADE;
517DROP TABLE IF EXISTS tm_calendar_tm_calendarera CASCADE;
518DROP TABLE IF EXISTS tm_calendar_tm_clock CASCADE;
519DROP TABLE IF EXISTS tm_clock CASCADE;
520DROP TABLE IF EXISTS tm_clocktime CASCADE;
521DROP TABLE IF EXISTS tm_complex CASCADE;
522DROP TABLE IF EXISTS tm_coordinate CASCADE;
523DROP TABLE IF EXISTS tm_coordinatesystem CASCADE;
524DROP TABLE IF EXISTS tm_duration CASCADE;
525DROP TABLE IF EXISTS tm_edge CASCADE;
526DROP TABLE IF EXISTS tm_geometricprimitive CASCADE;
527DROP TABLE IF EXISTS tm_instant CASCADE;
528DROP TABLE IF EXISTS tm_node CASCADE;
529DROP TABLE IF EXISTS tm_object CASCADE;
530DROP TABLE IF EXISTS tm_ordinalera CASCADE;
531DROP TABLE IF EXISTS tm_ordinalera_tm_ordinalera CASCADE;
532DROP TABLE IF EXISTS tm_ordinalposition CASCADE;
533DROP TABLE IF EXISTS tm_ordinalreferencesystem CASCADE;
534DROP TABLE IF EXISTS tm_period CASCADE;
535DROP TABLE IF EXISTS tm_periodduration CASCADE;
536DROP TABLE IF EXISTS tm_position CASCADE;
537DROP TABLE IF EXISTS tm_primitive CASCADE;
538DROP TABLE IF EXISTS tm_referencesystem CASCADE;
539DROP TABLE IF EXISTS tm_temporalcrs CASCADE;
540DROP TABLE IF EXISTS tm_temporalposition CASCADE;
541DROP TABLE IF EXISTS tm_topologicalcomplex CASCADE;
542DROP TABLE IF EXISTS tm_topologicalprimitive CASCADE;
543DROP TABLE IF EXISTS tp_boundary CASCADE;
544DROP TABLE IF EXISTS tp_complex CASCADE;
545DROP TABLE IF EXISTS tp_complex_tp_complex CASCADE;
546DROP TABLE IF EXISTS tp_complex_tp_primitive CASCADE;
547DROP TABLE IF EXISTS tp_directededge CASCADE;
548DROP TABLE IF EXISTS tp_directededge_tp_face CASCADE;
549DROP TABLE IF EXISTS tp_directededge_tp_node CASCADE;
550DROP TABLE IF EXISTS tp_directedface CASCADE;
551DROP TABLE IF EXISTS tp_directedface_tp_edge CASCADE;
552DROP TABLE IF EXISTS tp_directedface_tp_solid CASCADE;
553DROP TABLE IF EXISTS tp_directednode CASCADE;
554DROP TABLE IF EXISTS tp_directedsolid CASCADE;
555DROP TABLE IF EXISTS tp_directedsolid_tp_face CASCADE;
556DROP TABLE IF EXISTS tp_directedtopo CASCADE;
557DROP TABLE IF EXISTS tp_edge CASCADE;
558DROP TABLE IF EXISTS tp_edge_gm_primitive CASCADE;
559DROP TABLE IF EXISTS tp_edge_tp_complex CASCADE;
560DROP TABLE IF EXISTS tp_edge_tp_directedface CASCADE;
561DROP TABLE IF EXISTS tp_edge_tp_directednode CASCADE;
562DROP TABLE IF EXISTS tp_edge_tp_primitive CASCADE;
563DROP TABLE IF EXISTS tp_expression CASCADE;
564DROP TABLE IF EXISTS tp_expressionterm CASCADE;
565DROP TABLE IF EXISTS tp_face CASCADE;
566DROP TABLE IF EXISTS tp_face_gm_primitive CASCADE;
567DROP TABLE IF EXISTS tp_face_tp_complex CASCADE;
568DROP TABLE IF EXISTS tp_face_tp_directededge CASCADE;
569DROP TABLE IF EXISTS tp_face_tp_directedsolid CASCADE;
570DROP TABLE IF EXISTS tp_face_tp_primitive CASCADE;
571DROP TABLE IF EXISTS tp_node CASCADE;
572DROP TABLE IF EXISTS tp_node_gm_primitive CASCADE;
573DROP TABLE IF EXISTS tp_node_tp_complex CASCADE;
574DROP TABLE IF EXISTS tp_node_tp_primitive CASCADE;
575DROP TABLE IF EXISTS tp_primitive CASCADE;
576DROP TABLE IF EXISTS tp_ring CASCADE;
577DROP TABLE IF EXISTS tp_shell CASCADE;
578DROP TABLE IF EXISTS tp_solid CASCADE;
579DROP TABLE IF EXISTS tp_solid_gm_primitive CASCADE;
580DROP TABLE IF EXISTS tp_solid_tp_complex CASCADE;
581DROP TABLE IF EXISTS tp_solid_tp_directedface CASCADE;
582DROP TABLE IF EXISTS tp_solid_tp_primitive CASCADE;
583DROP TABLE IF EXISTS type CASCADE;
584DROP TABLE IF EXISTS typename CASCADE;
585DROP TABLE IF EXISTS unitofmeasure CASCADE;
586DROP TABLE IF EXISTS unlimitedinteger CASCADE;
587DROP TABLE IF EXISTS uomangle CASCADE;
588DROP TABLE IF EXISTS uomlength CASCADE;
589DROP TABLE IF EXISTS uomscale CASCADE;
590DROP TABLE IF EXISTS url CASCADE;
591DROP TABLE IF EXISTS cv_solidvaluepair_cv_discretecoverage CASCADE;
592DROP TABLE IF EXISTS geometries CASCADE;
593DROP TABLE IF EXISTS geometry_columns CASCADE;
594DROP TABLE IF EXISTS spatial_ref_sys CASCADE;
595DROP TABLE IF EXISTS ad_abstractaddress CASCADE;
596DROP TABLE IF EXISTS arcbycenterpoint CASCADE;
597DROP TABLE IF EXISTS cell CASCADE;
598DROP TABLE IF EXISTS cell_cellularcomplex CASCADE;
599DROP TABLE IF EXISTS cell_gm_complex CASCADE;
600DROP TABLE IF EXISTS cell_gm_composite CASCADE;
601DROP TABLE IF EXISTS cell_gm_primitive CASCADE;
602DROP TABLE IF EXISTS cell_tp_complex CASCADE;
603DROP TABLE IF EXISTS cell_tp_primitive CASCADE;
604DROP TABLE IF EXISTS cellularcomplex CASCADE;
605DROP TABLE IF EXISTS cellularcomplex_cell CASCADE;
606DROP TABLE IF EXISTS cellularcomplex_gm_complex CASCADE;
607DROP TABLE IF EXISTS cellularcomplex_gm_primitive CASCADE;
608DROP TABLE IF EXISTS cellularcomplex_tp_complex CASCADE;
609DROP TABLE IF EXISTS cellularcomplex_tp_primitive CASCADE;
610DROP TABLE IF EXISTS eg_pointestimate CASCADE;
611DROP TABLE IF EXISTS ex_extent_mo_responsiblepartyinfo CASCADE;
612DROP TABLE IF EXISTS fd_feature CASCADE;
613DROP TABLE IF EXISTS fd_featurecollection CASCADE;
614DROP TABLE IF EXISTS fd_featurecollection_fd_feature CASCADE;
615DROP TABLE IF EXISTS fd_feature_fd_featurecollection CASCADE;
616DROP TABLE IF EXISTS fd_featurename CASCADE;
617DROP TABLE IF EXISTS fd_feature_ns_avoidlist CASCADE;
618DROP TABLE IF EXISTS gf_featuretype_ns_avoidlist CASCADE;
619DROP TABLE IF EXISTS gm_composite_gm_complex CASCADE;
620DROP TABLE IF EXISTS gm_composite_gm_primitive CASCADE;
621DROP TABLE IF EXISTS lr_element CASCADE;
622DROP TABLE IF EXISTS lr_feature CASCADE;
623DROP TABLE IF EXISTS lr_linearreferencemethod CASCADE;
624DROP TABLE IF EXISTS lr_offsetexpression CASCADE;
625DROP TABLE IF EXISTS lr_positionexpression CASCADE;
626DROP TABLE IF EXISTS lr_referencemarker CASCADE;
627DROP TABLE IF EXISTS mo_acquisition_mo_compositeprocess CASCADE;
628DROP TABLE IF EXISTS mo_citation CASCADE;
629DROP TABLE IF EXISTS mo_individual CASCADE;
630DROP TABLE IF EXISTS mo_instrument_mo_acquisition CASCADE;
631DROP TABLE IF EXISTS mo_operation_mo_acquisition CASCADE;
632DROP TABLE IF EXISTS mo_organisation CASCADE;
633DROP TABLE IF EXISTS mo_organisation_mo_responsiblepartyinfo CASCADE;
634DROP TABLE IF EXISTS mo_party CASCADE;
635DROP TABLE IF EXISTS mo_platform_mo_acquisition CASCADE;
636DROP TABLE IF EXISTS mo_platform_mo_operation CASCADE;
637DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_acquisition CASCADE;
638DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_compositeprocess CASCADE;
639DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_instrument CASCADE;
640DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_observation CASCADE;
641DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_operation CASCADE;
642DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_organisation CASCADE;
643DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_platform CASCADE;
644DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_processing CASCADE;
645DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_project CASCADE;
646DROP TABLE IF EXISTS nl_composite CASCADE;
647DROP TABLE IF EXISTS nl_compositecurve CASCADE;
648DROP TABLE IF EXISTS nl_compositecurve_nl_compositecurve CASCADE;
649DROP TABLE IF EXISTS nl_compositepoint CASCADE;
650DROP TABLE IF EXISTS nl_compsitesurface CASCADE;
651DROP TABLE IF EXISTS nl_compsitesurface_nl_compsitesurface CASCADE;
652DROP TABLE IF EXISTS nl_curve CASCADE;
653DROP TABLE IF EXISTS nl_curvesegment CASCADE;
654DROP TABLE IF EXISTS nl_map CASCADE;
655DROP TABLE IF EXISTS nl_orientablecurve CASCADE;
656DROP TABLE IF EXISTS nl_orientablesurface CASCADE;
657DROP TABLE IF EXISTS nl_point CASCADE;
658DROP TABLE IF EXISTS nl_primitve CASCADE;
659DROP TABLE IF EXISTS nl_ring CASCADE;
660DROP TABLE IF EXISTS nl_surfaceboundary CASCADE;
661DROP TABLE IF EXISTS nl_surface CASCADE;
662DROP TABLE IF EXISTS nl_surfacepatch CASCADE;
663DROP TABLE IF EXISTS ns_avoidlist CASCADE;
664DROP TABLE IF EXISTS ns_costedlink CASCADE;
665DROP TABLE IF EXISTS ns_costedturn CASCADE;
666DROP TABLE IF EXISTS ns_costfunction CASCADE;
667DROP TABLE IF EXISTS ns_costfunction_ns_routerequest CASCADE;
668DROP TABLE IF EXISTS ns_routerequest CASCADE;
669DROP TABLE IF EXISTS ns_routerequest_ns_costfunction CASCADE;
670DROP TABLE IF EXISTS nt_advisory CASCADE;
671DROP TABLE IF EXISTS nt_advisorydirection CASCADE;
672DROP TABLE IF EXISTS nt_advisorydistance CASCADE;
673DROP TABLE IF EXISTS nt_advisoryelement CASCADE;
674DROP TABLE IF EXISTS nt_advisoryspatialrelation CASCADE;
675DROP TABLE IF EXISTS nt_combinednetwork CASCADE;
676DROP TABLE IF EXISTS nt_combinednetwork_nt_combinednetwork CASCADE;
677DROP TABLE IF EXISTS nt_constraint CASCADE;
678DROP TABLE IF EXISTS nt_exitassociation CASCADE;
679DROP TABLE IF EXISTS nt_junction CASCADE;
680DROP TABLE IF EXISTS nt_junction_nt_network CASCADE;
681DROP TABLE IF EXISTS nt_junction_nt_transfernode CASCADE;
682DROP TABLE IF EXISTS nt_laneconstraint CASCADE;
683DROP TABLE IF EXISTS nt_link CASCADE;
684DROP TABLE IF EXISTS nt_link_lr_linearreferencemethod CASCADE;
685DROP TABLE IF EXISTS nt_link_nt_junction CASCADE;
686DROP TABLE IF EXISTS nt_link_nt_maneuver CASCADE;
687DROP TABLE IF EXISTS nt_link_nt_network CASCADE;
688DROP TABLE IF EXISTS nt_linkposition CASCADE;
689DROP TABLE IF EXISTS nt_link_tp_face CASCADE;
690DROP TABLE IF EXISTS nt_link_tp_node CASCADE;
691DROP TABLE IF EXISTS nt_maneuver CASCADE;
692DROP TABLE IF EXISTS nt_maneuver_nt_link CASCADE;
693DROP TABLE IF EXISTS nt_maneuver_nt_route CASCADE;
694DROP TABLE IF EXISTS nt_maneuver_nt_turn CASCADE;
695DROP TABLE IF EXISTS nt_network CASCADE;
696DROP TABLE IF EXISTS nt_networkposition CASCADE;
697DROP TABLE IF EXISTS nt_network_tp_complex CASCADE;
698DROP TABLE IF EXISTS nt_network_tp_primitive CASCADE;
699DROP TABLE IF EXISTS nt_route CASCADE;
700DROP TABLE IF EXISTS nt_route_nt_combinednetwork CASCADE;
701DROP TABLE IF EXISTS nt_routesummary CASCADE;
702DROP TABLE IF EXISTS nt_temporalconstraint CASCADE;
703DROP TABLE IF EXISTS nt_transfer CASCADE;
704DROP TABLE IF EXISTS nt_transferlink CASCADE;
705DROP TABLE IF EXISTS nt_transfernode CASCADE;
706DROP TABLE IF EXISTS nt_transfernode_nt_combinednetwork CASCADE;
707DROP TABLE IF EXISTS nt_turn CASCADE;
708DROP TABLE IF EXISTS nt_turn_nt_junction CASCADE;
709DROP TABLE IF EXISTS nt_turn_nt_link CASCADE;
710DROP TABLE IF EXISTS nt_turn_nt_maneuver CASCADE;
711DROP TABLE IF EXISTS nt_turn_nt_network CASCADE;
712DROP TABLE IF EXISTS nt_vehicleconstraint CASCADE;
713DROP TABLE IF EXISTS nt_waypoint CASCADE;
714DROP TABLE IF EXISTS nt_waypointlist CASCADE;
715DROP TABLE IF EXISTS polygon CASCADE;
716DROP TABLE IF EXISTS rectangle CASCADE;
717DROP TABLE IF EXISTS si_gazetteer CASCADE;
718DROP TABLE IF EXISTS si_gazetteer_si_locationinstance CASCADE;
719DROP TABLE IF EXISTS si_locationinstance CASCADE;
720DROP TABLE IF EXISTS si_locationinstance_si_gazetteer CASCADE;
721DROP TABLE IF EXISTS si_locationinstance_si_locationinstance CASCADE;
722DROP TABLE IF EXISTS si_locationtype CASCADE;
723DROP TABLE IF EXISTS si_locationtype_si_gazetteer CASCADE;
724DROP TABLE IF EXISTS si_locationtype_si_locationtype CASCADE;
725DROP TABLE IF EXISTS si_locationtype_si_spatialreferencesystemusinggeographicidenti CASCADE;
726DROP TABLE IF EXISTS simplex CASCADE;
727DROP TABLE IF EXISTS simplex_gm_complex CASCADE;
728DROP TABLE IF EXISTS simplex_gm_composite CASCADE;
729DROP TABLE IF EXISTS simplex_gm_primitive CASCADE;
730DROP TABLE IF EXISTS simplex_simplicialcomplex CASCADE;
731DROP TABLE IF EXISTS simplex_tp_complex CASCADE;
732DROP TABLE IF EXISTS simplex_tp_primitive CASCADE;
733DROP TABLE IF EXISTS simplicialcomplex CASCADE;
734DROP TABLE IF EXISTS simplicialcomplex_simplex CASCADE;
735DROP TABLE IF EXISTS si_spatialreferencesystemusinggeographicidentifiers CASCADE;
736DROP TABLE IF EXISTS si_spatialreferencesystemusinggeographicidentifiers_si_locatio CASCADE;
737DROP TABLE IF EXISTS taxonomicclassification CASCADE;
738DROP TABLE IF EXISTS taxonomysystem CASCADE;
739DROP TABLE IF EXISTS temporalcrs CASCADE;
740DROP TABLE IF EXISTS temporaldatum CASCADE;
741DROP TABLE IF EXISTS timecs CASCADE;
742DROP TABLE IF EXISTS tk_position CASCADE;
743DROP TABLE IF EXISTS tm_intervallength CASCADE;
744DROP TABLE IF EXISTS topocurve CASCADE;
745DROP TABLE IF EXISTS topopoint CASCADE;
746DROP TABLE IF EXISTS toposurface CASCADE;
747DROP TABLE IF EXISTS topovolume CASCADE;
748DROP TABLE IF EXISTS tp_edge_tp_face CASCADE;
749DROP TABLE IF EXISTS tp_edge_tp_node CASCADE;
750DROP TABLE IF EXISTS uomweight CASCADE;
751DROP TABLE IF EXISTS vouchers CASCADE;
752DROP TABLE IF EXISTS weight CASCADE;
753
754
755
756DROP TABLE IF EXISTS ceda_guid CASCADE;
757UPDATE data_entity_migration
758        set ceda_observation_coll_id = NULL, doc_hash = NULL;
759
760UPDATE deployments_migration
761        set ceda_observation_id = NULL, doc_hash = NULL;
762       
763UPDATE deployment_data_migration
764        set ceda_processing_id = NULL, ceda_instrument_id = NULL,
765        ceda_compositeprocess_id = NULL, ceda_acquisition_id = NULL,
766        ceda_project_id = NULL, doc_hash = NULL;
767--DROP TABLE IF EXISTS data_entity_migration CASCADE;
768--DROP TABLE IF EXISTS deployments_migration CASCADE;
769--DROP TABLE IF EXISTS deployment_data_migration CASCADE;
770
771DROP SEQUENCE IF EXISTS angle_id_seq CASCADE;
772DROP SEQUENCE IF EXISTS any_id_seq CASCADE;
773DROP SEQUENCE IF EXISTS cc_concatenatedoperation_id_seq CASCADE;
774DROP SEQUENCE IF EXISTS cc_conversion_id_seq CASCADE;
775DROP SEQUENCE IF EXISTS cc_coordinateoperation_id_seq CASCADE;
776DROP SEQUENCE IF EXISTS cc_formula_id_seq CASCADE;
777DROP SEQUENCE IF EXISTS cc_generaloperationparameter_id_seq CASCADE;
778DROP SEQUENCE IF EXISTS cc_generalparametervalue_id_seq CASCADE;
779DROP SEQUENCE IF EXISTS cc_operationmethod_id_seq CASCADE;
780DROP SEQUENCE IF EXISTS cc_operationparametergroup_id_seq CASCADE;
781DROP SEQUENCE IF EXISTS cc_operationparameter_id_seq CASCADE;
782DROP SEQUENCE IF EXISTS cc_operationparametervalue_id_seq CASCADE;
783DROP SEQUENCE IF EXISTS cc_parametervaluegroup_id_seq CASCADE;
784DROP SEQUENCE IF EXISTS cc_parametervalue_id_seq CASCADE;
785DROP SEQUENCE IF EXISTS cc_passthroughoperation_id_seq CASCADE;
786DROP SEQUENCE IF EXISTS cc_singleoperation_id_seq CASCADE;
787DROP SEQUENCE IF EXISTS cc_transformation_id_seq CASCADE;
788DROP SEQUENCE IF EXISTS cd_datum_id_seq CASCADE;
789DROP SEQUENCE IF EXISTS cd_ellipsoid_id_seq CASCADE;
790DROP SEQUENCE IF EXISTS cd_engineeringdatum_id_seq CASCADE;
791DROP SEQUENCE IF EXISTS cd_geodeticdatum_id_seq CASCADE;
792DROP SEQUENCE IF EXISTS cd_imagedatum_id_seq CASCADE;
793DROP SEQUENCE IF EXISTS cd_primemeridian_id_seq CASCADE;
794DROP SEQUENCE IF EXISTS cd_seconddefiningparameter_id_seq CASCADE;
795DROP SEQUENCE IF EXISTS cd_verticaldatum_id_seq CASCADE;
796DROP SEQUENCE IF EXISTS ceda_acquisition_id_seq CASCADE;
797DROP SEQUENCE IF EXISTS ceda_citation_id_seq CASCADE;
798DROP SEQUENCE IF EXISTS ceda_compositeprocess_id_seq CASCADE;
799DROP SEQUENCE IF EXISTS ceda_instrument_id_seq CASCADE;
800DROP SEQUENCE IF EXISTS ceda_notes_id_seq CASCADE;
801DROP SEQUENCE IF EXISTS ceda_observationcollection_id_seq CASCADE;
802DROP SEQUENCE IF EXISTS ceda_observation_id_seq CASCADE;
803DROP SEQUENCE IF EXISTS ceda_operation_id_seq CASCADE;
804DROP SEQUENCE IF EXISTS ceda_platform_id_seq CASCADE;
805DROP SEQUENCE IF EXISTS ceda_process_id_seq CASCADE;
806DROP SEQUENCE IF EXISTS ceda_processing_id_seq CASCADE;
807DROP SEQUENCE IF EXISTS ceda_project_id_seq CASCADE;
808DROP SEQUENCE IF EXISTS ceda_result_id_seq CASCADE;
809DROP SEQUENCE IF EXISTS ceda_review_id_seq CASCADE;
810DROP SEQUENCE IF EXISTS ci_address_id_seq CASCADE;
811DROP SEQUENCE IF EXISTS ci_citation_id_seq CASCADE;
812DROP SEQUENCE IF EXISTS ci_contact_id_seq CASCADE;
813DROP SEQUENCE IF EXISTS ci_date_id_seq CASCADE;
814DROP SEQUENCE IF EXISTS ci_individual_id_seq CASCADE;
815DROP SEQUENCE IF EXISTS ci_onlineresource_id_seq CASCADE;
816DROP SEQUENCE IF EXISTS ci_organisation_id_seq CASCADE;
817DROP SEQUENCE IF EXISTS ci_party_id_seq CASCADE;
818DROP SEQUENCE IF EXISTS ci_responsibility_id_seq CASCADE;
819DROP SEQUENCE IF EXISTS ci_responsibleparty_id_seq CASCADE;
820DROP SEQUENCE IF EXISTS ci_responsiblepartyinfo_id_seq CASCADE;
821DROP SEQUENCE IF EXISTS ci_series_id_seq CASCADE;
822DROP SEQUENCE IF EXISTS ci_telephone_id_seq CASCADE;
823DROP SEQUENCE IF EXISTS class01_id_seq CASCADE;
824DROP SEQUENCE IF EXISTS class02_id_seq CASCADE;
825DROP SEQUENCE IF EXISTS class03_1_id_seq CASCADE;
826DROP SEQUENCE IF EXISTS class03_2_id_seq CASCADE;
827DROP SEQUENCE IF EXISTS class04_1_id_seq CASCADE;
828DROP SEQUENCE IF EXISTS class04_2_id_seq CASCADE;
829DROP SEQUENCE IF EXISTS class05_1_id_seq CASCADE;
830DROP SEQUENCE IF EXISTS class05_2_id_seq CASCADE;
831DROP SEQUENCE IF EXISTS class06_1_id_seq CASCADE;
832DROP SEQUENCE IF EXISTS class06_2_id_seq CASCADE;
833DROP SEQUENCE IF EXISTS class07_1_id_seq CASCADE;
834DROP SEQUENCE IF EXISTS class07_2_id_seq CASCADE;
835DROP SEQUENCE IF EXISTS class07_3_id_seq CASCADE;
836DROP SEQUENCE IF EXISTS class08_1_id_seq CASCADE;
837DROP SEQUENCE IF EXISTS class08_2_id_seq CASCADE;
838DROP SEQUENCE IF EXISTS class08_3_id_seq CASCADE;
839DROP SEQUENCE IF EXISTS class08_4_id_seq CASCADE;
840DROP SEQUENCE IF EXISTS class09_1_id_seq CASCADE;
841DROP SEQUENCE IF EXISTS class09_2_id_seq CASCADE;
842DROP SEQUENCE IF EXISTS class09_3_id_seq CASCADE;
843DROP SEQUENCE IF EXISTS class09_4_id_seq CASCADE;
844DROP SEQUENCE IF EXISTS class10_1_id_seq CASCADE;
845DROP SEQUENCE IF EXISTS class12_1_id_seq CASCADE;
846DROP SEQUENCE IF EXISTS class12_2_id_seq CASCADE;
847DROP SEQUENCE IF EXISTS class12_3_id_seq CASCADE;
848DROP SEQUENCE IF EXISTS class12_4_id_seq CASCADE;
849DROP SEQUENCE IF EXISTS cl_classificationcollection_id_seq CASCADE;
850DROP SEQUENCE IF EXISTS cl_dataset_id_seq CASCADE;
851DROP SEQUENCE IF EXISTS clocktime_id_seq CASCADE;
852DROP SEQUENCE IF EXISTS cs_affinecs_id_seq CASCADE;
853DROP SEQUENCE IF EXISTS cs_cartesiancs_id_seq CASCADE;
854DROP SEQUENCE IF EXISTS cs_coordinatesystemaxis_id_seq CASCADE;
855DROP SEQUENCE IF EXISTS cs_coordinatesystem_id_seq CASCADE;
856DROP SEQUENCE IF EXISTS cs_cylindricalcs_id_seq CASCADE;
857DROP SEQUENCE IF EXISTS cs_ellipsoidalcs_id_seq CASCADE;
858DROP SEQUENCE IF EXISTS cs_engineeringcs_id_seq CASCADE;
859DROP SEQUENCE IF EXISTS cs_geodeticcs_id_seq CASCADE;
860DROP SEQUENCE IF EXISTS cs_imagecs_id_seq CASCADE;
861DROP SEQUENCE IF EXISTS cs_linearcs_id_seq CASCADE;
862DROP SEQUENCE IF EXISTS cs_polarcs_id_seq CASCADE;
863DROP SEQUENCE IF EXISTS cs_sphericalcs_id_seq CASCADE;
864DROP SEQUENCE IF EXISTS cs_userdefinedcs_id_seq CASCADE;
865DROP SEQUENCE IF EXISTS cs_verticalcs_id_seq CASCADE;
866DROP SEQUENCE IF EXISTS cv_attributevalues_id_seq CASCADE;
867DROP SEQUENCE IF EXISTS cv_continuouscoverage_id_seq CASCADE;
868DROP SEQUENCE IF EXISTS cv_continuousquadrilateralgridcoverage_id_seq CASCADE;
869DROP SEQUENCE IF EXISTS cv_coverage_id_seq CASCADE;
870DROP SEQUENCE IF EXISTS cv_curvevaluepair_id_seq CASCADE;
871DROP SEQUENCE IF EXISTS cv_discretecoverage_id_seq CASCADE;
872DROP SEQUENCE IF EXISTS cv_discretecurvecoverage_id_seq CASCADE;
873DROP SEQUENCE IF EXISTS cv_discretegridpointcoverage_id_seq CASCADE;
874DROP SEQUENCE IF EXISTS cv_discretepointcoverage_id_seq CASCADE;
875DROP SEQUENCE IF EXISTS cv_discretesolidcoverage_id_seq CASCADE;
876DROP SEQUENCE IF EXISTS cv_discretesurfacecoverage_id_seq CASCADE;
877DROP SEQUENCE IF EXISTS cv_domainobject_id_seq CASCADE;
878DROP SEQUENCE IF EXISTS cv_footprint_id_seq CASCADE;
879DROP SEQUENCE IF EXISTS cv_geometryvaluepair_id_seq CASCADE;
880DROP SEQUENCE IF EXISTS cv_gridcell_id_seq CASCADE;
881DROP SEQUENCE IF EXISTS cv_gridcoordinate_id_seq CASCADE;
882DROP SEQUENCE IF EXISTS cv_gridenvelope_id_seq CASCADE;
883DROP SEQUENCE IF EXISTS cv_grid_id_seq CASCADE;
884DROP SEQUENCE IF EXISTS cv_gridpoint_id_seq CASCADE;
885DROP SEQUENCE IF EXISTS cv_gridpointvaluepair_id_seq CASCADE;
886DROP SEQUENCE IF EXISTS cv_gridvaluecell_id_seq CASCADE;
887DROP SEQUENCE IF EXISTS cv_gridvaluesmatrix_id_seq CASCADE;
888DROP SEQUENCE IF EXISTS cv_hexagonalgridcoverage_id_seq CASCADE;
889DROP SEQUENCE IF EXISTS cv_pointvaluepair_id_seq CASCADE;
890DROP SEQUENCE IF EXISTS cv_rectifiedgrid_id_seq CASCADE;
891DROP SEQUENCE IF EXISTS cv_referenceablegrid_id_seq CASCADE;
892DROP SEQUENCE IF EXISTS cv_segmentedcurvecoverage_id_seq CASCADE;
893DROP SEQUENCE IF EXISTS cv_sequencerule_id_seq CASCADE;
894DROP SEQUENCE IF EXISTS cv_solidvaluepair_id_seq CASCADE;
895DROP SEQUENCE IF EXISTS cv_surfacevaluepair_id_seq CASCADE;
896DROP SEQUENCE IF EXISTS cvt_discretetimeinstantcoverage_id_seq CASCADE;
897DROP SEQUENCE IF EXISTS cv_thiessenpolygoncoverage_id_seq CASCADE;
898DROP SEQUENCE IF EXISTS cv_thiessenvaluepolygon_id_seq CASCADE;
899DROP SEQUENCE IF EXISTS cv_tincoverage_id_seq CASCADE;
900DROP SEQUENCE IF EXISTS cvt_timeinstantvaluepair_id_seq CASCADE;
901DROP SEQUENCE IF EXISTS cv_valuecurve_id_seq CASCADE;
902DROP SEQUENCE IF EXISTS cv_valuehexagon_id_seq CASCADE;
903DROP SEQUENCE IF EXISTS cv_valueobject_id_seq CASCADE;
904DROP SEQUENCE IF EXISTS cv_valuesegment_id_seq CASCADE;
905DROP SEQUENCE IF EXISTS cv_valuetriangle_id_seq CASCADE;
906DROP SEQUENCE IF EXISTS date_id_seq CASCADE;
907DROP SEQUENCE IF EXISTS dateprecision_id_seq CASCADE;
908DROP SEQUENCE IF EXISTS datetime_id_seq CASCADE;
909DROP SEQUENCE IF EXISTS decimal_id_seq CASCADE;
910DROP SEQUENCE IF EXISTS directposition_id_seq CASCADE;
911DROP SEQUENCE IF EXISTS distance_id_seq CASCADE;
912DROP SEQUENCE IF EXISTS dq_absoluteexternalpositionalaccuracy_id_seq CASCADE;
913DROP SEQUENCE IF EXISTS dq_completeness_id_seq CASCADE;
914DROP SEQUENCE IF EXISTS dq_conformanceresult_id_seq CASCADE;
915DROP SEQUENCE IF EXISTS dq_dataquality_id_seq CASCADE;
916DROP SEQUENCE IF EXISTS dq_element_id_seq CASCADE;
917DROP SEQUENCE IF EXISTS dq_griddeddatapositionalaccuracy_id_seq CASCADE;
918DROP SEQUENCE IF EXISTS dq_logicalconsistency_id_seq CASCADE;
919DROP SEQUENCE IF EXISTS dq_positionalaccuracy_id_seq CASCADE;
920DROP SEQUENCE IF EXISTS dq_quantitativeresult_id_seq CASCADE;
921DROP SEQUENCE IF EXISTS dq_relativeinternalpositionalaccuracy_id_seq CASCADE;
922DROP SEQUENCE IF EXISTS dq_result_id_seq CASCADE;
923DROP SEQUENCE IF EXISTS dq_scope_id_seq CASCADE;
924DROP SEQUENCE IF EXISTS dq_temporalaccuracy_id_seq CASCADE;
925DROP SEQUENCE IF EXISTS dq_thematicaccuracy_id_seq CASCADE;
926DROP SEQUENCE IF EXISTS ds_aggregate_id_seq CASCADE;
927DROP SEQUENCE IF EXISTS ds_dataset_id_seq CASCADE;
928DROP SEQUENCE IF EXISTS ds_initiative_id_seq CASCADE;
929DROP SEQUENCE IF EXISTS ds_otheraggregate_id_seq CASCADE;
930DROP SEQUENCE IF EXISTS ds_series_id_seq CASCADE;
931DROP SEQUENCE IF EXISTS earootclass_id_seq CASCADE;
932DROP SEQUENCE IF EXISTS ex_boundingpolygon_id_seq CASCADE;
933DROP SEQUENCE IF EXISTS ex_extent_id_seq CASCADE;
934DROP SEQUENCE IF EXISTS ex_geographicboundingbox_id_seq CASCADE;
935DROP SEQUENCE IF EXISTS ex_geographicdescription_id_seq CASCADE;
936DROP SEQUENCE IF EXISTS ex_geographicextent_id_seq CASCADE;
937DROP SEQUENCE IF EXISTS ex_temporalextent_id_seq CASCADE;
938DROP SEQUENCE IF EXISTS ex_verticalextent_id_seq CASCADE;
939DROP SEQUENCE IF EXISTS genericname_id_seq CASCADE;
940DROP SEQUENCE IF EXISTS gf_aggregationtype_id_seq CASCADE;
941DROP SEQUENCE IF EXISTS gf_associationrole_id_seq CASCADE;
942DROP SEQUENCE IF EXISTS gf_associationtype_id_seq CASCADE;
943DROP SEQUENCE IF EXISTS gf_attributetype_id_seq CASCADE;
944DROP SEQUENCE IF EXISTS gf_constraint_id_seq CASCADE;
945DROP SEQUENCE IF EXISTS gf_featuretype_id_seq CASCADE;
946DROP SEQUENCE IF EXISTS gfi_domainfeature_id_seq CASCADE;
947DROP SEQUENCE IF EXISTS gfi_feature_id_seq CASCADE;
948DROP SEQUENCE IF EXISTS gf_inheritancerelation_id_seq CASCADE;
949DROP SEQUENCE IF EXISTS gf_locationalattributetype_id_seq CASCADE;
950DROP SEQUENCE IF EXISTS gf_metadataattributetype_id_seq CASCADE;
951DROP SEQUENCE IF EXISTS gf_operation_id_seq CASCADE;
952DROP SEQUENCE IF EXISTS gf_propertytype_id_seq CASCADE;
953DROP SEQUENCE IF EXISTS gf_spatialassociationtype_id_seq CASCADE;
954DROP SEQUENCE IF EXISTS gf_spatialattributetype_id_seq CASCADE;
955DROP SEQUENCE IF EXISTS gf_temporalassociationtype_id_seq CASCADE;
956DROP SEQUENCE IF EXISTS gf_temporalattributetype_id_seq CASCADE;
957DROP SEQUENCE IF EXISTS gf_thematicattributetype_id_seq CASCADE;
958DROP SEQUENCE IF EXISTS gm_affineplacement_id_seq CASCADE;
959DROP SEQUENCE IF EXISTS gm_aggregate_id_seq CASCADE;
960DROP SEQUENCE IF EXISTS gm_arcstringbybulge_id_seq CASCADE;
961DROP SEQUENCE IF EXISTS gm_arcstring_id_seq CASCADE;
962DROP SEQUENCE IF EXISTS gm_boundary_id_seq CASCADE;
963DROP SEQUENCE IF EXISTS gm_clothoid_id_seq CASCADE;
964DROP SEQUENCE IF EXISTS gm_complex_id_seq CASCADE;
965DROP SEQUENCE IF EXISTS gm_compositecurve_id_seq CASCADE;
966DROP SEQUENCE IF EXISTS gm_composite_id_seq CASCADE;
967DROP SEQUENCE IF EXISTS gm_compositepoint_id_seq CASCADE;
968DROP SEQUENCE IF EXISTS gm_compositesolid_id_seq CASCADE;
969DROP SEQUENCE IF EXISTS gm_compositesurface_id_seq CASCADE;
970DROP SEQUENCE IF EXISTS gm_conic_id_seq CASCADE;
971DROP SEQUENCE IF EXISTS gm_curve_id_seq CASCADE;
972DROP SEQUENCE IF EXISTS gm_curvesegment_id_seq CASCADE;
973DROP SEQUENCE IF EXISTS gm_geodesicstring_id_seq CASCADE;
974DROP SEQUENCE IF EXISTS gm_knot_id_seq CASCADE;
975DROP SEQUENCE IF EXISTS gm_linestring_id_seq CASCADE;
976DROP SEQUENCE IF EXISTS gm_object_id_seq CASCADE;
977DROP SEQUENCE IF EXISTS gm_offsetcurve_id_seq CASCADE;
978DROP SEQUENCE IF EXISTS gm_orientablecurve_id_seq CASCADE;
979DROP SEQUENCE IF EXISTS gm_orientableprimitive_id_seq CASCADE;
980DROP SEQUENCE IF EXISTS gm_orientablesurface_id_seq CASCADE;
981DROP SEQUENCE IF EXISTS gm_parametriccurvesurface_id_seq CASCADE;
982DROP SEQUENCE IF EXISTS gm_pointarray_id_seq CASCADE;
983DROP SEQUENCE IF EXISTS gm_point_id_seq CASCADE;
984DROP SEQUENCE IF EXISTS gm_pointref_id_seq CASCADE;
985DROP SEQUENCE IF EXISTS gm_polygon_id_seq CASCADE;
986DROP SEQUENCE IF EXISTS gm_polyhedralsurface_id_seq CASCADE;
987DROP SEQUENCE IF EXISTS gm_position_id_seq CASCADE;
988DROP SEQUENCE IF EXISTS gm_primitiveboundary_id_seq CASCADE;
989DROP SEQUENCE IF EXISTS gm_primitive_id_seq CASCADE;
990DROP SEQUENCE IF EXISTS gm_ring_id_seq CASCADE;
991DROP SEQUENCE IF EXISTS gm_solid_id_seq CASCADE;
992DROP SEQUENCE IF EXISTS gm_splinecurve_id_seq CASCADE;
993DROP SEQUENCE IF EXISTS gm_surfaceboundary_id_seq CASCADE;
994DROP SEQUENCE IF EXISTS gm_surface_id_seq CASCADE;
995DROP SEQUENCE IF EXISTS gm_surfacepatch_id_seq CASCADE;
996DROP SEQUENCE IF EXISTS gm_tin_id_seq CASCADE;
997DROP SEQUENCE IF EXISTS gm_triangle_id_seq CASCADE;
998DROP SEQUENCE IF EXISTS gm_triangulatedsurface_id_seq CASCADE;
999DROP SEQUENCE IF EXISTS if_classificationattributetype_id_seq CASCADE;
1000DROP SEQUENCE IF EXISTS io_identifiedobjectbase_id_seq CASCADE;
1001DROP SEQUENCE IF EXISTS io_identifiedobject_id_seq CASCADE;
1002DROP SEQUENCE IF EXISTS juliandate_id_seq CASCADE;
1003DROP SEQUENCE IF EXISTS le_algorithm_id_seq CASCADE;
1004DROP SEQUENCE IF EXISTS length_id_seq CASCADE;
1005DROP SEQUENCE IF EXISTS le_nominalresolution_id_seq CASCADE;
1006DROP SEQUENCE IF EXISTS le_source_id_seq CASCADE;
1007DROP SEQUENCE IF EXISTS li_lineage_id_seq CASCADE;
1008DROP SEQUENCE IF EXISTS li_processstep_id_seq CASCADE;
1009DROP SEQUENCE IF EXISTS li_source_id_seq CASCADE;
1010DROP SEQUENCE IF EXISTS localname_id_seq CASCADE;
1011DROP SEQUENCE IF EXISTS location_id_seq CASCADE;
1012DROP SEQUENCE IF EXISTS md_aggregateinformation_id_seq CASCADE;
1013DROP SEQUENCE IF EXISTS md_applicationschemainformation_id_seq CASCADE;
1014DROP SEQUENCE IF EXISTS md_browsegraphic_id_seq CASCADE;
1015DROP SEQUENCE IF EXISTS md_constraints_id_seq CASCADE;
1016DROP SEQUENCE IF EXISTS md_contentinformation_id_seq CASCADE;
1017DROP SEQUENCE IF EXISTS md_coveragedescription_id_seq CASCADE;
1018DROP SEQUENCE IF EXISTS md_digitaltransferoptions_id_seq CASCADE;
1019DROP SEQUENCE IF EXISTS md_dimension_id_seq CASCADE;
1020DROP SEQUENCE IF EXISTS md_distribution_id_seq CASCADE;
1021DROP SEQUENCE IF EXISTS md_distributor_id_seq CASCADE;
1022DROP SEQUENCE IF EXISTS md_extendedelementinformation_id_seq CASCADE;
1023DROP SEQUENCE IF EXISTS md_featurecataloguedescription_id_seq CASCADE;
1024DROP SEQUENCE IF EXISTS md_format_id_seq CASCADE;
1025DROP SEQUENCE IF EXISTS md_geometricobjects_id_seq CASCADE;
1026DROP SEQUENCE IF EXISTS md_gridspatialrepresentation_id_seq CASCADE;
1027DROP SEQUENCE IF EXISTS md_identification_id_seq CASCADE;
1028DROP SEQUENCE IF EXISTS md_identifier_id_seq CASCADE;
1029DROP SEQUENCE IF EXISTS md_imagedescription_id_seq CASCADE;
1030DROP SEQUENCE IF EXISTS md_keywords_id_seq CASCADE;
1031DROP SEQUENCE IF EXISTS md_legalconstraints_id_seq CASCADE;
1032DROP SEQUENCE IF EXISTS md_maintenanceinformation_id_seq CASCADE;
1033DROP SEQUENCE IF EXISTS md_medium_id_seq CASCADE;
1034DROP SEQUENCE IF EXISTS md_metadataextensioninformation_id_seq CASCADE;
1035DROP SEQUENCE IF EXISTS md_metadata_id_seq CASCADE;
1036DROP SEQUENCE IF EXISTS md_portrayalcataloguereference_id_seq CASCADE;
1037DROP SEQUENCE IF EXISTS md_rangedimension_id_seq CASCADE;
1038DROP SEQUENCE IF EXISTS md_referencesystem_id_seq CASCADE;
1039DROP SEQUENCE IF EXISTS md_representativefraction_id_seq CASCADE;
1040DROP SEQUENCE IF EXISTS md_scopedescription_id_seq CASCADE;
1041DROP SEQUENCE IF EXISTS md_securityconstraints_id_seq CASCADE;
1042DROP SEQUENCE IF EXISTS md_spatialrepresentation_id_seq CASCADE;
1043DROP SEQUENCE IF EXISTS md_standardorderprocess_id_seq CASCADE;
1044DROP SEQUENCE IF EXISTS md_usage_id_seq CASCADE;
1045DROP SEQUENCE IF EXISTS md_vectorspatialrepresentation_id_seq CASCADE;
1046DROP SEQUENCE IF EXISTS measure_id_seq CASCADE;
1047DROP SEQUENCE IF EXISTS membername_id_seq CASCADE;
1048DROP SEQUENCE IF EXISTS mi_coveragedescription_id_seq CASCADE;
1049DROP SEQUENCE IF EXISTS mi_rangeelementdescription_id_seq CASCADE;
1050DROP SEQUENCE IF EXISTS mo_acquisition_id_seq CASCADE;
1051DROP SEQUENCE IF EXISTS mo_compositeprocess_id_seq CASCADE;
1052DROP SEQUENCE IF EXISTS mo_computation_id_seq CASCADE;
1053DROP SEQUENCE IF EXISTS mo_featureofinterest_id_seq CASCADE;
1054DROP SEQUENCE IF EXISTS mo_inputoutput_id_seq CASCADE;
1055DROP SEQUENCE IF EXISTS mo_instrument_id_seq CASCADE;
1056DROP SEQUENCE IF EXISTS mo_instrumentplatformpair_id_seq CASCADE;
1057DROP SEQUENCE IF EXISTS mo_location_id_seq CASCADE;
1058DROP SEQUENCE IF EXISTS mo_observationcollection_id_seq CASCADE;
1059DROP SEQUENCE IF EXISTS mo_observation_id_seq CASCADE;
1060DROP SEQUENCE IF EXISTS mo_onlineresource_id_seq CASCADE;
1061DROP SEQUENCE IF EXISTS mo_operation_id_seq CASCADE;
1062DROP SEQUENCE IF EXISTS mo_organization_id_seq CASCADE;
1063DROP SEQUENCE IF EXISTS mo_platform_id_seq CASCADE;
1064DROP SEQUENCE IF EXISTS mo_process_id_seq CASCADE;
1065DROP SEQUENCE IF EXISTS mo_processing_id_seq CASCADE;
1066DROP SEQUENCE IF EXISTS mo_project_id_seq CASCADE;
1067DROP SEQUENCE IF EXISTS mo_responsiblepartyinfo_id_seq CASCADE;
1068DROP SEQUENCE IF EXISTS mo_result_id_seq CASCADE;
1069DROP SEQUENCE IF EXISTS multiplicity_id_seq CASCADE;
1070DROP SEQUENCE IF EXISTS multiplicityrange_id_seq CASCADE;
1071DROP SEQUENCE IF EXISTS mx_datafile_id_seq CASCADE;
1072DROP SEQUENCE IF EXISTS namedvalue_id_seq CASCADE;
1073DROP SEQUENCE IF EXISTS namespace_id_seq CASCADE;
1074DROP SEQUENCE IF EXISTS om_categoryobservation_id_seq CASCADE;
1075DROP SEQUENCE IF EXISTS om_complexobservation_id_seq CASCADE;
1076DROP SEQUENCE IF EXISTS om_countobservation_id_seq CASCADE;
1077DROP SEQUENCE IF EXISTS om_discretecoverageobservation_id_seq CASCADE;
1078DROP SEQUENCE IF EXISTS om_geometryobservation_id_seq CASCADE;
1079DROP SEQUENCE IF EXISTS om_measurement_id_seq CASCADE;
1080DROP SEQUENCE IF EXISTS om_observation_id_seq CASCADE;
1081DROP SEQUENCE IF EXISTS om_process_id_seq CASCADE;
1082DROP SEQUENCE IF EXISTS om_temporalobservation_id_seq CASCADE;
1083DROP SEQUENCE IF EXISTS om_truthobservation_id_seq CASCADE;
1084DROP SEQUENCE IF EXISTS qe_coverageresult_id_seq CASCADE;
1085DROP SEQUENCE IF EXISTS qe_usability_id_seq CASCADE;
1086DROP SEQUENCE IF EXISTS record_id_seq CASCADE;
1087DROP SEQUENCE IF EXISTS recordtype_id_seq CASCADE;
1088DROP SEQUENCE IF EXISTS rs_identifier_id_seq CASCADE;
1089DROP SEQUENCE IF EXISTS rs_referencesystem_id_seq CASCADE;
1090DROP SEQUENCE IF EXISTS scale_id_seq CASCADE;
1091DROP SEQUENCE IF EXISTS sc_compoundcrs_id_seq CASCADE;
1092DROP SEQUENCE IF EXISTS sc_crs_id_seq CASCADE;
1093DROP SEQUENCE IF EXISTS sc_derivedcrs_id_seq CASCADE;
1094DROP SEQUENCE IF EXISTS sc_engineeringcrs_id_seq CASCADE;
1095DROP SEQUENCE IF EXISTS sc_generalderivedcrs_id_seq CASCADE;
1096DROP SEQUENCE IF EXISTS sc_geodeticcrs_id_seq CASCADE;
1097DROP SEQUENCE IF EXISTS schema_id_seq CASCADE;
1098DROP SEQUENCE IF EXISTS sc_imagecrs_id_seq CASCADE;
1099DROP SEQUENCE IF EXISTS scopedname_id_seq CASCADE;
1100DROP SEQUENCE IF EXISTS sc_projectedcrs_id_seq CASCADE;
1101DROP SEQUENCE IF EXISTS sc_singlecrs_id_seq CASCADE;
1102DROP SEQUENCE IF EXISTS sc_verticalcrs_id_seq CASCADE;
1103DROP SEQUENCE IF EXISTS sf_process_id_seq CASCADE;
1104DROP SEQUENCE IF EXISTS sf_samplingfeature_id_seq CASCADE;
1105DROP SEQUENCE IF EXISTS sf_spatialsamplingfeature_id_seq CASCADE;
1106DROP SEQUENCE IF EXISTS sf_specimen_id_seq CASCADE;
1107DROP SEQUENCE IF EXISTS time_id_seq CASCADE;
1108DROP SEQUENCE IF EXISTS tm_caldate_id_seq CASCADE;
1109DROP SEQUENCE IF EXISTS tm_calendarera_id_seq CASCADE;
1110DROP SEQUENCE IF EXISTS tm_calendar_id_seq CASCADE;
1111DROP SEQUENCE IF EXISTS tm_clock_id_seq CASCADE;
1112DROP SEQUENCE IF EXISTS tm_clocktime_id_seq CASCADE;
1113DROP SEQUENCE IF EXISTS tm_complex_id_seq CASCADE;
1114DROP SEQUENCE IF EXISTS tm_coordinate_id_seq CASCADE;
1115DROP SEQUENCE IF EXISTS tm_coordinatesystem_id_seq CASCADE;
1116DROP SEQUENCE IF EXISTS tm_duration_id_seq CASCADE;
1117DROP SEQUENCE IF EXISTS tm_edge_id_seq CASCADE;
1118DROP SEQUENCE IF EXISTS tm_geometricprimitive_id_seq CASCADE;
1119DROP SEQUENCE IF EXISTS tm_instant_id_seq CASCADE;
1120DROP SEQUENCE IF EXISTS tm_node_id_seq CASCADE;
1121DROP SEQUENCE IF EXISTS tm_object_id_seq CASCADE;
1122DROP SEQUENCE IF EXISTS tm_ordinalera_id_seq CASCADE;
1123DROP SEQUENCE IF EXISTS tm_ordinalposition_id_seq CASCADE;
1124DROP SEQUENCE IF EXISTS tm_ordinalreferencesystem_id_seq CASCADE;
1125DROP SEQUENCE IF EXISTS tm_periodduration_id_seq CASCADE;
1126DROP SEQUENCE IF EXISTS tm_period_id_seq CASCADE;
1127DROP SEQUENCE IF EXISTS tm_position_id_seq CASCADE;
1128DROP SEQUENCE IF EXISTS tm_primitive_id_seq CASCADE;
1129DROP SEQUENCE IF EXISTS tm_referencesystem_id_seq CASCADE;
1130DROP SEQUENCE IF EXISTS tm_temporalcrs_id_seq CASCADE;
1131DROP SEQUENCE IF EXISTS tm_temporalposition_id_seq CASCADE;
1132DROP SEQUENCE IF EXISTS tm_topologicalcomplex_id_seq CASCADE;
1133DROP SEQUENCE IF EXISTS tm_topologicalprimitive_id_seq CASCADE;
1134DROP SEQUENCE IF EXISTS tp_boundary_id_seq CASCADE;
1135DROP SEQUENCE IF EXISTS tp_complex_id_seq CASCADE;
1136DROP SEQUENCE IF EXISTS tp_directededge_id_seq CASCADE;
1137DROP SEQUENCE IF EXISTS tp_directedface_id_seq CASCADE;
1138DROP SEQUENCE IF EXISTS tp_directednode_id_seq CASCADE;
1139DROP SEQUENCE IF EXISTS tp_directedsolid_id_seq CASCADE;
1140DROP SEQUENCE IF EXISTS tp_directedtopo_id_seq CASCADE;
1141DROP SEQUENCE IF EXISTS tp_edge_id_seq CASCADE;
1142DROP SEQUENCE IF EXISTS tp_expression_id_seq CASCADE;
1143DROP SEQUENCE IF EXISTS tp_expressionterm_id_seq CASCADE;
1144DROP SEQUENCE IF EXISTS tp_face_id_seq CASCADE;
1145DROP SEQUENCE IF EXISTS tp_node_id_seq CASCADE;
1146DROP SEQUENCE IF EXISTS tp_primitive_id_seq CASCADE;
1147DROP SEQUENCE IF EXISTS tp_ring_id_seq CASCADE;
1148DROP SEQUENCE IF EXISTS tp_shell_id_seq CASCADE;
1149DROP SEQUENCE IF EXISTS tp_solid_id_seq CASCADE;
1150DROP SEQUENCE IF EXISTS type_id_seq CASCADE;
1151DROP SEQUENCE IF EXISTS typename_id_seq CASCADE;
1152DROP SEQUENCE IF EXISTS unitofmeasure_id_seq CASCADE;
1153DROP SEQUENCE IF EXISTS unlimitedinteger_id_seq CASCADE;
1154DROP SEQUENCE IF EXISTS uomangle_id_seq CASCADE;
1155DROP SEQUENCE IF EXISTS uomlength_id_seq CASCADE;
1156DROP SEQUENCE IF EXISTS uomscale_id_seq CASCADE;
1157DROP SEQUENCE IF EXISTS url_id_seq CASCADE;
1158DROP SEQUENCE IF EXISTS nt_laneconstraint_id_seq CASCADE;
1159DROP SEQUENCE IF EXISTS nt_link_id_seq CASCADE;
1160DROP SEQUENCE IF EXISTS nt_linkposition_id_seq CASCADE;
1161DROP SEQUENCE IF EXISTS nt_maneuver_id_seq CASCADE;
1162DROP SEQUENCE IF EXISTS nt_network_id_seq CASCADE;
1163DROP SEQUENCE IF EXISTS nt_networkposition_id_seq CASCADE;
1164DROP SEQUENCE IF EXISTS nt_route_id_seq CASCADE;
1165DROP SEQUENCE IF EXISTS nt_routesummary_id_seq CASCADE;
1166DROP SEQUENCE IF EXISTS nt_temporalconstraint_id_seq CASCADE;
1167DROP SEQUENCE IF EXISTS nt_transfer_id_seq CASCADE;
1168DROP SEQUENCE IF EXISTS nt_transferlink_id_seq CASCADE;
1169DROP SEQUENCE IF EXISTS nt_transfernode_id_seq CASCADE;
1170DROP SEQUENCE IF EXISTS nt_turn_id_seq CASCADE;
1171DROP SEQUENCE IF EXISTS nt_vehicleconstraint_id_seq CASCADE;
1172DROP SEQUENCE IF EXISTS nt_waypoint_id_seq CASCADE;
1173DROP SEQUENCE IF EXISTS nt_waypointlist_id_seq CASCADE;
1174DROP SEQUENCE IF EXISTS polygon_id_seq CASCADE;
1175DROP SEQUENCE IF EXISTS rectangle_id_seq CASCADE;
1176DROP SEQUENCE IF EXISTS si_gazetteer_id_seq CASCADE;
1177DROP SEQUENCE IF EXISTS si_locationinstance_id_seq CASCADE;
1178DROP SEQUENCE IF EXISTS si_locationtype_id_seq CASCADE;
1179DROP SEQUENCE IF EXISTS simplex_id_seq CASCADE;
1180DROP SEQUENCE IF EXISTS simplicialcomplex_id_seq CASCADE;
1181DROP SEQUENCE IF EXISTS si_spatialreferencesystemusinggeographicidentifiers_id_seq CASCADE;
1182DROP SEQUENCE IF EXISTS taxonomicclassification_id_seq CASCADE;
1183DROP SEQUENCE IF EXISTS taxonomysystem_id_seq CASCADE;
1184DROP SEQUENCE IF EXISTS temporalcrs_id_seq CASCADE;
1185DROP SEQUENCE IF EXISTS temporaldatum_id_seq CASCADE;
1186DROP SEQUENCE IF EXISTS timecs_id_seq CASCADE;
1187DROP SEQUENCE IF EXISTS tk_position_id_seq CASCADE;
1188DROP SEQUENCE IF EXISTS tm_intervallength_id_seq CASCADE;
1189DROP SEQUENCE IF EXISTS topocurve_id_seq CASCADE;
1190DROP SEQUENCE IF EXISTS topopoint_id_seq CASCADE;
1191DROP SEQUENCE IF EXISTS toposurface_id_seq CASCADE;
1192DROP SEQUENCE IF EXISTS topovolume_id_seq CASCADE;
1193DROP SEQUENCE IF EXISTS uomweight_id_seq CASCADE;
1194DROP SEQUENCE IF EXISTS vouchers_id_seq CASCADE;
1195DROP SEQUENCE IF EXISTS weight_id_seq CASCADE;
Note: See TracBrowser for help on using the repository browser.