mysql - PhpMyAdmin export : reference without uppercase -
first, i'm sorry poor english, i'm french.
i use phpmyadmin xampp in localhost , other phpmyadmin on server
my tables personne, adresse, titre.
when use export option server sql perfect :
create table if not exists `personne` ( `idpersonne` int(11) not null auto_increment, `email` varchar(255) collate utf8_unicode_ci default null, `gsm` varchar(255) collate utf8_unicode_ci default null, `nom` varchar(255) collate utf8_unicode_ci not null, `prenom` varchar(255) collate utf8_unicode_ci default null, `telephone` varchar(255) collate utf8_unicode_ci default null, `idadresse` int(11) default null, `idtitre` int(11) default null, primary key (`idpersonne`), unique key `uniquepersonne` (`nom`,`prenom`), key `idx_f6b8abb9d3e663e4` (`idadresse`), key `idx_f6b8abb9e8b304a9` (`idtitre`) ) engine=innodb default charset=utf8 collate=utf8_unicode_ci auto_increment=685 ; alter table `personne` add constraint `fk_f6b8abb9d3e663e4` foreign key (`idadresse`) references `adresse` (`idadresse`) on delete set null, add constraint `fk_f6b8abb9e8b304a9` foreign key (`idtitre`) references `titre` (`idtitre`) on delete set null;
by when use local export
create table if not exists `personne` ( `idpersonne` int(11) not null, `email` varchar(255) collate utf8_unicode_ci default null, `gsm` varchar(255) collate utf8_unicode_ci default null, `nom` varchar(255) collate utf8_unicode_ci not null, `prenom` varchar(255) collate utf8_unicode_ci default null, `telephone` varchar(255) collate utf8_unicode_ci default null, `idadresse` int(11) default null, `idtitre` int(11) default null ) engine=innodb auto_increment=685 default charset=utf8 collate=utf8_unicode_ci;
it's makes lines primary, unique, normal key , auto_increment :
alter table `personne` add primary key (`idpersonne`), add unique key `uniquepersonne` (`nom`,`prenom`), add key `idx_f6b8abb9d3e663e4` (`idadresse`), add key `idx_f6b8abb9e8b304a9` (`idtitre`); alter table `personne` modify `idpersonne` int(11) not null auto_increment,auto_increment=685;
and reference don't contain uppercase
alter table `personne` add constraint `fk_f6b8abb9d3e663e4` foreign key (`idadresse`) references `adresse` (`idadresse`) on delete set null, add constraint `fk_f6b8abb9e8b304a9` foreign key (`idtitre`) references `titre` (`idtitre`) on delete set null;
how have same result of server?
thank help
adjust lower_case_table_names setting mysql achieve goal. see how force case sensitive table names?
Comments
Post a Comment