-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1:3306
-- Tiempo de generación: 17-05-2021 a las 22:58:35
-- Versión del servidor: 10.4.10-MariaDB
-- Versión de PHP: 7.0.33

START TRANSACTION;



--
-- Base de datos: `install`
--

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

--
-- Estructura de tabla para la tabla `academic_settings`
--

CREATE TABLE IF NOT EXISTS `academic_settings` (
  `settings_id` int(100) NOT NULL AUTO_INCREMENT,
  `type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`settings_id`),
  UNIQUE KEY `settings_id` (`settings_id`),
  KEY `settings_id_2` (`settings_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `academic_settings`
--

INSERT INTO `academic_settings` (`settings_id`, `type`, `description`) VALUES
(2, 'report_teacher', '1'),
(3, 'minium_mark', '61'),
(22, 'tabulation', NULL),
(25, 'routine', '1'),
(1, 'limit_upload', ''),
(26, 'terms', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n');

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

--
-- Estructura de tabla para la tabla `accountant`
--

CREATE TABLE IF NOT EXISTS `accountant` (
  `accountant_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(300) NOT NULL,
  `email` varchar(300) DEFAULT NULL,
  `password` varchar(300) NOT NULL,
  `phone` varchar(300) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  `username` varchar(300) NOT NULL,
  `fb_token` longtext DEFAULT NULL,
  `fb_id` longtext DEFAULT NULL,
  `fb_photo` longtext DEFAULT NULL,
  `fb_name` longtext DEFAULT NULL,
  `g_oauth` longtext DEFAULT NULL,
  `g_fname` longtext DEFAULT NULL,
  `femail` longtext DEFAULT NULL,
  `g_lname` longtext DEFAULT NULL,
  `g_picture` longtext DEFAULT NULL,
  `link` longtext DEFAULT NULL,
  `g_email` longtext DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `last_name` varchar(200) DEFAULT NULL,
  `gender` varchar(200) DEFAULT NULL,
  `idcard` varchar(200) DEFAULT NULL,
  `since` varchar(20) DEFAULT NULL,
  `birthday` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`accountant_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `account_role`
--

CREATE TABLE IF NOT EXISTS `account_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `permissions` int(10) DEFAULT 0,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcado de datos para la tabla `account_role`
--

INSERT INTO `account_role` (`role_id`, `type`, `permissions`) VALUES
(1, 'messages', 1),
(2, 'students', 1),
(3, 'academic', 1),
(4, 'polls', 1),
(5, 'news', 1),
(6, 'schedules', 1),
(7, 'admins', 1),
(8, 'accountants', 1),
(9, 'attendance', 1),
(10, 'notifications', 1),
(11, 'school_bus', 1),
(12, 'system_reports', 1),
(13, 'parents', 1),
(14, 'librarians', 1),
(15, 'calendar', 1),
(16, 'admissions', 1),
(17, 'classrooms', 1),
(18, 'academic_settings', 1),
(19, 'teachers', 1),
(20, 'library', 1),
(21, 'files', 1),
(22, 'behavior', 1),
(23, 'accounting', 1),
(24, 'settings', 1);

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

--
-- Estructura de tabla para la tabla `activity_read`
--

CREATE TABLE IF NOT EXISTS `activity_read` (
  `actividy_read_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `subject_activity_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `year` varchar(50) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `activity_type` varchar(50) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`actividy_read_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `attendance`
--

CREATE TABLE IF NOT EXISTS `attendance` (
  `attendance_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
  `year` longtext COLLATE utf8_unicode_ci NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0(undefined) 1(present) 2(absent)',
  `subject_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`attendance_id`),
  KEY `attendance_id` (`attendance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `attendance_live`
--

CREATE TABLE IF NOT EXISTS `attendance_live` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `live_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `date` varchar(600) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `book`
--

CREATE TABLE IF NOT EXISTS `book` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `author` longtext COLLATE utf8_unicode_ci NOT NULL,
  `class_id` longtext COLLATE utf8_unicode_ci NOT NULL,
  `price` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` longtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_name` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_copies` int(11) DEFAULT NULL,
  `issued_copies` int(11) DEFAULT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `book_request`
--

CREATE TABLE IF NOT EXISTS `book_request` (
  `book_request_id` int(11) NOT NULL AUTO_INCREMENT,
  `book_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `issue_start_date` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `issue_end_date` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`book_request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `ci_sessions`
--

CREATE TABLE IF NOT EXISTS `ci_sessions` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `class`
--

CREATE TABLE IF NOT EXISTS `class` (
  `class_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `jornada_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) NOT NULL,
  `nivel_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `class_routine`
--

CREATE TABLE IF NOT EXISTS `class_routine` (
  `class_routine_id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `time_start` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_end` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_start_min` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_end_min` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `day` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `amend` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `amstart` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `classroom_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`class_routine_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `deliveries`
--

CREATE TABLE IF NOT EXISTS `deliveries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `homework_code` varchar(600) NOT NULL,
  `student_id` int(11) NOT NULL,
  `date` varchar(600) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `file_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `student_comment` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `teacher_comment` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject_id` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `homework_reply` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mark` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `document`
--

CREATE TABLE IF NOT EXISTS `document` (
  `document_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_name` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_type` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_id` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filesize` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `wall_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `publish_date` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `upload_date` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`document_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `dormitory`
--

CREATE TABLE IF NOT EXISTS `dormitory` (
  `dormitory_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `number` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`dormitory_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `email_template`
--

CREATE TABLE IF NOT EXISTS `email_template` (
  `email_template_id` int(11) NOT NULL AUTO_INCREMENT,
  `task` longtext COLLATE utf8_unicode_ci NOT NULL,
  `subject` longtext COLLATE utf8_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8_unicode_ci NOT NULL,
  `instruction` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`email_template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcado de datos para la tabla `email_template`
--

INSERT INTO `email_template` (`email_template_id`, `task`, `subject`, `body`, `instruction`) VALUES
(1, 'new_homework', 'New homework uploaded', '<p>Hi,</p>\r\n<p>Your teacher of&nbsp;[SUBJECT] has created a new&nbsp;homework to the system, the information is as follows:</p>\r\n<p><br />Title&nbsp;: [TITLE]</p>\r\n<p>Description: [DESCRIPTION]</p>\r\n<p>&nbsp;</p>\r\n<p>To review this homework, enter your <strong>Virtual Classroom</strong>,&nbsp;Homework section.</p>', ''),
(2, 'student_absences', 'Absenses', '<div>Hi&nbsp;<strong>[PARENT]</strong>,</div>\r\n<p>The reason for the mail is to notify you that your appreciable son&nbsp;<strong>[STUDENT]</strong>&nbsp; is not present in the classes today, if it is an emergency please contact the shcool.</p>', ''),
(3, 'student_reports', 'New report', '<div>\r\n<div>\r\n<p>Hi&nbsp;<strong>[PARENT]</strong>,</p>\r\n<p>A new discipline report has been created for <strong>[STUDENT]</strong>, please check the academic reports within your account.</p>\r\n</div>\r\n</div>', ''),
(4, 'parent_new_invoice', 'New invoice', '<p>Hi&nbsp;<strong>[PARENT]</strong>,</p>\r\n<p>A new invoice has been created for <strong>[STUDENT]</strong>,&nbsp;to see the details of the invoice please enter your payment management in your account.</p>', ''),
(5, 'student_new_invoice', 'New invoice', '<p>Hi <strong>[STUDENT]</strong>,</p>\r\n<p>A new invoice has been created with your name, to see the details of the invoice please enter your payment management in your account.</p>', '');

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

--
-- Estructura de tabla para la tabla `enroll`
--

CREATE TABLE IF NOT EXISTS `enroll` (
  `enroll_id` int(11) NOT NULL AUTO_INCREMENT,
  `enroll_code` longtext COLLATE utf8_unicode_ci NOT NULL,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) DEFAULT NULL,
  `roll` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `date_added` longtext COLLATE utf8_unicode_ci NOT NULL,
  `year` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`enroll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `events`
--

CREATE TABLE IF NOT EXISTS `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `color` varchar(7) DEFAULT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Estructura de tabla para la tabla `exam`
--

CREATE TABLE IF NOT EXISTS `exam` (
  `exam_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `start` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `end` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`exam_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `expense_category`
--

CREATE TABLE IF NOT EXISTS `expense_category` (
  `expense_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`expense_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `user_type` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `folder_token` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fileorder` varchar(200) NOT NULL,
  PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `folder`
--

CREATE TABLE IF NOT EXISTS `folder` (
  `folder_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `user_type` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` varchar(200) NOT NULL,
  `token` longtext NOT NULL,
  PRIMARY KEY (`folder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `forum`
--

CREATE TABLE IF NOT EXISTS `forum` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `post_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `section_id` int(11) NOT NULL,
  `post_status` int(11) DEFAULT 1,
  `type` varchar(200) NOT NULL,
  `wall_type` varchar(20) DEFAULT NULL,
  `publish_date` varchar(20) DEFAULT NULL,
  `upload_date` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `forum_message`
--

CREATE TABLE IF NOT EXISTS `forum_message` (
  `message` longtext CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
  `post_id` int(11) NOT NULL,
  `date` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `grade`
--

CREATE TABLE IF NOT EXISTS `grade` (
  `grade_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `grade_point` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `mark_from` int(11) DEFAULT NULL,
  `mark_upto` int(11) DEFAULT NULL,
  PRIMARY KEY (`grade_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `group_message`
--

CREATE TABLE IF NOT EXISTS `group_message` (
  `group_message_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_message_thread_code` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `sender` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `read_status` int(11) DEFAULT NULL,
  `attached_file_name` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`group_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `group_message_thread`
--

CREATE TABLE IF NOT EXISTS `group_message_thread` (
  `group_message_thread_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_message_thread_code` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `members` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `group_name` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_message_timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`group_message_thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `homework`
--

CREATE TABLE IF NOT EXISTS `homework` (
  `homework_id` int(11) NOT NULL AUTO_INCREMENT,
  `homework_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `uploader_id` int(11) NOT NULL,
  `time_end` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `section_id` int(11) NOT NULL,
  `uploader_type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date_end` varchar(600) DEFAULT NULL,
  `type` int(11) NOT NULL,
  `user` varchar(200) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `year` varchar(20) DEFAULT NULL,
  `filesize` varchar(20) DEFAULT NULL,
  `wall_type` varchar(20) DEFAULT NULL,
  `publish_date` varchar(20) DEFAULT NULL,
  `upload_date` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`homework_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `homework_files`
--

CREATE TABLE IF NOT EXISTS `homework_files` (
  `fhomework_file_id` int(11) NOT NULL AUTO_INCREMENT,
  `homework_code` varchar(200) DEFAULT NULL,
  `delivery_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `file` longtext DEFAULT NULL,
  PRIMARY KEY (`fhomework_file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `horarios_examenes`
--

CREATE TABLE IF NOT EXISTS `horarios_examenes` (
  `horario_id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `time_start` int(11) NOT NULL,
  `time_end` int(11) NOT NULL,
  `time_start_min` varchar(11) NOT NULL,
  `time_end_min` varchar(11) NOT NULL,
  `day` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `year` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `fecha` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `amstart` varchar(20) DEFAULT NULL,
  `amend` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`horario_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `invoice`
--

CREATE TABLE IF NOT EXISTS `invoice` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `title` longtext COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `amount` int(11) NOT NULL,
  `amount_paid` longtext COLLATE utf8_unicode_ci NOT NULL,
  `due` longtext COLLATE utf8_unicode_ci NOT NULL,
  `creation_timestamp` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `payment_timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_method` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_details` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'paid or unpaid',
  `year` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `language`
--

CREATE TABLE IF NOT EXISTS `language` (
  `phrase_id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase` longtext COLLATE utf8_unicode_ci NOT NULL,
  `english` longtext COLLATE utf8_unicode_ci NOT NULL,
  `spanish` longtext COLLATE utf8_unicode_ci NOT NULL,
  `portuguese` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `hindi` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `french` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `serbian` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `arabic` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`phrase_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3689 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `language` (`phrase_id`, `phrase`, `english`, `spanish`, `portuguese`, `hindi`, `french`, `serbian`, `arabic`) VALUES
(382, 'student_comment', 'Student comment', 'Comentario del estudiante', 'Comentário do aluno', 'छात्र टिप्पणी', 'Commentaire de l\'élève', 'Студентски коментар', 'تعليق الطالب'),
(383, 'delivery_status', 'Delivery status', 'Estado de la entrega', 'Status de entrega', 'वितरण की स्थिति', 'Statut de livraison', 'Статус испоруке', 'حالة التسليم'),
(384, 'file_response', 'File/Response', 'Archivo/Respuesta', 'Arquivo / Resposta', 'फ़ाइल / प्रतिक्रिया', 'Fichier / Réponse', 'Одговор на фајл', 'ملف / الاستجابة'),
(385, 'delayed_delivery', 'Delivery after time', 'Entrega tarde', 'Entrega após o tempo', 'समय के बाद वितरण', 'Livraison après le temps', 'Одложена испорука', 'التسليم بعد الوقت'),
(386, 'update_homework', 'Update homework', 'Actualizar tarea', 'Atualize a lição de casa', 'होमवर्क अपडेट करें', 'Mettre à jour les devoirs', 'Ажурирати домаћи задатак', 'تحديث الواجبات المنزليةv'),
(387, 'delivery_type', 'Delivery type', 'Tipo de entrega', 'Tipo de entrega', 'वितरण के प्रकार', 'Type de livraison', 'Тип испоруке', 'نوع التوصيل'),
(388, 'new_discussion', 'New discussion', 'Nueva discusión ', 'Nova discussão', 'नई चर्चा', 'Nouvelle discussion', 'Нова дискусија', 'مناقشة جديدة'),
(389, 'publish', 'Publish', 'Publicar', 'Publicar', 'प्रकाशित करना', 'Publier', 'Објавити', 'نشر'),
(390, 'update_forum', 'Update forum', 'Actualizar foro', 'Atualizar fórum', 'फ़ोरम अपडेट करें', 'Forum de mise à jour', 'Упдате форум', 'تحديث المنتدى'),
(391, 'uploaded_by', 'Uploaded by', 'Subido por', 'Enviado por', 'द्वारा डाली गई', 'telechargé par', 'Уплоадед би', 'تم الرفع بواسطة'),
(392, 'send_bulk_emails', 'Send bulk email', 'Enviar correos masivos', 'Enviar e-mail em massa', 'थोक ईमेल भेजें', 'Envoyer un courrier électronique en bloc', 'Пошаљите масе е-поште', 'إرسال البريد الإلكتروني المجمع'),
(393, 'categories', 'Categories', 'Categorías', 'Categorias', 'श्रेणियाँ', 'Catégories', 'Категорије', 'الاقسام'),
(394, 'new_expense', 'New expense', 'Nuevo egreso', 'Nova despesa', 'नया खर्च', 'Nouvelle dépense', 'Ново издање', 'حساب جديد'),
(395, 'category', 'Category', 'Categoría', 'Categoria', 'वर्ग', 'Catégorie', 'Категорија', 'الفئة'),
(396, 'new_category', 'New category', 'Nueva categoria', 'Nova categoria', 'नई श्रेणी', 'Nouvelle catégorie', 'Нова категорија', 'فئة جديدة'),
(397, 'confirm_delete', 'Do you want to delete the information?', 'Seguro desea eliminar la información?', 'Deseja excluir as informações?', 'क्या आप जानकारी को हटाना चाहते हैं?', 'Voulez-vous supprimer les informations?', 'Да ли желите да обришете информације?', 'هل تريد حذف المعلومات؟'),
(398, 'confirm_approval', 'Surely you want to approve?', 'Confirma que desea aprobar?', 'Certamente você quer aprovar?', 'निश्चित रूप से आप स्वीकृति देना चाहते हैं?', 'Vous voulez certainement approuver?', 'Да ли желите да одобрите?', 'بالتأكيد كنت ترغب في الموافقة؟'),
(399, 'confirm_reject', 'Insurance do you want to reject?', 'Confirma que desea rechazar?', 'Seguro você quer rejeitar?', 'बीमा क्या आप अस्वीकार करना चाहते हैं?', 'Assurance voulez-vous rejeter?', 'Да ли желите да одбијете?', 'التأمين هل تريد أن ترفض؟'),
(400, 'confirm_delete_student', 'Are you sure you want to remove the student?', 'Confirma que desea eliminar al estudiante?', 'Tem certeza de que deseja remover o aluno?', 'क्या आप वाकई छात्र को निकालना चाहते हैं?', 'Êtes-vous sûr de vouloir supprimer l\'étudiant?', 'Да ли желите да избришете ученика?', 'هل تريد بالتأكيد إزالة الطالب؟'),
(401, 'confirm_solved', 'Are you sure you want to mark as resolved?', 'Seguro desea marcar como resuelto?', 'Tem certeza de que deseja marcar como resolvido?', 'क्या आप वाकई हल के रूप में चिह्नित करना चाहते हैं?', 'Êtes-vous sûr de vouloir marquer comme résolu?', 'Осигурање желите означити као ријешено?', 'هل تريد بالتأكيد وضع علامة على أنه تم حلها؟'),
(402, 'notification_center', 'Notification center', 'Centro de notificaciones', 'Centro de Notificação', 'सूचना केन्द्र', 'Centre de notification', 'Обавештење центар', 'مركز إعلام'),
(403, 'welcome_notifications', 'Welcome to the notification center', 'Bienvenido al centro de notificaciones', 'Bem-vindo ao centro de notificação', 'अधिसूचना केंद्र में आपका स्वागत है', 'Bienvenue au centre de notification', 'Добродошли у центар за обавештења', 'مرحبا بكم في مركز الإعلام'),
(404, 'what_send', 'What do you want to notify today?', '¿Qué notificaciones desea enviar?', 'O que você quer notificar hoje?', 'आज आपको क्या सूचित करना है?', 'Que souhaitez-vous notifier aujourd\'hui?', 'Које обавештења желите послати?', 'ماذا تريد أن تخطر اليوم؟'),
(405, 'send_email', 'Send email', 'Enviar correo', 'Enviar email', 'ईमेल भेजें', 'Envoyer un courrier électronique', 'Пошаљи пошту', 'ارسل بريد الكتروني'),
(406, 'successfully_added', 'Successfully added information', 'Información agregada con éxito', 'nformações adicionadas com sucesso', 'सफलतापूर्वक जानकारी जोड़ा', 'Informations ajoutées avec succès', 'Успешно додано', 'تمت إضافة معلومات بنجاح'),
(407, 'successfully_updated', 'Information updated successfully', 'Información actualizada con éxito', 'Informações atualizadas com sucesso', 'सूचना सफलतापूर्वक अपडेट की गई', 'Informations mises à jour avec succès', 'Успешно ажуриран', 'تم تحديث المعلومات بنجاح'),
(408, 'successfully_deleted', 'Information deleted successfully', 'Información eliminada con éxito', 'Informações eliminadas com sucesso', 'जानकारी सफलतापूर्वक हटाई गई', 'Informations supprimées avec succès', 'Успешно избрисан', 'تم حذف المعلومات بنجاح'),
(409, 'sent_successfully', 'Information sent successfully', 'Información enviada con éxito', 'Informações enviadas com sucesso', 'सूचना सफलतापूर्वक भेजी गई', 'Informations envoyées avec succès', 'Послато успешно', 'تم إرسال المعلومات بنجاح'),
(410, 'successfully_uploaded', 'Information uploaded successfully', 'Información subida con éxito', 'Informações carregadas com sucesso', 'सूचना सफलतापूर्वक अपलोड की गई', 'Informations téléchargées avec succès', 'Успешно постављен', 'تم تحميل المعلومات بنجاح'),
(411, 'reply_sent', 'Reply sent', 'Respuesta enviada', 'Resposta enviada', 'उत्तर भेजा', 'Réponse envoyée', 'Одговор послат', 'تم إرسال الرد'),
(412, 'message_sent', 'Message sent', 'Mensaje enviado', 'Mensagem enviada', 'मैसेज बेजा गया', 'Message envoyé', 'Порука послата', 'تم الارسال'),
(413, 'limit_questions', 'To add more questions configure the exam to accept more', 'Para agregar más preguntas configura el examen para aceptar más', 'Para adicionar mais perguntas configure o exame para aceitar mais', 'और अधिक प्रश्न जोड़ने के लिए अधिक स्वीकार करने के लिए परीक्षा को कॉन्फ़िगर करें', 'Pour ajouter d\'autres questions, configurez l\'examen pour accepter plus', 'Да бисте додали још питања, конфигурирајте испит да бисте прихватили више', 'لإضافة المزيد من الأسئلة، يمكنك تهيئة الاختبار لقبول المزيد'),
(414, 'delivered_homework', 'Homework successfully delivered', 'Tarea entregada correctamente', 'Tarefa entregue corretamente.', 'कार्य सफलतापूर्वक वितरित', 'Travail à domicile livré avec succès', 'Задатак је исправно достављен', 'تم تسليم الواجبات المنزلية بنجاح'),
(415, 'paid', 'Paid', 'Pagado', 'Paid', 'भुगतान किया', 'Payé', 'Плаћени', 'دفع'),
(416, 'unpaid', 'Unpaid', 'Sin pagar', 'Unpaid', 'वेतन के बिना', 'Non payé', 'Неплаћен', 'غير مدفوع'),
(417, 'social', 'Socials', 'Social', 'Social', 'सामाजिक', 'Socials', 'Социјално', 'سيالز'),
(418, 'no_questions', 'No. Questions', 'No. de Preguntas', 'Pergunta Total', 'कोई प्रश्न नहीं', 'Question totale', 'Укупно питање', 'إجمالي السؤال'),
(419, 'on_time', 'On time', 'A tiempo', 'Na Hora', 'समय पर', 'À temps', 'На време', 'في الوقت المحدد'),
(420, 'view_response', 'View response', 'Ver respuesta', 'Ver resposta', 'प्रतिक्रिया देखें', 'Voir la réponse', 'Погледајте одговор', 'عرض الرد'),
(421, 'success_password', 'Your password has been reset successfully. This is your new password:', 'Tu password ha sido reseteado exitosamente. Éste es tu nuevo password:', 'Sua senha foi reiniciada com sucesso. Esta é a sua nova senha:', 'आपका पासवर्ड सफलतापूर्वक रीसेट कर दिया गया है यह आपका नया पासवर्ड है:', 'Votre mot de passe a été réinitialisé avec succès. Ceci est votre nouveau mot de passe:', 'Ваша лозинка је успјешно ресетована. Ово је ваша нова лозинка:', 'تمت إعادة تعيين كلمة المرور بنجاح. هذه هي كلمة المرور الجديدة:'),
(422, 'message_group', 'Group Message', 'Mensaje en grupo', NULL, NULL, NULL, NULL, ''),
(423, 'groups', 'Groups', 'Grupos', NULL, NULL, NULL, NULL, ''),
(424, 'create_group', 'Create group', 'Crear un grupo', NULL, NULL, NULL, NULL, ''),
(425, 'select_group_or', 'Select group or', 'Seleccionar un grupo o', NULL, NULL, NULL, NULL, ''),
(426, 'group_members', 'Group members', 'Miembros del grupo', NULL, NULL, NULL, NULL, ''),
(427, 'user_type', 'User type', 'Tipo de profesor', NULL, NULL, NULL, NULL, ''),
(428, 'user_permissions', 'User permissions', 'Permisos del usuario', NULL, NULL, NULL, NULL, ''),
(429, 'add_language', 'Add language', 'Agregar idioma', NULL, NULL, NULL, NULL, ''),
(430, 'flag', 'Flag', 'Bandera', NULL, NULL, NULL, NULL, ''),
(431, 'grades', 'Grade leves', 'Niveles de grado', NULL, NULL, NULL, NULL, ''),
(432, 'mark_from', 'Mark from', 'Desde', NULL, NULL, NULL, NULL, ''),
(433, 'mark_to', 'Mark to', 'Hasta', NULL, NULL, NULL, NULL, ''),
(434, 'point', 'Point', 'Punto', NULL, NULL, NULL, NULL, ''),
(435, 'grade', 'Grade', 'Grado', NULL, NULL, NULL, NULL, ''),
(436, 'participants', 'Participants', 'Participantes', NULL, NULL, NULL, NULL, ''),
(437, 'google_err', 'This email address is already being used by another user, to be able to add it first it must be deactivated from the other account', 'Esta dirección de email ya esta siendo utilizada por otro usuario, para poder agregarla primero debe ser desactivada desde la otra cuenta', NULL, NULL, NULL, NULL, ''),
(438, 'google_true', 'Your Google account has been linked successfully', 'Tu cuenta de Google se ha vinculado con éxito', NULL, NULL, NULL, NULL, ''),
(439, 'facebook_true', 'Your Facebook account has been linked successfully', 'Tu cuenta de Facebook se ha vinculado con éxito', NULL, NULL, NULL, NULL, ''),
(440, 'facebook_err', 'This Facebook account is already being used by another user, to be able to add it first it must be deactivated from the other profile', 'Esta cuenta de Facebook ya esta siendo utilizada por otro usuario, para poder agregarla primero debe ser desactivada desde el otro perfil', NULL, NULL, NULL, NULL, ''),
(441, 'facebook_delete', 'Your Facebook account has been successfully unlinked', 'Tu cuenta de Facebook se ha desvinculado correctamente', NULL, NULL, NULL, NULL, ''),
(442, 'google_delete', 'Your Google account has been successfully unlinked', 'Tu cuenta de Facebook se ha desvinculado correctamente', NULL, NULL, NULL, NULL, ''),
(443, 'my_notifications', 'My Notifications', 'Mis notificaciones', NULL, NULL, NULL, NULL, ''),
(444, 'absence_approved', 'You have approved your leave of absence.', 'Ha aprobado tu permiso de ausencia.', NULL, NULL, NULL, NULL, ''),
(445, 'absence_rejected', 'You have rejected your leave of absence.', 'Ha rechazado tu permiso de ausencia.', NULL, NULL, NULL, NULL, ''),
(446, 'absence_approved_for', 'Has approved the leave of absence for', 'Ha aprobado el permiso de ausencia para', NULL, NULL, NULL, NULL, ''),
(447, 'absence_rejected_for', 'You have rejected the leave of absence to', 'Ha rechazado el permiso de ausencia para', NULL, NULL, NULL, NULL, ''),
(448, 'new_homework_notify', 'You have created a new homework with the title', 'Ha creado una nueva tarea con el título', NULL, NULL, NULL, NULL, ''),
(449, 'homework_rated', 'has rated your homework', 'ha calificado tu tarea', NULL, NULL, NULL, NULL, ''),
(450, 'study_material_notify', 'You have uploaded study material to your portal', 'Ha subido material de estudio a tu portal', NULL, NULL, NULL, NULL, ''),
(451, 'online_exam_notify', 'added a new online exam with the title', 'agregó un nuevo examen en línea con el título', NULL, NULL, NULL, NULL, ''),
(452, 'news_notify', 'You have received a new news with title', 'Has recibido una nueva noticia con título', NULL, NULL, NULL, NULL, ''),
(453, 'event_notify', 'A new event has been created with the title', 'Se ha creado un nuevo evento con el título', NULL, NULL, NULL, NULL, ''),
(454, 'new_comment', 'Added a new comment on', 'Agregó un nuevo comentario en', NULL, NULL, NULL, NULL, ''),
(455, 'report_solved', 'It has been marked as solved', 'Se ha marcado como resuelto', NULL, NULL, NULL, NULL, ''),
(456, 'unit_content', 'has uploaded files in Unit Contents for', 'ha subido archivos en Contenidos de Unidad para', NULL, NULL, NULL, NULL, ''),
(457, 'book_added', 'has added a new book to the library for', 'ha agregado un nuevo libro a la biblioteca para', NULL, NULL, NULL, NULL, ''),
(458, 'file_uploaded', 'Uploaded a file for teachers with the title', 'Subió un archivo para profesores con el título', NULL, NULL, NULL, NULL, ''),
(459, 'absence_request', 'has requested a new leave of absence to', 'ha solicitado un nuevo permiso de ausencia para', NULL, NULL, NULL, NULL, ''),
(460, 'reg_teacher', 'A new user has been registered as a teacher with the name', 'Se ha registrado un nuevo usuario como profesor con el nombre', NULL, NULL, NULL, NULL, ''),
(461, 'reg_student', 'A new user has been registered as a student with the name', 'Se ha registrado un nuevo usuario como estudiante con el nombre', NULL, NULL, NULL, NULL, ''),
(462, 'reg_parent', 'A new user has been registered as a parent with the name', 'Se ha registrado un nuevo usuario como padre con el nombre', NULL, NULL, NULL, NULL, ''),
(463, 'finish_exam_notify', 'has finished the exam', 'ha finalizado el examen', NULL, NULL, NULL, NULL, ''),
(464, 'teacher_report_notify', 'has created a new report for the teacher', 'ha creado un nuevo reporte para el profesor', NULL, NULL, NULL, NULL, ''),
(465, 'comment_forum', 'has posted a comment in the forum', 'ha publicado un comentario en el foro', NULL, NULL, NULL, NULL, ''),
(466, 'student_report_notify', 'has created a new report for the student', 'ha creado un nuevo reporte para el estudiante', NULL, NULL, NULL, NULL, ''),
(467, 'marks_notify', 'has updated the marks of', 'ha actualizado las calificaciones de', NULL, NULL, NULL, NULL, ''),
(468, 'absense_teacher', 'has requested a new leave of absence', 'ha solicitado un nuevo permiso de ausencia', NULL, NULL, NULL, NULL, ''),
(469, 'new_message_notify', 'has sent you a new message', 'te ha enviado un nuevo mensaje', NULL, NULL, NULL, NULL, ''),
(470, 'at', 'at', 'a las', NULL, NULL, NULL, NULL, ''),
(471, 'login_facebook', 'Login with Facebook', 'Acceder con Facebook', NULL, NULL, NULL, NULL, ''),
(472, 'login_google', 'Login with Google', 'Acceder con Google', NULL, NULL, NULL, NULL, ''),
(473, 'login_error', 'There is an error in the login, verify and try again', 'Hay un error en el inicio de sesión, verifica y vuelve a intentarlo nuevamente', NULL, NULL, NULL, NULL, ''),
(474, 'social_error', 'Sorry, you can not sign in with this account you must first link it to your user profile', 'Lo sentimos, no puedes iniciar sesión con esta cuenta primero debes vincularla a tu perfil de usuario', NULL, NULL, NULL, NULL, ''),
(475, 'calendar', 'Calendar', 'Calendario', NULL, NULL, NULL, NULL, ''),
(476, 'my_files', 'My files', 'Mis archivos', NULL, NULL, NULL, NULL, ''),
(477, 'system_reports', 'System reports', 'Reportes del Sistema', NULL, NULL, NULL, NULL, ''),
(478, 'settings', 'Settings', 'Ajustes', NULL, NULL, NULL, NULL, ''),
(479, 'minimize_menu', 'Minimize menu', 'Minimizar menu', NULL, NULL, NULL, NULL, ''),
(480, 'search_students', 'Search students', 'Buscar estudiantes', NULL, NULL, NULL, NULL, ''),
(481, 'you', 'You', 'Tu', NULL, NULL, NULL, NULL, ''),
(482, 'view_all_messages', 'View all messages', 'Ver todos los mensajes', NULL, NULL, NULL, NULL, ''),
(483, 'view_all_notifications', 'View all notifications', 'Ver todas las notificationes', NULL, NULL, NULL, NULL, ''),
(484, 'my_account', 'My Account', 'Mi cuenta', NULL, NULL, NULL, NULL, ''),
(485, 'my_profile', 'My profile', 'Mi perfil', NULL, NULL, NULL, NULL, ''),
(486, 'what_publish', 'What do you want to publish today?', 'qué deseas publicar hoy?', NULL, NULL, NULL, NULL, ''),
(487, 'upload_image', 'Upload image', 'Subir imagen', NULL, NULL, NULL, NULL, ''),
(488, 'poll', 'Poll', 'Encuesta', NULL, NULL, NULL, NULL, ''),
(489, 'go_to_details', 'Go to details', 'Ir a los detalles', NULL, NULL, NULL, NULL, ''),
(490, 'welcome_admin_dashboard', 'Welcome to your admin dashboard.', 'Bienvenido a tu tablero de administrador.', NULL, NULL, NULL, NULL, ''),
(491, 'no_today_events', 'There are no events today', 'No hay eventos para hoy', NULL, NULL, NULL, NULL, ''),
(492, 'this_month_is_birthday', 'This month is the birthday of', 'Este mes es el cumpleaños de', NULL, NULL, NULL, NULL, ''),
(493, 'view_all_birthdays', 'View all birthdays', 'Ver todos los cumpleaños', NULL, NULL, NULL, NULL, ''),
(494, 'absent_students', 'Absent', 'Estudiantes ausentes', NULL, NULL, NULL, NULL, ''),
(495, 'no_absent_students', 'No students absent', 'No hay estudiantes ausentes', NULL, NULL, NULL, NULL, ''),
(496, 'select_an_option', 'Select an option', 'Seleccionar una ocion', NULL, NULL, NULL, NULL, ''),
(497, 'chats', 'Chats', 'Chats', NULL, NULL, NULL, NULL, ''),
(498, 'write', 'Write', 'Escribir', NULL, NULL, NULL, NULL, ''),
(499, 'librarian', 'Librarian', 'Bibliotecaria', NULL, NULL, NULL, NULL, ''),
(500, 'accountant', 'Accountant', 'Contadora', NULL, NULL, NULL, NULL, ''),
(501, 'create_message', 'Create message', 'Crear mensaje', NULL, NULL, NULL, NULL, ''),
(502, 'shared_files', 'Shared files', 'Archivos compartidos', NULL, NULL, NULL, NULL, ''),
(503, 'without_shared_files', 'There are no shared files', 'Sin archivos compartidos', NULL, NULL, NULL, NULL, ''),
(504, 'shared_photos', 'Shared photos', 'Fotos compartidas', NULL, NULL, NULL, NULL, ''),
(505, 'without_shared_pictures', 'There are no shared photos', 'Sin fotos compartidas', NULL, NULL, NULL, NULL, ''),
(506, 'viewed', 'Seen', 'Visto', NULL, NULL, NULL, NULL, ''),
(507, 'your_notifications', 'Your notifications', 'Tus notifications', NULL, NULL, NULL, NULL, ''),
(508, 'member_since', 'Member since', 'Miembro desde', NULL, NULL, NULL, NULL, ''),
(509, 'identification', 'Personal document', 'Identificación', NULL, NULL, NULL, NULL, ''),
(510, 'quick_links', 'Quick links', 'Enlaces rápidos', NULL, NULL, NULL, NULL, ''),
(511, 'update_information', 'Update information', 'Actualizar información', NULL, NULL, NULL, NULL, ''),
(512, 'your_linked_accounts', 'Your linked accounts', 'Tus cuentas vinculadas', NULL, NULL, NULL, NULL, ''),
(513, 'link', 'Link', 'Vincular', NULL, NULL, NULL, NULL, ''),
(514, 'update_profile', 'Update profile', 'Actualizar perfil', NULL, NULL, NULL, NULL, ''),
(515, 'first_name', 'First name', 'Nombre', NULL, NULL, NULL, NULL, ''),
(516, 'last_name', 'Last name', 'Apellido', NULL, NULL, NULL, NULL, ''),
(517, 'student_details', 'Student details', 'Detalles del estudiante', NULL, NULL, NULL, NULL, ''),
(518, 'parent_details', 'Parent details', 'Detalles del padre', NULL, NULL, NULL, NULL, ''),
(519, 'complementary_data', 'Complementary data', 'Información complementaria', NULL, NULL, NULL, NULL, ''),
(520, 'transport', 'School bus', 'Transporte', NULL, NULL, NULL, NULL, ''),
(521, 'next', 'Next', 'Siguiente', NULL, NULL, NULL, NULL, ''),
(522, 'new_parent_admission', 'Select an parent', 'Nuevo padre', NULL, NULL, NULL, NULL, ''),
(523, 'new_parent_admission_message', 'If you want to add a new parent, mark this option', 'Si dese agregar un nuevo padre marque esta opción', NULL, NULL, NULL, NULL, ''),
(524, 'select_parent', 'Select parent', 'Seleccionar un padre', NULL, NULL, NULL, NULL, ''),
(525, 'home_phone', 'Home phone', 'Telefono de casa', NULL, NULL, NULL, NULL, ''),
(526, 'business_work', 'Workplace', 'Lugar de trabajo', NULL, NULL, NULL, NULL, ''),
(527, 'phone_work', 'Work phone', 'Telefono de trabajo', NULL, NULL, NULL, NULL, ''),
(528, 'conditions_or_diseases', 'Conditions or diseases', 'Condiciones o enfermedades', NULL, NULL, NULL, NULL, ''),
(529, 'allergies', 'Allergies', 'Alergías', NULL, NULL, NULL, NULL, ''),
(530, 'personal_doctor', 'Personal doctor', 'Doctor personal', NULL, NULL, NULL, NULL, ''),
(531, 'doctor_phone', 'Doctor phone', 'Telefono del doctor', NULL, NULL, NULL, NULL, ''),
(532, 'athorized_person', 'Authorized person', 'Persona autorizada', NULL, NULL, NULL, NULL, ''),
(533, 'phone_authorized_person', 'Authorized person phone', 'Telefono persona autorizada', NULL, NULL, NULL, NULL, ''),
(534, 'notes', 'Notes', 'Notas', NULL, NULL, NULL, NULL, ''),
(535, 'already_exist', 'Username already exist', 'El usuario ya existe', NULL, NULL, NULL, NULL, ''),
(536, 'accountants', 'Accountants', 'Contadoras', NULL, NULL, NULL, NULL, ''),
(537, 'librarians', 'Librarians', 'Bibliotecarias', NULL, NULL, NULL, NULL, ''),
(538, 'admin_permissions', 'Admin permissions', 'Permisos de administrador', NULL, NULL, NULL, NULL, ''),
(539, 'all_permissions', 'All permissions', 'Todos los permisos', NULL, NULL, NULL, NULL, ''),
(540, 'new_account', 'New account', 'Nueva cuenta', NULL, NULL, NULL, NULL, ''),
(541, 'search', 'Search', 'Buscar', NULL, NULL, NULL, NULL, ''),
(542, 'return', 'Return', 'Regresar', NULL, NULL, NULL, NULL, ''),
(543, 'upload_from_excel', 'Upload from excel', 'Subir desde excel', NULL, NULL, NULL, NULL, ''),
(544, 'export_students', 'Export students', 'Exportar estudiantes', NULL, NULL, NULL, NULL, ''),
(545, 'filter_by_class', 'Filter by class', 'Filtrar por grado', NULL, NULL, NULL, NULL, ''),
(546, 'export', 'Export', 'Exportar', NULL, NULL, NULL, NULL, ''),
(547, 'upload_students', 'Upload students', 'Subir estudiantes', NULL, NULL, NULL, NULL, ''),
(548, 'download_template', 'Download template', 'Descargar plantilla', NULL, NULL, NULL, NULL, ''),
(549, 'work_phone', 'Work phone', 'Telefono de trabajo', NULL, NULL, NULL, NULL, ''),
(550, 'authorized_person', 'Authorized person', 'Persona autorizada', NULL, NULL, NULL, NULL, ''),
(551, 'note', 'Notes', 'Notas', NULL, NULL, NULL, NULL, ''),
(552, 'authorized_person_phone', 'Authorized person phone', 'Telefono persona autorizada', NULL, NULL, NULL, NULL, ''),
(553, 'payments_history', 'Payments history', 'Historial de pagos', NULL, NULL, NULL, NULL, ''),
(554, 'view_details', 'View details', 'Ver detalles', NULL, NULL, NULL, NULL, ''),
(555, 'student_attendance', 'Students attendance', 'Asistencia de estudiante', NULL, NULL, NULL, NULL, ''),
(556, 'year', 'Year', 'Año', NULL, NULL, NULL, NULL, ''),
(557, 'student_marks', 'Student marks', 'Calificaciones', NULL, NULL, NULL, NULL, ''),
(558, 'student_invoices', 'Student invoices', 'Pagos de estudiantes', NULL, NULL, NULL, NULL, ''),
(559, 'payments_and_invoices', 'Payments and invoices', 'Pagos y Facturas', NULL, NULL, NULL, NULL, ''),
(560, 'atendance', 'Attendance', 'Asistencia', NULL, NULL, NULL, NULL, ''),
(561, 'add_schedule', 'Add class routine', 'Agregar horario', NULL, NULL, NULL, NULL, ''),
(562, 'add_schedules', 'Add class routine', 'Agregar horarios', NULL, NULL, NULL, NULL, ''),
(563, 'course', 'Subject', 'Curso', NULL, NULL, NULL, NULL, ''),
(564, 'sunday', 'Sunday', 'Domingo', NULL, NULL, NULL, NULL, ''),
(565, 'saturday', 'Saturday', 'Sábado', NULL, NULL, NULL, NULL, ''),
(566, 'add_routine', 'Add class routine', 'Agregar horario', NULL, NULL, NULL, NULL, ''),
(567, 'time', 'Time', 'Tiempo', NULL, NULL, NULL, NULL, ''),
(568, 'new_class', 'New class', 'Nuevo grado', NULL, NULL, NULL, NULL, ''),
(569, 'create_new_class', 'Create new class', 'Crear nuevo grado', NULL, NULL, NULL, NULL, ''),
(570, 'new_subject', ' New subject', 'Nuevo curso', NULL, NULL, NULL, NULL, ''),
(571, 'create_new_subject', 'Create new subject', 'Crear nuevo curso', NULL, NULL, NULL, NULL, ''),
(572, 'icon', 'Subject icon', 'Icono', NULL, NULL, NULL, NULL, ''),
(573, 'color', 'Subject color', 'Color', NULL, NULL, NULL, NULL, ''),
(574, 'subject_dashboard', 'Subject dashboard ', 'Tablero de curso', NULL, NULL, NULL, NULL, ''),
(575, 'view_exam', 'View exam', 'Ver examen', NULL, NULL, NULL, NULL, ''),
(576, 'view_forum', 'View forum', 'Ver foro', NULL, NULL, NULL, NULL, ''),
(577, 'view_homework', 'View homework', 'Ver tarea', NULL, NULL, NULL, NULL, ''),
(578, 'subject_activity', 'Subject activity', 'Actividad del curso', NULL, NULL, NULL, NULL, ''),
(579, 'latest_news', 'Latest news', 'Ultimas noticias', NULL, NULL, NULL, NULL, ''),
(580, 'teacher_of_the_subject', 'Teacher of the subject', 'Profesor del curso', NULL, NULL, NULL, NULL, ''),
(581, 'confirm_publish', 'Sure you want to publish the information?', 'Seguro desea publicar la información?', NULL, NULL, NULL, NULL, ''),
(582, 'publish_exam', 'Publish exam', 'Publicar examen', NULL, NULL, NULL, NULL, ''),
(583, 'published', 'Published', 'Publicado', NULL, NULL, NULL, NULL, ''),
(584, 'confirm_expired', 'Sure you want to mark as expired?', 'Seguro desea marcar como expirado', NULL, NULL, NULL, NULL, ''),
(585, 'mark_as_expired', 'Mark as expired', 'Marcar como expirado', NULL, NULL, NULL, NULL, ''),
(586, 'expired', 'Expired', 'Expirado', NULL, NULL, NULL, NULL, ''),
(587, 'start_time', 'Start time', 'Hora de inicio', NULL, NULL, NULL, NULL, ''),
(588, 'end_time', 'End time', 'Hora limite', NULL, NULL, NULL, NULL, ''),
(589, 'minimum_percentage', 'Minimum percentage', 'Porcentaje minimo', NULL, NULL, NULL, NULL, ''),
(590, 'allow_homework_deliveries', 'Allow deliveries up to', 'Permitir entregas hasta', NULL, NULL, NULL, NULL, ''),
(591, 'no_published', 'Not published', 'No publicado', NULL, NULL, NULL, NULL, ''),
(592, 'show_students', 'Show to students', 'Mostrar a los estudiantes?', NULL, NULL, NULL, NULL, ''),
(593, 'show_message', 'If you want students to see this information, enable this option.', 'Si desea mostrar la información a los estudiantes marque esta opción', NULL, NULL, NULL, NULL, ''),
(594, 'not_published', 'Not published', 'No publicado', NULL, NULL, NULL, NULL, ''),
(595, 'read_forum', 'Read forum', 'Leer foro', NULL, NULL, NULL, NULL, ''),
(596, 'new_topic', 'New topic', 'Nuevo tema', NULL, NULL, NULL, NULL, ''),
(597, 'topic', 'Topic', 'Tema', NULL, NULL, NULL, NULL, ''),
(598, 'reply', 'Reply', 'Responder', NULL, NULL, NULL, NULL, ''),
(599, 'upload_study_material', 'Upload study material', 'Subir material de estudio', NULL, NULL, NULL, NULL, ''),
(600, 'file_type', 'File type', 'Tipo de archivo', NULL, NULL, NULL, NULL, ''),
(601, 'book_request', 'Book request', 'Solicitudes de libros', NULL, NULL, NULL, NULL, ''),
(602, 'total_books', 'Total books', 'Libros totales', NULL, NULL, NULL, NULL, ''),
(603, 'total_copies', 'Total copies', 'Copias totales', NULL, NULL, NULL, NULL, ''),
(604, 'delivered_copies', 'Delivered copies', 'Copias entregadas', NULL, NULL, NULL, NULL, ''),
(605, 'available_message', ' If the book is available, enable this option', 'Si el libro esta disponible active esta opcion', NULL, NULL, NULL, NULL, ''),
(606, 'virtual_message', 'If it is a virtual book (PDF, Doc) enable this option', 'Si el libro es virtual (PDF, Doc) habilite esta opción', NULL, NULL, NULL, NULL, ''),
(607, 'upload_book', 'Upload book', 'Subir libro', NULL, NULL, NULL, NULL, ''),
(608, 'requested_by', 'Requested by', 'Solicitado por', NULL, NULL, NULL, NULL, ''),
(609, 'starting_date', 'Starting date', 'Fecha de inicio', NULL, NULL, NULL, NULL, ''),
(610, 'ending_date', 'Ending date', 'Fecha limite ', NULL, NULL, NULL, NULL, ''),
(611, 'no_actions', 'No more actions', 'Sin acciones', NULL, NULL, NULL, NULL, ''),
(612, 'calendar_events', 'Calendar events', 'Calendario de eventos', NULL, NULL, NULL, NULL, ''),
(613, 'edit_event', 'Edit event', 'Editar evento', NULL, NULL, NULL, NULL, ''),
(614, 'general_reports', 'General reports', 'Reporte general', NULL, NULL, NULL, NULL, ''),
(615, 'final_marks', 'FInal marks', 'Calificaciones finales', NULL, NULL, NULL, NULL, ''),
(616, 'class_report', 'Class report', 'Reporte de grado', NULL, NULL, NULL, NULL, ''),
(617, 'get_report', 'Get report', 'Generar reporte', NULL, NULL, NULL, NULL, ''),
(618, 'system_email', 'System email', 'Correo del sistema', NULL, NULL, NULL, NULL, ''),
(619, 'system_phone', 'System phone', 'Telefono del sistema', NULL, NULL, NULL, NULL, ''),
(620, 'allow_user_register', 'Allow users to create accounts', 'Permitir registros', NULL, NULL, NULL, NULL, ''),
(621, 'user_register_message', 'Users can register from the frontend if you enable this option', 'Permitir a los usuarios crear cuentas', NULL, NULL, NULL, NULL, ''),
(622, 'timezone', 'Timezone', 'Zona horaria', NULL, NULL, NULL, NULL, ''),
(623, 'social_login', 'Social login', 'Inicio de sesión con social', NULL, NULL, NULL, NULL, ''),
(624, 'enable_social_login', 'Enable social login', 'Habilitar inicio de sesión social', NULL, NULL, NULL, NULL, ''),
(625, 'social_login_message', 'Users can use their Google account and Facebook to login', 'Permita a los usuarios acceder con su cuenta de facebook y google', NULL, NULL, NULL, NULL, ''),
(626, 'logo_color', 'Logo color', 'Logo color', NULL, NULL, NULL, NULL, ''),
(627, 'logo_white', 'Logo white', 'Colo blanco', NULL, NULL, NULL, NULL, ''),
(628, 'icon_white', 'Icon white', 'Icono blanco', NULL, NULL, NULL, NULL, ''),
(629, 'favicon', 'Favicon', 'Favicon', NULL, NULL, NULL, NULL, ''),
(630, 'background', 'Background', 'Backrgound', NULL, NULL, NULL, NULL, ''),
(631, 'home', 'Home', 'Inicio', NULL, NULL, NULL, NULL, ''),
(632, 'total_income', 'Total income', 'Ingresos totales', NULL, NULL, NULL, NULL, ''),
(633, 'total_expense', 'Total expense', 'Egresos totales', NULL, NULL, NULL, NULL, ''),
(634, 'pending_payments', 'Pending payments', 'Pagos pendientes', NULL, NULL, NULL, NULL, ''),
(635, 'completed_payments', 'Completed payments', 'Pagos confirmados', NULL, NULL, NULL, NULL, ''),
(636, 'recent_income', 'Recent income', 'Ingresos recientes', NULL, NULL, NULL, NULL, ''),
(637, 'recent_expense', 'Recent expense ', 'Egresos recientes', NULL, NULL, NULL, NULL, ''),
(638, 'single_invoice', 'Single invoice', 'Factura individual', NULL, NULL, NULL, NULL, ''),
(639, 'bulk_invoice', 'Bulk invoice', 'Facturas multiples', NULL, NULL, NULL, NULL, ''),
(640, 'add_category', 'Add category', 'Agregar categoría', NULL, NULL, NULL, NULL, ''),
(641, 'add_expense', 'Add expense', 'Agregar egreso', NULL, NULL, NULL, NULL, ''),
(642, 'folder', 'Folder', 'Carpeta', NULL, NULL, NULL, NULL, ''),
(643, 'recents', 'Recents', 'Recientes', NULL, NULL, NULL, NULL, ''),
(644, 'folders', 'Folders', 'Carpetas', NULL, NULL, NULL, NULL, ''),
(645, 'your_files', 'Your files', 'Tus archivos', NULL, NULL, NULL, NULL, ''),
(646, 'upload_new_file', 'Upload new file', 'Subir nuevo', NULL, NULL, NULL, NULL, ''),
(647, 'drag_your_files_here', 'Drag your files here', 'Arrastra tus archivos aquí', NULL, NULL, NULL, NULL, ''),
(648, 'your_files_message', 'Upload your files to your account', 'Almacena tus archivos en tu cuenta', NULL, NULL, NULL, NULL, ''),
(649, 'new_folder', 'New folder', 'Nueva careta', NULL, NULL, NULL, NULL, ''),
(650, 'create_folder', 'Create folder', 'Crear carpeta', NULL, NULL, NULL, NULL, ''),
(651, 'recent_files', 'Recent files', 'Archivos recientes', NULL, NULL, NULL, NULL, ''),
(652, 'my_folders', 'My folders', 'Mis carpetas', NULL, NULL, NULL, NULL, ''),
(653, 'total_folders', 'Total folders', 'Carpetas totales', NULL, NULL, NULL, NULL, ''),
(654, 'total_files', 'Total files', 'Archivos totales', NULL, NULL, NULL, NULL, ''),
(655, 'upload_files', 'Upload files', 'Subir archivos', NULL, NULL, NULL, NULL, ''),
(656, 'notifications_center', 'Notifications center', 'Centro de notificaciones', NULL, NULL, NULL, NULL, ''),
(657, 'available_for_all_users', 'Available for all users', 'Disponible para todos los usuarios', NULL, NULL, NULL, NULL, ''),
(658, 'send_emails', 'Send emails', 'Enviar correos', NULL, NULL, NULL, NULL, ''),
(659, 'message', 'Message', 'Mensaje', NULL, NULL, NULL, NULL, ''),
(660, 'enable_teacher_reports', 'Enable teacher reports', 'Habilitar reporte de profesores', NULL, NULL, NULL, NULL, ''),
(661, 'enable_sundays_schedules', 'Enable saturday and sunday in the schedules', 'Habilitar sabado y domingo en horarios', NULL, NULL, NULL, NULL, ''),
(662, 'terms_conditions', 'Terms and Conditions', 'Términos y Condiciones', NULL, NULL, NULL, NULL, ''),
(663, 'login_to_your_account', 'Login to your account.', 'Accede a tu cuenta', NULL, NULL, NULL, NULL, ''),
(664, 'forgot_my_password', 'Forgot my password.', 'Olvide mi contraseña', NULL, NULL, NULL, NULL, ''),
(665, 'or', 'or', 'o', NULL, NULL, NULL, NULL, ''),
(666, 'no_recent_activity', 'There is no recent activity', 'Sin actividad reciente', NULL, NULL, NULL, NULL, ''),
(667, 'no_subject_activity', 'No activity in the subject', 'No hay actividad en el curso', NULL, NULL, NULL, NULL, ''),
(668, 'teachers_reports', 'Teacher reports', 'Reporte de profesoresq', NULL, NULL, NULL, NULL, ''),
(669, 'add_report', 'Add report', 'Agregar reporte', NULL, NULL, NULL, NULL, ''),
(670, 'stduent', 'Student', 'Estudiante', NULL, NULL, NULL, NULL, ''),
(671, 'update_group', 'Update group', 'Actualizar grupo', NULL, NULL, NULL, NULL, ''),
(672, 'select_all', 'Select all', 'Seleccionar todos', NULL, NULL, NULL, NULL, ''),
(673, 'teacher_schedules', 'Teacher schedules', 'Horario de profesores', NULL, NULL, NULL, NULL, ''),
(674, 'teacher_subjects', 'Teacher subjects', 'Cursos de profesores', NULL, NULL, NULL, NULL, ''),
(675, 'personal_informaton', 'Personal information', 'Información personal', NULL, NULL, NULL, NULL, ''),
(676, 'parent_childs', 'Parent Childs', 'Estudiantes asociados', NULL, NULL, NULL, NULL, ''),
(677, 'stuents', 'Students', 'Estudiantes', NULL, NULL, NULL, NULL, ''),
(678, 'librarian_update', 'Librarian Update', 'Actualizar bibliotecaria', NULL, NULL, NULL, NULL, ''),
(679, 'birthdays', 'Birthdays', 'Cumpleaños', NULL, NULL, NULL, NULL, ''),
(680, 'print_invoice', 'Print invoice', 'Imprimir', NULL, NULL, NULL, NULL, ''),
(681, 'vote', 'Vote now', 'Votar', NULL, NULL, NULL, NULL, ''),
(682, 'welcome_teacher_dashboard', 'Welcome to your teacher dashboard.', 'Bienvenido a tu tablero de profesor.', NULL, NULL, NULL, NULL, ''),
(683, 'go_to_my_classes', 'Go to your classes.', 'Ir a mis clases', NULL, NULL, NULL, NULL, ''),
(684, 'create_new_folder', 'Create new folder', 'Crear nueva carpeta', NULL, NULL, NULL, NULL, ''),
(685, 'cerate_folder', 'Create folder', 'Crear carpeta', NULL, NULL, NULL, NULL, ''),
(686, 'available_for_students', 'Available for students', 'Disponible para estudiantes', NULL, NULL, NULL, NULL, ''),
(687, 'student_welcome_dashboard_message', ' Welcome to your student dashboard.', 'Bienvenido a tu tablero de estudiante.', NULL, NULL, NULL, NULL, ''),
(688, 'go_to_my_subjects', 'Go to your subjects', 'Ir a mis cursos', NULL, NULL, NULL, NULL, ''),
(689, 'complementary_information', 'Complementary data', 'Información adicional', NULL, NULL, NULL, NULL, ''),
(690, 'phone_doctor', 'Doctor phone', 'Telefono del doctor', NULL, NULL, NULL, NULL, ''),
(691, 'go_to_exams', 'Go to exams', 'Ir a examenes', NULL, NULL, NULL, NULL, ''),
(692, 'take_exam_message', 'You can take the exam in the established time', 'Solo puedes tomar el examen en horarios establecidos', NULL, NULL, NULL, NULL, ''),
(693, 'online_exam_results', 'Online exam results', 'Resultados', NULL, NULL, NULL, NULL, ''),
(694, 'no_reply', 'No reply', 'Sin responder', NULL, NULL, NULL, NULL, ''),
(695, 'view_all_marks', 'View all marks', 'Ver todas las calificaciones', NULL, NULL, NULL, NULL, ''),
(696, 'all_files', 'All files', 'Todos los archivos', NULL, NULL, NULL, NULL, ''),
(697, 'welcome_message_parent', 'Welcome to your parent dashboard.', 'Bienvenido a tu tablero de padre.', NULL, NULL, NULL, NULL, ''),
(698, 'go_to_academic', 'Go to academic', 'Ir a academico', NULL, NULL, NULL, NULL, ''),
(699, 'work_business', 'Workplace', 'Lugar de trabajo', NULL, NULL, NULL, NULL, ''),
(700, 'librarian_dashboard', 'Librarian dashboard', 'Tablero', NULL, NULL, NULL, NULL, ''),
(701, 'welcome_librarian_dashboard', 'Welcome to your librarian dashboard', 'Bienvenido a tu tablero de bibliotecario.', NULL, NULL, NULL, NULL, ''),
(702, 'go_to_library', 'Go to library', 'Ir a libreria', NULL, NULL, NULL, NULL, ''),
(703, 'accountant_dashboard', 'Accountant dashboard', 'Tablero', NULL, NULL, NULL, NULL, ''),
(704, 'vew_all_notifications', 'View all notifications', 'Ver todas las notificaciones', NULL, NULL, NULL, NULL, ''),
(705, 'welcome_accountant_dashboard', 'Welcome to you accountant dashboard.', 'Bienvenido a tu tablero de contador.', NULL, NULL, NULL, NULL, ''),
(706, 'go_to_payments', 'Go to payments', 'Ir a pagos', NULL, NULL, NULL, NULL, ''),
(707, 'your_email', 'Your email', 'Tu correo', NULL, NULL, NULL, NULL, ''),
(708, 'fist_name', 'First name', 'Nombre', NULL, NULL, NULL, NULL, ''),
(709, 'percentage_required', 'Percentage Required', 'Porcentaje requerido', NULL, NULL, NULL, NULL, ''),
(710, 'total_mark', 'Total mark', 'Calificacion total', NULL, NULL, NULL, NULL, ''),
(711, 'question_type', 'Question type', 'Tipo de pregunt', NULL, NULL, NULL, NULL, ''),
(712, 'multiple_choice', 'Multiple choice', 'Opcion multiple', NULL, NULL, NULL, NULL, ''),
(713, 'true_false', 'True  or False', 'Falso o Verdadero', NULL, NULL, NULL, NULL, ''),
(714, 'blank_spaces', 'Blank Spaces', 'Espacios en blanco', NULL, NULL, NULL, NULL, ''),
(715, 'select_question_type', 'Select question type', 'Seleccionar', NULL, NULL, NULL, NULL, ''),
(716, 'results_for', 'Results for', 'Resultados para', NULL, NULL, NULL, NULL, ''),
(717, 'mark_obtained', 'Mark obtained', 'Calificacion obtenida', NULL, NULL, NULL, NULL, ''),
(718, 'result', 'Result', 'Resultado', NULL, NULL, NULL, NULL, ''),
(719, 'answers', 'Answers', 'Respuestas', NULL, NULL, NULL, NULL, ''),
(720, 'fail', 'Failed', 'Fallo', NULL, NULL, NULL, NULL, ''),
(721, 'options_number', 'Number of options', 'Numero de opciones', NULL, NULL, NULL, NULL, ''),
(722, 'value_required', 'Value required', 'Requerido', NULL, NULL, NULL, NULL, ''),
(723, 'true', 'True', 'Verdadero', NULL, NULL, NULL, NULL, ''),
(724, 'false', 'False', 'Falso', NULL, NULL, NULL, NULL, ''),
(725, 'instructions', 'Instructions', 'Instrucciones', NULL, NULL, NULL, NULL, ''),
(726, 'instructions_message', 'It is required to complete the question of type of spaces. When you need to insert a line, you can simply enter \'_\' to get a blank space. You can check it in the preview below.', 'Se requiere para completar la pregunta de tipo de espacios. Cuando necesite insertar una línea, simplemente puede ingresar \'_\' para obtener un espacio en blanco. Puedes comprobarlo en la vista previa abajo.', NULL, NULL, NULL, NULL, ''),
(727, 'preview', 'Preview', 'Previsualizacion', NULL, NULL, NULL, NULL, ''),
(728, 'correct_words', 'Correct words', 'Palabras correctas', NULL, NULL, NULL, NULL, ''),
(729, 'correct_words_message', 'Here enter the words that complement your question, please enter them in the same order and separated by commas.', 'Aquí ingrese las palabras que complementan su pregunta, por favor ingresarlas en el mismo orden y separadas por coma.', NULL, NULL, NULL, NULL, ''),
(730, 'report_success', 'It has been marked as solved', 'El reporte se ha marcado como resuelto', NULL, NULL, NULL, NULL, ''),
(731, 'manage_sections', '', 'Administrar secciones', NULL, NULL, NULL, NULL, ''),
(732, 'new_section', '', 'Nueva sección', NULL, NULL, NULL, NULL, ''),
(733, 'new_event_notify', '', 'Se ha agregado un nuevo evento a tu calendario.', NULL, NULL, NULL, NULL, ''),
(734, 'new_poll_notify', '', 'Se ha agregado una nueva encuesta.', NULL, NULL, NULL, NULL, ''),
(735, 'suer_admin', '', 'Super admin', NULL, NULL, NULL, NULL, ''),
(736, 'grade_levels', '', 'Niveles de grado', NULL, NULL, NULL, NULL, ''),
(737, 'new_semester', '', 'Nuevo semestre', NULL, NULL, NULL, NULL, ''),
(738, 'absences_message', '', 'El estudiante no se encuentra presente el día de hoy', NULL, NULL, NULL, NULL, ''),
(739, 'students_reports_message', '', 'Se ha agregado un nuevo reporte', NULL, NULL, NULL, NULL, ''),
(740, 'new_invoice_message', '', 'Se ha agregado una nueva factura', NULL, NULL, NULL, NULL, ''),
(741, 'new_invoices', '', 'Nuevas facturas', NULL, NULL, NULL, NULL, ''),
(742, 'backup_restore', '', 'Copias de seguridad ', NULL, NULL, NULL, NULL, ''),
(743, 'generate_backup', '', 'Generar copia de seguridad', NULL, NULL, NULL, NULL, ''),
(744, 'import_backup', '', 'Restaurar copia de seguridad', NULL, NULL, NULL, NULL, ''),
(745, 'update_section', '', 'Actualizar seccón', NULL, NULL, NULL, NULL, ''),
(746, 'calassrooms', '', 'Salones de clases', NULL, NULL, NULL, NULL, ''),
(747, 'new_bus', '', 'Nuevo bus', NULL, NULL, NULL, NULL, ''),
(748, 'update_transport', '', 'Actualizar bus', NULL, NULL, NULL, NULL, ''),
(749, 'update_subject', '', 'Actualizar curso', NULL, NULL, NULL, NULL, ''),
(750, 'new_poll', '', 'Nueva encuest', NULL, NULL, NULL, NULL, ''),
(751, 'votes', '', 'Votos', NULL, NULL, NULL, NULL, ''),
(752, 'create_new_group', '', 'Crear nuevo grupo', NULL, NULL, NULL, NULL, ''),
(753, 'teachers_permissions', '', 'Permisos de profesores', NULL, NULL, NULL, NULL, ''),
(754, 'without_shared_picture', '', 'Sin fotografías compartidas', NULL, NULL, NULL, NULL, ''),
(755, 'dashoard', '', 'Dashboard', NULL, NULL, NULL, NULL, ''),
(756, 'suject_activity', '', 'Actividad del curso', NULL, NULL, NULL, NULL, ''),
(757, 'waiting_information', '', 'Esperando información', NULL, NULL, NULL, NULL, ''),
(758, 'select_an_question', '', 'Seleccionar una pregunta', NULL, NULL, NULL, NULL, ''),
(759, 'option_', '', 'Opción', NULL, NULL, NULL, NULL, ''),
(760, 'instuctions', '', 'Instrucciones', NULL, NULL, NULL, NULL, ''),
(761, 'failed', '', 'Fallo', NULL, NULL, NULL, NULL, ''),
(762, 'exam_information', '', 'Información del examen', NULL, NULL, NULL, NULL, ''),
(763, 'minute', '', 'Minuto', NULL, NULL, NULL, NULL, ''),
(764, 'second', '', 'Segundo', NULL, NULL, NULL, NULL, ''),
(765, 'waiting_results', '', 'Esperando resultados', NULL, NULL, NULL, NULL, ''),
(766, 'youtube_video', '', '', NULL, NULL, NULL, NULL, ''),
(767, 'income', '', '', NULL, NULL, NULL, NULL, ''),
(768, 'new_notice_info', '', '', NULL, NULL, NULL, NULL, ''),
(769, 'live', '', '', NULL, NULL, NULL, NULL, ''),
(770, 'meet', '', '', NULL, NULL, NULL, NULL, ''),
(771, 'create_live', '', '', NULL, NULL, NULL, NULL, ''),
(772, 'optional', '', '', NULL, NULL, NULL, NULL, ''),
(773, 'lost_text', '', '', NULL, NULL, NULL, NULL, ''),
(774, 'multilpe_choice', '', '', NULL, NULL, NULL, NULL, ''),
(775, 'update_question', '', '', NULL, NULL, NULL, NULL, ''),
(776, 'no_options_can_be_blank', '', '', NULL, NULL, NULL, NULL, ''),
(777, 'enter_exam_password', '', '', NULL, NULL, NULL, NULL, ''),
(778, 'password_does_not_match', '', '', NULL, NULL, NULL, NULL, ''),
(779, 'pass', '', '', NULL, NULL, NULL, NULL, ''),
(780, 'Verdadero', 'Verdadero', '', NULL, NULL, NULL, NULL, ''),
(796, 'students_report', '', '', NULL, NULL, NULL, NULL, ''),
(797, 'update_semester', '', '', NULL, NULL, NULL, NULL, ''),
(798, 'marks_report', '', '', NULL, NULL, NULL, NULL, ''),
(799, 'student_card', '', '', NULL, NULL, NULL, NULL, ''),
(800, 'tabulation_report', '', '', NULL, NULL, NULL, NULL, ''),
(801, 'mens', '', '', NULL, NULL, NULL, NULL, ''),
(802, 'women', '', '', NULL, NULL, NULL, NULL, ''),
(803, 'signature', '', '', NULL, NULL, NULL, NULL, ''),
(804, 'accounting_report', '', '', NULL, NULL, NULL, NULL, ''),
(1125, 'go_to_timeline', '', '', NULL, NULL, NULL, NULL, ''),
(865, 'update_routine', '', '', NULL, NULL, NULL, NULL, ''),
(1087, 'this_week', '', '', NULL, NULL, NULL, NULL, ''),
(1086, 'school_timeline', '', '', NULL, NULL, NULL, NULL, ''),
(1055, 'go_to_my_timeline', '', '', NULL, NULL, NULL, NULL, ''),
(1050, 'added_new_forum_discussion', '', '', NULL, NULL, NULL, NULL, ''),
(1045, 'progress', '', '', NULL, NULL, NULL, NULL, ''),
(966, 'new_request', '', '', NULL, NULL, NULL, NULL, ''),
(967, 'request', '', '', NULL, NULL, NULL, NULL, ''),
(1017, 'date_format', '', '', NULL, NULL, NULL, NULL, ''),
(1016, 'group_information', '', '', NULL, NULL, NULL, NULL, ''),
(1015, 'actions', '', '', NULL, NULL, NULL, NULL, ''),
(1014, 'waiting_mark', '', '', NULL, NULL, NULL, NULL, ''),
(1003, 'send_marks_by_email', '', '', NULL, NULL, NULL, NULL, ''),
(1004, 'you_dont_have_notifications', '', '', NULL, NULL, NULL, NULL, ''),
(1005, 'download_adminssion_sheet', '', '', NULL, NULL, NULL, NULL, ''),
(1006, 'download_adminssion_sheet_message', '', '', NULL, NULL, NULL, NULL, ''),
(1007, 'interal', 'Internal', '', NULL, NULL, NULL, NULL, ''),
(1008, 'external', '', '', NULL, NULL, NULL, NULL, ''),
(1009, 'live_type', 'Live type', '', NULL, NULL, NULL, NULL, ''),
(1010, 'internal', '', '', NULL, NULL, NULL, NULL, ''),
(1011, 'site_url', 'Site URL', '', NULL, NULL, NULL, NULL, ''),
(1012, 'update_live', 'Update live', '', NULL, NULL, NULL, NULL, ''),
(1013, 'modules', '', '', NULL, NULL, NULL, NULL, ''),
(1239, 'no_available', '', '', NULL, NULL, NULL, NULL, ''),
(1293, 'see_files', '', '', NULL, NULL, NULL, NULL, ''),
(1311, 'calendar_language', '', '', NULL, NULL, NULL, NULL, ''),
(1314, 'download_file', '', '', NULL, NULL, NULL, NULL, ''),
(1315, 'download_student_sheet', '', '', NULL, NULL, NULL, NULL, ''),
(1318, 'new_student', '', '', NULL, NULL, NULL, NULL, ''),
(1319, 'enroll', '', '', NULL, NULL, NULL, NULL, ''),
(1320, 'date_of_birth', '', '', NULL, NULL, NULL, NULL, ''),
(1321, 'generated_by', '', '', NULL, NULL, NULL, NULL, ''),
(1328, 'student_live_attendance', '', '', NULL, NULL, NULL, NULL, ''),
(1399, 'school_location', '', '', NULL, NULL, NULL, NULL, ''),
(1584, 'enable_logs', '', '', NULL, NULL, NULL, NULL, ''),
(1585, 'for_development_purposes', '', '', NULL, NULL, NULL, NULL, ''),
(1602, 'about_the_subject', '', '', NULL, NULL, NULL, NULL, ''),
(1605, 'subject_stats', '', '', NULL, NULL, NULL, NULL, ''),
(1608, 'homeworks', '', '', NULL, NULL, NULL, NULL, ''),
(1609, 'forums', '', '', NULL, NULL, NULL, NULL, ''),
(1610, 'live_classes', '', '', NULL, NULL, NULL, NULL, ''),
(1663, 'student_marksheet', '', '', NULL, NULL, NULL, NULL, ''),
(1664, 'student_marksheet_are_there', '', '', NULL, NULL, NULL, NULL, ''),
(1671, 'exam', '', '', NULL, NULL, NULL, NULL, ''),
(1672, 'marks_sent', '', '', NULL, NULL, NULL, NULL, ''),
(1673, 'welcome', '', '', NULL, NULL, NULL, NULL, ''),
(1674, 'new_account_has_been_created_with_your_email_address_in', '', '', NULL, NULL, NULL, NULL, ''),
(1675, 'your_data_are_as_follows', '', '', NULL, NULL, NULL, NULL, ''),
(1676, 'your_account_require_approval', '', '', NULL, NULL, NULL, NULL, ''),
(1677, 'congratulations', '', '', NULL, NULL, NULL, NULL, ''),
(1678, 'your_account_has_been_approved_now_you_can_login', '', '', NULL, NULL, NULL, NULL, ''),
(1679, 'root_folder', '', '', NULL, NULL, NULL, NULL, ''),
(1741, 'password_reset', '', '', NULL, NULL, NULL, NULL, ''),
(1781, 'email_already_exist', '', '', NULL, NULL, NULL, NULL, ''),
(1786, 'blue', '', '', NULL, NULL, NULL, NULL, ''),
(1787, 'turquoise', '', '', NULL, NULL, NULL, NULL, ''),
(1788, 'green', '', '', NULL, NULL, NULL, NULL, ''),
(1789, 'yellow', '', '', NULL, NULL, NULL, NULL, ''),
(1790, 'orange', '', '', NULL, NULL, NULL, NULL, ''),
(1791, 'red', '', '', NULL, NULL, NULL, NULL, ''),
(1792, 'black', '', '', NULL, NULL, NULL, NULL, ''),
(1797, 'current_class', '', '', NULL, NULL, NULL, NULL, ''),
(1798, 'class_to_promote', '', '', NULL, NULL, NULL, NULL, ''),
(1799, 'current_section', '', '', NULL, NULL, NULL, NULL, ''),
(1800, 'to_section', '', '', NULL, NULL, NULL, NULL, ''),
(1801, 'successfully_promoted', '', '', NULL, NULL, NULL, NULL, ''),
(1924, 'users_have_a_birthday_this_month', '', '', NULL, NULL, NULL, NULL, ''),
(1963, 'create_your_first_group', '', '', NULL, NULL, NULL, NULL, ''),
(1968, 'chat groups', '', '', NULL, NULL, NULL, NULL, ''),
(1981, 'without_shared_photos', '', '', NULL, NULL, NULL, NULL, ''),
(1986, 'members_on_this_group', '', '', NULL, NULL, NULL, NULL, ''),
(2049, 'show_results', '', '', NULL, NULL, NULL, NULL, ''),
(2050, 'keep_hidden', '', '', NULL, NULL, NULL, NULL, ''),
(2051, 'show_when_exam_is_finished', '', '', NULL, NULL, NULL, NULL, ''),
(2052, '15_minutes_after_finished', '', '', NULL, NULL, NULL, NULL, ''),
(2053, '30_minutes_after_finished', '', '', NULL, NULL, NULL, NULL, ''),
(2058, 'edit_delivery', '', '', NULL, NULL, NULL, NULL, ''),
(2059, 'are_you_sure', '', '', NULL, NULL, NULL, NULL, ''),
(2062, 'your_comment', '', '', NULL, NULL, NULL, NULL, ''),
(2063, 'your_submitted_files', '', '', NULL, NULL, NULL, NULL, ''),
(2304, 'have_seen_this_post', '', '', NULL, NULL, NULL, NULL, ''),
(2405, 'your_chats_groups', '', '', NULL, NULL, NULL, NULL, ''),
(2454, 'chat_groups', '', '', NULL, NULL, NULL, NULL, ''),
(2537, 'manage_attendance', '', '', NULL, NULL, NULL, NULL, ''),
(2540, 'teachers_attendance', '', '', NULL, NULL, NULL, NULL, ''),
(2980, 'your_other_live_classes', '', '', NULL, NULL, NULL, NULL, ''),
(2981, 'solved', '', '', NULL, NULL, NULL, NULL, ''),
(2986, 'new_invoice_has_been_generated_for', '', '', NULL, NULL, NULL, NULL, ''),
(2987, 'update_invoice', '', '', NULL, NULL, NULL, NULL, ''),
(2988, 'descrition', '', '', NULL, NULL, NULL, NULL, ''),
(2989, 'update_category', '', '', NULL, NULL, NULL, NULL, ''),
(2990, 'udate', '', '', NULL, NULL, NULL, NULL, ''),
(2991, 'update_expense', '', '', NULL, NULL, NULL, NULL, ''),
(2992, 'update_grade_level', '', '', NULL, NULL, NULL, NULL, ''),
(2997, 'show_questions_randomly', '', '', NULL, NULL, NULL, NULL, ''),
(3020, 'ask_for_results', '', '', NULL, NULL, NULL, NULL, ''),
(3021, 'waiting_for_results', '', '', NULL, NULL, NULL, NULL, ''),
(3154, 'your_child', '', '', NULL, NULL, NULL, NULL, ''),
(3155, 'is_absent_today', '', '', NULL, NULL, NULL, NULL, ''),
(3188, 'users_seen_this_post', '', '', NULL, NULL, NULL, NULL, ''),
(3201, 'students_seen_this_post', '', '', NULL, NULL, NULL, NULL, ''),
(3613, 'approve', '', '', NULL, NULL, NULL, NULL, ''),
(3614, 'request_accepted_successfully', '', '', NULL, NULL, NULL, NULL, ''),
(3615, 'no_actions_available', '', '', NULL, NULL, NULL, NULL, '');

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

--
-- Estructura de tabla para la tabla `librarian`
--

CREATE TABLE IF NOT EXISTS `librarian` (
  `librarian_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(300) NOT NULL,
  `email` varchar(300) DEFAULT NULL,
  `password` varchar(300) NOT NULL,
  `phone` varchar(300) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  `username` varchar(300) NOT NULL,
  `fb_token` longtext DEFAULT NULL,
  `fb_id` longtext DEFAULT NULL,
  `fb_photo` longtext DEFAULT NULL,
  `fb_name` longtext DEFAULT NULL,
  `g_oauth` longtext DEFAULT NULL,
  `g_fname` longtext DEFAULT NULL,
  `femail` longtext DEFAULT NULL,
  `g_lname` longtext DEFAULT NULL,
  `g_picture` longtext DEFAULT NULL,
  `link` longtext DEFAULT NULL,
  `g_email` longtext DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `last_name` varchar(200) DEFAULT NULL,
  `gender` varchar(200) DEFAULT NULL,
  `idcard` varchar(200) DEFAULT NULL,
  `since` varchar(20) DEFAULT NULL,
  `birthday` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`librarian_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `live`
--

CREATE TABLE IF NOT EXISTS `live` (
  `live_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(600) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `time` varchar(200) DEFAULT NULL,
  `user_type` varchar(200) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `year` varchar(200) DEFAULT NULL,
  `wall_type` varchar(200) DEFAULT NULL,
  `publish_date` varchar(300) DEFAULT NULL,
  `upload_date` varchar(300) DEFAULT NULL,
  `room` longtext DEFAULT NULL,
  `siteUrl` longtext DEFAULT NULL,
  `liveType` int(11) DEFAULT NULL,
  PRIMARY KEY (`live_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `live_status`
--

CREATE TABLE IF NOT EXISTS `live_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(300) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `live_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `mark`
--

CREATE TABLE IF NOT EXISTS `mark` (
  `mark_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `mark_obtained` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mark_total` int(11) NOT NULL DEFAULT 100,
  `comment` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci NOT NULL,
  `labuno` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labdos` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labtres` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labcuatro` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labcinco` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labseis` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labsiete` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labocho` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labnueve` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `labtotal` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `final` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`mark_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `mensaje_reporte`
--

CREATE TABLE IF NOT EXISTS `mensaje_reporte` (
  `news_message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` longtext COLLATE utf8_unicode_ci NOT NULL,
  `news_id` int(11) NOT NULL,
  `date` longtext COLLATE utf8_unicode_ci NOT NULL,
  `user_type` longtext COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`news_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `message`
--

CREATE TABLE IF NOT EXISTS `message` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_thread_code` longtext NOT NULL,
  `message` longtext NOT NULL,
  `sender` longtext NOT NULL,
  `timestamp` longtext NOT NULL,
  `read_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 unread 1 read',
  `file_name` longtext DEFAULT NULL,
  `reciever` varchar(200) DEFAULT NULL,
  `file_type` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `message_thread`
--

CREATE TABLE IF NOT EXISTS `message_thread` (
  `message_thread_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_thread_code` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sender` longtext COLLATE utf8_unicode_ci NOT NULL,
  `reciever` longtext COLLATE utf8_unicode_ci NOT NULL,
  `last_message_timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`message_thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_code` longtext COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `date2` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `publish_date` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `embed` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `notice_message`
--

CREATE TABLE IF NOT EXISTS `notice_message` (
  `notice_message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notice_id` int(11) NOT NULL,
  `date` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `message_file_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`notice_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `notification`
--

CREATE TABLE IF NOT EXISTS `notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_type` varchar(200) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL,
  `time` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT 0,
  `notify` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `original_id` int(11) DEFAULT NULL,
  `original_type` varchar(200) DEFAULT NULL,
  `url` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(200) DEFAULT NULL,
  `class_id` int(11) DEFAULT 0,
  `subject_id` int(11) DEFAULT 0,
  `year` varchar(20) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `online_exam`
--

CREATE TABLE IF NOT EXISTS `online_exam` (
  `online_exam_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `title` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `exam_date` int(11) DEFAULT NULL,
  `time_start` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_end` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `duration` text COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'duration in second',
  `minimum_percentage` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `instruction` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'pending',
  `running_year` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `wall_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `publish_date` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uploader_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uploader_id` int(11) DEFAULT NULL,
  `upload_date` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `results` int(11) DEFAULT 0,
  `show_random` int(11) DEFAULT 0,
  PRIMARY KEY (`online_exam_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `online_exam_result`
--

CREATE TABLE IF NOT EXISTS `online_exam_result` (
  `online_exam_result_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `online_exam_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `answer_script` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `obtained_mark` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `exam_started_timestamp` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `result` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`online_exam_result_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `online_users`
--

CREATE TABLE IF NOT EXISTS `online_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `session` longtext NOT NULL,
  `time` longtext NOT NULL,
  `id_usuario` int(11) DEFAULT NULL,
  `type` longtext NOT NULL,
  `gp` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `parent`
--

CREATE TABLE IF NOT EXISTS `parent` (
  `parent_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` longtext COLLATE utf8_unicode_ci NOT NULL,
  `password` longtext COLLATE utf8_unicode_ci NOT NULL,
  `phone` longtext COLLATE utf8_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8_unicode_ci NOT NULL,
  `profession` longtext COLLATE utf8_unicode_ci NOT NULL,
  `username` longtext COLLATE utf8_unicode_ci NOT NULL,
  `gender` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `business` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idcard` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `business_phone` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `home_phone` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_token` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_id` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_photo` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_name` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_oauth` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_fname` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `femail` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_lname` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_picture` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_email` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `since` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `payment`
--

CREATE TABLE IF NOT EXISTS `payment` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_category_id` int(11) DEFAULT NULL,
  `title` longtext COLLATE utf8_unicode_ci NOT NULL,
  `payment_type` longtext COLLATE utf8_unicode_ci NOT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `method` longtext COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `amount` longtext COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
  `year` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `month` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `pending_users`
--

CREATE TABLE IF NOT EXISTS `pending_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `last_name` varchar(200) DEFAULT NULL,
  `birthday` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `profession` varchar(200) DEFAULT NULL,
  `sex` varchar(200) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `type` varchar(10) NOT NULL,
  `roll` varchar(200) DEFAULT NULL,
  `since` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `polls`
--

CREATE TABLE IF NOT EXISTS `polls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `options` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(100) NOT NULL,
  `user` varchar(100) NOT NULL,
  `poll_code` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date2` varchar(200) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `publish_date` varchar(20) DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `poll_response`
--

CREATE TABLE IF NOT EXISTS `poll_response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_code` varchar(100) NOT NULL,
  `answer` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(100) NOT NULL,
  `user` varchar(100) NOT NULL,
  `date2` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `question_bank`
--

CREATE TABLE IF NOT EXISTS `question_bank` (
  `question_bank_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `online_exam_id` int(11) DEFAULT NULL,
  `question_title` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `number_of_options` int(11) DEFAULT NULL,
  `options` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `correct_answers` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `mark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`question_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `question_paper`
--

CREATE TABLE IF NOT EXISTS `question_paper` (
  `question_paper_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `question_paper` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `exam_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`question_paper_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `readed`
--

CREATE TABLE IF NOT EXISTS `readed` (
  `readed_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_type` varchar(50) DEFAULT NULL,
  `activity_code` varchar(50) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`readed_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `reporte_alumnos`
--

CREATE TABLE IF NOT EXISTS `reporte_alumnos` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `report_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `priority` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `student_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) DEFAULT 0,
  `file` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `reporte_mensaje`
--

CREATE TABLE IF NOT EXISTS `reporte_mensaje` (
  `report_message_id` int(11) NOT NULL AUTO_INCREMENT,
  `report_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `message` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sender_type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sender_id` int(11) NOT NULL,
  `timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`report_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `reports`
--

CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `user_id` varchar(600) NOT NULL,
  `title` longtext NOT NULL,
  `description` longtext NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `priority` varchar(100) NOT NULL,
  `file` longtext DEFAULT NULL,
  `status` int(11) NOT NULL,
  `date` varchar(600) NOT NULL,
  `code` varchar(600) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `report_response`
--

CREATE TABLE IF NOT EXISTS `report_response` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` longtext NOT NULL,
  `date` varchar(600) NOT NULL,
  `report_code` varchar(100) NOT NULL,
  `sender_type` varchar(100) NOT NULL,
  `sender_id` int(11) NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `request`
--

CREATE TABLE IF NOT EXISTS `request` (
  `request_id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` int(11) NOT NULL,
  `start_date` longtext COLLATE utf8_unicode_ci NOT NULL,
  `end_date` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = pending, 1 = accepted, 2 = rejected',
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `title` longtext COLLATE utf8_unicode_ci NOT NULL,
  `file` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `section`
--

CREATE TABLE IF NOT EXISTS `section` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `class_id` int(11) NOT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `settings`
--

INSERT INTO `settings` (`settings_id`, `type`, `description`) VALUES
(1, 'system_name', 'EduAppGT PRO'),
(2, 'system_title', 'School Management System'),
(3, 'address', 'Guatemala City'),
(4, 'phone', '00000000'),
(5, 'paypal_email', 'admin@paypal.com'),
(6, 'currency', '$'),
(7, 'system_email', 'cool@eduappgt.com'),
(20, 'municipio', NULL),
(11, 'language', 'english'),
(13, 'minimark', '50'),
(16, 'timezone', 'America/Guatemala'),
(18, 'msg91_code', '0'),
(21, 'running_year', '2021'),
(22, 'facebook', 'https://facebook.com/google'),
(23, 'twitter', 'https://twitter.com/google'),
(24, 'instagram', 'https://instagram.com/google'),
(25, 'youtube', 'https://youtube.com/google'),
(26, 'sms_status', '0'),
(27, 'msg91_key', NULL),
(28, 'msg91_sender', NULL),
(29, 'msg91_route', NULL),
(30, 'buyer', NULL),
(31, 'purchase_code', NULL),
(32, 'clickatell_username', NULL),
(33, 'clickatell_password', NULL),
(34, 'clickatell_api', NULL),
(35, 'twilio_account', NULL),
(36, 'authentication_token', NULL),
(37, 'registered_phone', NULL),
(38, 'absences', NULL),
(39, 'students_reports', NULL),
(40, 'p_new_invoice', NULL),
(41, 's_new_invoice', '1'),
(42, 'new_homework', NULL),
(43, 'register', '1'),
(44, 'facebook_sync', ''),
(45, 'google_sync', 'gooogle_client_id'),
(46, 'facebook_login', ''),
(47, 'google_login', 'gooogle_secret'),
(48, 'social_login', '1'),
(49, 'favicon', '63f1ed995b376666a593b00cdb32d5ddfavicon.png'),
(50, 'logow', '8231ae739c7bd4a126c4c7f3d1685e6elogo-white.png'),
(51, 'logo', '63f1ed995b376666a593b00cdb32d5dd0564fea78adf8acf191ec32910140a6blogo.png'),
(52, 'logocolor', '6ec8d3ab0e71c79bb4805a22fabbdd00logo-color.png'),
(53, 'icon_white', '63f1ed995b376666a593b00cdb32d5ddlogo-icon.png'),
(55, 'bglogin', '3ad1f8ca3f9012765ce53ca8ef6dca57math.svg'),
(56, 'date_format', 'm/d'),
(57, 'calendar', 'en'),
(58, 'logs', '0'),
(59, 'stat', '0'),
(60, 'protocol', NULL),
(61, 'smtp_host', NULL),
(62, 'smtp_port', NULL),
(63, 'smtp_user', NULL),
(64, 'smtp_pass', NULL),
(65, 'charset', NULL);

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

--
-- Estructura de tabla para la tabla `student`
--

CREATE TABLE IF NOT EXISTS `student` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` text CHARACTER SET utf8 NOT NULL,
  `birthday` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `sex` longtext COLLATE utf8_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` longtext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `dormitory_id` int(11) DEFAULT NULL,
  `transport_id` int(11) DEFAULT NULL,
  `student_session` int(11) NOT NULL DEFAULT 1,
  `username` longtext COLLATE utf8_unicode_ci NOT NULL,
  `date` longtext COLLATE utf8_unicode_ci NOT NULL,
  `board` int(11) DEFAULT 0,
  `fb_token` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_id` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_photo` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_name` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_oauth` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_fname` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `femail` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_lname` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_picture` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_email` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `solvencia` int(11) NOT NULL DEFAULT 1,
  `class_id` int(11) NOT NULL,
  `image` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `since` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `diseases` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allergies` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `doctor` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `doctor_phone` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authorized_person` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authorized_phone` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `students_request`
--

CREATE TABLE IF NOT EXISTS `students_request` (
  `request_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `start_date` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `end_date` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `subject`
--

CREATE TABLE IF NOT EXISTS `subject` (
  `subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `class_id` int(11) NOT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci NOT NULL,
  `la1` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 1.',
  `la2` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 2.',
  `la3` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 3.',
  `la4` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 4.',
  `la5` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 5.',
  `la6` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 6.',
  `la7` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 7.',
  `la8` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 8.',
  `la9` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 9.',
  `la10` varchar(500) COLLATE utf8_unicode_ci DEFAULT 'Lab 10.',
  `type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `section_id` int(11) NOT NULL,
  `color` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `about` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `teacher`
--

CREATE TABLE IF NOT EXISTS `teacher` (
  `teacher_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `sex` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `birthday` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `idcard` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `token` varchar(600) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_code` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_token` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_id` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_photo` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fb_name` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_oauth` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_fname` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `femail` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_lname` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_picture` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `g_email` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `since` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `teacher_attendance`
--

CREATE TABLE IF NOT EXISTS `teacher_attendance` (
  `attendance_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` longtext NOT NULL,
  `year` longtext NOT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`attendance_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `ticket`
--

CREATE TABLE IF NOT EXISTS `ticket` (
  `ticket_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ticket_code` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'opened closed',
  `priority` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'baja media alta',
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `student_id` int(11) NOT NULL,
  `assigned_staff_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ticket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `ticket_message`
--

CREATE TABLE IF NOT EXISTS `ticket_message` (
  `ticket_message_id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_code` longtext COLLATE utf8_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8_unicode_ci NOT NULL,
  `file` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sender_type` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sender_id` int(11) NOT NULL,
  `timestamp` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ticket_message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `transport`
--

CREATE TABLE IF NOT EXISTS `transport` (
  `transport_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `number_of_vehicle` longtext COLLATE utf8_unicode_ci NOT NULL,
  `route_fare` longtext COLLATE utf8_unicode_ci NOT NULL,
  `driver_name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `driver_phone` longtext COLLATE utf8_unicode_ci NOT NULL,
  `route` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`transport_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
COMMIT;

