INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Henry David', 'Thoreau', '1817', '1862', 'https://en.wikipedia.org/wiki/Henry_David_Thoreau');# 1 row affected.
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Friedrich', 'Nietzsche', '1844', '1900', 'http://en.wikipedia.org/wiki/Friedrich_Nietzsche');# 1 row affected.
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Antoine', 'de Saint-Exupery', '1900', '1944', 'http://en.wikipedia.org/wiki/Antoine_de_Saint-Exupery');# 1 row affected.
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Robert', 'Browning', '1812', '1889', 'http://en.wikipedia.org/wiki/Robert_Browning');# 1 row affected.
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Woody', 'Allen', '1935', 'null', 'http://en.wikipedia.org/wiki/Woddy_Allen');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Oscar', 'Wilde', '1854', '1900', 'http://en.wikipedia.org/wiki/Oscar_wilde');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Emo', 'Philips', '1956', 'null', 'http://en.wikipedia.org/wiki/Emo_Philips');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Groucho', 'Marx', '1890', '1977', 'http://en.wikipedia.org/wiki/Groucho_Marx');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('François-Marie', 'Voltaire', '1890', '1977', 'http://en.wikipedia.org/wiki/Voltaire');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Robert', 'Orben', '1927', 'null', 'http://en.wikipedia.org/wiki/Robert_Orben');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Napoleon', 'Bonaparte', '1769', '1821', 'http://en.wikipedia.org/wiki/Napoleon');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Noam', 'Chomsky', '1928', 'null', 'http://en.wikipedia.org/wiki/Noam_Chomsky');
INSERT INTO author (fname, sname, dob, dod, link) VALUES ('Mark', 'Twain', '1835', '1910', 'http://en.wikipedia.org/wiki/Mark_Twain');

INSERT INTO quote (quote, aid) VALUES ('There is no remedy but to love more.', '1');
INSERT INTO quote (quote, aid) VALUES ('There is always some madness in love. But there is also always some reason in madness.', '2');
INSERT INTO quote (quote, aid) VALUES ('Love does not consist in gazing at each other, but in looking outward together in the same direction.', '3');
INSERT INTO quote (quote, aid) VALUES ('Take away love and our earth is a tomb.', '4');
INSERT INTO quote (quote, aid) VALUES ('It\'s not that I\'m afraid to die, I just don\'t want to be there when it happens.', '5');
INSERT INTO quote (quote, aid) VALUES ('Work is the curse of the drinking classes.', '6');
INSERT INTO quote (quote, aid) VALUES ('A computer once beat me at chess, but it was no match for me at kick boxing.', '7');
INSERT INTO quote (quote, aid) VALUES ('Women should be obscene and not heard.', '8');
INSERT INTO quote (quote, aid) VALUES ('An ideal form of government is democracy tempered with assassination.', '9');
INSERT INTO quote (quote, aid) VALUES ('Illegal aliens have always been a problem in the United States. Ask any Indian.', '10');
INSERT INTO quote (quote, aid) VALUES ('Religion is what keeps the poor from murdering the rich.', '11');
INSERT INTO quote (quote, aid) VALUES ('Any dictator would admire the uniformity and obedience of the [U.S.] media.', '12');
INSERT INTO quote (quote, aid) VALUES ('Surely the ass who invented the first religion ought to be the first ass damned. Faith is believing in that which I know ain\'t so.', '13');

INSERT INTO quote_has_category (cid, qid) VALUES ('2', '1');
INSERT INTO quote_has_category (cid, qid) VALUES ('2', '2');
INSERT INTO quote_has_category (cid, qid) VALUES ('3', '2');
INSERT INTO quote_has_category (cid, qid) VALUES ('2', '3');
INSERT INTO quote_has_category (cid, qid) VALUES ('2', '4');
INSERT INTO quote_has_category (cid, qid) VALUES ('4', '5');
INSERT INTO quote_has_category (cid, qid) VALUES ('4', '6');
INSERT INTO quote_has_category (cid, qid) VALUES ('4', '7');
INSERT INTO quote_has_category (cid, qid) VALUES ('4', '8');
INSERT INTO quote_has_category (cid, qid) VALUES ('1', '9');
INSERT INTO quote_has_category (cid, qid) VALUES ('1', '10');
INSERT INTO quote_has_category (cid, qid) VALUES ('1', '11');
INSERT INTO quote_has_category (cid, qid) VALUES ('1', '12');
INSERT INTO quote_has_category (cid, qid) VALUES ('5', '13');


// QUOTES
There is no remedy but to love more.|Henry David Thoreau|1817-1862|http://en.wikipedia.org/wiki/Henry_David_Thoreau|love
There is always some madness in love. But there is also always some reason in madness.|Friedrich Nietzsche|1844-1900|http://en.wikipedia.org/wiki/Friedrich_Nietzsche|love, philosophy
Love does not consist in gazing at each other, but in looking outward together in the same direction.|Antoine de Saint-Exupery|1900-1944|http://en.wikipedia.org/wiki/Antoine_de_Saint-Exupery|love
Take away love and our earth is a tomb.|Robert Browning|1812-1889|http://en.wikipedia.org/wiki/Robert_Browning|love
It's not that I'm afraid to die, I just don't want to be there when it happens.|Woody Allen|1935-|http://en.wikipedia.org/wiki/Woddy_Allen|humour
Work is the curse of the drinking classes.|Oscar Wilde|1854-1900|http://en.wikipedia.org/wiki/Oscar_wilde|humour, politics
A computer once beat me at chess, but it was no match for me at kick boxing.|Emo Philips|1956-|http://en.wikipedia.org/wiki/Emo_Philips|humour
Women should be obscene and not heard.|Groucho Marx|1890-1977|http://en.wikipedia.org/wiki/Groucho_Marx|humour
An ideal form of government is democracy tempered with assassination.|Voltaire|1694-1778|http://en.wikipedia.org/wiki/Voltaire|politics
Illegal aliens have always been a problem in the United States. Ask any Indian.|Robert Orben|1927-|http://en.wikipedia.org/wiki/Robert_Orben|politics
Religion is what keeps the poor from murdering the rich.|Napoleon Bonaparte|1769-1821|http://en.wikipedia.org/wiki/Napoleon|politics
Any dictator would admire the uniformity and obedience of the [U.S.] media.|Noam Chomsky|1928-|http://en.wikipedia.org/wiki/Noam_Chomsky|politics
Surely the ass who invented the first religion ought to be the first ass damned. Faith is believing in that which I know ain't so.|Mark Twain|1835-1910|http://en.wikipedia.org/wiki/Mark_Twain|religion, humour