wenn ich nicht vollkommen verblödet bin soll man folgendes einspeisen:
DROP TABLE IF EXISTS `houseconfig`; CREATE TABLE `houseconfig` ( `locid` int(10) unsigned NOT NULL auto_increment, `location` varchar(255) NOT NULL default 'village.php', `locname` varchar(50) NOT NULL default 'Wohnviertel', `buy` enum('0','1') NOT NULL default '0', `sell` enum('0','1') NOT NULL default '0', `build` enum('0','1') NOT NULL default '0', `rob` enum('0','1') NOT NULL default '0', `defaultgoldprice` int(10) unsigned NOT NULL default '30000', `defaultgemprice` int(10) unsigned NOT NULL default '50', `buildprice_increase` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`locid`) ) TYPE=MyISAM COMMENT='Konfiguration der Wohnanlagen - was ist erlaubt?';
CREATE TABLE `housemodules` ( `moduleid` int(10) unsigned NOT NULL auto_increment, `modulefile` varchar(50) NOT NULL default 'default.php', `modulename` varchar(50) NOT NULL default 'living_room', `moduleauthor` varchar(50) NOT NULL default '', `moduleversion` varchar(20) NOT NULL default '', `built_in` enum('0','1') NOT NULL default '1', `linkcategory` varchar(50) NOT NULL default 'Räume', `linktitle` varchar(50) NOT NULL default '', `linkorder` smallint(3) unsigned NOT NULL default '1', `showto` SET( 'owner', 'guest' ) DEFAULT 'owner,guest' NOT NULL, PRIMARY KEY (`moduleid`), UNIQUE `modulename` (`modulename`), KEY `built_in` (`built_in`), KEY `linkorder` (`linkorder`), KEY `showto` (`showto`) ) TYPE=MyISAM COMMENT='Module der Häuser'; CREATE TABLE `housemoduledata` ( `moduleid` int(10) unsigned NOT NULL, `name` varchar(50) NOT NULL default '', `houseid` int(10) unsigned NOT NULL default '0', `value` varchar(255) NULL, PRIMARY KEY (`moduleid`,`name`,`houseid`) ) TYPE=MyISAM COMMENT='Moduldaten für die Häuser'; DROP TABLE IF EXISTS `houses`; CREATE TABLE `houses` ( `houseid` int(10) unsigned NOT NULL auto_increment, `owner` int(10) unsigned NOT NULL default '0', `status` enum('build','sell','ready') NOT NULL default 'build', `goldprice` int(10) unsigned NOT NULL default '30000', `gemprice` int(10) unsigned NOT NULL default '50', `housename` varchar(25) default NULL, `description` text NOT NULL default '', `locid` int(10) UNSIGNED NOT NULL default '1', PRIMARY KEY (`houseid`), KEY `locid` (`locid`), KEY `owner` (`owner`) ) TYPE=MyISAM; INSERT INTO `settings` VALUES ('startbuild','0'), ('mindkbuild','1'), ('minlevelbuild','5'), ('defaulthousemodule','1');
Fehler
SQL-Befehl:
CREATE TABLE `housemodules` ( `moduleid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `modulefile` varchar( 50 ) NOT NULL default 'default.php', `modulename` varchar( 50 ) NOT NULL default 'living_room', `moduleauthor` varchar( 50 ) NOT NULL default '', `moduleversion` varchar( 20 ) NOT NULL default '', `built_in` enum( '0', '1' ) NOT NULL default '1', `linkcategory` varchar( 50 ) NOT NULL default 'R䵭e', `l inktitle ` varchar( 50 ) NOT NULL default '', `l inkorder ` smallint( 3 ) unsigned NOT NULL default '1 ', `s howto ` SET( 'owner ', 'guest ' ) DEFAULT 'owner, guest ' NOT NULL , PRIMARY KEY ( `m oduleid `) , UNIQUE `m odulename ` ( `m odulename `) , KEY `b uilt_in ` ( `b uilt_in `) , KEY `l inkorder ` ( `l inkorder `) , KEY `s howto ` ( `s howto `) ) TYPE = MYISAM COMMENT = 'Module der H䵳er ';
MySQL meldet: #1067 - Invalid default value for 'linkcategory'
evt kann mir jemand auch genau die sql-befehle die ausgeführt werden sollen in einer txt schicken. mfg
|