Ticket #6986: trac_schema_before.sql

-- MySQL dump 10.11
--
-- Host: localhost    Database: trac
-- ------------------------------------------------------
-- Server version       5.0.37-community-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 `attachment`
--

DROP TABLE IF EXISTS `attachment`;
CREATE TABLE `attachment` (
  `type` text NOT NULL,
  `id` text NOT NULL,
  `filename` text NOT NULL,
  `size` int(11) default NULL,
  `time` int(11) default NULL,
  `description` text,
  `author` text,
  `ipnr` text,
  PRIMARY KEY  (`type`(111),`id`(111),`filename`(111))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `auth_cookie`
--

DROP TABLE IF EXISTS `auth_cookie`;
CREATE TABLE `auth_cookie` (
  `cookie` text NOT NULL,
  `name` text NOT NULL,
  `ipnr` text NOT NULL,
  `time` int(11) default NULL,
  PRIMARY KEY  (`cookie`(111),`ipnr`(111),`name`(111))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `component`
--

DROP TABLE IF EXISTS `component`;
CREATE TABLE `component` (
  `name` text NOT NULL,
  `owner` text,
  `description` text,
  PRIMARY KEY  (`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `enum`
--

DROP TABLE IF EXISTS `enum`;
CREATE TABLE `enum` (
  `type` text NOT NULL,
  `name` text NOT NULL,
  `value` text,
  PRIMARY KEY  (`type`(166),`name`(166))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `milestone`
--

DROP TABLE IF EXISTS `milestone`;
CREATE TABLE `milestone` (
  `name` text NOT NULL,
  `due` int(11) default NULL,
  `completed` int(11) default NULL,
  `description` text,
  PRIMARY KEY  (`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `node_change`
--

DROP TABLE IF EXISTS `node_change`;
CREATE TABLE `node_change` (
  `rev` text NOT NULL,
  `path` text NOT NULL,
  `node_type` text,
  `change_type` text NOT NULL,
  `base_path` text,
  `base_rev` text,
  PRIMARY KEY  (`rev`(20),`path`(255),`change_type`(2)),
  KEY `node_change_rev_idx` (`rev`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `permission`
--

DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `username` text NOT NULL,
  `action` text NOT NULL,
  PRIMARY KEY  (`username`(166),`action`(166))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `report`
--

DROP TABLE IF EXISTS `report`;
CREATE TABLE `report` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `author` text,
  `title` text,
  `query` text,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `revision`
--

DROP TABLE IF EXISTS `revision`;
CREATE TABLE `revision` (
  `rev` text NOT NULL,
  `time` int(11) default NULL,
  `author` text,
  `message` text,
  PRIMARY KEY  (`rev`(20)),
  KEY `revision_time_idx` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `session`
--

DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
  `sid` text NOT NULL,
  `authenticated` int(11) NOT NULL default '0',
  `last_visit` int(11) default NULL,
  PRIMARY KEY  (`sid`(32),`authenticated`),
  KEY `session_last_visit_idx` (`last_visit`),
  KEY `session_authenticated_idx` (`authenticated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `session_attribute`
--

DROP TABLE IF EXISTS `session_attribute`;
CREATE TABLE `session_attribute` (
  `sid` text NOT NULL,
  `authenticated` int(11) NOT NULL default '0',
  `name` text NOT NULL,
  `value` text,
  PRIMARY KEY  (`sid`(32),`authenticated`,`name`(64))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `system`
--

DROP TABLE IF EXISTS `system`;
CREATE TABLE `system` (
  `name` text NOT NULL,
  `value` text,
  PRIMARY KEY  (`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `ticket`
--

DROP TABLE IF EXISTS `ticket`;
CREATE TABLE `ticket` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` text,
  `time` int(11) default NULL,
  `changetime` int(11) default NULL,
  `component` text,
  `severity` text,
  `priority` text,
  `owner` text,
  `reporter` text,
  `cc` text,
  `version` text,
  `milestone` text,
  `status` text,
  `resolution` text,
  `summary` text,
  `description` text,
  `keywords` text,
  PRIMARY KEY  (`id`),
  KEY `ticket_time_idx` (`time`),
  KEY `ticket_status_idx` (`status`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `ticket_change`
--

DROP TABLE IF EXISTS `ticket_change`;
CREATE TABLE `ticket_change` (
  `ticket` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `author` text,
  `field` text NOT NULL,
  `oldvalue` text,
  `newvalue` text,
  PRIMARY KEY  (`ticket`,`time`,`field`(111)),
  KEY `ticket_change_ticket_idx` (`ticket`),
  KEY `ticket_change_time_idx` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `ticket_custom`
--

DROP TABLE IF EXISTS `ticket_custom`;
CREATE TABLE `ticket_custom` (
  `ticket` int(11) NOT NULL default '0',
  `name` text NOT NULL,
  `value` text,
  PRIMARY KEY  (`ticket`,`name`(166))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `version`
--

DROP TABLE IF EXISTS `version`;
CREATE TABLE `version` (
  `name` text NOT NULL,
  `time` int(11) default NULL,
  `description` text,
  PRIMARY KEY  (`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `wiki`
--

DROP TABLE IF EXISTS `wiki`;
CREATE TABLE `wiki` (
  `name` text NOT NULL,
  `version` int(11) NOT NULL default '0',
  `time` int(11) default NULL,
  `author` text,
  `ipnr` text,
  `text` text,
  `comment` text,
  `readonly` int(11) default NULL,
  PRIMARY KEY  (`name`(166),`version`),
  KEY `wiki_time_idx` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!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 2008-03-07 20:00:43