   `totaltweets` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`did`),
   KEY `pid_refs_pid_5901525b` (`pid`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=235992 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=236924 ;
 
 -- --------------------------------------------------------
 

--

CREATE TABLE IF NOT EXISTS `rawdata` (
  `tweet_id` double NOT NULL,
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(10) NOT NULL,
  `timestamp` double NOT NULL,

--

CREATE TABLE IF NOT EXISTS `rawtweets` (
  `tweet_id` decimal(22,0) NOT NULL,
  `tweet_json` varchar(16000) NOT NULL,
  `tweet_stored_seconds` int(11) NOT NULL,
  `tweet_stored_fraction` double NOT NULL,
