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

#
# Table structure for table 'clans'
#

DROP TABLE IF EXISTS clans;
CREATE TABLE clans (
  auto_clan int(10) unsigned NOT NULL auto_increment,
  clan_acc varchar(6) NOT NULL default '',
  clan_id varchar(40) NOT NULL default '',
  clan_description varchar(100) NOT NULL default '',
  clan_author tinytext NOT NULL,
  clan_comment longtext,
  updated timestamp NOT NULL default CURRENT_TIMESTAMP,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (auto_clan),
  KEY clans_clan_acc_idx (clan_acc),
  KEY clans_clan_id_idx (clan_id),
  FULLTEXT KEY clans_text_idx (clan_description,clan_comment,clan_acc,clan_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
