# INSERT INTO instrument  VALUES ('AMBER','VLTI','','')\g

#
# initialize table 'instrument'
#
DELETE FROM instrument WHERE ins_id LIKE 'AMBER%'\g
INSERT INTO instrument  VALUES ('AMBER','VLTI','','')\g

#
# insert instrument component table
#
DELETE FROM component WHERE comp_id = 'AMBER%'\g
INSERT INTO component VALUES ('MIDI',NULL,NULL,'Amber','INS','ins/midi','1900-01-01T00:00:00','inf','C','INST')\g

#
# insert actual MIDI components
#
DELETE FROM real_component WHERE ins_id = 'AMBER%'\g
INSERT INTO real_component VALUES ('AMBER','AMBER','Amber','INS')\g

