View Single Post
  #4  
Old 06-30-2015, 04:45 PM
Mortykins's Avatar
Mortykins
Hill Giant
 
Join Date: Apr 2014
Posts: 156
Default

Here is the schema for that table, is this correct?

Code:
CREATE TABLE IF NOT EXISTS `start_zones` (
  `x` float NOT NULL DEFAULT '0',
  `y` float NOT NULL DEFAULT '0',
  `z` float NOT NULL DEFAULT '0',
  `zone_id` int(4) NOT NULL DEFAULT '0',
  `bind_id` int(4) NOT NULL DEFAULT '0',
  `player_choice` int(2) NOT NULL DEFAULT '0',
  `player_class` int(2) NOT NULL DEFAULT '0',
  `player_deity` int(4) NOT NULL DEFAULT '0',
  `player_race` int(4) NOT NULL DEFAULT '0',
  `start_zone` int(4) NOT NULL DEFAULT '0',
  `bind_x` float NOT NULL DEFAULT '0',
  `bind_y` float NOT NULL DEFAULT '0',
  `bind_z` float NOT NULL DEFAULT '0',
  `select_rank` tinyint(3) unsigned NOT NULL DEFAULT '50',
  PRIMARY KEY (`player_choice`,`player_race`,`player_class`,`player_deity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Reply With Quote