text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50549
  Source Host           : localhost:3306
  Source Database       : pooq
  
  Target Server Type    : MYSQL
  Target Server Version : 50549
  File Encoding         : 65001
  
  Date: 2016-06-07 15:39:27
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for migrations
  -- ----------------------------
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE `migrations` (
  `migration`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `batch`  int(11) NOT NULL 
  )
  ENGINE=InnoDB
  DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
  
  ;
  
  -- ----------------------------
  -- Records of migrations
  -- ----------------------------
  BEGIN;
  INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table', '1'), ('2014_10_12_100000_create_password_resets_table', '1'), ('2016_06_07_062214_create_roles_table', '1');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for password_resets
  -- ----------------------------
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE `password_resets` (
  `email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `token`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `created_at`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
  INDEX `password_resets_email_index` (`email`) USING BTREE ,
  INDEX `password_resets_token_index` (`token`) USING BTREE 
  )
  ENGINE=InnoDB
  DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
  
  ;
  
  -- ----------------------------
  -- Records of password_resets
  -- ----------------------------
  BEGIN;
  COMMIT;
  
  -- ----------------------------
  -- Table structure for roles
  -- ----------------------------
  DROP TABLE IF EXISTS `roles`;
  CREATE TABLE `roles` (
  `id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `created_at`  timestamp NULL DEFAULT NULL ,
  `updated_at`  timestamp NULL DEFAULT NULL ,
  PRIMARY KEY (`id`)
  )
  ENGINE=InnoDB
  DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
  AUTO_INCREMENT=2
  
  ;
  
  -- ----------------------------
  -- Records of roles
  -- ----------------------------
  BEGIN;
  INSERT INTO `roles` VALUES ('1', '草未眠', '2016-06-07 06:49:14', '2016-06-07 06:49:14');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for users
  -- ----------------------------
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users` (
  `id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
  `remember_token`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
  `created_at`  timestamp NULL DEFAULT NULL ,
  `updated_at`  timestamp NULL DEFAULT NULL ,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `users_email_unique` (`email`) USING BTREE 
  )
  ENGINE=InnoDB
  DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
  AUTO_INCREMENT=1
  
  ;
  
  -- ----------------------------
  -- Records of users
  -- ----------------------------
  BEGIN;
  COMMIT;
  
  -- ----------------------------
  -- Auto increment value for roles
  -- ----------------------------
  ALTER TABLE `roles` AUTO_INCREMENT=2;
  
  -- ----------------------------
  -- Auto increment value for users
  -- ----------------------------
  ALTER TABLE `users` AUTO_INCREMENT=1;
  