


DROP TABLE IF EXISTS `bebes_princeps`;
CREATE TABLE `bebes_princeps` (
  `id` int(11) NOT NULL default '0',
  `sexe` varchar(50) NOT NULL default '',
  `accouchement` varchar(50) NOT NULL default '',
  `lieu_naissance` varchar(50) NOT NULL default '',
  `poids_naissance` int(11) NOT NULL default '0',
  `terme` decimal(4,2) NOT NULL default '0.00',
  `terme_normalise` int(11) NOT NULL default '0',
  `CRIB` int(11) NOT NULL default '0',
  `jour_naissance` date NOT NULL default '2000-01-01',
  `jour_experience` int(11) NOT NULL default '0',
  `SM1` int(11) NOT NULL default '0',
  `SM3` int(11) NOT NULL default '0',
  `SM7` int(11) NOT NULL default '0',
  `SM15` int(11) NOT NULL default '0',
  `etat_J1` varchar(50) default NULL,
  `etat_J3` varchar(50) default NULL,
  `etat_J7` varchar(50) default NULL,
  `etat_J15` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_depart`;
CREATE TABLE `fiches_depart` (
  `id` int(11) NOT NULL default '0',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_en_categorie_complete`;
CREATE TABLE `fiches_en_categorie_complete` (
  `id` int(11) NOT NULL default '0',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_en_categorie_intermediaire`;
CREATE TABLE `fiches_en_categorie_intermediaire` (
  `id` int(11) NOT NULL default '0',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_en_POS`;
CREATE TABLE `fiches_en_POS` (
  `id` int(11) NOT NULL default '0',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_lemmatisees`;
CREATE TABLE `fiches_lemmatisees` (
  `id` int(11) NOT NULL default '0',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_normalisees`;
CREATE TABLE `fiches_normalisees` (
  `id` int(11) NOT NULL default '0',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `fiches_originelles`;
CREATE TABLE `fiches_originelles` (
  `id` int(11) NOT NULL default '0',
  `id_bebe` int(11) NOT NULL default '0',
  `jour` int(11) NOT NULL default '0',
  `heure_saisie` decimal(4,2) default '0.00',
  `poids` int(11) NOT NULL default '0',
  `classe_poids` varchar(50) default NULL,
  `position` varchar(50) NOT NULL default '',
  `classe_position` varchar(50) default NULL,
  `sedation` varchar(50) NOT NULL default '',
  `ventilation` varchar(50) NOT NULL default '',
  `id_infirmiere` int(11) NOT NULL default '0',
  `frequence_occupation` varchar(50) NOT NULL default '',
  `moral_infirmiere` varchar(50) NOT NULL default '',
  `pronostic_infirmiere` varchar(50) NOT NULL default '',
  `relation_infirmiere_parents` varchar(50) NOT NULL default '',
  `relation_mere_bebe` varchar(50) NOT NULL default '',
  `frequence_visites_parents` varchar(50) NOT NULL default '',
  `texte` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `infirmieres_princeps`;
CREATE TABLE `infirmieres_princeps` (
  `id` int(11) NOT NULL default '0',
  `age` int(11) NOT NULL default '0',
  `etudes` int(11) NOT NULL default '0',
  `diplome` varchar(50) NOT NULL default '',
  `anciennete` decimal(4,2) NOT NULL default '0.00',
  `service` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `occ_prema`;
CREATE TABLE `occ_prema` (
  `numero_ordre` int(11) NOT NULL default '0',
  `fiche` int(11) NOT NULL default '0',
  `forme_depart` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `forme_normalisee` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
  `lemme` varchar(100) character set latin1 collate latin1_bin NOT NULL default '',
  `categorie` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`numero_ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `signaletique_fiches_princeps`;
CREATE TABLE `signaletique_fiches_princeps` (
  `id` int(11) NOT NULL default '0',
  `id_bebe` int(11) NOT NULL default '0',
  `jour` int(11) NOT NULL default '0',
  `heure_saisie` decimal(4,2) default '0.00',
  `poids` int(11) NOT NULL default '0',
  `position` varchar(50) NOT NULL default '',
  `sedation` varchar(50) NOT NULL default '',
  `ventilation` varchar(50) NOT NULL default '',
  `id_infirmiere` int(11) NOT NULL default '0',
  `frequence_occupation` varchar(50) NOT NULL default '',
  `moral_infirmiere` varchar(50) NOT NULL default '',
  `pronostic_infirmiere` varchar(50) NOT NULL default '',
  `relation_infirmiere_parents` varchar(50) NOT NULL default '',
  `relation_mere_bebe` varchar(50) NOT NULL default '',
  `frequence_visites_parents` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


