MariaDB [(none)]> create database papeleria;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> use papeleria;
Database changed
MariaDB [papeleria]> CREATE TABLE Producto (
    ->     ID_producto VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     Precio_costo INT NOT NULL,
    ->     Precio_venta INT NOT NULL,
    ->     Disponible INT NOT NULL
    -> );
Query OK, 0 rows affected (0.009 sec)

MariaDB [papeleria]> CREATE TABLE Distribuidor (
    ->     ID_distribuidor VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     Telefono VARCHAR(45) NOT NULL,
    ->     Ciudad VARCHAR(45) NOT NULL
    -> );
Query OK, 0 rows affected (0.010 sec)

MariaDB [papeleria]> CREATE TABLE Consumidor (
    ->     ID_consumidor VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     Telefono VARCHAR(45) NOT NULL,
    ->     Ciudad VARCHAR(45) NOT NULL
    -> );
Query OK, 0 rows affected (0.010 sec)

MariaDB [papeleria]> CREATE TABLE Pedidos_Distribuidores (
    ->     ID_pedidodistri VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Fecha VARCHAR(45) NOT NULL,
    ->     FK_distribuidor VARCHAR(20) NOT NULL,
    ->     FOREIGN KEY(FK_distribuidor) REFERENCES Distribuidor(ID_distribuidor) 
    ->     ON DELETE CASCADE ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.021 sec)

MariaDB [papeleria]> CREATE TABLE Detalles_Pedido (
    ->     ID_detallePedi VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     cantidad_pedido INT NOT NULL,
    ->     Precio_compra INT NOT NULL,
    ->     FK_pedidodistri VARCHAR(20) NOT NULL,
    ->     FK_producto VARCHAR(20) NOT NULL,
    ->     FOREIGN KEY(FK_pedidodistri) REFERENCES Pedidos_Distribuidores(ID_pedidodistri)
    ->     ON DELETE CASCADE ON UPDATE CASCADE,
    ->     FOREIGN KEY(FK_producto) REFERENCES Producto(ID_producto)
    ->     ON DELETE CASCADE ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.021 sec)

MariaDB [papeleria]> CREATE TABLE Ventas (
    ->     ID_venta VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Fecha VARCHAR(45) NOT NULL,
    ->     FK_consumidor VARCHAR(20) NOT NULL,
    ->     FOREIGN KEY(FK_consumidor) REFERENCES Consumidor(ID_consumidor)
    ->     ON DELETE CASCADE ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.020 sec)

MariaDB [papeleria]> CREATE TABLE Detalles_Venta (
    ->     ID_detalleVenta VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Cantidad_vendida INT NOT NULL,
    ->     FK_venta VARCHAR(20) NOT NULL,
    ->     FK_producto VARCHAR(20) NOT NULL,
    ->     FOREIGN KEY(FK_venta) REFERENCES Ventas(ID_venta)
    ->     ON DELETE CASCADE ON UPDATE CASCADE,
    ->     FOREIGN KEY(FK_producto) REFERENCES Producto(ID_producto)
    ->     ON DELETE CASCADE ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.032 sec)

MariaDB [papeleria]> CREATE TABLE Categorias (
    ->     ID_categoria VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     Descripcion VARCHAR(100)
    -> );
Query OK, 0 rows affected (0.009 sec)

MariaDB [papeleria]> CREATE TABLE Metodos_Pago (
    ->     ID_metodo_pago VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     Descripcion VARCHAR(100)
    -> );
Query OK, 0 rows affected (0.010 sec)

MariaDB [papeleria]> CREATE TABLE Promociones (
    ->     ID_promocion VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     Nombre VARCHAR(45) NOT NULL,
    ->     Descripcion VARCHAR(100),
    ->     Descuento INT NOT NULL,
    ->     Fecha_inicio VARCHAR(45) NOT NULL,
    ->     Fecha_fin VARCHAR(45) NOT NULL
    -> );
Query OK, 0 rows affected (0.009 sec)

MariaDB [papeleria]> CREATE TABLE Producto_Promocion (
    ->     ID_producto VARCHAR(20) NOT NULL,
    ->     ID_promocion VARCHAR(20) NOT NULL,
    ->     Fecha_aplicacion VARCHAR(45) NOT NULL,
    ->     PRIMARY KEY (ID_producto, ID_promocion),
    ->     FOREIGN KEY(ID_producto) REFERENCES Producto(ID_producto)
    ->     ON DELETE CASCADE ON UPDATE CASCADE,
    ->     FOREIGN KEY(ID_promocion) REFERENCES Promociones(ID_promocion)
    ->     ON DELETE CASCADE ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.021 sec)

MariaDB [papeleria]> CREATE TABLE Historial_Inventario (
    ->     ID_historial VARCHAR(20) NOT NULL PRIMARY KEY,
    ->     ID_producto VARCHAR(20) NOT NULL,
    ->     Fecha_cambio VARCHAR(20) NOT NULL,
    ->     Cantidad_anterior INT NOT NULL,
    ->     Cantidad_nueva INT NOT NULL,
    ->     FOREIGN KEY(ID_producto) REFERENCES Producto(ID_producto)
    ->     ON DELETE CASCADE ON UPDATE CASCADE
    -> );
Query OK, 0 rows affected (0.020 sec)

MariaDB [papeleria]> show tables;
+------------------------+
| Tables_in_papeleria    |
+------------------------+
| categorias             |
| consumidor             |
| detalles_pedido        |
| detalles_venta         |
| distribuidor           |
| historial_inventario   |
| metodos_pago           |
| pedidos_distribuidores |
| producto               |
| producto_promocion     |
| promociones            |
| ventas                 |
+------------------------+
12 rows in set (0.001 sec)

MariaDB [papeleria]> exit