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

MariaDB [(none)]> show databases;
+---------------------+
| Database            |
+---------------------+
| bdbiblioteca        |
| information_schema  |
| inventariopapeleria |
| libreria            |
| libro               |
| matricula           |
| matricula1          |
| matricula2          |
| mysql               |
| otros               |
| performance_schema  |
| phpmyadmin          |
| prueba              |
| subconsultas        |
| test                |
| turismo             |
+---------------------+
16 rows in set (0.013 sec)

MariaDB [(none)]> use inventariopapeleria;
Database changed
MariaDB [inventariopapeleria]> Create table producto
    -> (id_producto varchar (20) not null primary key,
    ->  Nombre varchar (45) not null,
    ->  Precio_costo int (45) not null,
    -> Precio_venta int (45) not null,
    -> Disponible int (45) not null);
Query OK, 0 rows affected (0.018 sec)

MariaDB [inventariopapeleria]> 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.024 sec)

MariaDB [inventariopapeleria]> 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.018 sec)

MariaDB [inventariopapeleria]> describe distribuidor;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_distribuidor | 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.015 sec)

MariaDB [inventariopapeleria]> 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 [inventariopapeleria]> describe consumidor;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_consumidor | 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.003 sec)

MariaDB [inventariopapeleria]> create table pedidos_distribuidores
    ->  (id_pedidodistri varchar (20) not null primary key,
    -> Fecha varchar (45) not null,
    -> FK_distribuidor varchar (45) not null,
    -> foreign key(FK_distribuidor) references distribuidor(id_distribuidor) on delete cascade on update cascade);
Query OK, 0 rows affected (0.026 sec)

MariaDB [inventariopapeleria]> describe pedidos_distribuidores;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_pedidodistri | varchar(20) | NO   | PRI | NULL    |       |
| Fecha           | varchar(45) | NO   |     | NULL    |       |
| FK_distribuidor | varchar(45) | NO   | MUL | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
3 rows in set (0.023 sec)

MariaDB [inventariopapeleria]> create table Detalles_pedido
    -> (id_detallePedi varchar(20) not null primary key,
    -> Nombre varchar (45) not null,
    -> cantidad_pedido int(45) 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.025 sec)

MariaDB [inventariopapeleria]> describe detalles_pedido;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_detallePedi  | varchar(20) | NO   | PRI | NULL    |       |
| Nombre          | varchar(45) | NO   |     | NULL    |       |
| cantidad_pedido | int(45)     | NO   |     | NULL    |       |
| FK_pedidodistri | varchar(20) | NO   | MUL | NULL    |       |
| FK_producto     | varchar(20) | NO   | MUL | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
5 rows in set (0.013 sec)

MariaDB [inventariopapeleria]> alter table detalles_pedido add precio_compra int (45) not null after fk_pedidodistri;
Query OK, 0 rows affected (0.028 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [inventariopapeleria]> describe detalles_pedido;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_detallePedi  | varchar(20) | NO   | PRI | NULL    |       |
| Nombre          | varchar(45) | NO   |     | NULL    |       |
| cantidad_pedido | int(45)     | NO   |     | NULL    |       |
| FK_pedidodistri | varchar(20) | NO   | MUL | NULL    |       |
| precio_compra   | int(45)     | NO   |     | NULL    |       |
| FK_producto     | varchar(20) | NO   | MUL | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
6 rows in set (0.013 sec)

MariaDB [inventariopapeleria]> alter table detalles_pedido drop precio_compra;
Query OK, 0 rows affected (0.030 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [inventariopapeleria]> describe detalles_pedido;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_detallePedi  | varchar(20) | NO   | PRI | NULL    |       |
| Nombre          | varchar(45) | NO   |     | NULL    |       |
| cantidad_pedido | int(45)     | NO   |     | NULL    |       |
| FK_pedidodistri | varchar(20) | NO   | MUL | NULL    |       |
| FK_producto     | varchar(20) | NO   | MUL | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
5 rows in set (0.011 sec)

MariaDB [inventariopapeleria]> alter table detalles_pedido add precio_compra int (45) not null after cantidad_pedido;
Query OK, 0 rows affected (0.006 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [inventariopapeleria]> describe detalles_pedido;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_detallePedi  | varchar(20) | NO   | PRI | NULL    |       |
| Nombre          | varchar(45) | NO   |     | NULL    |       |
| cantidad_pedido | int(45)     | NO   |     | NULL    |       |
| precio_compra   | int(45)     | NO   |     | NULL    |       |
| FK_pedidodistri | varchar(20) | NO   | MUL | NULL    |       |
| FK_producto     | varchar(20) | NO   | MUL | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
6 rows in set (0.005 sec)

MariaDB [inventariopapeleria]> create table Venta
    -> (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.016 sec)

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

MariaDB [inventariopapeleria]> create table Detalles_venta
    -> (id_detalleventa varchar (20) not null primary key,
    -> Cantidad_vendida int (45) not null,
    -> FK_venta varchar (20) not null,
    -> FK_producto varchar (20) not null,
    -> foreign key(FK_venta) references venta(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.028 sec)

MariaDB [inventariopapeleria]> describe detalles_venta;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| id_detalleventa  | 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.012 sec)

MariaDB [inventariopapeleria]> exit
Bye