From e36cce7903210153c6d02d0dca1be967d73c6561 Mon Sep 17 00:00:00 2001 From: Michael Foster Date: Sat, 21 Sep 2013 13:01:30 +1000 Subject: schema for ban appeals --- install.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'install.sql') diff --git a/install.sql b/install.sql index 462cd2f0..dcfce8f7 100644 --- a/install.sql +++ b/install.sql @@ -268,6 +268,22 @@ CREATE TABLE IF NOT EXISTS `flood` ( KEY `time` (`time`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin AUTO_INCREMENT=1 ; +-- -------------------------------------------------------- + +-- +-- Table structure for table `ban_appeals` +-- + +CREATE TABLE IF NOT EXISTS `ban_appeals` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `ban_id` int(10) unsigned NOT NULL, + `time` int(10) unsigned NOT NULL, + `message` text NOT NULL, + `denied` tinyint(1) NOT NULL, + PRIMARY KEY (`id`), + KEY `ban_id` (`ban_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; + /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -- cgit v1.3