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

START TRANSACTION;



--
-- Database: `vet_lodging`
--

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

--
-- Table structure for table `audit_trail`
--

CREATE TABLE `audit_trail` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `ref_table` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_table_id` bigint(20) NOT NULL,
  `ref_table_label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_trail`
--

INSERT INTO `audit_trail` (`id`, `user_id`, `ref_table`, `ref_table_id`, `ref_table_label`, `action`, `details`, `created_by`, `created_at`) VALUES
(1, 1, 'user', 3, 'User', 'New', '[{\"label\":\"Details\",\"columns\":[{\"display\":true,\"name\":\"username\",\"label\":\"Username\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"type\",\"label\":\"Type\",\"type\":\"local\",\"val\":\"Admin\"},{\"display\":true,\"name\":\"first_name\",\"label\":\"First Name\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"middle_name\",\"label\":\"Middle Name\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"last_name\",\"label\":\"Last Name\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"email\",\"label\":\"Email\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"gender\",\"label\":\"Gender\",\"type\":\"local\",\"val\":\"Male\"},{\"display\":true,\"name\":\"address\",\"label\":\"Address\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"company_id\",\"label\":\"Company\",\"type\":\"foreign\",\"val\":\"1\",\"text\":\"Company 1\"},{\"display\":true,\"name\":\"branch_id\",\"label\":\"Branch\",\"type\":\"foreign\",\"val\":\"1\",\"text\":\"Branch 1\"}]}]', 'superadmin', '2023-09-07 16:09:43'),
(2, 1, 'user', 3, 'User', 'Update', '[{\"label\":\"Original Details\",\"columns\":[{\"display\":true,\"name\":\"username\",\"label\":\"Username\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"type\",\"label\":\"Type\",\"type\":\"local\",\"val\":\"Admin\"},{\"display\":true,\"name\":\"first_name\",\"label\":\"First Name\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"middle_name\",\"label\":\"Middle Name\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"last_name\",\"label\":\"Last Name\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"email\",\"label\":\"Email\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"gender\",\"label\":\"Gender\",\"type\":\"local\",\"val\":\"Male\"},{\"display\":true,\"name\":\"address\",\"label\":\"Address\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"company_id\",\"label\":\"Company\",\"type\":\"foreign\",\"val\":\"1\",\"text\":\"Company 1\"},{\"display\":true,\"name\":\"branch_id\",\"label\":\"Branch\",\"type\":\"foreign\",\"val\":\"1\",\"text\":\"Branch 1\"}]},{\"label\":\"New Details\",\"columns\":[{\"display\":true,\"name\":\"username\",\"label\":\"Username\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"type\",\"label\":\"Type\",\"type\":\"local\",\"val\":\"Admin\"},{\"display\":true,\"name\":\"first_name\",\"label\":\"First Name\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"middle_name\",\"label\":\"Middle Name\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"last_name\",\"label\":\"Last Name\",\"type\":\"local\",\"val\":\"admin\"},{\"display\":true,\"name\":\"email\",\"label\":\"Email\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"gender\",\"label\":\"Gender\",\"type\":\"local\",\"val\":\"Male\"},{\"display\":true,\"name\":\"address\",\"label\":\"Address\",\"type\":\"local\",\"val\":null},{\"display\":true,\"name\":\"company_id\",\"label\":\"Company\",\"type\":\"foreign\",\"val\":\"1\",\"text\":\"Company 1\"},{\"display\":true,\"name\":\"branch_id\",\"label\":\"Branch\",\"type\":\"foreign\",\"val\":\"1\",\"text\":\"Branch 1\"}]}]', 'superadmin', '2023-09-25 10:04:01');

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `id` bigint(20) NOT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`id`, `company_id`, `code`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 'Branch 1', 'Branch 1', 'superadmin', '2023-09-07 16:09:06', 'superadmin', '2023-09-07 16:09:06', 0);

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

--
-- Table structure for table `branch_sms`
--

CREATE TABLE `branch_sms` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `sms_id` bigint(20) DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent_ctr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `send_at` datetime DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `branch_variable`
--

CREATE TABLE `branch_variable` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_variable_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `breed`
--

CREATE TABLE `breed` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `breed`
--

INSERT INTO `breed` (`id`, `branch_id`, `code`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 'Pitbull', 'Pitbull', 'admin', '2023-09-11 13:20:15', 'admin', '2023-09-11 13:20:15', 0),
(2, 1, 'Chihuahua', 'Chihuahua', 'admin', '2023-09-11 13:20:28', 'admin', '2023-09-11 13:20:28', 0);

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

--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middle_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client`
--

