CREATE TABLE IF NOT EXISTS `customers` (
  `kunden_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `vorname` varchar(100) NOT NULL DEFAULT '',
  `nachname` varchar(100) NOT NULL DEFAULT '',
  `firma` varchar(100) NOT NULL DEFAULT '',
  `strasse` varchar(100) NOT NULL DEFAULT '',
  `plz` varchar(10) NOT NULL DEFAULT '',
  `ort` varchar(100) NOT NULL DEFAULT '',
  `land` varchar(40) NOT NULL DEFAULT '',
  `tel` varchar(70) NOT NULL DEFAULT '',
  `fax` varchar(70) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `burner_username` varchar(100) DEFAULT NULL,
  `username` varchar(100) NOT NULL DEFAULT '',
  `passwort` varchar(50) NOT NULL DEFAULT '',
  `timestamp` datetime DEFAULT NULL,
  `uid` varchar(20) NOT NULL DEFAULT '',
  `newsletter` int(1) NOT NULL DEFAULT '1',
  `kundenausweis_erhalten` datetime DEFAULT NULL,
  `gesperrt` int(1) NOT NULL DEFAULT '0',
  `hold_kunde` int(1) NOT NULL DEFAULT '0',
  `KK_proofed_kunde` int(1) NOT NULL DEFAULT '0',
  `darf_nachnahme` int(1) NOT NULL DEFAULT '0',
  `mandant` varchar(15) NOT NULL DEFAULT '',
  `kunden_bemerkung` text NOT NULL,
  `many_cards_allowed` int(1) NOT NULL DEFAULT '0',
  `immer_versandkostenfrei` int(1) NOT NULL DEFAULT '0',
  `geb_datum` datetime DEFAULT NULL,
  `apid` varchar(255) DEFAULT NULL,
  `wishlist_public` int(1) NOT NULL DEFAULT '0',
  `not_used` int(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `username` (`username`,`mandant`),
  KEY `mandant` (`mandant`),
  KEY `username_2` (`username`),
  KEY `passwort` (`passwort`),
  KEY `email` (`email`),
  KEY `timestamp` (`timestamp`),
  KEY `land` (`land`),
  KEY `kunden_id` (`kunden_id`,`username`,`passwort`),
  KEY `burner_username` (`burner_username`),
  KEY `hold_kunde` (`hold_kunde`),
  KEY `apid` (`apid`),
  KEY `newsletter` (`newsletter`),
  KEY `newsletter_2` (`newsletter`,`mandant`),
  FULLTEXT KEY `vorname` (`vorname`,`nachname`,`ort`,`username`,`email`,`firma`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

INSERT INTO `customers` (`kunden_id`, `vorname`, `nachname`, `firma`, `strasse`, `plz`, `ort`, `land`, `tel`, `fax`, `email`, `burner_username`, `username`, `passwort`, `timestamp`, `uid`, `newsletter`, `kundenausweis_erhalten`, `gesperrt`, `hold_kunde`, `KK_proofed_kunde`, `darf_nachnahme`, `mandant`, `kunden_bemerkung`, `many_cards_allowed`, `immer_versandkostenfrei`, `geb_datum`, `apid`, `wishlist_public`, `not_used`) VALUES
(9588, 'firstname', 'sirname', 'Firma', 'chernostreet 3', '58878', 'stae', 'slovakia', '123456789', '', '2012-10-09 02:01:03', 'dodl47', 'zabby', 'a8b1377d0edaece4c15136dfed447', '2007-02-08 14:17:10', '', 1, NULL, 0, 0, 0, 0, 'highest', '', 0, 0, NULL, 'c009-4096-b15e-b955457383f2', 1, 0);

repair table customers;

flush tables;

--let $MYSQLD_DATADIR=`SELECT @@datadir`
--exec $MYISAMCHK -rev $MYSQLD_DATADIR/test/customers.MYI

update customers set email='randomstring' where kunden_id = 9588;