text: SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `github_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `github_id` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `repository` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `github_id`),
    FULLTEXT KEY `SEARCH` (`content`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `foursquare_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `guid` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `guid`),
    FULLTEXT KEY `SEARCH` (`content`,`title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `goodreads_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `guid` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `guid`),
    FULLTEXT KEY `SEARCH` (`content`, `title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  
  delimiter '//'
  CREATE PROCEDURE add_data_column() BEGIN
  IF NOT EXISTS(
  	SELECT * FROM information_schema.COLUMNS
  	WHERE COLUMN_NAME='is_unwanted' AND TABLE_NAME='data'
  	)
  	THEN
  		ALTER TABLE `data` ADD COLUMN `is_unwanted` TINYINT(1)  NOT NULL DEFAULT 0 AFTER `timestamp`;
  END IF;
  END;
  //
  delimiter ';'
  CALL add_data_column();
  DROP PROCEDURE add_data_column;
  
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `stackoverflow_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `stackoverflow_id` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `stackoverflow_id`),
    FULLTEXT KEY `SEARCH` (`content`,`title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `googlebuzz_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `buzz_id` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `buzz_id`),
    FULLTEXT KEY `SEARCH` (`content`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `twitterfavorites_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `tweet_id` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `author` varchar(255) NOT NULL,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `tweet_id`),
    FULLTEXT KEY `SEARCH` (`content`,`title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `bliptv_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `title` varchar(255) NOT NULL,
    `uri` varchar(255) NOT NULL,
    `show` varchar(255) NOT NULL,
    `embed_uri` varchar(255) NOT NULL,
    `embed` text NOT NULL,
    `length` int(6) unsigned NOT NULL,
    `thumbnail` varchar(255) NOT NULL,
    `license` varchar(255) NOT NULL,
    `content` text NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  (`id`),
    UNIQUE KEY `DUPLICATES` (`source_id`,`uri`),
    FULLTEXT KEY `SEARCH` (`title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `scribd_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `guid` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `guid`),
    FULLTEXT KEY `SEARCH` (`content`,`title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `launchpad_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `link` varchar(256) NOT NULL,
    `title` varchar(256) NOT NULL,
    `content` text NOT NULL,
    `branch_url` text NOT NULL,
    `branch` text NOT NULL,
    `revision` varchar(256) NOT NULL,
    `project` varchar(256) NOT NULL,
    `message` text NOT NULL,
    `published` int(10) unsigned NOT NULL,
    PRIMARY KEY  (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`,`link`),
    FULLTEXT KEY `SEARCH` (`title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `scrnshots_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `created_at` varchar(45) NOT NULL,
    `title` text NOT NULL,
    `description` text NOT NULL,
    `link` varchar(256) NOT NULL,
    `href` varchar(256) NOT NULL,
    `thumbnail` varchar(256) NOT NULL,
    `image` varchar(256) NOT NULL,
    PRIMARY KEY  (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`,`link`),
    FULLTEXT KEY `SEARCH` (`description`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `gitorious_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `gitorious_id` varchar(255) NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `repository` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `gitorious_id`),
    FULLTEXT KEY `SEARCH` (`content`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;
  
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE IF NOT EXISTS `getsatisfaction_data` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `source_id` int(10) unsigned NOT NULL,
    `title` text NOT NULL,
    `content` text,
    `link` varchar(255) NOT NULL,
    `published` varchar(45) NOT NULL,
    PRIMARY KEY  USING BTREE (`id`),
    UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `link`, `published`),
    FULLTEXT KEY `SEARCH` (`content`, `title`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  SET character_set_client = @saved_cs_client;