/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.5.61-cll : Database - domaindi_managedomain
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`domaindi_managedomain` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `domaindi_managedomain`;

/*Table structure for table `marketplace_apps` */

DROP TABLE IF EXISTS `marketplace_apps`;

CREATE TABLE `marketplace_apps` (
  `app_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `link` varchar(200) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `description` text,
  `menu_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`app_id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

/*Data for the table `marketplace_apps` */

insert  into `marketplace_apps`(`app_id`,`title`,`link`,`image`,`category_id`,`description`,`menu_id`) values (27,'LiveRep App',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-liverep.jpg',19,'<p><b>LiveRep is a product and one of the many apps of the Contrib Network. It allows our brand to create a community for their brand and allow them to be talk directly to their viewers.</b></p><p><img src=\\\"https://rdbuploads.s3.amazonaws.com/backgrounds/desc-liverep-feature.png\\\" title=\\\"\\\" alt=\\\"\\\"><br></p><br><code></code>','app_messaging'),(2,'Micro News',NULL,'https://rdbuploads.s3.amazonaws.com/vnoc/apps_marketplace/apps-micronews.png',5,'<p><strong>MicroNews are small chunks of text to send updates to the brand.\\n You could add this to your website by copying and pasting the script to\\n your desired page.</strong></p><p align=\\\"justify\\\"><strong><img style=\\\"width: 300px; height: 300px;\\\" src=\\\"https://vnocassets.s3.amazonaws.com/apps/micronews_app.png\\\" title=\\\"\\\" alt=\\\"\\\"><br></strong></p>','app_micronews'),(3,'Rating',NULL,'https://rdbuploads.s3.amazonaws.com/vnoc/apps_marketplace/apps-rating.png',5,'<p><strong>Contrib widget that will enable you to rate your site. You could use this script to rate anything in your page or website</strong></p><p><strong><img src=\\\"https://vnocassets.s3.amazonaws.com/apps/rating_app.png\\\" title=\\\"\\\" alt=\\\"\\\" style=\\\"width: 200px; height: 150px;\\\"><br></strong></p>','app_rating'),(4,'A/B Test',NULL,'https://rdbuploads.s3.amazonaws.com/vnoc/apps_marketplace/apps-abtest.png',15,'<p><b>Optimize domain by comparing 2 frameworks.</b></p><p><strong>This would allow you to test two frameworks within VNOC. You \\ncould choose any framework that we have on VNOC and activate it after a \\nnumber of days that you also want both frameworks to be activated.\\n</strong></p>','app_optimize'),(28,'Perks',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-perks.png',18,'Perks per domain','app_perks'),(26,'iProfile Form Generator',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/uploads/apps-form-generator.png',2,'','app_iprofile_formgenerator'),(11,'Wordpress Widgets',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/2013/apps-badge-wordpress-widgets.png',14,'<p><b>List of Wordpress widgets that you can use </b><br></p>','app_wpwidget'),(39,'Eservice App',NULL,'https://d1p6j71028fbjm.cloudfront.net/icons/app-vnoc-1.png',5,'<p>Initial content</p>','app_eservice'),(13,'iPartner App',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/2013/apps-badge-Ipartner.png',18,'<p><b>Manage domain partners and approve partnership requests.</b></p><p><b>It has a script to be embedded on websites to show partners.</b></p><p><b><img src=\\\"https://vnocassets.s3.amazonaws.com/apps/partner_apps.png\\\" title=\\\"\\\" alt=\\\"\\\" style=\\\"width: 500px; height: 400px;\\\"><br></b></p><p><b><br></b></p>','app_partners'),(14,'Team Members Script',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/2013/apps-badge-team.png',14,'Script that displays team members','app_team_members'),(15,'Brand Value',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/2013/apps-badge-value.png',14,'Brand statistics','app_brand_value'),(16,'Domain Verticals',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/2013/apps-badge-categories.png',14,'Domains of similar category','app_doman_vertical'),(17,'Referral Bounty',NULL,'https://d2qcctj8epnr7y.cloudfront.net/images/lucille/apps-refferalbounty.png',14,'Manage Referral Bounty','app_bounty'),(18,'Events','(null)','https://d2qcctj8epnr7y.cloudfront.net/sheina/vnoc/contrib-event5.png',3,'Events in Contrib','app_events'),(19,'Contrib Forum',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-discussions.png',5,'Contrib forum discussion','app_contrib_forum'),(21,'Social Posting',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-social-posting.png',5,'Share posts to different social networking sites','app_socialpost'),(22,'Referral Signup Code',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-referral-signup.png',18,'Referral signup code','app_refsignup'),(23,'Lead Widget',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-lead-widget2.png',2,'Embeddable script to get leads from different brands','app_leadwidget'),(24,'Domain Marketplace Listings',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-DOMAIN-MARKETPLACE.png',1,'Manage domains for listings','app_dmlisting'),(25,'Featured Challenge',NULL,'https://d2qcctj8epnr7y.cloudfront.net/uploads/apps-featured-challenge.png',14,'Edit Featured challenge - application only for challenge frameworks websites','app_editfchallenge'),(29,'Sponsorship',NULL,'https://s3.amazonaws.com/assets.zipsite.net/uploads/apps-sponsorship.png',3,'Sponsorship','app_sponsorship'),(30,'Google Analytics App',NULL,'https://s3.amazonaws.com/assets.zipsite.net/images/ga-stats.png',18,'Statistics for Google Analytics','app_googleanalytics'),(31,'Piwik App',NULL,'https://s3.amazonaws.com/assets.zipsite.net/images/lucille/apps-piwikstats.png',18,'Statistics for Piwik','app_piwik'),(37,'Ecommerce App',NULL,'https://s3.amazonaws.com/assets.zipsite.net/images/2013/apps-ecommerce.jpg',1,'<p>Ecommerce App<br></p>','app_ecommerce'),(38,'Github-Contrib Subscription',NULL,'https://s3.amazonaws.com/assets.zipsite.net/images/apps-github-contrib-sub.jpg',5,'<p><span style=\\\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;\\\" id=\\\"docs-internal-guid-d859bf40-616d-03df-af66-574ace9ed39e\\\">contrib-github developers embeddble static widget for every framework</span></p>','app_github_contrib'),(32,'Contribution App',NULL,'https://s3.amazonaws.com/assets.zipsite.net/images/lucille/apps-contribution.png',11,'<p><b>Contribution App Form Script - a script to be syndicated to website pages to allow visitors/users to add contributions.&nbsp;</b></p><p><b><img src=\\\"https://vnocassets.s3.amazonaws.com/apps/contribution_app.png\\\" title=\\\"Contributio App Form\\\" alt=\\\"\\\" style=\\\"width: 400px; height: 800px;\\\"><br></b></p><p><b><br></b></p>','app_contributionapp'),(33,'Referral Program Beta',NULL,'https://s3.amazonaws.com/assets.zipsite.net/images/lucille/apps-referralbeta.jpg',2,'<p><b>In Referral Program App:</b></p><ol><li>Add marketing group that will serve as as holder for all referral programs that will be added per domain.</li><li>Add marketing banners that will be shown to vnoc sites referral page.</li></ol><p align=\\\"center\\\"><img src=\\\"https://vnocassets.s3.amazonaws.com/apps/referral_app.png\\\" title=\\\"\\\" alt=\\\"\\\" style=\\\"width: 400px; height: 250px;\\\"><br></p><p align=\\\"left\\\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3. Other Referral Programs - manage referral programs to be shown on referral&nbsp;&nbsp; <br></p><p align=\\\"left\\\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; program page on building site.<br></p><p><br></p>','app_referral_beta'),(34,'Piwik Embed Code',NULL,'https://vnocassets.s3.amazonaws.com/apps/apps-piwikembed.png',3,'Embed piwik code to track website stats','app_piwik_code');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
