CREATE TABLE devices ( name text NOT NULL, model text NOT NULL, serial integer NOT NULL UNIQUE ); INSERT INTO devices (name, model, serial) VALUES ( 'HP ZBook 17 G3 Mobile Workstation', 'ZBook', 'SN-2015' );
ALTER TABLE devices RENAME TO equipment;
SELECT name, model, serial FROM equipment;
ALTER TABLE equipment ADD COLUMN location text;
SELECT * FROM albums;
SELECT * FROM artists;
SELECT * FROM customers;
SELECT * FROM employees;
SELECT * FROM genres;
SELECT * FROM invoice_items;
SELECT * FROM invoices;
SELECT * FROM media_types;
SELECT * FROM playlist_track;
SELECT * FROM playlists;
SELECT * FROM tracks;