clean.sql
1.44 KB
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
DELETE FROM "oa_mail_account";
DELETE FROM "oa_mail_provider";
DELETE FROM "oa_attendance";
DELETE FROM "oa_announcement_receiver";
DELETE FROM "oa_announcement";
DELETE FROM "oa_task_log";
DELETE FROM "oa_task_receiver";
DELETE FROM "oa_task";
DELETE FROM "oa_vote_record";
DELETE FROM "oa_vote_option";
DELETE FROM "oa_discussion_like";
DELETE FROM "oa_discussion_reply";
DELETE FROM "oa_discussion";
DELETE FROM "oa_contact_share";
DELETE FROM "oa_contact";
DELETE FROM "oa_contact_category";
DELETE FROM "oa_note_receiver";
DELETE FROM "oa_note";
DELETE FROM "oa_note_category";
DELETE FROM "oa_plan";
DELETE FROM "oa_work_report";
DELETE FROM "oa_schedule_participant";
DELETE FROM "oa_schedule";
DELETE FROM oa_mail_message;
DELETE FROM oa_mail_folder;
DELETE FROM oa_seal_apply;
DELETE FROM oa_seal;
DELETE FROM oa_file_node;
DELETE FROM oa_file_permission;
DELETE FROM oa_file_favorite;
DELETE FROM oa_vehicle_apply;
DELETE FROM oa_vehicle_return;
DELETE FROM oa_vehicle;
DELETE FROM oa_supply_apply_item;
DELETE FROM oa_supply_apply;
DELETE FROM oa_supply_item;
DELETE FROM "oa_meeting_room_booking";
DELETE FROM "oa_meeting_room";
DELETE FROM oa_reimbursement;
DELETE FROM oa_overtime_apply;
DELETE FROM oa_leave_apply;
DELETE FROM oa_regular_apply;
DELETE FROM oa_resign_apply;
DELETE FROM "oa_official_doc_receive";
DELETE FROM "oa_official_doc_send";
DELETE FROM "oa_official_doc_template";
DELETE FROM oa_travel_apply;
DELETE FROM oa_travel_reimbursement;