/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `archive` (
`id` int(10) unsigned NOT NULL,
`boardid` smallint(5) unsigned NOT NULL,
`timestamp` int(20) unsigned NOT NULL,
`subject` varchar(255) CHARACTER SET latin1 NOT NULL,
`length` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`,`boardid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bans` (
`id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
`ip` int(15) unsigned NOT NULL,
`netmask` int(15) unsigned DEFAULT NULL,
`boards` text NOT NULL,
`added` int(10) unsigned NOT NULL,
`until` int(10) unsigned NOT NULL,
`staff` varchar(50) NOT NULL,
`reason` text NOT NULL,
`note` text NOT NULL,
`blind` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=980 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boards` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`dir` varchar(16) NOT NULL,
`sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(64) NOT NULL,
`longname` varchar(128) NOT NULL,
`subname` char(3) NOT NULL,
`postarea_desc` text NOT NULL,
`postarea_extra` text NOT NULL,
`force_css` varchar(255) NOT NULL,
`board_type` tinyint(1) unsigned NOT NULL,
`anonymous` varchar(128) NOT NULL DEFAULT 'Sin Nombre',
`subject` varchar(64) NOT NULL DEFAULT 'Sin asunto',
`message` varchar(128) NOT NULL DEFAULT 'Sin mensaje',
`disable_name` tinyint(1) unsigned NOT NULL DEFAULT '0',
`disable_subject` tinyint(1) unsigned NOT NULL DEFAULT '0',
`useid` tinyint(1) unsigned NOT NULL DEFAULT '1',
`slip` tinyint(1) unsigned NOT NULL DEFAULT '0',
`countrycode` tinyint(1) unsigned DEFAULT '0',
`recyclebin` tinyint(1) unsigned NOT NULL DEFAULT '1',
`locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
`secret` tinyint(1) unsigned NOT NULL DEFAULT '0',
`allow_spoilers` tinyint(1) unsigned NOT NULL DEFAULT '0',
`allow_oekaki` tinyint(1) unsigned NOT NULL DEFAULT '0',
`allow_noimage` tinyint(1) unsigned NOT NULL DEFAULT '1',
`allow_images` tinyint(1) unsigned NOT NULL DEFAULT '1',
`allow_image_replies` tinyint(1) unsigned NOT NULL DEFAULT '1',
`maxsize` smallint(5) unsigned NOT NULL DEFAULT '500',
`thumb_px` smallint(3) unsigned NOT NULL DEFAULT '250',
`numthreads` tinyint(2) unsigned NOT NULL DEFAULT '10',
`numcont` tinyint(2) unsigned NOT NULL DEFAULT '10',
`numline` tinyint(3) unsigned NOT NULL DEFAULT '20',
`maxage` smallint(3) unsigned NOT NULL DEFAULT '0',
`maxinactive` smallint(3) unsigned NOT NULL DEFAULT '0',
`archive` tinyint(1) unsigned NOT NULL DEFAULT '0',
`threadsecs` smallint(4) unsigned NOT NULL DEFAULT '600',
`postsecs` tinyint(3) unsigned NOT NULL DEFAULT '30',
PRIMARY KEY (`id`),
KEY `dir` (`dir`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boards_filetypes` (
`boardid` smallint(5) unsigned NOT NULL,
`filetypeid` smallint(5) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `filetypes` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`ext` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`mime` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`preserve_name` tinyint(1) NOT NULL,
`ffmpeg_thumb` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `filters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`boards` text NOT NULL,
`type` tinyint(1) NOT NULL,
`action` tinyint(1) NOT NULL,
`from` varchar(255) NOT NULL,
`from_trip` varchar(30) NOT NULL,
`to` text NOT NULL,
`reason` varchar(255) NOT NULL,
`seconds` int(20) unsigned NOT NULL,
`blind` tinyint(1) NOT NULL,
`redirect_url` varchar(40) NOT NULL,
`redirect_time` tinyint(3) unsigned NOT NULL,
`staff` varchar(50) NOT NULL,
`added` int(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `last` (
`id` int(10) unsigned NOT NULL,
`boardid` smallint(5) unsigned NOT NULL,
`board_name` varchar(64) NOT NULL,
`timestamp` int(20) NOT NULL,
`timestamp_formatted` varchar(50) NOT NULL,
`content` varchar(200) NOT NULL,
`url` varchar(64) NOT NULL,
PRIMARY KEY (`id`,`boardid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`timestamp` int(20) unsigned NOT NULL,
`staff` varchar(75) NOT NULL,
`action` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4138 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(1) NOT NULL,
`staffid` tinyint(3) unsigned NOT NULL,
`staff_name` varchar(50) NOT NULL,
`title` varchar(255) NOT NULL,
`message` text NOT NULL,
`name` varchar(255) NOT NULL,
`timestamp_formatted` varchar(255) NOT NULL,
`timestamp` int(20) unsigned NOT NULL,
PRIMARY KEY (`type`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`boardid` smallint(5) unsigned NOT NULL,
`parentid` mediumint(10) unsigned NOT NULL,
`timestamp` int(20) unsigned DEFAULT NULL,
`timestamp_formatted` varchar(50) NOT NULL,
`name` varchar(255) NOT NULL,
`tripcode` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text NOT NULL,
`password` varchar(255) NOT NULL,
`file` varchar(75) NOT NULL,
`file_hex` varchar(75) NOT NULL,
`file_size` int(20) unsigned NOT NULL,
`image_width` smallint(5) unsigned NOT NULL,
`image_height` smallint(5) unsigned NOT NULL,
`thumb` varchar(255) NOT NULL,
`thumb_width` smallint(5) unsigned NOT NULL,
`thumb_height` smallint(5) unsigned NOT NULL,
`ip` int(15) unsigned NOT NULL,
`IS_DELETED` tinyint(1) NOT NULL,
`bumped` int(20) unsigned NOT NULL,
`last` int(20) unsigned NOT NULL,
`locked` tinyint(1) NOT NULL,
`expires` int(20) unsigned NOT NULL,
`expires_formatted` varchar(30) NOT NULL,
`expires_alert` tinyint(1) NOT NULL,
`length` smallint(4) unsigned NOT NULL,
PRIMARY KEY (`boardid`,`id`),
KEY `parentid` (`parentid`),
KEY `bumped` (`bumped`)
) ENGINE=MyISAM AUTO_INCREMENT=1743 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reports` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`board` varchar(16) NOT NULL,
`postid` int(10) unsigned NOT NULL,
`parentid` int(10) unsigned NOT NULL,
`link` varchar(64) NOT NULL,
`ip` varchar(15) NOT NULL,
`reason` varchar(255) NOT NULL,
`reporterip` varchar(15) NOT NULL,
`timestamp` int(20) unsigned NOT NULL,
`timestamp_formatted` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=811 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `search` (
`id` int(10) NOT NULL,
`boardid` smallint(5) NOT NULL,
`timestamp` int(20) NOT NULL,
`subject` varchar(255) CHARACTER SET latin1 NOT NULL,
`message` text CHARACTER SET latin1 NOT NULL,
`parentid` int(10) NOT NULL,
`parenttime` int(20) NOT NULL,
`parentsub` varchar(255) CHARACTER SET latin1 NOT NULL,
`num` smallint(5) NOT NULL,
PRIMARY KEY (`id`,`boardid`),
FULLTEXT KEY `message` (`message`),
FULLTEXT KEY `subject` (`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `search_kako` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`boardid` smallint(5) unsigned NOT NULL,
`pid` int(10) unsigned NOT NULL,
`subject` varchar(255) CHARACTER SET latin1 NOT NULL,
`message` text CHARACTER SET latin1 NOT NULL,
`parentid` int(10) unsigned NOT NULL,
`num` smallint(5) unsigned NOT NULL,
`timestamp_formatted` varchar(50) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`id`,`boardid`),
FULLTEXT KEY `kakoindex` (`message`,`subject`)
) ENGINE=MyISAM AUTO_INCREMENT=115631 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `search_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`timestamp` int(20) unsigned NOT NULL,
`keyword` varchar(255) CHARACTER SET latin1 NOT NULL,
`ita` varchar(16) CHARACTER SET latin1 NOT NULL,
`ip` int(20) unsigned NOT NULL,
`res` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3593 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `session` (
`session_id` varbinary(32) NOT NULL,
`expires` int(32) NOT NULL,
`staff_id` tinyint(3) NOT NULL,
PRIMARY KEY (`session_id`),
KEY `staff_id` (`staff_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`added` int(10) unsigned NOT NULL,
`lastactive` int(10) unsigned NOT NULL,
`rights` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `username` (`username`,`password`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `filetypes` VALUES (1,'jpg','image/jpeg','',0,0),(2,'png','image/png','',0,0),(3,'gif','image/gif','',0,0),(4,'swf','application/x-shockwave-flash','mime/swf.png',1,0),(5,'webm','video/webm','',0,1),(6,'ogg','audio/ogg','',0,1),(7,'opus','audio/opus','',0,1),(8,'mod','audio/mod','mime/mod.png',0,0),(9,'xm','audio/xm','mime/xm.png',0,0),(10,'s3m','audio/s3m','mime/s3m.png',0,0),(11,'mp3','audio/mpeg','',0,1),(12,'torrent','application/x-bittorrent','mime/torrent.png',1,0),(13,'pdf','application/pdf','mime/pdf.png',1,0),(14,'epub','application/epub+zip','mime/epub.png',1,0);
