DROP DATABASE IF EXISTS ventas; | |
CREATE DATABASE IF NOT EXISTS ventas; | |
USE ventas; | |
CREATE TABLE productos( | |
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, | |
codigo VARCHAR(255) NOT NULL, | |
descripcion VARCHAR(255) NOT NULL, | |
precioVenta DECIMAL(5, 2) NOT NULL, | |
precioCompra DECIMAL(5, 2) NOT NULL, | |
existencia DECIMAL(5, 2) NOT NULL, | |
PRIMARY KEY(id) | |
) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; | |
CREATE TABLE ventas( | |
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, | |
fecha DATETIME NOT NULL, | |
total DECIMAL(7,2), | |
PRIMARY KEY(id) | |
) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; | |
CREATE TABLE productos_vendidos( | |
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, | |
id_producto BIGINT UNSIGNED NOT NULL, | |
cantidad BIGINT UNSIGNED NOT NULL, | |
id_venta BIGINT UNSIGNED NOT NULL, | |
PRIMARY KEY(id), | |
FOREIGN KEY(id_producto) REFERENCES productos(id) ON DELETE CASCADE, | |
FOREIGN KEY(id_venta) REFERENCES ventas(id) ON DELETE CASCADE | |
) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; | |
INSERT INTO productos(id, codigo, descripcion, precioVenta, precioCompra, existencia) | |
VALUES | |
(1, '1', 'Galletas chokis', 15, 10, 100), | |
(2, '2', 'Mermelada de fresa', 80, 65, 100), | |
(3, '3', 'Aceite', 20, 18, 100), | |
(4, '4', 'Palomitas de maíz', 15, 12, 100), | |
(5, '5', 'Doritos', 8, 5, 100); | |
# Correcto |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment