landsandboat/sql/accounts_banned.sql

19 lines
715 B
SQL

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Structure de la table `accounts_banned`
--
DROP TABLE IF EXISTS `accounts_banned`;
CREATE TABLE IF NOT EXISTS `accounts_banned` (
`accid` int(10) unsigned NOT NULL DEFAULT '0',
`timebann` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`timeunbann` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`banncomment` varchar(512) DEFAULT NULL,
PRIMARY KEY (`accid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;