-- -------------------------------------------------------------
-- TablePlus 4.1.2(382)
--
-- https://tableplus.com/
--
-- Database: laravel_cms
-- Generation Time: 2021-09-15 02:21:25.6820
-- -------------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE TABLE `admins` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=active, 0=inactive',
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` bigint unsigned DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `admins_username_unique` (`username`),
UNIQUE KEY `admins_email_unique` (`email`),
KEY `admins_created_by_foreign` (`created_by`),
KEY `admins_updated_by_foreign` (`updated_by`),
KEY `admins_deleted_by_foreign` (`deleted_by`),
KEY `admins_first_name_index` (`first_name`),
KEY `admins_phone_no_index` (`phone_no`),
CONSTRAINT `admins_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `admins_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `admins_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `article_types` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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;
CREATE TABLE `blogs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`meta_description` text COLLATE utf8mb4_unicode_ci,
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>active, 0=>inactive',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` bigint unsigned DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `blogs_slug_unique` (`slug`),
KEY `blogs_created_by_foreign` (`created_by`),
KEY `blogs_updated_by_foreign` (`updated_by`),
KEY `blogs_deleted_by_foreign` (`deleted_by`),
CONSTRAINT `blogs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `blogs_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `blogs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache` (
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` int NOT NULL,
UNIQUE KEY `cache_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `categories` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`banner_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`logo_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`meta_description` text COLLATE utf8mb4_unicode_ci,
`parent_category_id` bigint unsigned DEFAULT NULL COMMENT 'Null if category is parent, else parent id',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>active, 0=>inactive',
`enable_bg` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=>active, 0=>inactive',
`bg_color` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FFFFFF',
`text_color` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '000000',
`priority` bigint unsigned NOT NULL DEFAULT '1',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` bigint unsigned DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `categories_slug_unique` (`slug`),
KEY `categories_created_by_foreign` (`created_by`),
KEY `categories_updated_by_foreign` (`updated_by`),
KEY `categories_deleted_by_foreign` (`deleted_by`),
KEY `categories_parent_category_id_foreign` (`parent_category_id`),
CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `categories_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `categories_parent_category_id_foreign` FOREIGN KEY (`parent_category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `categories_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `contacts` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = not seen by admin, 1 = seen by admin',
`admin_id` bigint unsigned DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `contacts_updated_by_foreign` (`updated_by`),
KEY `contacts_deleted_by_foreign` (`deleted_by`),
CONSTRAINT `contacts_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `contacts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `countries` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`flag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `countries_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `failed_jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `languages` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`short_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`flag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`banner` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`banner_caption` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`country_id` bigint unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `languages_code_unique` (`code`),
KEY `languages_country_id_foreign` (`country_id`),
CONSTRAINT `languages_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `migrations` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `model_has_permissions` (
`permission_id` bigint unsigned NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `model_has_roles` (
`role_id` bigint unsigned NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint unsigned NOT NULL,
PRIMARY KEY (`role_id`,`model_id`,`model_type`),
KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `oauth_access_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint unsigned DEFAULT NULL,
`client_id` bigint unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `oauth_auth_codes` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint unsigned NOT NULL,
`client_id` bigint unsigned NOT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `oauth_clients` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint unsigned DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
`personal_access_client` tinyint(1) NOT NULL,
`password_client` tinyint(1) NOT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `oauth_personal_access_clients` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`client_id` bigint unsigned NOT 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;
CREATE TABLE `oauth_refresh_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `pages` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`meta_description` text COLLATE utf8mb4_unicode_ci,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`banner_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category_id` bigint unsigned DEFAULT NULL COMMENT 'Null if page has no category',
`article_type_id` bigint unsigned DEFAULT NULL COMMENT 'If Article Belongs to a Type',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>active, 0=>inactive',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` bigint unsigned DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pages_slug_unique` (`slug`),
KEY `pages_created_by_foreign` (`created_by`),
KEY `pages_updated_by_foreign` (`updated_by`),
KEY `pages_deleted_by_foreign` (`deleted_by`),
KEY `pages_category_id_foreign` (`category_id`),
CONSTRAINT `pages_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `pages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `pages_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `pages_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) 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;
CREATE TABLE `permissions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`group_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `role_has_permissions` (
`permission_id` bigint unsigned NOT NULL,
`role_id` bigint unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`role_id`),
KEY `role_has_permissions_role_id_foreign` (`role_id`),
CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `roles` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `services` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`meta_description` text COLLATE utf8mb4_unicode_ci,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`banner_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category_id` bigint unsigned DEFAULT NULL COMMENT 'Null if page has no category',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=>active, 0=>inactive',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` bigint unsigned DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `services_slug_unique` (`slug`),
KEY `services_created_by_foreign` (`created_by`),
KEY `services_updated_by_foreign` (`updated_by`),
KEY `services_deleted_by_foreign` (`deleted_by`),
KEY `services_category_id_foreign` (`category_id`),
CONSTRAINT `services_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `services_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `services_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `services_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`site_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Geeks of Sydney',
`site_logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'logo.png',
`site_favicon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'favicon.ico',
`site_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_copyright_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_meta_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_meta_author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_contact_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_working_day_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_facebook_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_youtube_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_twitter_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_linkedin_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_custom_data1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_custom_data2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_custom_data3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`site_custom_data4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `settings_updated_by_foreign` (`updated_by`),
CONSTRAINT `settings_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `tracks` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`reference_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'If there is possible to keep any reference link',
`admin_id` bigint unsigned NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tracks_deleted_by_foreign` (`deleted_by`),
KEY `tracks_admin_id_foreign` (`admin_id`),
CONSTRAINT `tracks_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
CONSTRAINT `tracks_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `users` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=active, 0=inactive',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_by` bigint unsigned DEFAULT NULL,
`updated_by` bigint unsigned DEFAULT NULL,
`deleted_by` bigint unsigned DEFAULT NULL,
`language_id` bigint unsigned DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_username_unique` (`username`),
UNIQUE KEY `users_email_unique` (`email`),
KEY `users_first_name_index` (`first_name`),
KEY `users_phone_no_index` (`phone_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `admins` (`id`, `first_name`, `last_name`, `username`, `phone_no`, `email`, `email_verified_at`, `password`, `avatar`, `status`, `remember_token`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', '', 'superadmin', '019XXXXXXXX', 'superadmin@example.com', NULL, '$2y$10$clsFbJxGHyq5n9fZGNetJuiF6NkgDd90K2mMEYSRQViylvWeO3zbu', NULL, 1, NULL, NULL, NULL, NULL, NULL, '2021-09-14 15:59:42', '2021-09-14 15:59:42'),
(2, 'Admin', '', 'admin', '018XXXXXXXX', 'admin@example.com', NULL, '$2y$10$zcG5XXjUFjIS/Y/HsRdX7.ojNl2iqXoiJ1hqlIRlzcNY.GauKVbju', NULL, 1, NULL, NULL, NULL, NULL, NULL, '2021-09-14 15:59:42', '2021-09-14 15:59:42'),
(3, 'Editor', '', 'editor', '017XXXXXXXX', 'editor@example.com', NULL, '$2y$10$R1Mz6Ze17jClYcaOyAZ9uehiMe09V0tzL.qpk7zslE5Q2H4R51CxG', NULL, 1, NULL, NULL, NULL, NULL, NULL, '2021-09-14 15:59:42', '2021-09-14 15:59:42');
INSERT INTO `blogs` (`id`, `title`, `slug`, `image`, `description`, `meta_description`, `status`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'This is a simple blog from admin panel', 'this-is-a-simple-blog-from-admin-panel', NULL, '<div>Welcome to our blog <br /></div>', NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43'),
(2, 'This is a another blog from admin panel', 'this-is-a-another-blog-from-admin-panel', NULL, '<div>Welcome to our blog <br /></div>', NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43');
INSERT INTO `categories` (`id`, `name`, `slug`, `banner_image`, `logo_image`, `description`, `meta_description`, `parent_category_id`, `status`, `enable_bg`, `bg_color`, `text_color`, `priority`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'Application Developement', 'application-development', NULL, NULL, NULL, NULL, NULL, 1, 0, 'FFFFFF', '000000', 2, NULL, NULL, 1, NULL, '2021-09-14 15:59:43', '2021-09-14 17:02:54'),
(3, 'Computer Service', 'computer', NULL, NULL, NULL, NULL, NULL, 1, 0, 'FFFFFF', '000000', 1, NULL, NULL, 1, NULL, '2021-09-14 15:59:43', '2021-09-14 17:01:17'),
(4, 'Other', 'other', NULL, NULL, NULL, NULL, NULL, 1, 0, 'FFFFFF', '000000', 3, NULL, 1, NULL, NULL, '2021-09-14 17:02:37', '2021-09-14 17:02:37');
INSERT INTO `countries` (`id`, `name`, `code`, `flag`) VALUES
(1, 'United States of America', 'en', 'en.png'),
(2, 'Finland', 'fi', 'fi.png'),
(3, 'Germany', 'de', 'de.png'),
(4, 'Sweden', 'se', 'se.png'),
(5, 'Norwegian', 'no', 'no.png'),
(6, 'Greenland', 'dk', 'dk.png'),
(7, 'France', 'fr', 'fr.png'),
(8, 'Italy', 'it', 'it.png'),
(9, 'Spain', 'es', 'es.png'),
(10, 'Albanian', 'al', 'al.png'),
(11, 'Bangladesh', 'bn', 'bn.png');
INSERT INTO `languages` (`id`, `name`, `short_name`, `code`, `flag`, `banner`, `banner_caption`, `country`, `country_id`) VALUES
(1, 'English', 'Eng', 'en', 'en.png', NULL, NULL, 'United States of America', 1),
(2, 'Finnish', 'Finnish', 'fi', 'fi.png', NULL, NULL, 'Finland', 2),
(3, 'German', 'Deutsch', 'de', 'de.png', NULL, NULL, 'Germany', 3),
(4, 'Svenska', 'Svenska', 'se', 'se.png', NULL, NULL, 'Sweden', 4),
(5, 'Norsk', 'Norsk', 'no', 'no.png', NULL, NULL, 'Norwegian', 5),
(6, 'Dansk', 'Dansk', 'dk', 'dk.png', NULL, NULL, 'Greenland', 6),
(7, 'Francais', 'Francais', 'fr', 'fr.png', NULL, NULL, 'France', 7),
(8, 'English', 'Eng', 'it', 'it.png', NULL, NULL, 'Italy', 8),
(9, 'Italiano', 'Italiano', 'es', 'es.png', NULL, NULL, 'Spain', 9),
(10, 'Spannish', 'Espanol', 'al', 'al.png', NULL, NULL, 'Albanian', 10),
(11, 'Bangla', 'Bangla', 'bn', 'bn.png', NULL, NULL, 'Bangladesh', 11);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(2, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(3, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(4, '2016_06_01_000004_create_oauth_clients_table', 1),
(5, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(6, '2020_05_01_000000_create_admins_table', 1),
(7, '2020_05_01_0000040_create_settings_table', 1),
(8, '2020_05_01_000010_create_users_table', 1),
(9, '2020_05_01_000020_create_failed_jobs_table', 1),
(10, '2020_05_01_000030_create_password_resets_table', 1),
(11, '2020_05_01_000050_create_categories_table', 1),
(12, '2020_05_01_000060_create_pages_table', 1),
(13, '2020_05_01_000070_create_blogs_table', 1),
(14, '2020_05_01_000080_create_contacts_table', 1),
(15, '2020_05_01_000090_create_tracks_table', 1),
(16, '2021_02_03_061323_create_article_types_table', 1),
(17, '2021_02_27_184353_create_permission_tables', 1),
(18, '2021_02_27_185000_create_countries_table', 1),
(19, '2021_02_27_185728_create_languages_table', 1),
(20, '2021_08_07_071049_create_cache_table', 1),
(21, '2021_08_07_101047_create_services_table', 1);
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(2, 'App\\Models\\Admin', 1),
(2, 'App\\Models\\Admin', 2),
(3, 'App\\Models\\Admin', 3),
(4, 'App\\Models\\Admin', 1);
INSERT INTO `pages` (`id`, `title`, `slug`, `description`, `meta_description`, `image`, `banner_image`, `category_id`, `article_type_id`, `status`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us', '<div>Welcome to our about us page <br /></div>', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43'),
(2, 'Contact Us', 'contact-us', '<div>Welcome to our contact us page <br /></div>', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43');
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `group_name`, `created_at`, `updated_at`) VALUES
(1, 'dashboard.view', 'admin', 'dashboard', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(2, 'settings.view', 'admin', 'settings', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(3, 'settings.edit', 'admin', 'settings', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(4, 'permission.view', 'admin', 'permission', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(5, 'permission.create', 'admin', 'permission', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(6, 'permission.edit', 'admin', 'permission', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(7, 'permission.delete', 'admin', 'permission', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(8, 'admin.view', 'admin', 'admin', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(9, 'admin.create', 'admin', 'admin', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(10, 'admin.edit', 'admin', 'admin', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(11, 'admin.delete', 'admin', 'admin', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(12, 'admin_profile.view', 'admin', 'admin_profile', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(13, 'admin_profile.edit', 'admin', 'admin_profile', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(14, 'role.view', 'admin', 'role_manage', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(15, 'role.create', 'admin', 'role_manage', '2021-09-14 15:59:37', '2021-09-14 15:59:37'),
(16, 'role.edit', 'admin', 'role_manage', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(17, 'role.delete', 'admin', 'role_manage', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(18, 'user.view', 'admin', 'user', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(19, 'user.create', 'admin', 'user', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(20, 'user.edit', 'admin', 'user', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(21, 'user.delete', 'admin', 'user', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(22, 'category.view', 'admin', 'category', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(23, 'category.create', 'admin', 'category', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(24, 'category.edit', 'admin', 'category', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(25, 'category.delete', 'admin', 'category', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(26, 'page.view', 'admin', 'page', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(27, 'page.create', 'admin', 'page', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(28, 'page.edit', 'admin', 'page', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(29, 'page.delete', 'admin', 'page', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(30, 'service.view', 'admin', 'service', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(31, 'service.create', 'admin', 'service', '2021-09-14 15:59:38', '2021-09-14 15:59:38'),
(32, 'service.edit', 'admin', 'service', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(33, 'service.delete', 'admin', 'service', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(34, 'blog.view', 'admin', 'blog', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(35, 'blog.create', 'admin', 'blog', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(36, 'blog.edit', 'admin', 'blog', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(37, 'blog.delete', 'admin', 'blog', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(38, 'slider.view', 'admin', 'slider', '2021-09-14 15:59:39', '2021-09-14 15:59:39'),
(39, 'slider.create', 'admin', 'slider', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(40, 'slider.edit', 'admin', 'slider', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(41, 'slider.delete', 'admin', 'slider', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(42, 'tracking.view', 'admin', 'tracking', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(43, 'tracking.delete', 'admin', 'tracking', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(44, 'email_notification.view', 'admin', 'notifications', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(45, 'email_notification.edit', 'admin', 'notifications', '2021-09-14 15:59:40', '2021-09-14 15:59:40'),
(46, 'email_message.view', 'admin', 'notifications', '2021-09-14 15:59:41', '2021-09-14 15:59:41'),
(47, 'email_message.edit', 'admin', 'notifications', '2021-09-14 15:59:41', '2021-09-14 15:59:41'),
(48, 'module.view', 'admin', 'module', '2021-09-14 15:59:41', '2021-09-14 15:59:41'),
(49, 'module.create', 'admin', 'module', '2021-09-14 15:59:41', '2021-09-14 15:59:41'),
(50, 'module.edit', 'admin', 'module', '2021-09-14 15:59:41', '2021-09-14 15:59:41'),
(51, 'module.delete', 'admin', 'module', '2021-09-14 15:59:41', '2021-09-14 15:59:41'),
(52, 'module.toggle', 'admin', 'module', '2021-09-14 15:59:41', '2021-09-14 15:59:41');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 4),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(6, 4),
(7, 4),
(8, 4),
(9, 4),
(10, 4),
(11, 4),
(12, 4),
(13, 4),
(14, 4),
(15, 4),
(16, 4),
(17, 4),
(18, 4),
(19, 4),
(20, 4),
(21, 4),
(22, 4),
(23, 4),
(24, 4),
(25, 4),
(26, 4),
(27, 4),
(28, 4),
(29, 4),
(30, 4),
(31, 4),
(32, 4),
(33, 4),
(34, 4),
(35, 4),
(36, 4),
(37, 4),
(38, 4),
(39, 4),
(40, 4),
(41, 4),
(42, 4),
(43, 4),
(44, 4),
(45, 4),
(46, 4),
(47, 4),
(48, 4),
(49, 4),
(50, 4),
(51, 4),
(52, 4);
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Subscriber', 'admin', '2021-09-14 15:59:36', '2021-09-14 15:59:36'),
(2, 'Admin', 'admin', '2021-09-14 15:59:36', '2021-09-14 15:59:36'),
(3, 'Editor', 'admin', '2021-09-14 15:59:36', '2021-09-14 15:59:36'),
(4, 'Super Admin', 'admin', '2021-09-14 15:59:37', '2021-09-14 15:59:37');
INSERT INTO `services` (`id`, `title`, `slug`, `description`, `meta_description`, `image`, `banner_image`, `category_id`, `status`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'Laptop/Macbook Repair', 'laptop-macbook-repair', 'In present day time almost every individual works on the laptop, no matter you are a college student, working professional or a businessman. With technological advancements, there are many new ranges and features of laptops seen coming up on the market, but like any other electronic goods, it too needs maintenance and repair. We brings for you customized solution to repair laptops anytime around the country. Our team has enough experience at the back, and they can help repairing any simple or complex laptop problems at ease.\n <br />\n We are popular for fast and friendly service, call us anytime, and we will offer laptop services on your doorstep. We are popular because of our customer friendly attitude and quick turnaround time. Apart from that, we offer an affordable solution for all your laptop repairing services. With We, you can find all original and genuine laptop parts and accessories. Our team is reachable around the clock, and we will make sure your device is functioning in quickest possible time.\n <br />\n Many clients around the country introduce us as \"laptop specialist\" and its all because of our dedication and professional in solving all problems at ease. We are presently reputed and popular laptop repairing and accessories network in the whole of Australia. At We, we make sure that you laptop repairing experience is easy, fast and hassle free. What\'s more interesting about our services is that we have a range of utility, quality and fashionable accessories that makeover and protects your close friend ? your laptop.\n <br />\n Some of our services particularly aimed at for businesses\n <br />\n <ul>\n <li>Desktop support ? Maintenance, installation and repair.</li>\n <li>Software support including installation, registration and provision.</li>\n <li>Hardware support including provision, installation, set up and repair.</li>\n <li>Network system set up and configuration.</li>\n <li>Application support- Web apps, mobile apps, etc.</li>\n <li>Virus prevention, protection and removal.</li>\n <li>Server installation and maintenance.</li>\n <li>WiFi network system set up.</li>\n </ul>', NULL, 'service-laptop-macbook-repair.jpg', 'service-laptop-macbook-repair-banner.jpg', NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43'),
(2, 'Computer Repair', 'computer-repair', 'We can repair all models and ranges of computers.\n Call us now, and our team will provide a great solution for desktops, server, computer, smartphone, game accessories and all peripherals such as cameras, scanners, and printers. Our team responds immediately after getting your call; we will make sure your system is back to work in quickest possible time. Our team is available anytime, and we don\'t charge anything extra for nights and weekends. Our computer repairing services are based in Australia, and our geeks are all certified computer repairing professionals.\n <br />\n We understand the importance of computer in your life; our experts will make sure that the device is functional in quickest possible time. We assure you of all repairing services; our geeks will reach your home or business location to fix the problem. We provides a full guarantee on work, and we are known in the market for our fast and flawless computer repairing services.\n <br />\n Have full trust on We; our team will never let you down.', NULL, 'service-computer-repair.jpg', 'service-computer-repair-banner.jpg', NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43'),
(3, 'Web Application Development', 'web-application-development', 'Services for your future web or mobile applications.\n <br />\n\n Our services focuses on the following things -\n <ul>\n <li>Web application development</li>\n <li>Mobile application development</li>\n <li>Website Design</li>\n <li>Mobile App Design</li>\n <li>Management of business IT infrastructure.</li>\n </ul>\n ', NULL, 'service-web-application.jpg', 'service-web-application-banner.jpg', NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43'),
(4, 'Data Backup & Recovery', 'data-backup-recovery', 'We believe in providing the best possible solution for homes as well as businesses. We always believe in meeting the need of our clients and helping them get back to work in quickest possible time. Life is completely dependent on these gadgets these days, and we strive hard to provide an affordable and quality solution for your business and home. All our geeks are skilled and trained to offer top notch services.\n <br />\n We believe all important data are stored in computer systems; We will assure you of data recovery, the storage set up and back up in best possible manner. Our customer data recovery and backup services are designed for home and business; call our geeks today to help you provide the best of deals. Our professionals will make sure you lever lose your precious data by backing it up. We takes up every data recovery assignment with utmost proficiency.\n <br />\n Here are some of the services on offer with us:\n <br />\n We offer data recovery services for all media devices.\n <br />\n <ul>\n <li>All our data recovery systems are confidential and secure.</li>\n <li>We assure you of fastest data recovery services in the country.</li>\n <li>Our team uses some of the best and latest technologies for data recovery.</li>\n <li>Apart from that our team of geeks will help you by backing up useful files for your home or office.</li>\n </ul>\n ', NULL, 'service-data-recovery.jpg', 'service-data-recovery-banner.jpg', NULL, 1, NULL, NULL, NULL, NULL, '2021-09-14 15:59:43', '2021-09-14 15:59:43');
INSERT INTO `tracks` (`id`, `title`, `description`, `reference_link`, `admin_id`, `deleted_at`, `deleted_by`, `created_at`, `updated_at`) VALUES
(1, 'computer', 'Category has been updated successfully !!', NULL, 1, NULL, NULL, '2021-09-14 17:01:17', '2021-09-14 17:01:17'),
(2, 'application', 'Category has been updated successfully !!', NULL, 1, NULL, NULL, '2021-09-14 17:01:52', '2021-09-14 17:01:52'),
(3, 'application-development', 'Category has been updated successfully !!', NULL, 1, NULL, NULL, '2021-09-14 17:02:24', '2021-09-14 17:02:24'),
(4, 'Other', 'New Category has been created', NULL, 1, NULL, NULL, '2021-09-14 17:02:37', '2021-09-14 17:02:37'),
(5, 'application-development', 'Category has been updated successfully !!', NULL, 1, NULL, NULL, '2021-09-14 17:02:54', '2021-09-14 17:02:54');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
Download
