-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `elitdevs_w_marketing_1`
--

-- --------------------------------------------------------

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subdomain` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `cover` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '1',
  `lat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lng` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minimum` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `description` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fee` double(8,2) NOT NULL DEFAULT '0.00',
  `static_fee` double(8,2) NOT NULL DEFAULT '0.00',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `views` int NOT NULL DEFAULT '0',
  `whatsapp_phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `do_covertion` int NOT NULL DEFAULT '1',
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_info` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mollie_payment_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint UNSIGNED DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_reply_at` timestamp NULL DEFAULT NULL,
  `last_client_reply_at` timestamp NULL DEFAULT NULL,
  `last_support_reply_at` timestamp NULL DEFAULT NULL,
  `last_message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `is_last_message_by_contact` tinyint(1) NOT NULL DEFAULT '0',
  `has_chat` tinyint(1) NOT NULL DEFAULT '0',
  `resolved_chat` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `enabled_ai_bot` tinyint(1) NOT NULL DEFAULT '1',
  `subscribed` tinyint(1) NOT NULL DEFAULT '1',
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `lng` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `iso2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso3` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timezone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `languages` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `lat`, `lng`, `iso2`, `iso3`, `phone_code`, `timezone`, `languages`, `created_at`, `updated_at`) VALUES
(1, 'Afghanistan', '33.93911', '67.709953', 'AF', 'AFG', '93', 'Asia/Kabul', 'fa-AF,ps,uz-AF,tk', NULL, NULL),
(2, 'Albania', '41.153332', '20.168331', 'AL', 'ALB', '355', 'Europe/Tirane', 'sq,el', NULL, NULL),
(3, 'Algeria', '28.033886', '1.659626', 'DZ', 'DZA', '213', 'Africa/Algiers', 'ar-DZ', NULL, NULL),
(4, 'American Samoa', '-14.270972', '-170.132217', 'AS', 'ASM', '1-684', 'Pacific/Pago_Pago', 'en-AS,sm,to', NULL, NULL),
(5, 'Andorra', '42.546245', '1.601554', 'AD', 'AND', '376', 'Europe/Andorra', 'ca', NULL, NULL),
(6, 'Angola', '-11.202692', '17.873887', 'AO', 'AGO', '244', 'Africa/Lagos', 'pt-AO', NULL, NULL),
(7, 'Anguilla', '18.220554', '-63.068615', 'AI', 'AIA', '1-264', 'America/Port_of_Spain', 'en-AI', NULL, NULL),
(8, 'Antarctica', '-75.250973', '-0.071389', 'AQ', 'ATA', '672', 'Antarctica/Troll', '', NULL, NULL),
(9, 'Antigua and Barbuda', '17.060816', '-61.796428', 'AG', 'ATG', '1-268', 'America/Antigua', 'en-AG', NULL, NULL),
(10, 'Argentina', '-38.416097', '-63.616672', 'AR', 'ARG', '54', 'America/Argentina/Buenos_Aires', 'es-AR,en,it,de,fr,gn', NULL, NULL),
(11, 'Armenia', '40.069099', '45.038189', 'AM', 'ARM', '374', 'Asia/Yerevan', 'hy', NULL, NULL),
(12, 'Aruba', '12.52111', '-69.968338', 'AW', 'ABW', '297', 'America/Curacao', 'nl-AW,es,en', NULL, NULL),
(13, 'Australia', '-25.274398', '133.775136', 'AU', 'AUS', '61', 'Australia/Sydney', 'en-AU', NULL, NULL),
(14, 'Austria', '47.516231', '14.550072', 'AT', 'AUT', '43', 'Europe/Vienna', 'de-AT,hr,hu,sl', NULL, NULL),
(15, 'Azerbaijan', '40.143105', '47.576927', 'AZ', 'AZE', '994', 'Asia/Baku', 'az,ru,hy', NULL, NULL),
(16, 'Bahamas', '25.03428', '-77.39628', 'BS', 'BHS', '1-242', 'America/Nassau', 'en-BS', NULL, NULL),
(17, 'Bahrain', '25.930414', '50.637772', 'BH', 'BHR', '973', 'Asia/Bahrain', 'ar-BH,en,fa,ur', NULL, NULL),
(18, 'Bangladesh', '23.684994', '90.356331', 'BD', 'BGD', '880', 'Asia/Dhaka', 'bn-BD,en', NULL, NULL),
(19, 'Barbados', '13.193887', '-59.543198', 'BB', 'BRB', '1-246', 'America/Barbados', 'en-BB', NULL, NULL),
(20, 'Belarus', '53.709807', '27.953389', 'BY', 'BLR', '375', 'Europe/Minsk', 'be,ru', NULL, NULL),
(21, 'Belgium', '50.503887', '4.469936', 'BE', 'BEL', '32', 'Europe/Brussels', 'nl-BE,fr-BE,de-BE', NULL, NULL),
(22, 'Belize', '17.189877', '-88.49765', 'BZ', 'BLZ', '501', 'America/Belize', 'en-BZ,es', NULL, NULL),
(23, 'Benin', '9.30769', '2.315834', 'BJ', 'BEN', '229', 'Africa/Lagos', 'fr-BJ', NULL, NULL),
(24, 'Bermuda', '32.321384', '-64.75737', 'BM', 'BMU', '1-441', 'Atlantic/Bermuda', 'en-BM,pt', NULL, NULL),
(25, 'Bhutan', '27.514162', '90.433601', 'BT', 'BTN', '975', 'Asia/Thimphu', 'dz', NULL, NULL),
(26, 'Bolivia', '-16.290154', '-63.588653', 'BO', 'BOL', '591', 'America/La_Paz', 'es-BO,qu,ay', NULL, NULL),
(27, 'Bosnia and Herzegovina', '43.915886', '17.679076', 'BA', 'BIH', '387', 'Europe/Belgrade', 'bs,hr-BA,sr-BA', NULL, NULL),
(28, 'Botswana', '-22.328474', '24.684866', 'BW', 'BWA', '267', 'Africa/Maputo', 'en-BW,tn-BW', NULL, NULL),
(29, 'Brazil', '-14.235004', '-51.92528', 'BR', 'BRA', '55', 'America/Sao_Paulo', 'pt-BR,es,en,fr', NULL, NULL),
(30, 'British Indian Ocean Territory', '-6.343194', '71.876519', 'IO', 'IOT', '246', 'Indian/Chagos', 'en-IO', NULL, NULL),
(31, 'British Virgin Islands', '18.420695', '-64.639968', 'VG', 'VGB', '1-284', 'America/Port_of_Spain', 'en-VG', NULL, NULL),
(32, 'Brunei', '4.535277', '114.727669', 'BN', 'BRN', '673', 'Asia/Brunei', 'ms-BN,en-BN', NULL, NULL),
(33, 'Bulgaria', '42.733883', '25.48583', 'BG', 'BGR', '359', 'Europe/Sofia', 'bg,tr-BG', NULL, NULL),
(34, 'Burkina Faso', '12.238333', '-1.561593', 'BF', 'BFA', '226', 'Africa/Abidjan', 'fr-BF', NULL, NULL),
(35, 'Burundi', '-3.373056', '29.918886', 'BI', 'BDI', '257', 'Africa/Maputo', 'fr-BI,rn', NULL, NULL),
(36, 'Cambodia', '12.565679', '104.990963', 'KH', 'KHM', '855', 'Asia/Phnom_Penh', 'km,fr,en', NULL, NULL),
(37, 'Cameroon', '7.369722', '12.354722', 'CM', 'CMR', '237', 'Africa/Lagos', 'en-CM,fr-CM', NULL, NULL),
(38, 'Canada', '56.130366', '-106.346771', 'CA', 'CAN', '1', 'America/Toronto', 'en-CA,fr-CA,iu', NULL, NULL),
(39, 'Cape Verde', '16.002082', '-24.013197', 'CV', 'CPV', '238', 'Atlantic/Cape_Verde', 'pt-CV', NULL, NULL),
(40, 'Cayman Islands', '19.513469', '-80.566956', 'KY', 'CYM', '1-345', 'America/Cayman', 'en-KY', NULL, NULL),
(41, 'Central African Republic', '6.611111', '20.939444', 'CF', 'CAF', '236', 'Africa/Lagos', 'fr-CF,sg,ln,kg', NULL, NULL),
(42, 'Chad', '15.454166', '18.732207', 'TD', 'TCD', '235', 'Africa/Ndjamena', 'fr-TD,ar-TD,sre', NULL, NULL),
(43, 'Chile', '-35.675147', '-71.542969', 'CL', 'CHL', '56', 'America/Santiago', 'es-CL', NULL, NULL),
(44, 'China', '35.86166', '104.195397', 'CN', 'CHN', '86', 'Asia/Shanghai', 'zh-CN,yue,wuu,dta,ug,za', NULL, NULL),
(45, 'Christmas Island', '-10.447525', '105.690449', 'CX', 'CXR', '61', 'Indian/Christmas', 'en,zh,ms-CC', NULL, NULL),
(46, 'Cocos Islands', '-12.164165', '96.870956', 'CC', 'CCK', '61', 'Indian/Cocos', 'ms-CC,en', NULL, NULL),
(47, 'Colombia', '4.570868', '-74.297333', 'CO', 'COL', '57', 'America/Bogota', 'es-CO', NULL, NULL),
(48, 'Comoros', '-11.875001', '43.872219', 'KM', 'COM', '269', 'Indian/Comoro', 'ar,fr-KM', NULL, NULL),
(49, 'Cook Islands', '-21.236736', '-159.777671', 'CK', 'COK', '682', 'Pacific/Rarotonga', 'en-CK,mi', NULL, NULL),
(50, 'Costa Rica', '9.748917', '-83.753428', 'CR', 'CRI', '506', 'America/Costa_Rica', 'es-CR,en', NULL, NULL),
(51, 'Croatia', '45.1', '15.2', 'HR', 'HRV', '385', 'Europe/Belgrade', 'hr-HR,sr', NULL, NULL),
(52, 'Cuba', '21.521757', '-77.781167', 'CU', 'CUB', '53', 'America/Havana', 'es-CU', NULL, NULL),
(53, 'Curacao', '12.16957', '-68.990021', 'CW', 'CUW', '599', 'America/Curacao', 'nl,pap', NULL, NULL),
(54, 'Cyprus', '35.126413', '33.429859', 'CY', 'CYP', '357', 'Asia/Nicosia', 'el-CY,tr-CY,en', NULL, NULL),
(55, 'Czech Republic', '49.817492', '15.472962', 'CZ', 'CZE', '420', 'Europe/Prague', 'cs,sk', NULL, NULL),
(56, 'Democratic Republic of the Congo', '-4.038333', '21.758664', 'CD', 'COD', '243', 'Africa/Lagos', 'fr-CD,ln,kg', NULL, NULL),
(57, 'Denmark', '56.26392', '9.501785', 'DK', 'DNK', '45', 'Europe/Copenhagen', 'da-DK,en,fo,de-DK', NULL, NULL),
(58, 'Djibouti', '11.825138', '42.590275', 'DJ', 'DJI', '253', 'Africa/Djibouti', 'fr-DJ,ar,so-DJ,aa', NULL, NULL),
(59, 'Dominica', '15.414999', '-61.370976', 'DM', 'DMA', '1-767', 'America/Port_of_Spain', 'en-DM', NULL, NULL),
(60, 'Dominican Republic', '18.735693', '-70.162651', 'DO', 'DOM', '1-809, 1-829, 1-849', 'America/Santo_Domingo', 'es-DO', NULL, NULL),
(61, 'East Timor', '-8.874217', '125.727539', 'TL', 'TLS', '670', 'Asia/Dili', 'tet,pt-TL,id,en', NULL, NULL),
(62, 'Ecuador', '-1.831239', '-78.183406', 'EC', 'ECU', '593', 'America/Guayaquil', 'es-EC', NULL, NULL),
(63, 'Egypt', '26.820553', '30.802498', 'EG', 'EGY', '20', 'Africa/Cairo', 'ar-EG,en,fr', NULL, NULL),
(64, 'El Salvador', '13.794185', '-88.89653', 'SV', 'SLV', '503', 'America/El_Salvador', 'es-SV', NULL, NULL),
(65, 'Equatorial Guinea', '1.650801', '10.267895', 'GQ', 'GNQ', '240', 'Africa/Lagos', 'es-GQ,fr', NULL, NULL),
(66, 'Eritrea', '15.179384', '39.782334', 'ER', 'ERI', '291', 'Africa/Asmara', 'aa-ER,ar,tig,kun,ti-ER', NULL, NULL),
(67, 'Estonia', '58.595272', '25.013607', 'EE', 'EST', '372', 'Europe/Tallinn', 'et,ru', NULL, NULL),
(68, 'Ethiopia', '9.145', '40.489673', 'ET', 'ETH', '251', 'Africa/Addis_Ababa', 'am,en-ET,om-ET,ti-ET,so-ET,sid', NULL, NULL),
(69, 'Falkland Islands', '-51.796253', '-59.523613', 'FK', 'FLK', '500', 'Atlantic/Stanley', 'en-FK', NULL, NULL),
(70, 'Faroe Islands', '61.892635', '-6.911806', 'FO', 'FRO', '298', 'Atlantic/Faroe', 'fo,da-FO', NULL, NULL),
(71, 'Fiji', '-16.578193', '179.414413', 'FJ', 'FJI', '679', 'Pacific/Fiji', 'en-FJ,fj', NULL, NULL),
(72, 'Finland', '61.92411', '25.748151', 'FI', 'FIN', '358', 'Europe/Helsinki', 'fi-FI,sv-FI,smn', NULL, NULL),
(73, 'France', '46.227638', '2.213749', 'FR', 'FRA', '33', 'Europe/Paris', 'fr-FR,frp,br,co,ca,eu,oc', NULL, NULL),
(74, 'French Polynesia', '-17.679742', '-149.406843', 'PF', 'PYF', '689', 'Pacific/Tahiti', 'fr-PF,ty', NULL, NULL),
(75, 'Gabon', '-0.803689', '11.609444', 'GA', 'GAB', '241', 'Africa/Lagos', 'fr-GA', NULL, NULL),
(76, 'Gambia', '13.443182', '-15.310139', 'GM', 'GMB', '220', 'Africa/Abidjan', 'en-GM,mnk,wof,wo,ff', NULL, NULL),
(77, 'Georgia', '42.315407', '43.356892', 'GE', 'GEO', '995', 'Asia/Tbilisi', 'ka,ru,hy,az', NULL, NULL),
(78, 'Germany', '51.165691', '10.451526', 'DE', 'DEU', '49', 'Europe/Berlin', 'de', NULL, NULL),
(79, 'Ghana', '7.946527', '-1.023194', 'GH', 'GHA', '233', 'Africa/Accra', 'en-GH,ak,ee,tw', NULL, NULL),
(80, 'Gibraltar', '36.137741', '-5.345374', 'GI', 'GIB', '350', 'Europe/Gibraltar', 'en-GI,es,it,pt', NULL, NULL),
(81, 'Greece', '39.074208', '21.824312', 'GR', 'GRC', '30', 'Europe/Athens', 'el-GR,en,fr', NULL, NULL),
(82, 'Greenland', '71.706936', '-42.604303', 'GL', 'GRL', '299', 'America/Godthab', 'kl,da-GL,en', NULL, NULL),
(83, 'Grenada', '12.262776', '-61.604171', 'GD', 'GRD', '1-473', 'America/Port_of_Spain', 'en-GD', NULL, NULL),
(84, 'Guam', '13.444304', '144.793731', 'GU', 'GUM', '1-671', 'Pacific/Guam', 'en-GU,ch-GU', NULL, NULL),
(85, 'Guatemala', '15.783471', '-90.230759', 'GT', 'GTM', '502', 'America/Guatemala', 'es-GT', NULL, NULL),
(86, 'Guernsey', '49.465691', '-2.585278', 'GG', 'GGY', '44-1481', 'Europe/London', 'en,fr', NULL, NULL),
(87, 'Guinea', '9.945587', '-9.696645', 'GN', 'GIN', '224', 'Africa/Abidjan', 'fr-GN', NULL, NULL),
(88, 'Guinea-Bissau', '11.803749', '-15.180413', 'GW', 'GNB', '245', 'Africa/Bissau', 'pt-GW,pov', NULL, NULL),
(89, 'Guyana', '4.860416', '-58.93018', 'GY', 'GUY', '592', 'America/Guyana', 'en-GY', NULL, NULL),
(90, 'Haiti', '18.971187', '-72.285215', 'HT', 'HTI', '509', 'America/Port-au-Prince', 'ht,fr-HT', NULL, NULL),
(91, 'Honduras', '15.199999', '-86.241905', 'HN', 'HND', '504', 'America/Tegucigalpa', 'es-HN', NULL, NULL),
(92, 'Hong Kong', '22.396428', '114.109497', 'HK', 'HKG', '852', 'Asia/Hong_Kong', 'zh-HK,yue,zh,en', NULL, NULL),
(93, 'Hungary', '47.162494', '19.503304', 'HU', 'HUN', '36', 'Europe/Budapest', 'hu-HU', NULL, NULL),
(94, 'Iceland', '64.963051', '-19.020835', 'IS', 'ISL', '354', 'Atlantic/Reykjavik', 'is,en,de,da,sv,no', NULL, NULL),
(95, 'India', '20.593684', '78.96288', 'IN', 'IND', '91', 'Asia/Kolkata', 'en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc', NULL, NULL),
(96, 'Indonesia', '-0.789275', '113.921327', 'ID', 'IDN', '62', 'Asia/Jakarta', 'id,en,nl,jv', NULL, NULL),
(97, 'Iran', '32.427908', '53.688046', 'IR', 'IRN', '98', 'Asia/Tehran', 'fa-IR,ku', NULL, NULL),
(98, 'Iraq', '33.223191', '43.679291', 'IQ', 'IRQ', '964', 'Asia/Baghdad', 'ar-IQ,ku,hy', NULL, NULL),
(99, 'Ireland', '53.41291', '-8.24389', 'IE', 'IRL', '353', 'Europe/Dublin', 'en-IE,ga-IE', NULL, NULL),
(100, 'Isle of Man', '54.236107', '-4.548056', 'IM', 'IMN', '44-1624', 'Europe/London', 'en,gv', NULL, NULL),
(101, 'Israel', '31.046051', '34.851612', 'IL', 'ISR', '972', 'Asia/Jerusalem', 'he,ar-IL,en-IL,', NULL, NULL),
(102, 'Italy', '41.87194', '12.56738', 'IT', 'ITA', '39', 'Europe/Rome', 'it-IT,de-IT,fr-IT,sc,ca,co,sl', NULL, NULL),
(103, 'Ivory Coast', '7.539989', '-5.54708', 'CI', 'CIV', '225', 'Africa/Abidjan', 'fr-CI', NULL, NULL),
(104, 'Jamaica', '18.109581', '-77.297508', 'JM', 'JAM', '1-876', 'America/Jamaica', 'en-JM', NULL, NULL),
(105, 'Japan', '36.204824', '138.252924', 'JP', 'JPN', '81', 'Asia/Tokyo', 'ja', NULL, NULL),
(106, 'Jersey', '49.214439', '-2.13125', 'JE', 'JEY', '44-1534', 'Europe/London', 'en,pt', NULL, NULL),
(107, 'Jordan', '30.585164', '36.238414', 'JO', 'JOR', '962', 'Asia/Amman', 'ar-JO,en', NULL, NULL),
(108, 'Kazakhstan', '48.019573', '66.923684', 'KZ', 'KAZ', '7', 'Asia/Almaty', 'kk,ru', NULL, NULL),
(109, 'Kenya', '-0.023559', '37.906193', 'KE', 'KEN', '254', 'Africa/Nairobi', 'en-KE,sw-KE', NULL, NULL),
(110, 'Kiribati', '-3.370417', '-168.734039', 'KI', 'KIR', '686', 'Pacific/Tarawa', 'en-KI,gil', NULL, NULL),
(111, 'Kosovo', '42.602636', '20.902977', 'XK', 'XKX', '383', 'Europe/Belgrade', 'sq,sr', NULL, NULL),
(112, 'Kuwait', '29.31166', '47.481766', 'KW', 'KWT', '965', 'Asia/Kuwait', 'ar-KW,en', NULL, NULL),
(113, 'Kyrgyzstan', '41.20438', '74.766098', 'KG', 'KGZ', '996', 'Asia/Bishkek', 'ky,uz,ru', NULL, NULL),
(114, 'Laos', '19.85627', '102.495496', 'LA', 'LAO', '856', 'Asia/Vientiane', 'lo,fr,en', NULL, NULL),
(115, 'Latvia', '56.879635', '24.603189', 'LV', 'LVA', '371', 'Europe/Riga', 'lv,ru,lt', NULL, NULL),
(116, 'Lebanon', '33.854721', '35.862285', 'LB', 'LBN', '961', 'Asia/Beirut', 'ar-LB,fr-LB,en,hy', NULL, NULL),
(117, 'Lesotho', '-29.609988', '28.233608', 'LS', 'LSO', '266', 'Africa/Johannesburg', 'en-LS,st,zu,xh', NULL, NULL),
(118, 'Liberia', '6.428055', '-9.429499', 'LR', 'LBR', '231', 'Africa/Monrovia', 'en-LR', NULL, NULL),
(119, 'Libya', '26.3351', '17.228331', 'LY', 'LBY', '218', 'Africa/Tripoli', 'ar-LY,it,en', NULL, NULL),
(120, 'Liechtenstein', '47.166', '9.555373', 'LI', 'LIE', '423', 'Europe/Zurich', 'de-LI', NULL, NULL),
(121, 'Lithuania', '55.169438', '23.881275', 'LT', 'LTU', '370', 'Europe/Vilnius', 'lt,ru,pl', NULL, NULL),
(122, 'Luxembourg', '49.815273', '6.129583', 'LU', 'LUX', '352', 'Europe/Luxembourg', 'lb,de-LU,fr-LU', NULL, NULL),
(123, 'Macau', '22.198745', '113.543873', 'MO', 'MAC', '853', 'Asia/Macau', 'zh,zh-MO,pt', NULL, NULL),
(124, 'Macedonia', '41.608635', '21.745275', 'MK', 'MKD', '389', 'Europe/Belgrade', 'mk,sq,tr,rmm,sr', NULL, NULL),
(125, 'Madagascar', '-18.766947', '46.869107', 'MG', 'MDG', '261', 'Indian/Antananarivo', 'fr-MG,mg', NULL, NULL),
(126, 'Malawi', '-13.254308', '34.301525', 'MW', 'MWI', '265', 'Africa/Maputo', 'ny,yao,tum,swk', NULL, NULL),
(127, 'Malaysia', '4.210484', '101.975766', 'MY', 'MYS', '60', 'Asia/Kuala_Lumpur', 'ms-MY,en,zh,ta,te,ml,pa,th', NULL, NULL),
(128, 'Maldives', '3.202778', '73.22068', 'MV', 'MDV', '960', 'Indian/Maldives', 'dv,en', NULL, NULL),
(129, 'Mali', '17.570692', '-3.996166', 'ML', 'MLI', '223', 'Africa/Abidjan', 'fr-ML,bm', NULL, NULL),
(130, 'Malta', '35.937496', '14.375416', 'MT', 'MLT', '356', 'Europe/Malta', 'mt,en-MT', NULL, NULL),
(131, 'Marshall Islands', '7.131474', '171.184478', 'MH', 'MHL', '692', 'Pacific/Majuro', 'mh,en-MH', NULL, NULL),
(132, 'Mauritania', '21.00789', '-10.940835', 'MR', 'MRT', '222', 'Africa/Abidjan', 'ar-MR,fuc,snk,fr,mey,wo', NULL, NULL),
(133, 'Mauritius', '-20.348404', '57.552152', 'MU', 'MUS', '230', 'Indian/Mauritius', 'en-MU,bho,fr', NULL, NULL),
(134, 'Mayotte', '-12.8275', '45.166244', 'YT', 'MYT', '262', 'Indian/Mayotte', 'fr-YT', NULL, NULL),
(135, 'Mexico', '23.634501', '-102.552784', 'MX', 'MEX', '52', 'America/Mexico_City', 'es-MX', NULL, NULL),
(136, 'Micronesia', '7.425554', '150.550812', 'FM', 'FSM', '691', 'Pacific/Pohnpei', 'en-FM,chk,pon,yap,kos,uli,woe,nkr,kpg', NULL, NULL),
(137, 'Moldova', '47.411631', '28.369885', 'MD', 'MDA', '373', 'Europe/Chisinau', 'ro,ru,gag,tr', NULL, NULL),
(138, 'Monaco', '43.750298', '7.412841', 'MC', 'MCO', '377', 'Europe/Monaco', 'fr-MC,en,it', NULL, NULL),
(139, 'Mongolia', '46.862496', '103.846656', 'MN', 'MNG', '976', 'Asia/Ulaanbaatar', 'mn,ru', NULL, NULL),
(140, 'Montenegro', '42.708678', '19.37439', 'ME', 'MNE', '382', 'Europe/Belgrade', 'sr,hu,bs,sq,hr,rom', NULL, NULL),
(141, 'Montserrat', '16.742498', '-62.187366', 'MS', 'MSR', '1-664', 'America/Port_of_Spain', 'en-MS', NULL, NULL),
(142, 'Morocco', '31.791702', '-7.09262', 'MA', 'MAR', '212', 'Africa/Casablanca', 'ar-MA,fr', NULL, NULL),
(143, 'Mozambique', '-18.665695', '35.529562', 'MZ', 'MOZ', '258', 'Africa/Maputo', 'pt-MZ,vmw', NULL, NULL),
(144, 'Myanmar', '21.913965', '95.956223', 'MM', 'MMR', '95', 'Asia/Rangoon', 'my', NULL, NULL),
(145, 'Namibia', '-22.95764', '18.49041', 'NA', 'NAM', '264', 'Africa/Windhoek', 'en-NA,af,de,hz,naq', NULL, NULL),
(146, 'Nauru', '-0.522778', '166.931503', 'NR', 'NRU', '674', 'Pacific/Nauru', 'na,en-NR', NULL, NULL),
(147, 'Nepal', '28.394857', '84.124008', 'NP', 'NPL', '977', 'Asia/Kathmandu', 'ne,en', NULL, NULL),
(148, 'Netherlands', '52.132633', '5.291266', 'NL', 'NLD', '31', 'Europe/Amsterdam', 'nl-NL,fy-NL', NULL, NULL),
(149, 'Netherlands Antilles', '12.226079', '-69.060087', 'AN', 'ANT', '599', 'America/Curacao', 'nl-AN,en,es', NULL, NULL),
(150, 'New Caledonia', '-20.904305', '165.618042', 'NC', 'NCL', '687', 'Pacific/Noumea', 'fr-NC', NULL, NULL),
(151, 'New Zealand', '-40.900557', '174.885971', 'NZ', 'NZL', '64', 'Pacific/Auckland', 'en-NZ,mi', NULL, NULL),
(152, 'Nicaragua', '12.865416', '-85.207229', 'NI', 'NIC', '505', 'America/Managua', 'es-NI,en', NULL, NULL),
(153, 'Niger', '17.607789', '8.081666', 'NE', 'NER', '227', 'Africa/Lagos', 'fr-NE,ha,kr,dje', NULL, NULL),
(154, 'Nigeria', '9.081999', '8.675277', 'NG', 'NGA', '234', 'Africa/Lagos', 'en-NG,ha,yo,ig,ff', NULL, NULL),
(155, 'Niue', '-19.054445', '-169.867233', 'NU', 'NIU', '683', 'Pacific/Niue', 'niu,en-NU', NULL, NULL),
(156, 'North Korea', '40.339852', '127.510093', 'KP', 'PRK', '850', 'Asia/Pyongyang', 'ko-KP', NULL, NULL),
(157, 'Northern Mariana Islands', '17.33083', '145.38469', 'MP', 'MNP', '1-670', 'Pacific/Saipan', 'fil,tl,zh,ch-MP,en-MP', NULL, NULL),
(158, 'Norway', '60.472024', '8.468946', 'NO', 'NOR', '47', 'Europe/Oslo', 'no,nb,nn,se,fi', NULL, NULL),
(159, 'Oman', '21.512583', '55.923255', 'OM', 'OMN', '968', 'Asia/Muscat', 'ar-OM,en,bal,ur', NULL, NULL),
(160, 'Pakistan', '30.375321', '69.345116', 'PK', 'PAK', '92', 'Asia/Karachi', 'ur-PK,en-PK,pa,sd,ps,brh', NULL, NULL),
(161, 'Palau', '7.51498', '134.58252', 'PW', 'PLW', '680', 'Pacific/Palau', 'pau,sov,en-PW,tox,ja,fil,zh', NULL, NULL),
(162, 'Palestine', '31.952162', '35.233154', 'PS', 'PSE', '970', 'Asia/Hebron', 'ar-PS', NULL, NULL),
(163, 'Panama', '8.537981', '-80.782127', 'PA', 'PAN', '507', 'America/Panama', 'es-PA,en', NULL, NULL),
(164, 'Papua New Guinea', '-6.314993', '143.95555', 'PG', 'PNG', '675', 'Pacific/Port_Moresby', 'en-PG,ho,meu,tpi', NULL, NULL),
(165, 'Paraguay', '-23.442503', '-58.443832', 'PY', 'PRY', '595', 'America/Asuncion', 'es-PY,gn', NULL, NULL),
(166, 'Peru', '-9.189967', '-75.015152', 'PE', 'PER', '51', 'America/Lima', 'es-PE,qu,ay', NULL, NULL),
(167, 'Philippines', '12.879721', '121.774017', 'PH', 'PHL', '63', 'Asia/Manila', 'tl,en-PH,fil', NULL, NULL),
(168, 'Pitcairn', '-24.703615', '-127.439308', 'PN', 'PCN', '64', 'Pacific/Pitcairn', 'en-PN', NULL, NULL),
(169, 'Poland', '51.919438', '19.145136', 'PL', 'POL', '48', 'Europe/Warsaw', 'pl', NULL, NULL),
(170, 'Portugal', '39.399872', '-8.224454', 'PT', 'PRT', '351', 'Europe/Lisbon', 'pt-PT,mwl', NULL, NULL),
(171, 'Puerto Rico', '18.220833', '-66.590149', 'PR', 'PRI', '1-787, 1-939', 'America/Puerto_Rico', 'en-PR,es-PR', NULL, NULL),
(172, 'Qatar', '25.354826', '51.183884', 'QA', 'QAT', '974', 'Asia/Qatar', 'ar-QA,es', NULL, NULL),
(173, 'Republic of the Congo', '-0.228021', '15.827659', 'CG', 'COG', '242', 'Africa/Lagos', 'fr-CG,kg,ln-CG', NULL, NULL),
(174, 'Reunion', '-21.115141', '55.536384', 'RE', 'REU', '262', 'Indian/Reunion', 'fr-RE', NULL, NULL),
(175, 'Romania', '45.943161', '24.96676', 'RO', 'ROU', '40', 'Europe/Bucharest', 'ro,hu,rom', NULL, NULL),
(176, 'Russia', '61.52401', '105.318756', 'RU', 'RUS', '7', 'Europe/Moscow', 'ru,tt,xal,cau,ady,kv,ce,tyv,cv,udm,tut,mns,bua,myv,mdf,chm,ba,inh,tut,kbd,krc,ava,sah,nog', NULL, NULL),
(177, 'Rwanda', '-1.940278', '29.873888', 'RW', 'RWA', '250', 'Africa/Maputo', 'rw,en-RW,fr-RW,sw', NULL, NULL),
(178, 'Saint Barthelemy', '', '', 'BL', 'BLM', '590', 'America/Port_of_Spain', 'fr', NULL, NULL),
(179, 'Saint Helena', '-24.143474', '-10.030696', 'SH', 'SHN', '290', 'Africa/Abidjan', 'en-SH', NULL, NULL),
(180, 'Saint Kitts and Nevis', '17.357822', '-62.782998', 'KN', 'KNA', '1-869', 'America/Port_of_Spain', 'en-KN', NULL, NULL),
(181, 'Saint Lucia', '13.909444', '-60.978893', 'LC', 'LCA', '1-758', 'America/Port_of_Spain', 'en-LC', NULL, NULL),
(182, 'Saint Martin', '', '', 'MF', 'MAF', '590', 'America/Port_of_Spain', 'fr', NULL, NULL),
(183, 'Saint Pierre and Miquelon', '46.941936', '-56.27111', 'PM', 'SPM', '508', 'America/Miquelon', 'fr-PM', NULL, NULL),
(184, 'Saint Vincent and the Grenadines', '12.984305', '-61.287228', 'VC', 'VCT', '1-784', 'America/Port_of_Spain', 'en-VC,fr', NULL, NULL),
(185, 'Samoa', '-13.759029', '-172.104629', 'WS', 'WSM', '685', 'Pacific/Apia', 'sm,en-WS', NULL, NULL),
(186, 'San Marino', '43.94236', '12.457777', 'SM', 'SMR', '378', 'Europe/Rome', 'it-SM', NULL, NULL),
(187, 'Sao Tome and Principe', '0.18636', '6.613081', 'ST', 'STP', '239', 'Africa/Abidjan', 'pt-ST', NULL, NULL),
(188, 'Saudi Arabia', '23.885942', '45.079162', 'SA', 'SAU', '966', 'Asia/Riyadh', 'ar-SA', NULL, NULL),
(189, 'Senegal', '14.497401', '-14.452362', 'SN', 'SEN', '221', 'Africa/Abidjan', 'fr-SN,wo,fuc,mnk', NULL, NULL),
(190, 'Serbia', '44.016521', '21.005859', 'RS', 'SRB', '381', 'Europe/Belgrade', 'sr,hu,bs,rom', NULL, NULL),
(191, 'Seychelles', '-4.679574', '55.491977', 'SC', 'SYC', '248', 'Indian/Mahe', 'en-SC,fr-SC', NULL, NULL),
(192, 'Sierra Leone', '8.460555', '-11.779889', 'SL', 'SLE', '232', 'Africa/Abidjan', 'en-SL,men,tem', NULL, NULL),
(193, 'Singapore', '1.352083', '103.819836', 'SG', 'SGP', '65', 'Asia/Singapore', 'cmn,en-SG,ms-SG,ta-SG,zh-SG', NULL, NULL),
(194, 'Sint Maarten', '18.075277', '-63.060001', 'SX', 'SXM', '1-721', 'America/Curacao', 'nl,en', NULL, NULL),
(195, 'Slovakia', '48.669026', '19.699024', 'SK', 'SVK', '421', 'Europe/Prague', 'sk,hu', NULL, NULL),
(196, 'Slovenia', '46.151241', '14.995463', 'SI', 'SVN', '386', 'Europe/Belgrade', 'sl,sh', NULL, NULL),
(197, 'Solomon Islands', '-9.64571', '160.156194', 'SB', 'SLB', '677', 'Pacific/Guadalcanal', 'en-SB,tpi', NULL, NULL),
(198, 'Somalia', '5.152149', '46.199616', 'SO', 'SOM', '252', 'Africa/Mogadishu', 'so-SO,ar-SO,it,en-SO', NULL, NULL),
(199, 'South Africa', '-30.559482', '22.937506', 'ZA', 'ZAF', '27', 'Africa/Johannesburg', 'zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr', NULL, NULL),
(200, 'South Korea', '35.907757', '127.766922', 'KR', 'KOR', '82', 'Asia/Seoul', 'ko-KR,en', NULL, NULL),
(201, 'South Sudan', '', '', 'SS', 'SSD', '211', 'Africa/Khartoum', 'en', NULL, NULL),
(202, 'Spain', '40.463667', '-3.74922', 'ES', 'ESP', '34', 'Europe/Madrid', 'es-ES,ca,gl,eu,oc', NULL, NULL),
(203, 'Sri Lanka', '7.873054', '80.771797', 'LK', 'LKA', '94', 'Asia/Colombo', 'si,ta,en', NULL, NULL),
(204, 'Sudan', '12.862807', '30.217636', 'SD', 'SDN', '249', 'Africa/Khartoum', 'ar-SD,en,fia', NULL, NULL),
(205, 'Suriname', '3.919305', '-56.027783', 'SR', 'SUR', '597', 'America/Paramaribo', 'nl-SR,en,srn,hns,jv', NULL, NULL),
(206, 'Svalbard and Jan Mayen', '77.553604', '23.670272', 'SJ', 'SJM', '47', 'Europe/Oslo', 'no,ru', NULL, NULL),
(207, 'Swaziland', '-26.522503', '31.465866', 'SZ', 'SWZ', '268', 'Africa/Johannesburg', 'en-SZ,ss-SZ', NULL, NULL),
(208, 'Sweden', '60.128161', '18.643501', 'SE', 'SWE', '46', 'Europe/Stockholm', 'sv-SE,se,sma,fi-SE', NULL, NULL),
(209, 'Switzerland', '46.818188', '8.227512', 'CH', 'CHE', '41', 'Europe/Zurich', 'de-CH,fr-CH,it-CH,rm', NULL, NULL),
(210, 'Syria', '34.802075', '38.996815', 'SY', 'SYR', '963', 'Asia/Damascus', 'ar-SY,ku,hy,arc,fr,en', NULL, NULL),
(211, 'Taiwan', '23.69781', '120.960515', 'TW', 'TWN', '886', 'Asia/Taipei', 'zh-TW,zh,nan,hak', NULL, NULL),
(212, 'Tajikistan', '38.861034', '71.276093', 'TJ', 'TJK', '992', 'Asia/Dushanbe', 'tg,ru', NULL, NULL),
(213, 'Tanzania', '-6.369028', '34.888822', 'TZ', 'TZA', '255', 'Africa/Dar_es_Salaam', 'sw-TZ,en,ar', NULL, NULL),
(214, 'Thailand', '15.870032', '100.992541', 'TH', 'THA', '66', 'Asia/Bangkok', 'th,en', NULL, NULL),
(215, 'Togo', '8.619543', '0.824782', 'TG', 'TGO', '228', 'Africa/Abidjan', 'fr-TG,ee,hna,kbp,dag,ha', NULL, NULL),
(216, 'Tokelau', '-8.967363', '-171.855881', 'TK', 'TKL', '690', 'Pacific/Fakaofo', 'tkl,en-TK', NULL, NULL),
(217, 'Tonga', '-21.178986', '-175.198242', 'TO', 'TON', '676', 'Pacific/Tongatapu', 'to,en-TO', NULL, NULL),
(218, 'Trinidad and Tobago', '10.691803', '-61.222503', 'TT', 'TTO', '1-868', 'America/Port_of_Spain', 'en-TT,hns,fr,es,zh', NULL, NULL),
(219, 'Tunisia', '33.886917', '9.537499', 'TN', 'TUN', '216', 'Africa/Tunis', 'ar-TN,fr', NULL, NULL),
(220, 'Turkey', '38.963745', '35.243322', 'TR', 'TUR', '90', 'Europe/Istanbul', 'tr-TR,ku,diq,az,av', NULL, NULL),
(221, 'Turkmenistan', '38.969719', '59.556278', 'TM', 'TKM', '993', 'Asia/Ashgabat', 'tk,ru,uz', NULL, NULL),
(222, 'Turks and Caicos Islands', '21.694025', '-71.797928', 'TC', 'TCA', '1-649', 'America/Grand_Turk', 'en-TC', NULL, NULL),
(223, 'Tuvalu', '-7.109535', '177.64933', 'TV', 'TUV', '688', 'Pacific/Funafuti', 'tvl,en,sm,gil', NULL, NULL),
(224, 'U.S. Virgin Islands', '18.335765', '-64.896335', 'VI', 'VIR', '1-340', 'America/Port_of_Spain', 'en-VI', NULL, NULL),
(225, 'Uganda', '1.373333', '32.290275', 'UG', 'UGA', '256', 'Africa/Kampala', 'en-UG,lg,sw,ar', NULL, NULL),
(226, 'Ukraine', '48.379433', '31.16558', 'UA', 'UKR', '380', 'Europe/Kiev', 'uk,ru-UA,rom,pl,hu', NULL, NULL),
(227, 'United Arab Emirates', '23.424076', '53.847818', 'AE', 'ARE', '971', 'Asia/Dubai', 'ar-AE,fa,en,hi,ur', NULL, NULL),
(228, 'United Kingdom', '55.378051', '-3.435973', 'GB', 'GBR', '44', 'Europe/London', 'en-GB,cy-GB,gd', NULL, NULL),
(229, 'United States', '37.09024', '-95.712891', 'US', 'USA', '1', 'America/New_York', 'en-US,es-US,haw,fr', NULL, NULL),
(230, 'Uruguay', '-32.522779', '-55.765835', 'UY', 'URY', '598', 'America/Montevideo', 'es-UY', NULL, NULL),
(231, 'Uzbekistan', '41.377491', '64.585262', 'UZ', 'UZB', '998', 'Asia/Tashkent', 'uz,ru,tg', NULL, NULL),
(232, 'Vanuatu', '-15.376706', '166.959158', 'VU', 'VUT', '678', 'Pacific/Efate', 'bi,en-VU,fr-VU', NULL, NULL),
(233, 'Vatican', '41.902916', '12.453389', 'VA', 'VAT', '379', 'Europe/Rome', 'la,it,fr', NULL, NULL),
(234, 'Venezuela', '6.42375', '-66.58973', 'VE', 'VEN', '58', 'America/Caracas', 'es-VE', NULL, NULL),
(235, 'Vietnam', '14.058324', '108.277199', 'VN', 'VNM', '84', 'Asia/Ho_Chi_Minh', 'vi,en,fr,zh,km', NULL, NULL),
(236, 'Wallis and Futuna', '-13.768752', '-177.156097', 'WF', 'WLF', '681', 'Pacific/Wallis', 'wls,fud,fr-WF', NULL, NULL),
(237, 'Western Sahara', '24.215527', '-12.885834', 'EH', 'ESH', '212', 'Africa/El_Aaiun', 'ar,mey', NULL, NULL),
(238, 'Yemen', '15.552727', '48.516388', 'YE', 'YEM', '967', 'Asia/Aden', 'ar-YE', NULL, NULL),
(239, 'Zambia', '-13.133897', '27.849332', 'ZM', 'ZMB', '260', 'Africa/Maputo', 'en-ZM,bem,loz,lun,lue,ny,toi', NULL, NULL),
(240, 'Zimbabwe', '-19.015438', '29.154857', 'ZW', 'ZWE', '263', 'Africa/Maputo', 'en-ZW,sn,nr,nd', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `custom_contacts_fields`
--

CREATE TABLE `custom_contacts_fields` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_contacts_fields_contacts`
--

