Edit - opensis.sql

Edit: opensis.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `opensis65`
--

DELIMITER $$
--
-- Procedures
--
CREATE PROCEDURE `ATTENDANCE_CALC`(IN cp_id INT)
BEGIN
 DELETE FROM missing_attendance WHERE COURSE_PERIOD_ID=cp_id;
 INSERT INTO missing_attendance(SCHOOL_ID,SYEAR,SCHOOL_DATE,COURSE_PERIOD_ID,PERIOD_ID,TEACHER_ID,SECONDARY_TEACHER_ID) 
         SELECT s.ID AS SCHOOL_ID,acc.SYEAR,acc.SCHOOL_DATE,cp.COURSE_PERIOD_ID,cpv.PERIOD_ID, IF(tra.course_period_id=cp.course_period_id AND acc.school_date<tra.assign_date =true,tra.pre_teacher_id,cp.teacher_id) AS TEACHER_ID,
         cp.SECONDARY_TEACHER_ID FROM attendance_calendar acc INNER JOIN course_periods cp ON cp.CALENDAR_ID=acc.CALENDAR_ID INNER JOIN course_period_var cpv ON cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID 
         AND (cpv.COURSE_PERIOD_DATE IS NULL AND position(substring('UMTWHFS' FROM DAYOFWEEK(acc.SCHOOL_DATE) FOR 1) IN cpv.DAYS)>0 OR cpv.COURSE_PERIOD_DATE IS NOT NULL AND cpv.COURSE_PERIOD_DATE=acc.SCHOOL_DATE) 
         INNER JOIN schools s ON s.ID=acc.SCHOOL_ID LEFT JOIN teacher_reassignment tra ON (cp.course_period_id=tra.course_period_id) INNER JOIN schedule sch ON sch.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID 
         AND sch.student_id IN(SELECT student_id FROM student_enrollment se WHERE sch.school_id=se.school_id AND sch.syear=se.syear AND start_date<=acc.school_date AND (end_date IS NULL OR end_date>=acc.school_date))
         AND (cp.MARKING_PERIOD_ID IS NOT NULL AND cp.MARKING_PERIOD_ID IN (SELECT MARKING_PERIOD_ID FROM school_years WHERE SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN START_DATE AND END_DATE UNION SELECT MARKING_PERIOD_ID FROM school_semesters WHERE SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN START_DATE AND END_DATE UNION SELECT MARKING_PERIOD_ID FROM school_quarters WHERE SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN START_DATE AND END_DATE) OR (cp.MARKING_PERIOD_ID IS NULL AND acc.school_date BETWEEN cp.begin_date AND cp.end_date))
         AND sch.START_DATE<=acc.SCHOOL_DATE AND (sch.END_DATE IS NULL OR sch.END_DATE>=acc.SCHOOL_DATE ) AND cpv.DOES_ATTENDANCE='Y' AND acc.SCHOOL_DATE<CURDATE() AND cp.course_period_id=cp_id 
         AND NOT EXISTS (SELECT '' FROM  attendance_completed ac WHERE ac.SCHOOL_DATE=acc.SCHOOL_DATE AND ac.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND ac.PERIOD_ID=cpv.PERIOD_ID 
         AND IF(tra.course_period_id=cp.course_period_id AND acc.school_date<=tra.assign_date =true,ac.staff_id=tra.pre_teacher_id,ac.staff_id=cp.teacher_id)) 
         GROUP BY acc.SCHOOL_DATE,cp.COURSE_PERIOD_ID,cp.TEACHER_ID,cpv.PERIOD_ID;
 END$$

CREATE PROCEDURE `ATTENDANCE_CALC_BY_DATE`(IN sch_dt DATE,IN year INT,IN school INT)
BEGIN
  DELETE FROM missing_attendance WHERE SCHOOL_DATE=sch_dt AND SYEAR=year AND SCHOOL_ID=school;
  INSERT INTO missing_attendance(SCHOOL_ID,SYEAR,SCHOOL_DATE,COURSE_PERIOD_ID,PERIOD_ID,TEACHER_ID,SECONDARY_TEACHER_ID) SELECT s.ID AS SCHOOL_ID,acc.SYEAR,acc.SCHOOL_DATE,cp.COURSE_PERIOD_ID,cpv.PERIOD_ID, IF(tra.course_period_id=cp.course_period_id AND acc.school_date<tra.assign_date =true,tra.pre_teacher_id,cp.teacher_id) AS TEACHER_ID,cp.SECONDARY_TEACHER_ID FROM attendance_calendar acc INNER JOIN marking_periods mp ON mp.SYEAR=acc.SYEAR AND mp.SCHOOL_ID=acc.SCHOOL_ID AND acc.SCHOOL_DATE BETWEEN mp.START_DATE AND mp.END_DATE INNER JOIN course_periods cp ON cp.MARKING_PERIOD_ID=mp.MARKING_PERIOD_ID  AND cp.CALENDAR_ID=acc.CALENDAR_ID INNER JOIN course_period_var cpv ON cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND cpv.DOES_ATTENDANCE='Y' LEFT JOIN teacher_reassignment tra ON (cp.course_period_id=tra.course_period_id) INNER JOIN school_periods sp ON sp.SYEAR=acc.SYEAR AND sp.SCHOOL_ID=acc.SCHOOL_ID AND sp.PERIOD_ID=cpv.PERIOD_ID AND (sp.BLOCK IS NULL AND position(substring('UMTWHFS' FROM DAYOFWEEK(acc.SCHOOL_DATE) FOR 1) IN cpv.DAYS)>0 OR sp.BLOCK IS NOT NULL AND acc.BLOCK IS NOT NULL AND sp.BLOCK=acc.BLOCK) INNER JOIN schools s ON s.ID=acc.SCHOOL_ID INNER JOIN schedule sch ON sch.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND sch.START_DATE<=acc.SCHOOL_DATE AND (sch.END_DATE IS NULL OR sch.END_DATE>=acc.SCHOOL_DATE )  LEFT JOIN attendance_completed ac ON ac.SCHOOL_DATE=acc.SCHOOL_DATE AND IF(tra.course_period_id=cp.course_period_id AND acc.school_date<tra.assign_date =true,ac.staff_id=tra.pre_teacher_id,ac.staff_id=cp.teacher_id) AND ac.PERIOD_ID=sp.PERIOD_ID WHERE acc.SYEAR=year AND acc.SCHOOL_ID=school AND (acc.MINUTES IS NOT NULL AND acc.MINUTES>0) AND acc.SCHOOL_DATE=sch_dt AND ac.STAFF_ID IS NULL GROUP BY s.TITLE,acc.SCHOOL_DATE,cp.TITLE,cp.COURSE_PERIOD_ID,cp.TEACHER_ID;
 END$$

CREATE PROCEDURE `SEAT_COUNT`()
BEGIN
 UPDATE course_periods SET filled_seats=filled_seats-1 WHERE COURSE_PERIOD_ID IN (SELECT COURSE_PERIOD_ID FROM schedule WHERE end_date IS NOT NULL AND end_date < CURDATE() AND dropped='N');
 UPDATE schedule SET dropped='Y' WHERE end_date IS NOT NULL AND end_date < CURDATE() AND dropped='N';
 END$$

CREATE PROCEDURE `SEAT_FILL`()
BEGIN
 UPDATE course_periods SET filled_seats=filled_seats+1 WHERE COURSE_PERIOD_ID IN (SELECT COURSE_PERIOD_ID FROM schedule WHERE dropped='Y' AND ( end_date IS NULL OR end_date >= CURDATE()));
 UPDATE schedule SET dropped='N' WHERE dropped='Y' AND ( end_date IS NULL OR end_date >= CURDATE()) ;
 END$$

CREATE PROCEDURE `TEACHER_REASSIGNMENT`()
BEGIN
 UPDATE course_periods cp,course_period_var cpv,teacher_reassignment tr,school_periods sp,marking_periods mp,staff st SET cp.title=CONCAT(sp.title,IF(cp.mp<>'FY',CONCAT(' - ',mp.short_name),''),IF(CHAR_LENGTH(cpv.days)<5,CONCAT(' - ',cpv.days),''),' - ',cp.short_name,' - ',CONCAT_WS(' ',st.first_name,st.middle_name,st.last_name)), cp.teacher_id=tr.teacher_id WHERE cpv.period_id=sp.period_id and cp.marking_period_id=mp.marking_period_id and st.staff_id=tr.teacher_id and cp.course_period_id=tr.course_period_id AND assign_date <= CURDATE() AND updated='N' AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID; 
  UPDATE teacher_reassignment SET updated='Y' WHERE assign_date <=CURDATE() AND updated='N';
 END$$

--
-- Functions
--
CREATE FUNCTION `CALC_CUM_GPA_MP`(
 mp_id int
 ) RETURNS int(11)
BEGIN
 
 DECLARE req_mp INT DEFAULT 0;
 DECLARE done INT DEFAULT 0;
 DECLARE gp_points DECIMAL(10,2);
 DECLARE student_id INT;
 DECLARE gp_points_weighted DECIMAL(10,2);
 DECLARE divisor DECIMAL(10,2);
 DECLARE credit_earned DECIMAL(10,2);
 DECLARE cgpa DECIMAL(10,2);
 
 DECLARE cur1 CURSOR FOR
    SELECT srcg.student_id,
                   IF(ISNULL(sum(srcg.unweighted_gp)),  (SUM(srcg.weighted_gp*srcg.credit_earned)),
                       IF(ISNULL(sum(srcg.weighted_gp)), SUM(srcg.unweighted_gp*srcg.credit_earned),
                          ( SUM(srcg.unweighted_gp*srcg.credit_attempted)+ SUM(srcg.weighted_gp*srcg.credit_earned))
                         ))as gp_points,
 
                       SUM(srcg.weighted_gp*srcg.credit_earned) as gp_points_weighted,
                       SUM(srcg.credit_attempted) as divisor,
                       SUM(srcg.credit_earned) as credit_earned,
    		      IF(ISNULL(sum(srcg.unweighted_gp)),  (SUM(srcg.weighted_gp*srcg.credit_earned))/ sum(srcg.credit_attempted),
                           IF(ISNULL(sum(srcg.weighted_gp)), SUM(srcg.unweighted_gp*srcg.credit_earned)/sum(srcg.credit_attempted),
                              ( SUM(srcg.unweighted_gp*srcg.credit_attempted)+ SUM(srcg.weighted_gp*srcg.credit_earned))/sum(srcg.credit_attempted)
                             )
                          ) as cgpa
 
             FROM marking_periods mp,temp_cum_gpa srcg
             INNER JOIN schools sc ON sc.id=srcg.school_id
             WHERE srcg.marking_period_id= mp.marking_period_id AND srcg.gp_scale<>0 AND srcg.marking_period_id NOT LIKE 'E%'
             AND mp.marking_period_id IN (SELECT marking_period_id  FROM marking_periods WHERE mp_type=req_mp )
             GROUP BY srcg.student_id;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 
 
   CREATE TEMPORARY TABLE tmp(
     student_id int,
     sum_weighted_factors decimal(10,6),
     count_weighted_factors int,
     sum_unweighted_factors decimal(10,6),
     count_unweighted_factors int,
     grade_level_short varchar(10)
   );
 
   INSERT INTO tmp(student_id,sum_weighted_factors,count_weighted_factors,
     sum_unweighted_factors, count_unweighted_factors,grade_level_short)
   SELECT
     srcg.student_id,
     SUM(srcg.weighted_gp/s.reporting_gp_scale) AS sum_weighted_factors,
     COUNT(*) AS count_weighted_factors,
     SUM(srcg.unweighted_gp/srcg.gp_scale) AS sum_unweighted_factors,
     COUNT(*) AS count_unweighted_factors,
     eg.short_name
   FROM student_report_card_grades srcg
   INNER JOIN schools s ON s.id=srcg.school_id
   LEFT JOIN enroll_grade eg on eg.student_id=srcg.student_id AND eg.syear=srcg.syear AND eg.school_id=srcg.school_id
   WHERE srcg.marking_period_id=mp_id AND srcg.gp_scale<>0 AND srcg.marking_period_id NOT LIKE 'E%'
   GROUP BY srcg.student_id,eg.short_name;
 
  /* UPDATE student_mp_stats sms
     INNER JOIN tmp t on t.student_id=sms.student_id
   SET
     sms.sum_weighted_factors=t.sum_weighted_factors,
     sms.count_weighted_factors=t.count_weighted_factors,
     sms.sum_unweighted_factors=t.sum_unweighted_factors,
     sms.count_unweighted_factors=t.count_unweighted_factors
   WHERE sms.marking_period_id=mp_id;*/
 
   /*INSERT INTO student_mp_stats(student_id,marking_period_id,sum_weighted_factors,count_weighted_factors,
     sum_unweighted_factors,count_unweighted_factors,grade_level_short)
   SELECT
       t.student_id,
       mp_id,
       t.sum_weighted_factors,
       t.count_weighted_factors,
       t.sum_unweighted_factors,
       t.count_unweighted_factors,
       t.grade_level_short
     FROM tmp t
     LEFT JOIN student_mp_stats sms ON sms.student_id=t.student_id AND sms.marking_period_id=mp_id
     WHERE sms.student_id IS NULL;*/
 
   INSERT INTO student_gpa_calculated (student_id,marking_period_id)
   SELECT
       t.student_id,
       mp_id
     FROM tmp t
     LEFT JOIN student_gpa_calculated sms ON sms.student_id=t.student_id AND sms.marking_period_id=mp_id
     WHERE sms.student_id IS NULL;
 
 /*  UPDATE student_mp_stats g
     INNER JOIN (
 	SELECT s.student_id,
 		SUM(s.weighted_gp/sc.reporting_gp_scale)/COUNT(*) AS cum_weighted_factor,
 		SUM(s.unweighted_gp/s.gp_scale)/COUNT(*) AS cum_unweighted_factor
 	FROM student_report_card_grades s
 	INNER JOIN schools sc ON sc.id=s.school_id
 	LEFT JOIN course_periods p ON p.course_period_id=s.course_period_id
 	WHERE p.marking_period_id IS NULL OR p.marking_period_id=s.marking_period_id
 	GROUP BY student_id) gg ON gg.student_id=g.student_id
     SET g.cum_unweighted_factor=gg.cum_unweighted_factor, g.cum_weighted_factor=gg.cum_weighted_factor;*/
 
   UPDATE student_gpa_calculated g
     INNER JOIN (
 	SELECT s.student_id,
 		SUM(s.weighted_gp/sc.reporting_gp_scale)/COUNT(*) AS cum_weighted_factor,
 		SUM(s.unweighted_gp/s.gp_scale)/COUNT(*) AS cum_unweighted_factor
 	FROM student_report_card_grades s
 	INNER JOIN schools sc ON sc.id=s.school_id
 	LEFT JOIN course_periods p ON p.course_period_id=s.course_period_id
 	WHERE p.marking_period_id IS NULL OR p.marking_period_id=s.marking_period_id
 	GROUP BY student_id) gg ON gg.student_id=g.student_id
     SET g.cum_unweighted_factor=gg.cum_unweighted_factor;
 
 
     SELECT mp_type INTO @mp_type FROM marking_periods WHERE marking_period_id=mp_id;
 
  
     IF @mp_type = 'quarter'  THEN
            set req_mp = 'quarter';
     ELSEIF @mp_type = 'semester'  THEN
         IF EXISTS(SELECT student_id FROM student_report_card_grades srcg WHERE srcg.marking_period_id IN (SELECT marking_period_id  FROM marking_periods WHERE mp_type=@mp_type)) THEN
            set req_mp  = 'semester';
        ELSE
            set req_mp  = 'quarter';
         END IF;
    ELSEIF @mp_type = 'year'  THEN
            IF EXISTS(SELECT student_id FROM student_report_card_grades srcg WHERE srcg.MARKING_PERIOD_ID IN (SELECT marking_period_id  FROM marking_periods WHERE mp_type='semester')
                      UNION  SELECT student_id FROM student_report_card_grades srcg WHERE srcg.MARKING_PERIOD_ID IN (SELECT marking_period_id  FROM history_marking_periods WHERE mp_type='semester')
                      ) THEN
                  set req_mp  = 'semester';
          
           ELSE
                   set req_mp  = 'quarter ';
             END IF;
    END IF;
 
 
 
 open cur1;
 fetch cur1 into student_id, gp_points,gp_points_weighted,divisor,credit_earned,cgpa;
 
 while not done DO
     IF EXISTS(SELECT student_id FROM student_gpa_calculated WHERE  student_gpa_calculated.student_id=student_id) THEN
     UPDATE student_gpa_calculated gc
                SET gc.cgpa=cgpa where gc.student_id=student_id and gc.marking_period_id=mp_id;
     ELSE
         INSERT INTO student_gpa_running(student_id,marking_period_id,mp,cgpa)
           VALUES(student_id,mp_id,mp_id,cgpa);
     END IF;
 fetch cur1 into student_id, gp_points,gp_points_weighted,divisor,credit_earned,cgpa;
 END WHILE;
 /*while not done DO
     IF EXISTS(SELECT student_id FROM student_gpa_running WHERE  student_gpa_running.student_id=student_id) THEN
     UPDATE student_gpa_running gc
                SET gpa_points=gp_points,gpa_points_weighted=gp_points_weighted,gc.divisor=divisor,credit_earned=credit_earned,gc.cgpa=cgpa where gc.student_id=student_id;
     ELSE
         INSERT INTO student_gpa_running(student_id,marking_period_id,gpa_points,gpa_points_weighted, divisor,credit_earned,cgpa)
           VALUES(student_id,mp_id,gp_points,gp_points_weighted,divisor,credit_earned,cgpa);
     END IF;
 fetch cur1 into student_id, gp_points,gp_points_weighted,divisor,credit_earned,cgpa;
 END WHILE;*/
 CLOSE cur1;
 
 
 RETURN 1;
 
 END$$

