text: -- MySQL dump 10.13  Distrib 5.7.15, for Linux (x86_64)
  --
  -- Host: localhost    Database: lmjfdb
  -- ------------------------------------------------------
  -- Server version	5.7.15-0ubuntu0.16.04.1
  
  /*!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 utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!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 */;
  
  --
  -- Table structure for table `Absence`
  --
  
  DROP TABLE IF EXISTS `Absence`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Absence` (
    `studentMatricule` varchar(45) NOT NULL,
    `TimePeriodID` int(11) NOT NULL,
    `Date` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`studentMatricule`,`TimePeriodID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Absence`
  --
  
  
  --
  -- Table structure for table `AverageGrade`
  --
  
  DROP TABLE IF EXISTS `AverageGrade`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `AverageGrade` (
    `studentMatricule` int(11) NOT NULL,
    `semestreID` int(11) NOT NULL,
    `comitteeAppreciation` varchar(45) DEFAULT NULL,
    `position` varchar(45) DEFAULT NULL,
    `NbrStudent` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`studentMatricule`,`semestreID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `AverageGrade`
  --
  --
  -- Table structure for table `Classroom`
  --
  
  DROP TABLE IF EXISTS `Classroom`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Classroom` (
    `classRoomID` int(11) NOT NULL AUTO_INCREMENT,
    `classRomLocationName` varchar(45) DEFAULT NULL,
    `typeClassRoom` varchar(45) DEFAULT NULL,
    `BuildingLevel` varchar(45) DEFAULT NULL,
    `ClassRoomName` varchar(45) DEFAULT NULL,
    `ClassRoomDescription` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`classRoomID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Classroom`
  --
  
  --
  -- Table structure for table `Course`
  --
  
  DROP TABLE IF EXISTS `Course`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Course` (
    `courseID` int(11) NOT NULL AUTO_INCREMENT,
    `cycleID` int(11) DEFAULT NULL,
    `courseName` varchar(45) DEFAULT NULL,
    `courseDescription` varchar(45) DEFAULT NULL,
    `courseCoeff` varchar(45) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`courseID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Course`
  --
  
  --
  -- Table structure for table `CourseChild`
  --
  
  DROP TABLE IF EXISTS `CourseChild`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `CourseChild` (
    `CourseChildID` int(11) NOT NULL AUTO_INCREMENT,
    `courseID` int(11) NOT NULL,
    `labelCourse` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`CourseChildID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `CourseChild`
  --
  --
  -- Table structure for table `CourseSchedule`
  --
  
  DROP TABLE IF EXISTS `CourseSchedule`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `CourseSchedule` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `CourseID` int(11) NOT NULL,
    `TimePeriodID` int(11) NOT NULL,
    `ClassRoomID` int(11) NOT NULL,
    `TeacherID` int(11) 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=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `CourseSchedule`
  --
  
  --
  -- Table structure for table `Cycle`
  --
  
  DROP TABLE IF EXISTS `Cycle`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Cycle` (
    `cycleID` int(11) NOT NULL AUTO_INCREMENT,
    `cycleName` varchar(45) DEFAULT NULL,
    `typeCycle` varchar(45) DEFAULT NULL,
    `cycleDescription` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`cycleID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Cycle`
  --
  
  
  --
  -- Table structure for table `Parent`
  --
  
  DROP TABLE IF EXISTS `Parent`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Parent` (
    `parentID` int(11) NOT NULL AUTO_INCREMENT,
    `parentFistName` varchar(45) DEFAULT NULL,
    `parentLastName` varchar(255) DEFAULT NULL,
    `parentPassword` varchar(45) DEFAULT NULL,
    `parentTelephone` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`parentID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Parent`
  --
  
  --
  -- Table structure for table `ProfPrincipal`
  --
  
  DROP TABLE IF EXISTS `ProfPrincipal`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `ProfPrincipal` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `idTeacher` int(11) NOT NULL,
    `classRoomID` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `ProfPrincipal`
  --
  
  --
  -- Table structure for table `Retard`
  --
  
  DROP TABLE IF EXISTS `Retard`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Retard` (
    `studentMatricule` varchar(45) NOT NULL,
    `TimePeriodID` int(11) NOT NULL,
    `Date` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`studentMatricule`,`TimePeriodID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Retard`
  --
  
  --
  -- Table structure for table `Semestre`
  --
  
  DROP TABLE IF EXISTS `Semestre`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Semestre` (
    `semestreID` int(11) NOT NULL AUTO_INCREMENT,
    `semestreDescription` varchar(45) DEFAULT NULL,
    `academicYear` varchar(45) NOT NULL,
    `startDate` varchar(45) NOT NULL,
    `endDate` varchar(45) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`semestreID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Semestre`
  --
  
  
  --
  -- Table structure for table `Student`
  --
  
  DROP TABLE IF EXISTS `Student`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Student` (
    `studentMatricule` varchar(45) NOT NULL,
    `classRoomID` int(11) NOT NULL,
    `studentParentID` int(11) NOT NULL,
    `studentName` varchar(255) NOT NULL,
    `studentLastName` varchar(255) NOT NULL,
    `studentBirthdate` varchar(45) NOT NULL,
    `studentSexe` varchar(1) NOT NULL,
    `studentBirthPlace` varchar(225) DEFAULT NULL,
    `responsableStudent` varchar(45) NOT NULL,
    `contactresponsableStudent` varchar(45) NOT NULL,
    `studentRegime` varchar(45) DEFAULT NULL,
    `studentInterne` varchar(45) DEFAULT NULL,
    `studentAffecte` varchar(45) DEFAULT NULL,
    `studentRedoublant` tinyint(1) DEFAULT '0',
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `academicYear` varchar(45) NOT NULL,
    PRIMARY KEY (`studentMatricule`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Student`
  --
  
  --
  -- Table structure for table `Teacher`
  --
  
  DROP TABLE IF EXISTS `Teacher`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Teacher` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `idTeacher` int(11) NOT NULL,
    `courseID` int(11) NOT NULL,
    `classRoomID` int(11) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `pp` tinyint(4) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Teacher`
  --
  
  --
  -- Table structure for table `Time_period`
  --
  
  DROP TABLE IF EXISTS `Time_period`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Time_period` (
    `TimePeriodID` int(11) NOT NULL AUTO_INCREMENT,
    `StartHour` varchar(45) DEFAULT NULL,
    `EndHour` varchar(45) DEFAULT NULL,
    `DayOFWeek` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`TimePeriodID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Time_period`
  --
  
  
  --
  -- Table structure for table `anneeScolaire`
  --
  
  DROP TABLE IF EXISTS `anneeScolaire`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `anneeScolaire` (
    `academicYear` varchar(45) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`academicYear`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `anneeScolaire`
  --
  
  --
  -- Table structure for table `courseGrade`
  --
  
  DROP TABLE IF EXISTS `courseGrade`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `courseGrade` (
    `studentMatricule` int(11) NOT NULL,
    `semestreID` int(11) NOT NULL,
    `testID` int(11) NOT NULL,
    `Grade` varchar(45) DEFAULT NULL,
    `Appreciation` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`studentMatricule`,`semestreID`,`testID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `courseGrade`
  --
  
  --
  -- Table structure for table `courseTest`
  --
  
  DROP TABLE IF EXISTS `courseTest`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `courseTest` (
    `CoursetestID` int(11) NOT NULL AUTO_INCREMENT,
    `semestreID` int(11) NOT NULL,
    `CourseChildID` int(11) NOT NULL,
    `teacherID` int(11) NOT NULL,
    `classRoomID` int(11) DEFAULT NULL,
    `testName` varchar(225) DEFAULT NULL,
    `testDescription` varchar(225) DEFAULT NULL,
    `maxGradevalue` varchar(45) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`CoursetestID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `courseTest`
  --
  
  --
  -- 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(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migrations`
  --
  
  --
  -- 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(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`),
    KEY `password_resets_token_index` (`token`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `password_resets`
  --
  
  --
  -- Table structure for table `roles`
  --
  
  DROP TABLE IF EXISTS `roles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT 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=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `roles`
  --
  
  --
  -- Table structure for table `roles_user`
  --
  
  DROP TABLE IF EXISTS `roles_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `roles_user` (
    `roles_id` int(10) unsigned NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`roles_id`,`user_id`),
    KEY `role_user_role_id_index` (`roles_id`),
    KEY `role_user_user_id_index` (`user_id`),
    CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`roles_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
    CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `roles_user`
  --
  --
  -- 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` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `userFirstName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `userLastName` varchar(255) COLLATE utf8_unicode_ci  NULL,
    `userContact` varchar(255) COLLATE utf8_unicode_ci  NULL,
    `email` varchar(255) CHARACTER SET utf8  NULL,
    `password` varchar(255) CHARACTER SET utf8  NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_userlogin_unique` (`email`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  