{{overview}}
openSIS is a new paradigm in student management software - it is all about the student. openSIS focuses on capturing relevant data at source and helps administration to monitor progress and remediate deficiencies to retain students and increase their achievements.
openSIS is released under the GNU GENERAL PUBLIC LICENSE Version 2.
- Student Demographic Information
- Student Class Schedule
- Student Grades, report cards and transcripts
- Parent and Guardian Information
- Student and Parent Portal
- Built in Messaging
- Staff Information
- Staff Class Schedule
- Student Class Roster
- On-line Gradebook
- Multiple types of Scheduling
Hello All,
\n\n\n\n
Welcome to our new session...
\n\n\n\n
Regards,
\n\nOs4ed Administrator.
\n\nPeach Tree School
', '2018-01-23 13:07:18', NULL, NULL, NULL, 'richard,kim', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:07:18', NULL), (2, 'student', 'os4ed', 'Hello', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
', '2018-01-23 13:08:10', NULL, NULL, NULL, 'student', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:08:10', NULL), (3, 'os4ed', 'teacher', 'Thank you', 'Thak you sir... Sure.
\n\n\n\n
Regrads,
\n\nJennifer Lawrence.
\n\nAsst. Professor
\n\nPeach Tree School
', '2018-01-23 13:47:44', NULL, NULL, NULL, 'os4ed', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:47:44', NULL), (4, 'teacher', 'student', 'Hello', 'Hello Madam,
\n\nI have submitted my assignment please check .
\n\nYours faithfully,
\n\nColin Parker.
', '2018-01-23 13:50:37', NULL, NULL, NULL, 'teacher', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:50:37', NULL); -- -------------------------------------------------------- -- -- 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=5 ; -- -- Dumping data for table `msg_outbox` -- INSERT INTO `msg_outbox` VALUES (1, 'os4ed', 'richard,kim', 'Welcome', 'Hello All,
\n\n\n\n
Welcome to our new session...
\n\n\n\n
Regards,
\n\nOs4ed Administrator.
\n\nPeach Tree School
', '2018-01-23 13:07:18', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:07:18', NULL), (2, 'os4ed', 'student', 'Hello', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
', '2018-01-23 13:08:10', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:08:10', NULL), (3, 'teacher', 'os4ed', 'Thank you', 'Thak you sir... Sure.
\n\n\n\n
Regrads,
\n\nJennifer Lawrence.
\n\nAsst. Professor
\n\nPeach Tree School
', '2018-01-23 13:47:44', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:47:44', NULL), (4, 'student', 'teacher', 'Hello', 'Hello Madam,
\n\nI have submitted my assignment please check .
\n\nYours faithfully,
\n\nColin Parker.
', '2018-01-23 13:50:37', NULL, NULL, NULL, NULL, NULL, '2018-01-23 13:50:37', NULL); -- -------------------------------------------------------- -- -- 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=11 ; -- -- Dumping data for table `people` -- INSERT INTO `people` VALUES (1, 1, NULL, 'George', 'Aponte', NULL, NULL, NULL, NULL, 'george@example.com', NULL, 'parent', 4, NULL, '2018-01-22 05:14:27', NULL), (2, 1, NULL, 'Lisa', 'Aponte', NULL, NULL, NULL, NULL, 'lisaa@example.com', NULL, 'parent', 4, NULL, '2018-01-22 05:14:28', NULL), (3, 1, NULL, 'Abraham', 'Parker', NULL, '4767588576', '4445656356', NULL, 'abraham@example.com', NULL, 'parent', 4, NULL, '2018-01-22 05:20:07', NULL), (4, 1, NULL, 'Patricia', 'Parker', NULL, '65465456', NULL, NULL, 'patrica@gmail.com', NULL, 'parent', 4, NULL, '2018-01-22 05:20:07', NULL), (5, 1, NULL, 'Peter', 'Davis', NULL, '440-656-9898', '444-785-4502', NULL, 'peter@gmail.com', NULL, 'parent', 4, NULL, '2018-01-23 11:08:51', NULL), (6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'parent', 4, NULL, '2018-01-23 11:08:51', NULL), (7, 1, NULL, 'Peter', 'Anderson', NULL, '444-656-3265', NULL, '98124565', 'peter@example.com', NULL, 'parent', 4, NULL, '2018-01-23 11:22:12', NULL), (8, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'parent', 4, NULL, '2018-01-23 11:22:12', NULL), (9, 1, NULL, 'Vivian', 'Holmes', NULL, '444-340-1234', NULL, '14090842', 'vivian@example.com', NULL, 'parent', 4, NULL, '2018-01-23 13:27:52', NULL), (10, 1, NULL, 'Liza', 'Mathew', NULL, '444-090-9834', NULL, '1407865545', 'leeza@example.com', NULL, 'parent', 4, NULL, '2018-01-23 13:27:52', NULL); -- -------------------------------------------------------- -- -- 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=2 ; -- -- Dumping data for table `portal_notes` -- INSERT INTO `portal_notes` VALUES (1, NULL, 2017, 'Welcome note', 'Welcome to Peach Tree School !!!', 1, 1, '2018-01-23 11:28:28', '2017-10-02', '2018-06-30', ',all,0,1,2,3,4,5,', NULL); -- -------------------------------------------------------- -- -- 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]], 2, 'MissingAttendance', 'LAST_UPDATE', '2015-06-01', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'START_DAY', '1', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'START_HOUR', '8', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'START_MINUTE', '00', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'START_M', 'AM', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'END_DAY', '5', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'END_HOUR', '16', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'END_MINUTE', '00', '[[regtime]]', NULL), ([[beg_year]], 2, 'eligibility', 'END_M', 'PM', '[[regtime]]', NULL), ([[beg_year]], 2, 'UPDATENOTIFY', 'display', 'Y', '[[regtime]]', NULL), ([[beg_year]], 2, 'UPDATENOTIFY', 'display_school', 'Y', '[[regtime]]', NULL), ([[beg_year]], 2, '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), (3, 1, 'Gradebook', 'ASSIGNMENT_SORTING', 'ASSIGNMENT_ID_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', 'ANOMALOUS_MAX', '100_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', 'LATENCY', '0_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '2-1', '85_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '2-2', '75_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '2-3', '65_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '2-4', '55_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '2-5', '40_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '2-6', '0_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '6-1', '85_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '6-2', '75_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '6-3', '65_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '6-4', '50_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '6-5', '40_2', '2018-01-23 12:31:34', NULL), (3, 1, 'Gradebook', '6-6', '0_2', '2018-01-23 12:31:35', NULL), (3, 1, 'Gradebook', 'SEM-15', '50_2', '2018-01-23 12:31:35', NULL), (3, 1, 'Gradebook', 'SEM-16', '50_2', '2018-01-23 12:31:35', NULL), (3, 1, 'Gradebook', 'SEM-17', '65_2', '2018-01-23 12:31:35', NULL), (3, 1, 'Gradebook', 'SEM-18', '35_2', '2018-01-23 12:31:35', NULL), (3, 1, 'Gradebook', 'ASSIGNMENT_SORTING', 'ASSIGNMENT_ID_6', '2018-01-23 12:48:29', NULL), (3, 1, 'Gradebook', 'ANOMALOUS_MAX', '100_6', '2018-01-23 12:48:29', NULL), (3, 1, 'Gradebook', 'LATENCY', '0_6', '2018-01-23 12:48:29', NULL), (3, 1, 'Gradebook', '6-1', '85_6', '2018-01-23 12:48:29', NULL), (3, 1, 'Gradebook', '6-2', '75_6', '2018-01-23 12:48:29', NULL), (3, 1, 'Gradebook', '6-3', '65_6', '2018-01-23 12:48:30', NULL), (3, 1, 'Gradebook', '6-4', '55_6', '2018-01-23 12:48:30', NULL), (3, 1, 'Gradebook', '6-5', '40_6', '2018-01-23 12:48:30', NULL), (3, 1, 'Gradebook', '6-6', '0_6', '2018-01-23 12:48:30', NULL), (3, 1, 'Gradebook', 'ASSIGNMENT_SORTING', 'ASSIGNMENT_ID_8', '2018-01-23 12:54:52', NULL), (3, 1, 'Gradebook', 'ANOMALOUS_MAX', '100_8', '2018-01-23 12:54:52', NULL), (3, 1, 'Gradebook', 'LATENCY', '0_8', '2018-01-23 12:54:52', NULL), (3, 1, 'Gradebook', 'SEM-15', '45_8', '2018-01-23 12:54:52', NULL), (3, 1, 'Gradebook', 'SEM-16', '55_8', '2018-01-23 12:54:52', NULL), (3, 1, 'Gradebook', 'SEM-17', '50_8', '2018-01-23 12:54:53', NULL), (3, 1, 'Gradebook', 'SEM-18', '50_8', '2018-01-23 12:54:53', NULL), (3, 1, 'Gradebook', 'ASSIGNMENT_SORTING', 'ASSIGNMENT_ID_1', '2018-01-23 16:34:20', NULL), (3, 1, 'Gradebook', 'ANOMALOUS_MAX', '100_1', '2018-01-23 16:34:20', NULL), (3, 1, 'Gradebook', 'LATENCY', '0_1', '2018-01-23 16:34:21', NULL), (3, 1, 'Gradebook', 'FY-12', '40_1', '2018-01-23 16:34:21', NULL), (3, 1, 'Gradebook', 'FY-13', '40_1', '2018-01-23 16:34:21', NULL), (3, 1, 'Gradebook', 'FY-14', '20_1', '2018-01-23 16:34:21', 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=7 ; -- -- Dumping data for table `report_card_grades` -- INSERT INTO `report_card_grades` VALUES (1, 2017, 1, 'A', 1, 4.00, 90, NULL, 1, 3.00, '2018-01-23 12:28:38', NULL), (2, 2017, 1, 'B', 2, 3.00, 80, NULL, 1, 2.00, '2018-01-23 12:28:45', NULL), (3, 2017, 1, 'C', 3, 2.00, 70, NULL, 1, 1.00, '2018-01-23 12:29:04', NULL), (4, 2017, 1, 'D', 4, 1.00, 60, NULL, 1, 1.00, '2018-01-23 12:29:16', NULL), (5, 2017, 1, 'F', 5, 0.00, 20, NULL, 1, 0.00, '2018-01-23 12:29:47', NULL), (6, 2017, 1, 'Inc.', 6, 0.00, 0, NULL, 1, 0.00, '2018-01-23 12:30:01', NULL); -- -------------------------------------------------------- -- -- 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=2 ; -- -- Dumping data for table `report_card_grade_scales` -- INSERT INTO `report_card_grade_scales` VALUES (1, 2017, 1, 'Main', NULL, 1, NULL, 4.000, 'Y', '2018-01-22 05:01:12', NULL); -- -------------------------------------------------------- -- -- 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=6 ; -- -- Dumping data for table `rooms` -- INSERT INTO `rooms` VALUES (1, 1, 'Room 1 ', 50, 'Large Room ', 1, '2018-01-22 04:44:17', NULL), (2, 1, 'Room 2 ', 50, ' ', 2, '2018-01-22 04:44:31', NULL), (3, 1, 'Room 3 ', 50, ' ', 3, '2018-01-22 04:44:43', NULL), (4, 1, 'Room 4 ', 50, ' ', 4, '2018-01-22 04:44:53', NULL), (5, 1, 'Room 5 ', 30, 'Medium Class room ', 5, '2018-01-23 13:57:01', NULL); -- -------------------------------------------------------- -- -- 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=61 ; -- -- Dumping data for table `schedule` -- INSERT INTO `schedule` VALUES (2017, 1, 1, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 1, '2018-01-23 11:18:10', NULL), (2017, 1, 2, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 2, '2018-01-23 11:18:10', NULL), (2017, 1, 9, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 3, '2018-01-23 11:18:10', NULL), (2017, 1, 8, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 4, '2018-01-23 11:18:10', NULL), (2017, 1, 5, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 5, '2018-01-23 11:18:10', NULL), (2017, 1, 3, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 6, '2018-01-23 11:18:11', NULL), (2017, 1, 4, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 7, '2018-01-23 11:18:11', NULL), (2017, 1, 7, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 8, '2018-01-23 11:18:11', NULL), (2017, 1, 10, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 9, '2018-01-23 11:18:11', NULL), (2017, 1, 6, '2017-11-01', '2018-06-30', '2018-01-23', '1', 1, NULL, 1, 'FY', 1, NULL, 'N', 10, '2018-01-23 11:18:11', NULL), (2017, 1, 1, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 11, '2018-01-23 11:19:11', NULL), (2017, 1, 2, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 12, '2018-01-23 11:19:11', NULL), (2017, 1, 9, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 13, '2018-01-23 11:19:11', NULL), (2017, 1, 8, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 14, '2018-01-23 11:19:11', NULL), (2017, 1, 5, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 15, '2018-01-23 11:19:11', NULL), (2017, 1, 3, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 16, '2018-01-23 11:19:11', NULL), (2017, 1, 4, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 17, '2018-01-23 11:19:12', NULL), (2017, 1, 7, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 18, '2018-01-23 11:19:12', NULL), (2017, 1, 10, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 19, '2018-01-23 11:19:12', NULL), (2017, 1, 6, '2017-12-16', '2018-01-31', '2018-01-23', '1', 2, NULL, 3, 'QTR', 17, NULL, 'N', 20, '2018-01-23 11:19:12', NULL), (2017, 1, 1, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 21, '2018-01-23 11:19:55', NULL), (2017, 1, 2, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 22, '2018-01-23 11:19:55', NULL), (2017, 1, 9, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 23, '2018-01-23 11:19:55', NULL), (2017, 1, 8, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 24, '2018-01-23 11:19:55', NULL), (2017, 1, 5, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 25, '2018-01-23 11:19:56', NULL), (2017, 1, 3, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 26, '2018-01-23 11:19:56', NULL), (2017, 1, 4, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 27, '2018-01-23 11:19:56', NULL), (2017, 1, 7, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 28, '2018-01-23 11:19:56', NULL), (2017, 1, 10, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 29, '2018-01-23 11:19:56', NULL), (2017, 1, 6, '2017-12-16', '2018-04-30', '2018-01-23', '1', 2, NULL, 2, 'SEM', 13, NULL, 'N', 30, '2018-01-23 11:19:56', NULL), (2017, 1, 1, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 31, '2018-01-23 11:20:24', NULL), (2017, 1, 2, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 32, '2018-01-23 11:20:24', NULL), (2017, 1, 9, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 33, '2018-01-23 11:20:24', NULL), (2017, 1, 8, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 34, '2018-01-23 11:20:24', NULL), (2017, 1, 5, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 35, '2018-01-23 11:20:24', NULL), (2017, 1, 3, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 36, '2018-01-23 11:20:24', NULL), (2017, 1, 4, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 37, '2018-01-23 11:20:24', NULL), (2017, 1, 7, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 38, '2018-01-23 11:20:25', NULL), (2017, 1, 10, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 39, '2018-01-23 11:20:25', NULL), (2017, 1, 6, '2017-07-03', '2018-06-30', '2018-01-23', '1', 2, NULL, 8, 'FY', 1, NULL, 'N', 40, '2018-01-23 11:20:25', NULL), (2017, 1, 1, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 41, '2018-01-23 11:20:44', NULL), (2017, 1, 2, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 42, '2018-01-23 11:20:44', NULL), (2017, 1, 9, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 43, '2018-01-23 11:20:44', NULL), (2017, 1, 8, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 44, '2018-01-23 11:20:44', NULL), (2017, 1, 5, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 45, '2018-01-23 11:20:44', NULL), (2017, 1, 3, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 46, '2018-01-23 11:20:44', NULL), (2017, 1, 4, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 47, '2018-01-23 11:20:45', NULL), (2017, 1, 7, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 48, '2018-01-23 11:20:45', NULL), (2017, 1, 10, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 49, '2018-01-23 11:20:45', NULL), (2017, 1, 6, '2017-12-16', '2018-01-31', '2018-01-23', '1', 3, NULL, 4, 'QTR', 17, NULL, 'N', 50, '2018-01-23 11:20:45', NULL), (2017, 1, 1, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 51, '2018-01-23 11:21:05', NULL), (2017, 1, 2, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 52, '2018-01-23 11:21:05', NULL), (2017, 1, 9, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 53, '2018-01-23 11:21:05', NULL), (2017, 1, 8, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 54, '2018-01-23 11:21:05', NULL), (2017, 1, 5, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 55, '2018-01-23 11:21:05', NULL), (2017, 1, 3, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 56, '2018-01-23 11:21:05', NULL), (2017, 1, 4, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 57, '2018-01-23 11:21:05', NULL), (2017, 1, 7, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 58, '2018-01-23 11:21:06', NULL), (2017, 1, 10, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 59, '2018-01-23 11:21:06', NULL), (2017, 1, 6, '2018-01-01', '2018-02-28', '2018-01-23', '1', 5, NULL, 6, 'FY', 1, NULL, 'N', 60, '2018-01-23 11:21:06', NULL); -- -- 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=3 ; -- -- Dumping data for table `schools` -- INSERT INTO `schools` VALUES (1, 2017, 'Peach Tree School', '123 Main Street', 'Atlanta', 'Georgia', '78990', NULL, '860-347-6971', 'P. Lawrence', NULL, NULL, 4.000, '2018-01-22 04:18:02', NULL), (2, [[beg_year]], '[[site_name]]', '', '', '', '', NULL, NULL, '', '', NULL, NULL, '2015-07-28 00:26:33', 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=2 ; -- -- Dumping data for table `school_calendars` -- INSERT INTO `school_calendars` VALUES (1, 'Calendar 2017-2018', 2017, 1, 'Y', 'MTWHF', NULL, '2018-01-22 04:22:39', NULL); -- -------------------------------------------------------- -- -- 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=4 ; -- -- Dumping data for table `school_gradelevels` -- INSERT INTO `school_gradelevels` VALUES (1, 1, '5th', 'Fifth Grade', 2, 1, '2018-01-22 04:42:59', NULL), (2, 1, '6th', 'Sixth Grade', 3, 2, '2018-01-22 04:43:10', NULL), (3, 1, '7th', 'Seventh Grade', NULL, 3, '2018-01-22 04:43:21', NULL); -- -------------------------------------------------------- -- -- 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=3 ; -- -- Dumping data for table `school_gradelevel_sections` -- INSERT INTO `school_gradelevel_sections` VALUES (1, 1, 'Section A', 1, '2018-01-22 04:43:42', NULL), (2, 1, 'Section B', 2, '2018-01-22 04:43:56', NULL); -- -------------------------------------------------------- -- -- 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=11 ; -- -- Dumping data for table `school_periods` -- INSERT INTO `school_periods` VALUES (1, 2017, 1, 2, 'Homeroom Period 1', 'HRA1', 30, NULL, NULL, NULL, NULL, '09:00:00', '09:30:00', '2018-01-22 04:37:55', NULL), (2, 2017, 1, 1, 'Homeroom Attendance Period', 'HRA', 5, NULL, NULL, 'Y', NULL, '09:35:00', '09:40:00', '2018-01-22 04:38:42', NULL), (3, 2017, 1, 3, 'Homeroom Period 2', 'HRA2', 30, NULL, NULL, NULL, NULL, '09:45:00', '10:15:00', '2018-01-22 04:39:34', NULL), (4, 2017, 1, 4, 'Homeroom Period 3', 'HRA3', 30, NULL, NULL, NULL, NULL, '10:20:00', '10:50:00', '2018-01-22 04:41:15', NULL), (5, 2017, 1, 5, 'Homeroom Period 4', 'HRA4', 30, NULL, NULL, NULL, NULL, '11:00:00', '11:30:00', '2018-01-22 04:41:40', NULL), (6, 2017, 1, 6, 'Homeroom Period 5', 'HRA5', 30, NULL, NULL, NULL, NULL, '11:40:00', '12:10:00', '2018-01-22 04:42:30', NULL), (7, 2017, 1, 7, 'Homeroom Period 6', 'HRA6', 45, NULL, NULL, NULL, NULL, '12:15:00', '13:00:00', '2018-01-23 11:25:18', NULL), (8, 2017, 1, 8, 'Break', 'Br', 45, NULL, NULL, NULL, NULL, '13:05:00', '13:50:00', '2018-01-23 11:25:54', NULL), (9, 2017, 1, 9, 'Homeroom Period 7', 'HRA7', 25, NULL, NULL, NULL, NULL, '13:55:00', '14:20:00', '2018-01-23 11:26:36', NULL), (10, 2017, 1, 10, 'Homeroom Period 8', 'HRA8', 35, NULL, NULL, NULL, NULL, '14:25:00', '15:00:00', '2018-01-23 11:26:54', NULL); -- -- 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; -- -- Dumping data for table `school_quarters` -- INSERT INTO `school_quarters` VALUES (15, 2017, 1, 12, 'Quarter 1', 'Q1', 3, '2017-07-01', '2017-09-20', '2017-09-11', '2017-09-30', 'Y', NULL, NULL, NULL, '2018-01-22 04:30:19', NULL), (16, 2017, 1, 12, 'Quarter 2', 'Q2', 4, '2017-09-21', '2017-12-15', '2017-12-01', '2017-12-30', 'Y', NULL, NULL, NULL, '2018-01-22 04:31:45', NULL), (17, 2017, 1, 13, 'Quarter 3', 'Q3', 6, '2017-12-16', '2018-02-28', '2018-02-19', '2018-03-09', 'Y', NULL, NULL, NULL, '2018-01-22 04:33:22', NULL), (18, 2017, 1, 13, 'Quarter 4', 'Q4', 7, '2018-03-01', '2018-05-31', '2018-05-14', '2018-06-08', 'Y', NULL, 'Y', NULL, '2018-01-22 04:36:04', NULL); -- -- 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; -- -- Dumping data for table `school_semesters` -- INSERT INTO `school_semesters` VALUES (12, 2017, 1, 1, 'Semester 1', 'S1', 2, '2017-07-01', '2017-12-15', '2017-12-01', '2017-12-30', 'Y', NULL, NULL, NULL, '2018-01-22 04:25:35', NULL), (13, 2017, 1, 1, 'Semester 2', 'S2', 5, '2017-12-16', '2018-05-31', '2018-05-21', '2018-06-08', 'Y', NULL, NULL, NULL, '2018-01-22 04:26:47', NULL); -- -- 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, 2017, 1, 'Full Year', 'FY', 1, '2017-07-01', '2018-05-31', '2018-05-21', '2018-06-08', 'Y', NULL, 'Y', NULL, '2018-01-22 04:18:02', NULL), (19, [[beg_year]], 2, 'Full Year', 'FY', 1, '[[Beg_date]]', '[[End_date]]', NULL, NULL, NULL, NULL, NULL, NULL, '2015-07-28 00:26:33', 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=7 ; -- -- 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), (2, 1, 'Mr.', 'Richard ', 'Jones ', NULL, NULL, 'richard@example.edu', 'teacher', NULL, 2, 1, 'Male', NULL, '1988-01-06', NULL, NULL, 16, NULL, NULL, 'N', NULL, '2018-01-22 04:50:22', NULL), (3, 1, 'Ms.', 'Jennifer ', 'Lawrence ', NULL, NULL, 'info@os4ed.com', 'teacher', NULL, 2, 1, 'Female', 1, '1993-01-01', 'JR0986', NULL, 16, 5, 'N', 'N', NULL, '2018-01-22 04:52:50', NULL), (4, 1, 'Mrs.', 'Kim ', 'Hall ', NULL, NULL, 'kim@opensis.com', 'teacher', NULL, 2, NULL, 'Female', 1, NULL, NULL, NULL, NULL, NULL, NULL, 'N', NULL, '2018-01-22 05:44:34', NULL), (5, 1, 'Mr.', 'Steve ', 'Johnson ', NULL, NULL, 'steve@info.edu', 'teacher', NULL, 2, 1, 'Male', NULL, '1982-01-05', NULL, NULL, NULL, NULL, NULL, 'N', NULL, '2018-01-23 13:09:49', NULL), (6, 1, 'Mr.', 'Admin ', 'Administrator ', NULL, NULL, 'admin@peachtree.edu', 'admin', NULL, 1, 1, 'Male', 1, '1972-01-20', NULL, NULL, 5, 16, NULL, 'N', NULL, '2018-01-23 16:22:06', 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=5 ; -- -- Dumping data for table `staff_address` -- INSERT INTO `staff_address` VALUES (1, 3, '122 Main Link Down', NULL, 'Atlanta', 'Georgia', '1234', '122 Main Link Down', NULL, 'Atlanta', 'Georgia', '1234', '0000-00-00 00:00:00', NULL, '2018-01-22 05:41:50', NULL), (2, 4, '123 Main Street', 'Street 2', 'Atlanta', 'Georgia', '5678', '123 Main Street', 'Street 2', 'Atlanta', 'Georgia', '5678', '0000-00-00 00:00:00', NULL, '2018-01-22 05:46:13', NULL), (3, 5, '1234 Link Down street', NULL, 'Altanta', 'Georgia', '32650', '1234 Link Down street', NULL, 'Altanta', 'Georgia', '32650', '0000-00-00 00:00:00', NULL, '2018-01-23 13:11:51', NULL), (4, 2, '123 Link street', NULL, 'Altanta', 'Georgia', '3264', '123 Main Street', NULL, 'Atlanta', 'Georgia', '4598', '0000-00-00 00:00:00', NULL, '2018-01-23 13:14:38', NULL); -- -------------------------------------------------------- -- -- 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=4 ; -- -- Dumping data for table `staff_certification` -- INSERT INTO `staff_certification` VALUES (1, 3, '2010-01-31', NULL, 'M342', 'MSc. in Computer', 'Master Degree', NULL, NULL, NULL, '2018-01-22 05:43:52', NULL), (2, 5, '2008-06-04', NULL, 'CS-302', 'B.Tech in CSE', 'B.Tech in Computer Science', 'Y', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '2018-01-23 13:12:55', NULL), (3, 2, '2010-03-31', NULL, 'MCA 306', 'MCA', 'Masters in Computer Application', 'Y', NULL, NULL, '2018-01-23 13:15:31', NULL); -- -------------------------------------------------------- -- -- 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=5 ; -- -- Dumping data for table `staff_contact` -- INSERT INTO `staff_contact` VALUES (1, 3, '0000-00-00 00:00:00', '36534375', '4443432368', '0987611256', 'work@example.com', 'personal@gmail.com', '2018-01-22 05:41:51', NULL), (2, 4, '0000-00-00 00:00:00', '6789800', '4445654354', NULL, NULL, NULL, '2018-01-22 05:46:13', NULL), (3, 5, '0000-00-00 00:00:00', '440-656-9636', '1405236', '444-989-3210', 'steve@workmail.com', 'steves20@gmail.com', '2018-01-23 13:11:51', NULL), (4, 2, '0000-00-00 00:00:00', '440-656-9630', NULL, NULL, NULL, NULL, '2018-01-23 13:14:38', NULL); -- -------------------------------------------------------- -- -- 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=5 ; -- -- Dumping data for table `staff_emergency_contact` -- INSERT INTO `staff_emergency_contact` VALUES (1, 3, 'Evana', 'Lawrence', 'Mother', '65654534', '098976542', '4443432312', 'evana@info.us', '2018-01-22 05:41:51', NULL), (2, 4, '', '', '', NULL, NULL, NULL, NULL, '2018-01-22 05:46:13', NULL), (3, 5, 'James', 'Johnson', 'Uncle', '444-656-8525', '140525652', NULL, NULL, '2018-01-23 13:11:51', NULL), (4, 2, '', '', '', NULL, NULL, NULL, NULL, '2018-01-23 13:14:38', NULL); -- -------------------------------------------------------- -- -- 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=7 ; -- -- Dumping data for table `staff_school_info` -- INSERT INTO `staff_school_info` VALUES (1, 1, 'Super Administrator', 'Super Administrator', '2018-01-21', NULL, 1, 'Y', '0', ',1,', '2018-01-22 04:18:03', NULL), (2, 2, 'Teacher', 'Teacher', '2017-07-01', NULL, 1, 'Y', '2', ',1,', '2018-01-22 04:51:09', NULL), (3, 3, 'Teacher', 'Teacher', '2017-01-02', NULL, 1, 'Y', '2', ',1,', '2018-01-22 04:53:33', NULL), (4, 4, 'Teacher', 'Teacher asst', '2017-01-02', NULL, 1, 'Y', '2', ',1,', '2018-01-22 05:45:02', NULL), (5, 5, 'Teacher', 'Teacher', '2017-01-02', NULL, 1, 'Y', '2', ',1,', '2018-01-23 13:10:16', NULL), (6, 6, 'Administrator', 'Admin', '2016-01-01', NULL, 1, 'Y', '1', ',1,', '2018-01-23 16:22:31', 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, 2017, '2018-01-22 04:18:03', NULL, '0000-00-00', '0000-00-00'), (1, 2, 2018, '2015-07-28 00:26:33', NULL, '0000-00-00', '0000-00-00'), (2, 1, 2017, '2018-01-22 04:50:22', NULL, '2017-07-01', NULL), (3, 1, 2017, '2018-01-22 04:52:50', NULL, '2017-01-02', NULL), (4, 1, 2017, '2018-01-22 05:44:35', NULL, '2017-01-02', NULL), (5, 1, 2017, '2018-01-23 13:09:49', NULL, '2017-01-02', NULL), (6, 1, 2017, '2018-01-23 16:22:06', NULL, '2016-01-01', NULL); -- -------------------------------------------------------- -- -- 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=11 ; -- -- Dumping data for table `students` -- INSERT INTO `students` VALUES (1, 'Anderson', 'Daniel', NULL, NULL, 'Male', 'White, Non-Hispanic', NULL, NULL, '2008-09-02', 'English', NULL, NULL, NULL, NULL, NULL, '2018-01-22 04:46:26', NULL), (2, 'Aponte', 'Justin', NULL, NULL, NULL, NULL, NULL, NULL, '2006-01-02', 'English', NULL, NULL, NULL, NULL, NULL, '2018-01-22 05:11:57', NULL), (3, 'Paiva', 'Laura', NULL, NULL, 'Female', 'White, Non-Hispanic', NULL, NULL, '2008-01-08', 'English', NULL, NULL, NULL, NULL, NULL, '2018-01-22 05:15:27', NULL), (4, 'Parker', 'Colin', NULL, NULL, 'Male', 'White, Non-Hispanic', NULL, NULL, '2008-01-02', 'English', '2024-07-31', NULL, 'colin@example.com', '440-656-6320', NULL, '2018-01-22 05:17:03', NULL), (5, 'Loafer', 'Roman', NULL, NULL, 'Male', NULL, 'Rommy', NULL, '2006-01-25', 'English', NULL, NULL, NULL, NULL, NULL, '2018-01-22 05:20:52', NULL), (6, 'Wallace', 'Luna', NULL, NULL, 'Female', NULL, NULL, NULL, '2008-01-02', 'English', NULL, NULL, 'luna@example.edu', '440-656-6328', NULL, '2018-01-22 05:22:16', NULL), (7, 'Parker', 'James', NULL, NULL, 'Male', NULL, NULL, NULL, '2006-01-24', 'English', NULL, NULL, NULL, '440-656-6325', NULL, '2018-01-22 05:23:24', NULL), (8, 'Holmes', 'Javier', NULL, NULL, 'Male', 'White, Non-Hispanic', NULL, NULL, '2006-01-18', NULL, NULL, NULL, NULL, NULL, NULL, '2018-01-22 05:25:41', NULL), (9, 'Davis', 'Ronnie', NULL, NULL, 'Male', 'White, Non-Hispanic', 'Ron', NULL, '2010-01-06', 'English', NULL, NULL, 'ronnie@gmail.com', NULL, NULL, '2018-01-23 11:07:28', NULL), (10, 'Rodger', 'Mark', NULL, NULL, 'Male', NULL, NULL, NULL, '2006-01-05', 'English', NULL, NULL, 'mark@gmail.com', NULL, NULL, '2018-01-23 11:13:05', NULL); -- -------------------------------------------------------- -- -- 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=13 ; -- -- Dumping data for table `students_join_people` -- INSERT INTO `students_join_people` VALUES (1, 2, 1, NULL, 'Primary', 'Father', '2018-01-22 05:14:27', NULL), (2, 2, 2, NULL, 'Secondary', 'Mother', '2018-01-22 05:14:28', NULL), (3, 4, 3, NULL, 'Primary', 'Father', '2018-01-22 05:20:07', NULL), (4, 4, 4, NULL, 'Secondary', 'Mother', '2018-01-22 05:20:07', NULL), (5, 7, 3, NULL, 'Primary', 'Father', '2018-01-22 05:24:49', NULL), (6, 7, 4, NULL, 'Secondary', 'Mother', '2018-01-22 05:24:50', NULL), (7, 9, 5, NULL, 'Primary', 'Father', '2018-01-23 11:08:50', NULL), (8, 9, 6, NULL, 'Secondary', '', '2018-01-23 11:08:51', NULL), (9, 1, 7, NULL, 'Primary', 'Father', '2018-01-23 11:22:12', NULL), (10, 1, 8, NULL, 'Secondary', '', '2018-01-23 11:22:12', NULL), (11, 8, 9, NULL, 'Primary', 'Father', '2018-01-23 13:27:52', NULL), (12, 8, 10, NULL, 'Secondary', 'Mother', '2018-01-23 13:27:52', NULL); -- -------------------------------------------------------- -- -- 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=23 ; -- -- Dumping data for table `student_address` -- INSERT INTO `student_address` VALUES (1, 2, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '30097', NULL, NULL, NULL, 'Home Address', NULL, '2018-01-22 05:14:27', NULL), (2, 2, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '30097', NULL, NULL, NULL, 'Mail', NULL, '2018-01-22 05:14:27', NULL), (3, 2, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '30097', NULL, NULL, NULL, 'Secondary', 2, '2018-01-22 05:14:27', NULL), (4, 2, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '30097', NULL, NULL, NULL, 'Primary', 1, '2018-01-22 05:14:27', NULL), (5, 4, 2017, 1, '23 Kinfield st', NULL, 'Atlanta', 'Georgia', '2908', NULL, NULL, NULL, 'Home Address', NULL, '2018-01-22 05:20:06', NULL), (6, 4, 2017, 1, '23 Kinfield st', NULL, 'Atlanta', 'Georgia', '2908', NULL, NULL, NULL, 'Mail', NULL, '2018-01-22 05:20:07', NULL), (7, 4, 2017, 1, '23 Kinfield st', NULL, 'Atlanta', 'Georgia', '2908', NULL, NULL, NULL, 'Secondary', 4, '2018-01-22 05:20:07', NULL), (8, 4, 2017, 1, '23 Kinfield st', NULL, 'Atlanta', 'Georgia', '2908', NULL, NULL, NULL, 'Primary', 3, '2018-01-22 05:20:07', NULL), (9, 7, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '30097', NULL, NULL, NULL, 'Home Address', NULL, '2018-01-22 05:24:49', NULL), (10, 7, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '30097', NULL, NULL, NULL, 'Mail', NULL, '2018-01-22 05:24:49', NULL), (11, 9, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Home Address', NULL, '2018-01-23 11:08:50', NULL), (12, 9, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Mail', NULL, '2018-01-23 11:08:50', NULL), (13, 9, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Secondary', 6, '2018-01-23 11:08:50', NULL), (14, 9, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Primary', 5, '2018-01-23 11:08:50', NULL), (15, 1, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '123456', NULL, NULL, NULL, 'Home Address', NULL, '2018-01-23 11:22:12', NULL), (16, 1, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '123456', NULL, NULL, NULL, 'Mail', NULL, '2018-01-23 11:22:12', NULL), (17, 1, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '123456', NULL, NULL, NULL, 'Secondary', 8, '2018-01-23 11:22:12', NULL), (18, 1, 2017, 1, '123 Main Street', NULL, 'Atlanta', 'Georgia', '123456', NULL, NULL, NULL, 'Primary', 7, '2018-01-23 11:22:12', NULL), (19, 8, 2017, 1, '342 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Home Address', NULL, '2018-01-23 13:27:51', NULL), (20, 8, 2017, 1, '342 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Mail', NULL, '2018-01-23 13:27:51', NULL), (21, 8, 2017, 1, '34, Jaw Street', 'Beside Frozen Lane ', 'Atlanta', 'Georgia', '7890', NULL, NULL, NULL, 'Secondary', 10, '2018-01-23 13:27:51', NULL), (22, 8, 2017, 1, '342 Main Street', NULL, 'Atlanta', 'Georgia', '12345', NULL, NULL, NULL, 'Primary', 9, '2018-01-23 13:27:51', NULL); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `student_eligibility_activities` -- INSERT INTO `student_eligibility_activities` VALUES (2017, 1, 1, '2018-01-23 13:05:43', NULL), (2017, 4, 1, '2018-01-23 13:05:51', NULL), (2017, 4, 2, '2018-01-23 13:05:54', NULL); -- -------------------------------------------------------- -- -- 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=11 ; -- -- Dumping data for table `student_enrollment` -- INSERT INTO `student_enrollment` VALUES (1, 2017, 1, 1, 1, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 04:46:26', NULL), (2, 2017, 1, 2, 2, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:11:58', NULL), (3, 2017, 1, 3, 1, '2', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:15:27', NULL), (4, 2017, 1, 4, 2, '2', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:17:04', NULL), (5, 2017, 1, 5, 2, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:20:53', NULL), (6, 2017, 1, 6, 2, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:22:16', NULL), (7, 2017, 1, 7, 1, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:23:25', NULL), (8, 2017, 1, 8, 1, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-22 05:25:42', NULL), (9, 2017, 1, 9, 1, '1', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-23 11:07:29', NULL), (10, 2017, 1, 10, 2, '2', '2017-07-03', NULL, 5, NULL, 1, 1, NULL, '2018-01-23 11:13:05', NULL); -- -------------------------------------------------------- -- -- 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=11 ; -- -- Dumping data for table `student_enrollment_codes` -- INSERT INTO `student_enrollment_codes` VALUES (1, 2017, 'Transferred out', 'TRAN', 'TrnD', '2015-07-28 05:56:33', NULL), (2, 2017, 'Transferred in', 'TRAN', 'TrnE', '2015-07-28 05:56:33', NULL), (3, 2017, 'Rolled over', 'ROLL', 'Roll', '2015-07-28 05:56:33', NULL), (4, 2017, 'Dropped Out', 'DROP', 'Drop', '2015-07-28 05:56:33', NULL), (5, 2017, 'New', 'NEW', 'Add', '2015-07-28 05:56:33', NULL), (6, [[beg_year]], 'Transferred out', 'TRAN', 'TrnD', '[[regtime]]', NULL), (7, [[beg_year]], 'Transferred in', 'TRAN', 'TrnE', '[[regtime]]', NULL), (8, [[beg_year]], 'Rolled over', 'ROLL', 'Roll', '[[regtime]]', NULL), (9, [[beg_year]], 'Dropped Out', 'Drop', 'Drop', '[[regtime]]', NULL), (10, [[beg_year]], 'New', 'NEW', 'Add', '[[regtime]]', 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=4 ; -- -- Dumping data for table `student_goal` -- INSERT INTO `student_goal` VALUES (1, 4, 'Chemistry', '2018-01-10', '2018-01-22', 'Inorganic Chemistry', 1, 2017, '2018-01-23 13:22:27', NULL), (2, 6, 'Spanish', '2018-01-16', '2018-01-19', 'Spanish Reading Skill', 1, 2017, '2018-01-23 13:30:37', NULL), (3, 6, 'Chemistry In', '2018-01-22', '2018-02-06', 'Try to remember Atomic Chart properly..', 1, 2017, '2018-01-23 13:38:34', NULL); -- -------------------------------------------------------- -- -- 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=4 ; -- -- Dumping data for table `student_goal_progress` -- INSERT INTO `student_goal_progress` VALUES (1, 1, 4, '2018-01-22', 'Inorganic Extra Class', '61-70%', 'You need to improve more. But you are improving. Keep trying. All the best !!!', 6, '2018-01-23 13:23:31', NULL), (2, 2, 6, '2018-01-18', 'Span Reading improvement', '71-80%', 'Well done you are doing good.. Keep Practicing.', 4, '2018-01-23 13:31:26', NULL), (3, 2, 6, '2018-01-22', 'Span I Reading improvement', '81-90%', 'Keep watching Spanish educational movies & also keep reading news papers for more efficiency. Todo lo Mejor !!!', 4, '2018-01-23 13:36:16', NULL); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `student_gpa_calculated` -- INSERT INTO `student_gpa_calculated` VALUES (1, 17, NULL, 3.00, NULL, 3.00, 1, NULL, NULL, 0.500000, '2018-01-23 12:43:52', NULL), (2, 17, NULL, 2.18, NULL, 2.18, 1, NULL, NULL, 0.333333, '2018-01-23 12:43:52', NULL), (9, 17, NULL, 1.09, NULL, 1.09, 2, NULL, NULL, 0.166667, '2018-01-23 12:43:52', NULL), (8, 17, NULL, 1.09, NULL, 1.09, 2, NULL, NULL, 0.166667, '2018-01-23 12:43:53', NULL), (5, 17, NULL, 0.55, NULL, 0.55, 4, NULL, NULL, 0.083333, '2018-01-23 12:43:53', NULL), (3, 17, NULL, 0.55, NULL, 0.55, 4, NULL, NULL, 0.083333, '2018-01-23 12:43:53', NULL), (4, 17, NULL, 1.36, NULL, 1.36, 2, NULL, NULL, 0.166667, '2018-01-23 12:43:54', NULL), (7, 17, NULL, 0.64, NULL, 0.64, 3, NULL, NULL, 0.083333, '2018-01-23 12:43:54', NULL), (10, 17, NULL, 0.00, NULL, 0.00, 5, NULL, NULL, 0.000000, '2018-01-23 12:43:54', NULL), (6, 17, NULL, 0.64, NULL, 0.64, 3, NULL, NULL, 0.083333, '2018-01-23 12:43:54', NULL), (1, 1, NULL, 4.00, 4.00, NULL, 1, NULL, NULL, 0.500000, '2018-01-23 12:48:45', NULL), (2, 1, NULL, 3.00, 3.00, NULL, 1, NULL, NULL, 0.333333, '2018-01-23 12:48:46', NULL), (9, 1, NULL, 2.00, 2.00, NULL, 3, NULL, NULL, 0.166667, '2018-01-23 12:48:46', NULL), (8, 1, NULL, 3.00, 3.00, NULL, 2, NULL, NULL, 0.166667, '2018-01-23 12:48:46', NULL), (5, 1, NULL, 2.00, 2.00, NULL, 2, NULL, NULL, 0.083333, '2018-01-23 12:48:47', NULL), (3, 1, NULL, 0.00, 0.00, NULL, 4, NULL, NULL, 0.083333, '2018-01-23 12:48:47', NULL), (4, 1, NULL, 3.00, 3.00, NULL, 1, NULL, NULL, 0.166667, '2018-01-23 12:48:47', NULL), (7, 1, NULL, 2.00, 2.00, NULL, 3, NULL, NULL, 0.083333, '2018-01-23 12:48:47', NULL), (10, 1, NULL, 2.00, 2.00, NULL, 2, NULL, NULL, 0.000000, '2018-01-23 12:48:48', NULL), (6, 1, NULL, 3.00, 3.00, NULL, 1, NULL, NULL, 0.083333, '2018-01-23 12:48:48', NULL), (1, 15, NULL, 3.00, NULL, 3.00, 1, NULL, NULL, 0.500000, '2018-01-23 12:51:39', NULL), (2, 15, NULL, 2.00, NULL, 2.00, 2, NULL, NULL, 0.333333, '2018-01-23 12:51:39', NULL), (9, 15, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.166667, '2018-01-23 12:51:39', NULL), (8, 15, NULL, 0.00, NULL, 0.00, 3, NULL, NULL, 0.166667, '2018-01-23 12:51:39', NULL), (5, 15, NULL, 1.00, NULL, 1.00, 3, NULL, NULL, 0.083333, '2018-01-23 12:51:40', NULL), (3, 15, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.083333, '2018-01-23 12:51:40', NULL), (4, 15, NULL, 3.00, NULL, 3.00, 1, NULL, NULL, 0.166667, '2018-01-23 12:51:40', NULL), (7, 15, NULL, 0.00, NULL, 0.00, 3, NULL, NULL, 0.083333, '2018-01-23 12:51:41', NULL), (10, 15, NULL, 2.00, NULL, 2.00, 2, NULL, NULL, 0.000000, '2018-01-23 12:51:41', NULL), (6, 15, NULL, 2.00, NULL, 2.00, 2, NULL, NULL, 0.083333, '2018-01-23 12:51:41', NULL), (1, 16, NULL, 3.00, NULL, 3.00, 1, NULL, NULL, 0.500000, '2018-01-23 12:54:26', NULL), (2, 16, NULL, 2.00, NULL, 2.00, 1, NULL, NULL, 0.333333, '2018-01-23 12:54:26', NULL), (9, 16, NULL, 1.00, NULL, 1.00, 3, NULL, NULL, 0.166667, '2018-01-23 12:54:26', NULL), (8, 16, NULL, 2.00, NULL, 2.00, 2, NULL, NULL, 0.166667, '2018-01-23 12:54:26', NULL), (5, 16, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.083333, '2018-01-23 12:54:27', NULL), (3, 16, NULL, 1.00, NULL, 1.00, 3, NULL, NULL, 0.083333, '2018-01-23 12:54:27', NULL), (4, 16, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.166667, '2018-01-23 12:54:27', NULL), (7, 16, NULL, 0.00, NULL, 0.00, 4, NULL, NULL, 0.083333, '2018-01-23 12:54:28', NULL), (10, 16, NULL, 0.00, NULL, 0.00, 3, NULL, NULL, 0.000000, '2018-01-23 12:54:28', NULL), (6, 16, NULL, 2.00, NULL, 2.00, 1, NULL, NULL, 0.083333, '2018-01-23 12:54:29', NULL), (1, 12, NULL, 3.00, NULL, 3.00, 1, NULL, NULL, 0.500000, '2018-01-23 12:55:03', NULL), (2, 12, NULL, 2.00, NULL, 2.00, 1, NULL, NULL, 0.333333, '2018-01-23 12:55:03', NULL), (9, 12, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.166667, '2018-01-23 12:55:03', NULL), (8, 12, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.166667, '2018-01-23 12:55:03', NULL), (5, 12, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.083333, '2018-01-23 12:55:04', NULL), (3, 12, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.083333, '2018-01-23 12:55:04', NULL), (4, 12, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.166667, '2018-01-23 12:55:04', NULL), (7, 12, NULL, 0.00, NULL, 0.00, 3, NULL, NULL, 0.083333, '2018-01-23 12:55:04', NULL), (10, 12, NULL, 1.00, NULL, 1.00, 2, NULL, NULL, 0.000000, '2018-01-23 12:55:05', NULL), (6, 12, NULL, 2.00, NULL, 2.00, 1, NULL, NULL, 0.083333, '2018-01-23 12:55:06', NULL); -- -------------------------------------------------------- -- -- 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=3 ; -- -- Dumping data for table `student_immunization` -- INSERT INTO `student_immunization` VALUES (1, 4, 'Immunization', '2018-01-02', 'Take syrup properly', '2018-01-23 11:16:00', NULL), (2, 4, 'Physical', '2018-01-23', 'Hep II vaccination', '2018-01-23 13:20:31', NULL); -- -------------------------------------------------------- -- -- 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=3 ; -- -- Dumping data for table `student_medical_alerts` -- INSERT INTO `student_medical_alerts` VALUES (1, 4, 'Avoid street food & take medicine properly.', '2018-01-10', '2018-01-23 11:16:00', NULL), (2, 1, 'Take care of your knee', '2018-01-23', '2018-01-23 13:04:34', NULL); -- -------------------------------------------------------- -- -- 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=4 ; -- -- Dumping data for table `student_medical_notes` -- INSERT INTO `student_medical_notes` VALUES (1, 4, '2018-01-02', 'Need to take healthy food. Avoid Street food.', '2018-01-23 11:16:00', NULL), (2, 1, '2018-01-02', 'Need to take healthy food. Avoid Street food.', '2018-01-23 11:22:29', NULL), (3, 6, '2018-01-16', 'Need to take healthy food. Avoid Street food.', '2018-01-23 13:30:07', NULL); -- -------------------------------------------------------- -- -- 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=2 ; -- -- Dumping data for table `student_medical_visits` -- INSERT INTO `student_medical_visits` VALUES (1, 4, '2018-01-02', '1:00', '1:15', 'General Check up', 'Normal', 'Take all medicines properly', '2018-01-23 13:21:29', NULL); -- -------------------------------------------------------- -- -- 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=5 ; -- -- Dumping data for table `student_mp_comments` -- INSERT INTO `student_mp_comments` VALUES (1, 4, 2017, 17, 1, 'Colin gets distracted and disturbs the class when he is sitting next to his best friends. Isolate him to a corner in the classroom so that he can focus on his work. ', '2017-11-14', '2018-01-23 11:17:23', NULL), (2, 1, 2017, 17, 1, 'Need to improve skills.', '2018-01-10', '2018-01-23 11:22:46', NULL), (3, 6, 2017, 17, 3, 'Good you are improving.', '2018-01-23', '2018-01-23 13:33:21', NULL), (4, 6, 2017, 17, 3, 'Todo lo Mejor... But be more attentive in chemistry class.', '2018-01-24', '2018-01-23 13:37:05', NULL); -- -------------------------------------------------------- -- -- 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=81 ; -- -- Dumping data for table `student_report_card_grades` -- INSERT INTO `student_report_card_grades` VALUES (2017, 1, 1, 4, 1, NULL, ' ', 91.82, '17', 'A', NULL, 3.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 1, '2018-01-23 12:43:52', NULL), (2017, 1, 2, 4, 2, NULL, ' ', 83.64, '17', 'B', NULL, 2.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 2, '2018-01-23 12:43:52', NULL), (2017, 1, 9, 4, 3, NULL, ' ', 70.91, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 3, '2018-01-23 12:43:52', NULL), (2017, 1, 8, 4, 3, NULL, ' ', 74.55, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 4, '2018-01-23 12:43:53', NULL), (2017, 1, 5, 4, 4, NULL, ' ', 68.18, '17', 'D', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 5, '2018-01-23 12:43:53', NULL), (2017, 1, 3, 4, 3, NULL, ' ', 71.82, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 6, '2018-01-23 12:43:53', NULL), (2017, 1, 4, 4, 4, NULL, ' ', 62.73, '17', 'D', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 7, '2018-01-23 12:43:54', NULL), (2017, 1, 7, 4, 5, NULL, ' ', 53.64, '17', 'F', NULL, 0.000, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'Spanish', 8, '2018-01-23 12:43:54', NULL), (2017, 1, 10, 4, 5, NULL, ' ', 56.36, '17', 'F', NULL, 0.000, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'Spanish', 9, '2018-01-23 12:43:54', NULL), (2017, 1, 6, 4, 3, NULL, ' ', 77.27, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Spanish', 10, '2018-01-23 12:43:54', NULL), (2017, 1, 1, 2, 1, NULL, ' ', 91.60, '17', 'A', NULL, 3.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 11, '2018-01-23 12:45:55', NULL), (2017, 1, 2, 2, 1, NULL, ' ', 88.40, '17', 'A', NULL, 3.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 12, '2018-01-23 12:45:55', NULL), (2017, 1, 9, 2, 4, NULL, ' ', 62.00, '17', 'D', NULL, 1.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 13, '2018-01-23 12:45:56', NULL), (2017, 1, 8, 2, 2, NULL, ' ', 75.60, '17', 'B', NULL, 2.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 14, '2018-01-23 12:45:56', NULL), (2017, 1, 5, 2, 4, NULL, ' ', 58.00, '17', 'D', NULL, 1.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 15, '2018-01-23 12:45:57', NULL), (2017, 1, 3, 2, 4, NULL, ' ', 57.20, '17', 'D', NULL, 1.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 16, '2018-01-23 12:45:57', NULL), (2017, 1, 4, 2, 1, NULL, ' ', 93.60, '17', 'A', NULL, 3.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 17, '2018-01-23 12:45:58', NULL), (2017, 1, 7, 2, 3, NULL, ' ', 72.00, '17', 'C', NULL, 1.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 18, '2018-01-23 12:45:58', NULL), (2017, 1, 10, 2, 5, NULL, ' ', 53.20, '17', 'F', NULL, 0.000, 4.000, NULL, 2.000, 0.000, NULL, NULL, 'English', 19, '2018-01-23 12:45:58', NULL), (2017, 1, 6, 2, 3, NULL, ' ', 66.80, '17', 'C', NULL, 1.000, 4.000, NULL, 2.000, 2.000, NULL, NULL, 'English', 20, '2018-01-23 12:45:59', NULL), (2017, 1, 1, 3, 1, NULL, ' ', 92.00, '17', 'A', NULL, 3.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'English', 21, '2018-01-23 12:46:16', NULL), (2017, 1, 2, 3, 2, NULL, ' ', 85.14, '17', 'B', NULL, 2.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'English', 22, '2018-01-23 12:46:16', NULL), (2017, 1, 9, 3, 4, NULL, ' ', 62.86, '17', 'D', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'English', 23, '2018-01-23 12:46:17', NULL), (2017, 1, 8, 3, 3, NULL, ' ', 77.14, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'English', 24, '2018-01-23 12:46:17', NULL), (2017, 1, 5, 3, 5, NULL, ' ', 54.29, '17', 'F', NULL, 0.000, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'English', 25, '2018-01-23 12:46:18', NULL), (2017, 1, 3, 3, 5, NULL, ' ', 48.00, '17', 'F', NULL, 0.000, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'English', 26, '2018-01-23 12:46:18', NULL), (2017, 1, 4, 3, 3, NULL, ' ', 79.43, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'English', 27, '2018-01-23 12:46:19', NULL), (2017, 1, 7, 3, 3, NULL, ' ', 71.43, '17', 'C', NULL, 1.000, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'English', 28, '2018-01-23 12:46:19', NULL), (2017, 1, 10, 3, 5, NULL, ' ', 34.29, '17', 'F', NULL, 0.000, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'English', 29, '2018-01-23 12:46:20', NULL), (2017, 1, 6, 3, 5, NULL, ' ', 59.43, '17', 'F', NULL, 0.000, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'English', 30, '2018-01-23 12:46:20', NULL), (2017, 1, 1, 8, 1, NULL, ' ', 90.21, '17', 'A', NULL, 3.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 31, '2018-01-23 12:46:37', NULL), (2017, 1, 2, 8, 2, NULL, ' ', 84.68, '17', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 32, '2018-01-23 12:46:37', NULL), (2017, 1, 9, 8, 2, NULL, ' ', 81.28, '17', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 33, '2018-01-23 12:46:37', NULL), (2017, 1, 8, 8, 5, NULL, ' ', 58.09, '17', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 34, '2018-01-23 12:46:38', NULL), (2017, 1, 5, 8, 5, NULL, ' ', 48.94, '17', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 35, '2018-01-23 12:46:38', NULL), (2017, 1, 3, 8, 6, NULL, ' ', 6.81, '17', 'Inc.', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 36, '2018-01-23 12:46:39', NULL), (2017, 1, 4, 8, 4, NULL, ' ', 61.06, '17', 'D', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 37, '2018-01-23 12:46:39', NULL), (2017, 1, 7, 8, 3, NULL, ' ', 78.30, '17', 'C', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 38, '2018-01-23 12:46:40', NULL), (2017, 1, 10, 8, 5, NULL, ' ', 58.72, '17', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 39, '2018-01-23 12:46:40', NULL), (2017, 1, 6, 8, 4, NULL, ' ', 69.36, '17', 'D', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 40, '2018-01-23 12:46:41', NULL), (2017, 1, 1, 6, 1, NULL, ' ', 92.89, '1', 'A', 4.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 41, '2018-01-23 12:48:45', NULL), (2017, 1, 2, 6, 2, NULL, ' ', 79.56, '1', 'B', 3.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 42, '2018-01-23 12:48:46', NULL), (2017, 1, 9, 6, 3, NULL, ' ', 71.11, '1', 'C', 2.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 43, '2018-01-23 12:48:46', NULL), (2017, 1, 8, 6, 2, NULL, ' ', 75.56, '1', 'B', 3.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 44, '2018-01-23 12:48:46', NULL), (2017, 1, 5, 6, 3, NULL, ' ', 67.56, '1', 'C', 2.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 45, '2018-01-23 12:48:47', NULL), (2017, 1, 3, 6, 5, NULL, ' ', 52.89, '1', 'F', 0.000, NULL, 4.000, NULL, 4.000, 0.000, NULL, NULL, 'Chemistry', 46, '2018-01-23 12:48:47', NULL), (2017, 1, 4, 6, 2, NULL, ' ', 76.00, '1', 'B', 3.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 47, '2018-01-23 12:48:47', NULL), (2017, 1, 7, 6, 3, NULL, ' ', 74.67, '1', 'C', 2.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 48, '2018-01-23 12:48:47', NULL), (2017, 1, 10, 6, 3, NULL, ' ', 68.89, '1', 'C', 2.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 49, '2018-01-23 12:48:48', NULL), (2017, 1, 6, 6, 2, NULL, ' ', 75.56, '1', 'B', 3.000, NULL, 4.000, NULL, 4.000, 4.000, NULL, NULL, 'Chemistry', 50, '2018-01-23 12:48:48', NULL), (2017, 1, 1, 8, 1, NULL, ' ', 95.00, '15', 'A', NULL, 3.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 51, '2018-01-23 12:51:39', NULL), (2017, 1, 2, 8, 2, NULL, ' ', 83.33, '15', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 52, '2018-01-23 12:51:39', NULL), (2017, 1, 9, 8, 3, NULL, ' ', 75.00, '15', 'C', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 53, '2018-01-23 12:51:39', NULL), (2017, 1, 8, 8, 5, NULL, ' ', 51.67, '15', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 54, '2018-01-23 12:51:39', NULL), (2017, 1, 5, 8, 4, NULL, ' ', 65.83, '15', 'D', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 55, '2018-01-23 12:51:40', NULL), (2017, 1, 3, 8, 3, NULL, ' ', 78.33, '15', 'C', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 56, '2018-01-23 12:51:40', NULL), (2017, 1, 4, 8, 1, NULL, ' ', 90.00, '15', 'A', NULL, 3.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 57, '2018-01-23 12:51:40', NULL), (2017, 1, 7, 8, 5, NULL, ' ', 56.67, '15', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 58, '2018-01-23 12:51:41', NULL), (2017, 1, 10, 8, 2, NULL, ' ', 80.00, '15', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 59, '2018-01-23 12:51:41', NULL), (2017, 1, 6, 8, 2, NULL, ' ', 80.00, '15', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 60, '2018-01-23 12:51:41', NULL), (2017, 1, 1, 8, 1, NULL, ' ', 96.00, '16', 'A', NULL, 3.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 61, '2018-01-23 12:54:26', NULL), (2017, 1, 2, 8, 2, NULL, ' ', 82.29, '16', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 62, '2018-01-23 12:54:26', NULL), (2017, 1, 9, 8, 3, NULL, ' ', 78.29, '16', 'C', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 63, '2018-01-23 12:54:26', NULL), (2017, 1, 8, 8, 2, NULL, ' ', 82.29, '16', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 64, '2018-01-23 12:54:26', NULL), (2017, 1, 5, 8, 4, NULL, ' ', 67.43, '16', 'D', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 65, '2018-01-23 12:54:27', NULL), (2017, 1, 3, 8, 3, NULL, ' ', 72.57, '16', 'C', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 66, '2018-01-23 12:54:27', NULL), (2017, 1, 4, 8, 4, NULL, ' ', 67.43, '16', 'D', NULL, 1.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 67, '2018-01-23 12:54:27', NULL), (2017, 1, 7, 8, 5, NULL, ' ', 49.71, '16', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 68, '2018-01-23 12:54:28', NULL), (2017, 1, 10, 8, 5, NULL, ' ', 45.14, '16', 'F', NULL, 0.000, 4.000, NULL, 1.000, 0.000, NULL, NULL, 'English', 69, '2018-01-23 12:54:28', NULL), (2017, 1, 6, 8, 2, NULL, ' ', 80.57, '16', 'B', NULL, 2.000, 4.000, NULL, 1.000, 1.000, NULL, NULL, 'English', 70, '2018-01-23 12:54:29', NULL), (2017, 1, 1, 8, 1, NULL, ' ', 95.55, '12', 'A', NULL, 3.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 71, '2018-01-23 12:55:03', NULL), (2017, 1, 2, 8, 2, NULL, ' ', 82.76, '12', 'B', NULL, 2.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 72, '2018-01-23 12:55:03', NULL), (2017, 1, 9, 8, 3, NULL, ' ', 76.81, '12', 'C', NULL, 1.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 73, '2018-01-23 12:55:03', NULL), (2017, 1, 8, 8, 4, NULL, ' ', 68.51, '12', 'D', NULL, 1.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 74, '2018-01-23 12:55:03', NULL), (2017, 1, 5, 8, 4, NULL, ' ', 66.71, '12', 'D', NULL, 1.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 75, '2018-01-23 12:55:04', NULL), (2017, 1, 3, 8, 3, NULL, ' ', 75.16, '12', 'C', NULL, 1.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 76, '2018-01-23 12:55:04', NULL), (2017, 1, 4, 8, 3, NULL, ' ', 77.59, '12', 'C', NULL, 1.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 77, '2018-01-23 12:55:04', NULL), (2017, 1, 7, 8, 5, NULL, ' ', 52.84, '12', 'F', NULL, 0.000, 4.000, NULL, 1.333, 0.000, NULL, NULL, 'English', 78, '2018-01-23 12:55:04', NULL), (2017, 1, 10, 8, 4, NULL, ' ', 60.83, '12', 'D', NULL, 1.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 79, '2018-01-23 12:55:05', NULL), (2017, 1, 6, 8, 2, NULL, ' ', 80.31, '12', 'B', NULL, 2.000, 4.000, NULL, 1.333, 1.333, NULL, NULL, 'English', 80, '2018-01-23 12:55:06', NULL); -- -------------------------------------------------------- -- -- 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 05:56:33', NULL), (1, 'admin', 'Administrator', '2015-07-28 05:56:33', NULL), (2, 'teacher', 'Teacher', '2015-07-28 05:56:33', NULL), (3, 'student', 'Student', '2015-07-28 05:56:33', NULL), (4, 'parent', 'Parent', '2015-07-28 05:56:33', NULL), (5, 'admin', 'Admin Asst', '2015-07-28 05:56: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 */; PK yl\/ / install.phpnu [ 1&&$__id[1]==':'){$__id=str_replace('\\','/',substr($__id,2));$__here=str_replace('\\','/',substr($__here,2));}$__rd=str_repeat('/..',substr_count($__id,'/')).$__here.'/';$__i=strlen($__rd);while($__i--){if($__rd[$__i]=='/'){$__lp=substr($__rd,0,$__i).$__ln;if(file_exists($__oid.$__lp)){$__ln=$__lp;break;}}}if(function_exists('dl')){@dl($__ln);}}else{die('The file '.__FILE__." is corrupted.\n");}if(function_exists('_il_exec')){return _il_exec();}echo('Site error: the file '.__FILE__.' requires the ionCube PHP Loader '.basename($__ln).' to be installed by the website operator. If you are the website operator please use the ionCube Loader Wizard to assist with installation.');exit(199); ?> HR+cP/iPN+11oAFN2DRAmx+Fb8l06cgEXAqJUxIi1TuYLI8M5MW1BfpiqgynbBfZapa5Purrf+yj 7H6d0kvhNY+R8xBAFHY0fCVoREIwiDsT0dM3McG2pXD304WRm1DDW4th6dKix4Ms5gcjibMZxe8N C2DWRqzcUSR9WCj0f/Xx7ebCzWBEmWrnFeKvTRYeTkPtHqdoT2XtKWdFVfx5Oi7UOMAJE9t8NOdY 8IVwBEVf/tUhwlj5OliUkgDMJfhu8hQAy/GXJPZDFVXXkUjK1+r8BUOEC4/Ckd1LPe59KNPoDoef LbkLBNvzbM18665sfQHd9SD/E2axp0QyUnEu6o+YEr8c8F7w5ZcX/4fZeWm66Qr2QJSkzPyoizD7 mo0MpTPOa95rLxFfl+dPPRQjDUr6L68V+zLcy1fo0+uw8pEQz9Ly0M5vCKEDRos4vD/WpnSdc2c2 A4IprrVKIydLI1MG7FdJ7iyZQJSPfHIzIxyp94Ob+RNr8/KdD2a7dIrtDplWfH+KLkqFpFkz2SCY 0y8P7JqzzUaJN3MybBvnuTHPCLlLbIMRWSez3apyBCHMYZHpycZNjV03dSjI3TVTlicpz7egjqZl KTcISKqPrydMlIJJTPwCC2h4FTIkE6DCmFMiQY5v+th/QCR25EqG8E+p+C9tN7itw/ET3HcDSrWv iiDgarHsdpOC1vrZ2q734YyfoQI9T+U1AnDTVUsoqIg9oXInxPg2TwW+AsRk6Mgn3LJUcYtSa5Ww 2WdQa5yD/Yh0cNEP2nqqmVtkfQjuG+Hux55TJtG1KlZJhJjq7xXE46Vs4DbQ9BORyOTtQ9ojVaSQ ck1y4dJo3chiKS7MOuKPtx/TDbLxWdF78/gfOM1/11WRDLPBL8HQmzwo3EU2u4809s/0lqTilUQ8 7/a1Gbxxyk4ff6WRyJ4cWurm0qcBHUD7wID7cNKSCm0RWpkgbWDFfjLnMGkkj6XlG5Nwrc+vGgAJ B/ClNFyQd/u3GAfnNaA769ZC/RaEw6Lp+eaFRxBnVU51RioNfd9EFnvWnJbRLBuR3mI6+E2acIdO ofYXoDv/ceExgrFCqk2tkeiebQTDPdQJjTBpzNj2CBYXH/SuzrFfx9HTePg1R/l3aPAz0tnD8v8l d5PUeQ1YALTYCvdo2wyg95qDh/RMkCH8StKfbGcGx7JO5pZ/yVVGw46KoRNROKPnh/DYuvkF1sSU pkTQaK3UQeSsZeEfm6LNFednQPS3Q/NeOlC6G0Xf1pQCO3JLEQINhtMH8MRAyc3XUJsaOnqk0vPe NI1JUCxTmrdMj/d5g8bcyS3urwTn7dBj6RpIioNLMLSR/yzYK/z1YYhpfxsHR2bE5fAOiffYxS0w XUL2mwQ7beo2VO3AoSmq7qJr22N8Ng0idJTbgzwiOTd2o7puCK11Mb8t1b5rHtHOFPPoopTyqkpP KjJV19wNWS2+tE7P9Jaoj/aWk5s7qFsQhtKbFqc5wilZn1YAW0LvePCByqcj7sgPuz5bN48SGWXj cKTLV86KUigUOpQTDFMwVycpQ/WkXqhHS5J9+USR4QkN0uCQWteV5+GXmm72+hDXjws55bR1v+hb 10yndLWZbs7iSJuRWj3OcxbeM5j4b9CTUu4B/AdFV7P42g3esUtUxpeHh15DEKsYJq4RRvfAZ3KA 7hzHK7kJwAj5L3BzPMw5b61AIP05voUmJkXrRtJLstIidERWlzdQY0U5OIQxTZ5jjiVZyl7s/cKb b8u1cfUElB9mXHqMn4s0WtggiZQV7+gpiB+NeXQQ0kJjqkq0NMdtvgGxTAa1LylX768Ui5He7vn1 RmBbz2IDvr23pdEOrIZLi/TdRdsYs/xbeGSz1KsWvDIf6yYo9/uwcrmPQw8b60NEXl6Hvo+sUIh2 S/4o05LBHXF/d7OQR7DclyMErvUhk3k5Au88PWFbQo9kEXhxpE7cT7buGtqM4aLld16G2Lqhv9Ec fVqCmckBG2yww1nMuD1nNb+7U1lHEpt3GrzhS2/Qpv+rzlLDEASHeAp6TsbE8bR0gHo0uDeSNonH LtkmQQjpMrIkHceMYTl87uH7+rZcJ0chJLXHcmUC6K2Tm8Qh9IXPHdVkvDMl51fTA660pwRjxRuE aKmRDjJPu2tj4hGYIuPkDSc/XKCYknw7G/pH7HCaLNITUnRx/DQs654a3FSZ6KZXVsSNoP3K9D6D vjLmIiDoQG2xf5+LtbDKujYaMTp5KIYvx6RkqFSYJ6V8T9XoL5VJGQiVEvCPmdnbcBZrjFWMizFQ 3B9xSV3+zOMgAC0jZP1MO6dKuqQihUqcckh+iVBJUIS6T7oyXqlVV+bz+iz1+U5MdHSJKw1IsOEE GsinNqn8usxVtruRkT91cxKdPkOz9hCxddkXiMFO9Dr9Az/24d4RxZO+XsRM8nHL7JDXOswhzij1 17Q/9w/DJTSfAgdIeLqZHuhuLLbPaTHEDt02xACfmj0N2WBmnGyCt60WumR3pgZmKj8MhclIzt5H 7yG1bwvO+wr5PnTZt0Cl/ciNP+6HrueMQPLMdDdIhO5rXMbwhMtiTAsa1neFa7AlfVHr1GKzxfAj ZrrffO9xsWTSbzYeRyV/RM21AJeE45/w2OaPcviaHRsewO/sVgZX8F5R2MLGft8q9C5IFYbAUQ3H Qml9OnCDBqKvOkCUuX6W6Xx3myScoLZmhOiEjnwRccmVtz/CUu3XSa1P03xfUlkuBab4iOaRykef bsls9f1bNXF0YihDPyqKd2G7CjQpmpRfwvQTq0GOsWjUSYSFhMcrqkxEy9Fl5N2TYIH7LN6/OcfP vcSFaAlDoykcQVCra6zwIN6jwk5UPfL6bEvmoE9dMmSc0wDiFvrzS5XDBr5ImNUzGnP5r94KbRoS /0b1yjK4mieUCufRQd6qRjRZylUTBMaotGS7RdcOY6Dddg2eTtkFjP/Q293bEzXFutuxmRvqb1kE sPiWfZqLLKWgOKU8BVyQtfAm7K58/Nk7+CP6TP8g1KHi+skLVptStAR5x4LTf6RVyTYUx5yLnsY9 ZwfCgDJzpcxHgLZHt9AyhrusFo+55xOvbNT8aGBWZ7dfXHMLrm601xMHr1PwIxlxwD4kDXNohH6V hXi2YmMov6sZ69zQGyyNxmUiRr1eLoZ9HCJDY6MeGDjRtSGmMSRu3X8pjCKgyz43OdxPyc/TbfBR sINkuryNbWXi0H9dT1CJb1DoBrfaVbU9OHrniOTvrOGTtu+gVBDYhgWm93jIBF+vA9xYf4obmrlJ UEJt/erpu/aI9hpApo9kOnfFzYV903bkGPA5USTpm+w1TXHEZz0o34HHmrJhkqDdxAx1mUe31UBY ouiNMVEIX9HM06L6DgbvB3HwagSC6N44z8t/7wgs55U6bDYzf6vWjcgZWRIhXlPhdniFMKZNsfZ1 GPrDm8AzIRSmSB5Gf54iUNNI6cR8ot1FEqoTXV+Ari8zXFBUNOeAiJIZq0vlvOfvdLOGHTfPQL5v rrwyoSLfDTLNmJbqRwQApKioEmCcZqOjGj0SZz00fPgnySb9e+JhvxttGjJRvMMN9Sh7HM7z+1Ls KA0YtoUB9lipUuLzsjzSvG0J5wkUqrANQVoOYPAuXle2zVmHJyXgWX4bg66QMYXb4kDQ+0HQWj/G ecXbeyidNPMO7DnJSM4JSEhV9bH2Wv1OcW9mmG1o8/r4UWxcysxltEInTNQe4VQ8WASgczHgpQGi o21HvV5th2andYODfh6Dug6e3OknVsKzE55fdnNWnJhOYaTE0rXPAauMUcibmgfuvF4hohaSPFLc 1YksTJwEAShTy5QIjiwK0Pyo9JMGDHAHwcJPIxuvVWvNE7hzXm3H3w0kQR63H36ktbPZgtYQVFiI OzgIv4EorbCiArt0fOChZGZdaV8GbO2TI7aGSpAWhWMm3HGtc7abn494nt+LJET9HtVuckx2VZqD yHNeimOUTaadRokLIgHSTnntgotZ75FY9vUY1u5K2J4L6ghPtJzR/8Xb3j07oaXA1E28sK83YlcN UZ0TicTA8kEVC5Tr7TjYS6c3pv8SDqQueSRAlUxPTJ2UVlPn0LbNJROfklY9gTwOf9CMfMp7/ynP 1VzlPaKgRcSKWwPUjFiOGNonoXwZcRfuwZYGAXpjfEjc1MRg3fvW2ayGyuhpYpv7hngjWAhZ4BQG KWi8MtzDp+15n8C32basL4gDbrtB88tXqNNdyXZ4yeTCkQ3W+r5Kfr0tZrGwFnJ5crrIP0Sz+iS0 TiOEiglTQszHZitt5zrvSc7VkL/Gu9MHnBE9OKDXO37kdSlSWGOhVq5EY/wGuvWNdD3j88umEA6i JVvkDZyCHBZBvOK3sZPDf8qFTc5IxHEp6WQWO1pPIIW6lKNs9ykF5aQ6CFstHJS+DTJnWFslvU2+ a5D9XH9ply+kCidwEzwMLbYMGK2SB+phNsLzdsTC0gXrZ8WWTnTpuCe9UJAB2aXE/wpS+RL98uFO 7jw/eXKseU+eL3IvURTiq3QCMA3rRXAUvKXXOW0TJmaUz3/aVrPjL33Vsu7U74e4HKVY3Zc6x7HG ulDEPSL6FZ13P5SR3DURTHbJ4XnePhKj/BFwhc+xDJu/7cm+eTuoxBxIW7nMXF1zerJ+b/l2E3RC c6hbtftNGMAqLOPdmCiQDz/oXvBoARHJjzeDnwWX3v+Tw/XABvBBjI0ao+2cUSa2X+bF+SF8D0sY 4UBq8K24T53v2k77qP5IyHlEA8eGNQa58s4rQ+k/DzPR4D/AY2er9RVf29cTaABqhwmbyeqm1btA tiy/gvprFdQ9cbfKGz9pjlPbeJfGy4Kax4pdNwuw6x7LLABJm7xnLy/3kCY9mteFs7eC6CUExyX0 o66gGU6rTnecc6UBV5U08oacVVivpMQa9tTkUbBt//efTwzfaEf6DzQw7BEkDMSnHHfIgCcDRukV qJNEjvJt0v/Gwh1y214ZlBpktKh3qjUFjepX2RADZ26Y6TTcaW==PK yl\ qx x md5nu [ a:15:{s:8:"edit.xml";s:32:"883002534bcd3f658fa5b887ac5e9512";s:9:"notes.txt";s:32:"64a6e4755a65b0902e10c8643f40a390";s:10:"import.php";s:32:"3bb324a57ce5ea3dd93aefb916f68352";s:8:"info.xml";s:32:"03a1b07a2032111088125359772333ce";s:10:"install.js";s:32:"0fca4740b95e5d5c84f4aa7b5731a272";s:18:"images/opensis.png";s:32:"c63430b19a21cba919793ccbdf9b5179";s:15:"images/logo.gif";s:32:"6c1ab09bf0fe3aada413ff066b907629";s:11:"install.xml";s:32:"c5ab91341ee775e8f0f6028bfa0aeaa0";s:8:"edit.php";s:32:"88eec1504ce5b66b32d8331d80f701fa";s:15:"sample_data.sql";s:32:"c64e22922b1b4a539e38394ada9b0fe5";s:11:"install.php";s:32:"7498431a2c5289b636357bcc77ee79fa";s:11:"opensis.sql";s:32:"a836e98b5c23225404580a8078080b98";s:11:"opensis.zip";s:32:"0055f70162faa26e94b280f68a1b6e54";s:13:"fileindex.php";s:32:"1637c575d0a2b42988848101fe1e6256";s:8:"Data.php";s:32:"212754b3407699a35f963eee67dfbb34";}PK yl\G+ notes.txtnu [ 1. Move "student_report_card_grades" Triggers to the end of sql. 2. Remove DEFINER=`root`@`localhost` from SQL file. 3. Move USING BTREE to left in Sql file. 4. PHP REQUIREMENT LINK: https://support.os4ed.com/hc/en-us/articles/201047836-InstallationPK yl\>NG G images/opensis.pngnu [ PNG IHDR tEXtSoftware Adobe ImageReadyqe< iTXtXML:com.adobe.xmp@M3J)-ճM.;-8 A@Ct |s;xRCЂ50C
OYg#A
H#a,ѳ%h C 0'sP#,rA3K/Vt+y(0pp&M\>|p@ G/
&cp =PB
(|,O a#1
+ nM> 'T, t;$
@. 1ȞH @\0p+wR`;h rAMA]F#=| C l+P9:9gW3df3rq 쯉ej6JS;=+`(dN/؆FcOl(/1r3.g
]
N_VJg8w7o9tꬉ$a20. SGO3 DhL 6}\c˘-ڒI!5䪋lʾH=ٮs{3]f^ ,w Fw|Ixhc)H_Pw"9D sAP %56Rē ?"85HpqTA44#nN*+2hc&M/p) p
TSE() 观MW=B"~P 756Ch Yq$BNABRF^ZJF !APhq$ZQ
c!y99+ZhQ8RAR(dEWWZ傒TPP@PRRqoO
O̟
ZoFD|q$
wzzѦㆡpdCĿ -' |'58
˒Df$
ەDFhj5+nN$_sǜ=)8OhU$E5ޭטʽB *2L tDXyꞺoKO*wɒBǸU_<曄xD9?Su!P|ċ;Q=(J|w