# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Lundi 06 Décembre 2004 à 15:22
# Version du serveur: 4.0.15
# Version de PHP: 4.3.3
# 
# Base de données: `basepres`
# 

# --------------------------------------------------------

#
# Structure de la table `laversion`
#

CREATE TABLE `laversion` (
  `_rowid` int(11) NOT NULL auto_increment,
  `valeur` int(11) default NULL,
  PRIMARY KEY  (`_rowid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Contenu de la table `laversion`
#

INSERT INTO `laversion` (`_rowid`, `valeur`) VALUES (1, 420);

# --------------------------------------------------------

#
# Structure de la table `lignes`
#

CREATE TABLE `lignes` (
  `ALD` smallint(6) NOT NULL default '1',
  `codebarre` int(10) unsigned NOT NULL default '0',
  `dur` varchar(200) NOT NULL default '',
  `fin` varchar(200) NOT NULL default '',
  `hor1` varchar(20) NOT NULL default '',
  `hor2` varchar(20) NOT NULL default '',
  `hor3` varchar(20) NOT NULL default '',
  `hor4` varchar(20) NOT NULL default '',
  `hor5` varchar(20) NOT NULL default '',
  `hor6` varchar(20) NOT NULL default '',
  `ID` int(10) unsigned NOT NULL auto_increment,
  `lemedic` varchar(255) NOT NULL default '',
  `ordre` smallint(5) unsigned NOT NULL default '0',
  `patient` int(10) unsigned NOT NULL default '0',
  `forme` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=98 ;

#
# Contenu de la table `lignes`
#

INSERT INTO `lignes` (`ALD`, `codebarre`, `dur`, `fin`, `hor1`, `hor2`, `hor3`, `hor4`, `hor5`, `hor6`, `ID`, `lemedic`, `ordre`, `patient`, `forme`) VALUES (1, 44470, '', '', '1', '', '', '1', '', '', 97, 'AUGMENTIN 0500 MG COMPRIME', 1, 4, '');
INSERT INTO `lignes` (`ALD`, `codebarre`, `dur`, `fin`, `hor1`, `hor2`, `hor3`, `hor4`, `hor5`, `hor6`, `ID`, `lemedic`, `ordre`, `patient`, `forme`) VALUES (1, 44414, '', '', '1', '1', '', '1', '', '', 96, 'ATROVENT 0.25 MG 2ML SOLUTION POUR INHALATION', 0, 4, 'bouffée');
INSERT INTO `lignes` (`ALD`, `codebarre`, `dur`, `fin`, `hor1`, `hor2`, `hor3`, `hor4`, `hor5`, `hor6`, `ID`, `lemedic`, `ordre`, `patient`, `forme`) VALUES (0, 51158, '', '', '', '', '', '', '1', '', 77, 'IMOVANE COMPRIME', 1, 3, '');
INSERT INTO `lignes` (`ALD`, `codebarre`, `dur`, `fin`, `hor1`, `hor2`, `hor3`, `hor4`, `hor5`, `hor6`, `ID`, `lemedic`, `ordre`, `patient`, `forme`) VALUES (0, 47343, '', '', '1', '', '', '', '', '', 76, 'DEROXAT COMPRIME', 0, 3, '');
INSERT INTO `lignes` (`ALD`, `codebarre`, `dur`, `fin`, `hor1`, `hor2`, `hor3`, `hor4`, `hor5`, `hor6`, `ID`, `lemedic`, `ordre`, `patient`, `forme`) VALUES (1, 58849, '7', '8', '1', '2', '3', '4', '5', '6', 13, 'TARGOCID 400 MG 3,2 ML INJ. FLACON', 0, 13, 'cpé');
INSERT INTO `lignes` (`ALD`, `codebarre`, `dur`, `fin`, `hor1`, `hor2`, `hor3`, `hor4`, `hor5`, `hor6`, `ID`, `lemedic`, `ordre`, `patient`, `forme`) VALUES (1, 58849, '7', '8', '1', '2', '3', '4', '5', '6', 5, 'TARGOCID 400 MG 3,2 ML INJ. FLACON', 0, 7, 'cpé');

# --------------------------------------------------------

#
# Structure de la table `medecins`
#

CREATE TABLE `medecins` (
  `fonction` varchar(50) NOT NULL default '',
  `ID` int(10) unsigned NOT NULL auto_increment,
  `nom` varchar(100) NOT NULL default '',
  `nomcomplet` varchar(200) NOT NULL default '',
  `prenom` varchar(100) NOT NULL default '',
  `telephone` varchar(15) NOT NULL default '',
  `bz1` varchar(100) NOT NULL default '',
  `bz2` varchar(100) NOT NULL default '',
  `bz3` varchar(100) NOT NULL default '',
  `mdp` varchar(15) default NULL,
  `prestout` int(11) default NULL,
  `admin` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Contenu de la table `medecins`
#

INSERT INTO `medecins` (`fonction`, `ID`, `nom`, `nomcomplet`, `prenom`, `telephone`, `bz1`, `bz2`, `bz3`, `mdp`, `prestout`, `admin`) VALUES ('', 2, 'MABUSE', 'Dr MABUSE Paulin', 'Paulin', '', '', '2', '', NULL, NULL, NULL);

# --------------------------------------------------------

#
# Structure de la table `notes`
#

CREATE TABLE `notes` (
  `_rowid` int(11) NOT NULL auto_increment,
  `texte` blob,
  `patient` int(11) default NULL,
  `date` int(11) default NULL,
  `type` int(11) default NULL,
  `heure` varchar(10) default NULL,
  `datex` varchar(12) default NULL,
  `auteur` varchar(30) default NULL,
  PRIMARY KEY  (`_rowid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Contenu de la table `notes`
#

INSERT INTO `notes` (`_rowid`, `texte`, `patient`, `date`, `type`, `heure`, `datex`, `auteur`) VALUES (1, 0x4154524f56454e5420302e3235204d4720324d4c20534f4c5554494f4e20504f555220494e48414c4154494f4e203a2020312020626f756666c3a965206c65206d6174696e2c20312020626f756666c3a965206c65206d6964692c20312020626f756666c3a965206c6520736f697220200d4155474d454e54494e2030353030204d4720434f4d5052494d45203a2020312020206c65206d6174696e2c20312020206c6520736f697220200d, 4, 41206, 3, '12:05', '06/12/2004', 'Dr MABUSE Paulin');

# --------------------------------------------------------

#
# Structure de la table `patients`
#

CREATE TABLE `patients` (
  `ade` smallint(6) NOT NULL default '0',
  `alla` smallint(6) NOT NULL default '0',
  `allerg` varchar(255) NOT NULL default '',
  `CI` varchar(255) NOT NULL default '',
  `datenaissance` varchar(20) NOT NULL default '',
  `datentree` varchar(20) NOT NULL default '',
  `dia` smallint(6) NOT NULL default '0',
  `diagno` varchar(255) NOT NULL default '',
  `gla` smallint(6) NOT NULL default '0',
  `gro` smallint(6) NOT NULL default '0',
  `hta` smallint(6) NOT NULL default '0',
  `ID` int(10) unsigned NOT NULL auto_increment,
  `ire` smallint(6) NOT NULL default '0',
  `ihe` smallint(6) NOT NULL default '0',
  `medecin` varchar(50) NOT NULL default '',
  `IDmedecin` int(11) NOT NULL default '0',
  `nom` varchar(100) NOT NULL default '',
  `nomcomplet` varchar(200) NOT NULL default '',
  `poids` smallint(6) NOT NULL default '0',
  `prenom` varchar(100) NOT NULL default '',
  `sexe` smallint(6) NOT NULL default '1',
  `taille` smallint(6) NOT NULL default '0',
  `ulc` smallint(6) NOT NULL default '0',
  `archive` int(11) NOT NULL default '0',
  `s1` varchar(100) NOT NULL default '',
  `lit` varchar(40) NOT NULL default '',
  `consignes` blob,
  `datep` varchar(10) default NULL,
  `datec` varchar(10) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=70 ;

#
# Contenu de la table `patients`
#

INSERT INTO `patients` (`ade`, `alla`, `allerg`, `CI`, `datenaissance`, `datentree`, `dia`, `diagno`, `gla`, `gro`, `hta`, `ID`, `ire`, `ihe`, `medecin`, `IDmedecin`, `nom`, `nomcomplet`, `poids`, `prenom`, `sexe`, `taille`, `ulc`, `archive`, `s1`, `lit`, `consignes`, `datep`, `datec`) VALUES (0, 0, '', '', '', '2/07/03', 0, '', 0, 0, 0, 4, 0, 0, 'Dr MABUSE Paulin', 2, 'SCHMOL', 'SCHMOL Raoul', 0, 'Raoul', 1, 0, 0, 0, '', '', NULL, '06/12/2004', NULL);
INSERT INTO `patients` (`ade`, `alla`, `allerg`, `CI`, `datenaissance`, `datentree`, `dia`, `diagno`, `gla`, `gro`, `hta`, `ID`, `ire`, `ihe`, `medecin`, `IDmedecin`, `nom`, `nomcomplet`, `poids`, `prenom`, `sexe`, `taille`, `ulc`, `archive`, `s1`, `lit`, `consignes`, `datep`, `datec`) VALUES (1, 0, '', '', '30/07/62', '15/09/03', 1, '', 1, 0, 0, 3, 0, 1, 'Dr MABUSE Paulin', 2, 'TRUC', 'TRUC Jean', 56, 'Jean', 1, 180, 1, 0, '', '', NULL, NULL, NULL);

# --------------------------------------------------------

#
# Structure de la table `prefs`
#

CREATE TABLE `prefs` (
  `id` smallint(5) unsigned NOT NULL default '0',
  `textes` varchar(100) default NULL,
  `valeurs` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `prefs`
#

INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (0, NULL, 400);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (1, '9H', 30);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (2, '12H', 11);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (3, '16H', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (4, '21H', 1);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (5, '22H', 1);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (6, '24H', 12);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (7, 'le matin', 12);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (8, 'le midi', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (9, 'à 16H', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (10, 'le soir', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (11, 'au coucher', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (12, 'à minuit', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (13, 'Dur', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (14, 'Fin', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (15, 'Centre Hospitalier de', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (16, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (17, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (18, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (19, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (20, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (21, 'Arial', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (22, 'Arial', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (23, 'Arial', 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (24, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (25, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (26, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (27, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (28, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (29, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (30, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (31, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (32, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (33, NULL, 2);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (34, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (35, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (36, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (37, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (38, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (39, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (40, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (41, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (42, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (43, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (44, NULL, 0);
INSERT INTO `prefs` (`id`, `textes`, `valeurs`) VALUES (45, NULL, 0);