Hi everybody,
I have a problem with the execution of a SQL Query, phpMyAdmin gives me the following error:
#1005 - Can't create table './bot/BOTS.frm' (errno: 121)
here is the SQL Query:
CREATE TABLE IF NOT EXISTS BOTS (
BOT_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
BRA_ID tinyint(3) unsigned NOT NULL,
BOT_NAME varchar(30) NOT NULL DEFAULT '',
BOT_ALIAS varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (BOT_ID),
KEY BRA_ID (BRA_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
CREATE TABLE IF NOT EXISTS BOTS_VALUES (
BOT_ID tinyint(3) unsigned NOT NULL,
VAL_NAME varchar(50) NOT NULL,
VAL_VALUE text NOT NULL,
PRIMARY KEY (BOT_ID,VAL_NAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS BRAINS (
BRA_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
BRA_NAME varchar(30) NOT NULL DEFAULT '',
BRA_CREDENTIALS varchar(100) NOT NULL,
PRIMARY KEY (BRA_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
CREATE TABLE IF NOT EXISTS CATEGORIES (
CAT_ID int(10) unsigned NOT NULL AUTO_INCREMENT,
BRA_ID tinyint(3) unsigned NOT NULL,
CAT_WEIGHT smallint(5) unsigned NOT NULL,
CAT_PATTERN text NOT NULL,
CAT_THAT text NOT NULL,
CAT_TOPIC text NOT NULL,
CAT_REGEXP text NOT NULL,
CAT_STARS text NOT NULL,
CAT_TEMPLATE text NOT NULL,
CAT_PREPARED text NOT NULL,
PRIMARY KEY (CAT_ID),
KEY BRA_ID (BRA_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;
CREATE TABLE IF NOT EXISTS CATEGORIES_PARENTS (
CAT_ID int(10) unsigned NOT NULL,
CAT_PARENT_ID int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (CAT_ID,CAT_PARENT_ID),
KEY CAT_PARENT_ID (CAT_PARENT_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS CATEGORIES_STARTERS (
BRA_ID tinyint(3) unsigned NOT NULL,
CAT_STARTER varchar(200) NOT NULL,
CAT_ID int(10) unsigned NOT NULL,
PRIMARY KEY (BRA_ID,CAT_STARTER,CAT_ID),
KEY CAT_ID (CAT_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS USERS (
USR_ID int(10) unsigned NOT NULL AUTO_INCREMENT,
USR_SESSION varchar(255) NOT NULL,
PRIMARY KEY (USR_ID),
UNIQUE KEY USR_SESSION (USR_SESSION)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=322 ;
CREATE TABLE IF NOT EXISTS USERS_LOGS (
USR_ID int(10) unsigned NOT NULL,
BOT_ID smallint(5) unsigned NOT NULL,
LOG_TYPE enum('input','that') NOT NULL,
LOG_DATE datetime NOT NULL,
LOG_ENTRY text NOT NULL,
KEY BOT_ID (BOT_ID),
KEY USR_ID (USR_ID,BOT_ID,LOG_DATE)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS USERS_VALUES (
USR_ID int(10) unsigned NOT NULL,
BOT_ID smallint(5) unsigned NOT NULL,
VAL_NAME varchar(50) NOT NULL,
VAL_VALUE text NOT NULL,
PRIMARY KEY (USR_ID,BOT_ID,VAL_NAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE BOTS
ADD CONSTRAINT BOTS_ibfk_1 FOREIGN KEY (BRA_ID) REFERENCES BRAINS (BRA_ID);
ALTER TABLE BOTS_VALUES
ADD CONSTRAINT BOTS_VALUES_ibfk_1 FOREIGN KEY (BOT_ID) REFERENCES BOTS (BOT_ID) ON DELETE CASCADE;
ALTER TABLE CATEGORIES
ADD CONSTRAINT CATEGORIES_ibfk_1 FOREIGN KEY (BRA_ID) REFERENCES BRAINS (BRA_ID);
ALTER TABLE CATEGORIES_PARENTS
ADD CONSTRAINT CATEGORIES_PARENTS_ibfk_1 FOREIGN KEY (CAT_ID) REFERENCES CATEGORIES (CAT_ID) ON DELETE CASCADE,
ADD CONSTRAINT CATEGORIES_PARENTS_ibfk_2 FOREIGN KEY (CAT_PARENT_ID) REFERENCES CATEGORIES (CAT_ID) ON DELETE CASCADE;
ALTER TABLE CATEGORIES_STARTERS
ADD CONSTRAINT CATEGORIES_STARTERS_ibfk_1 FOREIGN KEY (CAT_ID) REFERENCES CATEGORIES (CAT_ID) ON DELETE CASCADE,
ADD CONSTRAINT CATEGORIES_STARTERS_ibfk_2 FOREIGN KEY (BRA_ID) REFERENCES BRAINS (BRA_ID);
ALTER TABLE USERS_LOGS
ADD CONSTRAINT USERS_LOGS_ibfk_1 FOREIGN KEY (USR_ID) REFERENCES USERS (USR_ID);
ALTER TABLE USERS_VALUES
ADD CONSTRAINT USERS_VALUES_ibfk_1 FOREIGN KEY (USR_ID) REFERENCES USERS (USR_ID);
Thanks in advance.
Best regards.
