При выполнении
Code: Select all
./ej-users --convert --from-plugin xml --to-plugin mysql
Code: Select all
mysql: CREATE TABLE logins (user_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, login VARCHAR(64) NOT NULL UNIQUE KEY COLLATE utf8_bin, email VARCHAR(128), pwdmethod TINYINT NOT NULL DEFAULT 0, password VARCHAR(128), privileged TINYINT NOT NULL DEFAULT 0, invisible TINYINT NOT NULL DEFAULT 0, banned TINYINT NOT NULL DEFAULT 0, locked TINYINT NOT NULL DEFAULT 0, readonly TINYINT NOT NULL DEFAULT 0, neverclean TINYINT NOT NULL DEFAULT 0, simplereg TINYINT NOT NULL DEFAULT 0, regtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, logintime TIMESTAMP DEFAULT 0, pwdtime TIMESTAMP DEFAULT 0, changetime TIMESTAMP DEFAULT 0 )
mysql: CREATE TABLE cookies (cookie VARCHAR(32) NOT NULL PRIMARY KEY, user_id INT NOT NULL, contest_id INT UNSIGNED NOT NULL, priv_level TINYINT NOT NULL DEFAULT 0, role_id TINYINT NOT NULL DEFAULT 0, ip_version TINYINT NOT NULL DEFAULT 4, locale_id TINYINT NOT NULL DEFAULT 0, recovery TINYINT NOT NULL DEFAULT 0, team_login TINYINT NOT NULL DEFAULT 0, ip VARCHAR(64) NOT NULL, ssl_flag TINYINT NOT NULL DEFAULT 0, expire DATETIME NOT NULL, FOREIGN KEY (user_id) REFERENCES logins (user_id) )
Sun Jun 5 22:56:18 2011:error:database error: Can't create table 'ejudge.cookies' (errno: 150)
Sun Jun 5 22:56:18 2011:error:plugin mysql failed to create a new database
Code: Select all
user_id INT NOT NULL
Code: Select all
user_id INT UNSIGNED NOT NULL
Arch Linux, MySQL 5.5.13, ejudge 2.3.18.