From Docunext Technology Wiki
-- phpMyAdmin SQL Dump
-- version 3.2.0.1deb1
-- http://www.phpmyadmin.net
--
-- Host: 192.168.8.2
-- Generation Time: Aug 23, 2010 at 12:12 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.9-4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `ocsweb`
--
-- --------------------------------------------------------
--
-- Table structure for table `accesslog`
--
CREATE TABLE IF NOT EXISTS `accesslog` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`USERID` varchar(255) default NULL,
`LOGDATE` datetime default NULL,
`PROCESSES` text,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`),
KEY `USERID` (`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
-- --------------------------------------------------------
--
-- Table structure for table `accountinfo`
--
CREATE TABLE IF NOT EXISTS `accountinfo` (
`HARDWARE_ID` int(11) NOT NULL,
`TAG` varchar(255) default 'NA',
PRIMARY KEY (`HARDWARE_ID`),
KEY `TAG` (`TAG`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `bios`
--
CREATE TABLE IF NOT EXISTS `bios` (
`HARDWARE_ID` int(11) NOT NULL,
`SMANUFACTURER` varchar(255) default NULL,
`SMODEL` varchar(255) default NULL,
`SSN` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`BMANUFACTURER` varchar(255) default NULL,
`BVERSION` varchar(255) default NULL,
`BDATE` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`),
KEY `SSN` (`SSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `blacklist_macaddresses`
--
CREATE TABLE IF NOT EXISTS `blacklist_macaddresses` (
`ID` int(11) NOT NULL auto_increment,
`MACADDRESS` varchar(255) NOT NULL default '',
PRIMARY KEY (`MACADDRESS`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
-- --------------------------------------------------------
--
-- Table structure for table `blacklist_serials`
--
CREATE TABLE IF NOT EXISTS `blacklist_serials` (
`ID` int(11) NOT NULL auto_increment,
`SERIAL` varchar(255) NOT NULL default '',
PRIMARY KEY (`SERIAL`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE IF NOT EXISTS `config` (
`NAME` varchar(50) NOT NULL,
`IVALUE` int(11) default NULL,
`TVALUE` varchar(255) default NULL,
`COMMENTS` text,
PRIMARY KEY (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `conntrack`
--
CREATE TABLE IF NOT EXISTS `conntrack` (
`IP` varchar(255) NOT NULL default '',
`TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`IP`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `controllers`
--
CREATE TABLE IF NOT EXISTS `controllers` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`MANUFACTURER` varchar(255) default NULL,
`NAME` varchar(255) default NULL,
`CAPTION` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`VERSION` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=593 ;
-- --------------------------------------------------------
--
-- Table structure for table `deleted_equiv`
--
CREATE TABLE IF NOT EXISTS `deleted_equiv` (
`DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`DELETED` varchar(255) NOT NULL,
`EQUIVALENT` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `deploy`
--
CREATE TABLE IF NOT EXISTS `deploy` (
`NAME` varchar(255) NOT NULL,
`CONTENT` longblob NOT NULL,
PRIMARY KEY (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `devices`
--
CREATE TABLE IF NOT EXISTS `devices` (
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(50) NOT NULL,
`IVALUE` int(11) default NULL,
`TVALUE` varchar(255) default NULL,
`COMMENTS` text,
KEY `HARDWARE_ID` (`HARDWARE_ID`),
KEY `TVALUE` (`TVALUE`),
KEY `IVALUE` (`IVALUE`),
KEY `NAME` (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `devicetype`
--
CREATE TABLE IF NOT EXISTS `devicetype` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `dico_ignored`
--
CREATE TABLE IF NOT EXISTS `dico_ignored` (
`EXTRACTED` varchar(255) NOT NULL,
PRIMARY KEY (`EXTRACTED`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `dico_soft`
--
CREATE TABLE IF NOT EXISTS `dico_soft` (
`EXTRACTED` varchar(255) NOT NULL,
`FORMATTED` varchar(255) NOT NULL,
PRIMARY KEY (`EXTRACTED`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `download_affect_rules`
--
CREATE TABLE IF NOT EXISTS `download_affect_rules` (
`ID` int(11) NOT NULL auto_increment,
`RULE` int(11) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`CFIELD` varchar(20) character set latin1 collate latin1_general_ci NOT NULL,
`OP` varchar(20) character set latin1 collate latin1_general_ci NOT NULL,
`COMPTO` varchar(20) character set latin1 collate latin1_general_ci NOT NULL,
`SERV_VALUE` varchar(20) character set latin1 collate latin1_general_ci default NULL,
`RULE_NAME` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `download_available`
--
CREATE TABLE IF NOT EXISTS `download_available` (
`FILEID` varchar(255) NOT NULL,
`NAME` varchar(255) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`FRAGMENTS` int(11) NOT NULL,
`SIZE` int(11) NOT NULL,
`OSNAME` varchar(255) NOT NULL,
`COMMENT` text,
PRIMARY KEY (`FILEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `download_enable`
--
CREATE TABLE IF NOT EXISTS `download_enable` (
`ID` int(11) NOT NULL auto_increment,
`FILEID` varchar(255) NOT NULL,
`INFO_LOC` varchar(255) NOT NULL,
`PACK_LOC` varchar(255) NOT NULL,
`CERT_PATH` varchar(255) default NULL,
`CERT_FILE` varchar(255) default NULL,
`SERVER_ID` int(11) default NULL,
`GROUP_ID` int(11) default NULL,
PRIMARY KEY (`ID`),
KEY `FILEID` (`FILEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `download_history`
--
CREATE TABLE IF NOT EXISTS `download_history` (
`HARDWARE_ID` int(11) NOT NULL,
`PKG_ID` int(11) NOT NULL default '0',
`PKG_NAME` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `download_servers`
--
CREATE TABLE IF NOT EXISTS `download_servers` (
`HARDWARE_ID` int(11) NOT NULL,
`URL` varchar(250) character set latin1 collate latin1_general_ci NOT NULL,
`ADD_PORT` int(11) NOT NULL,
`ADD_REP` varchar(250) character set latin1 collate latin1_general_ci NOT NULL,
`GROUP_ID` int(11) NOT NULL,
PRIMARY KEY (`HARDWARE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `drives`
--
CREATE TABLE IF NOT EXISTS `drives` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`LETTER` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`FILESYSTEM` varchar(255) default NULL,
`TOTAL` int(11) default NULL,
`FREE` int(11) default NULL,
`NUMFILES` int(11) default NULL,
`VOLUMN` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6546 ;
-- --------------------------------------------------------
--
-- Table structure for table `engine_mutex`
--
CREATE TABLE IF NOT EXISTS `engine_mutex` (
`NAME` varchar(255) NOT NULL default '',
`PID` int(11) default NULL,
`TAG` varchar(255) NOT NULL default '',
PRIMARY KEY (`NAME`,`TAG`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `engine_persistent`
--
CREATE TABLE IF NOT EXISTS `engine_persistent` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) NOT NULL default '',
`IVALUE` int(11) default NULL,
`TVALUE` varchar(255) default NULL,
UNIQUE KEY `NAME` (`NAME`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE IF NOT EXISTS `files` (
`NAME` varchar(255) NOT NULL,
`VERSION` varchar(255) NOT NULL,
`OS` varchar(255) NOT NULL,
`CONTENT` longblob NOT NULL,
PRIMARY KEY (`NAME`,`OS`,`VERSION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`HARDWARE_ID` int(11) NOT NULL default '0',
`REQUEST` longtext,
`CREATE_TIME` int(11) default '0',
`REVALIDATE_FROM` int(11) default '0',
PRIMARY KEY (`HARDWARE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `groups_cache`
--
CREATE TABLE IF NOT EXISTS `groups_cache` (
`HARDWARE_ID` int(11) NOT NULL default '0',
`GROUP_ID` int(11) NOT NULL default '0',
`STATIC` int(11) default '0',
PRIMARY KEY (`HARDWARE_ID`,`GROUP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `hardware`
--
CREATE TABLE IF NOT EXISTS `hardware` (
`ID` int(11) NOT NULL auto_increment,
`DEVICEID` varchar(255) NOT NULL,
`NAME` varchar(255) default NULL,
`WORKGROUP` varchar(255) default NULL,
`USERDOMAIN` varchar(255) default NULL,
`OSNAME` varchar(255) default NULL,
`OSVERSION` varchar(255) default NULL,
`OSCOMMENTS` varchar(255) default NULL,
`PROCESSORT` varchar(255) default NULL,
`PROCESSORS` int(11) default '0',
`PROCESSORN` smallint(6) default NULL,
`MEMORY` int(11) default NULL,
`SWAP` int(11) default NULL,
`IPADDR` varchar(255) default NULL,
`ETIME` datetime default NULL,
`LASTDATE` datetime default NULL,
`LASTCOME` datetime default NULL,
`QUALITY` decimal(7,4) default NULL,
`FIDELITY` bigint(20) default '1',
`USERID` varchar(255) default NULL,
`TYPE` int(11) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`WINCOMPANY` varchar(255) default NULL,
`WINOWNER` varchar(255) default NULL,
`WINPRODID` varchar(255) default NULL,
`WINPRODKEY` varchar(255) default NULL,
`USERAGENT` varchar(50) default NULL,
`CHECKSUM` int(11) default '131071',
`SSTATE` int(11) default '0',
PRIMARY KEY (`DEVICEID`,`ID`),
KEY `NAME` (`NAME`),
KEY `CHECKSUM` (`CHECKSUM`),
KEY `DEVICEID` (`DEVICEID`),
KEY `ID` (`ID`),
KEY `USERID` (`USERID`),
KEY `WORKGROUP` (`WORKGROUP`),
KEY `OSNAME` (`OSNAME`),
KEY `MEMORY` (`MEMORY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
-- --------------------------------------------------------
--
-- Table structure for table `hardware_osname_cache`
--
CREATE TABLE IF NOT EXISTS `hardware_osname_cache` (
`ID` int(11) NOT NULL auto_increment,
`OSNAME` varchar(255) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `OSNAME` (`OSNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Table structure for table `inputs`
--
CREATE TABLE IF NOT EXISTS `inputs` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`TYPE` varchar(255) default NULL,
`MANUFACTURER` varchar(255) default NULL,
`CAPTION` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`INTERFACE` varchar(255) default NULL,
`POINTTYPE` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `locks`
--
CREATE TABLE IF NOT EXISTS `locks` (
`HARDWARE_ID` int(11) NOT NULL,
`ID` int(11) default NULL,
`SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`HARDWARE_ID`),
KEY `SINCE` (`SINCE`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `memories`
--
CREATE TABLE IF NOT EXISTS `memories` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`CAPTION` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`CAPACITY` varchar(255) default NULL,
`PURPOSE` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`SPEED` varchar(255) default NULL,
`NUMSLOTS` smallint(6) default NULL,
`SERIALNUMBER` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
-- --------------------------------------------------------
--
-- Table structure for table `modems`
--
CREATE TABLE IF NOT EXISTS `modems` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(255) default NULL,
`MODEL` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `monitors`
--
CREATE TABLE IF NOT EXISTS `monitors` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`MANUFACTURER` varchar(255) default NULL,
`CAPTION` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`SERIAL` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `netmap`
--
CREATE TABLE IF NOT EXISTS `netmap` (
`IP` varchar(15) NOT NULL,
`MAC` varchar(17) NOT NULL,
`MASK` varchar(15) NOT NULL,
`NETID` varchar(15) NOT NULL,
`DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
`NAME` varchar(255) default NULL,
PRIMARY KEY (`MAC`),
KEY `IP` (`IP`),
KEY `NETID` (`NETID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `networks`
--
CREATE TABLE IF NOT EXISTS `networks` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`DESCRIPTION` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`TYPEMIB` varchar(255) default NULL,
`SPEED` varchar(255) default NULL,
`MACADDR` varchar(255) default NULL,
`STATUS` varchar(255) default NULL,
`IPADDRESS` varchar(255) default NULL,
`IPMASK` varchar(255) default NULL,
`IPGATEWAY` varchar(255) default NULL,
`IPSUBNET` varchar(255) default NULL,
`IPDHCP` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `MACADDR` (`MACADDR`),
KEY `IPSUBNET` (`IPSUBNET`),
KEY `ID` (`ID`),
KEY `IPADDRESS` (`IPADDRESS`),
KEY `IPGATEWAY` (`IPGATEWAY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;
-- --------------------------------------------------------
--
-- Table structure for table `network_devices`
--
CREATE TABLE IF NOT EXISTS `network_devices` (
`ID` int(11) NOT NULL auto_increment,
`DESCRIPTION` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`MACADDR` varchar(255) default NULL,
`USER` varchar(255) default NULL,
PRIMARY KEY (`ID`),
KEY `MACADDR` (`MACADDR`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `operators`
--
CREATE TABLE IF NOT EXISTS `operators` (
`ID` varchar(255) NOT NULL default '',
`FIRSTNAME` varchar(255) default NULL,
`LASTNAME` varchar(255) default NULL,
`PASSWD` varchar(50) default NULL,
`ACCESSLVL` int(11) default NULL,
`COMMENTS` text,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `ports`
--
CREATE TABLE IF NOT EXISTS `ports` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`TYPE` varchar(255) default NULL,
`NAME` varchar(255) default NULL,
`CAPTION` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=145 ;
-- --------------------------------------------------------
--
-- Table structure for table `printers`
--
CREATE TABLE IF NOT EXISTS `printers` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(255) default NULL,
`DRIVER` varchar(255) default NULL,
`PORT` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `prolog_conntrack`
--
CREATE TABLE IF NOT EXISTS `prolog_conntrack` (
`ID` int(11) NOT NULL auto_increment,
`DEVICEID` varchar(255) default NULL,
`TIMESTAMP` int(11) default NULL,
`PID` int(11) default NULL,
KEY `ID` (`ID`),
KEY `DEVICEID` (`DEVICEID`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `regconfig`
--
CREATE TABLE IF NOT EXISTS `regconfig` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) default NULL,
`REGTREE` int(11) default NULL,
`REGKEY` text,
`REGVALUE` varchar(255) default NULL,
PRIMARY KEY (`ID`),
KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `registry`
--
CREATE TABLE IF NOT EXISTS `registry` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(255) default NULL,
`REGVALUE` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `NAME` (`NAME`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `registry_name_cache`
--
CREATE TABLE IF NOT EXISTS `registry_name_cache` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `registry_regvalue_cache`
--
CREATE TABLE IF NOT EXISTS `registry_regvalue_cache` (
`ID` int(11) NOT NULL auto_increment,
`REGVALUE` varchar(255) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `REGVALUE` (`REGVALUE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `slots`
--
CREATE TABLE IF NOT EXISTS `slots` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`DESIGNATION` varchar(255) default NULL,
`PURPOSE` varchar(255) default NULL,
`STATUS` varchar(255) default NULL,
`PSHARE` tinyint(4) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
-- --------------------------------------------------------
--
-- Table structure for table `softwares`
--
CREATE TABLE IF NOT EXISTS `softwares` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`PUBLISHER` varchar(255) default NULL,
`NAME` varchar(255) default NULL,
`VERSION` varchar(255) default NULL,
`FOLDER` text,
`COMMENTS` text,
`FILENAME` varchar(255) default NULL,
`FILESIZE` int(11) default '0',
`SOURCE` int(11) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `NAME` (`NAME`),
KEY `ID` (`ID`),
KEY `VERSION` (`VERSION`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=530863 ;
-- --------------------------------------------------------
--
-- Table structure for table `softwares_name_cache`
--
CREATE TABLE IF NOT EXISTS `softwares_name_cache` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(255) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=197354 ;
-- --------------------------------------------------------
--
-- Table structure for table `sounds`
--
CREATE TABLE IF NOT EXISTS `sounds` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`MANUFACTURER` varchar(255) default NULL,
`NAME` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
--
-- Table structure for table `storages`
--
CREATE TABLE IF NOT EXISTS `storages` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`MANUFACTURER` varchar(255) default NULL,
`NAME` varchar(255) default NULL,
`MODEL` varchar(255) default NULL,
`DESCRIPTION` varchar(255) default NULL,
`TYPE` varchar(255) default NULL,
`DISKSIZE` int(11) default NULL,
`SERIALNUMBER` varchar(255) default NULL,
`FIRMWARE` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ;
-- --------------------------------------------------------
--
-- Table structure for table `subnet`
--
CREATE TABLE IF NOT EXISTS `subnet` (
`NETID` varchar(15) NOT NULL,
`NAME` varchar(255) default NULL,
`ID` int(11) default NULL,
`MASK` varchar(255) default NULL,
PRIMARY KEY (`NETID`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `tags`
--
CREATE TABLE IF NOT EXISTS `tags` (
`Tag` varchar(255) NOT NULL default '',
`Login` varchar(255) NOT NULL default '',
PRIMARY KEY (`Tag`,`Login`),
KEY `Tag` (`Tag`),
KEY `Login` (`Login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `videos`
--
CREATE TABLE IF NOT EXISTS `videos` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(255) default NULL,
`CHIPSET` varchar(255) default NULL,
`MEMORY` varchar(255) default NULL,
`RESOLUTION` varchar(255) default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
See Also