24-10-2025-Pair-Leccion-05-SQL- MODIFICACION E INSERCION.sql

USE tienda_zapatillas;
ALTER TABLE zapatillas
	ADD COLUMN marca VARCHAR (45) NOT NULL,
    ADD COLUMN talla INT NOT NULL;
    
ALTER TABLE empleados
	MODIFY COLUMN salario DECIMAL NOT NULL;
    
ALTER TABLE clientes
	ADD COLUMN pais VARCHAR(45);
SELECT *
	FROM clientes; 
    
ALTER TABLE clientes 
	DROP COLUMN pais;
    
ALTER TABLE facturas
	ADD COLUMN total DECIMAL;
INSERT INTO zapatillas (id_zapatilla, modelo, color, marca, talla)
	VALUES(1, "XQYUN", "Negro", "Nike", 42),
		(2, "UOPMN", "Rosas", "Nike", 39),
        (3, "OPNYT", "Verde", "Adidas", 35);
INSERT INTO empleados (id_empleado, nombre, tienda, salario, fecha_incorporacion)
	VALUES (1, "Laura", "Alcobendas", 25987, "2010-09-03"),
		(2, "Maria", "Sevilla", 00.0, "2001-04-11"),
        (3, "Ester", "Oviedo", 30165.98, "2000-11-29");

SELECT *
	FROM empleados; 
    
INSERT INTO clientes (id_cliente, nombre, numero_telefono, email, direccion, ciudad, provincia, codigo_postal)
	VALUES (1, "Monica", 1234567289, "monica@email.com", "Calle Felicidad", "Móstoles", "Madrid", "28176"), 
		(2, "Lorena", 289345678, "lorena@email.com", "Calle Alegria", "Barcelona", "Barcelona", "12346"), 
        (3, "Carmen", 298463759, "carmen@email.com", "Calle del Color", "Vigo", "Pontevedra", "23456");
INSERT INTO facturas (id_factura, numero_factura, fecha, id_zapatilla, id_empleado, id_cliente, total)
	VALUES (1, "123", "2001-12-11", 1, 2, 1, 54.98),
		(2, "1234", "2005-05-23", 1, 1, 3, 89.91),
        (3, "12345", "2015-09-18", 2, 3, 3, 76.23);

SELECT *
	FROM facturas; 

    
UPDATE zapatillas
	SET color = "Amarillo"
    WHERE id_zapatilla = 2;
SELECT * 
	FROM zapatillas; 
UPDATE empleados
	SET tienda = "A Coruña"
    WHERE id_empleado = 1;
SELECT * 
	FROM empleados; 
UPDATE clientes
	SET numero_telefono = 123456728 
    WHERE id_cliente = 1;
UPDATE facturas
	SET total = 89.91 
    WHERE id_zapatilla = 2;