# MySQL dump 8.16
#
# Host: pfam    Database: pfam_21_0
#--------------------------------------------------------
# Server version	4.1.10-standard

#
# Table structure for table 'dead_clans'
#

DROP TABLE IF EXISTS dead_clans;
CREATE TABLE dead_clans (
  clan_acc varchar(7) NOT NULL default '',
  clan_description varchar(100) NOT NULL default '',
  clan_membership longtext NOT NULL,
  `comment` mediumtext NOT NULL,
  forward_to varchar(6) default '',
  `user` tinytext NOT NULL,
  killed timestamp NOT NULL default CURRENT_TIMESTAMP,
  KEY dead_clans_forward_idx (forward_to),
  KEY dead_clans_clan_acc_idx (clan_acc),
  FULLTEXT KEY dead_clans_text_idx (clan_acc,clan_description,clan_membership,`comment`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
