Changeset 8422 for mauRepo


Ignore:
Timestamp:
29/06/12 17:29:11 (7 years ago)
Author:
mnagni
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed

  • mauRepo/MolesManager/trunk/src/libs/migration/tests/dropAllTables.sql

    r8358 r8422  
    1 DROP TABLE IF EXISTS angle CASCADE; 
     1DROP SEQUENCE IF EXISTS ad_abstractaddress_id_seq CASCADE; 
     2DROP SEQUENCE IF EXISTS arcbycenterpoint_id_seq CASCADE; 
     3DROP SEQUENCE IF EXISTS cell_id_seq CASCADE; 
     4DROP SEQUENCE IF EXISTS cellularcomplex_id_seq CASCADE; 
     5DROP SEQUENCE IF EXISTS eg_pointestimate_id_seq CASCADE; 
     6DROP SEQUENCE IF EXISTS fd_featurecollection_id_seq CASCADE; 
     7DROP SEQUENCE IF EXISTS fd_feature_id_seq CASCADE; 
     8DROP SEQUENCE IF EXISTS fd_featurename_id_seq CASCADE; 
     9DROP SEQUENCE IF EXISTS lr_element_id_seq CASCADE; 
     10DROP SEQUENCE IF EXISTS lr_feature_id_seq CASCADE; 
     11DROP SEQUENCE IF EXISTS lr_linearreferencemethod_id_seq CASCADE; 
     12DROP SEQUENCE IF EXISTS lr_offsetexpression_id_seq CASCADE; 
     13DROP SEQUENCE IF EXISTS lr_positionexpression_id_seq CASCADE; 
     14DROP SEQUENCE IF EXISTS lr_referencemarker_id_seq CASCADE; 
     15DROP SEQUENCE IF EXISTS mo_citation_id_seq CASCADE; 
     16DROP SEQUENCE IF EXISTS mo_individual_id_seq CASCADE; 
     17DROP SEQUENCE IF EXISTS mo_organisation_id_seq CASCADE; 
     18DROP SEQUENCE IF EXISTS mo_party_id_seq CASCADE; 
     19DROP SEQUENCE IF EXISTS nl_compositecurve_id_seq CASCADE; 
     20DROP SEQUENCE IF EXISTS nl_composite_id_seq CASCADE; 
     21DROP SEQUENCE IF EXISTS nl_compositepoint_id_seq CASCADE; 
     22DROP SEQUENCE IF EXISTS nl_compsitesurface_id_seq CASCADE; 
     23DROP SEQUENCE IF EXISTS nl_curve_id_seq CASCADE; 
     24DROP SEQUENCE IF EXISTS nl_curvesegment_id_seq CASCADE; 
     25DROP SEQUENCE IF EXISTS nl_map_id_seq CASCADE; 
     26DROP SEQUENCE IF EXISTS nl_orientablecurve_id_seq CASCADE; 
     27DROP SEQUENCE IF EXISTS nl_orientablesurface_id_seq CASCADE; 
     28DROP SEQUENCE IF EXISTS nl_point_id_seq CASCADE; 
     29DROP SEQUENCE IF EXISTS nl_primitve_id_seq CASCADE; 
     30DROP SEQUENCE IF EXISTS nl_ring_id_seq CASCADE; 
     31DROP SEQUENCE IF EXISTS nl_surfaceboundary_id_seq CASCADE; 
     32DROP SEQUENCE IF EXISTS nl_surface_id_seq CASCADE; 
     33DROP SEQUENCE IF EXISTS nl_surfacepatch_id_seq CASCADE; 
     34DROP SEQUENCE IF EXISTS ns_avoidlist_id_seq CASCADE; 
     35DROP SEQUENCE IF EXISTS ns_costedlink_id_seq CASCADE; 
     36DROP SEQUENCE IF EXISTS ns_costedturn_id_seq CASCADE; 
     37DROP SEQUENCE IF EXISTS ns_costfunction_id_seq CASCADE; 
     38DROP SEQUENCE IF EXISTS ns_routerequest_id_seq CASCADE; 
     39DROP SEQUENCE IF EXISTS nt_advisorydirection_id_seq CASCADE; 
     40DROP SEQUENCE IF EXISTS nt_advisorydistance_id_seq CASCADE; 
     41DROP SEQUENCE IF EXISTS nt_advisoryelement_id_seq CASCADE; 
     42DROP SEQUENCE IF EXISTS nt_advisory_id_seq CASCADE; 
     43DROP SEQUENCE IF EXISTS nt_advisoryspatialrelation_id_seq CASCADE; 
     44DROP SEQUENCE IF EXISTS nt_combinednetwork_id_seq CASCADE; 
     45DROP SEQUENCE IF EXISTS nt_constraint_id_seq CASCADE; 
     46DROP SEQUENCE IF EXISTS nt_exitassociation_id_seq CASCADE; 
     47DROP SEQUENCE IF EXISTS nt_junction_id_seq CASCADE; 
     48DROP TABLE IF EXISTS angle CASCADE; 
    249DROP TABLE IF EXISTS "any" CASCADE; 
    350DROP TABLE IF EXISTS cc_concatenatedoperation CASCADE; 
    … …  
    546593DROP TABLE IF EXISTS geometry_columns CASCADE; 
    547594DROP TABLE IF EXISTS spatial_ref_sys CASCADE; 
     595DROP TABLE IF EXISTS ad_abstractaddress CASCADE; 
     596DROP TABLE IF EXISTS arcbycenterpoint CASCADE; 
     597DROP TABLE IF EXISTS cell CASCADE; 
     598DROP TABLE IF EXISTS cell_cellularcomplex CASCADE; 
     599DROP TABLE IF EXISTS cell_gm_complex CASCADE; 
     600DROP TABLE IF EXISTS cell_gm_composite CASCADE; 
     601DROP TABLE IF EXISTS cell_gm_primitive CASCADE; 
     602DROP TABLE IF EXISTS cell_tp_complex CASCADE; 
     603DROP TABLE IF EXISTS cell_tp_primitive CASCADE; 
     604DROP TABLE IF EXISTS cellularcomplex CASCADE; 
     605DROP TABLE IF EXISTS cellularcomplex_cell CASCADE; 
     606DROP TABLE IF EXISTS cellularcomplex_gm_complex CASCADE; 
     607DROP TABLE IF EXISTS cellularcomplex_gm_primitive CASCADE; 
     608DROP TABLE IF EXISTS cellularcomplex_tp_complex CASCADE; 
     609DROP TABLE IF EXISTS cellularcomplex_tp_primitive CASCADE; 
     610DROP TABLE IF EXISTS eg_pointestimate CASCADE; 
     611DROP TABLE IF EXISTS ex_extent_mo_responsiblepartyinfo CASCADE; 
     612DROP TABLE IF EXISTS fd_feature CASCADE; 
     613DROP TABLE IF EXISTS fd_featurecollection CASCADE; 
     614DROP TABLE IF EXISTS fd_featurecollection_fd_feature CASCADE; 
     615DROP TABLE IF EXISTS fd_feature_fd_featurecollection CASCADE; 
     616DROP TABLE IF EXISTS fd_featurename CASCADE; 
     617DROP TABLE IF EXISTS fd_feature_ns_avoidlist CASCADE; 
     618DROP TABLE IF EXISTS gf_featuretype_ns_avoidlist CASCADE; 
     619DROP TABLE IF EXISTS gm_composite_gm_complex CASCADE; 
     620DROP TABLE IF EXISTS gm_composite_gm_primitive CASCADE; 
     621DROP TABLE IF EXISTS lr_element CASCADE; 
     622DROP TABLE IF EXISTS lr_feature CASCADE; 
     623DROP TABLE IF EXISTS lr_linearreferencemethod CASCADE; 
     624DROP TABLE IF EXISTS lr_offsetexpression CASCADE; 
     625DROP TABLE IF EXISTS lr_positionexpression CASCADE; 
     626DROP TABLE IF EXISTS lr_referencemarker CASCADE; 
     627DROP TABLE IF EXISTS mo_acquisition_mo_compositeprocess CASCADE; 
     628DROP TABLE IF EXISTS mo_citation CASCADE; 
     629DROP TABLE IF EXISTS mo_individual CASCADE; 
     630DROP TABLE IF EXISTS mo_instrument_mo_acquisition CASCADE; 
     631DROP TABLE IF EXISTS mo_operation_mo_acquisition CASCADE; 
     632DROP TABLE IF EXISTS mo_organisation CASCADE; 
     633DROP TABLE IF EXISTS mo_organisation_mo_responsiblepartyinfo CASCADE; 
     634DROP TABLE IF EXISTS mo_party CASCADE; 
     635DROP TABLE IF EXISTS mo_platform_mo_acquisition CASCADE; 
     636DROP TABLE IF EXISTS mo_platform_mo_operation CASCADE; 
     637DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_acquisition CASCADE; 
     638DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_compositeprocess CASCADE; 
     639DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_instrument CASCADE; 
     640DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_observation CASCADE; 
     641DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_operation CASCADE; 
     642DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_organisation CASCADE; 
     643DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_platform CASCADE; 
     644DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_processing CASCADE; 
     645DROP TABLE IF EXISTS mo_responsiblepartyinfo_mo_project CASCADE; 
     646DROP TABLE IF EXISTS nl_composite CASCADE; 
     647DROP TABLE IF EXISTS nl_compositecurve CASCADE; 
     648DROP TABLE IF EXISTS nl_compositecurve_nl_compositecurve CASCADE; 
     649DROP TABLE IF EXISTS nl_compositepoint CASCADE; 
     650DROP TABLE IF EXISTS nl_compsitesurface CASCADE; 
     651DROP TABLE IF EXISTS nl_compsitesurface_nl_compsitesurface CASCADE; 
     652DROP TABLE IF EXISTS nl_curve CASCADE; 
     653DROP TABLE IF EXISTS nl_curvesegment CASCADE; 
     654DROP TABLE IF EXISTS nl_map CASCADE; 
     655DROP TABLE IF EXISTS nl_orientablecurve CASCADE; 
     656DROP TABLE IF EXISTS nl_orientablesurface CASCADE; 
     657DROP TABLE IF EXISTS nl_point CASCADE; 
     658DROP TABLE IF EXISTS nl_primitve CASCADE; 
     659DROP TABLE IF EXISTS nl_ring CASCADE; 
     660DROP TABLE IF EXISTS nl_surfaceboundary CASCADE; 
     661DROP TABLE IF EXISTS nl_surface CASCADE; 
     662DROP TABLE IF EXISTS nl_surfacepatch CASCADE; 
     663DROP TABLE IF EXISTS ns_avoidlist CASCADE; 
     664DROP TABLE IF EXISTS ns_costedlink CASCADE; 
     665DROP TABLE IF EXISTS ns_costedturn CASCADE; 
     666DROP TABLE IF EXISTS ns_costfunction CASCADE; 
     667DROP TABLE IF EXISTS ns_costfunction_ns_routerequest CASCADE; 
     668DROP TABLE IF EXISTS ns_routerequest CASCADE; 
     669DROP TABLE IF EXISTS ns_routerequest_ns_costfunction CASCADE; 
     670DROP TABLE IF EXISTS nt_advisory CASCADE; 
     671DROP TABLE IF EXISTS nt_advisorydirection CASCADE; 
     672DROP TABLE IF EXISTS nt_advisorydistance CASCADE; 
     673DROP TABLE IF EXISTS nt_advisoryelement CASCADE; 
     674DROP TABLE IF EXISTS nt_advisoryspatialrelation CASCADE; 
     675DROP TABLE IF EXISTS nt_combinednetwork CASCADE; 
     676DROP TABLE IF EXISTS nt_combinednetwork_nt_combinednetwork CASCADE; 
     677DROP TABLE IF EXISTS nt_constraint CASCADE; 
     678DROP TABLE IF EXISTS nt_exitassociation CASCADE; 
     679DROP TABLE IF EXISTS nt_junction CASCADE; 
     680DROP TABLE IF EXISTS nt_junction_nt_network CASCADE; 
     681DROP TABLE IF EXISTS nt_junction_nt_transfernode CASCADE; 
     682DROP TABLE IF EXISTS nt_laneconstraint CASCADE; 
     683DROP TABLE IF EXISTS nt_link CASCADE; 
     684DROP TABLE IF EXISTS nt_link_lr_linearreferencemethod CASCADE; 
     685DROP TABLE IF EXISTS nt_link_nt_junction CASCADE; 
     686DROP TABLE IF EXISTS nt_link_nt_maneuver CASCADE; 
     687DROP TABLE IF EXISTS nt_link_nt_network CASCADE; 
     688DROP TABLE IF EXISTS nt_linkposition CASCADE; 
     689DROP TABLE IF EXISTS nt_link_tp_face CASCADE; 
     690DROP TABLE IF EXISTS nt_link_tp_node CASCADE; 
     691DROP TABLE IF EXISTS nt_maneuver CASCADE; 
     692DROP TABLE IF EXISTS nt_maneuver_nt_link CASCADE; 
     693DROP TABLE IF EXISTS nt_maneuver_nt_route CASCADE; 
     694DROP TABLE IF EXISTS nt_maneuver_nt_turn CASCADE; 
     695DROP TABLE IF EXISTS nt_network CASCADE; 
     696DROP TABLE IF EXISTS nt_networkposition CASCADE; 
     697DROP TABLE IF EXISTS nt_network_tp_complex CASCADE; 
     698DROP TABLE IF EXISTS nt_network_tp_primitive CASCADE; 
     699DROP TABLE IF EXISTS nt_route CASCADE; 
     700DROP TABLE IF EXISTS nt_route_nt_combinednetwork CASCADE; 
     701DROP TABLE IF EXISTS nt_routesummary CASCADE; 
     702DROP TABLE IF EXISTS nt_temporalconstraint CASCADE; 
     703DROP TABLE IF EXISTS nt_transfer CASCADE; 
     704DROP TABLE IF EXISTS nt_transferlink CASCADE; 
     705DROP TABLE IF EXISTS nt_transfernode CASCADE; 
     706DROP TABLE IF EXISTS nt_transfernode_nt_combinednetwork CASCADE; 
     707DROP TABLE IF EXISTS nt_turn CASCADE; 
     708DROP TABLE IF EXISTS nt_turn_nt_junction CASCADE; 
     709DROP TABLE IF EXISTS nt_turn_nt_link CASCADE; 
     710DROP TABLE IF EXISTS nt_turn_nt_maneuver CASCADE; 
     711DROP TABLE IF EXISTS nt_turn_nt_network CASCADE; 
     712DROP TABLE IF EXISTS nt_vehicleconstraint CASCADE; 
     713DROP TABLE IF EXISTS nt_waypoint CASCADE; 
     714DROP TABLE IF EXISTS nt_waypointlist CASCADE; 
     715DROP TABLE IF EXISTS polygon CASCADE; 
     716DROP TABLE IF EXISTS rectangle CASCADE; 
     717DROP TABLE IF EXISTS si_gazetteer CASCADE; 
     718DROP TABLE IF EXISTS si_gazetteer_si_locationinstance CASCADE; 
     719DROP TABLE IF EXISTS si_locationinstance CASCADE; 
     720DROP TABLE IF EXISTS si_locationinstance_si_gazetteer CASCADE; 
     721DROP TABLE IF EXISTS si_locationinstance_si_locationinstance CASCADE; 
     722DROP TABLE IF EXISTS si_locationtype CASCADE; 
     723DROP TABLE IF EXISTS si_locationtype_si_gazetteer CASCADE; 
     724DROP TABLE IF EXISTS si_locationtype_si_locationtype CASCADE; 
     725DROP TABLE IF EXISTS si_locationtype_si_spatialreferencesystemusinggeographicidenti CASCADE; 
     726DROP TABLE IF EXISTS simplex CASCADE; 
     727DROP TABLE IF EXISTS simplex_gm_complex CASCADE; 
     728DROP TABLE IF EXISTS simplex_gm_composite CASCADE; 
     729DROP TABLE IF EXISTS simplex_gm_primitive CASCADE; 
     730DROP TABLE IF EXISTS simplex_simplicialcomplex CASCADE; 
     731DROP TABLE IF EXISTS simplex_tp_complex CASCADE; 
     732DROP TABLE IF EXISTS simplex_tp_primitive CASCADE; 
     733DROP TABLE IF EXISTS simplicialcomplex CASCADE; 
     734DROP TABLE IF EXISTS simplicialcomplex_simplex CASCADE; 
     735DROP TABLE IF EXISTS si_spatialreferencesystemusinggeographicidentifiers CASCADE; 
     736DROP TABLE IF EXISTS si_spatialreferencesystemusinggeographicidentifiers_si_locatio CASCADE; 
     737DROP TABLE IF EXISTS taxonomicclassification CASCADE; 
     738DROP TABLE IF EXISTS taxonomysystem CASCADE; 
     739DROP TABLE IF EXISTS temporalcrs CASCADE; 
     740DROP TABLE IF EXISTS temporaldatum CASCADE; 
     741DROP TABLE IF EXISTS timecs CASCADE; 
     742DROP TABLE IF EXISTS tk_position CASCADE; 
     743DROP TABLE IF EXISTS tm_intervallength CASCADE; 
     744DROP TABLE IF EXISTS topocurve CASCADE; 
     745DROP TABLE IF EXISTS topopoint CASCADE; 
     746DROP TABLE IF EXISTS toposurface CASCADE; 
     747DROP TABLE IF EXISTS topovolume CASCADE; 
     748DROP TABLE IF EXISTS tp_edge_tp_face CASCADE; 
     749DROP TABLE IF EXISTS tp_edge_tp_node CASCADE; 
     750DROP TABLE IF EXISTS uomweight CASCADE; 
     751DROP TABLE IF EXISTS vouchers CASCADE; 
     752DROP TABLE IF EXISTS weight CASCADE; 
     753 
    548754 
    549755 
    … …  
    559765        ceda_compositeprocess_id = NULL, ceda_acquisition_id = NULL, 
    560766        ceda_project_id = NULL, doc_hash = NULL; 
    561  
     767--DROP TABLE IF EXISTS data_entity_migration CASCADE; 
     768--DROP TABLE IF EXISTS deployments_migration CASCADE; 
     769--DROP TABLE IF EXISTS deployment_data_migration CASCADE; 
    562770 
    563771DROP SEQUENCE IF EXISTS angle_id_seq CASCADE; 
    … …  
    9481156DROP SEQUENCE IF EXISTS uomscale_id_seq CASCADE; 
    9491157DROP SEQUENCE IF EXISTS url_id_seq CASCADE; 
     1158DROP SEQUENCE IF EXISTS nt_laneconstraint_id_seq CASCADE; 
     1159DROP SEQUENCE IF EXISTS nt_link_id_seq CASCADE; 
     1160DROP SEQUENCE IF EXISTS nt_linkposition_id_seq CASCADE; 
     1161DROP SEQUENCE IF EXISTS nt_maneuver_id_seq CASCADE; 
     1162DROP SEQUENCE IF EXISTS nt_network_id_seq CASCADE; 
     1163DROP SEQUENCE IF EXISTS nt_networkposition_id_seq CASCADE; 
     1164DROP SEQUENCE IF EXISTS nt_route_id_seq CASCADE; 
     1165DROP SEQUENCE IF EXISTS nt_routesummary_id_seq CASCADE; 
     1166DROP SEQUENCE IF EXISTS nt_temporalconstraint_id_seq CASCADE; 
     1167DROP SEQUENCE IF EXISTS nt_transfer_id_seq CASCADE; 
     1168DROP SEQUENCE IF EXISTS nt_transferlink_id_seq CASCADE; 
     1169DROP SEQUENCE IF EXISTS nt_transfernode_id_seq CASCADE; 
     1170DROP SEQUENCE IF EXISTS nt_turn_id_seq CASCADE; 
     1171DROP SEQUENCE IF EXISTS nt_vehicleconstraint_id_seq CASCADE; 
     1172DROP SEQUENCE IF EXISTS nt_waypoint_id_seq CASCADE; 
     1173DROP SEQUENCE IF EXISTS nt_waypointlist_id_seq CASCADE; 
     1174DROP SEQUENCE IF EXISTS polygon_id_seq CASCADE; 
     1175DROP SEQUENCE IF EXISTS rectangle_id_seq CASCADE; 
     1176DROP SEQUENCE IF EXISTS si_gazetteer_id_seq CASCADE; 
     1177DROP SEQUENCE IF EXISTS si_locationinstance_id_seq CASCADE; 
     1178DROP SEQUENCE IF EXISTS si_locationtype_id_seq CASCADE; 
     1179DROP SEQUENCE IF EXISTS simplex_id_seq CASCADE; 
     1180DROP SEQUENCE IF EXISTS simplicialcomplex_id_seq CASCADE; 
     1181DROP SEQUENCE IF EXISTS si_spatialreferencesystemusinggeographicidentifiers_id_seq CASCADE; 
     1182DROP SEQUENCE IF EXISTS taxonomicclassification_id_seq CASCADE; 
     1183DROP SEQUENCE IF EXISTS taxonomysystem_id_seq CASCADE; 
     1184DROP SEQUENCE IF EXISTS temporalcrs_id_seq CASCADE; 
     1185DROP SEQUENCE IF EXISTS temporaldatum_id_seq CASCADE; 
     1186DROP SEQUENCE IF EXISTS timecs_id_seq CASCADE; 
     1187DROP SEQUENCE IF EXISTS tk_position_id_seq CASCADE; 
     1188DROP SEQUENCE IF EXISTS tm_intervallength_id_seq CASCADE; 
     1189DROP SEQUENCE IF EXISTS topocurve_id_seq CASCADE; 
     1190DROP SEQUENCE IF EXISTS topopoint_id_seq CASCADE; 
     1191DROP SEQUENCE IF EXISTS toposurface_id_seq CASCADE; 
     1192DROP SEQUENCE IF EXISTS topovolume_id_seq CASCADE; 
     1193DROP SEQUENCE IF EXISTS uomweight_id_seq CASCADE; 
     1194DROP SEQUENCE IF EXISTS vouchers_id_seq CASCADE; 
     1195DROP SEQUENCE IF EXISTS weight_id_seq CASCADE; 
Note: See TracChangeset for help on using the changeset viewer.