CREATE FUNCTION `CALC_GPA_MP`(
 	s_id int,
 	mp_id int
 ) RETURNS int(11)
BEGIN
   SELECT
     SUM(srcg.weighted_gp/s.reporting_gp_scale) AS sum_weighted_factors, 
     COUNT(*) AS count_weighted_factors,                        
     SUM(srcg.unweighted_gp/srcg.gp_scale) AS sum_unweighted_factors, 
     COUNT(*) AS count_unweighted_factors,
    IF(ISNULL(sum(srcg.unweighted_gp)),  (SUM(srcg.weighted_gp*srcg.credit_earned))/ sum(srcg.credit_attempted),
                       IF(ISNULL(sum(srcg.weighted_gp)), SUM(srcg.unweighted_gp*srcg.credit_earned)/sum(srcg.credit_attempted),
                          ( SUM(srcg.unweighted_gp*srcg.credit_attempted)+ SUM(srcg.weighted_gp*srcg.credit_earned))/sum(srcg.credit_attempted)
                         )
       ),
     
     SUM(srcg.weighted_gp*srcg.credit_earned)/(select sum(sg.credit_attempted) from student_report_card_grades sg where sg.marking_period_id=mp_id AND sg.student_id=s_id
                                                   AND sg.weighted_gp  IS NOT NULL  AND sg.unweighted_gp IS NULL AND sg.course_period_id IS NOT NULL GROUP BY sg.student_id, sg.marking_period_id) ,
     SUM(srcg.unweighted_gp*srcg.credit_earned)/ (select sum(sg.credit_attempted) from student_report_card_grades sg where sg.marking_period_id=mp_id AND sg.student_id=s_id
                                                      AND sg.unweighted_gp  IS NOT NULL  AND sg.weighted_gp IS NULL AND sg.course_period_id IS NOT NULL GROUP BY sg.student_id, sg.marking_period_id) ,
     eg.short_name
   INTO
     @sum_weighted_factors,
     @count_weighted_factors,
     @sum_unweighted_factors,
     @count_unweighted_factors,
     @gpa,
     @weighted_gpa,
     @unweighted_gpa,
     @grade_level_short
   FROM student_report_card_grades srcg
   INNER JOIN schools s ON s.id=srcg.school_id
 INNER JOIN course_periods cp ON cp.course_period_id=srcg.course_period_id
 INNER JOIN report_card_grade_scales rcgs ON rcgs.id=cp.grade_scale_id
   LEFT JOIN enroll_grade eg on eg.student_id=srcg.student_id AND eg.syear=srcg.syear AND eg.school_id=srcg.school_id
   WHERE srcg.marking_period_id=mp_id AND srcg.student_id=s_id AND srcg.gp_scale<>0 AND srcg.course_period_id IS NOT NULL AND (rcgs.gpa_cal='Y' OR cp.grade_scale_id IS NULL) AND srcg.marking_period_id NOT LIKE 'E%'
   AND (eg.START_DATE IS NULL OR eg.START_DATE='0000-00-00'  OR eg.START_DATE<=CURDATE()) AND (eg.END_DATE IS NULL OR eg.END_DATE='0000-00-00'  OR eg.END_DATE>=CURDATE())  
   GROUP BY srcg.student_id,eg.short_name;
 
   /*IF EXISTS(SELECT NULL FROM student_mp_stats WHERE marking_period_id=mp_id AND student_id=s_id) THEN
     UPDATE student_mp_stats
     SET
       sum_weighted_factors=@sum_weighted_factors,
       count_weighted_factors=@count_weighted_factors,
       sum_unweighted_factors=@sum_unweighted_factors,
       count_unweighted_factors=@count_unweighted_factors
     WHERE marking_period_id=mp_id AND student_id=s_id;
   ELSE
     INSERT INTO student_mp_stats(student_id,marking_period_id,sum_weighted_factors,count_weighted_factors,
         sum_unweighted_factors,count_unweighted_factors,grade_level_short)
       VALUES(s_id,mp_id,@sum_weighted_factors,@count_weighted_factors,@sum_unweighted_factors,
         @count_unweighted_factors,@grade_level_short);
   END IF;
 
   UPDATE student_mp_stats g
     INNER JOIN (
 	SELECT s.student_id,
 		SUM(s.weighted_gp/sc.reporting_gp_scale)/COUNT(*) AS cum_weighted_factor,
 		SUM(s.unweighted_gp/s.gp_scale)/COUNT(*) AS cum_unweighted_factor
 	FROM student_report_card_grades s
 	INNER JOIN schools sc ON sc.id=s.school_id
 	LEFT JOIN course_periods p ON p.course_period_id=s.course_period_id
 	WHERE s.course_period_id IS NOT NULL AND p.marking_period_id IS NULL OR p.marking_period_id=s.marking_period_id
 	GROUP BY student_id) gg ON gg.student_id=g.student_id
     SET g.cum_unweighted_factor=gg.cum_unweighted_factor, g.cum_weighted_factor=gg.cum_weighted_factor
     WHERE g.student_id=s_id;*/
 
   IF NOT EXISTS(SELECT NULL FROM student_gpa_calculated WHERE marking_period_id=mp_id AND student_id=s_id) THEN
     INSERT INTO student_gpa_calculated (student_id,marking_period_id)
       VALUES(s_id,mp_id);
   END IF;
 
   UPDATE student_gpa_calculated g
     INNER JOIN (
 	SELECT s.student_id,
 		SUM(s.unweighted_gp/s.gp_scale)/COUNT(*) AS cum_unweighted_factor
 	FROM student_report_card_grades s
 	INNER JOIN schools sc ON sc.id=s.school_id
 	LEFT JOIN course_periods p ON p.course_period_id=s.course_period_id
 	WHERE s.course_period_id IS NOT NULL AND p.marking_period_id IS NULL OR p.marking_period_id=s.marking_period_id
 	GROUP BY student_id) gg ON gg.student_id=g.student_id
     SET g.cum_unweighted_factor=gg.cum_unweighted_factor
     WHERE g.student_id=s_id;
 
 IF EXISTS(SELECT student_id FROM student_gpa_calculated WHERE marking_period_id=mp_id AND student_id=s_id) THEN
     UPDATE student_gpa_calculated
     SET
       gpa            = @gpa,
       weighted_gpa   =@weighted_gpa,
       unweighted_gpa =@unweighted_gpa
 
     WHERE marking_period_id=mp_id AND student_id=s_id;
   ELSE
         INSERT INTO student_gpa_calculated(student_id,marking_period_id,mp,gpa,weighted_gpa,unweighted_gpa,grade_level_short)
             VALUES(s_id,mp_id,mp_id,@gpa,@weighted_gpa,@unweighted_gpa,@grade_level_short  );
                    
 
    END IF;
 
   RETURN 0;
 END$$

CREATE FUNCTION `CREDIT`(
  	cp_id int,
  	mp_id int
  ) RETURNS decimal(10,3)
BEGIN
   SELECT credits,IF(ISNULL(marking_period_id),'Y',marking_period_id),mp INTO @credits,@marking_period_id,@mp FROM course_periods WHERE course_period_id=cp_id;
    SELECT mp_type INTO @mp_type FROM marking_periods WHERE marking_period_id=mp_id;
   
 IF @marking_period_id='Y' THEN 
 RETURN @credits;
    ELSEIF   @marking_period_id=mp_id THEN
     RETURN @credits;
 ELSEIF @mp = 'QTR' AND @mp_type = 'semester' THEN
      RETURN @credits;
    ELSEIF @mp='FY' AND @mp_type='semester' THEN
      SELECT COUNT(*) INTO @val FROM marking_periods WHERE parent_id=@marking_period_id GROUP BY parent_id;
    ELSEIF @mp = 'FY' AND @mp_type = 'quarter' THEN
      SELECT count(*) into @val FROM marking_periods WHERE grandparent_id=@marking_period_id GROUP BY grandparent_id;
    ELSEIF @mp = 'SEM' AND @mp_type = 'quarter' THEN
      SELECT count(*) into @val FROM marking_periods WHERE parent_id=@marking_period_id GROUP BY parent_id;
    ELSE
      RETURN 0;
    END IF;
    IF @val > 0 THEN
      RETURN @credits/@val;
    END IF;
    RETURN 0;
 END$$

CREATE FUNCTION `fn_marking_period_seq`() RETURNS int(11)
BEGIN
   INSERT INTO marking_period_id_generator VALUES(NULL);
 RETURN LAST_INSERT_ID();
 END$$

CREATE FUNCTION `RE_CALC_GPA_MP`(
 	s_id int,
 	mp_id int,
         sy int,
         sch_id int
 ) RETURNS int(11)
