Distribuzione FUSS » octomon

-- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (x86_64)

--

-- Host: localhost    Database: octomon

-- ------------------------------------------------------

-- Server version	5.5.31-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 */;

--

-- Table structure for table `activity`

--

DROP TABLE IF EXISTS `activity`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `activity` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `user_id` int(11) DEFAULT NULL,

  `description` varchar(2000) NOT NULL,

  `timestamp` datetime DEFAULT NULL,

  `end_timestamp` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `activity_school_id_exists` (`school_id`),

  KEY `activity_user_id_exists` (`user_id`)

) ENGINE=MyISAM AUTO_INCREMENT=7545 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `alarm_definition`

--

DROP TABLE IF EXISTS `alarm_definition`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `alarm_definition` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `user_id` int(11) NOT NULL,

  `description` varchar(200) NOT NULL,

  `code` varchar(2000) NOT NULL,

  `active` tinyint(4) NOT NULL,

  `local` tinyint(4) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `alarm_definition_user_id_exists` (`user_id`)

) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `alarm_definition_run`

--

DROP TABLE IF EXISTS `alarm_definition_run`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `alarm_definition_run` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `definition_id` int(11) NOT NULL,

  `school_timestamp` double DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `schoolDefIndex` (`school_id`,`definition_id`),

  KEY `alarm_definition_run_definition_id_exists` (`definition_id`)

) ENGINE=MyISAM AUTO_INCREMENT=159 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `alarms`

--

DROP TABLE IF EXISTS `alarms`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `alarms` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `host_id` int(11) NOT NULL,

  `definition_id` int(11) DEFAULT NULL,

  `description` varchar(200) NOT NULL,

  `timestamp` datetime DEFAULT NULL,

  `ack` tinyint(4) DEFAULT NULL,

  `ack_by_id` int(11) DEFAULT NULL,

  `ack_when` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `alarms_ack_by_id_exists` (`ack_by_id`),

  KEY `alarms_host_id_exists` (`host_id`),

  KEY `alarms_definition_id_exists` (`definition_id`)

) ENGINE=MyISAM AUTO_INCREMENT=7241 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `area`

--

DROP TABLE IF EXISTS `area`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `area` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `code` varchar(50) DEFAULT NULL,

  `name` varchar(150) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `components`

--

DROP TABLE IF EXISTS `components`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `components` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(200) DEFAULT NULL,

  `value` varchar(200) DEFAULT NULL,

  `host_id` int(11) DEFAULT NULL,

  `timestamp` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `components_name_host_id` (`name`,`host_id`),

  KEY `components_host_id_name` (`host_id`,`name`)

) ENGINE=MyISAM AUTO_INCREMENT=27731667 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `computer`

--

DROP TABLE IF EXISTS `computer`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `computer` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `hostname` varchar(200) DEFAULT NULL,

  `serial_number` varchar(200) DEFAULT NULL,

  `video_serial_number` varchar(200) DEFAULT NULL,

  `location` varchar(200) DEFAULT NULL,

  `warranty_expire` date DEFAULT NULL,

  `dismissed` tinyint(4) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `computer_school_id_exists` (`school_id`)

) ENGINE=MyISAM AUTO_INCREMENT=6352 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `group_permission`

--

