25.08.2015, 17:44
Quote:
Hello, try with this query:
Код:
CREATE TABLE IF NOT EXISTS users (userid INTEGER PRIMARY KEY AUTO_INCREMENT, username VARCHAR(24), password VARCHAR(129), admin INTEGER DEFAULT 0 NOT NULL, score INTEGER DEFAULT 0 NOT NULL, money INTEGER DEFAULT 1000 NOT NULL, banned INTEGER DEFAULT 0 NOT NULL, ip VARCHAR(16) NOT NULL ) 1) You've forgotten about underscore in AUTO_INCREMENT 2) 'NOCASE' was unknown collate I've tried to run this query in my own MySQL server and it ran well. Any other questions? Greetings. |