This repository has been archived by the owner on Jul 3, 2022. It is now read-only.
/
drop.sql
28 lines (26 loc) · 1.56 KB
/
drop.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
/** Delete all triggers **/
DROP TRIGGER IF EXISTS update_cache_characters_insert;
DROP TRIGGER IF EXISTS update_cache_quests_update;
DROP TRIGGER IF EXISTS update_cache_quests_characters_insert;
DROP TRIGGER IF EXISTS update_cache_quests_characters_update;
DROP TRIGGER IF EXISTS update_cache_quests_characters_delete;
DROP TRIGGER IF EXISTS update_cache_charactergroups_insert;
DROP TRIGGER IF EXISTS update_cache_charactergroupsquests_update;
DROP TRIGGER IF EXISTS update_cache_charactergroupsquests_groups_insert;
DROP TRIGGER IF EXISTS update_cache_charactergroupsquests_groups_update;
DROP TRIGGER IF EXISTS update_cache_charactergroupsquests_groups_delete;
DROP TRIGGER IF EXISTS update_cache_characters_charactergroups_insert;
DROP TRIGGER IF EXISTS update_cache_characters_charactergroups_update;
DROP TRIGGER IF EXISTS update_cache_characters_charactergroups_delete;
DROP TRIGGER IF EXISTS update_cache_cache_charactergroups_insert;
DROP TRIGGER IF EXISTS update_cache_cache_charactergroups_update;
DROP TRIGGER IF EXISTS update_cache_characters_xplevels_insert;
DROP TRIGGER IF EXISTS update_cache_characters_xplevels_update;
DROP TRIGGER IF EXISTS update_cache_characters_xplevels_delete;
/** Delete all routines **/
DROP PROCEDURE IF EXISTS update_cache_characters_quest;
DROP PROCEDURE IF EXISTS update_cache_characters_charactergroup;
DROP PROCEDURE IF EXISTS update_cache_characters;
DROP PROCEDURE IF EXISTS update_cache_characters_xplevels;
DROP PROCEDURE IF EXISTS update_cache_charactergroups_charactergroupsquest;
DROP PROCEDURE IF EXISTS update_cache_charactergroups;