 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Apr 20, 2017 at 05:49 AM
+-- Generation Time: Apr 20, 2017 at 05:54 AM
 -- Server version: 10.1.19-MariaDB
 -- PHP Version: 5.6.24
 

-- Table structure for table `subject_offers`
--

CREATE TABLE `subject_offers` (
  `subject_offer_id` int(8) UNSIGNED NOT NULL,
  `subject_offer_semester` enum('first','second','summer') NOT NULL,
  `subject_offer_school_year` varchar(9) NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,

  `deleted_at` int(11) DEFAULT NULL,
  `deleted_user_id` int(11) UNSIGNED DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_user_id` int(11) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`course_id`),
  UNIQUE KEY `course_code` (`course_code`),
  UNIQUE KEY `course_description` (`course_description`),
  UNIQUE KEY `course_code_id` (`course_code_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `courses`
