-- phpMyAdmin SQL Dump

-- version 3.5.1

-- http://www.phpmyadmin.net

--

-- Värd: localhost

-- Skapad: 20 maj 2014 kl 17:37

-- Serverversion: 5.5.25

-- PHP-version: 5.4.

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00"

--

-- Databas: `football`

--

​

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

​

--

-- Tabellstruktur `dv_football_hashtags`

--

​

CREATE TABLE `dv_football_hashtags` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `game_id` int(11) NOT NULL,

  `hashtag` varchar(250) COLLATE utf8_swedish_ci NOT NULL,

  `antal` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=36 ;

​

--

-- Dumpning av Data i tabell `dv_football_hashtags`

--

​

INSERT INTO `dv_football_hashtags` (`id`, `game_id`, `hashtag`, `antal`) VALUES

(1, 1, 'throwback', 10),

(2, 1, 'worldcup2014', 10),

(3, 1, 'spain', 10),

(4, 1, 'neymar', 40),

(5, 1, 'worldc', 10),

(6, 1, 'messi', 16),

(7, 1, 'me', 16),

(8, 1, 'barcelona', 4),

(9, 1, 'ronaldo', 4),

(10, 1, 'likes', 4),

(11, 1, 'love', 4),

(12, 1, 'bear', 4),

(13, 1, 'sea', 4),

(14, 1, 'tower', 4),

(15, 1, 'hour', 4),

(16, 1, 'car', 4),

(17, 1, 'spa', 4),

(18, 1, 'brasil', 7),

(19, 1, 'fifaworldcup', 13),

(20, 1, 'cr7', 13),

(21, 1, 'futebol', 13),

(22, 1, 'nike', 4),

(23, 1, 'adidas', 4),

(24, 1, 'argentina', 4),

(25, 1, 'portugal', 4),

(26, 1, 'realmadrid', 4),

(27, 1, 'brazilian', 13),

(28, 1, 'teamfollowback', 13),

(29, 1, 'i', 13),

(30, 1, 'likeforlike', 13),

(31, 1, 'like4like', 13),

(32, 1, 'likeback', 13),

(33, 1, 'l4', 10),

(34, 1, 'l4l', 4),

(35, 1, 'fol', 4);

​

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

​

--

-- Tabellstruktur `dv_football_tweets`

--

​

CREATE TABLE `dv_football_tweets` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `tweet_id` char(25) COLLATE utf8_swedish_ci NOT NULL,

  `game_id` int(11) NOT NULL,

  `datum` varchar(12) COLLATE utf8_swedish_ci NOT NULL,

  `tweet` varchar(250) COLLATE utf8_swedish_ci NOT NULL,

  `username` varchar(250) COLLATE utf8_swedish_ci NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `tweet_id` (`tweet_id`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=14 ;

​

--

-- Dumpning av Data i tabell `dv_football_tweets`

--

​

INSERT INTO `dv_football_tweets` (`id`, `tweet_id`, `game_id`, `datum`, `tweet`, `username`) VALUES

(1, '468606158740402176', 1, '1400593448', 'RT @iFiFa2014: #Brazil #FIFA2014 #WorldCup World cup 2010 #throwback #worldcup #worldcup2014 #brazil #spain #neymar haha #worldc... http://…', 'soccerseason198'),

(2, '468601756969361409', 1, '1400593448', 'RT @iFiFa2014: #Brazil #FIFA2014 #WorldCup World cup 2010 #throwback #worldcup #worldcup2014 #brazil #spain #neymar haha #worldc... http://…', 'soccerfreak4677'),

(3, '468600950933168130', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup World cup 2010 #throwback #worldcup #worldcup2014 #brazil #spain #neymar haha #worldc... http://t.co/xHRxDSO3ED', 'iFiFa2014'),

(4, '468574000139231233', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup #messi #me #barcelona #neymar #ronaldo #likes #love #bear #sea #tower #hour #car #Spa... http://t.co/KrgcaONUv9', 'iFiFa2014'),

(5, '468563035712655360', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup 2⃣3⃣ days to go #worldcup #neymar #brasil ⏰⏰⏰⏰⏰⏰ http://t.co/Y4CQSzWeQD', 'iFiFa2014'),

(6, '468558672776663040', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup #fifaworldcup #neymar #cr7 #messi #futebol #nike #brasil http://t.co/ozJWxSKCg0', 'iFiFa2014'),

(7, '468558669857452032', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup #fifaworldcup #neymar #cr7 #messi #futebol #adidas #argentina http://t.co/t9WwA5ETup', 'iFiFa2014'),

(8, '468558666766254082', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup #fifaworldcup #neymar #cr7 #messi #futebol #portugal http://t.co/NXTCEjOoi8', 'iFiFa2014'),

(9, '468558659870814208', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup #fifaworldcup #neymar #cr7 #messi #futebol #realmadrid http://t.co/qkZNEBqnIt', 'iFiFa2014'),

(10, '468546362808606721', 1, '1400593448', 'RT @iFiFa2014: #Brazil #FIFA2014 #WorldCup Vamos #neymar #brazilian #me #teamfollowback #i #likeforlike #like4like #likeback #l4... http://…', 'pierreharley101'),

(11, '468544057967640577', 1, '1400593448', 'RT @iFiFa2014: #Brazil #FIFA2014 #WorldCup Vamos #neymar #brazilian #me #teamfollowback #i #likeforlike #like4like #likeback #l4... http://…', 'teenagewanderer'),

(12, '468536203751743489', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup Vamos #neymar #brazilian #me #teamfollowback #i #likeforlike #like4like #likeback #l4... http://t.co/Od8Ajktdai', 'iFiFa2014'),

(13, '468532787214286849', 1, '1400593448', '#Brazil #FIFA2014 #WorldCup #neymar #brazilian #me #teamfollowback #i #likeforlike #like4like #likeback #l4l #fol... http://t.co/91tJEFmSv5', 'iFiFa2014');

​