CREATE TABLE `propietarios` (
`id_Propietario_tabla` int(6) NOT NULL,
`id_propietario` int(6) NOT NULL,
`nombre` varchar(25) COLLATE utf8_spanish_ci NOT NULL,
`apellido` varchar(25) COLLATE utf8_spanish_ci NOT NULL,
`telefono` varchar(25) COLLATE utf8_spanish_ci NOT NULL,
`dni` varchar(11) COLLATE utf8_spanish_ci NOT NULL,
`cuit` int(12) NOT NULL,
`direccion` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`email` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`fecha_nac` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
CREATE TABLE `cuotas` (
`id_cuota` int(6) NOT NULL,
`id_lote` int(5) NOT NULL,
`cuota` int(2) NOT NULL,
`fecha_vencimiento` date NOT NULL,
`estado` int(1) NOT NULL,
`pago` date NOT NULL,
`modo` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
`recibo` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
`comentario` varchar(20) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
INSERT INTO `cuotas` (`id_cuota`, `id_lote`, `cuota`, `fecha_vencimiento`, `estado`, `pago`, `modo`, `recibo`, `comentario`) VALUES
(1, 10811, 1, '2018-04-02', 5, '0000-00-00', '-', '-', '-'),
(2, 10811, 2, '2018-05-02', 5, '0000-00-00', '-', '-', '-'),
(3, 10811, 3, '2018-06-02', 5, '0000-00-00', '-', '-', '-'),
(4, 10811, 4, '2018-07-02', 5, '0000-00-00', '-', '-', '-'),
(5, 10811, 5, '2018-08-02', 5, '0000-00-00', '-', '-', '-'),
(6, 10811, 6, '2018-09-02', 3, '0000-00-00', '-', '-', '-'),
(7, 10811, 7, '2018-10-02', 3, '0000-00-00', '-', '-', '-'),
(8, 10811, 8, '2018-11-02', 3, '0000-00-00', '-', '-', '-'),
(9, 10811, 9, '2018-12-02', 3, '0000-00-00', '-', '-', '-'),
(10, 10811, 10, '2019-01-02', 3, '0000-00-00', '-', '-', '-'),
(11, 10811, 11, '2019-02-02', 3, '0000-00-00', '-', '-', '-'),
(12, 10811, 12, '2019-03-02', 3, '0000-00-00', '-', '-', '-'),
(13, 10811, 13, '2019-04-02', 3, '0000-00-00', '-', '-', '-'),
(14, 10811, 14, '2019-05-02', 3, '0000-00-00', '-', '-', '-'),
(15, 10811, 15, '2019-06-02', 3, '0000-00-00', '-', '-', '-'),
(16, 10811, 16, '2019-07-02', 3, '0000-00-00', '-', '-', '-'),
(17, 10811, 17, '2019-08-02', 3, '0000-00-00', '-', '-', '-'),
(18, 10811, 18, '2019-09-02', 3, '0000-00-00', '-', '-', '-'),
(19, 10811, 19, '2019-10-02', 3, '0000-00-00', '-', '-', '-'),
(20, 10811, 20, '2019-11-02', 3, '0000-00-00', '-', '-', '-'),
(21, 10811, 21, '2019-12-02', 3, '0000-00-00', '-', '-', '-'),
(22, 10811, 22, '2020-01-02', 3, '0000-00-00', '-', '-', '-'),
(23, 10811, 23, '2020-02-02', 3, '0000-00-00', '-', '-', '-'),
(24, 10811, 24, '2020-03-02', 3, '0000-00-00', '-', '-', '-'),
(25, 10811, 25, '2020-04-02', 3, '0000-00-00', '-', '-', '-'),
(26, 10811, 26, '2020-05-02', 3, '0000-00-00', '-', '-', '-'),
(27, 10811, 27, '2020-06-02', 3, '0000-00-00', '-', '-', '-'),
(28, 10811, 28, '2020-07-02', 3, '0000-00-00', '-', '-', '-'),
(29, 10811, 29, '2020-08-02', 3, '0000-00-00', '-', '-', '-'),
(30, 10811, 30, '2020-09-02', 3, '0000-00-00', '-', '-', '-'),
(31, 10811, 31, '2020-10-02', 3, '0000-00-00', '-', '-', '-'),
(32, 10811, 32, '2020-11-02', 3, '0000-00-00', '-', '-', '-'),
(33, 10811, 33, '2020-12-02', 3, '0000-00-00', '-', '-', '-'),
(34, 10811, 34, '2021-01-02', 3, '0000-00-00', '-', '-', '-'),
(35, 10811, 35, '2021-02-02', 3, '0000-00-00', '-', '-', '-'),
(36, 10811, 36, '2021-03-02', 3, '0000-00-00', '-', '-', '-'),
(37, 10811, 37, '2021-04-02', 3, '0000-00-00', '-', '-', '-'),
(38, 10811, 38, '2021-05-02', 3, '0000-00-00', '-', '-', '-'),
(39, 10811, 39, '2021-06-02', 3, '0000-00-00', '-', '-', '-'),
(40, 10811, 40, '2021-07-02', 3, '0000-00-00', '-', '-', '-'),
(41, 10811, 41, '2021-08-02', 3, '0000-00-00', '-', '-', '-'),
(42, 10811, 42, '2021-09-02', 3, '0000-00-00', '-', '-', '-'),
(43, 10811, 43, '2021-10-02', 3, '0000-00-00', '-', '-', '-'),
(44, 10811, 44, '2021-11-02', 3, '0000-00-00', '-', '-', '-'),
(45, 10811, 45, '2021-12-02', 3, '0000-00-00', '-', '-', '-'),
(46, 10811, 46, '2022-01-02', 3, '0000-00-00', '-', '-', '-'),
(47, 10811, 47, '2022-02-02', 3, '0000-00-00', '-', '-', '-'),
(48, 10811, 48, '2022-03-02', 3, '0000-00-00', '-', '-', '-'),
(49, 10811, 49, '2022-04-02', 3, '0000-00-00', '-', '-', '-'),
(50, 10811, 50, '2022-05-02', 3, '0000-00-00', '-', '-', '-'),
(51, 10811, 51, '2022-06-02', 3, '0000-00-00', '-', '-', '-'),
(52, 10811, 52, '2022-07-02', 3, '0000-00-00', '-', '-', '-'),
(53, 10811, 53, '2022-08-02', 3, '0000-00-00', '-', '-', '-'),
(54, 10811, 54, '2022-09-02', 3, '0000-00-00', '-', '-', '-'),
(55, 10811, 55, '2022-10-02', 3, '0000-00-00', '-', '-', '-'),
(56, 10811, 56, '2022-11-02', 3, '0000-00-00', '-', '-', '-'),
(57, 10811, 57, '2022-12-02', 3, '0000-00-00', '-', '-', '-'),
(58, 10811, 58, '2023-01-02', 3, '0000-00-00', '-', '-', '-'),
(59, 10811, 59, '2023-02-02', 3, '0000-00-00', '-', '-', '-'),
(60, 10811, 60, '2023-03-02', 3, '0000-00-00', '-', '-', '-'),
(61, 21111, 1, '2018-09-25', 3, '0000-00-00', '-', '-', '-'),
(62, 21111, 2, '2018-10-25', 3, '0000-00-00', '-', '-', '-'),
(63, 21111, 3, '2018-11-25', 3, '0000-00-00', '-', '-', '-'),
(64, 21111, 4, '2018-12-25', 3, '0000-00-00', '-', '-', '-'),
(65, 21111, 5, '2019-01-25', 3, '0000-00-00', '-', '-', '-'),
(66, 21111, 6, '2019-02-25', 3, '0000-00-00', '-', '-', '-'),
(67, 21111, 7, '2019-03-25', 3, '0000-00-00', '-', '-', '-'),
(68, 21111, 8, '2019-04-25', 3, '0000-00-00', '-', '-', '-'),
(69, 21111, 9, '2019-05-25', 3, '0000-00-00', '-', '-', '-'),
(70, 21111, 10, '2019-06-25', 3, '0000-00-00', '-', '-', '-'),
(71, 21111, 11, '2019-07-25', 3, '0000-00-00', '-', '-', '-'),
(72, 21111, 12, '2019-08-25', 3, '0000-00-00', '-', '-', '-');
INSERT INTO `propietarios` (`id_Propietario_tabla`, `id_propietario`, `nombre`, `apellido`, `telefono`, `dni`, `cuit`, `direccion`, `email`, `fecha_nac`) VALUES
(1, 10811, 'Matias', 'Roldan', '1525142535', '31245987', 31245987, 'Av. Coronel Diaz 1846', 'matias@gmail.com', '1989-03-02'),
(2, 21111, 'Juan', 'Perez', '1547582451', '304587157', 31245987, 'Av. siempre viva 123', 'juanpe@gmail.com', '0080-03-02');