26 lines
939 B
SQL
26 lines
939 B
SQL
-- Adminer 4.2.0 MySQL dump
|
|
|
|
SET NAMES utf8mb4;
|
|
SET time_zone = '+00:00';
|
|
|
|
DROP TABLE IF EXISTS `ninechan`;
|
|
CREATE TABLE `ninechan` (
|
|
`id` int(16) unsigned NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) COLLATE utf8_bin NOT NULL,
|
|
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
|
`trip` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
|
`email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
|
`date` varchar(255) COLLATE utf8_bin NOT NULL,
|
|
`content` text COLLATE utf8_bin NOT NULL,
|
|
`password` varchar(255) COLLATE utf8_bin NOT NULL,
|
|
`ip` varchar(255) COLLATE utf8_bin NOT NULL,
|
|
`op` tinyint(1) unsigned NOT NULL DEFAULT '1',
|
|
`tid` int(16) unsigned NOT NULL DEFAULT '0',
|
|
`locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
|
`ban` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
|
`lastreply` int(11) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
|
|
|
-- 2015-05-12 19:19:23
|