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

START TRANSACTION;



--
-- Database: `mytiqkets_demo`
--

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

--
-- Table structure for table `add_desk`
--

CREATE TABLE `add_desk` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `lid` int(11) NOT NULL,
  `desk_count` int(11) DEFAULT NULL,
  `desk_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numbered` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `add_desk`
--

INSERT INTO `add_desk` (`id`, `uid`, `lid`, `desk_count`, `desk_name`, `numbered`, `date`, `time`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 2, 2, NULL, 'Desk-1', 1, '2024-06-14', '12:30:02', 2, 12, 'Y', '2024-06-14 07:00:19', '2024-06-14 07:00:02', '2024-06-14 07:00:19'),
(2, 2, 2, NULL, 'Desk-2', 1, '2024-06-14', '12:30:02', 2, 12, 'Y', '2024-06-14 07:00:19', '2024-06-14 07:00:02', '2024-06-14 07:00:19'),
(3, 2, 2, NULL, 'Desk-3', 1, '2024-06-14', '12:30:02', 2, 12, 'Y', '2024-06-14 07:00:19', '2024-06-14 07:00:02', '2024-06-14 07:00:19'),
(4, 2, 2, NULL, 'Desk-1', 1, '2024-06-14', '12:31:20', 2, NULL, 'Y', NULL, '2024-06-14 07:01:20', '2024-06-14 07:01:20'),
(5, 2, 2, NULL, 'Desk-2', 1, '2024-06-14', '12:31:20', 2, NULL, 'Y', NULL, '2024-06-14 07:01:20', '2024-06-14 07:01:20'),
(6, 2, 2, NULL, 'Desk-3', 1, '2024-06-14', '12:31:20', 2, NULL, 'Y', NULL, '2024-06-14 07:01:20', '2024-06-14 07:01:20'),
(7, 2, 2, NULL, 'Desk-4', 1, '2024-06-14', '12:31:20', 2, NULL, 'Y', NULL, '2024-06-14 07:01:20', '2024-06-14 07:01:20'),
(8, 2, 2, NULL, 'Desk-5', 1, '2024-06-14', '12:31:20', 2, NULL, 'Y', NULL, '2024-06-14 07:01:20', '2024-06-14 07:01:20'),
(9, 2, 2, NULL, 'Desk-6', 1, '2024-06-14', '12:31:20', 2, NULL, 'Y', NULL, '2024-06-14 07:01:20', '2024-06-14 07:01:20'),
(10, 15, 3, NULL, 'Desk-1', 1, '2024-06-14', '13:39:54', 15, 15, 'Y', '2024-06-14 08:13:38', '2024-06-14 08:09:54', '2024-06-14 08:13:38'),
(11, 15, 3, NULL, 'Desk-2', 1, '2024-06-14', '13:39:54', 15, 15, 'Y', '2024-06-14 08:13:38', '2024-06-14 08:09:54', '2024-06-14 08:13:38'),
(12, 15, 3, NULL, 'Desk-3', 1, '2024-06-14', '13:39:54', 15, 15, 'Y', '2024-06-14 08:13:38', '2024-06-14 08:09:54', '2024-06-14 08:13:38'),
(13, 15, 3, NULL, 'Desk-4', 1, '2024-06-14', '13:39:54', 15, 15, 'Y', '2024-06-14 08:13:38', '2024-06-14 08:09:54', '2024-06-14 08:13:38'),
(14, 15, 3, NULL, 'Desk-1', 1, '2024-06-14', '13:43:38', 15, NULL, 'Y', NULL, '2024-06-14 08:13:38', '2024-06-14 08:13:38'),
(15, 15, 3, NULL, 'Desk-2', 1, '2024-06-14', '13:43:38', 15, NULL, 'Y', NULL, '2024-06-14 08:13:38', '2024-06-14 08:13:38'),
(16, 15, 3, NULL, 'Desk-3', 1, '2024-06-14', '13:43:38', 15, NULL, 'Y', NULL, '2024-06-14 08:13:38', '2024-06-14 08:13:38'),
(17, 15, 3, NULL, 'Desk-4', 1, '2024-06-14', '13:43:38', 15, NULL, 'Y', NULL, '2024-06-14 08:13:38', '2024-06-14 08:13:38');

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

