diff options
Diffstat (limited to 'basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.eclipse.build.tools/scripts_cvs/searchcvs/mysql-modelingschema.dump')
-rw-r--r-- | basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.eclipse.build.tools/scripts_cvs/searchcvs/mysql-modelingschema.dump | 161 |
1 files changed, 161 insertions, 0 deletions
diff --git a/basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.eclipse.build.tools/scripts_cvs/searchcvs/mysql-modelingschema.dump b/basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.eclipse.build.tools/scripts_cvs/searchcvs/mysql-modelingschema.dump new file mode 100644 index 0000000..a33d400 --- /dev/null +++ b/basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.eclipse.build.tools/scripts_cvs/searchcvs/mysql-modelingschema.dump @@ -0,0 +1,161 @@ +-- 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 */; + |