The setup already creates the devices(name, model, serial, note) table and inserts two rows.
Write only below the final comment the ALTER TABLE statements needed to complete this workflow:
- rename the
devices table to equipment
- add the
location column
- add the
quality column with type REAL
- rename the
serial column to serial_id
- remove the
note column
At the end of the workflow, these conditions must be true:
- the final table must be named
equipment
devices must no longer existequipment must still contain the two rows inserted by the setuplocation, quality, and serial_id must existnote must no longer exist
Hints
Hint 1
You do not need to create or populate devices: the setup already does that. Start with ALTER TABLE devices RENAME TO equipment;.
Hint 2
After the rename, all following changes must be made on equipment.
Hint 3
Add location and quality REAL, rename serial to serial_id, and only at the end remove note.