u8ncAYu0

1DROP DATABASE IF EXISTS ventas;
2CREATE DATABASE IF NOT EXISTS ventas;
3USE ventas;
4CREATE TABLE productos(
5	id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
6	codigo VARCHAR(255) NOT NULL,
7	descripcion VARCHAR(255) NOT NULL,
8	precioVenta DECIMAL(5, 2) NOT NULL,
9	precioCompra DECIMAL(5, 2) NOT NULL,
10	existencia DECIMAL(5, 2) NOT NULL,
11	PRIMARY KEY(id)
12) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;
13
14CREATE TABLE ventas(
15	id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
16	fecha DATETIME NOT NULL,
17	total DECIMAL(7,2),
18	PRIMARY KEY(id)
19) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;
20
21CREATE TABLE productos_vendidos(
22	id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
23	id_producto BIGINT UNSIGNED NOT NULL,
24	cantidad BIGINT UNSIGNED NOT NULL,
25	id_venta BIGINT UNSIGNED NOT NULL,
26	PRIMARY KEY(id),
27	FOREIGN KEY(id_producto) REFERENCES productos(id) ON DELETE CASCADE,
28	FOREIGN KEY(id_venta) REFERENCES ventas(id) ON DELETE CASCADE
29) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8;
30
31INSERT INTO productos(id, codigo, descripcion, precioVenta, precioCompra, existencia) 
32VALUES
33(1, '1', 'Galletas chokis', 15, 10, 100),
34(2, '2', 'Mermelada de fresa', 80, 65, 100),
35(3, '3', 'Aceite', 20, 18, 100),
36(4, '4', 'Palomitas de maíz', 15, 12, 100),
37(5, '5', 'Doritos', 8, 5, 100);
38
39# Correcto