-- USE domiti_accetto;
INSERT INTO `users` (`name`,`last_name`,`email`,`phone`,`password`,`status`)
VALUES
    ('Marco','Velasco','smark.v.p@gmail.com','333-633-8748','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Admin','Admin','admin@admin.com','333-633-8748','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Joel','Martinez','joel2506@outlook.es','333-633-8748','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Manuel','Delgado','manuel1592@hotmail.com','333-503-3822','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Ruby','Gomez','ruby@gmail.es','333-167-2179','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Guillermo','Duran','guillermo6135@outlook.com','333-062-8299','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Manuel','Herrera','manuel5546@gmail.es','333-416-0370','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Esmeralda','Alvarez','esmeralda@outlook.com','333-350-2830','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Alondra','Marti','alondra9399@outlook.es','333-962-7145','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Esmeralda','Gutierrez','esmeralda285@gmail.com','333-838-6314','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Rodrigo','Ferrer','rodrigo@outlook.es','333-913-5246','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Alondra','Diez','alondra@outlook.es','333-771-2523','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1);
INSERT INTO `users` (`name`,`last_name`,`email`,`phone`,`password`,`status`)
VALUES
    ('Maria','Soto','maria8260@hotmail.com','333-427-1616','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Guillermo','Campos','guillermo9669@gmail.es','333-611-0444','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Alondra','Morales','alondra1@outlook.com','333-274-7434','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Guillermo','Gimenez','guillermo9933@outlook.com','333-934-5339','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Joel','Hernandez','joel1@outlook.com','333-790-1415','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Daniela','Ramirez','daniela6112@gmail.com','333-497-7254','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Ruby','Vicente','ruby@hotmail.es','333-874-2341','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Alondra','Medina','alondra2917@outlook.es','333-902-4371','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Guillermo','Prieto','guillermo@hotmail.com','333-316-6701','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Alondra','Calvo','alondra@outlook.com','333-846-5746','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1);
INSERT INTO `users` (`name`,`last_name`,`email`,`phone`,`password`,`status`)
VALUES
    ('Rodrigo','Iglesias','rodrigo7515@gmail.es','333-150-3723','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Guillermo','Leon','guillermo3213@hotmail.com','333-458-0433','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Maria','Gallego','maria3975@outlook.com','333-323-8601','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Johana','Garrido','johana@outlook.es','333-247-9774','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Manuel','Vazquez','manuel9017@outlook.com','333-875-1732','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Jorge','Ortega','jorge@gmail.es','333-345-6036','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Jorge','Aguilar','jorge3817@outlook.com','333-195-1162','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Daniel','Dominguez','daniel@hotmail.com','333-484-7854','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Esmeralda','ﾑez','esmeralda@hotmail.es','333-894-4632','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Jorge','Romero','jorge6954@outlook.com','333-903-5975','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1);
INSERT INTO `users` (`name`,`last_name`,`email`,`phone`,`password`,`status`)
VALUES
    ('Manuel','Martinez','manuel7501@gmail.es','333-112-3568','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Guillermo','Dominguez','guillermo2394@outlook.com','333-316-4122','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Maria','Ferrer','maria@gmail.es','333-376-2627','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Maria','Vidal','maria@hotmail.com','333-724-3110','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1),
    ('Joel','Pastor','joel@outlook.com','333-519-7879','$2y$10$RJcs9I0vyqk12l0se8YFR.S/KSq7xMMCUn.sYZu.pWiil/NZyFxl.',1);

INSERT INTO `properties` (`type`,`name`,`address`,`property_number`,`id_user`)
VALUES
    ('Hotel','Los olivos','C. Narciso Serradel Sevilla, San Miguel de Huentitán, 44300 Guadalajara, Jal.',1229,1),
    ('Coto','El fresno','Ostia 2782, Providencia 2a. Secc, 44648 Guadalajara, Jal.',2504,1),
    ('Coto','El fresno','C. San Florencio 1980, Colomos Patria, 45110 Zapopan, Jal.',1853,1),
    ('Hotel','Palmares','La Pradera 17, Royal Country, 45116 Zapopan, Jal.',1998,2),
    ('Coto','Santa Anita','Ostia 2782, Providencia 2a. Secc, 44648 Guadalajara, Jal.',2192,2);

INSERT INTO `residence` (`address`,`number`,`id_property`,`status`,created_at,updated_at)
VALUES
    ('Calle Guadalajara',8,4,'1',NOW(),NOW()),
    ('Avenida Monterrey',4,2,'1',NOW(),NOW()),
    ('Avenida principal',2,2,'1',NOW(),NOW()),
    ('Morelos',5,5,'1',NOW(),NOW()),
    ('Avenida Tlaxcala',6,2,'1',NOW(),NOW()),
    ('Avenida Tlaxcala',1,3,'1',NOW(),NOW()),
    ('Hidalgo',7,1,'1',NOW(),NOW()),
    ('Calle madero',4,5,'1',NOW(),NOW()),
    ('Calle madero',3,2,'1',NOW(),NOW()),
    ('Hidalgo',1,3,'1',NOW(),NOW());
INSERT INTO `residence` (`address`,`number`,`id_property`,`status`,created_at,updated_at)
VALUES
    ('Calle madero',8,1,'1',NOW(),NOW()),
    ('Avenida Monterrey',5,3,'1',NOW(),NOW()),
    ('Calle madero',6,3,'1',NOW(),NOW()),
    ('Calle Talpa',9,2,'1',NOW(),NOW()),
    ('Avenida Monterrey',3,4,'1',NOW(),NOW()),
    ('Avenida Monterrey',6,3,'1',NOW(),NOW()),
    ('Avenida Monterrey',2,1,'1',NOW(),NOW()),
    ('Calle Guadalajara',9,4,'1',NOW(),NOW()),
    ('Salto del agua',8,5,'1',NOW(),NOW()),
    ('Calle Talpa',9,1,'1',NOW(),NOW());
INSERT INTO `residence` (`address`,`number`,`id_property`,`status`,created_at,updated_at)
VALUES
    ('Avenida Monterrey',7,4,'1',NOW(),NOW()),
    ('Salto del agua',2,3,'1',NOW(),NOW()),
    ('Calle Guadalajara',7,4,'1',NOW(),NOW()),
    ('Avenida Monterrey',2,2,'1',NOW(),NOW()),
    ('Hidalgo',3,3,'1',NOW(),NOW()),
    ('Calle Guadalajara',5,4,'1',NOW(),NOW()),
    ('Avenida Monterrey',3,3,'1',NOW(),NOW()),
    ('Calle madero',6,2,'1',NOW(),NOW()),
    ('Salto del agua',7,2,'1',NOW(),NOW()),
    ('Calle Talpa',6,4,'1',NOW(),NOW());
INSERT INTO `residence` (`address`,`number`,`id_property`,`status`,created_at,updated_at)
VALUES
    ('Calle madero',2,2,'1',NOW(),NOW()),
    ('Calle Guadalajara',6,3,'1',NOW(),NOW()),
    ('Hidalgo',6,1,'1',NOW(),NOW()),
    ('Calle Talpa',1,2,'1',NOW(),NOW()),
    ('Calle Guadalajara',2,2,'1',NOW(),NOW()),
    ('Avenida Tlaxcala',6,1,'1',NOW(),NOW()),
    ('Morelos',9,3,'1',NOW(),NOW()),
    ('Avenida Monterrey',9,4,'1',NOW(),NOW()),
    ('Avenida Monterrey',8,4,'1',NOW(),NOW()),
    ('Calle Talpa',10,2,'1',NOW(),NOW());
INSERT INTO `residence` (`address`,`number`,`id_property`,`status`,created_at,updated_at)
VALUES
    ('Morelos',3,5,'1',NOW(),NOW()),
    ('Avenida Monterrey',9,5,'1',NOW(),NOW()),
    ('Morelos',9,3,'1',NOW(),NOW()),
    ('Salto del agua',2,2,'1',NOW(),NOW()),
    ('Calle Talpa',6,2,'1',NOW(),NOW()),
    ('Salto del agua',7,1,'1',NOW(),NOW()),
    ('Camino del monte',7,2,'1',NOW(),NOW()),
    ('Calle Guadalajara',2,2,'1',NOW(),NOW()),
    ('Camino del monte',2,3,'1',NOW(),NOW()),
    ('Avenida Monterrey',10,5,'1',NOW(),NOW());