# This SQL script updates the airline database for lab sheet 10
ALTER TABLE Aircraft ADD inspection_date DATETIME AFTER registration;
UPDATE Aircraft SET inspection_date = '2011-04-25' WHERE registration = 'ZK-BLOB';
UPDATE Aircraft SET inspection_date = '2011-05-03' WHERE registration = 'ZK-DUCK';
UPDATE Aircraft SET inspection_date = '2011-11-20' WHERE registration = 'ZK-BIGG';
UPDATE Aircraft SET inspection_date = '2011-10-18' WHERE registration = 'ZK-WHIZ';
UPDATE Aircraft SET inspection_date = '2011-06-23' WHERE registration = 'ZK-HUGE';
UPDATE Aircraft SET inspection_date = '2011-09-12' WHERE registration = 'ZK-GIGA';