Ignore:
Timestamp:
02/02/12 10:15:47 (8 years ago)
Author:
mnagni
Message:

Correctly generates DB tables for CEDAEditor

in sqlTables.sql

1) No more "metadata = MetaData?()"
2) no more "metadata.create_all(engine)"

Just a couple of stupid thigs has still to be fixed by hand:
3) Column('refDirection', ARRAY, nullable=True) ----> Column('refDirection', ARRAY(TEXT), nullable=True)
4) Column('role', CI_RoleCode.db_type(), nullable=False) ----> Column('role', CI_RoleCode.db_type())

File:
1 edited

Legend:

Unmodified
Added
Removed
  • mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll

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