

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `travlync_rawlanguage`
--

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `note_id` int(20) NOT NULL,
  `user_id` int(20) NOT NULL,
  `get_id` int(20) NOT NULL COMMENT 'course_id/ makeupclass_id',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'course/ makeupclass',
  `note_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `course_date_find` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `note_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'course_note / leave_note',
  `leave_approved_status` int(10) NOT NULL DEFAULT '0' COMMENT '0 means Unapproved, 1 means Approved, 2 means Rejected'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notes`
--

INSERT INTO `notes` (`note_id`, `user_id`, `get_id`, `type`, `note_desc`, `course_date_find`, `note_type`, `leave_approved_status`) VALUES
(1, 4, 1, 'course', 'leave from student Id 4\nupdate description accepted by admin', '2018-05-03', 'leave_note', 1),
(2, 4, 1, 'course', 'note for student id 4\nupdate by admin\n\nJustin', '2018-05-03', 'course_note', 0),
(3, 368, 70, 'course', 'teacherhai koi', '2018-05-04', 'course_note', 0),
(4, 1, 1, 'course', 'note4byadminid1', '2018-05-03', 'course_note', 0),
(5, 4, 1, 'course', 'leave id 4 17:24', '2018-05-03', 'leave_note', 2),
(6, 1, 3, 'course', 'admin notes', '2018-05-03', 'course_note', 0),
(7, 368, 70, 'course', 'mjhhj', '2018-05-04', 'course_note', 0),
(8, 368, 70, 'course', 'chhhh. mnmn', '2018-05-04', 'leave_note', 2),
(9, 1, 1, 'course', 'd7duu7fhu', '2018-05-03', 'leave_note', 2),
(10, 1, 1, 'course', 'jchnc', '2018-05-03', 'leave_note', 0),
(11, 1, 1, 'course', 'jfucx', '2018-05-03', 'course_note', 0),
(12, 1, 3, 'course', 'admin\nupdate', '2018-05-03', 'course_note', 0),
(13, 1, 70, 'course', 'user admin 26', '2018-05-04', 'course_note', 0),
(14, 4, 28, 'makeupclass', 'leave makeup class user ID 4', '2018-05-04', 'leave_note', 1),
(15, 4, 28, 'makeupclass', 'leave makeup id 4', '2018-05-04', 'leave_note', 0),
(16, 4, 1, 'course', 'testing bro', '2018-05-03', 'leave_note', 0),
(17, 4, 0, 'course', 'testing bro', '2018-06-26', 'course_note', 0),
(18, 4, 0, 'course', 'testing bro', '2018-06-26', 'course_note', 0),
(19, 4, 0, 'course', 'testing bro', '2018-06-26', 'course_note', 0),
(20, 4, 0, 'course', 'testing bro', '2018-06-26', 'course_note', 0),
(21, 4, 0, 'course', 'testing bro', '2018-06-26', 'course_note', 0),
(22, 4, 0, 'course', 'testing bro', '2018-06-26', 'course_note', 0),
(23, 4, 28, 'makeupclass', 'testing note save by user 4\nhkgj', '2018-05-04', 'course_note', 0),
(24, 4, 28, 'makeupclass', 'testing note save by user id 4\n\nup\nd\ngjgk\nbj 9higiv', '2018-05-04', 'course_note', 0),
(40, 4, 1, 'course', '6gviubu', '2018-05-03', 'leave_note', 0),
(25, 4, 28, 'makeupclass', 'testing note save by user id 4 hhhhhh', '2018-05-04', 'course_note', 0),
(26, 4, 28, 'makeupclass', 'testing note save by user id 4', '2018-05-04', 'course_note', 0),
(27, 4, 28, 'makeupclass', '444444\n111111', '2018-05-04', 'course_note', 0),
(28, 1, 28, 'makeupclass', 'note by admin', '2018-05-04', 'course_note', 0),
(29, 1, 3, 'course', 'admin', '2018-05-03', 'leave_note', 2),
(42, 368, 1, 'course', 'elllobsj', '2018-05-03', 'leave_note', 0),
(30, 1, 32, 'makeupclass', 'bhjfjf', '2018-05-10', 'course_note', 0),
(31, 1, 32, 'makeupclass', 'hjdjhdjdjhd dhjr hdhd hjd', '2018-05-10', 'course_note', 0),
(32, 1, 31, 'makeupclass', 'hhhh', '2018-05-04', 'leave_note', 0),
(33, 1, 28, 'makeupclass', 'bnxnnxx', '2018-05-04', 'leave_note', 0),
(34, 1, 32, 'makeupclass', 'bncnjff jjdn HD. b', '2018-05-10', 'leave_note', 1),
(35, 1, 32, 'makeupclass', 'jfjkgkfjfl', '2018-05-10', 'course_note', 0),
(36, 1, 32, 'makeupclass', 'bbbbbbbb\nupdate', '2018-05-10', 'course_note', 0),
(41, 368, 1, 'course', 'hello mnbnm', '2018-05-03', 'leave_note', 2),
(37, 4, 28, 'makeupclass', 'hhhhhh ujj bbbbb', '2018-05-04', 'course_note', 0),
(38, 4, 1, 'course', 'f7guvivhji', '2018-05-03', 'course_note', 1),
(39, 4, 28, 'makeupclass', 'leave test user ID 4', '2018-05-04', 'leave_note', 0),
(43, 368, 1, 'course', 'new admin leave', '2018-05-03', 'leave_note', 2),
(44, 1, 130, 'course', 'uvuvib ghhjzbzjd', '2018-06-11', 'leave_note', 2),
(45, 1, 130, 'course', 'y u@ug gggggfgtgggg\nsjshss', '2018-06-11', 'course_note', 1),
(46, 1, 130, 'course', 'gubii hh', '2018-06-11', 'course_note', 0),
(47, 368, 1, 'course', 'hdgvxvbvb', '2018-05-03', 'leave_note', 1),
(48, 368, 1, 'course', 'bvnnb', '2018-05-03', 'course_note', 0),
(49, 170, 130, 'course', 'jsjsis\njdjdjdj', '2018-06-11', 'course_note', 0),
(50, 170, 130, 'course', 'usjsjs', '2018-06-11', 'leave_note', 2),
(51, 1, 130, 'course', 'hejddudhd', '2018-06-11', 'leave_note', 1),
(52, 368, 32, 'makeupclass', 'note', '2018-05-10', 'course_note', 0),
(53, 368, 32, 'makeupclass', 'jjjjjij', '2018-05-10', 'leave_note', 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `notes`
--
ALTER TABLE `notes`
  ADD PRIMARY KEY (`note_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `note_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
