Below is a current dump of the MySQL structure. If anyone wishes to hack the script above, please try to use field names from this.
[code]-- MySQL dump 10.11
--
-- Host: localhost Database: oanew
-- ------------------------------------------------------
-- Server version 5.0.51a-3ubuntu5.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `oa_alert_log`
--
DROP TABLE IF EXISTS `oa_alert_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_alert_log` (
`alert_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`alert_table` varchar(50) NOT NULL,
`alert_foreign_row` int(10) NOT NULL,
`alert_details` varchar(200) NOT NULL,
`user_id` int(10) unsigned default NULL,
`alert_ack_time` datetime NOT NULL default '0000-00-00 00:00:00',
`alert_note` varchar(200) NOT NULL,
`system_change_id` int(10) unsigned default NULL,
`alert_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`alert_id`),
KEY `system_id` (`system_id`),
KEY `oa_alert_log_user_id` (`user_id`),
KEY `oa_alert_change_id` (`system_change_id`),
CONSTRAINT `id_1` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`),
CONSTRAINT `id_2` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`),
CONSTRAINT `id_3` 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 `oa_audit_log`
--
DROP TABLE IF EXISTS `oa_audit_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_audit_log` (
`audit_log_id` int(10) NOT NULL auto_increment,
`user_id` int(10) unsigned default '0',
`system_id` int(10) unsigned default NULL,
`audit_log_event_type` varchar(50) NOT NULL,
`audit_log_event_details` varchar(200) NOT NULL,
`audit_log_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`audit_log_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `oa_audit_log_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`),
CONSTRAINT `oa_audit_log_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 `oa_config`
--
DROP TABLE IF EXISTS `oa_config`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_config` (
`config_name` varchar(45) NOT NULL default '',
`config_value` varchar(45) NOT NULL default '',
PRIMARY KEY (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `oa_group`
--
DROP TABLE IF EXISTS `oa_group`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group` (
`group_id` int(10) unsigned NOT NULL auto_increment,
`group_name` varchar(100) NOT NULL,
`group_type` varchar(1) NOT NULL,
`group_dynamic_select` text NOT NULL,
`group_parent` int(10) NOT NULL default '1',
`group_contact` varchar(50) NOT NULL,
`group_description` varchar(255) NOT NULL,
`group_category` varchar(50) NOT NULL,
`group_phone` varchar(20) NOT NULL,
`group_fax` varchar(20) NOT NULL,
`group_address` varchar(200) NOT NULL,
`group_city` varchar(50) NOT NULL,
`group_state` varchar(3) NOT NULL,
`group_postcode` int(6) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `oa_group_gateway`
--
DROP TABLE IF EXISTS `oa_group_gateway`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group_gateway` (
`group_gateway_id` int(10) NOT NULL auto_increment,
`group_id` int(10) NOT NULL,
`system_id` int(10) unsigned default NULL,
`group_gateway_link_type` varchar(100) NOT NULL,
`group_gateway_ip_address_internal` varchar(30) NOT NULL,
`group_gateway_ip_address_external` varchar(30) NOT NULL,
`group_gateway_connecting_group` int(10) NOT NULL,
PRIMARY KEY (`group_gateway_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_group_gateway_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 `oa_group_sys`
--
DROP TABLE IF EXISTS `oa_group_sys`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group_sys` (
`group_sys_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`group_id` int(10) unsigned default NULL,
`group_sys_type` varchar(20) NOT NULL,
PRIMARY KEY (`group_sys_id`),
KEY `system_id` (`system_id`),
KEY `group_id` (`group_id`),
CONSTRAINT `oa_group_sys_group_id` FOREIGN KEY (`group_id`) REFERENCES `oa_group` (`group_id`),
CONSTRAINT `oa_group_sys_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 `oa_group_user`
--
DROP TABLE IF EXISTS `oa_group_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_group_user` (
`group_user_id` int(10) NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL,
`group_id` int(10) unsigned NOT NULL,
`group_user_access_level` int(10) NOT NULL,
PRIMARY KEY (`group_user_id`),
KEY `user_id` (`user_id`),
KEY `group_id` (`group_id`),
CONSTRAINT `oa_group_user_group_id` FOREIGN KEY (`group_id`) REFERENCES `oa_group` (`group_id`),
CONSTRAINT `oa_group_user_user_id` FOREIGN KEY (`user_id`) REFERENCES `oa_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `oa_net_nmap_ports`
--
DROP TABLE IF EXISTS `oa_net_nmap_ports`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_nmap_ports` (
`nmap_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`nmap_port_number` int(10) unsigned NOT NULL default '0',
`nmap_port_proto` varchar(10) NOT NULL default '',
`nmap_port_name` varchar(45) NOT NULL default '',
`nmap_port_version` varchar(100) NOT NULL default '',
`nmap_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`nmap_id`),
KEY `system_id` (`system_id`),
KEY `id2` (`nmap_port_number`),
KEY `id3` (`nmap_port_proto`),
CONSTRAINT `oa_net_nmap_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 `oa_net_scan_latest`
--
DROP TABLE IF EXISTS `oa_net_scan_latest`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_scan_latest` (
`scan_latest_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scan_latest_ip_address` varchar(30) NOT NULL,
`scan_latest_type` varchar(10) NOT NULL,
`scan_latest_detail` varchar(100) NOT NULL,
`scan_latest_frequency` tinyint(4) NOT NULL,
`scan_latest_date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`scan_latest_result` varchar(20) NOT NULL,
`scan_latest_success` varchar(2) NOT NULL,
PRIMARY KEY (`scan_latest_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_net_scan_latest_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 `oa_net_scan_log`
--
DROP TABLE IF EXISTS `oa_net_scan_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_scan_log` (
`scan_log_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scan_log_ip_address` varchar(30) NOT NULL,
`scan_log_type` varchar(10) NOT NULL,
`scan_log_detail` varchar(100) NOT NULL,
`scan_log_frequency` tinyint(4) NOT NULL,
`scan_log_date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`scan_log_result` varchar(20) NOT NULL,
`scan_log_success` varchar(2) NOT NULL,
PRIMARY KEY (`scan_log_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_net_scan_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 `oa_net_scan_type`
--
DROP TABLE IF EXISTS `oa_net_scan_type`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_net_scan_type` (
`scan_type_id` int(10) NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scan_type_ip_address` varchar(30) NOT NULL,
`scan_type` varchar(10) NOT NULL,
`scan_type_detail` varchar(100) NOT NULL,
`scan_type_frequency` tinyint(4) NOT NULL,
PRIMARY KEY (`scan_type_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_net_scan_type_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 `oa_spare`
--
DROP TABLE IF EXISTS `oa_spare`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_spare` (
`spare_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`spare_field_1` varchar(45) NOT NULL default '',
`spare_field_2` varchar(100) NOT NULL default '',
`spare_field_3` varchar(200) NOT NULL default '',
`spare_field_4` varchar(200) NOT NULL default '',
`spare_field_5` varchar(200) NOT NULL default '',
`spare_field_6` varchar(200) NOT NULL default '',
`spare_field_7` varchar(200) NOT NULL default '',
`spare_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`spare_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `oa_spare_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 `oa_switch_ports`
--
DROP TABLE IF EXISTS `oa_switch_ports`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_switch_ports` (
`switch_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`switch_system_id` int(10) unsigned default NULL,
`switch_port` varchar(100) NOT NULL default '',
`switch_timestamp` varchar(200) NOT NULL default '',
`switch_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`switch_id`),
KEY `system_id` (`system_id`),
KEY `switch_system_id` (`switch_system_id`),
CONSTRAINT `oa_switch_ports_switch_switch_id` FOREIGN KEY (`switch_system_id`) REFERENCES `system` (`system_id`),
CONSTRAINT `oa_switch_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 `oa_user`
--
DROP TABLE IF EXISTS `oa_user`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_user` (
`user_id` int(10) unsigned NOT NULL auto_increment,
`user_name` varchar(100) NOT NULL,
`user_password` varchar(100) NOT NULL,
`user_full_name` varchar(100) NOT NULL,
`user_email` varchar(100) default NULL,
`user_lang` varchar(100) default NULL,
`user_display_number` smallint(6) NOT NULL default '10',
`user_theme` varchar(100) default NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Definition of table `oa_user_sessions`
--
DROP TABLE IF EXISTS `oa_user_sessions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `oa_user_sessions` (
`session_id` varchar(40) NOT NULL default '0',
`ip_address` varchar(16) NOT NULL default '0',
`user_agent` varchar(50) NOT NULL,
`last_activity` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table `sys_hw_battery`
--
DROP TABLE IF EXISTS `sys_hw_battery`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_battery` (
`bt_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`bt_description` varchar(100) NOT NULL default '',
`bt_device_id` varchar(100) NOT NULL default '',
`bt_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`bt_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`bt_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_battery_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_hw_bios`
--
DROP TABLE IF EXISTS `sys_hw_bios`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_bios` (
`bios_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`bios_description` varchar(200) NOT NULL default '',
`bios_manufacturer` varchar(200) NOT NULL default '',
`bios_serial_number` varchar(100) NOT NULL default '',
`bios_sm_bios_version` varchar(100) NOT NULL default '',
`bios_version` varchar(100) NOT NULL default '',
`bios_asset_tag` varchar(100) NOT NULL default '',
`bios_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`bios_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`bios_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_bios_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_hw_firewire`
--
DROP TABLE IF EXISTS `sys_hw_firewire`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_firewire` (
`fw_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`fw_description` varchar(200) NOT NULL default '',
`fw_manufacturer` varchar(100) NOT NULL default '',
`fw_caption` varchar(200) NOT NULL default '',
`fw_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`fw_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`fw_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_firewire_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `sys_hw_floppy`
--
DROP TABLE IF EXISTS `sys_hw_floppy`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_floppy` (
`floppy_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`floppy_description` varchar(100) NOT NULL default '',
`floppy_device_id` varchar(100) NOT NULL default '',
`floppy_manufacturer` varchar(100) NOT NULL default '',
`floppy_caption` varchar(100) NOT NULL default '',
`floppy_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`floppy_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`floppy_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_floppy_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_hw_graphs_disk`
--
DROP TABLE IF EXISTS `sys_hw_graphs_disk`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_graphs_disk` (
`disk_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`disk_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`disk_letter` varchar(4) NOT NULL default '',
`disk_percent` varchar(3) NOT NULL default '',
PRIMARY KEY (`disk_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_graphs_disk_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_hw_hard_drive`
--
DROP TABLE IF EXISTS `sys_hw_hard_drive`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_hard_drive` (
`hard_drive_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`hard_drive_caption` varchar(100) NOT NULL default '',
`hard_drive_index` varchar(100) NOT NULL default '',
`hard_drive_interface_type` varchar(10) NOT NULL default '',
`hard_drive_manufacturer` varchar(100) NOT NULL default '',
`hard_drive_model` varchar(100) NOT NULL default '',
`hard_drive_serial` varchar(100) NOT NULL default '',
`hard_drive_partitions` int(10) unsigned NOT NULL default '0',
`hard_drive_scsi_bus` varchar(10) NOT NULL default '',
`hard_drive_scsi_logical_unit` varchar(100) NOT NULL default '',
`hard_drive_scsi_port` varchar(10) NOT NULL default '',
`hard_drive_size` int(10) unsigned NOT NULL default '0',
`hard_drive_device_id` varchar(200) NOT NULL default '',
`hard_drive_status` varchar(10) NOT NULL default '',
`hard_drive_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`hard_drive_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`hard_drive_id`),
KEY `hard_drive_index` (`hard_drive_index`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_hard_drive_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_hw_keyboard`
--
DROP TABLE IF EXISTS `sys_hw_keyboard`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_keyboard` (
`keyboard_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`keyboard_description` varchar(100) NOT NULL default '',
`keyboard_caption` varchar(100) NOT NULL default '',
`keyboard_connection` varchar(45) NOT NULL default '',
`keyboard_device_id` varchar(100) NOT NULL default '',
`keyboard_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`keyboard_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`keyboard_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_keyboard_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_hw_memory`
--
DROP TABLE IF EXISTS `sys_hw_memory`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_memory` (
`memory_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`memory_bank` varchar(45) NOT NULL default '',
`memory_type` varchar(45) NOT NULL default '',
`memory_form_factor` varchar(45) NOT NULL default '',
`memory_detail` varchar(45) NOT NULL default '',
`memory_capacity` int(10) NOT NULL,
`memory_speed` varchar(45) NOT NULL default '',
`memory_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`memory_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`memory_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_memory_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_hw_modem`
--
DROP TABLE IF EXISTS `sys_hw_modem`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_modem` (
`modem_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`modem_attached_to` varchar(100) NOT NULL default '',
`modem_country_selected` varchar(100) NOT NULL default '',
`modem_description` varchar(100) NOT NULL default '',
`modem_device_id` varchar(100) NOT NULL default '',
`modem_device_type` varchar(100) NOT NULL default '',
`modem_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`modem_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`modem_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_modem_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_hw_monitor`
--
DROP TABLE IF EXISTS `sys_hw_monitor`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_monitor` (
`monitor_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`monitor_manufacturer` varchar(45) NOT NULL default '',
`monitor_device_id` varchar(45) NOT NULL default '',
`monitor_manufacture_date` varchar(45) NOT NULL default '',
`monitor_model` varchar(45) NOT NULL default '',
`monitor_serial` varchar(45) NOT NULL default '',
`monitor_serial_man` varchar(45) NOT NULL default '',
`monitor_edid` varchar(45) NOT NULL default '',
`monitor_description` varchar(100) NOT NULL default '',
`monitor_value` varchar(45) NOT NULL default '',
`monitor_purchase_order_number` varchar(45) NOT NULL default '',
`monitor_date_purchased` date NOT NULL default '0000-00-00',
`monitor_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`monitor_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`monitor_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_monitor_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_hw_motherboard`
--
DROP TABLE IF EXISTS `sys_hw_motherboard`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_motherboard` (
`motherboard_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`motherboard_manufacturer` varchar(50) NOT NULL default '',
`motherboard_product` varchar(50) NOT NULL default '',
`motherboard_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`motherboard_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`motherboard_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_motherboard_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_hw_mouse`
--
DROP TABLE IF EXISTS `sys_hw_mouse`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_mouse` (
`mouse_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`mouse_description` varchar(100) NOT NULL default '',
`mouse_number_of_buttons` varchar(45) NOT NULL default '',
`mouse_device_id` varchar(100) NOT NULL default '',
`mouse_type` varchar(45) NOT NULL default '',
`mouse_port` varchar(45) NOT NULL default '',
`mouse_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`mouse_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`mouse_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_mouse_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_hw_network_card`
--
DROP TABLE IF EXISTS `sys_hw_network_card`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_network_card` (
`net_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`net_mac_address` varchar(17) NOT NULL default '',
`net_manufacturer` varchar(100) NOT NULL default '',
`net_model` varchar(100) NOT NULL default '',
`net_description` varchar(255) NOT NULL default '',
`net_ip_enabled` varchar(10) NOT NULL default '',
`net_index` varchar(10) NOT NULL default '',
`net_dhcp_enabled` varchar(100) NOT NULL default '',
`net_dhcp_server` varchar(30) NOT NULL default '',
`net_dhcp_lease_obtained` varchar(14) NOT NULL default '',
`net_dhcp_lease_expires` varchar(14) NOT NULL default '',
`net_dns_host_name` varchar(100) NOT NULL default '',
`net_dns_server` varchar(100) NOT NULL default '',
`net_dns_domain` varchar(100) NOT NULL default '',
`net_dns_domain_suffix` varchar(100) NOT NULL default '',
`net_dns_domain_reg_enabled` varchar(10) NOT NULL default '',
`net_wins_primary` varchar(30) NOT NULL default '',
`net_wins_secondary` varchar(30) NOT NULL default '',
`net_wins_lmhosts_enabled` varchar(10) NOT NULL default '',
`net_adapter_type` varchar(100) NOT NULL default '',
`net_connection_id` varchar(255) NOT NULL default '',
`net_connection_status` varchar(30) NOT NULL default '',
`net_speed` varchar(10) NOT NULL default '',
`net_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`net_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`net_id`),
KEY `net_mac_address` (`net_mac_address`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_network_card_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_hw_network_card_ip`
--
DROP TABLE IF EXISTS `sys_hw_network_card_ip`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_network_card_ip` (
`ip_id` int(10) unsigned NOT NULL auto_increment,
`net_mac_address` varchar(17) NOT NULL default '',
`ip_address` varchar(30) NOT NULL default '',
`ip_address_v6` varchar(30) NOT NULL default '',
`ip_subnet` varchar(30) NOT NULL default '',
`ip_address_version` varchar(10) NOT NULL default '',
`ip_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ip_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ip_id`),
KEY `id` (`net_mac_address`),
CONSTRAINT `sys_hw_network_card_ip_net_mac_address` FOREIGN KEY (`net_mac_address`) REFERENCES `sys_hw_network_card` (`net_mac_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `sys_hw_onboard_device`
--
DROP TABLE IF EXISTS `sys_hw_onboard_device`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_onboard_device` (
`onboard_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`onboard_description` varchar(50) NOT NULL default '',
`onboard_type` varchar(20) NOT NULL default '',
`onboard_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`onboard_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`onboard_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_onboard_device_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_hw_optical_drive`
--
DROP TABLE IF EXISTS `sys_hw_optical_drive`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_optical_drive` (
`optical_drive_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`optical_drive_caption` varchar(100) NOT NULL default '',
`optical_drive_model` varchar(100) NOT NULL default '',
`optical_drive_device_id` varchar(100) NOT NULL default '',
`optical_drive_mount_point` varchar(10) NOT NULL default '',
`optical_drive_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`optical_drive_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`optical_drive_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_optical_drive_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_hw_partition`
--
DROP TABLE IF EXISTS `sys_hw_partition`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_partition` (
`partition_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`hard_drive_index` varchar(100) NOT NULL default '',
`partition_mount_point` varchar(100) NOT NULL default '',
`partition_name` varchar(100) NOT NULL default '',
`partition_size` int(10) unsigned NOT NULL default '1',
`partition_free_space` int(10) unsigned NOT NULL default '1',
`partition_used_space` int(10) unsigned NOT NULL default '1',
`partition_format` varchar(20) NOT NULL default '',
`partition_caption` varchar(100) NOT NULL default '',
`partition_device_id` varchar(100) NOT NULL default '',
`partition_disk_index` varchar(50) NOT NULL default '',
`partition_boot_partition` varchar(10) NOT NULL default '',
`partition_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`partition_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`partition_id`),
KEY `system_id` (`system_id`),
KEY `hard_drive_index` (`hard_drive_index`),
CONSTRAINT `sys_hw_partition_hard_drive_index` FOREIGN KEY (`hard_drive_index`) REFERENCES `sys_hw_hard_drive` (`hard_drive_index`),
CONSTRAINT `sys_hw_partition_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_hw_processor`
--
DROP TABLE IF EXISTS `sys_hw_processor`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_processor` (
`processor_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`processor_cores` int(2) unsigned NOT NULL default '0',
`processor_description` varchar(100) NOT NULL default '',
`processor_speed` int(10) unsigned NOT NULL default '0',
`processor_manufacturer` varchar(100) NOT NULL default '',
`processor_power_management_supported` varchar(20) NOT NULL default '',
`processor_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`processor_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`processor_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_processor_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_hw_scsi_controller`
--
DROP TABLE IF EXISTS `sys_hw_scsi_controller`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_scsi_controller` (
`scsi_controller_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scsi_controller_caption` varchar(200) NOT NULL default '',
`scsi_controller_device_id` varchar(200) NOT NULL default '',
`scsi_controller_manufacturer` varchar(100) NOT NULL default '',
`scsi_controller_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`scsi_controller_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`scsi_controller_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_scsi_controller_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_hw_scsi_device`
--
DROP TABLE IF EXISTS `sys_hw_scsi_device`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_scsi_device` (
`scsi_device_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`scsi_device_controller` int(10) unsigned default NULL,
`scsi_device_device` varchar(200) NOT NULL default '',
`scsi_device_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`scsi_device_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`scsi_device_id`),
KEY `system_id` (`system_id`),
KEY `scsi_device_controller` (`scsi_device_controller`),
CONSTRAINT `sys_hw_scsi_device_scsi_device_controller` FOREIGN KEY (`scsi_device_controller`) REFERENCES `sys_hw_scsi_controller` (`scsi_controller_id`),
CONSTRAINT `sys_hw_scsi_device_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_hw_sound`
--
DROP TABLE IF EXISTS `sys_hw_sound`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_sound` (
`sound_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`sound_manufacturer` varchar(100) NOT NULL default '',
`sound_device_id` varchar(100) NOT NULL default '',
`sound_name` varchar(100) NOT NULL default '',
`sound_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`sound_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`sound_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_sound_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_hw_tape_drive`
--
DROP TABLE IF EXISTS `sys_hw_tape_drive`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_tape_drive` (
`tape_drive_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`tape_drive_caption` varchar(100) NOT NULL default '',
`tape_drive_description` varchar(100) NOT NULL default '',
`tape_drive_device_id` varchar(100) NOT NULL default '',
`tape_drive_manufacturer` varchar(100) NOT NULL default '',
`tape_drive_name` varchar(100) NOT NULL default '',
`tape_drive_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`tape_drive_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`tape_drive_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_tape_drive_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_hw_usb`
--
DROP TABLE IF EXISTS `sys_hw_usb`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_usb` (
`usb_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`usb_caption` varchar(100) NOT NULL default '',
`usb_description` varchar(100) NOT NULL default '',
`usb_manufacturer` varchar(100) NOT NULL default '',
`usb_device_id` varchar(120) NOT NULL default '',
`usb_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`usb_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`usb_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_usb_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_hw_video`
--
DROP TABLE IF EXISTS `sys_hw_video`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_hw_video` (
`video_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`video_description` varchar(100) NOT NULL default '',
`video_manufacturer` varchar(100) NOT NULL default '',
`video_current_horizontal_res` varchar(20) NOT NULL default '',
`video_current_vertical_res` varchar(20) NOT NULL default '',
`video_memory` varchar(100) NOT NULL default '',
`video_caption` varchar(100) NOT NULL default '',
`video_current_number_colours` varchar(20) NOT NULL default '',
`video_current_refresh_rate` varchar(20) NOT NULL default '',
`video_device_id` varchar(100) NOT NULL default '',
`video_driver_date` varchar(20) NOT NULL default '',
`video_driver_version` varchar(20) NOT NULL default '',
`video_max_refresh_rate` varchar(20) NOT NULL default '',
`video_min_refresh_rate` varchar(20) NOT NULL default '',
`video_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`video_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`video_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_hw_video_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_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_database`
--
DROP TABLE IF EXISTS `sys_sw_database`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_database` (
`db_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`db_type` varchar(50) NOT NULL default '',
`db_version` varchar(50) NOT NULL default '',
`db_port` int(10) unsigned default NULL,
`db_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`db_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`db_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_db_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_database_details`
--
DROP TABLE IF EXISTS `sys_sw_database_details`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_database_details` (
`details_id` int(10) unsigned NOT NULL auto_increment,
`db_id` int(10) unsigned default NULL,
`details_name` varchar(50) NOT NULL default '',
`details_internal_id` varchar(50) NOT NULL default '',
`details_current_size` varchar(50) NOT NULL default '',
`details_filename` varchar(200) NOT NULL default '',
`details_creation_date` datetime NOT NULL default '0000-00-00 00:00:00',
`details_last_accessed_date` varchar(50) NOT NULL default '',
`details_last_accessed_login_name` varchar(50) NOT NULL default '',
`details_last_accessed_hostname` varchar(50) NOT NULL default '',
`details_last_accessed_program` varchar(50) NOT NULL default '',
`details_last_accessed_domain` varchar(50) NOT NULL default '',
`details_last_accessed_username` varchar(50) NOT NULL default '',
`details_last_accessed_protocol` varchar(50) NOT NULL default '',
`details_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`details_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`details_id`),
KEY `system_id` (`db_id`),
CONSTRAINT `sys_sw_db_id` FOREIGN KEY (`db_id`) REFERENCES `sys_sw_database` (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `sys_sw_database_log`
--
DROP TABLE IF EXISTS `sys_sw_database_log`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_database_log` (
`log_id` int(10) unsigned NOT NULL auto_increment,
`details_id` int(10) unsigned default NULL,
`log_size` varchar(50) NOT NULL default '',
`log_last_accessed_date` varchar(50) NOT NULL default '',
`log_last_accessed_login_name` varchar(50) NOT NULL default '',
`log_last_accessed_hostname` varchar(50) NOT NULL default '',
`log_last_accessed_program` varchar(50) NOT NULL default '',
`log_last_accessed_domain` varchar(50) NOT NULL default '',
`log_last_accessed_username` varchar(50) NOT NULL default '',
`log_last_accessed_protocol` varchar(50) NOT NULL default '',
`log_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`log_id`),
KEY `system_id` (`details_id`),
CONSTRAINT `sys_sw_db_details_id` FOREIGN KEY (`details_id`) REFERENCES `sys_sw_database_details` (`details_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_software_key`
--
DROP TABLE IF EXISTS `sys_sw_software_key`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `sys_sw_software_key` (
`key_id` int(10) unsigned NOT NULL auto_increment,
`system_id` int(10) unsigned default NULL,
`key_name` varchar(250) NOT NULL default '',
`key_text` varchar(100) NOT NULL default '',
`key_release` varchar(100) NOT NULL default '',
`key_edition` varchar(100) NOT NULL default '',
`key_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`key_first_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`key_id`),
KEY `system_id` (`system_id`),
CONSTRAINT `sys_sw_software_key_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_cost_center` 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);
INSERT INTO `oa_group` VALUES (17,'Virtual Systems','d','SELECT distinct(system.system_id) FROM system, sys_hw_video WHERE sys_hw_video.video_description LIKE \'%vmware%\' AND system.man_status = \'production\' AND sys_hw_video.system_id = system.system_id',1,'Administrator','Virtual','','','','','','',0);
INSERT INTO `oa_group` VALUES (18,'Windows Servers','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%windows%server%\' AND system.man_status = \'production\'',1,'Administrator','Win Svr','','','','','','',0);
INSERT INTO `oa_group` VALUES (19,'Windows XP','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%windows xp%\' AND system.man_status = \'production\'',1,'Administrator','XP','','','','','','',0);
INSERT INTO `oa_group` VALUES (20,'Windows 2000','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%windows%2000%\' AND system.man_status = \'production\'',1,'Administrator','Win 2000','','','','','','',0);
INSERT INTO `oa_group` VALUES (21,'Windows 2003','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%windows%2003%\' AND system.man_status = \'production\'',1,'Administrator','Win 2003','','','','','','',0);
INSERT INTO `oa_group` VALUES (22,'Windows Vista','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%vista%\' AND system.man_status = \'production\'',1,'Administrator','Vista','','','','','','',0);
INSERT INTO `oa_group` VALUES (23,'Ubuntu','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%ubuntu%\' AND system.man_status = \'production\'',1,'Administrator','Ubuntu','','','','','','',0);
INSERT INTO `oa_group` VALUES (24,'Debian','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%debian%\' AND system.man_status = \'production\'',1,'Administrator','Debian','','','','','','',0);
INSERT INTO `oa_group` VALUES (25,'RedHat','d','SELECT distinct(system.system_id) FROM system WHERE system.os_full_name LIKE \'%red%hat%\' AND system.man_status = \'production\'',1,'Administrator','RedHat','','','','','','',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);
INSERT INTO `oa_group_user` VALUES (9,1,17,10);
INSERT INTO `oa_group_user` VALUES (10,1,18,10);
INSERT INTO `oa_group_user` VALUES (11,1,19,10);
INSERT INTO `oa_group_user` VALUES (12,1,20,10);
INSERT INTO `oa_group_user` VALUES (13,1,21,10);
INSERT INTO `oa_group_user` VALUES (14,1,22,10);
INSERT INTO `oa_group_user` VALUES (15,1,23,10);
INSERT INTO `oa_group_user` VALUES (16,1,24,10);
INSERT INTO `oa_group_user` VALUES (17,1,25,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 */;
-- Dump completed on 2008-09-17 21:43:02
[/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.
|