text: -- --------------------------------------------------------
  -- Host:                         localhost
  -- Server version:               5.7.24 - MySQL Community Server (GPL)
  -- Server OS:                    Win64
  -- HeidiSQL Version:             10.2.0.5599
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!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' */;
  
  
  -- Dumping database structure for euraka-live
  CREATE DATABASE IF NOT EXISTS `euraka-live` /*!40100 DEFAULT CHARACTER SET latin1 */;
  USE `euraka-live`;
  
  -- Dumping structure for table euraka-live.activity_log
  CREATE TABLE IF NOT EXISTS `activity_log` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `logname` varchar(255) NOT NULL,
    `description` varchar(255) NOT NULL,
    `subject_id` int(10) NOT NULL,
    `subject_type` varchar(255) NOT NULL,
    `cause_id` int(10) NOT NULL,
    `cause_type` varchar(255) NOT NULL,
    `properties` text NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.badges
  CREATE TABLE IF NOT EXISTS `badges` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `level` tinyint(4) NOT NULL DEFAULT '1',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.campaigns
  CREATE TABLE IF NOT EXISTS `campaigns` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `campaign` varchar(50) NOT NULL,
    `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.campaign_user
  CREATE TABLE IF NOT EXISTS `campaign_user` (
    `user_id` int(11) NOT NULL,
    `campaign_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.categories
  CREATE TABLE IF NOT EXISTS `categories` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `title` varchar(50) CHARACTER SET latin1 NOT NULL,
    `slug` varchar(150) CHARACTER SET latin1 NOT NULL,
    `parent_id` int(10) NOT NULL,
    `image` varchar(70) CHARACTER SET latin1 DEFAULT NULL,
    `status` enum('active','inactive') CHARACTER SET latin1 NOT NULL,
    `about_user` text CHARACTER SET latin1,
    `created_by` int(10) NOT NULL,
    `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.challenges
  CREATE TABLE IF NOT EXISTS `challenges` (
    `id` int(10) NOT NULL,
    `title` varchar(50) NOT NULL,
    `slug` varchar(50) NOT NULL,
    `description` text NOT NULL,
    `image` varchar(70) DEFAULT NULL,
    `status` enum('active','inactive') NOT NULL,
    `active_from` datetime NOT NULL,
    `created_by` int(10) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.challenges_categories
  CREATE TABLE IF NOT EXISTS `challenges_categories` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `challenge_id` int(10) NOT NULL,
    `categorie_id` int(10) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.comments
  CREATE TABLE IF NOT EXISTS `comments` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `user_id` int(10) NOT NULL,
    `post_id` int(10) NOT NULL,
    `parent_id` int(10) NOT NULL,
    `body` text NOT NULL,
    `updated_at` datetime NOT NULL,
    `created_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.contributors
  CREATE TABLE IF NOT EXISTS `contributors` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `first_name` varchar(50) NOT NULL,
    `last_name` varchar(50) NOT NULL,
    `slug` varchar(150) NOT NULL,
    `display_name` varchar(50) NOT NULL,
    `email` varchar(50) NOT NULL,
    `email_verified_at` datetime NOT NULL,
    `mobile` varchar(50) DEFAULT NULL,
    `image` varchar(50) DEFAULT NULL,
    `address` varchar(50) DEFAULT NULL,
    `branch_id` int(10) NOT NULL,
    `country_id` int(10) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.contributors_friends
  CREATE TABLE IF NOT EXISTS `contributors_friends` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `user_id` int(10) NOT NULL,
    `friend_id` int(10) NOT NULL,
    `requested_date` datetime NOT NULL,
    `accepted_date` datetime DEFAULT NULL,
    `status` varchar(50) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.contributor_campaign
  CREATE TABLE IF NOT EXISTS `contributor_campaign` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `branch` varchar(50) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.countries
  CREATE TABLE IF NOT EXISTS `countries` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NOT NULL,
    `short_code` varchar(50) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    `status` enum('active','inactive') DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.likabale_counters
  CREATE TABLE IF NOT EXISTS `likabale_counters` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `likable_id` varchar(36) NOT NULL,
    `likable_type` varchar(150) NOT NULL,
    `count` int(10) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.likable_like
  CREATE TABLE IF NOT EXISTS `likable_like` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `likable_id` varchar(36) NOT NULL,
    `likable_type` varchar(150) NOT NULL,
    `user_id` int(10) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.migrations
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.notifications
  CREATE TABLE IF NOT EXISTS `notifications` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `type` varchar(255) NOT NULL,
    `notifiable` varchar(255) NOT NULL,
    `data` text NOT NULL,
    `read_at` datetime NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.password_resets
  CREATE TABLE IF NOT EXISTS `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`(191))
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.permissions
  CREATE TABLE IF NOT EXISTS `permissions` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(191) 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_unique` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.permission_role
  CREATE TABLE IF NOT EXISTS `permission_role` (
    `permission_id` int(10) unsigned NOT NULL,
    `role_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`permission_id`,`role_id`),
    KEY `permission_role_role_id_foreign` (`role_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.reputations
  CREATE TABLE IF NOT EXISTS `reputations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `point` mediumint(9) NOT NULL DEFAULT '0',
    `subject_id` int(11) DEFAULT NULL,
    `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payee_id` int(10) unsigned DEFAULT NULL,
    `meta` text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.roles
  CREATE TABLE IF NOT EXISTS `roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `roles_name_unique` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.role_user
  CREATE TABLE IF NOT EXISTS `role_user` (
    `user_id` int(10) unsigned NOT NULL,
    `role_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`user_id`,`role_id`),
    KEY `role_user_role_id_foreign` (`role_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.users
  CREATE TABLE IF NOT EXISTS `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `reputation` int(10) unsigned NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table euraka-live.user_badges
  CREATE TABLE IF NOT EXISTS `user_badges` (
    `user_id` int(10) unsigned NOT NULL,
    `badge_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`user_id`,`badge_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  