清单 14. Schema.sql DROP TABLE IF EXISTS authors. CREATE TABLE authors ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name TEXT NOT NULL, PRIMARY KEY ( id ) ).
DROP TABLE IF EXISTS books. CREATE TABLE books ( id MEDIUMINT NOT NULL AUTO_INCREMENT, author_id MEDIUMINT NOT NULL, name TEXT NOT NULL, PRIMARY KEY ( id ) ).
INSERT INTO authors VALUES ( null, Jack Herrington ). INSERT INTO authors VALUES ( null, Dave Thomas ).
INSERT INTO books VALUES ( null, 1, Code Generation in Action ). INSERT INTO books VALUES ( null, 1, Podcasting Hacks ). INSERT INTO books VALUES ( null, 1, PHP Hacks ). INSERT INTO books VALUES ( null, 2, Pragmatic Programmer ). INSERT INTO books VALUES ( null, 2, Ruby on Rails ). INSERT INTO books VALUES ( null, 2, Programming Ruby ).