%defaultDatasource jdbc:h2:mem:db1
%datasources chemistry=jdbc:h2:mem:chemistry

drop table if exists color;
CREATE TABLE color (
  id int(11) NOT NULL,
  name varchar(45) NOT NULL,
  code varchar(10),
  PRIMARY KEY (id)
);

INSERT INTO color (id, name, code) VALUES (1001,'AliceBlue','#F0F8FF');
INSERT INTO color (id, name, code) VALUES (1002,'AntiqueWhite','#FAEBD7');
INSERT INTO color (id, name, code) VALUES (1003,'Aqua','#00FFFF');
INSERT INTO color (id, name, code) VALUES (1004,'Aquamarine','#7FFFD4');
INSERT INTO color (id, name, code) VALUES (1005,'Azure','#F0FFFF');
INSERT INTO color (id, name, code) VALUES (1006,'Beige','#F5F5DC');
INSERT INTO color (id, name, code) VALUES (1007,'Bisque','#FFE4C4');
INSERT INTO color (id, name, code) VALUES (1008,'Black','#000000');

SELECT * FROM color WHERE name LIKE 'A%';