MySQL problem - Doesn't have a default value
#5

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;
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 4 Guest(s)