| 1 |
rodolico |
1 |
-- Remove all tables and entries associated with the maintenance module
|
|
|
2 |
DROP TABLE IF EXISTS `maintenance_schedule`;
|
|
|
3 |
DROP TABLE IF EXISTS `maintenance_performed`;
|
|
|
4 |
DROP TABLE IF EXISTS `maintenance_task`;
|
|
|
5 |
delete from _system where group_name = 'Modules' and key_name = 'Maintenance';
|
|
|
6 |
delete from menu where parent_id = (select menu_id from menu where parent_id is null and caption = 'Maintenance');
|
|
|
7 |
delete from menu where parent_id is null and caption = 'Maintenance';
|
|
|
8 |
delete from report where name in ('Maintenance Due','Device Maintenance Record','Maintenance Performed in Period');
|