DROP TABLE IF EXISTS `mx82695_team`;
CREATE TABLE `mx82695_team` (
  `tid` int(11) NOT NULL auto_increment,
  `nname` varchar(255) collate latin1_general_ci NOT NULL default '',
  `vname` varchar(255) collate latin1_general_ci NOT NULL default '',
  `bild_klein` text collate latin1_general_ci NOT NULL,
  `bild_gross` text collate latin1_general_ci NOT NULL,
  `stellung` varchar(255) collate latin1_general_ci NOT NULL default '',
  `time` varchar(255) collate latin1_general_ci NOT NULL default '',
  `long` varchar(255) collate latin1_general_ci NOT NULL default '',
  `gtraenk` varchar(255) collate latin1_general_ci NOT NULL default '',
  `speise` varchar(255) collate latin1_general_ci NOT NULL default '',
  `duft` varchar(255) collate latin1_general_ci NOT NULL default '',
  `hobby` varchar(255) collate latin1_general_ci NOT NULL default '',
  `insel` varchar(255) collate latin1_general_ci NOT NULL default '',
  `bbrother` varchar(255) collate latin1_general_ci NOT NULL default '',
  `location` varchar(255) collate latin1_general_ci NOT NULL default '',
  `laster` varchar(255) collate latin1_general_ci NOT NULL default '',
  `hot` varchar(255) collate latin1_general_ci NOT NULL default '',
  `flop` varchar(255) collate latin1_general_ci NOT NULL default '',
  `spruch` varchar(255) collate latin1_general_ci NOT NULL default '',
  `email` varchar(255) collate latin1_general_ci NOT NULL default '',
  `beschr_kurz` text collate latin1_general_ci NOT NULL,
  `beschr_lang` text collate latin1_general_ci NOT NULL,
  `pos` int(11) NOT NULL default '0',
  `anzeigen` int(11) NOT NULL default '0',
  `url1` varchar(255) collate latin1_general_ci NOT NULL default '',
  `url2` varchar(255) collate latin1_general_ci NOT NULL default '',
  `bday` varchar(255) collate latin1_general_ci NOT NULL default '',
  `gid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  UNIQUE KEY `pos` (`pos`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
