-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Lun 04 Mai 2015 à 16:01
-- Version du serveur: 5.0.37
-- Version de PHP: 5.2.1


-- 
-- Base de données: `ran`
-- 

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

-- 
-- Structure de la table `cause_deces`
-- 

CREATE TABLE IF NOT EXISTS `cause_deces` (
  `cad_code` smallint(6) NOT NULL,
  `cad_libelle` varchar(50) NOT NULL,
  `ordre` tinyint(4) NOT NULL,
  PRIMARY KEY  (`cad_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `cause_deces`
-- 

INSERT INTO `cause_deces` (`cad_code`, `cad_libelle`, `ordre`) VALUES 
(1, 'AVC hémorragique', 1),
(2, 'AVC ischémique', 2),
(3, 'AVP', 3),
(4, 'TC non AVP', 4),
(5, 'Anoxie', 5),
(6, 'Autre', 6);

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

-- 
-- Structure de la table `cond_immuno_sup`
-- 

CREATE TABLE IF NOT EXISTS `cond_immuno_sup` (
  `cis_code` decimal(2,0) NOT NULL,
  `cis_libelle` varchar(100) NOT NULL,
  PRIMARY KEY  (`cis_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `cond_immuno_sup`
-- 

INSERT INTO `cond_immuno_sup` (`cis_code`, `cis_libelle`) VALUES 
(1, 'Advagraf'),
(2, 'Prograf'),
(3, 'Neoral'),
(4, 'Rapamune'),
(5, 'Certican'),
(6, 'Cellcept'),
(7, 'Myfortic'),
(8, 'Imurel'),
(9, 'Methylprednisolone'),
(10, 'Mabthera'),
(11, 'Ig IV'),
(12, 'Soliris'),
(13, 'Thymoglobulines'),
(14, 'Simulect'),
(15, 'Plasmaphérese'),
(16, 'Immuno absorption');

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

-- 
-- Structure de la table `cote`
-- 

CREATE TABLE IF NOT EXISTS `cote` (
  `cot_code` decimal(1,0) NOT NULL,
  `cot_libelle` varchar(20) NOT NULL,
  PRIMARY KEY  (`cot_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `cote`
-- 

INSERT INTO `cote` (`cot_code`, `cot_libelle`) VALUES 
(1, 'Gauche'),
(2, 'Droit');

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

-- 
-- Structure de la table `groupe_hla`
-- 

CREATE TABLE IF NOT EXISTS `groupe_hla` (
  `hla_code` decimal(2,0) NOT NULL,
  `hla_libelle` varchar(10) NOT NULL,
  PRIMARY KEY  (`hla_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `groupe_hla`
-- 

INSERT INTO `groupe_hla` (`hla_code`, `hla_libelle`) VALUES 
(1, 'HLA A'),
(2, 'HLA B'),
(3, 'HLA Cw'),
(4, 'HLA DR'),
(5, 'HLA DQ'),
(6, 'HLA DP');

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

-- 
-- Structure de la table `groupe_sanguin`
-- 

CREATE TABLE IF NOT EXISTS `groupe_sanguin` (
  `gsa_code` smallint(6) NOT NULL,
  `gsa_libelle` varchar(50) NOT NULL,
  PRIMARY KEY  (`gsa_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `groupe_sanguin`
-- 

INSERT INTO `groupe_sanguin` (`gsa_code`, `gsa_libelle`) VALUES 
(1, 'A'),
(2, 'B'),
(3, 'AB'),
(4, 'O');

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

-- 
-- Structure de la table `liquide_perfusion`
-- 

CREATE TABLE IF NOT EXISTS `liquide_perfusion` (
  `lip_code` decimal(2,0) NOT NULL,
  `lip_libelle` varchar(100) NOT NULL,
  `ordre` tinyint(4) NOT NULL,
  PRIMARY KEY  (`lip_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `liquide_perfusion`
-- 

INSERT INTO `liquide_perfusion` (`lip_code`, `lip_libelle`, `ordre`) VALUES 
(1, 'Viaspan', 1),
(2, 'Celsior', 2),
(3, 'IgL', 3),
(4, 'Scott', 4),
(5, 'Autre', 5);

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

- 
-- Structure de la table `parente`
-- 

CREATE TABLE IF NOT EXISTS `parente` (
  `par_code` decimal(2,0) NOT NULL,
  `par_libelle` varchar(50) NOT NULL,
  `ordre` tinyint(4) NOT NULL,
  PRIMARY KEY  (`par_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `parente`
-- 

INSERT INTO `parente` (`par_code`, `par_libelle`, `ordre`) VALUES 
(1, 'Parent', 1),
(2, 'Enfant', 2),
(3, 'Fratrie', 3),
(4, 'Conjoint', 5),
(5, 'Apparenté autre', 4),
(6, 'Non apparenté', 6);
-- --------------------------------------------------------

-- 
-- Structure de la table `rang_valeur_hla`
-- 

CREATE TABLE IF NOT EXISTS `rang_valeur_hla` (
  `rvh_code` decimal(1,0) NOT NULL,
  `rvh_libelle` decimal(1,0) NOT NULL,
  PRIMARY KEY  (`rvh_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `rang_valeur_hla`
-- 

INSERT INTO `rang_valeur_hla` (`rvh_code`, `rvh_libelle`) VALUES 
(1, 1),
(2, 2);

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

-- 
-- Structure de la table `risque_immuno`
-- 

CREATE TABLE IF NOT EXISTS `risque_immuno` (
  `rim_code` decimal(1,0) NOT NULL,
  `rim_libelle` varchar(50) NOT NULL,
  PRIMARY KEY  (`rim_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `risque_immuno`
-- 

INSERT INTO `risque_immuno` (`rim_code`, `rim_libelle`) VALUES 
(1, 'Non immunisé'),
(2, 'Immunisé sans DSA'),
(3, 'Immunisé DSA'),
(4, 'ABO incompatible');

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

-- 
-- Structure de la table `serologie`
-- 

CREATE TABLE IF NOT EXISTS `serologie` (
  `ser_code` decimal(2,0) NOT NULL,
  `ser_libelle` varchar(20) NOT NULL,
  PRIMARY KEY  (`ser_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `serologie`
-- 

INSERT INTO `serologie` (`ser_code`, `ser_libelle`) VALUES 
(1, 'CMV'),
(2, 'EBV'),
(3, 'Toxoplasmose'),
(4, 'HIV'),
(5, 'HTLV'),
(6, 'Syphilis'),
(7, 'HCV'),
(8, 'ARNc'),
(9, 'Ag HBS'),
(10, 'Ac HBS'),
(11, 'Ac HBC'),
(12, 'DNA B');

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

-- 
-- Structure de la table `statut_serologie`
-- 

CREATE TABLE IF NOT EXISTS `statut_serologie` (
  `sts_code` decimal(2,0) NOT NULL,
  `sts_libelle` varchar(50) NOT NULL,
  PRIMARY KEY  (`sts_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `statut_serologie`
-- 

INSERT INTO `statut_serologie` (`sts_code`, `sts_libelle`) VALUES 
(1, '+'),
(2, '-');

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

-- 
-- Structure de la table `statut_virologique`
-- 

CREATE TABLE IF NOT EXISTS `statut_virologique` (
  `svi_code` decimal(2,0) NOT NULL,
  `svi_libelle` varchar(20) NOT NULL,
  PRIMARY KEY  (`svi_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `statut_virologique`
-- 

INSERT INTO `statut_virologique` (`svi_code`, `svi_libelle`) VALUES 
(1, 'D-/R-'),
(2, 'D-/R+'),
(3, 'D+/R-'),
(4, 'D+/R+'),
(5, 'R+'),
(6, 'R-');

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

-- 
-- Structure de la table `val_incompatibilite_hla`
-- 

CREATE TABLE IF NOT EXISTS `val_incompatibilite_hla` (
  `vih_code` decimal(1,0) NOT NULL,
  `vih_libelle` varchar(50) NOT NULL,
  PRIMARY KEY  (`vih_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `val_incompatibilite_hla`
-- 

INSERT INTO `val_incompatibilite_hla` (`vih_code`, `vih_libelle`) VALUES 
(1, '0'),
(2, '1'),
(3, '2');

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

-- 
-- Structure de la table `virus`
-- 

CREATE TABLE IF NOT EXISTS `virus` (
  `vir_code` decimal(2,0) NOT NULL,
  `vir_libelle` varchar(20) NOT NULL,
  PRIMARY KEY  (`vir_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `virus`
-- 

INSERT INTO `virus` (`vir_code`, `vir_libelle`) VALUES 
(1, 'CMV'),
(2, 'EBV'),
(3, 'Toxo');

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

-- 
-- Structure de la table `voie_abord`
-- 

CREATE TABLE IF NOT EXISTS `voie_abord` (
  `voa_code` decimal(1,0) NOT NULL,
  `voa_libelle` varchar(50) NOT NULL,
  PRIMARY KEY  (`voa_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `voie_abord`
-- 

INSERT INTO `voie_abord` (`voa_code`, `voa_libelle`) VALUES 
(1, 'Lombotomie'),
(2, 'Coelioscopie');



-- 
-- Structure de la table `type_donneur_decede`
-- 

CREATE TABLE IF NOT EXISTS `type_donneur_decede` (
  `tdd_code` decimal(1,0) NOT NULL,
  `tdd_libelle` varchar(50) NOT NULL,
  PRIMARY KEY  (`tdd_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `type_donneur_decede`
-- 

INSERT INTO `type_donneur_decede` (`tdd_code`, `tdd_libelle`) VALUES 
(1, 'DDCA'),
(2, 'DDME');
