Need clarification on DB items

[Lurker_005]

ok a simple attempt to comment the mysql table definitions for spawns.

I trimed out the table fields not relarted to tieing the tables together.

#
# Table structure for table 'npc_types'
#

CREATE TABLE npc_types (  # key is the ID, Table defines mob to be spawned
  id int(11) NOT NULL auto_increment,
  name text NOT NULL,
#sniped
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Table structure for table 'spawn2'
#

CREATE TABLE spawn2 (  # defines where and how the spawngroup spawns
  id int(11) NOT NULL auto_increment,
  spawngroupID int(11) NOT NULL default '0',
#sniped
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Table structure for table 'spawnentry'
#

CREATE TABLE spawnentry (  # lists the npc_types that can spawn in a given spawn group
  spawngroupID int(11) NOT NULL default '0',
  npcID int(11) NOT NULL default '0',  # npc_tpe ID
#sniped
  PRIMARY KEY  (spawngroupID,npcID)
) TYPE=MyISAM;



#
# Table structure for table 'spawngroup'
#

CREATE TABLE spawngroup (  # named entry used to tie spawn2 and spawnenrty together
  id int(11) NOT NULL auto_increment,  # ID (spawngroupID)
  name varchar(30) NOT NULL default '',  # user given name neams nothing
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;