 -- AUTO_INCREMENT for table `comments`
 --
 ALTER TABLE `comments`
-  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
+  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
 --
 -- AUTO_INCREMENT for table `groups`
 --

--

INSERT INTO `teachers` (`id`, `username`, `email`, `password`, `remember_token`, `schools_id`, `created_at`, `updated_at`) VALUES
(1, 'Mr. Jacey Haley DDS', 'nitzsche.delmer@kub.info', '$2y$10$FxSnrGOCjtg.M.JNhCxx9eZ3y95fBhGjr.KDOt6dH62PaEZGNwmPq', 'EWBheN39UO', 1, '2017-11-09 06:26:18', '2017-11-09 06:26:18'),
(2, 'Dexter Reinger', 'fkutch@hotmail.com', '$2y$10$FxSnrGOCjtg.M.JNhCxx9eZ3y95fBhGjr.KDOt6dH62PaEZGNwmPq', 'JgtKuQhaAHQ3vU6RuBn0uFcVCMWC9rH2Mc5N26SEoEteShJYvFqYcgjD5Hil', 1, '2017-11-09 06:26:18', '2017-12-06 07:04:34');

--
-- Indexes for dumped tables

CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(10) unsigned NOT NULL,
  `lesson_logs_id` int(10) unsigned NOT NULL,
  `students_id` int(10) unsigned NOT NULL,
  `storage_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `original_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mime_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_ext` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `post_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 转存表中的数据 `posts`
--

INSERT INTO `posts` (`id`, `lesson_logs_id`, `students_id`, `storage_name`, `original_name`, `mime_type`, `file_ext`, `post_code`, `content`, `created_at`, `updated_at`) VALUES
(1, 1, 3, '20171210-5a2d499d135b7.png', 'Screen Shot 2015-03-31 at 8.51.28 PM.png', 'image/png', 'png', '5a2d499d135b7', '', '2017-12-10 06:50:05', '2017-12-10 06:50:05'),
(2, 1, 4, 'Screen Shot 2015-03-31 at 8.54.02 PM.png-5a2d4a8ba8101.png', 'Screen Shot 2015-03-31 at 8.54.02 PM.png', 'image/png', 'png', '5a2d4a8ba8101', '', '2017-12-10 06:54:03', '2017-12-10 06:54:03'),
(3, 1, 5, '尤文杰个人简历.xls-5a2d4bc13dbdf.xls', '尤文杰个人简历.xls', 'application/vnd.ms-excel', 'xls', '5a2d4bc13dbdf', '', '2017-12-10 06:59:13', '2017-12-10 06:59:13');

-- --------------------------------------------------------

