source: ISOcat/trunk/mod-ISOcat-access-data/dbms/ISOcat-schema-drop.sql @ 2029

Last change on this file since 2029 was 2029, checked in by mwindhouwer, 12 years ago

Initial import of all the *cats, i.e., ISOcat, RELcat and SCHEMAcat.
File size: 5.6 KB
Line 
1-- tables
2DROP TABLE IF EXISTS core_account CASCADE;
3DROP TABLE IF EXISTS core_adhoc_group CASCADE;
4DROP TABLE IF EXISTS core_change_request CASCADE;
5DROP TABLE IF EXISTS core_change_request_vote CASCADE;
6DROP TABLE IF EXISTS core_closed_data_category CASCADE;
7DROP TABLE IF EXISTS core_closed_linguistic_section CASCADE;
8DROP TABLE IF EXISTS core_complex_data_category CASCADE;
9DROP TABLE IF EXISTS core_conceptual_domain CASCADE;
10DROP TABLE IF EXISTS core_conceptual_domain_rule CASCADE;
11DROP TABLE IF EXISTS core_constrained_data_category CASCADE;
12DROP TABLE IF EXISTS core_constrained_linguistic_section CASCADE;
13DROP TABLE IF EXISTS core_container_data_category CASCADE;
14DROP TABLE IF EXISTS core_data_category CASCADE;
15DROP TABLE IF EXISTS core_data_category_selection CASCADE;
16DROP TABLE IF EXISTS core_data_type CASCADE;
17DROP TABLE IF EXISTS core_dc_status_log CASCADE;
18DROP TABLE IF EXISTS core_dcr_board CASCADE;
19DROP TABLE IF EXISTS core_decision_group CASCADE;
20DROP TABLE IF EXISTS core_group CASCADE;
21DROP TABLE IF EXISTS core_language CASCADE;
22DROP TABLE IF EXISTS core_language_section CASCADE;
23DROP TABLE IF EXISTS core_linguistic_section CASCADE;
24DROP TABLE IF EXISTS core_message CASCADE;
25DROP TABLE IF EXISTS core_open_conceptual_domain CASCADE;
26DROP TABLE IF EXISTS core_open_data_category CASCADE;
27DROP TABLE IF EXISTS core_owner CASCADE;
28DROP TABLE IF EXISTS core_profile CASCADE;
29DROP TABLE IF EXISTS core_profile_value_domain CASCADE;
30DROP TABLE IF EXISTS core_registration_authority CASCADE;
31DROP TABLE IF EXISTS core_registration_group CASCADE;
32DROP TABLE IF EXISTS core_rule CASCADE;
33DROP TABLE IF EXISTS core_rule_type CASCADE;
34DROP TABLE IF EXISTS core_selected_complex_data_category CASCADE;
35DROP TABLE IF EXISTS core_selected_container_data_category CASCADE;
36DROP TABLE IF EXISTS core_selected_data_category CASCADE;
37DROP TABLE IF EXISTS core_selected_simple_data_category CASCADE;
38DROP TABLE IF EXISTS core_session CASCADE;
39DROP TABLE IF EXISTS core_simple_data_category CASCADE;
40DROP TABLE IF EXISTS core_submission_group CASCADE;
41DROP TABLE IF EXISTS core_thematic_domain_group CASCADE;
42DROP TABLE IF EXISTS core_user CASCADE;
43DROP TABLE IF EXISTS core_value_domain CASCADE;
44DROP TABLE IF EXISTS generic_lock CASCADE;
45DROP TABLE IF EXISTS generic_name CASCADE;
46DROP TABLE IF EXISTS generic_text CASCADE;
47DROP TABLE IF EXISTS link_dc_access CASCADE;
48DROP TABLE IF EXISTS link_dcs_access CASCADE;
49DROP TABLE IF EXISTS link_open_data_category_conceptual_domain CASCADE;
50DROP TABLE IF EXISTS link_closed_data_category_conceptual_domains CASCADE;
51DROP TABLE IF EXISTS link_constrained_data_category_conceptual_domains CASCADE;
52DROP TABLE IF EXISTS link_constrained_linguistic_section_conceptual_domains CASCADE;
53DROP TABLE IF EXISTS link_data_category_selection_users CASCADE;
54DROP TABLE IF EXISTS link_group_members CASCADE;
55DROP TABLE IF EXISTS link_profile_members CASCADE;
56DROP TABLE IF EXISTS link_selected_data_category_picklist CASCADE;
57DROP TABLE IF EXISTS link_selected_data_category_profiles CASCADE;
58DROP TABLE IF EXISTS link_simple_data_category_super CASCADE;
59DROP TABLE IF EXISTS link_value_domain_values CASCADE;
60DROP TABLE IF EXISTS link_dc_access CASCADE;
61DROP TABLE IF EXISTS link_dcs_access CASCADE;
62
63-- views
64DROP VIEW IF EXISTS view_dc_name;
65DROP VIEW IF EXISTS view_dcs;
66DROP VIEW IF EXISTS view_dcs_dc;
67DROP VIEW IF EXISTS view_profile;
68DROP VIEW IF EXISTS view_data_category;
69DROP VIEW IF EXISTS view_text;
70DROP VIEW IF EXISTS view_name;
71DROP VIEW IF EXISTS view_owner;
72DROP VIEW IF EXISTS view_user;
73DROP VIEW IF EXISTS view_dc_type;
74DROP VIEW IF EXISTS view_message;
75DROP VIEW IF EXISTS view_link_dcs_access;
76DROP VIEW IF EXISTS view_dcs_access;
77DROP VIEW IF EXISTS view_dc_access;
78DROP VIEW IF EXISTS view_cr_submission_group;
79DROP VIEW IF EXISTS view_cr_decision_group_tdg;
80DROP VIEW IF EXISTS view_cr_decision_group_dcrb;
81
82-- functions
83
84DROP FUNCTION IF EXISTS get_dc_identifier(id integer);
85DROP FUNCTION IF EXISTS get_dc_name_status_language(id integer,name varchar,status varchar);
86DROP FUNCTION IF EXISTS get_dc_name_status(id integer,status varchar);
87DROP FUNCTION IF EXISTS get_dc_name(id integer) CASCADE;
88DROP FUNCTION IF EXISTS get_dc_type(dc integer) CASCADE;
89DROP FUNCTION IF EXISTS pid(dcif integer) CASCADE;
90DROP FUNCTION IF EXISTS profile_path(prof integer) CASCADE;
91DROP FUNCTION IF EXISTS profile_self_or_descendants(prof integer) CASCADE;
92DROP FUNCTION IF EXISTS profile_ancestors(integer) CASCADE;
93DROP FUNCTION IF EXISTS dc_profiles(dc integer) CASCADE;
94DROP FUNCTION IF EXISTS dcs_self_or_descendants(dcs integer) CASCADE;
95DROP FUNCTION IF EXISTS user_name(uid integer) CASCADE;
96DROP FUNCTION IF EXISTS concat(text, text) CASCADE;
97DROP FUNCTION IF EXISTS merge_accounts(keep integer, remove integer) CASCADE;
98DROP FUNCTION IF EXISTS dc_super_cycle(path integer[],super integer) CASCADE;
99
100DROP AGGREGATE IF EXISTS concat(text) CASCADE;
101
102-- triggers and trigger functions
103
104--DROP TRIGGER IF EXISTS core_data_category_delete_generic_text ON core_data_category;
105--DROP TRIGGER IF EXISTS core_language_section_delete_generic_text ON core_language_section;
106--DROP TRIGGER IF EXISTS core_linguistic_section_delete_generic_text ON core_linguistic_section;
107--DROP TRIGGER IF EXISTS generic_text_delete_generic_text ON generic_text;
108
109DROP FUNCTION IF EXISTS delete_generic_text();
110
111--DROP TRIGGER IF EXISTS core_data_category_delete_generic_name ON core_data_category;
112--DROP TRIGGER IF EXISTS core_language_section_delete_generic_name ON core_language_section;
113
114DROP FUNCTION IF EXISTS delete_generic_name();
115
116DROP FUNCTION IF EXISTS update_search_identifier();
117DROP FUNCTION IF EXISTS update_search_name();
118DROP FUNCTION IF EXISTS update_search_text();
119DROP FUNCTION IF EXISTS prevent_super_cycle();
Note: See TracBrowser for help on using the repository browser.