[LetsOWN[PL]]

Quote:

Originally Posted by DarkLored I have been creating a filterscript and for some reason when I open the server it does not properly create the sql_sequence table and messes up my register system. pawn Код: LoadDatabase() {     new Query[800];     AdminSys = db_open("darkadmin.db");     strcat(Query, "CREATE TABLE IF NOT EXISTS users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(24) COLLATE NOCASE, password VARCHAR(129), admin INTEGER DEFAULT 0 NOT NULL,", sizeof(Query));     strcat(Query, "score INTEGER DEFAULT 0 NOT NULL, money INTEGER DEFAULT 1000 NOT NULL, banned INTEGER DEFAULT 0 NOT NULL, ip VARCHAR(16) NOT NULL )", sizeof(Query));     db_query(AdminSys, Query); } does anyone know why this is happening? help will be appreciated.

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 )

What could be the problem:

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.