D7mFNCNj

1CREATE DATABASE IF NOT EXISTS MoopleDEV;
2USE MoopleDEV;
3DROP TABLE IF EXISTS `accounts`;
4
5CREATE TABLE `accounts` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `name` varchar(13) NOT NULL DEFAULT '',
8  `password` varchar(128) NOT NULL DEFAULT '',
9  `salt` varchar(128) DEFAULT NULL,
10  `pin` varchar(10) DEFAULT NULL,
11  `pic` varchar(26) DEFAULT NULL,
12  `loggedin` tinyint(4) NOT NULL DEFAULT '0',
13  `lastlogin` timestamp NULL DEFAULT NULL,
14  `createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
15  `birthday` date NOT NULL DEFAULT '0000-00-00',
16  `banned` tinyint(1) NOT NULL DEFAULT '0',
17  `banreason` text,
18  `gm` tinyint(1) NOT NULL DEFAULT '0',
19  `macs` tinytext,
20  `nxCredit` int(11) DEFAULT NULL,
21  `maplePoint` int(11) DEFAULT NULL,
22  `nxPrepaid` int(11) DEFAULT NULL,
23  `characterslots` tinyint(2) NOT NULL DEFAULT '5',
24  `gender` tinyint(2) NOT NULL DEFAULT '10',
25  `tempban` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
26  `greason` tinyint(4) NOT NULL DEFAULT '0',
27  `tos` tinyint(1) NOT NULL DEFAULT '0',
28  PRIMARY KEY (`id`),
29  UNIQUE KEY `name` (`name`),
30  KEY `ranking1` (`id`,`banned`,`gm`)
31) ENGINE=InnoDB DEFAULT CHARSET=latin1;