BEGIN
   SELECT
     SUM(srcg.weighted_gp/s.reporting_gp_scale) AS sum_weighted_factors, 
     COUNT(*) AS count_weighted_factors,                        
     SUM(srcg.unweighted_gp/srcg.gp_scale) AS sum_unweighted_factors, 
     COUNT(*) AS count_unweighted_factors,
    IF(ISNULL(sum(srcg.unweighted_gp)),  (SUM(srcg.weighted_gp*srcg.credit_earned))/ sum(srcg.credit_attempted),
                       IF(ISNULL(sum(srcg.weighted_gp)), SUM(srcg.unweighted_gp*srcg.credit_earned)/sum(srcg.credit_attempted),
                          ( SUM(srcg.unweighted_gp*srcg.credit_attempted)+ SUM(srcg.weighted_gp*srcg.credit_earned))/sum(srcg.credit_attempted)
                         )
       ),
     
     SUM(srcg.weighted_gp*srcg.credit_earned)/(select sum(sg.credit_attempted) from student_report_card_grades sg where sg.marking_period_id=mp_id AND sg.student_id=s_id
                                                   AND sg.weighted_gp  IS NOT NULL  AND sg.unweighted_gp IS NULL GROUP BY sg.student_id, sg.marking_period_id) ,
     SUM(srcg.unweighted_gp*srcg.credit_earned)/ (select sum(sg.credit_attempted) from student_report_card_grades sg where sg.marking_period_id=mp_id AND sg.student_id=s_id
                                                      AND sg.unweighted_gp  IS NOT NULL  AND sg.weighted_gp IS NULL GROUP BY sg.student_id, sg.marking_period_id) ,
     eg.short_name
   INTO
     @sum_weighted_factors,
     @count_weighted_factors,
     @sum_unweighted_factors,
     @count_unweighted_factors,
     @gpa,
     @weighted_gpa,
     @unweighted_gpa,
     @grade_level_short
   FROM student_report_card_grades srcg
   INNER JOIN schools s ON s.id=srcg.school_id
   LEFT JOIN enroll_grade eg on eg.student_id=srcg.student_id AND eg.syear=srcg.syear AND eg.school_id=srcg.school_id
   WHERE srcg.marking_period_id=mp_id AND srcg.student_id=s_id AND srcg.gp_scale<>0 AND srcg.school_id=sch_id AND srcg.syear=sy AND srcg.marking_period_id NOT LIKE 'E%'
 AND (eg.START_DATE IS NULL OR eg.START_DATE='0000-00-00'  OR eg.START_DATE<=CURDATE()) AND (eg.END_DATE IS NULL OR eg.END_DATE='0000-00-00'  OR eg.END_DATE>=CURDATE())
   GROUP BY srcg.student_id,eg.short_name;
 
   /*IF EXISTS(SELECT NULL FROM student_mp_stats WHERE marking_period_id=mp_id AND student_id=s_id) THEN
     UPDATE student_mp_stats
     SET
       sum_weighted_factors=@sum_weighted_factors,
       count_weighted_factors=@count_weighted_factors,
       sum_unweighted_factors=@sum_unweighted_factors,
       count_unweighted_factors=@count_unweighted_factors
     WHERE marking_period_id=mp_id AND student_id=s_id;
   ELSE
     INSERT INTO student_mp_stats(student_id,marking_period_id,sum_weighted_factors,count_weighted_factors,
         sum_unweighted_factors,count_unweighted_factors,grade_level_short)
       VALUES(s_id,mp_id,@sum_weighted_factors,@count_weighted_factors,@sum_unweighted_factors,
         @count_unweighted_factors,@grade_level_short);
   END IF;
 
   UPDATE student_mp_stats g
     INNER JOIN (
 	SELECT s.student_id,
 		SUM(s.weighted_gp/sc.reporting_gp_scale)/COUNT(*) AS cum_weighted_factor,
 		SUM(s.unweighted_gp/s.gp_scale)/COUNT(*) AS cum_unweighted_factor
 	FROM student_report_card_grades s
 	INNER JOIN schools sc ON sc.id=s.school_id
 	LEFT JOIN course_periods p ON p.course_period_id=s.course_period_id
 	WHERE p.marking_period_id IS NULL OR p.marking_period_id=s.marking_period_id
 	GROUP BY student_id) gg ON gg.student_id=g.student_id
     SET g.cum_unweighted_factor=gg.cum_unweighted_factor, g.cum_weighted_factor=gg.cum_weighted_factor
     WHERE g.student_id=s_id;*/
 
   IF NOT EXISTS(SELECT NULL FROM student_gpa_calculated WHERE marking_period_id=mp_id AND student_id=s_id) THEN
     INSERT INTO student_mp_stats(student_id,marking_period_id)
       VALUES(s_id,mp_id);
   END IF;
 
   UPDATE student_gpa_calculated g
     INNER JOIN (
 	SELECT s.student_id,
 		SUM(s.unweighted_gp/s.gp_scale)/COUNT(*) AS cum_unweighted_factor
 	FROM student_report_card_grades s
 	INNER JOIN schools sc ON sc.id=s.school_id
 	LEFT JOIN course_periods p ON p.course_period_id=s.course_period_id
 	WHERE p.marking_period_id IS NULL OR p.marking_period_id=s.marking_period_id
 	GROUP BY student_id) gg ON gg.student_id=g.student_id
     SET g.cum_unweighted_factor=gg.cum_unweighted_factor
     WHERE g.student_id=s_id;
 
 IF EXISTS(SELECT student_id FROM student_gpa_calculated WHERE marking_period_id=mp_id AND student_id=s_id) THEN
     UPDATE student_gpa_calculated
     SET
       gpa            = @gpa,
       weighted_gpa   =@weighted_gpa,
       unweighted_gpa =@unweighted_gpa
 
     WHERE marking_period_id=mp_id AND student_id=s_id;
   ELSE
         INSERT INTO student_gpa_calculated(student_id,marking_period_id,mp,gpa,weighted_gpa,unweighted_gpa,grade_level_short)
             VALUES(s_id,mp_id,mp_id,@gpa,@weighted_gpa,@unweighted_gpa,@grade_level_short  );
                    
 
    END IF;
 
   RETURN 0;
 END$$

CREATE FUNCTION `SET_CLASS_RANK_MP`(
 	mp_id int
 ) RETURNS int(11)
BEGIN
 
 DECLARE done INT DEFAULT 0;
 DECLARE marking_period_id INT;
 DECLARE student_id INT;
 DECLARE rank NUMERIC;
 
 declare cur1 cursor for
 select
   mp.marking_period_id,
   sgc.student_id,
  (select count(*)+1 
    from student_gpa_calculated sgc3
    where sgc3.gpa > sgc.gpa
      and sgc3.marking_period_id = mp.marking_period_id 
      and sgc3.student_id in (select distinct sgc2.student_id 
                                                 from student_gpa_calculated sgc2, student_enrollment se2
                                                 where sgc2.student_id = se2.student_id 
                                                 and sgc2.marking_period_id = mp.marking_period_id 
                                                 and se2.grade_id = se.grade_id
                                                 and se2.syear = se.syear
                                                 group by gpa
                                 )
   ) as rank
   from student_enrollment se, student_gpa_calculated sgc, marking_periods mp
   where se.student_id = sgc.student_id
     and sgc.marking_period_id = mp.marking_period_id
     and mp.marking_period_id = mp_id
     and se.syear = mp.syear
     and not sgc.gpa is null
   order by grade_id, rank;
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 
 open cur1;
 fetch cur1 into marking_period_id,student_id,rank;
 
 while not done DO
 	update student_gpa_calculated sgc
 	  set
 	    class_rank = rank
 	where sgc.marking_period_id = marking_period_id
 	  and sgc.student_id = student_id;
 	fetch cur1 into marking_period_id,student_id,rank;
 END WHILE;
 CLOSE cur1;
 
 RETURN 1;
 END$$

CREATE FUNCTION `STUDENT_DISABLE`(
 stu_id int
 ) RETURNS int(1)
BEGIN
 UPDATE students set is_disable ='Y' where (select end_date from student_enrollment where  student_id=stu_id ORDER BY id DESC LIMIT 1) IS NOT NULL AND (select end_date from student_enrollment where  student_id=stu_id ORDER BY id DESC LIMIT 1)< CURDATE() AND  student_id=stu_id;
 RETURN 1;
 END$$

DELIMITER ;

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

--
-- Table structure for table `app`
--

