wok-6.x 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