File: /var/www/html/tmpr/../tmpr/../VCARDEXPORTS/templatex.sql
/*!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.5.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: templatex
-- ------------------------------------------------------
-- Server version 10.5.25-MariaDB
/*!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 utf8mb4 */;
/*!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 `ad_responder`
--
DROP TABLE IF EXISTS `ad_responder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ad_responder` (
`ar_id` int(11) NOT NULL AUTO_INCREMENT,
`ar_name` varchar(50) NOT NULL,
`ar_options` text NOT NULL,
`ar_status` tinyint(4) NOT NULL DEFAULT 1,
PRIMARY KEY (`ar_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ad_responder`
--
LOCK TABLES `ad_responder` WRITE;
/*!40000 ALTER TABLE `ad_responder` DISABLE KEYS */;
/*!40000 ALTER TABLE `ad_responder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `api`
--
DROP TABLE IF EXISTS `api`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`api` varchar(300) NOT NULL,
`site` varchar(500) NOT NULL,
`datetime` timestamp NOT NULL DEFAULT current_timestamp(),
`active_datetime` datetime NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api`
--
LOCK TABLES `api` WRITE;
/*!40000 ALTER TABLE `api` DISABLE KEYS */;
/*!40000 ALTER TABLE `api` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `autoresponder`
--
DROP TABLE IF EXISTS `autoresponder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `autoresponder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`ar_name` varchar(100) NOT NULL,
`ar_details` text NOT NULL,
`status` tinyint(4) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `autoresponder`
--
LOCK TABLES `autoresponder` WRITE;
/*!40000 ALTER TABLE `autoresponder` DISABLE KEYS */;
/*!40000 ALTER TABLE `autoresponder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bonusdetails`
--
DROP TABLE IF EXISTS `bonusdetails`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bonusdetails` (
`b_id` int(11) NOT NULL AUTO_INCREMENT,
`b_name` varchar(250) NOT NULL,
`b_link` varchar(500) NOT NULL,
`b_date` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`b_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bonusdetails`
--
LOCK TABLES `bonusdetails` WRITE;
/*!40000 ALTER TABLE `bonusdetails` DISABLE KEYS */;
/*!40000 ALTER TABLE `bonusdetails` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `campaign`
--
DROP TABLE IF EXISTS `campaign`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `campaign` (
`campaign_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`user_id` int(11) NOT NULL,
`datetime` datetime NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`campaign_id`)
) ENGINE=InnoDB AUTO_INCREMENT=744 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `campaign`
--
LOCK TABLES `campaign` WRITE;
/*!40000 ALTER TABLE `campaign` DISABLE KEYS */;
/*!40000 ALTER TABLE `campaign` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`cat_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
`status` tinyint(4) NOT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ci_sessions`
--
DROP TABLE IF EXISTS `ci_sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ci_sessions` (
`id` varchar(40) NOT NULL,
`ip_address` varchar(45) NOT NULL,
`timestamp` int(10) unsigned NOT NULL DEFAULT 0,
`data` blob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ci_sessions`
--
LOCK TABLES `ci_sessions` WRITE;
/*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */;
INSERT INTO `ci_sessions` VALUES ('1ca69bn9o47sa9p6r0ad2ll2gbtipmfb','172.31.31.227',1723481450,'__ci_last_regenerate|i:1723481307;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('1i3mlrdr3nhp8kkbb75qsv1rvie14vlc','172.31.31.227',1723481307,'__ci_last_regenerate|i:1723481307;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('394m77gil3hlp2bbh818bs356l3fo851','172.31.31.227',1723480179,'__ci_last_regenerate|i:1723480179;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('6kjosp3jjh74vqm7ljasns0dad9vnosu','172.31.31.227',1723582375,'__ci_last_regenerate|i:1723582375;'),('7fedv1odn8hromif2brgsrrel6kgod9k','172.31.31.227',1723742915,'__ci_last_regenerate|i:1723742915;'),('8pu51andkm0plr6r4u2ienao5tjjpm69','172.31.31.227',1723479491,'__ci_last_regenerate|i:1723479491;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('e326aolq80l4p10om4bich0h3jojfasp','172.31.31.227',1723582394,'__ci_last_regenerate|i:1723582375;'),('fd60q4jk0qdibo4b70p1niobv1dd7v97','192.168.29.28',1709527343,'__ci_last_regenerate|i:1709527091;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;user_id|s:2:\"20\";email|s:24:\"ravi.kushwah@pixelnx.com\";member_login|b:0;'),('gfv8vh5l0ke4fc20635s8vvie7prd84k','172.31.33.170',1723549563,'__ci_last_regenerate|i:1723549499;user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('lkrqcpioqsqvdp12mjdt8l6hm4609iqe','192.168.29.28',1709526602,'__ci_last_regenerate|i:1709526602;user_id|s:2:\"20\";email|s:24:\"ravi.kushwah@pixelnx.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('od0gv99v9pq3horu85bg7ojv6hdgnkie','172.31.31.227',1724315220,'__ci_last_regenerate|i:1724315193;user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('pcbnp2nlmsjie6m22vr0353t7l2u3q9e','172.31.31.227',1723480787,'__ci_last_regenerate|i:1723480787;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('sesfljpdubsaffthgjlufrkcm9phlkr4','172.31.31.227',1723477977,'__ci_last_regenerate|i:1723477977;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:2:\"20\";email|s:19:\"sokottah2@gmail.com\";member_login|b:0;admin_member_login|b:1;access_level|s:1:\"0\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:5:\"Admin\";facebook_post|b:0;'),('tjdebdn3sbfb3q3t4haagbtfekbcgigd','172.31.33.170',1723498404,'__ci_last_regenerate|i:1723498404;'),('v8sluse9mvghfnup00psq3iio2rqe3g5','192.168.29.28',1709527091,'__ci_last_regenerate|i:1709527091;price|i:0;__ci_vars|a:1:{s:5:\"price\";s:3:\"old\";}user_id|s:4:\"1104\";email|s:17:\"user@pixaguru.com\";member_login|b:1;admin_member_login|b:0;access_level|s:1:\"9\";profile_pic|s:31:\"uploads/user_20/profile_pic.png\";name|s:4:\"user\";facebook_post|b:0;');
/*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `coupon_code`
--
DROP TABLE IF EXISTS `coupon_code`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `coupon_code` (
`cp_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`offer_name` varchar(255) NOT NULL,
`coupon_code` text NOT NULL,
`discount_set` varchar(100) NOT NULL,
`discount_per_price` varchar(100) NOT NULL,
`discount_create_time` datetime NOT NULL,
`discount_expire_time` datetime NOT NULL,
PRIMARY KEY (`cp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `coupon_code`
--
LOCK TABLES `coupon_code` WRITE;
/*!40000 ALTER TABLE `coupon_code` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupon_code` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `edited_video`
--
DROP TABLE IF EXISTS `edited_video`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `edited_video` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_video` int(11) NOT NULL,
`title` varchar(250) NOT NULL,
`created_on` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `edited_video`
--
LOCK TABLES `edited_video` WRITE;
/*!40000 ALTER TABLE `edited_video` DISABLE KEYS */;
/*!40000 ALTER TABLE `edited_video` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fb_ads`
--
DROP TABLE IF EXISTS `fb_ads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fb_ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`page_id` varchar(50) NOT NULL,
`advertname` varchar(200) NOT NULL,
`image_path` varchar(500) NOT NULL,
`link` varchar(500) NOT NULL,
`title` varchar(100) NOT NULL,
`description` varchar(200) NOT NULL,
`call_to_action` varchar(500) NOT NULL,
`product_heading` varchar(200) NOT NULL,
`objective` varchar(50) NOT NULL,
`optimization` varchar(50) NOT NULL,
`billing_event` varchar(50) NOT NULL,
`status` varchar(50) NOT NULL,
`campaign_id` varchar(50) NOT NULL,
`adset_id` varchar(50) NOT NULL,
`creative_id` varchar(50) NOT NULL,
`ads_id` varchar(50) NOT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fb_ads`
--
LOCK TABLES `fb_ads` WRITE;
/*!40000 ALTER TABLE `fb_ads` DISABLE KEYS */;
/*!40000 ALTER TABLE `fb_ads` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fb_details`
--
DROP TABLE IF EXISTS `fb_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fb_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`fb_user_id` varchar(25) NOT NULL,
`account_id` varchar(25) NOT NULL,
`app_id` varchar(30) NOT NULL,
`app_secret` varchar(100) NOT NULL,
`access_token` varchar(500) NOT NULL,
`failure_message` varchar(250) NOT NULL,
`datetime` datetime NOT NULL,
`expire_access_token` timestamp NOT NULL DEFAULT current_timestamp(),
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fb_details`
--
LOCK TABLES `fb_details` WRITE;
/*!40000 ALTER TABLE `fb_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `fb_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `landingpage`
--
DROP TABLE IF EXISTS `landingpage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `landingpage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`list_id` varchar(100) NOT NULL,
`ar_id` varchar(100) NOT NULL,
`ar_htmlform` text NOT NULL,
`design` longblob NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`pagedata` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `landingpage`
--
LOCK TABLES `landingpage` WRITE;
/*!40000 ALTER TABLE `landingpage` DISABLE KEYS */;
/*!40000 ALTER TABLE `landingpage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `lp_templates`
--
DROP TABLE IF EXISTS `lp_templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lp_templates` (
`tempid` int(11) NOT NULL AUTO_INCREMENT,
`temp_design` longblob NOT NULL,
`temp_status` tinyint(4) NOT NULL,
`temp_fonts` varchar(250) NOT NULL,
PRIMARY KEY (`tempid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `lp_templates`
--
LOCK TABLES `lp_templates` WRITE;
/*!40000 ALTER TABLE `lp_templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `lp_templates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `plans`
--
DROP TABLE IF EXISTS `plans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plans` (
`pl_id` int(11) NOT NULL AUTO_INCREMENT,
`pl_name` varchar(255) NOT NULL,
`pl_price` float(10,2) NOT NULL,
`pl_currency` varchar(10) NOT NULL DEFAULT 'USD',
`interval` varchar(200) NOT NULL,
`create_datetime` datetime NOT NULL,
`update_datetime` datetime NOT NULL,
`plan_description` text NOT NULL,
`user_id` int(11) NOT NULL,
`interval_count` varchar(50) NOT NULL,
`plan_type` varchar(100) NOT NULL,
PRIMARY KEY (`pl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `plans`
--
LOCK TABLES `plans` WRITE;
/*!40000 ALTER TABLE `plans` DISABLE KEYS */;
INSERT INTO `plans` VALUES (1,'Plan 3',41.00,'USD','31','2023-05-27 09:17:32','2023-11-23 13:52:50',' 100 images\n100 logos',20,'month','paid'),(9,'Free',0.00,'USD','7','2024-03-04 05:30:02','2024-03-04 05:30:02','Free Trial Plan',20,'week','free');
/*!40000 ALTER TABLE `plans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qg_video_templates`
--
DROP TABLE IF EXISTS `qg_video_templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qg_video_templates` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`raw_data` varchar(1000) NOT NULL,
`user_id` bigint(20) NOT NULL,
`title` varchar(50) NOT NULL,
`name` varchar(20) NOT NULL,
`registered` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `qg_video_templates`
--
LOCK TABLES `qg_video_templates` WRITE;
/*!40000 ALTER TABLE `qg_video_templates` DISABLE KEYS */;
INSERT INTO `qg_video_templates` VALUES (30,'{\"type\":\"serve\",\"action\":\"copy\",\"id\":\"95d6a431-daee-4201-9060-e08fd0fd77ec\",\"render\":\"507c681e-7827-46aa-a9b2-d1ad33fc10f3\",\"owner\":\"qj9pibxbma\",\"status\":\"ready\",\"url\":\"https://cdn.shotstack.io/au/stage/qj9pibxbma/507c681e-7827-46aa-a9b2-d1ad33fc10f3.mp4\",\"error\":null,\"completed\":\"2023-06-23T12:32:45.856Z\"}',31,'Hi','WAZm9aqs.mp4','2023-06-23 07:02:46'),(31,'{\"type\":\"serve\",\"action\":\"copy\",\"id\":\"3378066e-87d2-4b89-8d15-b37d363faac8\",\"render\":\"c31b0370-3cf1-4319-bea8-2dbd9f411f6c\",\"owner\":\"qj9pibxbma\",\"status\":\"ready\",\"url\":\"https://cdn.shotstack.io/au/stage/qj9pibxbma/c31b0370-3cf1-4319-bea8-2dbd9f411f6c.mp4\",\"error\":null,\"completed\":\"2023-06-23T12:33:25.344Z\"}',31,'Hi','US3B7HXC.mp4','2023-06-23 07:03:25');
/*!40000 ALTER TABLE `qg_video_templates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `split_test`
--
DROP TABLE IF EXISTS `split_test`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `split_test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) NOT NULL,
`fb_ads_id` varchar(200) NOT NULL,
`date` datetime NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `split_test`
--
LOCK TABLES `split_test` WRITE;
/*!40000 ALTER TABLE `split_test` DISABLE KEYS */;
/*!40000 ALTER TABLE `split_test` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sub_category`
--
DROP TABLE IF EXISTS `sub_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_category` (
`sub_cat_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`cat_id` int(11) NOT NULL,
`status` tinyint(4) NOT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`sub_cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sub_category`
--
LOCK TABLES `sub_category` WRITE;
/*!40000 ALTER TABLE `sub_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `sub_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sub_users`
--
DROP TABLE IF EXISTS `sub_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_user_id` int(11) NOT NULL,
`sub_user_id` int(11) NOT NULL,
`sub_user_type` varchar(20) NOT NULL,
`status` tinyint(4) NOT NULL,
`datetime` datetime NOT NULL,
`code` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sub_users`
--
LOCK TABLES `sub_users` WRITE;
/*!40000 ALTER TABLE `sub_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `sub_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `suggestion`
--
DROP TABLE IF EXISTS `suggestion`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suggestion` (
`suggestion_id` int(11) NOT NULL AUTO_INCREMENT,
`question` varchar(250) NOT NULL,
`suggestion` varchar(500) NOT NULL,
`suggestion_order` int(11) NOT NULL,
`status` tinyint(4) NOT NULL,
`s_id` int(11) NOT NULL,
`sub_cat_id` int(11) NOT NULL,
`frontend` int(11) NOT NULL DEFAULT 1,
`oto` int(11) NOT NULL,
PRIMARY KEY (`suggestion_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `suggestion`
--
LOCK TABLES `suggestion` WRITE;
/*!40000 ALTER TABLE `suggestion` DISABLE KEYS */;
/*!40000 ALTER TABLE `suggestion` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `suggestion_category`
--
DROP TABLE IF EXISTS `suggestion_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suggestion_category` (
`s_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`s_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `suggestion_category`
--
LOCK TABLES `suggestion_category` WRITE;
/*!40000 ALTER TABLE `suggestion_category` DISABLE KEYS */;
INSERT INTO `suggestion_category` VALUES (1,'Template design',1),(2,'Increase Effectiveness With Proper Use Of Colors',1),(3,'General',1);
/*!40000 ALTER TABLE `suggestion_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `template_importer`
--
DROP TABLE IF EXISTS `template_importer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `template_importer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`importe_name` varchar(255) NOT NULL,
`imported_date` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `template_importer`
--
LOCK TABLES `template_importer` WRITE;
/*!40000 ALTER TABLE `template_importer` DISABLE KEYS */;
/*!40000 ALTER TABLE `template_importer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `theme_setting`
--
DROP TABLE IF EXISTS `theme_setting`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `theme_setting` (
`ts_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`data_key` varchar(200) NOT NULL,
`data_value` text NOT NULL,
PRIMARY KEY (`ts_id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `theme_setting`
--
LOCK TABLES `theme_setting` WRITE;
/*!40000 ALTER TABLE `theme_setting` DISABLE KEYS */;
INSERT INTO `theme_setting` VALUES (42,20,'pg_logo_image','logo.png'),(43,20,'pg_favicon_image','favicon.png'),(44,20,'pg_preloader_image','preloader.gif'),(62,20,'smtp_settings_data','{\"smtp_host\":\"mail.kamleshyadav.com\",\"smtp_port\":\"465\",\"smtp_user\":\"support@kamleshyadav.com\",\"smtp_pass\":\"^G-9lGru~7Z8\",\"enable_smpt\":\"true\",\"mail_title\":\"Pixaguru Support \",\"from_mail\":\"support@kamleshyadav.com\",\"smpt_crypto\":\"ssl\"}'),(63,20,'paymentSetting','{\"stripe_publishKey\":\"pk_test_51F39j4Dn0Yc5TNXRz2wgu98A42cC6JDFDBQMnCrjHJuoT8UCJ6atcbuDBxmfKil2IAEF9FawPCKl0ICn60pgHCJB00ccN0aCz0\",\"strpe_secret_key\":\"sk_test_51F39j4Dn0Yc5TNXRktDp0b1CdEwNxiLIHg2e3jihOgrIKXUyNn8VzJKOdHS76RIbU8Hb4xnDbFIIfO0EJXoJook20054O5hd9t\",\"paypal_client_id\":\"AV5uTH4UXLFTm42A3QrkolHzAP8k1tWWDruQwY3sInjooCxsVcDGBKSpNXhIVxyMGaX3Itn-yoOwFag9\",\"sandbox_accounts\":\"sb-u4jdx27299772@business.example.com\"}'),(64,20,'bg_remove_api','{\"appId\":\"19188\",\"secret_key\":\"1gc7ghrsulggitvs1l95te99a9p7aqbd1ta6p0jdu58hn1029f8v\",\"AuthKey\":\"MTg1NDQ6bG1jOTI1ZTZkcGhuNjdxYW1oOTdoZ21nams2NmthbWZzNjRhamhmZ2lnbWJqa2pmcW9hMA==\"}'),(65,20,'apiSetting','{\"open_ai_key\":\"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\",\"youtube_api_key\":\"AIzaSyDCx-bN76PUkynehO4Xf3hXVLT3L5w_h-0\",\"pixabay_key\":\"4298772-5bcc33553ad61ce64e43177ae\"}'),(66,20,'language','english'),(67,20,'siteTitle','Pixaguru Update');
/*!40000 ALTER TABLE `theme_setting` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `uploaded_video`
--
DROP TABLE IF EXISTS `uploaded_video`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uploaded_video` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`campaign_name` varchar(250) NOT NULL,
`a_title` varchar(250) NOT NULL,
`r_title` varchar(250) NOT NULL,
`size` float NOT NULL,
`dimension` varchar(250) NOT NULL,
`added_on` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `uploaded_video`
--
LOCK TABLES `uploaded_video` WRITE;
/*!40000 ALTER TABLE `uploaded_video` DISABLE KEYS */;
/*!40000 ALTER TABLE `uploaded_video` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `uploaded_video_thumb_list`
--
DROP TABLE IF EXISTS `uploaded_video_thumb_list`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uploaded_video_thumb_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`video_id` int(11) NOT NULL,
`thumb_name` varchar(250) NOT NULL,
`slot_time` float NOT NULL,
`time` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `uploaded_video_thumb_list`
--
LOCK TABLES `uploaded_video_thumb_list` WRITE;
/*!40000 ALTER TABLE `uploaded_video_thumb_list` DISABLE KEYS */;
/*!40000 ALTER TABLE `uploaded_video_thumb_list` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_download_mange`
--
DROP TABLE IF EXISTS `user_download_mange`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_download_mange` (
`n_id` int(11) NOT NULL AUTO_INCREMENT,
`status` varchar(50) NOT NULL,
`payment_details` text NOT NULL,
PRIMARY KEY (`n_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_download_mange`
--
LOCK TABLES `user_download_mange` WRITE;
/*!40000 ALTER TABLE `user_download_mange` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_download_mange` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_image`
--
DROP TABLE IF EXISTS `user_image`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_image` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`image_url` varchar(500) NOT NULL,
`thumb_url` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1346 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_image`
--
LOCK TABLES `user_image` WRITE;
/*!40000 ALTER TABLE `user_image` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_image` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_subscriptions`
--
DROP TABLE IF EXISTS `user_subscriptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_subscriptions` (
`usp_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT 0,
`plan_id` int(11) NOT NULL,
`payment_method` varchar(50) NOT NULL DEFAULT '',
`stripe_subscription_id` varchar(50) NOT NULL,
`stripe_customer_id` varchar(50) NOT NULL,
`stripe_plan_id` varchar(50) NOT NULL,
`plan_amount` float(10,2) NOT NULL,
`plan_amount_currency` varchar(10) NOT NULL,
`plan_interval` varchar(10) NOT NULL,
`plan_interval_count` tinyint(2) NOT NULL,
`plan_period_start` datetime NOT NULL,
`plan_period_end` datetime NOT NULL,
`payer_email` varchar(50) NOT NULL,
`created` datetime NOT NULL,
`status` varchar(50) NOT NULL,
PRIMARY KEY (`usp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_subscriptions`
--
LOCK TABLES `user_subscriptions` WRITE;
/*!40000 ALTER TABLE `user_subscriptions` DISABLE KEYS */;
INSERT INTO `user_subscriptions` VALUES (4,1104,9,'TrialPeriod','admin_mCYpK0rS&fAN','admin_iJnqyXAbxel$SD','admin_9W$aizNfJY',0.00,'USD','week',1,'2024-03-04 05:30:24','2024-03-11 05:30:24','user','2024-03-04 05:30:24','success'),(5,1105,9,'TrialPeriod','free_TLpEA(Jal0V#','free_UD54d*2aTZ87Qb','free_Ei#m7fz1Dj',0.00,'USD','week',1,'2024-08-12 15:51:01','2024-08-19 15:51:01','sokottah2@gmail.com','2024-08-12 15:51:01','success');
/*!40000 ALTER TABLE `user_subscriptions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_templates`
--
DROP TABLE IF EXISTS `user_templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_templates` (
`template_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`campaign_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`sub_cat_id` int(11) NOT NULL,
`template_name` varchar(100) NOT NULL,
`template_data` longtext NOT NULL,
`gradient_background` varchar(100) NOT NULL,
`thumb` varchar(500) NOT NULL,
`template_size` varchar(50) NOT NULL DEFAULT '1200x628',
`save_as_template` tinyint(4) NOT NULL,
`datetime` datetime NOT NULL,
`modifydate` datetime NOT NULL,
`access_level` tinyint(4) NOT NULL DEFAULT 1,
`status` tinyint(4) NOT NULL,
`template_access_leavel` int(11) NOT NULL,
`template_custom_size` varchar(100) NOT NULL,
PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3217 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_templates`
--
LOCK TABLES `user_templates` WRITE;
/*!40000 ALTER TABLE `user_templates` DISABLE KEYS */;
INSERT INTO `user_templates` VALUES (3216,20,1,1,0,'dddddddddddddd','','','','1200x885',0,'2024-08-12 16:44:02','2024-08-12 16:44:02',1,1,0,'0');
/*!40000 ALTER TABLE `user_templates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`email` varchar(250) NOT NULL,
`phone_no` varchar(20) NOT NULL,
`profile_pic` varchar(500) NOT NULL,
`password` varchar(500) NOT NULL,
`status` tinyint(4) NOT NULL,
`datetime` datetime NOT NULL,
`code` varchar(50) NOT NULL,
`access_level` varchar(50) NOT NULL COMMENT 'Plan ID ',
`role` varchar(10) NOT NULL DEFAULT 'user',
`source` varchar(20) NOT NULL,
`subscription_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1106 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (20,'Admin','sokottah2@gmail.com','874512653','uploads/user_20/profile_pic.png','a363557c5501c2409346cc8929069e7c',1,'2018-04-24 04:11:17','ff1c1e7c','0','admin','',0),(1104,'user','user@pixaguru.com','','uploads/user_20/profile_pic.png','32c8c0b9c740472cacdaaebb44802140',1,'2024-03-04 05:30:24','','9','user','',4),(1105,'sokottah2','sokottah5@gmail.com','','','a363557c5501c2409346cc8929069e7c',1,'2024-08-12 15:51:01','','9','user','',5);
/*!40000 ALTER TABLE `users` 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 2025-04-17 20:56:31