· 7 years ago · Jan 08, 2019, 02:00 PM
1CREATE TABLE IF NOT EXISTS `accounts` (
2`id` int(11) NOT NULL,
3 `login` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
4 `password` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
5 `registered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6 `serial` text NOT NULL,
7 `email` text NOT NULL,
8 `warns` int(1) NOT NULL DEFAULT '0',
9 `money` int(11) NOT NULL DEFAULT '0',
10 `bank_money` int(25) NOT NULL DEFAULT '0',
11 `job_stats` text CHARACTER SET utf8 COLLATE utf8_polish_ci,
12 `job_upgrades` text,
13 `skin` int(11) NOT NULL DEFAULT '0',
14 `reputation` int(11) NOT NULL DEFAULT '0',
15 `dA` int(11) NOT NULL DEFAULT '0',
16 `dB` int(11) NOT NULL DEFAULT '0',
17 `dC` int(11) NOT NULL DEFAULT '0',
18 `playtime` int(12) NOT NULL DEFAULT '0',
19 `premium_date` date NOT NULL DEFAULT '0000-01-01'
20) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COMMENT='Neveron';