SQL Dump

This is just so a copy of the nowplaying database lives on the blockchain

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.18-0ubuntu0.17.04.1)
# Database: nowplaying
# Generation Time: 2018-02-13 13:51:50 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table posts
# ------------------------------------------------------------

DROP TABLE IF EXISTS `posts`;

CREATE TABLE `posts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author` varchar(20) NOT NULL DEFAULT '',
  `permlink` varchar(500) NOT NULL DEFAULT '',
  `scraped` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created` timestamp NULL DEFAULT NULL,
  `votes` int(11) NOT NULL DEFAULT '0',
  `did_vote` tinyint(4) NOT NULL DEFAULT '0',
  `did_comment` tinyint(4) NOT NULL DEFAULT '0',
  `is_approved` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `author` (`author`,`permlink`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;

INSERT INTO `posts` (`id`, `author`, `permlink`, `scraped`, `created`, `votes`, `did_vote`, `did_comment`, `is_approved`)
VALUES
    (98,'operahoser','now-playing-week-3-conspiracy-music-guru','2018-01-20 23:04:58','2018-01-20 01:42:30',4,1,1,1),
    (99,'amos1969','now-playing-week-3-the-levellers-one-way','2018-01-20 23:04:58','2018-01-19 22:10:03',4,1,1,1),
    (100,'yourfriendbil','now-playing-week-3-time-to-get-funky','2018-01-20 23:04:58','2018-01-19 20:54:42',5,1,1,1),
    (101,'muklis','now-playing-week-3-aerosmiht-i-don-t-wanna-miss-a-thing','2018-01-20 23:04:58','2018-01-19 18:26:30',4,1,1,1),
    (102,'gpieromusic','now-playing-week-3-the-intermission-project','2018-01-20 23:04:58','2018-01-19 16:07:18',6,1,1,1),
    (103,'angeljames','now-playing-week-3','2018-01-20 23:04:58','2018-01-19 16:06:27',2,1,1,1),
    (104,'psicologo','now-playing-week-3-jamiroquai','2018-01-20 23:04:58','2018-01-19 15:55:33',8,1,1,1),
    (105,'esaug','now-playing-week-3-radio-head','2018-01-20 23:04:58','2018-01-19 14:38:06',7,1,1,1),
    (106,'darryljonesjr','now-playing-week-3','2018-01-20 23:04:58','2018-01-19 05:55:39',3,1,1,1),
    (107,'v1tko','now-playing-week-3','2018-01-20 23:04:58','2018-01-19 05:52:51',5,1,1,1),
    (108,'enolderman','now-playing-week-3-beats-but-no-carrots','2018-01-20 23:04:58','2018-01-19 03:06:18',6,1,1,1),
    (109,'estebanrojas','now-playing-week-3','2018-01-20 23:04:58','2018-01-18 15:56:42',3,1,1,1),
    (110,'ericosman','now-playing-1-17-hundreds-of-sparrows','2018-01-20 23:04:58','2018-01-17 21:04:48',4,1,1,1),
    (111,'popsoz','now-playing-week-3','2018-01-20 23:04:58','2018-01-15 22:18:03',5,1,1,1),
    (114,'ericosman','now-playing-1-12-in-my-life','2018-01-20 23:11:25','2018-01-13 04:15:48',7,1,1,1),
    (116,'ericosman','nowplaying-new-years-edition','2018-01-20 23:12:06','2018-01-02 02:41:03',11,1,1,1),
    (117,'ericosman','first-steemit-post-now-spinning','2018-01-20 23:12:27','2017-12-28 22:52:18',8,1,1,1),
    (118,'louie-jr','now-playing-week-2','2018-01-20 23:13:25','2018-01-08 19:10:09',4,1,1,1),
    (120,'popsoz','now-playing-week-2','2018-01-20 23:14:15','2018-01-09 21:41:42',1,1,1,1),
    (121,'popsoz','nowplaying-week-1','2018-01-20 23:14:34','2018-01-01 23:03:48',22,1,1,1),
    (122,'jrovner','now-playing-week-2','2018-01-20 23:15:08','2018-01-13 19:21:27',5,1,1,1),
    (123,'jrovner','nowplaying-whitney-light-upon-the-lake','2018-01-20 23:15:32','2017-12-31 15:16:39',4,1,1,1),
    (200,'walnut1','now-playing-week-3-hawaiian-tunes','2018-01-20 23:31:41','2018-01-18 22:23:06',9,1,1,1),
    (242,'mochawoo','now-playing-week-3','2018-01-20 23:56:48','2018-01-20 22:54:12',5,1,1,1),
    (335,'bennettitalia','now-playing-week-3-vampire-weekend','2018-01-21 00:58:34','2018-01-21 05:22:33',12,1,1,1),
    (811,'hanlovello','now-playing-week-4','2018-01-21 03:26:22','2018-01-21 08:15:33',6,1,1,1),
    (835,'v1tko','now-playing-week-4','2018-01-21 03:31:57','2018-01-21 07:29:03',4,1,1,1),
    (856,'ezinwakelvin','now-playing-week-3-ed-sheeran','2018-01-21 03:37:48','2018-01-21 07:47:06',9,1,1,1),
    (1007,'louie-jr','no-playing-week-3','2018-01-21 04:03:36','2018-01-15 13:33:36',4,1,1,1),
    (1141,'petrajordan','now-playing-week-4','2018-01-21 07:13:11','2018-01-21 09:38:42',5,1,1,1),
    (1187,'popsoz','now-playing-week-4-ocean-man-by-ween','2018-01-21 10:32:54','2018-01-21 15:12:18',7,1,1,1),
    (1188,'angeljames','now-playing-week-4-the-maccabees-no-kind-words','2018-01-21 10:32:54','2018-01-21 13:03:03',10,1,1,1),
    (1189,'darryljonesjr','now-playing-week-4','2018-01-21 10:32:54','2018-01-21 12:14:51',5,1,1,1),
    (1266,'estebanrojas','now-playing-week-4','2018-01-21 14:50:59','2018-01-21 19:45:57',2,1,1,1),
    (1347,'ericosman','now-playing-1-13-every-time-the-feeling','2018-01-21 14:58:22','2018-01-13 19:21:00',5,1,1,1),
    (1348,'ericosman','nowplaying-1-2-everyday-people','2018-01-21 14:58:49','2018-01-02 22:59:54',3,1,1,1),
    (1349,'jmares','now-playing-week-4-flintstones-by-jacob-collier','2018-01-21 20:11:09','2018-01-21 21:21:09',5,1,1,1),
    (1350,'amos1969','now-playing-week-4-nick-cave-and-the-bad-sees-red-right-hand','2018-01-21 20:11:09','2018-01-21 20:44:39',4,1,1,1),
    (1407,'mindseye-music','now-playing-week-4','2018-01-21 21:21:43','2018-01-22 02:19:06',4,1,1,1),
    (1547,'jrovner','now-playing-week-4','2018-01-21 23:20:45','2018-01-22 04:16:51',3,1,1,1),
    (2185,'operahoser','now-playing-week-4-the-new-pornographers','2018-01-22 05:50:09','2018-01-22 09:37:18',4,1,1,1),
    (2197,'indy8phish','now-playing-week-4','2018-01-22 07:32:11','2018-01-22 12:32:06',3,1,1,1),
    (2990,'heypapalegend','now-playing-week-4','2018-01-22 09:48:06','2018-01-22 14:47:33',6,1,1,1),
    (3453,'louie-jr','now-playing-week-4','2018-01-23 08:49:53','2018-01-23 13:49:48',5,1,1,1),
    (12815,'psicologo','now-playing-week-4-the-mars-volta','2018-01-23 23:00:39','2018-01-23 18:19:00',3,1,1,1),
    (12838,'caseywst','now-playing-week-1','2018-01-23 23:02:35','2018-01-23 15:04:39',4,1,1,1),
    (13253,'mochawoo','now-playing-week-4-gang-of-youths','2018-01-23 23:13:25','2018-01-23 17:07:00',6,1,1,1),
    (13293,'indiebandguru','now-playing-week-4','2018-01-23 23:15:46','2018-01-23 16:34:24',4,1,1,1),
    (13371,'manznothot','now-playing-week-4','2018-01-23 23:17:14','2018-01-23 15:00:48',3,1,1,1),
    (17384,'enolderman','now-playing-week-4','2018-01-24 23:43:04','2018-01-24 17:15:18',5,1,1,1),
    (17385,'nomadrituals','now-playing-week-4','2018-01-24 23:43:04','2018-01-24 15:35:30',4,1,1,1),
    (17426,'walnut1','now-playing-week-4','2018-01-24 23:54:37','2018-01-25 04:54:24',10,1,1,1),
    (18372,'majes.tytyty','lou-reed-lyrics-18-i-thought-i-was-someone-good-from-perfect-day-now-playing-week-4','2018-01-25 05:51:30','2018-01-25 07:29:39',16,1,1,1),
    (22029,'bennettitalia','now-playing-week-4-midnight-oil','2018-01-25 12:50:57','2018-01-25 17:50:21',8,1,1,1),
    (22317,'anatolianwishdom','now-playing-week-4-ruefues','2018-01-25 13:10:57','2018-01-25 18:10:27',1,1,1,1),
    (26467,'ezinwakelvin','now-playing-week-4-dead-again-by-asa','2018-01-25 17:47:39','2018-01-25 22:46:30',5,1,1,1),
    (26701,'paragonova','now-playing-week-4-hall-of-fame-the-script-ft-will-i-am','2018-01-25 18:02:39','2018-01-25 23:01:06',1,1,1,1),
    (44899,'power909','new-music-streaming-24-7','2018-01-26 23:16:23','2018-01-26 23:46:18',2,1,1,1),
    (44900,'mrprecious','now-playing-turn-your-lights-down-low-by-bob-marley','2018-01-26 23:16:23','2018-01-26 10:34:06',4,1,1,1),
    (48328,'jampresents','now-playing-week-5-snarky-puppy-lingus','2018-01-28 13:01:58','2018-01-28 15:52:39',12,1,1,1),
    (48329,'nomadrituals','now-playing-week-5','2018-01-28 13:01:58','2018-01-28 15:40:30',7,1,1,1),
    (48330,'tomashofficial','now-playing-week-5-into-the-well-mree','2018-01-28 13:01:58','2018-01-28 15:01:21',8,1,1,1),
    (51943,'ericosman','now-playing-1-22-neil-young-cripple-creek-ferry','2018-01-28 20:29:38','2018-01-27 17:09:27',7,1,1,1),
    (58628,'innocentclair','now-playing-week-5','2018-01-29 08:21:05','2018-01-29 10:35:45',43,1,1,1),
    (58629,'eldontang','now-playing-week-5-poly-math-ekerot','2018-01-29 08:21:05','2018-01-29 09:43:12',7,1,1,1),
    (58630,'angeljames','now-playing-week-5-delta-spirit','2018-01-29 08:21:05','2018-01-29 08:53:06',6,1,1,1),
    (58631,'darryljonesjr','now-playing-week-5','2018-01-29 08:21:05','2018-01-29 08:47:18',4,1,1,1),
    (58633,'majes.tytyty','lou-reed-lyrics-19-free-to-find-a-new-illusion-from-i-m-set-free-now-playing-week-5','2018-01-29 08:21:05','2018-01-29 03:57:57',31,1,1,1),
    (58634,'operahoser','now-playing-week-5-the-berenstein-bears','2018-01-29 08:21:05','2018-01-29 02:24:30',1,1,1,1),
    (58635,'enolderman','now-playing-week-5-lift-you-up','2018-01-29 08:21:05','2018-01-29 01:54:21',6,1,1,1),
    (58636,'v1tko','now-playing-week-5','2018-01-29 08:21:05','2018-01-29 00:57:03',4,1,1,1),
    (58637,'amos1969','now-playing-week-5-rem-losing-my-religion','2018-01-29 08:21:05','2018-01-28 22:47:45',7,1,1,1),
    (58639,'popsoz','now-playing-week-5-should-i-stay-or-should-i-go-kylie-minogue-accompanied-by-jools-holland','2018-01-29 08:21:05','2018-01-28 17:17:33',6,1,1,1),
    (59138,'manznothot','now-playing-week-5','2018-01-29 09:35:57','2018-01-29 14:27:45',2,1,1,1),
    (59139,'louie-jr','now-plays-week-5','2018-01-29 09:35:57','2018-01-29 13:49:33',6,1,1,1),
    (60154,'innocentclair','4gh4pm-now-playing-week-5','2018-01-31 00:09:59','2018-01-31 04:01:03',13,1,1,1),
    (60155,'estebanrojas','steemit-now-playing-week-5','2018-01-31 00:09:59','2018-01-30 21:21:48',4,1,1,1),
    (60156,'paranoidcoder','my-cloud-by-grabbitz-nowplaying','2018-01-31 00:09:59','2018-01-30 15:47:57',2,1,1,1),
    (60157,'indy8phish','now-playing-week-5-the-protomen-act-ii-the-father-of-death','2018-01-31 00:09:59','2018-01-30 15:31:09',3,1,1,1),
    (60158,'azizirazlie','now-playing-week-5','2018-01-31 00:09:59','2018-01-30 04:39:48',10,1,1,1),
    (60159,'jkipo','now-playing-week-5-perfect-2a5a200014376','2018-01-31 00:09:59','2018-01-30 04:06:24',6,1,1,1),
    (60170,'nowplaying-music','spotify-playlist-now-playing-week-4','2018-01-31 00:09:59','2018-01-29 01:49:42',13,1,1,0),
    (60178,'nowplaying-music','now-playing-week-5','2018-01-31 00:09:59','2018-01-28 14:45:51',32,1,1,0),
    (60190,'nowplaying-music','now-playing-week-3-recap','2018-01-31 00:09:59','2018-01-24 06:02:33',6,1,1,0),
    (67630,'psicologo','now-playing-week-5-audioslave-like-a-stone','2018-01-31 07:32:04','2018-01-31 11:21:24',6,1,1,1),
    (69184,'anatolianwishdom','one-of-the-best-turkish-rock-band-lyricks-in-english-duman-oje','2018-01-31 08:36:12','2018-01-31 13:26:33',3,1,1,1),
    (86012,'operahoser','now-playing-week-5-the-tragically-hip','2018-01-31 16:14:17','2018-01-31 21:13:18',5,1,1,1),
    (92450,'ericosman','now-playing-1-31-yo-la-tengo-she-may-she-might','2018-01-31 19:08:19','2018-02-01 00:07:33',5,1,1,1),
    (106743,'sallyswitchblade','now-playing-week-5-shovels-and-rope-birmingham','2018-02-01 17:29:42','2018-02-01 21:32:03',17,1,1,1),
    (107372,'mindseye-music','now-playing-week-5-jeff-rosenstock','2018-02-01 20:14:50','2018-02-02 01:14:18',10,1,1,1),
    (109344,'jmares','now-playing-week-5','2018-02-01 21:12:51','2018-02-02 02:12:00',5,1,1,1),
    (138783,'mochawoo','now-playing-week-5-i-heard-it-from-the-grapevine','2018-02-02 18:29:03','2018-02-02 23:28:33',6,1,1,1),
    (142065,'jrovner','now-playing-week-5','2018-02-02 20:05:04','2018-02-03 01:04:24',5,1,1,1),
    (166595,'loubega','re--nowplaying-20180203t200909541z','2018-02-03 15:09:56','2018-02-03 20:09:09',1,1,1,1),
    (170165,'anatolianwishdom','70s-czech-progresiff-band-modry-efekt','2018-02-03 18:52:14','2018-02-03 22:35:51',4,1,1,1),
    (171929,'loubega','nowplaying-week-6','2018-02-04 00:40:22','2018-02-04 05:40:12',4,1,1,1),
    (172188,'nowplaying-music','nowplaying-week-6','2018-02-04 00:42:40','2018-02-04 05:42:30',26,1,1,0),
    (174355,'jampresents','now-playing-week-6-entry-john-lennon-whatever-gets-you-thru-the-night','2018-02-04 09:50:36','2018-02-04 13:31:24',4,1,1,1),
    (174395,'majes.tytyty','lou-reed-lyrics-20-to-always-make-love-by-proxy-from-how-do-you-think-it-feels-now-playing-week-6','2018-02-04 10:14:49','2018-02-04 10:45:06',20,1,1,1),
    (174432,'popsoz','now-playing-week-6','2018-02-04 10:37:54','2018-02-04 15:17:51',5,1,1,1),
    (174582,'emmanuelnukchee','now-playing-week-6','2018-02-04 11:07:49','2018-02-04 16:07:00',7,1,1,1),
    (175418,'tomashofficial','now-playing-week-6-we-can-be-ghosts-now-hiatus','2018-02-04 11:29:51','2018-02-04 16:29:03',5,1,1,1),
    (176042,'amos1969','now-playing-week-6-grateful-dead-sugar-magnolia','2018-02-04 11:45:50','2018-02-04 16:45:21',5,1,1,1),
    (177829,'nomadrituals','now-playing-week-6','2018-02-04 12:30:50','2018-02-04 17:30:36',4,1,1,1),
    (180429,'enolderman','a-musician-worth-checking-out-now-playing-week-6','2018-02-04 13:35:50','2018-02-04 18:35:03',7,1,1,1),
    (184001,'sallyswitchblade','now-playing-week-6-amelia-curran-and-larkin-poe','2018-02-04 15:03:51','2018-02-04 20:03:45',11,1,1,1),
    (186913,'jgvinstl','now-playing-week-6-cypress-hill','2018-02-05 01:23:20','2018-02-05 05:55:12',17,1,1,1),
    (186914,'v1tko','now-playing-week-6','2018-02-05 01:23:20','2018-02-05 04:41:21',4,1,1,1),
    (186915,'paragonova','now-playing-week-6-hall-of-fame-the-script-0d1333c47b7e8','2018-02-05 01:23:21','2018-02-05 01:19:36',3,1,1,1),
    (186916,'ezinwakelvin','now-playing-week-6-jailer-by-asa-6a193b2a11c7e','2018-02-05 01:23:21','2018-02-05 01:09:48',5,1,1,1),
    (202112,'louie-jr','nowplaying-week-5','2018-02-05 08:20:09','2018-02-05 13:19:42',4,1,1,1),
    (204032,'nowplaying-music','spotify-playlist-week-5-jan-28-feb-3','2018-02-05 09:14:09','2018-02-05 14:13:18',9,1,1,0),
    (212166,'azizirazlie','29zsjk-now-playing-week-6-tobia-sammet-s-avantasia-scarecrow','2018-02-05 13:06:09','2018-02-05 18:05:45',9,1,1,1),
    (212706,'angeljames','now-playing-week-6-girlpool','2018-02-05 13:21:09','2018-02-05 18:21:00',14,1,1,1),
    (214815,'darryljonesjr','now-playing-week-6','2018-02-05 14:18:10','2018-02-05 19:17:27',6,1,1,1),
    (216525,'manznothot','now-playing-week-6','2018-02-05 15:03:10','2018-02-05 20:02:45',21,1,1,1),
    (218475,'rossenpavlov','netsky-rio','2018-02-05 15:53:10','2018-02-05 20:53:00',14,1,1,1),
    (225675,'operahoser','now-playing-week-6-mike-keneally-and-beer-for-dolphins','2018-02-05 18:53:10','2018-02-05 23:53:00',3,1,1,1),
    (227356,'innocentclair','now-playing-week-6','2018-02-05 19:34:10','2018-02-06 00:34:09',11,1,1,1),
    (243536,'asly','so-meaningful-lyrics-and-song-by-turkish-rock-pop-musician-fea5dbfef5167','2018-02-06 02:07:11','2018-02-06 07:06:21',3,1,1,1),
    (244192,'eldontang','now-playing-week-6-dutch-criminal-record-socks-and-sandals','2018-02-06 02:23:11','2018-02-06 07:22:21',35,1,1,1),
    (245872,'anatolianwishdom','have-you-heared-of-turkish-metal-band-pentegram-english-song-1000-in-the-eastland','2018-02-06 03:03:11','2018-02-06 08:02:18',4,1,1,1),
    (258901,'indy8phish','now-playing-week-6-the-frames-what-happens-when-the-heart-just-stops','2018-02-06 08:06:12','2018-02-06 13:05:18',4,1,1,1),
    (275864,'mochawoo','now-playing-week-6-khruangbin','2018-02-06 14:41:13','2018-02-06 19:40:57',4,1,1,1),
    (289003,'fiveart','battles-the-yabba','2018-02-06 19:47:13','2018-02-07 00:46:21',5,1,1,0),
    (309594,'fiveart','herve-x-zebra-katz-tear-the-house-up','2018-02-07 03:38:15','2018-02-07 08:38:06',6,1,1,0),
    (317649,'innocentclair','4fzopo-now-playing-week-6','2018-02-07 06:40:15','2018-02-07 11:39:48',16,1,1,1),
    (343732,'fiveart','the-avalanches-because-i-m-me','2018-02-07 16:40:16','2018-02-07 21:39:18',11,1,1,0),
    (360322,'innocentclair','2ged2n-now-playing-week-6','2018-02-07 23:08:17','2018-02-08 04:07:18',12,1,1,1),
    (361360,'v1tko','2ugnic-now-playing-week-6','2018-02-07 23:32:17','2018-02-08 04:31:21',8,1,1,1),
    (370483,'azizirazlie','nowplaying-week-6','2018-02-08 02:45:20','2018-02-08 07:45:03',8,1,1,1),
    (381005,'majes.tytyty','lou-reed-lyrics-21-life-is-meant-to-be-more-than-this-from-caroline-says-2-now-playing-week-6','2018-02-08 05:46:21','2018-02-08 10:46:06',18,1,1,1),
    (388245,'fiveart','superorganism-everybody-wants-to-be-famous','2018-02-08 07:48:22','2018-02-08 12:47:33',11,1,1,0),
    (412282,'bohmanok','music-playing-drumer-9a8f296c0861c','2018-02-08 13:52:08','2018-02-08 18:39:21',3,1,1,1),
    (436914,'derrickdso','now-playing-week-6-janelle-destroy','2018-02-08 19:41:09','2018-02-09 00:40:24',3,1,1,1),
    (440932,'jrovner','now-playing-week-6','2018-02-08 20:38:44','2018-02-09 01:38:42',3,1,1,1),
    (460238,'bandmxo88','nowplaying-week-6-armada-asal-kau-bahagia','2018-02-09 21:25:06','2018-02-09 08:18:48',5,1,1,1),
    (460272,'dianasteem7','singsong-bfmv-5489378ac51c6','2018-02-09 21:27:45','2018-02-08 05:33:21',11,1,1,0),
    (460324,'ibnuhubban','aceh-song-entitled-ujeun-rhoet-rain-that-descends-from-the-sky-or-untalented-singsong-7d4147364cc3c','2018-02-09 21:28:15','2018-02-06 12:53:48',9,1,1,0),
    (460715,'bandmxo88','nowplaying-week-6-payung-teduh-akad-menikahlah-official-lyric-video','2018-02-09 22:35:53','2018-02-09 18:11:15',4,1,1,1),
    (461774,'hazel420','now-playing-week-6-entry-kutiman-inner-galactic-lovers-kutiman-mixes-fiverr','2018-02-10 07:24:55','2018-02-09 14:49:21',7,1,1,0),
    (462816,'asly','the-video-which-made-anne-marie-known-in-turkey-82aa97071ee6e','2018-02-10 19:05:35','2018-02-08 14:07:42',4,1,1,0),
    (462925,'ericosman','now-playing-2-10-screaming-females-rose-mountain','2018-02-10 19:29:30','2018-02-10 18:59:42',6,1,1,1),
    (462926,'hazramiami','top-10-best-places-and-cities-to-visit-in-the-uk-1b91fbeec86a','2018-02-10 19:29:30','2018-02-10 11:02:33',4,1,1,0),
    (462927,'fiveart','damian-jr-gong-marley-speak-life','2018-02-10 19:29:30','2018-02-10 10:25:15',4,1,1,0),
    (462928,'mindseye-music','dpbfs-steemit-record-pool-song-of-the-day-cirrus-by-bonobo','2018-02-10 19:29:30','2018-02-10 06:44:42',8,1,1,1),
    (462929,'nasrul71','b5435990-0e07-11e8-956c-1531c3d89b8c','2018-02-10 19:29:30','2018-02-10 02:24:21',4,1,1,0),
    (462930,'fiveart','fkj-and-pomo-lucky-star','2018-02-10 19:29:30','2018-02-09 19:27:51',3,1,1,0),
    (462931,'fiveart','la-chica-be-able','2018-02-10 19:29:30','2018-02-09 18:47:27',4,1,1,0),
    (462932,'fiveart','ibeyi-river','2018-02-10 19:29:30','2018-02-09 18:35:00',3,1,1,0),
    (462935,'clicknpict2','like-where-the-steemit-concern-to-me-tonight-4b24d4ea3066d','2018-02-10 19:29:30','2018-02-09 14:14:30',1,1,1,0),
    (462937,'clicknpict2','funniest-mma-boxing-moments-zg1hbmlh-w1il5','2018-02-10 19:29:31','2018-02-09 04:27:24',5,1,1,0),
    (462941,'ibnuhubban','i-try-to-sedate-you-with-my-golden-voice-or-untalented-singsong-36b5a34e62c62','2018-02-10 19:29:31','2018-02-08 15:18:21',10,1,1,0),
    (462943,'nasrul71','my-song-for-you','2018-02-10 19:29:31','2018-02-08 12:47:48',6,1,1,0),
    (462952,'nasrul71','special-for-surpassinggoogle-at-untalented-singsong','2018-02-10 19:29:31','2018-02-07 13:10:36',3,1,1,0),
    (462958,'nasrul71','lagu-pasangan-pengantin-baru-zg1hbmlh-cgpwy','2018-02-10 19:29:31','2018-02-06 19:07:15',4,1,1,0),
    (462964,'ibnuhubban','expressive-children-s-photo-tips-caedbe36d460c','2018-02-10 19:29:32','2018-02-06 06:52:15',11,1,1,0),
    (462973,'ahmadnizari1','my-entry-untalented-singsong-contest-by-surpassinggoogle-4359014899c67','2018-02-10 19:29:32','2018-02-05 09:06:15',3,1,1,0),
    (462980,'nasrul71','bitcoin-its-number-one-zg1hbmlh-dfgc2','2018-02-10 19:29:32','2018-02-04 19:03:06',4,1,1,0),
    (463791,'nasrul71','electric-power-of-the-tree-kedondong-0120ec4352e21','2018-02-10 19:54:28','2018-02-10 18:47:15',0,0,0,0),
    (470141,'markiful','promo-steem-2018-02-08-04-45-07','2018-02-10 21:45:41','2018-02-08 04:45:33',4,0,0,0),
    (470174,'markiful123','cover-to-the-untalented-singsong-contest-by-surpassinggoogle','2018-02-10 21:45:42','2018-02-04 18:47:06',4,0,0,0),
    (470253,'maxwell95','top-10-all-time-romantic-songs-that-have-and-will-survive-through-centuries','2018-02-10 21:48:53','2018-02-08 07:38:15',16,0,0,0),
    (470254,'maxwell95','follow-the-music-by-maxwell-bruno-65c380125fb76','2018-02-10 21:48:53','2018-02-06 23:18:42',23,0,0,0),
    (470378,'sidneybrown','sweater-weather-cover-must-watch','2018-02-10 21:49:57','2018-02-04 21:14:39',13,0,0,0),
    (470660,'hazramiami','genjot-visits-wisman-5-countries-it-targeted-kemenpar-fced61806576a','2018-02-11 01:14:54','2018-02-11 03:21:09',12,0,0,0),
    (473625,'ayoyemi','now-playing-week-7-beautiful-nubia','2018-02-11 01:59:33','2018-02-11 06:59:27',5,1,1,1),
    (475266,'enolderman','vulnerability-is-strength-now-playing-week-7','2018-02-11 02:23:33','2018-02-11 07:22:39',8,1,1,1),
    (481202,'fiveart','r-a-the-rugged-man-look-what-you-made-me-do-taylor-swift-remix','2018-02-11 03:49:33','2018-02-11 08:49:03',4,0,0,0),
    (492654,'fiveart','superorganism-something-for-your-m-i-n-d','2018-02-11 06:33:34','2018-02-11 11:33:12',0,0,0,0),
    (493138,'fiveart','portugal-the-man-noise-pollution','2018-02-11 06:40:34','2018-02-11 11:39:42',7,0,0,0),
    (496988,'walnut1','now-playing-week-7','2018-02-11 07:35:34','2018-02-11 12:34:42',11,1,1,1),
    (499718,'fiveart','chinese-man-wolf','2018-02-11 08:14:34','2018-02-11 13:14:00',1,0,0,0),
    (509437,'popsoz','now-playing-week-7','2018-02-11 10:33:35','2018-02-11 15:32:48',5,1,1,1),
    (516393,'tomashofficial','now-playing-week-7-night-of-the-long-knives-everything-everything','2018-02-11 14:42:29','2018-02-11 19:18:12',4,1,1,1),
    (516394,'nomadrituals','now-playing-week-7','2018-02-11 14:42:29','2018-02-11 19:01:15',4,1,1,1),
    (516395,'dnokz','introducing-myself-bae8ce9fb7c54','2018-02-11 14:42:29','2018-02-11 18:46:33',6,0,0,0),
    (516396,'gtelefon','now-playing-week-7','2018-02-11 14:42:29','2018-02-11 18:41:24',3,1,1,1),
    (516397,'fiveart','wicked-dub-division-meets-north-east-ska-jazz-orchestra-mama','2018-02-11 14:42:29','2018-02-11 18:06:57',1,0,0,0),
    (516398,'markiful','beautiful-sunset-2018-02-11-18-04-20','2018-02-11 14:42:29','2018-02-11 18:04:27',2,0,0,0),
    (516419,'leoagus','once-released-despacito-is-best-758c9d0cc7ab7','2018-02-11 14:42:30','2018-02-09 03:20:27',5,0,0,0),
    (519110,'jampresents','now-playing-week-7-esperanza-spalding-black-gold','2018-02-11 15:20:49','2018-02-11 20:20:36',4,1,1,1),
    (524616,'amos1969','now-playing-week-7-billy-bragg-world-turned-upside-down','2018-02-11 16:41:49','2018-02-11 21:41:12',3,1,1,1),
    (525298,'louie-jr','now-playing-week-7','2018-02-11 16:51:49','2018-02-11 21:51:00',10,1,1,1),
    (529737,'jgvinstl','now-playing-week-7-ween','2018-02-11 17:55:49','2018-02-11 22:55:15',14,1,1,1),
    (530652,'manznothot','now-playing-week-7','2018-02-11 18:08:49','2018-02-11 23:08:09',5,1,1,1),
    (531509,'fiveart','flying-lotus-post-requisite','2018-02-11 18:20:50','2018-02-11 23:20:24',4,0,0,0),
    (563798,'markiful','run-for-a-post-2018-02-08-11-38-43','2018-02-12 02:02:52','2018-02-08 11:38:51',2,0,0,0),
    (564716,'darryljonesjr','now-playing-week-7','2018-02-12 02:16:51','2018-02-12 07:16:24',5,1,1,1),
    (565340,'v1tko','now-playing-week-7','2018-02-12 02:25:51','2018-02-12 07:25:24',8,1,1,1),
    (571395,'fiveart','princess-nokia-orange-blossom','2018-02-12 03:51:51','2018-02-12 08:50:57',1,0,0,0),
    (589140,'angeljames','now-playing-week-7-young-the-giant','2018-02-12 08:03:52','2018-02-12 13:03:42',9,1,1,1),
    (592602,'arjimi','now-playing-week-7-hangar-18-by-megadeth','2018-02-12 08:52:52','2018-02-12 13:52:21',8,1,1,1),
    (615638,'mochawoo','now-playing-week-7-arctic-monkeys','2018-02-12 14:17:53','2018-02-12 19:17:33',3,1,1,1),
    (622848,'estebanrojas','now-playing-week-7','2018-02-12 16:02:53','2018-02-12 21:02:18',5,1,1,1),
    (631050,'paouzcategui','now-playing-week-7','2018-02-12 18:02:54','2018-02-12 23:02:06',5,1,1,1),
    (637251,'acmu','now-playing-week-7','2018-02-12 19:32:54','2018-02-13 00:31:57',4,1,1,1),
    (637525,'rmaa','now-playing-week-7','2018-02-12 19:36:54','2018-02-13 00:36:36',2,1,1,1),
    (638078,'lysa2018','now-playing-week-7','2018-02-12 19:44:54','2018-02-13 00:44:15',3,1,1,1),
    (663755,'operahoser','now-playing-week-7-adrian-belew-inner-revolution','2018-02-13 01:49:57','2018-02-13 06:49:39',3,1,1,1),
    (674450,'azizirazlie','nowplaying-week-7-metallica-kill-the-king','2018-02-13 04:26:58','2018-02-13 09:26:15',6,1,1,1),
    (690611,'v1tko','4qjzxx-now-playing-week-7','2018-02-13 08:23:58','2018-02-13 13:23:48',4,1,1,1),
    (690949,'angeljames','now-playing-week-7-mellow-fellow','2018-02-13 08:28:58','2018-02-13 13:28:39',4,1,1,1),
    (691769,'arjimi','now-playing-7-the-strokes-reptilia','2018-02-13 08:40:58','2018-02-13 13:40:48',3,1,1,1),
    (692323,'eldontang','now-playing-week-7-buddy-holly-heartbeat','2018-02-13 08:48:58','2018-02-13 13:48:27',1,1,1,1);

/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table spotifyRef
# ------------------------------------------------------------

DROP TABLE IF EXISTS `spotifyRef`;

CREATE TABLE `spotifyRef` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `postId` int(11) NOT NULL,
  `artistId` int(11) NOT NULL,
  `songId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `username` varchar(100) NOT NULL DEFAULT '',
  `xp` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`username`, `xp`)
