-- Adminer 4.8.1 MySQL 8.0.31-0ubuntu0.22.04.1 dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';


CREATE TABLE `bussiness` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `documents` (
  `deleted_at` timestamp NULL DEFAULT NULL,
  `added_by` int NOT NULL,
  `mimetype` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `unique_id` int NOT NULL,
  `extension` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size_1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size_2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stored_at` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder_id` int DEFAULT NULL,
  `tag_id` bigint unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `document_unique_id` (`unique_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `documents` (`deleted_at`, `added_by`, `mimetype`, `id`, `name`, `unique_id`, `extension`, `size_1`, `size_2`, `stored_at`, `path`, `public_url`, `folder_id`, `tag_id`, `title`, `description`, `created_at`, `updated_at`) VALUES
('0000-00-00 00:00:00',	1,	'application/octet-stream',	20,	'LICENCE',	85538124,	'',	'1.025390625',	NULL,	NULL,	'uploads_blog/1693222554_85538124.',	NULL,	0,	NULL,	NULL,	NULL,	'2023-08-28 06:05:54',	'2023-08-28 06:05:54'),
('0000-00-00 00:00:00',	1,	'application/x-yaml',	21,	'.travis.yml',	92563660,	'yml',	'0.119140625',	NULL,	NULL,	'uploads_blog/1693222555_92563660.yml',	NULL,	0,	NULL,	NULL,	NULL,	'2023-08-28 06:05:55',	'2023-08-28 06:05:55'),
('0000-00-00 00:00:00',	1,	'application/octet-stream',	22,	'.npmignore',	68914484,	'npmignore',	'0.021484375',	NULL,	NULL,	'uploads_blog/1693222555_68914484.npmignore',	NULL,	0,	NULL,	NULL,	NULL,	'2023-08-28 06:05:55',	'2023-08-28 06:05:55'),
('0000-00-00 00:00:00',	1,	'image/png',	26,	'filelogo.png',	14430241,	'png',	'13.4248046875',	NULL,	NULL,	'uploads_blog/1693288523_14430241.png',	NULL,	1,	NULL,	NULL,	NULL,	'2023-08-29 00:25:23',	'2023-08-29 00:25:23'),
('0000-00-00 00:00:00',	1,	'application/sql',	27,	'add_bussiness_col.sql',	64604373,	'sql',	'4.0830078125',	NULL,	NULL,	'uploads_blog/1693288563_64604373.sql',	NULL,	1,	NULL,	NULL,	NULL,	'2023-08-29 00:26:03',	'2023-08-29 00:26:03'),
(NULL,	1,	'application/x-php',	36,	'imglib_lang.php',	44708759,	'php',	'3.5712890625',	NULL,	NULL,	'uploads_blog/1693291203_44708759.php',	NULL,	19,	NULL,	NULL,	NULL,	'2023-08-29 01:10:03',	'2023-08-29 01:10:03'),
(NULL,	1,	'text/html',	37,	'index.html',	70836781,	'html',	'0.1279296875',	NULL,	NULL,	'uploads_blog/1693291234_70836781.html',	NULL,	0,	NULL,	NULL,	NULL,	'2023-08-29 01:10:34',	'2023-08-29 01:10:34'),
(NULL,	1,	'application/x-php',	38,	'email_lang.php',	51092971,	'php',	'3.328125',	NULL,	NULL,	'uploads_blog/1693291253_51092971.php',	NULL,	20,	NULL,	NULL,	NULL,	'2023-08-29 01:10:53',	'2023-08-29 01:10:53'),
(NULL,	1,	'application/x-php',	39,	'form_validation_lang.php',	28827472,	'php',	'4.595703125',	NULL,	NULL,	'uploads_blog/1693291253_28827472.php',	NULL,	20,	NULL,	NULL,	NULL,	'2023-08-29 01:10:53',	'2023-08-29 01:10:53'),
(NULL,	1,	'image/webp',	40,	'aws-1.webp',	99465494,	'webp',	'75.3046875',	NULL,	NULL,	'uploads_blog/1693308382_99465494.webp',	NULL,	1,	NULL,	NULL,	NULL,	'2023-08-29 05:56:22',	'2023-08-29 05:56:22'),
(NULL,	1,	'image/png',	41,	'spaces_-LvYaleNV5XzR7yihd_K_uploads_git-blob-8fa81da7967760246ddfebb87eacd536aa6832d5_home_screen.png',	17535682,	'png',	'167.4248046875',	NULL,	NULL,	'uploads_blog/1693314562_17535682.png',	NULL,	21,	NULL,	NULL,	NULL,	'2023-08-29 07:39:22',	'2023-08-29 07:39:22'),
(NULL,	1,	'text/markdown',	42,	'CHANGELOG.md',	66505285,	'md',	'1.7578125',	NULL,	NULL,	'uploads_blog/1693480653_66505285.md',	NULL,	19,	NULL,	NULL,	NULL,	'2023-08-31 05:47:33',	'2023-08-31 05:47:33'),
(NULL,	1,	'application/octet-stream',	43,	'LICENSE',	52965632,	'',	'1.0654296875',	NULL,	NULL,	'uploads_blog/1693480653_52965632.',	NULL,	19,	NULL,	NULL,	NULL,	'2023-08-31 05:47:33',	'2023-08-31 05:47:33'),
(NULL,	1,	'application/x-javascript',	44,	'karma.conf.js',	65415012,	'js',	'1.4169921875',	NULL,	NULL,	'uploads_blog/1693480653_65415012.js',	NULL,	19,	NULL,	NULL,	NULL,	'2023-08-31 05:47:33',	'2023-08-31 05:47:33'),
(NULL,	1,	'application/sql',	45,	'abc.sql',	21748111,	'sql',	'0.4462890625',	NULL,	NULL,	'uploads_blog/1693682409_21748111.sql',	NULL,	20,	NULL,	NULL,	NULL,	'2023-09-02 13:50:09',	'2023-09-02 13:50:09'),
(NULL,	1,	'application/sql',	46,	'add_bussiness_col.sql',	56217972,	'sql',	'4.0830078125',	NULL,	NULL,	'uploads_blog/1693810895_56217972.sql',	NULL,	19,	NULL,	NULL,	NULL,	'2023-09-04 01:31:35',	'2023-09-04 01:31:35');

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) 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;


CREATE TABLE `folder_directory` (
  `section_id` int DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `folder_name` varchar(100) NOT NULL,
  `parent_folder_id` int DEFAULT NULL,
  `added_by` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `folder_directory` (`section_id`, `id`, `folder_name`, `parent_folder_id`, `added_by`, `created_at`, `updated_at`) VALUES
(1,	1,	'Folder B',	0,	1,	'2023-08-28 01:30:58',	'2023-08-28 01:30:58'),
(1,	12,	'folder 109',	0,	1,	'2023-08-28 05:54:58',	'2023-08-28 05:54:58'),
(1,	19,	'dsd',	1,	1,	'2023-08-29 01:08:53',	'2023-08-29 01:08:53'),
(1,	20,	'r44',	0,	1,	'2023-08-29 01:10:43',	'2023-08-29 01:10:43'),
(1,	21,	'f5',	19,	1,	'2023-08-29 05:56:53',	'2023-08-29 05:56:53'),
(1,	22,	'some 89',	12,	1,	'2023-08-29 07:28:39',	'2023-08-29 07:28:39'),
(1,	23,	'c2',	22,	1,	'2023-08-29 07:28:48',	'2023-08-29 07:28:48'),
(1,	24,	'y7',	21,	1,	'2023-08-29 07:39:08',	'2023-08-29 07:39:08');

CREATE TABLE `group` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `bussiness_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1,	'2014_10_12_000000_create_users_table',	1),
(2,	'2014_10_12_100000_create_password_resets_table',	1),
(3,	'2016_06_01_000001_create_oauth_auth_codes_table',	1),
(4,	'2016_06_01_000002_create_oauth_access_tokens_table',	1),
(5,	'2016_06_01_000003_create_oauth_refresh_tokens_table',	1),
(6,	'2016_06_01_000004_create_oauth_clients_table',	1),
(7,	'2016_06_01_000005_create_oauth_personal_access_clients_table',	1),
(8,	'2019_08_19_000000_create_failed_jobs_table',	1),
(9,	'2019_12_14_000001_create_personal_access_tokens_table',	1),
(10,	'2023_08_18_050237_create_group_models_table',	1),
(11,	'2023_08_18_050406_create_role_models_table',	1);

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci 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_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` char(36) 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;

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1,	'99f4fd93-4cea-49c8-9ed9-bdea38702344',	'2023-08-23 01:47:33',	'2023-08-23 01:47:33');


CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 2023-09-04 09:17:31
