Microsoft Windows [Versión 10.0.26100.4061]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\Yeison>cd/xampp/mysql/bin

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (10061)

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.32-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> source C:\xampp\inventario2.sql
Query OK, 0 rows affected (0.003 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 1 row affected (0.003 sec)

Database changed
Query OK, 0 rows affected (0.039 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.004 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.027 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 5 rows affected (0.002 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.025 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.003 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.025 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 5 rows affected (0.002 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.012 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 11 rows affected (0.003 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.026 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 10 rows affected (0.009 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

MariaDB [inventario]> show tables;
+----------------------+
| Tables_in_inventario |
+----------------------+
| cliente              |
| detalles_pedido      |
| detalles_venta       |
| pedidos_proveedores  |
| producto             |
| proveedores          |
| venta                |
+----------------------+
7 rows in set (0.009 sec)

MariaDB [inventario]> describe cliente;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_cliente | varchar(20) | NO   | PRI | NULL    |       |
| Nombre     | varchar(45) | NO   |     | NULL    |       |
| Telefono   | varchar(45) | NO   |     | NULL    |       |
| Ciudad     | varchar(45) | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.027 sec)

MariaDB [inventario]> describe detalles_pedido;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_detallePedi  | varchar(20) | NO   | PRI | NULL    |       |
| Nombre          | varchar(45) | NO   |     | NULL    |       |
| camtidad_pedido | int(45)     | NO   |     | NULL    |       |
| Precio_compra   | int(45)     | NO   |     | NULL    |       |
| FK_pedidoProve  | varchar(20) | NO   | MUL | NULL    |       |
| FK_produto      | varchar(20) | NO   | MUL | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
6 rows in set (0.022 sec)

MariaDB [inventario]> describe detalles_venta;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| id_detalleVent   | varchar(20) | NO   | PRI | NULL    |       |
| Cantidad_vendida | int(45)     | NO   |     | NULL    |       |
| FK_venta         | varchar(20) | NO   | MUL | NULL    |       |
| FK_producto      | varchar(20) | NO   | MUL | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
4 rows in set (0.025 sec)

MariaDB [inventario]> describe pedidos_provedores;
ERROR 1146 (42S02): Table 'inventario.pedidos_provedores' doesn't exist
MariaDB [inventario]> describe pedidos_proveedores;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_pedidoProve | varchar(20) | NO   | PRI | NULL    |       |
| Fecha          | varchar(45) | NO   |     | NULL    |       |
| FK_proveedor   | varchar(20) | NO   | MUL | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
3 rows in set (0.025 sec)

MariaDB [inventario]> describe producto;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_producto  | varchar(20) | NO   | PRI | NULL    |       |
| Nombre       | varchar(45) | NO   |     | NULL    |       |
| Precio_costo | int(45)     | NO   |     | NULL    |       |
| Precio_venta | int(45)     | NO   |     | NULL    |       |
| Disponible   | int(45)     | NO   |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
5 rows in set (0.020 sec)

MariaDB [inventario]> describe proveedores;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| id_proveedor | varchar(20) | NO   | PRI | NULL    |       |
| Nombre       | varchar(45) | NO   |     | NULL    |       |
| Telefono     | varchar(45) | NO   |     | NULL    |       |
| Ciudad       | varchar(45) | NO   |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.030 sec)

MariaDB [inventario]> describe venta;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_venta   | varchar(20) | NO   | PRI | NULL    |       |
| Fecha      | varchar(45) | NO   |     | NULL    |       |
| FK_cliente | varchar(20) | NO   | MUL | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.022 sec)

MariaDB [inventario]> select * from cliente;
+------------+-----------------+------------+--------------+
| id_cliente | Nombre          | Telefono   | Ciudad       |
+------------+-----------------+------------+--------------+
| C001       | Juan Perez      | 3111234567 | Medellin     |
| C002       | Ana Martinez    | 3122345678 | Bogota       |
| C003       | Carlos Gomez    | 3133456789 | Cali         |
| C004       | Laura Rodriguez | 3144567890 | Barranquilla |
| C005       | Luis Fernandez  | 3155678901 | Medellin     |
| C006       | Marta Suarez    | 3166789012 | Medellin     |
| C007       | David Ramirez   | 3177890123 | Bogota       |
| C008       | Gloria Ortiz    | 3188901234 | Santa Marta  |
| C009       | Rosa Morales    | 3199012345 | Cali         |
| C010       | Pedro Rios      | 3100123456 | Medellin     |
+------------+-----------------+------------+--------------+
10 rows in set (0.002 sec)

MariaDB [inventario]> select * from detalles_pedido;
+----------------+---------------------+-----------------+---------------+----------------+------------+
| id_detallePedi | Nombre              | camtidad_pedido | Precio_compra | FK_pedidoProve | FK_produto |
+----------------+---------------------+-----------------+---------------+----------------+------------+
| DP001          | Refrigerador Grande |              10 |       1400000 | PP001          | P001       |
| DP002          | Lavadora Compacta   |              15 |       1150000 | PP002          | P002       |
| DP003          | Microondas Digital  |              20 |        290000 | PP003          | P003       |
| DP004          | Horno Electrico     |              25 |        680000 | PP004          | P004       |
| DP005          | Licuadora Potente   |              30 |        145000 | PP005          | P005       |
+----------------+---------------------+-----------------+---------------+----------------+------------+
5 rows in set (0.001 sec)

MariaDB [inventario]> select * from detalles_venta;
+----------------+------------------+----------+-------------+
| id_detalleVent | Cantidad_vendida | FK_venta | FK_producto |
+----------------+------------------+----------+-------------+
| DV001          |                2 | V001     | P001        |
| DV002          |                1 | V002     | P002        |
| DV003          |                3 | V003     | P003        |
| DV004          |                2 | V004     | P004        |
| DV005          |                1 | V005     | P005        |
| DV006          |                2 | V006     | P006        |
| DV007          |                1 | V007     | P007        |
| DV008          |                4 | V008     | P008        |
| DV009          |                2 | V009     | P009        |
| DV010          |                3 | V010     | P010        |
+----------------+------------------+----------+-------------+
10 rows in set (0.001 sec)

MariaDB [inventario]> select * from pedidos_proveedores;
+----------------+------------+--------------+
| id_pedidoProve | Fecha      | FK_proveedor |
+----------------+------------+--------------+
| PP001          | 2024-10-01 | PR001        |
| PP002          | 2024-10-02 | PR002        |
| PP003          | 2024-10-03 | PR003        |
| PP004          | 2024-10-04 | PR004        |
| PP005          | 2024-10-05 | PR005        |
+----------------+------------+--------------+
5 rows in set (0.001 sec)

MariaDB [inventario]> select * from producto;
+-------------+----------------------+--------------+--------------+------------+
| id_producto | Nombre               | Precio_costo | Precio_venta | Disponible |
+-------------+----------------------+--------------+--------------+------------+
| P001        | Refrigerador         |      1500000 |            0 |         50 |
| P0011       |  Refrigerador Toyota |      2000000 |            0 |          0 |
| P002        | Lavadora             |      1200000 |            0 |         30 |
| P003        | Microondas           |       300000 |            0 |        100 |
| P004        | Horno                |       700000 |            0 |         60 |
| P005        | Licuadora            |       150000 |            0 |        200 |
| P006        | Aspiradora           |       500000 |            0 |         80 |
| P007        | Televisor            |      2000000 |            0 |         40 |
| P008        | Ventilador           |        80000 |            0 |        150 |
| P009        | Cafetera             |       120000 |            0 |        120 |
| P010        | Plancha              |        90000 |            0 |         70 |
+-------------+----------------------+--------------+--------------+------------+
11 rows in set (0.001 sec)

MariaDB [inventario]> select * from proveedores;
+--------------+----------------------+------------+--------------+
| id_proveedor | Nombre               | Telefono   | Ciudad       |
+--------------+----------------------+------------+--------------+
| PR001        | ElectroHouse         | 3001234567 | Medellin     |
| PR002        | MegaElectro          | 3012345678 | Bogota       |
| PR003        | HogarPlus            | 3023456789 | Cali         |
| PR004        | TecnoElectro         | 3034567890 | Barranquilla |
| PR005        | ElectroCenter        | 3045678901 | Cartagena    |
| PR006        | HomeElectronics      | 3056789012 | Pereira      |
| PR007        | TotalElectro         | 3067890123 | Bucaramanga  |
| PR008        | ElectroService       | 3078901234 | Santa Marta  |
| PR009        | ElectroDistribuidora | 3089012345 | Manizales    |
| PR010        | ElectroTienda        | 3090123456 | Ibagué       |
+--------------+----------------------+------------+--------------+
10 rows in set (0.001 sec)

MariaDB [inventario]> select * from venta;
+----------+------------+------------+
| id_venta | Fecha      | FK_cliente |
+----------+------------+------------+
| V001     | 2024-10-15 | C001       |
| V002     | 2024-10-16 | C002       |
| V003     | 2024-10-17 | C003       |
| V004     | 2024-10-18 | C004       |
| V005     | 2024-10-19 | C005       |
| V006     | 2024-10-20 | C006       |
| V007     | 2024-10-21 | C007       |
| V008     | 2024-10-22 | C008       |
| V009     | 2024-10-23 | C009       |
| V010     | 2024-10-24 | C010       |
+----------+------------+------------+
10 rows in set (0.001 sec)

MariaDB [inventario]> CREATE TABLE devoluciones (
    ->     id_devolucion VARCHAR(20) PRIMARY KEY,
    ->     Fecha DATE NOT NULL,
    ->     Motivo ENUM('defectuoso', 'equivocacion', 'insatisfaccion', 'otros') NOT NULL,
    ->     Estado ENUM('pendiente', 'aprobada', 'rechazada', 'procesada') NOT NULL,
    ->     FK_venta VARCHAR(20) NOT NULL,
    ->     Comentarios TEXT,
    ->     Evidencia BLOB,
    ->     FOREIGN KEY (FK_venta) REFERENCES venta(id_venta) ON DELETE CASCADE
    -> );
Query OK, 0 rows affected (0.073 sec)

MariaDB [inventario]> CREATE TABLE detalles_devolucion (
    ->     id_detalle_dev VARCHAR(20) PRIMARY KEY,
    ->     Cantidad INT NOT NULL,
    ->     FK_devolucion VARCHAR(20) NOT NULL,
    ->     FK_producto VARCHAR(20) NOT NULL,
    ->     FOREIGN KEY (FK_devolucion) REFERENCES devoluciones(id_devolucion) ON DELETE CASCADE,
    ->     FOREIGN KEY (FK_producto) REFERENCES producto(id_producto) ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.034 sec)

MariaDB [inventario]> CREATE TABLE inventario_historico (
    ->     id_registro INT AUTO_INCREMENT PRIMARY KEY,
    ->     fecha TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    ->     FK_producto VARCHAR(20) NOT NULL,
    ->     cambio_cantidad INT NOT NULL,
    ->     tipo_movimiento ENUM('compra', 'venta', 'devolucion', 'ajuste') NOT NULL,
    ->     origen_movimiento VARCHAR(20),
    ->     FOREIGN KEY (FK_producto) REFERENCES producto(id_producto) ON DELETE CASCADE
    -> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.042 sec)

MariaDB [inventario]> CREATE TABLE alertas_inventario (
    ->     id_alerta INT AUTO_INCREMENT PRIMARY KEY,
    ->     FK_producto VARCHAR(20) NOT NULL,
    ->     Tipo_alerta ENUM('stock_minimo', 'stock_sobrante', 'sin_movimiento') NOT NULL,
    ->     Fecha DATE NOT NULL,
    ->     Leida BOOLEAN DEFAULT FALSE,
    ->     FOREIGN KEY (FK_producto) REFERENCES producto(id_producto) ON DELETE CASCADE
    -> );
Query OK, 0 rows affected (0.036 sec)

MariaDB [inventario]> ALTER TABLE producto
    -> ADD COLUMN stock_minimo INT NOT NULL DEFAULT 10 AFTER Disponible,
    -> ADD COLUMN stock_maximo INT AFTER stock_minimo,
    -> ADD COLUMN imagen BLOB,
    -> ADD COLUMN activo BOOLEAN DEFAULT TRUE;
Query OK, 0 rows affected (0.014 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [inventario]> select * from producto;
+-------------+----------------------+--------------+--------------+------------+--------------+--------------+--------+--------+
| id_producto | Nombre               | Precio_costo | Precio_venta | Disponible | stock_minimo | stock_maximo | imagen | activo |
+-------------+----------------------+--------------+--------------+------------+--------------+--------------+--------+--------+
| P001        | Refrigerador         |      1500000 |            0 |         50 |           10 |         NULL | NULL   |      1 |
| P0011       |  Refrigerador Toyota |      2000000 |            0 |          0 |           10 |         NULL | NULL   |      1 |
| P002        | Lavadora             |      1200000 |            0 |         30 |           10 |         NULL | NULL   |      1 |
| P003        | Microondas           |       300000 |            0 |        100 |           10 |         NULL | NULL   |      1 |
| P004        | Horno                |       700000 |            0 |         60 |           10 |         NULL | NULL   |      1 |
| P005        | Licuadora            |       150000 |            0 |        200 |           10 |         NULL | NULL   |      1 |
| P006        | Aspiradora           |       500000 |            0 |         80 |           10 |         NULL | NULL   |      1 |
| P007        | Televisor            |      2000000 |            0 |         40 |           10 |         NULL | NULL   |      1 |
| P008        | Ventilador           |        80000 |            0 |        150 |           10 |         NULL | NULL   |      1 |
| P009        | Cafetera             |       120000 |            0 |        120 |           10 |         NULL | NULL   |      1 |
| P010        | Plancha              |        90000 |            0 |         70 |           10 |         NULL | NULL   |      1 |
+-------------+----------------------+--------------+--------------+------------+--------------+--------------+--------+--------+
11 rows in set (0.008 sec)

MariaDB [inventario]> INSERT INTO devoluciones (id_devolucion, Fecha, Motivo, Estado, FK_venta, Comentarios) VALUES
    -> ('DEV001', '2024-10-25', 'defectuoso', 'procesada', 'V001', 'Refrigerador con falla en el compresor'),
    -> ('DEV002', '2024-10-26', 'equivocacion', 'aprobada', 'V002', 'Cliente pidió modelo equivocado'),
    -> ('DEV003', '2024-10-27', 'insatisfaccion', 'pendiente', 'V003', 'Microondas no cumplió expectativas'),
    -> ('DEV004', '2024-10-28', 'otros', 'rechazada', 'V004', 'Devolución sin justificación válida'),
    -> ('DEV005', '2024-10-29', 'defectuoso', 'procesada', 'V005', 'Licuadora con fuga en la base'),
    -> ('DEV006', '2024-10-30', 'equivocacion', 'aprobada', 'V006', 'Color no coincidió'),
    -> ('DEV007', '2024-10-31', 'defectuoso', 'pendiente', 'V007', 'TV con pixeles muertos'),
    -> ('DEV008', '2024-11-01', 'insatisfaccion', 'aprobada', 'V008', 'Ventilador muy ruidoso'),
    -> ('DEV009', '2024-11-02', 'otros', 'rechazada', 'V009', 'Cafetera usada devuelta'),
    -> ('DEV010', '2024-11-03', 'defectuoso', 'procesada', 'V010', 'Plancha no calienta');
Query OK, 10 rows affected (0.008 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [inventario]> select * from devuluciones;
ERROR 1146 (42S02): Table 'inventario.devuluciones' doesn't exist
MariaDB [inventario]> select * from devoluciones;
+---------------+------------+----------------+-----------+----------+----------------------------------------+-----------+
| id_devolucion | Fecha      | Motivo         | Estado    | FK_venta | Comentarios                            | Evidencia |
+---------------+------------+----------------+-----------+----------+----------------------------------------+-----------+
| DEV001        | 2024-10-25 | defectuoso     | procesada | V001     | Refrigerador con falla en el compresor | NULL      |
| DEV002        | 2024-10-26 | equivocacion   | aprobada  | V002     | Cliente pidió modelo equivocado        | NULL      |
| DEV003        | 2024-10-27 | insatisfaccion | pendiente | V003     | Microondas no cumplió expectativas     | NULL      |
| DEV004        | 2024-10-28 | otros          | rechazada | V004     | Devolución sin justificación válida    | NULL      |
| DEV005        | 2024-10-29 | defectuoso     | procesada | V005     | Licuadora con fuga en la base          | NULL      |
| DEV006        | 2024-10-30 | equivocacion   | aprobada  | V006     | Color no coincidió                     | NULL      |
| DEV007        | 2024-10-31 | defectuoso     | pendiente | V007     | TV con pixeles muertos                 | NULL      |
| DEV008        | 2024-11-01 | insatisfaccion | aprobada  | V008     | Ventilador muy ruidoso                 | NULL      |
| DEV009        | 2024-11-02 | otros          | rechazada | V009     | Cafetera usada devuelta                | NULL      |
| DEV010        | 2024-11-03 | defectuoso     | procesada | V010     | Plancha no calienta                    | NULL      |
+---------------+------------+----------------+-----------+----------+----------------------------------------+-----------+
10 rows in set (0.001 sec)

MariaDB [inventario]> INSERT INTO detalles_devolucion (id_detalle_dev, Cantidad, FK_devolucion, FK_producto) VALUES
    -> ('DD001', 1, 'DEV001', 'P001'),
    -> ('DD002', 1, 'DEV002', 'P002'),
    -> ('DD003', 1, 'DEV003', 'P003'),
    -> ('DD004', 1, 'DEV004', 'P004'),
    -> ('DD005', 1, 'DEV005', 'P005'),
    -> ('DD006', 1, 'DEV006', 'P006'),
    -> ('DD007', 1, 'DEV007', 'P007'),
    -> ('DD008', 1, 'DEV008', 'P008'),
    -> ('DD009', 1, 'DEV009', 'P009'),
    -> ('DD010', 1, 'DEV010', 'P010');
Query OK, 10 rows affected (0.006 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [inventario]> select * from detalles_devolucion;
+----------------+----------+---------------+-------------+
| id_detalle_dev | Cantidad | FK_devolucion | FK_producto |
+----------------+----------+---------------+-------------+
| DD001          |        1 | DEV001        | P001        |
| DD002          |        1 | DEV002        | P002        |
| DD003          |        1 | DEV003        | P003        |
| DD004          |        1 | DEV004        | P004        |
| DD005          |        1 | DEV005        | P005        |
| DD006          |        1 | DEV006        | P006        |
| DD007          |        1 | DEV007        | P007        |
| DD008          |        1 | DEV008        | P008        |
| DD009          |        1 | DEV009        | P009        |
| DD010          |        1 | DEV010        | P010        |
+----------------+----------+---------------+-------------+
10 rows in set (0.002 sec)

MariaDB [inventario]> INSERT INTO inventario_historico (fecha, FK_producto, cambio_cantidad, tipo_movimiento, origen_movimiento) VALUES
    -> ('2024-10-25 10:00:00', 'P001', -2, 'venta', 'V001'),
    -> ('2024-10-25 11:30:00', 'P002', -1, 'venta', 'V002'),
    -> ('2024-10-26 09:15:00', 'P003', -3, 'venta', 'V003'),
    -> ('2024-10-26 14:00:00', 'P004', 25, 'compra', 'PP004'),
    -> ('2024-10-27 10:30:00', 'P005', 30, 'compra', 'PP005'),
    -> ('2024-10-28 16:45:00', 'P001', 1, 'devolucion', 'DEV001'),
    -> ('2024-10-29 12:00:00', 'P002', 1, 'devolucion', 'DEV002'),
    -> ('2024-10-30 10:20:00', 'P006', -2, 'venta', 'V006'),
    -> ('2024-10-31 11:10:00', 'P007', -1, 'venta', 'V007'),
    -> ('2024-11-01 15:30:00', 'P008', 5, 'ajuste', NULL);
Query OK, 10 rows affected (0.007 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [inventario]> select * from inventario_historico;
+-------------+---------------------+-------------+-----------------+-----------------+-------------------+
| id_registro | fecha               | FK_producto | cambio_cantidad | tipo_movimiento | origen_movimiento |
+-------------+---------------------+-------------+-----------------+-----------------+-------------------+
|           1 | 2024-10-25 10:00:00 | P001        |              -2 | venta           | V001              |
|           2 | 2024-10-25 11:30:00 | P002        |              -1 | venta           | V002              |
|           3 | 2024-10-26 09:15:00 | P003        |              -3 | venta           | V003              |
|           4 | 2024-10-26 14:00:00 | P004        |              25 | compra          | PP004             |
|           5 | 2024-10-27 10:30:00 | P005        |              30 | compra          | PP005             |
|           6 | 2024-10-28 16:45:00 | P001        |               1 | devolucion      | DEV001            |
|           7 | 2024-10-29 12:00:00 | P002        |               1 | devolucion      | DEV002            |
|           8 | 2024-10-30 10:20:00 | P006        |              -2 | venta           | V006              |
|           9 | 2024-10-31 11:10:00 | P007        |              -1 | venta           | V007              |
|          10 | 2024-11-01 15:30:00 | P008        |               5 | ajuste          | NULL              |
+-------------+---------------------+-------------+-----------------+-----------------+-------------------+
10 rows in set (0.001 sec)

MariaDB [inventario]> INSERT INTO alertas_inventario (FK_producto, Tipo_alerta, Fecha, Leida) VALUES
    -> ('P001', 'stock_minimo', '2024-10-25', FALSE),
    -> ('P003', 'stock_minimo', '2024-10-26', TRUE),
    -> ('P007', 'stock_minimo', '2024-10-28', FALSE),
    -> ('P010', 'stock_minimo', '2024-10-30', TRUE),
    -> ('P002', 'sin_movimiento', '2024-10-27', FALSE),
    -> ('P005', 'stock_sobrante', '2024-10-29', FALSE),
    -> ('P008', 'stock_minimo', '2024-11-01', FALSE),
    -> ('P004', 'sin_movimiento', '2024-10-31', TRUE),
    -> ('P006', 'stock_minimo', '2024-11-02', FALSE),
    -> ('P009', 'stock_sobrante', '2024-11-03', FALSE);
Query OK, 10 rows affected (0.008 sec)
Records: 10  Duplicates: 0  Warnings: 0

MariaDB [inventario]> select * from alertas_inventario;
+-----------+-------------+----------------+------------+-------+
| id_alerta | FK_producto | Tipo_alerta    | Fecha      | Leida |
+-----------+-------------+----------------+------------+-------+
|         1 | P001        | stock_minimo   | 2024-10-25 |     0 |
|         2 | P003        | stock_minimo   | 2024-10-26 |     1 |
|         3 | P007        | stock_minimo   | 2024-10-28 |     0 |
|         4 | P010        | stock_minimo   | 2024-10-30 |     1 |
|         5 | P002        | sin_movimiento | 2024-10-27 |     0 |
|         6 | P005        | stock_sobrante | 2024-10-29 |     0 |
|         7 | P008        | stock_minimo   | 2024-11-01 |     0 |
|         8 | P004        | sin_movimiento | 2024-10-31 |     1 |
|         9 | P006        | stock_minimo   | 2024-11-02 |     0 |
|        10 | P009        | stock_sobrante | 2024-11-03 |     0 |
+-----------+-------------+----------------+------------+-------+
10 rows in set (0.001 sec)

MariaDB [inventario]>