-- MySQL dump 10.13  Distrib 5.5.43, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: rt-math-1
-- ------------------------------------------------------
-- Server version	5.5.43-0ubuntu0.14.04.1-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `client_users`
--

DROP TABLE IF EXISTS `client_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_users` (
  `email` char(40) NOT NULL DEFAULT '',
  `name` char(50) NOT NULL DEFAULT '',
  `password` char(40) DEFAULT NULL,
  `offExt` char(8) DEFAULT NULL,
  `offLoc` char(30) DEFAULT NULL,
  `department` char(20) DEFAULT NULL,
  `groupReq` char(20) DEFAULT NULL,
  `date_updated` int(11) DEFAULT NULL,
  `mail_trans` int(1) DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `each_req`
--

DROP TABLE IF EXISTS `each_req`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `each_req` (
  `serial_num` int(11) NOT NULL AUTO_INCREMENT,
  `effective_sn` int(11) DEFAULT NULL,
  `queue_id` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `requestors` varchar(255) DEFAULT NULL,
  `owner` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `initial_priority` int(11) DEFAULT NULL,
  `final_priority` int(11) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `time_worked` int(11) DEFAULT NULL,
  `date_time_worked` int(11) DEFAULT NULL,
  `date_created` int(11) DEFAULT NULL,
  `date_told` int(11) DEFAULT NULL,
  `date_acted` int(11) DEFAULT NULL,
  `date_start` int(11) DEFAULT NULL,
  `date_due` int(11) DEFAULT NULL,
  `id_other` varchar(255) DEFAULT NULL,
  `sponsors` varchar(255) DEFAULT NULL,
  `theme` varchar(255) DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  `component` varchar(255) DEFAULT NULL,
  `advancement` varchar(255) DEFAULT NULL,
  `date_assigned` int(11) DEFAULT NULL,
  `date_done` int(11) DEFAULT NULL,
  `assigned_by` varchar(255) DEFAULT NULL,
  `package` varchar(255) DEFAULT NULL,
  `tentative_who` varchar(255) DEFAULT NULL,
  `dependencies` text,
  `notification` varchar(255) DEFAULT NULL,
  `see_also` text,
  `merged` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `equip_type` varchar(255) DEFAULT NULL,
  `equip_other` varchar(255) DEFAULT NULL,
  `equip_name` varchar(255) DEFAULT NULL,
  `equip_barcode` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `software` varchar(255) DEFAULT NULL,
  `private` int(1) DEFAULT NULL,
  `urgency` enum('not','asp','24h','Urg','EM!') DEFAULT NULL,
  `submitted_for` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `signing_authority` varchar(255) DEFAULT NULL,
  `offExt` varchar(255) DEFAULT NULL,
  `offLoc` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `audited_by` varchar(255) DEFAULT NULL,
  `cost_estimate` varchar(255) DEFAULT NULL,
  `date_worked` int(11) DEFAULT NULL,
  `date_summarized` int(11) DEFAULT NULL,
  `subscription_code` varchar(255) DEFAULT NULL,
  `responsible` varchar(255) DEFAULT NULL,
  `summary` text,
  `timing` enum('reactive','proactive') DEFAULT NULL,
  PRIMARY KEY (`serial_num`),
  KEY `effective_sn` (`effective_sn`),
  KEY `equip_name_index` (`equip_name`),
  FULLTEXT KEY `summary` (`summary`),
  FULLTEXT KEY `subject` (`subject`)
) ENGINE=MyISAM AUTO_INCREMENT=100417 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `owner`
--

DROP TABLE IF EXISTS `owner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `owner` (
  `ownerId` varchar(12) NOT NULL DEFAULT '',
  `name` varchar(30) NOT NULL DEFAULT '',
  `isRole` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ownerId`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ownerOrganization`
--

DROP TABLE IF EXISTS `ownerOrganization`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ownerOrganization` (
  `ownerId` varchar(12) NOT NULL DEFAULT '',
  `orgId` int(11) NOT NULL DEFAULT '0',
  `roles` set('RSG') DEFAULT NULL,
  PRIMARY KEY (`ownerId`,`orgId`),
  CONSTRAINT `0_372` FOREIGN KEY (`ownerId`) REFERENCES `owner` (`ownerId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `queue_acl`
--

DROP TABLE IF EXISTS `queue_acl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queue_acl` (
  `queue_id` char(40) DEFAULT NULL,
  `auth_key` char(80) DEFAULT NULL,
  `user_id` char(40) DEFAULT NULL,
  `date_updated` int(11) DEFAULT NULL,
  `date_expires` int(11) DEFAULT NULL,
  `can_create` tinyint(4) DEFAULT NULL,
  `comment` tinyint(4) DEFAULT NULL,
  `reply` tinyint(4) DEFAULT NULL,
  `summary` tinyint(4) DEFAULT NULL,
  `history` tinyint(4) DEFAULT NULL,
  `manipulate` tinyint(4) DEFAULT NULL,
  `admin` tinyint(4) DEFAULT NULL,
  `mail` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `queue_area_people`
--

DROP TABLE IF EXISTS `queue_area_people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queue_area_people` (
  `queue_id` char(40) NOT NULL DEFAULT '',
  `area` char(40) NOT NULL DEFAULT '',
  `user_id` char(40) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `queue_areas`
--

DROP TABLE IF EXISTS `queue_areas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queue_areas` (
  `queue_id` char(40) NOT NULL DEFAULT '',
  `area` char(40) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `queues`
--

DROP TABLE IF EXISTS `queues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queues` (
  `queue_id` char(40) NOT NULL DEFAULT '',
  `mail_alias` char(40) DEFAULT NULL,
  `comment_alias` char(40) DEFAULT NULL,
  `m_owner_trans` int(11) DEFAULT NULL,
  `m_members_trans` int(11) DEFAULT NULL,
  `m_user_trans` int(11) DEFAULT NULL,
  `m_user_create` int(11) DEFAULT NULL,
  `m_members_corresp` int(11) DEFAULT NULL,
  `m_members_comment` int(11) DEFAULT NULL,
  `m_user_resolve` int(11) DEFAULT NULL,
  `default_prio` int(11) DEFAULT NULL,
  `default_final_prio` int(11) DEFAULT NULL,
  `default_due_in` int(11) DEFAULT NULL,
  PRIMARY KEY (`queue_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `refers_to`
--

DROP TABLE IF EXISTS `refers_to`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `refers_to` (
  `serial_num` int(11) NOT NULL DEFAULT '0',
  `type` enum('dependency','see_also') NOT NULL DEFAULT 'dependency',
  `seq_num` smallint(6) NOT NULL DEFAULT '0',
  `reference` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`serial_num`,`type`,`seq_num`),
  KEY `reference` (`reference`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='an efficiently queryable form of references to other\nitems f';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `effective_sn` int(11) DEFAULT NULL,
  `serial_num` int(11) DEFAULT NULL,
  `actor` varchar(100) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `trans_data` text,
  `trans_date` int(11) DEFAULT NULL,
  `trans_prev` text,
  `content` text,
  PRIMARY KEY (`id`),
  KEY `effective_sn` (`effective_sn`),
  KEY `serial_num` (`serial_num`),
  KEY `type_index` (`type`),
  KEY `trans_date_index` (`trans_date`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM AUTO_INCREMENT=1086783 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `user_id` char(40) NOT NULL DEFAULT '',
  `real_name` char(40) DEFAULT NULL,
  `password` char(40) DEFAULT NULL,
  `email` char(40) DEFAULT NULL,
  `phone` char(15) DEFAULT NULL,
  `office` char(30) DEFAULT NULL,
  `department` char(20) DEFAULT NULL,
  `comments` char(120) DEFAULT NULL,
  `admin_rt` int(11) DEFAULT NULL,
  `date_updated` int(11) DEFAULT NULL,
  `mail_trans` int(1) DEFAULT NULL,
  `m_user_create` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM 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 2015-06-14  9:09:24