-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 28, 2014 at 12:32 AM
-- Server version: 5.6.16
-- PHP Version: 5.5.11

SET FOREIGN_KEY_CHECKS=0;
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: `bonnenuit`
--

--
-- Dumping data for table `adresse`
--

INSERT INTO `adresse` (`adresse_p_id`, `adresse_no_rue_app`, `adresse_codepostal`, `ville_fk_id`) VALUES
(4, 'BIG', 'J1N1N7', 1);

--
-- Dumping data for table `article`
--

INSERT INTO `article` (`article_p_id`, `article_code`, `article_description`, `article_taxable`, `article_actif`, `categorie_fk_id`) VALUES
(1, 'SIMPLE', '1 lit simple', 'V', 'V', 1),
(2, 'BIDON', 'BIDON', 'V', 'V', 3),
(3, 'BIDON GROUPE', 'BIDON GROUPE', 'V', 'V', 2);

--
-- Dumping data for table `categorie_article`
--

INSERT INTO `categorie_article` (`categorie_article_p_id`, `categorie_article_description`) VALUES
(1, 'CHAMBRE'),
(2, 'GROUPE'),
(3, 'DEPANNEUR'),
(4, 'RESTAURANT'),
(5, 'ADMINISTRATION'),
(6, '');

--
-- Dumping data for table `chambre`
--

INSERT INTO `chambre` (`chambre_p_id`, `chambre_nombredelits`, `chambre_devantlhotel`, `chambre_nombreEtage`, `chambre_numero`, `chambre_description`) VALUES
(1, 1, 'V', 1, 128, '1 Lit Double'),
(2, 1, 'V', 1, 126, '1 Lit Dobule'),
(3, 1, 'V', 1, 124, '1 Lit Double'),
(4, 2, 'V', 1, 122, '1 Lit Double 1 Lit Simple'),
(5, 2, 'V', 1, 120, '1 Lit Double 1 Lit Simple'),
(6, 2, 'V', 1, 118, '1 Lit Double 1 Lit Simple'),
(7, 1, 'V', 1, 116, '1 Lit Double'),
(8, 2, 'V', 1, 101, 'SUITE 2 Lit Double'),
(9, 2, 'V', 1, 103, 'SUITE 2 Lit Double'),
(10, 2, 'V', 1, 105, 'SUITE 2 Lit Double'),
(11, 2, 'V', 1, 107, '1 Lit Double 1 Lit Simple'),
(12, 2, 'V', 1, 109, '1 lit Double 1 Lit Simple'),
(13, 2, 'V', 1, 111, '2 Lit Simple'),
(14, 2, 'F', 1, 127, '2 Lit Simple'),
(15, 2, 'F', 1, 125, '1 Lit Double 1 Lit Simple'),
(16, 2, 'F', 1, 123, '2 Lit Simple'),
(17, 2, 'F', 1, 121, '2 Lit Simple'),
(18, 1, 'F', 1, 119, '1 Lit Double'),
(19, 1, 'F', 1, 117, '1 Lit Double'),
(20, 1, 'F', 1, 115, '1 Lit Double'),
(21, 1, 'F', 1, 113, '1 Lit Double'),
(22, 1, 'F', 1, 102, '1 Lit Double'),
(23, 2, 'F', 1, 104, '2 Lit Simple'),
(24, 1, 'F', 1, 106, '1 Lit Double'),
(25, 1, 'F', 1, 108, '1 Lit Double'),
(26, 3, 'F', 1, 110, 'SUITE 1 Lit Double 2 Lit Simple'),
(27, 1, 'V', 2, 230, '1 Lit Double'),
(28, 2, 'V', 2, 228, '1 Lit Double 1 Lit Simple'),
(29, 2, 'V', 2, 226, '1 Lit Double 1 Lit Simple'),
(30, 2, 'V', 2, 224, '1 Lit Double 1 Lit Simple'),
(31, 2, 'V', 2, 222, '1 Lit Double 1 Lit Simple'),
(32, 2, 'V', 2, 220, '1 Lit Double 1 Lit Simple'),
(33, 2, 'V', 2, 218, '1 Lit Double 1 Lit Simple'),
(34, 2, 'V', 2, 216, '1 Lit Double 1 Lit Simple'),
(35, 2, 'V', 2, 214, '1 Lit Double 1 Lit Simple'),
(36, 2, 'V', 2, 212, '1 Lit Double 1 Lit Simple'),
(37, 2, 'V', 2, 201, '1 Lit Double 1 Lit Simple'),
(38, 2, 'V', 2, 203, '1 Lit Double 1 Lit Simple'),
(39, 2, 'V', 2, 205, '1 Lit Double 1 Lit Simple'),
(40, 2, 'V', 2, 207, '1 Lit Double 1 Lit Simple'),
(41, 2, 'V', 2, 209, '1 Lit Double 1 Lit Simple'),
(42, 2, 'V', 2, 211, '2 Lit Simple'),
(43, 2, 'F', 2, 229, '2 Lit Simple'),
(44, 2, 'F', 2, 227, '1 Lit Double 1 Lit Simple'),
(45, 1, 'F', 2, 225, '1 Lit Double'),
(46, 1, 'F', 2, 219, '1 Lit Double'),
(47, 1, 'F', 2, 217, '1 Lit Double'),
(48, 1, 'F', 2, 215, '1 Lit Double'),
(49, 1, 'F', 2, 213, '1 Lit Double'),
(50, 1, 'F', 2, 202, '1 Lit Double'),
(51, 2, 'F', 2, 204, '1 Lit Double 1 Lit Simple'),
(52, 1, 'F', 2, 206, '1 Lit Double'),
(53, 1, 'F', 2, 208, '1 Lit Double'),
(54, 3, 'F', 2, 210, '1 Lit Double 2 Lit Simple');

