-- MySQL dump 10.14  Distrib 5.5.46-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cc_adexchange_live
-- ------------------------------------------------------
-- Server version	5.5.46-MariaDB-1ubuntu0.14.04.2

/*!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 `advertiser_webpage`
--

DROP TABLE IF EXISTS `advertiser_webpage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `advertiser_webpage` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `webpage_name` varchar(255) DEFAULT '',
  `advertiser_id` int(11) DEFAULT NULL,
  `body_bg_color` varchar(150) DEFAULT NULL,
  `heading_bg_color` varchar(150) DEFAULT NULL,
  `heading_txt_color` varchar(150) DEFAULT NULL,
  `heading_text` varchar(255) DEFAULT NULL,
  `mid_bg_color` varchar(150) DEFAULT NULL,
  `mid_txt_color` varchar(150) DEFAULT NULL,
  `mid_text` tinytext,
  `mid_image_isflg` enum('0','1') DEFAULT '1',
  `mid_imagename` varchar(255) DEFAULT NULL,
  `mid_youtube_url` tinytext,
  `footer_bg_color` varchar(150) DEFAULT NULL,
  `footer_txt_color` varchar(150) DEFAULT NULL,
  `footer_address` varchar(255) DEFAULT NULL,
  `footer_phone` varchar(50) DEFAULT NULL,
  `footer_email` varchar(255) DEFAULT NULL,
  `added_date` datetime DEFAULT NULL,
  `modified_date` datetime DEFAULT NULL,
  `url` varchar(150) NOT NULL,
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `advertiser_webpage`
--

LOCK TABLES `advertiser_webpage` WRITE;
/*!40000 ALTER TABLE `advertiser_webpage` DISABLE KEYS */;
INSERT INTO `advertiser_webpage` VALUES (1,'vikram\'s dhaba',30,'rgb(145, 88, 88)','rgb(31, 26, 5)','rgb(255, 255, 255)','Khao pio so jaao','rgb(245, 245, 245)','rgb(0, 0, 0)','testing wala dhaba','1','buyerid.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','my address','123456789','vikram@collectcent.com','2016-05-14 08:42:31','2016-05-14 08:42:31','http://localhost/anui/public/Y29sbGVjdGNlbnQtd3BfMQ=='),(2,'',30,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://localhost/anui/public/30/2'),(3,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','1234567890','email@email.com','2016-05-16 09:46:48','2016-05-16 09:46:48','http://localhost/anui/public/wp/30'),(4,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','1234567890','email@email.com','2016-05-16 09:47:12','2016-05-16 09:47:12','http://localhost/anui/public/wp/30/4'),(5,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','1234567890','email@email.com','2016-05-16 09:47:40','2016-05-16 09:47:40','http://localhost/anui/public/wp/30/5'),(6,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','1234567890','email@email.com','2016-05-16 10:00:08','2016-05-16 10:00:08','http://localhost/anui/public/wp/30/6'),(7,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','1234567890','email@email.com','2016-05-16 10:01:13','2016-05-16 10:01:13','http://localhost/anui/public/wp/30/7'),(8,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','12345678901','email@email.com','2016-05-16 10:05:27','2016-05-16 10:05:27','http://localhost/anui/public/wp/30/8'),(9,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','12345678902','email@email.com','2016-05-16 10:12:21','2016-05-16 10:12:21','http://localhost/anui/public/wp/30/9'),(10,'namename',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','headeing heading','rgb(245, 245, 245)','rgb(0, 0, 0)','description description','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','addressaddress','12345678902','email@email.com','2016-05-16 10:12:53','2016-05-16 10:12:53','http://localhost/anui/public/wp/30/10'),(11,'hello',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','how are you','rgb(245, 245, 245)','rgb(0, 0, 0)','description of advertisement','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','address','7878787878','manoj@manoj.com','2016-05-16 11:15:42','2016-05-16 11:15:42','http://localhost/anui/public/wp/30/11'),(12,'hello',30,'rgb(255, 255, 255)','rgb(77, 118, 136)','rgb(255, 255, 255)','how are you','rgb(245, 245, 245)','rgb(0, 0, 0)','description of advertisement','1','320x50.png','','rgb(51, 124, 187)','rgb(255, 255, 255)','address','7878787878','manoj@manoj.com','2016-05-16 12:39:25','2016-05-16 12:39:25','http://localhost/anui/public/wp/30/12');
/*!40000 ALTER TABLE `advertiser_webpage` 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 2016-05-17 10:12:21
