#4235 Copy table causes SQL error

[J.M. Rütter]

In table operations, when copying a table to a different database, the operation fails with an SQL error for CREATE TABLE. This happens for some tables, not for all.

Sample structure for reproducing:

CREATE TABLE IF NOT EXISTS `emails` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(150) NOT NULL DEFAULT '',
  `validated` int(11) NOT NULL DEFAULT '0',
  `listID` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `letters` varchar(10) NOT NULL DEFAULT 'W',
  `ip` varchar(40) NOT NULL DEFAULT '',
  `confcode` varchar(32) NOT NULL DEFAULT '',
  `conf_ip` varchar(40) NOT NULL DEFAULT '',
  `conf_ts` bigint(20) NOT NULL DEFAULT '0',
  `partner` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=33743 ;

8cf74b688d882a9545a651498664de912c7fb659 is the first bad commit
commit 8cf74b688d882a9545a651498664de912c7fb659
Author: Viduranga Wijesooriya vpowerrc@gmail.com
Date: Sat Jan 11 02:27:40 2014 +0530

added #1004 Create indexes at the end in SQL export

Signed-off-by: Viduranga Wijesooriya <vpowerrc@gmail.com>

:040000 040000 1cb78160ad121cb0177c896df4cfc787c7ecc36d 33366ed9017c8811a8a31b06ed162be300cd3014 M libraries

[Viduranga Wijesooriya]

Hi,
Sorry for the bad commit. I fixed it. Please check https://github.com/phpmyadmin/phpmyadmin/pull/862
Inform me if something breaks again.
Thank you

[Marc Delisle]

Fixed with
https://github.com/phpmyadmin/phpmyadmin/commit/d5a3b01f77c5efbfbb8a8bb328dd9272ff7170c2

https://github.com/phpmyadmin/phpmyadmin/commit/eebcb9c531424d1d314e4d4064c0004688f851b7