CREATE TABLE `custom_contacts_fields_contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `contact_id` bigint UNSIGNED NOT NULL,
  `custom_contacts_field_id` bigint UNSIGNED NOT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `flows`
--

CREATE TABLE `flows` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint UNSIGNED NOT NULL,
  `nodes` text COLLATE utf8mb4_unicode_ci,
  `connections` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `groups_contacts`
--

CREATE TABLE `groups_contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `contact_id` bigint UNSIGNED NOT NULL,
  `group_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint UNSIGNED NOT NULL,
  `fb_message_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_id` bigint UNSIGNED NOT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `header_text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `footer_text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `header_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `header_video` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `header_location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `header_document` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `buttons` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `error` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `is_campign_messages` tinyint(1) NOT NULL DEFAULT '0',
  `is_message_by_contact` tinyint(1) NOT NULL DEFAULT '0',
  `message_type` int NOT NULL DEFAULT '1' COMMENT '1 - text, 2-media, 3-location',
  `status` int NOT NULL DEFAULT '1' COMMENT '0-Schuduled, 1-Sending, 2-Sent, 3-Delivered, 4-Read, 5-Failed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `scchuduled_at` timestamp NULL DEFAULT NULL,
  `components` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_id` bigint UNSIGNED DEFAULT NULL,
  `header_audio` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bot_has_replied` tinyint(1) NOT NULL DEFAULT '0',
  `ai_bot_has_replied` tinyint(1) NOT NULL DEFAULT '0',
  `original_message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sender_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2021_02_27_230105_create_plans', 1),
