/*!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);
