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