(7, '2021_02_27_232353_create_companies', 1),
(8, '2021_02_27_234032_create_posts', 1),
(9, '2023_02_27_171315_create_sessions_table', 1),
(10, '2023_02_27_225028_create_permission_tables', 1),
(11, '2023_02_27_233806_create_config', 1),
(12, '2023_04_05_191813_add_welcome_valid_until_field_to_users_table', 1),
(13, '2023_07_29_134946_create_contacts_table', 1),
(14, '2023_08_11_122409_create_contact_messages', 1),
(15, '2023_08_17_205139_create_wa_templates_table', 1),
(16, '2023_08_26_044436_create_campaings_table', 1),
(17, '2023_09_07_140918_create_replies_table', 1),
(18, '2023_09_14_193132_update_configs_table', 1),
(19, '2023_10_26_174758_update_contacts_table_with_enable_ai', 1),
(20, '2023_11_11_171841_add_cancel_url_to_users', 1),
(21, '2023_11_23_103106_update_replies_and_messages_table', 1),
(22, '2024_01_17_000000_rename_password_resets_table', 1),
(23, '2024_02_21_210321_update_wa_campaings_table', 1),
(24, '2024_02_26_121412_add_role_staff', 1),
(25, '2024_03_13_192149_update_wa_campaings', 1),
(26, '2024_04_17_071551_update_contacts_with_unsubscribed', 1),
(27, '2024_06_01_173207_create_flows_table', 1),
(28, '2024_06_01_175043_update_replies_table', 1),
(29, '2024_06_13_101719_update_contact_table', 1),
(30, '2024_06_13_142408_add_phone_to_users', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(5, 'App\\Models\\User', 1);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `plan`
--

CREATE TABLE `plan` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `limit_items` int DEFAULT '0' COMMENT '0 is unlimited',
  `limit_orders` int DEFAULT '0' COMMENT '0 is unlimited',
  `price` double(8,2) NOT NULL,
  `period` int NOT NULL DEFAULT '1' COMMENT '1 - monthly, 2-anually',
  `paddle_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(555) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `features` varchar(555) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `limit_views` int NOT NULL DEFAULT '0' COMMENT '0 is unlimited',
  `enable_ordering` int NOT NULL DEFAULT '1',
  `stripe_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paypal_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mollie_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paystack_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `post_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vendor_id` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `created_at`, `updated_at`, `post_type`, `title`, `subtitle`, `description`, `image`, `link`, `link_name`, `vendor_id`) VALUES