CREATE TABLE `app` (
  `name` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `app`
--

INSERT INTO `app` VALUES
('version', '6.5'),
('date', 'February 05, 2018'),
('build', '20180205001'),
('update', '0'),
('last_updated', 'February 05, 2018');

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

--
-- Table structure for table `attendance_calendar`
--

CREATE TABLE `attendance_calendar` (
  `syear` decimal(4,0) NOT NULL,
  `school_id` decimal(10,0) NOT NULL,
  `school_date` date NOT NULL,
  `minutes` decimal(10,0) DEFAULT NULL,
  `block` varchar(10) DEFAULT NULL,
  `calendar_id` decimal(10,0) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`syear`,`school_id`,`school_date`,`calendar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Triggers `attendance_calendar`
--
DROP TRIGGER IF EXISTS `td_cal_missing_attendance`;
DELIMITER //
CREATE TRIGGER `td_cal_missing_attendance` AFTER DELETE ON `attendance_calendar`
 FOR EACH ROW DELETE mi.* FROM missing_attendance mi,course_periods cp WHERE mi.course_period_id=cp.course_period_id and cp.calendar_id=OLD.calendar_id AND mi.SCHOOL_DATE=OLD.school_date
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ti_cal_missing_attendance`;
DELIMITER //
CREATE TRIGGER `ti_cal_missing_attendance` AFTER INSERT ON `attendance_calendar`
 FOR EACH ROW BEGIN
     DECLARE associations INT;
     SET associations = (SELECT COUNT(course_period_id) FROM `course_periods` WHERE calendar_id=NEW.calendar_id);
     IF associations>0 THEN
 	CALL ATTENDANCE_CALC_BY_DATE(NEW.school_date, NEW.syear,NEW.school_id);
     END IF;
 END
//
DELIMITER ;

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

--
-- Table structure for table `attendance_codes`
--

CREATE TABLE `attendance_codes` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `state_code` varchar(1) DEFAULT NULL,
  `default_code` varchar(1) DEFAULT NULL,
  `table_name` decimal(10,0) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendance_codes_ind2` USING BTREE (`syear`,`school_id`),
  KEY `attendance_codes_ind3` USING BTREE (`short_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `attendance_code_categories`
--

CREATE TABLE `attendance_code_categories` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendance_code_categories_ind1` USING BTREE (`id`),
  KEY `attendance_code_categories_ind2` USING BTREE (`syear`,`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `attendance_completed`
--

CREATE TABLE `attendance_completed` (
  `staff_id` decimal(10,0) NOT NULL,
  `school_date` date NOT NULL,
  `period_id` decimal(10,0) NOT NULL,
  `course_period_id` int(11) NOT NULL,
  `cpv_id` int(11) NOT NULL,
  `substitute_staff_id` decimal(10,0) DEFAULT NULL,
  `is_taken_by_substitute_staff` char(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `attendance_day`
--

CREATE TABLE `attendance_day` (
  `student_id` decimal(10,0) NOT NULL,
  `school_date` date NOT NULL,
  `minutes_present` decimal(10,0) DEFAULT NULL,
  `state_value` decimal(2,1) DEFAULT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`student_id`,`school_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `attendance_period`
--

CREATE TABLE `attendance_period` (
  `student_id` decimal(10,0) NOT NULL,
  `school_date` date NOT NULL,
  `period_id` decimal(10,0) NOT NULL,
  `attendance_code` decimal(10,0) DEFAULT NULL,
  `attendance_teacher_code` decimal(10,0) DEFAULT NULL,
  `attendance_reason` varchar(100) DEFAULT NULL,
  `admin` varchar(1) DEFAULT NULL,
  `course_period_id` decimal(10,0) NOT NULL DEFAULT '0',
  `marking_period_id` int(11) DEFAULT NULL,
  `comment` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`student_id`,`school_date`,`period_id`),
  KEY `attendance_period_ind1` USING BTREE (`student_id`),
  KEY `attendance_period_ind2` USING BTREE (`period_id`),
  KEY `attendance_period_ind3` USING BTREE (`attendance_code`),
  KEY `attendance_period_ind4` USING BTREE (`school_date`),
  KEY `attendance_period_ind5` USING BTREE (`attendance_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `calendar_events`
--

CREATE TABLE `calendar_events` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `calendar_id` decimal(10,0) DEFAULT NULL,
  `school_date` date DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `description` text,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `calendar_events_visibility`
--

CREATE TABLE `calendar_events_visibility` (
  `calendar_id` int(11) NOT NULL,
  `profile_id` int(11) DEFAULT NULL,
  `profile` varchar(50) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `syear` decimal(4,0) NOT NULL,
  `course_id` int(8) NOT NULL AUTO_INCREMENT,
  `subject_id` decimal(10,0) NOT NULL,
  `school_id` decimal(10,0) NOT NULL,
  `grade_level` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `short_name` varchar(25) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`course_id`),
  KEY `courses_ind1` USING BTREE (`course_id`,`syear`),
  KEY `courses_ind2` USING BTREE (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Stand-in structure for view `course_details`
--
CREATE TABLE `course_details` (
`school_id` decimal(10,0)
,`syear` int(4)
,`marking_period_id` int(11)
,`subject_id` decimal(10,0)
,`course_id` decimal(10,0)
,`course_period_id` int(11)
,`teacher_id` int(11)
,`secondary_teacher_id` int(11)
,`course_title` varchar(100)
,`cp_title` varchar(100)
,`grade_scale_id` int(11)
,`mp` varchar(3)
,`credits` decimal(10,3)
,`begin_date` date
,`end_date` date
);
-- --------------------------------------------------------

--
-- Table structure for table `course_periods`
--

CREATE TABLE `course_periods` (
  `syear` int(4) NOT NULL,
  `school_id` decimal(10,0) NOT NULL,
  `course_period_id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` decimal(10,0) NOT NULL,
  `course_weight` varchar(10) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `short_name` text,
  `mp` varchar(3) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `secondary_teacher_id` int(11) DEFAULT NULL,
  `total_seats` int(11) DEFAULT NULL,
  `filled_seats` decimal(10,0) NOT NULL DEFAULT '0',
  `does_honor_roll` varchar(1) DEFAULT NULL,
  `does_class_rank` varchar(1) DEFAULT NULL,
  `gender_restriction` varchar(1) DEFAULT NULL,
  `house_restriction` varchar(1) DEFAULT NULL,
  `availability` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `calendar_id` int(11) DEFAULT NULL,
  `half_day` varchar(1) DEFAULT NULL,
  `does_breakoff` varchar(1) DEFAULT NULL,
  `rollover_id` int(11) DEFAULT NULL,
  `grade_scale_id` int(11) DEFAULT NULL,
  `credits` decimal(10,3) DEFAULT NULL,
  `schedule_type` enum('FIXED','VARIABLE','BLOCKED') DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_by` int(11) NOT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`course_period_id`),
  KEY `course_periods_ind1` USING BTREE (`syear`),
  KEY `course_periods_ind2` USING BTREE (`course_id`,`course_weight`,`syear`,`school_id`),
  KEY `course_periods_ind3` USING BTREE (`course_period_id`),
  KEY `course_periods_ind5` USING BTREE (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Triggers `course_periods`
--
DROP TRIGGER IF EXISTS `td_course_periods`;
DELIMITER //
CREATE TRIGGER `td_course_periods` AFTER DELETE ON `course_periods`
 FOR EACH ROW BEGIN
 	DELETE FROM course_period_var WHERE course_period_id=OLD.course_period_id;
 END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `tu_course_periods`;
DELIMITER //
CREATE TRIGGER `tu_course_periods` AFTER UPDATE ON `course_periods`
 FOR EACH ROW BEGIN
 	CALL ATTENDANCE_CALC(NEW.course_period_id);
 END
//
DELIMITER ;

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

--
-- Table structure for table `course_period_var`
--

CREATE TABLE `course_period_var` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_period_id` int(11) NOT NULL,
  `days` varchar(7) DEFAULT NULL,
  `course_period_date` date DEFAULT NULL,
  `period_id` int(11) NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `room_id` int(11) NOT NULL,
  `does_attendance` varchar(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Triggers `course_period_var`
--
DROP TRIGGER IF EXISTS `td_course_period_var`;
DELIMITER //
CREATE TRIGGER `td_course_period_var` AFTER DELETE ON `course_period_var`
 FOR EACH ROW CALL ATTENDANCE_CALC(OLD.course_period_id)
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ti_course_period_var`;
DELIMITER //
CREATE TRIGGER `ti_course_period_var` AFTER INSERT ON `course_period_var`
 FOR EACH ROW CALL ATTENDANCE_CALC(NEW.course_period_id)
//
DELIMITER ;
DROP TRIGGER IF EXISTS `tu_course_period_var`;
DELIMITER //
CREATE TRIGGER `tu_course_period_var` AFTER UPDATE ON `course_period_var`
 FOR EACH ROW CALL ATTENDANCE_CALC(NEW.course_period_id)
//
DELIMITER ;

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

--
-- Table structure for table `course_subjects`
--

CREATE TABLE `course_subjects` (
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `subject_id` int(8) NOT NULL AUTO_INCREMENT,
  `title` text,
  `short_name` text,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`subject_id`),
  KEY `course_subjects_ind1` USING BTREE (`syear`,`school_id`,`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) DEFAULT NULL,
  `search` varchar(1) DEFAULT NULL,
  `title` varchar(30) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `select_options` varchar(10000) DEFAULT NULL,
  `category_id` decimal(10,0) DEFAULT NULL,
  `system_field` char(1) DEFAULT NULL,
  `required` varchar(1) DEFAULT NULL,
  `default_selection` varchar(255) DEFAULT NULL,
  `hide` varchar(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `address_desc_ind2` USING BTREE (`type`),
  KEY `address_fields_ind3` USING BTREE (`category_id`),
  KEY `custom_desc_ind` USING BTREE (`id`),
  KEY `custom_desc_ind2` USING BTREE (`type`),
  KEY `custom_fields_ind3` USING BTREE (`category_id`),
  KEY `people_desc_ind2` USING BTREE (`type`),
  KEY `people_fields_ind3` USING BTREE (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `eligibility`
--

CREATE TABLE `eligibility` (
  `student_id` decimal(10,0) DEFAULT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_date` date DEFAULT NULL,
  `period_id` decimal(10,0) DEFAULT NULL,
  `eligibility_code` varchar(20) DEFAULT NULL,
  `course_period_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  KEY `eligibility_ind1` USING BTREE (`student_id`,`course_period_id`,`school_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `eligibility_activities`
--

CREATE TABLE `eligibility_activities` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eligibility_activities_ind1` USING BTREE (`school_id`,`syear`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `eligibility_completed`
--

CREATE TABLE `eligibility_completed` (
  `staff_id` decimal(10,0) NOT NULL,
  `school_date` date NOT NULL,
  `period_id` decimal(10,0) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_id`,`school_date`,`period_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Stand-in structure for view `enroll_grade`
--
CREATE TABLE `enroll_grade` (
`id` int(8)
,`syear` decimal(4,0)
,`school_id` decimal(10,0)
,`student_id` decimal(10,0)
,`start_date` date
,`end_date` date
,`short_name` varchar(5)
,`title` varchar(50)
);
-- --------------------------------------------------------

--
-- Table structure for table `ethnicity`
--

CREATE TABLE `ethnicity` (
  `ethnicity_id` int(8) NOT NULL AUTO_INCREMENT,
  `ethnicity_name` varchar(255) NOT NULL,
  `sort_order` int(8) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date time ethnicity record modified',
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ethnicity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `ethnicity`
--

INSERT INTO `ethnicity` VALUES
(1, 'White, Non-Hispanic', 1, '0000-00-00 00:00:00', NULL),
(2, 'Black, Non-Hispanic', 2, '0000-00-00 00:00:00', NULL),
(3, 'Hispanic', 3, '0000-00-00 00:00:00', NULL),
(4, 'American Indian or Native Alaskan', 4, '0000-00-00 00:00:00', NULL),
(5, 'Pacific Islander', 5, '0000-00-00 00:00:00', NULL),
(6, 'Asian', 6, '0000-00-00 00:00:00', NULL),
(7, 'Indian', 7, '0000-00-00 00:00:00', NULL),
(8, 'Middle Eastern', 8, '0000-00-00 00:00:00', NULL),
(9, 'African', 9, '0000-00-00 00:00:00', NULL),
(10, 'Mixed Race', 10, '0000-00-00 00:00:00', NULL),
(11, 'Other', 11, '0000-00-00 00:00:00', NULL),
(12, 'Black', 12, '0000-00-00 00:00:00', NULL),
(13, 'White', 13, '0000-00-00 00:00:00', NULL),
(14, 'African', 14, '0000-00-00 00:00:00', NULL),
(15, 'Indigenous', 15, '2013-05-31 04:50:54', NULL);

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

--
-- Table structure for table `gradebook_assignments`
--

CREATE TABLE `gradebook_assignments` (
  `assignment_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` decimal(10,0) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `course_period_id` decimal(10,0) DEFAULT NULL,
  `course_id` decimal(10,0) DEFAULT NULL,
  `assignment_type_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `assigned_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `points` decimal(10,0) DEFAULT NULL,
  `description` longtext,
  `ungraded` int(8) NOT NULL DEFAULT '1',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`assignment_id`),
  KEY `gradebook_assignment_types_ind1` USING BTREE (`staff_id`,`course_id`),
  KEY `gradebook_assignments_ind1` USING BTREE (`staff_id`,`marking_period_id`),
  KEY `gradebook_assignments_ind2` USING BTREE (`course_id`,`course_period_id`),
  KEY `gradebook_assignments_ind3` USING BTREE (`assignment_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gradebook_assignment_types`
--

CREATE TABLE `gradebook_assignment_types` (
  `assignment_type_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` decimal(10,0) DEFAULT NULL,
  `course_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `final_grade_percent` decimal(6,5) DEFAULT NULL,
  `course_period_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`assignment_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gradebook_grades`
--

CREATE TABLE `gradebook_grades` (
  `student_id` decimal(10,0) NOT NULL,
  `period_id` decimal(10,0) DEFAULT NULL,
  `course_period_id` decimal(10,0) NOT NULL,
  `assignment_id` decimal(10,0) NOT NULL,
  `points` decimal(6,2) DEFAULT NULL,
  `comment` longtext,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`student_id`,`assignment_id`,`course_period_id`),
  KEY `gradebook_grades_ind1` USING BTREE (`assignment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `grades_completed`
--

CREATE TABLE `grades_completed` (
  `staff_id` decimal(10,0) NOT NULL,
  `marking_period_id` int(11) NOT NULL,
  `period_id` decimal(10,0) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_id`,`marking_period_id`,`period_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `hacking_log`
--

CREATE TABLE `hacking_log` (
  `host_name` varchar(20) DEFAULT NULL,
  `ip_address` varchar(20) DEFAULT NULL,
  `login_date` date DEFAULT NULL,
  `version` varchar(20) DEFAULT NULL,
  `php_self` varchar(20) DEFAULT NULL,
  `document_root` varchar(100) DEFAULT NULL,
  `script_name` varchar(100) DEFAULT NULL,
  `modname` varchar(100) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `history_marking_periods`
--

CREATE TABLE `history_marking_periods` (
  `parent_id` int(11) DEFAULT NULL,
  `mp_type` char(20) DEFAULT NULL,
  `name` char(30) DEFAULT NULL,
  `post_end_date` date DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  `syear` int(11) DEFAULT NULL,
  `marking_period_id` int(11) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`marking_period_id`),
  KEY `history_marking_period_ind1` USING BTREE (`school_id`),
  KEY `history_marking_period_ind2` USING BTREE (`syear`),
  KEY `history_marking_period_ind3` USING BTREE (`mp_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `history_school`
--

CREATE TABLE `history_school` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `marking_period_id` int(11) NOT NULL,
  `school_name` varchar(100) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `honor_roll`
--

CREATE TABLE `honor_roll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `school_id` int(11) NOT NULL,
  `syear` int(4) NOT NULL,
  `title` varchar(100) NOT NULL,
  `value` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `language_id` int(8) NOT NULL AUTO_INCREMENT,
  `language_name` varchar(127) NOT NULL,
  `sort_order` int(8) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`language_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES
(1, 'English', 1, '2015-07-28 11:26:33', NULL),
(2, 'Arabic', 2, '2015-07-28 11:26:33', NULL),
(3, 'Bengali', 3, '2015-07-28 11:26:33', NULL),
(4, 'Chinese', 4, '2015-07-28 11:26:33', NULL),
(5, 'French', 5, '2015-07-28 11:26:33', NULL),
(6, 'German', 6, '2015-07-28 11:26:33', NULL),
(7, 'Haitian Creole', 7, '2015-07-28 11:26:33', NULL),
(8, 'Hindi', 8, '2015-07-28 11:26:33', NULL),
(9, 'Italian', 9, '2015-07-28 11:26:33', NULL),
(10, 'Japanese', 10, '2015-07-28 11:26:33', NULL),
(11, 'Korean', 11, '2015-07-28 11:26:33', NULL),
(12, 'Malay', 12, '2015-07-28 11:26:33', NULL),
(13, 'Polish', 13, '2015-07-28 11:26:33', NULL),
(14, 'Portuguese', 14, '2015-07-28 11:26:33', NULL),
(15, 'Russian', 15, '2015-07-28 11:26:33', NULL),
(16, 'Spanish', 16, '2015-07-28 11:26:33', NULL),
(17, 'Thai', 17, '2015-07-28 11:26:33', NULL),
(18, 'Turkish', 18, '2015-07-28 11:26:33', NULL),
(19, 'Urdu', 19, '2015-07-28 11:26:33', NULL),
(20, 'Vietnamese', 20, '2015-07-28 11:26:33', NULL);

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

--
-- Table structure for table `login_authentication`
--

CREATE TABLE `login_authentication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `profile_id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `failed_login` int(3) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `COMPOSITE` (`user_id`,`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `login_authentication`
--

INSERT INTO `login_authentication` VALUES
(1, 1, 0, '[[admin_username]]', '[[admin_pass]]', '2018-01-23 16:45:45', 0, '2015-07-28 05:56:33', NULL);

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

--
-- Table structure for table `login_message`
--

CREATE TABLE `login_message` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `message` longtext,
  `display` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `login_message`
--

INSERT INTO `login_message` VALUES
(1, 'This is a restricted network. Use of this network, its equipment, and resources is monitored at all times and requires explicit permission from the network administrator. If you do not have this permission in writing, you are violating the regulations of this network and can and will be prosecuted to the fullest extent of law. By continuing into this system, you are acknowledging that you are aware of and agree to these terms.', 'Y');

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

--
-- Table structure for table `login_records`
--

CREATE TABLE `login_records` (
  `syear` decimal(5,0) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `profile` varchar(50) DEFAULT NULL,
  `user_name` varchar(100) DEFAULT NULL,
  `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `faillog_count` decimal(4,0) DEFAULT NULL,
  `staff_id` decimal(10,0) DEFAULT NULL,
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `faillog_time` varchar(255) DEFAULT NULL,
  `ip_address` varchar(20) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `log_maintain`
--

CREATE TABLE `log_maintain` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `value` decimal(30,0) DEFAULT NULL,
  `session_id` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `lunch_period`
--

CREATE TABLE `lunch_period` (
  `student_id` decimal(10,0) DEFAULT NULL,
  `school_date` date DEFAULT NULL,
  `period_id` decimal(10,0) DEFAULT NULL,
  `attendance_code` decimal(10,0) DEFAULT NULL,
  `attendance_teacher_code` decimal(10,0) DEFAULT NULL,
  `attendance_reason` varchar(100) DEFAULT NULL,
  `admin` varchar(1) DEFAULT NULL,
  `course_period_id` decimal(10,0) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `lunch_period` varchar(100) DEFAULT NULL,
  `table_name` decimal(10,0) DEFAULT NULL,
  `comment` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mail_group`
--

CREATE TABLE `mail_group` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `creation_date` datetime NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mail_groupmembers`
--

CREATE TABLE `mail_groupmembers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `profile` varchar(255) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Stand-in structure for view `marking_periods`
--
CREATE TABLE `marking_periods` (
`marking_period_id` int(11)
,`mp_source` varchar(7)
,`syear` decimal(10,0)
,`school_id` decimal(10,0)
,`mp_type` varchar(20)
,`title` varchar(50)
,`short_name` varchar(10)
,`sort_order` decimal(10,0)
,`parent_id` decimal(19,0)
,`grandparent_id` decimal(19,0)
,`start_date` date
,`end_date` date
,`post_start_date` date
,`post_end_date` date
,`does_grades` varchar(1)
,`does_exam` varchar(1)
,`does_comments` varchar(1)
);
-- --------------------------------------------------------

--
-- Table structure for table `marking_period_id_generator`
--

CREATE TABLE `marking_period_id_generator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `marking_period_id_generator`
--

INSERT INTO `marking_period_id_generator` VALUES
(1);

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

--
-- Table structure for table `medical_info`
--

CREATE TABLE `medical_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `syear` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `physician` varchar(255) DEFAULT NULL,
  `physician_phone` varchar(255) DEFAULT NULL,
  `preferred_hospital` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `missing_attendance`
--

CREATE TABLE `missing_attendance` (
  `school_id` int(11) NOT NULL,
  `syear` varchar(6) NOT NULL,
  `school_date` date NOT NULL,
  `course_period_id` int(11) NOT NULL,
  `period_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `secondary_teacher_id` int(11) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `msg_inbox`
--

CREATE TABLE `msg_inbox` (
  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
  `to_user` varchar(211) NOT NULL,
  `from_user` varchar(211) NOT NULL,
  `mail_Subject` varchar(211) DEFAULT NULL,
  `mail_body` longtext NOT NULL,
  `mail_datetime` datetime DEFAULT NULL,
  `mail_attachment` varchar(211) DEFAULT NULL,
  `isdraft` int(11) DEFAULT NULL,
  `istrash` varchar(255) DEFAULT NULL,
  `to_multiple_users` varchar(255) DEFAULT NULL,
  `to_cc` varchar(255) DEFAULT NULL,
  `to_cc_multiple` varchar(255) DEFAULT NULL,
  `to_bcc` varchar(255) DEFAULT NULL,
  `to_bcc_multiple` varchar(255) DEFAULT NULL,
  `mail_read_unread` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `msg_outbox`
--

CREATE TABLE `msg_outbox` (
  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
  `from_user` varchar(211) NOT NULL,
  `to_user` varchar(211) NOT NULL,
  `mail_subject` varchar(211) DEFAULT NULL,
  `mail_body` longtext NOT NULL,
  `mail_datetime` datetime DEFAULT NULL,
  `mail_attachment` varchar(211) DEFAULT NULL,
  `istrash` int(11) DEFAULT NULL,
  `to_cc` varchar(255) DEFAULT NULL,
  `to_bcc` varchar(255) DEFAULT NULL,
  `to_grpName` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `people`
--

CREATE TABLE `people` (
  `staff_id` int(11) NOT NULL AUTO_INCREMENT,
  `current_school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(5) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `middle_name` varchar(100) DEFAULT NULL,
  `home_phone` varchar(255) DEFAULT NULL,
  `work_phone` varchar(255) DEFAULT NULL,
  `cell_phone` varchar(255) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `custody` varchar(1) DEFAULT NULL,
  `profile` varchar(30) DEFAULT NULL,
  `profile_id` decimal(10,0) DEFAULT NULL,
  `is_disable` varchar(10) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `people_fields`
--

CREATE TABLE `people_fields` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) DEFAULT NULL,
  `search` varchar(1) DEFAULT NULL,
  `title` varchar(30) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `select_options` varchar(10000) DEFAULT NULL,
  `category_id` decimal(10,0) DEFAULT NULL,
  `system_field` char(1) DEFAULT NULL,
  `required` varchar(1) DEFAULT NULL,
  `default_selection` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `people_desc_ind` USING BTREE (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `people_field_categories`
--

CREATE TABLE `people_field_categories` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `include` varchar(100) DEFAULT NULL,
  `admin` char(1) DEFAULT NULL,
  `teacher` char(1) DEFAULT NULL,
  `parent` char(1) DEFAULT NULL,
  `none` char(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `people_field_categories`
--

INSERT INTO `people_field_categories` VALUES
(1, 'General Info', 1, NULL, 'Y', 'Y', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'Address Info', 2, NULL, 'Y', 'Y', 'Y', 'Y', '2015-07-28 11:26:33', NULL);

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

--
-- Table structure for table `portal_notes`
--

CREATE TABLE `portal_notes` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `school_id` decimal(10,0) DEFAULT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` longtext,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `published_user` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `published_profiles` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `profile_exceptions`
--

CREATE TABLE `profile_exceptions` (
  `profile_id` decimal(10,0) DEFAULT NULL,
  `modname` varchar(255) DEFAULT NULL,
  `can_use` varchar(1) DEFAULT NULL,
  `can_edit` varchar(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `profile_exceptions`
--

INSERT INTO `profile_exceptions` VALUES
(2, 'students/Student.php&category_id=6', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/Student.php&category_id=7', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'students/Student.php&category_id=6', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'students/Student.php&category_id=6', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'users/User.php&category_id=5', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'schoolsetup/Schools.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'schoolsetup/Calendar.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'students/Student.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'students/Student.php&category_id=1', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'students/Student.php&category_id=3', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'students/ChangePassword.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'scheduling/ViewSchedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'scheduling/PrintSchedules.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'scheduling/Requests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(3, 'grades/StudentGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'grades/FinalGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'grades/ReportCards.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'grades/Transcripts.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'grades/GPARankList.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'attendance/StudentSummary.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'attendance/DailySummary.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'eligibility/Student.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'eligibility/StudentList.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/Schools.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/MarkingPeriods.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/Calendar.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/Student.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/AddUsers.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/AdvancedReport.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/StudentLabels.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/Student.php&category_id=1', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/Student.php&category_id=3', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/Student.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'users/User.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/Rooms.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'grades/Grades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'users/Preferences.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'scheduling/Schedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'scheduling/PrintSchedules.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'scheduling/PrintClassLists.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'scheduling/PrintClassPictures.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/InputFinalGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/ReportCards.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/Grades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/Assignments.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/AnomalousGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/Configuration.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/ProgressReports.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/StudentGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/FinalGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/ReportCardGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'grades/ReportCardComments.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'attendance/TakeAttendance.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'attendance/DailySummary.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'attendance/StudentSummary.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'eligibility/EnterEligibility.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'scheduling/ViewSchedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'attendance/StudentSummary.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'attendance/DailySummary.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'eligibility/Student.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'eligibility/StudentList.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'schoolsetup/Schools.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'schoolsetup/Calendar.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'students/Student.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'students/Student.php&category_id=1', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'students/Student.php&category_id=3', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'users/User.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'users/User.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'users/Preferences.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'scheduling/ViewSchedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'scheduling/Requests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'grades/StudentGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'grades/FinalGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'grades/ReportCards.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'grades/Transcripts.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'grades/GPARankList.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'users/User.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'users/User.php&category_id=3', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/Courses.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/CourseCatalog.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/PrintCatalog.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'schoolsetup/PrintAllCourses.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'students/Student.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'students/ChangePassword.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'scheduling/StudentScheduleReport.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'grades/ParentProgressReports.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'scheduling/StudentScheduleReport.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'Billing/Fee.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'Billing/Balance_Report.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'Billing/DailyTransactions.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'Billing/Fee.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'Billing/Balance_Report.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'Billing/DailyTransactions.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/PortalNotes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/MarkingPeriods.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/Calendar.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/Periods.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/GradeLevels.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/Schools.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/UploadLogo.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/Schools.php?new_school=true', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/CopySchool.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/SystemPreference.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/Courses.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/CourseCatalog.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/PrintCatalog.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/PrintCatalogGradeLevel.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/PrintAllCourses.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/TeacherReassignment.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php&include=GeneralInfoInc&student_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/AssignOtherInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/AddUsers.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/AdvancedReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/AddDrop.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Letters.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/MailingLabels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/StudentLabels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/PrintStudentInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/PrintStudentContactInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/GoalReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/StudentFields.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'students/EnrollmentCodes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Upload.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Upload.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php&category_id=3', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/Student.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/User.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/User.php&staff_id=new', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/AddStudents.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/Preferences.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/Profiles.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/Exceptions.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/UserFields.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=grades/InputFinalGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=grades/Grades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=grades/ProgressReports.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=attendance/TakeAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=attendance/Missing_Attendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=eligibility/EnterEligibility.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'users/User.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/User.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'scheduling/Schedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/ViewSchedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/Requests.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/MassSchedule.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/MassRequests.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/MassDrops.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/PrintSchedules.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'scheduling/PrintClassLists.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'scheduling/PrintClassPictures.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/PrintRequests.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/ScheduleReport.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/RequestsReport.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/UnfilledRequests.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/IncompleteSchedules.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/AddDrop.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'scheduling/Scheduler.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/ReportCards.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'grades/CalcGPA.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'grades/Transcripts.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'grades/TeacherCompletion.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/GradeBreakdown.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/FinalGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/GPARankList.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/AdminProgressReports.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/HonorRoll.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/ReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'grades/ReportCardComments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'grades/HonorRollSetup.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'grades/FixGPA.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/EditReportCardGrades.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'grades/EditHistoryMarkingPeriods.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'attendance/Administration.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/AddAbsences.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/AttendanceData.php?list_by_day=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/Percent.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/Percent.php?list_by_day=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/DailySummary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/StudentSummary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/FixDailyAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/DuplicateAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'attendance/AttendanceCodes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'eligibility/Student.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'eligibility/AddActivity.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'eligibility/StudentList.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'eligibility/TeacherCompletion.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'eligibility/Activities.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'eligibility/EntryTimes.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(5, 'Billing/LedgerCard.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/Balance_Report.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/DailyTransactions.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/PaymentHistory.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/Fee.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/StudentPayments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/MassAssignFees.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/MassAssignPayments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/SetUp.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/SetUp_FeeType.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Billing/SetUp_PayPal.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'tools/LogDetails.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'tools/DeleteLog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'tools/Rollover.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'users/Staff.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/SchoolCustomFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=6', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=7', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/User.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/PortalNotes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Schools.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Schools.php?new_school=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/CopySchool.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/MarkingPeriods.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Calendar.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Periods.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/GradeLevels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Rollover.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Courses.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/CourseCatalog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/PrintCatalog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/PrintCatalogGradeLevel.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/PrintAllCourses.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/UploadLogo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/TeacherReassignment.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&include=GeneralInfoInc&student_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/AssignOtherInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/AddUsers.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/AdvancedReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/AddDrop.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Letters.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/MailingLabels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/StudentLabels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/PrintStudentInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/PrintStudentContactInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/GoalReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/StudentFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/AddressFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/PeopleFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/EnrollmentCodes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Upload.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Upload.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=3', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/StudentReenroll.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/EnrollmentReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/User.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/User.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/User.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/User.php&staff_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/AddStudents.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Preferences.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Profiles.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Exceptions.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/UserFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=grades/InputFinalGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=grades/Grades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=attendance/TakeAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=attendance/Missing_Attendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=eligibility/EnterEligibility.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/UploadUserPhoto.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/UploadUserPhoto.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/UserAdvancedReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/UserAdvancedReportStaff.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/Schedule.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/Requests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/MassSchedule.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/MassRequests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/MassDrops.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/ScheduleReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/RequestsReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/UnfilledRequests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/IncompleteSchedules.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/AddDrop.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/PrintSchedules.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/PrintRequests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/PrintClassLists.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/PrintClassPictures.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/Courses.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/Scheduler.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'scheduling/ViewSchedule.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/ReportCards.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/CalcGPA.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/Transcripts.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/GradeBreakdown.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/FinalGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/GPARankList.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/ReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/ReportCardComments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/FixGPA.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/EditReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/EditHistoryMarkingPeriods.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/HistoricalReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/Administration.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/AddAbsences.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/AttendanceData.php?list_by_day=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/Percent.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/Percent.php?list_by_day=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/DailySummary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/StudentSummary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/DuplicateAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/AttendanceCodes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'attendance/FixDailyAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'eligibility/Student.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'eligibility/AddActivity.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'eligibility/StudentList.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'eligibility/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'eligibility/Activities.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'eligibility/EntryTimes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'tools/LogDetails.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'tools/DeleteLog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'schoolsetup/SchoolCustomFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'tools/Rollover.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Upload.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Upload.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/SystemPreference.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'students/Student.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/HonorRoll.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=grades/ProgressReports.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/User.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/HonorRollSetup.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'grades/AdminProgressReports.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/LedgerCard.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/Balance_Report.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/DailyTransactions.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/PaymentHistory.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/Fee.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/StudentPayments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/MassAssignFees.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/MassAssignPayments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/SetUp.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/SetUp_FeeType.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'Billing/SetUp_PayPal.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php&staff_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Exceptions_staff.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/StaffFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php&category_id=3', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'messaging/Inbox.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'messaging/Compose.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'messaging/SentMail.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'messaging/Trash.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'messaging/Group.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'messaging/Inbox.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'messaging/Compose.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'messaging/SentMail.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'messaging/Trash.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(4, 'messaging/Group.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'messaging/Inbox.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'messaging/Compose.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'messaging/SentMail.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'messaging/Trash.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'messaging/Group.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'messaging/Inbox.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'messaging/Compose.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'messaging/SentMail.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'messaging/Trash.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(3, 'messaging/Group.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=6', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=7', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/User.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/PortalNotes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Schools.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Schools.php?new_school=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/CopySchool.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/MarkingPeriods.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Calendar.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Periods.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/GradeLevels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Rollover.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Courses.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/CourseCatalog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/PrintCatalog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/PrintCatalogGradeLevel.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/PrintAllCourses.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/UploadLogo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/TeacherReassignment.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&include=GeneralInfoInc&student_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/AssignOtherInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/AddUsers.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/AdvancedReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/AddDrop.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Letters.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/MailingLabels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/StudentLabels.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/PrintStudentInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/PrintStudentContactInfo.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/GoalReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/StudentFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/AddressFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/PeopleFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/EnrollmentCodes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Upload.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Upload.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=3', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/StudentReenroll.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/EnrollmentReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/User.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/User.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/User.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/User.php&staff_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/AddStudents.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Preferences.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Profiles.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Exceptions.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/UserFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=grades/InputFinalGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=grades/Grades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=attendance/TakeAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=attendance/Missing_Attendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=eligibility/EnterEligibility.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/UploadUserPhoto.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/UploadUserPhoto.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/UserAdvancedReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/UserAdvancedReportStaff.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/Schedule.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/Requests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/MassSchedule.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/MassRequests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/MassDrops.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/ScheduleReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/RequestsReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/UnfilledRequests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/IncompleteSchedules.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/AddDrop.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/PrintSchedules.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/PrintRequests.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/PrintClassLists.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/PrintClassPictures.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/Courses.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/Scheduler.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'scheduling/ViewSchedule.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/ReportCards.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/CalcGPA.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/Transcripts.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/GradeBreakdown.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/FinalGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/GPARankList.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/ReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/ReportCardComments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/FixGPA.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/EditReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/EditHistoryMarkingPeriods.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/HistoricalReportCardGrades.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/Administration.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/AddAbsences.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/AttendanceData.php?list_by_day=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/Percent.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/Percent.php?list_by_day=true', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/DailySummary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/StudentSummary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/DuplicateAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/AttendanceCodes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'attendance/FixDailyAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'eligibility/Student.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'eligibility/AddActivity.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'eligibility/StudentList.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'eligibility/TeacherCompletion.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'eligibility/Activities.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'eligibility/EntryTimes.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/LogDetails.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/DeleteLog.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/Backup.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/Rollover.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Upload.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Upload.php?modfunc=edit', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/SystemPreference.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'students/Student.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/HonorRoll.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=grades/ProgressReports.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/User.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/HonorRollSetup.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/AdminProgressReports.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/LedgerCard.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/Balance_Report.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/DailyTransactions.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/PaymentHistory.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/Fee.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/StudentPayments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/MassAssignFees.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/MassAssignPayments.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/SetUp.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/SetUp_FeeType.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'Billing/SetUp_PayPal.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php&staff_id=new', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Exceptions_staff.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/StaffFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php&category_id=3', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/SchoolCustomFields.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'messaging/Inbox.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'messaging/Compose.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'messaging/SentMail.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'messaging/Trash.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'messaging/Group.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Rooms.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/school_specific_standards.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=grades/AdminProgressReports.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/Reports.php?func=Basic', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/Reports.php?func=Ins_r', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'tools/Reports.php?func=Ins_cf', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/us_common_standards.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/EffortGradeLibrary.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'grades/EffortGradeSetup.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'scheduling/PrintSchedules.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(0, 'users/TeacherPrograms.php?include=attendance/MissingAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(0, 'users/Staff.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'schoolsetup/Rooms.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/TeacherPrograms.php?include=attendance/MissingAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(1, 'users/Staff.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'students/EnrollmentReport.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'users/TeacherPrograms.php?include=attendance/MissingAttendance.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'messaging/Inbox.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'messaging/Compose.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'messaging/SentMail.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'messaging/Trash.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'messaging/Group.php', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'users/Staff.php&category_id=1', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'users/Staff.php&category_id=2', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'users/Staff.php&category_id=3', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(2, 'users/Staff.php&category_id=4', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'users/Staff.php&category_id=5', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'grades/ParentProgressReports.php', 'Y', NULL, '2015-07-28 11:26:33', NULL),
(0, 'schoolsetup/Sections.php', 'Y', 'Y', '2017-07-25 17:53:00', NULL),
(1, 'schoolsetup/Sections.php', 'Y', 'Y', '2017-07-25 17:53:25', NULL);

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

--
-- Table structure for table `program_config`
--

CREATE TABLE `program_config` (
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `program` varchar(255) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  KEY `program_config_ind1` USING BTREE (`program`,`school_id`,`syear`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `program_config`
--

INSERT INTO `program_config` VALUES
(2015, NULL, 'Currency', 'US Dollar (USD)', '1', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'British Pound (GBP)', '2', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Euro (EUR)', '3', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Canadian Dollar (CAD)', '4', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Australian Dollar (AUD)', '5', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Brazilian Real (BRL)', '6', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Chinese Yuan Renminbi (CNY)', '7', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Danish Krone (DKK)', '8', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Japanese Yen (JPY)', '9', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Indian Rupee (INR)', '10', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Indonesian Rupiah (IDR)', '11', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Korean Won  (KRW)', '12', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Malaysian Ringit (MYR)', '13', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Mexican Peso (MXN)', '14', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'New Zealand Dollar (NZD)', '15', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Norwegian Krone  (NOK)', '16', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Pakistan Rupee  (PKR)', '17', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Philippino Peso (PHP)', '18', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Saudi Riyal (SAR)', '19', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Singapore Dollar (SGD)', '20', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'South African Rand  (ZAR)', '21', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Swedish Krona  (SEK)', '22', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Swiss Franc  (CHF)', '23', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Thai Bhat  (THB)', '24', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'Turkish Lira  (TRY)', '25', '2015-07-28 11:26:33', NULL),
(2015, NULL, 'Currency', 'United Arab Emirates Dirham (AED)', '26', '2015-07-28 11:26:33', NULL),
(2015, 1, 'MissingAttendance', 'LAST_UPDATE', '2018-02-02', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'START_DAY', '1', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'START_HOUR', '8', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'START_MINUTE', '00', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'START_M', 'AM', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'END_DAY', '5', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'END_HOUR', '16', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'END_MINUTE', '00', '2015-07-28 11:26:33', NULL),
(2015, 1, 'eligibility', 'END_M', 'PM', '2015-07-28 11:26:33', NULL),
(2015, 1, 'UPDATENOTIFY', 'display', 'Y', '2016-05-14 14:56:51', NULL),
(2015, 1, 'UPDATENOTIFY', 'display_school', 'Y', '2016-05-14 14:56:51', NULL),
(2015, 1, 'SeatFill', 'LAST_UPDATE', '2017-07-14', '2015-07-28 11:26:33', NULL),
(2016, 1, 'eligibility', 'START_DAY', '1', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'START_HOUR', '8', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'START_MINUTE', '00', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'START_M', 'AM', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'END_DAY', '5', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'END_HOUR', '16', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'END_MINUTE', '00', '2017-07-14 18:30:31', NULL),
(2016, 1, 'eligibility', 'END_M', 'PM', '2017-07-14 18:30:31', NULL),
(2017, 1, 'MissingAttendance', 'LAST_UPDATE', '2018-02-02', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'START_DAY', '1', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'START_HOUR', '8', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'START_MINUTE', '00', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'START_M', 'AM', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'END_DAY', '5', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'END_HOUR', '16', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'END_MINUTE', '00', '2018-01-22 04:18:02', NULL),
(2017, 1, 'eligibility', 'END_M', 'PM', '2018-01-22 04:18:02', NULL),
(2017, 1, 'UPDATENOTIFY', 'display', 'Y', '2018-01-22 04:18:02', NULL),
(2017, 1, 'UPDATENOTIFY', 'display_school', 'Y', '2018-01-22 04:18:02', NULL),
(2017, 1, 'SeatFill', 'LAST_UPDATE', '2018-02-02', '2018-01-22 04:18:02', NULL),
([[beg_year]], 1, 'MissingAttendance', 'LAST_UPDATE', '[[Beg_date]]', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'START_DAY', '1', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'START_HOUR', '8', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'START_MINUTE', '00', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'START_M', 'AM', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'END_DAY', '5', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'END_HOUR', '16', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'END_MINUTE', '00', '[[regtime]]', NULL),
([[beg_year]], 1, 'eligibility', 'END_M', 'PM', '[[regtime]]', NULL),
([[beg_year]], 1, 'UPDATENOTIFY', 'display', 'Y', '[[regtime]]', NULL),
([[beg_year]], 1, 'UPDATENOTIFY', 'display_school', 'Y', '[[regtime]]', NULL),
([[beg_year]], 1, 'SeatFill', 'LAST_UPDATE', '[[Beg_date]]', '[[regtime]]', NULL);

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

--
-- Table structure for table `program_user_config`
--

CREATE TABLE `program_user_config` (
  `user_id` decimal(10,0) NOT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `program` varchar(255) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  KEY `program_user_config_ind1` USING BTREE (`user_id`,`program`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `program_user_config`
--

INSERT INTO `program_user_config` VALUES
(1, NULL, 'Preferences', 'THEME', 'blue', '2015-07-28 05:56:33', NULL),
(1, NULL, 'Preferences', 'MONTH', 'M', '2015-07-28 05:56:33', NULL),
(1, NULL, 'Preferences', 'DAY', 'j', '2015-07-28 05:56:33', NULL),
(1, NULL, 'Preferences', 'YEAR', 'Y', '2015-07-28 05:56:33', NULL),
(1, NULL, 'Preferences', 'HIDDEN', 'Y', '2015-07-28 05:56:33', NULL),
(1, NULL, 'Preferences', 'CURRENCY', '1', '2015-07-28 05:56:33', NULL),
(1, NULL, 'Preferences', 'HIDE_ALERTS', 'N', '2015-07-28 05:56:33', NULL);

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

--
-- Table structure for table `report_card_comments`
--

CREATE TABLE `report_card_comments` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `course_id` decimal(10,0) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `title` text,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `report_card_comments_ind1` USING BTREE (`syear`,`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `report_card_grades`
--

CREATE TABLE `report_card_grades` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `gpa_value` decimal(4,2) DEFAULT NULL,
  `break_off` decimal(10,0) DEFAULT NULL,
  `comment` longtext,
  `grade_scale_id` decimal(10,0) DEFAULT NULL,
  `unweighted_gp` decimal(4,2) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `report_card_grades_ind1` USING BTREE (`syear`,`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `report_card_grade_scales`
--

CREATE TABLE `report_card_grade_scales` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) NOT NULL,
  `title` varchar(25) DEFAULT NULL,
  `comment` varchar(100) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `gp_scale` decimal(10,3) DEFAULT NULL,
  `gpa_cal` enum('Y','N') NOT NULL DEFAULT 'Y',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `room_id` int(11) NOT NULL AUTO_INCREMENT,
  `school_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `capacity` int(11) DEFAULT NULL,
  `description` text,
  `sort_order` int(11) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `schedule`
--

CREATE TABLE `schedule` (
  `syear` decimal(4,0) NOT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `student_id` decimal(10,0) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `modified_date` date DEFAULT NULL,
  `modified_by` varchar(255) DEFAULT NULL,
  `course_id` decimal(10,0) NOT NULL,
  `course_weight` varchar(10) DEFAULT NULL,
  `course_period_id` decimal(10,0) NOT NULL,
  `mp` varchar(3) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `scheduler_lock` varchar(1) DEFAULT NULL,
  `dropped` varchar(1) DEFAULT 'N',
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `schedule_ind1` USING BTREE (`course_id`,`course_weight`),
  KEY `schedule_ind2` USING BTREE (`course_period_id`),
  KEY `schedule_ind3` USING BTREE (`student_id`,`marking_period_id`,`start_date`,`end_date`),
  KEY `schedule_ind4` USING BTREE (`syear`,`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Triggers `schedule`
--
DROP TRIGGER IF EXISTS `td_schedule`;
DELIMITER //
CREATE TRIGGER `td_schedule` AFTER DELETE ON `schedule`
 FOR EACH ROW BEGIN
         UPDATE course_periods SET filled_seats=filled_seats-1 WHERE course_period_id=OLD.course_period_id AND OLD.dropped='N';
 	CALL ATTENDANCE_CALC(OLD.course_period_id);
 END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ti_schdule`;
DELIMITER //
CREATE TRIGGER `ti_schdule` AFTER INSERT ON `schedule`
 FOR EACH ROW BEGIN
         UPDATE course_periods SET filled_seats=filled_seats+1 WHERE course_period_id=NEW.course_period_id;
 	CALL ATTENDANCE_CALC(NEW.course_period_id);
 END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `tu_schedule`;
DELIMITER //
CREATE TRIGGER `tu_schedule` AFTER UPDATE ON `schedule`
 FOR EACH ROW CALL ATTENDANCE_CALC(NEW.course_period_id)
//
DELIMITER ;

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

--
-- Table structure for table `schedule_requests`
--

CREATE TABLE `schedule_requests` (
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `request_id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) DEFAULT NULL,
  `subject_id` decimal(10,0) DEFAULT NULL,
  `course_id` decimal(10,0) DEFAULT NULL,
  `course_weight` varchar(10) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `priority` decimal(10,0) DEFAULT NULL,
  `with_teacher_id` decimal(10,0) DEFAULT NULL,
  `not_teacher_id` decimal(10,0) DEFAULT NULL,
  `with_period_id` decimal(10,0) DEFAULT NULL,
  `not_period_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`request_id`),
  KEY `schedule_requests_ind1` USING BTREE (`student_id`,`course_id`,`course_weight`,`syear`,`school_id`),
  KEY `schedule_requests_ind2` USING BTREE (`syear`,`school_id`),
  KEY `schedule_requests_ind3` USING BTREE (`course_id`,`course_weight`,`syear`,`school_id`),
  KEY `schedule_requests_ind4` USING BTREE (`with_teacher_id`),
  KEY `schedule_requests_ind5` USING BTREE (`not_teacher_id`),
  KEY `schedule_requests_ind6` USING BTREE (`with_period_id`),
  KEY `schedule_requests_ind7` USING BTREE (`not_period_id`),
  KEY `schedule_requests_ind8` USING BTREE (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `schools`
--

CREATE TABLE `schools` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(10) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `area_code` decimal(3,0) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `principal` varchar(100) DEFAULT NULL,
  `www_address` varchar(100) DEFAULT NULL,
  `e_mail` varchar(100) DEFAULT NULL,
  `reporting_gp_scale` decimal(10,3) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `schools_ind1` USING BTREE (`syear`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `schools`
--

INSERT INTO `schools` VALUES
(1, [[beg_year]], '[[site_name]]', '123 Main Street', 'Atlanta', 'Georgia', '78990', NULL, '860-347-6971', 'P. Lawrence', NULL, NULL, 4.000, '2018-01-22 04:18:02', NULL);

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

--
-- Table structure for table `school_calendars`
--

CREATE TABLE `school_calendars` (
  `school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `calendar_id` int(8) NOT NULL AUTO_INCREMENT,
  `default_calendar` varchar(1) DEFAULT NULL,
  `days` varchar(7) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`calendar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `school_custom_fields`
--

CREATE TABLE `school_custom_fields` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `school_id` int(11) NOT NULL,
  `type` varchar(10) DEFAULT NULL,
  `search` varchar(1) DEFAULT NULL,
  `title` varchar(30) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `select_options` varchar(10000) DEFAULT NULL,
  `category_id` decimal(10,0) DEFAULT NULL,
  `system_field` char(1) DEFAULT NULL,
  `required` varchar(1) DEFAULT NULL,
  `default_selection` varchar(255) DEFAULT NULL,
  `hide` varchar(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `school_gradelevels`
--

CREATE TABLE `school_gradelevels` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `school_id` decimal(10,0) DEFAULT NULL,
  `short_name` varchar(5) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `next_grade_id` decimal(10,0) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `school_gradelevels_ind1` USING BTREE (`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `school_gradelevel_sections`
--

CREATE TABLE `school_gradelevel_sections` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `school_id` decimal(10,0) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `school_gradelevels_ind1` (`school_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `school_periods`
--

CREATE TABLE `school_periods` (
  `period_id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `length` decimal(10,0) DEFAULT NULL,
  `block` varchar(10) DEFAULT NULL,
  `ignore_scheduling` varchar(10) DEFAULT NULL,
  `attendance` varchar(1) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`period_id`),
  KEY `school_periods_ind1` USING BTREE (`period_id`,`syear`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Triggers `school_periods`
--
DROP TRIGGER IF EXISTS `tu_periods`;
DELIMITER //
CREATE TRIGGER `tu_periods` AFTER UPDATE ON `school_periods`
 FOR EACH ROW UPDATE course_period_var SET start_time=NEW.start_time,end_time=NEW.end_time WHERE period_id=NEW.period_id
//
DELIMITER ;

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

--
-- Table structure for table `school_progress_periods`
--

CREATE TABLE `school_progress_periods` (
  `marking_period_id` int(11) NOT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `quarter_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `post_start_date` date DEFAULT NULL,
  `post_end_date` date DEFAULT NULL,
  `does_grades` varchar(1) DEFAULT NULL,
  `does_exam` varchar(1) DEFAULT NULL,
  `does_comments` varchar(1) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`marking_period_id`),
  KEY `school_progress_periods_ind1` USING BTREE (`quarter_id`),
  KEY `school_progress_periods_ind2` USING BTREE (`syear`,`school_id`,`start_date`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `school_quarters`
--

CREATE TABLE `school_quarters` (
  `marking_period_id` int(11) NOT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `semester_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `post_start_date` date DEFAULT NULL,
  `post_end_date` date DEFAULT NULL,
  `does_grades` varchar(1) DEFAULT NULL,
  `does_exam` varchar(1) DEFAULT NULL,
  `does_comments` varchar(1) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`marking_period_id`),
  KEY `school_quarters_ind1` USING BTREE (`semester_id`),
  KEY `school_quarters_ind2` USING BTREE (`syear`,`school_id`,`start_date`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Triggers `school_quarters`
--
DROP TRIGGER IF EXISTS `tu_school_quarters`;
DELIMITER //
CREATE TRIGGER `tu_school_quarters` AFTER UPDATE ON `school_quarters`
 FOR EACH ROW UPDATE course_periods SET begin_date=NEW.start_date,end_date=NEW.end_date WHERE marking_period_id=NEW.marking_period_id
//
DELIMITER ;

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

--
-- Table structure for table `school_semesters`
--

CREATE TABLE `school_semesters` (
  `marking_period_id` int(11) NOT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `year_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `post_start_date` date DEFAULT NULL,
  `post_end_date` date DEFAULT NULL,
  `does_grades` varchar(1) DEFAULT NULL,
  `does_exam` varchar(1) DEFAULT NULL,
  `does_comments` varchar(1) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`marking_period_id`),
  KEY `school_semesters_ind1` USING BTREE (`year_id`),
  KEY `school_semesters_ind2` USING BTREE (`syear`,`school_id`,`start_date`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Triggers `school_semesters`
--
DROP TRIGGER IF EXISTS `tu_school_semesters`;
DELIMITER //
CREATE TRIGGER `tu_school_semesters` AFTER UPDATE ON `school_semesters`
 FOR EACH ROW UPDATE course_periods SET begin_date=NEW.start_date,end_date=NEW.end_date WHERE marking_period_id=NEW.marking_period_id
//
DELIMITER ;

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

--
-- Table structure for table `school_years`
--

CREATE TABLE `school_years` (
  `marking_period_id` int(11) NOT NULL,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `post_start_date` date DEFAULT NULL,
  `post_end_date` date DEFAULT NULL,
  `does_grades` varchar(1) DEFAULT NULL,
  `does_exam` varchar(1) DEFAULT NULL,
  `does_comments` varchar(1) DEFAULT NULL,
  `rollover_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`marking_period_id`),
  KEY `school_years_ind2` USING BTREE (`syear`,`school_id`,`start_date`,`end_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `school_years`
--

INSERT INTO `school_years` VALUES
(1, [[beg_year]], 1, 'Full Year', 'FY', 1, '[[Beg_date]]', '[[End_date]]', '2018-05-21', '2018-06-08', 'Y', NULL, 'Y', NULL, '2018-01-22 04:18:02', NULL);

--
-- Triggers `school_years`
--
DROP TRIGGER IF EXISTS `tu_school_years`;
DELIMITER //
CREATE TRIGGER `tu_school_years` AFTER UPDATE ON `school_years`
 FOR EACH ROW UPDATE course_periods SET begin_date=NEW.start_date,end_date=NEW.end_date WHERE marking_period_id=NEW.marking_period_id
//
DELIMITER ;

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `staff_id` int(8) NOT NULL AUTO_INCREMENT,
  `current_school_id` decimal(10,0) DEFAULT NULL,
  `title` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `first_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `last_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `middle_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `profile` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `homeroom` varchar(5) CHARACTER SET utf8 DEFAULT NULL,
  `profile_id` decimal(10,0) DEFAULT NULL,
  `primary_language_id` int(8) DEFAULT NULL,
  `gender` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `ethnicity_id` int(8) DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `alternate_id` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `name_suffix` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `second_language_id` int(8) DEFAULT NULL,
  `third_language_id` int(8) DEFAULT NULL,
  `is_disable` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `physical_disability` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `disability_desc` varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`staff_id`),
  KEY `staff_ind2` USING BTREE (`last_name`,`first_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` VALUES
(1, 1, NULL, '[[admin_fname]]', '[[admin_lname]]', '', NULL, NULL, 'admin', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL, '2015-07-28 05:56:33', NULL);

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

--
-- Table structure for table `staff_address`
--

CREATE TABLE `staff_address` (
  `staff_address_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` int(8) NOT NULL,
  `staff_address1_primary` text NOT NULL,
  `staff_address2_primary` text,
  `staff_city_primary` varchar(255) NOT NULL,
  `staff_state_primary` varchar(255) NOT NULL,
  `staff_zip_primary` varchar(255) NOT NULL,
  `staff_address1_mail` text NOT NULL,
  `staff_address2_mail` text,
  `staff_city_mail` varchar(255) NOT NULL,
  `staff_state_mail` varchar(255) NOT NULL,
  `staff_zip_mail` varchar(255) NOT NULL,
  `last_update` datetime NOT NULL,
  `staff_pobox_mail` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date time staff address record modified',
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_address_id`),
  UNIQUE KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `staff_certification`
--

CREATE TABLE `staff_certification` (
  `staff_certification_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` int(8) NOT NULL,
  `staff_certification_date` date DEFAULT NULL,
  `staff_certification_expiry_date` date DEFAULT NULL,
  `staff_certification_code` varchar(127) DEFAULT NULL,
  `staff_certification_short_name` varchar(127) DEFAULT NULL,
  `staff_certification_name` varchar(255) DEFAULT NULL,
  `staff_primary_certification_indicator` char(1) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `staff_certification_description` text,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_certification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `staff_contact`
--

CREATE TABLE `staff_contact` (
  `staff_phone_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` int(8) NOT NULL,
  `last_update` datetime NOT NULL,
  `staff_home_phone` varchar(62) DEFAULT NULL,
  `staff_mobile_phone` varchar(62) DEFAULT NULL,
  `staff_work_phone` varchar(62) DEFAULT NULL,
  `staff_work_email` varchar(127) DEFAULT NULL,
  `staff_personal_email` varchar(127) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_phone_id`),
  UNIQUE KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `staff_emergency_contact`
--

CREATE TABLE `staff_emergency_contact` (
  `staff_emergency_contact_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` int(8) NOT NULL,
  `staff_emergency_first_name` varchar(255) NOT NULL,
  `staff_emergency_last_name` varchar(255) NOT NULL,
  `staff_emergency_relationship` varchar(255) NOT NULL,
  `staff_emergency_home_phone` varchar(64) DEFAULT NULL,
  `staff_emergency_mobile_phone` varchar(64) DEFAULT NULL,
  `staff_emergency_work_phone` varchar(64) DEFAULT NULL,
  `staff_emergency_email` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_emergency_contact_id`),
  UNIQUE KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `staff_fields`
--

CREATE TABLE `staff_fields` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) DEFAULT NULL,
  `search` varchar(1) DEFAULT NULL,
  `title` varchar(30) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `select_options` varchar(10000) DEFAULT NULL,
  `category_id` decimal(10,0) DEFAULT NULL,
  `system_field` char(1) DEFAULT NULL,
  `required` varchar(1) DEFAULT NULL,
  `default_selection` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_desc_ind1` USING BTREE (`id`),
  KEY `staff_desc_ind2` USING BTREE (`type`),
  KEY `staff_fields_ind3` USING BTREE (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `staff_field_categories`
--

CREATE TABLE `staff_field_categories` (
  `id` int(8) NOT NULL DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `include` varchar(100) DEFAULT NULL,
  `admin` char(1) DEFAULT NULL,
  `teacher` char(1) DEFAULT NULL,
  `parent` char(1) DEFAULT NULL,
  `none` char(1) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_field_categories`
--

INSERT INTO `staff_field_categories` VALUES
(1, 'Demographic Info', 1, NULL, 'Y', 'Y', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(2, 'Addresses & Contacts', 2, NULL, 'Y', 'Y', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(3, 'School Information', 3, NULL, 'Y', 'Y', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(4, 'Certification Information', 4, NULL, 'Y', 'Y', 'Y', 'Y', '2015-07-28 11:26:33', NULL),
(5, 'Schedule', 5, NULL, 'Y', 'Y', NULL, NULL, '2015-07-28 11:26:33', NULL);

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

--
-- Table structure for table `staff_school_info`
--

CREATE TABLE `staff_school_info` (
  `staff_school_info_id` int(8) NOT NULL AUTO_INCREMENT,
  `staff_id` int(8) NOT NULL,
  `category` varchar(255) NOT NULL,
  `job_title` varchar(255) DEFAULT NULL,
  `joining_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `home_school` int(8) NOT NULL,
  `opensis_access` char(1) NOT NULL DEFAULT 'N',
  `opensis_profile` varchar(255) DEFAULT NULL,
  `school_access` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time staff school info was modified',
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`staff_school_info_id`),
  UNIQUE KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `staff_school_info`
--

INSERT INTO `staff_school_info` VALUES
(1, 1, 'Super Administrator', 'Super Administrator', '[[Beg_date]]', NULL, 1, 'Y', '0', ',1,', '2018-01-22 04:18:03', NULL);

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

--
-- Table structure for table `staff_school_relationship`
--

CREATE TABLE `staff_school_relationship` (
  `staff_id` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `syear` int(4) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`staff_id`,`school_id`,`syear`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_school_relationship`
--

INSERT INTO `staff_school_relationship` VALUES
(1, 1, [[beg_year]], '[[regtime]]', NULL, '0000-00-00', '0000-00-00');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `student_id` int(8) NOT NULL AUTO_INCREMENT,
  `last_name` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `middle_name` varchar(50) DEFAULT NULL,
  `name_suffix` varchar(3) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `ethnicity` varchar(255) DEFAULT NULL,
  `common_name` varchar(255) DEFAULT NULL,
  `social_security` varchar(255) DEFAULT NULL,
  `birthdate` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `estimated_grad_date` varchar(255) DEFAULT NULL,
  `alt_id` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `is_disable` varchar(10) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`student_id`),
  KEY `name` USING BTREE (`last_name`,`first_name`,`middle_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `students_join_people`
--

CREATE TABLE `students_join_people` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) NOT NULL,
  `person_id` decimal(10,0) NOT NULL,
  `is_emergency` varchar(10) DEFAULT NULL,
  `emergency_type` varchar(100) DEFAULT NULL,
  `relationship` varchar(100) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_address`
--

CREATE TABLE `student_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `syear` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `street_address_1` varchar(5000) DEFAULT NULL,
  `street_address_2` varchar(5000) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `bus_pickup` varchar(1) DEFAULT NULL,
  `bus_dropoff` varchar(1) DEFAULT NULL,
  `bus_no` varchar(255) DEFAULT NULL,
  `type` varchar(500) NOT NULL,
  `people_id` int(11) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_eligibility_activities`
--

CREATE TABLE `student_eligibility_activities` (
  `syear` decimal(4,0) DEFAULT NULL,
  `student_id` decimal(10,0) DEFAULT NULL,
  `activity_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  KEY `student_eligibility_activities_ind1` USING BTREE (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `student_enrollment`
--

CREATE TABLE `student_enrollment` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `student_id` decimal(10,0) DEFAULT NULL,
  `grade_id` decimal(10,0) DEFAULT NULL,
  `section_id` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `enrollment_code` decimal(10,0) DEFAULT NULL,
  `drop_code` decimal(10,0) DEFAULT NULL,
  `next_school` decimal(10,0) DEFAULT NULL,
  `calendar_id` decimal(10,0) DEFAULT NULL,
  `last_school` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_enrollment_1` USING BTREE (`student_id`,`enrollment_code`),
  KEY `student_enrollment_2` USING BTREE (`grade_id`),
  KEY `student_enrollment_3` USING BTREE (`syear`,`student_id`,`school_id`,`grade_id`),
  KEY `student_enrollment_6` USING BTREE (`syear`,`student_id`,`start_date`,`end_date`),
  KEY `student_enrollment_7` USING BTREE (`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_enrollment_codes`
--

CREATE TABLE `student_enrollment_codes` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `syear` decimal(4,0) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `type` varchar(4) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `student_enrollment_codes`
--

INSERT INTO `student_enrollment_codes` VALUES
(1, [[beg_year]], 'Transferred out', 'TRAN', 'TrnD', '2015-07-28 05:56:33', NULL),
(2, [[beg_year]], 'Transferred in', 'TRAN', 'TrnE', '2015-07-28 05:56:33', NULL),
(3, [[beg_year]], 'Rolled over', 'ROLL', 'Roll', '2015-07-28 05:56:33', NULL),
(4, [[beg_year]], 'Dropped Out', 'DROP', 'Drop', '2015-07-28 05:56:33', NULL),
(5, [[beg_year]], 'New', 'NEW', 'Add', '2015-07-28 05:56:33', NULL);

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

--
-- Table structure for table `student_field_categories`
--

CREATE TABLE `student_field_categories` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `sort_order` decimal(10,0) DEFAULT NULL,
  `include` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `student_field_categories`
--

INSERT INTO `student_field_categories` VALUES
(1, 'General Info', 1, NULL, '2015-07-28 11:26:33', NULL),
(2, 'Medical', 3, NULL, '2015-07-28 11:26:33', NULL),
(3, 'Addresses & Contacts', 2, NULL, '2015-07-28 11:26:33', NULL),
(4, 'Comments', 4, NULL, '2015-07-28 11:26:33', NULL),
(5, 'Goals', 5, NULL, '2015-07-28 11:26:33', NULL),
(6, 'Enrollment Info', 6, NULL, '2015-07-28 11:26:33', NULL),
(7, 'Files', 7, NULL, '2015-07-28 11:26:33', NULL);

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

--
-- Table structure for table `student_goal`
--

CREATE TABLE `student_goal` (
  `goal_id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) NOT NULL,
  `goal_title` varchar(100) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `goal_description` text,
  `school_id` decimal(10,0) DEFAULT NULL,
  `syear` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`goal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_goal_progress`
--

CREATE TABLE `student_goal_progress` (
  `progress_id` int(8) NOT NULL AUTO_INCREMENT,
  `goal_id` decimal(10,0) NOT NULL,
  `student_id` decimal(10,0) NOT NULL,
  `start_date` date DEFAULT NULL,
  `progress_name` text NOT NULL,
  `proficiency` varchar(100) NOT NULL,
  `progress_description` text NOT NULL,
  `course_period_id` decimal(10,0) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`progress_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_gpa_calculated`
--

CREATE TABLE `student_gpa_calculated` (
  `student_id` decimal(10,0) DEFAULT NULL,
  `marking_period_id` int(11) DEFAULT NULL,
  `mp` varchar(4) DEFAULT NULL,
  `gpa` decimal(10,2) DEFAULT NULL,
  `weighted_gpa` decimal(10,2) DEFAULT NULL,
  `unweighted_gpa` decimal(10,2) DEFAULT NULL,
  `class_rank` decimal(10,0) DEFAULT NULL,
  `grade_level_short` varchar(100) DEFAULT NULL,
  `cgpa` decimal(10,2) DEFAULT NULL,
  `cum_unweighted_factor` decimal(10,6) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  KEY `student_gpa_calculated_ind1` USING BTREE (`marking_period_id`,`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `student_immunization`
--

CREATE TABLE `student_immunization` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  `medical_date` date DEFAULT NULL,
  `comments` longtext,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_medical_ind1` USING BTREE (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_medical_alerts`
--

CREATE TABLE `student_medical_alerts` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) DEFAULT NULL,
  `title` text,
  `alert_date` date DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_medical_alerts_ind1` USING BTREE (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_medical_notes`
--

CREATE TABLE `student_medical_notes` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) NOT NULL,
  `doctors_note_date` date DEFAULT NULL,
  `doctors_note_comments` longtext,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_medical_visits`
--

CREATE TABLE `student_medical_visits` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) DEFAULT NULL,
  `school_date` date DEFAULT NULL,
  `time_in` varchar(20) DEFAULT NULL,
  `time_out` varchar(20) DEFAULT NULL,
  `reason` text,
  `result` text,
  `comments` longtext,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_medical_visits_ind1` USING BTREE (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_mp_comments`
--

CREATE TABLE `student_mp_comments` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `student_id` decimal(10,0) NOT NULL,
  `syear` decimal(4,0) NOT NULL,
  `marking_period_id` int(11) NOT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `comment` longtext,
  `comment_date` date DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `student_report_card_comments`
--

CREATE TABLE `student_report_card_comments` (
  `syear` decimal(4,0) NOT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `student_id` decimal(10,0) NOT NULL,
  `course_period_id` decimal(10,0) NOT NULL,
  `report_card_comment_id` decimal(10,0) NOT NULL,
  `comment` varchar(1) DEFAULT NULL,
  `marking_period_id` int(11) NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`syear`,`student_id`,`course_period_id`,`marking_period_id`,`report_card_comment_id`),
  KEY `student_report_card_comments_ind1` USING BTREE (`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `student_report_card_grades`
--

CREATE TABLE `student_report_card_grades` (
  `syear` decimal(4,0) DEFAULT NULL,
  `school_id` decimal(10,0) DEFAULT NULL,
  `student_id` decimal(10,0) NOT NULL,
  `course_period_id` decimal(10,0) DEFAULT NULL,
  `report_card_grade_id` decimal(10,0) DEFAULT NULL,
  `report_card_comment_id` decimal(10,0) DEFAULT NULL,
  `comment` longtext,
  `grade_percent` decimal(5,2) DEFAULT NULL,
  `marking_period_id` varchar(10) NOT NULL,
  `grade_letter` varchar(5) DEFAULT NULL,
  `weighted_gp` decimal(10,3) DEFAULT NULL,
  `unweighted_gp` decimal(10,3) DEFAULT NULL,
  `gp_scale` decimal(10,3) DEFAULT NULL,
  `gpa_cal` varchar(2) DEFAULT NULL,
  `credit_attempted` decimal(10,3) DEFAULT NULL,
  `credit_earned` decimal(10,3) DEFAULT NULL,
  `credit_category` varchar(10) DEFAULT NULL,
  `course_code` varchar(100) DEFAULT NULL,
  `course_title` text,
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_report_card_grades_ind1` USING BTREE (`school_id`),
  KEY `student_report_card_grades_ind2` USING BTREE (`student_id`),
  KEY `student_report_card_grades_ind3` USING BTREE (`course_period_id`),
  KEY `student_report_card_grades_ind4` USING BTREE (`marking_period_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `system_preference`
--

CREATE TABLE `system_preference` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `school_id` int(8) NOT NULL,
  `full_day_minute` int(8) DEFAULT NULL,
  `half_day_minute` int(8) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `system_preference`
--

INSERT INTO `system_preference` VALUES
(1, 1, 5, 2, '2015-07-28 11:26:33', NULL);

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

--
-- Table structure for table `system_preference_misc`
--

CREATE TABLE `system_preference_misc` (
  `fail_count` decimal(5,0) NOT NULL DEFAULT '3',
  `activity_days` decimal(5,0) NOT NULL DEFAULT '30',
  `system_maintenance_switch` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `teacher_reassignment`
--

CREATE TABLE `teacher_reassignment` (
  `course_period_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `assign_date` date NOT NULL,
  `modified_date` date NOT NULL,
  `pre_teacher_id` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  `updated` enum('Y','N') NOT NULL DEFAULT 'N',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Stand-in structure for view `transcript_grades`
--
CREATE TABLE `transcript_grades` (
`school_id` int(8)
,`school_name` varchar(100)
,`mp_source` varchar(7)
,`mp_id` int(11)
,`mp_name` varchar(50)
,`syear` decimal(10,0)
,`posted` date
,`student_id` decimal(10,0)
,`gradelevel` varchar(100)
,`grade_letter` varchar(5)
,`gp_value` decimal(10,3)
,`weighting` decimal(10,3)
,`gp_scale` decimal(10,3)
,`credit_attempted` decimal(10,3)
,`credit_earned` decimal(10,3)
,`credit_category` varchar(10)
,`course_period_id` decimal(10,0)
,`course_name` text
,`course_short_name` varchar(25)
,`gpa_cal` varchar(2)
,`weighted_gpa` decimal(10,2)
,`unweighted_gpa` decimal(10,2)
,`gpa` decimal(10,2)
,`class_rank` decimal(10,0)
,`sort_order` decimal(10,0)
);
-- --------------------------------------------------------

--
-- Table structure for table `user_profiles`
--

CREATE TABLE `user_profiles` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `profile` varchar(30) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `user_profiles`
--

INSERT INTO `user_profiles` VALUES
(0, 'admin', 'Super Administrator', '2015-07-28 00:26:33', NULL),
(1, 'admin', 'Administrator', '2015-07-28 00:26:33', NULL),
(2, 'teacher', 'Teacher', '2015-07-28 00:26:33', NULL),
(3, 'student', 'Student', '2015-07-28 00:26:33', NULL),
(4, 'parent', 'Parent', '2015-07-28 00:26:33', NULL),
(5, 'admin', 'Admin Asst', '2015-07-28 00:26:33', NULL);

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

--
-- Structure for view `course_details`
--
DROP TABLE IF EXISTS `course_details`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `course_details` AS select `cp`.`school_id` AS `school_id`,`cp`.`syear` AS `syear`,`cp`.`marking_period_id` AS `marking_period_id`,`c`.`subject_id` AS `subject_id`,`cp`.`course_id` AS `course_id`,`cp`.`course_period_id` AS `course_period_id`,`cp`.`teacher_id` AS `teacher_id`,`cp`.`secondary_teacher_id` AS `secondary_teacher_id`,`c`.`title` AS `course_title`,`cp`.`title` AS `cp_title`,`cp`.`grade_scale_id` AS `grade_scale_id`,`cp`.`mp` AS `mp`,`cp`.`credits` AS `credits`,`cp`.`begin_date` AS `begin_date`,`cp`.`end_date` AS `end_date` from (`course_periods` `cp` join `courses` `c`) where (`cp`.`course_id` = `c`.`course_id`);

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

--
-- Structure for view `enroll_grade`
--
DROP TABLE IF EXISTS `enroll_grade`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `enroll_grade` AS select `e`.`id` AS `id`,`e`.`syear` AS `syear`,`e`.`school_id` AS `school_id`,`e`.`student_id` AS `student_id`,`e`.`start_date` AS `start_date`,`e`.`end_date` AS `end_date`,`sg`.`short_name` AS `short_name`,`sg`.`title` AS `title` from (`student_enrollment` `e` join `school_gradelevels` `sg`) where (`e`.`grade_id` = `sg`.`id`);

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

--
-- Structure for view `marking_periods`
--
DROP TABLE IF EXISTS `marking_periods`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `marking_periods` AS select `q`.`marking_period_id` AS `marking_period_id`,'openSIS' AS `mp_source`,`q`.`syear` AS `syear`,`q`.`school_id` AS `school_id`,'quarter' AS `mp_type`,`q`.`title` AS `title`,`q`.`short_name` AS `short_name`,`q`.`sort_order` AS `sort_order`,`q`.`semester_id` AS `parent_id`,`s`.`year_id` AS `grandparent_id`,`q`.`start_date` AS `start_date`,`q`.`end_date` AS `end_date`,`q`.`post_start_date` AS `post_start_date`,`q`.`post_end_date` AS `post_end_date`,`q`.`does_grades` AS `does_grades`,`q`.`does_exam` AS `does_exam`,`q`.`does_comments` AS `does_comments` from (`school_quarters` `q` join `school_semesters` `s` on((`q`.`semester_id` = `s`.`marking_period_id`))) union select `school_semesters`.`marking_period_id` AS `marking_period_id`,'openSIS' AS `mp_source`,`school_semesters`.`syear` AS `syear`,`school_semesters`.`school_id` AS `school_id`,'semester' AS `mp_type`,`school_semesters`.`title` AS `title`,`school_semesters`.`short_name` AS `short_name`,`school_semesters`.`sort_order` AS `sort_order`,`school_semesters`.`year_id` AS `parent_id`,-(1) AS `grandparent_id`,`school_semesters`.`start_date` AS `start_date`,`school_semesters`.`end_date` AS `end_date`,`school_semesters`.`post_start_date` AS `post_start_date`,`school_semesters`.`post_end_date` AS `post_end_date`,`school_semesters`.`does_grades` AS `does_grades`,`school_semesters`.`does_exam` AS `does_exam`,`school_semesters`.`does_comments` AS `does_comments` from `school_semesters` union select `school_years`.`marking_period_id` AS `marking_period_id`,'openSIS' AS `mp_source`,`school_years`.`syear` AS `syear`,`school_years`.`school_id` AS `school_id`,'year' AS `mp_type`,`school_years`.`title` AS `title`,`school_years`.`short_name` AS `short_name`,`school_years`.`sort_order` AS `sort_order`,-(1) AS `parent_id`,-(1) AS `grandparent_id`,`school_years`.`start_date` AS `start_date`,`school_years`.`end_date` AS `end_date`,`school_years`.`post_start_date` AS `post_start_date`,`school_years`.`post_end_date` AS `post_end_date`,`school_years`.`does_grades` AS `does_grades`,`school_years`.`does_exam` AS `does_exam`,`school_years`.`does_comments` AS `does_comments` from `school_years` union select `history_marking_periods`.`marking_period_id` AS `marking_period_id`,'History' AS `mp_source`,`history_marking_periods`.`syear` AS `syear`,`history_marking_periods`.`school_id` AS `school_id`,`history_marking_periods`.`mp_type` AS `mp_type`,`history_marking_periods`.`name` AS `title`,NULL AS `short_name`,NULL AS `sort_order`,`history_marking_periods`.`parent_id` AS `parent_id`,-(1) AS `grandparent_id`,NULL AS `start_date`,`history_marking_periods`.`post_end_date` AS `end_date`,NULL AS `post_start_date`,`history_marking_periods`.`post_end_date` AS `post_end_date`,'Y' AS `does_grades`,NULL AS `does_exam`,NULL AS `does_comments` from `history_marking_periods`;

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

--
-- Structure for view `transcript_grades`
--
DROP TABLE IF EXISTS `transcript_grades`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `transcript_grades` AS select `s`.`id` AS `school_id`,if((`mp`.`mp_source` = 'history'),(select `history_school`.`school_name` from `history_school` where ((`history_school`.`student_id` = `rcg`.`student_id`) and (`history_school`.`marking_period_id` = `mp`.`marking_period_id`))),`s`.`title`) AS `school_name`,`mp`.`mp_source` AS `mp_source`,`mp`.`marking_period_id` AS `mp_id`,`mp`.`title` AS `mp_name`,`mp`.`syear` AS `syear`,`mp`.`end_date` AS `posted`,`rcg`.`student_id` AS `student_id`,`sgc`.`grade_level_short` AS `gradelevel`,`rcg`.`grade_letter` AS `grade_letter`,`rcg`.`unweighted_gp` AS `gp_value`,`rcg`.`weighted_gp` AS `weighting`,`rcg`.`gp_scale` AS `gp_scale`,`rcg`.`credit_attempted` AS `credit_attempted`,`rcg`.`credit_earned` AS `credit_earned`,`rcg`.`credit_category` AS `credit_category`,`rcg`.`course_period_id` AS `course_period_id`,`rcg`.`course_title` AS `course_name`,(select `courses`.`short_name` from (`course_periods` join `courses`) where ((`course_periods`.`course_id` = `courses`.`course_id`) and (`course_periods`.`course_period_id` = `rcg`.`course_period_id`))) AS `course_short_name`,`rcg`.`gpa_cal` AS `gpa_cal`,`sgc`.`weighted_gpa` AS `weighted_gpa`,`sgc`.`unweighted_gpa` AS `unweighted_gpa`,`sgc`.`gpa` AS `gpa`,`sgc`.`class_rank` AS `class_rank`,`mp`.`sort_order` AS `sort_order` from (((`student_report_card_grades` `rcg` join `marking_periods` `mp` on(((`mp`.`marking_period_id` = `rcg`.`marking_period_id`) and (`mp`.`mp_type` in ('year','semester','quarter'))))) join `student_gpa_calculated` `sgc` on(((`sgc`.`student_id` = `rcg`.`student_id`) and (`sgc`.`marking_period_id` = `rcg`.`marking_period_id`)))) join `schools` `s` on((`s`.`id` = `mp`.`school_id`)));
--
-- Triggers `student_report_card_grades`
--
DROP TRIGGER IF EXISTS `td_student_report_card_grades`;
DELIMITER //
CREATE TRIGGER `td_student_report_card_grades` AFTER DELETE ON `student_report_card_grades`
 FOR EACH ROW SELECT CALC_GPA_MP(OLD.student_id, OLD.marking_period_id) INTO @return$$
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ti_student_report_card_grades`;
DELIMITER //
CREATE TRIGGER `ti_student_report_card_grades` AFTER INSERT ON `student_report_card_grades`
 FOR EACH ROW SELECT CALC_GPA_MP(NEW.student_id, NEW.marking_period_id) INTO @return$$
//
DELIMITER ;
DROP TRIGGER IF EXISTS `tu_student_report_card_grades`;
DELIMITER //
CREATE TRIGGER `tu_student_report_card_grades` AFTER UPDATE ON `student_report_card_grades`
 FOR EACH ROW SELECT CALC_GPA_MP(NEW.student_id, NEW.marking_period_id) INTO @return$$
//
DELIMITER ;
/*!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 */;

Cancel