DROP TABLE IF EXISTS quote;
CREATE TABLE quote (
   uniqueQuoteID INTEGER NOT NULL AUTO_INCREMENT,
   uniqueAuthorID INTEGER NOT NULL ,
   commentary VARCHAR( 2048 ), /* Roedy's or other commentary, with lead <p class="roedy"> unless multi-paragraph */
   dateAdded DATE NOT NULL,
   composedDate DATE,
   featuredDate DATE,
   quotation VARCHAR( 2048 ) NOT NULL,  /* text of quotation without <blockquote. May include unexpanded macros. Includes leading <p> and trailing </p> etc */
   sortkey VARCHAR ( 500 ) NOT NULL, /* used to sort quotes, and detect possible dups */
   source VARCHAR( 2048 ), /* including URL markup, where the quote came from or backing for it. */
   title VARCHAR( 200 ),
   weight INTEGER NOT NULL,  /* just additional weight for this quote. Does not include flock weights, birthday weights, featured weights etc */
   flocks SET(
   'abortion',
   'animalrights',
   'canada',
   'christian',
   'environment',
   'euthanasia',
   'evolution',
   'gandhi',
   'gaymarriage',
   'israel',
   'livinglove',
   'misc',
   'money',
   'napoleon',
   'patriotism',
   'politics',
   'population',
   'programming',
   'relationships',
   'religion',
   'sexuality',
   'war'
   'warming'),
   PRIMARY KEY( uniqueQuoteID )
   );
