# HG changeset patch
# User Eric Joseph-Alexandre <erjo@slitaz.org>
# Date 1247307509 -7200
# Node ID 6cf13fdfcede6e54caee23946b04a852d10acbfb
# Parent  76e84daf36d7dc650d919961e014f19234eeaa49
Add ocsreports

diff -r 76e84daf36d7 -r 6cf13fdfcede ocsreports/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/ocsreports/receipt	Sat Jul 11 12:18:29 2009 +0200
@@ -0,0 +1,109 @@
+# SliTaz package receipt.
+
+PACKAGE="ocsreports"
+VERSION="1.02.1"
+CATEGORY="network"
+SHORT_DESC="Inventory and package deployement system"
+MAINTAINER="pascal.bellard@slitaz.org"
+DEPENDS="php-apache php-mysql mysql"
+WANTED="ocsinventory"
+SOURCE="OCSNG_UNIX_SERVER"
+TARBALL="${SOURCE}_${VERSION}.tar.gz"
+WEB_SITE="http://www.ocsinventory-ng.org/"
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	src=$WOK/$WANTED/$SOURCE-$VERSION
+	
+	mkdir -p $fs/usr/share \
+		$fs/etc/ocsreports
+		
+	cp -a $WOK/$WANTED/${SOURCE}-${VERSION}/${PACKAGE} $fs/usr/share/
+	cat > $fs/etc/ocsreports/dbconfig.inc.php <<EOT
+<?php 
+	\$_SESSION["SERVEUR_SQL"]="localhost";
+	\$_SESSION["COMPTE_BASE"]="ocs";
+	\$_SESSION["PSWD_BASE"]="ocs";
+?>
+EOT
+
+	install -o root -g www -m 0755 $src/Apache/binutils/ipdiscover-util.pl \
+		$fs/usr/share/ocsreports/ipdiscover-util.pl
+
+	rm -f $fs/usr/share/${PACKAGE}/dbconfig.inc.php
+	cd $fs/usr/share/${PACKAGE} ; ln -s /etc/ocsreports/dbconfig.inc.php ; cd -
+
+	# Remove doc file.
+	rm -f  $fs/usr/share/ocsreports/files/*.pdf
+}
+
+post_install()
+{
+	# Configure apache server
+	if [ -f $1/etc/apache/httpd.conf ]; then
+		if [ ! -f $1/etc/apache/conf.d/$PACKAGE ]; then
+			cat > $1/etc/apache/conf.d/$PACKAGE <<EOT
+<IfModule mod_alias.c>
+    Alias /$PACKAGE /usr/share/$PACKAGE/
+</IfModule>
+<Directory "/usr/share/$PACKAGE">
+	Options Indexes FollowSymLinks
+	AllowOverride None
+	Order deny,allow
+	Allow from all
+</Directory>
+
+EOT
+			if [ -z "$1" ]; then
+				# Start Web server.
+				test -f /var/run/apache/httpd.pid && \
+					( kill -0 $(cat /var/run/apache/httpd.pid) && /etc/init.d/apache restart )
+			fi
+		fi
+	fi
+
+	# Configure every thing for ocsweb.
+	if [ -z $1 ]; then
+		if ( ! mysqladmin -s ping > /dev/null ); then
+			echo "Starting MySQL server"
+			( /etc/init.d/mysql start ; status  ) || exit 
+			sleep 4 #let the mysql daemon start
+		fi
+		if ( ! mysql -Be 'show databases' | grep -q ocsweb ); then
+			echo -n "Create $PACKAGE database and schema"
+		#	mysql -Be "create database ocsweb" ; status
+			mysql -f -s -u root < /usr/share/$PACKAGE/files/ocsbase.sql > /dev/null 2>&1
+			# We suppose that ocs user does not exist.
+			# It may be false.
+			echo  -n "Create user ocs with password ocs"
+			mysql -Be "grant all privileges on ocsweb.* to 'ocs'@'localhost' 
+				identified by 'ocs'" ; status
+		fi
+			
+	fi
+}
+
+post_remove()
+{
+		echo -n "Would you like to remove data and database files.(y/n) "
+		read answer
+
+		case $answer in 
+		y|Y)
+			echo -n "Removing data directories..."
+			rm -rf /usr/share/ocsreports
+			if ( mysql -Be 'show databases' | grep -q ocsweb ); then
+				echo -n "Deleting ocsreports database;"
+				mysql -u root -Be "drop database ocsweb;" ; status
+				echo  -n "Delete user ocs"
+				mysql -u root -Be "delete from mysql.db where user=ocs;" ; status
+			fi
+			unset $answer
+			;;
+		*)
+			;;
+		esac
+	
+}
+
diff -r 76e84daf36d7 -r 6cf13fdfcede ocsreports/stuff/dbconfig.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/ocsreports/stuff/dbconfig.inc.php	Sat Jul 11 12:18:29 2009 +0200
@@ -0,0 +1,5 @@
+<?php 
+$_SESSION["SERVEUR_SQL"]="localhost";
+$_SESSION["COMPTE_BASE"]="ocs";
+$_SESSION["PSWD_BASE"]="ocs";
+?>
\ No newline at end of file
diff -r 76e84daf36d7 -r 6cf13fdfcede ocsreports/stuff/ocsbase.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/ocsreports/stuff/ocsbase.sql	Sat Jul 11 12:18:29 2009 +0200
@@ -0,0 +1,1086 @@
+-- MySQL dump 10.11
+--
+-- Host: localhost    Database: ocsweb
+-- ------------------------------------------------------
+-- Server version	5.0.51b-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `accesslog`
+--
+USE ocsweb;
+
+DROP TABLE IF EXISTS `accesslog`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `accesslog` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `USERID` varchar(255) default NULL,
+  `LOGDATE` datetime default NULL,
+  `PROCESSES` text,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `accesslog`
+--
+
+LOCK TABLES `accesslog` WRITE;
+/*!40000 ALTER TABLE `accesslog` DISABLE KEYS */;
+/*!40000 ALTER TABLE `accesslog` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `accountinfo`
+--
+
+DROP TABLE IF EXISTS `accountinfo`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `accountinfo` (
+  `HARDWARE_ID` int(11) NOT NULL,
+  `TAG` varchar(255) default 'NA',
+  PRIMARY KEY  (`HARDWARE_ID`),
+  KEY `TAG` (`TAG`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `accountinfo`
+--
+
+LOCK TABLES `accountinfo` WRITE;
+/*!40000 ALTER TABLE `accountinfo` DISABLE KEYS */;
+/*!40000 ALTER TABLE `accountinfo` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `bios`
+--
+
+DROP TABLE IF EXISTS `bios`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `bios` (
+  `HARDWARE_ID` int(11) NOT NULL,
+  `SMANUFACTURER` varchar(255) default NULL,
+  `SMODEL` varchar(255) default NULL,
+  `SSN` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `BMANUFACTURER` varchar(255) default NULL,
+  `BVERSION` varchar(255) default NULL,
+  `BDATE` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`),
+  KEY `SSN` (`SSN`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `bios`
+--
+
+LOCK TABLES `bios` WRITE;
+/*!40000 ALTER TABLE `bios` DISABLE KEYS */;
+/*!40000 ALTER TABLE `bios` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `config`
+--
+
+DROP TABLE IF EXISTS `config`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `config` (
+  `NAME` varchar(50) NOT NULL,
+  `IVALUE` int(11) default NULL,
+  `TVALUE` varchar(255) default NULL,
+  `COMMENTS` text,
+  PRIMARY KEY  (`NAME`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `config`
+--
+
+LOCK TABLES `config` WRITE;
+/*!40000 ALTER TABLE `config` DISABLE KEYS */;
+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');
+/*!40000 ALTER TABLE `config` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `conntrack`
+--
+
+DROP TABLE IF EXISTS `conntrack`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `conntrack` (
+  `IP` varchar(255) NOT NULL default '',
+  `TIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  PRIMARY KEY  (`IP`)
+) ENGINE=MEMORY DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `conntrack`
+--
+
+LOCK TABLES `conntrack` WRITE;
+/*!40000 ALTER TABLE `conntrack` DISABLE KEYS */;
+/*!40000 ALTER TABLE `conntrack` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `controllers`
+--
+
+DROP TABLE IF EXISTS `controllers`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `controllers` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `MANUFACTURER` varchar(255) default NULL,
+  `NAME` varchar(255) default NULL,
+  `CAPTION` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `VERSION` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `controllers`
+--
+
+LOCK TABLES `controllers` WRITE;
+/*!40000 ALTER TABLE `controllers` DISABLE KEYS */;
+/*!40000 ALTER TABLE `controllers` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `deleted_equiv`
+--
+
+DROP TABLE IF EXISTS `deleted_equiv`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `deleted_equiv` (
+  `DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `DELETED` varchar(255) NOT NULL,
+  `EQUIVALENT` varchar(255) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `deleted_equiv`
+--
+
+LOCK TABLES `deleted_equiv` WRITE;
+/*!40000 ALTER TABLE `deleted_equiv` DISABLE KEYS */;
+/*!40000 ALTER TABLE `deleted_equiv` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `deploy`
+--
+
+DROP TABLE IF EXISTS `deploy`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `deploy` (
+  `NAME` varchar(255) NOT NULL,
+  `CONTENT` longblob NOT NULL,
+  PRIMARY KEY  (`NAME`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `deploy`
+--
+
+LOCK TABLES `deploy` WRITE;
+/*!40000 ALTER TABLE `deploy` DISABLE KEYS */;
+/*!40000 ALTER TABLE `deploy` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `devices`
+--
+
+DROP TABLE IF EXISTS `devices`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `devices` (
+  `HARDWARE_ID` int(11) NOT NULL,
+  `NAME` varchar(50) NOT NULL,
+  `IVALUE` int(11) default NULL,
+  `TVALUE` varchar(255) default NULL,
+  `COMMENTS` text,
+  KEY `HARDWARE_ID` (`HARDWARE_ID`),
+  KEY `TVALUE` (`TVALUE`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `devices`
+--
+
+LOCK TABLES `devices` WRITE;
+/*!40000 ALTER TABLE `devices` DISABLE KEYS */;
+/*!40000 ALTER TABLE `devices` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `devicetype`
+--
+
+DROP TABLE IF EXISTS `devicetype`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `devicetype` (
+  `ID` int(11) NOT NULL auto_increment,
+  `NAME` varchar(255) default NULL,
+  PRIMARY KEY  (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `devicetype`
+--
+
+LOCK TABLES `devicetype` WRITE;
+/*!40000 ALTER TABLE `devicetype` DISABLE KEYS */;
+/*!40000 ALTER TABLE `devicetype` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `dico_cat`
+--
+
+DROP TABLE IF EXISTS `dico_cat`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `dico_cat` (
+  `NAME` varchar(255) NOT NULL,
+  `PERMANENT` tinyint(4) default '0',
+  PRIMARY KEY  (`NAME`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `dico_cat`
+--
+
+LOCK TABLES `dico_cat` WRITE;
+/*!40000 ALTER TABLE `dico_cat` DISABLE KEYS */;
+/*!40000 ALTER TABLE `dico_cat` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `dico_ignored`
+--
+
+DROP TABLE IF EXISTS `dico_ignored`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `dico_ignored` (
+  `EXTRACTED` varchar(255) NOT NULL,
+  PRIMARY KEY  (`EXTRACTED`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `dico_ignored`
+--
+
+LOCK TABLES `dico_ignored` WRITE;
+/*!40000 ALTER TABLE `dico_ignored` DISABLE KEYS */;
+/*!40000 ALTER TABLE `dico_ignored` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `dico_soft`
+--
+
+DROP TABLE IF EXISTS `dico_soft`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `dico_soft` (
+  `EXTRACTED` varchar(255) NOT NULL,
+  `FORMATTED` varchar(255) NOT NULL,
+  PRIMARY KEY  (`EXTRACTED`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `dico_soft`
+--
+
+LOCK TABLES `dico_soft` WRITE;
+/*!40000 ALTER TABLE `dico_soft` DISABLE KEYS */;
+/*!40000 ALTER TABLE `dico_soft` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `download_available`
+--
+
+DROP TABLE IF EXISTS `download_available`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `download_available` (
+  `FILEID` varchar(255) NOT NULL,
+  `NAME` varchar(255) NOT NULL,
+  `PRIORITY` int(11) NOT NULL,
+  `FRAGMENTS` int(11) NOT NULL,
+  `SIZE` int(11) NOT NULL,
+  `OSNAME` varchar(255) NOT NULL,
+  `COMMENT` text,
+  PRIMARY KEY  (`FILEID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `download_available`
+--
+
+LOCK TABLES `download_available` WRITE;
+/*!40000 ALTER TABLE `download_available` DISABLE KEYS */;
+/*!40000 ALTER TABLE `download_available` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `download_enable`
+--
+
+DROP TABLE IF EXISTS `download_enable`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `download_enable` (
+  `ID` int(11) NOT NULL auto_increment,
+  `FILEID` varchar(255) NOT NULL,
+  `INFO_LOC` varchar(255) NOT NULL,
+  `PACK_LOC` varchar(255) NOT NULL,
+  `CERT_PATH` varchar(255) default NULL,
+  `CERT_FILE` varchar(255) default NULL,
+  PRIMARY KEY  (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `download_enable`
+--
+
+LOCK TABLES `download_enable` WRITE;
+/*!40000 ALTER TABLE `download_enable` DISABLE KEYS */;
+/*!40000 ALTER TABLE `download_enable` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `download_history`
+--
+
+DROP TABLE IF EXISTS `download_history`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `download_history` (
+  `HARDWARE_ID` int(11) NOT NULL,
+  `PKG_ID` int(11) NOT NULL default '0',
+  `PKG_NAME` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`PKG_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `download_history`
+--
+
+LOCK TABLES `download_history` WRITE;
+/*!40000 ALTER TABLE `download_history` DISABLE KEYS */;
+/*!40000 ALTER TABLE `download_history` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `drives`
+--
+
+DROP TABLE IF EXISTS `drives`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `drives` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `LETTER` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `FILESYSTEM` varchar(255) default NULL,
+  `TOTAL` int(11) default NULL,
+  `FREE` int(11) default NULL,
+  `NUMFILES` int(11) default NULL,
+  `VOLUMN` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `drives`
+--
+
+LOCK TABLES `drives` WRITE;
+/*!40000 ALTER TABLE `drives` DISABLE KEYS */;
+/*!40000 ALTER TABLE `drives` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `files`
+--
+
+DROP TABLE IF EXISTS `files`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+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 DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `files`
+--
+
+LOCK TABLES `files` WRITE;
+/*!40000 ALTER TABLE `files` DISABLE KEYS */;
+/*!40000 ALTER TABLE `files` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `hardware`
+--
+
+DROP TABLE IF EXISTS `hardware`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `hardware` (
+  `ID` int(11) NOT NULL auto_increment,
+  `DEVICEID` varchar(255) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `WORKGROUP` varchar(255) default NULL,
+  `USERDOMAIN` varchar(255) default NULL,
+  `OSNAME` varchar(255) default NULL,
+  `OSVERSION` varchar(255) default NULL,
+  `OSCOMMENTS` varchar(255) default NULL,
+  `PROCESSORT` varchar(255) default NULL,
+  `PROCESSORS` int(11) default '0',
+  `PROCESSORN` smallint(6) default NULL,
+  `MEMORY` int(11) default NULL,
+  `SWAP` int(11) default NULL,
+  `IPADDR` varchar(255) default NULL,
+  `ETIME` datetime default NULL,
+  `LASTDATE` datetime default NULL,
+  `LASTCOME` datetime default NULL,
+  `QUALITY` decimal(4,3) default '0.000',
+  `FIDELITY` bigint(20) default '1',
+  `USERID` varchar(255) default NULL,
+  `TYPE` int(11) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `WINCOMPANY` varchar(255) default NULL,
+  `WINOWNER` varchar(255) default NULL,
+  `WINPRODID` varchar(255) default NULL,
+  `WINPRODKEY` varchar(255) default NULL,
+  `USERAGENT` varchar(50) default NULL,
+  `CHECKSUM` int(11) default '131071',
+  PRIMARY KEY  (`DEVICEID`,`ID`),
+  KEY `NAME` (`NAME`),
+  KEY `CHECKSUM` (`CHECKSUM`),
+  KEY `DEVICEID` (`DEVICEID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `hardware`
+--
+
+LOCK TABLES `hardware` WRITE;
+/*!40000 ALTER TABLE `hardware` DISABLE KEYS */;
+/*!40000 ALTER TABLE `hardware` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `inputs`
+--
+
+DROP TABLE IF EXISTS `inputs`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `inputs` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `TYPE` varchar(255) default NULL,
+  `MANUFACTURER` varchar(255) default NULL,
+  `CAPTION` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `INTERFACE` varchar(255) default NULL,
+  `POINTTYPE` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `inputs`
+--
+
+LOCK TABLES `inputs` WRITE;
+/*!40000 ALTER TABLE `inputs` DISABLE KEYS */;
+/*!40000 ALTER TABLE `inputs` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `locks`
+--
+
+DROP TABLE IF EXISTS `locks`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `locks` (
+  `HARDWARE_ID` int(11) NOT NULL,
+  `ID` int(11) default NULL,
+  `SINCE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  PRIMARY KEY  (`HARDWARE_ID`),
+  KEY `SINCE` (`SINCE`)
+) ENGINE=MEMORY DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `locks`
+--
+
+LOCK TABLES `locks` WRITE;
+/*!40000 ALTER TABLE `locks` DISABLE KEYS */;
+/*!40000 ALTER TABLE `locks` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `memories`
+--
+
+DROP TABLE IF EXISTS `memories`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `memories` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `CAPTION` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `CAPACITY` varchar(255) default NULL,
+  `PURPOSE` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `SPEED` varchar(255) default NULL,
+  `NUMSLOTS` smallint(6) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `memories`
+--
+
+LOCK TABLES `memories` WRITE;
+/*!40000 ALTER TABLE `memories` DISABLE KEYS */;
+/*!40000 ALTER TABLE `memories` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `modems`
+--
+
+DROP TABLE IF EXISTS `modems`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `modems` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `MODEL` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `modems`
+--
+
+LOCK TABLES `modems` WRITE;
+/*!40000 ALTER TABLE `modems` DISABLE KEYS */;
+/*!40000 ALTER TABLE `modems` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `monitors`
+--
+
+DROP TABLE IF EXISTS `monitors`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `monitors` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `MANUFACTURER` varchar(255) default NULL,
+  `CAPTION` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `SERIAL` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `monitors`
+--
+
+LOCK TABLES `monitors` WRITE;
+/*!40000 ALTER TABLE `monitors` DISABLE KEYS */;
+/*!40000 ALTER TABLE `monitors` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `netmap`
+--
+
+DROP TABLE IF EXISTS `netmap`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+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 DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `netmap`
+--
+
+LOCK TABLES `netmap` WRITE;
+/*!40000 ALTER TABLE `netmap` DISABLE KEYS */;
+/*!40000 ALTER TABLE `netmap` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `network_devices`
+--
+
+DROP TABLE IF EXISTS `network_devices`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `network_devices` (
+  `ID` int(11) NOT NULL auto_increment,
+  `DESCRIPTION` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `MACADDR` varchar(255) default NULL,
+  `USER` varchar(255) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `MACADDR` (`MACADDR`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `network_devices`
+--
+
+LOCK TABLES `network_devices` WRITE;
+/*!40000 ALTER TABLE `network_devices` DISABLE KEYS */;
+/*!40000 ALTER TABLE `network_devices` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `networks`
+--
+
+DROP TABLE IF EXISTS `networks`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `networks` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `TYPEMIB` varchar(255) default NULL,
+  `SPEED` varchar(255) default NULL,
+  `MACADDR` varchar(255) default NULL,
+  `STATUS` varchar(255) default NULL,
+  `IPADDRESS` varchar(255) default NULL,
+  `IPMASK` varchar(255) default NULL,
+  `IPGATEWAY` varchar(255) default NULL,
+  `IPSUBNET` varchar(255) default NULL,
+  `IPDHCP` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `MACADDR` (`MACADDR`),
+  KEY `IPSUBNET` (`IPSUBNET`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `networks`
+--
+
+LOCK TABLES `networks` WRITE;
+/*!40000 ALTER TABLE `networks` DISABLE KEYS */;
+/*!40000 ALTER TABLE `networks` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `operators`
+--
+
+DROP TABLE IF EXISTS `operators`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+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` int(11) default NULL,
+  `COMMENTS` text,
+  PRIMARY KEY  (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `operators`
+--
+
+LOCK TABLES `operators` WRITE;
+/*!40000 ALTER TABLE `operators` DISABLE KEYS */;
+INSERT INTO `operators` VALUES ('admin','admin','admin','admin',1,'Default administrator account');
+/*!40000 ALTER TABLE `operators` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `ports`
+--
+
+DROP TABLE IF EXISTS `ports`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `ports` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `TYPE` varchar(255) default NULL,
+  `NAME` varchar(255) default NULL,
+  `CAPTION` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `ports`
+--
+
+LOCK TABLES `ports` WRITE;
+/*!40000 ALTER TABLE `ports` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ports` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `printers`
+--
+
+DROP TABLE IF EXISTS `printers`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `printers` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `DRIVER` varchar(255) default NULL,
+  `PORT` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `printers`
+--
+
+LOCK TABLES `printers` WRITE;
+/*!40000 ALTER TABLE `printers` DISABLE KEYS */;
+/*!40000 ALTER TABLE `printers` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `regconfig`
+--
+
+DROP TABLE IF EXISTS `regconfig`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `regconfig` (
+  `ID` int(11) NOT NULL auto_increment,
+  `NAME` varchar(255) default NULL,
+  `REGTREE` int(11) default NULL,
+  `REGKEY` text,
+  `REGVALUE` varchar(255) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `NAME` (`NAME`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `regconfig`
+--
+
+LOCK TABLES `regconfig` WRITE;
+/*!40000 ALTER TABLE `regconfig` DISABLE KEYS */;
+/*!40000 ALTER TABLE `regconfig` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `registry`
+--
+
+DROP TABLE IF EXISTS `registry`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `registry` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `REGVALUE` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `NAME` (`NAME`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `registry`
+--
+
+LOCK TABLES `registry` WRITE;
+/*!40000 ALTER TABLE `registry` DISABLE KEYS */;
+/*!40000 ALTER TABLE `registry` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `slots`
+--
+
+DROP TABLE IF EXISTS `slots`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `slots` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `DESIGNATION` varchar(255) default NULL,
+  `PURPOSE` varchar(255) default NULL,
+  `STATUS` varchar(255) default NULL,
+  `PSHARE` tinyint(4) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `slots`
+--
+
+LOCK TABLES `slots` WRITE;
+/*!40000 ALTER TABLE `slots` DISABLE KEYS */;
+/*!40000 ALTER TABLE `slots` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `softwares`
+--
+
+DROP TABLE IF EXISTS `softwares`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `softwares` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `PUBLISHER` varchar(255) default NULL,
+  `NAME` varchar(255) default NULL,
+  `VERSION` varchar(255) default NULL,
+  `FOLDER` text,
+  `COMMENTS` text,
+  `FILENAME` varchar(255) default NULL,
+  `FILESIZE` int(11) default '0',
+  `SOURCE` int(11) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `NAME` (`NAME`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `softwares`
+--
+
+LOCK TABLES `softwares` WRITE;
+/*!40000 ALTER TABLE `softwares` DISABLE KEYS */;
+/*!40000 ALTER TABLE `softwares` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `sounds`
+--
+
+DROP TABLE IF EXISTS `sounds`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `sounds` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `MANUFACTURER` varchar(255) default NULL,
+  `NAME` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `sounds`
+--
+
+LOCK TABLES `sounds` WRITE;
+/*!40000 ALTER TABLE `sounds` DISABLE KEYS */;
+/*!40000 ALTER TABLE `sounds` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `storages`
+--
+
+DROP TABLE IF EXISTS `storages`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `storages` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `MANUFACTURER` varchar(255) default NULL,
+  `NAME` varchar(255) default NULL,
+  `MODEL` varchar(255) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `TYPE` varchar(255) default NULL,
+  `DISKSIZE` int(11) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `storages`
+--
+
+LOCK TABLES `storages` WRITE;
+/*!40000 ALTER TABLE `storages` DISABLE KEYS */;
+/*!40000 ALTER TABLE `storages` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `subnet`
+--
+
+DROP TABLE IF EXISTS `subnet`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `subnet` (
+  `NETID` varchar(15) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `ID` int(11) default NULL,
+  `MASK` varchar(255) default NULL,
+  PRIMARY KEY  (`NETID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `subnet`
+--
+
+LOCK TABLES `subnet` WRITE;
+/*!40000 ALTER TABLE `subnet` DISABLE KEYS */;
+/*!40000 ALTER TABLE `subnet` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `videos`
+--
+
+DROP TABLE IF EXISTS `videos`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `videos` (
+  `ID` int(11) NOT NULL auto_increment,
+  `HARDWARE_ID` int(11) NOT NULL,
+  `NAME` varchar(255) default NULL,
+  `CHIPSET` varchar(255) default NULL,
+  `MEMORY` varchar(255) default NULL,
+  `RESOLUTION` varchar(255) default NULL,
+  PRIMARY KEY  (`HARDWARE_ID`,`ID`),
+  KEY `ID` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `videos`
+--
+
+LOCK TABLES `videos` WRITE;
+/*!40000 ALTER TABLE `videos` DISABLE KEYS */;
+/*!40000 ALTER TABLE `videos` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2009-04-25  0:01:16