 
 CREATE TABLE IF NOT EXISTS `reserva` (
 `idReserva` int(11) NOT NULL,
-  `fecha` varchar(45) NOT NULL,
   `idPelicula` int(11) NOT NULL,
-  `cedula_usuario` int(11) NOT NULL,
-  `cedula_operario` int(11) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+  `cedula_usuario` int(11) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+
+--
+-- Volcado de datos para la tabla `reserva`
+--
+
+INSERT INTO `reserva` (`idReserva`, `idPelicula`, `cedula_usuario`) VALUES
+(3, 3, 12622023),
+(5, 1, 12622023);
 
 -- --------------------------------------------------------
 


INSERT INTO `usuario` (`cedula`, `nombre`, `apellido`, `telefono`, `password`, `tipo`) VALUES
(100100, 'John', 'Doe', '4555555', '1234', 'admin'),
(324559696, 'Kakaroto', 'Mondo', '4220808', '1234', 'cliente');

-- --------------------------------------------------------

--

CREATE TABLE IF NOT EXISTS `ticket` (
`idTicket` int(11) NOT NULL,
  `idReserva` int(11) NOT NULL,
  `precio` double NOT NULL DEFAULT '10000'
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `ticket`
--

INSERT INTO `ticket` (`idTicket`, `idReserva`, `precio`) VALUES
(1, 3, 10000),
(2, 3, 10000),
(3, 3, 10000),
(4, 3, 10000),
(5, 3, 10000),
(30, 4, 10000),
(31, 4, 10000),
(32, 4, 10000),
(33, 4, 10000),
(34, 4, 10000),
(35, 4, 10000),
(36, 4, 10000),
(37, 4, 10000),
(38, 5, 10000),
(39, 5, 10000),
(40, 5, 10000),
(41, 5, 10000),
(42, 5, 10000),
(43, 5, 10000);

-- --------------------------------------------------------

