diff options
Diffstat (limited to 'weabot.sql')
| -rw-r--r-- | weabot.sql | 268 |
1 files changed, 268 insertions, 0 deletions
diff --git a/weabot.sql b/weabot.sql new file mode 100644 index 0000000..e91a8f2 --- /dev/null +++ b/weabot.sql @@ -0,0 +1,268 @@ +/*!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); |