DROP TABLE IF EXISTS `group_permission`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `group_permission` (

  `group_id` int(11) NOT NULL,

  `permission_id` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `host_scrap_book`

--

DROP TABLE IF EXISTS `host_scrap_book`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `host_scrap_book` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `host_id` int(11) NOT NULL,

  `user_id` int(11) DEFAULT NULL,

  `content` varchar(2000) NOT NULL,

  `timestamp` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `host_scrap_book_host_id_exists` (`host_id`),

  KEY `host_scrap_book_user_id_exists` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `other_hardware`

--

DROP TABLE IF EXISTS `other_hardware`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `other_hardware` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `kind_id` int(11) DEFAULT NULL,

  `vendor` varchar(200) DEFAULT NULL,

  `model` varchar(200) DEFAULT NULL,

  `serial_number` varchar(200) DEFAULT NULL,

  `warranty_expire` date DEFAULT NULL,

  `location` varchar(200) DEFAULT NULL,

  `dismissed` tinyint(1) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `other_hardware_school_id_exists` (`school_id`),

  KEY `other_hardware_kind_id_exists` (`kind_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `other_hardware_kind`

--

DROP TABLE IF EXISTS `other_hardware_kind`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `other_hardware_kind` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(200) DEFAULT NULL,

  `description` varchar(200) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `permission`

--

DROP TABLE IF EXISTS `permission`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `permission` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `permission_name` varchar(16) NOT NULL,

  `description` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `permission_name` (`permission_name`)

) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `school`

--

DROP TABLE IF EXISTS `school`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `school` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(200) DEFAULT NULL,

  `area_id` int(11) DEFAULT NULL,

  `address` varchar(300) DEFAULT NULL,

  `phone_number` varchar(200) DEFAULT NULL,

  `email_address` varchar(200) DEFAULT NULL,

  `lat` double DEFAULT NULL,

  `lon` double DEFAULT NULL,

  `last_timestamp` double DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `school_area_id_exists` (`area_id`)

) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `school_key`

--

DROP TABLE IF EXISTS `school_key`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `school_key` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `fingerprint` varchar(200) NOT NULL,

  `crypto_key` text,

  PRIMARY KEY (`id`),

  UNIQUE KEY `fingerprint` (`fingerprint`),

  KEY `school_key_school_id_exists` (`school_id`)

) ENGINE=MyISAM AUTO_INCREMENT=238 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `school_key_usage`

--

DROP TABLE IF EXISTS `school_key_usage`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `school_key_usage` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `key_id` int(11) DEFAULT NULL,

  `timestamp` datetime DEFAULT NULL,

  `first_data_timestamp` double DEFAULT NULL,

  `last_data_timestamp` double DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `school_key_usage_school_id_exists` (`school_id`),

  KEY `school_key_usage_key_id_exists` (`key_id`)

) ENGINE=MyISAM AUTO_INCREMENT=10069 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `school_props`

--

DROP TABLE IF EXISTS `school_props`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `school_props` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `propname` varchar(200) NOT NULL,

  `propvalue` varchar(200) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `school_props_school_id_exists` (`school_id`)

) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `school_tg_user`

--

DROP TABLE IF EXISTS `school_tg_user`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `school_tg_user` (

  `school_id` int(11) NOT NULL,

  `tg_user_id` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `scrap_book`

--

DROP TABLE IF EXISTS `scrap_book`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `scrap_book` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `school_id` int(11) NOT NULL,

  `user_id` int(11) DEFAULT NULL,

  `content` varchar(2000) NOT NULL,

  `timestamp` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `scrap_book_school_id_exists` (`school_id`),

  KEY `scrap_book_user_id_exists` (`user_id`)

) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `tg_group`

--

DROP TABLE IF EXISTS `tg_group`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `tg_group` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `group_name` varchar(16) NOT NULL,

  `display_name` varchar(255) DEFAULT NULL,

  `created` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `group_name` (`group_name`)

) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `tg_user`

--

DROP TABLE IF EXISTS `tg_user`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `tg_user` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `user_name` varchar(16) NOT NULL,

  `email_address` varchar(255) NOT NULL,

  `display_name` varchar(255) DEFAULT NULL,

  `password` varchar(40) DEFAULT NULL,

  `created` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `user_name` (`user_name`),

  UNIQUE KEY `email_address` (`email_address`)

) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `ticket`

--

DROP TABLE IF EXISTS `ticket`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ticket` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `opened` datetime DEFAULT NULL,

  `opened_by_id` int(11) DEFAULT NULL,

  `ticket_for` varchar(200) DEFAULT NULL,

  `object_id` int(11) DEFAULT NULL,

  `description` varchar(2000) DEFAULT NULL,

  `closed` datetime DEFAULT NULL,

  `closed_by` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `ticket_opened_by_id_exists` (`opened_by_id`)

) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `ticket_note`

--

DROP TABLE IF EXISTS `ticket_note`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ticket_note` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `ticket_id` int(11) DEFAULT NULL,

  `user_id` int(11) DEFAULT NULL,

  `timestamp` datetime DEFAULT NULL,

  `content` varchar(2000) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `ticket_note_ticket_id_exists` (`ticket_id`),

  KEY `ticket_note_user_id_exists` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `used`

--

DROP TABLE IF EXISTS `used`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `used` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `host_id` int(11) NOT NULL,

  `timestamp` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `used_host_id_exists` (`host_id`)

) ENGINE=MyISAM AUTO_INCREMENT=1185194 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `used_not_good`

--

DROP TABLE IF EXISTS `used_not_good`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `used_not_good` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `host_id` int(11) NOT NULL,

  `timestamp` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `used_host_id_exists` (`host_id`)

) ENGINE=MyISAM AUTO_INCREMENT=793 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `user_group`

--

DROP TABLE IF EXISTS `user_group`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `user_group` (

  `group_id` int(11) NOT NULL,

  `user_id` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `visit`

--

DROP TABLE IF EXISTS `visit`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `visit` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `visit_key` varchar(40) NOT NULL,

  `created` datetime DEFAULT NULL,

  `expiry` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `visit_key` (`visit_key`)

) ENGINE=MyISAM AUTO_INCREMENT=15645 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Table structure for table `visit_identity`

--

DROP TABLE IF EXISTS `visit_identity`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `visit_identity` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `visit_key` varchar(40) NOT NULL,

  `user_id` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `visit_key` (`visit_key`)

) ENGINE=MyISAM AUTO_INCREMENT=3195 DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!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 2013-07-16 19:03:56