source: mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll @ 8017

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