/
postgresql.sql
77 lines (77 loc) · 4.38 KB
/
postgresql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
CREATE OR REPLACE FUNCTION cleanupTestDatabase()
RETURNS INTEGER AS $$
BEGIN
TRUNCATE TABLE m_object_text_info RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_operation_execution RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_sequence RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_acc_cert_wi_reference RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_acc_cert_wi RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_acc_cert_case RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_acc_cert_campaign RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_acc_cert_definition RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_audit_ref_value RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_audit_prop_value RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_audit_delta RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_audit_item RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_audit_event RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_ext_date RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_ext_long RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_ext_string RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_ext_poly RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_ext_reference RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_ext_boolean RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_reference RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_ext_date RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_ext_long RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_ext_poly RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_ext_reference RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_ext_string RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_ext_boolean RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_extension RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_reference RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment_policy_situation RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_assignment RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_connector_target_system RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_connector RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_connector_host RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_lookup_table_row RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_lookup_table RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_node RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_shadow RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_task_dependent RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_task RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_template RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_value_policy RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_resource RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_user_employee_type RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_user_organization RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_user_organizational_unit RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_focus_photo RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_focus_policy_situation RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_user RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_report RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_report_output RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_org_org_type RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_org_closure RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_org RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_role RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_service_type RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_service RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_abstract_role RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_system_configuration RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_generic_object RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_trigger RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_focus RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_security_policy RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_form RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_case_wi_reference RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_case_wi RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_case RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_function_library RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_ext_item RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_subtype RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object_collection RESTART IDENTITY CASCADE;
TRUNCATE TABLE m_object RESTART IDENTITY CASCADE;
RETURN 0;
END;
$$ LANGUAGE plpgsql;