--
-- Dumping data for table `client`
--

INSERT INTO `client` (`client_p_id`, `client_nom`, `client_prenom`, `adresse_fk_id`, `client_commentaire`) VALUES
(1, 'BID', 'BID', 4, '');

--
-- Dumping data for table `constante`
--

INSERT INTO `constante` (`constante_p_id`, `constante_noTps`, `constante_noTvq`, `constante_neq`, `constante_messagefacture`) VALUES
(1, '0', '0', '1170077359', 'Merci!');

--
-- Dumping data for table `depot`
--

INSERT INTO `depot` (`depot_p_id`, `depot_date`, `depot_montant`, `employe_fk_id`) VALUES
(1, '2014-07-01', '0.00', 1);

--
-- Dumping data for table `employe`
--

INSERT INTO `employe` (`employe_p_id`, `employe_prenom`, `employe_nom`, `utilisateur_fk_id`, `employe_commentaire`) VALUES
(1, 'Denise', 'Rivard', 1, NULL);

--
-- Dumping data for table `facture`
--

INSERT INTO `facture` (`facture_p_id`, `facture_jour`, `facture_heure`, `facture_depense`, `facture_commentaire`, `client_fk_id`, `fermeture_fk_id`, `taxe_fk_id`) VALUES
(3, '2014-07-23', '12:37:57', '0.00', '', 1, 1, 1),
(4, '2014-07-23', '13:00:56', '0.00', '', 1, 1, 1),
(5, '2014-07-23', '13:05:29', '0.00', '', 1, 1, 1),
(6, '2014-07-27', '14:05:56', '0.00', '', 1, 1, 1),
(7, '2014-07-27', '14:12:36', '0.00', '', 1, 1, 1),
(8, '2014-07-27', '14:22:05', '0.00', '', 1, 1, 1),
(9, '2014-07-27', '14:25:15', '0.00', '', 1, 1, 1),
(10, '2014-07-27', '14:28:59', '0.00', '', 1, 1, 1),
(11, '2014-07-27', '14:34:35', '0.00', '', 1, 1, 1),
(12, '2014-07-27', '15:01:24', '0.00', '', 1, 1, 1),
(13, '2014-07-27', '15:12:54', '0.00', '', 1, 1, 1),
(14, '2014-07-27', '15:15:59', '0.00', '', 1, 1, 1),
(15, '2014-07-27', '15:44:39', '0.00', '', 1, 1, 1),
(16, '2014-07-27', '18:28:07', '0.00', '', 1, 1, 1);

--
-- Dumping data for table `fermeture`
--

INSERT INTO `fermeture` (`fermeture_p_id`, `fermeture_jour`, `employe_fk_id`, `depot_fk_id`, `fermeture_commentaire`) VALUES
(1, '2014-07-01', 1, 1, NULL);

--
-- Dumping data for table `groupe`
--

INSERT INTO `groupe` (`groupe_p_id`, `groupe_nom`, `client_fk_id`) VALUES
(1, 'BIDON', 1);

--
-- Dumping data for table `groupe_utilisateur`
--

INSERT INTO `groupe_utilisateur` (`groupe_utilisateur_p_id`, `groupe_utilisateur_nom`) VALUES
(1, 'ADMINISTRATEUR'),
(2, 'RECEPTION'),
(3, 'SPECTATEUR');

--
-- Dumping data for table `modedepaiement`
--

