File: /home/clientsoftwares/public_html/property-management.clientsoftwares.com/app/demo.sql
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `banks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banks` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`gateway_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`details` tinytext COLLATE utf8mb4_unicode_ci,
`account_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`account_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `core_pages`
--
DROP TABLE IF EXISTS `core_pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_pages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`summary` tinytext COLLATE utf8mb4_unicode_ci,
`content` tinytext COLLATE utf8mb4_unicode_ci,
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `currencies`
--
DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currencies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`currency_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`symbol` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`currency_placement` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'before' COMMENT 'before, after',
`current_currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'on' COMMENT 'on, off',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `expense_types`
--
DROP TABLE IF EXISTS `expense_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expense_types` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tax` decimal(8,3) NOT NULL DEFAULT '0.000',
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(4) DEFAULT '1' COMMENT '0=deactivate,1=active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `expenses`
--
DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`property_id` bigint(20) unsigned DEFAULT NULL,
`property_unit_id` bigint(20) unsigned DEFAULT NULL,
`expense_type_id` bigint(20) unsigned DEFAULT NULL,
`description` mediumtext COLLATE utf8mb4_unicode_ci,
`total_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`responsibilities` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1=tenant, 2=owner',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `failed_jobs`
--
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`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,
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `faqs`
--
DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faqs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`answer` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `features`
--
DROP TABLE IF EXISTS `features`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `features` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`summary` tinytext COLLATE utf8mb4_unicode_ci,
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `file_managers`
--
DROP TABLE IF EXISTS `file_managers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_managers` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`folder_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`file_size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`origin_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`origin_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `file_managers_origin_type_origin_id_index` (`origin_type`,`origin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `gateway_currencies`
--
DROP TABLE IF EXISTS `gateway_currencies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gateway_currencies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`gateway_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD',
`conversion_rate` decimal(8,2) NOT NULL DEFAULT '1.00',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `gateways`
--
DROP TABLE IF EXISTS `gateways`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gateways` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1=Active,0=Disable',
`mode` tinyint(4) NOT NULL DEFAULT '2' COMMENT '1=live,2=sandbox',
`url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'client id, public key, key, store id, api key',
`secret` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'client secret, secret, store password, auth token',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `how_it_works`
--
DROP TABLE IF EXISTS `how_it_works`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `how_it_works` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`summary` tinytext COLLATE utf8mb4_unicode_ci,
`content` tinytext COLLATE utf8mb4_unicode_ci,
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `information`
--
DROP TABLE IF EXISTS `information`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `information` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`property_id` int(10) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`distance` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`additional_information` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `invoice_items`
--
DROP TABLE IF EXISTS `invoice_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_items` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`invoice_id` bigint(20) unsigned DEFAULT NULL,
`invoice_type_id` bigint(20) unsigned DEFAULT NULL,
`amount` decimal(8,2) DEFAULT NULL,
`tax_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `invoice_recurring_setting_items`
--
DROP TABLE IF EXISTS `invoice_recurring_setting_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_recurring_setting_items` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`invoice_recurring_setting_id` bigint(20) unsigned DEFAULT NULL,
`invoice_type_id` bigint(20) unsigned DEFAULT NULL,
`amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `invoice_recurring_settings`
--
DROP TABLE IF EXISTS `invoice_recurring_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_recurring_settings` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`property_id` bigint(20) unsigned NOT NULL,
`property_unit_id` bigint(20) unsigned NOT NULL,
`start_date` datetime NOT NULL DEFAULT '2023-05-21 13:36:41',
`recurring_type` tinyint(4) NOT NULL DEFAULT '1',
`cycle_day` int(11) DEFAULT NULL,
`due_day_after` int(11) NOT NULL DEFAULT '0',
`invoice_prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=deactivate,1=active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `invoice_types`
--
DROP TABLE IF EXISTS `invoice_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_types` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tax` decimal(8,3) NOT NULL DEFAULT '0.000',
`status` tinyint(4) DEFAULT '1' COMMENT '0=deactivate,1=active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `invoices`
--
DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`invoice_recurring_setting_id` bigint(20) unsigned DEFAULT NULL,
`property_id` bigint(20) unsigned NOT NULL,
`property_unit_id` bigint(20) unsigned NOT NULL,
`order_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`invoice_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`month` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`due_date` date NOT NULL,
`amount` decimal(8,2) DEFAULT NULL,
`tax_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=pending,1=paid,2=overdue',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `invoices_invoice_no_unique` (`invoice_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kyc_configs`
--
DROP TABLE IF EXISTS `kyc_configs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kyc_configs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` bigint(20) unsigned DEFAULT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`details` text COLLATE utf8mb4_unicode_ci NOT NULL,
`is_both` tinyint(4) NOT NULL DEFAULT '0',
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kyc_verifications`
--
DROP TABLE IF EXISTS `kyc_verifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kyc_verifications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`kyc_config_id` bigint(20) unsigned NOT NULL,
`front_id` bigint(20) unsigned DEFAULT NULL,
`back_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '2' COMMENT 'accepted, pending, rejected',
`reason` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `languages`
--
DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `languages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`font_id` int(11) DEFAULT NULL,
`icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rtl` tinyint(4) NOT NULL DEFAULT '0',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=Active,0=Disable',
`default` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1=yes,0=no',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `languages_name_unique` (`name`),
UNIQUE KEY `languages_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `maintainers`
--
DROP TABLE IF EXISTS `maintainers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintainers` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`property_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `maintenance_issues`
--
DROP TABLE IF EXISTS `maintenance_issues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintenance_issues` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `maintenance_requests`
--
DROP TABLE IF EXISTS `maintenance_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintenance_requests` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`property_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`unit_id` bigint(20) unsigned DEFAULT NULL,
`issue_id` bigint(20) unsigned NOT NULL,
`details` text COLLATE utf8mb4_unicode_ci,
`status` tinyint(4) NOT NULL DEFAULT '3',
`attach_id` bigint(20) unsigned DEFAULT NULL,
`invoice_id` bigint(20) unsigned DEFAULT NULL,
`amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
`id` bigint(20) UNSIGNED NOT NULL,
`first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_view` tinyint(1) NOT NULL DEFAULT '0',
`message` tinytext COLLATE utf8mb4_unicode_ci,
`reply` tinytext COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Table structure for table `metas`
--
DROP TABLE IF EXISTS `metas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `metas` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`page_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta_title` mediumtext COLLATE utf8mb4_unicode_ci,
`meta_description` mediumtext COLLATE utf8mb4_unicode_ci,
`meta_keyword` mediumtext COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `notice_boards`
--
DROP TABLE IF EXISTS `notice_boards`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notice_boards` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`details` text COLLATE utf8mb4_unicode_ci,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`property_id` bigint(20) unsigned DEFAULT NULL,
`unit_id` bigint(20) unsigned DEFAULT NULL,
`property_all` tinyint(4) NOT NULL DEFAULT '0',
`unit_all` tinyint(4) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `notice_user`
--
DROP TABLE IF EXISTS `notice_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notice_user` (
`notice_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`body` text COLLATE utf8mb4_unicode_ci,
`url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_seen` tinyint(4) NOT NULL DEFAULT '0',
`user_id` bigint(20) unsigned DEFAULT NULL,
`sender_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`payment_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`invoice_id` bigint(20) unsigned DEFAULT NULL,
`amount` double(8,2) DEFAULT '0.00',
`tax_amount` double(8,2) DEFAULT NULL,
`tax_percentage` double(8,2) DEFAULT NULL,
`system_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gateway_id` bigint(20) unsigned NOT NULL,
`gateway_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`conversion_rate` double(8,2) DEFAULT '1.00',
`subtotal` double(8,2) NOT NULL DEFAULT '0.00',
`total` double(8,2) DEFAULT '0.00',
`transaction_amount` double(8,2) DEFAULT '0.00',
`payment_status` tinyint(4) DEFAULT '0' COMMENT '0=pending, 1=paid, 2=cancelled',
`bank_id` tinyint(4) DEFAULT NULL,
`bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bank_account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deposit_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deposit_slip_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `owner_packages`
--
DROP TABLE IF EXISTS `owner_packages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `owner_packages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`package_id` bigint(20) unsigned NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`max_maintainer` int(11) NOT NULL DEFAULT '0',
`max_property` int(11) NOT NULL DEFAULT '0',
`max_unit` int(11) NOT NULL DEFAULT '0',
`max_tenant` int(11) NOT NULL DEFAULT '0',
`max_invoice` int(11) NOT NULL DEFAULT '0',
`max_auto_invoice` int(11) NOT NULL DEFAULT '0',
`ticket_support` tinyint(4) NOT NULL DEFAULT '0',
`notice_support` tinyint(4) NOT NULL DEFAULT '0',
`monthly_price` decimal(8,2) NOT NULL DEFAULT '0.00',
`yearly_price` decimal(8,2) NOT NULL DEFAULT '0.00',
`start_date` datetime NOT NULL,
`end_date` datetime NOT NULL,
`order_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
`is_trail` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'default for 1 , not default for 0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `owners`
--
DROP TABLE IF EXISTS `owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `owners` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `packages`
--
DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `packages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`max_maintainer` int(11) NOT NULL DEFAULT '0',
`max_property` int(11) NOT NULL DEFAULT '0',
`max_unit` int(11) NOT NULL DEFAULT '0',
`max_tenant` int(11) NOT NULL DEFAULT '0',
`max_invoice` int(11) NOT NULL DEFAULT '0',
`max_auto_invoice` int(11) NOT NULL DEFAULT '0',
`ticket_support` tinyint(4) NOT NULL DEFAULT '0',
`notice_support` tinyint(4) NOT NULL DEFAULT '0',
`monthly_price` decimal(8,2) NOT NULL DEFAULT '0.00',
`yearly_price` decimal(8,2) NOT NULL DEFAULT '0.00',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'active for 1 , deactivate for 0',
`is_default` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'default for 1 , not default for 0',
`is_trail` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'default for 1 , not default for 0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `packages_name_unique` (`name`),
UNIQUE KEY `packages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `password_resets`
--
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `personal_access_tokens`
--
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) unsigned NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci,
`last_used_at` timestamp NULL DEFAULT NULL,
`expires_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `properties`
--
DROP TABLE IF EXISTS `properties`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `properties` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`property_type` tinyint(4) NOT NULL COMMENT '1=Own, 2=Lease',
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`number_of_unit` int(11) NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`thumbnail_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`unit_type` tinyint(4) DEFAULT NULL COMMENT '1=Single, 2=Multiple',
`status` tinyint(4) DEFAULT '4' COMMENT '1=Active, 2=Inactive, 3=Cancelled, 4=Draft',
`thumbnail_image_id` bigint(20) unsigned DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `property_details`
--
DROP TABLE IF EXISTS `property_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_details` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`property_id` bigint(20) unsigned NOT NULL,
`lease_amount` decimal(8,2) DEFAULT '0.00',
`lease_start_date` date DEFAULT NULL,
`lease_end_date` date DEFAULT NULL,
`country_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zip_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` text COLLATE utf8mb4_unicode_ci,
`map_link` mediumtext COLLATE utf8mb4_unicode_ci,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `property_details_property_id_foreign` (`property_id`),
CONSTRAINT `property_details_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `property_images`
--
DROP TABLE IF EXISTS `property_images`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_images` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`property_id` bigint(20) unsigned NOT NULL,
`file_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `property_images_property_id_foreign` (`property_id`),
CONSTRAINT `property_images_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `property_units`
--
DROP TABLE IF EXISTS `property_units`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_units` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`property_id` bigint(20) unsigned NOT NULL,
`unit_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`bedroom` int(11) NOT NULL,
`bath` int(11) NOT NULL,
`kitchen` int(11) NOT NULL,
`general_rent` decimal(8,2) DEFAULT '0.00',
`security_deposit_type` tinyint(4) DEFAULT '0',
`security_deposit` decimal(8,2) DEFAULT '0.00',
`late_fee_type` tinyint(4) DEFAULT '0',
`late_fee` decimal(8,2) DEFAULT '0.00',
`incident_receipt` decimal(8,2) DEFAULT '0.00',
`rent_type` tinyint(4) DEFAULT NULL COMMENT '1=monthly,2=yearly,3=custom',
`monthly_due_day` int(11) DEFAULT NULL,
`yearly_due_day` int(11) DEFAULT NULL,
`lease_start_date` date DEFAULT NULL,
`lease_end_date` date DEFAULT NULL,
`lease_payment_due_date` date DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `property_units_property_id_foreign` (`property_id`),
CONSTRAINT `property_units_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `properties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`option_value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `subscription_orders`
--
DROP TABLE IF EXISTS `subscription_orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_orders` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`payment_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`package_id` bigint(20) unsigned DEFAULT NULL,
`duration_type` tinyint(4) NOT NULL DEFAULT '1',
`amount` double(8,2) DEFAULT '0.00',
`tax_amount` double(8,2) DEFAULT NULL,
`tax_percentage` double(8,2) DEFAULT NULL,
`system_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gateway_id` bigint(20) unsigned NOT NULL,
`gateway_currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`conversion_rate` double(8,2) DEFAULT '1.00',
`subtotal` double(8,2) NOT NULL DEFAULT '0.00',
`total` double(8,2) DEFAULT '0.00',
`transaction_amount` double(8,2) DEFAULT '0.00',
`payment_status` tinyint(4) DEFAULT '0' COMMENT '0=pending, 1=paid, 2=cancelled',
`bank_id` tinyint(4) DEFAULT NULL,
`bank_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bank_account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deposit_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deposit_slip_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tax_settings`
--
DROP TABLE IF EXISTS `tax_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_settings` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`owner_user_id` bigint(20) unsigned NOT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0',
`amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tenant_details`
--
DROP TABLE IF EXISTS `tenant_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tenant_details` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tenant_id` bigint(20) unsigned NOT NULL,
`previous_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`previous_country_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`previous_state_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`previous_city_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`previous_zip_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permanent_country_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permanent_state_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permanent_city_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permanent_zip_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tenants`
--
DROP TABLE IF EXISTS `tenants`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tenants` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`job` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`image_id` bigint(20) unsigned DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`family_member` int(11) NOT NULL,
`property_id` bigint(20) unsigned DEFAULT NULL,
`unit_id` bigint(20) unsigned DEFAULT NULL,
`rent_type` tinyint(4) NOT NULL DEFAULT '1',
`due_date` tinyint(4) DEFAULT NULL,
`lease_start_date` date DEFAULT NULL,
`lease_end_date` date DEFAULT NULL,
`general_rent` decimal(8,2) NOT NULL DEFAULT '0.00',
`security_deposit_type` tinyint(4) DEFAULT '0',
`security_deposit` decimal(8,2) NOT NULL DEFAULT '0.00',
`late_fee_type` tinyint(4) DEFAULT '0',
`late_fee` decimal(8,2) NOT NULL DEFAULT '0.00',
`incident_receipt` decimal(8,2) NOT NULL DEFAULT '0.00',
`status` tinyint(4) NOT NULL DEFAULT '3',
`close_refund_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
`close_charge` decimal(8,2) NOT NULL DEFAULT '0.00',
`close_date` date DEFAULT NULL,
`close_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `testimonials`
--
DROP TABLE IF EXISTS `testimonials`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testimonials` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` tinytext COLLATE utf8mb4_unicode_ci,
`star` tinyint(4) NOT NULL DEFAULT '5',
`status` tinyint(4) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ticket_replies`
--
DROP TABLE IF EXISTS `ticket_replies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_replies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`reply` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ticket_topics`
--
DROP TABLE IF EXISTS `ticket_topics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_topics` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`status` tinyint(4) DEFAULT '1' COMMENT '0=deactivate,1=active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tickets`
--
DROP TABLE IF EXISTS `tickets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tickets` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`property_id` bigint(20) unsigned NOT NULL,
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`unit_id` bigint(20) unsigned DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`details` text COLLATE utf8mb4_unicode_ci NOT NULL,
`topic_id` bigint(20) unsigned NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`ticket_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `tickets_ticket_no_unique` (`ticket_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `transactions`
--
DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`total_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
`txn_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`payment_method` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`currency` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`payment_details` longtext COLLATE utf8mb4_unicode_ci,
`payment_time` datetime DEFAULT NULL,
`status` enum('initiate','pending','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `transactions_txn_id_unique` (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`contact_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Active = true, Inactive = false',
`created_by` bigint(20) DEFAULT NULL,
`role` int(11) NOT NULL DEFAULT '1',
`owner_user_id` bigint(20) unsigned DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
UNIQUE KEY `users_contact_number_unique` (`contact_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms_histories`;
CREATE TABLE `sms_histories` (
`id` bigint(20) UNSIGNED NOT NULL,
`owner_user_id` bigint(20) UNSIGNED NOT NULL,
`api` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`date` datetime DEFAULT NULL,
`error` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `mail_histories`;
CREATE TABLE `mail_histories` (
`id` bigint(20) UNSIGNED NOT NULL,
`owner_user_id` bigint(20) UNSIGNED NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8mb4_unicode_ci,
`status` tinyint(4) NOT NULL DEFAULT '1',
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`date` datetime DEFAULT NULL,
`error` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`host` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `currencies` (id, currency_code, symbol, currency_placement, current_currency, created_at, updated_at, deleted_at) VALUES(1, 'USD', '$', 'before', 'on', '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL),(2, 'BDT', '৳', 'before', 'off', '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL),(3, 'INR', '₹', 'before', 'off', '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL),(4, 'GBP', '£', 'after', 'off', '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL),(5, 'MXN', '$', 'before', 'off', '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL),(6, 'SAR', 'SR', 'before', 'off', '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL);
INSERT INTO `file_managers` (`id`, `folder_name`, `file_name`, `file_size`, `origin_type`, `origin_id`, `created_at`, `updated_at`, `deleted_at`) VALUES(1, 'files/Gateway', 'paypal.png', NULL, 'App\\Models\\Gateway', 1, NULL, NULL, NULL),(2, 'files/Gateway', 'stripe.png', NULL, 'App\\Models\\Gateway', 2, NULL, NULL, NULL),(3, 'files/Gateway', 'razorpay.png', NULL, 'App\\Models\\Gateway', 3, NULL, NULL, NULL),(4, 'files/Gateway', 'instamojo.png', NULL, 'App\\Models\\Gateway', 4, NULL, NULL, NULL),(5, 'files/Gateway', 'mollie.png', NULL, 'App\\Models\\Gateway', 5, NULL, NULL, NULL),(6, 'files/Gateway', 'paystack.png', NULL, 'App\\Models\\Gateway', 6, NULL, NULL, NULL),(7, 'files/Gateway', 'sslcommerz.png', NULL, 'App\\Models\\Gateway', 7, NULL, NULL, NULL),(8, 'files/Gateway', 'flutterwave.png', NULL, 'App\\Models\\Gateway', 8, NULL, NULL, NULL),(9, 'files/Gateway', 'mercadopago.png', NULL, 'App\\Models\\Gateway', 9, NULL, NULL, NULL),(10, 'files/Gateway', 'bank.png', NULL, 'App\\Models\\Gateway', 10, NULL, NULL, NULL);
INSERT INTO `gateways` (id,owner_user_id, title, slug, image, status, mode, url, `key`, secret, created_at, updated_at, deleted_at) VALUES (1,2,'Paypal','paypal','assets/images/gateway-icon/paypal.jpg',1,2,'','','',NULL,NULL,NULL),(2,2,'Stripe','stripe','assets/images/gateway-icon/stripe.jpg',1,2,'','','',NULL,NULL,NULL),(3,2,'Razorpay','razorpay','assets/images/gateway-icon/razorpay.jpg',1,2,'','','',NULL,NULL,NULL),(4,2,'Instamojo','instamojo','assets/images/gateway-icon/instamojo.jpg',1,2,'','','',NULL,NULL,NULL),(5,2,'Mollie','mollie','assets/images/gateway-icon/mollie.jpg',1,2,'','','',NULL,NULL,NULL),(6,2,'Paystack','paystack','assets/images/gateway-icon/paystack.jpg',1,2,'','','',NULL,NULL,NULL),(7,2,'Sslcommerz','sslcommerz','assets/images/gateway-icon/sslcommerz.jpg',1,2,'','','',NULL,NULL,NULL),(8,2,'Flutterwave','flutterwave','assets/images/gateway-icon/flutterwave.jpg',1,2,'','','',NULL,NULL,NULL),(9,2,'Mercadopago','mercadopago','assets/images/gateway-icon/mercadopago.jpg',1,2,'','','',NULL,NULL,NULL),(10,2,'Bank','bank','assets/images/gateway-icon/bank.jpg',1,2,'','','',NULL,NULL,NULL),(11,2,'Cash','cash','assets/images/gateway-icon/cash.jpg',1,2,'','','',NULL,NULL,NULL);
INSERT INTO `gateway_currencies` (`id`, `gateway_id`, `currency`, `conversion_rate`, `created_at`, `updated_at`, `deleted_at`) VALUES(1, 1, 'USD', '1.00', NULL, NULL, NULL),(2, 2, 'USD', '1.00', NULL, NULL, NULL),(3, 3, 'INR', '80.00', NULL, NULL, NULL),(4, 4, 'INR', '80.00', NULL, NULL, NULL),(5, 5, 'USD', '1.00', NULL, NULL, NULL),(6, 6, 'NGN', '464.00', NULL, NULL, NULL),(7, 7, 'BDT', '100.00', NULL, NULL, NULL),(8, 8, 'NGN', '464.00', NULL, NULL, NULL),(9, 9, 'BRL', '5.00', NULL, NULL, NULL),(10, 10, 'USD', '1.00', NULL, NULL, NULL);
INSERT INTO `languages` (id,name, code, icon, rtl, status, `default`, created_at, updated_at, deleted_at) VALUES(1, 'English', 'en', NULL, 0, 1, 1, '2023-02-02 14:17:04', '2023-02-02 14:17:04', NULL);
INSERT INTO users (id,first_name, last_name, email, email_verified_at, password, contact_number, status, created_by, `role`, owner_user_id, remember_token, deleted_at, created_at, updated_at) VALUES(1,'Mr', 'Admin', 'admin@gmail.com', '2023-02-02 17:34:12.000', '$2y$10$QJ79PGQOQgVetj9TVY/ow.qPyGm7nFD9N91y4Tl6pJy50C9wIFa/i', '01951973806', 1, NULL, 4, NULL, 'sT3YHYYmFXC71oWxpQgAnJ6SJgiUU7RHyo7HaJpUPr3ReTcrT7khlasBsVfi', NULL, NULL, '2023-02-04 13:54:59.000'),(2,'Mr', 'Owner', 'owner@gmail.com', '2023-02-02 17:34:12.000', '$2y$10$QJ79PGQOQgVetj9TVY/ow.qPyGm7nFD9N91y4Tl6pJy50C9wIFa/i', '01952973806', 1, NULL, 1, 2, '7O53ovKAFazO3hOh3Y0aXqAmhvncPe7FRCQCP8pldES3v3tBvAsLrynD67Pf', NULL, NULL, '2023-02-04 13:54:59.000');
INSERT INTO owners (user_id, status, created_at, updated_at, deleted_at) VALUES(2, 1, '2023-03-27 15:21:38.000', '2023-03-27 15:21:38.000', NULL);
INSERT INTO `settings` VALUES (1,'build_version','8',NULL,'2023-02-02 11:34:12','2023-02-02 11:34:12',NULL),(2,'current_version','2.4',NULL,'2023-02-02 11:34:12','2023-02-02 11:34:12',NULL),(3,'app_name','Zaiproty',NULL,'2023-02-02 17:51:06','2023-02-02 17:51:06',NULL),(4,'app_email','admin@zaiproty.com',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(5,'app_contact_number','551728282',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(6,'app_location','USA',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(7,'app_copyright','Developed by Zaiproty',NULL,'2023-02-02 17:51:06','2023-02-06 04:50:26',NULL),(8,'app_developed_by','Zaiproty',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(9,'currency_id','1',NULL,'2023-02-02 17:51:06','2023-02-06 07:09:23',NULL),(10,'language_id','1',NULL,'2023-02-02 17:51:06','2023-02-02 17:51:06',NULL),(11,'app_preloader_status','2',NULL,'2023-02-02 17:51:06','2023-02-02 17:51:06',NULL),(12,'sign_in_text_title','You are signing in Ziaproty',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(13,'sign_in_text_subtitle','You are signing in Ziaproty',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(14,'meta_keyword','Zaiproty',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(15,'meta_author','Zaiproty',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(16,'revisit',NULL,NULL,'2023-02-02 17:51:06','2023-02-02 17:51:06',NULL),(17,'sitemap_link',NULL,NULL,'2023-02-02 17:51:06','2023-02-02 17:51:06',NULL),(18,'meta_description','Zaiproty',NULL,'2023-02-02 17:51:06','2023-02-04 09:45:55',NULL),(23,'website_primary_color','#3686FC',NULL,'2023-02-04 09:46:20','2023-02-06 07:08:05',NULL),(24,'website_secondary_color','#8253FB',NULL,'2023-02-04 09:46:20','2023-02-06 07:08:14',NULL),(25,'button_primary_color','#3686FC',NULL,'2023-02-04 09:46:20','2023-02-06 07:08:21',NULL),(26,'button_hover_color','#0063E6',NULL,'2023-02-04 09:46:20','2023-02-06 07:08:26',NULL),(27,'website_color_mode','0',NULL,'2023-02-04 09:46:20','2023-02-06 07:08:05',NULL),(28,'gateway_settings','{\"paypal\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Client ID\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret\",\"name\":\"secret\",\"is_show\":1}],\"stripe\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Public Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret Key\",\"name\":\"secret\",\"is_show\":0}],\"razorpay\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret\",\"name\":\"secret\",\"is_show\":1}],\"instamojo\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Api Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Auth Token\",\"name\":\"secret\",\"is_show\":1}],\"mollie\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Mollie Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret\",\"name\":\"secret\",\"is_show\":0}],\"paystack\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Public Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Secret Key\",\"name\":\"secret\",\"is_show\":0}],\"mercadopago\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Client ID\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Client Secret\",\"name\":\"secret\",\"is_show\":1}],\"sslcommerz\":[{\"label\":\"Url\",\"name\":\"url\",\"is_show\":0},{\"label\":\"Store ID\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Store Password\",\"name\":\"secret\",\"is_show\":1}],\"flutterwave\":[{\"label\":\"Hash\",\"name\":\"url\",\"is_show\":1},{\"label\":\"Public Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Client Secret\",\"name\":\"secret\",\"is_show\":1}],\"coinbase\":[{\"label\":\"Hash\",\"name\":\"url\",\"is_show\":0},{\"label\":\"API Key\",\"name\":\"key\",\"is_show\":1},{\"label\":\"Client Secret\",\"name\":\"secret\",\"is_show\":0}]}',NULL,'2023-02-22 20:49:54','2023-02-22 20:49:54',NULL);
INSERT INTO migrations (id, migration, batch) VALUES(1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(3, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(4, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(5, '2022_06_14_123059_create_metas_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(6, '2022_06_23_121213_create_settings_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(7, '2022_06_25_110824_create_currencies_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(8, '2022_06_25_111037_create_languages_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(9, '2022_10_03_070043_create_transactions_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(10, '2022_11_26_183258_create_file_managers_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(11, '2022_11_30_040739_create_gateways_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(12, '2022_11_30_043112_create_invoice_types_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(13, '2022_11_30_043152_create_ticket_topics_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(14, '2022_12_02_143113_create_properties_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(15, '2022_12_02_143115_create_property_details_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(16, '2022_12_02_150206_create_property_units_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(17, '2022_12_02_151705_create_property_images_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(18, '2022_12_12_120950_create_expense_types_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(19, '2022_12_12_121023_create_expenses_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(20, '2022_12_14_124619_create_tenants_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(21, '2022_12_14_152333_create_invoices_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(22, '2022_12_15_072303_create_tenant_details_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(23, '2022_12_19_184746_create_invoice_items_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(24, '2022_12_24_055810_create_information_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(25, '2022_12_24_134905_create_maintainers_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(26, '2022_12_26_093722_create_notice_boards_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(27, '2022_12_26_112846_create_notice_user_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(28, '2023_01_03_075827_create_gateway_currencies_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(29, '2023_01_07_120244_create_banks_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(30, '2023_01_08_093333_create_kyc_verifications_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(31, '2023_01_08_101846_create_kyc_configs_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(32, '2023_01_11_113946_create_maintenance_issues_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(33, '2023_01_11_130025_create_maintenance_requests_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(34, '2023_01_12_131452_create_tickets_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(35, '2023_01_22_070829_create_ticket_replies_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(36, '2023_01_30_071830_create_orders_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(37, '2023_02_01_094211_create_notifications_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(38, '2023_02_07_131801_create_invoice_recurring_settings_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(39, '2023_02_07_132102_create_invoice_recurring_setting_items_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(40, '2023_02_08_070028_add_field_to_invoices_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(41, '2023_02_11_130034_create_packages_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(42, '2023_02_26_123728_create_owners_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(43, '2023_02_27_051537_add_field_to_users_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(44, '2023_02_27_134555_create_owner_packages_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(45, '2023_02_28_060601_add_dependency_field_for_multi_owner_saas', 1);
INSERT INTO migrations (id, migration, batch) VALUES(46, '2023_03_06_115256_change_filed_to_tenant_details_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(47, '2023_03_06_125634_add_field_to_invoice_types_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(48, '2023_03_06_131839_add_field_to_expense_types_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(49, '2023_03_06_140942_add_field_to_invoice_items_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(50, '2023_03_06_141916_add_field_to_invoices_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(51, '2023_03_20_071848_create_features_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(52, '2023_03_20_100913_create_how_it_works_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(53, '2023_03_20_122923_create_core_pages_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(54, '2023_03_21_090904_create_testimonials_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(55, '2023_03_21_095818_create_faqs_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(56, '2023_03_23_130158_create_subscription_orders_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(57, '2023_03_28_063823_create_tax_settings_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(58, '2023_05_15_105919_add_field_font_id_to_languages_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(59, '2023_06_12_095437_create_sms_histories_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(60, '2023_06_14_062807_create_mail_histories_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(61, '2023_06_19_120927_create_messages_table', 1);
INSERT INTO migrations (id, migration, batch) VALUES(62, '2023_06_20_094453_add_field_type_to_tenants_table', 1);
SET FOREIGN_KEY_CHECKS=1;