-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2+deb7u4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 22, 2017 at 10:38 AM
-- Server version: 5.5.49
-- PHP Version: 5.4.45-0+deb7u2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `BDdavid`
--

-- --------------------------------------------------------

--
-- Table structure for table `TP_BLOG`
--

CREATE TABLE IF NOT EXISTS `TP_BLOG` (
  `Titre` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Description` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Image` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Titre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TP_BLOG`
--

INSERT INTO `TP_BLOG` (`Titre`, `Description`, `url`, `Image`) VALUES
('L''objet le plus rond du monde', '<p>	  \r\n	  A kilogram isn''t what it used to be. Literally. The original name for it was the ''grave'', proposed in 1793 but it fell victim to the French Revolution like its creator, Lavoisier. So begins the tale of the most unusual SI unit. The kilogram is the only base unit with a prefix in its name, and the only one still defined by a physical artifact, the international prototype kilogram or IPK.\r\n	</p>\r\n	<p>\r\n	  But the problem with this definition has long been apparent. The IPK doesn''t seem to maintain its mass compared to 40 similar cylinders minted at the same time. The goal is therefore to eliminate the kilogram''s dependence on a physical object. Two main approaches are being considered to achieve this end: the Avogadro Project and the Watt Balance.\r\n	</p>\r\n	<p>\r\n	  The Avogadro project aims to redefine Avogadro''s constant (currently defined by the kilogram -- the number of atoms in 12 g of carbon-12) and reverse the relationship so that the kilogram is precisely specified by Avogadro''s constant. This method required creating the most perfect sphere on Earth. It is made out of a single crystal of silicon 28 atoms. By carefully measuring the diameter, the volume can be precisely specified. Since the atom spacing of silicon is well known, the number of atoms in a sphere can be accurately calculated. This allows for a very precise determination of Avogadro''s constant.\r\n	</p>', 'https://www.youtube.com/watch?v=ZMByI4s-D-Y', 'http://marseille/~david/TP_NOTE/img/round.jpg'),
('Le boson de Higgs', 'Le boson de Higgs  est une particule élémentaire dont l''existence, postulée en 1964,permet d''expliquer ainsi pourquoi certaines particules ont une masse et d''autres n''en ont pas.', 'https://www.youtube.com/watch?v=fU6thWi2U5U', 'http://marseille/~david/TP_NOTE/img/higgs.jpg'),
('Le mur de Planck', 'Le Mur de Planck (du nom du physicien Max Planck) désigne la période de l''histoire de l''univers où ce dernier avait un âge de l''ordre du temps de Planck, à savoir environ 10-44 secondes. Avant ce temps, période appelée l''ère de Planck, toutes les lois actuelles de la physique classique comme de la physique quantique trouvent leur limitation dans la mesure où il devient nécessaire d''avoir une description microscopique de la gravitation (on appelle une telle théorie gravité quantique) qui reste encore mystérieuse à ce jour.\r\n	', 'https://www.youtube.com/watch?v=yDEM3lwkXyo', 'http://marseille/~david/TP_NOTE/img/planck.jpg');

/*!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 */;
