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

START TRANSACTION;



--
-- Database: `admin`
--

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

--
-- Table structure for table `assign_roles`
--

CREATE TABLE `assign_roles` (
  `id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  `module_id` bigint UNSIGNED NOT NULL,
  `view` int NOT NULL DEFAULT '0',
  `view_own` int NOT NULL DEFAULT '0',
  `creat` int NOT NULL DEFAULT '0',
  `edit` int NOT NULL DEFAULT '0',
  `delet` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assign_roles`
--

INSERT INTO `assign_roles` (`id`, `role_id`, `module_id`, `view`, `view_own`, `creat`, `edit`, `delet`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 0, 0, 0, 0, 0, '2025-04-25 12:10:05', NULL),
(2, 1, 2, 1, 1, 1, 0, 0, '2025-04-25 12:10:05', NULL),
(3, 1, 3, 1, 0, 0, 1, 0, '2025-04-25 12:10:05', NULL),
(4, 1, 4, 1, 0, 0, 0, 1, '2025-04-25 12:10:05', NULL),
(5, 1, 7, 1, 0, 0, 0, 0, '2025-04-25 12:10:05', NULL),
(6, 1, 5, 0, 1, 1, 0, 0, '2025-04-25 12:10:05', NULL),
(7, 1, 6, 1, 1, 0, 1, 0, '2025-04-25 12:10:05', NULL),
(8, 2, 1, 1, 0, 0, 0, 0, '2025-07-04 12:14:58', NULL),
(9, 2, 2, 1, 1, 0, 0, 0, '2025-07-04 12:14:58', NULL),
(10, 2, 3, 1, 0, 1, 0, 0, '2025-07-04 12:14:58', NULL),
(11, 2, 4, 1, 0, 0, 0, 0, '2025-07-04 12:14:58', NULL),
(12, 2, 5, 0, 0, 0, 0, 0, '2025-07-04 12:14:58', NULL),
(13, 2, 6, 0, 0, 0, 0, 0, '2025-07-04 12:14:58', NULL),
(14, 2, 7, 0, 0, 0, 0, 0, '2025-07-04 12:14:58', NULL),
(15, 3, 1, 1, 1, 0, 1, 1, '2025-07-04 12:25:18', NULL),
(16, 3, 2, 1, 0, 0, 0, 0, '2025-07-04 12:25:18', NULL),
(17, 3, 3, 1, 0, 0, 0, 0, '2025-07-04 12:25:18', NULL),
(18, 3, 4, 0, 0, 0, 0, 0, '2025-07-04 12:25:18', NULL),
(19, 3, 5, 0, 0, 0, 0, 0, '2025-07-04 12:25:18', NULL),
(20, 3, 6, 0, 0, 0, 0, 0, '2025-07-04 12:25:18', NULL),
(21, 3, 7, 0, 0, 0, 0, 0, '2025-07-04 12:25:18', NULL),
(22, 12, 1, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(23, 12, 2, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(24, 12, 3, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(25, 12, 4, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(26, 12, 7, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(27, 12, 5, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(28, 12, 6, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(29, 12, 8, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(30, 12, 9, 1, 1, 1, 1, 1, '2025-04-25 12:10:05', NULL),
(31, 1, 8, 0, 0, 0, 0, 0, '2025-07-09 10:35:56', NULL),
(32, 1, 9, 0, 0, 0, 0, 0, '2025-07-09 10:35:56', NULL);

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 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 `features`
--

CREATE TABLE `features` (
  `id` bigint UNSIGNED NOT NULL,
  `feature_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `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 `features`
--

INSERT INTO `features` (`id`, `feature_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'features 1', 1, NULL, NULL),
(2, 'features 2', 1, NULL, NULL),
(3, 'features 3', 1, NULL, NULL),
(4, 'features 4', 1, NULL, NULL);

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

--
-- Table structure for table `grace_time_settings`
--

CREATE TABLE `grace_time_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `trial_package_days` int DEFAULT NULL,
  `paid_package_days` int 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 `grace_time_settings`
--

INSERT INTO `grace_time_settings` (`id`, `trial_package_days`, `paid_package_days`, `created_at`, `updated_at`) VALUES
(1, 9, 15, NULL, NULL);

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2025_06_28_120757_add_role_to_users_table', 2),
(6, '2025_06_30_063835_trial_history', 3);

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

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` int NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `view` int NOT NULL DEFAULT '0',
  `view_own` int NOT NULL DEFAULT '0',
  `creat` int NOT NULL DEFAULT '0',
  `edit` int NOT NULL DEFAULT '0',
  `delet` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `name`, `view`, `view_own`, `creat`, `edit`, `delet`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Subscription', 1, 1, 1, 1, 1, 1, '2025-04-24 12:27:55', NULL),
(2, 'Customer', 1, 1, 1, 1, 1, 1, '2025-04-24 12:27:55', NULL),
(3, 'Order', 1, 1, 1, 1, 1, 1, '2025-04-24 12:28:56', NULL),
(4, 'Invoice', 1, 1, 1, 1, 1, 1, '2025-04-24 12:28:56', NULL),
(5, 'General Settings', 1, 1, 1, 1, 1, 1, '2025-04-24 12:30:07', NULL),
(6, 'Reports', 1, 1, 1, 1, 1, 1, '2025-04-24 12:30:07', NULL),
(7, 'Dashboard', 1, 0, 0, 0, 0, 1, '2025-04-24 12:30:07', NULL),
(8, 'User', 1, 1, 1, 1, 1, 1, '2025-04-24 12:30:07', NULL),
(9, 'Role', 1, 1, 1, 1, 1, 1, '2025-04-24 12:30:07', NULL);

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

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

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `name` text,
  `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `roles` (`id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Property Manager', 'Property Manager', 1, '2025-04-24 15:14:35', NULL),
(2, 'Leasing Consultant', 'Leasing Consultant', 1, '2025-04-24 15:14:35', NULL),
(3, 'Real Estate Marketing Specialist', 'Real Estate Marketing Specialist', 1, '2025-04-24 15:15:16', NULL),
(4, 'Investment Analyst', 'Investment Analyst', 1, '2025-04-24 15:15:16', NULL),
(5, 'Administrative Assistant', 'Administrative Assistant', 1, '2025-04-24 15:15:56', NULL),
(6, 'Construction Project Manager', 'Construction Project Manager', 1, '2025-04-24 15:15:56', NULL),
(7, 'Transaction Coordinator', 'Transaction Coordinator', 1, '2025-04-24 15:16:28', NULL),
(8, 'Sales Manager', 'Sales Manager', 1, '2025-04-24 15:16:28', NULL),
(9, 'Legal Compilance Officer', 'Legal Compilance Officer', 1, '2025-04-24 15:16:28', NULL),
(12, 'Admin', 'Superadmin', 1, '2025-04-24 15:16:28', NULL);

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint UNSIGNED NOT NULL,
  `plan_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `premium_plan` tinyint(1) NOT NULL DEFAULT '0',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `monthly_actual_price` double DEFAULT NULL,
  `monthly_discount` int DEFAULT NULL,
  `monthly_offer_price` double DEFAULT NULL,
  `quaterly_actual_price` double DEFAULT NULL,
  `quaterly_discount` int DEFAULT NULL,
  `quaterly_offer_price` double DEFAULT NULL,
  `halfyearly_actual_price` double DEFAULT NULL,
  `halfyearly_discount` int DEFAULT NULL,
  `halfyearly_offer_price` double DEFAULT NULL,
  `yearly_actual_price` double DEFAULT NULL,
  `yearly_discount` int DEFAULT NULL,
  `yearly_offer_price` double DEFAULT NULL,
  `trial_setting` int DEFAULT NULL,
  `number_of_trial_property` int NOT NULL DEFAULT '1',
  `number_of_trial_team_member` int NOT NULL DEFAULT '1',
  `features` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `number_of_property` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_team_members` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_file_exports` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_file_cabinate` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stacking_plan` int NOT NULL DEFAULT '0',
  `stacking_plan_enb` int NOT NULL DEFAULT '0',
  `google_drive` int NOT NULL DEFAULT '0',
  `critical_data` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `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 `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `plan_name`, `premium_plan`, `description`, `monthly_actual_price`, `monthly_discount`, `monthly_offer_price`, `quaterly_actual_price`, `quaterly_discount`, `quaterly_offer_price`, `halfyearly_actual_price`, `halfyearly_discount`, `halfyearly_offer_price`, `yearly_actual_price`, `yearly_discount`, `yearly_offer_price`, `trial_setting`, `number_of_trial_property`, `number_of_trial_team_member`, `features`, `duration`, `number_of_property`, `number_of_team_members`, `number_of_file_exports`, `number_of_file_cabinate`, `stacking_plan`, `stacking_plan_enb`, `google_drive`, `critical_data`, `status`, `created_at`, `updated_at`) VALUES
(12, 'Pro', 0, 'Basic', 500, 10, 450, 1500, 20, 1200, 3000, 30, 2100, 6000, 40, 3600, 14, 1, 1, ',1,2', NULL, '1', '50', NULL, NULL, 1, 0, 0, 1, 1, '2025-06-19 04:32:57', '2025-06-20 00:52:27'),
(11, 'Premium', 1, 'Premium', 1500, 10, 1350, 4500, 20, 3600, 9000, 30, 6300, 18000, 40, 10800, 14, 1, 1, ',1,4', NULL, '3', '6', NULL, NULL, 1, 0, 0, 1, 1, '2025-06-16 22:14:25', '2025-06-20 03:06:19');

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

--
-- Table structure for table `trial_history`
--

CREATE TABLE `trial_history` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `total_days` int DEFAULT NULL,
  `created` date NOT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assign_roles`
--
ALTER TABLE `assign_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assign_roles_module_id_foreign` (`module_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 `features`
--
ALTER TABLE `features`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for table `modules`
--
ALTER TABLE `modules`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

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

