1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
|
-- Structure de la table `Villa`
CREATE TABLE IF NOT EXISTS `Villa` (
`NoVilla` int(11) NOT NULL auto_increment,
`RueVilla` varchar(50) default NULL,
`CPVilla` varchar(5) default NULL,
`VilleVilla` varchar(30) default NULL,
`NbPlaces` smallint(6) default NULL,
`NbChambres` smallint(6) default NULL,
`Surface` smallint(6) default NULL,
`Jardin` tinyint(1) default NULL,
`Prix` decimal(19,4) default NULL,
`CdBailleur` varchar(8) default NULL,
PRIMARY KEY (`NoVilla`),
KEY `CdBailleur` (`CdBailleur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Contenu de la table `Villa`
--
INSERT INTO `Villa` (`NoVilla`, `RueVilla`, `CPVilla`, `VilleVilla`, `NbPlaces`, `NbChambres`, `Surface`, `Jardin`, `Prix`, `CdBailleur`) VALUES
(1, '15 chemin du Torgan', '11350', 'Padern', 5, 2, 90, 1, 350.0000, 'major'),
(2, '7 rue du Confluent', '11350', 'Padern', 4, 2, 70, 1, 300.0000, 'lassie'),
(3, '8 passage des Jardins', '11350', 'Padern', 4, 2, 65, 0, 300.0000, 'marty'),
(4, '4 rue du Verdouble', '11350', 'Padern', 4, 2, 60, 1, 300.0000, 'marty'),
(5, '12 rue Sainte Cécile', '11350', 'Padern', 6, 3, 90, 1, 400.0000, 'puj'),
-- --------------------------------------------------------
--
-- Structure de la table ``
--
CREATE TABLE IF NOT EXISTS `Bailleur` (
`CdBailleur` varchar(8) NOT NULL,
`NomBailleur` varchar(30) default NULL,
`RueBailleur` varchar(50) default NULL,
`CPBailleur` varchar(5) default NULL,
`VilleBailleur` varchar(30) default NULL,
`TelBailleur` varchar(20) default NULL,
`MelBailleur` varchar(30) default NULL,
PRIMARY KEY (`CdBailleur`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `Bailleur`
--
INSERT INTO `Bailleur` (`CdBailleur`, `NomBailleur`, `RueBailleur`, `CPBailleur`, `VilleBailleur`, `TelBailleur`, `MelBailleur`) VALUES
('marty', 'Marty', ' Jardins', '11350', 'Padern', '04 00 00 00 00', '@wanadoo.fr'),
('lassie', 'McTavish', 'Confluent', '11350', 'Padern', '04 00 00 00 00', '@wanadoo.fr'),
('caussa', 'Caussade', 'Padern', '11350', 'Cucugnan', '04 00 00 00 00', '@wanadoo.fr'),
('petit', 'Legrand', 'Pont', '11350', 'Tuchan', '04 00 00 00 00', '@wanadoo.fr'),
('kirst', 'Asch', 'Artisans', '11350', 'Tuchan', '04 00 00 00 00', '@wanadoo.fr'),
-- --------------------------------------------------------
--
-- Structure de la table `RESERVATION`
--
CREATE TABLE IF NOT EXISTS `RESERVATION` (
`NoRes` int(11) NOT NULL auto_increment,
`DateResDeb` datetime default NULL,
`numsemaine` smallint(6) default NULL,
`NoVilla` int(11) default NULL,
PRIMARY KEY (`NoRes`),
KEY `NoVilla` (`NoVilla`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Contenu de la table `RESERVATION`
--
INSERT INTO `RESERVATION` (`NoRes`, `DateResDeb`, `numsemaine`, `NoVilla`) VALUES
(1, '2008-06-02 00:00:00', 23, 1),
(2, '2008-06-02 00:00:00', 23, 2),
(3, '2008-06-02 00:00:00', 23, 3),
(4, '2008-06-02 00:00:00', 23, 6),
(5, '2008-06-02 00:00:00', 23, 7),
(6, '2008-06-02 00:00:00', 23, 8),
(7, '2008-06-02 00:00:00', 23, 9),
(8, '2008-06-02 00:00:00', 23, 10),
(9, '2008-06-02 00:00:00', 23, 14),
(10, '2008-06-02 00:00:00', 23, 15),
(11, '2008-06-09 00:00:00', 24, 2),
(12, '2008-06-09 00:00:00', 24, 7),
(13, '2008-06-09 00:00:00', 24, 9),
(14, '2008-06-09 00:00:00', 24, 10),
(15, '2008-06-09 00:00:00', 24, 13),
(16, '2008-06-09 00:00:00', 24, 15),
(17, '2008-06-16 00:00:00', 25, 1),
(18, '2008-06-16 00:00:00', 25, 2),
(19, '2008-06-16 00:00:00', 25, 6),
(20, '2008-06-16 00:00:00', 25, 7),
(21, '2008-06-16 00:00:00', 25, 9),
(22, '2008-06-16 00:00:00', 25, 10),
(23, '2008-06-16 00:00:00', 25, 13),
(24, '2008-06-16 00:00:00', 25, 8),
(25, '2008-06-23 00:00:00', 26, 1),
(26, '2008-06-23 00:00:00', 26, 3),
(27, '2008-06-23 00:00:00', 26, 7),
(28, '2008-06-23 00:00:00', 26, 8),
(29, '2008-06-23 00:00:00', 26, 14),
(30, '2008-06-23 00:00:00', 26, 15); |
Partager