rbsJEDAe

1-- --------------------------------------------------------
2
3--
4-- Table structure for table `twitter_tweets`
5--
6
7CREATE TABLE IF NOT EXISTS `twitter_tweets` (
8  `id` bigint(20) NOT NULL,
9  `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
10  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
11  `created` datetime NOT NULL,
12  PRIMARY KEY (`id`),
13  KEY `user` (`user_name`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `twitter_users`
20--
21
22CREATE TABLE IF NOT EXISTS `twitter_users` (
23  `id` bigint(20) NOT NULL,
24  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
25  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
26  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
27  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
28  `followers` int(11) NOT NULL,
29  `importance` int(11) NOT NULL,
30  PRIMARY KEY (`id`),
31  UNIQUE KEY `user` (`name`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
33
34-- --------------------------------------------------------