-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathtweak_development_dump 16.01.2010.sql
52 lines (47 loc) · 11.5 KB
/
tweak_development_dump 16.01.2010.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
# CocoaMySQL dump
# Version 0.7b5
# http://cocoamysql.sourceforge.net
#
# Host: localhost (MySQL 5.1.30)
# Database: tweak_development
# Generation Time: 2010-01-16 12:28:54 -0800
# ************************************************************
# Dump of table raw_tweets
# ------------------------------------------------------------
CREATE TABLE `raw_tweets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8_unicode_ci,
`from_user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`to_user_id` int(11) DEFAULT NULL,
`tweet_id` bigint(20) DEFAULT NULL,
`geo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`from_user_id` int(11) DEFAULT NULL,
`iso_language_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`profile_image_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tweet_time` datetime DEFAULT NULL,
`is_parsed` tinyint(1) DEFAULT '0',
`is_retweeted` tinyint(1) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`text_hash` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_raw_tweets_on_text_hash` (`text_hash`),
KEY `index_raw_tweets_on_tweet_id` (`tweet_id`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('56','#haiti #need national mobilization & leadership #source Dahoud Andre http://bit.ly/5IMJWB','sophiabliu',NULL,'7819864837',NULL,'2309632','en','<a href="http://www.tweetdeck.com/" rel="nofollow">TweetDeck</a>','http://a3.twimg.com/profile_images/63642181/Sophia_Photo_normal.jpeg','2010-01-16 07:37:56','0','1','2010-01-16 08:23:28','2010-01-16 08:29:57','-482200777');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('57','#Haiti #Need Dr treating survivors need people & supplies #Contact Dr Denis Cyrille Rue Monseigneur Guilloux #556 Cell# 3555-1406 via@MejidX','RIElliott',NULL,'7818136987',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 06:15:45','0','1','2010-01-16 08:23:28','2010-01-16 08:40:21','822894786');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('58','#Haiti #Need generator & water pump repair, tents #Location Leogane, Haiti Nursing School #Contact @nursetim www.haitinursing.org','RIElliott',NULL,'7817996296',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 06:09:46','0','1','2010-01-16 08:23:28','2010-01-16 08:40:22','-477846350');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('59','#Haiti #need #rescue #name American & UF Alumni Lee Strickland is stuck there alive #location Hotel Montana.\nPlease RT send help now!','407underground',NULL,'7817672933',NULL,'4596715','en','<a href="http://www.tweetdeck.com/" rel="nofollow">TweetDeck</a>','http://a1.twimg.com/profile_images/201454202/tweeter_button_normal.png','2010-01-16 05:56:28','0','1','2010-01-16 08:23:28','2010-01-16 08:40:22','621575413');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('60','#Haiti #need #rescue #name American Christine Legagneur is stuck there alive #location UNIBANK Bourdon (via @carodefay)','RIElliott',NULL,'7817104261',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 05:33:19','0','1','2010-01-16 08:23:28','2010-01-16 08:40:22','136843415');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('61','#Haiti #need #rescue #name JessicaLeriche\'s uncle+others #location StGerardTechSchl He JUST calld w/ cll.70RueStGerard,Carrefour-Fueilles','RIElliott',NULL,'7816973595',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 05:28:15','0','1','2010-01-16 08:23:28','2010-01-16 08:40:23','-107985634');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('62','#Haiti #need #rescue #name Adolpho Prato #location Carribean Market @tbijou (Adolpho sent text message morning Jan 15)','RIElliott',NULL,'7815007356',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 04:16:26','0','1','2010-01-16 08:23:28','2010-01-16 08:40:23','139880693');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('63','#Haiti #offering full-service hospital not being utilized #location MILOT Haiti #Name Hopital Sacre Coeur Contact Carol Fipp 9042237233','RIElliott',NULL,'7817229976',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 05:38:17','0','1','2010-01-16 08:23:29','2010-01-16 08:40:24','-635364669');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('64','#haiti #status trapped #name Stephanie Gilles #loc Ruelle Chretien 48 #contact twitter.com/LexyLeahy','KAT1NKA',NULL,'7829878321',NULL,'7931349','nl','<a href="http://twitter.com/">web</a>','http://a1.twimg.com/profile_images/531273612/fotootje_normal.jpg','2010-01-16 15:49:25','0','1','2010-01-16 15:50:43','2010-01-16 15:52:25','-393829004');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('65','#haiti #need #volunteers #medical #loc [address] #num [amount] #contact [@ or #] #info [more description]','epiccolorado',NULL,'7832162092',NULL,'77635286','en','<a href="http://apiwiki.twitter.com/" rel="nofollow">API</a>','http://a3.twimg.com/profile_images/633620809/epiclogo_normal.png','2010-01-16 17:06:20','0','1','2010-01-16 17:07:33','2010-01-16 17:08:25','-756353730');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('66','#haiti #need Blackberry apps #info many Federal Government officials use blackberrys not iphones','sophiabliu',NULL,'7832422663',NULL,'2309632','en','<a href="http://www.tweetdeck.com/" rel="nofollow">TweetDeck</a>','http://a3.twimg.com/profile_images/63642181/Sophia_Photo_normal.jpeg','2010-01-16 17:15:11','0','1','2010-01-16 17:15:37','2010-01-16 17:16:26','-52276515');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('67','#haiti #need #transport #loc [address] #loc [address] #num [amount] #info [more description]','epiccolorado',NULL,'7832756599',NULL,'77635286','en','<a href="http://apiwiki.twitter.com/" rel="nofollow">API</a>','http://a3.twimg.com/profile_images/633620809/epiclogo_normal.png','2010-01-16 17:26:21','0','1','2010-01-16 17:27:44','2010-01-16 17:28:27','-370981401');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('68','#haiti #need #food #loc Mariani 2 Rue F. Juste, Montaigne de la Paix 18 #source @rqskye #info URGENT Grandmother needs food to take meds','epiccolorado',NULL,'7833251513',NULL,'77635286','en','<a href="http://www.tweetdeck.com/" rel="nofollow">TweetDeck</a>','http://a3.twimg.com/profile_images/633620809/epiclogo_normal.png','2010-01-16 17:42:58','0','1','2010-01-16 17:43:51','2010-01-16 17:44:28','1000425984');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('69','#haiti #offering #med #loc SacredHeart Hosp, Milot #num 200 #contact Carol Crudem #contact 904 223 7233 #info has landing pad, staff, suppl','epiccolorado',NULL,'7833325727',NULL,'77635286','en','<a href="http://www.tweetdeck.com/" rel="nofollow">TweetDeck</a>','http://a3.twimg.com/profile_images/633620809/epiclogo_normal.png','2010-01-16 17:45:31','0','1','2010-01-16 17:45:52','2010-01-16 17:46:28','376086236');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('70','#Haiti #Need #Rescue #Name Christine Legagneur alive txtin from 35581388 & 37337213 #Location Unibank Bourdon under debris via @ZoeGeneral','RIElliott',NULL,'7833969791',NULL,'26580270','en','<a href="http://twitter.com/">web</a>','http://a3.twimg.com/profile_images/554277135/twitterProfilePhoto_normal.jpg','2010-01-16 18:07:37','0','1','2010-01-16 18:08:03','2010-01-16 18:08:29','-11685083');
INSERT INTO `raw_tweets` (`id`,`text`,`from_user`,`to_user_id`,`tweet_id`,`geo`,`from_user_id`,`iso_language_code`,`source`,`profile_image_url`,`tweet_time`,`is_parsed`,`is_retweeted`,`created_at`,`updated_at`,`text_hash`) VALUES ('71','#haiti #road #loc [location of road closure]i #status closed','epiccolorado',NULL,'7833934152',NULL,'77635286','en','<a href="http://apiwiki.twitter.com/" rel="nofollow">API</a>','http://a3.twimg.com/profile_images/633620809/epiclogo_normal.png','2010-01-16 18:06:24','0','1','2010-01-16 18:08:03','2010-01-16 18:08:30','-494350234');