INSERT INTO `modedepaiement` (`modedepaiement_p_id`, `modedepaiement_nom`) VALUES
(1, 'Comptant'),
(2, 'Chque'),
(3, 'Visa'),
(4, 'MasterCard'),
(5, 'AmericanExpress'),
(6, 'Interac'),
(7, 'Autres');

--
-- Dumping data for table `sequence`
--

INSERT INTO `sequence` (`sequence_nomtable`, `sequence_dernierid`) VALUES
('adresse', 4),
('article', 4),
('categorie_article', 7),
('chambre', 55),
('client', 1),
('depot', 2),
('employe', 2),
('encaissement', 0),
('facture', 16),
('fermeture', 2),
('groupe', 1),
('groupe_utilisateur', 4),
('location_chambre', 0),
('modedepaiement', 8),
('reservation', 0),
('reservation_groupe', 0),
('reservation_individu', 0),
('status_chambre', 12),
('taxe', 2),
('telephone', 2),
('telephone_type', 5),
('utilisateur', 2),
('vente', 12),
('vente_article', 0),
('ville', 1);

--
-- Dumping data for table `status_chambre`
--

INSERT INTO `status_chambre` (`status_chambre_p_id`, `status_chambre_description`) VALUES
(1, 'LIBRE'),
(2, 'RESERVEE'),
(3, 'CHECKIN'),
(4, 'CHECK OUT'),
(5, 'A CANCELLER'),
(6, 'CANCEL'),
(8, 'PAYEE'),
(10, 'EN REPARATION'),
(11, 'CACHE');

--
-- Dumping data for table `taxe`
--

INSERT INTO `taxe` (`taxe_p_id`, `taxe_tps`, `taxe_tvq`, `taxe_hebergement`, `taxe_changement`) VALUES
(1, '0.700', '0.700', '0.00', '2014-07-01');

--
-- Dumping data for table `telephone`
--

INSERT INTO `telephone` (`telephone_p_id`, `telephone_numero`, `telephone_type_fk_id`, `client_fk_id`) VALUES
(1, '', 1, 1),
(2, '1111111111', 1, 1);

--
-- Dumping data for table `telephone_type`
--

INSERT INTO `telephone_type` (`telephone_type_p_id`, `telephone_type_nom`) VALUES
(1, 'MAISON'),
(2, 'TRAVAIL'),
(3, 'MOBILE'),
(4, 'VOIP');

--
-- Dumping data for table `utilisateur`
--

INSERT INTO `utilisateur` (`utilisateur_p_id`, `utilisateur_nom`, `utilisateur_motdepasse`, `utilisateur_actif`, `groupe_utilisateur_fk_id`) VALUES
(1, 'Denise', '7E7EFE20EF99333543BEE021B00229A2', 'V', 1);

--
-- Dumping data for table `vente`
--

INSERT INTO `vente` (`vente_p_id`, `vente_jour`, `vente_heure`, `vente_prix`, `facture_fk_id`, `article_fk_id`) VALUES
(1, '2014-07-23', '13:00:58', '0.00', 4, 20),
(2, '2014-07-23', '13:05:32', '0.00', 5, 20),
(3, '2014-07-27', '14:06:11', '0.00', 6, 20),
(4, '2014-07-27', '14:07:30', '0.00', 6, 20),
(5, '2014-07-27', '14:12:39', '0.00', 7, 20),
(6, '2014-07-27', '14:22:14', '0.00', 8, 20),
(7, '2014-07-27', '14:25:19', '0.00', 9, 20),
(8, '2014-07-27', '14:29:01', '0.00', 10, 20),
(9, '2014-07-27', '14:41:14', '0.00', 11, 20),
(10, '2014-07-27', '15:01:34', '0.00', 12, 20),
(11, '2014-07-27', '15:12:59', '0.00', 13, 20),
(12, '2014-07-27', '15:16:12', '0.00', 14, 20);

--
-- Dumping data for table `vente_article`
--

INSERT INTO `vente_article` (`vente_article_p_fk_id`, `vente_article_quantite`) VALUES
(1, 0),
(2, 0),
(3, 0),
(4, 0),
(5, 0),
(6, 0),
(7, 0),
(8, 0),
(9, 0),
(10, 0),
(11, 0),
(12, 0);

--
-- Dumping data for table `ville`
--

INSERT INTO `ville` (`ville_p_id`, `ville_nom`, `ville_province`, `ville_pays`) VALUES
(1, 'ST-ADELE', 'QUEBEC', 'CANADA');
SET FOREIGN_KEY_CHECKS=1;

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