-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `s_class`
--

CREATE TABLE IF NOT EXISTS `s_class` (
  `class_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `class_name` varchar(255) NOT NULL,
  `class_status` tinyint(2) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `delete_status` tinyint(2) NOT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `s_class`
--

INSERT INTO `s_class` (`class_id`, `class_name`, `class_status`, `created_date`, `modified_date`, `delete_status`) VALUES
(7, 'PKG', 0, '2016-11-26 07:35:38', '0000-00-00 00:00:00', 0),
(8, 'LKG', 0, '2016-11-26 07:44:06', '0000-00-00 00:00:00', 0),
(9, 'UKG', 0, '2016-11-26 07:44:29', '0000-00-00 00:00:00', 0),
(10, 'I STD', 0, '2016-11-26 07:44:52', '0000-00-00 00:00:00', 0),
(11, 'II STD', 0, '2016-11-26 07:45:21', '0000-00-00 00:00:00', 0);

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

--
-- Table structure for table `s_non_teaching_staff`
--

CREATE TABLE IF NOT EXISTS `s_non_teaching_staff` (
  `staff_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `staff_name` varchar(255) NOT NULL,
  `staff_email` varchar(255) NOT NULL,
  `staff_phone` varchar(255) NOT NULL,
  `staff_address` text NOT NULL,
  `staff_qualification` varchar(255) NOT NULL,
  `delete_status` tinyint(2) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `s_non_teaching_staff`
--

INSERT INTO `s_non_teaching_staff` (`staff_id`, `staff_name`, `staff_email`, `staff_phone`, `staff_address`, `staff_qualification`, `delete_status`, `created_date`, `modified_date`) VALUES
(1, 'sekar', 'sekars@gmail.com', '73051480410', 'villivakamss\r\nchennai', 'MCA', 0, '2016-07-31 09:56:04', '2016-07-31 09:56:37');

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

--
-- Table structure for table `s_send_sms`
--

CREATE TABLE IF NOT EXISTS `s_send_sms` (
  `sms_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sms_class_id` varchar(255) NOT NULL,
  `sms_student_id` varchar(255) NOT NULL,
  `sms_status` tinyint(2) NOT NULL COMMENT '1-send,2-not-send',
  `delete_status` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sms_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `s_send_sms`
--

INSERT INTO `s_send_sms` (`sms_id`, `sms_class_id`, `sms_student_id`, `sms_status`, `delete_status`) VALUES
(1, '1', '1', 1, 0),
(2, '1', '2', 1, 0),
(3, '1', '3', 1, 0),
(4, '1', '4', 1, 0),
(5, '1', '1', 1, 0),
(6, '1', '2', 1, 0),
(7, '1', '3', 1, 0),
(8, '1', '1', 1, 0),
(9, '1', '2', 1, 0),
(10, '1', '3', 1, 0),
(11, '1', '1', 1, 0),
(12, '1', '2', 1, 0),
(13, '1', '3', 1, 0),
(14, '1', '4', 1, 0),
(15, '1', '1', 1, 0),
(16, '1', '2', 1, 0),
(17, '1', '1', 1, 0),
(18, '1', '2', 1, 0),
(19, '1', '3', 1, 0),
(20, '1', '4', 1, 0),
(21, '1', '1', 1, 0),
(22, '1', '2', 1, 0),
(23, '1', '3', 1, 0),
(24, '1', '4', 1, 0),
(25, '1', '1', 1, 0),
(26, '1', '2', 1, 0),
(27, '1', '1', 1, 0),
(28, '1', '2', 1, 0),
(29, '1', '3', 1, 0),
(30, '1', '1', 1, 0),
(31, '1', '2', 1, 0),
(32, '1', '3', 1, 0),
(33, '1', '1', 1, 0),
(34, '1', '2', 1, 0),
(35, '1', '3', 1, 0);

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

--
-- Table structure for table `s_student`
--

CREATE TABLE IF NOT EXISTS `s_student` (
  `student_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(255) NOT NULL,
  `student_class_name` varchar(255) NOT NULL,
  `student_gender` tinyint(2) NOT NULL,
  `parent_name` varchar(255) NOT NULL,
  `parent_phone` varchar(255) NOT NULL,
  `parent_email` varchar(255) NOT NULL,
  `student_register_id` varchar(255) NOT NULL,
  `delete_status` tinyint(2) NOT NULL DEFAULT '0',
  `student_status` tinyint(2) NOT NULL DEFAULT '1',
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;

--
-- Dumping data for table `s_student`
--

INSERT INTO `s_student` (`student_id`, `student_name`, `student_class_name`, `student_gender`, `parent_name`, `parent_phone`, `parent_email`, `student_register_id`, `delete_status`, `student_status`, `created_date`, `modified_date`) VALUES
(14, 'jeevanandan', '1', 1, 'ravindran', '7305181480', 'jeeva@gmail.com', '89651', 0, 1, '2016-10-02 04:53:28', '0000-00-00 00:00:00'),
(16, 'British School', '1', 1, 'British', '7299077022', '', '10201', 0, 1, '2016-11-01 10:45:01', '2016-11-01 10:46:17'),
(17, 'Abishek', '1', 1, 'Ravi', '9789908387', '', '110022', 0, 1, '2016-11-01 10:48:50', '2016-11-26 06:39:52'),
(19, 'Kuson Ghising', '7', 2, 'Kumar Ghising', '9841106962', '', '001', 0, 1, '2016-11-26 07:48:35', '0000-00-00 00:00:00'),
(20, 'V. Balaji', '7', 1, 'M. Vasu', '8428880129', '', '002', 0, 1, '2016-11-26 07:49:46', '2016-11-26 08:34:50'),
(21, 'S. Dheeksha', '7', 1, 'R. Sriram', '9840508765', '', '003', 0, 1, '2016-11-26 07:51:39', '2016-11-26 08:35:20'),
(22, 'M. Nishanth', '7', 1, 'A.Mohana Sundharam', '9840443313', '', '004', 0, 1, '2016-11-26 07:53:18', '2016-11-26 08:35:58'),
(23, 'S.J. Sri varshan', '9', 1, 'Jagadeesh Babu', '9840748034', 'jagdishbabu_s@yahoo.com', '31', 0, 1, '2016-11-26 07:54:20', '0000-00-00 00:00:00'),
(24, 'Ketzia Joy', '9', 2, 'S.Kannan', '8220964608', 'rex.kannan@yahoo.com', '32', 0, 1, '2016-11-26 07:55:23', '0000-00-00 00:00:00'),
(25, 'J. Ashwin', '8', 1, 'L. Jebastin', '9840709276', '', '005', 0, 1, '2016-11-26 07:55:54', '0000-00-00 00:00:00'),
(26, 'Sharon Esther', '9', 2, 'Vijay Suresh', '9962821020', 'kvjaymary9493@gmail.com', '033', 0, 1, '2016-11-26 07:56:13', '0000-00-00 00:00:00'),
(27, 'K.G. Sukesh', '9', 1, 'Kirshnan', '9787712324', 'krishnan76@gmail.com', '034', 0, 1, '2016-11-26 07:57:00', '0000-00-00 00:00:00'),
(28, 'G. Jashwanthi', '9', 2, 'S.Guru Gopal', '9003091972', 'kavithagurugopal@gmail.com', '035', 0, 1, '2016-11-26 07:58:15', '0000-00-00 00:00:00'),
(29, 'R. Deodatth', '8', 1, 'S. Ramachandran', '9841693986', '', '006', 0, 1, '2016-11-26 07:58:33', '0000-00-00 00:00:00'),
(30, 'Dhilip kumar', '9', 1, 'Nanthakopal', '8939527114', 'pngopal15974@gmail.com', '036', 0, 1, '2016-11-26 08:00:29', '0000-00-00 00:00:00'),
(31, 'Gokul Raj', '9', 1, 'Gopal Krishna Raju', '8220889485', '', '037', 0, 1, '2016-11-26 08:01:05', '0000-00-00 00:00:00'),
(32, 'S. Eshaan Raj', '8', 1, 'K. Suresh', '9994492002', '', '007', 0, 1, '2016-11-26 08:01:29', '0000-00-00 00:00:00'),
(33, 'Kattula Anisha Chandra', '9', 2, 'Sunil kumar', '9949114858', '', '038', 0, 1, '2016-11-26 08:02:22', '0000-00-00 00:00:00'),
(34, 'A.Vandhana', '9', 2, 'K.Ashok', '9443287900', 'gaayathriashok@gmail.com', '039', 0, 1, '2016-11-26 08:02:54', '0000-00-00 00:00:00'),
(35, 'A. Aradhana', '8', 2, 'Arun Kumar', '9790825057', '', '008', 0, 1, '2016-11-26 08:03:20', '0000-00-00 00:00:00'),
(36, 'Hiranmaiyee', '9', 2, 'Chiranjeevi', '7401160999', '', '040', 0, 1, '2016-11-26 08:03:40', '0000-00-00 00:00:00'),
(37, 'Judah Paul Rajasekaran', '9', 1, 'Rajasekaran', '012345678', '', '041', 0, 1, '2016-11-26 08:05:16', '0000-00-00 00:00:00'),
(38, 'D. Rishitha', '8', 2, 'R. Dinagaran', '8056561874', '', '009', 0, 1, '2016-11-26 08:05:36', '0000-00-00 00:00:00'),
(39, 'P. Benjamin', '8', 1, 'Y. Philip Ratnasingh', '9382184794', '', '010', 0, 1, '2016-11-26 08:07:38', '0000-00-00 00:00:00'),
(40, 'A. Aaron', '8', 1, 'Abraham', '9884097280', '', '011', 0, 1, '2016-11-26 08:09:09', '0000-00-00 00:00:00'),
(41, 'Munagala Vishnavi', '10', 2, 'M. Chandra Mouli', '9444484501', '', '042', 0, 1, '2016-11-26 08:10:21', '0000-00-00 00:00:00'),
(42, 'S. Jairus Samuel', '8', 1, 'Samuel J Solomon', '9841054609', '', '012', 0, 1, '2016-11-26 08:10:36', '0000-00-00 00:00:00'),
(43, 'V. Saimithra', '10', 2, 'G. Venkatarajulu', '9884554647', '', '043', 0, 1, '2016-11-26 08:10:48', '0000-00-00 00:00:00'),
(44, 'O.D. Pranav Kumar', '10', 1, 'Deva prasanna', '9677058953', '', '044', 0, 1, '2016-11-26 08:11:29', '0000-00-00 00:00:00'),
(45, 'R. Vibhi Eesha', '8', 2, 'M. Ravi kumar', '9790540617', '', '013', 0, 1, '2016-11-26 08:11:43', '0000-00-00 00:00:00'),
(46, 'Jayadritha goush', '10', 2, 'Ranjoy Ghose', '8438343028', '', '045', 0, 1, '2016-11-26 08:11:55', '0000-00-00 00:00:00'),
(47, 'Pannith Raju', '10', 1, 'Jaganathan Raju', '9848577775', '', '046', 0, 1, '2016-11-26 08:12:23', '0000-00-00 00:00:00'),
(48, 'M. Ahsswanth', '8', 1, 'P. Muralinath', '9444407632', '', '014', 0, 1, '2016-11-26 08:12:38', '0000-00-00 00:00:00'),
(49, 'Paridhi', '10', 2, 'Kartikkumar', '9408570014', '', '047', 0, 1, '2016-11-26 08:12:49', '0000-00-00 00:00:00'),
(50, 'Sri varshini', '10', 2, 'Senthilnathan', '9786307363', '', '048', 0, 1, '2016-11-26 08:13:19', '0000-00-00 00:00:00'),
(51, 'A. Saimithra', '8', 2, 'Arun Prasad', '7708052499', '', '015', 0, 1, '2016-11-26 08:13:51', '0000-00-00 00:00:00'),
(52, 'Harshitha', '10', 2, 'Kulasekara perumal', '9445002557', '', '049', 0, 1, '2016-11-26 08:14:01', '0000-00-00 00:00:00'),
(53, 'K.S. Mahant mohan', '10', 1, 'A.K.Senthil Kumar', '9003992888', '', '050', 0, 1, '2016-11-26 08:14:45', '0000-00-00 00:00:00'),
(54, 'S. Sri Niranjan', '8', 1, 'Senthilnathan', '9786307363', '', '016', 0, 1, '2016-11-26 08:14:53', '0000-00-00 00:00:00'),
(55, 'Krishna', '10', 1, 'M.S.Ramesh', '9789077711', '', '051', 0, 1, '2016-11-26 08:15:51', '0000-00-00 00:00:00'),
(56, 'T. Sashwanth Harish ', '8', 1, 'Tayaprakash Sanmugam', '9840454332', '', '017', 0, 1, '2016-11-26 08:16:25', '0000-00-00 00:00:00'),
(57, 'G.Abishek Prabhu', '10', 1, 'S.Gopala Krishnan', '9791094556', '', '052', 0, 1, '2016-11-26 08:16:30', '0000-00-00 00:00:00'),
(58, 'O.D. Gireesh kumar', '11', 1, 'Deva prasanna', '9677058953', '', '053', 0, 1, '2016-11-26 08:17:09', '0000-00-00 00:00:00'),
(59, 'S. Kheerthanaa', '8', 2, 'V. Sudhakar', '93810111440', '', '018', 0, 1, '2016-11-26 08:17:11', '0000-00-00 00:00:00'),
(60, 'Jeffrin ', '11', 1, 'J.Jayakumar', '12346789', '', '054', 0, 1, '2016-11-26 08:17:41', '0000-00-00 00:00:00'),
(61, 'S. Krithik Shyam', '8', 1, 'G. Sathish Kumar', '9819755446', '', '019', 0, 1, '2016-11-26 08:18:07', '0000-00-00 00:00:00'),
(62, 'Sophiya', '11', 2, 'Suthakar Panneer selvam', '8682804112', '', '055', 0, 1, '2016-11-26 08:18:07', '0000-00-00 00:00:00'),
(63, 'Jeel J Vadgama', '11', 2, 'Jitendran Vadgama', '9884277164', '', '056', 0, 1, '2016-11-26 08:18:33', '0000-00-00 00:00:00'),
(64, 'Mathew', '11', 1, 'Sathu', '9500066488', '', '057', 0, 1, '2016-11-26 08:19:02', '0000-00-00 00:00:00'),
(65, 'R. Vaishnavi', '8', 2, 'Rathnakar.R.Nairy', '9176012849', '', '020', 0, 1, '2016-11-26 08:19:09', '0000-00-00 00:00:00'),
(66, 'Unnathi R.Nairy', '11', 2, 'Rathnakar.r.Nairy', '9176012849', '', '058', 0, 1, '2016-11-26 08:19:35', '0000-00-00 00:00:00'),
(67, 'Anjoe Grace', '11', 2, 'Prabu Jeya Pandiyan', '9381884164', '', '059', 0, 1, '2016-11-26 08:20:31', '0000-00-00 00:00:00'),
(68, 'Lohamithra', '9', 2, 'M. Balaji', '8939353131', '', '021', 0, 1, '2016-11-26 08:20:51', '0000-00-00 00:00:00'),
(69, 'Pranava', '11', 2, 'A.Saravanan ', '9884517850', '', '059', 0, 1, '2016-11-26 08:21:01', '0000-00-00 00:00:00'),
(70, 'Jai Shankar', '11', 1, 'S.Guru Gopal', '9003091972', '', '060', 0, 1, '2016-11-26 08:21:35', '0000-00-00 00:00:00'),
(71, 'U. Sanaz', '9', 2, 'Umar Sharief', '9884036132', '', '022', 0, 1, '2016-11-26 08:22:00', '0000-00-00 00:00:00'),
(72, 'K.S. Vikruth Kannan', '11', 1, 'A.K.Senthil Kumar', '9003992888', '', '061', 0, 1, '2016-11-26 08:22:06', '0000-00-00 00:00:00'),
(73, 'K. Pranavi', '9', 2, 'K. Kishore', '9866302838', '', '023', 0, 1, '2016-11-26 08:23:23', '0000-00-00 00:00:00'),
(74, 'K. Mohit', '9', 1, 'V. Kishore Kumar', '9840883786', '', '024', 0, 1, '2016-11-26 08:28:18', '0000-00-00 00:00:00'),
(75, 'S. Akshat', '9', 1, 'A. Suresh', '9840492384', '', '025', 0, 1, '2016-11-26 08:29:34', '0000-00-00 00:00:00'),
(76, 'D. Ayan', '9', 1, 'Dorjay Sherpa', '9884064098', '', '026', 0, 1, '2016-11-26 08:30:21', '0000-00-00 00:00:00'),
(77, 'Jadon . Jezliah', '9', 1, 'Thirumalai Ravanan', '9003143491', '', '027', 0, 1, '2016-11-26 08:31:26', '0000-00-00 00:00:00'),
(78, 'B. Roushan', '9', 1, 'R. Baskar', '9445191899', '', '028', 0, 1, '2016-11-26 08:32:18', '0000-00-00 00:00:00'),
(79, 'M. Chaaranya', '9', 1, 'S. Murukesh', '9445157368', '', '029', 0, 1, '2016-11-26 08:33:06', '0000-00-00 00:00:00'),
(80, 'M. Lalith kumar', '9', 1, 'T.J. Madhav Rao', '9841318394', '', '030', 0, 1, '2016-11-26 08:33:52', '0000-00-00 00:00:00'),
(81, 'Jeevanandan', '7', 1, 'Ravindran', '7305181480', '', '59846', 0, 1, '2016-11-30 17:50:34', '0000-00-00 00:00:00');

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

--
-- Table structure for table `s_teaching_staff`
--

CREATE TABLE IF NOT EXISTS `s_teaching_staff` (
  `staff_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `staff_name` varchar(255) NOT NULL,
  `staff_email` varchar(255) NOT NULL,
  `staff_phone` varchar(255) NOT NULL,
  `staff_address` text NOT NULL,
  `staff_qualification` varchar(255) NOT NULL,
  `delete_status` tinyint(2) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `s_teaching_staff`
--

INSERT INTO `s_teaching_staff` (`staff_id`, `staff_name`, `staff_email`, `staff_phone`, `staff_address`, `staff_qualification`, `delete_status`, `created_date`, `modified_date`) VALUES
(1, 'R. Jeevanandan', 'jeevanandan', '9965164194', 'chennai1\r\nvillivakam\r\n600049', '6-A', 0, '2016-07-31 09:45:56', '2016-09-07 06:24:49'),
(2, 'Abishek', 'abisir@gmail.com', '9789908387', 'Villivakam', '6-B', 0, '2016-09-05 08:01:07', '2016-09-07 06:25:18'),
(3, 'Rajasekar', 'sekar@gmail.com', '9789908387', 'Villivakam', '6-C', 0, '2016-09-05 08:07:36', '2016-09-07 06:25:40');

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

--
-- Table structure for table `s_template`
--

CREATE TABLE IF NOT EXISTS `s_template` (
  `template_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) NOT NULL,
  `template_content` text NOT NULL,
  `template_sender_id` varchar(255) NOT NULL,
  `template_status` varchar(255) NOT NULL DEFAULT '2',
  `template_for` text NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `delete_status` tinyint(2) NOT NULL,
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `s_template`
--

INSERT INTO `s_template` (`template_id`, `template_name`, `template_content`, `template_sender_id`, `template_status`, `template_for`, `created_date`, `modified_date`, `delete_status`) VALUES
(1, 'Absent', 'Dear Parents, Your #VAL1# #VAL2# hasn''t come to school today. Teachers and Management wish a quick recovery if the child is unwell. Thanks.', '69326', '1', 'Student', '2016-07-31 09:22:15', '2016-08-27 12:14:41', 0),
(2, 'SMS LAUNCH', 'Dear Parents, we are happy to announce that now we have launched SMS alert system in our school - BRITISH SCHOOL', '70383', '1', 'Student', '2016-08-27 13:04:07', '2016-08-27 16:28:01', 0),
(4, 'HOME WORK', 'Englshs', '78750', '1', 'Student', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(5, 'HOLIDAY', 'tomorrow have holiday', '78921', '1', 'Student', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(6, 'INFORMATION', 'please bring science books', '78922', '1', 'Student', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(7, 'FEES REMAINDER', 'please pay remaining fees', '78923', '1', 'Student', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

