posts schema

gistfile1.sql

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = 'SYSTEM';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

CREATE TABLE `posts` (
  `uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `chan` varchar(10) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `board` varchar(10) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `thread_id` bigint(20) unsigned NOT NULL,
  `id` bigint(20) unsigned NOT NULL,
  `nick` varchar(200) NOT NULL DEFAULT '',
  `trip` varchar(30) NOT NULL DEFAULT '',
  `capcode` varchar(30) NOT NULL,
  `mail` varchar(200) NOT NULL DEFAULT '',
  `poster_id` varchar(100) NOT NULL,
  `has_priv` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(200) NOT NULL DEFAULT '',
  `text` longtext NOT NULL,
  `tldr` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `img_md5` varchar(254) NOT NULL DEFAULT '',
  `img_width` int(11) unsigned NOT NULL DEFAULT '0',
  `img_height` int(11) unsigned NOT NULL DEFAULT '0',
  `img_size` int(11) unsigned NOT NULL DEFAULT '0',
  `img_spoiler` tinyint(1) unsigned NOT NULL,
  `img_name` varchar(254) NOT NULL,
  `added` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `meta` text NOT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `chan` (`chan`,`board`,`thread_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;