-- MySQL dump 10.13  Distrib 5.1.63, for debian-linux-gnu (i686)
--
-- Host: localhost    Database: d_acs
-- ------------------------------------------------------
-- Server version	5.1.63-0ubuntu0.11.10.1

/*!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 */;

--
-- Current Database: `d_acs`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `d_acs` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `d_acs`;

--
-- Table structure for table `device`
--

DROP TABLE IF EXISTS `device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device` (
  `serial_number` varchar(100) NOT NULL,
  `manufacturer` varchar(100) DEFAULT NULL,
  `oui` varchar(100) DEFAULT NULL,
  `product_class` varchar(100) DEFAULT NULL,
  `subscriber_id` int(11) NOT NULL,
  `network_id` int(11) NOT NULL,
  `model_id` int(11) NOT NULL,
  PRIMARY KEY (`serial_number`),
  KEY `subscriber_id` (`subscriber_id`),
  KEY `network_id` (`network_id`),
  CONSTRAINT `device_fk` FOREIGN KEY (`subscriber_id`) REFERENCES `subscriber` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `device_fk1` FOREIGN KEY (`network_id`) REFERENCES `network` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device`
--

LOCK TABLES `device` WRITE;
/*!40000 ALTER TABLE `device` DISABLE KEYS */;
INSERT INTO `device` VALUES ('340804DD05AC','D-LINK','340804','DIR router',1,1,9);
/*!40000 ALTER TABLE `device` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_identy`
--

DROP TABLE IF EXISTS `device_identy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device_identy` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `serial` varchar(16) NOT NULL,
  `authType` varchar(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device_identy`
--

LOCK TABLES `device_identy` WRITE;
/*!40000 ALTER TABLE `device_identy` DISABLE KEYS */;
INSERT INTO `device_identy` VALUES (32,'14D64D88B276','1'),(33,'340804E21970','1'),(34,'340804DD05AC','0');
/*!40000 ALTER TABLE `device_identy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_param`
--

DROP TABLE IF EXISTS `device_param`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device_param` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial_number` varchar(100) NOT NULL,
  `param_id` int(11) NOT NULL,
  `param_value` varchar(200) DEFAULT NULL,
  `creation_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `serial_number` (`serial_number`),
  KEY `param_id` (`param_id`),
  CONSTRAINT `device_params_fk` FOREIGN KEY (`param_id`) REFERENCES `parameter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `parameterlist_fk` FOREIGN KEY (`serial_number`) REFERENCES `device` (`serial_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=2340;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device_param`
--

LOCK TABLES `device_param` WRITE;
/*!40000 ALTER TABLE `device_param` DISABLE KEYS */;
INSERT INTO `device_param` VALUES (288,'340804DD05AC',56,'1.0','2012-07-23 08:24:29'),(289,'340804DD05AC',57,'DIR-620','2012-07-23 08:24:29'),(290,'340804DD05AC',58,'1.3.0','2012-07-23 08:24:29'),(291,'340804DD05AC',59,'http://192.168.1.203:8999/','2012-07-23 08:24:29'),(292,'340804DD05AC',60,'NONE','2012-07-23 08:24:29'),(293,'340804DD05AC',61,'admin','2012-07-23 08:24:29'),(294,'340804DD05AC',62,'20','2012-07-23 08:24:29'),(295,'340804DD05AC',63,'1992-10-04T09:23:12Z','2012-07-23 08:24:29');
/*!40000 ALTER TABLE `device_param` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_type`
--

DROP TABLE IF EXISTS `device_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device_type`
--

LOCK TABLES `device_type` WRITE;
/*!40000 ALTER TABLE `device_type` DISABLE KEYS */;
INSERT INTO `device_type` VALUES (1,'Router'),(2,'Modem'),(3,'Phone'),(4,'Camera'),(5,'Switch');
/*!40000 ALTER TABLE `device_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `download`
--

DROP TABLE IF EXISTS `download`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `download` (
  `serial_number` varchar(100) NOT NULL,
  `file_id` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `upgrade_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `file_id` (`file_id`),
  KEY `serial_number` (`serial_number`),
  CONSTRAINT `download_fk` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `download_fk1` FOREIGN KEY (`serial_number`) REFERENCES `device` (`serial_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=5461;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `download`
--

LOCK TABLES `download` WRITE;
/*!40000 ALTER TABLE `download` DISABLE KEYS */;
/*!40000 ALTER TABLE `download` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `error`
--

DROP TABLE IF EXISTS `error`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `error` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `history_id` int(11) NOT NULL,
  `error` varchar(200) DEFAULT NULL,
  `accoured_date` date DEFAULT NULL,
  `sent` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `error`
--

LOCK TABLES `error` WRITE;
/*!40000 ALTER TABLE `error` DISABLE KEYS */;
/*!40000 ALTER TABLE `error` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `file`
--

DROP TABLE IF EXISTS `file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(200) DEFAULT NULL,
  `file_type` varchar(100) DEFAULT NULL,
  `version` varchar(100) DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `model_id` (`model_id`),
  CONSTRAINT `file_fk` FOREIGN KEY (`model_id`) REFERENCES `model` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=4096;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `file`
--

LOCK TABLES `file` WRITE;
/*!40000 ALTER TABLE `file` DISABLE KEYS */;
INSERT INTO `file` VALUES (1,'http://192.168.1.133:8080/ACSProject/download?serialNumber=340804DD05BC&type=3_Vendor_Configuration_File&uniqueCode=90642d8e-dd96-4c76-ac45-dacd2b0905f1','3 Vendor Configuration File','',9,'config.tar.gz',2733);
/*!40000 ALTER TABLE `file` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history`
--

DROP TABLE IF EXISTS `history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `param_value` varchar(200) DEFAULT NULL,
  `change_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `applied` int(11) DEFAULT NULL,
  `device_param_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `device_param_id` (`device_param_id`),
  CONSTRAINT `history_fk` FOREIGN KEY (`device_param_id`) REFERENCES `device_param` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=288 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=512;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `history`
--

LOCK TABLES `history` WRITE;
/*!40000 ALTER TABLE `history` DISABLE KEYS */;
/*!40000 ALTER TABLE `history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manufacturer`
--

DROP TABLE IF EXISTS `manufacturer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `manufacturer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `manufacturer`
--

LOCK TABLES `manufacturer` WRITE;
/*!40000 ALTER TABLE `manufacturer` DISABLE KEYS */;
INSERT INTO `manufacturer` VALUES (1,'D-Link');
/*!40000 ALTER TABLE `manufacturer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model`
--

DROP TABLE IF EXISTS `model`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `device_type_id` int(11) NOT NULL,
  `manufacturer_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `device_type_id` (`device_type_id`),
  KEY `manufacturer_id` (`manufacturer_id`),
  CONSTRAINT `model_fk` FOREIGN KEY (`device_type_id`) REFERENCES `device_type` (`id`),
  CONSTRAINT `model_fk1` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=8192;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model`
--

LOCK TABLES `model` WRITE;
/*!40000 ALTER TABLE `model` DISABLE KEYS */;
INSERT INTO `model` VALUES (7,'DSL-2760U',2,1),(8,'DIR-300NRU rev.b5',2,1),(9,'DLink Router',2,1),(10,'DIR_620_TR069',2,1),(12,'DIR-620',1,1),(13,'ON201LW',1,1),(14,'OGC200W',1,1);
/*!40000 ALTER TABLE `model` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `network`
--

DROP TABLE IF EXISTS `network`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `network` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `network`
--

LOCK TABLES `network` WRITE;
/*!40000 ALTER TABLE `network` DISABLE KEYS */;
INSERT INTO `network` VALUES (1,'D-link');
/*!40000 ALTER TABLE `network` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parameter`
--

DROP TABLE IF EXISTS `parameter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parameter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `visual_name` varchar(100) DEFAULT NULL,
  `writable` int(11) DEFAULT NULL,
  `default_value` varchar(200) DEFAULT NULL,
  `isdefparam` tinyint(4) DEFAULT NULL,
  `isvisible_for_operator` tinyint(4) DEFAULT NULL,
  `model_id` int(11) NOT NULL,
  `param_type` varchar(50) DEFAULT NULL,
  `isvisible_for_admin` tinyint(4) NOT NULL,
  `is_lan` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `model_id` (`model_id`),
  CONSTRAINT `parameter_list_fk` FOREIGN KEY (`model_id`) REFERENCES `model` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parameter`
--

LOCK TABLES `parameter` WRITE;
/*!40000 ALTER TABLE `parameter` DISABLE KEYS */;
INSERT INTO `parameter` VALUES (1,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,10,'string',1,0),(2,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,10,'string',1,0),(3,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,10,'string',1,0),(4,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,10,'string',1,0),(5,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,10,'string',1,0),(6,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,10,'string',1,0),(7,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,10,'unsignedInt',1,0),(8,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,10,'string',1,0),(9,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,10,'string',1,0),(10,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,10,'string',1,0),(11,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,10,'string',1,0),(12,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.WEPKey.2.WEPKey','WEPKey.2.WEPKey',0,'',1,NULL,10,'string',1,1),(13,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.WEPKey.1.WEPKey','WEPKey.1.WEPKey',0,'',1,NULL,10,'string',1,1),(14,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.IEEE11iAuthenticationMode','IEEE11iAuthenticationMode',0,'',1,NULL,10,'string',1,1),(15,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.IEEE11iEncryptionModes','IEEE11iEncryptionModes',0,'',1,NULL,10,'string',1,1),(16,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.WPAEncryptionModes','WPAEncryptionModes',0,'',1,NULL,10,'string',1,1),(17,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.SSID','WLANConfiguration 1 SSID',1,'',1,NULL,10,'string',1,1),(18,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.AutoChannelEnable','AutoChannelEnable',1,'0',1,NULL,10,'boolean',1,1),(19,'InternetGatewayDevice.LANDevice.1.LANEthernetInterfaceConfig.4.Name','LANEthernetInterfaceConfig',0,'',1,NULL,10,'string',1,1),(20,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,7,'string',1,0),(21,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,7,'string',1,0),(22,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,7,'string',1,0),(23,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,7,'string',1,0),(24,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,7,'string',1,0),(25,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,7,'string',1,0),(26,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,7,'unsignedInt',1,0),(27,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,7,'string',1,0),(28,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,7,'string',1,0),(29,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,7,'string',1,0),(30,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,7,'string',1,0),(31,'InternetGatewayDevice.LANDevice.1.LANHostConfigManagement.DHCPServerEnable','LANHostConfigManagement DHCPServerEnable',1,'0',1,NULL,7,'boolean',1,1),(32,'InternetGatewayDevice.LANDevice.1.LANHostConfigManagement.DomainName','LANHostConfigManagement DomainName',1,'',1,NULL,7,'string',1,1),(33,'InternetGatewayDevice.LANDevice.1.LANUSBInterfaceConfig.1.Enable','LANUSBInterfaceConfig 1 Enable',1,'1',1,NULL,7,'boolean',1,1),(34,'InternetGatewayDevice.LANDevice.1.LANEthernetInterfaceConfig.1.Status','LANEthernetInterfaceConfig 1 Status',0,'',1,NULL,7,'string',1,1),(35,'InternetGatewayDevice.LANDevice.1.LANEthernetInterfaceConfig.1.MACAddress','MACAddress',0,'',1,NULL,7,'string',1,1),(36,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,8,'string',1,0),(37,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,8,'string',1,0),(38,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,8,'string',1,0),(39,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,8,'string',1,0),(40,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,8,'string',1,0),(41,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,8,'string',1,0),(42,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,8,'unsignedInt',1,0),(43,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,8,'string',1,0),(44,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,8,'string',1,0),(45,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,8,'string',1,0),(46,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,8,'string',1,0),(47,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.WEPKey.2.WEPKey','WEPKey.2.WEPKey',0,'',1,NULL,8,'string',1,1),(48,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.WEPKey.1.WEPKey','WEPKey.1.WEPKey',0,'',1,NULL,8,'string',1,1),(49,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.IEEE11iAuthenticationMode','IEEE11iAuthenticationMode',0,'',1,NULL,8,'string',1,1),(50,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.IEEE11iEncryptionModes','IEEE11iEncryptionModes',0,'',1,NULL,8,'string',1,1),(51,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.WPAEncryptionModes','WPAEncryptionModes',0,'',1,NULL,8,'string',1,1),(52,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.SSID','WLANConfiguration 1 SSID',1,'',1,NULL,8,'string',1,1),(53,'InternetGatewayDevice.LANDevice.1.WLANConfiguration.1.AutoChannelEnable','AutoChannelEnable',1,'0',1,NULL,8,'boolean',1,1),(54,'InternetGatewayDevice.LANDevice.1.LANEthernetInterfaceConfig.4.Name','LANEthernetInterfaceConfig',0,'',1,NULL,12,'string',1,1),(55,'InternetGatewayDevice.ManagementServer.Password','ManagementServer.Password',1,NULL,1,NULL,8,'string',1,0),(56,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,9,'string',1,0),(57,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,9,'string',1,0),(58,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,9,'string',1,0),(59,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,9,'string',1,0),(60,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,9,'string',1,0),(61,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,9,'string',1,0),(62,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,9,'unsignedInt',1,0),(63,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,9,'string',1,0),(64,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,9,'string',1,0),(65,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,9,'string',1,0),(66,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,9,'string',1,0),(78,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,12,'string',1,0),(79,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,12,'string',1,0),(80,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,12,'string',1,0),(81,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,12,'string',1,0),(82,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,12,'string',1,0),(83,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,12,'string',1,0),(84,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,12,'unsignedInt',1,0),(85,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,12,'string',1,0),(86,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,12,'string',1,0),(87,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,12,'string',1,0),(88,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,12,'string',1,0),(91,'InternetGatewayDevice.LANDevice.1.LANEthernetInterfaceConfig.4.MACAddress','LANEthernetInterfaceMACAddress',0,'',1,NULL,12,'string',1,1),(98,'InternetGatewayDevice.LANDevice.1.LANHostConfigManagement.IPInterface.1.IPInterfaceAddressingType','LANIPInterfaceAddressingType',0,'',1,NULL,12,'string',1,1),(99,'InternetGatewayDevice.LANDeviceNumberOfEntries','LANDeviceNumberOfEntries',0,'',1,NULL,9,'string',1,1),(100,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,13,'string',1,0),(101,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,13,'string',1,0),(102,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,13,'string',1,0),(103,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,13,'string',1,0),(104,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,13,'string',1,0),(105,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,13,'string',1,0),(106,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,13,'unsignedInt',1,0),(107,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,13,'string',1,0),(108,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,13,'string',1,0),(109,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,13,'string',1,0),(110,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,13,'string',1,0),(111,'InternetGatewayDevice.DeviceInfo.SpecVersion','SpecVersion',0,'',1,NULL,14,'string',1,0),(112,'InternetGatewayDevice.DeviceInfo.HardwareVersion','HardVersion',0,'',1,NULL,14,'string',1,0),(113,'InternetGatewayDevice.DeviceInfo.SoftwareVersion','SoftVersion',0,'',1,NULL,14,'string',1,0),(114,'InternetGatewayDevice.ManagementServer.ConnectionRequestURL','Connection URL',0,'',1,NULL,14,'string',1,0),(115,'InternetGatewayDevice.ManagementServer.ConnectionRequestPassword','Password',1,'',1,NULL,14,'string',1,0),(116,'InternetGatewayDevice.ManagementServer.ConnectionRequestUsername','Username',1,'',1,NULL,14,'string',1,0),(117,'InternetGatewayDevice.ManagementServer.PeriodicInformInterval','Interval',1,'10',1,NULL,14,'unsignedInt',1,0),(118,'InternetGatewayDevice.ManagementServer.PeriodicInformTime','Periodic Time',0,'',1,NULL,14,'string',1,0),(119,'InternetGatewayDevice.ManagementServer.URL','Management Server URL',1,'192.168.1.53:30006',1,NULL,14,'string',1,0),(120,'InternetGatewayDevice.ManagementServer.Username','Management Server Username',1,'',1,NULL,14,'string',1,0),(121,'InternetGatewayDevice.DeviceInfo.ModelName','ModelName',0,'',1,NULL,14,'string',1,0);
/*!40000 ALTER TABLE `parameter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reboot`
--

DROP TABLE IF EXISTS `reboot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reboot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial_number` varchar(100) DEFAULT NULL,
  `reboot_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `serial_number` (`serial_number`),
  CONSTRAINT `reboot_fk` FOREIGN KEY (`serial_number`) REFERENCES `device` (`serial_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=16384;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reboot`
--

LOCK TABLES `reboot` WRITE;
/*!40000 ALTER TABLE `reboot` DISABLE KEYS */;
INSERT INTO `reboot` VALUES (24,'340804DD05AC',1);
/*!40000 ALTER TABLE `reboot` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `server_parameters`
--

DROP TABLE IF EXISTS `server_parameters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `server_parameters` (
  `username` varchar(24) CHARACTER SET latin1 NOT NULL,
  `password` varchar(24) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `server_parameters`
--

LOCK TABLES `server_parameters` WRITE;
/*!40000 ALTER TABLE `server_parameters` DISABLE KEYS */;
INSERT INTO `server_parameters` VALUES ('admin','admin');
/*!40000 ALTER TABLE `server_parameters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status`
--

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status`
--

LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,'pending',NULL),(2,'activated',NULL),(3,'deleted',NULL);
/*!40000 ALTER TABLE `status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscriber`
--

DROP TABLE IF EXISTS `subscriber`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscriber` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `surname` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscriber`
--

LOCK TABLES `subscriber` WRITE;
/*!40000 ALTER TABLE `subscriber` DISABLE KEYS */;
INSERT INTO `subscriber` VALUES (1,'Subscriber1',NULL,NULL,' Armenia, Gyumri, sayat nova'),(2,'Subscriber5',NULL,NULL,'Armenia, Kapan'),(3,'Subscriber2',NULL,NULL,'Armenia, Erevan, sayat nova'),(4,'Subscriber4',NULL,NULL,'Armenia, Vanadzor, sayat nova'),(5,'Subscriber3',NULL,NULL,'Armenia, Gyumri, shirakaci');
/*!40000 ALTER TABLE `subscriber` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unknown`
--

DROP TABLE IF EXISTS `unknown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unknown` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial` varchar(100) NOT NULL,
  `model_name` varchar(100) DEFAULT NULL,
  `unknown_type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=55;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unknown`
--

LOCK TABLES `unknown` WRITE;
/*!40000 ALTER TABLE `unknown` DISABLE KEYS */;
INSERT INTO `unknown` VALUES (1,'340804E21970','ON201LW','not_in_glossary'),(2,'14D64D88B276','OGC200W','not_in_glossary');
/*!40000 ALTER TABLE `unknown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload`
--

DROP TABLE IF EXISTS `upload`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial_number` varchar(50) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  `file_id` int(11) DEFAULT NULL,
  `status` int(2) unsigned DEFAULT '0',
  `upload_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `FK_upload_serial` (`serial_number`),
  CONSTRAINT `FK_upload_serial` FOREIGN KEY (`serial_number`) REFERENCES `device` (`serial_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload`
--

LOCK TABLES `upload` WRITE;
/*!40000 ALTER TABLE `upload` DISABLE KEYS */;
/*!40000 ALTER TABLE `upload` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `type_id` int(11) NOT NULL,
  `status_id` int(11) NOT NULL,
  `unique_key` varchar(200) DEFAULT NULL,
  `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status_change_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(50) DEFAULT NULL,
  `surname` varchar(50) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `manager_email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_key` (`unique_key`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `unique_key_2` (`unique_key`),
  KEY `type_id` (`type_id`),
  KEY `status_id` (`status_id`),
  CONSTRAINT `user_fk` FOREIGN KEY (`type_id`) REFERENCES `user_type` (`id`),
  CONSTRAINT `user_fk1` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'admin','21232F297A57A5A743894A0E4A801FC3','0101@gmail.com',1,2,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','','','',''),(2,'operator','4B583376B2767B923C3E1DA60D10DE59','operator@mail.ru',2,2,NULL,'2011-09-23 00:50:48','0000-00-00 00:00:00','','','',NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_type`
--

DROP TABLE IF EXISTS `user_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_type`
--

LOCK TABLES `user_type` WRITE;
/*!40000 ALTER TABLE `user_type` DISABLE KEYS */;
INSERT INTO `user_type` VALUES (1,'administrator',NULL),(2,'operator',NULL);
/*!40000 ALTER TABLE `user_type` 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 2012-07-23 12:32:24
