Blame | Last modification | View Log | RSS feed
-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (x86_64)---- Host: localhost Database: cheapmusic-- -------------------------------------------------------- Server version 5.1.73/*!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 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!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 */;---- Table structure for table `coupons`--DROP TABLE IF EXISTS `coupons`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `coupons` (`id` int(7) NOT NULL AUTO_INCREMENT,`advertiser` varchar(32) NOT NULL,`startdate` datetime NOT NULL,`enddate` datetime NOT NULL,`description` varchar(256) NOT NULL,`couponcode` varchar(32) NOT NULL,`url` varchar(256) NOT NULL,`pixel` varchar(256) NOT NULL,PRIMARY KEY (`id`),KEY `startdate` (`startdate`),KEY `enddate` (`enddate`)) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `coupons`--LOCK TABLES `coupons` WRITE;/*!40000 ALTER TABLE `coupons` DISABLE KEYS */;INSERT INTO `coupons` VALUES (13,'Musicnotes','2019-03-04 00:00:00','2019-12-31 00:00:00','25% Off Orders of $25 or More','MNAF25','https://click.linksynergy.com/fs-bin/click?id=c6/hJezRA68&offerid=395807.10000682&type=3&subid=0','https://ad.linksynergy.com/fs-bin/show?id=c6/hJezRA68&bids=395807.10000682&type=3&subid=0'),(14,'Musicnotes','2019-02-04 00:00:00','2019-12-31 00:00:00','5% Off Orders of $10 or More','MNAF5','https://click.linksynergy.com/fs-bin/click?id=c6/hJezRA68&offerid=395807.10000680&type=3&subid=0','https://ad.linksynergy.com/fs-bin/show?id=c6/hJezRA68&bids=395807.10000680&type=3&subid=0'),(15,'Musicnotes','2019-01-03 00:00:00','2019-12-31 00:00:00','Join Musicnotes Pro - Save 15% on all Orders - Free PDFs inc. Transpositions!','','https://click.linksynergy.com/fs-bin/click?id=c6/hJezRA68&offerid=395807.10000678&type=3&subid=0','https://ad.linksynergy.com/fs-bin/show?id=c6/hJezRA68&bids=395807.10000678&type=3&subid=0'),(16,'Musicnotes','2018-09-04 00:00:00','2024-09-03 00:00:00','MusiciansLike You Save Over $40 Every Year with Musicnotes Pro!','','https://click.linksynergy.com/fs-bin/click?id=c6/hJezRA68&offerid=395807.10000653&type=3&subid=0','https://ad.linksynergy.com/fs-bin/show?id=c6/hJezRA68&bids=395807.10000653&type=3&subid=0'),(88,'FYE.com','2019-06-06 00:00:00','2019-07-11 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.dpbolvw.net/click-9093269-13710657','https://www.lduhtrp.net/image-9093269-13710657\r'),(89,'FYE.com','2019-06-13 00:00:00','2019-07-25 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.dpbolvw.net/click-9093269-13710659','https://www.lduhtrp.net/image-9093269-13710659\r'),(90,'FYE.com','2019-06-27 00:00:00','2019-07-03 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.dpbolvw.net/click-9093269-13754894','https://www.tqlkg.com/image-9093269-13754894\r'),(91,'FYE.com','2019-07-06 00:00:00','2019-07-10 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.jdoqocy.com/click-9093269-13754896','https://www.ftjcfx.com/image-9093269-13754896\r'),(92,'FYE.com','2019-07-13 00:00:00','2019-07-14 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.kqzyfj.com/click-9093269-13754899','https://www.tqlkg.com/image-9093269-13754899\r'),(93,'FYE.com','2019-07-14 00:00:00','2019-07-17 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.jdoqocy.com/click-9093269-13754948','https://www.awltovhc.com/image-9093269-13754948\r'),(94,'FYE.com','2019-07-19 00:00:00','2019-07-24 00:00:00','15% off everything (excludes sale, pre-order & exclusives)','','https://www.dpbolvw.net/click-9093269-13754950','https://www.lduhtrp.net/image-9093269-13754950\r'),(95,'FYE.com','2019-07-10 00:00:00','2019-07-13 00:00:00','20% off when you spend $25 or more (excludes sale, pre-order, exclusives)','','https://www.kqzyfj.com/click-9093269-13754898','https://www.ftjcfx.com/image-9093269-13754898\r'),(96,'FYE.com','2019-07-18 00:00:00','2019-07-19 00:00:00','25% off when you spend $30 or more (excludes sale, pre-order, exclusives)','','https://www.tkqlhce.com/click-9093269-13754949','https://www.awltovhc.com/image-9093269-13754949\r'),(97,'FYE.com','2019-07-03 00:00:00','2019-07-06 00:00:00','4th of July Weekend Sale- spend $30, get 25% off (excludes sale, pre-order, exclusives)','','https://www.tkqlhce.com/click-9093269-13754895','https://www.tqlkg.com/image-9093269-13754895\r'),(98,'FYE.com','2019-06-11 00:00:00','2019-07-13 00:00:00','Flash sale, spend $30, get 25% off (excludes sale, pre-order, exclusives)','','https://www.jdoqocy.com/click-9093269-13710658','https://www.lduhtrp.net/image-9093269-13710658\r'),(99,'FYE.com','2019-06-25 00:00:00','2019-07-27 00:00:00','Flash sale, spend $30, get 25% off (excludes sale, pre-order, exclusives)','','https://www.dpbolvw.net/click-9093269-13710660','https://www.ftjcfx.com/image-9093269-13710660\r'),(100,'FYE.com','2019-06-04 00:00:00','2019-07-06 00:00:00','Flash Sale: 20% off all reg. price music and movies','','https://www.jdoqocy.com/click-9093269-13710656','https://www.tqlkg.com/image-9093269-13710656\r'),(101,'Secondspin.com','2019-07-02 00:00:00','2019-07-03 00:00:00','Buy 2 Items, Get 3rd for $1','B2G9JL','https://www.dpbolvw.net/click-9093269-13763611','https://www.tqlkg.com/image-9093269-13763611\r'),(102,'Secondspin.com','2019-07-05 00:00:00','2019-07-08 00:00:00','Buy 3, Get 4th for FREE','SSB3JY9','https://www.dpbolvw.net/click-9093269-13763620','https://www.ftjcfx.com/image-9093269-13763620\r'),(103,'Secondspin.com','2019-06-28 00:00:00','2019-07-18 00:00:00','Favorite DVDs 30-60% off','','https://www.jdoqocy.com/click-9093269-13763608','https://www.awltovhc.com/image-9093269-13763608\r'),(104,'Secondspin.com','2019-06-14 00:00:00','2019-07-04 00:00:00','Half Price Blu-ray','','https://www.kqzyfj.com/click-9093269-13747758','https://www.awltovhc.com/image-9093269-13747758\r'),(105,'Secondspin.com','2019-06-14 00:00:00','2019-07-04 00:00:00','Half Price CDs at Second Spin','','https://www.kqzyfj.com/click-9093269-13747759','https://www.awltovhc.com/image-9093269-13747759\r'),(106,'Secondspin.com','2019-06-28 00:00:00','2019-07-18 00:00:00','Hit CDs 30-60% off','','https://www.jdoqocy.com/click-9093269-13763607','https://www.tqlkg.com/image-9093269-13763607\r'),(107,'Secondspin.com','2017-07-26 00:00:00','2020-06-15 00:00:00','SecondSpin.com Flat Rate Shipping','','https://www.tkqlhce.com/click-9093269-12976211','https://www.ftjcfx.com/image-9093269-12976211\r'),(108,'Secondspin.com','2019-07-04 00:00:00','2019-07-04 00:00:00','Spend $30, Get 30% off','4THJULY9','https://www.kqzyfj.com/click-9093269-13763614','https://www.lduhtrp.net/image-9093269-13763614\r'),(109,'Sheet Music Plus','2019-06-11 00:00:00','2019-07-02 00:00:00','20% OFF G Schirmer','','https://www.dpbolvw.net/click-9093269-13735708','https://www.tqlkg.com/image-9093269-13735708\r'),(110,'Sheet Music Plus','2019-06-11 00:00:00','2019-07-03 00:00:00','20% OFF G. Schirmer','','https://www.dpbolvw.net/click-9093269-13735711','https://www.awltovhc.com/image-9093269-13735711\r'),(111,'Sheet Music Plus','2019-06-11 00:00:00','2019-07-02 00:00:00','20% OFF G. Schirmer','','https://www.anrdoezrs.net/click-9093269-13686454','https://www.awltovhc.com/image-9093269-13686454\r'),(112,'Sheet Music Plus','2019-06-11 00:00:00','2019-07-02 00:00:00','20% OFF G. Schirmer','','https://www.jdoqocy.com/click-9093269-13657168','https://www.lduhtrp.net/image-9093269-13657168\r'),(113,'Sheet Music Plus','2019-06-11 00:00:00','2019-07-02 00:00:00','20% OFF G. Schirmer','','https://www.tkqlhce.com/click-9093269-13686411','https://www.lduhtrp.net/image-9093269-13686411\r'),(114,'Sheet Music Plus','2019-05-29 00:00:00','2028-06-18 00:00:00','20% OFF Musical Theater Sheet Music! Shop music from the stage to the page','','https://www.tkqlhce.com/click-9093269-13735732','https://www.ftjcfx.com/image-9093269-13735732\r'),(115,'Sheet Music Plus','2019-05-29 00:00:00','2028-06-18 00:00:00','20% OFF Musical Theater Sheet Music! Shop music from the stage to the page','','https://www.anrdoezrs.net/click-9093269-13735712','https://www.lduhtrp.net/image-9093269-13735712\r'),(116,'Sheet Music Plus','2019-05-29 00:00:00','2028-06-18 00:00:00','20% OFF Musical Theater Sheet Music! Shop music from the stage to the page','','https://www.anrdoezrs.net/click-9093269-13735730','https://www.lduhtrp.net/image-9093269-13735730\r'),(117,'Sheet Music Plus','2019-05-29 00:00:00','2028-06-18 00:00:00','20% OFF Musical Theater Sheet Music! Shop music from the stage to the page','','https://www.jdoqocy.com/click-9093269-13735739','https://www.awltovhc.com/image-9093269-13735739\r'),(118,'Sheet Music Plus','2019-05-29 00:00:00','2028-06-18 00:00:00','20% OFF Musical Theater Sheet Music! Shop music from the stage to the page','','https://www.kqzyfj.com/click-9093269-13735734','https://www.awltovhc.com/image-9093269-13735734\r'),(119,'Sheet Music Plus','2019-06-12 00:00:00','2019-07-09 00:00:00','Female Composers Sale! Get 20% OFF!','','https://www.tkqlhce.com/click-9093269-13676865','https://www.awltovhc.com/image-9093269-13676865\r'),(120,'Sheet Music Plus','2019-06-12 00:00:00','2019-07-09 00:00:00','Female Composers Sale, get 20% off!','','https://www.dpbolvw.net/click-9093269-13735703','https://www.lduhtrp.net/image-9093269-13735703\r'),(121,'Sheet Music Plus','2019-06-12 00:00:00','2019-07-09 00:00:00','Female Composers Sale, get 20% off!','','https://www.kqzyfj.com/click-9093269-13735702','https://www.tqlkg.com/image-9093269-13735702\r'),(122,'Sheet Music Plus','2019-06-12 00:00:00','2019-07-09 00:00:00','Female Composers Sale, get 20% off!','','https://www.tkqlhce.com/click-9093269-13735655','https://www.lduhtrp.net/image-9093269-13735655\r'),(123,'Sheet Music Plus','2019-06-12 00:00:00','2019-07-09 00:00:00','Female Composers Sale, get 20% off!','','https://www.jdoqocy.com/click-9093269-13735706','https://www.awltovhc.com/image-9093269-13735706\r');/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2019-07-01 18:06:49