VALUES
    ('amos1969',5),
    ('anatolianwishdom',0),
    ('angeljames',5),
    ('bennettitalia',5),
    ('caseywst',0),
    ('cretem',0),
    ('darryljonesjr',5),
    ('deleo-official',0),
    ('eldontang',0),
    ('enolderman',5),
    ('ericosman',5),
    ('esaug',5),
    ('estebanrojas',5),
    ('ezinwakelvin',5),
    ('gpieromusic',5),
    ('hanlovello',5),
    ('heypapalegend',0),
    ('indiebandguru',0),
    ('indy8phish',0),
    ('innocentclair',0),
    ('jampresents',0),
    ('jmares',0),
    ('jrovner',0),
    ('louie-jr',5),
    ('majes.tytyty',0),
    ('manznothot',0),
    ('mindseye-music',0),
    ('mochawoo',5),
    ('mrprecious',0),
    ('muklis',5),
    ('nomadrituals',0),
    ('operahoser',5),
    ('paragonova',0),
    ('petrajordan',0),
    ('popsoz',5),
    ('power909',0),
    ('psicologo',5),
    ('sidneybrown',0),
    ('tomashofficial',0),
    ('v1tko',15),
    ('walnut1',15),
    ('yourfriendbil',5);

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table weeks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `weeks`;

CREATE TABLE `weeks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `payout` float DEFAULT NULL,
  `startWeek` tinyint(4) NOT NULL DEFAULT '0',
  `recap` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `weeks` WRITE;
/*!40000 ALTER TABLE `weeks` DISABLE KEYS */;

INSERT INTO `weeks` (`id`, `payout`, `startWeek`, `recap`)
VALUES
    (1,0,1,1),
    (2,0,1,1),
    (3,1.724,1,1),
    (4,3.6,1,1),
    (5,NULL,1,0),
    (6,NULL,0,0);

/*!40000 ALTER TABLE `weeks` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;