# MySQL dump 8.16
#
# Host: pfam    Database: pfam_20_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) default NULL,
  clan_author tinytext,
  clan_comment longtext,
  updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  created datetime default NULL,
  PRIMARY KEY  (auto_clan),
  UNIQUE KEY clan_acc (clan_acc),
  UNIQUE KEY clan_id (clan_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
