/*
 * < ÀKURA, This application manages the daily activities of a Teacher and a Student of a School>
 *
 * Copyright (C) 2012 Virtusa Corporation.
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of 
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 */

USE `akura`;
--
-- Dumping data for table `SECURITY_QUESTIONS`
--
INSERT INTO `SECURITY_QUESTIONS` VALUES (1,'What is the name of your best friend from Childhood?','2012-01-05 09:28:24'),(2,'What was the name of your first teacher?','2012-01-05 09:28:54'),(3,'What is your mother’s madden name?','2012-01-05 09:29:27'),(4,'What is your favorite Vehicle?','2012-01-05 09:29:27'),(5,'What is your favorite Color?','2012-01-05 09:29:27'),(6,'What is your Hero’s name?','2012-01-05 09:29:27'),(7,'What is your favorite Novel?','2012-01-05 09:29:27');

--
-- Dumping data for table `WARNING_LEVEL`
--
DELETE FROM `WARNING_LEVEL` WHERE WARNING_LEVEL_ID = 2;
INSERT INTO `WARNING_LEVEL` (`WARNING_LEVEL_ID`,`DESCRIPTION`,`COLOUR`,`MODIFIED_TIME`) VALUES 
(2,'Bad','Amber','2011-09-06 15:20:36'),
(3,'Average','Yellow','2011-09-06 15:20:36');


--
-- Dumping data for table `WARNING_LEVEL`
--
INSERT INTO `PUBLICATION_TYPE` (`PUBLICATION_TYPE_ID`,`TYPE`,`MODIFIED_TIME`) VALUES 
(1,'News','2011-09-06 15:20:36'),
(2,'Events','2011-09-06 15:20:36');

--
-- Dumping data for table `FAITH_LIFE_CATEGORY`
--
INSERT INTO `FAITH_LIFE_CATEGORY` (`FAITH_LIFE_CATEGORY_ID`, `DESCRIPTION`, `MODIFIED_TIME`) VALUES (1, 'Other', '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_CATEGORY` (`FAITH_LIFE_CATEGORY_ID`, `DESCRIPTION`, `MODIFIED_TIME`) VALUES (2, 'Positive', '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_CATEGORY` (`FAITH_LIFE_CATEGORY_ID`, `DESCRIPTION`, `MODIFIED_TIME`) VALUES (3, 'Negative', '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_CATEGORY` (`FAITH_LIFE_CATEGORY_ID`, `DESCRIPTION`, `MODIFIED_TIME`) VALUES (4, 'Attitude', '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_CATEGORY` (`FAITH_LIFE_CATEGORY_ID`, `DESCRIPTION`, `MODIFIED_TIME`) VALUES (5, 'Participation', '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_CATEGORY` (`FAITH_LIFE_CATEGORY_ID`, `DESCRIPTION`, `MODIFIED_TIME`) VALUES (6, 'General', '2012-01-03 11:40:26');

--
-- Dumping data for table `FAITH_LIFE_COMMENT`
--

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (1, 'gets along well with other children', 2, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (2, 'accepts responsibility', 2, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (3, 'cooperates well', 2, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (4, 'helps others', 2, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (5, 'possesses good self-discipline', 2, '2012-01-03 11:40:26');
INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (6, 'Need to improve respect for others', 3, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (7, 'Interrupts others', 3, '2012-01-03 11:40:26');
INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (8, 'displays an excellent attitude', 4, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (9, 'attitude toward school is excellent', 4, '2012-01-03 11:40:26');
INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (10, 'participates well in class', 5, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (11, 'volunteers often', 5, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (12, 'willing to take part in all classroom activities', 5, '2012-01-03 11:40:26');
INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (13, 'is an attentive student', 6, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (14, 'is gaining self-confidence', 6, '2012-01-03 11:40:26');

INSERT INTO `FAITH_LIFE_COMMENT` (`FAITH_LIFE_COMMENT_ID`, `DESCRIPTION`, `FAITH_LIFE_CATEGORY_ID`, `MODIFIED_TIME`) VALUES (15, 'work habits are improving', 6, '2012-01-03 11:40:26');

--
-- Dumping data for table `PARTICIPANT_CATEGORY`
--
INSERT INTO `PARTICIPANT_CATEGORY` (`PARTICIPANT_CATEGORY_ID`,`DESCRIPTION`,`MODIFIED_TIME`) VALUES (1,'Class Wise','2011-12-15 14:39:38');
INSERT INTO `PARTICIPANT_CATEGORY` (`PARTICIPANT_CATEGORY_ID`,`DESCRIPTION`,`MODIFIED_TIME`) VALUES (2,'Sports Wise','2011-12-16 14:39:38');
INSERT INTO `PARTICIPANT_CATEGORY` (`PARTICIPANT_CATEGORY_ID`,`DESCRIPTION`,`MODIFIED_TIME`) VALUES (3,'Club and Society Wise','2011-12-17 14:39:38');