Hello guys im new here nice to meet you all.
First of all i have installed my database and when i want to execute sql file (RMX-0S SQL DATABASE) i get error
[Err] 1005 - Can't create table 'rmxosdb.users' (errno: 150)
[Err] -- SQL Database for RMX-OS
-- by Blizzard
START TRANSACTION;
-- these two are used to create the database and can be ommited in case the database already exists
CREATE DATABASE IF NOT EXISTS `rmxosdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `rmxosdb`;
DROP TABLE IF EXISTS `save_data`;
DROP TABLE IF EXISTS `inbox`;
DROP TABLE IF EXISTS `buddy_list`;
DROP TABLE IF EXISTS `user_data`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `ips`;
DROP TABLE IF EXISTS `users`;
-- Registered Users
CREATE TABLE `users` (
`user_id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(32) NOT NULL UNIQUE,
`password` varchar(11) NOT NULL,
`usergroup` int(10) NOT NULL default 0,
`banned` tinyint(1) NOT NULL default 0,
PRIMARY KEY (`user_id`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- IPs
CREATE TABLE `ips` (
`user_id` int(10) unsigned NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`user_id`, `ip`),
FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- Guilds
CREATE TABLE `guilds` (
`guild_id` int(10) unsigned NOT NULL auto_increment,
`leader_id` int(10) unsigned NOT NULL UNIQUE,
`guildname` varchar(32) NOT NULL UNIQUE,
`password` varchar(11) NOT NULL,
PRIMARY KEY (`guild_id`),
FOREIGN KEY (`leader_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- Special User Data
CREATE TABLE `user_data` (
`user_id` int(10) unsigned NOT NULL,
`lastlogin` DATETIME NOT NULL,
`guild_id` int(10) unsigned default NULL,
PRIMARY KEY (`user_id`),
FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE,
FOREIGN KEY (`guild_id`) REFERENCES guilds(`guild_id`) ON DELETE SET NULL
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- Buddy List
CREATE TABLE `buddy_list` (
`user1_id` int(10) unsigned NOT NULL,
`user2_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`user1_id`, `user2_id`),
FOREIGN KEY (`user1_id`) REFERENCES users(`user_id`) ON DELETE CASCADE,
FOREIGN KEY (`user2_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- PM Inbox Data
CREATE TABLE `inbox` (
`pm_id` int(10) unsigned NOT NULL auto_increment,
`recipient_id` int(10) unsigned NOT NULL,
`sendername` varchar(32) NOT NULL,
`senddate` DATETIME NOT NULL,
`message` text NOT NULL,
`unread` tinyint(1) NOT NULL default 1,
PRIMARY KEY (`pm_id`),
FOREIGN KEY (`recipient_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- Saved Data
CREATE TABLE `save_data` (
`user_id` int(10) unsigned NOT NULL,
`data_name` varchar(255) NOT NULL,
`data_value` text NOT NULL,
PRIMARY KEY (`user_id`, `data_name`),
FOREIGN KEY (`user_id`) REFERENCES users(`user_id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
COMMIT;
[Msg] Finished - Unsuccessfully
--------------------------------------------------