YMkeBwVt

1
2CREATE TABLE IF NOT EXISTS `reserva_voucher` (
3  `idreserva` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `voucher` varchar(10) NOT NULL,
5  `reserva` int(10) unsigned NOT NULL,
6  `cliente` int(10) unsigned NOT NULL,
7  `datareserva` datetime DEFAULT NULL,
8  `horario` int(10) unsigned NOT NULL,
9  `data` date NOT NULL,
10  `qnt` int(10) unsigned NOT NULL DEFAULT '0',
11  `valor` float(9,2) DEFAULT '0.00',
12  `comprovante` varchar(150) DEFAULT NULL,
13  `datacomprovante` datetime DEFAULT NULL,
14  `situacao` enum('N','A','C','R') NOT NULL DEFAULT 'N',
15  `pontos` int(11) DEFAULT '0',
16  `unidade_bases` int(10) unsigned DEFAULT NULL,
17  `ordem` int(10) unsigned DEFAULT NULL,
18  PRIMARY KEY (`idreserva`),
19  KEY `cliente` (`cliente`,`horario`),
20  KEY `horario` (`horario`),
21  KEY `unidade_bases` (`unidade_bases`),
22  KEY `reserva` (`reserva`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
24
25--
26-- Extraindo dados da tabela `reserva_voucher`
27--
28
29INSERT INTO `reserva_voucher` (`idreserva`, `voucher`, `reserva`, `cliente`, `datareserva`, `horario`, `data`, `qnt`, `valor`, `comprovante`, `datacomprovante`, `situacao`, `pontos`, `unidade_bases`, `ordem`) VALUES
30(1, '1234567890', 6449, 23, '2016-11-21 12:45:50', 1, '2016-11-27', 10, NULL, '2618b5e10bf6babbc82d291ae3769d2a_[autoserviã§o]_-_horã¡rio_individual.pdf', NULL, 'N', NULL, 1, 1),
31(2, '1234567890', 6449, 23, '2016-11-21 15:53:00', 1, '2016-11-27', 10, 0.00, '2a5448423b72c3ab7d63e23cd3ff1fe2_63.pdf', '2016-11-21 16:43:54', 'A', NULL, 1, 2);