
--
-- Table structure for table `user_meta`
--

CREATE TABLE `user_meta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_meta_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_meta`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_id` bigint unsigned DEFAULT NULL,
  `super_user` tinyint(1) NOT NULL DEFAULT '0',
  `manage_supers` tinyint(1) NOT NULL DEFAULT '0',
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `last_login` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin@archielite.com',NULL,'$2y$10$iv8FhYwQKJsWmEm4gV9ayeBDYj64Wt52Tm8NEKNM4Jkej/xOXnnH2',NULL,'2023-03-18 01:06:44','2023-03-18 01:06:44','System','Admin','admin',NULL,1,1,NULL,NULL);

--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `widget_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sidebar_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint unsigned NOT NULL DEFAULT '0',
  `data` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES (1,'NewsletterWidget','pre_footer_sidebar','jobbox',0,'{\"id\":\"NewsletterWidget\",\"title\":\"New Things Will Always <br> Update Regularly\",\"background_image\":\"general\\/newsletter-background-image.png\",\"image_left\":\"general\\/newsletter-image-left.png\",\"image_right\":\"general\\/newsletter-image-right.png\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(2,'SiteInformationWidget','footer_sidebar','jobbox',1,'{\"introduction\":\"JobBox is the heart of the design community and the best resource to discover and connect with designers and jobs worldwide.\",\"facebook_url\":\"#\",\"twitter_url\":\"#\",\"linkedin_url\":\"#\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(3,'CustomMenuWidget','footer_sidebar','jobbox',2,'{\"id\":\"CustomMenuWidget\",\"name\":\"Resources\",\"menu_id\":\"resources\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(4,'CustomMenuWidget','footer_sidebar','jobbox',3,'{\"id\":\"CustomMenuWidget\",\"name\":\"Community\",\"menu_id\":\"community\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(5,'CustomMenuWidget','footer_sidebar','jobbox',4,'{\"id\":\"CustomMenuWidget\",\"name\":\"Quick links\",\"menu_id\":\"quick-links\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(6,'CustomMenuWidget','footer_sidebar','jobbox',5,'{\"id\":\"CustomMenuWidget\",\"name\":\"More\",\"menu_id\":\"more\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(7,'DownloadWidget','footer_sidebar','jobbox',6,'{\"app_store_url\":\"#\",\"app_store_image\":\"general\\/app-store.png\",\"android_app_url\":\"#\",\"google_play_image\":\"general\\/android.png\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(8,'BlogSearchWidget','primary_sidebar','jobbox',1,'{\"id\":\"BlogSearchWidget\",\"name\":\"Search\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(9,'BlogCategoriesWidget','primary_sidebar','jobbox',2,'{\"id\":\"BlogCategoriesWidget\",\"name\":\"Categories\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(10,'BlogPostsWidget','primary_sidebar','jobbox',3,'{\"id\":\"BlogPostsWidget\",\"type\":\"popular\",\"name\":\"Popular Posts\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(11,'BlogTagsWidget','primary_sidebar','jobbox',4,'{\"id\":\"BlogTagsWidget\",\"name\":\"Popular Tags\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(12,'BlogSearchWidget','blog_sidebar','jobbox',0,'{\"id\":\"BlogSearchWidget\",\"name\":\"Blog Search\",\"description\":\"Search blog posts\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(13,'BlogPostsWidget','blog_sidebar','jobbox',1,'{\"id\":\"BlogPostsWidget\",\"name\":\"Blog posts\",\"description\":\"Blog posts widget.\",\"type\":\"popular\",\"number_display\":5}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(14,'AdsBannerWidget','blog_sidebar','jobbox',2,'{\"id\":\"AdsBannerWidget\",\"name\":\"Ads banner\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(15,'GalleryWidget','blog_sidebar','jobbox',3,'{\"id\":\"GalleryWidget\",\"name\":\"Gallery\",\"title_gallery\":\"Gallery\",\"number_image\":8}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(16,'AdsBannerWidget','candidate_sidebar','jobbox',0,'{\"id\":\"AdsBannerWidget\",\"name\":\"Ads banner\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(17,'AdsBannerWidget','company_sidebar','jobbox',0,'{\"id\":\"AdsBannerWidget\",\"name\":\"Ads banner\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(18,'NewsletterWidget','pre_footer_sidebar','jobbox-vi',0,'{\"id\":\"NewsletterWidget\",\"title\":\"M\\u1ecdi tin t\\u1ee9c \\u0111\\u1ec1u \\u0111\\u01b0\\u1ee3c <br> c\\u1eadp nh\\u1eadt th\\u01b0\\u1eddng xuy\\u00ean\",\"background_image\":\"general\\/newsletter-background-image.png\",\"image_left\":\"general\\/newsletter-image-left.png\",\"image_right\":\"general\\/newsletter-image-right.png\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(19,'SiteInformationWidget','footer_sidebar','jobbox-vi',1,'{\"introduction\":\"JobBox l\\u00e0 trung t\\u00e2m c\\u1ee7a c\\u1ed9ng \\u0111\\u1ed3ng thi\\u1ebft k\\u1ebf v\\u00e0 l\\u00e0 ngu\\u1ed3n t\\u00e0i nguy\\u00ean t\\u1ed1t nh\\u1ea5t \\u0111\\u1ec3 kh\\u00e1m ph\\u00e1 v\\u00e0 k\\u1ebft n\\u1ed1i v\\u1edbi c\\u00e1c nh\\u00e0 thi\\u1ebft k\\u1ebf v\\u00e0 c\\u00f4ng vi\\u1ec7c tr\\u00ean to\\u00e0n th\\u1ebf gi\\u1edbi.\",\"facebook_url\":\"#\",\"twitter_url\":\"#\",\"linkedin_url\":\"#\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(20,'CustomMenuWidget','footer_sidebar','jobbox-vi',2,'{\"id\":\"CustomMenuWidget\",\"name\":\"T\\u00e0i nguy\\u00ean\",\"menu_id\":\"resources\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(21,'CustomMenuWidget','footer_sidebar','jobbox-vi',3,'{\"id\":\"CustomMenuWidget\",\"name\":\"C\\u1ed9ng \\u0111\\u1ed3ng\",\"menu_id\":\"community\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(22,'CustomMenuWidget','footer_sidebar','jobbox-vi',4,'{\"id\":\"CustomMenuWidget\",\"name\":\"Li\\u00ean k\\u1ebft nhanh\",\"menu_id\":\"quick-links\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(23,'CustomMenuWidget','footer_sidebar','jobbox-vi',5,'{\"id\":\"CustomMenuWidget\",\"name\":\"C\\u00f2n th\\u00eam\",\"menu_id\":\"more\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(24,'DownloadWidget','footer_sidebar','jobbox-vi',6,'{\"app_store_url\":\"#\",\"app_store_image\":\"general\\/app-store.png\",\"android_app_url\":\"#\",\"google_play_image\":\"general\\/android.png\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(25,'BlogSearchWidget','primary_sidebar','jobbox-vi',1,'{\"id\":\"BlogSearchWidget\",\"name\":\"T\\u00ecm ki\\u1ebfm\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(26,'BlogCategoriesWidget','primary_sidebar','jobbox-vi',2,'{\"id\":\"BlogCategoriesWidget\",\"name\":\"Danh m\\u1ee5c\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(27,'BlogPostsWidget','primary_sidebar','jobbox-vi',3,'{\"id\":\"BlogPostsWidget\",\"type\":\"popular\",\"name\":\"B\\u00e0i vi\\u1ebft ph\\u1ed5 bi\\u1ebfn\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(28,'BlogTagsWidget','primary_sidebar','jobbox-vi',4,'{\"id\":\"BlogTagsWidget\",\"name\":\"Th\\u1ebb ph\\u1ed5 bi\\u1ebfn]\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(29,'BlogSearchWidget','blog_sidebar','jobbox-vi',0,'{\"id\":\"BlogSearchWidget\",\"name\":\"T\\u00ecm ki\\u1ebfm b\\u00e0i vi\\u1ebft\",\"description\":\"T\\u00ecm ki\\u1ebfm b\\u00e0i vi\\u1ebft blog\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(30,'BlogPostsWidget','blog_sidebar','jobbox-vi',1,'{\"id\":\"BlogPostsWidget\",\"name\":\"B\\u00e0i vi\\u1ebft Blog\",\"description\":\"Widget b\\u00e0i vi\\u1ebft Blog.\",\"type\":\"popular\",\"number_display\":5}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(31,'AdsBannerWidget','blog_sidebar','jobbox-vi',2,'{\"id\":\"AdsBannerWidget\",\"name\":\"Bi\\u1ec3u ng\\u1eef Ads\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(32,'GalleryWidget','blog_sidebar','jobbox-vi',3,'{\"id\":\"GalleryWidget\",\"name\":\"Th\\u01b0 vi\\u1ec7n \\u1ea3nh\",\"title_gallery\":\"Th\\u01b0 vi\\u1ec7n \\u1ea3nh\",\"number_image\":8}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(33,'AdsBannerWidget','candidate_sidebar','jobbox-vi',0,'{\"id\":\"AdsBannerWidget\",\"name\":\"Bi\\u1ec3u ng\\u1eef Ads\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2023-03-18 01:06:47','2023-03-18 01:06:47'),(34,'AdsBannerWidget','company_sidebar','jobbox-vi',0,'{\"id\":\"AdsBannerWidget\",\"name\":\"Bi\\u1ec3u ng\\u1eef Ads\",\"banner_ads\":\"widgets\\/widget-banner.png\",\"url\":\"\\/\"}','2023-03-18 01:06:47','2023-03-18 01:06:47');


