- Timestamp:
- 04/01/12 10:35:54 (9 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll
r8017 r8043 1 DROP TABLE IF EXISTS absractobservableproperty, 2 ci_address, ci_citation, ci_contact, ci_date, 3 ci_onlineresource, ci_responsibleparty, ci_series, 4 ci_telephone, clocktime, compositeobservableproperty, 5 date, dateprecision, datetime, distance, dq_dataquality, 6 dq_element, dq_result, dq_scope, ex_extent, 7 ex_geographicdescription, ex_geographicextent, ex_temporalextent, 8 ex_verticalextent, genericname, gf_constraint, gf_propertytype, 9 gfi_domainfeature, gfi_feature, gm_object, io_identifiedobjectbase, 10 le_algorithm, le_nominalresolution, le_processing, le_source, 11 length, li_lineage, li_processstep, li_source, localname, 12 location, md_aggregateinformation, md_applicationschemainformation, 13 md_browsegraphic, md_constraints, md_contentinformation, 14 md_digitaltransferoptions, md_distribution, md_distributor, 15 md_extendedelementinformation, md_format, md_identification, 16 md_identifier, md_keywords, md_maintenanceinformation, 17 md_medium, md_metadata, md_metadataextensioninformation, 18 md_portrayalcataloguereference, md_referencesystem, md_representativefraction, 19 md_scopedescription, md_spatialrepresentation, md_standardorderprocess, 20 md_usage, measure, mi_event, mi_instrument, mi_objective, 21 mi_operation, mi_platform, mi_platformpass, mo_acquisition, 22 mo_compositeprocess, mo_computation, mo_fetureofinterest, 23 mo_inputoutput, mo_instrument, mo_instrumentplatformpair, 24 mo_location, mo_observation, mo_observationcollection, mo_onlineresource, 25 mo_operation, mo_organization, mo_platform, mo_process, mo_processing, 26 mo_project, mo_responsiblepartyinfo, mo_result, mo_specimen, 27 mo_specimenprocess, namedvalue, number, observablepropertyconstraint, 28 om_observation, om_process, rs_identifier, rs_referencesystem, 29 any, sc_crs, scale, scopedname, sf_process, sf_samplingfeature, 30 sf_specimen, simpleobservableproperty, time, tm_duration, 31 tm_geometricprimitive, tm_instant, tm_object, tm_period, 32 tm_periodduration, tm_position, tm_primitive, tm_temporalposition, 33 unitofmeasure, uomlength, uomscale, url, ceda_acquisition, ceda_citation, 34 ceda_compositeprocess, ceda_instrument, ceda_notes, ceda_observation, 35 ceda_observationcollection, ceda_operation, ceda_platform, ceda_process, 36 ceda_processing, ceda_project, ceda_result, ceda_review, ci_organisation, 37 ci_responsibility, ceda_observationcollection_ceda_project, md_identifier_ci_citation, 38 mo_instrument_mo_instrument, mo_observationcollection_mo_observationcollection, 39 mo_observationcollection_mo_project, mo_operation_mo_operation, mo_platform_mo_platform, 40 mo_project_mo_project, mo_result_mo_result, om_observation_om_observation, mo_project_mo_observation, 41 mo_observation_mo_observationcollection, ci_citation_md_identifier, ceda_project_ceda_observation, 42 ceda_observation_ceda_observationcollection, ci_individual, ci_party, ci_responsiblepartyinfo, 43 ceda_process_ceda_acquisition, ceda_process_ceda_compositeprocess, ci_onlineresource_mo_onlineresource, 44 clocktime_datetime, date_datetime, earootclass, ex_geographicextent_ex_geographicdescription, 45 genericname_localname, genericname_scopedname, gf_attributetype, gf_featuretype, gf_propertytype_gf_attributetype, 46 47 CASCADE; 48 49 DROP SEQUENCE IF EXISTS absractobservableproperty_id_seq, any_id_seq, 50 ci_address_id_seq, ci_citation_id_seq, ci_contact_id_seq, ci_date_id_seq, 51 ci_onlineresource_id_seq, ci_responsibleparty_id_seq, ci_series_id_seq, 52 ci_telephone_id_seq, clocktime_id_seq, compositeobservableproperty_id_seq, 53 date_id_seq, dateprecision_id_seq, datetime_id_seq, distance_id_seq, 54 dq_dataquality_id_seq, dq_element_id_seq, dq_result_id_seq, clocktime_id_seq, 55 ceda_acquisition_id_seq, ceda_citation_id_seq, ceda_compositeprocess_id_seq, 56 ceda_instrument_id_seq, ceda_notes_id_seq, ceda_observation_id_seq, 57 ceda_observationcollection_id_seq, ceda_operation_id_seq, ceda_platform_id_seq, 58 ceda_process_id_seq, ceda_processing_id_seq, ceda_project_id_seq, ceda_result_id_seq, 59 ceda_review_id_seq, ci_organisation_id_seq, ci_responsibility_id_seq, dq_scope_id_seq, 60 ex_extent_id_seq, ex_geographicdescription_id_seq, ex_geographicextent_id_seq, 61 ex_temporalextent_id_seq, ex_verticalextent_id_seq, genericname_id_seq, 62 gf_constraint_id_seq, gf_propertytype_id_seq, gfi_domainfeature_id_seq 63 CASCADE; 64 65 66 SELECT 1 SELECT 67 2 'DROP TABLE IF EXISTS '||c.relname ||' CASCADE;' 68 3 FROM pg_catalog.pg_class c … … 83 18 AND pg_catalog.pg_table_is_visible(c.oid) 84 19 ORDER BY 1; 85 86 DROP TABLE IF EXISTS ceda_acquisition CASCADE;87 DROP TABLE IF EXISTS ceda_citation CASCADE;88 DROP TABLE IF EXISTS ceda_compositeprocess CASCADE;89 DROP TABLE IF EXISTS ceda_instrument CASCADE;90 DROP TABLE IF EXISTS ceda_notes CASCADE;91 DROP TABLE IF EXISTS ceda_observation CASCADE;92 DROP TABLE IF EXISTS ceda_observationcollection CASCADE;93 DROP TABLE IF EXISTS ceda_operation CASCADE;94 DROP TABLE IF EXISTS ceda_platform CASCADE;95 DROP TABLE IF EXISTS ceda_process CASCADE;96 DROP TABLE IF EXISTS ceda_process_ceda_acquisition CASCADE;97 DROP TABLE IF EXISTS ceda_process_ceda_compositeprocess CASCADE;98 DROP TABLE IF EXISTS ceda_process_ceda_processing CASCADE;99 DROP TABLE IF EXISTS ceda_processing CASCADE;100 DROP TABLE IF EXISTS ceda_project CASCADE;101 DROP TABLE IF EXISTS ceda_result CASCADE;102 DROP TABLE IF EXISTS ceda_review CASCADE;103 DROP TABLE IF EXISTS ci_address CASCADE;104 DROP TABLE IF EXISTS ci_citation CASCADE;105 DROP TABLE IF EXISTS ci_contact CASCADE;106 DROP TABLE IF EXISTS ci_date CASCADE;107 DROP TABLE IF EXISTS ci_onlineresource CASCADE;108 DROP TABLE IF EXISTS ci_onlineresource_mo_onlineresource CASCADE;109 DROP TABLE IF EXISTS ci_responsibleparty CASCADE;110 DROP TABLE IF EXISTS ci_series CASCADE;111 DROP TABLE IF EXISTS ci_telephone CASCADE;112 DROP TABLE IF EXISTS clocktime CASCADE;113 DROP TABLE IF EXISTS clocktime_datetime CASCADE;114 DROP TABLE IF EXISTS date CASCADE;115 DROP TABLE IF EXISTS date_datetime CASCADE;116 DROP TABLE IF EXISTS dateprecision CASCADE;117 DROP TABLE IF EXISTS datetime CASCADE;118 DROP TABLE IF EXISTS dq_dataquality CASCADE;119 DROP TABLE IF EXISTS dq_element CASCADE;120 DROP TABLE IF EXISTS dq_result CASCADE;121 DROP TABLE IF EXISTS dq_scope CASCADE;122 DROP TABLE IF EXISTS earootclass CASCADE;123 DROP TABLE IF EXISTS ex_extent CASCADE;124 DROP TABLE IF EXISTS ex_geographicdescription CASCADE;125 DROP TABLE IF EXISTS ex_geographicextent CASCADE;126 DROP TABLE IF EXISTS ex_geographicextent_ex_geographicdescription CASCADE;127 DROP TABLE IF EXISTS ex_temporalextent CASCADE;128 DROP TABLE IF EXISTS ex_verticalextent CASCADE;129 DROP TABLE IF EXISTS genericname CASCADE;130 DROP TABLE IF EXISTS genericname_localname CASCADE;131 DROP TABLE IF EXISTS genericname_scopedname CASCADE;132 DROP TABLE IF EXISTS gf_attributetype CASCADE;133 DROP TABLE IF EXISTS gf_constraint CASCADE;134 DROP TABLE IF EXISTS gf_featuretype CASCADE;135 DROP TABLE IF EXISTS gf_propertytype CASCADE;136 DROP TABLE IF EXISTS gf_propertytype_gf_attributetype CASCADE;137 DROP TABLE IF EXISTS gm_object CASCADE;138 DROP TABLE IF EXISTS io_identifiedobjectbase CASCADE;139 DROP TABLE IF EXISTS io_identifiedobjectbase_sc_crs CASCADE;140 DROP TABLE IF EXISTS li_lineage CASCADE;141 DROP TABLE IF EXISTS li_processstep CASCADE;142 DROP TABLE IF EXISTS li_source CASCADE;143 DROP TABLE IF EXISTS localname CASCADE;144 DROP TABLE IF EXISTS localname_typename CASCADE;145 DROP TABLE IF EXISTS md_aggregateinformation CASCADE;146 DROP TABLE IF EXISTS md_applicationschemainformation CASCADE;147 DROP TABLE IF EXISTS md_browsegraphic CASCADE;148 DROP TABLE IF EXISTS md_constraints CASCADE;149 DROP TABLE IF EXISTS md_contentinformation CASCADE;150 DROP TABLE IF EXISTS md_distribution CASCADE;151 DROP TABLE IF EXISTS md_extendedelementinformation CASCADE;152 DROP TABLE IF EXISTS md_format CASCADE;153 DROP TABLE IF EXISTS md_identification CASCADE;154 DROP TABLE IF EXISTS md_identifier CASCADE;155 DROP TABLE IF EXISTS md_identifier_rs_identifier CASCADE;156 DROP TABLE IF EXISTS md_keywords CASCADE;157 DROP TABLE IF EXISTS md_maintenanceinformation CASCADE;158 DROP TABLE IF EXISTS md_metadata CASCADE;159 DROP TABLE IF EXISTS md_metadataextensioninformation CASCADE;160 DROP TABLE IF EXISTS md_portrayalcataloguereference CASCADE;161 DROP TABLE IF EXISTS md_referencesystem CASCADE;162 DROP TABLE IF EXISTS md_representativefraction CASCADE;163 DROP TABLE IF EXISTS md_scopedescription CASCADE;164 DROP TABLE IF EXISTS md_spatialrepresentation CASCADE;165 DROP TABLE IF EXISTS md_usage CASCADE;166 DROP TABLE IF EXISTS measure CASCADE;167 DROP TABLE IF EXISTS measure_scale CASCADE;168 DROP TABLE IF EXISTS measure_time CASCADE;169 DROP TABLE IF EXISTS mo_acquisition CASCADE;170 DROP TABLE IF EXISTS mo_acquisition_ceda_acquisition CASCADE;171 DROP TABLE IF EXISTS mo_compositeprocess CASCADE;172 DROP TABLE IF EXISTS mo_compositeprocess_ceda_compositeprocess CASCADE;173 DROP TABLE IF EXISTS mo_computation CASCADE;174 DROP TABLE IF EXISTS mo_computation_mo_processing CASCADE;175 DROP TABLE IF EXISTS mo_inputoutput CASCADE;176 DROP TABLE IF EXISTS mo_instrument CASCADE;177 DROP TABLE IF EXISTS mo_instrument_ceda_instrument CASCADE;178 DROP TABLE IF EXISTS mo_instrumentplatformpair CASCADE;179 DROP TABLE IF EXISTS mo_location CASCADE;180 DROP TABLE IF EXISTS mo_observation CASCADE;181 DROP TABLE IF EXISTS mo_observation_ceda_observation CASCADE;182 DROP TABLE IF EXISTS mo_observationcollection CASCADE;183 DROP TABLE IF EXISTS mo_observationcollection_ceda_observationcollection CASCADE;184 DROP TABLE IF EXISTS mo_onlineresource CASCADE;185 DROP TABLE IF EXISTS mo_operation CASCADE;186 DROP TABLE IF EXISTS mo_operation_ceda_operation CASCADE;187 DROP TABLE IF EXISTS mo_platform CASCADE;188 DROP TABLE IF EXISTS mo_platform_ceda_platform CASCADE;189 DROP TABLE IF EXISTS mo_process CASCADE;190 DROP TABLE IF EXISTS mo_process_ceda_process CASCADE;191 DROP TABLE IF EXISTS mo_processing CASCADE;192 DROP TABLE IF EXISTS mo_processing_ceda_processing CASCADE;193 DROP TABLE IF EXISTS mo_process_mo_acquisition CASCADE;194 DROP TABLE IF EXISTS mo_process_mo_compositeprocess CASCADE;195 DROP TABLE IF EXISTS mo_process_mo_computation CASCADE;196 DROP TABLE IF EXISTS mo_project CASCADE;197 DROP TABLE IF EXISTS mo_project_ceda_project CASCADE;198 DROP TABLE IF EXISTS mo_responsiblepartyinfo CASCADE;199 DROP TABLE IF EXISTS mo_result CASCADE;200 DROP TABLE IF EXISTS mo_result_ceda_result CASCADE;201 DROP TABLE IF EXISTS multiplicity CASCADE;202 DROP TABLE IF EXISTS namedvalue CASCADE;203 DROP TABLE IF EXISTS obs_coll_migration CASCADE;204 DROP TABLE IF EXISTS observation_migration CASCADE;205 DROP TABLE IF EXISTS om_observation CASCADE;206 DROP TABLE IF EXISTS om_observation_mo_observation CASCADE;207 DROP TABLE IF EXISTS om_process CASCADE;208 DROP TABLE IF EXISTS om_process_mo_process CASCADE;209 DROP TABLE IF EXISTS rs_identifier CASCADE;210 DROP TABLE IF EXISTS rs_referencesystem CASCADE;211 DROP TABLE IF EXISTS rs_referencesystem_sc_crs CASCADE;212 DROP TABLE IF EXISTS scale CASCADE;213 DROP TABLE IF EXISTS sc_crs CASCADE;214 DROP TABLE IF EXISTS scopedname CASCADE;215 DROP TABLE IF EXISTS time CASCADE;216 DROP TABLE IF EXISTS tm_duration CASCADE;217 DROP TABLE IF EXISTS tm_duration_tm_periodduration CASCADE;218 DROP TABLE IF EXISTS tm_geometricprimitive CASCADE;219 DROP TABLE IF EXISTS tm_geometricprimitive_tm_instant CASCADE;220 DROP TABLE IF EXISTS tm_geometricprimitive_tm_period CASCADE;221 DROP TABLE IF EXISTS tm_instant CASCADE;222 DROP TABLE IF EXISTS tm_object CASCADE;223 DROP TABLE IF EXISTS tm_object_tm_primitive CASCADE;224 DROP TABLE IF EXISTS tm_period CASCADE;225 DROP TABLE IF EXISTS tm_periodduration CASCADE;226 DROP TABLE IF EXISTS tm_position CASCADE;227 DROP TABLE IF EXISTS tm_primitive CASCADE;228 DROP TABLE IF EXISTS tm_primitive_tm_geometricprimitive CASCADE;229 DROP TABLE IF EXISTS tm_temporalposition CASCADE;230 DROP TABLE IF EXISTS typename CASCADE;231 DROP TABLE IF EXISTS unitofmeasure CASCADE;232 DROP TABLE IF EXISTS unitofmeasure_uomlength CASCADE;233 DROP TABLE IF EXISTS unitofmeasure_uomscale CASCADE;234 DROP TABLE IF EXISTS uomlength CASCADE;235 DROP TABLE IF EXISTS uomscale CASCADE;236 DROP TABLE IF EXISTS url CASCADE;237 238 DROP SEQUENCE IF EXISTS any_id_seq CASCADE;239 DROP SEQUENCE IF EXISTS ceda_acquisition_id_seq CASCADE;240 DROP SEQUENCE IF EXISTS ceda_citation_id_seq CASCADE;241 DROP SEQUENCE IF EXISTS ceda_compositeprocess_id_seq CASCADE;242 DROP SEQUENCE IF EXISTS ceda_instrument_id_seq CASCADE;243 DROP SEQUENCE IF EXISTS ceda_notes_id_seq CASCADE;244 DROP SEQUENCE IF EXISTS ceda_observationcollection_id_seq CASCADE;245 DROP SEQUENCE IF EXISTS ceda_observation_id_seq CASCADE;246 DROP SEQUENCE IF EXISTS ceda_operation_id_seq CASCADE;247 DROP SEQUENCE IF EXISTS ceda_platform_id_seq CASCADE;248 DROP SEQUENCE IF EXISTS ceda_process_id_seq CASCADE;249 DROP SEQUENCE IF EXISTS ceda_processing_id_seq CASCADE;250 DROP SEQUENCE IF EXISTS ceda_project_id_seq CASCADE;251 DROP SEQUENCE IF EXISTS ceda_result_id_seq CASCADE;252 DROP SEQUENCE IF EXISTS ceda_review_id_seq CASCADE;253 DROP SEQUENCE IF EXISTS ci_address_id_seq CASCADE;254 DROP SEQUENCE IF EXISTS ci_citation_id_seq CASCADE;255 DROP SEQUENCE IF EXISTS ci_contact_id_seq CASCADE;256 DROP SEQUENCE IF EXISTS ci_date_id_seq CASCADE;257 DROP SEQUENCE IF EXISTS ci_onlineresource_id_seq CASCADE;258 DROP SEQUENCE IF EXISTS ci_responsibleparty_id_seq CASCADE;259 DROP SEQUENCE IF EXISTS ci_series_id_seq CASCADE;260 DROP SEQUENCE IF EXISTS ci_telephone_id_seq CASCADE;261 DROP SEQUENCE IF EXISTS clocktime_id_seq CASCADE;262 DROP SEQUENCE IF EXISTS date_id_seq CASCADE;263 DROP SEQUENCE IF EXISTS dateprecision_id_seq CASCADE;264 DROP SEQUENCE IF EXISTS datetime_id_seq CASCADE;265 DROP SEQUENCE IF EXISTS dq_dataquality_id_seq CASCADE;266 DROP SEQUENCE IF EXISTS dq_element_id_seq CASCADE;267 DROP SEQUENCE IF EXISTS dq_result_id_seq CASCADE;268 DROP SEQUENCE IF EXISTS dq_scope_id_seq CASCADE;269 DROP SEQUENCE IF EXISTS earootclass_id_seq CASCADE;270 DROP SEQUENCE IF EXISTS ex_extent_id_seq CASCADE;271 DROP SEQUENCE IF EXISTS ex_geographicdescription_id_seq CASCADE;272 DROP SEQUENCE IF EXISTS ex_geographicextent_id_seq CASCADE;273 DROP SEQUENCE IF EXISTS ex_temporalextent_id_seq CASCADE;274 DROP SEQUENCE IF EXISTS ex_verticalextent_id_seq CASCADE;275 DROP SEQUENCE IF EXISTS genericname_id_seq CASCADE;276 DROP SEQUENCE IF EXISTS gf_attributetype_id_seq CASCADE;277 DROP SEQUENCE IF EXISTS gf_constraint_id_seq CASCADE;278 DROP SEQUENCE IF EXISTS gf_featuretype_id_seq CASCADE;279 DROP SEQUENCE IF EXISTS gf_propertytype_id_seq CASCADE;280 DROP SEQUENCE IF EXISTS gm_object_id_seq CASCADE;281 DROP SEQUENCE IF EXISTS io_identifiedobjectbase_id_seq CASCADE;282 DROP SEQUENCE IF EXISTS li_lineage_id_seq CASCADE;283 DROP SEQUENCE IF EXISTS li_processstep_id_seq CASCADE;284 DROP SEQUENCE IF EXISTS li_source_id_seq CASCADE;285 DROP SEQUENCE IF EXISTS localname_id_seq CASCADE;286 DROP SEQUENCE IF EXISTS md_aggregateinformation_id_seq CASCADE;287 DROP SEQUENCE IF EXISTS md_applicationschemainformation_id_seq CASCADE;288 DROP SEQUENCE IF EXISTS md_browsegraphic_id_seq CASCADE;289 DROP SEQUENCE IF EXISTS md_constraints_id_seq CASCADE;290 DROP SEQUENCE IF EXISTS md_contentinformation_id_seq CASCADE;291 DROP SEQUENCE IF EXISTS md_distribution_id_seq CASCADE;292 DROP SEQUENCE IF EXISTS md_extendedelementinformation_id_seq CASCADE;293 DROP SEQUENCE IF EXISTS md_format_id_seq CASCADE;294 DROP SEQUENCE IF EXISTS md_identification_id_seq CASCADE;295 DROP SEQUENCE IF EXISTS md_identifier_id_seq CASCADE;296 DROP SEQUENCE IF EXISTS md_keywords_id_seq CASCADE;297 DROP SEQUENCE IF EXISTS md_maintenanceinformation_id_seq CASCADE;298 DROP SEQUENCE IF EXISTS md_metadataextensioninformation_id_seq CASCADE;299 DROP SEQUENCE IF EXISTS md_metadata_id_seq CASCADE;300 DROP SEQUENCE IF EXISTS md_portrayalcataloguereference_id_seq CASCADE;301 DROP SEQUENCE IF EXISTS md_referencesystem_id_seq CASCADE;302 DROP SEQUENCE IF EXISTS md_representativefraction_id_seq CASCADE;303 DROP SEQUENCE IF EXISTS md_scopedescription_id_seq CASCADE;304 DROP SEQUENCE IF EXISTS md_spatialrepresentation_id_seq CASCADE;305 DROP SEQUENCE IF EXISTS md_usage_id_seq CASCADE;306 DROP SEQUENCE IF EXISTS measure_id_seq CASCADE;307 DROP SEQUENCE IF EXISTS mo_acquisition_id_seq CASCADE;308 DROP SEQUENCE IF EXISTS mo_compositeprocess_id_seq CASCADE;309 DROP SEQUENCE IF EXISTS mo_computation_id_seq CASCADE;310 DROP SEQUENCE IF EXISTS mo_inputoutput_id_seq CASCADE;311 DROP SEQUENCE IF EXISTS mo_instrument_id_seq CASCADE;312 DROP SEQUENCE IF EXISTS mo_instrumentplatformpair_id_seq CASCADE;313 DROP SEQUENCE IF EXISTS mo_location_id_seq CASCADE;314 DROP SEQUENCE IF EXISTS mo_observationcollection_id_seq CASCADE;315 DROP SEQUENCE IF EXISTS mo_observation_id_seq CASCADE;316 DROP SEQUENCE IF EXISTS mo_onlineresource_id_seq CASCADE;317 DROP SEQUENCE IF EXISTS mo_operation_id_seq CASCADE;318 DROP SEQUENCE IF EXISTS mo_platform_id_seq CASCADE;319 DROP SEQUENCE IF EXISTS mo_process_id_seq CASCADE;320 DROP SEQUENCE IF EXISTS mo_processing_id_seq CASCADE;321 DROP SEQUENCE IF EXISTS mo_project_id_seq CASCADE;322 DROP SEQUENCE IF EXISTS mo_responsiblepartyinfo_id_seq CASCADE;323 DROP SEQUENCE IF EXISTS mo_result_id_seq CASCADE;324 DROP SEQUENCE IF EXISTS multiplicity_id_seq CASCADE;325 DROP SEQUENCE IF EXISTS namedvalue_id_seq CASCADE;326 DROP SEQUENCE IF EXISTS om_observation_id_seq CASCADE;327 DROP SEQUENCE IF EXISTS om_process_id_seq CASCADE;328 DROP SEQUENCE IF EXISTS rs_identifier_id_seq CASCADE;329 DROP SEQUENCE IF EXISTS rs_referencesystem_id_seq CASCADE;330 DROP SEQUENCE IF EXISTS scale_id_seq CASCADE;331 DROP SEQUENCE IF EXISTS sc_crs_id_seq CASCADE;332 DROP SEQUENCE IF EXISTS scopedname_id_seq CASCADE;333 DROP SEQUENCE IF EXISTS time_id_seq CASCADE;334 DROP SEQUENCE IF EXISTS tm_duration_id_seq CASCADE;335 DROP SEQUENCE IF EXISTS tm_geometricprimitive_id_seq CASCADE;336 DROP SEQUENCE IF EXISTS tm_instant_id_seq CASCADE;337 DROP SEQUENCE IF EXISTS tm_object_id_seq CASCADE;338 DROP SEQUENCE IF EXISTS tm_periodduration_id_seq CASCADE;339 DROP SEQUENCE IF EXISTS tm_period_id_seq CASCADE;340 DROP SEQUENCE IF EXISTS tm_position_id_seq CASCADE;341 DROP SEQUENCE IF EXISTS tm_primitive_id_seq CASCADE;342 DROP SEQUENCE IF EXISTS tm_temporalposition_id_seq CASCADE;343 DROP SEQUENCE IF EXISTS typename_id_seq CASCADE;344 DROP SEQUENCE IF EXISTS unitofmeasure_id_seq CASCADE;345 DROP SEQUENCE IF EXISTS uomlength_id_seq CASCADE;346 DROP SEQUENCE IF EXISTS uomscale_id_seq CASCADE;347 DROP SEQUENCE IF EXISTS url_id_seq CASCADE;348 349 SELECT obs_coll_migration.data_ent_id AS obs_coll_migration_data_ent_id, obs_coll_migration.data_ent_name AS obs_coll_migration_data_ent_name, obs_coll_migration.obs_coll_id AS obs_coll_migration_obs_coll_id, obs_coll_migration.data_ent_creation AS obs_coll_migration_data_ent_creation, obs_coll_migration.exist_path AS obs_coll_migration_exist_path350 FROM obs_coll_migration351 WHERE obs_coll_migration.data_ent_id = 'tag:badc.nerc.ac.uk,2009-12-10:/view/badc.nerc.ac.uk__ATOM__dataent_hadgem1-ct'352 353 SELECT observation_migration.depl_id AS observation_migration_depl_id, observation_migration.depl_name AS observation_migration_depl_name, observation_migration.obs_id AS observation_migration_obs_id, observation_migration.depl_creation AS observation_migration_depl_creation, observation_migration.exist_path AS observation_migration_exist_path354 FROM observation_migration355 WHERE depl_name = 'dep_11731402648516527.atom'356 357 SELECT ceda_observation.ceda_observation_id AS ceda_observation_ceda_observation_id, ceda_observation.mo_observation_id AS ceda_observation_mo_observation_id, ceda_observation.ceda_observationcollection_member AS ceda_observation_ceda_observationcollection_member, ceda_observation."dataLineage" AS "ceda_observation_dataLineage", ceda_observation.t_type AS ceda_observation_t_type358 FROM ceda_observation359 WHERE ceda_observation.ceda_observation_id = 980360 361 SELECT obs_coll_migration.data_ent_id AS obs_coll_migration_data_ent_id, obs_coll_migration.data_ent_name AS obs_coll_migration_data_ent_name, obs_coll_migration.obs_coll_id AS obs_coll_migration_obs_coll_id, obs_coll_migration.data_ent_creation AS obs_coll_migration_data_ent_creation, obs_coll_migration.exist_path AS obs_coll_migration_exist_path362 FROM obs_coll_migration363 WHERE obs_coll_migration.data_ent_id = 'tag:badc.nerc.ac.uk,2009-12-10:/view/badc.nerc.ac.uk__ATOM__dataent_COAPEC'364 365 SELECT observation_migration.depl_id AS observation_migration_depl_id, observation_migration.depl_name AS observation_migration_depl_name, observation_migration.obs_id AS observation_migration_obs_id, observation_migration.depl_creation AS observation_migration_depl_creation, observation_migration.exist_path AS observation_migration_exist_path366 FROM observation_migration367 WHERE depl_name = 'dep_11655964239611677.atom'368
Note: See TracChangeset
for help on using the changeset viewer.