-- MySQL dump 10.10
-- 
-- You can load this file into mysql using: 
-- $ mysql -u root -p < mysql-modelingschema.dump
-- 
-- Note that the database name for the stored CVS data is `modeling`, as in the Eclipse Modeling Project. 
-- You'll probably want to change that for your project's needs.
-- 
-- Host: localhost    Database: modeling
-- ------------------------------------------------------
-- Server version	5.0.22-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 */;

DROP DATABASE IF EXISTS `modeling`;
CREATE DATABASE `modeling`;

USE `modeling`;

--
-- Table structure for table `bugs`
--

DROP TABLE IF EXISTS `bugs`;
CREATE TABLE `bugs` (
  `fid` smallint(5) unsigned NOT NULL,
  `revision` varchar(15) NOT NULL,
  `bugid` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`fid`,`revision`,`bugid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bugs`
--


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

--
-- Table structure for table `commits`
--

DROP TABLE IF EXISTS `commits`;
CREATE TABLE `commits` (
  `fid` smallint(5) unsigned NOT NULL,
  `revision` varchar(15) NOT NULL,
  `date` datetime NOT NULL,
  `author` varchar(20) NOT NULL,
  `state` enum('Exp','dead') NOT NULL,
  `linesplus` smallint(5) unsigned default NULL,
  `linesminus` smallint(5) unsigned default NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`fid`,`revision`),
  KEY `author` (`author`),
  FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `commits`
--


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

--
-- Table structure for table `cvsfiles`
--

DROP TABLE IF EXISTS `cvsfiles`;
CREATE TABLE `cvsfiles` (
  `fid` int(11) NOT NULL auto_increment,
  `cvsname` text NOT NULL,
  `head` varchar(15) NOT NULL,
  `keyword_subs` enum('b','k','kv','kvl','v') NOT NULL,
  `project` varchar(50) NOT NULL,
  PRIMARY KEY  (`fid`),
  KEY `project` (`project`),
  UNIQUE KEY `cvsname` (`cvsname`(333))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cvsfiles`
--


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

--
-- Table structure for table `filetags`
--

DROP TABLE IF EXISTS `filetags`;
CREATE TABLE `filetags` (
  `fid` mediumint(8) unsigned NOT NULL,
  `tid` smallint(5) unsigned NOT NULL,
  `revision` varchar(15) NOT NULL,
  PRIMARY KEY  (`fid`,`tid`),
  KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `filetags`
--


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

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `tid` int(11) NOT NULL auto_increment,
  `tagname` varbinary(50) NOT NULL,
  `tagdate` datetime default NULL,
  PRIMARY KEY  (`tid`),
  UNIQUE KEY `tagname` (`tagname`),
  KEY `tagdate` (`tagdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tags`
--


/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
LOCK TABLES `tags` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
/*!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 */;