VentriloCP mysql problem.

[lukrut 0]

Witam.

 

Mam problem z wykonaniem bazy sql w phpmyadmin.

 

DROP TABLE IF EXISTS servers;
CREATE TABLE servers (
id	  INT AUTO_INCREMENT,
vdomain VARCHAR (127) NOT NULL,
vip	 VARCHAR (15) NOT NULL,
vport   INT NOT NULL,
faddr   VARCHAR (127) NOT NULL,
fport   INT NOT NULL,
fuser   VARCHAR (127) NOT NULL,
fpass   VARCHAR (127),
fpath   VARCHAR (255),
 sip	 VARCHAR (127),
 sport   INT,
 spass   VARCHAR (127)
PRIMARY KEY (id)
);

DROP TABLE IF EXISTS users;
CREATE TABLE users (
id	 INT AUTO_INCREMENT,
fname  VARCHAR (127) NOT NULL,
lname  VARCHAR (127) NOT NULL,
email  VARCHAR (127) UNIQUE NOT NULL,
pass   CHAR (16) BINARY NOT NULL,
rights ENUM ('admin', 'tech', 'user') NOT NULL DEFAULT 'user',
serverid INT,
PRIMARY KEY (id)
);

INSERT INTO users (fname, lname, email, pass, rights, serverid)
VALUES ('Admin', 'Administator', 'admin', ENCODE('a', 'crypt_key'), 'admin', NULL);

--INSERT INTO users (fname, lname, email, pass, rights, serverid)
--VALUES ('Admin', 'Administator', 'admin', DES_ENCRYPT('a', 'crypt_key'), 'admin', NULL);

--INSERT INTO users (fname, lname, email, pass, rights, serverid)
--VALUES ('Admin', 'Administator', 'admin', AES_ENCRYPT('a', 'crypt_key'), 'admin', NULL);

INSERT INTO servers (vdomain, vip, vport, faddr, fport, fuser, fpass, fpath)
VALUES ('zaonce.internal', '10.0.0.2', 2222, '10.0.0.2', 21, 'ventrilo', '123', '');

INSERT INTO servers (vdomain, vip, vport, faddr, fport, fuser, fpass, fpath)
VALUES ('test.vtalk.net', '69.56.219.157', 3780, '69.56.219.157', 21, 'wwwsecur', 'vtalknet', '');

INSERT INTO users (fname, lname, email, pass, rights, serverid)
VALUES ('Nikita', 'LocalUser', 'local', 'l', 'user', 1);

INSERT INTO users (fname, lname, email, pass, rights, serverid)
VALUES ('Nikita', 'RemoteUser', 'remote', 'r', 'user', 2);

INSERT INTO users (fname, lname, email, pass, rights, serverid)
VALUES ('Nikita', 'TechUser', 'tech', 't', 'tech', NULL);

INSERT INTO users (fname, lname, email, pass, rights, serverid)
VALUES ('Nikita', 'AdminUser', 'admin', 'a', 'admin', NULL);

 

Informacja zwrotna:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id)
)' at line 14 

 

Z góry dziękuje za pomoc, prozdrawiam.

 

P.S. Panel instaluje na własne potrzeby.

[Gość Kamikadze]

Po

 

  spass   VARCHAR (127)

 

 

Nie musi być przecinka?

[lukrut 0]

Teraz pojawia się nowy problem

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--INSERT INTO users (fname, lname, email, pass, rights, serverid)
--VALUES ('Ad' at line 1 

[Misiek08 285]

Wrzuć w 1 linię te wszystkie inserty. Możliwe, że nowa linia jest tworzona znakiem, który przez PMA jest kodowany i potem MySQL dostaje krzak od Ciebie.