diff options
author | Moritz Lenz <moritz@faui2k3.org> | 2010-05-22 13:59:48 (GMT) |
---|---|---|
committer | Moritz Lenz <moritz@faui2k3.org> | 2010-05-22 13:59:48 (GMT) |
commit | b60a0a9933a32ee1b4adcc3d2892e98401bd405e (patch) | |
tree | 65d1c86fbf03c3e31a4ac02ead15d3a4d5a83302 | |
parent | af9f970c4c2c223289cd909015eaa8ce302719fa (diff) |
replace schema by mysqldump
-rw-r--r-- | ilbot.sql | 49 |
1 files changed, 38 insertions, 11 deletions
@@ -1,13 +1,40 @@ +-- MySQL dump 10.11 +-- +-- Host: localhost Database: moritz5 +-- ------------------------------------------------------ +-- Server version 5.0.51a-24+lenny3 + +/*!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 `irclog` +-- + DROP TABLE IF EXISTS `irclog`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; CREATE TABLE `irclog` ( - id INT auto_increment, - channel VARCHAR(30), - day CHAR(10), - nick VARCHAR(40), - timestamp INT, - line TEXT, - spam BOOL default false, - PRIMARY KEY(`id`) - ) CHARSET=utf8; - --- vim: sw=4 ts=4 expandtab + `id` int(11) NOT NULL auto_increment, + `channel` varchar(30) default NULL, + `day` char(10) default NULL, + `nick` varchar(40) default NULL, + `timestamp` int(11) default NULL, + `line` mediumtext, + `spam` tinyint(1) default '0', + PRIMARY KEY (`id`), + KEY `nick_index` (`nick`), + KEY `day_index` (`day`), + KEY `irclog_day_channel_idx` (`day`,`channel`), + KEY `channel_idx` (`channel`), + FULLTEXT KEY `message_index` (`line`) +) ENGINE=MyISAM AUTO_INCREMENT=2357358 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; |