source: mauRepo/MolesManager/trunk/cedaMoles/dropAllTables.sql @ 8514

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/mauRepo/MolesManager/trunk/cedaMoles/dropAllTables.sql@8514
Revision 8514, 62.8 KB checked in by mnagni, 8 years ago (diff)

Incomplete - # 22534: Add versiojn number to the gui page
 http://team.ceda.ac.uk/trac/ceda/ticket/22534
Correct party_indexes definition (from now on, ON DELETE = cascade)

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