Package: ocsinventory-server Severity: wishlist Tags: patch Hello,
Following the bug #512660 I make some changes to let ocsinventory-server create the database. I use dbconfig-common with two SQL scripts: - debian/db/mysql: for a new installation - debian/db/1.02: for an upgrade from 1.01 I don't have a 1.0 and previous version database to make the diffs and I suppose that it's not a serious problem since they are not packaged. The process is not ended for now, I need to modify ocsinventory-reports to automatically create dbconfig.inc.php (with dbconfig-common). I attach a gziped diff, I publish my developpement in a bzr repository at http://www.baby-gnu.org/~nebu/archives/ocsinventory/server/dad/ Regards. -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (500, 'unstable'), (90, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 2.6.30-rc6+hati.1 (SMP w/2 CPU cores; PREEMPT) Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash -- Daniel Dehennin Récupérer ma clef GPG: gpg --keyserver pgp.mit.edu --recv-keys 0x6A2540D1
=== added directory 'debian/db'
=== added file 'debian/db/1.02'
--- debian/db/1.02 1970-01-01 00:00:00 +0000
+++ debian/db/1.02 2009-05-20 10:21:06 +0000
@@ -0,0 +1,271 @@
+-- -*- sql -*-
+USE ocsweb;
+
+--
+-- Create new schema
+--
+CREATE TABLE `blacklist_macaddresses` (
+ `ID` INTEGER auto_increment,
+ `MACADDRESS` VARCHAR(255),
+ PRIMARY KEY (`MACADDRESS`),
+ KEY `ID` (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `blacklist_serials` (
+ `ID` INTEGER auto_increment,
+ `SERIAL` VARCHAR(255),
+ PRIMARY KEY (`SERIAL`),
+ KEY `ID` (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `download_affect_rules` (
+ `ID` int(11) NOT NULL auto_increment,
+ `RULE` int(11) NOT NULL,
+ `PRIORITY` int(11) NOT NULL,
+ `CFIELD` varchar(20) collate latin1_general_ci NOT NULL,
+ `OP` varchar(20) collate latin1_general_ci NOT NULL,
+ `COMPTO` varchar(20) collate latin1_general_ci NOT NULL,
+ `SERV_VALUE` varchar(20) collate latin1_general_ci default NULL,
+ `RULE_NAME` varchar(200) collate latin1_general_ci NOT NULL,
+ PRIMARY KEY (`ID`)
+) ENGINE=MyISAM;
+
+CREATE TABLE `download_servers` (
+ `HARDWARE_ID` int(11) NOT NULL,
+ `URL` varchar(250) collate latin1_general_ci NOT NULL,
+ `ADD_PORT` int(11) NOT NULL,
+ `ADD_REP` varchar(250) collate latin1_general_ci NOT NULL,
+ `GROUP_ID` int(11) NOT NULL,
+ PRIMARY KEY (`HARDWARE_ID`)
+) ENGINE=MyISAM;
+
+CREATE TABLE `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;
+
+CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+
+CREATE TABLE `groups` (
+ `HARDWARE_ID` integer default NULL,
+ `REQUEST` longtext,
+ `CREATE_TIME` INT default 0,
+ `REVALIDATE_FROM` INT default 0,
+ PRIMARY KEY (`HARDWARE_ID`)
+) ENGINE=MYISAM;
+
+CREATE TABLE `groups_cache` (
+ `HARDWARE_ID` integer NOT NULL default 0,
+ `GROUP_ID` integer NOT NULL default 0,
+ `STATIC` integer default 0,
+ PRIMARY KEY (`HARDWARE_ID`, `GROUP_ID`)
+) ENGINE=MYISAM;
+
+CREATE TABLE `hardware_osname_cache` (
+ `ID` INTEGER auto_increment,
+ `OSNAME` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `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;
+
+CREATE TABLE `softwares_name_cache` (
+ `ID` INTEGER auto_increment,
+ `NAME` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `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;
+
+CREATE TABLE `registry_name_cache` (
+ `ID` INTEGER auto_increment,
+ `NAME` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `registry_regvalue_cache` (
+ `ID` INTEGER auto_increment,
+ `REGVALUE` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+
+--
+-- Update existing schemas
+--
+
+-- accesslog
+ALTER TABLE `accesslog` ADD KEY `USERID` (`USERID`);
+
+-- devices
+ALTER TABLE `devices` ADD KEY `IVALUE` (`IVALUE`);
+ALTER TABLE `devices` ADD KEY `NAME` (`NAME`);
+
+-- download_enable
+ALTER TABLE `download_enable` ADD COLUMN `SERVER_ID` INTEGER;
+ALTER TABLE `download_enable` ADD COLUMN `GROUP_ID` INTEGER;
+ALTER TABLE `download_enable` ADD KEY `FILEID` (`FILEID`);
+
+-- hardware
+ALTER TABLE `hardware` ADD COLUMN `SSTATE` INTEGER default 0;
+ALTER TABLE `hardware` CHANGE `QUALITY` `QUALITY` DECIMAL(7,4) default NULL; -- NULL or 0 ?
+ALTER TABLE `hardware` ADD KEY `USERID` (`USERID`);
+ALTER TABLE `hardware` ADD KEY `WORKGROUP` (`WORKGROUP`);
+ALTER TABLE `hardware` ADD KEY `OSNAME` (`OSNAME`);
+ALTER TABLE `hardware` ADD KEY `MEMORY` (`MEMORY`);
+
+-- memories
+ALTER TABLE `memories` ADD COLUMN `SERIALNUMBER` VARCHAR(255) default NULL AFTER `NUMSLOTS`;
+
+-- networks
+-- IPSUBNET is 15/255 ?
+ALTER TABLE `networks` ADD KEY `IPADDRESS` (`IPADDRESS`);
+ALTER TABLE `networks` ADD KEY `IPGATEWAY` (`IPGATEWAY`);
+
+-- softwares
+ALTER TABLE `softwares` ADD KEY `VERSION`(`VERSION`);
+
+-- storages
+ALTER TABLE `storages` ADD COLUMN `SERIALNUMBER` VARCHAR(255) default NULL AFTER `DISKSIZE`;
+ALTER TABLE `storages` ADD COLUMN `FIRMWARE` VARCHAR(255) default NULL AFTER `SERIALNUMBER`;
+
+-- subnet
+ALTER TABLE `subnet` ADD KEY `ID` (`ID`);
+
+--
+-- Insert new values
+--
+
+-- blacklist_macaddresses
+INSERT INTO `blacklist_macaddresses` (`MACADDRESS`) VALUES
+ ('00:00:00:00:00:00'),
+ ('FF:FF:FF:FF:FF:FF'),
+ ('44:45:53:54:00:00'),
+ ('44:45:53:54:00:01'),
+ ('00:01:02:7D:9B:1C'),
+ ('00:08:A1:46:06:35'),
+ ('00:08:A1:66:E2:1A'),
+ ('00:09:DD:10:37:68'),
+ ('00:0F:EA:9A:E2:F0'),
+ ('00:10:5A:72:71:F3'),
+ ('00:11:11:85:08:8B'),
+ ('10:11:11:11:11:11'),
+ ('44:45:53:54:61:6F'),
+ ('');
+
+-- blacklist_serials
+INSERT INTO `blacklist_serials` (`SERIAL`) VALUES
+ ('N/A'),
+ ('(null string)'),
+ ('INVALID'),
+ ('SYS-1234567890'),
+ ('SYS-9876543210'),
+ ('SN-12345'),
+ ('SN-1234567890'),
+ ('1111111111'),
+ ('1111111'),
+ ('1'),
+ ('0123456789'),
+ ('12345'),
+ ('123456'),
+ ('1234567'),
+ ('12345678'),
+ ('123456789'),
+ ('1234567890'),
+ ('123456789000'),
+ ('12345678901234567'),
+ ('0000000000'),
+ ('000000000'),
+ ('00000000'),
+ ('0000000'),
+ ('000000'),
+ ('NNNNNNN'),
+ ('xxxxxxxxxxx'),
+ ('EVAL'),
+ ('IATPASS'),
+ ('none'),
+ ('To Be Filled By O.E.M.'),
+ ('Tulip Computers'),
+ ('Serial Number xxxxxx'),
+ ('SN-123456fvgv3i0b8o5n6n7k'),
+ ('');
+
+-- config
+-- Update GUI_VERSION
+UPDATE `config`
+ SET `TVALUE`='5003', `COMMENTS`='Version of the installed GUI and database'
+ WHERE NAME='GUI_VERSION';
+
+DELETE FROM `config` WHERE NAME='IP_MIN_QUALITY';
+
+-- Default new configuration
+INSERT INTO `config` (`NAME`, `IVALUE`, `TVALUE`, `COMMENTS`) VALUES
+ ('DOWNLOAD_GROUPS_TRACE_EVENTS', 1, '', 'Specify if you want to track packages affected to a group on computer''s level'),
+ ('DOWNLOAD_PACK_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for download files'),
+ ('DOWNLOAD_SERVER_URI', 0, '$IP$/local', 'Server url used for group of server'),
+ ('DOWNLOAD_SERVER_DOCROOT', 0, 'd:\\\\tele_ocs', 'Server directory used for group of server'),
+ ('ENABLE_GROUPS', 1, '', 'Enable the computer''s groups feature'),
+ ('GENERATE_OCS_FILES', 0, '', 'Use with ocsinventory-injector, enable the multi entities feature'),
+ ('GUI_REPORT_AGIN_MACH', 30, '', 'Filter on lastdate for console page'),
+ ('GUI_REPORT_DD_MAX', 4000, '', 'Filter on Hard Drive for console page'),
+ ('GUI_REPORT_DD_MINI', 500, '', 'Filter on PROCESSOR for console page'),
+ ('GUI_REPORT_LAST_DIFF', 1, '', 'Difference between LASTDATE and LASTCOME'),
+ ('GUI_REPORT_NOT_VIEW', 3, '', 'Filter on DAY for console page'),
+ ('GUI_REPORT_PROC_MAX', 3000, '', 'Filter on PROCESSOR for console page'),
+ ('GUI_REPORT_PROC_MINI', 1000, '', 'Filter on Hard Drive for console page'),
+ ('GUI_REPORT_RAM_MAX', 512, '', 'Filter on RAM for console page'),
+ ('GUI_REPORT_RAM_MINI', 128, '', 'Filter on RAM for console page'),
+ ('GROUPS_CACHE_OFFSET', 43200, '', 'Random number computed in the defined range. Designed to avoid computing many groups in the same process'),
+ ('GROUPS_CACHE_REVALIDATE', 43200, '', 'Specify the validity of computer''s groups (default: compute it once a day - see offset)'),
+ ('IPDISCOVER_BETTER_THRESHOLD', 1, '', 'Specify the minimal difference to replace an ipdiscover agent'),
+ ('IPDISCOVER_IPD_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for Ipdiscover files'),
+ ('IPDISCOVER_NO_POSTPONE', 0, '', 'Disable the time before a first election (not recommended)'),
+ ('IPDISCOVER_USE_GROUPS', 1, '', 'Enable groups for ipdiscover (for example, you might want to prevent some groups'),
+ ('INVENTORY_CACHE_ENABLED', 1, '', 'Enable some stuff to improve DB queries, especially for GUI multicriteria searching system'),
+ ('INVENTORY_FILTER_ENABLED', 0, '', 'Enable core filter system to modify some things "on the fly"'),
+ ('INVENTORY_FILTER_FLOOD_IP', 0, '', 'Enable inventory flooding filter. A dedicated ipaddress ia allowed to send a new computer only once in this period'),
+ ('INVENTORY_FILTER_FLOOD_IP_CACHE_TIME', 300, '', 'Period definition for INVENTORY_FILTER_FLOOD_IP'),
+ ('INVENTORY_FILTER_ON', 0, '', 'Enable inventory filter stack'),
+ ('INVENTORY_WRITE_DIFF', 0, '', 'Configure engine to make a differential update of inventory sections (row level). Lower DB backend load, higher frontend load'),
+ ('LOCK_REUSE_TIME', 600, '', 'Validity of a computer''s lock'),
+ ('OCS_FILES_FORMAT', 0, 'OCS', 'Generate either compressed file or clear XML text'),
+ ('OCS_FILES_OVERWRITE', 0, '', 'Specify if you want to keep trace of all inventory between to synchronisation with the higher level server'),
+ ('OCS_FILES_PATH', 0, '/tmp', 'Path to ocs files directory (must be writeable)'),
+ ('PROLOG_FILTER_ON', 0, '', 'Enable prolog filter stack'),
+ ('SESSION_VALIDITY_TIME', 1, '', 'Validity of a session');
+
+
+-- Fill the caches
+INSERT INTO `registry_name_cache` (`NAME`) SELECT DISTINCT `NAME` FROM `registry`;
+INSERT INTO `registry_regvalue_cache` (`REGVALUE`) SELECT DISTINCT `REGVALUE` FROM `registry`;
+INSERT INTO `hardware_osname_cache` (`OSNAME`) SELECT DISTINCT `OSNAME` FROM `hardware`;
+INSERT INTO `softwares_name_cache` (`NAME`) SELECT DISTINCT `NAME` FROM `softwares`;
+
+--
+-- Drop useless
+--
+
+DROP TABLE IF EXISTS `dico_cat`;
+DROP TABLE IF EXISTS `tag`;
=== added file 'debian/db/mysql'
--- debian/db/mysql 1970-01-01 00:00:00 +0000
+++ debian/db/mysql 2009-05-20 10:21:06 +0000
@@ -0,0 +1,655 @@
+-- -*- sql -*-
+USE ocsweb;
+
+--
+-- Create Schema
+--
+CREATE TABLE `accesslog` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `USERID` VARCHAR(255) default NULL,
+ `LOGDATE` DATETIME default NULL,
+ `PROCESSES` TEXT,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`),
+ KEY `USERID` (`USERID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `accountinfo` (
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `TAG` VARCHAR(255) default 'NA',
+ PRIMARY KEY (`HARDWARE_ID`),
+ KEY `TAG` (`TAG`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `bios` (
+ `HARDWARE_ID` INTEGER 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 ;
+
+CREATE TABLE `blacklist_macaddresses` (
+ `ID` INTEGER auto_increment,
+ `MACADDRESS` VARCHAR(255),
+ PRIMARY KEY (`MACADDRESS`),
+ KEY `ID` (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `blacklist_serials` (
+ `ID` INTEGER auto_increment,
+ `SERIAL` VARCHAR(255),
+ PRIMARY KEY (`SERIAL`),
+ KEY `ID` (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `config` (
+ `NAME` VARCHAR(50) NOT NULL,
+ `IVALUE` INTEGER default NULL,
+ `TVALUE` VARCHAR(255) default NULL,
+ `COMMENTS` TEXT,
+ PRIMARY KEY (`NAME`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `conntrack` (
+ `IP` VARCHAR(255),
+ `TIMESTAMP` TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ PRIMARY KEY (`IP`)
+) ENGINE = HEAP;
+
+CREATE TABLE `controllers` (
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `ID` INTEGER NOT NULL auto_increment,
+ `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 (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `deleted_equiv` (
+ `DATE` TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ `DELETED` VARCHAR(255) NOT NULL,
+ `EQUIVALENT` VARCHAR(255) default NULL
+) ENGINE=MYISAM ;
+
+CREATE TABLE `deploy` (
+ `NAME` VARCHAR(255) NOT NULL,
+ `CONTENT` LONGBLOB NOT NULL,
+ PRIMARY KEY (`NAME`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `devices` (
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `NAME` VARCHAR(50) NOT NULL,
+ `IVALUE` INTEGER 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 ;
+
+CREATE TABLE `devicetype` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `NAME` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `dico_ignored` (
+ `EXTRACTED` VARCHAR(255) NOT NULL,
+ PRIMARY KEY (`EXTRACTED`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `dico_soft` (
+ `EXTRACTED` VARCHAR(255) NOT NULL,
+ `FORMATTED` VARCHAR(255) NOT NULL,
+ PRIMARY KEY (`EXTRACTED`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `download_affect_rules` (
+ `ID` int(11) NOT NULL auto_increment,
+ `RULE` int(11) NOT NULL,
+ `PRIORITY` int(11) NOT NULL,
+ `CFIELD` varchar(20) collate latin1_general_ci NOT NULL,
+ `OP` varchar(20) collate latin1_general_ci NOT NULL,
+ `COMPTO` varchar(20) collate latin1_general_ci NOT NULL,
+ `SERV_VALUE` varchar(20) collate latin1_general_ci default NULL,
+ `RULE_NAME` varchar(200) collate latin1_general_ci NOT NULL,
+ PRIMARY KEY (`ID`)
+) ENGINE=MyISAM;
+
+CREATE TABLE `download_available` (
+ `FILEID` VARCHAR(255) NOT NULL,
+ `NAME` VARCHAR(255) NOT NULL,
+ `PRIORITY` INTEGER NOT NULL,
+ `FRAGMENTS` INTEGER NOT NULL,
+ `SIZE` INTEGER NOT NULL,
+ `OSNAME` VARCHAR(255) NOT NULL,
+ `COMMENT` TEXT,
+ PRIMARY KEY (`FILEID`)
+) ENGINE = INNODB;
+
+CREATE TABLE `download_enable` (
+ `ID` INTEGER 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),
+ `CERT_FILE` VARCHAR(255),
+ `SERVER_ID` INTEGER,
+ `GROUP_ID` INTEGER,
+ PRIMARY KEY (`ID`),
+ KEY `FILEID` (`FILEID`)
+) ENGINE = INNODB;
+
+CREATE TABLE `download_history` (
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `PKG_ID` INTEGER default NULL,
+ `PKG_NAME` VARCHAR(255),
+ PRIMARY KEY (`HARDWARE_ID`, `PKG_ID`)
+) ENGINE = INNODB;
+
+CREATE TABLE `download_servers` (
+ `HARDWARE_ID` int(11) NOT NULL,
+ `URL` varchar(250) collate latin1_general_ci NOT NULL,
+ `ADD_PORT` int(11) NOT NULL,
+ `ADD_REP` varchar(250) collate latin1_general_ci NOT NULL,
+ `GROUP_ID` int(11) NOT NULL,
+ PRIMARY KEY (`HARDWARE_ID`)
+) ENGINE=MyISAM;
+
+CREATE TABLE `drives` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `LETTER` VARCHAR(255) default NULL,
+ `TYPE` VARCHAR(255) default NULL,
+ `FILESYSTEM` VARCHAR(255) default NULL,
+ `TOTAL` INTEGER default NULL,
+ `FREE` INTEGER default NULL,
+ `NUMFILES` INTEGER default NULL,
+ `VOLUMN` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `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;
+
+CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+
+CREATE TABLE `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 ;
+
+CREATE TABLE `groups` (
+ `HARDWARE_ID` integer default NULL,
+ `REQUEST` longtext,
+ `CREATE_TIME` INT default 0,
+ `REVALIDATE_FROM` INT default 0,
+ PRIMARY KEY (`HARDWARE_ID`)
+) ENGINE=MYISAM;
+
+CREATE TABLE `groups_cache` (
+ `HARDWARE_ID` integer NOT NULL default 0,
+ `GROUP_ID` integer NOT NULL default 0,
+ `STATIC` integer default 0,
+ PRIMARY KEY (`HARDWARE_ID`, `GROUP_ID`)
+) ENGINE=MYISAM;
+
+CREATE TABLE `hardware` (
+ `ID` INTEGER 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` INTEGER default 0,
+ `PROCESSORN` SMALLINT default NULL,
+ `MEMORY` INTEGER default NULL,
+ `SWAP` INTEGER default NULL,
+ `IPADDR` VARCHAR(255) default NULL,
+ `ETIME` DATETIME default NULL,
+ `LASTDATE` DATETIME default NULL,
+ `LASTCOME` DATETIME default NULL,
+ `QUALITY` DECIMAL(7,4) default 0,
+ `FIDELITY` BIGINT default 1,
+ `USERID` VARCHAR(255) default NULL,
+ `TYPE` INTEGER 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` INTEGER default 131071,
+ `SSTATE` INTEGER default 0,
+ PRIMARY KEY (`DEVICEID`, `ID`),
+ KEY `ID` (`ID`),
+ KEY `DEVICEID` (`DEVICEID`),
+ KEY `NAME` (`NAME`),
+ KEY `CHECKSUM` (`CHECKSUM`),
+ KEY `USERID` (`USERID`),
+ KEY `WORKGROUP` (`WORKGROUP`),
+ KEY `OSNAME` (`OSNAME`),
+ KEY `MEMORY` (`MEMORY`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `hardware_osname_cache` (
+ `ID` INTEGER auto_increment,
+ `OSNAME` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `inputs` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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 (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `locks` (
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `ID` INTEGER DEFAULT NULL,
+ `SINCE` TIMESTAMP default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ PRIMARY KEY (`HARDWARE_ID`),
+ KEY `SINCE` (`SINCE`)
+) ENGINE=HEAP ;
+
+CREATE TABLE `memories` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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 default NULL,
+ `SERIALNUMBER` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `modems` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `NAME` VARCHAR(255) default NULL,
+ `MODEL` VARCHAR(255) default NULL,
+ `DESCRIPTION` VARCHAR(255) default NULL,
+ `TYPE` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `monitors` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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 (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `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 ;
+
+CREATE TABLE `networks` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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 (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`),
+ KEY `MACADDR` (`MACADDR`),
+ KEY `IPADDRESS` (`IPADDRESS`),
+ KEY `IPGATEWAY` (`IPGATEWAY`),
+ KEY `IPSUBNET` (`IPSUBNET`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `network_devices` (
+ `ID` INTEGER 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 ;
+
+CREATE TABLE `operators` (
+ `ID` VARCHAR(255) NOT NULL default '',
+ `FIRSTNAME` VARCHAR(255) default NULL,
+ `LASTNAME` VARCHAR(255) default NULL,
+ `PASSWD` VARCHAR(50) default NULL,
+ `ACCESSLVL` INTEGER default NULL,
+ `COMMENTS` text,
+ PRIMARY KEY (`ID`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `ports` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `TYPE` VARCHAR(255) default NULL,
+ `NAME` VARCHAR(255) default NULL,
+ `CAPTION` VARCHAR(255) default NULL,
+ `DESCRIPTION` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `printers` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `NAME` VARCHAR(255) default NULL,
+ `DRIVER` VARCHAR(255) default NULL,
+ `PORT` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `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;
+
+CREATE TABLE `regconfig` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `NAME` VARCHAR(255) default NULL,
+ `REGTREE` INTEGER default NULL,
+ `REGKEY` text,
+ `REGVALUE` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`),
+ KEY `NAME` (`NAME`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `registry` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `NAME` VARCHAR(255) default NULL,
+ `REGVALUE` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`),
+ KEY `NAME` (`NAME`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `registry_name_cache` (
+ `ID` INTEGER auto_increment,
+ `NAME` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `registry_regvalue_cache` (
+ `ID` INTEGER auto_increment,
+ `REGVALUE` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `slots` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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 ;
+
+CREATE TABLE `softwares` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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` INTEGER default '0',
+ `SOURCE` INTEGER default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`),
+ KEY `NAME` (`NAME`),
+ KEY `VERSION` (`VERSION`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `softwares_name_cache` (
+ `ID` INTEGER auto_increment,
+ `NAME` VARCHAR(255) UNIQUE,
+ PRIMARY KEY (`ID`)
+) ENGINE = MYISAM;
+
+CREATE TABLE `sounds` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `MANUFACTURER` VARCHAR(255) default NULL,
+ `NAME` VARCHAR(255) default NULL,
+ `DESCRIPTION` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `storages` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER 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` INTEGER default NULL,
+ `SERIALNUMBER` VARCHAR(255) default NULL,
+ `FIRMWARE` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+CREATE TABLE `subnet` (
+ `NETID` VARCHAR(15) NOT NULL,
+ `NAME` VARCHAR(255),
+ `ID` INTEGER,
+ `MASK` VARCHAR(255),
+ PRIMARY KEY (`NETID`),
+ KEY `ID` (`ID`)
+) ENGINE=MYISAM ;
+
+CREATE TABLE `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;
+
+CREATE TABLE `videos` (
+ `ID` INTEGER NOT NULL auto_increment,
+ `HARDWARE_ID` INTEGER NOT NULL,
+ `NAME` VARCHAR(255) default NULL,
+ `CHIPSET` VARCHAR(255) default NULL,
+ `MEMORY` VARCHAR(255) default NULL,
+ `RESOLUTION` VARCHAR(255) default NULL,
+ PRIMARY KEY (`ID`, `HARDWARE_ID`),
+ KEY `ID` (`ID`)
+) ENGINE=INNODB ;
+
+
+--
+-- Insert default values
+--
+
+-- administrator
+INSERT INTO `operators` (`ID`, `FIRSTNAME`, `LASTNAME`, `PASSWD`, `ACCESSLVL`, `COMMENTS`) VALUES
+ ('admin', 'admin', 'admin', 'admin', 1, 'Default administrator account');
+
+-- configuration
+INSERT INTO `config` (`NAME`, `IVALUE`, `TVALUE`, `COMMENTS`) VALUES
+ ('AUTO_DUPLICATE_LVL', 7, '', 'Duplicates bitmap'),
+ ('DEPLOY', 1, '', 'Activates or not the automatic deployment option'),
+ ('DOWNLOAD', 0, '', 'Activate softwares auto deployment feature'),
+ ('DOWNLOAD_CYCLE_LATENCY', 60, '', 'Time between two cycles (seconds)'),
+ ('DOWNLOAD_PERIOD_LENGTH', 10, '', 'Number of cycles in a period'),
+ ('DOWNLOAD_FRAG_LATENCY', 10, '', 'Time between two downloads (seconds)'),
+ ('DOWNLOAD_GROUPS_TRACE_EVENTS', 1, '', 'Specify if you want to track packages affected to a group on computer''s level'),
+ ('DOWNLOAD_PACK_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for download files'),
+ ('DOWNLOAD_PERIOD_LATENCY', 0, '', 'Time between two periods (seconds)'),
+ ('DOWNLOAD_SERVER_URI', 0, '$IP$/local', 'Server url used for group of server'),
+ ('DOWNLOAD_SERVER_DOCROOT', 0, 'd:\\\\tele_ocs', 'Server directory used for group of server'),
+ ('DOWNLOAD_TIMEOUT', 30, '', 'Validity of a package (in days)'),
+ ('ENABLE_GROUPS', 1, '', 'Enable the computer''s groups feature'),
+ ('FREQUENCY', 0, '', 'Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'),
+ ('GENERATE_OCS_FILES', 0, '', 'Use with ocsinventory-injector, enable the multi entities feature'),
+ ('GUI_REPORT_AGIN_MACH', 30, '', 'Filter on lastdate for console page'),
+ ('GUI_REPORT_DD_MAX', 4000, '', 'Filter on Hard Drive for console page'),
+ ('GUI_REPORT_DD_MINI', 500, '', 'Filter on PROCESSOR for console page'),
+ ('GUI_REPORT_LAST_DIFF', 1, '', 'Difference between LASTDATE and LASTCOME'),
+ ('GUI_REPORT_NOT_VIEW', 3, '', 'Filter on DAY for console page'),
+ ('GUI_REPORT_PROC_MAX', 3000, '', 'Filter on PROCESSOR for console page'),
+ ('GUI_REPORT_PROC_MINI', 1000, '', 'Filter on Hard Drive for console page'),
+ ('GUI_REPORT_RAM_MAX', 512, '', 'Filter on RAM for console page'),
+ ('GUI_REPORT_RAM_MINI', 128, '', 'Filter on RAM for console page'),
+ ('GUI_VERSION', 0, '5003', 'Version of the installed GUI and database'),
+ ('GROUPS_CACHE_OFFSET', 43200, '', 'Random number computed in the defined range. Designed to avoid computing many groups in the same process'),
+ ('GROUPS_CACHE_REVALIDATE', 43200, '', 'Specify the validity of computer''s groups (default: compute it once a day - see offset)'),
+ ('IPDISCOVER', 2, '', 'Max number of computers per gateway retrieving IP on the network'),
+ ('IPDISCOVER_BETTER_THRESHOLD', 1, '', 'Specify the minimal difference to replace an ipdiscover agent'),
+ ('IPDISCOVER_IPD_DIR', 0, '/var/lib/ocsinventory-reports', 'Directory for Ipdiscover files'),
+ ('IPDISCOVER_LATENCY', 100, '', 'Default latency between two arp requests'),
+ ('IPDISCOVER_MAX_ALIVE', 7, '', 'Max number of days before an Ip Discover computer is replaced'),
+ ('IPDISCOVER_NO_POSTPONE', 0, '', 'Disable the time before a first election (not recommended)'),
+ ('IPDISCOVER_USE_GROUPS', 1, '', 'Enable groups for ipdiscover (for example, you might want to prevent some groups'),
+ ('INVENTORY_CACHE_ENABLED', 1, '', 'Enable some stuff to improve DB queries, especially for GUI multicriteria searching system'),
+ ('INVENTORY_DIFF', 1, '', 'Activate/Deactivate inventory incremental writing'),
+ ('INVENTORY_FILTER_ENABLED', 0, '', 'Enable core filter system to modify some things "on the fly"'),
+ ('INVENTORY_FILTER_FLOOD_IP', 0, '', 'Enable inventory flooding filter. A dedicated ipaddress ia allowed to send a new computer only once in this period'),
+ ('INVENTORY_FILTER_FLOOD_IP_CACHE_TIME', 300, '', 'Period definition for INVENTORY_FILTER_FLOOD_IP'),
+ ('INVENTORY_FILTER_ON', 0, '', 'Enable inventory filter stack'),
+ ('INVENTORY_TRANSACTION', 1, '', 'Enable/disable db commit at each inventory section'),
+ ('INVENTORY_WRITE_DIFF', 0, '', 'Configure engine to make a differential update of inventory sections (row level). Lower DB backend load, higher frontend load'),
+ ('LOCAL_SERVER', 0, 'localhost', 'Server address used for local import'),
+ ('LOCAL_PORT', 80, '', 'Server port used for local import'),
+ ('LOCK_REUSE_TIME', 600, '', 'Validity of a computer''s lock'),
+ ('LOGLEVEL', 0, '', 'ocs engine loglevel'),
+ ('OCS_FILES_FORMAT', 0, 'OCS', 'Generate either compressed file or clear XML text'),
+ ('OCS_FILES_OVERWRITE', 0, '', 'Specify if you want to keep trace of all inventory between to synchronisation with the higher level server'),
+ ('OCS_FILES_PATH', 0, '/tmp', 'Path to ocs files directory (must be writeable)'),
+ ('PROLOG_FILTER_ON', 0, '', 'Enable prolog filter stack'),
+ ('PROLOG_FREQ', 24, '', 'Specify the frequency (hours) of prolog, on agents'),
+ ('REGISTRY', 0, '', 'Activates or not the registry query function'),
+ ('SESSION_VALIDITY_TIME', 1, '', 'Validity of a session'),
+ ('TRACE_DELETED', 0, '', 'Trace deleted/duplicated computers (Activated by GLPI)'),
+ ('UPDATE', 0, '', 'Activates or not the update feature');
+
+-- blacklisted macaddresses
+INSERT INTO `blacklist_macaddresses` (`MACADDRESS`) VALUES
+ ('00:00:00:00:00:00'),
+ ('FF:FF:FF:FF:FF:FF'),
+ ('44:45:53:54:00:00'),
+ ('44:45:53:54:00:01'),
+ ('00:01:02:7D:9B:1C'),
+ ('00:08:A1:46:06:35'),
+ ('00:08:A1:66:E2:1A'),
+ ('00:09:DD:10:37:68'),
+ ('00:0F:EA:9A:E2:F0'),
+ ('00:10:5A:72:71:F3'),
+ ('00:11:11:85:08:8B'),
+ ('10:11:11:11:11:11'),
+ ('44:45:53:54:61:6F'),
+ ('');
+
+-- blacklisted serials
+INSERT INTO `blacklist_serials` (`SERIAL`) VALUES
+ ('N/A'),
+ ('(null string)'),
+ ('INVALID'),
+ ('SYS-1234567890'),
+ ('SYS-9876543210'),
+ ('SN-12345'),
+ ('SN-1234567890'),
+ ('1111111111'),
+ ('1111111'),
+ ('1'),
+ ('0123456789'),
+ ('12345'),
+ ('123456'),
+ ('1234567'),
+ ('12345678'),
+ ('123456789'),
+ ('1234567890'),
+ ('123456789000'),
+ ('12345678901234567'),
+ ('0000000000'),
+ ('000000000'),
+ ('00000000'),
+ ('0000000'),
+ ('000000'),
+ ('NNNNNNN'),
+ ('xxxxxxxxxxx'),
+ ('EVAL'),
+ ('IATPASS'),
+ ('none'),
+ ('To Be Filled By O.E.M.'),
+ ('Tulip Computers'),
+ ('Serial Number xxxxxx'),
+ ('SN-123456fvgv3i0b8o5n6n7k'),
+ ('');
=== modified file 'debian/ocsinventory-server.install'
--- debian/ocsinventory-server.install 2009-05-19 05:39:42 +0000
+++ debian/ocsinventory-server.install 2009-05-20 09:17:00 +0000
@@ -1,1 +1,3 @@
debian/conf/ocsinventory.conf usr/share/ocsinventory-server/files
+debian/db/mysql usr/share/dbconfig-common/data/ocsinventory-server/install
+debian/db/1.02 usr/share/dbconfig-common/data/ocsinventory-server/upgrade/mysql/
pgpXpyFXvRpTc.pgp
Description: PGP signature
