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.
