CREATE TABLE `onebbs` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `comment` varchar(191) NOT NULL,
  `date` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `setting` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `main_title` varchar(191) NOT NULL DEFAULT '一行掲示板',
  `main_file` varchar(191) NOT NULL DEFAULT 'index',
  `log_title` varchar(191) NOT NULL DEFAULT '過去ログ',
  `log_file` varchar(191) NOT NULL DEFAULT 'log',
  `line_limit` tinyint UNSIGNED NOT NULL DEFAULT '20',
  `max_page` tinyint UNSIGNED NOT NULL DEFAULT '10',
  `name_limit` tinyint UNSIGNED NOT NULL DEFAULT '20',
  `comment_limit` tinyint UNSIGNED NOT NULL DEFAULT '100',
  `sepa` varchar(191) NOT NULL DEFAULT ' // ',
  `time_line` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `color_0` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '#ff00ff',
  `color_1` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '#008000',
  `color_2` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '#a52a2a',
  `color_3` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '#000000',
  `color_4` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '#808080',
  `captcha` tinyint UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `setting` () VALUES ();
