Subversion Repositories computer_asset_manager_v1

delete from installed_packages;
delete from software_version;
delete from software;
delete from device where device_type_id in (select device_type_id from device_type where name = 'PCI Card');
delete from device where device_id > 3000;
delete from sysinfo_report;
delete from maintenance_performed;
delete from maintenance_schedule;
delete from backups;
delete from backups_run;
delete from backups_server;
delete from backups_usage;
delete from disk_info;
delete from disk_space;
delete from network;
delete from pci_attribute;
delete from pci_device;
delete from unknown_entry;