/*!40101 SET NAMES utf8 */;
/*!40103 set @old_time_zone=@@time_zone */;
/*!40103 set time_zone='+00:00' */;
/*!40014 set @old_unique_checks=@@unique_checks, unique_checks=0 */;
/*!40014 set @old_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=0 */;
/*!40101 set @old_sql_mode=@@sql_mode, sql_mode='no_auto_value_on_zero' */;
/*!40111 set @old_sql_notes=@@sql_notes, sql_notes=0 */;

--
-- Table structure for table `T_COMPOSITEUR_CMP`
--

Drop table if exists `t_compositeur_cmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
Create table `t_compositeur_cmp` (
  `CMP_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `CMP_DECE` smallint(6) DEFAULT NULL,
  `CMP_NAISSANCE` smallint(6) DEFAULT NULL,
  `CMP_NOM` varchar(50) DEFAULT NULL,
  `CMP_PRENOM` varchar(50) DEFAULT NULL,
  primary key (`cmp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `T_COMPOSITEUR_CMP`
--

Lock tables `t_compositeur_cmp` write;
/*!40000 alter table `t_compositeur_cmp` disable keys */;
INSERT INTO `T_COMPOSITEUR_CMP` VALUES (1,1750,1685,'Bach','Johann Sebastian'),(2,1827,1770,'Beethoven','Ludwig van'),(3,1935,1885,'Berg','Alban'),(4,1976,1913,'Britten','Benjamin'),(5,1896,1824,'Bruckner','Anton'),(6,1713,1653,'Corelli','Arcangelo'),(7,1894,1841,'Chabrier','Emmanuel'),(8,1849,1810,'Chopin','Frédéric'),(9,1990,1900,'Copland','Aaron'),(10,1661,1626,'Couperin','Louis'),(11,1904,1841,'Dvorak','Anton'),(12,1937,1898,'Gershwin','George'),(13,1918,1862,'Debussy','Claude'),(14,1759,1685,'Handel','George Frideric'),(15,1911,1860,'Mahler','Gustav'),(16,1953,1891,'Prokofiev','Serge'),(17,1943,1873,'Rachmaninov','Serge'),(18,1764,1683,'Rameau','Jean-Philippe'),(19,1847,1809,'Mendelssohn','Felix'),(20,1791,1756,'Mozart','Wolgang Amadeus'),(21,1963,1899,'Poulenc','Francis'),(22,1937,1875,'Ravel','Maurice'),(23,1910,1873,'Reger','Max'),(24,1868,1792,'Rossini','Gioachino'),(25,1828,1797,'Schubert','Franz'),(26,1856,1810,'Schumann','Robert'),(27,1915,1872,'Scriabine','Alexandre'),(28,0,0,'Haydn',''),(29,1893,1840,'Tchaîkovski','Piotr Ilytch'),(30,1901,1813,'Verdi','Giuseppe'),(31,1741,1678,'Vivaldi','Antonio'),(32,1782,1735,'Bach','Johann Christian'),(33,1788,1714,'Bach','Carl Philipp Emanuel'),(34,1784,1710,'Bach','Wilhelm Friedemann'),(64,NULL,NULL,'Fauré','Gabriel'),(65,NULL,NULL,'Bowie','David'),(66,NULL,NULL,'Champfort','Alain'),(67,NULL,NULL,'Chevalier','Maurice');
/*!40000 alter table `t_compositeur_cmp` enable keys */;
Unlock tables;
/*!40103 set time_zone=@old_time_zone */;

/*!40101 set sql_mode=@old_sql_mode */;
/*!40014 set foreign_key_checks=@old_foreign_key_checks */;
/*!40014 set unique_checks=@old_unique_checks */;
/*!40101 set character_set_client=@old_character_set_client */;
/*!40101 set character_set_results=@old_character_set_results */;
/*!40101 set collation_connection=@old_collation_connection */;
/*!40111 set sql_notes=@old_sql_notes */;

-- Dump completed on 2017-10-18 10:28:30