090324 追記 DBのSQL文

中身進んでないのに…って感じですけど、DBのテーブル作るSQL文を追加で載せておきます。

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";




CREATE TABLE IF NOT EXISTS `item` (
  `dbitemid` bigint(20) NOT NULL AUTO_INCREMENT,
  `dbitemname` text COLLATE utf8_unicode_ci NOT NULL,
  `dbitemkind` tinyint(4) NOT NULL,
  `dbitemlevel` tinyint(4) NOT NULL,
  `dbitemlimit` tinyint(4) NOT NULL,
  PRIMARY KEY (`dbitemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `monster` (
  `dbmonsterid` bigint(20) NOT NULL AUTO_INCREMENT,
  `dbmonstername` text COLLATE utf8_unicode_ci NOT NULL,
  `dbmonsterlevel` tinyint(4) NOT NULL,
  `dbmonstermoney` tinyint(4) NOT NULL,
  `dbmonsteratk` tinyint(4) NOT NULL,
  `dbmonsterdef` tinyint(4) NOT NULL,
  `dbmonsterstr` tinyint(4) NOT NULL,
  PRIMARY KEY (`dbmonsterid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `player` (
  `dbid` bigint(20) NOT NULL AUTO_INCREMENT,
  `dbname` text COLLATE utf8_unicode_ci NOT NULL,
  `dblevel` tinyint(4) NOT NULL,
  `dbmoney` bigint(4) NOT NULL,
  `dbattack` tinyint(4) NOT NULL,
  `dbdefence` tinyint(4) NOT NULL,
  `dbstrength` tinyint(4) NOT NULL,
  `dbluk` tinyint(4) NOT NULL,
  PRIMARY KEY (`dbid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `tower` (
  `dbmapid` bigint(20) NOT NULL AUTO_INCREMENT,
  `dbmapdata` text COLLATE utf8_unicode_ci NOT NULL,
  `dbmaplinku` bigint(20) DEFAULT NULL,
  `dbmaplinkd` bigint(20) DEFAULT NULL,
  `dbmaplinkf` bigint(20) DEFAULT NULL,
  `dbmaplinkb` bigint(20) DEFAULT NULL,
  `dbmaplinkl` bigint(20) DEFAULT NULL,
  `dbmaplinkr` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`dbmapid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;