Subversion Repositories computer_asset_manager_v1

Rev

Blame | Last modification | View Log | Download | RSS feed 

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