1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
|
-- Structure de la table `accountinfo`
--
CREATE TABLE `accountinfo` (
`HARDWARE_ID` int(11) NOT NULL,
`TAG` varchar(255) collate latin1_general_ci default 'NA',
PRIMARY KEY (`HARDWARE_ID`),
KEY `TAG` (`TAG`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Contenu de la table `accountinfo`
--
INSERT INTO `accountinfo` VALUES (2, 'Inspiron 50');
-- --------------------------------------------------------
-- Structure de la table `hardware`
--
CREATE TABLE `hardware` (
`ID` int(11) NOT NULL auto_increment,
`DEVICEID` varchar(255) collate latin1_general_ci NOT NULL,
`NAME` varchar(255) collate latin1_general_ci default NULL,
`WORKGROUP` varchar(255) collate latin1_general_ci default NULL,
`OSNAME` varchar(255) collate latin1_general_ci default NULL,
`OSVERSION` varchar(255) collate latin1_general_ci default NULL,
`OSCOMMENTS` varchar(255) collate latin1_general_ci default NULL,
`PROCESSORT` varchar(255) collate latin1_general_ci 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) collate latin1_general_ci default NULL,
`ETIME` datetime default NULL,
`LASTDATE` datetime default NULL,
`LASTCOME` datetime default NULL,
`QUALITY` decimal(4,3) default '0.000',
`FIDELITY` bigint(20) default '1',
`USERID` varchar(255) collate latin1_general_ci default NULL,
`TYPE` int(11) default NULL,
`DESCRIPTION` varchar(255) collate latin1_general_ci default NULL,
`WINCOMPANY` varchar(255) collate latin1_general_ci default NULL,
`WINOWNER` varchar(255) collate latin1_general_ci default NULL,
`WINPRODID` varchar(255) collate latin1_general_ci default NULL,
`WINPRODKEY` varchar(255) collate latin1_general_ci default NULL,
`USERAGENT` varchar(50) collate latin1_general_ci default NULL,
`CHECKSUM` int(11) default '131071',
PRIMARY KEY (`DEVICEID`,`ID`),
KEY `NAME` (`NAME`),
KEY `CHECKSUM` (`CHECKSUM`),
KEY `DEVICEID` (`DEVICEID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
--
-- Contenu de la table `hardware`
--
INSERT INTO `hardware` VALUES (2, 'PORTABLE-2006-10-10-13-03-25', 'PORTABLE', 'PARIS', 'Microsoft Windows XP Professional', '5.1.2600', 'Service Pack 2', 'Intel(R) Pentium(R) 4 Mobile CPU 60GHz', 1196, 1, 256, 834, '192.168.0.107', '0000-00-00 00:00:00', '2006-10-10 15:38:43', '2006-10-10 15:38:43', 0.102, 2, 'C', 0, NULL, 'societe', 'Ri', '7version', 'clé windows xp, 'OCS-NG_windows_client_v4026', 1311); |
Partager