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 */;
m
f
a
z
b
i
n
wq
c
m
y
d
j
cc
mi
a
ii
ew
j
a
j
a
few
ge
oo
jo
a
sse
a
c
pl
cc
k
mm
m
a
yt
q
e
e
e
m
h
99
a
d
g
ea
c
r
ve
a
ews
cvd
nto
fer
teg
m
me
c
a
g
v
d
l
d
i
r
g
a
h
y
m
i
c
d
e
a
c
y
c
v
v
o
ce
fe
f43
aa
cef
be
e
https://open.spotify.com/embed?uri=spotify:user:1240132288:playlist:3534YIz6z0SCnvXEdnYkKM
a
1
no
d
c
e
a
b
2
w
a
g
ff
m
o
mc
3
ne
la
a
c
a
t
da
c
d
l
ee
d
ga
ac
aczz
sk
b
c
z
zz
s
w
Thanks for entering this week's #nowplaying!
Hanging this baby on the fridge!
thx @popsoz dear