DROP DATABASE IF EXISTS colswap;
CREATE DATABASE colswap;
USE colswap;
CREATE TABLE components (Number VARCHAR(50) PRIMARY KEY, Category TINYTEXT);
INSERT INTO components(Number, Category) VALUES ('120-00001', 'Capacitor');
CREATE VIEW colview AS SELECT Number, Category FROM components;