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

START TRANSACTION;



--
-- Database: `iosuiteadmin_abscrm`
--

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

--
-- Table structure for table `tbl_activities`
--

CREATE TABLE `tbl_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `due_date` date NOT NULL,
  `due_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `end_date` date NOT NULL,
  `reminder_minutes_before` int(10) UNSIGNED DEFAULT NULL,
  `reminder_at` datetime DEFAULT NULL,
  `reminded_at` datetime DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Owner',
  `owner_assigned_date` datetime NOT NULL,
  `activity_type_id` bigint(20) UNSIGNED NOT NULL,
  `completed_at` datetime DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED NOT 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;

--
-- Dumping data for table `tbl_activities`
--

INSERT INTO `tbl_activities` (`id`, `title`, `description`, `note`, `due_date`, `due_time`, `end_time`, `end_date`, `reminder_minutes_before`, `reminder_at`, `reminded_at`, `user_id`, `owner_assigned_date`, `activity_type_id`, `completed_at`, `created_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'test', NULL, '<p>TEST</p>', '2023-05-22', '14:00:00', '14:15:00', '2023-05-22', 30, '2023-05-22 13:30:00', NULL, 1, '2023-05-22 13:47:13', 1, NULL, 1, NULL, '2023-05-22 11:47:13', '2023-05-22 11:47:13');

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

--
-- Table structure for table `tbl_activityables`
--

CREATE TABLE `tbl_activityables` (
  `activity_id` bigint(20) UNSIGNED NOT NULL,
  `activityable_type` varchar(191) NOT NULL,
  `activityable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_activity_calendar_sync`
--

CREATE TABLE `tbl_activity_calendar_sync` (
  `activity_id` bigint(20) UNSIGNED NOT NULL,
  `calendar_id` bigint(20) UNSIGNED NOT NULL,
  `event_id` varchar(191) NOT NULL,
  `icaluid` varchar(191) NOT NULL,
  `synchronized_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_activity_guest`
--

CREATE TABLE `tbl_activity_guest` (
  `activity_id` bigint(20) UNSIGNED NOT NULL,
  `guest_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_activity_types`
--

CREATE TABLE `tbl_activity_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `swatch_color` varchar(7) DEFAULT NULL,
  `icon` varchar(50) NOT NULL,
  `flag` varchar(50) DEFAULT 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 `tbl_activity_types`
--

INSERT INTO `tbl_activity_types` (`id`, `name`, `swatch_color`, `icon`, `flag`, `created_at`, `updated_at`) VALUES
(1, 'Call', '#a3e635', 'Phone', 'call', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'Meeting', '#64748b', 'Users', 'meeting', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'Task', '#ffd600', 'CheckCircle', 'task', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(4, 'Email', '#818cf8', 'Mail', 'email', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(5, 'Deadline', '#f43f5e', 'Clock', 'deadline', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_billables`
--

CREATE TABLE `tbl_billables` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax_type` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `terms` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `billableable_type` varchar(191) NOT NULL,
  `billableable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_billable_products`
--

CREATE TABLE `tbl_billable_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `unit_price` decimal(15,3) NOT NULL DEFAULT 0.000,
  `qty` decimal(15,2) NOT NULL DEFAULT 1.00,
  `unit` varchar(191) DEFAULT NULL,
  `tax_rate` decimal(15,3) NOT NULL DEFAULT 0.000,
  `tax_label` varchar(191) NOT NULL,
  `discount_type` varchar(191) DEFAULT NULL,
  `discount_total` decimal(15,2) NOT NULL DEFAULT 0.00,
  `amount` decimal(15,3) NOT NULL DEFAULT 0.000,
  `note` text DEFAULT NULL,
  `display_order` int(11) NOT NULL,
  `billable_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED 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 `tbl_brands`
--

CREATE TABLE `tbl_brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `display_name` varchar(191) NOT NULL,
  `logo_view` varchar(191) DEFAULT NULL,
  `logo_mail` varchar(191) DEFAULT NULL,
  `config` mediumtext DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `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 `tbl_brands`
--

INSERT INTO `tbl_brands` (`id`, `name`, `display_name`, `logo_view`, `logo_mail`, `config`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'ABS CRM', 'ABS CRM', NULL, NULL, '{\"primary_color\":\"#4f46e5\",\"document\":{\"mail_subject\":\"Your document is ready\",\"mail_message\":\"\",\"mail_button_text\":\"Read Your Document\",\"signed_mail_subject\":\"Thank you for signing our document.\",\"signed_mail_message\":\"You can view the document at any time by clicking the button below. You can also download it as a PDF to save it.\",\"signed_thankyou_message\":\"Thank you for signing our document. We will be in touch shortly so that we can get started.\",\"accepted_thankyou_message\":\"Thank you for accepting our document. We will be in touch shortly so that we can get started.\"},\"pdf\":{\"font\":\"DejaVu Sans\",\"size\":\"a4\",\"orientation\":\"portrait\"},\"signature\":{\"bound_text\":\"I, {{ signerName }}, agree to the terms of this agreement and I agree that my typed name below can be used as a digital representation of my signature to that fact\"},\"navigation\":{\"background_color\":\"#f3f4f6\"}}', 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_callables`
--

CREATE TABLE `tbl_callables` (
  `call_id` bigint(20) UNSIGNED NOT NULL,
  `callable_type` varchar(191) NOT NULL,
  `callable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_calls`
--

CREATE TABLE `tbl_calls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `call_outcome_id` bigint(20) UNSIGNED NOT NULL,
  `body` text NOT NULL,
  `date` datetime 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 `tbl_call_outcomes`
--

CREATE TABLE `tbl_call_outcomes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `swatch_color` varchar(7) DEFAULT 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 `tbl_call_outcomes`
--

INSERT INTO `tbl_call_outcomes` (`id`, `name`, `swatch_color`, `created_at`, `updated_at`) VALUES
(1, 'No Answer', '#f43f5e', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'Busy', '#f43f5e', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'Wrong Number', '#8898aa', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(4, 'Unavailable', '#8898aa', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(5, 'Left voice message', '#ffd600', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(6, 'Moved conversation forward', '#a3e635', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_changelog`
--

CREATE TABLE `tbl_changelog` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event` varchar(191) DEFAULT NULL,
  `log_name` varchar(191) DEFAULT NULL,
  `description` text NOT NULL,
  `identifier` varchar(191) DEFAULT NULL,
  `subject_type` varchar(191) DEFAULT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `causer_type` varchar(191) DEFAULT NULL,
  `causer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `causer_name` varchar(191) DEFAULT NULL,
  `properties` text DEFAULT NULL,
  `batch_uuid` char(36) DEFAULT 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 `tbl_changelog`
--

INSERT INTO `tbl_changelog` (`id`, `event`, `log_name`, `description`, `identifier`, `subject_type`, `subject_id`, `causer_type`, `causer_id`, `causer_name`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES
(1, 'created', 'model', 'created', 'created', 'App\\Models\\SupportTicket', 1, 'App\\Models\\User', 1, 'Adriano Dominick', '{\"attributes\":{\"user.name\":\"Adriano Dominick\",\"country.name\":null,\"source.name\":null,\"id\":1,\"email\":null,\"uuid\":\"d7139a3b-044f-4053-9700-424cdf2a665b\",\"user_id\":1,\"source_id\":null,\"first_name\":\"Adriano\",\"last_name\":\"Dominick\",\"job_title\":null,\"avatar\":null,\"street\":null,\"city\":null,\"state\":null,\"postal_code\":null,\"country_id\":null}}', NULL, '2023-05-22 11:50:27', '2023-05-22 11:50:27');

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

--
-- Table structure for table `tbl_comments`
--

CREATE TABLE `tbl_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `body` text NOT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `commentable_type` varchar(191) NOT NULL,
  `commentable_id` bigint(20) UNSIGNED 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 `tbl_companies`
--

CREATE TABLE `tbl_companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Owner',
  `owner_assigned_date` datetime DEFAULT NULL,
  `source_id` bigint(20) UNSIGNED DEFAULT NULL,
  `industry_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parent_company_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) DEFAULT NULL,
  `domain` varchar(191) DEFAULT NULL,
  `street` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `next_activity_id` bigint(20) 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 `tbl_contactables`
--

CREATE TABLE `tbl_contactables` (
  `contact_id` bigint(20) UNSIGNED NOT NULL,
  `contactable_type` varchar(191) NOT NULL,
  `contactable_id` bigint(20) UNSIGNED 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 `tbl_contacts`
--

CREATE TABLE `tbl_contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(191) DEFAULT NULL,
  `uuid` char(36) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Owner',
  `owner_assigned_date` datetime DEFAULT NULL,
  `source_id` bigint(20) UNSIGNED DEFAULT NULL,
  `first_name` varchar(191) NOT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `job_title` varchar(191) DEFAULT NULL,
  `avatar` varchar(191) DEFAULT NULL,
  `street` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `next_activity_id` bigint(20) 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;

--
-- Dumping data for table `tbl_contacts`
--

INSERT INTO `tbl_contacts` (`id`, `email`, `uuid`, `user_id`, `owner_assigned_date`, `source_id`, `first_name`, `last_name`, `job_title`, `avatar`, `street`, `city`, `state`, `postal_code`, `country_id`, `created_by`, `next_activity_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, NULL, 'd7139a3b-044f-4053-9700-424cdf2a665b', 1, '2023-05-22 13:50:27', NULL, 'Adriano', 'Dominick', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, '2023-05-22 11:50:27', '2023-05-22 11:50:27');

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

--
-- Table structure for table `tbl_countries`
--

CREATE TABLE `tbl_countries` (
  `id` int(10) UNSIGNED NOT NULL,
  `capital` varchar(255) DEFAULT NULL,
  `citizenship` varchar(255) DEFAULT NULL,
  `country_code` char(3) NOT NULL DEFAULT '',
  `currency_code` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `iso_3166_2` char(2) NOT NULL DEFAULT '',
  `iso_3166_3` char(3) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `region_code` char(3) NOT NULL DEFAULT '',
  `sub_region_code` char(3) NOT NULL DEFAULT '',
  `eea` tinyint(1) NOT NULL DEFAULT 0,
  `calling_code` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_countries`
--

INSERT INTO `tbl_countries` (`id`, `capital`, `citizenship`, `country_code`, `currency_code`, `full_name`, `iso_3166_2`, `iso_3166_3`, `name`, `region_code`, `sub_region_code`, `eea`, `calling_code`) VALUES
(4, 'Kabul', 'Afghan', '004', 'AFN', 'Islamic Republic of Afghanistan', 'AF', 'AFG', 'Afghanistan', '142', '034', 0, '93'),
(8, 'Tirana', 'Albanian', '008', 'ALL', 'Republic of Albania', 'AL', 'ALB', 'Albania', '150', '039', 0, '355'),
(10, 'Antartica', 'of Antartica', '010', '', 'Antarctica', 'AQ', 'ATA', 'Antarctica', '', '', 0, '672'),
(12, 'Algiers', 'Algerian', '012', 'DZD', 'People’s Democratic Republic of Algeria', 'DZ', 'DZA', 'Algeria', '002', '015', 0, '213'),
(16, 'Pago Pago', 'American Samoan', '016', 'USD', 'Territory of American', 'AS', 'ASM', 'American Samoa', '009', '061', 0, '1'),
(20, 'Andorra la Vella', 'Andorran', '020', 'EUR', 'Principality of Andorra', 'AD', 'AND', 'Andorra', '150', '039', 0, '376'),
(24, 'Luanda', 'Angolan', '024', 'AOA', 'Republic of Angola', 'AO', 'AGO', 'Angola', '002', '017', 0, '244'),
(28, 'St John’s', 'of Antigua and Barbuda', '028', 'XCD', 'Antigua and Barbuda', 'AG', 'ATG', 'Antigua and Barbuda', '019', '029', 0, '1'),
(31, 'Baku', 'Azerbaijani', '031', 'AZN', 'Republic of Azerbaijan', 'AZ', 'AZE', 'Azerbaijan', '142', '145', 0, '994'),
(32, 'Buenos Aires', 'Argentinian', '032', 'ARS', 'Argentine Republic', 'AR', 'ARG', 'Argentina', '019', '005', 0, '54'),
(36, 'Canberra', 'Australian', '036', 'AUD', 'Commonwealth of Australia', 'AU', 'AUS', 'Australia', '009', '053', 0, '61'),
(40, 'Vienna', 'Austrian', '040', 'EUR', 'Republic of Austria', 'AT', 'AUT', 'Austria', '150', '155', 1, '43'),
(44, 'Nassau', 'Bahamian', '044', 'BSD', 'Commonwealth of the Bahamas', 'BS', 'BHS', 'Bahamas', '019', '029', 0, '1'),
(48, 'Manama', 'Bahraini', '048', 'BHD', 'Kingdom of Bahrain', 'BH', 'BHR', 'Bahrain', '142', '145', 0, '973'),
(50, 'Dhaka', 'Bangladeshi', '050', 'BDT', 'People’s Republic of Bangladesh', 'BD', 'BGD', 'Bangladesh', '142', '034', 0, '880'),
(51, 'Yerevan', 'Armenian', '051', 'AMD', 'Republic of Armenia', 'AM', 'ARM', 'Armenia', '142', '145', 0, '374'),
(52, 'Bridgetown', 'Barbadian', '052', 'BBD', 'Barbados', 'BB', 'BRB', 'Barbados', '019', '029', 0, '1'),
(56, 'Brussels', 'Belgian', '056', 'EUR', 'Kingdom of Belgium', 'BE', 'BEL', 'Belgium', '150', '155', 1, '32'),
(60, 'Hamilton', 'Bermudian', '060', 'BMD', 'Bermuda', 'BM', 'BMU', 'Bermuda', '019', '021', 0, '1'),
(64, 'Thimphu', 'Bhutanese', '064', 'BTN', 'Kingdom of Bhutan', 'BT', 'BTN', 'Bhutan', '142', '034', 0, '975'),
(68, 'Sucre (BO1)', 'Bolivian', '068', 'BOB', 'Plurinational State of Bolivia', 'BO', 'BOL', 'Bolivia, Plurinational State of', '019', '005', 0, '591'),
(70, 'Sarajevo', 'of Bosnia and Herzegovina', '070', 'BAM', 'Bosnia and Herzegovina', 'BA', 'BIH', 'Bosnia and Herzegovina', '150', '039', 0, '387'),
(72, 'Gaborone', 'Botswanan', '072', 'BWP', 'Republic of Botswana', 'BW', 'BWA', 'Botswana', '002', '018', 0, '267'),
(74, 'Bouvet island', 'of Bouvet island', '074', '', 'Bouvet Island', 'BV', 'BVT', 'Bouvet Island', '', '', 0, '47'),
(76, 'Brasilia', 'Brazilian', '076', 'BRL', 'Federative Republic of Brazil', 'BR', 'BRA', 'Brazil', '019', '005', 0, '55'),
(84, 'Belmopan', 'Belizean', '084', 'BZD', 'Belize', 'BZ', 'BLZ', 'Belize', '019', '013', 0, '501'),
(86, 'Diego Garcia', 'Changosian', '086', 'USD', 'British Indian Ocean Territory', 'IO', 'IOT', 'British Indian Ocean Territory', '', '', 0, '246'),
(90, 'Honiara', 'Solomon Islander', '090', 'SBD', 'Solomon Islands', 'SB', 'SLB', 'Solomon Islands', '009', '054', 0, '677'),
(92, 'Road Town', 'British Virgin Islander;', '092', 'USD', 'British Virgin Islands', 'VG', 'VGB', 'Virgin Islands, British', '019', '029', 0, '1'),
(96, 'Bandar Seri Begawan', 'Bruneian', '096', 'BND', 'Brunei Darussalam', 'BN', 'BRN', 'Brunei Darussalam', '142', '035', 0, '673'),
(100, 'Sofia', 'Bulgarian', '100', 'BGN', 'Republic of Bulgaria', 'BG', 'BGR', 'Bulgaria', '150', '151', 1, '359'),
(104, 'Yangon', 'Burmese', '104', 'MMK', 'Union of Myanmar/', 'MM', 'MMR', 'Myanmar', '142', '035', 0, '95'),
(108, 'Bujumbura', 'Burundian', '108', 'BIF', 'Republic of Burundi', 'BI', 'BDI', 'Burundi', '002', '014', 0, '257'),
(112, 'Minsk', 'Belarusian', '112', 'BYR', 'Republic of Belarus', 'BY', 'BLR', 'Belarus', '150', '151', 0, '375'),
(116, 'Phnom Penh', 'Cambodian', '116', 'KHR', 'Kingdom of Cambodia', 'KH', 'KHM', 'Cambodia', '142', '035', 0, '855'),
(120, 'Yaoundé', 'Cameroonian', '120', 'XAF', 'Republic of Cameroon', 'CM', 'CMR', 'Cameroon', '002', '017', 0, '237'),
(124, 'Ottawa', 'Canadian', '124', 'CAD', 'Canada', 'CA', 'CAN', 'Canada', '019', '021', 0, '1'),
(132, 'Praia', 'Cape Verdean', '132', 'CVE', 'Republic of Cape Verde', 'CV', 'CPV', 'Cape Verde', '002', '011', 0, '238'),
(136, 'George Town', 'Caymanian', '136', 'KYD', 'Cayman Islands', 'KY', 'CYM', 'Cayman Islands', '019', '029', 0, '1'),
(140, 'Bangui', 'Central African', '140', 'XAF', 'Central African Republic', 'CF', 'CAF', 'Central African Republic', '002', '017', 0, '236'),
(144, 'Colombo', 'Sri Lankan', '144', 'LKR', 'Democratic Socialist Republic of Sri Lanka', 'LK', 'LKA', 'Sri Lanka', '142', '034', 0, '94'),
(148, 'N’Djamena', 'Chadian', '148', 'XAF', 'Republic of Chad', 'TD', 'TCD', 'Chad', '002', '017', 0, '235'),
(152, 'Santiago', 'Chilean', '152', 'CLP', 'Republic of Chile', 'CL', 'CHL', 'Chile', '019', '005', 0, '56'),
(156, 'Beijing', 'Chinese', '156', 'CNY', 'People’s Republic of China', 'CN', 'CHN', 'China', '142', '030', 0, '86'),
(158, 'Taipei', 'Taiwanese', '158', 'TWD', 'Republic of China, Taiwan (TW1)', 'TW', 'TWN', 'Taiwan, Province of China', '142', '030', 0, '886'),
(162, 'Flying Fish Cove', 'Christmas Islander', '162', 'AUD', 'Christmas Island Territory', 'CX', 'CXR', 'Christmas Island', '', '', 0, '61'),
(166, 'Bantam', 'Cocos Islander', '166', 'AUD', 'Territory of Cocos (Keeling) Islands', 'CC', 'CCK', 'Cocos (Keeling) Islands', '', '', 0, '61'),
(170, 'Santa Fe de Bogotá', 'Colombian', '170', 'COP', 'Republic of Colombia', 'CO', 'COL', 'Colombia', '019', '005', 0, '57'),
(174, 'Moroni', 'Comorian', '174', 'KMF', 'Union of the Comoros', 'KM', 'COM', 'Comoros', '002', '014', 0, '269'),
(175, 'Mamoudzou', 'Mahorais', '175', 'EUR', 'Departmental Collectivity of Mayotte', 'YT', 'MYT', 'Mayotte', '002', '014', 0, '262'),
(178, 'Brazzaville', 'Congolese', '178', 'XAF', 'Republic of the Congo', 'CG', 'COG', 'Congo', '002', '017', 0, '242'),
(180, 'Kinshasa', 'Congolese', '180', 'CDF', 'Democratic Republic of the Congo', 'CD', 'COD', 'Congo, the Democratic Republic of the', '002', '017', 0, '243'),
(184, 'Avarua', 'Cook Islander', '184', 'NZD', 'Cook Islands', 'CK', 'COK', 'Cook Islands', '009', '061', 0, '682'),
(188, 'San José', 'Costa Rican', '188', 'CRC', 'Republic of Costa Rica', 'CR', 'CRI', 'Costa Rica', '019', '013', 0, '506'),
(191, 'Zagreb', 'Croatian', '191', 'HRK', 'Republic of Croatia', 'HR', 'HRV', 'Croatia', '150', '039', 1, '385'),
(192, 'Havana', 'Cuban', '192', 'CUP', 'Republic of Cuba', 'CU', 'CUB', 'Cuba', '019', '029', 0, '53'),
(196, 'Nicosia', 'Cypriot', '196', 'EUR', 'Republic of Cyprus', 'CY', 'CYP', 'Cyprus', '142', '145', 1, '357'),
(203, 'Prague', 'Czech', '203', 'CZK', 'Czech Republic', 'CZ', 'CZE', 'Czech Republic', '150', '151', 1, '420'),
(204, 'Porto Novo (BJ1)', 'Beninese', '204', 'XOF', 'Republic of Benin', 'BJ', 'BEN', 'Benin', '002', '011', 0, '229'),
(208, 'Copenhagen', 'Danish', '208', 'DKK', 'Kingdom of Denmark', 'DK', 'DNK', 'Denmark', '150', '154', 1, '45'),
(212, 'Roseau', 'Dominican', '212', 'XCD', 'Commonwealth of Dominica', 'DM', 'DMA', 'Dominica', '019', '029', 0, '1'),
(214, 'Santo Domingo', 'Dominican', '214', 'DOP', 'Dominican Republic', 'DO', 'DOM', 'Dominican Republic', '019', '029', 0, '1'),
(218, 'Quito', 'Ecuadorian', '218', 'USD', 'Republic of Ecuador', 'EC', 'ECU', 'Ecuador', '019', '005', 0, '593'),
(222, 'San Salvador', 'Salvadoran', '222', 'SVC', 'Republic of El Salvador', 'SV', 'SLV', 'El Salvador', '019', '013', 0, '503'),
(226, 'Malabo', 'Equatorial Guinean', '226', 'XAF', 'Republic of Equatorial Guinea', 'GQ', 'GNQ', 'Equatorial Guinea', '002', '017', 0, '240'),
(231, 'Addis Ababa', 'Ethiopian', '231', 'ETB', 'Federal Democratic Republic of Ethiopia', 'ET', 'ETH', 'Ethiopia', '002', '014', 0, '251'),
(232, 'Asmara', 'Eritrean', '232', 'ERN', 'State of Eritrea', 'ER', 'ERI', 'Eritrea', '002', '014', 0, '291'),
(233, 'Tallinn', 'Estonian', '233', 'EUR', 'Republic of Estonia', 'EE', 'EST', 'Estonia', '150', '154', 1, '372'),
(234, 'Tórshavn', 'Faeroese', '234', 'DKK', 'Faeroe Islands', 'FO', 'FRO', 'Faroe Islands', '150', '154', 0, '298'),
(238, 'Stanley', 'Falkland Islander', '238', 'FKP', 'Falkland Islands', 'FK', 'FLK', 'Falkland Islands (Malvinas)', '019', '005', 0, '500'),
(239, 'King Edward Point (Grytviken)', 'of South Georgia and the South Sandwich Islands', '239', '', 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 'South Georgia and the South Sandwich Islands', '', '', 0, '44'),
(242, 'Suva', 'Fijian', '242', 'FJD', 'Republic of Fiji', 'FJ', 'FJI', 'Fiji', '009', '054', 0, '679'),
(246, 'Helsinki', 'Finnish', '246', 'EUR', 'Republic of Finland', 'FI', 'FIN', 'Finland', '150', '154', 1, '358'),
(248, 'Mariehamn', 'Åland Islander', '248', 'EUR', 'Åland Islands', 'AX', 'ALA', 'Åland Islands', '150', '154', 0, '358'),
(250, 'Paris', 'French', '250', 'EUR', 'French Republic', 'FR', 'FRA', 'France', '150', '155', 1, '33'),
(254, 'Cayenne', 'Guianese', '254', 'EUR', 'French Guiana', 'GF', 'GUF', 'French Guiana', '019', '005', 0, '594'),
(258, 'Papeete', 'Polynesian', '258', 'XPF', 'French Polynesia', 'PF', 'PYF', 'French Polynesia', '009', '061', 0, '689'),
(260, 'Port-aux-Francais', 'of French Southern and Antarctic Lands', '260', 'EUR', 'French Southern and Antarctic Lands', 'TF', 'ATF', 'French Southern Territories', '', '', 0, '33'),
(262, 'Djibouti', 'Djiboutian', '262', 'DJF', 'Republic of Djibouti', 'DJ', 'DJI', 'Djibouti', '002', '014', 0, '253'),
(266, 'Libreville', 'Gabonese', '266', 'XAF', 'Gabonese Republic', 'GA', 'GAB', 'Gabon', '002', '017', 0, '241'),
(268, 'Tbilisi', 'Georgian', '268', 'GEL', 'Georgia', 'GE', 'GEO', 'Georgia', '142', '145', 0, '995'),
(270, 'Banjul', 'Gambian', '270', 'GMD', 'Republic of the Gambia', 'GM', 'GMB', 'Gambia', '002', '011', 0, '220'),
(275, NULL, 'Palestinian', '275', NULL, NULL, 'PS', 'PSE', 'Palestinian Territory, Occupied', '142', '145', 0, '970'),
(276, 'Berlin', 'German', '276', 'EUR', 'Federal Republic of Germany', 'DE', 'DEU', 'Germany', '150', '155', 1, '49'),
(288, 'Accra', 'Ghanaian', '288', 'GHS', 'Republic of Ghana', 'GH', 'GHA', 'Ghana', '002', '011', 0, '233'),
(292, 'Gibraltar', 'Gibraltarian', '292', 'GIP', 'Gibraltar', 'GI', 'GIB', 'Gibraltar', '150', '039', 0, '350'),
(296, 'Tarawa', 'Kiribatian', '296', 'AUD', 'Republic of Kiribati', 'KI', 'KIR', 'Kiribati', '009', '057', 0, '686'),
(300, 'Athens', 'Greek', '300', 'EUR', 'Hellenic Republic', 'GR', 'GRC', 'Greece', '150', '039', 1, '30'),
(304, 'Nuuk', 'Greenlander', '304', 'DKK', 'Greenland', 'GL', 'GRL', 'Greenland', '019', '021', 0, '299'),
(308, 'St George’s', 'Grenadian', '308', 'XCD', 'Grenada', 'GD', 'GRD', 'Grenada', '019', '029', 0, '1'),
(312, 'Basse Terre', 'Guadeloupean', '312', 'EUR ', 'Guadeloupe', 'GP', 'GLP', 'Guadeloupe', '019', '029', 0, '590'),
(316, 'Agaña (Hagåtña)', 'Guamanian', '316', 'USD', 'Territory of Guam', 'GU', 'GUM', 'Guam', '009', '057', 0, '1'),
(320, 'Guatemala City', 'Guatemalan', '320', 'GTQ', 'Republic of Guatemala', 'GT', 'GTM', 'Guatemala', '019', '013', 0, '502'),
(324, 'Conakry', 'Guinean', '324', 'GNF', 'Republic of Guinea', 'GN', 'GIN', 'Guinea', '002', '011', 0, '224'),
(328, 'Georgetown', 'Guyanese', '328', 'GYD', 'Cooperative Republic of Guyana', 'GY', 'GUY', 'Guyana', '019', '005', 0, '592'),
(332, 'Port-au-Prince', 'Haitian', '332', 'HTG', 'Republic of Haiti', 'HT', 'HTI', 'Haiti', '019', '029', 0, '509'),
(334, 'Territory of Heard Island and McDonald Islands', 'of Territory of Heard Island and McDonald Islands', '334', '', 'Territory of Heard Island and McDonald Islands', 'HM', 'HMD', 'Heard Island and McDonald Islands', '', '', 0, '61'),
(336, 'Vatican City', 'of the Holy See/of the Vatican', '336', 'EUR', 'the Holy See/ Vatican City State', 'VA', 'VAT', 'Holy See (Vatican City State)', '150', '039', 0, '39'),
(340, 'Tegucigalpa', 'Honduran', '340', 'HNL', 'Republic of Honduras', 'HN', 'HND', 'Honduras', '019', '013', 0, '504'),
(344, '(HK3)', 'Hong Kong Chinese', '344', 'HKD', 'Hong Kong Special Administrative Region of the People’s Republic of China (HK2)', 'HK', 'HKG', 'Hong Kong', '142', '030', 0, '852'),
(348, 'Budapest', 'Hungarian', '348', 'HUF', 'Republic of Hungary', 'HU', 'HUN', 'Hungary', '150', '151', 1, '36'),
(352, 'Reykjavik', 'Icelander', '352', 'ISK', 'Republic of Iceland', 'IS', 'ISL', 'Iceland', '150', '154', 0, '354'),
(356, 'New Delhi', 'Indian', '356', 'INR', 'Republic of India', 'IN', 'IND', 'India', '142', '034', 0, '91'),
(360, 'Jakarta', 'Indonesian', '360', 'IDR', 'Republic of Indonesia', 'ID', 'IDN', 'Indonesia', '142', '035', 0, '62'),
(364, 'Tehran', 'Iranian', '364', 'IRR', 'Islamic Republic of Iran', 'IR', 'IRN', 'Iran, Islamic Republic of', '142', '034', 0, '98'),
(368, 'Baghdad', 'Iraqi', '368', 'IQD', 'Republic of Iraq', 'IQ', 'IRQ', 'Iraq', '142', '145', 0, '964'),
(372, 'Dublin', 'Irish', '372', 'EUR', 'Ireland (IE1)', 'IE', 'IRL', 'Ireland', '150', '154', 1, '353'),
(376, '(IL1)', 'Israeli', '376', 'ILS', 'State of Israel', 'IL', 'ISR', 'Israel', '142', '145', 0, '972'),
(380, 'Rome', 'Italian', '380', 'EUR', 'Italian Republic', 'IT', 'ITA', 'Italy', '150', '039', 1, '39'),
(384, 'Yamoussoukro (CI1)', 'Ivorian', '384', 'XOF', 'Republic of Côte d’Ivoire', 'CI', 'CIV', 'Côte d\'Ivoire', '002', '011', 0, '225'),
(388, 'Kingston', 'Jamaican', '388', 'JMD', 'Jamaica', 'JM', 'JAM', 'Jamaica', '019', '029', 0, '1'),
(392, 'Tokyo', 'Japanese', '392', 'JPY', 'Japan', 'JP', 'JPN', 'Japan', '142', '030', 0, '81'),
(398, 'Astana', 'Kazakh', '398', 'KZT', 'Republic of Kazakhstan', 'KZ', 'KAZ', 'Kazakhstan', '142', '143', 0, '7'),
(400, 'Amman', 'Jordanian', '400', 'JOD', 'Hashemite Kingdom of Jordan', 'JO', 'JOR', 'Jordan', '142', '145', 0, '962'),
(404, 'Nairobi', 'Kenyan', '404', 'KES', 'Republic of Kenya', 'KE', 'KEN', 'Kenya', '002', '014', 0, '254'),
(408, 'Pyongyang', 'North Korean', '408', 'KPW', 'Democratic People’s Republic of Korea', 'KP', 'PRK', 'Korea, Democratic People\'s Republic of', '142', '030', 0, '850'),
(410, 'Seoul', 'South Korean', '410', 'KRW', 'Republic of Korea', 'KR', 'KOR', 'Korea, Republic of', '142', '030', 0, '82'),
(414, 'Kuwait City', 'Kuwaiti', '414', 'KWD', 'State of Kuwait', 'KW', 'KWT', 'Kuwait', '142', '145', 0, '965'),
(417, 'Bishkek', 'Kyrgyz', '417', 'KGS', 'Kyrgyz Republic', 'KG', 'KGZ', 'Kyrgyzstan', '142', '143', 0, '996'),
(418, 'Vientiane', 'Lao', '418', 'LAK', 'Lao People’s Democratic Republic', 'LA', 'LAO', 'Lao People\'s Democratic Republic', '142', '035', 0, '856'),
(422, 'Beirut', 'Lebanese', '422', 'LBP', 'Lebanese Republic', 'LB', 'LBN', 'Lebanon', '142', '145', 0, '961'),
(426, 'Maseru', 'Basotho', '426', 'LSL', 'Kingdom of Lesotho', 'LS', 'LSO', 'Lesotho', '002', '018', 0, '266'),
(428, 'Riga', 'Latvian', '428', 'EUR', 'Republic of Latvia', 'LV', 'LVA', 'Latvia', '150', '154', 1, '371'),
(430, 'Monrovia', 'Liberian', '430', 'LRD', 'Republic of Liberia', 'LR', 'LBR', 'Liberia', '002', '011', 0, '231'),
(434, 'Tripoli', 'Libyan', '434', 'LYD', 'Socialist People’s Libyan Arab Jamahiriya', 'LY', 'LBY', 'Libya', '002', '015', 0, '218'),
(438, 'Vaduz', 'Liechtensteiner', '438', 'CHF', 'Principality of Liechtenstein', 'LI', 'LIE', 'Liechtenstein', '150', '155', 0, '423'),
(440, 'Vilnius', 'Lithuanian', '440', 'EUR', 'Republic of Lithuania', 'LT', 'LTU', 'Lithuania', '150', '154', 1, '370'),
(442, 'Luxembourg', 'Luxembourger', '442', 'EUR', 'Grand Duchy of Luxembourg', 'LU', 'LUX', 'Luxembourg', '150', '155', 1, '352'),
(446, 'Macao (MO3)', 'Macanese', '446', 'MOP', 'Macao Special Administrative Region of the People’s Republic of China (MO2)', 'MO', 'MAC', 'Macao', '142', '030', 0, '853'),
(450, 'Antananarivo', 'Malagasy', '450', 'MGA', 'Republic of Madagascar', 'MG', 'MDG', 'Madagascar', '002', '014', 0, '261'),
(454, 'Lilongwe', 'Malawian', '454', 'MWK', 'Republic of Malawi', 'MW', 'MWI', 'Malawi', '002', '014', 0, '265'),
(458, 'Kuala Lumpur (MY1)', 'Malaysian', '458', 'MYR', 'Malaysia', 'MY', 'MYS', 'Malaysia', '142', '035', 0, '60'),
(462, 'Malé', 'Maldivian', '462', 'MVR', 'Republic of Maldives', 'MV', 'MDV', 'Maldives', '142', '034', 0, '960'),
(466, 'Bamako', 'Malian', '466', 'XOF', 'Republic of Mali', 'ML', 'MLI', 'Mali', '002', '011', 0, '223'),
(470, 'Valletta', 'Maltese', '470', 'EUR', 'Republic of Malta', 'MT', 'MLT', 'Malta', '150', '039', 1, '356'),
(474, 'Fort-de-France', 'Martinican', '474', 'EUR', 'Martinique', 'MQ', 'MTQ', 'Martinique', '019', '029', 0, '596'),
(478, 'Nouakchott', 'Mauritanian', '478', 'MRO', 'Islamic Republic of Mauritania', 'MR', 'MRT', 'Mauritania', '002', '011', 0, '222'),
(480, 'Port Louis', 'Mauritian', '480', 'MUR', 'Republic of Mauritius', 'MU', 'MUS', 'Mauritius', '002', '014', 0, '230'),
(484, 'Mexico City', 'Mexican', '484', 'MXN', 'United Mexican States', 'MX', 'MEX', 'Mexico', '019', '013', 0, '52'),
(492, 'Monaco', 'Monegasque', '492', 'EUR', 'Principality of Monaco', 'MC', 'MCO', 'Monaco', '150', '155', 0, '377'),
(496, 'Ulan Bator', 'Mongolian', '496', 'MNT', 'Mongolia', 'MN', 'MNG', 'Mongolia', '142', '030', 0, '976'),
(498, 'Chisinau', 'Moldovan', '498', 'MDL', 'Republic of Moldova', 'MD', 'MDA', 'Moldova, Republic of', '150', '151', 0, '373'),
(499, 'Podgorica', 'Montenegrin', '499', 'EUR', 'Montenegro', 'ME', 'MNE', 'Montenegro', '150', '039', 0, '382'),
(500, 'Plymouth (MS2)', 'Montserratian', '500', 'XCD', 'Montserrat', 'MS', 'MSR', 'Montserrat', '019', '029', 0, '1'),
(504, 'Rabat', 'Moroccan', '504', 'MAD', 'Kingdom of Morocco', 'MA', 'MAR', 'Morocco', '002', '015', 0, '212'),
(508, 'Maputo', 'Mozambican', '508', 'MZN', 'Republic of Mozambique', 'MZ', 'MOZ', 'Mozambique', '002', '014', 0, '258'),
(512, 'Muscat', 'Omani', '512', 'OMR', 'Sultanate of Oman', 'OM', 'OMN', 'Oman', '142', '145', 0, '968'),
(516, 'Windhoek', 'Namibian', '516', 'NAD', 'Republic of Namibia', 'NA', 'NAM', 'Namibia', '002', '018', 0, '264'),
(520, 'Yaren', 'Nauruan', '520', 'AUD', 'Republic of Nauru', 'NR', 'NRU', 'Nauru', '009', '057', 0, '674'),
(524, 'Kathmandu', 'Nepalese', '524', 'NPR', 'Nepal', 'NP', 'NPL', 'Nepal', '142', '034', 0, '977'),
(528, 'Amsterdam (NL2)', 'Dutch', '528', 'EUR', 'Kingdom of the Netherlands', 'NL', 'NLD', 'Netherlands', '150', '155', 1, '31'),
(531, 'Willemstad', 'Curaçaoan', '531', 'ANG', 'Curaçao', 'CW', 'CUW', 'Curaçao', '019', '029', 0, '599'),
(533, 'Oranjestad', 'Aruban', '533', 'AWG', 'Aruba', 'AW', 'ABW', 'Aruba', '019', '029', 0, '297'),
(534, 'Philipsburg', 'Sint Maartener', '534', 'ANG', 'Sint Maarten', 'SX', 'SXM', 'Sint Maarten (Dutch part)', '019', '029', 0, '721'),
(535, NULL, 'of Bonaire, Sint Eustatius and Saba', '535', 'USD', NULL, 'BQ', 'BES', 'Bonaire, Sint Eustatius and Saba', '019', '029', 0, '599'),
(540, 'Nouméa', 'New Caledonian', '540', 'XPF', 'New Caledonia', 'NC', 'NCL', 'New Caledonia', '009', '054', 0, '687'),
(548, 'Port Vila', 'Vanuatuan', '548', 'VUV', 'Republic of Vanuatu', 'VU', 'VUT', 'Vanuatu', '009', '054', 0, '678'),
(554, 'Wellington', 'New Zealander', '554', 'NZD', 'New Zealand', 'NZ', 'NZL', 'New Zealand', '009', '053', 0, '64'),
(558, 'Managua', 'Nicaraguan', '558', 'NIO', 'Republic of Nicaragua', 'NI', 'NIC', 'Nicaragua', '019', '013', 0, '505'),
(562, 'Niamey', 'Nigerien', '562', 'XOF', 'Republic of Niger', 'NE', 'NER', 'Niger', '002', '011', 0, '227'),
(566, 'Abuja', 'Nigerian', '566', 'NGN', 'Federal Republic of Nigeria', 'NG', 'NGA', 'Nigeria', '002', '011', 0, '234'),
(570, 'Alofi', 'Niuean', '570', 'NZD', 'Niue', 'NU', 'NIU', 'Niue', '009', '061', 0, '683'),
(574, 'Kingston', 'Norfolk Islander', '574', 'AUD', 'Territory of Norfolk Island', 'NF', 'NFK', 'Norfolk Island', '009', '053', 0, '672'),
(578, 'Oslo', 'Norwegian', '578', 'NOK', 'Kingdom of Norway', 'NO', 'NOR', 'Norway', '150', '154', 0, '47'),
(580, 'Saipan', 'Northern Mariana Islander', '580', 'USD', 'Commonwealth of the Northern Mariana Islands', 'MP', 'MNP', 'Northern Mariana Islands', '009', '057', 0, '1'),
(581, 'United States Minor Outlying Islands', 'of United States Minor Outlying Islands', '581', 'USD', 'United States Minor Outlying Islands', 'UM', 'UMI', 'United States Minor Outlying Islands', '', '', 0, '1'),
(583, 'Palikir', 'Micronesian', '583', 'USD', 'Federated States of Micronesia', 'FM', 'FSM', 'Micronesia, Federated States of', '009', '057', 0, '691'),
(584, 'Majuro', 'Marshallese', '584', 'USD', 'Republic of the Marshall Islands', 'MH', 'MHL', 'Marshall Islands', '009', '057', 0, '692'),
(585, 'Melekeok', 'Palauan', '585', 'USD', 'Republic of Palau', 'PW', 'PLW', 'Palau', '009', '057', 0, '680'),
(586, 'Islamabad', 'Pakistani', '586', 'PKR', 'Islamic Republic of Pakistan', 'PK', 'PAK', 'Pakistan', '142', '034', 0, '92'),
(591, 'Panama City', 'Panamanian', '591', 'PAB', 'Republic of Panama', 'PA', 'PAN', 'Panama', '019', '013', 0, '507'),
(598, 'Port Moresby', 'Papua New Guinean', '598', 'PGK', 'Independent State of Papua New Guinea', 'PG', 'PNG', 'Papua New Guinea', '009', '054', 0, '675'),
(600, 'Asunción', 'Paraguayan', '600', 'PYG', 'Republic of Paraguay', 'PY', 'PRY', 'Paraguay', '019', '005', 0, '595'),
(604, 'Lima', 'Peruvian', '604', 'PEN', 'Republic of Peru', 'PE', 'PER', 'Peru', '019', '005', 0, '51'),
(608, 'Manila', 'Filipino', '608', 'PHP', 'Republic of the Philippines', 'PH', 'PHL', 'Philippines', '142', '035', 0, '63'),
(612, 'Adamstown', 'Pitcairner', '612', 'NZD', 'Pitcairn Islands', 'PN', 'PCN', 'Pitcairn', '009', '061', 0, '649'),
(616, 'Warsaw', 'Polish', '616', 'PLN', 'Republic of Poland', 'PL', 'POL', 'Poland', '150', '151', 1, '48'),
(620, 'Lisbon', 'Portuguese', '620', 'EUR', 'Portuguese Republic', 'PT', 'PRT', 'Portugal', '150', '039', 1, '351'),
(624, 'Bissau', 'Guinea-Bissau national', '624', 'XOF', 'Republic of Guinea-Bissau', 'GW', 'GNB', 'Guinea-Bissau', '002', '011', 0, '245'),
(626, 'Dili', 'East Timorese', '626', 'USD', 'Democratic Republic of East Timor', 'TL', 'TLS', 'Timor-Leste', '142', '035', 0, '670'),
(630, 'San Juan', 'Puerto Rican', '630', 'USD', 'Commonwealth of Puerto Rico', 'PR', 'PRI', 'Puerto Rico', '019', '029', 0, '1'),
(634, 'Doha', 'Qatari', '634', 'QAR', 'State of Qatar', 'QA', 'QAT', 'Qatar', '142', '145', 0, '974'),
(638, 'Saint-Denis', 'Reunionese', '638', 'EUR', 'Réunion', 'RE', 'REU', 'Réunion', '002', '014', 0, '262'),
(642, 'Bucharest', 'Romanian', '642', 'RON', 'Romania', 'RO', 'ROU', 'Romania', '150', '151', 1, '40'),
(643, 'Moscow', 'Russian', '643', 'RUB', 'Russian Federation', 'RU', 'RUS', 'Russian Federation', '150', '151', 0, '7'),
(646, 'Kigali', 'Rwandan; Rwandese', '646', 'RWF', 'Republic of Rwanda', 'RW', 'RWA', 'Rwanda', '002', '014', 0, '250'),
(652, 'Gustavia', 'of Saint Barthélemy', '652', 'EUR', 'Collectivity of Saint Barthélemy', 'BL', 'BLM', 'Saint Barthélemy', '019', '029', 0, '590'),
(654, 'Jamestown', 'Saint Helenian', '654', 'SHP', 'Saint Helena, Ascension and Tristan da Cunha', 'SH', 'SHN', 'Saint Helena, Ascension and Tristan da Cunha', '002', '011', 0, '290'),
(659, 'Basseterre', 'Kittsian; Nevisian', '659', 'XCD', 'Federation of Saint Kitts and Nevis', 'KN', 'KNA', 'Saint Kitts and Nevis', '019', '029', 0, '1'),
(660, 'The Valley', 'Anguillan', '660', 'XCD', 'Anguilla', 'AI', 'AIA', 'Anguilla', '019', '029', 0, '1'),
(662, 'Castries', 'Saint Lucian', '662', 'XCD', 'Saint Lucia', 'LC', 'LCA', 'Saint Lucia', '019', '029', 0, '1'),
(663, 'Marigot', 'of Saint Martin', '663', 'EUR', 'Collectivity of Saint Martin', 'MF', 'MAF', 'Saint Martin (French part)', '019', '029', 0, '590'),
(666, 'Saint-Pierre', 'St-Pierrais; Miquelonnais', '666', 'EUR', 'Territorial Collectivity of Saint Pierre and Miquelon', 'PM', 'SPM', 'Saint Pierre and Miquelon', '019', '021', 0, '508'),
(670, 'Kingstown', 'Vincentian', '670', 'XCD', 'Saint Vincent and the Grenadines', 'VC', 'VCT', 'Saint Vincent and the Grenadines', '019', '029', 0, '1'),
(674, 'San Marino', 'San Marinese', '674', 'EUR ', 'Republic of San Marino', 'SM', 'SMR', 'San Marino', '150', '039', 0, '378'),
(678, 'São Tomé', 'São Toméan', '678', 'STD', 'Democratic Republic of São Tomé and Príncipe', 'ST', 'STP', 'Sao Tome and Principe', '002', '017', 0, '239'),
(682, 'Riyadh', 'Saudi Arabian', '682', 'SAR', 'Kingdom of Saudi Arabia', 'SA', 'SAU', 'Saudi Arabia', '142', '145', 0, '966'),
(686, 'Dakar', 'Senegalese', '686', 'XOF', 'Republic of Senegal', 'SN', 'SEN', 'Senegal', '002', '011', 0, '221'),
(688, 'Belgrade', 'Serb', '688', 'RSD', 'Republic of Serbia', 'RS', 'SRB', 'Serbia', '150', '039', 0, '381'),
(690, 'Victoria', 'Seychellois', '690', 'SCR', 'Republic of Seychelles', 'SC', 'SYC', 'Seychelles', '002', '014', 0, '248'),
(694, 'Freetown', 'Sierra Leonean', '694', 'SLL', 'Republic of Sierra Leone', 'SL', 'SLE', 'Sierra Leone', '002', '011', 0, '232'),
(702, 'Singapore', 'Singaporean', '702', 'SGD', 'Republic of Singapore', 'SG', 'SGP', 'Singapore', '142', '035', 0, '65'),
(703, 'Bratislava', 'Slovak', '703', 'EUR', 'Slovak Republic', 'SK', 'SVK', 'Slovakia', '150', '151', 1, '421'),
(704, 'Hanoi', 'Vietnamese', '704', 'VND', 'Socialist Republic of Vietnam', 'VN', 'VNM', 'Viet Nam', '142', '035', 0, '84'),
(705, 'Ljubljana', 'Slovene', '705', 'EUR', 'Republic of Slovenia', 'SI', 'SVN', 'Slovenia', '150', '039', 1, '386'),
(706, 'Mogadishu', 'Somali', '706', 'SOS', 'Somali Republic', 'SO', 'SOM', 'Somalia', '002', '014', 0, '252'),
(710, 'Pretoria (ZA1)', 'South African', '710', 'ZAR', 'Republic of South Africa', 'ZA', 'ZAF', 'South Africa', '002', '018', 0, '27'),
(716, 'Harare', 'Zimbabwean', '716', 'ZWL', 'Republic of Zimbabwe', 'ZW', 'ZWE', 'Zimbabwe', '002', '014', 0, '263'),
(724, 'Madrid', 'Spaniard', '724', 'EUR', 'Kingdom of Spain', 'ES', 'ESP', 'Spain', '150', '039', 1, '34'),
(728, 'Juba', 'South Sudanese', '728', 'SSP', 'Republic of South Sudan', 'SS', 'SSD', 'South Sudan', '002', '015', 0, '211'),
(729, 'Khartoum', 'Sudanese', '729', 'SDG', 'Republic of the Sudan', 'SD', 'SDN', 'Sudan', '002', '015', 0, '249'),
(732, 'Al aaiun', 'Sahrawi', '732', 'MAD', 'Western Sahara', 'EH', 'ESH', 'Western Sahara', '002', '015', 0, '212'),
(740, 'Paramaribo', 'Surinamese', '740', 'SRD', 'Republic of Suriname', 'SR', 'SUR', 'Suriname', '019', '005', 0, '597'),
(744, 'Longyearbyen', 'of Svalbard', '744', 'NOK', 'Svalbard and Jan Mayen', 'SJ', 'SJM', 'Svalbard and Jan Mayen', '150', '154', 0, '47'),
(748, 'Mbabane', 'Swazi', '748', 'SZL', 'Kingdom of Swaziland', 'SZ', 'SWZ', 'Swaziland', '002', '018', 0, '268'),
(752, 'Stockholm', 'Swedish', '752', 'SEK', 'Kingdom of Sweden', 'SE', 'SWE', 'Sweden', '150', '154', 1, '46'),
(756, 'Berne', 'Swiss', '756', 'CHF', 'Swiss Confederation', 'CH', 'CHE', 'Switzerland', '150', '155', 0, '41'),
(760, 'Damascus', 'Syrian', '760', 'SYP', 'Syrian Arab Republic', 'SY', 'SYR', 'Syrian Arab Republic', '142', '145', 0, '963'),
(762, 'Dushanbe', 'Tajik', '762', 'TJS', 'Republic of Tajikistan', 'TJ', 'TJK', 'Tajikistan', '142', '143', 0, '992'),
(764, 'Bangkok', 'Thai', '764', 'THB', 'Kingdom of Thailand', 'TH', 'THA', 'Thailand', '142', '035', 0, '66'),
(768, 'Lomé', 'Togolese', '768', 'XOF', 'Togolese Republic', 'TG', 'TGO', 'Togo', '002', '011', 0, '228'),
(772, '(TK2)', 'Tokelauan', '772', 'NZD', 'Tokelau', 'TK', 'TKL', 'Tokelau', '009', '061', 0, '690'),
(776, 'Nuku’alofa', 'Tongan', '776', 'TOP', 'Kingdom of Tonga', 'TO', 'TON', 'Tonga', '009', '061', 0, '676'),
(780, 'Port of Spain', 'Trinidadian; Tobagonian', '780', 'TTD', 'Republic of Trinidad and Tobago', 'TT', 'TTO', 'Trinidad and Tobago', '019', '029', 0, '1'),
(784, 'Abu Dhabi', 'Emirian', '784', 'AED', 'United Arab Emirates', 'AE', 'ARE', 'United Arab Emirates', '142', '145', 0, '971'),
(788, 'Tunis', 'Tunisian', '788', 'TND', 'Republic of Tunisia', 'TN', 'TUN', 'Tunisia', '002', '015', 0, '216'),
(792, 'Ankara', 'Turk', '792', 'TRY', 'Republic of Turkey', 'TR', 'TUR', 'Turkey', '142', '145', 0, '90'),
(795, 'Ashgabat', 'Turkmen', '795', 'TMT', 'Turkmenistan', 'TM', 'TKM', 'Turkmenistan', '142', '143', 0, '993'),
(796, 'Cockburn Town', 'Turks and Caicos Islander', '796', 'USD', 'Turks and Caicos Islands', 'TC', 'TCA', 'Turks and Caicos Islands', '019', '029', 0, '1'),
(798, 'Funafuti', 'Tuvaluan', '798', 'AUD', 'Tuvalu', 'TV', 'TUV', 'Tuvalu', '009', '061', 0, '688'),
(800, 'Kampala', 'Ugandan', '800', 'UGX', 'Republic of Uganda', 'UG', 'UGA', 'Uganda', '002', '014', 0, '256'),
(804, 'Kiev', 'Ukrainian', '804', 'UAH', 'Ukraine', 'UA', 'UKR', 'Ukraine', '150', '151', 0, '380'),
(807, 'Skopje', 'of the former Yugoslav Republic of Macedonia', '807', 'MKD', 'the former Yugoslav Republic of Macedonia', 'MK', 'MKD', 'Macedonia, the former Yugoslav Republic of', '150', '039', 0, '389'),
(818, 'Cairo', 'Egyptian', '818', 'EGP', 'Arab Republic of Egypt', 'EG', 'EGY', 'Egypt', '002', '015', 0, '20'),
(826, 'London', 'British', '826', 'GBP', 'United Kingdom of Great Britain and Northern Ireland', 'GB', 'GBR', 'United Kingdom', '150', '154', 1, '44'),
(831, 'St Peter Port', 'of Guernsey', '831', 'GGP (GG2)', 'Bailiwick of Guernsey', 'GG', 'GGY', 'Guernsey', '150', '154', 0, '44'),
(832, 'St Helier', 'of Jersey', '832', 'JEP (JE2)', 'Bailiwick of Jersey', 'JE', 'JEY', 'Jersey', '150', '154', 0, '44'),
(833, 'Douglas', 'Manxman; Manxwoman', '833', 'IMP (IM2)', 'Isle of Man', 'IM', 'IMN', 'Isle of Man', '150', '154', 0, '44'),
(834, 'Dodoma (TZ1)', 'Tanzanian', '834', 'TZS', 'United Republic of Tanzania', 'TZ', 'TZA', 'Tanzania, United Republic of', '002', '014', 0, '255'),
(840, 'Washington DC', 'American', '840', 'USD', 'United States of America', 'US', 'USA', 'United States', '019', '021', 0, '1'),
(850, 'Charlotte Amalie', 'US Virgin Islander', '850', 'USD', 'United States Virgin Islands', 'VI', 'VIR', 'Virgin Islands, U.S.', '019', '029', 0, '1'),
(854, 'Ouagadougou', 'Burkinabe', '854', 'XOF', 'Burkina Faso', 'BF', 'BFA', 'Burkina Faso', '002', '011', 0, '226'),
(858, 'Montevideo', 'Uruguayan', '858', 'UYU', 'Eastern Republic of Uruguay', 'UY', 'URY', 'Uruguay', '019', '005', 0, '598'),
(860, 'Tashkent', 'Uzbek', '860', 'UZS', 'Republic of Uzbekistan', 'UZ', 'UZB', 'Uzbekistan', '142', '143', 0, '998'),
(862, 'Caracas', 'Venezuelan', '862', 'VEF', 'Bolivarian Republic of Venezuela', 'VE', 'VEN', 'Venezuela, Bolivarian Republic of', '019', '005', 0, '58'),
(876, 'Mata-Utu', 'Wallisian; Futunan; Wallis and Futuna Islander', '876', 'XPF', 'Wallis and Futuna', 'WF', 'WLF', 'Wallis and Futuna', '009', '061', 0, '681'),
(882, 'Apia', 'Samoan', '882', 'WST', 'Independent State of Samoa', 'WS', 'WSM', 'Samoa', '009', '061', 0, '685'),
(887, 'San’a', 'Yemenite', '887', 'YER', 'Republic of Yemen', 'YE', 'YEM', 'Yemen', '142', '145', 0, '967'),
(894, 'Lusaka', 'Zambian', '894', 'ZMW', 'Republic of Zambia', 'ZM', 'ZMB', 'Zambia', '002', '014', 0, '260');

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

--
-- Table structure for table `tbl_custom_fields`
--

CREATE TABLE `tbl_custom_fields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `resource_name` varchar(191) NOT NULL,
  `field_type` varchar(191) NOT NULL,
  `field_id` varchar(191) NOT NULL,
  `label` varchar(191) NOT NULL,
  `is_unique` tinyint(1) 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 `tbl_custom_field_options`
--

CREATE TABLE `tbl_custom_field_options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `custom_field_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `swatch_color` varchar(7) DEFAULT NULL,
  `display_order` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_dashboards`
--

CREATE TABLE `tbl_dashboards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `cards` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Owner',
  `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 `tbl_dashboards`
--

INSERT INTO `tbl_dashboards` (`id`, `name`, `is_default`, `cards`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Application Dashboard', 1, '[]', 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_dealables`
--

CREATE TABLE `tbl_dealables` (
  `deal_id` bigint(20) UNSIGNED NOT NULL,
  `dealable_type` varchar(191) NOT NULL,
  `dealable_id` bigint(20) UNSIGNED 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 `tbl_deals`
--

CREATE TABLE `tbl_deals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `uuid` char(36) NOT NULL,
  `swatch_color` varchar(7) DEFAULT NULL,
  `pipeline_id` bigint(20) UNSIGNED NOT NULL,
  `stage_id` bigint(20) UNSIGNED NOT NULL,
  `status` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `won_date` datetime DEFAULT NULL,
  `lost_date` datetime DEFAULT NULL,
  `lost_reason` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Owner',
  `owner_assigned_date` datetime DEFAULT NULL,
  `expected_close_date` date DEFAULT NULL,
  `stage_changed_date` datetime DEFAULT NULL,
  `amount` decimal(15,3) DEFAULT NULL,
  `board_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `web_form_id` bigint(20) UNSIGNED DEFAULT NULL,
  `next_activity_id` bigint(20) 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 `tbl_deal_stages_history`
--

CREATE TABLE `tbl_deal_stages_history` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `deal_id` bigint(20) UNSIGNED NOT NULL,
  `stage_id` bigint(20) UNSIGNED NOT NULL,
  `entered_at` datetime NOT NULL,
  `left_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_documentables`
--

CREATE TABLE `tbl_documentables` (
  `document_id` bigint(20) UNSIGNED NOT NULL,
  `documentable_type` varchar(191) NOT NULL,
  `documentable_id` bigint(20) UNSIGNED 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 `tbl_documents`
--

CREATE TABLE `tbl_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `uuid` char(36) NOT NULL,
  `document_type_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(15,3) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `requires_signature` tinyint(1) NOT NULL DEFAULT 1,
  `content` mediumtext DEFAULT NULL,
  `view_type` varchar(191) NOT NULL DEFAULT 'nav-top',
  `accepted_at` datetime DEFAULT NULL,
  `marked_accepted_by` bigint(20) UNSIGNED DEFAULT NULL,
  `send_at` datetime DEFAULT NULL,
  `original_date_sent` datetime DEFAULT NULL,
  `last_date_sent` datetime DEFAULT NULL,
  `sent_by` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_by` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_date` datetime DEFAULT NULL,
  `approval_feedback` text DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `data` text DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Owner',
  `owner_assigned_date` datetime NOT NULL,
  `created_by` bigint(20) UNSIGNED NOT 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 `tbl_document_signers`
--

CREATE TABLE `tbl_document_signers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `send_email` tinyint(1) NOT NULL,
  `sent_at` datetime DEFAULT NULL,
  `signature` varchar(191) DEFAULT NULL,
  `signed_at` datetime DEFAULT NULL,
  `sign_ip` varchar(45) DEFAULT NULL,
  `document_id` bigint(20) UNSIGNED 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 `tbl_document_templates`
--

CREATE TABLE `tbl_document_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `content` mediumtext NOT NULL,
  `view_type` varchar(191) DEFAULT NULL,
  `is_shared` tinyint(1) NOT NULL DEFAULT 0,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Owner',
  `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 `tbl_document_types`
--

CREATE TABLE `tbl_document_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `swatch_color` varchar(7) DEFAULT NULL,
  `flag` varchar(50) DEFAULT 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 `tbl_document_types`
--

INSERT INTO `tbl_document_types` (`id`, `name`, `swatch_color`, `flag`, `created_at`, `updated_at`) VALUES
(1, 'Proposal', '#a3e635', 'proposal', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'Quote', '#64748b', 'quote', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'Contract', '#ffd600', 'contract', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_email_account_folders`
--

CREATE TABLE `tbl_email_account_folders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email_account_id` bigint(20) UNSIGNED NOT NULL,
  `remote_id` varchar(191) DEFAULT NULL COMMENT 'API ID, uidvalidity etc...',
  `support_move` tinyint(1) NOT NULL DEFAULT 1,
  `syncable` tinyint(1) NOT NULL DEFAULT 0,
  `selectable` tinyint(1) NOT NULL DEFAULT 0,
  `type` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `display_name` varchar(191) 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 `tbl_email_account_messageables`
--

CREATE TABLE `tbl_email_account_messageables` (
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `messageable_type` varchar(191) NOT NULL,
  `messageable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_email_account_message_addresses`
--

CREATE TABLE `tbl_email_account_message_addresses` (
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `address` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `address_type` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_email_account_message_folders`
--

CREATE TABLE `tbl_email_account_message_folders` (
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `folder_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_email_account_message_headers`
--

CREATE TABLE `tbl_email_account_message_headers` (
  `name` varchar(191) NOT NULL,
  `value` text DEFAULT NULL,
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `header_type` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_failed_jobs`
--

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

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

--
-- Table structure for table `tbl_filters`
--

CREATE TABLE `tbl_filters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `identifier` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_shared` tinyint(1) NOT NULL DEFAULT 0,
  `is_readonly` tinyint(1) NOT NULL DEFAULT 0,
  `rules` longtext NOT NULL,
  `flag` varchar(50) DEFAULT 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 `tbl_filters`
--

INSERT INTO `tbl_filters` (`id`, `name`, `identifier`, `user_id`, `is_shared`, `is_readonly`, `rules`, `flag`, `created_at`, `updated_at`) VALUES
(1, 'contact.filters.my', 'contacts', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"user_id\",\"operator\":\"equal\",\"value\":\"me\"}}]}', 'my-contacts', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'contact.filters.my_recently_assigned', 'contacts', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"user_id\",\"operator\":\"equal\",\"value\":\"me\"}},{\"type\":\"rule\",\"query\":{\"type\":\"date\",\"rule\":\"owner_assigned_date\",\"operator\":\"is\",\"value\":\"this_month\"}}]}', 'my-recently-assigned-contacts', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'company.filters.my', 'companies', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"user_id\",\"operator\":\"equal\",\"value\":\"me\"}}]}', 'my-companies', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(4, 'company.filters.my_recently_assigned', 'companies', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"user_id\",\"operator\":\"equal\",\"value\":\"me\"}},{\"type\":\"rule\",\"query\":{\"type\":\"date\",\"rule\":\"owner_assigned_date\",\"operator\":\"is\",\"value\":\"this_month\"}}]}', 'my-recently-assigned-companies', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(5, 'deal.filters.my', 'deals', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"user_id\",\"operator\":\"equal\",\"value\":\"me\"}}]}', 'my-deals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(6, 'deal.filters.my_recently_assigned', 'deals', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"user_id\",\"operator\":\"equal\",\"value\":\"me\"}},{\"type\":\"rule\",\"query\":{\"type\":\"date\",\"rule\":\"owner_assigned_date\",\"operator\":\"is\",\"value\":\"this_month\"}}]}', 'my-recently-assigned-deals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(7, 'deal.filters.created_this_month', 'deals', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"date\",\"rule\":\"created_at\",\"operator\":\"is\",\"value\":\"this_month\"}}]}', 'deals-created-this-month', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(8, 'deal.filters.won', 'deals', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"status\",\"operator\":\"equal\",\"value\":\"won\"}}]}', 'won-deals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(9, 'deal.filters.lost', 'deals', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"status\",\"operator\":\"equal\",\"value\":\"lost\"}}]}', 'lost-deals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(10, 'deal.filters.open', 'deals', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"select\",\"rule\":\"status\",\"operator\":\"equal\",\"value\":\"open\"}}]}', 'open-deals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(11, 'activity.filters.open', 'activities', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"rule\":\"open_activities\"}}]}', 'open-activities', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(12, 'activity.filters.due_today', 'activities', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"rule\":\"due_today\"}}]}', 'due-today-activities', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(13, 'activity.filters.due_this_week', 'activities', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"rule\":\"due_this_week\"}}]}', 'due-this-week-activities', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(14, 'activity.overdue', 'activities', NULL, 1, 1, '{\"condition\":\"and\",\"children\":[{\"type\":\"rule\",\"query\":{\"type\":\"radio\",\"rule\":\"overdue\",\"operator\":\"equal\",\"value\":\"yes\"}}]}', 'overdue-activities', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_filter_default_views`
--

CREATE TABLE `tbl_filter_default_views` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `filter_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `view` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_guests`
--

CREATE TABLE `tbl_guests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `guestable_type` varchar(191) NOT NULL,
  `guestable_id` bigint(20) UNSIGNED NOT 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 `tbl_imports`
--

CREATE TABLE `tbl_imports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_path` varchar(191) NOT NULL,
  `skip_file_path` varchar(191) DEFAULT NULL,
  `resource_name` varchar(191) NOT NULL,
  `status` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `data` mediumtext DEFAULT NULL,
  `imported` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `skipped` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `duplicates` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `completed_at` datetime 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 `tbl_industries`
--

CREATE TABLE `tbl_industries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `tbl_industries`
--

INSERT INTO `tbl_industries` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Accountants', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'Advertising/Public Relations', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'Aerospace, Defense Contractors', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(4, 'Agriculture', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(5, 'Air Transport', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(6, 'Airlines', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(7, 'Alcoholic Beverages', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(8, 'Alternative Energy Production & Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(9, 'Architectural Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(10, 'Attorneys/Law Firms', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(11, 'Auto Dealers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(12, 'Auto Manufacturers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(13, 'Automotive', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(14, 'Banking, Mortgage', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(15, 'Banks, Commercial', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(16, 'Banks, Savings & Loans', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(17, 'Bars & Restaurants', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(18, 'Beer, Wine & Liquor', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(19, 'Books, Magazines & Newspapers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(20, 'Broadcasters, Radio/TV', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(21, 'Builders/General Contractors', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(22, 'Builders/Residential', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(23, 'Building Materials & Equipment', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(24, 'Business Associations', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(25, 'Business Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(26, 'Cable & Satellite TV Production & Distribution', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(27, 'Candidate Committees', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(28, 'Car Dealers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(29, 'Car Dealers, Imports', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(30, 'Car Manufacturers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(31, 'Casinos / Gambling', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(32, 'Cattle Ranchers/Livestock', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(33, 'Chemical & Related Manufacturing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(34, 'Chiropractors', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(35, 'Civil Servants/Public Officials', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(36, 'Clergy & Religious Organizations', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(37, 'Clothing Manufacturing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(38, 'Coal Mining', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(39, 'Colleges, Universities & Schools', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(40, 'Commercial Banks', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(41, 'Commercial TV & Radio Stations', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(42, 'Communications/Electronics', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(43, 'Computer Software', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(44, 'Construction', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(45, 'Construction Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(46, 'Credit Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(47, 'Crop Production & Basic Processing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(48, 'Cruise Lines', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(49, 'Cruise Ships & Lines', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(50, 'Dairy', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(51, 'Defense', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(52, 'Defense Aerospace', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(53, 'Defense Electronics', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(54, 'Defense/Foreign Policy Advocates', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(55, 'Dentists', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(56, 'Doctors & Other Health Professionals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(57, 'Drug Manufacturers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(58, 'Education', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(59, 'Electric Utilities', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(60, 'Electronics Manufacturing & Equipment', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(61, 'Electronics, Defense Contractors', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(62, 'Energy & Natural Resources', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(63, 'Entertainment Industry', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(64, 'Environment', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(65, 'Farm Bureaus', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(66, 'Farming', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(67, 'Finance / Credit Companies', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(68, 'Finance, Insurance & Real Estate', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(69, 'Food & Beverage', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(70, 'Food Processing & Sales', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(71, 'Food Products Manufacturing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(72, 'Food Stores', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(73, 'For-profit Education', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(74, 'For-profit Prisons', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(75, 'Foreign & Defense Policy', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(76, 'Forestry & Forest Products', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(77, 'Foundations, Philanthropists & Non-Profits', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(78, 'Funeral Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(79, 'Gambling & Casinos', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(80, 'Gambling, Indian Casinos', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(81, 'Garbage Collection/Waste Management', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(82, 'Gas & Oil', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(83, 'General Contractors', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(84, 'Government Employees', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(85, 'Gun Control', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(86, 'Gun Rights', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(87, 'Health', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(88, 'Health Professionals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(89, 'Health Services/HMOs', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(90, 'Hedge Funds', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(91, 'HMOs & Health Care Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(92, 'Home Builders', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(93, 'Hospitals & Nursing Homes', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(94, 'Hotels, Motels & Tourism', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(95, 'Human Rights', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(96, 'Ideological/Single-Issue', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(97, 'Indian Gaming', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(98, 'Industrial Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(99, 'Insurance', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(100, 'Internet', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(101, 'Labor', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(102, 'Lawyers & Lobbyists', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(103, 'Lawyers / Law Firms', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(104, 'Leadership PACs', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(105, 'Liquor, Wine & Beer', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(106, 'Livestock', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(107, 'Lobbyists', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(108, 'Lodging / Tourism', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(109, 'Logging, Timber & Paper Mills', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(110, 'Manufacturing, Misc', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(111, 'Marine Transport', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(112, 'Meat processing & products', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(113, 'Medical Supplies', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(114, 'Mining', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(115, 'Misc Business', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(116, 'Misc Finance', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(117, 'Misc Manufacturing & Distributing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(118, 'Misc Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(119, 'Miscellaneous Defense', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(120, 'Miscellaneous Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(121, 'Mortgage Bankers & Brokers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(122, 'Motion Picture Production & Distribution', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(123, 'Music Production', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(124, 'Natural Gas Pipelines', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(125, 'Newspaper, Magazine & Book Publishing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(126, 'Non-profits, Foundations & Philanthropists', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(127, 'Nurses', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(128, 'Nursing Homes/Hospitals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(129, 'Nutritional & Dietary Supplements', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(130, 'Oil & Gas', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(131, 'Other', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(132, 'Payday Lenders', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(133, 'Pharmaceutical Manufacturing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(134, 'Pharmaceuticals / Health Products', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(135, 'Phone Companies', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(136, 'Physicians & Other Health Professionals', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(137, 'Postal Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(138, 'Poultry & Eggs', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(139, 'Power Utilities', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(140, 'Printing & Publishing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(141, 'Private Equity & Investment Firms', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(142, 'Pro-Israel', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(143, 'Professional Sports, Sports Arenas & Related Equipment & Services', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(144, 'Progressive/Democratic', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(145, 'Public Employees', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(146, 'Public Sector Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(147, 'Publishing & Printing', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(148, 'Radio/TV Stations', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(149, 'Railroads', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(150, 'Real Estate', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(151, 'Record Companies/Singers', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(152, 'Recorded Music & Music Production', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(153, 'Recreation / Live Entertainment', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(154, 'Religious Organizations/Clergy', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(155, 'Residential Construction', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(156, 'Restaurants & Drinking Establishments', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(157, 'Retail Sales', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(158, 'Retired', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(159, 'Savings & Loans', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(160, 'Schools/Education', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(161, 'Sea Transport', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(162, 'Securities & Investment', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(163, 'Special Trade Contractors', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(164, 'Sports, Professional', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(165, 'Steel Production', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(166, 'Stock Brokers/Investment Industry', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(167, 'Student Loan Companies', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(168, 'Sugar Cane & Sugar Beets', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(169, 'Teachers Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(170, 'Teachers/Education', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(171, 'Telecom Services & Equipment', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(172, 'Telephone Utilities', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(173, 'Textiles', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(174, 'Timber, Logging & Paper Mills', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(175, 'Tobacco', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(176, 'Transportation', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(177, 'Transportation Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(178, 'Trash Collection/Waste Management', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(179, 'Trucking', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(180, 'TV / Movies / Music', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(181, 'TV Production', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(182, 'Unions', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(183, 'Universities, Colleges & Schools', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(184, 'Vegetables & Fruits', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(185, 'Venture Capital', '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(186, 'Waste Management', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_jobs`
--

CREATE TABLE `tbl_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_lost_reasons`
--

CREATE TABLE `tbl_lost_reasons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `tbl_mailable_templates`
--

CREATE TABLE `tbl_mailable_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `mailable` varchar(191) NOT NULL,
  `locale` varchar(12) NOT NULL DEFAULT 'en',
  `html_template` text NOT NULL,
  `text_template` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_mailable_templates`
--

INSERT INTO `tbl_mailable_templates` (`id`, `name`, `subject`, `mailable`, `locale`, `html_template`, `text_template`) VALUES
(1, 'Activity Reminder', 'Your {{ title }} activity is due on {{ due_date }}', 'App\\Mail\\ActivityReminder', 'en', '<p>Hello {{ assigned }}<br /></p>\r\n                <p>Your {{ title }} activity is due on {{ due_date }}<br /></p>\r\n                <p>{{#action_button}}View Activity{{/action_button}}</p>', NULL),
(2, 'Contact Attends To Activity', 'You have been added as guest to activity', 'App\\Mail\\ContactAttendsToActivity', 'en', '<p>Hello {{ guest_name }}<br /></p>\r\n                <p>You have been added as a guest of the {{ title }} activity.</p>', NULL),
(3, 'Document Accepted', 'Your {{ title }} document has been accepted', 'App\\Mail\\DocumentAccepted', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>Your {{ title }} document has been accepted<br /></p>\r\n                <p>{{#action_button}}View Document{{/action_button}}</p>', NULL),
(4, 'Document Viewed', '{{ title }} document has been viewed', 'App\\Mail\\DocumentViewed', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>The document {{ title }} has been viewed by the customer<br /></p>\r\n                <p>{{#action_button}}View Document{{/action_button}}</p>', NULL),
(5, 'Invitation Created', 'You have been invited to join', 'App\\Mail\\InvitationCreated', 'en', '<p>Hi {{ email }}<br /></p>\r\n                <p>Someone has invited you to access their CRM software.</p>\r\n                <p><a href=\"{{ invitation_url }}\">Click here</a> to activate your account!</p>\r\n                <p>Please note that the link is expires after {{ link_expires_after }} days, so make sure to create the account in {{ link_expires_after }} days.</p>', NULL),
(6, 'Signer Signed Document', 'Your {{ title }} document has been signed', 'App\\Mail\\SignerSignedDocument', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>Your {{ title }} document has been signed by {{ signer_name }}<br /></p>\r\n                <p>{{#action_button}}View Document{{/action_button}}</p>', NULL),
(7, 'User Assigned To Activity', 'You are added as an owner of the activity {{ title }}', 'App\\Mail\\UserAssignedToActivity', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>You have been assigned to activity {{ name }} by {{ assigneer }}<br /></p>\r\n                <p>{{#action_button}}View Activity{{/action_button}}</p>', NULL),
(8, 'User Assigned To Company', 'You are added as an owner of the company {{ name }}', 'App\\Mail\\UserAssignedToCompany', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>You have been assigned to a company {{ name }} by {{ assigneer }}<br /></p>\r\n                <p>{{#action_button}}View Company{{/action_button}}</p>', NULL),
(9, 'User Assigned To Contact', 'You are added as an owner of the contact {{ display_name }}', 'App\\Mail\\UserAssignedToContact', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>You have been assigned to a contact {{ display_name }} by {{ assigneer }}<br /></p>\r\n                <p>{{#action_button}}View Contact{{/action_button}}</p>', NULL),
(10, 'User Assigned To Deal', 'You are added as an owner of the deal {{ name }}', 'App\\Mail\\UserAssignedToDeal', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>You have been assigned to a deal {{ name }} by {{ assigneer }}<br /></p>\r\n                <p>{{#action_button}}View Deal{{/action_button}}</p>', NULL),
(11, 'User Assigned To Document', 'You are added as an owner of the document {{ title }}', 'App\\Mail\\UserAssignedToDocument', 'en', '<p>Hello {{ user }}<br /></p>\r\n                <p>You have been assigned to a document {{ title }} by {{ assigneer }}<br /></p>\r\n                <p>{{#action_button}}View Document{{/action_button}}</p>', NULL),
(12, 'User Attends To Activity', 'You have been added as guest to activity', 'App\\Mail\\UserAttendsToActivity', 'en', '<p>Hello {{ guest_name }}<br /></p>\r\n                <p>You have been added as a guest of the {{ title }} activity<br /></p>\r\n                <p>{{#action_button}}View Activity{{/action_button}}</p>', NULL),
(13, 'User Mentioned', 'You Were Mentioned by {{ user }}', 'App\\Mail\\UserMentioned', 'en', '<p>Hello {{ mentioned_user }}<br /></p>\r\n                <p>{{ user }} mentioned you.<br /></p>\r\n                <p>{{{ action_button }}}<br /></p>', NULL),
(14, 'Web Form Submitted', 'New submission on {{ title }} form', 'App\\Mail\\WebFormSubmitted', 'en', '<p>There is new submission via the {{ title }} web form.<br /><br /></p>\r\n                <p>{{{ payload }}}</p>', NULL);

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

--
-- Table structure for table `tbl_mediables`
--

CREATE TABLE `tbl_mediables` (
  `media_id` int(10) UNSIGNED NOT NULL,
  `mediable_type` varchar(191) NOT NULL,
  `mediable_id` int(10) UNSIGNED NOT NULL,
  `tag` varchar(191) NOT NULL,
  `order` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_message_links_clicks`
--

CREATE TABLE `tbl_message_links_clicks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `url` text DEFAULT NULL,
  `total` int(11) NOT NULL DEFAULT 1,
  `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 `tbl_migrations`
--

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

--
-- Dumping data for table `tbl_migrations`
--

INSERT INTO `tbl_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, '2015_00_00_000000_create_settings_table', 1),
(4, '2016_06_27_000000_create_mediable_tables', 1),
(5, '2017_01_01_000000_create_meta_table', 1),
(6, '2018_07_02_200000_setup_countries_table', 1),
(7, '2018_07_05_082312_create_sources_table', 1),
(8, '2018_07_15_100735_create_filters_table', 1),
(9, '2019_04_21_090707_create_industries_table', 1),
(10, '2019_04_21_090708_create_web_forms_table', 1),
(11, '2019_04_28_161509_create_activity_types_table', 1),
(12, '2019_04_28_161511_create_calendars_table', 1),
(13, '2019_04_28_161512_create_activities_table', 1),
(14, '2019_04_28_161513_create_companies_table', 1),
(15, '2019_04_28_161514_create_contacts_table', 1),
(16, '2019_05_13_104637_create_notes_table', 1),
(17, '2019_05_13_185450_create_activity_log_table', 1),
(18, '2019_05_18_105337_create_notifications_table', 1),
(19, '2019_05_29_162403_create_call_outcomes_table', 1),
(20, '2019_05_29_171102_create_calls_table', 1),
(21, '2019_06_05_112210_create_contactables_table', 1),
(22, '2019_07_09_073408_create_noteables_table', 1),
(23, '2019_07_09_074130_create_callables_table', 1),
(24, '2019_08_07_161510_create_pipelines_table', 1),
(25, '2019_08_07_161618_create_stages_table', 1),
(26, '2019_08_07_161823_create_deals_table', 1),
(27, '2019_08_08_114252_create_dealables_table', 1),
(28, '2019_08_19_000000_create_failed_jobs_table', 1),
(29, '2019_08_27_192356_create_mailable_templates_table', 1),
(30, '2019_09_13_113424_create_email_accounts_table', 1),
(31, '2019_09_16_204831_create_email_account_folders_table', 1),
(32, '2019_09_16_204832_create_email_account_messages_table', 1),
(33, '2019_09_25_080020_create_oauth_accounts_table', 1),
(34, '2019_10_01_161712_create_email_account_message_addresses_table', 1),
(35, '2019_10_13_083732_create_email_account_message_folders_table', 1),
(36, '2019_10_21_163313_create_email_account_messageables_table', 1),
(37, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(38, '2019_12_19_080500_create_email_account_message_headers_table', 1),
(39, '2020_01_24_000000_modify_meta_indexes', 1),
(40, '2020_01_28_143152_create_pending_media_attachments_table', 1),
(41, '2020_02_08_121142_create_predefined_mail_templates_table', 1),
(42, '2020_03_02_110359_create_workflows_table', 1),
(43, '2020_04_04_203752_create_dashboards_table', 1),
(44, '2020_04_19_093541_create_custom_fields_table', 1),
(45, '2020_04_20_093647_create_custom_field_options_table', 1),
(46, '2020_04_20_144421_create_model_has_custom_field_options_table', 1),
(47, '2020_05_05_185254_create_filter_default_views_table', 1),
(48, '2020_06_02_171249_create_zapier_hooks_table', 1),
(49, '2020_06_08_174707_create_cache_table', 1),
(50, '2020_06_10_160037_create_jobs_table', 1),
(51, '2020_08_01_074327_create_pinned_timeline_subjects_table', 1),
(52, '2020_08_02_091659_create_deal_stages_history_table', 1),
(53, '2020_08_18_075822_create_phones_table', 1),
(54, '2020_10_12_000000_add_variants_to_media', 1),
(55, '2020_10_18_071135_add_token_column_to_media_table', 1),
(56, '2020_10_30_081641_create_user_invitations_table', 1),
(57, '2020_11_29_090340_create_products_tables', 1),
(58, '2020_11_29_153456_create_billables_table', 1),
(59, '2020_11_29_153851_create_billable_products_table', 1),
(60, '2021_01_07_084626_create_comments_table', 1),
(61, '2021_01_21_100425_create_guests_table', 1),
(62, '2021_01_21_103751_create_activity_guest_table', 1),
(63, '2021_01_21_104321_create_activityables_table', 1),
(64, '2021_03_09_120940_create_synchronizations_table', 1),
(65, '2021_04_11_105946_create_activity_calendar_sync_table', 1),
(66, '2021_05_08_164518_create_patches_table', 1),
(67, '2021_09_01_075134_create_permission_tables', 1),
(68, '2021_10_20_155601_create_imports_table', 1),
(69, '2022_06_18_105721_create_teams_table', 1),
(70, '2022_06_18_105827_create_team_user_table', 1),
(71, '2022_06_20_140805_create_model_visibility_groups_table', 1),
(72, '2022_06_20_144603_create_model_visibility_group_dependents_table', 1),
(73, '2022_06_21_134625_create_user_ordered_models_table', 1),
(74, '2022_06_27_094921_add_teams_column_to_user_invitations_table', 1),
(75, '2022_07_01_150731_create_lost_reasons_table', 1),
(76, '2022_07_24_120703_create_document_types_table', 1),
(77, '2022_07_24_12072_create_brands_table', 1),
(78, '2022_07_24_120806_create_documents_table', 1),
(79, '2022_07_25_132129_create_document_signers_table', 1),
(80, '2022_07_25_143144_create_documentables_table', 1),
(81, '2022_07_26_101222_create_document_templates_table', 1),
(82, '2022_08_30_154952_create_views_table', 1),
(83, '2022_12_07_120547_create_message_links_clicks_table', 1);

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

--
-- Table structure for table `tbl_model_has_custom_field_options`
--

CREATE TABLE `tbl_model_has_custom_field_options` (
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `custom_field_id` bigint(20) UNSIGNED NOT NULL,
  `option_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_model_has_permissions`
--

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

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

--
-- Table structure for table `tbl_model_has_roles`
--

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

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

--
-- Table structure for table `tbl_model_visibility_groups`
--

CREATE TABLE `tbl_model_visibility_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(60) NOT NULL,
  `visibilityable_type` varchar(191) NOT NULL,
  `visibilityable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_model_visibility_group_dependents`
--

CREATE TABLE `tbl_model_visibility_group_dependents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_visibility_group_id` bigint(20) UNSIGNED NOT NULL,
  `dependable_type` varchar(191) NOT NULL,
  `dependable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_noteables`
--

CREATE TABLE `tbl_noteables` (
  `note_id` bigint(20) UNSIGNED NOT NULL,
  `noteable_type` varchar(191) NOT NULL,
  `noteable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_notes`
--

CREATE TABLE `tbl_notes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `body` text 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 `tbl_notifications`
--

CREATE TABLE `tbl_notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_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 `tbl_pending_media_attachments`
--

CREATE TABLE `tbl_pending_media_attachments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `draft_id` varchar(191) NOT NULL,
  `media_id` bigint(20) UNSIGNED 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 `tbl_permissions`
--

CREATE TABLE `tbl_permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) 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 `tbl_phones`
--

CREATE TABLE `tbl_phones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` varchar(191) NOT NULL,
  `type` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `phoneable_type` varchar(191) NOT NULL,
  `phoneable_id` bigint(20) UNSIGNED 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 `tbl_phones`
--

INSERT INTO `tbl_phones` (`id`, `number`, `type`, `phoneable_type`, `phoneable_id`, `created_at`, `updated_at`) VALUES
(1, '+255756444655', 1, 'App\\Models\\Contact', 1, '2023-05-22 11:50:27', '2023-05-22 11:50:27');

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

--
-- Table structure for table `tbl_pinned_timeline_subjects`
--

CREATE TABLE `tbl_pinned_timeline_subjects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subject_type` varchar(191) NOT NULL,
  `subject_id` bigint(20) UNSIGNED NOT NULL,
  `timelineable_type` varchar(191) NOT NULL,
  `timelineable_id` bigint(20) UNSIGNED 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 `tbl_pipelines`
--

CREATE TABLE `tbl_pipelines` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `flag` varchar(50) DEFAULT 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 `tbl_pipelines`
--

INSERT INTO `tbl_pipelines` (`id`, `name`, `flag`, `created_at`, `updated_at`) VALUES
(1, 'Sales Pipeline', 'default', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_predefined_mail_templates`
--

CREATE TABLE `tbl_predefined_mail_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `body` text NOT NULL,
  `is_shared` tinyint(1) NOT NULL DEFAULT 1,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Owner',
  `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 `tbl_products`
--

CREATE TABLE `tbl_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `unit_price` decimal(15,3) NOT NULL,
  `direct_cost` decimal(15,3) DEFAULT NULL,
  `unit` varchar(191) DEFAULT NULL,
  `tax_rate` decimal(15,3) NOT NULL DEFAULT 0.000,
  `tax_label` varchar(191) NOT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` bigint(20) UNSIGNED NOT 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 `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) 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 `tbl_role_has_permissions`
--

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

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

--
-- Table structure for table `tbl_sources`
--

CREATE TABLE `tbl_sources` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `flag` varchar(50) DEFAULT 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 `tbl_sources`
--

INSERT INTO `tbl_sources` (`id`, `name`, `flag`, `created_at`, `updated_at`) VALUES
(1, 'Organic search', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'Paid search', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'Email marketing', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(4, 'Social media', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(5, 'Referrals', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(6, 'Other campaigns', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(7, 'Direct traffic', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(8, 'Offline Source', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(9, 'Paid social', NULL, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(10, 'Web Form', 'web-form', '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_stages`
--

CREATE TABLE `tbl_stages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `win_probability` int(10) UNSIGNED NOT NULL DEFAULT 100,
  `display_order` int(10) UNSIGNED DEFAULT NULL,
  `pipeline_id` bigint(20) UNSIGNED 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 `tbl_stages`
--

INSERT INTO `tbl_stages` (`id`, `name`, `win_probability`, `display_order`, `pipeline_id`, `created_at`, `updated_at`) VALUES
(1, 'Qualified To Buy', 100, 1, 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(2, 'Contact Made', 100, 2, 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(3, 'Presentation Scheduled', 100, 3, 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(4, 'Proposal Made', 100, 4, 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37'),
(5, 'Appointment Scheduled', 100, 5, 1, '2023-05-18 19:30:37', '2023-05-18 19:30:37');

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

--
-- Table structure for table `tbl_teams`
--

CREATE TABLE `tbl_teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Manager',
  `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 `tbl_team_user`
--

CREATE TABLE `tbl_team_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `team_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED 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 `tbl_user_ordered_models`
--

CREATE TABLE `tbl_user_ordered_models` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `display_order` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `orderable_type` varchar(191) NOT NULL,
  `orderable_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_views`
--

CREATE TABLE `tbl_views` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `viewable_type` varchar(191) NOT NULL,
  `viewable_id` bigint(20) UNSIGNED NOT NULL,
  `visitor` text DEFAULT NULL,
  `collection` varchar(191) DEFAULT NULL,
  `viewed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbl_web_forms`
--

CREATE TABLE `tbl_web_forms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `uuid` char(36) NOT NULL,
  `title_prefix` varchar(191) DEFAULT NULL,
  `sections` text NOT NULL,
  `notifications` text DEFAULT NULL,
  `styles` text NOT NULL,
  `submit_data` text NOT NULL,
  `total_submissions` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `locale` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL COMMENT 'Owner',
  `created_by` bigint(20) UNSIGNED 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 `tbl_workflows`
--

CREATE TABLE `tbl_workflows` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `trigger_type` varchar(191) NOT NULL,
  `action_type` varchar(191) NOT NULL,
  `data` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `total_executions` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_by` bigint(20) UNSIGNED 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 `tbl_zapier_hooks`
--

CREATE TABLE `tbl_zapier_hooks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hook` varchar(191) NOT NULL,
  `resource_name` varchar(191) NOT NULL,
  `action` varchar(191) NOT NULL,
  `data` text DEFAULT NULL,
  `zap_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_activities`
--
ALTER TABLE `tbl_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_activities_user_id_foreign` (`user_id`),
  ADD KEY `tbl_activities_activity_type_id_foreign` (`activity_type_id`),
  ADD KEY `tbl_activities_created_by_foreign` (`created_by`),
  ADD KEY `tbl_activities_due_date_index` (`due_date`),
  ADD KEY `tbl_activities_due_time_index` (`due_time`),
  ADD KEY `tbl_activities_end_time_index` (`end_time`),
  ADD KEY `tbl_activities_end_date_index` (`end_date`),
  ADD KEY `tbl_activities_reminder_at_index` (`reminder_at`),
  ADD KEY `tbl_activities_completed_at_index` (`completed_at`);

--
-- Indexes for table `tbl_activityables`
--
ALTER TABLE `tbl_activityables`
  ADD PRIMARY KEY (`activity_id`,`activityable_id`,`activityable_type`),
  ADD KEY `tbl_activityables_activityable_type_activityable_id_index` (`activityable_type`,`activityable_id`);

--
-- Indexes for table `tbl_activity_calendar_sync`
--
ALTER TABLE `tbl_activity_calendar_sync`
  ADD KEY `tbl_activity_calendar_sync_activity_id_foreign` (`activity_id`),
  ADD KEY `tbl_activity_calendar_sync_calendar_id_foreign` (`calendar_id`),
  ADD KEY `tbl_activity_calendar_sync_event_id_index` (`event_id`),
  ADD KEY `tbl_activity_calendar_sync_icaluid_index` (`icaluid`),
  ADD KEY `tbl_activity_calendar_sync_synchronized_at_index` (`synchronized_at`);

--
-- Indexes for table `tbl_activity_guest`
--
ALTER TABLE `tbl_activity_guest`
  ADD KEY `tbl_activity_guest_activity_id_foreign` (`activity_id`),
  ADD KEY `tbl_activity_guest_guest_id_foreign` (`guest_id`);

--
-- Indexes for table `tbl_activity_types`
--
ALTER TABLE `tbl_activity_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_activity_types_name_unique` (`name`),
  ADD UNIQUE KEY `tbl_activity_types_icon_unique` (`icon`),
  ADD UNIQUE KEY `tbl_activity_types_flag_unique` (`flag`);

--
-- Indexes for table `tbl_billables`
--
ALTER TABLE `tbl_billables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_billables_billableable_type_billableable_id_index` (`billableable_type`,`billableable_id`);

--
-- Indexes for table `tbl_billable_products`
--
ALTER TABLE `tbl_billable_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_billable_products_billable_id_foreign` (`billable_id`),
  ADD KEY `tbl_billable_products_product_id_foreign` (`product_id`),
  ADD KEY `tbl_billable_products_amount_index` (`amount`),
  ADD KEY `tbl_billable_products_display_order_index` (`display_order`);

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

--
-- Indexes for table `tbl_callables`
--
ALTER TABLE `tbl_callables`
  ADD PRIMARY KEY (`call_id`,`callable_id`,`callable_type`),
  ADD KEY `tbl_callables_callable_type_callable_id_index` (`callable_type`,`callable_id`);

--
-- Indexes for table `tbl_calls`
--
ALTER TABLE `tbl_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_calls_user_id_foreign` (`user_id`),
  ADD KEY `tbl_calls_call_outcome_id_foreign` (`call_outcome_id`);

--
-- Indexes for table `tbl_call_outcomes`
--
ALTER TABLE `tbl_call_outcomes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_call_outcomes_name_unique` (`name`);

--
-- Indexes for table `tbl_changelog`
--
ALTER TABLE `tbl_changelog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject` (`subject_type`,`subject_id`),
  ADD KEY `causer` (`causer_type`,`causer_id`),
  ADD KEY `tbl_changelog_log_name_index` (`log_name`);

--
-- Indexes for table `tbl_comments`
--
ALTER TABLE `tbl_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_comments_created_by_foreign` (`created_by`),
  ADD KEY `tbl_comments_commentable_type_commentable_id_index` (`commentable_type`,`commentable_id`);

--
-- Indexes for table `tbl_companies`
--
ALTER TABLE `tbl_companies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_companies_user_id_foreign` (`user_id`),
  ADD KEY `tbl_companies_source_id_foreign` (`source_id`),
  ADD KEY `tbl_companies_industry_id_foreign` (`industry_id`),
  ADD KEY `tbl_companies_parent_company_id_foreign` (`parent_company_id`),
  ADD KEY `tbl_companies_country_id_foreign` (`country_id`),
  ADD KEY `tbl_companies_created_by_foreign` (`created_by`),
  ADD KEY `tbl_companies_next_activity_id_foreign` (`next_activity_id`),
  ADD KEY `tbl_companies_name_index` (`name`),
  ADD KEY `tbl_companies_email_index` (`email`),
  ADD KEY `tbl_companies_domain_index` (`domain`);

--
-- Indexes for table `tbl_contactables`
--
ALTER TABLE `tbl_contactables`
  ADD PRIMARY KEY (`contact_id`,`contactable_id`,`contactable_type`),
  ADD KEY `tbl_contactables_contactable_type_contactable_id_index` (`contactable_type`,`contactable_id`);

--
-- Indexes for table `tbl_contacts`
--
ALTER TABLE `tbl_contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_contacts_user_id_foreign` (`user_id`),
  ADD KEY `tbl_contacts_source_id_foreign` (`source_id`),
  ADD KEY `tbl_contacts_country_id_foreign` (`country_id`),
  ADD KEY `tbl_contacts_created_by_foreign` (`created_by`),
  ADD KEY `tbl_contacts_next_activity_id_foreign` (`next_activity_id`),
  ADD KEY `tbl_contacts_email_index` (`email`);

--
-- Indexes for table `tbl_countries`
--
ALTER TABLE `tbl_countries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_countries_id_index` (`id`);

--
-- Indexes for table `tbl_custom_fields`
--
ALTER TABLE `tbl_custom_fields`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_custom_fields_resource_name_field_id_unique` (`resource_name`,`field_id`);

--
-- Indexes for table `tbl_custom_field_options`
--
ALTER TABLE `tbl_custom_field_options`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_custom_field_options_custom_field_id_name_unique` (`custom_field_id`,`name`),
  ADD KEY `tbl_custom_field_options_display_order_index` (`display_order`);

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

--
-- Indexes for table `tbl_dealables`
--
ALTER TABLE `tbl_dealables`
  ADD PRIMARY KEY (`deal_id`,`dealable_id`,`dealable_type`),
  ADD KEY `tbl_dealables_dealable_type_dealable_id_index` (`dealable_type`,`dealable_id`);

--
-- Indexes for table `tbl_deals`
--
ALTER TABLE `tbl_deals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_deals_pipeline_id_foreign` (`pipeline_id`),
  ADD KEY `tbl_deals_stage_id_foreign` (`stage_id`),
  ADD KEY `tbl_deals_user_id_foreign` (`user_id`),
  ADD KEY `tbl_deals_created_by_foreign` (`created_by`),
  ADD KEY `tbl_deals_web_form_id_foreign` (`web_form_id`),
  ADD KEY `tbl_deals_next_activity_id_foreign` (`next_activity_id`),
  ADD KEY `tbl_deals_status_index` (`status`),
  ADD KEY `tbl_deals_won_date_index` (`won_date`),
  ADD KEY `tbl_deals_lost_date_index` (`lost_date`),
  ADD KEY `tbl_deals_lost_reason_index` (`lost_reason`),
  ADD KEY `tbl_deals_expected_close_date_index` (`expected_close_date`),
  ADD KEY `tbl_deals_amount_index` (`amount`),
  ADD KEY `tbl_deals_board_order_index` (`board_order`);

--
-- Indexes for table `tbl_deal_stages_history`
--
ALTER TABLE `tbl_deal_stages_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_deal_stages_history_stage_id_foreign` (`stage_id`),
  ADD KEY `tbl_deal_stages_history_deal_id_stage_id_index` (`deal_id`,`stage_id`),
  ADD KEY `tbl_deal_stages_history_entered_at_index` (`entered_at`),
  ADD KEY `tbl_deal_stages_history_left_at_index` (`left_at`);

--
-- Indexes for table `tbl_documentables`
--
ALTER TABLE `tbl_documentables`
  ADD PRIMARY KEY (`document_id`,`documentable_id`,`documentable_type`),
  ADD KEY `tbl_documentables_documentable_type_documentable_id_index` (`documentable_type`,`documentable_id`);

--
-- Indexes for table `tbl_documents`
--
ALTER TABLE `tbl_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_documents_document_type_id_foreign` (`document_type_id`),
  ADD KEY `tbl_documents_marked_accepted_by_foreign` (`marked_accepted_by`),
  ADD KEY `tbl_documents_sent_by_foreign` (`sent_by`),
  ADD KEY `tbl_documents_approved_by_foreign` (`approved_by`),
  ADD KEY `tbl_documents_brand_id_foreign` (`brand_id`),
  ADD KEY `tbl_documents_user_id_foreign` (`user_id`),
  ADD KEY `tbl_documents_created_by_foreign` (`created_by`),
  ADD KEY `tbl_documents_amount_index` (`amount`),
  ADD KEY `tbl_documents_status_index` (`status`);

--
-- Indexes for table `tbl_document_signers`
--
ALTER TABLE `tbl_document_signers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_document_signers_document_id_email_unique` (`document_id`,`email`);

--
-- Indexes for table `tbl_document_templates`
--
ALTER TABLE `tbl_document_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_document_templates_name_unique` (`name`),
  ADD KEY `tbl_document_templates_user_id_foreign` (`user_id`);

--
-- Indexes for table `tbl_document_types`
--
ALTER TABLE `tbl_document_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_document_types_name_unique` (`name`),
  ADD UNIQUE KEY `tbl_document_types_flag_unique` (`flag`);

--
-- Indexes for table `tbl_email_account_folders`
--
ALTER TABLE `tbl_email_account_folders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_email_account_folders_email_account_id_foreign` (`email_account_id`);

--
-- Indexes for table `tbl_email_account_messageables`
--
ALTER TABLE `tbl_email_account_messageables`
  ADD PRIMARY KEY (`message_id`,`messageable_id`,`messageable_type`),
  ADD KEY `email_account_messageables_index` (`messageable_type`,`messageable_id`);

--
-- Indexes for table `tbl_email_account_message_addresses`
--
ALTER TABLE `tbl_email_account_message_addresses`
  ADD KEY `tbl_email_account_message_addresses_message_id_foreign` (`message_id`);

--
-- Indexes for table `tbl_email_account_message_folders`
--
ALTER TABLE `tbl_email_account_message_folders`
  ADD KEY `tbl_email_account_message_folders_message_id_foreign` (`message_id`),
  ADD KEY `tbl_email_account_message_folders_folder_id_foreign` (`folder_id`);

--
-- Indexes for table `tbl_email_account_message_headers`
--
ALTER TABLE `tbl_email_account_message_headers`
  ADD KEY `tbl_email_account_message_headers_message_id_foreign` (`message_id`);

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

--
-- Indexes for table `tbl_filters`
--
ALTER TABLE `tbl_filters`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_filters_flag_unique` (`flag`),
  ADD KEY `tbl_filters_user_id_foreign` (`user_id`),
  ADD KEY `tbl_filters_identifier_index` (`identifier`);

--
-- Indexes for table `tbl_filter_default_views`
--
ALTER TABLE `tbl_filter_default_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_filter_default_views_filter_id_foreign` (`filter_id`),
  ADD KEY `tbl_filter_default_views_user_id_foreign` (`user_id`);

--
-- Indexes for table `tbl_guests`
--
ALTER TABLE `tbl_guests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_guests_guestable_type_guestable_id_index` (`guestable_type`,`guestable_id`);

--
-- Indexes for table `tbl_imports`
--
ALTER TABLE `tbl_imports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_imports_user_id_foreign` (`user_id`),
  ADD KEY `tbl_imports_status_index` (`status`);

--
-- Indexes for table `tbl_industries`
--
ALTER TABLE `tbl_industries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_industries_name_unique` (`name`);

--
-- Indexes for table `tbl_jobs`
--
ALTER TABLE `tbl_jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_jobs_queue_index` (`queue`);

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

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

--
-- Indexes for table `tbl_mediables`
--
ALTER TABLE `tbl_mediables`
  ADD PRIMARY KEY (`media_id`,`mediable_type`,`mediable_id`,`tag`),
  ADD KEY `tbl_mediables_mediable_id_mediable_type_index` (`mediable_id`,`mediable_type`),
  ADD KEY `tbl_mediables_tag_index` (`tag`),
  ADD KEY `tbl_mediables_order_index` (`order`);

--
-- Indexes for table `tbl_message_links_clicks`
--
ALTER TABLE `tbl_message_links_clicks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_message_links_clicks_message_id_foreign` (`message_id`);

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

--
-- Indexes for table `tbl_model_has_custom_field_options`
--
ALTER TABLE `tbl_model_has_custom_field_options`
  ADD KEY `tbl_model_has_custom_field_options_model_id_model_type_index` (`model_id`,`model_type`),
  ADD KEY `tbl_model_has_custom_field_options_custom_field_id_foreign` (`custom_field_id`),
  ADD KEY `tbl_model_has_custom_field_options_option_id_foreign` (`option_id`);

--
-- Indexes for table `tbl_model_has_permissions`
--
ALTER TABLE `tbl_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 `tbl_model_has_roles`
--
ALTER TABLE `tbl_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 `tbl_model_visibility_groups`
--
ALTER TABLE `tbl_model_visibility_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visibilityable_index` (`visibilityable_type`,`visibilityable_id`);

--
-- Indexes for table `tbl_model_visibility_group_dependents`
--
ALTER TABLE `tbl_model_visibility_group_dependents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visibility_group_id_foreign` (`model_visibility_group_id`),
  ADD KEY `dependable_index` (`dependable_type`,`dependable_id`);

--
-- Indexes for table `tbl_noteables`
--
ALTER TABLE `tbl_noteables`
  ADD PRIMARY KEY (`note_id`,`noteable_id`,`noteable_type`),
  ADD KEY `tbl_noteables_noteable_type_noteable_id_index` (`noteable_type`,`noteable_id`);

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

--
-- Indexes for table `tbl_notifications`
--
ALTER TABLE `tbl_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `tbl_pending_media_attachments`
--
ALTER TABLE `tbl_pending_media_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_pending_media_attachments_draft_id_index` (`draft_id`);

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

--
-- Indexes for table `tbl_phones`
--
ALTER TABLE `tbl_phones`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_phones_phoneable_type_phoneable_id_index` (`phoneable_type`,`phoneable_id`);

--
-- Indexes for table `tbl_pinned_timeline_subjects`
--
ALTER TABLE `tbl_pinned_timeline_subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_pinned_timeline_subjects_subject_type_subject_id_index` (`subject_type`,`subject_id`),
  ADD KEY `timelineable_type_timelineable_id_index` (`timelineable_type`,`timelineable_id`);

--
-- Indexes for table `tbl_pipelines`
--
ALTER TABLE `tbl_pipelines`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_pipelines_name_unique` (`name`),
  ADD UNIQUE KEY `tbl_pipelines_flag_unique` (`flag`);

--
-- Indexes for table `tbl_predefined_mail_templates`
--
ALTER TABLE `tbl_predefined_mail_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_predefined_mail_templates_name_unique` (`name`),
  ADD KEY `tbl_predefined_mail_templates_user_id_foreign` (`user_id`);

--
-- Indexes for table `tbl_products`
--
ALTER TABLE `tbl_products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_products_name_unique` (`name`),
  ADD UNIQUE KEY `tbl_products_sku_unique` (`sku`),
  ADD KEY `tbl_products_created_by_foreign` (`created_by`),
  ADD KEY `tbl_products_is_active_index` (`is_active`);

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

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

--
-- Indexes for table `tbl_sources`
--
ALTER TABLE `tbl_sources`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_sources_name_unique` (`name`),
  ADD UNIQUE KEY `tbl_sources_flag_unique` (`flag`);

--
-- Indexes for table `tbl_stages`
--
ALTER TABLE `tbl_stages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_stages_name_pipeline_id_unique` (`name`,`pipeline_id`),
  ADD KEY `tbl_stages_pipeline_id_foreign` (`pipeline_id`),
  ADD KEY `tbl_stages_display_order_index` (`display_order`);

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

--
-- Indexes for table `tbl_team_user`
--
ALTER TABLE `tbl_team_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tbl_team_user_team_id_user_id_unique` (`team_id`,`user_id`),
  ADD KEY `tbl_team_user_user_id_foreign` (`user_id`);

--
-- Indexes for table `tbl_user_ordered_models`
--
ALTER TABLE `tbl_user_ordered_models`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_order` (`user_id`,`orderable_id`,`orderable_type`),
  ADD KEY `tbl_user_ordered_models_orderable_type_orderable_id_index` (`orderable_type`,`orderable_id`),
  ADD KEY `tbl_user_ordered_models_display_order_index` (`display_order`);

--
-- Indexes for table `tbl_views`
--
ALTER TABLE `tbl_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_views_viewable_type_viewable_id_index` (`viewable_type`,`viewable_id`);

--
-- Indexes for table `tbl_web_forms`
--
ALTER TABLE `tbl_web_forms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_web_forms_user_id_foreign` (`user_id`),
  ADD KEY `tbl_web_forms_created_by_foreign` (`created_by`);

--
-- Indexes for table `tbl_workflows`
--
ALTER TABLE `tbl_workflows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_workflows_created_by_foreign` (`created_by`);

--
-- Indexes for table `tbl_zapier_hooks`
--
ALTER TABLE `tbl_zapier_hooks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tbl_zapier_hooks_zap_id_index` (`zap_id`),
  ADD KEY `tbl_zapier_hooks_user_id_index` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_activities`
--
ALTER TABLE `tbl_activities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_activity_types`
--
ALTER TABLE `tbl_activity_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_billables`
--
ALTER TABLE `tbl_billables`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_billable_products`
--
ALTER TABLE `tbl_billable_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_brands`
--
ALTER TABLE `tbl_brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_calls`
--
ALTER TABLE `tbl_calls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_call_outcomes`
--
ALTER TABLE `tbl_call_outcomes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_changelog`
--
ALTER TABLE `tbl_changelog`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_comments`
--
ALTER TABLE `tbl_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_companies`
--
ALTER TABLE `tbl_companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_contacts`
--
ALTER TABLE `tbl_contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_custom_fields`
--
ALTER TABLE `tbl_custom_fields`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_custom_field_options`
--
ALTER TABLE `tbl_custom_field_options`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_dashboards`
--
ALTER TABLE `tbl_dashboards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_deals`
--
ALTER TABLE `tbl_deals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_deal_stages_history`
--
ALTER TABLE `tbl_deal_stages_history`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_documents`
--
ALTER TABLE `tbl_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_document_signers`
--
ALTER TABLE `tbl_document_signers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_document_templates`
--
ALTER TABLE `tbl_document_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_document_types`
--
ALTER TABLE `tbl_document_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_email_account_folders`
--
ALTER TABLE `tbl_email_account_folders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_failed_jobs`
--
ALTER TABLE `tbl_failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_filters`
--
ALTER TABLE `tbl_filters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_filter_default_views`
--
ALTER TABLE `tbl_filter_default_views`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_guests`
--
ALTER TABLE `tbl_guests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_imports`
--
ALTER TABLE `tbl_imports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_industries`
--
ALTER TABLE `tbl_industries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=187;

--
-- AUTO_INCREMENT for table `tbl_jobs`
--
ALTER TABLE `tbl_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_lost_reasons`
--
ALTER TABLE `tbl_lost_reasons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_mailable_templates`
--
ALTER TABLE `tbl_mailable_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_message_links_clicks`
--
ALTER TABLE `tbl_message_links_clicks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_migrations`
--
ALTER TABLE `tbl_migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `tbl_model_visibility_groups`
--
ALTER TABLE `tbl_model_visibility_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_model_visibility_group_dependents`
--
ALTER TABLE `tbl_model_visibility_group_dependents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_notes`
--
ALTER TABLE `tbl_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_pending_media_attachments`
--
ALTER TABLE `tbl_pending_media_attachments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_permissions`
--
ALTER TABLE `tbl_permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_phones`
--
ALTER TABLE `tbl_phones`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_pinned_timeline_subjects`
--
ALTER TABLE `tbl_pinned_timeline_subjects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_pipelines`
--
ALTER TABLE `tbl_pipelines`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_predefined_mail_templates`
--
ALTER TABLE `tbl_predefined_mail_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_products`
--
ALTER TABLE `tbl_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_roles`
--
ALTER TABLE `tbl_roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_sources`
--
ALTER TABLE `tbl_sources`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_stages`
--
ALTER TABLE `tbl_stages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_teams`
--
ALTER TABLE `tbl_teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_team_user`
--
ALTER TABLE `tbl_team_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_user_ordered_models`
--
ALTER TABLE `tbl_user_ordered_models`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_views`
--
ALTER TABLE `tbl_views`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_web_forms`
--
ALTER TABLE `tbl_web_forms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_workflows`
--
ALTER TABLE `tbl_workflows`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_zapier_hooks`
--
ALTER TABLE `tbl_zapier_hooks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `tbl_activities`
--
ALTER TABLE `tbl_activities`
  ADD CONSTRAINT `tbl_activities_activity_type_id_foreign` FOREIGN KEY (`activity_type_id`) REFERENCES `tbl_activity_types` (`id`),
  ADD CONSTRAINT `tbl_activities_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_activities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_activityables`
--
ALTER TABLE `tbl_activityables`
  ADD CONSTRAINT `tbl_activityables_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `tbl_activities` (`id`);

--
-- Constraints for table `tbl_activity_calendar_sync`
--
ALTER TABLE `tbl_activity_calendar_sync`
  ADD CONSTRAINT `tbl_activity_calendar_sync_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `tbl_activities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_activity_calendar_sync_calendar_id_foreign` FOREIGN KEY (`calendar_id`) REFERENCES `tbl_calendars` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_activity_guest`
--
ALTER TABLE `tbl_activity_guest`
  ADD CONSTRAINT `tbl_activity_guest_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `tbl_activities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_activity_guest_guest_id_foreign` FOREIGN KEY (`guest_id`) REFERENCES `tbl_guests` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_billable_products`
--
ALTER TABLE `tbl_billable_products`
  ADD CONSTRAINT `tbl_billable_products_billable_id_foreign` FOREIGN KEY (`billable_id`) REFERENCES `tbl_billables` (`id`),
  ADD CONSTRAINT `tbl_billable_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `tbl_products` (`id`);

--
-- Constraints for table `tbl_callables`
--
ALTER TABLE `tbl_callables`
  ADD CONSTRAINT `tbl_callables_call_id_foreign` FOREIGN KEY (`call_id`) REFERENCES `tbl_calls` (`id`);

--
-- Constraints for table `tbl_calls`
--
ALTER TABLE `tbl_calls`
  ADD CONSTRAINT `tbl_calls_call_outcome_id_foreign` FOREIGN KEY (`call_outcome_id`) REFERENCES `tbl_call_outcomes` (`id`),
  ADD CONSTRAINT `tbl_calls_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_comments`
--
ALTER TABLE `tbl_comments`
  ADD CONSTRAINT `tbl_comments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_companies`
--
ALTER TABLE `tbl_companies`
  ADD CONSTRAINT `tbl_companies_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `tbl_countries` (`id`),
  ADD CONSTRAINT `tbl_companies_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_companies_industry_id_foreign` FOREIGN KEY (`industry_id`) REFERENCES `tbl_industries` (`id`),
  ADD CONSTRAINT `tbl_companies_next_activity_id_foreign` FOREIGN KEY (`next_activity_id`) REFERENCES `tbl_activities` (`id`),
  ADD CONSTRAINT `tbl_companies_parent_company_id_foreign` FOREIGN KEY (`parent_company_id`) REFERENCES `tbl_companies` (`id`),
  ADD CONSTRAINT `tbl_companies_source_id_foreign` FOREIGN KEY (`source_id`) REFERENCES `tbl_sources` (`id`),
  ADD CONSTRAINT `tbl_companies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_contactables`
--
ALTER TABLE `tbl_contactables`
  ADD CONSTRAINT `tbl_contactables_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `tbl_contacts` (`id`);

--
-- Constraints for table `tbl_contacts`
--
ALTER TABLE `tbl_contacts`
  ADD CONSTRAINT `tbl_contacts_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `tbl_countries` (`id`),
  ADD CONSTRAINT `tbl_contacts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_contacts_next_activity_id_foreign` FOREIGN KEY (`next_activity_id`) REFERENCES `tbl_activities` (`id`),
  ADD CONSTRAINT `tbl_contacts_source_id_foreign` FOREIGN KEY (`source_id`) REFERENCES `tbl_sources` (`id`),
  ADD CONSTRAINT `tbl_contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_custom_field_options`
--
ALTER TABLE `tbl_custom_field_options`
  ADD CONSTRAINT `tbl_custom_field_options_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `tbl_custom_fields` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_dealables`
--
ALTER TABLE `tbl_dealables`
  ADD CONSTRAINT `tbl_dealables_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `tbl_deals` (`id`);

--
-- Constraints for table `tbl_deals`
--
ALTER TABLE `tbl_deals`
  ADD CONSTRAINT `tbl_deals_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_deals_next_activity_id_foreign` FOREIGN KEY (`next_activity_id`) REFERENCES `tbl_activities` (`id`),
  ADD CONSTRAINT `tbl_deals_pipeline_id_foreign` FOREIGN KEY (`pipeline_id`) REFERENCES `tbl_pipelines` (`id`),
  ADD CONSTRAINT `tbl_deals_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `tbl_stages` (`id`),
  ADD CONSTRAINT `tbl_deals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_deals_web_form_id_foreign` FOREIGN KEY (`web_form_id`) REFERENCES `tbl_web_forms` (`id`);

--
-- Constraints for table `tbl_deal_stages_history`
--
ALTER TABLE `tbl_deal_stages_history`
  ADD CONSTRAINT `tbl_deal_stages_history_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `tbl_deals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_deal_stages_history_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `tbl_stages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_documentables`
--
ALTER TABLE `tbl_documentables`
  ADD CONSTRAINT `tbl_documentables_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `tbl_documents` (`id`);

--
-- Constraints for table `tbl_documents`
--
ALTER TABLE `tbl_documents`
  ADD CONSTRAINT `tbl_documents_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_documents_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `tbl_brands` (`id`),
  ADD CONSTRAINT `tbl_documents_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_documents_document_type_id_foreign` FOREIGN KEY (`document_type_id`) REFERENCES `tbl_document_types` (`id`),
  ADD CONSTRAINT `tbl_documents_marked_accepted_by_foreign` FOREIGN KEY (`marked_accepted_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_documents_sent_by_foreign` FOREIGN KEY (`sent_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_documents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_document_signers`
--
ALTER TABLE `tbl_document_signers`
  ADD CONSTRAINT `tbl_document_signers_document_id_foreign` FOREIGN KEY (`document_id`) REFERENCES `tbl_documents` (`id`);

--
-- Constraints for table `tbl_document_templates`
--
ALTER TABLE `tbl_document_templates`
  ADD CONSTRAINT `tbl_document_templates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_email_account_folders`
--
ALTER TABLE `tbl_email_account_folders`
  ADD CONSTRAINT `tbl_email_account_folders_email_account_id_foreign` FOREIGN KEY (`email_account_id`) REFERENCES `tbl_email_accounts` (`id`);

--
-- Constraints for table `tbl_email_account_messageables`
--
ALTER TABLE `tbl_email_account_messageables`
  ADD CONSTRAINT `tbl_email_account_messageables_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `tbl_email_account_messages` (`id`);

--
-- Constraints for table `tbl_email_account_message_addresses`
--
ALTER TABLE `tbl_email_account_message_addresses`
  ADD CONSTRAINT `tbl_email_account_message_addresses_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `tbl_email_account_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_email_account_message_folders`
--
ALTER TABLE `tbl_email_account_message_folders`
  ADD CONSTRAINT `tbl_email_account_message_folders_folder_id_foreign` FOREIGN KEY (`folder_id`) REFERENCES `tbl_email_account_folders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_email_account_message_folders_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `tbl_email_account_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_email_account_message_headers`
--
ALTER TABLE `tbl_email_account_message_headers`
  ADD CONSTRAINT `tbl_email_account_message_headers_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `tbl_email_account_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_filters`
--
ALTER TABLE `tbl_filters`
  ADD CONSTRAINT `tbl_filters_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_filter_default_views`
--
ALTER TABLE `tbl_filter_default_views`
  ADD CONSTRAINT `tbl_filter_default_views_filter_id_foreign` FOREIGN KEY (`filter_id`) REFERENCES `tbl_filters` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_filter_default_views_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_imports`
--
ALTER TABLE `tbl_imports`
  ADD CONSTRAINT `tbl_imports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_mediables`
--
ALTER TABLE `tbl_mediables`
  ADD CONSTRAINT `tbl_mediables_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `tbl_media` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_message_links_clicks`
--
ALTER TABLE `tbl_message_links_clicks`
  ADD CONSTRAINT `tbl_message_links_clicks_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `tbl_email_account_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_model_has_custom_field_options`
--
ALTER TABLE `tbl_model_has_custom_field_options`
  ADD CONSTRAINT `tbl_model_has_custom_field_options_custom_field_id_foreign` FOREIGN KEY (`custom_field_id`) REFERENCES `tbl_custom_fields` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_model_has_custom_field_options_option_id_foreign` FOREIGN KEY (`option_id`) REFERENCES `tbl_custom_field_options` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_model_has_permissions`
--
ALTER TABLE `tbl_model_has_permissions`
  ADD CONSTRAINT `tbl_model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `tbl_permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_model_has_roles`
--
ALTER TABLE `tbl_model_has_roles`
  ADD CONSTRAINT `tbl_model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `tbl_roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_model_visibility_group_dependents`
--
ALTER TABLE `tbl_model_visibility_group_dependents`
  ADD CONSTRAINT `visibility_group_id_foreign` FOREIGN KEY (`model_visibility_group_id`) REFERENCES `tbl_model_visibility_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_noteables`
--
ALTER TABLE `tbl_noteables`
  ADD CONSTRAINT `tbl_noteables_note_id_foreign` FOREIGN KEY (`note_id`) REFERENCES `tbl_notes` (`id`);

--
-- Constraints for table `tbl_notes`
--
ALTER TABLE `tbl_notes`
  ADD CONSTRAINT `tbl_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_predefined_mail_templates`
--
ALTER TABLE `tbl_predefined_mail_templates`
  ADD CONSTRAINT `tbl_predefined_mail_templates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_products`
--
ALTER TABLE `tbl_products`
  ADD CONSTRAINT `tbl_products_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_role_has_permissions`
--
ALTER TABLE `tbl_role_has_permissions`
  ADD CONSTRAINT `tbl_role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `tbl_permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `tbl_roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tbl_stages`
--
ALTER TABLE `tbl_stages`
  ADD CONSTRAINT `tbl_stages_pipeline_id_foreign` FOREIGN KEY (`pipeline_id`) REFERENCES `tbl_pipelines` (`id`);

--
-- Constraints for table `tbl_teams`
--
ALTER TABLE `tbl_teams`
  ADD CONSTRAINT `tbl_teams_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_team_user`
--
ALTER TABLE `tbl_team_user`
  ADD CONSTRAINT `tbl_team_user_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `tbl_teams` (`id`),
  ADD CONSTRAINT `tbl_team_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_web_forms`
--
ALTER TABLE `tbl_web_forms`
  ADD CONSTRAINT `tbl_web_forms_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_web_forms_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_workflows`
--
ALTER TABLE `tbl_workflows`
  ADD CONSTRAINT `tbl_workflows_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`);

--
-- Constraints for table `tbl_zapier_hooks`
--
ALTER TABLE `tbl_zapier_hooks`
  ADD CONSTRAINT `tbl_zapier_hooks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`);
COMMIT;

