08.08.2017, 14:09
I can't understand can you tell me what to do Here is the accounts.sql
pawn Код:
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`password` varchar(130) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`email` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`adminlevel` int(11) NOT NULL DEFAULT 0,
`lastlogin` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
`lastip` int(11) NOT NULL DEFAULT 0,
`newbrank` int(11) NOT NULL DEFAULT 0,
`ConnectTime` int(11) NOT NULL,
`admintitle` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
`donatepoints` int(11) NOT NULL DEFAULT 0,
`donaterank` int(11) NOT NULL DEFAULT 0,
`cookies` int(11) NOT NULL DEFAULT 0,
`ajailtime` int(11) NOT NULL DEFAULT 0,
`nmute` int(11) NOT NULL DEFAULT 0,
`chatmute` int(11) NOT NULL DEFAULT 0,
`reportban` int(11) NOT NULL DEFAULT 0,
`accountflags` int(11) NOT NULL DEFAULT 0,
`numkicks` int(11) NOT NULL,
`numbans` int(11) NOT NULL,
`numajails` int(11) NOT NULL,
`ahide` int(11) NOT NULL DEFAULT 0,
`securepass` int(11) DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `id`(`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10991 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;