Part 2...
[code]-- -- Table structure for table `sys_man_audits` --
DROP TABLE IF EXISTS `sys_man_audits`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_man_audits` ( `system_audits_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `system_audits_username` varchar(45) NOT NULL default '', `system_audits_type` varchar(45) NOT NULL default '', `system_audits_time` varchar(45) NOT NULL default '', `system_audits_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`system_audits_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_man_audits_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_man_change` --
DROP TABLE IF EXISTS `sys_man_change`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_man_change` ( `system_change_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `system_change_date` datetime NOT NULL default '0000-00-00 00:00:00', `system_change_short_desc` varchar(200) NOT NULL default '', `system_change_detailed_desc` varchar(200) NOT NULL default '', `system_change_authorising_person` varchar(45) NOT NULL default '', `system_change_reason` varchar(200) NOT NULL default '', `system_change_potential_issues` varchar(200) NOT NULL default '', `system_change_backout_plan` varchar(200) NOT NULL default '', `system_change_callid` int(10) unsigned NOT NULL default '0', `system_change_call_techid` int(10) unsigned NOT NULL default '0', `system_change_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`system_change_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_man_change_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_man_change_log` --
DROP TABLE IF EXISTS `sys_man_change_log`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_man_change_log` ( `system_change_log_id` int(10) unsigned NOT NULL auto_increment, `system_change_id` int(10) unsigned NOT NULL default '0', `system_change_log_attachmentid` int(10) unsigned NOT NULL default '0', `system_change_log_call_techid` int(10) unsigned NOT NULL default '0', `system_change_log_date` datetime NOT NULL default '0000-00-00 00:00:00', `system_change_log_comments` varchar(200) NOT NULL default '', PRIMARY KEY (`system_change_log_id`), KEY `system_change_id` (`system_change_id`), CONSTRAINT `sys_man_change_log_system_change_id` FOREIGN KEY (`system_change_id`) REFERENCES `sys_man_change` (`system_change_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_man_invoice` --
DROP TABLE IF EXISTS `sys_man_invoice`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_man_invoice` ( `invoice_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `invoice_filename` varchar(100) NOT NULL default '', `invoice_image` blob, PRIMARY KEY (`invoice_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_man_invoice_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_man_notes` --
DROP TABLE IF EXISTS `sys_man_notes`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_man_notes` ( `notes_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `user_id` int(10) unsigned default NULL, `notes_title` varchar(200) NOT NULL default '', `notes_text` text NOT NULL default '', `notes_timestamp` varchar(200) NOT NULL default '', PRIMARY KEY (`notes_id`), KEY `system_id` (`system_id`), KEY `user_id` (`user_id`), CONSTRAINT `sys_man_notes_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`), CONSTRAINT `sys_man_notes_user_id` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_man_passwords` --
DROP TABLE IF EXISTS `sys_man_passwords`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_man_passwords` ( `passwords_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `passwords_application` varchar(100) NOT NULL default '', `passwords_password` varchar(100) NOT NULL default '', `passwords_user` varchar(100) NOT NULL default '', PRIMARY KEY (`passwords_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_man_passwords_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_antivirus` --
DROP TABLE IF EXISTS `sys_sw_antivirus`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_antivirus` ( `virus_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `virus_manufacturer` varchar(150) NOT NULL default '', `virus_version` varchar(45) NOT NULL default '', `virus_name` varchar(100) NOT NULL default '', `virus_uptodate` varchar(45) NOT NULL default '', `virus_def_date` date NOT NULL default '0000-00-00', `virus_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `virus_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`virus_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_antivirus_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_environment_variable` --
DROP TABLE IF EXISTS `sys_sw_environment_variable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_environment_variable` ( `env_var_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `env_var_name` varchar(50) NOT NULL default '', `env_var_value` varchar(250) NOT NULL default '', `env_var_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `env_var_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`env_var_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_environment_variable_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_event_log` --
DROP TABLE IF EXISTS `sys_sw_event_log`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_event_log` ( `evt_log_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `evt_log_name` varchar(50) NOT NULL default '', `evt_log_file_name` varchar(100) NOT NULL default '', `evt_log_file_size` int(10) NOT NULL default '0', `evt_log_max_file_size` int(10) NOT NULL default '0', `evt_log_overwrite` varchar(30) NOT NULL default '', `evt_log_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `evt_log_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`evt_log_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_event_log_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_firewall` --
DROP TABLE IF EXISTS `sys_sw_firewall`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_firewall` ( `firewall_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `firewall_enabled_domain` varchar(45) NOT NULL default '', `firewall_disablenotifications_domain` varchar(45) NOT NULL default '', `firewall_donotallowexceptions_domain` varchar(45) NOT NULL default '', `firewall_enabled_standard` varchar(45) NOT NULL default '', `firewall_disablenotifications_standard` varchar(45) NOT NULL default '', `firewall_donotallowexceptions_standard` varchar(45) NOT NULL default '', `firewall_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `firewall_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`firewall_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_firewall_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_firewall_auth_app` --
DROP TABLE IF EXISTS `sys_sw_firewall_auth_app`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_firewall_auth_app` ( `firewall_app_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `firewall_app_name` varchar(100) NOT NULL default '', `firewall_app_executable` varchar(200) NOT NULL default '', `firewall_app_remote_address` varchar(45) NOT NULL default '', `firewall_app_enabled` varchar(45) NOT NULL default '', `firewall_app_profile` varchar(45) NOT NULL default '', `firewall_app_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `firewall_app_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`firewall_app_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_firewall_auth_app_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_firewall_ports` --
DROP TABLE IF EXISTS `sys_sw_firewall_ports`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_firewall_ports` ( `port_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `port_number` int(10) unsigned NOT NULL default '0', `port_protocol` varchar(45) NOT NULL default '', `port_scope` varchar(45) NOT NULL default '', `port_enabled` varchar(45) NOT NULL default '', `port_profile` varchar(45) NOT NULL default '', `port_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `port_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`port_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_firewall_ports_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_groups` --
DROP TABLE IF EXISTS `sys_sw_groups`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_groups` ( `groups_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `groups_description` varchar(200) NOT NULL default '', `groups_name` varchar(100) NOT NULL default '', `groups_members` varchar(100) NOT NULL default '', `groups_sid` varchar(100) NOT NULL default '', `groups_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `groups_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`groups_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_groups_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_groups_details` --
DROP TABLE IF EXISTS `sys_sw_groups_details`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_groups_details` ( `gd_name` varchar(100) NOT NULL default '', `gd_description` varchar(200) NOT NULL default '', PRIMARY KEY (`gd_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_ip_route` --
DROP TABLE IF EXISTS `sys_sw_ip_route`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_ip_route` ( `ip_route_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `ip_route_destination` varchar(20) NOT NULL default '', `ip_route_mask` varchar(20) NOT NULL default '', `ip_route_metric` varchar(10) NOT NULL default '', `ip_route_next_hop` varchar(20) NOT NULL default '', `ip_route_protocol` varchar(10) NOT NULL default '', `ip_route_type` varchar(10) NOT NULL default '', `ip_route_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `ip_route_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ip_route_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_ip_route_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_manual_software` --
DROP TABLE IF EXISTS `sys_sw_manual_software`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_manual_software` ( `man_soft_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `man_soft_det_id` int(10) unsigned NOT NULL default '0', `man_soft_version` varchar(45) NOT NULL default '', `man_soft_filesize` int(10) unsigned NOT NULL default '0', `man_soft_date_detected` date NOT NULL default '0000-00-00', `man_soft_date_first_detected` date NOT NULL default '0000-00-00', PRIMARY KEY (`man_soft_id`), KEY `sys_sw_manual_software_system_id` (`system_id`), CONSTRAINT `sys_sw_manual_software_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_manual_software_detection` --
DROP TABLE IF EXISTS `sys_sw_manual_software_detection`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_manual_software_detection` ( `man_soft_det_id` int(10) unsigned NOT NULL auto_increment, `man_soft_det_dir` varchar(45) NOT NULL default '', `man_soft_det_file` varchar(45) NOT NULL default '', `man_soft_det_name` varchar(45) NOT NULL default '', `man_soft_det_comments` varchar(45) NOT NULL default '', PRIMARY KEY (`man_soft_det_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_mapped` --
DROP TABLE IF EXISTS `sys_sw_mapped`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_mapped` ( `mapped_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `mapped_device_id` varchar(100) NOT NULL default '', `mapped_file_system` varchar(100) NOT NULL default '', `mapped_provider_name` varchar(100) NOT NULL default '', `mapped_free_space` int(10) unsigned NOT NULL default '0', `mapped_size` int(10) unsigned NOT NULL default '0', `mapped_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `mapped_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`mapped_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_mapped_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_media` --
DROP TABLE IF EXISTS `sys_sw_media`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_media` ( `media_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `media_type` varchar(45) NOT NULL default '', `media_file` varchar(250) NOT NULL default '', `media_size` int(10) unsigned NOT NULL default '0', `media_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`media_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_media_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_pagefile` --
DROP TABLE IF EXISTS `sys_sw_pagefile`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_pagefile` ( `pagefile_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `pagefile_name` varchar(100) NOT NULL default '', `pagefile_initial_size` int(10) NOT NULL default '0', `pagefile_max_size` int(10) NOT NULL default '0', `pagefile_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `pagefile_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`pagefile_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_pagefile_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_scheduled_task` --
DROP TABLE IF EXISTS `sys_sw_scheduled_task`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_scheduled_task` ( `sched_task_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `sched_task_name` varchar(100) NOT NULL default '', `sched_task_next_run` varchar(50) NOT NULL default '', `sched_task_status` varchar(50) NOT NULL default '', `sched_task_last_run` varchar(50) NOT NULL default '', `sched_task_last_result` varchar(50) NOT NULL default '', `sched_task_creator` varchar(50) NOT NULL default '', `sched_task_schedule` varchar(100) NOT NULL default '', `sched_task_task` varchar(100) NOT NULL default '', `sched_task_state` varchar(10) NOT NULL default '', `sched_task_runas` varchar(50) NOT NULL default '', `sched_task_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `sched_task_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`sched_task_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_scheduled_task_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_service` --
DROP TABLE IF EXISTS `sys_sw_service`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_service` ( `service_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `service_display_name` varchar(100) NOT NULL default '', `service_name` varchar(100) NOT NULL default '', `service_path_name` varchar(200) NOT NULL default '', `service_started` varchar(10) NOT NULL default '', `service_start_mode` varchar(10) NOT NULL default '', `service_state` varchar(10) NOT NULL default '', `service_count` varchar(5) NOT NULL default '', `service_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `service_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`service_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_service_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_service_details` --
DROP TABLE IF EXISTS `sys_sw_service_details`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_service_details` ( `sd_display_name` varchar(100) NOT NULL default '', `sd_description` varchar(200) NOT NULL default '', PRIMARY KEY (`sd_display_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_shares` --
DROP TABLE IF EXISTS `sys_sw_shares`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_shares` ( `shares_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `shares_caption` varchar(100) NOT NULL default '', `shares_name` varchar(100) NOT NULL default '', `shares_path` varchar(100) NOT NULL default '', `shares_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `shares_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`shares_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_shares_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_software` --
DROP TABLE IF EXISTS `sys_sw_software`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_software` ( `software_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `software_name` varchar(256) NOT NULL default '', `software_version` varchar(256) NOT NULL default '', `software_location` varchar(256) NOT NULL default '', `software_uninstall` mediumtext NOT NULL, `software_install_date` varchar(100) NOT NULL default '', `software_publisher` varchar(256) NOT NULL default '', `software_install_source` varchar(200) NOT NULL default '', `software_system_component` varchar(2) NOT NULL default '', `software_url` varchar(256) NOT NULL default '', `software_email` varchar(256) NOT NULL default '', `software_comment` varchar(200) NOT NULL default '', `software_man_comment` varchar(200) NOT NULL default '', `software_count` varchar(5) NOT NULL default '', `software_code_base` varchar(256) NOT NULL default '', `software_status` varchar(45) NOT NULL default '', `software_key` varchar(45) NOT NULL default '', `software_key_release` varchar(45) NOT NULL default '', `software_key_edition` varchar(45) NOT NULL default '', `software_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `software_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`software_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_software_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_startup` --
DROP TABLE IF EXISTS `sys_sw_startup`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_startup` ( `startup_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `startup_caption` varchar(200) NOT NULL default '', `startup_name` varchar(100) NOT NULL default '', `startup_command` varchar(200) NOT NULL default '', `startup_description` varchar(200) NOT NULL default '', `startup_location` varchar(200) NOT NULL default '', `startup_user` varchar(100) NOT NULL default '', `startup_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `startup_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`startup_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_startup_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_system_security` --
DROP TABLE IF EXISTS `sys_sw_system_security`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_system_security` ( `ss_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `ss_qno` varchar(45) NOT NULL default '', `ss_status` varchar(45) NOT NULL default '', `ss_reason` varchar(200) NOT NULL default '', `ss_product` varchar(45) NOT NULL default '', `ss_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `ss_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ss_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_system_security_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_system_security_bulletins` --
DROP TABLE IF EXISTS `sys_sw_system_security_bulletins`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_system_security_bulletins` ( `ssb_title` varchar(200) NOT NULL default '', `ssb_description` text NOT NULL, `ssb_bulletin` varchar(45) NOT NULL default '', `ssb_qno` varchar(45) NOT NULL default '', `ssb_url` varchar(100) NOT NULL default '', PRIMARY KEY (`ssb_qno`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_users` --
DROP TABLE IF EXISTS `sys_sw_users`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_users` ( `users_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `users_disabled` varchar(20) NOT NULL default '', `users_full_name` varchar(100) NOT NULL default '', `users_name` varchar(100) NOT NULL default '', `users_password_changeable` varchar(20) NOT NULL default '', `users_password_expires` varchar(20) NOT NULL default '', `users_password_required` varchar(20) NOT NULL default '', `users_sid` varchar(100) NOT NULL default '', `users_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `users_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`users_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_users_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_users_detail` --
DROP TABLE IF EXISTS `sys_sw_users_detail`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_users_detail` ( `ud_name` varchar(100) NOT NULL default '', `ud_description` varchar(200) NOT NULL default '', PRIMARY KEY (`ud_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_web_server` --
DROP TABLE IF EXISTS `sys_sw_web_server`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_web_server` ( `ws_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `ws_site` int(10) unsigned NOT NULL default '0', `ws_server_type` varchar(100) NOT NULL default '', `ws_description` varchar(100) NOT NULL default '', `ws_logging_enabled` varchar(100) NOT NULL default '', `ws_logging_dir` varchar(100) NOT NULL default '', `ws_logging_format` varchar(100) NOT NULL default '', `ws_logging_time_period` varchar(100) NOT NULL default '', `ws_home_directory` varchar(100) NOT NULL default '', `ws_directory_browsing` varchar(100) NOT NULL default '', `ws_default_documents` varchar(100) NOT NULL default '', `ws_secure_ip` varchar(100) NOT NULL default '', `ws_secure_port` varchar(100) NOT NULL default '', `ws_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `ws_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ws_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_web_server_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_web_server_ip` --
DROP TABLE IF EXISTS `sys_sw_web_server_ip`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_web_server_ip` ( `ws_ip_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `ws_ip_site` varchar(100) NOT NULL default '', `ws_ip_address` varchar(30) NOT NULL default '', `ws_ip_port` varchar(100) NOT NULL default '', `ws_ip_host_header` varchar(100) NOT NULL default '', `ws_ip_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `ws_ip_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ws_ip_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_web_server_ip_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_web_server_vd` --
DROP TABLE IF EXISTS `sys_sw_web_server_vd`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_web_server_vd` ( `ws_vd_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `ws_vd_site` varchar(100) NOT NULL default '', `ws_vd_name` varchar(100) NOT NULL default '', `ws_vd_path` varchar(100) NOT NULL default '', `ws_vd_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `ws_vd_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ws_vd_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_web_server_vd_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `sys_sw_windows` --
DROP TABLE IF EXISTS `sys_sw_windows`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sys_sw_windows` ( `windows_id` int(10) unsigned NOT NULL auto_increment, `system_id` int(10) unsigned default NULL, `windows_build_number` varchar(20) NOT NULL default '', `windows_user_name` varchar(100) NOT NULL default '', `windows_client_site_name` varchar(100) NOT NULL default '', `windows_domain_controller_address` varchar(100) NOT NULL default '', `windows_domain_controller_name` varchar(100) NOT NULL default '', `windows_domain_role` varchar(40) NOT NULL default '', `windows_part_of_domain` varchar(10) NOT NULL default '', `windows_id_number` varchar(100) NOT NULL default '', `windows_time_caption` varchar(100) NOT NULL default '', `windows_time_daylight` varchar(100) NOT NULL default '', `windows_boot_device` varchar(100) NOT NULL default '', `windows_country_code` varchar(50) NOT NULL default '', `windows_organisation` varchar(80) NOT NULL default '', `windows_language` varchar(50) NOT NULL default '', `windows_registered_user` varchar(50) NOT NULL default '', `windows_service_pack` varchar(20) NOT NULL default '', `windows_version` varchar(20) NOT NULL default '', `windows_install_directory` varchar(20) NOT NULL default '', `windows_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `windows_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`windows_id`), KEY `system_id` (`system_id`), CONSTRAINT `sys_sw_windows_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
-- -- Table structure for table `system` --
DROP TABLE IF EXISTS `system`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `system` ( `system_id` int(10) unsigned NOT NULL auto_increment, `system_key` varchar(200) NOT NULL default '', `uuid` varchar(100) NOT NULL default '', `mac_address` varchar(17) NOT NULL default '', `ip_address` varchar(30) NOT NULL default '', `hostname` varchar(100) NOT NULL default '', `domain` varchar(100) NOT NULL default '', `description` varchar(100) NOT NULL default '', `type` varchar(50) NOT NULL default '', `icon` varchar(50) NOT NULL default '', `os` varchar(50) NOT NULL default '', `os_short_name` varchar(50) NOT NULL default '', `os_full_name` varchar(100) NOT NULL default '', `os_version` varchar(50) NOT NULL default '', `linked_sys` int(10) NOT NULL default '0', `serial` varchar(50) NOT NULL default '', `model` varchar(50) NOT NULL default '', `manufacturer` varchar(50) NOT NULL default '', `form_factor` varchar(50) NOT NULL default '', `pc_memory` int(10) NOT NULL default '0', `pc_num_processor` int(10) NOT NULL default '0', `pc_date_os_installation` date NOT NULL default '1970-01-01', `printer_port_name` varchar(50) NOT NULL default '', `printer_shared` varchar(50) NOT NULL default '', `printer_shared_name` varchar(50) NOT NULL default '', `man_acting_server` varchar(3) NOT NULL default '', `man_status` ENUM('production', 'retired', 'maintenance', 'deleted') NOT NULL default 'production', `man_environment` ENUM('production', 'test', 'uat', 'dev', 'eval', 'DR') NOT NULL default 'production', `man_criticality` ENUM('critical', 'normal', 'low') NOT NULL default 'critical', `man_description` varchar(100) NOT NULL default '', `man_type` varchar(100) NOT NULL default '', `man_ip_address` varchar(30) NOT NULL default '', `man_location_name` varchar(100) NOT NULL default '', `man_location_address` varchar(100) NOT NULL default '', `man_location_city` varchar(100) NOT NULL default '', `man_location_state` varchar(100) NOT NULL default '', `man_location_country` varchar(100) NOT NULL default '', `man_location_room` varchar(100) NOT NULL default '', `man_location_rack` varchar(100) NOT NULL default '', `man_serial` varchar(50) NOT NULL default '', `man_asset_number` varchar(50) NOT NULL default '', `man_model` varchar(50) NOT NULL default '', `man_manufacturer` varchar(50) NOT NULL default '', `man_form_factor` varchar(50) NOT NULL default '', `man_icon` varchar(50) NOT NULL default '', `man_vendor` varchar(150) NOT NULL default '', `man_vm_server_name` varchar(150) NOT NULL default '', `man_vm_system_id` varchar(150) NOT NULL default '', `man_vm_group` varchar(150) NOT NULL default '', `man_cluster_name` varchar(150) NOT NULL default '', `man_purchase_order_number` varchar(50) NOT NULL default '', `man_purchase_vendor` varchar(100) NOT NULL default '', `man_purchase_invoice` varchar(100) NOT NULL default '', `man_purchase_date` date NOT NULL default '0000-00-00', `man_purchase_amount` varchar(50) NOT NULL default '', `man_warranty_duration` int(5) unsigned NOT NULL default '0', `man_warranty_expires` date NOT NULL default '0000-00-00', `man_warranty_type` ENUM('', '24x7x365', '9x5x5', 'Next Business Day') NOT NULL default '', `man_terminal_number` int(10) NOT NULL default '0', `man_switch_id` varchar(100) NOT NULL default '', `man_switch_port` varchar(100) NOT NULL default '', `man_ethernet_socket` varchar(45) NOT NULL default '', `man_wall_port` varchar(100) NOT NULL default '', `man_picture` varchar(100) NOT NULL default '', `man_contact_name` varchar(100) NOT NULL default '', `man_contact_organisation` varchar(100) NOT NULL default '', `man_contact_phone_number` varchar(20) NOT NULL default '', `man_contact_address` varchar(100) NOT NULL default '', `man_contact_city` varchar(100) NOT NULL default '', `man_contact_state` varchar(100) NOT NULL default '', `man_contact_country` varchar(100) NOT NULL default '', `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`system_id`), KEY `id` (`timestamp`), KEY `id2` (`system_key`), KEY `id3` (`ip_address`), KEY `system_id` (`system_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client;
LOCK TABLES `oa_config` WRITE; INSERT INTO `oa_config` VALUES ('oa_debug','off'); UNLOCK TABLES;
LOCK TABLES `oa_group` WRITE;
INSERT INTO `oa_group` VALUES (1,'All','s','',1,'Administrator','All','','','','','','',0);
INSERT INTO `oa_group` VALUES (10,'DNS Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE sys_sw_software.software_name = \'bind9\' AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','DNS','','','','','','',0);
INSERT INTO `oa_group` VALUES (11,'DHCP Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE sys_sw_software.software_name = \'DHCP\' AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','DHCP','','','','','','',0);
INSERT INTO `oa_group` VALUES (12,'Web Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE (sys_sw_software.software_name LIKE \'apache%\' OR sys_sw_software.software_name = \'IIS\') AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','Web','','','','','','',0);
INSERT INTO `oa_group` VALUES (13,'Database Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE (sys_sw_software.software_name LIKE \'SQL Server%\' OR sys_sw_software.software_name LIKE \'mysql-server%\') AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','Database','','','','','','',0);
INSERT INTO `oa_group` VALUES (14,'SSH Servers','d','SELECT distinct(system.system_id) FROM system, sys_sw_software WHERE sys_sw_software.software_name = \'openssh-server\' AND system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.software_timestamp AND system.man_status = \'production\'',1,'Administrator','SSH','','','','','','',0);
INSERT INTO `oa_group` VALUES (15,'Windows Systems','d','SELECT distinct(system.system_id) FROM system WHERE system.os = \'windows\' AND system.man_status = \'production\'',1,'Administrator','Windows','','','','','','',0);
INSERT INTO `oa_group` VALUES (16,'Linux Systems','d','SELECT distinct(system.system_id) FROM system WHERE system.os = \'linux\' AND system.man_status = \'production\'',1,'Administrator','Linux','','','','','','',0);
ALTER TABLE `oa_group` AUTO_INCREMENT = 1000;
UNLOCK TABLES;
LOCK TABLES `oa_group_user` WRITE; INSERT INTO `oa_group_user` VALUES (1,1,1,10); INSERT INTO `oa_group_user` VALUES (2,1,10,10); INSERT INTO `oa_group_user` VALUES (3,1,11,10); INSERT INTO `oa_group_user` VALUES (4,1,12,10); INSERT INTO `oa_group_user` VALUES (5,1,13,10); INSERT INTO `oa_group_user` VALUES (6,1,14,10); INSERT INTO `oa_group_user` VALUES (7,1,15,10); INSERT INTO `oa_group_user` VALUES (8,1,16,10); UNLOCK TABLES;
LOCK TABLES `oa_user` WRITE; INSERT INTO `oa_user` VALUES (1,'admin','5f4dcc3b5aa765d61d8327deb882cf99','Administrator',NULL,'en',10,'default'); UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
[/code]
_________________ Support and Development hours available from [url=https://opmantek.com]Opmantek[/url]. Please consider a purchase to help make Open-AudIT better for everyone.
|