INSERT INTO author ( author_id
                    , first
                    , last
         ) VALUES ( 0
                    , 'Jack'
                    , 'Herrington'
         );

INSERT INTO author ( author_id
                    , first
                    , last
         ) VALUES ( 0
                    , 'Larry'
                    , 'Wall'
         );

INSERT INTO publisher ( publisher_id
                    , name
         ) VALUES ( 0
                    , 'Manning'
         );

INSERT INTO publisher ( publisher_id
                    , name
         ) VALUES ( 0
                    , 'OReilly'
         );

INSERT INTO book ( book_id
                    , title
                    , author_id
                    , publisher_id
         ) VALUES ( 0
                    , 'Code Generation in Action'
                    , 1
                    , 1
         );

INSERT INTO book ( book_id
                    , title
                    , author_id
                    , publisher_id
         ) VALUES ( 0
                    , 'Programming Perl'
                    , 2
                    , 2
         );