[Err] 1072 - Key column 'forumaccid' doesn't exist in table
[Err] CREATE TABLE `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL DEFAULT '',
`password` varchar(128) NOT NULL DEFAULT '',
`salt` varchar(32) DEFAULT NULL,
`pin` varchar(4) DEFAULT NULL,
`loggedin` tinyint(4) NOT NULL DEFAULT '0',
`lastlogin` timestamp NULL DEFAULT NULL,
`createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`birthday` date NOT NULL DEFAULT '0000-00-00',
`banned` tinyint(1) NOT NULL DEFAULT '0',
`tempban` int(10) unsigned NOT NULL DEFAULT '0',
`banreason` text,
`gm` tinyint(1) NOT NULL DEFAULT '0',
`email` tinytext,
`emailcode` varchar(40) DEFAULT NULL,
`lastpwemail` timestamp NOT NULL DEFAULT '2002-12-31 10:00:00',
`storageMesos` int(11) DEFAULT '0',
`storageSlots` int(11) DEFAULT '-1',
`lastIp` varchar(30) DEFAULT NULL,
`paypalNX` int(10) unsigned NOT NULL DEFAULT '0',
`mPoints` int(10) unsigned NOT NULL DEFAULT '0',
`cardNX` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `forumaccid` (`forumaccid`),
KEY `ranking1` (`id`,`banned`,`gm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Err] 1146 - Table 'delphims.accounts' doesn't exist
[Err] --
-- Dumping data for table `accounts`
--
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
[Err] 1146 - Table 'delphims.accounts' doesn't exist
[Err] /*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
[Err] 1067 - Invalid default value for 'expiredate'
[Err] CREATE TABLE `inventoryitems` (
`inventoryitemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext NOT NULL,
`petid` int(11) NOT NULL DEFAULT '-1',
`expiredate` timestamp DEFAULT NULL,
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `characterid_2` (`characterid`,`inventorytype`),
CONSTRAINT `inventoryitems_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Err] 1146 - Table 'delphims.inventoryitems' doesn't exist
[Err] --
-- Dumping data for table `inventoryitems`
--
/*!40000 ALTER TABLE `inventoryitems` DISABLE KEYS */;
[Err] 1146 - Table 'delphims.inventoryitems' doesn't exist
[Err] /*!40000 ALTER TABLE `inventoryitems` ENABLE KEYS */;
[Msg] Finished - Unsuccessfully
--------------------------------------------------