Untitled diff

Created Diff never expires
9 removals
346 lines
9 additions
346 lines
-- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (x86_64)
-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
--
-- Host: localhost Database: racktables_20_7_db
-- Host: localhost Database: racktables_test
-- ------------------------------------------------------
-- ------------------------------------------------------
-- Server version 5.5.40-0ubuntu1
-- Server version 5.1.73
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
--
-- Table structure for table `Atom`
-- Table structure for table `Atom`
--
--
DROP TABLE IF EXISTS `Atom`;
DROP TABLE IF EXISTS `Atom`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Atom` (
CREATE TABLE `Atom` (
`molecule_id` int(10) unsigned DEFAULT NULL,
`molecule_id` int(10) unsigned DEFAULT NULL,
`rack_id` int(10) unsigned DEFAULT NULL,
`rack_id` int(10) unsigned DEFAULT NULL,
`unit_no` int(10) unsigned DEFAULT NULL,
`unit_no` int(10) unsigned DEFAULT NULL,
`atom` enum('front','interior','rear') COLLATE utf8_unicode_ci DEFAULT NULL,
`atom` enum('front','interior','rear') COLLATE utf8_unicode_ci DEFAULT NULL,
KEY `Atom-FK-molecule_id` (`molecule_id`),
KEY `Atom-FK-molecule_id` (`molecule_id`),
KEY `Atom-FK-rack_id` (`rack_id`),
KEY `Atom-FK-rack_id` (`rack_id`),
CONSTRAINT `Atom-FK-molecule_id` FOREIGN KEY (`molecule_id`) REFERENCES `Molecule` (`id`) ON DELETE CASCADE,
CONSTRAINT `Atom-FK-molecule_id` FOREIGN KEY (`molecule_id`) REFERENCES `Molecule` (`id`) ON DELETE CASCADE,
CONSTRAINT `Atom-FK-rack_id` FOREIGN KEY (`rack_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE
CONSTRAINT `Atom-FK-rack_id` FOREIGN KEY (`rack_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `Atom`
-- Dumping data for table `Atom`
--
--
LOCK TABLES `Atom` WRITE;
LOCK TABLES `Atom` WRITE;
/*!40000 ALTER TABLE `Atom` DISABLE KEYS */;
/*!40000 ALTER TABLE `Atom` DISABLE KEYS */;
/*!40000 ALTER TABLE `Atom` ENABLE KEYS */;
/*!40000 ALTER TABLE `Atom` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `Attribute`
-- Table structure for table `Attribute`
--
--
DROP TABLE IF EXISTS `Attribute`;
DROP TABLE IF EXISTS `Attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Attribute` (
CREATE TABLE `Attribute` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` enum('string','uint','float','dict','date') COLLATE utf8_unicode_ci DEFAULT NULL,
`type` enum('string','uint','float','dict','date') COLLATE utf8_unicode_ci DEFAULT NULL,
`name` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `Attribute`
-- Dumping data for table `Attribute`
--
--
LOCK TABLES `Attribute` WRITE;
LOCK TABLES `Attribute` WRITE;
/*!40000 ALTER TABLE `Attribute` DISABLE KEYS */;
/*!40000 ALTER TABLE `Attribute` DISABLE KEYS */;
INSERT INTO `Attribute` VALUES (1,'string','OEM S/N 1'),(2,'dict','HW type'),(3,'string','FQDN'),(4,'dict','SW type'),(5,'string','SW version'),(6,'uint','number of ports'),(7,'float','max. current, Ampers'),(8,'float','power load, percents'),(13,'float','max power, Watts'),(14,'string','contact person'),(16,'uint','flash memory, MB'),(17,'uint','DRAM, MB'),(18,'uint','CPU, MHz'),(20,'string','OEM S/N 2'),(21,'date','support contract expiration'),(22,'date','HW warranty expiration'),(24,'date','SW warranty expiration'),(25,'string','UUID'),(26,'dict','Hypervisor'),(27,'uint','Height, units'),(28,'string','Slot number'),(29,'uint','Sort order'),(30,'dict','Mgmt type'),(9999,'string','base MAC address');
INSERT INTO `Attribute` VALUES (1,'string','OEM S/N 1'),(2,'dict','HW type'),(3,'string','FQDN'),(4,'dict','SW type'),(5,'string','SW version'),(6,'uint','number of ports'),(7,'float','max. current, Ampers'),(8,'float','power load, percents'),(13,'float','max power, Watts'),(14,'string','contact person'),(16,'uint','flash memory, MB'),(17,'uint','DRAM, MB'),(18,'uint','CPU, MHz'),(20,'string','OEM S/N 2'),(21,'date','support contract expiration'),(22,'date','HW warranty expiration'),(24,'date','SW warranty expiration'),(25,'string','UUID'),(26,'dict','Hypervisor'),(27,'uint','Height, units'),(28,'string','Slot number'),(29,'uint','Sort order'),(30,'dict','Mgmt type'),(9999,'string','base MAC address');
/*!40000 ALTER TABLE `Attribute` ENABLE KEYS */;
/*!40000 ALTER TABLE `Attribute` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `AttributeMap`
-- Table structure for table `AttributeMap`
--
--
DROP TABLE IF EXISTS `AttributeMap`;
DROP TABLE IF EXISTS `AttributeMap`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AttributeMap` (
CREATE TABLE `AttributeMap` (
`objtype_id` int(10) unsigned NOT NULL DEFAULT '1',
`objtype_id` int(10) unsigned NOT NULL DEFAULT '1',
`attr_id` int(10) unsigned NOT NULL DEFAULT '1',
`attr_id` int(10) unsigned NOT NULL DEFAULT '1',
`chapter_id` int(10) unsigned DEFAULT NULL,
`chapter_id` int(10) unsigned DEFAULT NULL,
`sticky` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
`sticky` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
UNIQUE KEY `objtype_id` (`objtype_id`,`attr_id`),
UNIQUE KEY `objtype_id` (`objtype_id`,`attr_id`),
KEY `attr_id` (`attr_id`),
KEY `attr_id` (`attr_id`),
KEY `chapter_id` (`chapter_id`),
KEY `chapter_id` (`chapter_id`),
CONSTRAINT `AttributeMap-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`),
CONSTRAINT `AttributeMap-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`),
CONSTRAINT `AttributeMap-FK-attr_id` FOREIGN KEY (`attr_id`) REFERENCES `Attribute` (`id`)
CONSTRAINT `AttributeMap-FK-attr_id` FOREIGN KEY (`attr_id`) REFERENCES `Attribute` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `AttributeMap`
-- Dumping data for table `AttributeMap`
--
--
LOCK TABLES `AttributeMap` WRITE;
LOCK TABLES `AttributeMap` WRITE;
/*!40000 ALTER TABLE `AttributeMap` DISABLE KEYS */;
/*!40000 ALTER TABLE `AttributeMap` DISABLE KEYS */;
INSERT INTO `AttributeMap` VALUES (2,1,NULL,'no'),(2,2,27,'no'),(2,3,NULL,'no'),(2,5,NULL,'no'),(4,1,NULL,'no'),(4,2,11,'no'),(4,3,NULL,'no'),(4,4,13,'no'),(4,14,NULL,'no'),(4,21,NULL,'no'),(4,22,NULL,'no'),(4,24,NULL,'no'),(4,25,NULL,'no'),(4,26,29,'yes'),(4,28,NULL,'yes'),(5,1,NULL,'no'),(5,2,18,'no'),(6,1,NULL,'no'),(6,2,19,'no'),(6,20,NULL,'no'),(7,1,NULL,'no'),(7,2,17,'no'),(7,3,NULL,'no'),(7,4,16,'no'),(7,5,NULL,'no'),(7,14,NULL,'no'),(7,16,NULL,'no'),(7,17,NULL,'no'),(7,18,NULL,'no'),(7,21,NULL,'no'),(7,22,NULL,'no'),(7,24,NULL,'no'),(8,1,NULL,'yes'),(8,2,12,'yes'),(8,3,NULL,'no'),(8,4,14,'yes'),(8,5,NULL,'no'),(8,14,NULL,'no'),(8,16,NULL,'no'),(8,17,NULL,'no'),(8,18,NULL,'no'),(8,20,NULL,'no'),(8,21,NULL,'no'),(8,22,NULL,'no'),(8,24,NULL,'no'),(8,28,NULL,'yes'),(9,6,NULL,'no'),(12,1,NULL,'no'),(12,3,NULL,'no'),(12,7,NULL,'no'),(12,8,NULL,'no'),(12,13,NULL,'no'),(12,20,NULL,'no'),(15,2,23,'no'),(445,1,NULL,'no'),(445,2,21,'no'),(445,3,NULL,'no'),(445,5,NULL,'no'),(445,14,NULL,'no'),(445,22,NULL,'no'),(447,1,NULL,'no'),(447,2,9999,'no'),(447,3,NULL,'no'),(447,5,NULL,'no'),(447,14,NULL,'no'),(447,22,NULL,'no'),(798,1,NULL,'no'),(798,2,24,'no'),(798,3,NULL,'no'),(798,5,NULL,'no'),(798,14,NULL,'no'),(798,16,NULL,'no'),(798,17,NULL,'no'),(798,18,NULL,'no'),(798,20,NULL,'no'),(798,21,NULL,'no'),(798,22,NULL,'no'),(798,24,NULL,'no'),(798,28,NULL,'yes'),(965,1,NULL,'no'),(965,2,25,'no'),(965,3,NULL,'no'),(965,4,37,'no'),(1055,2,26,'no'),(1055,28,NULL,'yes'),(1323,1,NULL,'no'),(1323,2,28,'no'),(1323,3,NULL,'no'),(1323,5,NULL,'no'),(1397,1,NULL,'no'),(1397,2,34,'no'),(1397,14,NULL,'no'),(1397,21,NULL,'no'),(1397,22,NULL,'no'),(1398,1,NULL,'no'),(1398,2,35,'no'),(1398,14,NULL,'no'),(1398,21,NULL,'no'),(1398,22,NULL,'no'),(1502,1,NULL,'no'),(1502,2,31,'no'),(1502,3,NULL,'no'),(1502,14,NULL,'no'),(1502,20,NULL,'no'),(1502,21,NULL,'no'),(1502,22,NULL,'no'),(1503,1,NULL,'no'),(1503,2,30,'no'),(1503,3,NULL,'no'),(1503,4,14,'no'),(1503,5,NULL,'no'),(1503,14,NULL,'no'),(1503,16,NULL,'no'),(1503,17,NULL,'no'),(1503,18,NULL,'no'),(1503,20,NULL,'no'),(1503,21,NULL,'no'),(1503,22,NULL,'no'),(1503,24,NULL,'no'),(1504,3,NULL,'no'),(1504,4,13,'no'),(1504,14,NULL,'no'),(1504,24,NULL,'no'),(1505,14,NULL,'no'),(1506,14,NULL,'no'),(1506,17,NULL,'no'),(1506,18,NULL,'no'),(1507,1,NULL,'no'),(1507,2,32,'no'),(1507,3,NULL,'no'),(1507,4,33,'no'),(1507,5,NULL,'no'),(1507,14,NULL,'no'),(1507,20,NULL,'no'),(1507,21,NULL,'no'),(1507,22,NULL,'no'),(1560,27,NULL,'yes'),(1560,29,NULL,'yes'),(1562,14,NULL,'no'),(1644,1,NULL,'no'),(1644,2,36,'no'),(1644,3,NULL,'no'),(1787,3,NULL,'no'),(1787,14,NULL,'no'),(1787,30,38,'yes');
INSERT INTO `AttributeMap` VALUES (2,1,NULL,'no'),(2,2,27,'no'),(2,3,NULL,'no'),(2,5,NULL,'no'),(4,1,NULL,'no'),(4,2,11,'no'),(4,3,NULL,'no'),(4,4,13,'no'),(4,14,NULL,'no'),(4,21,NULL,'no'),(4,22,NULL,'no'),(4,24,NULL,'no'),(4,25,NULL,'no'),(4,26,29,'yes'),(4,28,NULL,'yes'),(5,1,NULL,'no'),(5,2,18,'no'),(6,1,NULL,'no'),(6,2,19,'no'),(6,20,NULL,'no'),(7,1,NULL,'no'),(7,2,17,'no'),(7,3,NULL,'no'),(7,4,16,'no'),(7,5,NULL,'no'),(7,14,NULL,'no'),(7,16,NULL,'no'),(7,17,NULL,'no'),(7,18,NULL,'no'),(7,21,NULL,'no'),(7,22,NULL,'no'),(7,24,NULL,'no'),(8,1,NULL,'yes'),(8,2,12,'yes'),(8,3,NULL,'no'),(8,4,14,'yes'),(8,5,NULL,'no'),(8,14,NULL,'no'),(8,16,NULL,'no'),(8,17,NULL,'no'),(8,18,NULL,'no'),(8,20,NULL,'no'),(8,21,NULL,'no'),(8,22,NULL,'no'),(8,24,NULL,'no'),(8,28,NULL,'yes'),(9,6,NULL,'no'),(12,1,NULL,'no'),(12,3,NULL,'no'),(12,7,NULL,'no'),(12,8,NULL,'no'),(12,13,NULL,'no'),(12,20,NULL,'no'),(15,2,23,'no'),(445,1,NULL,'no'),(445,2,21,'no'),(445,3,NULL,'no'),(445,5,NULL,'no'),(445,14,NULL,'no'),(445,22,NULL,'no'),(447,1,NULL,'no'),(447,2,9999,'no'),(447,3,NULL,'no'),(447,5,NULL,'no'),(447,14,NULL,'no'),(447,22,NULL,'no'),(798,1,NULL,'no'),(798,2,24,'no'),(798,3,NULL,'no'),(798,5,NULL,'no'),(798,14,NULL,'no'),(798,16,NULL,'no'),(798,17,NULL,'no'),(798,18,NULL,'no'),(798,20,NULL,'no'),(798,21,NULL,'no'),(798,22,NULL,'no'),(798,24,NULL,'no'),(798,28,NULL,'yes'),(965,1,NULL,'no'),(965,2,25,'no'),(965,3,NULL,'no'),(965,4,37,'no'),(1055,2,26,'no'),(1055,28,NULL,'yes'),(1323,1,NULL,'no'),(1323,2,28,'no'),(1323,3,NULL,'no'),(1323,5,NULL,'no'),(1397,1,NULL,'no'),(1397,2,34,'no'),(1397,14,NULL,'no'),(1397,21,NULL,'no'),(1397,22,NULL,'no'),(1398,1,NULL,'no'),(1398,2,35,'no'),(1398,14,NULL,'no'),(1398,21,NULL,'no'),(1398,22,NULL,'no'),(1502,1,NULL,'no'),(1502,2,31,'no'),(1502,3,NULL,'no'),(1502,14,NULL,'no'),(1502,20,NULL,'no'),(1502,21,NULL,'no'),(1502,22,NULL,'no'),(1503,1,NULL,'no'),(1503,2,30,'no'),(1503,3,NULL,'no'),(1503,4,14,'no'),(1503,5,NULL,'no'),(1503,14,NULL,'no'),(1503,16,NULL,'no'),(1503,17,NULL,'no'),(1503,18,NULL,'no'),(1503,20,NULL,'no'),(1503,21,NULL,'no'),(1503,22,NULL,'no'),(1503,24,NULL,'no'),(1504,3,NULL,'no'),(1504,4,13,'no'),(1504,14,NULL,'no'),(1504,24,NULL,'no'),(1505,14,NULL,'no'),(1506,14,NULL,'no'),(1506,17,NULL,'no'),(1506,18,NULL,'no'),(1507,1,NULL,'no'),(1507,2,32,'no'),(1507,3,NULL,'no'),(1507,4,33,'no'),(1507,5,NULL,'no'),(1507,14,NULL,'no'),(1507,20,NULL,'no'),(1507,21,NULL,'no'),(1507,22,NULL,'no'),(1560,27,NULL,'yes'),(1560,29,NULL,'yes'),(1562,14,NULL,'no'),(1644,1,NULL,'no'),(1644,2,36,'no'),(1644,3,NULL,'no'),(1787,3,NULL,'no'),(1787,14,NULL,'no'),(1787,30,38,'yes');
/*!40000 ALTER TABLE `AttributeMap` ENABLE KEYS */;
/*!40000 ALTER TABLE `AttributeMap` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `AttributeValue`
-- Table structure for table `AttributeValue`
--
--
DROP TABLE IF EXISTS `AttributeValue`;
DROP TABLE IF EXISTS `AttributeValue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AttributeValue` (
CREATE TABLE `AttributeValue` (
`object_id` int(10) unsigned NOT NULL,
`object_id` int(10) unsigned NOT NULL,
`object_tid` int(10) unsigned NOT NULL DEFAULT '0',
`object_tid` int(10) unsigned NOT NULL DEFAULT '0',
`attr_id` int(10) unsigned NOT NULL,
`attr_id` int(10) unsigned NOT NULL,
`string_value` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`string_value` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`uint_value` int(10) unsigned DEFAULT NULL,
`uint_value` int(10) unsigned DEFAULT NULL,
`float_value` float DEFAULT NULL,
`float_value` float DEFAULT NULL,
PRIMARY KEY (`object_id`,`attr_id`),
PRIMARY KEY (`object_id`,`attr_id`),
KEY `attr_id-uint_value` (`attr_id`,`uint_value`),
KEY `attr_id-uint_value` (`attr_id`,`uint_value`),
KEY `attr_id-string_value` (`attr_id`,`string_value`(12)),
KEY `attr_id-string_value` (`attr_id`,`string_value`(12)),
KEY `id-tid` (`object_id`,`object_tid`),
KEY `id-tid` (`object_id`,`object_tid`),
KEY `object_tid-attr_id` (`object_tid`,`attr_id`),
KEY `object_tid-attr_id` (`object_tid`,`attr_id`),
CONSTRAINT `AttributeValue-FK-map` FOREIGN KEY (`object_tid`, `attr_id`) REFERENCES `AttributeMap` (`objtype_id`, `attr_id`),
CONSTRAINT `AttributeValue-FK-map` FOREIGN KEY (`object_tid`, `attr_id`) REFERENCES `AttributeMap` (`objtype_id`, `attr_id`),
CONSTRAINT `AttributeValue-FK-object` FOREIGN KEY (`object_id`, `object_tid`) REFERENCES `Object` (`id`, `objtype_id`) ON DELETE CASCADE ON UPDATE CASCADE
CONSTRAINT `AttributeValue-FK-object` FOREIGN KEY (`object_id`, `object_tid`) REFERENCES `Object` (`id`, `objtype_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `AttributeValue`
-- Dumping data for table `AttributeValue`
--
--
LOCK TABLES `AttributeValue` WRITE;
LOCK TABLES `AttributeValue` WRITE;
/*!40000 ALTER TABLE `AttributeValue` DISABLE KEYS */;
/*!40000 ALTER TABLE `AttributeValue` DISABLE KEYS */;
/*!40000 ALTER TABLE `AttributeValue` ENABLE KEYS */;
/*!40000 ALTER TABLE `AttributeValue` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `CachedPAV`
-- Table structure for table `CachedPAV`
--
--
DROP TABLE IF EXISTS `CachedPAV`;
DROP TABLE IF EXISTS `CachedPAV`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CachedPAV` (
CREATE TABLE `CachedPAV` (
`object_id` int(10) unsigned NOT NULL,
`object_id` int(10) unsigned NOT NULL,
`port_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`port_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`vlan_id` int(10) unsigned NOT NULL DEFAULT '0',
`vlan_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`object_id`,`port_name`,`vlan_id`),
PRIMARY KEY (`object_id`,`port_name`,`vlan_id`),
KEY `vlan_id` (`vlan_id`),
KEY `vlan_id` (`vlan_id`),
CONSTRAINT `CachedPAV-FK-object-port` FOREIGN KEY (`object_id`, `port_name`) REFERENCES `CachedPVM` (`object_id`, `port_name`) ON DELETE CASCADE,
CONSTRAINT `CachedPAV-FK-object-port` FOREIGN KEY (`object_id`, `port_name`) REFERENCES `CachedPVM` (`object_id`, `port_name`) ON DELETE CASCADE,
CONSTRAINT `CachedPAV-FK-vlan_id` FOREIGN KEY (`vlan_id`) REFERENCES `VLANValidID` (`vlan_id`)
CONSTRAINT `CachedPAV-FK-vlan_id` FOREIGN KEY (`vlan_id`) REFERENCES `VLANValidID` (`vlan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `CachedPAV`
-- Dumping data for table `CachedPAV`
--
--
LOCK TABLES `CachedPAV` WRITE;
LOCK TABLES `CachedPAV` WRITE;
/*!40000 ALTER TABLE `CachedPAV` DISABLE KEYS */;
/*!40000 ALTER TABLE `CachedPAV` DISABLE KEYS */;
/*!40000 ALTER TABLE `CachedPAV` ENABLE KEYS */;
/*!40000 ALTER TABLE `CachedPAV` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `CachedPNV`
-- Table structure for table `CachedPNV`
--
--
DROP TABLE IF EXISTS `CachedPNV`;
DROP TABLE IF EXISTS `CachedPNV`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CachedPNV` (
CREATE TABLE `CachedPNV` (
`object_id` int(10) unsigned NOT NULL,
`object_id` int(10) unsigned NOT NULL,
`port_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`port_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`vlan_id` int(10) unsigned NOT NULL DEFAULT '0',
`vlan_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`object_id`,`port_name`,`vlan_id`),
PRIMARY KEY (`object_id`,`port_name`,`vlan_id`),
UNIQUE KEY `port_id` (`object_id`,`port_name`),
UNIQUE KEY `port_id` (`object_id`,`port_name`),
CONSTRAINT `CachedPNV-FK-compound` FOREIGN KEY (`object_id`, `port_name`, `vlan_id`) REFERENCES `CachedPAV` (`object_id`, `port_name`, `vlan_id`) ON DELETE CASCADE
CONSTRAINT `CachedPNV-FK-compound` FOREIGN KEY (`object_id`, `port_name`, `vlan_id`) REFERENCES `CachedPAV` (`object_id`, `port_name`, `vlan_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `CachedPNV`
-- Dumping data for table `CachedPNV`
--
--
LOCK TABLES `CachedPNV` WRITE;
LOCK TABLES `CachedPNV` WRITE;
/*!40000 ALTER TABLE `CachedPNV` DISABLE KEYS */;
/*!40000 ALTER TABLE `CachedPNV` DISABLE KEYS */;
/*!40000 ALTER TABLE `CachedPNV` ENABLE KEYS */;
/*!40000 ALTER TABLE `CachedPNV` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `CachedPVM`
-- Table structure for table `CachedPVM`
--
--
DROP TABLE IF EXISTS `CachedPVM`;
DROP TABLE IF EXISTS `CachedPVM`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CachedPVM` (
CREATE TABLE `CachedPVM` (
`object_id` int(10) unsigned NOT NULL,
`object_id` int(10) unsigned NOT NULL,
`port_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`port_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`vlan_mode` enum('access','trunk') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access',
`vlan_mode` enum('access','trunk') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access',
PRIMARY KEY (`object_id`,`port_name`),
PRIMARY KEY (`object_id`,`port_name`),
CONSTRAINT `CachedPVM-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE
CONSTRAINT `CachedPVM-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `CachedPVM`
-- Dumping data for table `CachedPVM`
--
--
LOCK TABLES `CachedPVM` WRITE;
LOCK TABLES `CachedPVM` WRITE;
/*!40000 ALTER TABLE `CachedPVM` DISABLE KEYS */;
/*!40000 ALTER TABLE `CachedPVM` DISABLE KEYS */;
/*!40000 ALTER TABLE `CachedPVM` ENABLE KEYS */;
/*!40000 ALTER TABLE `CachedPVM` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `CactiGraph`
-- Table structure for table `CactiGraph`
--
--
DROP TABLE IF EXISTS `CactiGraph`;
DROP TABLE IF EXISTS `CactiGraph`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CactiGraph` (
CREATE TABLE `CactiGraph` (
`object_id` int(10) unsigned NOT NULL,
`object_id` int(10) unsigned NOT NULL,
`server_id` int(10) unsigned NOT NULL,
`server_id` int(10) unsigned NOT NULL,
`graph_id` int(10) unsigned NOT NULL,
`graph_id` int(10) unsigned NOT NULL,
`caption` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`caption` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`server_id`,`graph_id`),
PRIMARY KEY (`object_id`,`server_id`,`graph_id`),
KEY `object_id` (`object_id`),
KEY `graph_id` (`graph_id`),
KEY `graph_id` (`graph_id`),
KEY `server_id` (`server_id`),
CONSTRAINT `CactiGraph-FK-server_id` FOREIGN KEY (`server_id`) REFERENCES `CactiServer` (`id`),
CONSTRAINT `CactiGraph-FK-server_id` FOREIGN KEY (`server_id`) REFERENCES `CactiServer` (`id`),
CONSTRAINT `CactiGraph-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE
CONSTRAINT `CactiGraph-FK-object_id` FOREIGN KEY (`object_id`) REFERENCES `Object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `CactiGraph`
-- Dumping data for table `CactiGraph`
--
--
LOCK TABLES `CactiGraph` WRITE;
LOCK TABLES `CactiGraph` WRITE;
/*!40000 ALTER TABLE `CactiGraph` DISABLE KEYS */;
/*!40000 ALTER TABLE `CactiGraph` DISABLE KEYS */;
/*!40000 ALTER TABLE `CactiGraph` ENABLE KEYS */;
/*!40000 ALTER TABLE `CactiGraph` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `CactiServer`
-- Table structure for table `CactiServer`
--
--
DROP TABLE IF EXISTS `CactiServer`;
DROP TABLE IF EXISTS `CactiServer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CactiServer` (
CREATE TABLE `CactiServer` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`base_url` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`base_url` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`username` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`username` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` char(64) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `CactiServer`
-- Dumping data for table `CactiServer`
--
--
LOCK TABLES `CactiServer` WRITE;
LOCK TABLES `CactiServer` WRITE;
/*!40000 ALTER TABLE `CactiServer` DISABLE KEYS */;
/*!40000 ALTER TABLE `CactiServer` DISABLE KEYS */;
/*!40000 ALTER TABLE `CactiServer` ENABLE KEYS */;
/*!40000 ALTER TABLE `CactiServer` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `Chapter`
-- Table structure for table `Chapter`
--
--
DROP TABLE IF EXISTS `Chapter`;
DROP TABLE IF EXISTS `Chapter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Chapter` (
CREATE TABLE `Chapter` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sticky` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
`sticky` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
`name` char(128) COLLATE utf8_unicode_ci NOT NULL,
`name` char(128) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `Chapter`
-- Dumping data for table `Chapter`
--
--
LOCK TABLES `Chapter` WRITE;
LOCK TABLES `Chapter` WRITE;
/*!40000 ALTER TABLE `Chapter` DISABLE KEYS */;
/*!40000 ALTER TABLE `Chapter` DISABLE KEYS */;
INSERT INTO `Chapter` VALUES (1,'yes','ObjectType'),(2,'yes','PortOuterInterface'),(11,'no','server models'),(12,'no','network switch models'),(13,'no','server OS type'),(14,'no','switch OS type'),(16,'no','router OS type'),(17,'no','router models'),(18,'no','disk array models'),(19,'no','tape library models'),(21,'no','KVM switch models'),(23,'no','console models'),(24,'no','network security models'),(25,'no','wireless models'),(26,'no','fibre channel switch models'),(27,'no','PDU models'),(28,'no','Voice/video hardware'),(29,'no','Yes/No'),(30,'no','network chassis models'),(31,'no','server chassis models'),(32,'no','virtual switch models'),(33,'no','virtual switch OS type'),(34,'no','power supply chassis models'),(35,'no','power supply models'),(36,'no','serial console server models'),(37,'no','wireless OS type'),(38,'no','management interface type'),(9999,'no','multiplexer models');
INSERT INTO `Chapter` VALUES (1,'yes','ObjectType'),(11,'no','server models'),(12,'no','network switch models'),(13,'no','server OS type'),(14,'no','switch OS type'),(16,'no','router OS type'),(17,'no','router models'),(18,'no','disk array models'),(19,'no','tape library models'),(21,'no','KVM switch models'),(23,'no','console models'),(24,'no','network security models'),(25,'no','wireless models'),(26,'no','fibre channel switch models'),(27,'no','PDU models'),(28,'no','Voice/video hardware'),(29,'no','Yes/No'),(30,'no','network chassis models'),(31,'no','server chassis models'),(32,'no','virtual switch models'),(33,'no','virtual switch OS type'),(34,'no','power supply chassis models'),(35,'no','power supply models'),(36,'no','serial console server models'),(37,'no','wireless OS type'),(38,'no','management interface type'),(9999,'no','multiplexer models');
/*!40000 ALTER TABLE `Chapter` ENABLE KEYS */;
/*!40000 ALTER TABLE `Chapter` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `Config`
-- Table structure for table `Config`
--
--
DROP TABLE IF EXISTS `Config`;
DROP TABLE IF EXISTS `Config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Config` (
CREATE TABLE `Config` (
`varname` char(32) COLLATE utf8_unicode_ci NOT NULL,
`varname` char(32) COLLATE utf8_unicode_ci NOT NULL,
`varvalue` text COLLATE utf8_unicode_ci NOT NULL,
`varvalue` text COLLATE utf8_unicode_ci NOT NULL,
`vartype` enum('string','uint') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'string',
`vartype` enum('string','uint') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'string',
`emptyok` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`emptyok` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`is_hidden` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`is_hidden` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`is_userdefined` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`is_userdefined` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`description` text COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`varname`)
PRIMARY KEY (`varname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `Config`
-- Dumping data for table `Config`
--
--
LOCK TABLES `Config` WRITE;
LOCK TABLES `Config` WRITE;
/*!40000 ALTER TABLE `Config` DISABLE KEYS */;
/*!40000 ALTER TABLE `Config` DISABLE KEYS */;
INSERT INTO `Config` VALUES ('8021Q_DEPLOY_MAXAGE','3600','uint','no','no','no','802.1Q deploy maximum age'),('8021Q_DEPLOY_MINAGE','300','uint','no','no','no','802.1Q deploy minimum age'),('8021Q_DEPLOY_RETRY','10800','uint','no','no','no','802.1Q deploy retry timer'),('8021Q_EXTSYNC_LISTSRC','false','string','yes','no','no','List source: objects with extended 802.1Q sync'),('8021Q_INSTANT_DEPLOY','no','string','no','no','yes','802.1Q: instant deploy'),('8021Q_MULTILINK_LISTSRC','false','string','yes','no','no','List source: IPv4/IPv6 networks allowing multiple VLANs from same domain'),('8021Q_WRI_AFTER_CONFT_LISTSRC','false','string','no','no','no','802.1Q: save device configuration after deploy (RackCode)'),('ADDNEW_AT_TOP','yes','string','no','no','yes','Render \"add new\" line at top of the list'),('ASSETWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','no','List source: objects for that asset tag should be set'),('AUTOPORTS_CONFIG','4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm','string','yes','no','no','AutoPorts configuration'),('CACTI_LISTSRC','false','string','yes','no','no','List of object with Cacti graphs'),('CDP_RUNNERS_LISTSRC','','string','yes','no','no','List of devices running CDP'),('DATETIME_FORMAT','%Y-%m-%d','string','no','no','yes','PHP strftime() format to use for date output'),('DATETIME_ZONE','UTC','string','yes','no','yes','Timezone to use for displaying/calculating dates'),('DB_VERSION','0.20.7','string','no','yes','no','Database version.'),('DEFAULT_IPV4_RS_INSERVICE','no','string','no','no','yes','Inservice status for new SLB real servers'),('DEFAULT_OBJECT_TYPE','4','uint','yes','no','yes','Default object type for new objects'),('DEFAULT_PORT_IIF_ID','1','uint','no','no','no','Default port inner interface ID'),('DEFAULT_PORT_OIF_IDS','1=24; 3=1078; 4=1077; 5=1079; 6=1080; 8=1082; 9=1084; 10=1588; 11=1668','string','no','no','no','Default port outer interface IDs'),('DEFAULT_RACK_HEIGHT','42','uint','yes','no','yes','Default rack height'),('DEFAULT_SLB_RS_PORT','','uint','yes','no','yes','Default port of SLB real server'),('DEFAULT_SLB_VS_PORT','','uint','yes','no','yes','Default port of SLB virtual service'),('DEFAULT_SNMP_COMMUNITY','public','string','no','no','no','Default SNMP Community string'),('DEFAULT_VDOM_ID','','uint','yes','no','yes','Default VLAN domain ID'),('DEFAULT_VST_ID','','uint','yes','no','yes','Default VLAN switch template ID'),('DETECT_URLS','no','string','yes','no','yes','Detect URLs in text fields'),('ENABLE_BULKPORT_FORM','yes','string','no','no','yes','Enable \"Bulk Port\" form'),('ENABLE_MULTIPORT_FORM','no','string','no','no','yes','Enable \"Add/update multiple ports\" form'),('enterprise','MyCompanyName','string','no','no','no','Organization name'),('EXT_IPV4_VIEW','yes','string','no','no','yes','Extended IPv4 view'),('FILTER_DEFAULT_ANDOR','and','string','no','no','yes','Default list filter boolean operation (or/and)'),('FILTER_PREDICATE_SIEVE','','string','yes','no','yes','Predicate sieve regex(7)'),('FILTER_RACKLIST_BY_TAGS','yes','string','yes','no','yes','Rackspace: show only racks matching the current object\'s tags'),('FILTER_SUGGEST_ANDOR','yes','string','no','no','yes','Suggest and/or selector in list filter'),('FILTER_SUGGEST_EXTRA','yes','string','no','no','yes','Suggest extra expression in list filter'),('FILTER_SUGGEST_PREDICATES','yes','string','no','no','yes','Suggest predicates in list filter'),('FILTER_SUGGEST_TAGS','yes','string','no','no','yes','Suggest tags in list filter'),('IPV4_ADDRS_PER_PAGE','256','uint','no','no','yes','IPv4 addresses per page'),('IPV4_AUTO_RELEASE','1','uint','no','no','yes','Auto-release IPv4 addresses on allocation'),('IPV4_ENABLE_KNIGHT','yes','string','no','no','yes','Enable IPv4 knight feature'),('IPV4_JAYWALK','no','string','no','no','no','Enable IPv4 address allocations w/o covering network'),('IPV4_TREE_RTR_AS_CELL','no','string','no','no','yes','Show full router info for each network in IPv4 tree view'),('IPV4_TREE_SHOW_USAGE','no','string','no','no','yes','Show address usage in IPv4 tree'),('IPV4_TREE_SHOW_VLAN','yes','string','no','no','yes','Show VLAN for each network in IPv4 tree'),('IPV4LB_LISTSRC','false','string','yes','no','no','List source: IPv4 load balancers'),('IPV4NAT_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8} or {$typeid_798}','string','yes','no','no','List source: IPv4 NAT performers'),('IPV4OBJ_LISTSRC','not ({$typeid_3} or {$typeid_9} or {$typeid_10} or {$typeid_11})','string','yes','no','no','List source: IPv4-enabled objects'),('LLDP_RUNNERS_LISTSRC','','string','yes','no','no','List of devices running LLDP'),('MASSCOUNT','8','uint','no','no','yes','"Fast" form is this many records tall'),('MAX_UNFILTERED_ENTITIES','0','uint','no','no','yes','Max item count to display on unfiltered result page'),('MAXSELSIZE','30','uint','no','no','yes','<SELECT> lists height'),('MGMT_PROTOS','ssh: {$typeid_4}; telnet: {$typeid_8}','string','yes','no','yes','Mapping of management protocol to devices'),('MUNIN_LISTSRC','false','string','yes','no','no','List of object with Munin graphs'),('NAMEWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','no','List source: objects for that common name should be set'),('NEAREST_RACKS_CHECKBOX','yes','string','yes','no','yes','Enable nearest racks in port list filter by default'),('PORT_EXCLUSION_LISTSRC','{$typeid_3} or {$typeid_10} or {$typeid_11} or {$typeid_1505} or {$typeid_1506}','string','yes','no','no','List source: objects without ports'),('PREVIEW_IMAGE_MAXPXS','320','uint','yes','no','yes','Max pixels per axis for image file preview'),('PREVIEW_TEXT_COLS','80','uint','yes','no','yes','Columns for text file preview'),('PREVIEW_TEXT_MAXCHARS','10240','uint','yes','no','yes','Max chars for text file preview'),('PREVIEW_TEXT_ROWS','25','uint','yes','no','yes','Rows for text file preview'),('PROXIMITY_RANGE','0','uint','yes','no','yes','Proximity range (0 is current rack only)'),('QUICK_LINK_PAGES','depot,ipv4space,rackspace','string','yes','no','yes','List of pages to dislay in quick links'),('RACK_PRESELECT_THRESHOLD','1','uint','no','no','yes','Rack pre-selection threshold'),('RACKS_PER_ROW','12','uint','yes','no','yes','Racks per row'),('REVERSED_RACKS_LISTSRC','false','string','yes','no','no','List of racks with reversed (top to bottom) units order'),('ROW_SCALE','2','uint','no','no','yes','Picture scale for rack row display'),('SEARCH_DOMAINS','','string','yes','no','yes','DNS domain list (comma-separated) to search in FQDN attributes'),('SHOW_AUTOMATIC_TAGS','no','string','no','no','yes','Show automatic tags'),('SHOW_EXPLICIT_TAGS','yes','string','no','no','yes','Show explicit tags'),('SHOW_IMPLICIT_TAGS','yes','string','no','no','yes','Show implicit tags'),('SHOW_LAST_TAB','yes','string','yes','no','yes','Remember last tab shown for each page'),('SHRINK_TAG_TREE_ON_CLICK','yes','string','no','no','yes','Dynamically hide useless tags in tagtree'),('STATIC_FILTER','yes','string','no','no','yes','Enable Filter Caching'),('SYNC_802Q_LISTSRC','','string','yes','no','no','List of VLAN switches sync is enabled on'),('SYNCDOMAIN_MAX_PROCESSES','0','uint','yes','no','no','How many worker proceses syncdomain cron script should create'),('TAGS_QUICKLIST_SIZE','20','uint','no','no','yes','Tags quick list size'),('TAGS_QUICKLIST_THRESHOLD','50','uint','yes','no','yes','Tags quick list threshold'),('TAGS_TOPLIST_SIZE','50','uint','yes','no','yes','Tags top list size'),('TREE_THRESHOLD','25','uint','yes','no','yes','Tree view auto-collapse threshold'),('VENDOR_SIEVE','','string','yes','no','yes','Vendor sieve configuration'),('VIRTUAL_OBJ_LISTSRC','1504,1505,1506,1507','string','no','no','no','List source: virtual objects'),('VLANIPV4NET_LISTSRC','','string','yes','no','yes','List of VLAN-based IPv4 networks'),('VLANSWITCH_LISTSRC','','string','yes','no','yes','List of VLAN running switches');
INSERT INTO `Config` VALUES ('8021Q_DEPLOY_MAXAGE','3600','uint','no','no','no','802.1Q deploy maximum age'),('8021Q_DEPLOY_MINAGE','300','uint','no','no','no','802.1Q deploy minimum age'),('8021Q_DEPLOY_RETRY','10800','uint','no','no','no','802.1Q deploy retry timer'),('8021Q_EXTSYNC_LISTSRC','false','string','yes','no','no','List source: objects with extended 802.1Q sync'),('8021Q_INSTANT_DEPLOY','no','string','no','no','yes','802.1Q: instant deploy'),('8021Q_MULTILINK_LISTSRC','false','string','yes','no','no','List source: IPv4/IPv6 networks allowing multiple VLANs from same domain'),('8021Q_WRI_AFTER_CONFT_LISTSRC','false','string','no','no','no','802.1Q: save device configuration after deploy (RackCode)'),('ADDNEW_AT_TOP','yes','string','no','no','yes','Render \"add new\" line at top of the list'),('ASSETWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','no','List source: objects for that asset tag should be set'),('AUTOPORTS_CONFIG','4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm','string','yes','no','no','AutoPorts configuration'),('CACTI_LISTSRC','false','string','yes','no','no','List of object with Cacti graphs'),('CACTI_RRA_ID','1','uint','no','no','yes','RRA ID for Cacti graphs displayed in RackTables'),('CDP_RUNNERS_LISTSRC','','string','yes','no','no','List of devices running CDP'),('DATETIME_FORMAT','%Y-%m-%d','string','no','no','yes','PHP strftime() format to use for date output'),('DATETIME_ZONE','UTC','string','yes','no','yes','Timezone to use for displaying/calculating dates'),('DB_VERSION','0.20.8','string','no','yes','no','Database version.'),('DEFAULT_IPV4_RS_INSERVICE','no','string','no','no','yes','Inservice status for new SLB real servers'),('DEFAULT_OBJECT_TYPE','4','uint','yes','no','yes','Default object type for new objects'),('DEFAULT_PORT_IIF_ID','1','uint','no','no','no','Default port inner interface ID'),('DEFAULT_PORT_OIF_IDS','1=24; 3=1078; 4=1077; 5=1079; 6=1080; 8=1082; 9=1084; 10=1588; 11=1668','string','no','no','no','Default port outer interface IDs'),('DEFAULT_RACK_HEIGHT','42','uint','yes','no','yes','Default rack height'),('DEFAULT_SLB_RS_PORT','','uint','yes','no','yes','Default port of SLB real server'),('DEFAULT_SLB_VS_PORT','','uint','yes','no','yes','Default port of SLB virtual service'),('DEFAULT_SNMP_COMMUNITY','public','string','no','no','no','Default SNMP Community string'),('DEFAULT_VDOM_ID','','uint','yes','no','yes','Default VLAN domain ID'),('DEFAULT_VST_ID','','uint','yes','no','yes','Default VLAN switch template ID'),('DETECT_URLS','no','string','yes','no','yes','Detect URLs in text fields'),('ENABLE_BULKPORT_FORM','yes','string','no','no','yes','Enable \"Bulk Port\" form'),('ENABLE_MULTIPORT_FORM','no','string','no','no','yes','Enable \"Add/update multiple ports\" form'),('enterprise','MyCompanyName','string','no','no','no','Organization name'),('EXT_IPV4_VIEW','yes','string','no','no','yes','Extended IPv4 view'),('FILTER_DEFAULT_ANDOR','and','string','no','no','yes','Default list filter boolean operation (or/and)'),('FILTER_PREDICATE_SIEVE','','string','yes','no','yes','Predicate sieve regex(7)'),('FILTER_RACKLIST_BY_TAGS','yes','string','yes','no','yes','Rackspace: show only racks matching the current object\'s tags'),('FILTER_SUGGEST_ANDOR','yes','string','no','no','yes','Suggest and/or selector in list filter'),('FILTER_SUGGEST_EXTRA','yes','string','no','no','yes','Suggest extra expression in list filter'),('FILTER_SUGGEST_PREDICATES','yes','string','no','no','yes','Suggest predicates in list filter'),('FILTER_SUGGEST_TAGS','yes','string','no','no','yes','Suggest tags in list filter'),('IPV4_ADDRS_PER_PAGE','256','uint','no','no','yes','IPv4 addresses per page'),('IPV4_AUTO_RELEASE','1','uint','no','no','yes','Auto-release IPv4 addresses on allocation'),('IPV4_ENABLE_KNIGHT','yes','string','no','no','yes','Enable IPv4 knight feature'),('IPV4_JAYWALK','no','string','no','no','no','Enable IPv4 address allocations w/o covering network'),('IPV4_TREE_RTR_AS_CELL','no','string','no','no','yes','Show full router info for each network in IPv4 tree view'),('IPV4_TREE_SHOW_USAGE','no','string','no','no','yes','Show address usage in IPv4 tree'),('IPV4_TREE_SHOW_VLAN','yes','string','no','no','yes','Show VLAN for each network in IPv4 tree'),('IPV4LB_LISTSRC','false','string','yes','no','no','List source: IPv4 load balancers'),('IPV4NAT_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8} or {$typeid_798}','string','yes','no','no','List source: IPv4 NAT performers'),('IPV4OBJ_LISTSRC','not ({$typeid_3} or {$typeid_9} or {$typeid_10} or {$typeid_11})','string','yes','no','no','List source: IPv4-enabled objects'),('LLDP_RUNNERS_LISTSRC','','string','yes','no','no','List of devices running LLDP'),('MASSCOUNT','8','uint','no','no','yes','"Fast" form is this many records tall'),('MAX_UNFILTERED_ENTITIES','0','uint','no','no','yes','Max item count to display on unfiltered result page'),('MAXSELSIZE','30','uint','no','no','yes','<SELECT> lists height'),('MGMT_PROTOS','ssh: {$typeid_4}; telnet: {$typeid_8}','string','yes','no','yes','Mapping of management protocol to devices'),('MUNIN_LISTSRC','false','string','yes','no','no','List of object with Munin graphs'),('NAMEWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','no','List source: objects for that common name should be set'),('NEAREST_RACKS_CHECKBOX','yes','string','yes','no','yes','Enable nearest racks in port list filter by default'),('PORT_EXCLUSION_LISTSRC','{$typeid_3} or {$typeid_10} or {$typeid_11} or {$typeid_1505} or {$typeid_1506}','string','yes','no','no','List source: objects without ports'),('PREVIEW_IMAGE_MAXPXS','320','uint','yes','no','yes','Max pixels per axis for image file preview'),('PREVIEW_TEXT_COLS','80','uint','yes','no','yes','Columns for text file preview'),('PREVIEW_TEXT_MAXCHARS','10240','uint','yes','no','yes','Max chars for text file preview'),('PREVIEW_TEXT_ROWS','25','uint','yes','no','yes','Rows for text file preview'),('PROXIMITY_RANGE','0','uint','yes','no','yes','Proximity range (0 is current rack only)'),('QUICK_LINK_PAGES','depot,ipv4space,rackspace','string','yes','no','yes','List of pages to display in quick links'),('RACK_PRESELECT_THRESHOLD','1','uint','no','no','yes','Rack pre-selection threshold'),('RACKS_PER_ROW','12','uint','yes','no','yes','Racks per row'),('REVERSED_RACKS_LISTSRC','false','string','yes','no','no','List of racks with reversed (top to bottom) units order'),('ROW_SCALE','2','uint','no','no','yes','Picture scale for rack row display'),('SEARCH_DOMAINS','','string','yes','no','yes','DNS domain list (comma-separated) to search in FQDN attributes'),('SHOW_AUTOMATIC_TAGS','no','string','no','no','yes','Show automatic tags'),('SHOW_EXPLICIT_TAGS','yes','string','no','no','yes','Show explicit tags'),('SHOW_IMPLICIT_TAGS','yes','string','no','no','yes','Show implicit tags'),('SHOW_LAST_TAB','yes','string','yes','no','yes','Remember last tab shown for each page'),('SHRINK_TAG_TREE_ON_CLICK','yes','string','no','no','yes','Dynamically hide useless tags in tagtree'),('STATIC_FILTER','yes','string','no','no','yes','Enable Filter Caching'),('SYNC_802Q_LISTSRC','','string','yes','no','no','List of VLAN switches sync is enabled on'),('SYNCDOMAIN_MAX_PROCESSES','0','uint','yes','no','no','How many worker proceses syncdomain cron script should create'),('TAGS_QUICKLIST_SIZE','20','uint','no','no','yes','Tags quick list size'),('TAGS_QUICKLIST_THRESHOLD','50','uint','yes','no','yes','Tags quick list threshold'),('TAGS_TOPLIST_SIZE','50','uint','yes','no','yes','Tags top list size'),('TREE_THRESHOLD','25','uint','yes','no','yes','Tree view auto-collapse threshold'),('VENDOR_SIEVE','','string','yes','no','yes','Vendor sieve configuration'),('VIRTUAL_OBJ_LISTSRC','1504,1505,1506,1507','string','no','no','no','List source: virtual objects'),('VLANIPV4NET_LISTSRC','','string','yes','no','yes','List of VLAN-based IPv4 networks'),('VLANSWITCH_LISTSRC','','string','yes','no','yes','List of VLAN running switches');
/*!40000 ALTER TABLE `Config` ENABLE KEYS */;
/*!40000 ALTER TABLE `Config` ENABLE KEYS */;
UNLOCK TABLES;
UNLOCK TABLES;
--
--
-- Table structure for table `Dictionary`
-- Table structure for table `Dictionary`
--
--
DROP TABLE IF EXISTS `Dictionary`;
DROP TABLE IF EXISTS `Dictionary`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Dictionary` (
CREATE TABLE `Dictionary` (
`chapter_id` int(10) unsigned NOT NULL,
`chapter_id` int(10) unsigned NOT NULL,
`dict_key` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dict_key` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dict_sticky` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
`dict_sticky` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'no',
`dict_value` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`dict_value` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`dict_key`),
PRIMARY KEY (`dict_key`),
UNIQUE KEY `dict_unique` (`chapter_id`,`dict_value`,`dict_sticky`),
UNIQUE KEY `dict_unique` (`chapter_id`,`dict_value`,`dict_sticky`),
CONSTRAINT `Dictionary-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`)
CONSTRAINT `Dictionary-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) ENGINE=InnoDB AUTO_INCREMENT=50000 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--
-- Dumping data for table `Dictionary`
-- Dumping data for table `Dictionary`
--
--
LOCK TABLES `Dictionary` WRITE;
LOCK TABLES `Dictionary` WRITE;
/*!40000 ALTER TABLE `Dictionary` DISABLE KEYS */;
/*!40000 ALTER TABLE `Dictionary` DISABLE KEYS */;
INSERT INTO `Dictionary` VALUES (1,1,'yes','BlackBox'),(1,10,'yes','CableOr
INSERT INTO