INSERT INTO `client` (`id`, `branch_id`, `first_name`, `middle_name`, `last_name`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`, `email`, `contact_no`) VALUES
(1, 1, 'kenneth', 'dsa', 'marco', 'admin', '2023-09-11 16:35:41', 'admin', '2023-09-21 13:22:50', 0, 'sadsad@gmail.com', 'sadasdasds'),
(2, 1, 'asdsa', 'dsa', 'dasdasd', 'admin', '2023-09-11 16:36:41', 'admin', '2023-09-11 16:36:41', 0, 'sadsad@gmail.com', 'sadasdasds'),
(3, 1, 'asdsa', 'dsa', 'dasdasd', 'admin', '2023-09-11 16:37:16', 'admin', '2023-09-11 16:37:16', 0, 'sadsad@gmail.com', 'sadasdasds'),
(4, 1, 'asdsa', 'dsa', 'dasdasd', 'admin', '2023-09-11 16:37:38', 'admin', '2023-09-11 16:37:38', 0, 'sadsad@gmail.com', 'sadasdasds'),
(5, 1, 'asdsa', 'dsa', 'dasdasd', 'admin', '2023-09-11 16:38:00', 'admin', '2023-09-11 16:38:00', 0, 'sadsad@gmail.com', 'sadasdasds'),
(6, 1, 'sdas', 'dsa', 'dsadsad', 'admin', '2023-09-11 16:41:39', 'admin', '2023-09-11 16:41:39', 0, 'sadsad@gmail.com', 'dasd'),
(7, 1, 'john', NULL, 'doe', 'admin', '2023-09-25 10:42:40', 'admin', '2023-09-25 10:42:40', 0, NULL, NULL);

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

--
-- Table structure for table `client_pet`
--

CREATE TABLE `client_pet` (
  `id` bigint(20) NOT NULL,
  `species_id` bigint(20) DEFAULT NULL,
  `breed_id` bigint(20) DEFAULT NULL,
  `client_id` bigint(20) DEFAULT NULL,
  `pet_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `client_pet`
--

INSERT INTO `client_pet` (`id`, `species_id`, `breed_id`, `client_id`, `pet_name`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 1, 5, 'sdasdasd', 'admin', '2023-09-11 16:38:00', 'admin', '2023-09-11 16:41:02', 1),
(2, 1, 1, 5, 'asdasdasdsad', 'admin', '2023-09-11 16:38:00', 'admin', '2023-09-11 16:41:02', 1),
(3, 1, 1, 6, 'asdasdsd', 'admin', '2023-09-11 16:41:39', 'admin', '2023-09-11 16:42:39', 1),
(4, 2, 1, 6, 'aaaaaaa', 'admin', '2023-09-11 16:41:39', 'admin', '2023-09-11 16:42:39', 1),
(5, 1, 2, 6, 'wwwwwwwwwwwwwwe', 'admin', '2023-09-11 16:42:53', 'admin', '2023-09-11 16:53:14', 1),
(6, 1, 2, 6, 'SDFSFDS', 'admin', '2023-09-11 16:50:39', 'admin', '2023-09-11 16:53:14', 1),
(7, 1, 2, 6, 'sssssssssswwwwwww', 'admin', '2023-09-11 16:53:05', 'admin', '2023-09-11 16:53:14', 1),
(8, 2, 2, 6, 'ccccccccccccc', 'admin', '2023-09-11 16:53:05', 'admin', '2023-09-12 08:08:20', 0),
(9, 1, 2, 6, 'bbbbbbbbb', 'admin', '2023-09-11 16:53:22', 'admin', '2023-09-11 16:53:22', 0),
(10, 1, 2, 6, 'dddd', 'admin', '2023-09-11 16:59:41', 'admin', '2023-09-11 16:59:41', 0),
(11, 2, 1, 6, 'wwwwww', 'admin', '2023-09-11 16:59:49', 'admin', '2023-09-11 16:59:49', 0),
(12, 1, 1, 1, 'blacky', 'admin', '2023-09-12 08:18:37', 'admin', '2023-09-12 08:18:37', 0),
(13, 1, 1, 2, 'whity', 'admin', '2023-09-12 08:18:53', 'admin', '2023-09-12 08:18:53', 0),
(14, 2, 1, 1, 'whity', 'admin', '2023-09-21 13:32:45', 'admin', '2023-09-21 13:32:45', 0),
(15, 2, 1, 7, 'pet ', 'admin', '2023-09-25 10:42:40', 'admin', '2023-09-25 10:42:40', 0);

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` bigint(20) NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parsed_logo_desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `code`, `description`, `address`, `contact_no`, `email`, `logo_desc`, `parsed_logo_desc`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 'Company 1', 'Company 1', NULL, NULL, NULL, NULL, NULL, 'superadmin', '2023-09-07 16:08:48', 'superadmin', '2023-09-07 16:08:48', 0);

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

--
-- Table structure for table `company_access`
--

CREATE TABLE `company_access` (
  `id` bigint(20) NOT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_access`
--

INSERT INTO `company_access` (`id`, `company_id`, `type`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(1, 1, 'Admin', 'CMS', 'superadmin', '2023-09-07 16:11:51', 'superadmin', '2023-09-07 16:11:51'),
(2, 1, 'Admin', 'Settings', 'superadmin', '2023-09-07 16:11:51', 'superadmin', '2023-09-07 16:11:51'),
(3, 1, 'Admin', 'Settings Branch Variable', 'superadmin', '2023-09-07 16:11:51', 'superadmin', '2023-09-07 16:11:51'),
(4, 1, 'Admin', 'Settings Branch Variable New', 'superadmin', '2023-09-07 16:11:51', 'superadmin', '2023-09-07 16:11:51'),
(5, 1, 'Admin', 'Settings Branch Variable Update', 'superadmin', '2023-09-07 16:11:51', 'superadmin', '2023-09-07 16:11:51'),
(6, 1, 'Admin', 'Settings Branch Variable Delete', 'superadmin', '2023-09-07 16:11:51', 'superadmin', '2023-09-07 16:11:51'),
(7, 1, 'Admin', 'CMS Room Type', 'superadmin', '2023-09-07 16:23:36', 'superadmin', '2023-09-07 16:23:36'),
(8, 1, 'Admin', 'CMS Room Type New', 'superadmin', '2023-09-07 16:23:36', 'superadmin', '2023-09-07 16:23:36'),
(9, 1, 'Admin', 'CMS Room Type Update', 'superadmin', '2023-09-07 16:23:36', 'superadmin', '2023-09-07 16:23:36'),
(10, 1, 'Admin', 'CMS Room Type Delete', 'superadmin', '2023-09-07 16:23:36', 'superadmin', '2023-09-07 16:23:36'),
(11, 1, 'Admin', 'CMS Breed', 'superadmin', '2023-09-11 13:18:37', 'superadmin', '2023-09-11 13:18:37'),
(12, 1, 'Admin', 'CMS Breed New', 'superadmin', '2023-09-11 13:18:37', 'superadmin', '2023-09-11 13:18:37'),
(13, 1, 'Admin', 'CMS Breed Update', 'superadmin', '2023-09-11 13:18:37', 'superadmin', '2023-09-11 13:18:37'),
(14, 1, 'Admin', 'CMS Breed Delete', 'superadmin', '2023-09-11 13:18:37', 'superadmin', '2023-09-11 13:18:37'),
(15, 1, 'Admin', 'CMS Species', 'superadmin', '2023-09-11 13:26:22', 'superadmin', '2023-09-11 13:26:22'),
(16, 1, 'Admin', 'CMS Species New', 'superadmin', '2023-09-11 13:26:22', 'superadmin', '2023-09-11 13:26:22'),
(17, 1, 'Admin', 'CMS Species Update', 'superadmin', '2023-09-11 13:26:22', 'superadmin', '2023-09-11 13:26:22'),
(18, 1, 'Admin', 'CMS Species Delete', 'superadmin', '2023-09-11 13:26:22', 'superadmin', '2023-09-11 13:26:22'),
(19, 1, 'Admin', 'Client', 'superadmin', '2023-09-11 13:48:07', 'superadmin', '2023-09-11 13:48:07'),
(20, 1, 'Admin', 'Room New', 'superadmin', '2023-09-11 13:48:07', 'superadmin', '2023-09-11 13:48:07'),
(21, 1, 'Admin', 'Room Update', 'superadmin', '2023-09-11 13:48:07', 'superadmin', '2023-09-11 13:48:07'),
(22, 1, 'Admin', 'Room Delete', 'superadmin', '2023-09-11 13:48:07', 'superadmin', '2023-09-11 13:48:07'),
(23, 1, 'Admin', 'Room', 'superadmin', '2023-09-11 13:49:13', 'superadmin', '2023-09-11 13:49:13'),
(24, 1, 'Admin', 'Service', 'superadmin', '2023-09-11 14:47:14', 'superadmin', '2023-09-11 14:47:14'),
(25, 1, 'Admin', 'Service New', 'superadmin', '2023-09-11 14:47:14', 'superadmin', '2023-09-11 14:47:14'),
(26, 1, 'Admin', 'Service Update', 'superadmin', '2023-09-11 14:47:14', 'superadmin', '2023-09-11 14:47:14'),
(27, 1, 'Admin', 'Service Delete', 'superadmin', '2023-09-11 14:47:14', 'superadmin', '2023-09-11 14:47:14'),
(28, 1, 'Admin', 'Client New', 'superadmin', '2023-09-11 15:18:19', 'superadmin', '2023-09-11 15:18:19'),
(29, 1, 'Admin', 'Client Update', 'superadmin', '2023-09-11 15:18:19', 'superadmin', '2023-09-11 15:18:19'),
(30, 1, 'Admin', 'Client Delete', 'superadmin', '2023-09-11 15:18:19', 'superadmin', '2023-09-11 15:18:19'),
(31, 1, 'Admin', 'CMS Service Type', 'superadmin', '2023-09-21 09:36:27', 'superadmin', '2023-09-21 09:36:27'),
(32, 1, 'Admin', 'CMS Service Type New', 'superadmin', '2023-09-21 09:36:27', 'superadmin', '2023-09-21 09:36:27'),
(33, 1, 'Admin', 'CMS Service Type Update', 'superadmin', '2023-09-21 09:36:27', 'superadmin', '2023-09-21 09:36:27'),
(34, 1, 'Admin', 'CMS Service Type Delete', 'superadmin', '2023-09-21 09:36:27', 'superadmin', '2023-09-21 09:36:27'),
(35, 1, 'Admin', 'Dashboard', 'superadmin', '2023-09-25 09:21:31', 'superadmin', '2023-09-25 09:21:31'),
(36, 1, 'Admin', 'Grooming', 'superadmin', '2023-09-25 09:21:31', 'superadmin', '2023-09-25 09:21:31'),
(37, 1, 'Admin', 'Grooming New', 'superadmin', '2023-09-25 09:21:31', 'superadmin', '2023-09-25 09:21:31'),
(38, 1, 'Admin', 'Grooming Update', 'superadmin', '2023-09-25 09:21:31', 'superadmin', '2023-09-25 09:21:31'),
(39, 1, 'Admin', 'Grooming Delete', 'superadmin', '2023-09-25 09:21:31', 'superadmin', '2023-09-25 09:21:31'),
(40, 1, 'Admin', 'CMS Payment Type', 'superadmin', '2023-09-25 11:15:16', 'superadmin', '2023-09-25 11:15:16'),
(41, 1, 'Admin', 'CMS Payment Type New', 'superadmin', '2023-09-25 11:15:16', 'superadmin', '2023-09-25 11:15:16'),
(42, 1, 'Admin', 'CMS Payment Type Update', 'superadmin', '2023-09-25 11:15:16', 'superadmin', '2023-09-25 11:15:16'),
(43, 1, 'Admin', 'CMS Payment Type Delete', 'superadmin', '2023-09-25 11:15:16', 'superadmin', '2023-09-25 11:15:16'),
(44, 1, 'Admin', 'Lodge', 'superadmin', '2023-09-25 14:49:43', 'superadmin', '2023-09-25 14:49:43'),
(45, 1, 'Admin', 'Lodge New', 'superadmin', '2023-09-25 14:49:43', 'superadmin', '2023-09-25 14:49:43'),
(46, 1, 'Admin', 'Lodge Lodge Payment', 'superadmin', '2023-09-25 14:49:43', 'superadmin', '2023-09-25 14:49:43'),
(47, 1, 'Admin', 'Lodge Lodge Payment Update', 'superadmin', '2023-09-25 14:49:43', 'superadmin', '2023-09-25 14:49:43'),
(48, 1, 'Admin', 'Lodge Lodge Payment Delete', 'superadmin', '2023-09-25 14:49:43', 'superadmin', '2023-09-25 14:49:43'),
(49, 1, 'Admin', 'Lodge Lodge Payment New', 'superadmin', '2023-09-25 14:50:46', 'superadmin', '2023-09-25 14:50:46');

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

--
-- Table structure for table `grooming`
--

CREATE TABLE `grooming` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `client_pet_id` bigint(20) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grooming`
--

INSERT INTO `grooming` (`id`, `branch_id`, `client_pet_id`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 14, 'Active', 'admin', '2023-09-25 10:15:41', 'admin', '2023-09-25 10:28:42', 1),
(2, 1, 12, 'Active', 'admin', '2023-09-25 10:30:33', 'admin', '2023-09-25 10:32:51', 1),
(3, 1, 12, 'Active', 'admin', '2023-09-25 10:34:18', 'admin', '2023-09-25 10:34:22', 1),
(4, 1, 12, 'Active', 'admin', '2023-09-25 10:34:34', 'admin', '2023-09-25 10:35:47', 0),
(5, 1, 14, 'Active', 'admin', '2023-09-25 10:37:43', 'admin', '2023-09-25 10:37:43', 0),
(6, 1, 15, 'Active', 'admin', '2023-09-25 10:43:54', 'admin', '2023-09-25 10:43:54', 0);

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

--
-- Table structure for table `grooming_service`
--

CREATE TABLE `grooming_service` (
  `id` bigint(20) NOT NULL,
  `grooming_id` bigint(20) DEFAULT NULL,
  `service_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_rate` decimal(12,2) DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grooming_service`
--

INSERT INTO `grooming_service` (`id`, `grooming_id`, `service_id`, `user_id`, `status`, `service_rate`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 1, 3, 'In Progress', '100.00', 'admin', '2023-09-25 10:17:34', 'admin', '2023-09-25 10:28:28', 0),
(2, 2, 2, 3, 'In Progress', '50.00', 'admin', '2023-09-25 10:30:33', 'admin', '2023-09-25 10:30:33', 0),
(3, 3, 2, 3, 'In Progress', '50.00', 'admin', '2023-09-25 10:34:18', 'admin', '2023-09-25 10:34:18', 0),
(4, 4, 2, 3, 'In Progress', '50.00', 'admin', '2023-09-25 10:34:34', 'admin', '2023-09-25 10:35:47', 0),
(5, 5, 2, 3, 'In Progress', '50.00', 'admin', '2023-09-25 10:37:43', 'admin', '2023-09-25 10:37:43', 0),
(6, 4, 2, 3, 'In Progress', '50.00', 'admin', '2023-09-25 10:39:21', 'admin', '2023-09-25 10:39:21', 0),
(7, 6, 1, 3, 'Complete', '30.00', 'admin', '2023-09-25 10:43:54', 'admin', '2023-09-25 10:43:54', 0),
(8, 6, 2, 3, 'Complete', '50.00', 'admin', '2023-09-25 10:43:54', 'admin', '2023-09-25 10:43:54', 0);

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

--
-- Table structure for table `lodge`
--

CREATE TABLE `lodge` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `room_id` bigint(20) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL,
  `client_pet_id` bigint(20) DEFAULT NULL,
  `time_in` datetime NOT NULL,
  `time_out` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lodge`
--

INSERT INTO `lodge` (`id`, `branch_id`, `room_id`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`, `client_pet_id`, `time_in`, `time_out`) VALUES
(5, 1, 5, 'Active', 'admin', '2023-09-22 10:56:14', 'admin', '2023-09-25 10:54:20', 0, 14, '2023-09-13 07:00:00', NULL),
(6, 1, 6, 'Active', 'admin', '2023-09-22 15:13:14', 'admin', '2023-09-22 15:13:25', 0, 13, '2023-09-22 15:00:00', NULL),
(7, 1, 7, 'Active', 'admin', '2023-09-22 15:16:09', 'admin', '2023-09-25 16:53:45', 0, 12, '2023-09-22 16:30:00', '2023-09-22 18:00:00');

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

--
-- Table structure for table `lodge_payment`
--

CREATE TABLE `lodge_payment` (
  `id` bigint(20) NOT NULL,
  `lodge_id` bigint(20) DEFAULT NULL,
  `payment_type_id` bigint(20) DEFAULT NULL,
  `amount` decimal(12,2) DEFAULT NULL,
  `payment_date` datetime NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lodge_service`
--

CREATE TABLE `lodge_service` (
  `id` bigint(20) NOT NULL,
  `lodge_id` bigint(20) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL,
  `service_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `service_rate` decimal(12,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lodge_service`
--

INSERT INTO `lodge_service` (`id`, `lodge_id`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`, `service_id`, `user_id`, `service_rate`) VALUES
(2, 7, 'Completed', 'admin', '2023-09-22 16:00:38', 'admin', '2023-09-22 16:36:52', 1, 1, 3, '100.00'),
(3, 7, 'Completed', 'admin', '2023-09-22 16:42:59', 'admin', '2023-09-25 13:23:58', 0, 1, 3, '100.00'),
(4, 5, 'In Progress', 'admin', '2023-09-22 16:46:22', 'admin', '2023-09-22 16:46:59', 1, 3, 3, '300.00'),
(5, 5, 'In Progress', 'admin', '2023-09-22 16:47:05', 'admin', '2023-09-22 16:47:05', 1, 3, 3, '300.00'),
(6, 5, 'In Progress', 'admin', '2023-09-22 16:47:16', 'admin', '2023-09-22 16:47:16', 0, 3, 3, '300.00'),
(7, 7, 'Completed', 'admin', '2023-09-22 16:53:31', 'admin', '2023-09-22 16:53:49', 1, 3, 3, '300.00'),
(8, 7, 'Completed', 'admin', '2023-09-25 13:23:58', 'admin', '2023-09-25 13:26:15', 0, 2, 3, '50.00'),
(9, 7, 'In Progress', 'admin', '2023-09-25 15:53:01', 'admin', '2023-09-25 15:53:01', 0, 2, 3, '50.00');

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

--
-- Table structure for table `payment_type`
--

CREATE TABLE `payment_type` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_type`
--

INSERT INTO `payment_type` (`id`, `branch_id`, `code`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 'Gcash', 'Gcash', 'admin', '2023-09-25 11:16:58', 'admin', '2023-09-25 11:16:58', 0),
(2, 1, 'Cash', 'Cash', 'admin', '2023-09-25 11:17:03', 'admin', '2023-09-25 11:17:03', 0),
(3, 1, 'Check', 'Check', 'admin', '2023-09-25 11:17:15', 'admin', '2023-09-25 11:17:15', 0);

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

--
-- Table structure for table `room`
--

CREATE TABLE `room` (
  `id` bigint(20) NOT NULL,
  `room_type_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `room_rate` decimal(12,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL,
  `branch_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `room`
--

INSERT INTO `room` (`id`, `room_type_id`, `code`, `description`, `room_rate`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`, `branch_id`) VALUES
(5, 2, 'Room 1', 'Room 1', '100.00', 'Occupied', 'admin', '2023-09-22 10:55:56', 'admin', '2023-09-22 10:56:14', 0, 1),
(6, 2, 'Room 3', 'Room 3', '10.00', 'Occupied', 'admin', '2023-09-22 15:12:18', 'admin', '2023-09-22 15:13:14', 0, 1),
(7, 2, 'Room 4', 'Room 4', '1000.00', 'Occupied', 'admin', '2023-09-22 15:13:40', 'admin', '2023-09-25 11:39:05', 0, 1);

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

--
-- Table structure for table `room_type`
--

CREATE TABLE `room_type` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `room_type`
--

INSERT INTO `room_type` (`id`, `branch_id`, `code`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 'Type 12', 'Type 12', 'admin', '2023-09-07 16:25:17', 'admin', '2023-09-07 16:25:49', 1),
(2, 1, 'Deluxed', 'Deluxed', 'admin', '2023-09-07 16:25:55', 'admin', '2023-09-21 09:58:12', 0),
(3, 1, 'Regular', 'Regular', 'admin', '2023-09-07 16:26:01', 'admin', '2023-09-21 09:58:01', 0);

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_rate` decimal(12,2) DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL,
  `service_type_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `branch_id`, `code`, `description`, `service_rate`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`, `service_type_id`) VALUES
(1, 1, 'NailCut', 'NailCut', '30.00', 'admin', '2023-09-11 14:48:32', 'admin', '2023-09-25 10:43:19', 0, 1),
(2, 1, 'Haircut', 'Haircut', '50.00', 'admin', '2023-09-11 14:48:43', 'admin', '2023-09-21 09:54:02', 0, 1),
(3, 1, 'Feeding', 'Feeding', '300.00', 'admin', '2023-09-21 09:57:33', 'admin', '2023-09-21 09:57:33', 0, 2);

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

--
-- Table structure for table `service_type`
--

CREATE TABLE `service_type` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_type`
--

INSERT INTO `service_type` (`id`, `branch_id`, `code`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 'Grooming', 'Grooming', 'admin', '2023-09-21 09:38:18', 'admin', '2023-09-21 09:38:18', 0),
(2, 1, 'Other Service', 'Other Service', 'admin', '2023-09-21 09:38:32', 'admin', '2023-09-21 09:38:32', 0);

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

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `id` bigint(20) NOT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `sms_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `species`
--

CREATE TABLE `species` (
  `id` bigint(20) NOT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `species`
--

INSERT INTO `species` (`id`, `branch_id`, `code`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `is_deleted`) VALUES
(1, 1, 'Cat', 'Cat', 'admin', '2023-09-11 13:28:44', 'admin', '2023-09-11 13:28:44', 0),
(2, 1, 'Dog', 'Dog', 'admin', '2023-09-11 13:28:51', 'admin', '2023-09-11 13:28:51', 0);

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

--
-- Table structure for table `user_access`
--

CREATE TABLE `user_access` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `branch_sms`
--
ALTER TABLE `branch_sms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D4A17D1CDCD6CC49` (`branch_id`),
  ADD KEY `IDX_D4A17D1CBD5C7E60` (`sms_id`);

--
-- Indexes for table `branch_variable`
--
ALTER TABLE `branch_variable`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_2BEE5E4EDCD6CC49` (`branch_id`);

--
-- Indexes for table `breed`
--
ALTER TABLE `breed`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_F8AF884FDCD6CC49` (`branch_id`);

--
-- Indexes for table `client`
--
ALTER TABLE `client`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C7440455DCD6CC49` (`branch_id`);

--
-- Indexes for table `client_pet`
--
ALTER TABLE `client_pet`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C3F60821B2A1D860` (`species_id`),
  ADD KEY `IDX_C3F60821A8B4A30F` (`breed_id`),
  ADD KEY `IDX_C3F6082119EB6921` (`client_id`);

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

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

--
-- Indexes for table `grooming`
--
ALTER TABLE `grooming`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_80D98779DCD6CC49` (`branch_id`),
  ADD KEY `IDX_80D98779C3C93405` (`client_pet_id`);

--
-- Indexes for table `grooming_service`
--
ALTER TABLE `grooming_service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_EFACD81DB6ACF293` (`grooming_id`),
  ADD KEY `IDX_EFACD81DED5CA9E6` (`service_id`),
  ADD KEY `IDX_EFACD81DA76ED395` (`user_id`);

--
-- Indexes for table `lodge`
--
ALTER TABLE `lodge`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_A11F814FDCD6CC49` (`branch_id`),
  ADD KEY `IDX_A11F814F54177093` (`room_id`),
  ADD KEY `IDX_A11F814FC3C93405` (`client_pet_id`);

--
-- Indexes for table `lodge_payment`
--
ALTER TABLE `lodge_payment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_787B521FB217AB93` (`lodge_id`),
  ADD KEY `IDX_787B521FDC058279` (`payment_type_id`);

--
-- Indexes for table `lodge_service`
--
ALTER TABLE `lodge_service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_F4CE4CC0B217AB93` (`lodge_id`),
  ADD KEY `IDX_F4CE4CC0ED5CA9E6` (`service_id`),
  ADD KEY `IDX_F4CE4CC0A76ED395` (`user_id`);

--
-- Indexes for table `payment_type`
--
ALTER TABLE `payment_type`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_AD5DC05DDCD6CC49` (`branch_id`);

--
-- Indexes for table `room`
--
ALTER TABLE `room`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_729F519B296E3073` (`room_type_id`),
  ADD KEY `IDX_729F519BDCD6CC49` (`branch_id`);

--
-- Indexes for table `room_type`
--
ALTER TABLE `room_type`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_EFDABD4DDCD6CC49` (`branch_id`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E19D9AD2DCD6CC49` (`branch_id`),
  ADD KEY `IDX_E19D9AD2AC8DE0F` (`service_type_id`);

--
-- Indexes for table `service_type`
--
ALTER TABLE `service_type`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_429DE3C5DCD6CC49` (`branch_id`);

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

--
-- Indexes for table `species`
--
ALTER TABLE `species`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_A50FF712DCD6CC49` (`branch_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `audit_trail`
--
ALTER TABLE `audit_trail`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

--
-- AUTO_INCREMENT for table `breed`
--
ALTER TABLE `breed`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `client_pet`
--
ALTER TABLE `client_pet`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

--
-- AUTO_INCREMENT for table `company_access`
--
ALTER TABLE `company_access`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

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

--
-- AUTO_INCREMENT for table `grooming_service`
--
ALTER TABLE `grooming_service`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `service_type`
--
ALTER TABLE `service_type`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `species`
--
ALTER TABLE `species`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `audit_trail`
--
ALTER TABLE `audit_trail`
  ADD CONSTRAINT `FK_B523E178A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Constraints for table `branch`
--
ALTER TABLE `branch`
  ADD CONSTRAINT `FK_BB861B1F979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`);

--
-- Constraints for table `branch_sms`
--
ALTER TABLE `branch_sms`
  ADD CONSTRAINT `FK_D4A17D1CBD5C7E60` FOREIGN KEY (`sms_id`) REFERENCES `sms` (`id`),
  ADD CONSTRAINT `FK_D4A17D1CDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `branch_variable`
--
ALTER TABLE `branch_variable`
  ADD CONSTRAINT `FK_2BEE5E4EDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `breed`
--
ALTER TABLE `breed`
  ADD CONSTRAINT `FK_F8AF884FDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `client`
--
ALTER TABLE `client`
  ADD CONSTRAINT `FK_C7440455DCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `client_pet`
--
ALTER TABLE `client_pet`
  ADD CONSTRAINT `FK_C3F6082119EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
  ADD CONSTRAINT `FK_C3F60821A8B4A30F` FOREIGN KEY (`breed_id`) REFERENCES `breed` (`id`),
  ADD CONSTRAINT `FK_C3F60821B2A1D860` FOREIGN KEY (`species_id`) REFERENCES `species` (`id`);

--
-- Constraints for table `company_access`
--
ALTER TABLE `company_access`
  ADD CONSTRAINT `FK_3BF64F21979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`);

--
-- Constraints for table `grooming`
--
ALTER TABLE `grooming`
  ADD CONSTRAINT `FK_80D98779C3C93405` FOREIGN KEY (`client_pet_id`) REFERENCES `client_pet` (`id`),
  ADD CONSTRAINT `FK_80D98779DCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `grooming_service`
--
ALTER TABLE `grooming_service`
  ADD CONSTRAINT `FK_EFACD81DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_EFACD81DB6ACF293` FOREIGN KEY (`grooming_id`) REFERENCES `grooming` (`id`),
  ADD CONSTRAINT `FK_EFACD81DED5CA9E6` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`);

--
-- Constraints for table `lodge`
--
ALTER TABLE `lodge`
  ADD CONSTRAINT `FK_A11F814F54177093` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`),
  ADD CONSTRAINT `FK_A11F814FC3C93405` FOREIGN KEY (`client_pet_id`) REFERENCES `client_pet` (`id`),
  ADD CONSTRAINT `FK_A11F814FDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `lodge_payment`
--
ALTER TABLE `lodge_payment`
  ADD CONSTRAINT `FK_787B521FB217AB93` FOREIGN KEY (`lodge_id`) REFERENCES `lodge` (`id`),
  ADD CONSTRAINT `FK_787B521FDC058279` FOREIGN KEY (`payment_type_id`) REFERENCES `payment_type` (`id`);

--
-- Constraints for table `lodge_service`
--
ALTER TABLE `lodge_service`
  ADD CONSTRAINT `FK_F4CE4CC0A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_F4CE4CC0B217AB93` FOREIGN KEY (`lodge_id`) REFERENCES `lodge` (`id`),
  ADD CONSTRAINT `FK_F4CE4CC0ED5CA9E6` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`);

--
-- Constraints for table `payment_type`
--
ALTER TABLE `payment_type`
  ADD CONSTRAINT `FK_AD5DC05DDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `room`
--
ALTER TABLE `room`
  ADD CONSTRAINT `FK_729F519B296E3073` FOREIGN KEY (`room_type_id`) REFERENCES `room_type` (`id`),
  ADD CONSTRAINT `FK_729F519BDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `room_type`
--
ALTER TABLE `room_type`
  ADD CONSTRAINT `FK_EFDABD4DDCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `service`
--
ALTER TABLE `service`
  ADD CONSTRAINT `FK_E19D9AD2AC8DE0F` FOREIGN KEY (`service_type_id`) REFERENCES `service_type` (`id`),
  ADD CONSTRAINT `FK_E19D9AD2DCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `service_type`
--
ALTER TABLE `service_type`
  ADD CONSTRAINT `FK_429DE3C5DCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `sms`
--
ALTER TABLE `sms`
  ADD CONSTRAINT `FK_B0A93A77979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`);

--
-- Constraints for table `species`
--
ALTER TABLE `species`
  ADD CONSTRAINT `FK_A50FF712DCD6CC49` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`);

--
-- Constraints for table `user_access`
--
ALTER TABLE `user_access`
  ADD CONSTRAINT `FK_633B3069A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
COMMIT;

