/*
SQLyog Community Edition- MySQL GUI v6.55
MySQL - 5.0.51 : Database - db_radios
*********************************************************************
*/





/*Table structure for table `tbl_frequences` */


CREATE TABLE `tbl_frequences` (
  `Id_Frequence` int(4) unsigned NOT NULL auto_increment,
  `Ref_Id_Ville` int(4) unsigned NOT NULL default '0',
  `Ref_Id_Radio` int(4) unsigned NOT NULL default '0',
  `Frequence` float default '0',
  PRIMARY KEY  (`Id_Frequence`),
  UNIQUE KEY `VillesRadios` (`Ref_Id_Radio`,`Ref_Id_Ville`),
  UNIQUE KEY `VillesFrequences` (`Ref_Id_Ville`,`Frequence`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='La table des fr�quences';

/*Data for the table `tbl_frequences` */

insert  into `tbl_frequences`(`Id_Frequence`,`Ref_Id_Ville`,`Ref_Id_Radio`,`Frequence`) values (1,1,1,102);
insert  into `tbl_frequences`(`Id_Frequence`,`Ref_Id_Ville`,`Ref_Id_Radio`,`Frequence`) values (2,1,2,103);
insert  into `tbl_frequences`(`Id_Frequence`,`Ref_Id_Ville`,`Ref_Id_Radio`,`Frequence`) values (3,1,3,104);
insert  into `tbl_frequences`(`Id_Frequence`,`Ref_Id_Ville`,`Ref_Id_Radio`,`Frequence`) values (4,2,1,103);
insert  into `tbl_frequences`(`Id_Frequence`,`Ref_Id_Ville`,`Ref_Id_Radio`,`Frequence`) values (5,3,3,106);

/*Table structure for table `tbl_radios` */


CREATE TABLE `tbl_radios` (
  `Id_Radio` int(4) unsigned NOT NULL auto_increment,
  `Nom_Radio` varchar(31) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`Id_Radio`),
  UNIQUE KEY `Nom_Radio` (`Nom_Radio`),
  KEY `Nom_Radio_2` (`Nom_Radio`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='La table des radios';

/*Data for the table `tbl_radios` */

insert  into `tbl_radios`(`Id_Radio`,`Nom_Radio`) values (1,'FIP');
insert  into `tbl_radios`(`Id_Radio`,`Nom_Radio`) values (2,'FUN');
insert  into `tbl_radios`(`Id_Radio`,`Nom_Radio`) values (3,'NRJ');
insert  into `tbl_radios`(`Id_Radio`,`Nom_Radio`) values (4,'RMC');

/*Table structure for table `tbl_villes` */


CREATE TABLE `tbl_villes` (
  `Id_Ville` int(4) unsigned NOT NULL auto_increment,
  `Nom_Ville` varchar(31) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`Id_Ville`),
  UNIQUE KEY `Nom_Ville` (`Nom_Ville`),
  KEY `Nom_Ville_2` (`Nom_Ville`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='La table des villes';

/*Data for the table `tbl_villes` */

insert  into `tbl_villes`(`Id_Ville`,`Nom_Ville`) values (1,'Beurk en Brousse');
insert  into `tbl_villes`(`Id_Ville`,`Nom_Ville`) values (2,'Paris');
insert  into `tbl_villes`(`Id_Ville`,`Nom_Ville`) values (3,'Lyon');