--
-- Table structure for table `currently_solves`
--

CREATE TABLE `currently_solves` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `currently_solve` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `currently_solves`
--

INSERT INTO `currently_solves` (`id`, `currently_solve`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Pen and paper ( sign-in sheets, etc)', 0, 0, '', NULL, NULL, NULL),
(2, 'We use another software/solutions', 0, 0, '', NULL, NULL, NULL),
(3, 'We don\'t have a system in our place', 0, 0, '', NULL, NULL, NULL),
(4, 'Low efficiency', 0, 0, '', NULL, NULL, NULL);

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` double(250,2) DEFAULT NULL,
  `balance` double(250,2) DEFAULT NULL,
  `joining_date` date 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 `failed_jobs`
--

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

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

--
-- Table structure for table `how_to_here`
--

CREATE TABLE `how_to_here` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `how_to_here` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `how_to_here`
--

INSERT INTO `how_to_here` (`id`, `how_to_here`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Friend', 0, 2, 'Y', NULL, NULL, '2024-06-13 01:03:33'),
(2, 'Blog post', 0, 0, '', NULL, NULL, NULL),
(3, 'Chat GPT', 0, 0, '', NULL, NULL, NULL),
(4, 'Search engine', 0, 0, '', NULL, NULL, NULL),
(5, 'sdsdsd', 2, NULL, 'Y', '2024-06-13 01:26:36', '2024-06-13 01:26:33', '2024-06-13 01:26:36');

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

--
-- Table structure for table `how_to_visits`
--

CREATE TABLE `how_to_visits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `how_to_visits` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `how_to_visits`
--

INSERT INTO `how_to_visits` (`id`, `how_to_visits`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Walk-Ins', 0, 0, '', NULL, NULL, NULL),
(2, 'Schedule Appointments', 0, 2, 'Y', NULL, NULL, '2024-06-12 23:49:36'),
(3, 'Both', 0, 11, 'N', NULL, NULL, '2024-06-14 06:19:48'),
(4, 'dfdf dfffffffffff', 2, 2, 'Y', '2024-06-12 23:52:04', '2024-06-12 23:51:20', '2024-06-12 23:52:04'),
(5, 'test', 11, NULL, 'Y', '2024-06-14 06:20:18', '2024-06-14 06:20:08', '2024-06-14 06:20:18');

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

--
-- Table structure for table `industry`
--

CREATE TABLE `industry` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `industry` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `industry`
--

INSERT INTO `industry` (`id`, `industry`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Industry', 0, 0, '', NULL, NULL, NULL),
(2, 'Banking and Financial Services', 0, 0, '', NULL, NULL, NULL),
(3, 'Retail', 0, 0, '', NULL, NULL, NULL),
(4, 'Government and Public Services', 0, 0, '', NULL, NULL, NULL),
(5, 'Telecom and Utility Services', 0, 0, '', NULL, NULL, NULL),
(6, ' Education', 0, 0, '', NULL, NULL, NULL),
(7, ' Hospitality and Tourism ', 0, 0, '', NULL, NULL, NULL),
(8, ' Airports and Transportation', 0, 0, '', NULL, NULL, NULL),
(9, 'Entertainment and Leisure', 0, 0, '', NULL, NULL, NULL),
(10, 'Restaurants and Food Services', 0, 0, '', NULL, NULL, NULL),
(11, 'Real Estate and Construction', 0, 0, '', NULL, NULL, '2024-06-12 23:11:55'),
(12, 'ee', 2, NULL, 'Y', '2024-06-13 07:49:19', '2024-06-12 07:13:20', '2024-06-13 07:49:19'),
(13, 'ee7676', 2, NULL, 'Y', '2024-06-13 07:49:14', '2024-06-12 07:40:28', '2024-06-13 07:49:14'),
(14, 'ee7676', 2, NULL, 'N', '2024-06-13 07:49:06', '2024-06-12 07:40:37', '2024-06-13 07:49:06'),
(15, '7676hghgggggggggg', 2, 2, 'Y', '2024-06-13 07:49:00', '2024-06-12 07:52:25', '2024-06-13 07:49:00'),
(16, 'testing', 11, NULL, 'Y', '2024-06-14 04:17:06', '2024-06-14 04:14:20', '2024-06-14 04:17:06'),
(17, 'tes', 11, NULL, 'Y', '2024-06-14 06:00:14', '2024-06-14 06:00:06', '2024-06-14 06:00:14'),
(18, 'testing', 11, NULL, 'Y', '2024-06-14 06:16:19', '2024-06-14 06:14:35', '2024-06-14 06:16:19');

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

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ln` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `service_enable` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`id`, `uid`, `location`, `address`, `city`, `state`, `lt`, `ln`, `date`, `time`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`, `service_enable`) VALUES
(1, 13, 'testing', 'Kuniamuthur, Ward 87, South Zone, Coimbatore South, Coimbatore District, Tamil Nadu, 641008, India', NULL, 'Tamil Nadu', '10.963943955109947', '76.95657236148806', NULL, NULL, 13, NULL, 'Y', NULL, '2024-06-14 06:58:05', '2024-06-14 06:58:05', NULL),
(2, 2, 'test', 'Siddhapudur, Ward 53, Central Zone, Coimbatore, Coimbatore North, Coimbatore District, Tamil Nadu, 641001, India', NULL, 'Tamil Nadu', '11.020732446907125', '76.97217609230366', NULL, NULL, 2, 2, 'Y', NULL, '2024-06-14 07:00:02', '2024-06-14 11:44:32', NULL),
(3, 15, 'Peelamedu', 'Saibaba Colony, Ward 22, West Zone, Coimbatore, Coimbatore North, Coimbatore District, Tamil Nadu, 641001, India', NULL, 'Tamil Nadu', '11.023207215779832', '76.93795945396529', NULL, NULL, 15, 15, 'Y', NULL, '2024-06-14 08:09:54', '2024-06-14 08:13:38', NULL),
(4, 15, 'Gandhipuram', 'Thokkasandra, Harohalli taluk, Ramanagara District, Karnataka, 562121, India', NULL, 'Karnataka', '12.57533973967085', '77.46452184358225', NULL, NULL, 15, NULL, 'Y', NULL, '2024-06-14 08:10:43', '2024-06-14 08:10:43', NULL);

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_07_10_112535_create_customers_table', 1),
(6, '2014_10_12_100000_create_password_reset_tokens_table', 2),
(9, '', 3),
(10, '2024_06_10_113852_create_industry_models_table', 4),
(11, '2024_06_10_133648_create_people_visits_table', 5),
(12, '2024_06_11_050905_create_howto_visits_table', 6),
(13, '2024_06_11_054209_create_solves_table', 7),
(14, '2024_06_11_062540_create_currently_solves_table', 8),
(15, '2024_06_11_065018_create_hearethis_table', 9),
(16, '2014_10_12_000000_create_users_table', 10),
(17, '2024_06_12_085752_create_locations_table', 11),
(18, '2024_06_12_092221_create_adddesks_table', 11),
(19, '2024_06_13_125706_create_openings_table', 11),
(20, '2024_06_14_041806_create_services_table', 11),
(21, '2024_06_14_092200_add_service_enable_to_location_table', 11);

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

--
-- Table structure for table `opening`
--

CREATE TABLE `opening` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `lid` int(11) NOT NULL,
  `day` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `open` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `opening`
--

INSERT INTO `opening` (`id`, `uid`, `lid`, `day`, `from`, `to`, `open`, `date`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 2, 2, 'Sun', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(2, 2, 2, 'Mon', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(3, 2, 2, 'Tue', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(4, 2, 2, 'Wed', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(5, 2, 2, 'Thr', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(6, 2, 2, 'Fri', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(7, 2, 2, 'Sat', '22:42', '22:42', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(8, 2, 2, 'Sun', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(9, 2, 2, 'Mon', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(10, 2, 2, 'Tue', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(11, 2, 2, 'Wed', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(12, 2, 2, 'Thr', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(13, 2, 2, 'Fri', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL),
(14, 2, 2, 'Sat', '12:30 AM', '01:00 AM', '1', NULL, 2, NULL, '1', NULL, NULL, NULL);

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

--
-- Table structure for table `people_visits`
--

CREATE TABLE `people_visits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `people_visits` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `people_visits`
--

INSERT INTO `people_visits` (`id`, `people_visits`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '0-10', 0, 0, 'Y', NULL, NULL, NULL),
(2, '10-50', 0, 0, 'Y', NULL, NULL, NULL),
(3, '50-100', 0, 0, 'Y', NULL, NULL, NULL),
(4, '100-500', 0, 0, 'Y', NULL, NULL, NULL),
(5, 'More than 500+', 0, 0, 'Y', NULL, NULL, NULL),
(6, 'I\'m Not Sure', 0, 2, 'Y', NULL, NULL, '2024-06-12 23:37:28'),
(7, 'fdfdf', 2, 2, 'N', '2024-06-12 23:40:35', '2024-06-12 23:40:00', '2024-06-12 23:40:35'),
(8, '47', 11, NULL, 'Y', '2024-06-14 04:16:38', '2024-06-14 04:16:17', '2024-06-14 04:16:38'),
(9, '57', 11, NULL, 'Y', '2024-06-14 06:17:57', '2024-06-14 06:16:41', '2024-06-14 06:17:57');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `lid` int(11) NOT NULL,
  `services` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `uid`, `lid`, `services`, `color`, `date`, `time`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 13, 1, 'infermation', '#7d85e2', '2024-06-14', '12:28:05', 13, NULL, 'Y', NULL, '2024-06-14 06:58:05', '2024-06-14 06:58:05'),
(2, 13, 1, 'Main Service', '#e2ca7d', '2024-06-14', '12:28:05', 13, NULL, 'Y', NULL, '2024-06-14 06:58:05', '2024-06-14 06:58:05'),
(3, 2, 2, 'infermation', '#7d85e2', '2024-06-14', '12:30:02', 2, NULL, 'Y', NULL, '2024-06-14 07:00:02', '2024-06-14 07:00:02'),
(4, 2, 2, 'Main Service', '#e2ca7d', '2024-06-14', '12:30:02', 2, NULL, 'Y', NULL, '2024-06-14 07:00:02', '2024-06-14 07:00:02'),
(5, 15, 3, 'infermation', '#7d85e2', '2024-06-14', '13:39:54', 15, NULL, 'Y', NULL, '2024-06-14 08:09:54', '2024-06-14 08:09:54'),
(6, 15, 3, 'Main Service', '#e2ca7d', '2024-06-14', '13:39:54', 15, NULL, 'Y', NULL, '2024-06-14 08:09:54', '2024-06-14 08:09:54'),
(7, 15, 4, 'infermation', '#7d85e2', '2024-06-14', '13:40:43', 15, NULL, 'Y', NULL, '2024-06-14 08:10:43', '2024-06-14 08:10:43'),
(8, 15, 4, 'Main Service', '#e2ca7d', '2024-06-14', '13:40:43', 15, NULL, 'Y', NULL, '2024-06-14 08:10:43', '2024-06-14 08:10:43'),
(9, 15, 3, 'Credit Card', '#37ac52', '2024-06-14', '13:41:12', 15, NULL, 'Y', NULL, '2024-06-14 08:11:12', '2024-06-14 08:11:17');

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

--
-- Table structure for table `solve_tickets`
--

CREATE TABLE `solve_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `solve` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `solve_tickets`
--

INSERT INTO `solve_tickets` (`id`, `solve`, `created_by`, `updated_by`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'No data about the service/staff performance', 0, 0, '', NULL, NULL, NULL),
(2, 'Long queue and/or wait times', 0, 0, '', NULL, NULL, NULL),
(3, 'Overcrowded within rooms', 0, 0, '', NULL, NULL, NULL),
(4, 'Low efficiency', 0, 0, '', NULL, NULL, NULL),
(5, 'No idea of what\'s going on, who\'s waiting, For how long. etc', 0, 2, 'Y', NULL, NULL, '2024-06-13 00:03:54'),
(6, 'dfdfdfdfdf dfdfdfdf', 2, 2, 'N', '2024-06-13 01:51:56', '2024-06-13 01:51:29', '2024-06-13 01:51:56'),
(7, 'tetds', 11, NULL, 'Y', '2024-06-14 06:23:34', '2024-06-14 06:22:41', '2024-06-14 06:23:34');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `solve_tickets`
--
ALTER TABLE `solve_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

