   `type` varchar(100) NOT NULL,
   PRIMARY KEY (`uid`),
   KEY `pid_refs_pid_38b0e356` (`pid`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=102231 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=102697 ;
 
 -- --------------------------------------------------------
 

  PRIMARY KEY (`tid`),
  KEY `pid_refs_pid_458415f9` (`pid`),
  KEY `ANALYSED` (`analysed`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1234553 ;

-- --------------------------------------------------------


--

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