Por Androidserver, 10 de dez. de 2011 em Archived
info
Grupo: Campones
Registrado: 29/11/11
Posts: 2
Reputação: 0
Qnd vo importar o mysql.sql do schemas , da isso
Erro
consulta SQL:
CREATE TABLE `accounts` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 32 ) NOT NULL DEFAULT '',
`password` VARCHAR( 255 ) NOT NULL /* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
`premdays` INT NOT NULL DEFAULT 0,
`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
`email` VARCHAR( 255 ) NOT NULL DEFAULT '',
`key` VARCHAR( 20 ) NOT NULL DEFAULT '0',
`blocked` TINYINT( 1 ) NOT NULL DEFAULTFALSE COMMENT 'internal usage',
`warnings` INT NOT NULL DEFAULT 0,
`group_id` INT NOT NULL DEFAULT 1,
`vip_time` INT( 15 ) NOT NULL DEFAULT 0,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`name`)) ENGINE = InnoDB;
Mensagens do MySQL : #1005 - Can't create table 'draconia.accounts' (errno: 121)
Registrado: 18/10/11
Posts: 0
Char no Tibia: Las-San
qual versao do seu ot TFS? e gesior etc?
info
Grupo: Campones
Registrado: 29/11/11
Posts: 2
Reputação: 0
Qnd vo importar o mysql.sql do schemas , da isso
Erro
consulta SQL:
CREATE TABLE `accounts` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 32 ) NOT NULL DEFAULT '',
`password` VARCHAR( 255 ) NOT NULL /* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
`premdays` INT NOT NULL DEFAULT 0,
`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
`email` VARCHAR( 255 ) NOT NULL DEFAULT '',
`key` VARCHAR( 20 ) NOT NULL DEFAULT '0',
`blocked` TINYINT( 1 ) NOT NULL DEFAULTFALSE COMMENT 'internal usage',
`warnings` INT NOT NULL DEFAULT 0,
`group_id` INT NOT NULL DEFAULT 1,
`vip_time` INT( 15 ) NOT NULL DEFAULT 0,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`name`)) ENGINE = InnoDB;
Mensagens do MySQL :
#1005 - Can't create table 'draconia.accounts' (errno: 121)