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

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -