b6gNdWyd

1-- Adminer 4.3.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `Echantillon`;
9CREATE TABLE `Echantillon` (
10  `ECH_CODE` int(11) NOT NULL,
11  `ECH_PRIXHT` double DEFAULT NULL,
12  `MED_DEPOTLEGAL` varchar(11) DEFAULT NULL,
13  PRIMARY KEY (`ECH_CODE`),
14  KEY `MED_DEPOTLEGAL` (`MED_DEPOTLEGAL`),
15  CONSTRAINT `MED_DEPOTLEGAL` FOREIGN KEY (`MED_DEPOTLEGAL`) REFERENCES `Medicament` (`MED_DEPOTLEGAL`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18
19INSERT INTO `Visite` (`VIS_MATRICULE`, `RAP_NUM`, `PRA_NUM`, `RAP_DATE`, `RAP_BILAN`, `RAP_MOTIF`) VALUES
20('p49',	1,	76,	'2015-06-23',	'RAS\r\nChangement de tel : 05 89 89 89 89',	'Rapport Annuel'),
21('m45',	2,	57,	'2016-08-19',	'Changement de direction, redéfinition de la politique médicamenteuse, recours au générique',	'Baisse activité'),
22('a131',	3,	23,	'2002-02-18',	'Médecin curieux, à recontacer en décembre pour réunion',	'Actualisation annuelle'),
23('a17',	4,	4,	'2002-02-20',	NULL,	NULL),
24('d13',	5,	57,	'2016-07-07',	NULL,	NULL),
25('q17',	6,	59,	'2016-08-18',	NULL,	NULL),
26('a131',	7,	41,	'2002-02-19',	NULL,	NULL),
27('r24',	8,	45,	'2015-10-16',	NULL,	NULL),
28('p49',	9,	5,	'2016-10-18',	NULL,	NULL),
29('p7',	10,	60,	'2015-10-11',	NULL,	NULL),
30('b13',	11,	56,	'2016-10-05',	NULL,	NULL),
31('n42',	12,	17,	'2014-06-13',	NULL,	NULL),
32('f21',	18,	79,	'2014-09-16',	NULL,	NULL),
33('o26',	19,	56,	'2014-08-12',	NULL,	NULL),
34('r24',	20,	17,	'2014-10-21',	NULL,	NULL),
35('a131',	21,	18,	'2016-12-15',	NULL,	NULL),
36('a55',	22,	6,	'2016-06-21',	NULL,	NULL);
37
38-- 2017-11-23 09:48:13