-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 14, 2024 at 09:19 AM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.0.28 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `pixelpages_development` -- -- -------------------------------------------------------- -- -- Table structure for table `ar_form_data` -- CREATE TABLE `ar_form_data` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `campaign_id` int(11) NOT NULL, `form_type` int(11) NOT NULL COMMENT '1 = subscription, 2 = contact form', `user_email` varchar(255) NOT NULL, `all_details` text NOT NULL, `date_added` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `autoresponder` -- CREATE TABLE `autoresponder` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `mkey` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `value` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `id` int(11) NOT NULL, `c_name` varchar(255) NOT NULL, `c_email` varchar(255) NOT NULL, `c_mobile` varchar(255) NOT NULL, `c_subject` varchar(255) NOT NULL, `c_message` longtext NOT NULL, `created_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` int(11) NOT NULL, `short_code` varchar(10) NOT NULL, `name` varchar(255) NOT NULL, `symbol` tinytext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `currencies` -- INSERT INTO `currencies` (`id`, `short_code`, `name`, `symbol`) VALUES (1, 'USD', 'United States Dollars', ''), (2, 'EUR', 'Euro', ''), (3, 'GBP', 'United Kingdom Pounds', ''), (4, 'DZD', 'Algeria Dinars', ''), (5, 'ARP', 'Argentina Pesos', ''), (6, 'AUD', 'Australia Dollars', ''), (7, 'ATS', 'Austria Schillings', ''), (8, 'BSD', 'Bahamas Dollars', ''), (9, 'BBD', 'Barbados Dollars', ''), (10, 'BEF', 'Belgium Francs', ''), (11, 'BMD', 'Bermuda Dollars', ''), (12, 'BRR', 'Brazil Real', ''), (13, 'BGL', 'Bulgaria Lev', ''), (14, 'CAD', 'Canada Dollars', ''), (15, 'CLP', 'Chile Pesos', ''), (16, 'CNY', 'China Yuan Renmimbi', ''), (17, 'CYP', 'Cyprus Pounds', ''), (18, 'CSK', 'Czech Republic Koruna', ''), (19, 'DKK', 'Denmark Kroner', ''), (20, 'NLG', 'Netherlands Guilders', ''), (21, 'XCD', 'Eastern Caribbean Dollars', ''), (22, 'EGP', 'Egypt Pounds', ''), (23, 'FJD', 'Fiji Dollars', ''), (24, 'FIM', 'Finland Markka', ''), (25, 'FRF', 'France Francs', ''), (26, 'DEM', 'Germany Deutsche Marks', ''), (27, 'XAU', 'Gold Ounces', ''), (28, 'GRD', 'Greece Drachmas', ''), (29, 'HKD', 'Hong Kong Dollars', ''), (30, 'HUF', 'Hungary Forint', ''), (31, 'ISK', 'Iceland Krona', ''), (32, 'INR', 'India Rupees', ''), (33, 'IDR', 'Indonesia Rupiah', ''), (34, 'IEP', 'Ireland Punt', ''), (35, 'ILS', 'Israel New Shekels', ''), (36, 'ITL', 'Italy Lira', ''), (37, 'JMD', 'Jamaica Dollars', ''), (38, 'JPY', 'Japan Yen', ''), (39, 'JOD', 'Jordan Dinar', ''), (40, 'KRW', 'South Korea Won', ''), (41, 'LBP', 'Lebanon Pounds', ''), (42, 'LUF', 'Luxembourg Francs', ''), (43, 'MYR', 'Malaysia Ringgit', ''), (44, 'MXP', 'Mexico Pesos', ''), (45, 'NLG', 'Netherlands Guilders', ''), (46, 'NZD', 'New Zealand Dollars', ''), (47, 'NOK', 'Norway Kroner', ''), (48, 'PKR', 'Pakistan Rupees', ''), (49, 'XPD', 'Palladium Ounces', ''), (50, 'PHP', 'Philippines Pesos', ''), (51, 'XPT', 'Platinum Ounces', ''), (52, 'PLZ', 'Poland Zloty', ''), (53, 'PTE', 'Portugal Escudo', ''), (54, 'ROL', 'Romania Leu', ''), (55, 'RUR', 'Russia Rubles', ''), (56, 'SAR', 'Saudi Arabia Riyal', ''), (57, 'XAG', 'Silver Ounces', ''), (58, 'SGD', 'Singapore Dollars', ''), (59, 'SKK', 'Slovakia Koruna', ''), (60, 'ZAR', 'South Africa Rand', ''), (61, 'KRW', 'South Korea Won', ''), (62, 'ESP', 'Spain Pesetas', ''), (63, 'XDR', 'Special Drawing Right (IMF),', ''), (64, 'SDD', 'Sudan Dinar', ''), (65, 'SEK', 'Sweden Krona', ''), (66, 'CHF', 'Switzerland Francs', ''), (67, 'TWD', 'Taiwan Dollars', ''), (68, 'THB', 'Thailand Baht', ''), (69, 'TTD', 'Trinidad and Tobago Dollars', ''), (70, 'TRL', 'Turkey Lira', ''), (71, 'VEB', 'Venezuela Bolivar', ''), (72, 'ZMK', 'Zambia Kwacha', ''), (73, 'EUR', 'Euro', ''), (74, 'XCD', 'Eastern Caribbean Dollars', ''), (75, 'XDR', 'Special Drawing Right (IMF),', ''), (76, 'XAG', 'Silver Ounces', ''), (77, 'XAU', 'Gold Ounces', ''), (78, 'XPD', 'Palladium Ounces', ''), (79, 'XPT', 'Platinum Ounces', ''); -- -------------------------------------------------------- -- -- Table structure for table `dfy_templates` -- CREATE TABLE `dfy_templates` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `template_name` varchar(255) NOT NULL, `zip_path` text NOT NULL, `zip_name` text NOT NULL, `date_created` datetime NOT NULL, `date_updated` datetime NOT NULL, `thumbnail_path` text NOT NULL, `is_downloadable` int(11) NOT NULL COMMENT '0 = no, 1 = yes' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `dfy_templates` -- INSERT INTO `dfy_templates` (`id`, `user_id`, `template_name`, `zip_path`, `zip_name`, `date_created`, `date_updated`, `thumbnail_path`, `is_downloadable`) VALUES (1, 1, 'Crypto Currency', 'uploads/template_zips/extracted_zip/1698499303_Crypto Currency/crypto-currency', 'crypto-currency.zip', '2023-08-10 10:21:50', '2023-12-29 17:04:21', 'uploads/template_zips/template_thumnails/1693304547_thumbnail_7.jpg', 0), (2, 1, 'Writer', 'uploads/template_zips/extracted_zip/1698388802_Writer/Writer', 'Writer.zip', '2023-08-11 09:54:18', '2023-10-27 06:40:02', 'uploads/template_zips/template_thumnails/1693292304_thumbnail_16.jpg', 0), (3, 1, 'Game', 'uploads/template_zips/extracted_zip/1698328611_Game/game', 'game.zip', '2023-08-12 04:58:54', '2023-10-26 13:56:52', 'uploads/template_zips/template_thumnails/1695978445_thumbnail_22.jpg', 0), (4, 1, 'Consulting', 'uploads/template_zips/extracted_zip/1698395536_Consulting/Consulting_html', 'Consulting_html.zip', '2023-08-12 11:29:22', '2023-10-27 14:02:16', 'uploads/template_zips/template_thumnails/1696480607_thumbnail_29.png', 0), (5, 1, 'Eco-recycling', 'uploads/template_zips/extracted_zip/1699436165_Eco-recycling/Eco-Recycling-html', 'Eco-Recycling-html.zip', '2023-08-12 11:29:45', '2023-11-08 09:36:05', 'uploads/template_zips/template_thumnails/1696481093_thumbnail_30.png', 0), (6, 1, 'SEO', 'uploads/template_zips/extracted_zip/1698499555_SEO/seo_html', 'seo_html.zip', '2023-08-14 06:43:56', '2023-10-28 18:55:55', 'uploads/template_zips/template_thumnails/1693304566_thumbnail_34.jpg', 0), (7, 1, 'supportDesk', 'uploads/template_zips/extracted_zip/1698397050_supportDesk/SupportDesk', 'SupportDesk.zip', '2023-08-14 07:21:11', '2023-10-27 14:27:30', 'uploads/template_zips/template_thumnails/1693292175_thumbnail_35.jpg', 0), (8, 1, 'Auto-Insurance', 'uploads/template_zips/extracted_zip/1699437162_Auto-Insurance/auto-insurance', 'auto-insurance.zip', '2023-08-14 10:02:43', '2023-11-08 09:52:42', 'uploads/template_zips/template_thumnails/1696481112_thumbnail_36.png', 0), (9, 1, 'Affiliate Marketing', 'uploads/template_zips/extracted_zip/1698389245_Affiliate Marketing/affiliate-marketing', 'affiliate-marketing.zip', '2023-08-14 11:07:03', '2023-10-27 06:47:26', 'uploads/template_zips/template_thumnails/1693291612_thumbnail_39.jpg', 0), (10, 1, 'App Landing', 'uploads/template_zips/extracted_zip/1698398587_App Landing/app-landing', 'app-landing.zip', '2023-08-14 11:07:33', '2023-10-27 14:53:07', 'uploads/template_zips/template_thumnails/1693291954_thumbnail_40.jpg', 0), (11, 1, 'Laundry-Service', 'uploads/template_zips/extracted_zip/1698655344_Laundry-Service/laundry', 'laundry.zip', '2023-08-16 06:47:39', '2023-10-30 14:12:24', 'uploads/template_zips/template_thumnails/1696481600_thumbnail_45.png', 0), (12, 1, 'Freelancer', 'uploads/template_zips/extracted_zip/1695303193_Freelancer/freelancer', 'freelancer.zip', '2023-08-16 07:08:52', '2023-09-21 13:33:13', 'uploads/template_zips/template_thumnails/1695303193_thumbnail_49.png', 0), (13, 1, 'Kids School', 'uploads/template_zips/extracted_zip/1698669413_Kids School/kids_school', 'kids_school.zip', '2023-08-16 09:56:22', '2023-10-30 18:06:53', 'uploads/template_zips/template_thumnails/1693304580_thumbnail_50.jpg', 0), (14, 1, 'Transport', 'uploads/template_zips/extracted_zip/1698656409_Transport/Transport', 'Transport.zip', '2023-08-17 12:05:04', '2023-10-30 14:30:09', 'uploads/template_zips/template_thumnails/1696857635_thumbnail_59.png', 0), (15, 1, 'Musician', 'uploads/template_zips/extracted_zip/1698325366_Musician/musician', 'musician.zip', '2023-08-17 12:11:58', '2023-10-26 13:02:46', 'uploads/template_zips/template_thumnails/1695983721_thumbnail_60.jpg', 0), (16, 1, 'VR Studio', 'uploads/template_zips/extracted_zip/1698403756_VR Studio/vr-studio', 'vr-studio.zip', '2023-08-17 13:21:03', '2023-10-27 16:19:16', 'uploads/template_zips/template_thumnails/1693292448_thumbnail_63.jpg', 0), (17, 1, 'Lock Smith', 'uploads/template_zips/extracted_zip/1696316498_Lock Smith/Lock Smith', 'Lock_Smith.zip', '2023-08-18 09:45:16', '2023-10-03 07:01:38', 'uploads/template_zips/template_thumnails/1696308137_thumbnail_64.jpg', 0), (18, 1, 'astrology', 'uploads/template_zips/extracted_zip/1699426692_astrology/astrologer', 'astrologer.zip', '2023-08-22 06:41:52', '2023-11-08 06:58:12', 'uploads/template_zips/template_thumnails/1696497452_thumbnail_65.jpg', 0), (19, 1, 'Yoga', 'uploads/template_zips/extracted_zip/1698326228_Yoga/yoga', 'yoga.zip', '2023-08-23 06:20:07', '2023-10-26 13:17:08', 'uploads/template_zips/template_thumnails/1695986527_thumbnail_66.jpg', 0), (20, 1, 'IT Services', 'uploads/template_zips/extracted_zip/1698400944_IT Services/IT Services', 'IT_Services.zip', '2023-08-23 12:13:46', '2023-10-27 15:32:24', 'uploads/template_zips/template_thumnails/1693292056_thumbnail_67.jpg', 0), (21, 1, 'Insurance', 'uploads/template_zips/extracted_zip/1699437705_Insurance/insurance', 'insurance.zip', '2023-08-24 09:25:10', '2023-11-08 10:01:45', 'uploads/template_zips/template_thumnails/1696857805_thumbnail_68.png', 0), (22, 1, 'Business Plan', 'uploads/template_zips/extracted_zip/1692877462_Business Plan/business-plan', 'business-plan.zip', '2023-08-24 11:03:58', '2023-08-29 06:53:46', 'uploads/template_zips/template_thumnails/1693292026_thumbnail_69.jpg', 0), (23, 1, 'Technical Support', 'uploads/template_zips/extracted_zip/1695304286_Technical Support/technical-support', 'technical-support.zip', '2023-08-25 12:44:43', '2023-09-21 13:51:26', 'uploads/template_zips/template_thumnails/1693292359_thumbnail_71.jpg', 0), (24, 1, 'pizza-shop', 'uploads/template_zips/extracted_zip/1699427068_pizza-shop/pizza-shop-DONE', 'pizza-shop-DONE.zip', '2023-08-26 05:17:20', '2023-11-08 07:04:28', 'uploads/template_zips/template_thumnails/1699427068_thumbnail_72.png', 0), (25, 1, 'Bakery', 'uploads/template_zips/extracted_zip/1698403838_Bakery/Bakery', 'Bakery.zip', '2023-08-26 06:18:36', '2023-10-27 16:20:38', 'uploads/template_zips/template_thumnails/1693291726_thumbnail_73.jpg', 0), (26, 1, 'Swimming', 'uploads/template_zips/extracted_zip/1698645211_Swimming/swimming', 'swimming.zip', '2023-08-26 11:43:22', '2023-10-30 11:23:31', 'uploads/template_zips/template_thumnails/1693304594_thumbnail_74.jpg', 0), (27, 1, 'Jewelry Store', 'uploads/template_zips/extracted_zip/1698326776_Jewelry Store/jewelry', 'jewelry.zip', '2023-08-26 13:17:39', '2023-10-26 13:26:16', 'uploads/template_zips/template_thumnails/1696050089_thumbnail_79.jpg', 0), (28, 1, 'Career Guides', 'uploads/template_zips/extracted_zip/1695304527_Career Guides/career-guides', 'career-guides.zip', '2023-08-26 13:31:14', '2023-09-21 13:55:27', 'uploads/template_zips/template_thumnails/1693292132_thumbnail_80.jpg', 0), (29, 1, 'Social Media', 'uploads/template_zips/extracted_zip/1698404851_Social Media/Social Media', 'Social_Media.zip', '2023-08-28 11:52:15', '2023-10-27 16:37:31', 'uploads/template_zips/template_thumnails/1693291596_thumbnail_81.jpg', 0), (30, 1, 'Driving school', 'uploads/template_zips/extracted_zip/1698409910_Driving school/Driving School', 'Driving_School.zip', '2023-08-28 11:53:09', '2023-10-27 18:01:50', 'uploads/template_zips/template_thumnails/1693918950_thumbnail_82.jpg', 0), (31, 1, 'Cyber-Security', 'uploads/template_zips/extracted_zip/1699427131_Cyber-Security/cyber-security', 'cyber-security.zip', '2023-08-28 12:29:46', '2023-11-08 07:05:31', 'uploads/template_zips/template_thumnails/1696498750_thumbnail_83.jpg', 0), (32, 1, 'E Learning', 'uploads/template_zips/extracted_zip/1695360027_E Learning/e-learning', 'e-learning.zip', '2023-08-29 06:00:13', '2023-09-22 05:20:28', 'uploads/template_zips/template_thumnails/1693290721_thumbnail_84.jpg', 0), (33, 1, 'plumber', 'uploads/template_zips/extracted_zip/1699438615_plumber/plumber', 'plumber.zip', '2023-08-29 06:18:13', '2023-11-08 10:16:55', 'uploads/template_zips/template_thumnails/1696858062_thumbnail_85.png', 0), (34, 1, 'Web_agency', 'uploads/template_zips/extracted_zip/1698499169_Web_agency/web_agency', 'web_agency.zip', '2023-08-29 09:43:05', '2023-10-28 18:49:29', 'uploads/template_zips/template_thumnails/1695279386_thumbnail_86.jpg', 0), (35, 1, 'Hotel Service', 'uploads/template_zips/extracted_zip/1695384561_Hotel Service/Hotel Services', 'Hotel_Services.zip', '2023-08-29 11:55:06', '2023-09-22 12:09:21', 'uploads/template_zips/template_thumnails/1693310106_thumbnail_.png', 0), (36, 1, 'Spa & Wellness', 'uploads/template_zips/extracted_zip/1696418055_Spa & Wellness/Spa & Wellness', 'Spa_Wellness.zip', '2023-08-29 14:02:43', '2023-10-04 11:14:15', 'uploads/template_zips/template_thumnails/1696053007_thumbnail_88.jpg', 0), (37, 1, 'Accountant', 'uploads/template_zips/extracted_zip/1699436335_Accountant/accountant', 'accountant.zip', '2023-08-31 05:47:22', '2023-11-08 09:38:55', 'uploads/template_zips/template_thumnails/1693460842_thumbnail_.png', 0), (38, 1, 'Organic-Food', 'uploads/template_zips/extracted_zip/1699426812_Organic-Food/organic-food', 'organic-food.zip', '2023-08-31 09:17:03', '2023-11-08 07:00:12', 'uploads/template_zips/template_thumnails/1696571975_thumbnail_90.jpg', 0), (39, 1, 'Restaurant', 'uploads/template_zips/extracted_zip/1698645378_Restaurant/restaurant', 'restaurant.zip', '2023-08-31 11:41:11', '2023-10-30 11:26:18', 'uploads/template_zips/template_thumnails/1695279920_thumbnail_91.jpg', 0), (40, 1, 'Fast Food', 'uploads/template_zips/extracted_zip/1695360457_Fast Food/fast-food', 'fast-food.zip', '2023-08-31 13:15:49', '2023-09-22 05:27:37', 'uploads/template_zips/template_thumnails/1693487749_thumbnail_.jpg', 0), (41, 1, 'Real Estate', 'uploads/template_zips/extracted_zip/1696418361_Real Estate/Real Estate', 'Real_Estate.zip', '2023-09-01 12:32:25', '2023-10-04 11:19:21', 'uploads/template_zips/template_thumnails/1696056482_thumbnail_93.jpg', 0), (42, 1, 'Non-Profit Charity', 'uploads/template_zips/extracted_zip/1698669934_Non-Profit Charity/non_profit_charity', 'non_profit_charity.zip', '2023-09-04 05:56:07', '2023-10-30 18:15:34', 'uploads/template_zips/template_thumnails/1695281079_thumbnail_94.jpg', 0), (43, 1, 'Lawyer', 'uploads/template_zips/extracted_zip/1696420203_Lawyer/lawyer', 'lawyer.zip', '2023-09-04 06:36:18', '2024-10-11 15:32:47', 'uploads/template_zips/template_thumnails/1693809378_thumbnail_.jpg', 0), (44, 1, 'Fitness Gym', 'uploads/template_zips/extracted_zip/1699426935_Fitness Gym/fitness-gym', 'fitness-gym.zip', '2023-09-04 11:02:29', '2023-11-08 07:02:16', 'uploads/template_zips/template_thumnails/1696496715_thumbnail_98.jpg', 0), (45, 1, 'Business Law', 'uploads/template_zips/extracted_zip/1695194391_Business Law/Business Law', 'Business_Law.zip', '2023-09-04 11:20:54', '2023-09-20 07:19:51', 'uploads/template_zips/template_thumnails/1693826823_thumbnail_99.png', 0), (46, 1, 'Beauty Salon', 'uploads/template_zips/extracted_zip/1698668450_Beauty Salon/beauty_salon', 'beauty_salon.zip', '2023-09-05 09:31:50', '2023-10-30 17:50:50', 'uploads/template_zips/template_thumnails/1695280289_thumbnail_100.jpg', 0), (47, 1, 'Music Tutoring', 'uploads/template_zips/extracted_zip/1696420365_Music Tutoring/music-tutoring', 'music-tutoring.zip', '2023-09-05 09:33:45', '2023-10-04 11:52:45', 'uploads/template_zips/template_thumnails/1693906425_thumbnail_.png', 0), (48, 1, 'Architecture Firms', 'uploads/template_zips/extracted_zip/1693916927_Architecture Firms/Architecture Firms', 'Architecture_Firms.zip', '2023-09-05 12:24:21', '2023-09-05 12:28:47', 'uploads/template_zips/template_thumnails/1693916661_thumbnail_.jpg', 0), (49, 1, 'Photography', 'uploads/template_zips/extracted_zip/1696058453_Photography/Photography', 'Photography.zip', '2023-09-05 14:35:42', '2023-09-30 07:20:53', 'uploads/template_zips/template_thumnails/1696057430_thumbnail_103.jpg', 0), (50, 1, 'Italian Restaurant', 'uploads/template_zips/extracted_zip/1699427378_Italian Restaurant/italian-restaurant', 'italian-restaurant.zip', '2023-09-06 09:48:43', '2023-11-08 07:09:38', 'uploads/template_zips/template_thumnails/1696502835_thumbnail_104.jpg', 0), (51, 1, 'Interior Design', 'uploads/template_zips/extracted_zip/1698668918_Interior Design/interior_design', 'interior_design.zip', '2023-09-06 10:14:05', '2023-10-30 17:58:38', 'uploads/template_zips/template_thumnails/1695280896_thumbnail_105.jpg', 0), (52, 1, 'Car Repair', 'uploads/template_zips/extracted_zip/1696419892_Car Repair/car-repair', 'car-repair.zip', '2023-09-06 11:38:45', '2023-10-04 11:44:52', 'uploads/template_zips/template_thumnails/1694000325_thumbnail_.png', 0), (53, 1, 'Fitness-Coaching', 'uploads/template_zips/extracted_zip/1695205286_Fitness-Coaching/Fitness Coaching', 'Fitness_Coaching.zip', '2023-09-06 12:46:20', '2023-09-20 10:21:26', 'uploads/template_zips/template_thumnails/1694004380_thumbnail_.jpg', 0), (54, 1, 'Consultant', 'uploads/template_zips/extracted_zip/1699427416_Consultant/consultant', 'consultant.zip', '2023-09-07 11:56:09', '2023-11-08 07:10:16', 'uploads/template_zips/template_thumnails/1696498231_thumbnail_108.jpg', 0), (55, 1, 'Security Service', 'uploads/template_zips/extracted_zip/1695726113_Security Service/Security Service', 'Security_Service.zip', '2023-09-08 09:44:21', '2023-09-26 11:01:53', 'uploads/template_zips/template_thumnails/1694167899_thumbnail_109.jpg', 0), (56, 1, 'Motivational-Speakers', 'uploads/template_zips/extracted_zip/1699427278_Motivational-Speakers/motivational-speakers', 'motivational-speakers.zip', '2023-09-08 10:29:04', '2023-11-08 07:07:58', 'uploads/template_zips/template_thumnails/1699427278_thumbnail_110.png', 0), (57, 1, 'Fashion', 'uploads/template_zips/extracted_zip/1696062983_Fashion/Fashion', 'Fashion.zip', '2023-09-08 12:45:09', '2023-09-30 08:36:23', 'uploads/template_zips/template_thumnails/1696059312_thumbnail_111.jpg', 0), (58, 1, 'photographer', 'uploads/template_zips/extracted_zip/1696068041_photographer/photographer', 'photographer.zip', '2023-09-08 12:46:20', '2023-09-30 10:20:07', 'uploads/template_zips/template_thumnails/1696069207_thumbnail_112.jpg', 0), (59, 1, 'Black Friday', 'uploads/template_zips/extracted_zip/1696068978_Black Friday/Black Friday', 'Black_Friday.zip', '2023-09-12 05:47:17', '2023-09-30 10:16:18', 'uploads/template_zips/template_thumnails/1696068978_thumbnail_114.jpg', 0), (60, 1, 'Health & Medical Center', 'uploads/template_zips/extracted_zip/1695905943_Health & Medical Center/Health & Medical Center', 'Health_Medical_Center.zip', '2023-09-12 07:32:21', '2023-09-28 12:59:03', 'uploads/template_zips/template_thumnails/1694523893_thumbnail_115.jpg', 0), (61, 1, 'Human Resources', 'uploads/template_zips/extracted_zip/1695725777_Human Resources/Human Resources', 'Human_Resources.zip', '2023-09-12 12:50:20', '2023-09-26 10:56:17', 'uploads/template_zips/template_thumnails/1694523020_thumbnail_.jpg', 0), (62, 1, 'Dentist', 'uploads/template_zips/extracted_zip/1699438829_Dentist/Dentist', 'Dentist.zip', '2023-09-13 07:03:58', '2023-11-08 10:20:29', 'uploads/template_zips/template_thumnails/1694594197_thumbnail_117.png', 0), (63, 1, 'Florist', 'uploads/template_zips/extracted_zip/1699507379_Florist/Florist', 'Florist.zip', '2023-09-13 08:44:56', '2023-11-09 05:22:59', 'uploads/template_zips/template_thumnails/1694594696_thumbnail_.png', 0), (64, 1, 'Home Cleaning Services', 'uploads/template_zips/extracted_zip/1698410097_Home Cleaning Services/home-cleaning-services', 'home-cleaning-services.zip', '2023-09-13 11:19:11', '2023-10-27 18:04:57', 'uploads/template_zips/template_thumnails/1694603951_thumbnail_.png', 0), (65, 1, 'HealthCare', 'uploads/template_zips/extracted_zip/1699507304_HealthCare/Healthcare', 'Healthcare.zip', '2023-09-13 12:18:02', '2023-11-09 05:21:44', 'uploads/template_zips/template_thumnails/1694607481_thumbnail_.png', 0), (66, 1, 'Event Wedding', 'uploads/template_zips/extracted_zip/1695721110_Event Wedding/Event & Wedding', 'Event_Wedding.zip', '2023-09-13 13:33:02', '2023-09-26 09:38:30', 'uploads/template_zips/template_thumnails/1694613160_thumbnail_121.jpg', 0), (67, 1, 'Petcare', 'uploads/template_zips/extracted_zip/1699509708_Petcare/Petcare', 'Petcare.zip', '2023-09-14 05:28:28', '2023-11-09 06:01:48', 'uploads/template_zips/template_thumnails/1694669308_thumbnail_.png', 0), (68, 1, 'Travel Agency', 'uploads/template_zips/extracted_zip/1696070403_Travel Agency/Travel Agency', 'Travel_Agency.zip', '2023-09-14 07:34:06', '2023-09-30 10:50:01', 'uploads/template_zips/template_thumnails/1696071001_thumbnail_123.jpg', 0), (69, 1, 'Digital-Marketing', 'uploads/template_zips/extracted_zip/1696071807_Digital-Marketing/Digital-Marketing', 'Digital-Marketing.zip', '2023-09-14 13:56:38', '2023-09-30 11:08:33', 'uploads/template_zips/template_thumnails/1696072113_thumbnail_124.jpg', 0), (70, 1, 'Carpenter', 'uploads/template_zips/extracted_zip/1698668688_Carpenter/carpenter', 'carpenter.zip', '2023-09-15 06:45:15', '2023-10-30 17:54:48', 'uploads/template_zips/template_thumnails/1695280671_thumbnail_125.jpg', 0), (71, 1, 'Marketing Agency', 'uploads/template_zips/extracted_zip/1698669648_Marketing Agency/marketing_agency', 'marketing_agency.zip', '2023-09-18 12:28:44', '2023-10-30 18:10:48', 'uploads/template_zips/template_thumnails/1695040828_thumbnail_126.jpg', 0), (72, 1, 'Web Security', 'uploads/template_zips/extracted_zip/1695906528_Web Security/Web Security', 'Web_Security.zip', '2023-09-19 05:03:41', '2023-09-28 13:08:48', 'uploads/template_zips/template_thumnails/1695130147_thumbnail_128.jpg', 0), (73, 1, 'Handmade Crafts', 'uploads/template_zips/extracted_zip/1696073964_Handmade Crafts/Handmade Crafts', 'Handmade_Crafts.zip', '2023-09-19 11:48:47', '2023-09-30 11:39:24', 'uploads/template_zips/template_thumnails/1696073964_thumbnail_129.jpg', 0), (74, 1, 'Mobile App Development', 'uploads/template_zips/extracted_zip/1695725252_Mobile App Development/Mobile App Development', 'Mobile_App_Development.zip', '2023-09-19 13:10:33', '2023-09-26 10:47:32', 'uploads/template_zips/template_thumnails/1695129773_thumbnail_130.jpg', 0), (75, 1, 'Cooking Classes', 'uploads/template_zips/extracted_zip/1698647068_Cooking Classes/cooking_classes', 'cooking_classes.zip', '2023-09-21 06:31:45', '2023-10-30 11:54:28', 'uploads/template_zips/template_thumnails/1695281711_thumbnail_132.jpg', 0), (76, 1, 'Home-repair-renovation', 'uploads/template_zips/extracted_zip/1699426966_Home-repair-renovation/home-repair-renovation', 'home-repair-renovation.zip', '2023-09-21 06:37:40', '2023-11-08 07:02:46', 'uploads/template_zips/template_thumnails/1696501600_thumbnail_133.jpg', 0), (77, 1, 'Child-Care', 'uploads/template_zips/extracted_zip/1695906044_Child-Care/Child-Care', 'Child-Care.zip', '2023-09-21 13:35:16', '2023-09-28 13:00:44', 'uploads/template_zips/template_thumnails/1695736408_thumbnail_134.jpg', 0), (78, 1, 'Event Management', 'uploads/template_zips/extracted_zip/1695722846_Event Management/Event Management', 'Event_Management.zip', '2023-09-22 05:34:46', '2023-09-26 10:07:26', 'uploads/template_zips/template_thumnails/1695380005_thumbnail_135.jpg', 0), (79, 1, 'Blogger', 'uploads/template_zips/extracted_zip/1698489715_Blogger/blogger', 'blogger.zip', '2023-09-22 05:49:59', '2023-10-28 16:11:56', 'uploads/template_zips/template_thumnails/1695377602_thumbnail_136.jpg', 0), (80, 1, 'Financial Advice', 'uploads/template_zips/extracted_zip/1696077856_Financial Advice/Financial Advice', 'Financial_Advice.zip', '2023-09-22 07:06:35', '2023-09-30 12:44:16', 'uploads/template_zips/template_thumnails/1696077856_thumbnail_137.jpg', 0), (81, 1, 'Outdoor Adventure', 'uploads/template_zips/extracted_zip/1698647472_Outdoor Adventure/outdoor_adventure', 'outdoor_adventure.zip', '2023-09-23 12:34:58', '2023-10-30 12:01:12', 'uploads/template_zips/template_thumnails/1695472498_thumbnail_.jpg', 0), (82, 1, 'Dog Training', 'uploads/template_zips/extracted_zip/1695906146_Dog Training/Dog-Training', 'Dog-Training.zip', '2023-09-25 10:14:07', '2023-09-28 13:02:26', 'uploads/template_zips/template_thumnails/1695706986_thumbnail_139.jpg', 0), (83, 1, 'Industry-Factory', 'uploads/template_zips/extracted_zip/1699427333_Industry-Factory/industry-factory', 'industry-factory.zip', '2023-09-25 11:12:17', '2023-11-08 07:08:53', 'uploads/template_zips/template_thumnails/1696502567_thumbnail_140.jpg', 0), (84, 1, 'Data Analytics', 'uploads/template_zips/extracted_zip/1698647619_Data Analytics/data_analytics', 'data_analytics.zip', '2023-09-26 06:02:23', '2023-10-30 12:03:39', 'uploads/template_zips/template_thumnails/1695708143_thumbnail_.jpg', 0), (85, 1, 'News & Media', 'uploads/template_zips/extracted_zip/1696079739_News & Media/News & Media', 'News_Media.zip', '2023-09-26 10:16:45', '2023-09-30 13:15:39', 'uploads/template_zips/template_thumnails/1696079738_thumbnail_142.jpg', 0), (86, 1, 'Creative Agency', 'uploads/template_zips/extracted_zip/1698655288_Creative Agency/creative_agency', 'creative_agency.zip', '2023-09-26 13:14:34', '2023-10-30 14:11:28', 'uploads/template_zips/template_thumnails/1695734074_thumbnail_.jpg', 0), (87, 1, 'Business & Corporate', 'uploads/template_zips/extracted_zip/1698411050_Business & Corporate/business-corporate', 'business-corporate.zip', '2023-09-27 11:58:16', '2023-10-27 18:20:50', 'uploads/template_zips/template_thumnails/1695815896_thumbnail_.png', 0), (88, 1, 'Nature & Wildlife', 'uploads/template_zips/extracted_zip/1696071676_Nature & Wildlife/Nature & Wildlife', 'Nature_Wildlife.zip', '2023-09-27 12:15:22', '2023-09-30 11:01:16', 'uploads/template_zips/template_thumnails/1696071676_thumbnail_146.jpg', 0), (89, 1, 'Academic', 'uploads/template_zips/extracted_zip/1695993154_Academic/Academic', 'Academic.zip', '2023-09-29 05:21:13', '2023-09-29 13:12:34', 'uploads/template_zips/template_thumnails/1695965277_thumbnail_148.jpg', 0), (90, 1, 'Deck Refinishing', 'uploads/template_zips/extracted_zip/1695965218_Deck Refinishing/Deck Refinishing', 'Deck_Refinishing.zip', '2023-09-29 05:26:58', '2023-09-29 05:29:27', 'uploads/template_zips/template_thumnails/1695965367_thumbnail_149.jpg', 0), (91, 1, 'Podcasting', 'uploads/template_zips/extracted_zip/1699507347_Podcasting/Podcasting', 'Podcasting.zip', '2023-09-29 10:32:51', '2023-11-09 05:22:27', 'uploads/template_zips/template_thumnails/1695983571_thumbnail_.png', 0), (92, 1, 'Email Marketing', 'uploads/template_zips/extracted_zip/1699427162_Email Marketing/email-marketing', 'email-marketing.zip', '2023-09-30 09:55:57', '2024-06-03 14:25:49', 'uploads/template_zips/template_thumnails/1696499035_thumbnail_151.jpg', 0), (93, 1, 'Music-Production', 'uploads/template_zips/extracted_zip/1696079768_Music-Production/Music-Production', 'Music-Production.zip', '2023-09-30 12:24:20', '2023-09-30 13:26:34', 'uploads/template_zips/template_thumnails/1696080394_thumbnail_152.jpg', 0), (94, 1, 'Arts and Crafts', 'uploads/template_zips/extracted_zip/1698649998_Arts and Crafts/Arts-crafts', 'Arts-crafts.zip', '2023-09-30 12:25:54', '2024-06-07 11:55:48', 'uploads/template_zips/template_thumnails/1696076754_thumbnail_.png', 0), (95, 1, 'Automotive', 'uploads/template_zips/extracted_zip/1696080816_Automotive/Automotive', 'Automotive.zip', '2023-09-30 13:27:20', '2023-09-30 13:33:36', 'uploads/template_zips/template_thumnails/1696080440_thumbnail_.jpg', 0), (96, 1, 'Gardening', 'uploads/template_zips/extracted_zip/1698410602_Gardening/gardening', 'gardening.zip', '2023-10-04 09:22:22', '2024-06-07 08:33:11', 'uploads/template_zips/template_thumnails/1696411342_thumbnail_.png', 0), (97, 1, 'Dentists', 'uploads/template_zips/extracted_zip/1698413441_Dentists/dentists', 'dentists.zip', '2023-10-04 11:34:55', '2023-10-27 19:00:41', 'uploads/template_zips/template_thumnails/1696419295_thumbnail_.png', 0), (98, 1, 'Kitchen-store', 'uploads/template_zips/extracted_zip/1698649298_Kitechen-store/kitchen-store', 'kitchen-store.zip', '2023-10-06 05:56:17', '2023-11-01 12:32:45', 'uploads/template_zips/template_thumnails/1696571777_thumbnail_.jpg', 0), (99, 1, 'Online Course', 'uploads/template_zips/extracted_zip/1699508621_Online Course/Online-courses', 'Online-courses.zip', '2023-10-09 10:18:20', '2023-11-09 05:43:41', 'uploads/template_zips/template_thumnails/1696846700_thumbnail_.png', 0), (100, 1, 'Webinar Services', 'uploads/template_zips/extracted_zip/1698414236_Webinar Services/webinar-services', 'webinar-services.zip', '2023-12-27 12:06:32', '2023-12-27 12:14:31', 'uploads/template_zips/template_thumnails/1698314608_thumbnail_.png', 0); -- -------------------------------------------------------- -- -- Table structure for table `frontend_settings` -- CREATE TABLE `frontend_settings` ( `id` int(11) NOT NULL, `site_settings` text NOT NULL, `about_us` longtext NOT NULL, `testimonials` text NOT NULL, `privacy_policy` longtext NOT NULL, `terms_conditions` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `frontend_settings` -- INSERT INTO `frontend_settings` (`id`, `site_settings`, `about_us`, `testimonials`, `privacy_policy`, `terms_conditions`) VALUES (1, '{\"site_title\":\"Pixelpages\",\"meta_keywords\":\"words,pixel\",\"meta_author\":\"pixel\",\"meta_description\":\"meta vb\",\"site_logo\":\"uploads\\/frontend\\/abd6ede1f3_1.png\",\"site_favicon\":\"uploads\\/frontend\\/61d33a4f3e_1.png\",\"site_preloader\":\"uploads\\/frontend\\/eadcb2ccda_1.png\",\"site_copyright\":\"Copyright \\u00a9 2024. PixelPages All Rights Reserved.\"}', '{\"about_heading\":\"ABOUT US\",\"about_sub_heading\":\"Who we are?\",\"about_description\":\"

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.<\\/p>\\r\\n\",\"about_image\":\"uploads\\/frontend\\/d7c4036e79_1.png\"}', '{\"testimonial_title\":[\"Sarah\",\"Peter\",\"Robert\"],\"testimonial_type\":[\"Small Business Owner\",\"Entrepreneur\",\"Project Manager\"],\"testimonial_description\":[\"Working with PixelPages has transformed my business! Their attention to detail and commitment to quality is unmatched. I\\u2019ve seen a significant increase in customer satisfaction and sales. Highly recommend!\",\"I can\'t thank PixelPages enough for their incredible service. From start to finish, they were professional and supportive. The results exceeded my expectations, and I will definitely be coming back!\",\"PixelPages provided us with top-notch solutions that were tailored to our needs. Their team is knowledgeable and always available to help. Our project was completed ahead of schedule, and we couldn\\u2019t be happier!\"],\"testimonial_image\":[\"uploads\\/frontend\\/smiling.jpg\",\"uploads\\/frontend\\/pria.jpg\",\"uploads\\/frontend\\/52c4d356c2f82c75a24abd2b95d918ee.png\"]}', '

Privacy Policy

\r\n\r\n

This Privacy Policy describes Our policies and procedures on the collection, use and disclosure of Your information when You use the Service and tells You about Your privacy rights and how the law protects You.

\r\n\r\n

We use Your Personal data to provide and improve the Service. By using the Service, You agree to the collection and use of information in accordance with this Privacy Policy.

\r\n\r\n

Interpretation and Definitions

\r\n\r\n

Interpretation

\r\n\r\n

The words of which the initial letter is capitalized have meanings defined under the following conditions. The following definitions shall have the same meaning regardless of whether they appear in singular or in plural.

\r\n\r\n

Definitions

\r\n\r\n

For the purposes of this Privacy Policy:

\r\n\r\n\r\n\r\n

Collecting and Using Your Personal Data

\r\n\r\n

Types of Data Collected

\r\n\r\n

Personal Data

\r\n\r\n

While using Our Service, We may ask You to provide Us with certain personally identifiable information that can be used to contact or identify You. Personally identifiable information may include, but is not limited to:

\r\n\r\n\r\n\r\n

Usage Data

\r\n\r\n

Usage Data is collected automatically when using the Service.

\r\n\r\n

Usage Data may include information such as Your Device's Internet Protocol address (e.g. IP address), browser type, browser version, the pages of our Service that You visit, the time and date of Your visit, the time spent on those pages, unique device identifiers and other diagnostic data.

\r\n\r\n

When You access the Service by or through a mobile device, We may collect certain information automatically, including, but not limited to, the type of mobile device You use, Your mobile device unique ID, the IP address of Your mobile device, Your mobile operating system, the type of mobile Internet browser You use, unique device identifiers and other diagnostic data.

\r\n\r\n

We may also collect information that Your browser sends whenever You visit our Service or when You access the Service by or through a mobile device.

\r\n\r\n

Information from Third-Party Social Media Services

\r\n\r\n

The Company allows You to create an account and log in to use the Service through the following Third-party Social Media Services:

\r\n\r\n\r\n\r\n

If You decide to register through or otherwise grant us access to a Third-Party Social Media Service, We may collect Personal data that is already associated with Your Third-Party Social Media Service's account, such as Your name, Your email address, Your activities or Your contact list associated with that account.

\r\n\r\n

You may also have the option of sharing additional information with the Company through Your Third-Party Social Media Service's account. If You choose to provide such information and Personal Data, during registration or otherwise, You are giving the Company permission to use, share, and store it in a manner consistent with this Privacy Policy.

\r\n\r\n

Tracking Technologies and Cookies

\r\n\r\n

We use Cookies and similar tracking technologies to track the activity on Our Service and store certain information. Tracking technologies used are beacons, tags, and scripts to collect and track information and to improve and analyze Our Service. The technologies We use may include:

\r\n\r\n\r\n\r\n

Cookies can be "Persistent" or "Session" Cookies. Persistent Cookies remain on Your personal computer or mobile device when You go offline, while Session Cookies are deleted as soon as You close Your web browser.

\r\n\r\n

We use both Session and Persistent Cookies for the purposes set out below:

\r\n\r\n\r\n\r\n

For more information about the cookies we use and your choices regarding cookies, please visit our Cookies Policy or the Cookies section of our Privacy Policy.

\r\n\r\n

Use of Your Personal Data

\r\n\r\n

The Company may use Personal Data for the following purposes:

\r\n\r\n\r\n\r\n

We may share Your personal information in the following situations:

\r\n\r\n\r\n\r\n

Retention of Your Personal Data

\r\n\r\n

The Company will retain Your Personal Data only for as long as is necessary for the purposes set out in this Privacy Policy. We will retain and use Your Personal Data to the extent necessary to comply with our legal obligations (for example, if we are required to retain your data to comply with applicable laws), resolve disputes, and enforce our legal agreements and policies.

\r\n\r\n

The Company will also retain Usage Data for internal analysis purposes. Usage Data is generally retained for a shorter period of time, except when this data is used to strengthen the security or to improve the functionality of Our Service, or We are legally obligated to retain this data for longer time periods.

\r\n\r\n

Transfer of Your Personal Data

\r\n\r\n

Your information, including Personal Data, is processed at the Company's operating offices and in any other places where the parties involved in the processing are located. It means that this information may be transferred to — and maintained on — computers located outside of Your state, province, country or other governmental jurisdiction where the data protection laws may differ than those from Your jurisdiction.

\r\n\r\n

Your consent to this Privacy Policy followed by Your submission of such information represents Your agreement to that transfer.

\r\n\r\n

The Company will take all steps reasonably necessary to ensure that Your data is treated securely and in accordance with this Privacy Policy and no transfer of Your Personal Data will take place to an organization or a country unless there are adequate controls in place including the security of Your data and other personal information.

\r\n\r\n

Delete Your Personal Data

\r\n\r\n

You have the right to delete or request that We assist in deleting the Personal Data that We have collected about You.

\r\n\r\n

Our Service may give You the ability to delete certain information about You from within the Service.

\r\n\r\n

You may update, amend, or delete Your information at any time by signing in to Your Account, if you have one, and visiting the account settings section that allows you to manage Your personal information. You may also contact Us to request access to, correct, or delete any personal information that You have provided to Us.

\r\n\r\n

Please note, however, that We may need to retain certain information when we have a legal obligation or lawful basis to do so.

\r\n\r\n

Disclosure of Your Personal Data

\r\n\r\n

Business Transactions

\r\n\r\n

If the Company is involved in a merger, acquisition or asset sale, Your Personal Data may be transferred. We will provide notice before Your Personal Data is transferred and becomes subject to a different Privacy Policy.

\r\n\r\n

Law enforcement

\r\n\r\n

Under certain circumstances, the Company may be required to disclose Your Personal Data if required to do so by law or in response to valid requests by public authorities (e.g. a court or a government agency).

\r\n\r\n

Other legal requirements

\r\n\r\n

The Company may disclose Your Personal Data in the good faith belief that such action is necessary to:

\r\n\r\n\r\n\r\n

Security of Your Personal Data

\r\n\r\n

The security of Your Personal Data is important to Us, but remember that no method of transmission over the Internet, or method of electronic storage is 100% secure. While We strive to use commercially acceptable means to protect Your Personal Data, We cannot guarantee its absolute security.

\r\n\r\n

Children's Privacy

\r\n\r\n

Our Service does not address anyone under the age of 13. We do not knowingly collect personally identifiable information from anyone under the age of 13. If You are a parent or guardian and You are aware that Your child has provided Us with Personal Data, please contact Us. If We become aware that We have collected Personal Data from anyone under the age of 13 without verification of parental consent, We take steps to remove that information from Our servers.

\r\n\r\n

If We need to rely on consent as a legal basis for processing Your information and Your country requires consent from a parent, We may require Your parent's consent before We collect and use that information.

\r\n\r\n

Links to Other Websites

\r\n\r\n

Our Service may contain links to other websites that are not operated by Us. If You click on a third party link, You will be directed to that third party's site. We strongly advise You to review the Privacy Policy of every site You visit.

\r\n\r\n

We have no control over and assume no responsibility for the content, privacy policies or practices of any third party sites or services.

\r\n\r\n

Changes to this Privacy Policy

\r\n\r\n

We may update Our Privacy Policy from time to time. We will notify You of any changes by posting the new Privacy Policy on this page.

\r\n\r\n

We will let You know via email and/or a prominent notice on Our Service, prior to the change becoming effective and update the "Last updated" date at the top of this Privacy Policy.

\r\n\r\n

You are advised to review this Privacy Policy periodically for any changes. Changes to this Privacy Policy are effective when they are posted on this page.

\r\n\r\n

Contact Us

\r\n\r\n

If you have any questions about this Privacy Policy, You can contact us:

\r\n\r\n\r\n', '

Terms and Conditions

\r\n\r\n

Please read these terms and conditions carefully before using Our Service.

\r\n\r\n

Interpretation and Definitions

\r\n\r\n

Interpretation

\r\n\r\n

The words of which the initial letter is capitalized have meanings defined under the following conditions. The following definitions shall have the same meaning regardless of whether they appear in singular or in plural.

\r\n\r\n

Definitions

\r\n\r\n

For the purposes of these Terms and Conditions:

\r\n\r\n\r\n\r\n

Acknowledgment

\r\n\r\n

These are the Terms and Conditions governing the use of this Service and the agreement that operates between You and the Company. These Terms and Conditions set out the rights and obligations of all users regarding the use of the Service.

\r\n\r\n

Your access to and use of the Service is conditioned on Your acceptance of and compliance with these Terms and Conditions. These Terms and Conditions apply to all visitors, users and others who access or use the Service.

\r\n\r\n

By accessing or using the Service You agree to be bound by these Terms and Conditions. If You disagree with any part of these Terms and Conditions then You may not access the Service.

\r\n\r\n

You represent that you are over the age of 18. The Company does not permit those under 18 to use the Service.

\r\n\r\n

Your access to and use of the Service is also conditioned on Your acceptance of and compliance with the Privacy Policy of the Company. Our Privacy Policy describes Our policies and procedures on the collection, use and disclosure of Your personal information when You use the Application or the Website and tells You about Your privacy rights and how the law protects You. Please read Our Privacy Policy carefully before using Our Service.

\r\n\r\n

Links to Other Websites

\r\n\r\n

Our Service may contain links to third-party web sites or services that are not owned or controlled by the Company.

\r\n\r\n

The Company has no control over, and assumes no responsibility for, the content, privacy policies, or practices of any third party web sites or services. You further acknowledge and agree that the Company shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with the use of or reliance on any such content, goods or services available on or through any such web sites or services.

\r\n\r\n

We strongly advise You to read the terms and conditions and privacy policies of any third-party web sites or services that You visit.

\r\n\r\n

Termination

\r\n\r\n

We may terminate or suspend Your access immediately, without prior notice or liability, for any reason whatsoever, including without limitation if You breach these Terms and Conditions.

\r\n\r\n

Upon termination, Your right to use the Service will cease immediately.

\r\n\r\n

Limitation of Liability

\r\n\r\n

Notwithstanding any damages that You might incur, the entire liability of the Company and any of its suppliers under any provision of this Terms and Your exclusive remedy for all of the foregoing shall be limited to the amount actually paid by You through the Service or 100 USD if You haven't purchased anything through the Service.

\r\n\r\n

To the maximum extent permitted by applicable law, in no event shall the Company or its suppliers be liable for any special, incidental, indirect, or consequential damages whatsoever (including, but not limited to, damages for loss of profits, loss of data or other information, for business interruption, for personal injury, loss of privacy arising out of or in any way related to the use of or inability to use the Service, third-party software and/or third-party hardware used with the Service, or otherwise in connection with any provision of this Terms), even if the Company or any supplier has been advised of the possibility of such damages and even if the remedy fails of its essential purpose.

\r\n\r\n

Some states do not allow the exclusion of implied warranties or limitation of liability for incidental or consequential damages, which means that some of the above limitations may not apply. In these states, each party's liability will be limited to the greatest extent permitted by law.

\r\n\r\n

"AS IS" and "AS AVAILABLE" Disclaimer

\r\n\r\n

The Service is provided to You "AS IS" and "AS AVAILABLE" and with all faults and defects without warranty of any kind. To the maximum extent permitted under applicable law, the Company, on its own behalf and on behalf of its Affiliates and its and their respective licensors and service providers, expressly disclaims all warranties, whether express, implied, statutory or otherwise, with respect to the Service, including all implied warranties of merchantability, fitness for a particular purpose, title and non-infringement, and warranties that may arise out of course of dealing, course of performance, usage or trade practice. Without limitation to the foregoing, the Company provides no warranty or undertaking, and makes no representation of any kind that the Service will meet Your requirements, achieve any intended results, be compatible or work with any other software, applications, systems or services, operate without interruption, meet any performance or reliability standards or be error free or that any errors or defects can or will be corrected.

\r\n\r\n

Without limiting the foregoing, neither the Company nor any of the company's provider makes any representation or warranty of any kind, express or implied: (i) as to the operation or availability of the Service, or the information, content, and materials or products included thereon; (ii) that the Service will be uninterrupted or error-free; (iii) as to the accuracy, reliability, or currency of any information or content provided through the Service; or (iv) that the Service, its servers, the content, or e-mails sent from or on behalf of the Company are free of viruses, scripts, trojan horses, worms, malware, timebombs or other harmful components.

\r\n\r\n

Some jurisdictions do not allow the exclusion of certain types of warranties or limitations on applicable statutory rights of a consumer, so some or all of the above exclusions and limitations may not apply to You. But in such a case the exclusions and limitations set forth in this section shall be applied to the greatest extent enforceable under applicable law.

\r\n\r\n

Governing Law

\r\n\r\n

The laws of the Country, excluding its conflicts of law rules, shall govern this Terms and Your use of the Service. Your use of the Application may also be subject to other local, state, national, or international laws.

\r\n\r\n

Disputes Resolution

\r\n\r\n

If You have any concern or dispute about the Service, You agree to first try to resolve the dispute informally by contacting the Company.

\r\n\r\n

For European Union (EU) Users

\r\n\r\n

If You are a European Union consumer, you will benefit from any mandatory provisions of the law of the country in which You are resident.

\r\n\r\n

United States Legal Compliance

\r\n\r\n

You represent and warrant that (i) You are not located in a country that is subject to the United States government embargo, or that has been designated by the United States government as a "terrorist supporting" country, and (ii) You are not listed on any United States government list of prohibited or restricted parties.

\r\n\r\n

Severability and Waiver

\r\n\r\n

Severability

\r\n\r\n

If any provision of these Terms is held to be unenforceable or invalid, such provision will be changed and interpreted to accomplish the objectives of such provision to the greatest extent possible under applicable law and the remaining provisions will continue in full force and effect.

\r\n\r\n

Waiver

\r\n\r\n

Except as provided herein, the failure to exercise a right or to require performance of an obligation under these Terms shall not affect a party's ability to exercise such right or require such performance at any time thereafter nor shall the waiver of a breach constitute a waiver of any subsequent breach.

\r\n\r\n

Translation Interpretation

\r\n\r\n

These Terms and Conditions may have been translated if We have made them available to You on our Service. You agree that the original English text shall prevail in the case of a dispute.

\r\n\r\n

Changes to These Terms and Conditions

\r\n\r\n

We reserve the right, at Our sole discretion, to modify or replace these Terms at any time. If a revision is material We will make reasonable efforts to provide at least 30 days' notice prior to any new terms taking effect. What constitutes a material change will be determined at Our sole discretion.

\r\n\r\n

By continuing to access or use Our Service after those revisions become effective, You agree to be bound by the revised terms. If You do not agree to the new terms, in whole or in part, please stop using the website and the Service.

\r\n\r\n

Contact Us

\r\n\r\n

If you have any questions about these Terms and Conditions, You can contact us:

\r\n\r\n\r\n'); -- -------------------------------------------------------- -- -- Table structure for table `imagelibrary` -- CREATE TABLE `imagelibrary` ( `id` int(11) NOT NULL, `uid` int(11) NOT NULL, `url` varchar(150) NOT NULL, `title` varchar(100) NOT NULL, `source` varchar(10) NOT NULL DEFAULT 'custom' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_info` -- CREATE TABLE `payment_info` ( `id` int(11) NOT NULL, `customer_id` int(11) NOT NULL COMMENT 'user id', `payment_data` text NOT NULL, `order_id` text NOT NULL, `plan_id` int(11) NOT NULL, `payment_status` int(11) NOT NULL COMMENT '1 = completed, 2 = Processing, 3 = rejected', `type` int(11) NOT NULL COMMENT '0 = Paypal, 1 = Rpay, 3 = Stripe, 4 = Paystack', `is_expired` tinyint(4) NOT NULL COMMENT 'activate for free after plan expired ', `created_on` datetime NOT NULL DEFAULT current_timestamp(), `updated_on` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `payment_info` -- INSERT INTO `payment_info` (`id`, `customer_id`, `payment_data`, `order_id`, `plan_id`, `payment_status`, `type`, `is_expired`, `created_on`, `updated_on`, `status`) VALUES (1, 14, '{\"reference\":\"T009379064492238\",\"trans\":\"3919639010\",\"status\":\"success\",\"message\":\"Approved\",\"transaction\":\"3919639010\",\"trxref\":\"T009379064492238\",\"redirecturl\":\"?trxref=T009379064492238&reference=T009379064492238\",\"user_id\":\"14\",\"plan_id\":\"11\"}', '11', 11, 1, 4, 0, '2024-06-26 11:59:56', '2024-06-26 11:59:56', 1); -- -------------------------------------------------------- -- -- Table structure for table `payment_integration` -- CREATE TABLE `payment_integration` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `title` varchar(225) NOT NULL, `key` int(11) NOT NULL COMMENT '1 - PayPal 2 - Razorpay 3 - Stripe', `value` longtext NOT NULL, `pay_cred` text NOT NULL, `token_data` text NOT NULL, `isCreated` datetime NOT NULL, `isUpdated` datetime NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `plans_list` -- CREATE TABLE `plans_list` ( `id` int(11) NOT NULL, `p_name` varchar(255) NOT NULL, `p_price` int(11) NOT NULL, `p_currency` varchar(25) NOT NULL, `p_interval` int(11) NOT NULL, `p_description` text NOT NULL, `p_status` int(11) NOT NULL DEFAULT 1 COMMENT '0 = not active, 1 = active\r\n', `p_templates` text NOT NULL, `p_sites` int(11) NOT NULL, `date_created` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `site_analytics` -- CREATE TABLE `site_analytics` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `site_id` int(11) NOT NULL COMMENT 'user_campaign id', `visit_count` int(11) NOT NULL, `date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `site_settings` -- CREATE TABLE `site_settings` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `site_name` varchar(25) NOT NULL, `site_logo` varchar(255) NOT NULL, `site_favicon` varchar(255) NOT NULL, `mandrill_settings` text NOT NULL, `smtp_settings` text NOT NULL, `support_email` text NOT NULL, `date_updated` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `site_settings` -- INSERT INTO `site_settings` (`id`, `user_id`, `site_name`, `site_logo`, `site_favicon`, `mandrill_settings`, `smtp_settings`, `support_email`, `date_updated`) VALUES (1, 1, 'PixelPages1', '', '', '', '', 'support@pixelpages.net', '2024-06-27 11:43:09'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_countries` -- CREATE TABLE `tbl_countries` ( `id` int(11) NOT NULL, `sortname` varchar(3) NOT NULL, `name` varchar(150) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- -- Dumping data for table `tbl_countries` -- INSERT INTO `tbl_countries` (`id`, `sortname`, `name`) VALUES (1, 'AF', 'Afghanistan'), (2, 'AL', 'Albania'), (3, 'DZ', 'Algeria'), (4, 'AS', 'American Samoa'), (5, 'AD', 'Andorra'), (6, 'AO', 'Angola'), (7, 'AI', 'Anguilla'), (8, 'AQ', 'Antarctica'), (9, 'AG', 'Antigua And Barbuda'), (10, 'AR', 'Argentina'), (11, 'AM', 'Armenia'), (12, 'AW', 'Aruba'), (13, 'AU', 'Australia'), (14, 'AT', 'Austria'), (15, 'AZ', 'Azerbaijan'), (16, 'BS', 'Bahamas The'), (17, 'BH', 'Bahrain'), (18, 'BD', 'Bangladesh'), (19, 'BB', 'Barbados'), (20, 'BY', 'Belarus'), (21, 'BE', 'Belgium'), (22, 'BZ', 'Belize'), (23, 'BJ', 'Benin'), (24, 'BM', 'Bermuda'), (25, 'BT', 'Bhutan'), (26, 'BO', 'Bolivia'), (27, 'BA', 'Bosnia and Herzegovina'), (28, 'BW', 'Botswana'), (29, 'BV', 'Bouvet Island'), (30, 'BR', 'Brazil'), (31, 'IO', 'British Indian Ocean Territory'), (32, 'BN', 'Brunei'), (33, 'BG', 'Bulgaria'), (34, 'BF', 'Burkina Faso'), (35, 'BI', 'Burundi'), (36, 'KH', 'Cambodia'), (37, 'CM', 'Cameroon'), (38, 'CA', 'Canada'), (39, 'CV', 'Cape Verde'), (40, 'KY', 'Cayman Islands'), (41, 'CF', 'Central African Republic'), (42, 'TD', 'Chad'), (43, 'CL', 'Chile'), (44, 'CN', 'China'), (45, 'CX', 'Christmas Island'), (46, 'CC', 'Cocos (Keeling) Islands'), (47, 'CO', 'Colombia'), (48, 'KM', 'Comoros'), (49, 'CG', 'Congo'), (50, 'CD', 'Congo The Democratic Republic Of The'), (51, 'CK', 'Cook Islands'), (52, 'CR', 'Costa Rica'), (53, 'CI', 'Cote D\'Ivoire (Ivory Coast)'), (54, 'HR', 'Croatia (Hrvatska)'), (55, 'CU', 'Cuba'), (56, 'CY', 'Cyprus'), (57, 'CZ', 'Czech Republic'), (58, 'DK', 'Denmark'), (59, 'DJ', 'Djibouti'), (60, 'DM', 'Dominica'), (61, 'DO', 'Dominican Republic'), (62, 'TP', 'East Timor'), (63, 'EC', 'Ecuador'), (64, 'EG', 'Egypt'), (65, 'SV', 'El Salvador'), (66, 'GQ', 'Equatorial Guinea'), (67, 'ER', 'Eritrea'), (68, 'EE', 'Estonia'), (69, 'ET', 'Ethiopia'), (70, 'XA', 'External Territories of Australia'), (71, 'FK', 'Falkland Islands'), (72, 'FO', 'Faroe Islands'), (73, 'FJ', 'Fiji Islands'), (74, 'FI', 'Finland'), (75, 'FR', 'France'), (76, 'GF', 'French Guiana'), (77, 'PF', 'French Polynesia'), (78, 'TF', 'French Southern Territories'), (79, 'GA', 'Gabon'), (80, 'GM', 'Gambia The'), (81, 'GE', 'Georgia'), (82, 'DE', 'Germany'), (83, 'GH', 'Ghana'), (84, 'GI', 'Gibraltar'), (85, 'GR', 'Greece'), (86, 'GL', 'Greenland'), (87, 'GD', 'Grenada'), (88, 'GP', 'Guadeloupe'), (89, 'GU', 'Guam'), (90, 'GT', 'Guatemala'), (91, 'XU', 'Guernsey and Alderney'), (92, 'GN', 'Guinea'), (93, 'GW', 'Guinea-Bissau'), (94, 'GY', 'Guyana'), (95, 'HT', 'Haiti'), (96, 'HM', 'Heard and McDonald Islands'), (97, 'HN', 'Honduras'), (98, 'HK', 'Hong Kong S.A.R.'), (99, 'HU', 'Hungary'), (100, 'IS', 'Iceland'), (101, 'IN', 'India'), (102, 'ID', 'Indonesia'), (103, 'IR', 'Iran'), (104, 'IQ', 'Iraq'), (105, 'IE', 'Ireland'), (106, 'IL', 'Israel'), (107, 'IT', 'Italy'), (108, 'JM', 'Jamaica'), (109, 'JP', 'Japan'), (110, 'XJ', 'Jersey'), (111, 'JO', 'Jordan'), (112, 'KZ', 'Kazakhstan'), (113, 'KE', 'Kenya'), (114, 'KI', 'Kiribati'), (115, 'KP', 'Korea North'), (116, 'KR', 'Korea South'), (117, 'KW', 'Kuwait'), (118, 'KG', 'Kyrgyzstan'), (119, 'LA', 'Laos'), (120, 'LV', 'Latvia'), (121, 'LB', 'Lebanon'), (122, 'LS', 'Lesotho'), (123, 'LR', 'Liberia'), (124, 'LY', 'Libya'), (125, 'LI', 'Liechtenstein'), (126, 'LT', 'Lithuania'), (127, 'LU', 'Luxembourg'), (128, 'MO', 'Macau S.A.R.'), (129, 'MK', 'Macedonia'), (130, 'MG', 'Madagascar'), (131, 'MW', 'Malawi'), (132, 'MY', 'Malaysia'), (133, 'MV', 'Maldives'), (134, 'ML', 'Mali'), (135, 'MT', 'Malta'), (136, 'XM', 'Man (Isle of)'), (137, 'MH', 'Marshall Islands'), (138, 'MQ', 'Martinique'), (139, 'MR', 'Mauritania'), (140, 'MU', 'Mauritius'), (141, 'YT', 'Mayotte'), (142, 'MX', 'Mexico'), (143, 'FM', 'Micronesia'), (144, 'MD', 'Moldova'), (145, 'MC', 'Monaco'), (146, 'MN', 'Mongolia'), (147, 'MS', 'Montserrat'), (148, 'MA', 'Morocco'), (149, 'MZ', 'Mozambique'), (150, 'MM', 'Myanmar'), (151, 'NA', 'Namibia'), (152, 'NR', 'Nauru'), (153, 'NP', 'Nepal'), (154, 'AN', 'Netherlands Antilles'), (155, 'NL', 'Netherlands The'), (156, 'NC', 'New Caledonia'), (157, 'NZ', 'New Zealand'), (158, 'NI', 'Nicaragua'), (159, 'NE', 'Niger'), (160, 'NG', 'Nigeria'), (161, 'NU', 'Niue'), (162, 'NF', 'Norfolk Island'), (163, 'MP', 'Northern Mariana Islands'), (164, 'NO', 'Norway'), (165, 'OM', 'Oman'), (166, 'PK', 'Pakistan'), (167, 'PW', 'Palau'), (168, 'PS', 'Palestinian Territory Occupied'), (169, 'PA', 'Panama'), (170, 'PG', 'Papua new Guinea'), (171, 'PY', 'Paraguay'), (172, 'PE', 'Peru'), (173, 'PH', 'Philippines'), (174, 'PN', 'Pitcairn Island'), (175, 'PL', 'Poland'), (176, 'PT', 'Portugal'), (177, 'PR', 'Puerto Rico'), (178, 'QA', 'Qatar'), (179, 'RE', 'Reunion'), (180, 'RO', 'Romania'), (181, 'RU', 'Russia'), (182, 'RW', 'Rwanda'), (183, 'SH', 'Saint Helena'), (184, 'KN', 'Saint Kitts And Nevis'), (185, 'LC', 'Saint Lucia'), (186, 'PM', 'Saint Pierre and Miquelon'), (187, 'VC', 'Saint Vincent And The Grenadines'), (188, 'WS', 'Samoa'), (189, 'SM', 'San Marino'), (190, 'ST', 'Sao Tome and Principe'), (191, 'SA', 'Saudi Arabia'), (192, 'SN', 'Senegal'), (193, 'RS', 'Serbia'), (194, 'SC', 'Seychelles'), (195, 'SL', 'Sierra Leone'), (196, 'SG', 'Singapore'), (197, 'SK', 'Slovakia'), (198, 'SI', 'Slovenia'), (199, 'XG', 'Smaller Territories of the UK'), (200, 'SB', 'Solomon Islands'), (201, 'SO', 'Somalia'), (202, 'ZA', 'South Africa'), (203, 'GS', 'South Georgia'), (204, 'SS', 'South Sudan'), (205, 'ES', 'Spain'), (206, 'LK', 'Sri Lanka'), (207, 'SD', 'Sudan'), (208, 'SR', 'Suriname'), (209, 'SJ', 'Svalbard And Jan Mayen Islands'), (210, 'SZ', 'Swaziland'), (211, 'SE', 'Sweden'), (212, 'CH', 'Switzerland'), (213, 'SY', 'Syria'), (214, 'TW', 'Taiwan'), (215, 'TJ', 'Tajikistan'), (216, 'TZ', 'Tanzania'), (217, 'TH', 'Thailand'), (218, 'TG', 'Togo'), (219, 'TK', 'Tokelau'), (220, 'TO', 'Tonga'), (221, 'TT', 'Trinidad And Tobago'), (222, 'TN', 'Tunisia'), (223, 'TR', 'Turkey'), (224, 'TM', 'Turkmenistan'), (225, 'TC', 'Turks And Caicos Islands'), (226, 'TV', 'Tuvalu'), (227, 'UG', 'Uganda'), (228, 'UA', 'Ukraine'), (229, 'AE', 'United Arab Emirates'), (230, 'GB', 'United Kingdom'), (231, 'US', 'United States'), (232, 'UM', 'United States Minor Outlying Islands'), (233, 'UY', 'Uruguay'), (234, 'UZ', 'Uzbekistan'), (235, 'VU', 'Vanuatu'), (236, 'VA', 'Vatican City State (Holy See)'), (237, 'VE', 'Venezuela'), (238, 'VN', 'Vietnam'), (239, 'VG', 'Virgin Islands (British)'), (240, 'VI', 'Virgin Islands (US)'), (241, 'WF', 'Wallis And Futuna Islands'), (242, 'EH', 'Western Sahara'), (243, 'YE', 'Yemen'), (244, 'YU', 'Yugoslavia'), (245, 'ZM', 'Zambia'), (246, 'ZW', 'Zimbabwe'); -- -------------------------------------------------------- -- -- Table structure for table `usertbl` -- CREATE TABLE `usertbl` ( `u_id` int(11) NOT NULL, `u_name` varchar(255) NOT NULL, `u_email` varchar(255) NOT NULL, `u_pic` text NOT NULL, `u_password` varchar(255) NOT NULL, `u_type` tinyint(4) NOT NULL COMMENT '1-Admin,2-Users,3-Team Member, 4-Client, 5-Reseller, 6-desginer', `u_status` tinyint(4) NOT NULL COMMENT '1-Active,2-InActive,3-Suspicious, 4-none-Suspicious', `u_plan` text NOT NULL, `is_parent` int(11) NOT NULL, `parent_id` int(11) NOT NULL COMMENT 'User id of TeamMember/Client/Reseller account', `u_purchaseddate` datetime NOT NULL, `u_profile_details` text NOT NULL, `created_on` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `usertbl` -- INSERT INTO `usertbl` (`u_id`, `u_name`, `u_email`, `u_pic`, `u_password`, `u_type`, `u_status`, `u_plan`, `is_parent`, `parent_id`, `u_purchaseddate`, `u_profile_details`, `created_on`) VALUES (1, 'Admin', 'admin@pixelpages.net', 'uploads/profile_img/profile_17.png', 'e6e061838856bf47e1de730719fb2609', 1, 1, '', 0, 0, '0000-00-00 00:00:00', '{\"ppa_uname\":\"Admin\",\"ppa_number\":null,\"ppa_address\":null,\"ppa_city\":null,\"ppa_state\":null,\"ppa_zipcode\":null,\"ppa_country\":null}', '2024-05-13 04:54:26'); -- -------------------------------------------------------- -- -- Table structure for table `user_campaigns` -- CREATE TABLE `user_campaigns` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `temp_id` int(11) NOT NULL, `template_name` varchar(225) NOT NULL, `campaign_host_name` varchar(255) NOT NULL, `template_metadata` text NOT NULL, `template_thumbnail` varchar(225) NOT NULL, `email_setting` text NOT NULL, `custom_css` longtext NOT NULL, `custom_js` longtext NOT NULL, `template_html` longtext NOT NULL, `created_date` datetime NOT NULL DEFAULT current_timestamp(), `status` tinyint(4) NOT NULL DEFAULT 1, `template_settings` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `ar_form_data` -- ALTER TABLE `ar_form_data` ADD PRIMARY KEY (`id`); -- -- Indexes for table `autoresponder` -- ALTER TABLE `autoresponder` ADD PRIMARY KEY (`id`), ADD KEY `m_id` (`user_id`); -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`id`); -- -- Indexes for table `currencies` -- ALTER TABLE `currencies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dfy_templates` -- ALTER TABLE `dfy_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `frontend_settings` -- ALTER TABLE `frontend_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `imagelibrary` -- ALTER TABLE `imagelibrary` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_info` -- ALTER TABLE `payment_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_integration` -- ALTER TABLE `payment_integration` ADD PRIMARY KEY (`id`); -- -- Indexes for table `plans_list` -- ALTER TABLE `plans_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `site_analytics` -- ALTER TABLE `site_analytics` ADD PRIMARY KEY (`id`); -- -- Indexes for table `site_settings` -- ALTER TABLE `site_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_countries` -- ALTER TABLE `tbl_countries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `usertbl` -- ALTER TABLE `usertbl` ADD PRIMARY KEY (`u_id`); -- -- Indexes for table `user_campaigns` -- ALTER TABLE `user_campaigns` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ar_form_data` -- ALTER TABLE `ar_form_data` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `autoresponder` -- ALTER TABLE `autoresponder` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `currencies` -- ALTER TABLE `currencies` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80; -- -- AUTO_INCREMENT for table `dfy_templates` -- ALTER TABLE `dfy_templates` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101; -- -- AUTO_INCREMENT for table `frontend_settings` -- ALTER TABLE `frontend_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `imagelibrary` -- ALTER TABLE `imagelibrary` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment_info` -- ALTER TABLE `payment_info` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `payment_integration` -- ALTER TABLE `payment_integration` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `plans_list` -- ALTER TABLE `plans_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `site_analytics` -- ALTER TABLE `site_analytics` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `site_settings` -- ALTER TABLE `site_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_countries` -- ALTER TABLE `tbl_countries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247; -- -- AUTO_INCREMENT for table `usertbl` -- ALTER TABLE `usertbl` MODIFY `u_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `user_campaigns` -- ALTER TABLE `user_campaigns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!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 */;