Page 20: More ALTER

ALTER TABLE hooptie
RENAME TO car_table;
ALTER TABLE car_table
ADD COLUMN car_id INT NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (car_id),
ADD COLUMN VIN VARCHAR(16) AFTER car_id,
CHANGE COLUMN mo model VARCHAR(20),
MODIFY COLUMN color VARCHAR(20) AFTER model,
CHANGE COLUMN howmuch price DECIMAL(7,2);