CREATE TABLE `ugyfel` ( `id` bigint(20) NOT NULL auto_increment, `email` varchar(100) NOT NULL default '', `kod` varchar(20) NOT NULL default '', `jelszo` varchar(20) NOT NULL default '', `reg_idopont` datetime NOT NULL default '0000-00-00 00:00:00', `megerositve` datetime NOT NULL default '0000-00-00 00:00:00', `uj_email` varchar(100) NOT NULL default '', `uj_kod` varchar(50) NOT NULL default '', PRIMARY KEY (`id`), KEY `email` (`email`), KEY `kod` (`kod`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;