SQLize | PHPize | SQLtest

-- Step 1: Gumawa ng bagong table na tbl_milkteashop CREATE TABLE tbl_milkteashop ( mt_id INT PRIMARY KEY AUTO_INCREMENT, mt_name VARCHAR(100) NOT NULL, mt_price DECIMAL(5,2) NOT NULL ); -- Step 2: Magdagdag ng bagong column (mt_flavor at mt_size) ALTER TABLE tbl_milkteashop ADD mt_flavor VARCHAR(50), ADD mt_size VARCHAR(10); -- Step 3: Baguhin ang column size ng mt_name mula VARCHAR(100) to VARCHAR(150) ALTER TABLE tbl_milkteashop MODIFY COLUMN mt_name VARCHAR(150); -- Step 4: Magdagdag ng bagong supplier table (para sa foreign key relationship) CREATE TABLE tbl_supplier ( supplier_id INT PRIMARY KEY AUTO_INCREMENT, supplier_name VARCHAR(100) NOT NULL ); -- Step 5: Magdagdag ng supplier_id column sa tbl_milkteashop at gawing foreign key ALTER TABLE tbl_milkteashop ADD supplier_id INT, ADD FOREIGN KEY (supplier_id) REFERENCES tbl_supplier(supplier_id) ON DELETE CASCADE; -- Step 6: Mag-delete ng column (mt_size) sa tbl_milkteashop ALTER TABLE tbl_milkteashop DROP COLUMN mt_size; -- Step 7: Mag-delete ng buong tbl_milkteashop table (Optional - Huwag i-run kung ayaw mong mabura!) -- DROP TABLE tbl_milkteashop;