diff options
Diffstat (limited to 'back/sql/20220401dump.sampledata.sql')
| -rw-r--r-- | back/sql/20220401dump.sampledata.sql | 85 |
1 files changed, 0 insertions, 85 deletions
diff --git a/back/sql/20220401dump.sampledata.sql b/back/sql/20220401dump.sampledata.sql deleted file mode 100644 index 5042e32..0000000 --- a/back/sql/20220401dump.sampledata.sql +++ /dev/null @@ -1,85 +0,0 @@ --- Adminer 4.7.9 MySQL dump - -SET NAMES utf8; -SET time_zone = '+00:00'; -SET foreign_key_checks = 0; -SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; - -SET NAMES utf8mb4; - -TRUNCATE `almacen`; -INSERT INTO `almacen` (`id`, `activo`, `ubigeo`, `departamento`, `provincia`, `latitud`, `longitud`, `esPrincipal`, `region_fk`) VALUES -(1, 1, '10201', 'Amazonas', 'Bagua', -5.63906152, -78.53166353, 0, 3), -(2, 1, '40101', 'Arequipa', 'Arequipa', -16.39881421, -71.537019649, 1, 1), -(3, 1, '50901', 'Ayacucho', 'Sucre', -14.01125749, -73.83884087, 0, 2), -(4, 1, '130101', 'La Libertad', 'Trujillo', -8.11176389, -79.02868652, 1, 1), -(5, 1, '150101', 'Lima', 'Lima', -12.04591952, -77.03049615, 1, 1), -(6, 1, '230101', 'Tacna', 'Tacna', -18.0137008, -70.2507964, 0, 1); - -TRUNCATE `averia`; - -TRUNCATE `camion`; -INSERT INTO `camion` (`id`, `activo`, `placa`, `kilometraje`, `estado`, `tipoCamion_fk`) VALUES -(1, 1, 'ETALLIC', 69420, 1, 1); - -TRUNCATE `cliente`; -INSERT INTO `cliente` (`id`, `activo`, `nombreCompleto`, `dni`, `correo`, `telefono`) VALUES -(1, 1, 'EmpresaAAA', '1234567890', 'contacto@empresaAAA.com', '123456789'), -(2, 1, 'EmpresaBBB', '1234567890', 'contacto@empresaBBB.com', '123456789'); - -TRUNCATE `pedido`; -INSERT INTO `pedido` (`id`, `activo`, `fechaPedido`, `cantidad`, `plazoEntrega`, `estado`, `codigoPedido`, `almacen_fk`, `cliente_fk`, `usuario_fk`, `PTG_fk`) VALUES -(2, 1, '2022-01-01 00:00:00', 10, 1, 0, '20220101_000001', 3, 1, 4, NULL); - -TRUNCATE `PTG`; -INSERT INTO `PTG` (`id`, `activo`, `fechaGenerado`, `esSimulacion`, `usuario_fk`) VALUES -(1, 1, '2022-06-01 05:10:47', 1, 1); - -TRUNCATE `region`; -INSERT INTO `region` (`id`, `activo`, `nombre`) VALUES -(1, 1, 'costa'), -(2, 1, 'sierra'), -(3, 1, 'selva'); - -TRUNCATE `rol`; -INSERT INTO `rol` (`id`, `activo`, `nombre`) VALUES -(1, 1, 'superuser'); - -TRUNCATE `ruta`; -INSERT INTO `ruta` (`id`, `activo`, `fechaInicio`, `fechaFin`, `PTG_fk`, `camion_fk`) VALUES -(1, 1, '2022-01-01 00:00:00', '2022-01-02 00:00:00', 1, 1); - -TRUNCATE `tipoAveria`; - -TRUNCATE `tipoCamion`; -INSERT INTO `tipoCamion` (`id`, `activo`, `nombre`, `capacidad`) VALUES -(1, 1, 'tipoA', 90), -(2, 1, 'tipoB', 45), -(3, 1, 'tipoC', 30); - -TRUNCATE `tramo`; -INSERT INTO `tramo` (`id`, `activo`, `distancia`, `estaBloqueado`, `almacen1_fk`, `almacen2_fk`) VALUES -(1, 1, 10, 0, 2, 5), -(2, 1, 10, 0, 3, 5), -(3, 1, 10, 0, 4, 5), -(4, 1, 10, 0, 6, 5), -(5, 1, 20, 0, 1, 4), -(6, 1, 20, 0, 4, 1), -(7, 1, 10, 0, 5, 2), -(8, 1, 10, 0, 5, 3), -(9, 1, 10, 0, 5, 4), -(10, 1, 10, 0, 5, 6); - -TRUNCATE `tramo_ruta`; -INSERT INTO `tramo_ruta` (`id`, `activo`, `orden`, `horaSalidaEst`, `horaLlegadaEst`, `horaSalidaReal`, `horaLlegadaReal`, `paquetesEntregar`, `ruta_fk`, `tramo_fk`) VALUES -(1, 1, 1, '2022-01-01 10:00:00', '2022-01-01 15:00:00', NULL, NULL, 0, 1, 9), -(2, 1, 2, '2022-01-01 16:00:00', '2022-01-01 21:00:00', NULL, NULL, 10, 1, 6); - -TRUNCATE `usuario`; -INSERT INTO `usuario` (`id`, `activo`, `usuario`, `clave`, `nombre`, `apellido`, `dni`, `correo`, `creador_fk`, `rol_fk`) VALUES -(1, 1, 'gabs', '*6AB7931FB2D104A478932D23AF4C7700D1A0C61A', 'Gabriela', 'Hernandez', '12345678', 'gabs@pucp.edu.pe', NULL, 1), -(2, 1, 'dayana', '*D279131EA232308E083B3EA192B78A0C15EA8701', 'Dayana', 'Alarcon', '12345678', 'dayana@pucp.edu.pe', 1, 1), -(3, 1, 'jannina', '*D279131EA232308E083B3EA192B84A0C15EA8701', 'Jannina', 'DeLosGodos', '12345678', 'jannina@pucp.edu.pe', 1, 1), -(4, 1, 'mitsuo', '*D279131EA232308E083B3EA192B74A0C15EA8701', 'Mitsuo', 'Tokumori', '12345678', 'mitsuo@pucp.edu.pe', 1, 1); - --- 2022-06-01 06:13:09 |