-
Notifications
You must be signed in to change notification settings - Fork 0
/
domain_config.sql
90 lines (76 loc) · 22.8 KB
/
domain_config.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 29, 2024 at 09:06 PM
-- Server version: 5.7.42-log
-- PHP Version: 7.4.33
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: `test_harry`
--
-- --------------------------------------------------------
--
-- Table structure for table `domain_config`
--
CREATE TABLE `domain_config` (
`id` int(11) NOT NULL,
`domain` varchar(255) NOT NULL,
`location_id` varchar(255) DEFAULT NULL,
`v_location_id` varchar(255) DEFAULT NULL,
`logo_url` varchar(255) DEFAULT NULL,
`background` varchar(255) DEFAULT NULL,
`dark_back` varchar(255) DEFAULT NULL,
`side_dark_back` varchar(255) DEFAULT NULL,
`side_back` varchar(255) DEFAULT NULL,
`grid_back` varchar(255) DEFAULT NULL,
`dark_grid_back` varchar(255) DEFAULT NULL,
`text_light` varchar(255) DEFAULT NULL,
`text_dark` varchar(255) DEFAULT NULL,
`icon_button_back` varchar(255) DEFAULT NULL,
`button_bottom_border` varchar(255) DEFAULT NULL,
`company_name` varchar(255) DEFAULT NULL,
`company_address` varchar(255) DEFAULT NULL,
`heading_color` varchar(255) DEFAULT NULL,
`emcode` longtext NOT NULL,
`cfv` longtext,
`cvv` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `domain_config`
--
INSERT INTO `domain_config` (`id`, `domain`, `location_id`, `v_location_id`, `logo_url`, `background`, `dark_back`, `side_dark_back`, `side_back`, `grid_back`, `dark_grid_back`, `text_light`, `text_dark`, `icon_button_back`, `button_bottom_border`, `company_name`, `company_address`, `heading_color`, `emcode`, `cfv`, `cvv`) VALUES
(1, 'portal.crmsoftware.ae', 'N2WFjzprq6BuyzRjJzNl', 'U1rqLdAWOqXSU1X1nFXB', 'https://app.crmsoftware.ae/writable/uploads/1686641765_6afe625fd388f4276e44.png', 'bg-white', 'bg-zinc-950', 'bg-zinc-900', 'bg-slate-50', 'bg-gray-100', 'bg-zinc-900', 'text-gray-900', 'text-white', 'bg-blue-500', 'rounded-full', 'CRM Software', 'Park1 Place Tower - Office No 401 Sheikh Zayed Rd - Trade Centre - Trade Centre 1 - Dubai', 'text-sky-600', ' <style>\r\n.border-red-700{\r\ncursor:pointer\r\n}\r\n</style>\r\n ', NULL, NULL),
(7, 'portal.ebmsbusiness.com', 'N2WFjzprq6BuyzRjJzNl', 'U1rqLdAWOqXSU1X1nFXB', 'https://ebmsbusiness.com/wp-content/uploads/2021/02/ebms-logo.png', 'bg-white', 'bg-zinc-950', 'bg-zinc-900', 'bg-slate-50', 'bg-gray-100', 'bg-zinc-900', 'text-gray-900', 'text-white', 'bg-blue-700', 'rounded-full', 'EBMS BUSINESS SERVICES', 'Park1 Place Tower - Office No 401 Sheikh Zayed Rd - Trade Centre - Trade Centre 1 - Dubai', 'text-sky-600', ' <script async src=\"https://chat.ebmschat.com/wwwa.js?fgh=1123k12\" data-wwwa=\"48\"></script>\r\n<script src=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.3.3/js/bootstrap.min.js\" integrity=\"sha512-ykZ1QQr0Jy/4ZkvKuqWn4iF3lqPZyij9iRv6sGqLRdTPkY69YX6+7wvVGmsdBbiIfN/8OdsI7HABjvEok6ZopQ==\" crossorigin=\"anonymous\" referrerpolicy=\"no-referrer\"></script>\r\n \r\n<style>\r\n.Addon{\r\npadding:0px !important;\r\nmargin:0px !important\r\n}\r\n\r\n.menlink{\r\nbackground-color:rgba(40, 54, 255, 0.04);\r\n\r\n}\r\n</style>\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.upload_application_form\', title: \'Application Form\' },\r\n{ key: \'contact.upload_license\', title: \'Business Licesne\' },\r\n{ key: \'contact.upload_certificate_of_formation\', title: \'Certificate Of Formation\' },\r\n{ key: \'contact.uplod_memorandum\', title: \'Memorandum\' },\r\n{ key: \'contact.upload_immigration_card\', title: \'Immigiration Card\' },\r\n{ key: \'contact.upload_freezone_proposal\', title: \'Freezone Proposal\' },\r\n{ key: \'contact.upload_occupancy_agreement\', title: \'Occupancy Agreement\' },\r\n{ key: \'contact.upload_business_activity\', title: \'Business Activity Certificate\' },\r\n{ key: \'contact.virtual_address\', title: \'Virtual Adress\' },\r\n{ key: \'contact.article_of_association\', title: \'Artical Of Association\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.e_visa_proof_of_payment\', title: \'E-Visa Proof OF Payment\' },\r\n{ key: \'contact.upload_e_visa\', title: \'E-Visa\' },\r\n{ key: \'contact.upload_change_status\', title: \'Change Status\' },\r\n{ key: \'contact.upload_medical__emirates_id_payment_proof\', title: \'Medical & Emirates Id Payment Proof\' },\r\n{ key: \'contact.upload_medical_fitness_report\', title: \'Medical Fitness Report\' },\r\n{ key: \'contact.upload_stamped_bio_metric\', title: \'Stamped Bio Metric\' },\r\n{ key: \'contact.upload_residence_visa_stamping\', title: \'Residence Visa Stamping\' },\r\n{ key: \'contact.upload_emirates_id\', title: \'Emirates ID\' }\r\n \r\n \r\n \r\n '),
(8, 'portal.expertplus.ae', 'RaMX8aRPgsxsz1iIvJTn', 'KlCDVqGjmyJyWrHMJP10', 'https://expertplus.ae/wp-content/uploads/2023/10/Ep-logo.svg', 'bg-white', 'bg-cyan-900', 'bg-cyan-950', 'bg-slate-50', 'bg-slate-100', 'bg-cyan-950', 'text-pink-950', 'text-white', 'bg-cyan-800', 'rounded-full', 'Expert Plus Business Setup', 'Office 106 White Crown Building, Shaikh Zayed Road, Dubai, UAE', 'text-sky-600', '<style>\r\n.Addon{\r\npadding:0px !important;\r\nmargin:0px !important\r\n}\r\n\r\n.menlink{\r\nbackground-color:rgba(40, 54, 255, 0.04);\r\n\r\n}\r\n</style> \r\n', ' { key: \'contact.upload_application_form\', title: \'Application Form\' },\r\n{ key: \'contact.upload_license\', title: \'Business Licesne\' },\r\n{ key: \'contact.upload_certificate_of_formation\', title: \'Certificate Of Formation\' },\r\n{ key: \'contact.uplod_memorandum\', title: \'Memorandum\' },\r\n{ key: \'contact.upload_immigration_card\', title: \'Immigiration Card\' },\r\n{ key: \'contact.upload_freezone_proposal\', title: \'Freezone Proposal\' },\r\n{ key: \'contact.upload_occupancy_agreement\', title: \'Occupancy Agreement\' },\r\n{ key: \'contact.upload_business_activity\', title: \'Business Activity Certificate\' },\r\n{ key: \'contact.virtual_address\', title: \'Virtual Adress\' },\r\n{ key: \'contact.article_of_association\', title: \'Artical Of Association\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.e_visa_proof_of_payment\', title: \'E-Visa Proof OF Payment\' },\r\n{ key: \'contact.upload_e_visa\', title: \'E-Visa\' },\r\n{ key: \'contact.upload_change_status\', title: \'Change Status\' },\r\n{ key: \'contact.upload_medical__emirates_id_payment_proof\', title: \'Medical & Emirates Id Payment Proof\' },\r\n{ key: \'contact.upload_medical_fitness_report\', title: \'Medical Fitness Report\' },\r\n{ key: \'contact.upload_stamped_bio_metric\', title: \'Stamped Bio Metric\' },\r\n{ key: \'contact.upload_residence_visa_stamping\', title: \'Residence Visa Stamping\' },\r\n{ key: \'contact.upload_emirates_id\', title: \'Emirates ID\' }\r\n \r\n \r\n \r\n \r\n \r\n '),
(9, 'portal.positivezone.ae', '5gGLQlyjPr1Tq4ndokP1', 'PrXdHgTixh6kLJaEzLkF', 'https://positivezone.ae/wp-content/uploads/2022/05/positive-zone-logo.svg', 'bg-white', 'bg-cyan-900', 'bg-cyan-950', 'bg-slate-50', 'bg-slate-100', 'bg-cyan-950', 'text-pink-950', 'text-white', 'bg-cyan-800', 'rounded-full', 'POSITIVE ZONE COMMERCIAL INFORMATION SERVICES', 'White Crown Building Office Number - 306 Sheikh Zayed Rd - Trade Centre - Trade Centre 1 - Dubai', 'text-sky-600', ' <style>\r\n.Addon{\r\npadding:0px !important;\r\nmargin:0px !important\r\n}\r\n\r\n.menlink{\r\nbackground-color:rgba(40, 54, 255, 0.04);\r\n\r\n}\r\n</style> \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.upload_application_form\', title: \'Application Form\' },\r\n{ key: \'contact.upload_license\', title: \'Business Licesne\' },\r\n{ key: \'contact.upload_certificate_of_formation\', title: \'Certificate Of Formation\' },\r\n{ key: \'contact.uplod_memorandum\', title: \'Memorandum\' },\r\n{ key: \'contact.upload_immigration_card\', title: \'Immigiration Card\' },\r\n{ key: \'contact.upload_freezone_proposal\', title: \'Freezone Proposal\' },\r\n{ key: \'contact.upload_occupancy_agreement\', title: \'Occupancy Agreement\' },\r\n{ key: \'contact.upload_business_activity\', title: \'Business Activity Certificate\' },\r\n{ key: \'contact.virtual_address\', title: \'Virtual Adress\' },\r\n{ key: \'contact.article_of_association\', title: \'Artical Of Association\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.e_visa_proof_of_payment\', title: \'E-Visa Proof OF Payment\' },\r\n{ key: \'contact.upload_e_visa\', title: \'E-Visa\' },\r\n{ key: \'contact.upload_change_status\', title: \'Change Status\' },\r\n{ key: \'contact.upload_medical__emirates_id_payment_proof\', title: \'Medical & Emirates Id Payment Proof\' },\r\n{ key: \'contact.upload_medical_fitness_report\', title: \'Medical Fitness Report\' },\r\n{ key: \'contact.upload_stamped_bio_metric\', title: \'Stamped Bio Metric\' },\r\n{ key: \'contact.upload_residence_visa_stamping\', title: \'Residence Visa Stamping\' },\r\n{ key: \'contact.upload_emirates_id\', title: \'Emirates ID\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n '),
(10, 'portal.easywaybusiness.ae', 'SljjOCSKys3hP4eTRkMg', 'Z41IU9EOo70c8YWop2vj', 'https://easywaybusiness.ae/wp-content/uploads/2023/03/ewbs-logo-1.svg', 'bg-white', 'bg-cyan-900', 'bg-cyan-950', 'bg-slate-50', 'bg-slate-100', 'bg-cyan-950', 'text-pink-950', 'text-white', 'bg-cyan-800', 'rounded-full', 'Easyway Business Services', 'White Crown Building - Office No 105 - Trade Centre - Trade Centre 1 - Dubai - United Arab Emirates', 'text-sky-600', ' <style>\r\n.Addon{\r\npadding:0px !important;\r\nmargin:0px !important\r\n}\r\n\r\n.menlink{\r\nbackground-color:rgba(40, 54, 255, 0.04);\r\n\r\n}\r\n</style> \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.upload_application_form\', title: \'Application Form\' },\r\n{ key: \'contact.upload_license\', title: \'Business Licesne\' },\r\n{ key: \'contact.upload_certificate_of_formation\', title: \'Certificate Of Formation\' },\r\n{ key: \'contact.uplod_memorandum\', title: \'Memorandum\' },\r\n{ key: \'contact.upload_immigration_card\', title: \'Immigiration Card\' },\r\n{ key: \'contact.upload_freezone_proposal\', title: \'Freezone Proposal\' },\r\n{ key: \'contact.upload_occupancy_agreement\', title: \'Occupancy Agreement\' },\r\n{ key: \'contact.upload_business_activity\', title: \'Business Activity Certificate\' },\r\n{ key: \'contact.virtual_address\', title: \'Virtual Adress\' },\r\n{ key: \'contact.article_of_association\', title: \'Artical Of Association\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.e_visa_proof_of_payment\', title: \'E-Visa Proof OF Payment\' },\r\n{ key: \'contact.upload_e_visa\', title: \'E-Visa\' },\r\n{ key: \'contact.upload_change_status\', title: \'Change Status\' },\r\n{ key: \'contact.upload_medical__emirates_id_payment_proof\', title: \'Medical & Emirates Id Payment Proof\' },\r\n{ key: \'contact.upload_medical_fitness_report\', title: \'Medical Fitness Report\' },\r\n{ key: \'contact.upload_stamped_bio_metric\', title: \'Stamped Bio Metric\' },\r\n{ key: \'contact.upload_residence_visa_stamping\', title: \'Residence Visa Stamping\' },\r\n{ key: \'contact.upload_emirates_id\', title: \'Emirates ID\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n '),
(11, 'portal.excellencezone.ae', 'iBg8DQNxQsR8Riaehhag', 'tqJ1AHkLzv8hC6SzXBc4', 'https://excellencezone.ae/wp-content/uploads/2023/07/EZ-logo.svg', 'bg-white', 'bg-cyan-900', 'bg-cyan-950', 'bg-slate-50', 'bg-slate-100', 'bg-cyan-950', 'text-pink-950', 'text-white', 'bg-cyan-800', 'rounded-full', 'Excellencezone Business Setup Services', 'White Crown Building - Office Number 1601,011 Park Place Tower World Trade Center Dubai', 'text-sky-600', ' <style>\r\n.Addon{\r\npadding:0px !important;\r\nmargin:0px !important\r\n}\r\n\r\n.menlink{\r\nbackground-color:rgba(40, 54, 255, 0.04);\r\n\r\n}\r\n</style> \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.upload_application_form\', title: \'Application Form\' },\r\n{ key: \'contact.upload_license\', title: \'Business Licesne\' },\r\n{ key: \'contact.upload_certificate_of_formation\', title: \'Certificate Of Formation\' },\r\n{ key: \'contact.uplod_memorandum\', title: \'Memorandum\' },\r\n{ key: \'contact.upload_immigration_card\', title: \'Immigiration Card\' },\r\n{ key: \'contact.upload_freezone_proposal\', title: \'Freezone Proposal\' },\r\n{ key: \'contact.upload_occupancy_agreement\', title: \'Occupancy Agreement\' },\r\n{ key: \'contact.upload_business_activity\', title: \'Business Activity Certificate\' },\r\n{ key: \'contact.virtual_address\', title: \'Virtual Adress\' },\r\n{ key: \'contact.article_of_association\', title: \'Artical Of Association\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ', ' { key: \'contact.e_visa_proof_of_payment\', title: \'E-Visa Proof OF Payment\' },\r\n{ key: \'contact.upload_e_visa\', title: \'E-Visa\' },\r\n{ key: \'contact.upload_change_status\', title: \'Change Status\' },\r\n{ key: \'contact.upload_medical__emirates_id_payment_proof\', title: \'Medical & Emirates Id Payment Proof\' },\r\n{ key: \'contact.upload_medical_fitness_report\', title: \'Medical Fitness Report\' },\r\n{ key: \'contact.upload_stamped_bio_metric\', title: \'Stamped Bio Metric\' },\r\n{ key: \'contact.upload_residence_visa_stamping\', title: \'Residence Visa Stamping\' },\r\n{ key: \'contact.upload_emirates_id\', title: \'Emirates ID\' }\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `domain_config`
--
ALTER TABLE `domain_config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `domain` (`domain`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `domain_config`
--
ALTER TABLE `domain_config`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
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 */;