by Kroneus on Sat Dec 23, 2017 4:41 pm
Hello Puprle,
everytime I put the prose sql file in my database (I am using navicat light), I am getting the following error message once I execute them. (The prose file is within the osIROSE-new-1.87.0 someone linked here before.)
[Err] 1451 - Cannot delete or update a parent row: a foreign key constraint fails
[Err] --
-- Gegevens worden uitgevoerd voor tabel `channels`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `characters`
--
DROP TABLE IF EXISTS `characters`;
[Err] 1050 - Table 'characters' already exists
[Err] CREATE TABLE `characters` (
`account_name` varchar(64) NOT NULL,
`id` int(11) NOT NULL auto_increment,
`char_name` varchar(64) NOT NULL,
`zuly` decimal(11,0) NOT NULL default '500',
`level` decimal(11,0) NOT NULL default '1',
`curHp` decimal(18,0) NOT NULL default '50',
`curMp` decimal(18,0) NOT NULL default '18',
`str` decimal(11,0) NOT NULL default '15',
`con` decimal(11,0) NOT NULL default '15',
`dex` decimal(11,0) NOT NULL default '15',
`_int` decimal(11,0) NOT NULL default '15',
`cha` decimal(11,0) NOT NULL default '10',
`sen` decimal(11,0) NOT NULL default '10',
`face` decimal(11,0) NOT NULL default '1',
`hairStyle` decimal(11,0) NOT NULL default '1',
`sex` decimal(11,0) NOT NULL default '0',
`exp` decimal(11,0) NOT NULL default '0',
`skillp` decimal(11,0) NOT NULL default '0',
`statp` decimal(11,0) NOT NULL default '0',
`clanid` decimal(11,0) NOT NULL default '0',
`unionid` decimal(11,0) NOT NULL default '0',
`union1points` int(11) NOT NULL default '0',
`union2points` int(11) NOT NULL default '0',
`union3points` int(11) NOT NULL default '0',
`union4points` int(11) NOT NULL default '0',
`union5points` int(11) NOT NULL default '0',
`union6points` int(11) NOT NULL default '0',
`union7points` int(11) NOT NULL default '0',
`union8points` int(11) NOT NULL default '0',
`union9points` int(11) NOT NULL default '0',
`union10points` int(11) NOT NULL default '0',
`classid` decimal(11,0) NOT NULL default '0',
`deletetime` decimal(20,0) NOT NULL default '0',
`clan_rank` int(11) NOT NULL default '0',
`stamina` int(11) NOT NULL default '5000',
`quests` blob,
`questflags` blob,
`quickbar` varchar(255) NOT NULL default '0',
`basic_skills` varchar(512) NOT NULL default '11,12,16,20,41,42,43,181,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
`askill` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
`askilllvl` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
`pskill` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
`pskilllvl` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
`respawnid` int(11) NOT NULL default '51',
`townid` int(11) NOT NULL default '20',
`class_skills` varchar(255) NOT NULL default '0',
`class_skills_level` varchar(255) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;