begin transaction;

create table quotes (
 pk integer primary key,
 attribution,
 quote,
 citation
);

insert into quotes (quote, attribution, citation)
select
 'Chance favors the prepared mind.' as quote,
 'Louis Pasteur' as attribution,
 'http://en.wikiquote.org/wiki/Louis_Pasteur#Quotes' as citation

union select
 'Once you accept an idea, it''s an idea whose time has come.',
 'William James',
 'Folk'

union select
 'High intention sets the universe in motion.',
 'Armand Hammer',
 'Folk'

union select
 'Anything will give up its secrets if you love it enough.',
 'George Washington Carver',
 'http://thinkexist.com/quotes/george_washington_carver/'

union select
 'A No. 2 pencil and a dream  can take you anywhere.',
 'Joyce A. Myers',
 'http://thinkexist.com/quotes/joyce_a._myers/'

union select
 'Hippopotomonstrosesquipedaliophobia - Fear of long words.',
 'Fredd Culbertson',
 'http://phobialist.com/#H-'

union select
 'Once the game is over, the king and the pawn go back in the same box.',
 'Italian Proverb',
 'http://en.wikiquote.org/wiki/Chess#O'

union select
 'God does not play dice with the universe.',
 'Albert Einstein',
 'http://en.wikiquote.org/wiki/Albert_Einstein#1920s'

union select
 'I do not think much of a man who is not wiser today than he was yesterday.',
 'Abraham Lincoln',
 'http://en.wikiquote.org/wiki/Abraham_Lincoln#Posthumous_attributions'

union select
 'The Tao is (like) the emptiness of a vessel; and in our employment of it we must be on our guard against all fulness. How deep and unfathomable it is, as if it were the Honoured Ancestor of all things!',
 'Laozi',
 'http://www.gutenberg.org/files/216/216-h/216-h.htm'

union select
 "An artist's only concern is to shoot for some kind of perfection, and _on his own terms_, not anyone else's.",
 'Zooey Glass',
 'http://en.wikiquote.org/wiki/Salinger,_J._D.#Zooey_.28novella.2C_1957.29';

commit;
