wok rev 3676
Add ocsreports
| author | Eric Joseph-Alexandre <erjo@slitaz.org> |
|---|---|
| date | Sat Jul 11 12:18:29 2009 +0200 (2009-07-11) |
| parents | 76e84daf36d7 |
| children | eccf4dfc09c1 |
| files | ocsreports/receipt ocsreports/stuff/dbconfig.inc.php ocsreports/stuff/ocsbase.sql |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/ocsreports/receipt Sat Jul 11 12:18:29 2009 +0200 1.3 @@ -0,0 +1,109 @@ 1.4 +# SliTaz package receipt. 1.5 + 1.6 +PACKAGE="ocsreports" 1.7 +VERSION="1.02.1" 1.8 +CATEGORY="network" 1.9 +SHORT_DESC="Inventory and package deployement system" 1.10 +MAINTAINER="pascal.bellard@slitaz.org" 1.11 +DEPENDS="php-apache php-mysql mysql" 1.12 +WANTED="ocsinventory" 1.13 +SOURCE="OCSNG_UNIX_SERVER" 1.14 +TARBALL="${SOURCE}_${VERSION}.tar.gz" 1.15 +WEB_SITE="http://www.ocsinventory-ng.org/" 1.16 + 1.17 +# Rules to gen a SliTaz package suitable for Tazpkg. 1.18 +genpkg_rules() 1.19 +{ 1.20 + src=$WOK/$WANTED/$SOURCE-$VERSION 1.21 + 1.22 + mkdir -p $fs/usr/share \ 1.23 + $fs/etc/ocsreports 1.24 + 1.25 + cp -a $WOK/$WANTED/${SOURCE}-${VERSION}/${PACKAGE} $fs/usr/share/ 1.26 + cat > $fs/etc/ocsreports/dbconfig.inc.php <<EOT 1.27 +<?php 1.28 + \$_SESSION["SERVEUR_SQL"]="localhost"; 1.29 + \$_SESSION["COMPTE_BASE"]="ocs"; 1.30 + \$_SESSION["PSWD_BASE"]="ocs"; 1.31 +?> 1.32 +EOT 1.33 + 1.34 + install -o root -g www -m 0755 $src/Apache/binutils/ipdiscover-util.pl \ 1.35 + $fs/usr/share/ocsreports/ipdiscover-util.pl 1.36 + 1.37 + rm -f $fs/usr/share/${PACKAGE}/dbconfig.inc.php 1.38 + cd $fs/usr/share/${PACKAGE} ; ln -s /etc/ocsreports/dbconfig.inc.php ; cd - 1.39 + 1.40 + # Remove doc file. 1.41 + rm -f $fs/usr/share/ocsreports/files/*.pdf 1.42 +} 1.43 + 1.44 +post_install() 1.45 +{ 1.46 + # Configure apache server 1.47 + if [ -f $1/etc/apache/httpd.conf ]; then 1.48 + if [ ! -f $1/etc/apache/conf.d/$PACKAGE ]; then 1.49 + cat > $1/etc/apache/conf.d/$PACKAGE <<EOT 1.50 +<IfModule mod_alias.c> 1.51 + Alias /$PACKAGE /usr/share/$PACKAGE/ 1.52 +</IfModule> 1.53 +<Directory "/usr/share/$PACKAGE"> 1.54 + Options Indexes FollowSymLinks 1.55 + AllowOverride None 1.56 + Order deny,allow 1.57 + Allow from all 1.58 +</Directory> 1.59 + 1.60 +EOT 1.61 + if [ -z "$1" ]; then 1.62 + # Start Web server. 1.63 + test -f /var/run/apache/httpd.pid && \ 1.64 + ( kill -0 $(cat /var/run/apache/httpd.pid) && /etc/init.d/apache restart ) 1.65 + fi 1.66 + fi 1.67 + fi 1.68 + 1.69 + # Configure every thing for ocsweb. 1.70 + if [ -z $1 ]; then 1.71 + if ( ! mysqladmin -s ping > /dev/null ); then 1.72 + echo "Starting MySQL server" 1.73 + ( /etc/init.d/mysql start ; status ) || exit 1.74 + sleep 4 #let the mysql daemon start 1.75 + fi 1.76 + if ( ! mysql -Be 'show databases' | grep -q ocsweb ); then 1.77 + echo -n "Create $PACKAGE database and schema" 1.78 + # mysql -Be "create database ocsweb" ; status 1.79 + mysql -f -s -u root < /usr/share/$PACKAGE/files/ocsbase.sql > /dev/null 2>&1 1.80 + # We suppose that ocs user does not exist. 1.81 + # It may be false. 1.82 + echo -n "Create user ocs with password ocs" 1.83 + mysql -Be "grant all privileges on ocsweb.* to 'ocs'@'localhost' 1.84 + identified by 'ocs'" ; status 1.85 + fi 1.86 + 1.87 + fi 1.88 +} 1.89 + 1.90 +post_remove() 1.91 +{ 1.92 + echo -n "Would you like to remove data and database files.(y/n) " 1.93 + read answer 1.94 + 1.95 + case $answer in 1.96 + y|Y) 1.97 + echo -n "Removing data directories..." 1.98 + rm -rf /usr/share/ocsreports 1.99 + if ( mysql -Be 'show databases' | grep -q ocsweb ); then 1.100 + echo -n "Deleting ocsreports database;" 1.101 + mysql -u root -Be "drop database ocsweb;" ; status 1.102 + echo -n "Delete user ocs" 1.103 + mysql -u root -Be "delete from mysql.db where user=ocs;" ; status 1.104 + fi 1.105 + unset $answer 1.106 + ;; 1.107 + *) 1.108 + ;; 1.109 + esac 1.110 + 1.111 +} 1.112 +
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/ocsreports/stuff/dbconfig.inc.php Sat Jul 11 12:18:29 2009 +0200 2.3 @@ -0,0 +1,5 @@ 2.4 +<?php 2.5 +$_SESSION["SERVEUR_SQL"]="localhost"; 2.6 +$_SESSION["COMPTE_BASE"]="ocs"; 2.7 +$_SESSION["PSWD_BASE"]="ocs"; 2.8 +?> 2.9 \ No newline at end of file
3.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 3.2 +++ b/ocsreports/stuff/ocsbase.sql Sat Jul 11 12:18:29 2009 +0200 3.3 @@ -0,0 +1,1086 @@ 3.4 +-- MySQL dump 10.11 3.5 +-- 3.6 +-- Host: localhost Database: ocsweb 3.7 +-- ------------------------------------------------------ 3.8 +-- Server version 5.0.51b-log 3.9 + 3.10 +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 3.11 +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 3.12 +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 3.13 +/*!40101 SET NAMES utf8 */; 3.14 +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 3.15 +/*!40103 SET TIME_ZONE='+00:00' */; 3.16 +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 3.17 +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 3.18 +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 3.19 +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 3.20 + 3.21 +-- 3.22 +-- Table structure for table `accesslog` 3.23 +-- 3.24 +USE ocsweb; 3.25 + 3.26 +DROP TABLE IF EXISTS `accesslog`; 3.27 +SET @saved_cs_client = @@character_set_client; 3.28 +SET character_set_client = utf8; 3.29 +CREATE TABLE `accesslog` ( 3.30 + `ID` int(11) NOT NULL auto_increment, 3.31 + `HARDWARE_ID` int(11) NOT NULL, 3.32 + `USERID` varchar(255) default NULL, 3.33 + `LOGDATE` datetime default NULL, 3.34 + `PROCESSES` text, 3.35 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.36 + KEY `ID` (`ID`) 3.37 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.38 +SET character_set_client = @saved_cs_client; 3.39 + 3.40 +-- 3.41 +-- Dumping data for table `accesslog` 3.42 +-- 3.43 + 3.44 +LOCK TABLES `accesslog` WRITE; 3.45 +/*!40000 ALTER TABLE `accesslog` DISABLE KEYS */; 3.46 +/*!40000 ALTER TABLE `accesslog` ENABLE KEYS */; 3.47 +UNLOCK TABLES; 3.48 + 3.49 +-- 3.50 +-- Table structure for table `accountinfo` 3.51 +-- 3.52 + 3.53 +DROP TABLE IF EXISTS `accountinfo`; 3.54 +SET @saved_cs_client = @@character_set_client; 3.55 +SET character_set_client = utf8; 3.56 +CREATE TABLE `accountinfo` ( 3.57 + `HARDWARE_ID` int(11) NOT NULL, 3.58 + `TAG` varchar(255) default 'NA', 3.59 + PRIMARY KEY (`HARDWARE_ID`), 3.60 + KEY `TAG` (`TAG`) 3.61 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.62 +SET character_set_client = @saved_cs_client; 3.63 + 3.64 +-- 3.65 +-- Dumping data for table `accountinfo` 3.66 +-- 3.67 + 3.68 +LOCK TABLES `accountinfo` WRITE; 3.69 +/*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */; 3.70 +/*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */; 3.71 +UNLOCK TABLES; 3.72 + 3.73 +-- 3.74 +-- Table structure for table `bios` 3.75 +-- 3.76 + 3.77 +DROP TABLE IF EXISTS `bios`; 3.78 +SET @saved_cs_client = @@character_set_client; 3.79 +SET character_set_client = utf8; 3.80 +CREATE TABLE `bios` ( 3.81 + `HARDWARE_ID` int(11) NOT NULL, 3.82 + `SMANUFACTURER` varchar(255) default NULL, 3.83 + `SMODEL` varchar(255) default NULL, 3.84 + `SSN` varchar(255) default NULL, 3.85 + `TYPE` varchar(255) default NULL, 3.86 + `BMANUFACTURER` varchar(255) default NULL, 3.87 + `BVERSION` varchar(255) default NULL, 3.88 + `BDATE` varchar(255) default NULL, 3.89 + PRIMARY KEY (`HARDWARE_ID`), 3.90 + KEY `SSN` (`SSN`) 3.91 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.92 +SET character_set_client = @saved_cs_client; 3.93 + 3.94 +-- 3.95 +-- Dumping data for table `bios` 3.96 +-- 3.97 + 3.98 +LOCK TABLES `bios` WRITE; 3.99 +/*!40000 ALTER TABLE `bios` DISABLE KEYS */; 3.100 +/*!40000 ALTER TABLE `bios` ENABLE KEYS */; 3.101 +UNLOCK TABLES; 3.102 + 3.103 +-- 3.104 +-- Table structure for table `config` 3.105 +-- 3.106 + 3.107 +DROP TABLE IF EXISTS `config`; 3.108 +SET @saved_cs_client = @@character_set_client; 3.109 +SET character_set_client = utf8; 3.110 +CREATE TABLE `config` ( 3.111 + `NAME` varchar(50) NOT NULL, 3.112 + `IVALUE` int(11) default NULL, 3.113 + `TVALUE` varchar(255) default NULL, 3.114 + `COMMENTS` text, 3.115 + PRIMARY KEY (`NAME`) 3.116 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.117 +SET character_set_client = @saved_cs_client; 3.118 + 3.119 +-- 3.120 +-- Dumping data for table `config` 3.121 +-- 3.122 + 3.123 +LOCK TABLES `config` WRITE; 3.124 +/*!40000 ALTER TABLE `config` DISABLE KEYS */; 3.125 +INSERT INTO `config` VALUES ('FREQUENCY',0,'','Specify the frequency (days) of inventories. (0: inventory at each login. -1: no inventory)'),('PROLOG_FREQ',24,'','Specify the frequency (hours) of prolog, on agents'),('IPDISCOVER',2,'','Max number of computers per gateway retrieving IP on the network'),('INVENTORY_DIFF',1,'','Activate/Deactivate inventory incremental writing'),('IPDISCOVER_LATENCY',100,'','Default latency between two arp requests'),('INVENTORY_TRANSACTION',1,'','Enable/disable db commit at each inventory section'),('REGISTRY',0,'','Activates or not the registry query function'),('IPDISCOVER_MAX_ALIVE',7,'','Max number of days before an Ip Discover computer is replaced'),('DEPLOY',1,'','Activates or not the automatic deployment option'),('UPDATE',0,'','Activates or not the update feature'),('GUI_VERSION',0,'4100','Version of the installed GUI and database'),('TRACE_DELETED',0,'','Trace deleted/duplicated computers (Activated by GLPI)'),('LOGLEVEL',0,'','ocs engine loglevel'),('AUTO_DUPLICATE_LVL',7,'','Duplicates bitmap'),('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_PERIOD_LATENCY',0,'','Time between two periods (seconds)'),('DOWNLOAD_TIMEOUT',30,'','Validity of a package (in days)'),('LOCAL_SERVER',0,'localhost','Server address used for local import'),('LOCAL_PORT',80,'','Server port used for local import'); 3.126 +/*!40000 ALTER TABLE `config` ENABLE KEYS */; 3.127 +UNLOCK TABLES; 3.128 + 3.129 +-- 3.130 +-- Table structure for table `conntrack` 3.131 +-- 3.132 + 3.133 +DROP TABLE IF EXISTS `conntrack`; 3.134 +SET @saved_cs_client = @@character_set_client; 3.135 +SET character_set_client = utf8; 3.136 +CREATE TABLE `conntrack` ( 3.137 + `IP` varchar(255) NOT NULL default '', 3.138 + `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 3.139 + PRIMARY KEY (`IP`) 3.140 +) ENGINE=MEMORY DEFAULT CHARSET=latin1; 3.141 +SET character_set_client = @saved_cs_client; 3.142 + 3.143 +-- 3.144 +-- Dumping data for table `conntrack` 3.145 +-- 3.146 + 3.147 +LOCK TABLES `conntrack` WRITE; 3.148 +/*!40000 ALTER TABLE `conntrack` DISABLE KEYS */; 3.149 +/*!40000 ALTER TABLE `conntrack` ENABLE KEYS */; 3.150 +UNLOCK TABLES; 3.151 + 3.152 +-- 3.153 +-- Table structure for table `controllers` 3.154 +-- 3.155 + 3.156 +DROP TABLE IF EXISTS `controllers`; 3.157 +SET @saved_cs_client = @@character_set_client; 3.158 +SET character_set_client = utf8; 3.159 +CREATE TABLE `controllers` ( 3.160 + `ID` int(11) NOT NULL auto_increment, 3.161 + `HARDWARE_ID` int(11) NOT NULL, 3.162 + `MANUFACTURER` varchar(255) default NULL, 3.163 + `NAME` varchar(255) default NULL, 3.164 + `CAPTION` varchar(255) default NULL, 3.165 + `DESCRIPTION` varchar(255) default NULL, 3.166 + `VERSION` varchar(255) default NULL, 3.167 + `TYPE` varchar(255) default NULL, 3.168 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.169 + KEY `ID` (`ID`) 3.170 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.171 +SET character_set_client = @saved_cs_client; 3.172 + 3.173 +-- 3.174 +-- Dumping data for table `controllers` 3.175 +-- 3.176 + 3.177 +LOCK TABLES `controllers` WRITE; 3.178 +/*!40000 ALTER TABLE `controllers` DISABLE KEYS */; 3.179 +/*!40000 ALTER TABLE `controllers` ENABLE KEYS */; 3.180 +UNLOCK TABLES; 3.181 + 3.182 +-- 3.183 +-- Table structure for table `deleted_equiv` 3.184 +-- 3.185 + 3.186 +DROP TABLE IF EXISTS `deleted_equiv`; 3.187 +SET @saved_cs_client = @@character_set_client; 3.188 +SET character_set_client = utf8; 3.189 +CREATE TABLE `deleted_equiv` ( 3.190 + `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 3.191 + `DELETED` varchar(255) NOT NULL, 3.192 + `EQUIVALENT` varchar(255) default NULL 3.193 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.194 +SET character_set_client = @saved_cs_client; 3.195 + 3.196 +-- 3.197 +-- Dumping data for table `deleted_equiv` 3.198 +-- 3.199 + 3.200 +LOCK TABLES `deleted_equiv` WRITE; 3.201 +/*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */; 3.202 +/*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */; 3.203 +UNLOCK TABLES; 3.204 + 3.205 +-- 3.206 +-- Table structure for table `deploy` 3.207 +-- 3.208 + 3.209 +DROP TABLE IF EXISTS `deploy`; 3.210 +SET @saved_cs_client = @@character_set_client; 3.211 +SET character_set_client = utf8; 3.212 +CREATE TABLE `deploy` ( 3.213 + `NAME` varchar(255) NOT NULL, 3.214 + `CONTENT` longblob NOT NULL, 3.215 + PRIMARY KEY (`NAME`) 3.216 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.217 +SET character_set_client = @saved_cs_client; 3.218 + 3.219 +-- 3.220 +-- Dumping data for table `deploy` 3.221 +-- 3.222 + 3.223 +LOCK TABLES `deploy` WRITE; 3.224 +/*!40000 ALTER TABLE `deploy` DISABLE KEYS */; 3.225 +/*!40000 ALTER TABLE `deploy` ENABLE KEYS */; 3.226 +UNLOCK TABLES; 3.227 + 3.228 +-- 3.229 +-- Table structure for table `devices` 3.230 +-- 3.231 + 3.232 +DROP TABLE IF EXISTS `devices`; 3.233 +SET @saved_cs_client = @@character_set_client; 3.234 +SET character_set_client = utf8; 3.235 +CREATE TABLE `devices` ( 3.236 + `HARDWARE_ID` int(11) NOT NULL, 3.237 + `NAME` varchar(50) NOT NULL, 3.238 + `IVALUE` int(11) default NULL, 3.239 + `TVALUE` varchar(255) default NULL, 3.240 + `COMMENTS` text, 3.241 + KEY `HARDWARE_ID` (`HARDWARE_ID`), 3.242 + KEY `TVALUE` (`TVALUE`) 3.243 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.244 +SET character_set_client = @saved_cs_client; 3.245 + 3.246 +-- 3.247 +-- Dumping data for table `devices` 3.248 +-- 3.249 + 3.250 +LOCK TABLES `devices` WRITE; 3.251 +/*!40000 ALTER TABLE `devices` DISABLE KEYS */; 3.252 +/*!40000 ALTER TABLE `devices` ENABLE KEYS */; 3.253 +UNLOCK TABLES; 3.254 + 3.255 +-- 3.256 +-- Table structure for table `devicetype` 3.257 +-- 3.258 + 3.259 +DROP TABLE IF EXISTS `devicetype`; 3.260 +SET @saved_cs_client = @@character_set_client; 3.261 +SET character_set_client = utf8; 3.262 +CREATE TABLE `devicetype` ( 3.263 + `ID` int(11) NOT NULL auto_increment, 3.264 + `NAME` varchar(255) default NULL, 3.265 + PRIMARY KEY (`ID`) 3.266 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.267 +SET character_set_client = @saved_cs_client; 3.268 + 3.269 +-- 3.270 +-- Dumping data for table `devicetype` 3.271 +-- 3.272 + 3.273 +LOCK TABLES `devicetype` WRITE; 3.274 +/*!40000 ALTER TABLE `devicetype` DISABLE KEYS */; 3.275 +/*!40000 ALTER TABLE `devicetype` ENABLE KEYS */; 3.276 +UNLOCK TABLES; 3.277 + 3.278 +-- 3.279 +-- Table structure for table `dico_cat` 3.280 +-- 3.281 + 3.282 +DROP TABLE IF EXISTS `dico_cat`; 3.283 +SET @saved_cs_client = @@character_set_client; 3.284 +SET character_set_client = utf8; 3.285 +CREATE TABLE `dico_cat` ( 3.286 + `NAME` varchar(255) NOT NULL, 3.287 + `PERMANENT` tinyint(4) default '0', 3.288 + PRIMARY KEY (`NAME`) 3.289 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.290 +SET character_set_client = @saved_cs_client; 3.291 + 3.292 +-- 3.293 +-- Dumping data for table `dico_cat` 3.294 +-- 3.295 + 3.296 +LOCK TABLES `dico_cat` WRITE; 3.297 +/*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */; 3.298 +/*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */; 3.299 +UNLOCK TABLES; 3.300 + 3.301 +-- 3.302 +-- Table structure for table `dico_ignored` 3.303 +-- 3.304 + 3.305 +DROP TABLE IF EXISTS `dico_ignored`; 3.306 +SET @saved_cs_client = @@character_set_client; 3.307 +SET character_set_client = utf8; 3.308 +CREATE TABLE `dico_ignored` ( 3.309 + `EXTRACTED` varchar(255) NOT NULL, 3.310 + PRIMARY KEY (`EXTRACTED`) 3.311 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.312 +SET character_set_client = @saved_cs_client; 3.313 + 3.314 +-- 3.315 +-- Dumping data for table `dico_ignored` 3.316 +-- 3.317 + 3.318 +LOCK TABLES `dico_ignored` WRITE; 3.319 +/*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */; 3.320 +/*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */; 3.321 +UNLOCK TABLES; 3.322 + 3.323 +-- 3.324 +-- Table structure for table `dico_soft` 3.325 +-- 3.326 + 3.327 +DROP TABLE IF EXISTS `dico_soft`; 3.328 +SET @saved_cs_client = @@character_set_client; 3.329 +SET character_set_client = utf8; 3.330 +CREATE TABLE `dico_soft` ( 3.331 + `EXTRACTED` varchar(255) NOT NULL, 3.332 + `FORMATTED` varchar(255) NOT NULL, 3.333 + PRIMARY KEY (`EXTRACTED`) 3.334 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.335 +SET character_set_client = @saved_cs_client; 3.336 + 3.337 +-- 3.338 +-- Dumping data for table `dico_soft` 3.339 +-- 3.340 + 3.341 +LOCK TABLES `dico_soft` WRITE; 3.342 +/*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */; 3.343 +/*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */; 3.344 +UNLOCK TABLES; 3.345 + 3.346 +-- 3.347 +-- Table structure for table `download_available` 3.348 +-- 3.349 + 3.350 +DROP TABLE IF EXISTS `download_available`; 3.351 +SET @saved_cs_client = @@character_set_client; 3.352 +SET character_set_client = utf8; 3.353 +CREATE TABLE `download_available` ( 3.354 + `FILEID` varchar(255) NOT NULL, 3.355 + `NAME` varchar(255) NOT NULL, 3.356 + `PRIORITY` int(11) NOT NULL, 3.357 + `FRAGMENTS` int(11) NOT NULL, 3.358 + `SIZE` int(11) NOT NULL, 3.359 + `OSNAME` varchar(255) NOT NULL, 3.360 + `COMMENT` text, 3.361 + PRIMARY KEY (`FILEID`) 3.362 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.363 +SET character_set_client = @saved_cs_client; 3.364 + 3.365 +-- 3.366 +-- Dumping data for table `download_available` 3.367 +-- 3.368 + 3.369 +LOCK TABLES `download_available` WRITE; 3.370 +/*!40000 ALTER TABLE `download_available` DISABLE KEYS */; 3.371 +/*!40000 ALTER TABLE `download_available` ENABLE KEYS */; 3.372 +UNLOCK TABLES; 3.373 + 3.374 +-- 3.375 +-- Table structure for table `download_enable` 3.376 +-- 3.377 + 3.378 +DROP TABLE IF EXISTS `download_enable`; 3.379 +SET @saved_cs_client = @@character_set_client; 3.380 +SET character_set_client = utf8; 3.381 +CREATE TABLE `download_enable` ( 3.382 + `ID` int(11) NOT NULL auto_increment, 3.383 + `FILEID` varchar(255) NOT NULL, 3.384 + `INFO_LOC` varchar(255) NOT NULL, 3.385 + `PACK_LOC` varchar(255) NOT NULL, 3.386 + `CERT_PATH` varchar(255) default NULL, 3.387 + `CERT_FILE` varchar(255) default NULL, 3.388 + PRIMARY KEY (`ID`) 3.389 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.390 +SET character_set_client = @saved_cs_client; 3.391 + 3.392 +-- 3.393 +-- Dumping data for table `download_enable` 3.394 +-- 3.395 + 3.396 +LOCK TABLES `download_enable` WRITE; 3.397 +/*!40000 ALTER TABLE `download_enable` DISABLE KEYS */; 3.398 +/*!40000 ALTER TABLE `download_enable` ENABLE KEYS */; 3.399 +UNLOCK TABLES; 3.400 + 3.401 +-- 3.402 +-- Table structure for table `download_history` 3.403 +-- 3.404 + 3.405 +DROP TABLE IF EXISTS `download_history`; 3.406 +SET @saved_cs_client = @@character_set_client; 3.407 +SET character_set_client = utf8; 3.408 +CREATE TABLE `download_history` ( 3.409 + `HARDWARE_ID` int(11) NOT NULL, 3.410 + `PKG_ID` int(11) NOT NULL default '0', 3.411 + `PKG_NAME` varchar(255) default NULL, 3.412 + PRIMARY KEY (`HARDWARE_ID`,`PKG_ID`) 3.413 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.414 +SET character_set_client = @saved_cs_client; 3.415 + 3.416 +-- 3.417 +-- Dumping data for table `download_history` 3.418 +-- 3.419 + 3.420 +LOCK TABLES `download_history` WRITE; 3.421 +/*!40000 ALTER TABLE `download_history` DISABLE KEYS */; 3.422 +/*!40000 ALTER TABLE `download_history` ENABLE KEYS */; 3.423 +UNLOCK TABLES; 3.424 + 3.425 +-- 3.426 +-- Table structure for table `drives` 3.427 +-- 3.428 + 3.429 +DROP TABLE IF EXISTS `drives`; 3.430 +SET @saved_cs_client = @@character_set_client; 3.431 +SET character_set_client = utf8; 3.432 +CREATE TABLE `drives` ( 3.433 + `ID` int(11) NOT NULL auto_increment, 3.434 + `HARDWARE_ID` int(11) NOT NULL, 3.435 + `LETTER` varchar(255) default NULL, 3.436 + `TYPE` varchar(255) default NULL, 3.437 + `FILESYSTEM` varchar(255) default NULL, 3.438 + `TOTAL` int(11) default NULL, 3.439 + `FREE` int(11) default NULL, 3.440 + `NUMFILES` int(11) default NULL, 3.441 + `VOLUMN` varchar(255) default NULL, 3.442 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.443 + KEY `ID` (`ID`) 3.444 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.445 +SET character_set_client = @saved_cs_client; 3.446 + 3.447 +-- 3.448 +-- Dumping data for table `drives` 3.449 +-- 3.450 + 3.451 +LOCK TABLES `drives` WRITE; 3.452 +/*!40000 ALTER TABLE `drives` DISABLE KEYS */; 3.453 +/*!40000 ALTER TABLE `drives` ENABLE KEYS */; 3.454 +UNLOCK TABLES; 3.455 + 3.456 +-- 3.457 +-- Table structure for table `files` 3.458 +-- 3.459 + 3.460 +DROP TABLE IF EXISTS `files`; 3.461 +SET @saved_cs_client = @@character_set_client; 3.462 +SET character_set_client = utf8; 3.463 +CREATE TABLE `files` ( 3.464 + `NAME` varchar(255) NOT NULL, 3.465 + `VERSION` varchar(255) NOT NULL, 3.466 + `OS` varchar(255) NOT NULL, 3.467 + `CONTENT` longblob NOT NULL, 3.468 + PRIMARY KEY (`NAME`,`OS`,`VERSION`) 3.469 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.470 +SET character_set_client = @saved_cs_client; 3.471 + 3.472 +-- 3.473 +-- Dumping data for table `files` 3.474 +-- 3.475 + 3.476 +LOCK TABLES `files` WRITE; 3.477 +/*!40000 ALTER TABLE `files` DISABLE KEYS */; 3.478 +/*!40000 ALTER TABLE `files` ENABLE KEYS */; 3.479 +UNLOCK TABLES; 3.480 + 3.481 +-- 3.482 +-- Table structure for table `hardware` 3.483 +-- 3.484 + 3.485 +DROP TABLE IF EXISTS `hardware`; 3.486 +SET @saved_cs_client = @@character_set_client; 3.487 +SET character_set_client = utf8; 3.488 +CREATE TABLE `hardware` ( 3.489 + `ID` int(11) NOT NULL auto_increment, 3.490 + `DEVICEID` varchar(255) NOT NULL, 3.491 + `NAME` varchar(255) default NULL, 3.492 + `WORKGROUP` varchar(255) default NULL, 3.493 + `USERDOMAIN` varchar(255) default NULL, 3.494 + `OSNAME` varchar(255) default NULL, 3.495 + `OSVERSION` varchar(255) default NULL, 3.496 + `OSCOMMENTS` varchar(255) default NULL, 3.497 + `PROCESSORT` varchar(255) default NULL, 3.498 + `PROCESSORS` int(11) default '0', 3.499 + `PROCESSORN` smallint(6) default NULL, 3.500 + `MEMORY` int(11) default NULL, 3.501 + `SWAP` int(11) default NULL, 3.502 + `IPADDR` varchar(255) default NULL, 3.503 + `ETIME` datetime default NULL, 3.504 + `LASTDATE` datetime default NULL, 3.505 + `LASTCOME` datetime default NULL, 3.506 + `QUALITY` decimal(4,3) default '0.000', 3.507 + `FIDELITY` bigint(20) default '1', 3.508 + `USERID` varchar(255) default NULL, 3.509 + `TYPE` int(11) default NULL, 3.510 + `DESCRIPTION` varchar(255) default NULL, 3.511 + `WINCOMPANY` varchar(255) default NULL, 3.512 + `WINOWNER` varchar(255) default NULL, 3.513 + `WINPRODID` varchar(255) default NULL, 3.514 + `WINPRODKEY` varchar(255) default NULL, 3.515 + `USERAGENT` varchar(50) default NULL, 3.516 + `CHECKSUM` int(11) default '131071', 3.517 + PRIMARY KEY (`DEVICEID`,`ID`), 3.518 + KEY `NAME` (`NAME`), 3.519 + KEY `CHECKSUM` (`CHECKSUM`), 3.520 + KEY `DEVICEID` (`DEVICEID`), 3.521 + KEY `ID` (`ID`) 3.522 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.523 +SET character_set_client = @saved_cs_client; 3.524 + 3.525 +-- 3.526 +-- Dumping data for table `hardware` 3.527 +-- 3.528 + 3.529 +LOCK TABLES `hardware` WRITE; 3.530 +/*!40000 ALTER TABLE `hardware` DISABLE KEYS */; 3.531 +/*!40000 ALTER TABLE `hardware` ENABLE KEYS */; 3.532 +UNLOCK TABLES; 3.533 + 3.534 +-- 3.535 +-- Table structure for table `inputs` 3.536 +-- 3.537 + 3.538 +DROP TABLE IF EXISTS `inputs`; 3.539 +SET @saved_cs_client = @@character_set_client; 3.540 +SET character_set_client = utf8; 3.541 +CREATE TABLE `inputs` ( 3.542 + `ID` int(11) NOT NULL auto_increment, 3.543 + `HARDWARE_ID` int(11) NOT NULL, 3.544 + `TYPE` varchar(255) default NULL, 3.545 + `MANUFACTURER` varchar(255) default NULL, 3.546 + `CAPTION` varchar(255) default NULL, 3.547 + `DESCRIPTION` varchar(255) default NULL, 3.548 + `INTERFACE` varchar(255) default NULL, 3.549 + `POINTTYPE` varchar(255) default NULL, 3.550 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.551 + KEY `ID` (`ID`) 3.552 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.553 +SET character_set_client = @saved_cs_client; 3.554 + 3.555 +-- 3.556 +-- Dumping data for table `inputs` 3.557 +-- 3.558 + 3.559 +LOCK TABLES `inputs` WRITE; 3.560 +/*!40000 ALTER TABLE `inputs` DISABLE KEYS */; 3.561 +/*!40000 ALTER TABLE `inputs` ENABLE KEYS */; 3.562 +UNLOCK TABLES; 3.563 + 3.564 +-- 3.565 +-- Table structure for table `locks` 3.566 +-- 3.567 + 3.568 +DROP TABLE IF EXISTS `locks`; 3.569 +SET @saved_cs_client = @@character_set_client; 3.570 +SET character_set_client = utf8; 3.571 +CREATE TABLE `locks` ( 3.572 + `HARDWARE_ID` int(11) NOT NULL, 3.573 + `ID` int(11) default NULL, 3.574 + `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 3.575 + PRIMARY KEY (`HARDWARE_ID`), 3.576 + KEY `SINCE` (`SINCE`) 3.577 +) ENGINE=MEMORY DEFAULT CHARSET=latin1; 3.578 +SET character_set_client = @saved_cs_client; 3.579 + 3.580 +-- 3.581 +-- Dumping data for table `locks` 3.582 +-- 3.583 + 3.584 +LOCK TABLES `locks` WRITE; 3.585 +/*!40000 ALTER TABLE `locks` DISABLE KEYS */; 3.586 +/*!40000 ALTER TABLE `locks` ENABLE KEYS */; 3.587 +UNLOCK TABLES; 3.588 + 3.589 +-- 3.590 +-- Table structure for table `memories` 3.591 +-- 3.592 + 3.593 +DROP TABLE IF EXISTS `memories`; 3.594 +SET @saved_cs_client = @@character_set_client; 3.595 +SET character_set_client = utf8; 3.596 +CREATE TABLE `memories` ( 3.597 + `ID` int(11) NOT NULL auto_increment, 3.598 + `HARDWARE_ID` int(11) NOT NULL, 3.599 + `CAPTION` varchar(255) default NULL, 3.600 + `DESCRIPTION` varchar(255) default NULL, 3.601 + `CAPACITY` varchar(255) default NULL, 3.602 + `PURPOSE` varchar(255) default NULL, 3.603 + `TYPE` varchar(255) default NULL, 3.604 + `SPEED` varchar(255) default NULL, 3.605 + `NUMSLOTS` smallint(6) default NULL, 3.606 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.607 + KEY `ID` (`ID`) 3.608 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.609 +SET character_set_client = @saved_cs_client; 3.610 + 3.611 +-- 3.612 +-- Dumping data for table `memories` 3.613 +-- 3.614 + 3.615 +LOCK TABLES `memories` WRITE; 3.616 +/*!40000 ALTER TABLE `memories` DISABLE KEYS */; 3.617 +/*!40000 ALTER TABLE `memories` ENABLE KEYS */; 3.618 +UNLOCK TABLES; 3.619 + 3.620 +-- 3.621 +-- Table structure for table `modems` 3.622 +-- 3.623 + 3.624 +DROP TABLE IF EXISTS `modems`; 3.625 +SET @saved_cs_client = @@character_set_client; 3.626 +SET character_set_client = utf8; 3.627 +CREATE TABLE `modems` ( 3.628 + `ID` int(11) NOT NULL auto_increment, 3.629 + `HARDWARE_ID` int(11) NOT NULL, 3.630 + `NAME` varchar(255) default NULL, 3.631 + `MODEL` varchar(255) default NULL, 3.632 + `DESCRIPTION` varchar(255) default NULL, 3.633 + `TYPE` varchar(255) default NULL, 3.634 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.635 + KEY `ID` (`ID`) 3.636 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.637 +SET character_set_client = @saved_cs_client; 3.638 + 3.639 +-- 3.640 +-- Dumping data for table `modems` 3.641 +-- 3.642 + 3.643 +LOCK TABLES `modems` WRITE; 3.644 +/*!40000 ALTER TABLE `modems` DISABLE KEYS */; 3.645 +/*!40000 ALTER TABLE `modems` ENABLE KEYS */; 3.646 +UNLOCK TABLES; 3.647 + 3.648 +-- 3.649 +-- Table structure for table `monitors` 3.650 +-- 3.651 + 3.652 +DROP TABLE IF EXISTS `monitors`; 3.653 +SET @saved_cs_client = @@character_set_client; 3.654 +SET character_set_client = utf8; 3.655 +CREATE TABLE `monitors` ( 3.656 + `ID` int(11) NOT NULL auto_increment, 3.657 + `HARDWARE_ID` int(11) NOT NULL, 3.658 + `MANUFACTURER` varchar(255) default NULL, 3.659 + `CAPTION` varchar(255) default NULL, 3.660 + `DESCRIPTION` varchar(255) default NULL, 3.661 + `TYPE` varchar(255) default NULL, 3.662 + `SERIAL` varchar(255) default NULL, 3.663 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.664 + KEY `ID` (`ID`) 3.665 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.666 +SET character_set_client = @saved_cs_client; 3.667 + 3.668 +-- 3.669 +-- Dumping data for table `monitors` 3.670 +-- 3.671 + 3.672 +LOCK TABLES `monitors` WRITE; 3.673 +/*!40000 ALTER TABLE `monitors` DISABLE KEYS */; 3.674 +/*!40000 ALTER TABLE `monitors` ENABLE KEYS */; 3.675 +UNLOCK TABLES; 3.676 + 3.677 +-- 3.678 +-- Table structure for table `netmap` 3.679 +-- 3.680 + 3.681 +DROP TABLE IF EXISTS `netmap`; 3.682 +SET @saved_cs_client = @@character_set_client; 3.683 +SET character_set_client = utf8; 3.684 +CREATE TABLE `netmap` ( 3.685 + `IP` varchar(15) NOT NULL, 3.686 + `MAC` varchar(17) NOT NULL, 3.687 + `MASK` varchar(15) NOT NULL, 3.688 + `NETID` varchar(15) NOT NULL, 3.689 + `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP, 3.690 + `NAME` varchar(255) default NULL, 3.691 + PRIMARY KEY (`MAC`), 3.692 + KEY `IP` (`IP`), 3.693 + KEY `NETID` (`NETID`) 3.694 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.695 +SET character_set_client = @saved_cs_client; 3.696 + 3.697 +-- 3.698 +-- Dumping data for table `netmap` 3.699 +-- 3.700 + 3.701 +LOCK TABLES `netmap` WRITE; 3.702 +/*!40000 ALTER TABLE `netmap` DISABLE KEYS */; 3.703 +/*!40000 ALTER TABLE `netmap` ENABLE KEYS */; 3.704 +UNLOCK TABLES; 3.705 + 3.706 +-- 3.707 +-- Table structure for table `network_devices` 3.708 +-- 3.709 + 3.710 +DROP TABLE IF EXISTS `network_devices`; 3.711 +SET @saved_cs_client = @@character_set_client; 3.712 +SET character_set_client = utf8; 3.713 +CREATE TABLE `network_devices` ( 3.714 + `ID` int(11) NOT NULL auto_increment, 3.715 + `DESCRIPTION` varchar(255) default NULL, 3.716 + `TYPE` varchar(255) default NULL, 3.717 + `MACADDR` varchar(255) default NULL, 3.718 + `USER` varchar(255) default NULL, 3.719 + PRIMARY KEY (`ID`), 3.720 + KEY `MACADDR` (`MACADDR`) 3.721 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.722 +SET character_set_client = @saved_cs_client; 3.723 + 3.724 +-- 3.725 +-- Dumping data for table `network_devices` 3.726 +-- 3.727 + 3.728 +LOCK TABLES `network_devices` WRITE; 3.729 +/*!40000 ALTER TABLE `network_devices` DISABLE KEYS */; 3.730 +/*!40000 ALTER TABLE `network_devices` ENABLE KEYS */; 3.731 +UNLOCK TABLES; 3.732 + 3.733 +-- 3.734 +-- Table structure for table `networks` 3.735 +-- 3.736 + 3.737 +DROP TABLE IF EXISTS `networks`; 3.738 +SET @saved_cs_client = @@character_set_client; 3.739 +SET character_set_client = utf8; 3.740 +CREATE TABLE `networks` ( 3.741 + `ID` int(11) NOT NULL auto_increment, 3.742 + `HARDWARE_ID` int(11) NOT NULL, 3.743 + `DESCRIPTION` varchar(255) default NULL, 3.744 + `TYPE` varchar(255) default NULL, 3.745 + `TYPEMIB` varchar(255) default NULL, 3.746 + `SPEED` varchar(255) default NULL, 3.747 + `MACADDR` varchar(255) default NULL, 3.748 + `STATUS` varchar(255) default NULL, 3.749 + `IPADDRESS` varchar(255) default NULL, 3.750 + `IPMASK` varchar(255) default NULL, 3.751 + `IPGATEWAY` varchar(255) default NULL, 3.752 + `IPSUBNET` varchar(255) default NULL, 3.753 + `IPDHCP` varchar(255) default NULL, 3.754 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.755 + KEY `MACADDR` (`MACADDR`), 3.756 + KEY `IPSUBNET` (`IPSUBNET`), 3.757 + KEY `ID` (`ID`) 3.758 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.759 +SET character_set_client = @saved_cs_client; 3.760 + 3.761 +-- 3.762 +-- Dumping data for table `networks` 3.763 +-- 3.764 + 3.765 +LOCK TABLES `networks` WRITE; 3.766 +/*!40000 ALTER TABLE `networks` DISABLE KEYS */; 3.767 +/*!40000 ALTER TABLE `networks` ENABLE KEYS */; 3.768 +UNLOCK TABLES; 3.769 + 3.770 +-- 3.771 +-- Table structure for table `operators` 3.772 +-- 3.773 + 3.774 +DROP TABLE IF EXISTS `operators`; 3.775 +SET @saved_cs_client = @@character_set_client; 3.776 +SET character_set_client = utf8; 3.777 +CREATE TABLE `operators` ( 3.778 + `ID` varchar(255) NOT NULL default '', 3.779 + `FIRSTNAME` varchar(255) default NULL, 3.780 + `LASTNAME` varchar(255) default NULL, 3.781 + `PASSWD` varchar(50) default NULL, 3.782 + `ACCESSLVL` int(11) default NULL, 3.783 + `COMMENTS` text, 3.784 + PRIMARY KEY (`ID`) 3.785 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.786 +SET character_set_client = @saved_cs_client; 3.787 + 3.788 +-- 3.789 +-- Dumping data for table `operators` 3.790 +-- 3.791 + 3.792 +LOCK TABLES `operators` WRITE; 3.793 +/*!40000 ALTER TABLE `operators` DISABLE KEYS */; 3.794 +INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account'); 3.795 +/*!40000 ALTER TABLE `operators` ENABLE KEYS */; 3.796 +UNLOCK TABLES; 3.797 + 3.798 +-- 3.799 +-- Table structure for table `ports` 3.800 +-- 3.801 + 3.802 +DROP TABLE IF EXISTS `ports`; 3.803 +SET @saved_cs_client = @@character_set_client; 3.804 +SET character_set_client = utf8; 3.805 +CREATE TABLE `ports` ( 3.806 + `ID` int(11) NOT NULL auto_increment, 3.807 + `HARDWARE_ID` int(11) NOT NULL, 3.808 + `TYPE` varchar(255) default NULL, 3.809 + `NAME` varchar(255) default NULL, 3.810 + `CAPTION` varchar(255) default NULL, 3.811 + `DESCRIPTION` varchar(255) default NULL, 3.812 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.813 + KEY `ID` (`ID`) 3.814 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.815 +SET character_set_client = @saved_cs_client; 3.816 + 3.817 +-- 3.818 +-- Dumping data for table `ports` 3.819 +-- 3.820 + 3.821 +LOCK TABLES `ports` WRITE; 3.822 +/*!40000 ALTER TABLE `ports` DISABLE KEYS */; 3.823 +/*!40000 ALTER TABLE `ports` ENABLE KEYS */; 3.824 +UNLOCK TABLES; 3.825 + 3.826 +-- 3.827 +-- Table structure for table `printers` 3.828 +-- 3.829 + 3.830 +DROP TABLE IF EXISTS `printers`; 3.831 +SET @saved_cs_client = @@character_set_client; 3.832 +SET character_set_client = utf8; 3.833 +CREATE TABLE `printers` ( 3.834 + `ID` int(11) NOT NULL auto_increment, 3.835 + `HARDWARE_ID` int(11) NOT NULL, 3.836 + `NAME` varchar(255) default NULL, 3.837 + `DRIVER` varchar(255) default NULL, 3.838 + `PORT` varchar(255) default NULL, 3.839 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.840 + KEY `ID` (`ID`) 3.841 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.842 +SET character_set_client = @saved_cs_client; 3.843 + 3.844 +-- 3.845 +-- Dumping data for table `printers` 3.846 +-- 3.847 + 3.848 +LOCK TABLES `printers` WRITE; 3.849 +/*!40000 ALTER TABLE `printers` DISABLE KEYS */; 3.850 +/*!40000 ALTER TABLE `printers` ENABLE KEYS */; 3.851 +UNLOCK TABLES; 3.852 + 3.853 +-- 3.854 +-- Table structure for table `regconfig` 3.855 +-- 3.856 + 3.857 +DROP TABLE IF EXISTS `regconfig`; 3.858 +SET @saved_cs_client = @@character_set_client; 3.859 +SET character_set_client = utf8; 3.860 +CREATE TABLE `regconfig` ( 3.861 + `ID` int(11) NOT NULL auto_increment, 3.862 + `NAME` varchar(255) default NULL, 3.863 + `REGTREE` int(11) default NULL, 3.864 + `REGKEY` text, 3.865 + `REGVALUE` varchar(255) default NULL, 3.866 + PRIMARY KEY (`ID`), 3.867 + KEY `NAME` (`NAME`) 3.868 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.869 +SET character_set_client = @saved_cs_client; 3.870 + 3.871 +-- 3.872 +-- Dumping data for table `regconfig` 3.873 +-- 3.874 + 3.875 +LOCK TABLES `regconfig` WRITE; 3.876 +/*!40000 ALTER TABLE `regconfig` DISABLE KEYS */; 3.877 +/*!40000 ALTER TABLE `regconfig` ENABLE KEYS */; 3.878 +UNLOCK TABLES; 3.879 + 3.880 +-- 3.881 +-- Table structure for table `registry` 3.882 +-- 3.883 + 3.884 +DROP TABLE IF EXISTS `registry`; 3.885 +SET @saved_cs_client = @@character_set_client; 3.886 +SET character_set_client = utf8; 3.887 +CREATE TABLE `registry` ( 3.888 + `ID` int(11) NOT NULL auto_increment, 3.889 + `HARDWARE_ID` int(11) NOT NULL, 3.890 + `NAME` varchar(255) default NULL, 3.891 + `REGVALUE` varchar(255) default NULL, 3.892 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.893 + KEY `NAME` (`NAME`), 3.894 + KEY `ID` (`ID`) 3.895 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.896 +SET character_set_client = @saved_cs_client; 3.897 + 3.898 +-- 3.899 +-- Dumping data for table `registry` 3.900 +-- 3.901 + 3.902 +LOCK TABLES `registry` WRITE; 3.903 +/*!40000 ALTER TABLE `registry` DISABLE KEYS */; 3.904 +/*!40000 ALTER TABLE `registry` ENABLE KEYS */; 3.905 +UNLOCK TABLES; 3.906 + 3.907 +-- 3.908 +-- Table structure for table `slots` 3.909 +-- 3.910 + 3.911 +DROP TABLE IF EXISTS `slots`; 3.912 +SET @saved_cs_client = @@character_set_client; 3.913 +SET character_set_client = utf8; 3.914 +CREATE TABLE `slots` ( 3.915 + `ID` int(11) NOT NULL auto_increment, 3.916 + `HARDWARE_ID` int(11) NOT NULL, 3.917 + `NAME` varchar(255) default NULL, 3.918 + `DESCRIPTION` varchar(255) default NULL, 3.919 + `DESIGNATION` varchar(255) default NULL, 3.920 + `PURPOSE` varchar(255) default NULL, 3.921 + `STATUS` varchar(255) default NULL, 3.922 + `PSHARE` tinyint(4) default NULL, 3.923 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.924 + KEY `ID` (`ID`) 3.925 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.926 +SET character_set_client = @saved_cs_client; 3.927 + 3.928 +-- 3.929 +-- Dumping data for table `slots` 3.930 +-- 3.931 + 3.932 +LOCK TABLES `slots` WRITE; 3.933 +/*!40000 ALTER TABLE `slots` DISABLE KEYS */; 3.934 +/*!40000 ALTER TABLE `slots` ENABLE KEYS */; 3.935 +UNLOCK TABLES; 3.936 + 3.937 +-- 3.938 +-- Table structure for table `softwares` 3.939 +-- 3.940 + 3.941 +DROP TABLE IF EXISTS `softwares`; 3.942 +SET @saved_cs_client = @@character_set_client; 3.943 +SET character_set_client = utf8; 3.944 +CREATE TABLE `softwares` ( 3.945 + `ID` int(11) NOT NULL auto_increment, 3.946 + `HARDWARE_ID` int(11) NOT NULL, 3.947 + `PUBLISHER` varchar(255) default NULL, 3.948 + `NAME` varchar(255) default NULL, 3.949 + `VERSION` varchar(255) default NULL, 3.950 + `FOLDER` text, 3.951 + `COMMENTS` text, 3.952 + `FILENAME` varchar(255) default NULL, 3.953 + `FILESIZE` int(11) default '0', 3.954 + `SOURCE` int(11) default NULL, 3.955 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.956 + KEY `NAME` (`NAME`), 3.957 + KEY `ID` (`ID`) 3.958 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.959 +SET character_set_client = @saved_cs_client; 3.960 + 3.961 +-- 3.962 +-- Dumping data for table `softwares` 3.963 +-- 3.964 + 3.965 +LOCK TABLES `softwares` WRITE; 3.966 +/*!40000 ALTER TABLE `softwares` DISABLE KEYS */; 3.967 +/*!40000 ALTER TABLE `softwares` ENABLE KEYS */; 3.968 +UNLOCK TABLES; 3.969 + 3.970 +-- 3.971 +-- Table structure for table `sounds` 3.972 +-- 3.973 + 3.974 +DROP TABLE IF EXISTS `sounds`; 3.975 +SET @saved_cs_client = @@character_set_client; 3.976 +SET character_set_client = utf8; 3.977 +CREATE TABLE `sounds` ( 3.978 + `ID` int(11) NOT NULL auto_increment, 3.979 + `HARDWARE_ID` int(11) NOT NULL, 3.980 + `MANUFACTURER` varchar(255) default NULL, 3.981 + `NAME` varchar(255) default NULL, 3.982 + `DESCRIPTION` varchar(255) default NULL, 3.983 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.984 + KEY `ID` (`ID`) 3.985 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.986 +SET character_set_client = @saved_cs_client; 3.987 + 3.988 +-- 3.989 +-- Dumping data for table `sounds` 3.990 +-- 3.991 + 3.992 +LOCK TABLES `sounds` WRITE; 3.993 +/*!40000 ALTER TABLE `sounds` DISABLE KEYS */; 3.994 +/*!40000 ALTER TABLE `sounds` ENABLE KEYS */; 3.995 +UNLOCK TABLES; 3.996 + 3.997 +-- 3.998 +-- Table structure for table `storages` 3.999 +-- 3.1000 + 3.1001 +DROP TABLE IF EXISTS `storages`; 3.1002 +SET @saved_cs_client = @@character_set_client; 3.1003 +SET character_set_client = utf8; 3.1004 +CREATE TABLE `storages` ( 3.1005 + `ID` int(11) NOT NULL auto_increment, 3.1006 + `HARDWARE_ID` int(11) NOT NULL, 3.1007 + `MANUFACTURER` varchar(255) default NULL, 3.1008 + `NAME` varchar(255) default NULL, 3.1009 + `MODEL` varchar(255) default NULL, 3.1010 + `DESCRIPTION` varchar(255) default NULL, 3.1011 + `TYPE` varchar(255) default NULL, 3.1012 + `DISKSIZE` int(11) default NULL, 3.1013 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.1014 + KEY `ID` (`ID`) 3.1015 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.1016 +SET character_set_client = @saved_cs_client; 3.1017 + 3.1018 +-- 3.1019 +-- Dumping data for table `storages` 3.1020 +-- 3.1021 + 3.1022 +LOCK TABLES `storages` WRITE; 3.1023 +/*!40000 ALTER TABLE `storages` DISABLE KEYS */; 3.1024 +/*!40000 ALTER TABLE `storages` ENABLE KEYS */; 3.1025 +UNLOCK TABLES; 3.1026 + 3.1027 +-- 3.1028 +-- Table structure for table `subnet` 3.1029 +-- 3.1030 + 3.1031 +DROP TABLE IF EXISTS `subnet`; 3.1032 +SET @saved_cs_client = @@character_set_client; 3.1033 +SET character_set_client = utf8; 3.1034 +CREATE TABLE `subnet` ( 3.1035 + `NETID` varchar(15) NOT NULL, 3.1036 + `NAME` varchar(255) default NULL, 3.1037 + `ID` int(11) default NULL, 3.1038 + `MASK` varchar(255) default NULL, 3.1039 + PRIMARY KEY (`NETID`) 3.1040 +) ENGINE=MyISAM DEFAULT CHARSET=latin1; 3.1041 +SET character_set_client = @saved_cs_client; 3.1042 + 3.1043 +-- 3.1044 +-- Dumping data for table `subnet` 3.1045 +-- 3.1046 + 3.1047 +LOCK TABLES `subnet` WRITE; 3.1048 +/*!40000 ALTER TABLE `subnet` DISABLE KEYS */; 3.1049 +/*!40000 ALTER TABLE `subnet` ENABLE KEYS */; 3.1050 +UNLOCK TABLES; 3.1051 + 3.1052 +-- 3.1053 +-- Table structure for table `videos` 3.1054 +-- 3.1055 + 3.1056 +DROP TABLE IF EXISTS `videos`; 3.1057 +SET @saved_cs_client = @@character_set_client; 3.1058 +SET character_set_client = utf8; 3.1059 +CREATE TABLE `videos` ( 3.1060 + `ID` int(11) NOT NULL auto_increment, 3.1061 + `HARDWARE_ID` int(11) NOT NULL, 3.1062 + `NAME` varchar(255) default NULL, 3.1063 + `CHIPSET` varchar(255) default NULL, 3.1064 + `MEMORY` varchar(255) default NULL, 3.1065 + `RESOLUTION` varchar(255) default NULL, 3.1066 + PRIMARY KEY (`HARDWARE_ID`,`ID`), 3.1067 + KEY `ID` (`ID`) 3.1068 +) ENGINE=InnoDB DEFAULT CHARSET=latin1; 3.1069 +SET character_set_client = @saved_cs_client; 3.1070 + 3.1071 +-- 3.1072 +-- Dumping data for table `videos` 3.1073 +-- 3.1074 + 3.1075 +LOCK TABLES `videos` WRITE; 3.1076 +/*!40000 ALTER TABLE `videos` DISABLE KEYS */; 3.1077 +/*!40000 ALTER TABLE `videos` ENABLE KEYS */; 3.1078 +UNLOCK TABLES; 3.1079 +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 3.1080 + 3.1081 +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 3.1082 +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 3.1083 +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 3.1084 +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 3.1085 +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 3.1086 +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 3.1087 +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 3.1088 + 3.1089 +-- Dump completed on 2009-04-25 0:01:16