(1, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'faq', '{\"en\":\"Can I cancel anytime?\"}', NULL, '{\"en\":\"Yes, you can! We believe in flexibility, and there are no long-term commitments. You can cancel your subscription at any time with no hidden fees or penalties.\"}', NULL, NULL, NULL, NULL),
(2, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'faq', '{\"en\":\"How do I create a marketing campaign?\"}', NULL, '{\"en\":\"Creating a marketing campaign is easy with our platform. We provide a user-friendly interface that allows you to design, target, and launch campaigns effortlessly. If you need assistance, our support team is always here to help.\"}', NULL, NULL, NULL, NULL),
(3, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'faq', '{\"en\":\"Is my data secure?\"}', NULL, '{\"en\":\"Absolutely. We take data security seriously. Our platform employs robust encryption protocols and follows industry best practices to ensure your data remains safe and confidential.\"}', NULL, NULL, NULL, NULL),
(4, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'faq', '{\"en\":\"Can I integrate this with my existing tools?\"}', NULL, '{\"en\":\"Yes, our platform is designed to be compatible with various third-party tools and services. We offer integrations that make it easy to connect with your existing marketing stack for a seamless experience.\"}', NULL, NULL, NULL, NULL),
(5, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"I love using the system\"}', '{\"en\":\"John Doe - CEO of Marketing LTD\"}', '{\"en\":\"This WhatsApp marketing platform has completely transformed how we engage with our customers. It\'s a game-changer for our marketing campaigns, and the direct WhatsApp chat feature has boosted our customer interactions. The platform is user-friendly, and the support team is incredibly responsive. Highly recommend!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/0.png?w=100&h=100', NULL, NULL, NULL),
(6, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Exceptional WhatsApp Marketing\"}', '{\"en\":\"Jane Smith - Marketing Manager\"}', '{\"en\":\"Your WhatsApp marketing platform has been a game-changer for our marketing efforts. The campaigns are highly effective, and the direct chat feature allows us to connect with customers on a personal level. It\'s made a significant impact on our business growth!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/1.png?w=100&h=100', NULL, NULL, NULL),
(7, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Effortless Marketing Campaigns\"}', '{\"en\":\"David Williams - Digital Marketer\"}', '{\"en\":\"Using your WhatsApp marketing platform has made managing campaigns effortless. The results have been outstanding, and the direct WhatsApp chat has improved our customer engagement. The platform\'s simplicity and the support team\'s assistance have been invaluable to our success.\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/2.png?w=100&h=100', NULL, NULL, NULL),
(8, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"A Must-Have for Marketers\"}', '{\"en\":\"Susan Brown - Marketing Director\"}', '{\"en\":\"Your WhatsApp marketing SaaS platform is a must-have for any marketer. It\'s streamlined our marketing efforts, and the direct chat feature has enhanced our customer relationships. The platform is intuitive, and the support team is top-notch. We couldn\'t be happier with the results!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/3.png?w=100&h=100', NULL, NULL, NULL),
(9, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Great Customer Service\"}', '{\"en\":\"Alex Johnson - Customer Service Manager\"}', '{\"en\":\"The customer service from this WhatsApp marketing platform has been exceptional. They\'re always ready to assist and make using the platform a breeze. Highly recommend!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/4.png?w=100&h=100', NULL, NULL, NULL),
(10, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Improved Business Operations\"}', '{\"en\":\"Emily Davis - Business Owner\"}', '{\"en\":\"This WhatsApp marketing platform has improved our business operations significantly. The direct chat feature has made communication with customers so much easier. It\'s a fantastic tool!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/5.png?w=100&h=100', NULL, NULL, NULL),
(11, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Excellent Marketing Tool\"}', '{\"en\":\"Michael Miller - Marketing Specialist\"}', '{\"en\":\"This WhatsApp marketing platform is an excellent tool for any business. It\'s easy to use and has made our marketing campaigns much more effective. The customer service is also top-notch!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/6.png?w=100&h=100', NULL, NULL, NULL),
(12, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Incredible Results\"}', '{\"en\":\"Sarah Thompson - Sales Manager\"}', '{\"en\":\"This WhatsApp marketing platform has delivered incredible results for our sales team. The direct chat feature has significantly improved our customer engagement. The platform is easy to use and the support team is always ready to help. Highly recommend!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/7.png?w=100&h=100', NULL, NULL, NULL),
(13, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'testimonial', '{\"en\":\"Boosted Our Marketing\"}', '{\"en\":\"Robert Anderson - Marketing Executive\"}', '{\"en\":\"Your WhatsApp marketing platform has boosted our marketing efforts. The campaigns are highly effective and the direct chat feature allows us to connect with customers on a personal level. It\'s made a significant impact on our business growth!\"}', 'https://mobidonia-demo.imgix.net/img/testimonials/8.png?w=100&h=100', NULL, NULL, NULL),
(14, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'feature', '{\"en\":\"Email marketing is 🏴‍☠️. Say hi to Whatsapp marketing\"}', NULL, '{\"en\":\"Whatsapp Marketing is a new fields in Direct Marketing. Experience around 98% read rate on your campaigns and never fear your account to get blocked from Whatsapp.\"}', 'https://mobidonia-demo.imgix.net/img/campaign.png', NULL, NULL, NULL),
(15, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'feature', '{\"en\":\"Chat with your contacts\"}', NULL, '{\"en\":\"Here, you will find fully featured chat system, from where you can send docs, images, fast replies, and rich message templates. Offer manual and automated support via the reply bot triggered by the client message.\"}', 'https://mobidonia-demo.imgix.net/img/chat_clear.png', NULL, NULL, NULL),
(16, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'feature', '{\"en\":\"AI Chat 🤖\"}', NULL, '{\"en\":\"Engage with your customers using our AI chat feature. It can handle common queries, provide information, and direct the conversation to a human operator if needed. Improve your customer service with our AI chat.\"}', 'https://mobidonia-demo.imgix.net/img/ai_chat.png', NULL, NULL, NULL),
(17, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'mainfeature', '{\"en\":\"Outbound Campaigns\"}', NULL, '{\"en\":\"Execute your outbound campaigns effectively.\"}', 'https://mobidonia-demo.imgix.net/img/camp.png', NULL, NULL, NULL),
(18, '2025-01-11 05:35:27', '2025-01-11 05:35:27', 'mainfeature', '{\"en\":\"Better Support\"}', NULL, '{\"en\":\"Experience superior customer support.\"}', 'https://mobidonia-demo.imgix.net/img/rating.png', NULL, NULL, NULL),
(19, '2025-01-11 05:35:28', '2025-01-11 05:35:28', 'mainfeature', '{\"en\":\"AI Chat\"}', NULL, '{\"en\":\"Be there 24/7 for your users.\"}', 'https://mobidonia-demo.imgix.net/img/robot.png', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int NOT NULL DEFAULT '1' COMMENT '1- Just a quick reply, 2-on exact match, 3-on contains',
  `trigger` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `used` int NOT NULL DEFAULT '0',
  `header` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `footer` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button1_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button2_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button3` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button3_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `button_url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `flow_id` bigint UNSIGNED DEFAULT NULL,
  `next_reply_id` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(4, 'staff', 'web', NULL, NULL),
(5, 'admin', 'web', '2025-01-11 05:35:22', '2025-01-11 05:35:22'),
(6, 'owner', 'web', '2025-01-11 05:35:22', '2025-01-11 05:35:22'),
(7, 'client', 'web', '2025-01-11 05:35:22', '2025-01-11 05:35:22');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wa_campaings`
--

CREATE TABLE `wa_campaings` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `send_to` int NOT NULL DEFAULT '1',
  `sended_to` int NOT NULL DEFAULT '0',
  `delivered_to` int NOT NULL DEFAULT '0',
  `read_by` int NOT NULL DEFAULT '0',
  `total_contacts` int NOT NULL DEFAULT '0',
  `timestamp_for_delivery` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variables` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `variables_match` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `media_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `template_id` bigint UNSIGNED DEFAULT NULL,
  `group_id` bigint UNSIGNED DEFAULT NULL,
  `contact_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bot_type` int NOT NULL DEFAULT '2' COMMENT '2-on exact match, 3-on contains',
  `trigger` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `used` int NOT NULL DEFAULT '0',
  `is_bot_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Flag to represent if the bot is active or not',
  `is_bot` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Flag to represent if the campaign is for bots',
  `is_api` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Flag to represent if the campaign is for API',
  `is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Flag to represent if the campaign is active or paused'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wa_templates`
--

CREATE TABLE `wa_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `components` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `companies_user_id_index` (`user_id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contacts_country_id_foreign` (`country_id`),
  ADD KEY `contacts_company_id_foreign` (`company_id`),
  ADD KEY `contacts_user_id_foreign` (`user_id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_contacts_fields`
--
ALTER TABLE `custom_contacts_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_contacts_fields_company_id_foreign` (`company_id`);

--
-- Indexes for table `custom_contacts_fields_contacts`
--
ALTER TABLE `custom_contacts_fields_contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_contacts_fields_contacts_contact_id_foreign` (`contact_id`),
  ADD KEY `custom_contacts_fields_contacts_custom_contacts_field_id_foreign` (`custom_contacts_field_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `flows`
--
ALTER TABLE `flows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `flows_company_id_foreign` (`company_id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groups_company_id_foreign` (`company_id`);

--
-- Indexes for table `groups_contacts`
--
ALTER TABLE `groups_contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groups_contacts_contact_id_foreign` (`contact_id`),
  ADD KEY `groups_contacts_group_id_foreign` (`group_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `messages_contact_id_foreign` (`contact_id`),
  ADD KEY `messages_company_id_foreign` (`company_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `plan`
--
ALTER TABLE `plan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `posts_vendor_id_foreign` (`vendor_id`);

--
-- Indexes for table `replies`
--
ALTER TABLE `replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `replies_company_id_foreign` (`company_id`),
  ADD KEY `replies_flow_id_foreign` (`flow_id`),
  ADD KEY `replies_next_reply_id_foreign` (`next_reply_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `wa_campaings`
--
ALTER TABLE `wa_campaings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wa_campaings_company_id_foreign` (`company_id`),
  ADD KEY `wa_campaings_template_id_foreign` (`template_id`),
  ADD KEY `wa_campaings_group_id_foreign` (`group_id`),
  ADD KEY `wa_campaings_contact_id_foreign` (`contact_id`);

--
-- Indexes for table `wa_templates`
--
ALTER TABLE `wa_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wa_templates_company_id_foreign` (`company_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241;

--
-- AUTO_INCREMENT for table `custom_contacts_fields`
--
ALTER TABLE `custom_contacts_fields`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_contacts_fields_contacts`
--
ALTER TABLE `custom_contacts_fields_contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flows`
--
ALTER TABLE `flows`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `groups_contacts`
--
ALTER TABLE `groups_contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plan`
--
ALTER TABLE `plan`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `replies`
--
ALTER TABLE `replies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `wa_campaings`
--
ALTER TABLE `wa_campaings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wa_templates`
--
ALTER TABLE `wa_templates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `contacts`
--
ALTER TABLE `contacts`
  ADD CONSTRAINT `contacts_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  ADD CONSTRAINT `contacts_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `custom_contacts_fields`
--
ALTER TABLE `custom_contacts_fields`
  ADD CONSTRAINT `custom_contacts_fields_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`);

--
-- Constraints for table `custom_contacts_fields_contacts`
--
ALTER TABLE `custom_contacts_fields_contacts`
  ADD CONSTRAINT `custom_contacts_fields_contacts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`),
  ADD CONSTRAINT `custom_contacts_fields_contacts_custom_contacts_field_id_foreign` FOREIGN KEY (`custom_contacts_field_id`) REFERENCES `custom_contacts_fields` (`id`);

--
-- Constraints for table `flows`
--
ALTER TABLE `flows`
  ADD CONSTRAINT `flows_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`);

--
-- Constraints for table `groups`
--
ALTER TABLE `groups`
  ADD CONSTRAINT `groups_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`);

--
-- Constraints for table `groups_contacts`
--
ALTER TABLE `groups_contacts`
  ADD CONSTRAINT `groups_contacts_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`),
  ADD CONSTRAINT `groups_contacts_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`);

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  ADD CONSTRAINT `messages_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`);

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `companies` (`id`);

--
-- Constraints for table `replies`
--
ALTER TABLE `replies`
  ADD CONSTRAINT `replies_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  ADD CONSTRAINT `replies_flow_id_foreign` FOREIGN KEY (`flow_id`) REFERENCES `flows` (`id`),
  ADD CONSTRAINT `replies_next_reply_id_foreign` FOREIGN KEY (`next_reply_id`) REFERENCES `replies` (`id`);

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wa_campaings`
--
ALTER TABLE `wa_campaings`
  ADD CONSTRAINT `wa_campaings_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  ADD CONSTRAINT `wa_campaings_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`),
  ADD CONSTRAINT `wa_campaings_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  ADD CONSTRAINT `wa_campaings_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `wa_templates` (`id`);

--
-- Constraints for table `wa_templates`
--
ALTER TABLE `wa_templates`
  ADD CONSTRAINT `wa_templates_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`);
COMMIT;

