-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 22-11-2010 a las 18:16:14
-- Versión del servidor: 5.1.41
-- Versión de PHP: 5.3.1
SET FOREIGN_KEY_CHECKS =0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de datos: 'RUTADEMIC'
--

--
-- Volcar la base de datos para la tabla 'academic_area'
--

INSERT INTO academic_area (serial_aca, name_aca, description_aca, status_aca) VALUES
(1, 'Matemáticas', 'pura mate', 'ACTIVE'),
(2, 'Química', 'pura quimica', 'ACTIVE'),
(3, 'Artes', 'Pura arte', 'ACTIVE'),
(4, 'Actividades Prácticas', 'inactivo para prruebas\r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE'),
(5, 'Sociales', 'Área de Sociales', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'activity'
--


--
-- Volcar la base de datos para la tabla 'activity_applied_criterias'
--


--
-- Volcar la base de datos para la tabla 'activity_attachment'
--


--
-- Volcar la base de datos para la tabla 'activity_type'
--

INSERT INTO activity_type (serial_att, name_att, description_att, status_att) VALUES
(1, 'Disciplina', 'Disciplina', 'ACTIVE'),
(2, 'Prueba', 'Típica prueba', 'ACTIVE'),
(3, 'Examen', 'examen mortal', 'ACTIVE'),
(4, 'Deber', 'tareas diarias', 'ACTIVE'),
(5, 'Examen Final', 'Exámen Final', 'INACTIVE'),
(6, 'Supletorio', 'Supletorios\r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'ACTIVE'),
(7, 'Deber Mañana', 'Deberes para mañana', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'allowed_pages_by_process'
--


--
-- Volcar la base de datos para la tabla 'article'
--

INSERT INTO article (serial_art, code_art, name_art, stock_art, status_art) VALUES
(1, 'ART-001', 'Mesas', 100, 'INACTIVE'),
(2, 'ART-002', 'Calentador #40', 25, 'ACTIVE'),
(3, 'ART-003', 'Busos Colegio', 5, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'authority'
--

INSERT INTO authority (serial_aut, serial_atc, degree_aut, first_name_aut, last_name_aut, in_charge_aut) VALUES
(1, 1, 'Médico', 'Andrés José', 'Londoño', 'YES'),
(2, 2, 'Ingeniero', 'Fermín', 'Miño', 'NO');

--
-- Volcar la base de datos para la tabla 'authority_charge'
--

INSERT INTO authority_charge (serial_atc, name_atc, description_atc, status_atc) VALUES
(1, 'Réctor', 'Señor Rector', 'ACTIVE'),
(2, 'Supervisor División', 'encargado mañana', 'ACTIVE'),
(3, 'Sub-Rector', 'Sub-rector &lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'bus'
--

INSERT INTO bus (serial_bus, code_bus, plate_num_bus, description_bus, capacity_bus, status_bus) VALUES
(1, 'BU001', 'GYB-206', 'asdasdasd', 0, 'ACTIVE'),
(2, 'BU-002', 'PTZ-208', 'asdasdasdsad', 0, 'ACTIVE'),
(3, 'B-003', 'ppp-555', '&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 100, 'ACTIVE'),
(4, 'B-002', 'ppp-556', '&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 100, 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'bus_driver'
--

INSERT INTO bus_driver (serial_bdr, id_bdr, first_name_bdr, last_name_bdr, mobile1_bdr, mobile2_bdr, phone1_bdr, phone2_bdr, phone3_bdr, address_bdr, drive_license_bdr, license_expire_date_bdr, status_bdr) VALUES
(1, '0103438180', 'Nelson', 'Fury', '223332', '', '222222222', '', '', 'asdasdasdasd', 'Profesional', '2010-10-20', 'ACTIVE'),
(2, '1715492656', 'Nick', 'Mandela', '223332', '', '232323', '', '', 'asdasdasdad', 'Profesional', '2010-10-30', 'ACTIVE'),
(3, 'c3', 'Perico', 'De los Palotes', '123456', '', '123465', '', '', 'jsdkalfjlasdadsf\r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'aaa', '2010-11-20', 'INACTIVE'),
(4, 'c4', 'Juan', 'Piwaver', '1345679', '', '413465', '', '', 'jdflkajsfoijsadlf áááá', 'asdad áá', '2010-11-24', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'bus_shift_year'
--


--
-- Volcar la base de datos para la tabla 'bus_year_user'
--


--
-- Volcar la base de datos para la tabla 'cat_period'
--

INSERT INTO cat_period (serial_cpd, name_cpd, description_cpd, status_cpd) VALUES
(1, 'Semestre', 'de a 6 meses', 'ACTIVE'),
(2, 'Bimestre', 'de a 2 mesess', 'ACTIVE'),
(3, 'Categoría Inactiva', 'debe estar inactiva para la prueba \r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'cat_subject'
--

INSERT INTO cat_subject (serial_csb, cat_serial_csb, serial_aca, serial_lng, code_csb, name_csb, status_csb) VALUES
(1, NULL, 3, 1, 'ART001', 'Música', 'ACTIVE'),
(2, 1, 3, 1, 'ART001-1', 'Oboe', 'ACTIVE'),
(3, 1, 3, 1, 'ART001-2', 'percusión', 'ACTIVE'),
(4, NULL, 1, 1, 'MAT001', 'matemática Básica', 'ACTIVE'),
(5, NULL, 2, 1, 'QUI001', 'Química Orgánica', 'ACTIVE'),
(6, 5, 2, 1, 'QUI001-1', 'Teoría', 'ACTIVE'),
(7, 5, 2, 1, 'QUI001-2', 'Práctica', 'ACTIVE'),
(8, NULL, 3, 1, 'ART-01-01', 'Música Clásica', 'ACTIVE'),
(9, NULL, 3, 1, 'ART-01-02', 'Pandereta', 'INACTIVE'),
(10, 9, 3, 1, 'ART-01-02-1', 'Principiante', 'INACTIVE'),
(11, 9, 3, 1, 'ART-01-02-2', 'Avanzado', 'INACTIVE'),
(12, NULL, 5, 1, 'S-001', 'Historia', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'classroom'
--

INSERT INTO classroom (serial_clr, name_clr, capacity_clr, description_clr, status_clr) VALUES
(1, 'JA001', 30, 'jaula primerita', 'ACTIVE'),
(2, 'JA002', 45, 'la mayor jaula', 'ACTIVE'),
(3, 'JA003', 100, 'la más grande \r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'class_group'
--

INSERT INTO class_group (serial_clg, name_clg, description_clg, status_clg) VALUES
(1, 'A', 'aaaaaaaaa', 'ACTIVE'),
(2, 'B', 'bbbbbbbbbbbbb', 'ACTIVE'),
(3, 'C', 'ccccccccccccccccc', 'ACTIVE'),
(4, 'D', 'el d quedará inactivo', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'country'
--

INSERT INTO country (serial_cou, name_cou, status_cou) VALUES
(1, 'Andorra', 'ACTIVE'),
(2, 'United arab emirates', 'ACTIVE'),
(3, 'Afghanistan', 'INACTIVE'),
(4, 'Antigua and barbuda', 'ACTIVE'),
(5, 'Anguilla', 'ACTIVE'),
(6, 'Albania', 'INACTIVE'),
(7, 'Armenia', 'ACTIVE'),
(8, 'Netherlands antilles', 'ACTIVE'),
(9, 'Angola', 'ACTIVE'),
(10, 'Antarctica', 'ACTIVE'),
(11, 'Argentina', 'ACTIVE'),
(12, 'Americansamoa', 'ACTIVE'),
(13, 'Austria', 'ACTIVE'),
(14, 'Australia', 'ACTIVE'),
(15, 'Aruba', 'ACTIVE'),
(16, 'Azerbaijan', 'ACTIVE'),
(17, 'Bosnia and herzegovina', 'ACTIVE'),
(18, 'Barbados', 'ACTIVE'),
(19, 'Bangladesh', 'ACTIVE'),
(20, 'Belgium', 'ACTIVE'),
(21, 'Burkinafaso', 'ACTIVE'),
(22, 'Bulgaria', 'ACTIVE'),
(23, 'Bahrain', 'ACTIVE'),
(24, 'Burundi', 'ACTIVE'),
(25, 'Benin', 'ACTIVE'),
(26, 'Bermuda', 'ACTIVE'),
(27, 'Bruneida russalam', 'ACTIVE'),
(28, 'Bolivia', 'ACTIVE'),
(29, 'Brazil', 'ACTIVE'),
(30, 'Bahamas', 'ACTIVE'),
(31, 'Bhutan', 'ACTIVE'),
(32, 'Bouvetisland', 'ACTIVE'),
(33, 'Botswana', 'ACTIVE'),
(34, 'Belarus', 'ACTIVE'),
(35, 'Belize', 'ACTIVE'),
(36, 'Canada', 'ACTIVE'),
(37, 'Cocos(keeling)islands', 'ACTIVE'),
(38, 'Congo', 'ACTIVE'),
(39, 'Central african republic', 'ACTIVE'),
(40, 'Congo', 'ACTIVE'),
(41, 'Switzerland', 'ACTIVE'),
(42, 'Coted''ivoire', 'ACTIVE'),
(43, 'Cookislands', 'ACTIVE'),
(44, 'Chile', 'ACTIVE'),
(45, 'Cameroon', 'ACTIVE'),
(46, 'China', 'ACTIVE'),
(47, 'Colombia', 'ACTIVE'),
(48, 'Costarica', 'ACTIVE'),
(49, 'Serbia and montenegro', 'ACTIVE'),
(50, 'Cuba', 'ACTIVE'),
(51, 'Capeverde', 'ACTIVE'),
(52, 'Christmas island', 'ACTIVE'),
(53, 'Cyprus', 'ACTIVE'),
(54, 'Czech republic', 'ACTIVE'),
(55, 'Germany', 'ACTIVE'),
(56, 'Djibouti', 'ACTIVE'),
(57, 'Denmark', 'ACTIVE'),
(58, 'Dominica', 'ACTIVE'),
(59, 'Dominican republic', 'ACTIVE'),
(60, 'Algeria', 'INACTIVE'),
(61, 'Ecuador', 'ACTIVE'),
(62, 'Estonia', 'ACTIVE'),
(63, 'Egypt', 'ACTIVE'),
(64, 'Western sahara', 'ACTIVE'),
(65, 'Eritrea', 'ACTIVE'),
(66, 'Spain', 'ACTIVE'),
(67, 'Ethiopia', 'ACTIVE'),
(68, 'Finland', 'ACTIVE'),
(69, 'Fiji', 'ACTIVE'),
(70, 'Micronesia', 'ACTIVE'),
(71, 'Faroe islands', 'ACTIVE'),
(72, 'France', 'ACTIVE'),
(73, 'Gabon', 'ACTIVE'),
(74, 'United kingdom', 'ACTIVE'),
(75, 'Grenada', 'ACTIVE'),
(76, 'Georgia', 'ACTIVE'),
(77, 'French guiana', 'ACTIVE'),
(78, 'Ghana', 'ACTIVE'),
(79, 'Gibraltar', 'ACTIVE'),
(80, 'Greenland', 'ACTIVE'),
(81, 'Gambia', 'ACTIVE'),
(82, 'Guinea', 'ACTIVE'),
(83, 'Guadeloupe', 'ACTIVE'),
(84, 'Equatorial guinea', 'ACTIVE'),
(85, 'Greece', 'ACTIVE'),
(86, 'Guatemala', 'ACTIVE'),
(87, 'Guam', 'ACTIVE'),
(88, 'Guinea-bissau', 'ACTIVE'),
(89, 'Guyana', 'ACTIVE'),
(90, 'Hong kong', 'ACTIVE'),
(91, 'Honduras', 'ACTIVE'),
(92, 'Croatia', 'ACTIVE'),
(93, 'Haiti', 'ACTIVE'),
(94, 'Hungary', 'ACTIVE'),
(95, 'Indonesia', 'ACTIVE'),
(96, 'Ireland', 'ACTIVE'),
(97, 'Israel', 'ACTIVE'),
(98, 'India', 'ACTIVE'),
(99, 'Iraq', 'ACTIVE'),
(100, 'Iran,islamic republic of', 'ACTIVE'),
(101, 'Iceland', 'ACTIVE'),
(102, 'Italy', 'ACTIVE'),
(103, 'Jamaica', 'ACTIVE'),
(104, 'Jordan', 'ACTIVE'),
(105, 'Japan', 'ACTIVE'),
(106, 'Kenya', 'ACTIVE'),
(107, 'Kyrgyzstan', 'ACTIVE'),
(108, 'Cambodia', 'ACTIVE'),
(109, 'Kiribati', 'ACTIVE'),
(110, 'Comoros', 'ACTIVE'),
(111, 'Saint kitts and nevis', 'ACTIVE'),
(112, 'Korea', 'ACTIVE'),
(113, 'Korea,republic of', 'ACTIVE'),
(114, 'Kuwait', 'ACTIVE'),
(115, 'Cayman islands', 'ACTIVE'),
(116, 'Kazakhstan', 'ACTIVE'),
(117, 'Lao', 'ACTIVE'),
(118, 'Lebanon', 'ACTIVE'),
(119, 'Saint lucia', 'ACTIVE'),
(120, 'Liechtenstein', 'ACTIVE'),
(121, 'Srilanka', 'ACTIVE'),
(122, 'Liberia', 'ACTIVE'),
(123, 'Lesotho', 'ACTIVE'),
(124, 'Lithuania', 'ACTIVE'),
(125, 'Luxembourg', 'ACTIVE'),
(126, 'Latvia', 'ACTIVE'),
(127, 'Libyanarabjamahiriya', 'ACTIVE'),
(128, 'Morocco', 'ACTIVE'),
(129, 'Monaco', 'ACTIVE'),
(130, 'Moldova,republic of', 'ACTIVE'),
(131, 'Madagascar', 'ACTIVE'),
(132, 'Marshall islands', 'ACTIVE'),
(133, 'Macedonia', 'ACTIVE'),
(134, 'Mali', 'ACTIVE'),
(135, 'Myanmar', 'ACTIVE'),
(136, 'Mongolia', 'ACTIVE'),
(137, 'Macao', 'ACTIVE'),
(138, 'Northern mariana islands', 'ACTIVE'),
(139, 'Martinique', 'ACTIVE'),
(140, 'Mauritania', 'ACTIVE'),
(141, 'Montserrat', 'ACTIVE'),
(142, 'Malta', 'ACTIVE'),
(143, 'Mauritius', 'ACTIVE'),
(144, 'Maldives', 'ACTIVE'),
(145, 'Malawi', 'ACTIVE'),
(146, 'Mexico', 'ACTIVE'),
(147, 'Malaysia', 'ACTIVE'),
(148, 'Mozambique', 'ACTIVE'),
(149, 'Namibia', 'ACTIVE'),
(150, 'New caledonia', 'ACTIVE'),
(151, 'Niger', 'ACTIVE'),
(152, 'Norfolk island', 'ACTIVE'),
(153, 'Nigeria', 'ACTIVE'),
(154, 'Nicaragua', 'ACTIVE'),
(155, 'Netherlands', 'ACTIVE'),
(156, 'Norway', 'ACTIVE'),
(157, 'Nepal', 'ACTIVE'),
(158, 'Nauru', 'ACTIVE'),
(159, 'Niue', 'ACTIVE'),
(160, 'New zealand', 'ACTIVE'),
(161, 'Oman', 'ACTIVE'),
(162, 'Panama', 'ACTIVE'),
(163, 'Peru', 'ACTIVE'),
(164, 'French polynesia', 'ACTIVE'),
(165, 'Papua new guinea', 'ACTIVE'),
(166, 'Philippines', 'ACTIVE'),
(167, 'Pakistan', 'ACTIVE'),
(168, 'Poland', 'ACTIVE'),
(169, 'Saint pierre and miquelon', 'ACTIVE'),
(170, 'Pitcairn', 'ACTIVE'),
(171, 'Puerto rico', 'ACTIVE'),
(172, 'Palestina', 'ACTIVE'),
(173, 'Portugal', 'ACTIVE'),
(174, 'Palau', 'ACTIVE'),
(175, 'Paraguay', 'ACTIVE'),
(176, 'Qatar', 'ACTIVE'),
(177, 'Reunion', 'ACTIVE'),
(178, 'Romania', 'ACTIVE'),
(179, 'Russian federation', 'ACTIVE'),
(180, 'Rwanda', 'ACTIVE'),
(181, 'Saudi arabia', 'ACTIVE'),
(182, 'Solomon islands', 'ACTIVE'),
(183, 'Seychelles', 'ACTIVE'),
(184, 'Sudan', 'ACTIVE'),
(185, 'Sweden', 'ACTIVE'),
(186, 'Singapore', 'ACTIVE'),
(187, 'Saint helena', 'ACTIVE'),
(188, 'Slovenia', 'ACTIVE'),
(189, 'Svalbard and janmayen', 'ACTIVE'),
(190, 'Slovakia', 'ACTIVE'),
(191, 'Sierra leone', 'ACTIVE'),
(192, 'San marino', 'ACTIVE'),
(193, 'Senegal', 'ACTIVE'),
(194, 'Somalia', 'ACTIVE'),
(195, 'Suriname', 'ACTIVE'),
(196, 'Saotome and principe', 'ACTIVE'),
(197, 'El salvador', 'ACTIVE'),
(198, 'Syrian arab republic', 'ACTIVE'),
(199, 'Swaziland', 'ACTIVE'),
(200, 'Turks and caicos islands', 'ACTIVE'),
(201, 'Chad', 'ACTIVE'),
(202, 'Togo', 'ACTIVE'),
(203, 'Thailand', 'ACTIVE'),
(204, 'Tajikistan', 'ACTIVE'),
(205, 'Tokelau', 'ACTIVE'),
(206, 'Timor-leste', 'ACTIVE'),
(207, 'Turkmenistan', 'ACTIVE'),
(208, 'Tunisia', 'ACTIVE'),
(209, 'Tonga', 'ACTIVE'),
(210, 'Turkey', 'ACTIVE'),
(211, 'Trinidad and tobago', 'ACTIVE'),
(212, 'Tuvalu', 'ACTIVE'),
(213, 'Taiwan,province of china', 'ACTIVE'),
(214, 'Tanzania,united republic of', 'ACTIVE'),
(215, 'Ukraine', 'ACTIVE'),
(216, 'Uganda', 'ACTIVE'),
(217, 'United states', 'ACTIVE'),
(218, 'Uruguay', 'ACTIVE'),
(219, 'Uzbekistan', 'ACTIVE'),
(220, 'Holysee(vatican city state)', 'ACTIVE'),
(221, 'Venezuela', 'ACTIVE'),
(222, 'Virgin islands,british', 'ACTIVE'),
(223, 'Virgin islands,u.s.', 'ACTIVE'),
(224, 'Vietnam', 'ACTIVE'),
(225, 'Vanuatu', 'ACTIVE'),
(226, 'Wallis and futuna', 'ACTIVE'),
(227, 'Samoa', 'ACTIVE'),
(228, 'Yemen', 'ACTIVE'),
(229, 'Mayotte', 'ACTIVE'),
(230, 'South africa', 'ACTIVE'),
(231, 'Zambia', 'ACTIVE'),
(232, 'Zimbabwe', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'course'
--

INSERT INTO course (serial_crs, serial_clg, serial_spt, serial_lvl, serial_scy, serial_set, attendance_crs, status_crs) VALUES
(1, 1, 1, 2, 2, 1, 'DAY', 'ACTIVE'),
(2, 2, 1, 2, 2, 1, 'DAY', 'ACTIVE'),
(3, 3, 1, 2, 2, 1, 'DAY', 'ACTIVE'),
(4, 1, 2, 1, 2, 2, 'CLASS', 'ACTIVE'),
(5, 2, 2, 1, 2, 2, 'CLASS', 'ACTIVE'),
(6, 3, 4, 1, 2, 2, 'DAY', 'ACTIVE'),
(7, 2, 4, 3, 2, 2, 'CLASS', 'ACTIVE'),
(8, 3, 4, 3, 2, 2, 'CLASS', 'ACTIVE'),
(9, 1, 2, 3, 2, 2, 'CLASS', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'currency'
--

INSERT INTO currency (serial_crr, abrevation_crr, name_crr, status_crr) VALUES
(1, 'ARS', 'Argentine Peso', 'ACTIVE'),
(2, 'AUD', 'Australian Dollar', 'ACTIVE'),
(3, 'BHD', 'Bahrain Dinar', 'ACTIVE'),
(4, 'BWP', 'Botswana Pula', 'ACTIVE'),
(5, 'BRL', 'Brazilian Real', 'ACTIVE'),
(6, 'BND', 'Brunei Dollar', 'ACTIVE'),
(7, 'CAD', 'Canadian Dollar', 'ACTIVE'),
(8, 'CLP', 'Chilean Peso', 'ACTIVE'),
(9, 'CNY', 'Chinese Yuan', 'ACTIVE'),
(10, 'COP', 'Colombian Peso', 'ACTIVE'),
(11, 'CYP', 'Cyprus Pound', 'ACTIVE'),
(12, 'CZK', 'Czech Koruna', 'ACTIVE'),
(13, 'DKK', 'Danish Krone', 'ACTIVE'),
(14, 'EUR', 'Euro', 'ACTIVE'),
(15, 'HUF', 'Hungarian Forint', 'ACTIVE'),
(16, 'ISK', 'Icelandic Krona', 'ACTIVE'),
(17, 'INR', 'Indian Rupee', 'ACTIVE'),
(18, 'IDR', 'Indonesian Rupiah', 'ACTIVE'),
(19, 'IRR', 'Iranian Rial', 'ACTIVE'),
(20, 'ILS', 'Israeli New Sheqel', 'ACTIVE'),
(21, 'JPY', 'Japanese Yen', 'ACTIVE'),
(22, 'KRW', 'Korean Won', 'ACTIVE'),
(23, 'KWD', 'Kuwaiti Dinar', 'ACTIVE'),
(24, 'LYD', 'Libyan Dinar', 'ACTIVE'),
(25, 'MYR', 'Malaysian Ringgit', 'ACTIVE'),
(26, 'MTL', 'Maltese Lira', 'ACTIVE'),
(27, 'MUR', 'Mauritian Rupee', 'ACTIVE'),
(28, 'MXN', 'Mexican Peso', 'ACTIVE'),
(29, 'NPR', 'Nepalese Rupee', 'ACTIVE'),
(30, 'NZD', 'New Zealand Dollar', 'ACTIVE'),
(31, 'NOK', 'Norwegian Krone', 'ACTIVE'),
(32, 'OMR', 'Omani Rial', 'ACTIVE'),
(33, 'PKR', 'Pakistan Rupee', 'ACTIVE'),
(34, 'PLN', 'Polish Zloty', 'ACTIVE'),
(35, 'GBP', 'Pound Sterling', 'ACTIVE'),
(36, 'QAR', 'Qatar Riyal', 'ACTIVE'),
(37, 'SAR', 'Saudi Arabian Riyal', 'ACTIVE'),
(38, 'SGD', 'Singapore Dollar', 'ACTIVE'),
(39, 'SIT', 'Slovenian Tolar', 'ACTIVE'),
(40, 'ZAR', 'South African Rand', 'ACTIVE'),
(41, 'LKR', 'Sri Lanka Rupee', 'ACTIVE'),
(42, 'SEK', 'Swedish Krona', 'ACTIVE'),
(43, 'CHF', 'Swiss Franc', 'ACTIVE'),
(44, 'THB', 'Thai Baht', 'ACTIVE'),
(45, 'TTD', 'Trinidad and Tobago Dollar', 'ACTIVE'),
(46, 'AED', 'U.A.E.Dirham', 'ACTIVE'),
(47, 'USD', 'U.S.Dollar', 'ACTIVE'),
(48, 'VEB', 'Venezuelan Bolivar', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'degree'
--

INSERT INTO degree (serial_dgr, name_dgr, status_dgr) VALUES
(1, 'Artes aplicadas', 'ACTIVE'),
(2, 'Auxiliar de laboratorio de ciencias naturales y Biología', 'ACTIVE'),
(3, 'Ciencias exactas', 'ACTIVE'),
(4, 'Ciencias sociales', 'ACTIVE'),
(5, 'Comercio y administración', 'ACTIVE'),
(6, 'Comunicación educativa', 'ACTIVE'),
(7, 'Contabilidad y administración', 'ACTIVE'),
(8, 'Diseño y dibujo', 'ACTIVE'),
(9, 'Docencia y desarrollo comunitario', 'ACTIVE'),
(10, 'Docencia y gestión en educación básica', 'ACTIVE'),
(11, 'Ecoturismo', 'ACTIVE'),
(12, 'Educación artística', 'ACTIVE'),
(13, 'Educación primaria', 'ACTIVE'),
(14, 'Educación especial', 'ACTIVE'),
(15, 'Educación inicial', 'ACTIVE'),
(16, 'Educación parvularia', 'ACTIVE'),
(17, 'Educación superior', 'ACTIVE'),
(18, 'Electricidad', 'ACTIVE'),
(19, 'Diplomado', 'ACTIVE'),
(20, 'Especialista', 'ACTIVE'),
(21, 'Phd', 'ACTIVE'),
(22, 'Máster', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'discipline'
--


--
-- Volcar la base de datos para la tabla 'employee'
--

INSERT INTO employee (serial_emp, serial_tdg, serial_usr, serial_grd, serial_mdg, serial_ste, serial_cou, serial_nnt, serial_tst, serial_unv, serial_tmd, serial_dgr, id_emp, type_emp, status_emp, first_name_emp, last_name_emp, specialty_emp, gender_emp, marital_status_emp, birthdate_emp, address_emp, city_emp, parish_emp, sector_emp, phone_emp, phone2_emp, phone3_emp, cellphone_emp, email_emp, family_dependents_emp, student_dependents_emp, teaching_since_tea_emp, seniority_university_tea_emp, date_start_in_school_emp) VALUES
(1, NULL, 2, 1, NULL, 19, 61, 1, NULL, NULL, NULL, 21, '1715492656', 'TEACHING', 'ACTIVE', 'Nelson', 'Mandela', '', 'MALE', 'UNMARRIED PARTNERS', '1986-02-12', '19 de noviembre y calle A #338', 'Quito', 'Chaupícruz', 'Las casas', '222222222', '', '', '', '', 0, 0, NULL, NULL, '2010-10-19'),
(2, NULL, 3, NULL, NULL, 25, 1, 5, NULL, NULL, NULL, NULL, 'Prof001', 'TEACHING', 'ACTIVE', 'Federico ', 'Jiménez', '', 'MALE', 'SINGLE', '1990-11-08', 'fafas\r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'Andorra City', '', '', '1234345', '', '', '', '', 0, 0, NULL, NULL, '2010-11-19'),
(3, NULL, 4, 2, NULL, 28, 4, 6, NULL, NULL, NULL, NULL, 'prof002', 'TEACHING,ADMINISTRATIVE', 'ACTIVE', 'Francisco', 'Miño', '', 'MALE', 'DIVORCED', '1990-11-21', 'dfsdafsdf', 'Bahamas', '', '', '123123', '', '', '', '', 0, 0, NULL, NULL, '2010-11-19'),
(4, NULL, 5, NULL, NULL, 39, 15, 15, NULL, NULL, NULL, NULL, 'Prof003', 'ADMINISTRATIVE', 'INACTIVE', 'Elber', 'Gonzalez', '', 'MALE', 'UNMARRIED PARTNERS', '1990-11-16', 'ddadfads', 'roma', '', '', '13123123', '', '', '', '', 0, 0, NULL, NULL, '2010-11-19'),
(5, NULL, 6, NULL, NULL, 31, 7, 2, NULL, NULL, NULL, NULL, 'prof004', 'TEACHING', 'ACTIVE', 'mónica', 'gonzales', '', 'FEMALE', 'SINGLE', '1990-11-08', 'sadfsafas', 'sdafs', '', '', '123123', '', '', '', '', 0, 0, NULL, NULL, '2010-11-19'),
(6, NULL, 8, NULL, NULL, 34, 10, 5, NULL, NULL, NULL, NULL, 'emp001', 'ADMINISTRATIVE', 'ACTIVE', 'Carlos', 'Perez', '', 'MALE', 'MARRIED', '1990-11-10', 'sadasda', 'sdad', '', '', '2131312', '', '', '', '', 0, 0, NULL, NULL, '2010-11-19'),
(7, NULL, 9, NULL, NULL, 38, 14, 5, NULL, NULL, NULL, NULL, 'prof005', 'TEACHING', 'ACTIVE', 'Felix', 'Merchán', '', 'MALE', 'WIDOWED', '1990-11-22', 'sfasaf', 'Sidney', '', '', '12313', '', '', '', '', 0, 0, NULL, NULL, '2010-11-19');

--
-- Volcar la base de datos para la tabla 'employee_area'
--

INSERT INTO employee_area (serial_aca, serial_emp, is_director_eba, status_eba) VALUES
(1, 2, 'NO', 'ACTIVE'),
(2, 3, 'NO', 'ACTIVE'),
(3, 7, 'NO', 'ACTIVE'),
(5, 1, 'NO', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'general_activity'
--


--
-- Volcar la base de datos para la tabla 'general_activity_attendees'
--


--
-- Volcar la base de datos para la tabla 'grade_change_log'
--


--
-- Volcar la base de datos para la tabla 'grade_criteria'
--

INSERT INTO grade_criteria (serial_gct, name_gct, description_gct, status_gct) VALUES
(1, '* General', 'Criterio General, se usa cuando no se va a aplicar criterios de calificación.', 'ACTIVE'),
(2, 'Consistencia', 'asasd', 'ACTIVE'),
(3, 'Conocimiento', 'adasdad', 'ACTIVE'),
(4, 'Aseo', 'qeue ste limpio!', 'ACTIVE'),
(5, 'Presentación', 'presentación', 'ACTIVE'),
(6, 'Trabajo en Grupo', 'inactivo &lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'group_hour'
--

INSERT INTO group_hour (serial_gph, name_gph, description_gph, status_gph) VALUES
(1, 'Primaria Diurna', 'horarios de primaria diurna', 'ACTIVE'),
(2, 'Grupo de Prueba', '&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'ACTIVE'),
(3, 'Grupo inactivo', 'debe estar inactivóó', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'group_hour_level'
--

INSERT INTO group_hour_level (serial_gph, serial_lvl, serial_scy, serial_set, working_days_ghl, status_ghl) VALUES
(2, 1, 2, 2, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'),
(2, 2, 2, 1, 'MONDAY,TUESDAY,WEDNESDAY', 'ACTIVE'),
(2, 3, 2, 2, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'guardian'
--

INSERT INTO guardian (serial_grd, serial_usr, serial_emp, id_grd, first_name_grd, last_name_grd, birthdate_grd, gender_grd, address_grd, phone_grd, status_grd, occupation_grd, company_name_grd, company_activity_grd, company_phone_grd) VALUES
(1, 2, 1, '1715492656', 'Nelson', 'Mandela', '1986-02-12', 'MALE', '19 de noviembre y calle A #338', '222222222', 'ACTIVE', 'Periodista', '', '', ''),
(2, 4, 3, 'prof002', 'Francisco', 'Miño', '1990-11-21', 'MALE', 'dfsdafsdf', '123123', 'INACTIVE', '', '', '', ''),
(3, 7, NULL, 'padre001', 'María', 'Gonzales', '1990-11-09', 'FEMALE', 'asdasdas', '1231231', 'ACTIVE', '', '', '', ''),
(4, 12, NULL, '12345678901', 'Oswaldo', 'Guayasamin', '1960-11-22', 'MALE', 'bosmediano 555', '456130101', 'ACTIVE', 'Artista', '', '', '');

--
-- Volcar la base de datos para la tabla 'hour'
--

INSERT INTO hour (serial_hrs, start_hrs, end_hrs, status_hrs) VALUES
(1, '07:15:00', '10:00:00', 'ACTIVE'),
(2, '10:00:00', '10:45:00', 'ACTIVE'),
(3, '10:45:00', '12:00:00', 'ACTIVE'),
(4, '12:00:00', '12:15:00', 'ACTIVE'),
(5, '12:15:00', '13:30:00', 'ACTIVE'),
(6, '07:00:00', '09:00:00', 'ACTIVE'),
(7, '09:00:00', '09:30:00', 'ACTIVE'),
(8, '09:30:00', '11:00:00', 'ACTIVE'),
(9, '11:00:00', '11:45:00', 'ACTIVE'),
(10, '11:45:00', '13:15:00', 'ACTIVE'),
(11, '01:00:00', '03:00:00', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'hour_by_group'
--

INSERT INTO hour_by_group (serial_hbg, serial_hrs, serial_gph, status_hbg, type_hbg) VALUES
(1, 1, 1, 'ACTIVE', 'NORMAL'),
(2, 2, 1, 'ACTIVE', 'LUNCH'),
(3, 3, 1, 'ACTIVE', 'NORMAL'),
(4, 4, 1, 'ACTIVE', 'LUNCH'),
(5, 5, 1, 'ACTIVE', 'NORMAL'),
(6, 6, 2, 'ACTIVE', 'NORMAL'),
(7, 7, 2, 'ACTIVE', 'LUNCH'),
(8, 8, 2, 'ACTIVE', 'NORMAL'),
(9, 9, 2, 'ACTIVE', 'LUNCH'),
(10, 10, 2, 'ACTIVE', 'NORMAL'),
(11, 11, 3, 'ACTIVE', 'NORMAL');

--
-- Volcar la base de datos para la tabla 'language'
--

INSERT INTO language (serial_lng, abbreviation_lng, name_lng) VALUES
(1, 'ES', 'Español'),
(2, 'EN', 'Inglés');

--
-- Volcar la base de datos para la tabla 'level'
--

INSERT INTO level (serial_lvl, name_lvl, description_lvl, status_lvl) VALUES
(1, '1er Bachillerato', '4to curso', 'ACTIVE'),
(2, '8vo Básica', 'primer curso', 'ACTIVE'),
(3, '3ero Bachillerato', 'título de la descripción', 'ACTIVE'),
(4, 'Primer Grado', 'Grado de los más Pequeños\r\n&lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'level_section_year'
--

INSERT INTO level_section_year (serial_pgy, serial_lvl, serial_scy, serial_set, status_lsy) VALUES
(1, 1, 2, 2, 'ACTIVE'),
(1, 2, 2, 1, 'ACTIVE'),
(1, 3, 2, 2, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'level_section_year_specialty'
--

INSERT INTO level_section_year_specialty (serial_spt, serial_lvl, serial_scy, serial_set, status_lss) VALUES
(1, 2, 2, 1, 'ACTIVE'),
(2, 1, 2, 2, 'ACTIVE'),
(2, 3, 2, 2, 'ACTIVE'),
(4, 1, 2, 2, 'ACTIVE'),
(4, 3, 2, 2, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'master_degree'
--


--
-- Volcar la base de datos para la tabla 'medical_file'
--


--
-- Volcar la base de datos para la tabla 'message'
--


--
-- Volcar la base de datos para la tabla 'message_thread'
--


--
-- Volcar la base de datos para la tabla 'message_thread_messages'
--


--
-- Volcar la base de datos para la tabla 'nationality'
--

INSERT INTO nationality (serial_nnt, name_nnt, status_nnt) VALUES
(1, 'ECUATORIANA', 'ACTIVE'),
(2, 'AFGANA', 'ACTIVE'),
(3, 'ALBANA', 'ACTIVE'),
(4, 'ALEMANA', 'ACTIVE'),
(5, 'ARGENTINA', 'ACTIVE'),
(6, 'BAHAMES', 'ACTIVE'),
(7, 'BELGA', 'ACTIVE'),
(8, 'BOLIVIANA', 'ACTIVE'),
(9, 'BRASILEÑA', 'ACTIVE'),
(10, 'CHILENA', 'ACTIVE'),
(11, 'COLOMBIANA', 'ACTIVE'),
(12, 'COSTARRICENSE', 'ACTIVE'),
(13, 'ESPAÑOLA', 'ACTIVE'),
(14, 'ESTADOUNIDENSE', 'ACTIVE'),
(15, 'ITALIANA', 'ACTIVE'),
(16, 'MEXICANA', 'ACTIVE'),
(17, 'PARAGUAYA', 'ACTIVE'),
(18, 'PERUANA', 'ACTIVE'),
(19, 'PORTUGUESA', 'ACTIVE'),
(20, 'PUERTORRIQUEÑA', 'ACTIVE'),
(21, 'SUIZA', 'ACTIVE'),
(22, 'VENEZOLANA', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'optional_subject'
--

INSERT INTO optional_subject (serial_osb, serial_csb, serial_pgy, serial_aca, serial_emp, status_osb, grade_type_sbc) VALUES
(1, 3, 1, 3, 7, 'ACTIVE', 'QUALITATIVE'),
(2, 2, 1, 3, 7, 'ACTIVE', 'QUALITATIVE');

--
-- Volcar la base de datos para la tabla 'optional_subject_level'
--

INSERT INTO optional_subject_level (serial_osb, serial_spt, serial_lvl, serial_scy, serial_set, status_osl) VALUES
(1, 1, 2, 2, 1, 'ACTIVE'),
(2, 2, 1, 2, 2, 'ACTIVE'),
(2, 2, 3, 2, 2, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'optional_subject_period'
--

INSERT INTO optional_subject_period (serial_prd, serial_osb, status_osp, weight_osp) VALUES
(1, 1, 'ACTIVE', '30.00'),
(1, 2, 'ACTIVE', '40.00'),
(2, 1, 'ACTIVE', '30.00'),
(2, 2, 'ACTIVE', '40.00'),
(3, 1, 'ACTIVE', '40.00'),
(3, 2, 'ACTIVE', '20.00');

--
-- Volcar la base de datos para la tabla 'opt_activity'
--


--
-- Volcar la base de datos para la tabla 'opt_activity_applied_criterias'
--


--
-- Volcar la base de datos para la tabla 'opt_activity_attachment'
--


--
-- Volcar la base de datos para la tabla 'opt_grade_change_log'
--


--
-- Volcar la base de datos para la tabla 'opt_student_activity_attachment'
--


--
-- Volcar la base de datos para la tabla 'opt_student_criteria_grade'
--


--
-- Volcar la base de datos para la tabla 'opt_subject_period_activity_type'
--

INSERT INTO opt_subject_period_activity_type (serial_att, serial_prd, serial_osb, weight_osa, status_osa) VALUES
(3, 1, 1, '75.00', 'ACTIVE'),
(3, 1, 2, '100.00', 'ACTIVE'),
(3, 2, 1, '75.00', 'ACTIVE'),
(3, 2, 2, '100.00', 'ACTIVE'),
(3, 3, 1, '75.00', 'ACTIVE'),
(3, 3, 2, '100.00', 'ACTIVE'),
(4, 1, 1, '25.00', 'ACTIVE'),
(4, 2, 1, '25.00', 'ACTIVE'),
(4, 3, 1, '25.00', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'opt_subject_year_activity_criteria_period'
--

INSERT INTO opt_subject_year_activity_criteria_period (serial_gct, serial_osb, serial_att, serial_prd, status_oac) VALUES
(2, 1, 3, 1, 'ACTIVE'),
(2, 1, 3, 2, 'ACTIVE'),
(2, 1, 3, 3, 'ACTIVE'),
(2, 1, 4, 1, 'ACTIVE'),
(2, 1, 4, 2, 'ACTIVE'),
(2, 1, 4, 3, 'ACTIVE'),
(2, 2, 3, 1, 'ACTIVE'),
(2, 2, 3, 2, 'ACTIVE'),
(2, 2, 3, 3, 'ACTIVE'),
(3, 1, 3, 1, 'ACTIVE'),
(3, 1, 3, 2, 'ACTIVE'),
(3, 1, 3, 3, 'ACTIVE'),
(3, 1, 4, 1, 'ACTIVE'),
(3, 1, 4, 2, 'ACTIVE'),
(3, 1, 4, 3, 'ACTIVE'),
(4, 2, 3, 1, 'ACTIVE'),
(4, 2, 3, 2, 'ACTIVE'),
(4, 2, 3, 3, 'ACTIVE'),
(5, 1, 3, 1, 'ACTIVE'),
(5, 1, 3, 2, 'ACTIVE'),
(5, 1, 3, 3, 'ACTIVE'),
(5, 1, 4, 1, 'ACTIVE'),
(5, 1, 4, 2, 'ACTIVE'),
(5, 1, 4, 3, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'opt_subject_year_grade_criteria'
--

INSERT INTO opt_subject_year_grade_criteria (serial_gct, serial_osb, status_oyc) VALUES
(2, 1, 'ACTIVE'),
(2, 2, 'ACTIVE'),
(3, 1, 'ACTIVE'),
(4, 2, 'ACTIVE'),
(5, 1, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'payment_concept'
--

INSERT INTO payment_concept (serial_pct, name_pct, status_pct) VALUES
(1, 'Matricula', 'ACTIVE'),
(2, 'Matrícula Extraordinaria', 'ACTIVE'),
(3, 'Pensión Mañana', 'INACTIVE'),
(4, 'Pensión Normal', 'ACTIVE'),
(5, '<input type="text" name="test" id="test" value="TEST!">', 'ACTIVE'),
(6, '123', 'ACTIVE'),
(7, '@!$%', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'period'
--

INSERT INTO period (serial_prd, serial_pgy, name_prd, start_date_prd, end_date_prd, max_grade_date_prd, status_prd, min_grade_prd, max_grade_prd, warning_grade_prd, weight_prd) VALUES
(1, 1, 'Primer Bimestre', '2010-11-22', '2011-01-15', '2011-01-07', 'ACTIVE', '8.00', '20.00', '12.00', '30.00'),
(2, 1, 'Segundo Bimestre', '2011-01-17', '2011-03-11', '2011-03-04', 'ACTIVE', '8.00', '20.00', '12.00', '30.00'),
(3, 1, 'Tercer Bimestre', '2011-03-14', '2011-05-20', '2011-05-13', 'ACTIVE', '8.00', '20.00', '12.00', '40.00');

--
-- Volcar la base de datos para la tabla 'period_group_year'
--

INSERT INTO period_group_year (serial_pgy, serial_scy, serial_cpd, name_pgy, status_pgy) VALUES
(1, 2, 1, 'Grupo Test', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'pre_registration'
--

INSERT INTO pre_registration (serial_prt, serial_nnt, serial_usr, serial_dgr, serial_spt, serial_lvl, serial_scy, serial_set, first_name_prt, last_name_prt, relationship_prt, birthdate_prt, gender_prt, address_prt, phone_prt, status_prt, first_name_father_prt, last_name_father_prt, first_name_mother_prt, last_name_mother_prt, city_birth_prt, blood_type_prt, allergies_prt, lives_with_prt, photo_prt, rep_first_name_prt, rep_last_name_prt, rep_relationship_prt, rep_birthdate_prt, rep_city_birth_prt, rep_marital_status_prt, rep_occupation_prt, rep_address_prt, rep_phone_prt, rep_mobile_prt, rep_company_name_prt, rep_company_activity_prt, rep_company_phone_prt, rep_photo_prt, rep_gender_prt, rep_id_prt) VALUES
(1, 21, 2, 21, 1, 2, 2, 1, 'Nelsinho', 'Mandela', 'PARENT', '1990-11-06', 'MALE', '19 de noviembre y calle A #338', '12345677', 'PROCESSED', 'Nelson', 'Mandela', 'María', 'Mandela', 'Berna', 'A+', '', 'PARENT', '', 'Nelson', 'Mandela', 'PARENT', '1986-02-12', 'Johnanesburgo', 'UNMARRIED PARTNERS', 'Periodista', '19 de noviembre y calle A #338', '222222222', '', '', '', '', '', 'MALE', '1715492656'),
(2, 1, 2, 1, 1, 2, 2, 1, 'Oswaldo', 'Guayasamin', 'PARENT', '1990-11-30', 'MALE', 'bosmediano 555', '789456', 'PROCESSED', 'Oswaldo', 'Guayasamin', 'Carla', 'Guayasamin', 'Quito', 'AB+', '', 'PARENT', '', 'Oswaldo', 'Guayasamin', 'PARENT', '1960-11-22', 'Quito', 'MARRIED', 'Artista', 'bosmediano 555', '456130101', '', '', '', '', '9b1717.jpeg', 'MALE', '12345678901'),
(3, 16, 2, 22, 1, 2, 2, 1, 'Raul', 'Gonzales Perez', 'PARENT', '1990-11-17', 'MALE', 'calle A y la q cruza', '1234560', 'STAND_BY', 'Manuel', 'Gonzales', 'Andrea', 'Perez', 'Mexico DF', 'A-', 'a la penisilina', 'AUNT_UNCLE', '', 'Carlos', 'Perez', 'AUNT_UNCLE', '1990-11-10', 'Mexico DF', 'MARRIED', 'Catedratico', 'sadasda', '2131312', '', '', '', '', '782e72.jpg', 'MALE', 'emp001'),
(4, 5, 2, 19, 1, 2, 2, 1, 'Cristina', 'Fernandez Ponce', 'PARENT', '1990-11-18', 'FEMALE', 'casa rosada', '753423863', 'STAND_BY', 'Nestor', 'Fernandez', 'Cristina', 'Ponce', 'Buenos Aires', 'AB+', 'N/A', 'PARENT', '', 'Federico', 'Ponce', 'GRANDPARENT', '1960-11-22', 'Quito', 'WIDOWED', 'Jubilado', '10 de Agosto OE3-290', '789123456', '', '', '', '', '', 'MALE', '12345678902'),
(5, 1, 2, 19, 1, 2, 2, 1, 'Matias', 'Escobar Alarcón', 'PARENT', '1990-11-17', 'MALE', 'calle Z 123', '1234567', 'STAND_BY', 'Pablo', 'Escobar', 'Martina', 'Alarcón', 'Quito', 'B-', '', 'PARENT', '', 'Martina', 'Alarcón', 'PARENT', '1960-11-22', 'Quito', 'WIDOWED', 'Ama de Casa', '12 de octubre 789', '7410852', '', '', '', '', '', 'FEMALE', '12345678903'),
(6, 1, 2, 4, 1, 2, 2, 1, 'Walter', 'Ayoví Corozo', 'PARENT', '1990-12-26', 'MALE', 'esmeraldas', '12301230', 'STAND_BY', 'Walter', 'Ayoví', 'Andrea', 'Corozo', 'Esmeraldas', 'B-', '', 'PARENT', '', 'Walter', 'Ayoví', 'PARENT', '1980-04-07', 'Esmeraldas', 'MARRIED', 'Futbolista', 'Gonzales Suarez', '7890123', '', '', '', '', '', 'MALE', '12345678904'),
(7, 1, 2, 21, 1, 2, 2, 1, 'Gabriela', 'de la Cruz Cárdenas', 'PARENT', '1990-11-03', 'FEMALE', 'Calle de los Manzanos', '789456', 'STAND_BY', 'Fabián', 'de la Cruz', 'Esther', 'Cárdenas', 'Quito', 'O-', '', 'GRANDPARENT', '', 'Fabián', 'de la Cruz', 'PARENT', '1990-11-16', 'Quito', 'MARRIED', 'Ingeniero de Software', 'Calle de los Manzanos', '789456120', '', '', '', '', '', 'MALE', '12345678905'),
(8, 1, 2, 7, 1, 2, 2, 1, 'Daniela', 'Miño', 'PARENT', '1990-11-14', 'FEMALE', 'av de los cerezos', '7410963', 'STAND_BY', 'Joaquín', 'Miño', 'Macarena', 'Jijón', 'Quito', 'O+', 'Rinitis Alérgica Crónica', 'SIBLING', '', 'María', 'Miño', 'AUNT_UNCLE', '1974-02-20', 'Quito', 'DIVORCED', 'Gerente de Prosonido', 'Hernandez de Girón', '099789456', '', '', '', '', '', 'FEMALE', '12345678906'),
(9, 1, 2, 8, 1, 2, 2, 1, 'Santiago', 'Villagomez', 'PARENT', '1990-06-06', 'MALE', 'vasco de Contreras 555', '789456', 'STAND_BY', 'Marcelo', 'Villagomez', 'Luisa', 'Astudillo', 'Quito', 'A+', 'NO.', 'AUNT_UNCLE', '', 'Frixón', 'Villagomez', 'SIBLING', '1983-07-07', 'Quito', 'SINGLE', 'Estudiante', 'Polonia y Rumania', '7894560', '', '', '', '', '', 'MALE', '12345678907');

--
-- Volcar la base de datos para la tabla 'pre_registration_period'
--

INSERT INTO pre_registration_period (serial_scy, start_date_prp, end_date_prp, status_prp) VALUES
(1, '2010-11-16', '2010-12-16', 'OPEN'),
(2, '2010-11-22', '2010-12-22', 'OPEN');

--
-- Volcar la base de datos para la tabla 'process'
--

INSERT INTO process (serial_prc, prc_serial_prc, name_prc, link_prc, weight_prc, status_prc) VALUES
(1, NULL, 'Parámetros', '#', '1.0', 'LOCKABLE'),
(2, 1, 'Área Académica', '#', '48.5', 'LOCKABLE'),
(3, 2, 'Nueva Área Académica', 'modules/academic_area/fNewArea', '48.6', 'LOCKABLE'),
(4, 2, 'Actualizar Área Académica', 'modules/academic_area/fSearchArea', '48.7', 'LOCKABLE'),
(5, 1, 'Autoridades', '#', '5.0', 'LOCKABLE'),
(6, 5, 'Nueva Autoridad', 'modules/authority/fNewAuthority', '6.0', 'LOCKABLE'),
(7, 5, 'Actualizar Autoridad', 'modules/authority/fSearchAuthority', '7.0', 'LOCKABLE'),
(8, 1, 'Cargos de Autoridades', '#', '4.1', 'LOCKABLE'),
(9, 8, 'Nuevo Cargo', 'modules/authority_charges/fNewCharge', '4.2', 'LOCKABLE'),
(10, 8, 'Actualizar Cargo', 'modules/authority_charges/fSearchCharge', '4.3', 'LOCKABLE'),
(11, 1, 'Perfiles', '#', '51.5', 'LOCKABLE'),
(12, 11, 'Nuevo Perfil', 'modules/profile/fNewProfile', '51.6', 'LOCKABLE'),
(13, 11, 'Actualizar Perfil', 'modules/profile/fSearchProfile', '51.7', 'LOCKABLE'),
(14, 1, 'Paises', '#', '14.0', 'LOCKABLE'),
(15, 14, 'Nuevo País', 'modules/country/fNewCountry', '15.0', 'LOCKABLE'),
(16, 14, 'Actualizar País', 'modules/country/fSearchCountry', '16.0', 'LOCKABLE'),
(17, 1, 'Provincias/Estados', '#', '17.0', 'LOCKABLE'),
(18, 17, 'Nueva Provincia/Estado', 'modules/state/fNewState', '18.0', 'LOCKABLE'),
(19, 17, 'Actualizar Provincia/Estado', 'modules/state/fSearchState', '19.0', 'LOCKABLE'),
(20, 1, 'Secciones', '#', '20.0', 'LOCKABLE'),
(21, 20, 'Nueva Sección', 'modules/section/fNewSection', '21.0', 'LOCKABLE'),
(22, 20, 'Actualizar Sección', 'modules/section/fSearchSection', '22.0', 'LOCKABLE'),
(23, 1, 'Niveles', '#', '23.0', 'LOCKABLE'),
(24, 23, 'Nuevo Nivel', 'modules/level/fNewLevel', '24.0', 'LOCKABLE'),
(25, 23, 'Actualizar Nivel', 'modules/level/fSearchLevel', '25.0', 'LOCKABLE'),
(26, 1, 'Especialidades', '#', '22.5', 'LOCKABLE'),
(27, 26, 'Nueva Especialidad', 'modules/specialty/fNewSpecialty', '22.6', 'LOCKABLE'),
(28, 26, 'Actualizar Especialidad', 'modules/specialty/fSearchSpecialty', '22.7', 'LOCKABLE'),
(29, 1, 'Paralelos', '#', '29.0', 'LOCKABLE'),
(30, 29, 'Nuevo Paralelo', 'modules/class_group/fNewClassGroup', '30.0', 'LOCKABLE'),
(31, 29, 'Actualizar Paralelo', 'modules/class_group/fSearchClassGroup', '31.0', 'LOCKABLE'),
(32, 1, 'Horas Académicas', '#', '32.0', 'LOCKABLE'),
(33, 32, 'Grupos de Horas', '#', '33.0', 'LOCKABLE'),
(34, 33, 'Nuevo Grupo Horas', 'modules/group_hour/fNewGroupHour', '34.0', 'LOCKABLE'),
(35, 33, 'Actualizar Grupo Horas', 'modules/group_hour/fSearchGroupHour', '35.0', 'LOCKABLE'),
(36, 1, 'Categoría de Período', '#', '36.0', 'LOCKABLE'),
(37, 36, 'Nueva Categoría', 'modules/cat_period/fNewCatPeriod', '37.0', 'LOCKABLE'),
(38, 36, 'Actualizar Categoría', 'modules/cat_period/fSearchCatPeriod', '38.0', 'LOCKABLE'),
(39, NULL, 'Configuración', '#', '39.0', 'LOCKABLE'),
(40, 39, 'Año Lectivo', '#', '40.0', 'LOCKABLE'),
(41, 40, 'Iniciar/Continuar', 'modules/year_setup/index', '41.0', 'LOCKABLE'),
(42, 1, 'Año Lectivo', '#', '19.5', 'LOCKABLE'),
(43, 42, 'Nuevo Año Lectivo', 'modules/school_year/fNewYear', '19.6', 'LOCKABLE'),
(44, 42, 'Actualizar Año Lectivo', 'modules/school_year/fSearchYear', '19.7', 'LOCKABLE'),
(45, NULL, 'Preinscripciones', '#', '45.0', 'LOCKABLE'),
(46, 45, 'Nueva Preinscripción', 'modules/pre_registration/fNewPreRegistration', '46.0', 'LOCKABLE'),
(47, 45, 'Actualizar Preinscripción', 'modules/pre_registration/fSelectPreRegisteredToUpdate', '47.0', 'LOCKABLE'),
(48, 45, 'Procesar Preinscripciones', 'modules/pre_registration/fSelectLevel', '48.0', 'LOCKABLE'),
(49, 1, 'Materias', '#', '49.0', 'LOCKABLE'),
(50, 49, 'Nueva Materia', 'modules/cat_subject/fNewCatSubject', '50.0', 'LOCKABLE'),
(51, 49, 'Actualizar Materia', 'modules/cat_subject/fSearchCatSubject', '51.0', 'LOCKABLE'),
(52, 1, 'Usuarios', '#', '52.0', 'LOCKABLE'),
(53, 52, 'Profesores', '#', '53.0', 'LOCKABLE'),
(54, 53, 'Nuevo Profesor', 'modules/employee/teacher/fNewTeacher', '54.0', 'LOCKABLE'),
(55, 53, 'Actualizar Profesor', 'modules/employee/teacher/fSearchTeacher', '55.0', 'LOCKABLE'),
(56, 52, 'Empleados', '#', '56.0', 'LOCKABLE'),
(57, 39, 'Materias', '#', '57.0', 'LOCKABLE'),
(58, 57, 'Iniciar/Continuar', 'modules/year_subject_setup/index', '58.0', 'LOCKABLE'),
(59, 39, 'Profesores', '#', '59.0', 'LOCKABLE'),
(60, 59, 'Horas disponibles por año', 'modules/teacher_hours_year/fSelectSchoolYear', '60.0', 'LOCKABLE'),
(61, 39, 'Estudiantes', '#', '61.0', 'LOCKABLE'),
(62, 61, 'Asignar Curso', 'modules/student/fSelectSchoolYear', '62.0', 'LOCKABLE'),
(63, 53, 'Asignar Área Académica', 'modules/employee/teacher/fAssignTeacherToAcademicArea', '63.0', 'LOCKABLE'),
(64, 56, 'Nuevo Empleado', 'modules/employee/general/fNewEmployee', '64.0', 'LOCKABLE'),
(65, 56, 'Actualizar Empleado', 'modules/employee/general/fSearchEmployee', '65.0', 'LOCKABLE'),
(66, 1, 'Aulas', '#', '51.1', 'LOCKABLE'),
(67, 66, 'Nueva Aula', 'modules/classroom/fNewClassroom', '67.0', 'LOCKABLE'),
(68, 66, 'Actualizar Aula', 'modules/classroom/fSearchClassroom', '68.0', 'LOCKABLE'),
(69, 52, 'Asignación de Perfiles', 'modules/user_profile/fSearchUser', '69.0', 'LOCKABLE'),
(70, 1, 'Procesos', '#', '70.0', 'LOCKABLE'),
(71, 70, 'Bloquear Procesos', 'modules/process/fSearchProfileProcess', '71.0', 'LOCKABLE'),
(72, 2, 'Asignar/Reasignar Director de Area', 'modules/academic_area/fChangeAcademicAreaDirector', '48.8', 'LOCKABLE'),
(73, 52, 'Representantes', '#', '56.1', 'LOCKABLE'),
(74, 73, 'Nuevo Representante', 'modules/guardian/fNewGuardian', '74.0', 'LOCKABLE'),
(75, 73, 'Actualizar Representante', 'modules/guardian/fSearchGuardian', '75.0', 'LOCKABLE'),
(76, 39, 'Preinscripciones', '#', '76.0', 'LOCKABLE'),
(77, 76, 'Periodos de Preinscripción', 'modules/school_year/fNewPreRegistrationPeriod', '77.0', 'LOCKABLE'),
(78, 1, 'Transportes', '#', '51.2', 'LOCKABLE'),
(79, 78, 'Conductores', '#', '79.0', 'LOCKABLE'),
(80, 79, 'Nuevo Conductor', 'modules/bus_driver/fNewBusDriver', '80.0', 'LOCKABLE'),
(81, 79, 'Actualizar Conductor', 'modules/bus_driver/fSearchBusDriver', '81.0', 'LOCKABLE'),
(82, 78, 'Buses', '#', '82.0', 'LOCKABLE'),
(83, 82, 'Nuevo Bus', 'modules/bus/fNewBus', '83.0', 'LOCKABLE'),
(84, 82, 'Actualizar Bus', 'modules/bus/fSearchBus', '84.0', 'LOCKABLE'),
(85, 78, 'Rutas', '#', '85.0', 'LOCKABLE'),
(86, 85, 'Nueva Ruta', 'modules/route/fNewRoute', '86.0', 'LOCKABLE'),
(87, 85, 'Actualizar Ruta', 'modules/route/fSearchRoute', '87.0', 'LOCKABLE'),
(88, 78, 'Turnos', '#', '88.0', 'LOCKABLE'),
(89, 88, 'Nuevo Turno', 'modules/shift/fNewShift', '89.0', 'LOCKABLE'),
(90, 88, 'Actualizar Turno', 'modules/shift/fSearchShift', '90.0', 'LOCKABLE'),
(91, 1, 'Tipos de Actividad', '#', '49.1', 'LOCKABLE'),
(92, 91, 'Nuevo Tipo', 'modules/activity_type/fNewActivityType', '92.0', 'LOCKABLE'),
(93, 91, 'Actualizar Tipo', 'modules/activity_type/fSearchActivityType', '93.0', 'LOCKABLE'),
(94, 1, 'Criterios de Evaluación', '#', '49.2', 'LOCKABLE'),
(95, 94, 'Nuevo Criterio', 'modules/grade_criteria/fNewGradeCriteria', '95.0', 'LOCKABLE'),
(96, 94, 'Actualizar Criterio', 'modules/grade_criteria/fSearchGradeCriteria', '96.0', 'LOCKABLE'),
(97, 39, 'Transportes', '#', '97.0', 'LOCKABLE'),
(98, 97, 'Iniciar/Continuar', 'modules/transportation_setup/fNewTransportationSetup', '98.0', 'LOCKABLE'),
(99, 52, 'Desactivar Usuario', 'modules/user/fSearchUser', '99.0', 'LOCKABLE'),
(100, NULL, 'Estudiantes', '#', '100.0', 'LOCKABLE'),
(101, 100, 'Documentación de Aprobados', 'modules/student_documents/fSelectStudent', '101.0', 'LOCKABLE'),
(102, 1, 'Artículos', '#', '51.3', 'LOCKABLE'),
(103, 102, 'Nuevo Artículo', 'modules/article/fNewArticle', '103.0', 'LOCKABLE'),
(104, 102, 'Actualizar Artículo', 'modules/article/fSearchArticle', '104.0', 'LOCKABLE'),
(105, 97, 'Asignar Usuarios', 'modules/transportation_setup/fSelectSchoolYear', '105.0', 'LOCKABLE'),
(106, 39, 'Criterios y Actividades', '#', '57.2', 'LOCKABLE'),
(107, 106, 'Materias Obligatorias', '#', '107.0', 'LOCKABLE'),
(108, 107, 'Iniciar/Continuar', 'modules/year_activity_criteria_setup/', '108.0', 'LOCKABLE'),
(109, 106, 'Materias Optativas', '#', '109.0', 'LOCKABLE'),
(110, 109, 'Iniciar/Continuar', 'modules/year_opt_activity_criteria_setup/', '110.0', 'LOCKABLE'),
(111, 1, 'Concepto de Pago', '#', '51.3', 'LOCKABLE'),
(112, 111, 'Nuevo Concepto de Pago', 'modules/payment_concept/fNewPaymentConcept', '1.0', 'LOCKABLE'),
(113, 111, 'Actualizar Concepto de Pago', 'modules/payment_concept/fSearchPaymentConcept', '2.0', 'LOCKABLE'),
(114, 1, 'Impuestos', '#', '51.4', 'LOCKABLE'),
(115, 114, 'Nuevo Impuesto', 'modules/tax/fNewTax', '1.0', 'LOCKABLE'),
(116, 114, 'Actualizar Impuesto', 'modules/tax/fSearchTax', '2.0', 'LOCKABLE'),
(117, 39, 'Rubros', '#', '114.0', 'LOCKABLE'),
(118, 117, 'Iniciar/Continuar', 'modules/year_level_specialty_payment_concept/index', '1.0', 'LOCKABLE'),
(119, NULL, 'Actividades', '#', '116.0', 'LOCKABLE'),
(120, 119, 'Nueva Actividad', '#', '1.0', 'LOCKABLE'),
(121, 119, 'Actualizar Actividad', '#', '2.0', 'LOCKABLE'),
(122, 119, 'Calificar Actividad', '#', '3.0', 'LOCKABLE'),
(123, 119, 'Recalificar Actividad', '#', '4.0', 'LOCKABLE'),
(124, 120, 'Materia Obligatoria', 'modules/activity/fNewActivity', '1.0', 'LOCKABLE'),
(125, 120, 'Materia Optativa ', 'modules/opt_activity/fNewOptionalActivity', '1.0', 'LOCKABLE'),
(126, 122, 'Materia Obligatoria', 'modules/student_criteria_grade/fGradeActivityByCourse', '1.0', 'LOCKABLE'),
(127, 122, 'Materia Optativa', 'modules/opt_student_criteria_grade/fOptionalSubjectGradeActivityByCourse', '2.0', 'LOCKABLE'),
(128, 121, 'Materia Obligatoria', 'modules/activity/fUpdateActivity', '1.0', 'LOCKABLE'),
(129, 121, 'Materia Optativa', 'modules/opt_activity/fUpdateOptionalActivity', '2.0', 'LOCKABLE'),
(130, 119, 'Ver Actividades', '#', '3.0', 'LOCKABLE'),
(131, 130, 'Materias Obligatorias', 'modules/student_subject_activity/fSelectSchoolYear ', '1.0', 'LOCKABLE'),
(132, 130, 'Materias Optativas', 'modules/student_opt_subject_activity/fSelectSchoolYear', '2.0', 'LOCKABLE'),
(133, 61, 'Asignar Materia Optativa', 'modules/student_optional_subject/fSelectSchoolYear', '62.5', 'LOCKABLE'),
(134, NULL, 'Materias', '#', '134.0', 'LOCKABLE'),
(135, 134, 'Plan de Estudios', 'modules/syllabus_files/fAssignSyllabusFiles', '1.0', 'LOCKABLE'),
(136, 134, 'Plan de Estudios Profesores', 'modules/syllabus_files_change_log/fChangeSyllabusFiles', '1.0', 'LOCKABLE'),
(137, 123, 'Materia Obligatoria', 'modules/grade_change_log/fGradeChangeLog', '1.0', 'LOCKABLE'),
(138, 123, 'Materia Optativa', 'modules/opt_grade_change_log/fOptGradeChangeLog', '1.1', 'LOCKABLE');

--
-- Volcar la base de datos para la tabla 'profile'
--

INSERT INTO profile (serial_prf, name_prf, type_prf, status_prf, owner_prf) VALUES
(1, 'Administrador', 'INTERNAL', 'ACTIVE', 'SYSTEM'),
(2, 'Representante', 'EXTERNAL', 'ACTIVE', 'SYSTEM'),
(3, 'Estudiante', 'EXTERNAL', 'ACTIVE', 'SYSTEM'),
(4, 'Docente', 'INTERNAL', 'ACTIVE', 'SYSTEM'),
(5, 'Administrativo', 'INTERNAL', 'ACTIVE', 'SYSTEM'),
(6, 'TEST', 'INTERNAL', 'ACTIVE', 'USER');

--
-- Volcar la base de datos para la tabla 'profile_process'
--

INSERT INTO profile_process (serial_prf, serial_prc, status_ppr) VALUES
(1, 1, 'ACTIVE'),
(1, 2, 'ACTIVE'),
(1, 3, 'ACTIVE'),
(1, 4, 'ACTIVE'),
(1, 5, 'ACTIVE'),
(1, 6, 'ACTIVE'),
(1, 7, 'ACTIVE'),
(1, 8, 'ACTIVE'),
(1, 9, 'ACTIVE'),
(1, 10, 'ACTIVE'),
(1, 11, 'ACTIVE'),
(1, 12, 'ACTIVE'),
(1, 13, 'ACTIVE'),
(1, 14, 'ACTIVE'),
(1, 15, 'ACTIVE'),
(1, 16, 'ACTIVE'),
(1, 17, 'ACTIVE'),
(1, 18, 'ACTIVE'),
(1, 19, 'ACTIVE'),
(1, 20, 'ACTIVE'),
(1, 21, 'ACTIVE'),
(1, 22, 'ACTIVE'),
(1, 23, 'ACTIVE'),
(1, 24, 'ACTIVE'),
(1, 25, 'ACTIVE'),
(1, 26, 'ACTIVE'),
(1, 27, 'ACTIVE'),
(1, 28, 'ACTIVE'),
(1, 29, 'ACTIVE'),
(1, 30, 'ACTIVE'),
(1, 31, 'ACTIVE'),
(1, 32, 'ACTIVE'),
(1, 33, 'ACTIVE'),
(1, 34, 'ACTIVE'),
(1, 35, 'ACTIVE'),
(1, 36, 'ACTIVE'),
(1, 37, 'ACTIVE'),
(1, 38, 'ACTIVE'),
(1, 39, 'ACTIVE'),
(1, 40, 'ACTIVE'),
(1, 41, 'ACTIVE'),
(1, 42, 'ACTIVE'),
(1, 43, 'ACTIVE'),
(1, 44, 'ACTIVE'),
(1, 45, 'ACTIVE'),
(1, 48, 'ACTIVE'),
(1, 49, 'ACTIVE'),
(1, 50, 'ACTIVE'),
(1, 51, 'ACTIVE'),
(1, 52, 'ACTIVE'),
(1, 54, 'ACTIVE'),
(1, 55, 'ACTIVE'),
(1, 56, 'ACTIVE'),
(1, 57, 'ACTIVE'),
(1, 58, 'ACTIVE'),
(1, 59, 'ACTIVE'),
(1, 60, 'ACTIVE'),
(1, 61, 'ACTIVE'),
(1, 62, 'ACTIVE'),
(1, 63, 'ACTIVE'),
(1, 64, 'ACTIVE'),
(1, 65, 'ACTIVE'),
(1, 66, 'ACTIVE'),
(1, 67, 'ACTIVE'),
(1, 68, 'ACTIVE'),
(1, 69, 'ACTIVE'),
(1, 70, 'ACTIVE'),
(1, 71, 'ACTIVE'),
(1, 72, 'ACTIVE'),
(1, 74, 'ACTIVE'),
(1, 75, 'ACTIVE'),
(1, 77, 'ACTIVE'),
(1, 80, 'ACTIVE'),
(1, 81, 'ACTIVE'),
(1, 83, 'ACTIVE'),
(1, 84, 'ACTIVE'),
(1, 86, 'ACTIVE'),
(1, 87, 'ACTIVE'),
(1, 89, 'ACTIVE'),
(1, 90, 'ACTIVE'),
(1, 92, 'ACTIVE'),
(1, 93, 'ACTIVE'),
(1, 95, 'ACTIVE'),
(1, 96, 'ACTIVE'),
(1, 98, 'ACTIVE'),
(1, 99, 'ACTIVE'),
(1, 103, 'ACTIVE'),
(1, 104, 'ACTIVE'),
(1, 105, 'ACTIVE'),
(1, 107, 'ACTIVE'),
(1, 108, 'ACTIVE'),
(1, 109, 'ACTIVE'),
(1, 110, 'ACTIVE'),
(1, 111, 'ACTIVE'),
(1, 112, 'ACTIVE'),
(1, 113, 'ACTIVE'),
(1, 114, 'ACTIVE'),
(1, 115, 'ACTIVE'),
(1, 116, 'ACTIVE'),
(1, 117, 'ACTIVE'),
(1, 118, 'ACTIVE'),
(1, 119, 'ACTIVE'),
(1, 133, 'ACTIVE'),
(1, 136, 'ACTIVE'),
(1, 137, 'ACTIVE'),
(1, 138, 'ACTIVE'),
(2, 46, 'ACTIVE'),
(2, 47, 'ACTIVE'),
(2, 101, 'ACTIVE'),
(3, 131, 'ACTIVE'),
(3, 132, 'ACTIVE'),
(4, 120, 'ACTIVE'),
(4, 120, 'ACTIVE'),
(4, 124, 'ACTIVE'),
(4, 125, 'ACTIVE'),
(4, 126, 'ACTIVE'),
(4, 127, 'ACTIVE'),
(4, 128, 'ACTIVE'),
(4, 129, 'ACTIVE'),
(4, 135, 'ACTIVE'),
(6, 9, 'BLOCKED'),
(6, 135, 'ACTIVE'),
(6, 136, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'psychological_file'
--


--
-- Volcar la base de datos para la tabla 'route'
--

INSERT INTO route (serial_rot, code_rot, description_rot, status_rot) VALUES
(1, 'RU1-2010', 'adasd', 'ACTIVE'),
(2, 'RU2-002', 'asdasd', 'ACTIVE'),
(3, 'RUT-003', 'ruta desactivada por viejaáá', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'school_setup'
--

INSERT INTO school_setup (serial_ste, serial_crr, name_sst, city_sst, address_sst, phone1_sst, phone2_sst, phone3_sst, contact_name_sst, contact_phone_sst, logo_sst, slogan_sst, main_color_sst, secondary_color_sst) VALUES
(19, 47, 'Colegio Juanito', 'Quito', 'mi casa', '222222222', '', '', 'Manuel Pelegrini', '393939392', '565b16.jpg', '', '000000', '383737');

--
-- Volcar la base de datos para la tabla 'school_year'
--

INSERT INTO school_year (serial_scy, start_date_scy, end_date_scy, status_scy, name_scy, grade_precision_scy) VALUES
(1, '2010-10-21', '2011-07-21', 'ACTIVE,NEW', 'Año 2010-2011 Sierra',  0),
(2, '2010-11-21', '2011-08-21', 'ACTIVE,NEW', 'Año de Test', 2),
(3, '2011-11-21', '2012-08-21', 'NEW', 'Año de Test 2', 2);

--
-- Volcar la base de datos para la tabla 'section'
--

INSERT INTO section (serial_set, name_set, description_set, status_set, type_set) VALUES
(1, 'Primaria', 'primaria tempranito', 'ACTIVE', 'DAY'),
(2, 'Secundaria', 'secundaria tempranito', 'ACTIVE', 'DAY'),
(3, 'Primaria DOS', 'Primaria Mañana &lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'INACTIVE', 'DAY'),
(4, 'Primaria', 'Primaria en la Tardé', 'ACTIVE', 'EVENING'),
(5, 'Secundaria', 'Secundaria', 'INACTIVE', 'EVENING');

--
-- Volcar la base de datos para la tabla 'section_by_year'
--

INSERT INTO section_by_year (serial_scy, serial_set, status_sby) VALUES
(2, 1, 'ACTIVE'),
(2, 2, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'shift'
--

INSERT INTO shift (serial_sft, name_sft, description_sft, status_sft) VALUES
(1, 'Nocturno', 'adasdsad', 'ACTIVE'),
(2, 'mañana', 'aadad', 'ACTIVE'),
(3, 'Media Mañana', 'Media Mañana', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'specialty'
--

INSERT INTO specialty (serial_spt, name_spt, description_spt, status_spt) VALUES
(1, '* Ninguna', 'Opción para todo nivel que no tiene una especialización', 'ACTIVE'),
(2, 'Físico Matemático', 'ñoños', 'ACTIVE'),
(3, 'Químico Biólogo', 'nerdos', 'ACTIVE'),
(4, 'Sociales', 'Sociales &lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'ACTIVE'),
(5, 'Ciencias', 'Ciencias', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'state'
--

INSERT INTO state (serial_ste, serial_cou, name_ste, status_ste) VALUES
(1, 61, 'Azuay', 'ACTIVE'),
(2, 61, 'Bolívar', 'ACTIVE'),
(3, 61, 'Cañar', 'ACTIVE'),
(4, 61, 'Carchi', 'ACTIVE'),
(5, 61, 'Chimborazo', 'ACTIVE'),
(6, 61, 'Cotopaxi', 'ACTIVE'),
(7, 61, 'El Oro', 'ACTIVE'),
(8, 61, 'Esmeraldas', 'ACTIVE'),
(9, 61, 'Galápagos', 'ACTIVE'),
(10, 61, 'Guayas', 'ACTIVE'),
(11, 61, 'Imbabura', 'ACTIVE'),
(12, 61, 'Loja', 'ACTIVE'),
(13, 61, 'Los Ríos', 'ACTIVE'),
(14, 61, 'Manabí', 'ACTIVE'),
(15, 61, 'Morona Santiago', 'ACTIVE'),
(16, 61, 'Napo', 'ACTIVE'),
(17, 61, 'Orellana', 'ACTIVE'),
(18, 61, 'Pastaza', 'ACTIVE'),
(19, 61, 'Pichincha', 'ACTIVE'),
(20, 61, 'Santa Elena', 'ACTIVE'),
(21, 61, 'Sto.Domingo de los Tsáchilas', 'ACTIVE'),
(22, 61, 'Sucumbíos', 'ACTIVE'),
(23, 61, 'Tungurahua', 'ACTIVE'),
(24, 61, 'Zamora Chinchipe', 'ACTIVE'),
(25, 1, 'Otra', 'ACTIVE'),
(26, 2, 'Otra', 'ACTIVE'),
(27, 3, 'Otra', 'ACTIVE'),
(28, 4, 'Otra', 'ACTIVE'),
(29, 5, 'Otra', 'ACTIVE'),
(30, 6, 'Otra', 'ACTIVE'),
(31, 7, 'Otra', 'ACTIVE'),
(32, 8, 'Otra', 'ACTIVE'),
(33, 9, 'Otra', 'ACTIVE'),
(34, 10, 'Otra', 'ACTIVE'),
(35, 11, 'Otra', 'ACTIVE'),
(36, 12, 'Otra', 'ACTIVE'),
(37, 13, 'Otra', 'ACTIVE'),
(38, 14, 'Otra', 'ACTIVE'),
(39, 15, 'Otra', 'ACTIVE'),
(40, 16, 'Otra', 'ACTIVE'),
(41, 17, 'Otra', 'ACTIVE'),
(42, 18, 'Otra', 'ACTIVE'),
(43, 19, 'Otra', 'ACTIVE'),
(44, 20, 'Otra', 'ACTIVE'),
(45, 21, 'Otra', 'ACTIVE'),
(46, 22, 'Otra', 'ACTIVE'),
(47, 23, 'Otra', 'ACTIVE'),
(48, 24, 'Otra', 'ACTIVE'),
(49, 25, 'Otra', 'ACTIVE'),
(50, 26, 'Otra', 'ACTIVE'),
(51, 27, 'Otra', 'ACTIVE'),
(52, 28, 'Otra', 'ACTIVE'),
(53, 29, 'Otra', 'ACTIVE'),
(54, 30, 'Otra', 'ACTIVE'),
(55, 31, 'Otra', 'ACTIVE'),
(56, 32, 'Otra', 'ACTIVE'),
(57, 33, 'Otra', 'ACTIVE'),
(58, 34, 'Otra', 'ACTIVE'),
(59, 35, 'Otra', 'ACTIVE'),
(60, 36, 'Otra', 'ACTIVE'),
(61, 37, 'Otra', 'ACTIVE'),
(62, 38, 'Otra', 'ACTIVE'),
(63, 39, 'Otra', 'ACTIVE'),
(64, 40, 'Otra', 'ACTIVE'),
(65, 41, 'Otra', 'ACTIVE'),
(66, 42, 'Otra', 'ACTIVE'),
(67, 43, 'Otra', 'ACTIVE'),
(68, 44, 'Otra', 'ACTIVE'),
(69, 45, 'Otra', 'ACTIVE'),
(70, 46, 'Otra', 'ACTIVE'),
(71, 47, 'Otra', 'ACTIVE'),
(72, 48, 'Otra', 'ACTIVE'),
(73, 49, 'Otra', 'ACTIVE'),
(74, 50, 'Otra', 'ACTIVE'),
(75, 51, 'Otra', 'ACTIVE'),
(76, 52, 'Otra', 'ACTIVE'),
(77, 53, 'Otra', 'ACTIVE'),
(78, 54, 'Otra', 'ACTIVE'),
(79, 55, 'Otra', 'ACTIVE'),
(80, 56, 'Otra', 'ACTIVE'),
(81, 57, 'Otra', 'ACTIVE'),
(82, 58, 'Otra', 'ACTIVE'),
(83, 59, 'Otra', 'ACTIVE'),
(84, 60, 'Otra', 'ACTIVE'),
(85, 62, 'Otra', 'ACTIVE'),
(86, 63, 'Otra', 'ACTIVE'),
(87, 64, 'Otra', 'ACTIVE'),
(88, 65, 'Otra', 'ACTIVE'),
(89, 66, 'Otra', 'ACTIVE'),
(90, 67, 'Otra', 'ACTIVE'),
(91, 68, 'Otra', 'ACTIVE'),
(92, 69, 'Otra', 'ACTIVE'),
(93, 70, 'Otra', 'ACTIVE'),
(94, 71, 'Otra', 'ACTIVE'),
(95, 72, 'Otra', 'ACTIVE'),
(96, 73, 'Otra', 'ACTIVE'),
(97, 74, 'Otra', 'ACTIVE'),
(98, 75, 'Otra', 'ACTIVE'),
(99, 76, 'Otra', 'ACTIVE'),
(100, 77, 'Otra', 'ACTIVE'),
(101, 78, 'Otra', 'ACTIVE'),
(102, 79, 'Otra', 'ACTIVE'),
(103, 80, 'Otra', 'ACTIVE'),
(104, 81, 'Otra', 'ACTIVE'),
(105, 82, 'Otra', 'ACTIVE'),
(106, 83, 'Otra', 'ACTIVE'),
(107, 84, 'Otra', 'ACTIVE'),
(108, 85, 'Otra', 'ACTIVE'),
(109, 86, 'Otra', 'ACTIVE'),
(110, 87, 'Otra', 'ACTIVE'),
(111, 88, 'Otra', 'ACTIVE'),
(112, 89, 'Otra', 'ACTIVE'),
(113, 90, 'Otra', 'ACTIVE'),
(114, 91, 'Otra', 'ACTIVE'),
(115, 92, 'Otra', 'ACTIVE'),
(116, 93, 'Otra', 'ACTIVE'),
(117, 94, 'Otra', 'ACTIVE'),
(118, 95, 'Otra', 'ACTIVE'),
(119, 96, 'Otra', 'ACTIVE'),
(120, 97, 'Otra', 'ACTIVE'),
(121, 98, 'Otra', 'ACTIVE'),
(122, 99, 'Otra', 'ACTIVE'),
(123, 100, 'Otra', 'ACTIVE'),
(124, 101, 'Otra', 'ACTIVE'),
(125, 102, 'Otra', 'ACTIVE'),
(126, 103, 'Otra', 'ACTIVE'),
(127, 104, 'Otra', 'ACTIVE'),
(128, 105, 'Otra', 'ACTIVE'),
(129, 106, 'Otra', 'ACTIVE'),
(130, 107, 'Otra', 'ACTIVE'),
(131, 108, 'Otra', 'ACTIVE'),
(132, 109, 'Otra', 'ACTIVE'),
(133, 110, 'Otra', 'ACTIVE'),
(134, 111, 'Otra', 'ACTIVE'),
(135, 112, 'Otra', 'ACTIVE'),
(136, 113, 'Otra', 'ACTIVE'),
(137, 114, 'Otra', 'ACTIVE'),
(138, 115, 'Otra', 'ACTIVE'),
(139, 116, 'Otra', 'ACTIVE'),
(140, 117, 'Otra', 'ACTIVE'),
(141, 118, 'Otra', 'ACTIVE'),
(142, 119, 'Otra', 'ACTIVE'),
(143, 120, 'Otra', 'ACTIVE'),
(144, 121, 'Otra', 'ACTIVE'),
(145, 122, 'Otra', 'ACTIVE'),
(146, 123, 'Otra', 'ACTIVE'),
(147, 124, 'Otra', 'ACTIVE'),
(148, 125, 'Otra', 'ACTIVE'),
(149, 126, 'Otra', 'ACTIVE'),
(150, 127, 'Otra', 'ACTIVE'),
(151, 128, 'Otra', 'ACTIVE'),
(152, 129, 'Otra', 'ACTIVE'),
(153, 130, 'Otra', 'ACTIVE'),
(154, 131, 'Otra', 'ACTIVE'),
(155, 132, 'Otra', 'ACTIVE'),
(156, 133, 'Otra', 'ACTIVE'),
(157, 134, 'Otra', 'ACTIVE'),
(158, 135, 'Otra', 'ACTIVE'),
(159, 136, 'Otra', 'ACTIVE'),
(160, 137, 'Otra', 'ACTIVE'),
(161, 138, 'Otra', 'ACTIVE'),
(162, 139, 'Otra', 'ACTIVE'),
(163, 140, 'Otra', 'ACTIVE'),
(164, 141, 'Otra', 'ACTIVE'),
(165, 142, 'Otra', 'ACTIVE'),
(166, 143, 'Otra', 'ACTIVE'),
(167, 144, 'Otra', 'ACTIVE'),
(168, 145, 'Otra', 'ACTIVE'),
(169, 146, 'Otra', 'ACTIVE'),
(170, 147, 'Otra', 'ACTIVE'),
(171, 148, 'Otra', 'ACTIVE'),
(172, 149, 'Otra', 'ACTIVE'),
(173, 150, 'Otra', 'ACTIVE'),
(174, 151, 'Otra', 'ACTIVE'),
(175, 152, 'Otra', 'ACTIVE'),
(176, 153, 'Otra', 'ACTIVE'),
(177, 154, 'Otra', 'ACTIVE'),
(178, 155, 'Otra', 'ACTIVE'),
(179, 156, 'Otra', 'ACTIVE'),
(180, 157, 'Otra', 'ACTIVE'),
(181, 158, 'Otra', 'ACTIVE'),
(182, 159, 'Otra', 'ACTIVE'),
(183, 160, 'Otra', 'ACTIVE'),
(184, 161, 'Otra', 'ACTIVE'),
(185, 162, 'Otra', 'ACTIVE'),
(186, 163, 'Otra', 'ACTIVE'),
(187, 164, 'Otra', 'ACTIVE'),
(188, 165, 'Otra', 'ACTIVE'),
(189, 166, 'Otra', 'ACTIVE'),
(190, 167, 'Otra', 'ACTIVE'),
(191, 168, 'Otra', 'ACTIVE'),
(192, 169, 'Otra', 'ACTIVE'),
(193, 170, 'Otra', 'ACTIVE'),
(194, 171, 'Otra', 'ACTIVE'),
(195, 172, 'Otra', 'ACTIVE'),
(196, 173, 'Otra', 'ACTIVE'),
(197, 174, 'Otra', 'ACTIVE'),
(198, 175, 'Otra', 'ACTIVE'),
(199, 176, 'Otra', 'ACTIVE'),
(200, 177, 'Otra', 'ACTIVE'),
(201, 178, 'Otra', 'ACTIVE'),
(202, 179, 'Otra', 'ACTIVE'),
(203, 180, 'Otra', 'ACTIVE'),
(204, 181, 'Otra', 'ACTIVE'),
(205, 182, 'Otra', 'ACTIVE'),
(206, 183, 'Otra', 'ACTIVE'),
(207, 184, 'Otra', 'ACTIVE'),
(208, 185, 'Otra', 'ACTIVE'),
(209, 186, 'Otra', 'ACTIVE'),
(210, 187, 'Otra', 'ACTIVE'),
(211, 188, 'Otra', 'ACTIVE'),
(212, 189, 'Otra', 'ACTIVE'),
(213, 190, 'Otra', 'ACTIVE'),
(214, 191, 'Otra', 'ACTIVE'),
(215, 192, 'Otra', 'ACTIVE'),
(216, 193, 'Otra', 'ACTIVE'),
(217, 194, 'Otra', 'ACTIVE'),
(218, 195, 'Otra', 'ACTIVE'),
(219, 196, 'Otra', 'ACTIVE'),
(220, 197, 'Otra', 'ACTIVE'),
(221, 198, 'Otra', 'ACTIVE'),
(222, 199, 'Otra', 'ACTIVE'),
(223, 200, 'Otra', 'ACTIVE'),
(224, 201, 'Otra', 'ACTIVE'),
(225, 202, 'Otra', 'ACTIVE'),
(226, 203, 'Otra', 'ACTIVE'),
(227, 204, 'Otra', 'ACTIVE'),
(228, 205, 'Otra', 'ACTIVE'),
(229, 206, 'Otra', 'ACTIVE'),
(230, 207, 'Otra', 'ACTIVE'),
(231, 208, 'Otra', 'ACTIVE'),
(232, 209, 'Otra', 'ACTIVE'),
(233, 210, 'Otra', 'ACTIVE'),
(234, 211, 'Otra', 'ACTIVE'),
(235, 212, 'Otra', 'ACTIVE'),
(236, 213, 'Otra', 'ACTIVE'),
(237, 214, 'Otra', 'ACTIVE'),
(238, 215, 'Otra', 'ACTIVE'),
(239, 216, 'Otra', 'ACTIVE'),
(240, 217, 'Otra', 'ACTIVE'),
(241, 218, 'Otra', 'ACTIVE'),
(242, 219, 'Otra', 'ACTIVE'),
(243, 220, 'Otra', 'ACTIVE'),
(244, 221, 'Otra', 'ACTIVE'),
(245, 222, 'Otra', 'ACTIVE'),
(246, 223, 'Otra', 'ACTIVE'),
(247, 224, 'Otra', 'ACTIVE'),
(248, 225, 'Otra', 'ACTIVE'),
(249, 226, 'Otra', 'ACTIVE'),
(250, 227, 'Otra', 'ACTIVE'),
(251, 228, 'Otra', 'ACTIVE'),
(252, 229, 'Otra', 'ACTIVE'),
(253, 230, 'Otra', 'ACTIVE'),
(254, 231, 'Otra', 'ACTIVE'),
(255, 232, 'Otra', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'student'
--

INSERT INTO student (serial_std, serial_usr, serial_nnt, id_std, first_name_std, last_name_std, birthdate_std, gender_std, address_std, phone_std, type_std, status_std) VALUES
(1, 10, 21, 'STD1', 'Nelsinho', 'Mandela', '1990-11-06', 'MALE', '19 de noviembre y calle A #338', '12345677', 'NEW', 'ACTIVE'),
(2, 11, 1, 'STD2', 'Oswaldo', 'Guayasamin', '1990-11-30', 'MALE', 'bosmediano 555', '789456', 'NEW', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'student_activity_attachment'
--


--
-- Volcar la base de datos para la tabla 'student_by_course'
--

INSERT INTO student_by_course (serial_std, serial_crs, status_stc) VALUES
(1, 2, 'ACTIVE'),
(2, 1, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'student_criteria_grade'
--


--
-- Volcar la base de datos para la tabla 'student_guardian'
--

INSERT INTO student_guardian (serial_std, serial_grd, relationship_stg, legal_guardian_stg, status_stg) VALUES
(1, 1, 'PARENT', 'YES', 'ACTIVE'),
(2, 4, 'PARENT', 'YES', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'student_optional_subject'
--


--
-- Volcar la base de datos para la tabla 'student_year'
--

INSERT INTO student_year (matricule_number_sty, serial_std, serial_spt, serial_lvl, serial_scy, serial_set, status_sty) VALUES
('STD1', 1, 1, 2, 2, 1, 'REGISTERED'),
('STD2', 2, 1, 2, 2, 1, 'REGISTERED');

--
-- Volcar la base de datos para la tabla 'student_year_debts'
--


--
-- Volcar la base de datos para la tabla 'subject'
--

INSERT INTO subject (serial_sbj, serial_csb, serial_spt, serial_lvl, serial_scy, serial_set, status_sbj) VALUES
(1, 6, 1, 2, 2, 1, 'ACTIVE'),
(2, 7, 1, 2, 2, 1, 'ACTIVE'),
(3, 4, 1, 2, 2, 1, 'ACTIVE'),
(4, 4, 2, 1, 2, 2, 'ACTIVE'),
(5, 8, 2, 1, 2, 2, 'ACTIVE'),
(6, 4, 2, 3, 2, 2, 'ACTIVE'),
(7, 6, 2, 3, 2, 2, 'ACTIVE'),
(8, 12, 4, 1, 2, 2, 'ACTIVE'),
(9, 4, 4, 1, 2, 2, 'ACTIVE'),
(10, 12, 4, 3, 2, 2, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'subject_course'
--

INSERT INTO subject_course (serial_sbc, serial_sbj, serial_crs, serial_aca, serial_emp, status_sbc, grade_type_sbc, hours_week_sbc) VALUES
(1, 3, 1, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10),
(2, 3, 2, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10),
(3, 3, 3, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10),
(4, 2, 1, 2, 3, 'ACTIVE', 'QUANTITATIVE', 2),
(5, 2, 2, 2, 3, 'ACTIVE', 'QUANTITATIVE', 2),
(6, 2, 3, 2, 3, 'ACTIVE', 'QUANTITATIVE', 2),
(7, 1, 1, 2, 3, 'ACTIVE', 'QUANTITATIVE', 2),
(8, 1, 2, 2, 3, 'ACTIVE', 'QUANTITATIVE', 2),
(9, 1, 3, 2, 3, 'ACTIVE', 'QUANTITATIVE', 2),
(10, 4, 4, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10),
(11, 4, 5, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10),
(12, 5, 4, 3, 7, 'ACTIVE', 'QUANTITATIVE', 4),
(13, 5, 5, 3, 7, 'ACTIVE', 'QUANTITATIVE', 4),
(14, 6, 9, 1, 2, 'ACTIVE', 'QUANTITATIVE', 10),
(15, 7, 9, 2, 3, 'ACTIVE', 'QUANTITATIVE', 4),
(16, 8, 6, 5, 1, 'ACTIVE', 'QUANTITATIVE', 6),
(17, 9, 6, 1, 2, 'ACTIVE', 'QUANTITATIVE', 4),
(18, 10, 7, 5, 1, 'ACTIVE', 'QUANTITATIVE', 6),
(19, 10, 8, 5, 1, 'ACTIVE', 'QUANTITATIVE', 6);

--
-- Volcar la base de datos para la tabla 'subject_course_period'
--

INSERT INTO subject_course_period (serial_prd, serial_sbc, status_scp, weight_scp) VALUES
(1, 1, 'ACTIVE', '100.00'),
(1, 2, 'ACTIVE', '100.00'),
(1, 3, 'ACTIVE', '100.00'),
(1, 4, 'ACTIVE', '50.00'),
(1, 5, 'ACTIVE', '50.00'),
(1, 6, 'ACTIVE', '50.00'),
(1, 7, 'ACTIVE', '50.00'),
(1, 8, 'ACTIVE', '50.00'),
(1, 9, 'ACTIVE', '50.00'),
(1, 10, 'ACTIVE', '100.00'),
(1, 11, 'ACTIVE', '100.00'),
(1, 12, 'ACTIVE', '100.00'),
(1, 13, 'ACTIVE', '100.00'),
(1, 14, 'ACTIVE', '100.00'),
(1, 15, 'ACTIVE', '100.00'),
(1, 16, 'ACTIVE', '100.00'),
(1, 17, 'ACTIVE', '100.00'),
(1, 18, 'ACTIVE', '100.00'),
(1, 19, 'ACTIVE', '100.00'),
(2, 1, 'ACTIVE', '100.00'),
(2, 2, 'ACTIVE', '100.00'),
(2, 3, 'ACTIVE', '100.00'),
(2, 4, 'ACTIVE', '60.00'),
(2, 5, 'ACTIVE', '60.00'),
(2, 6, 'ACTIVE', '60.00'),
(2, 7, 'ACTIVE', '40.00'),
(2, 8, 'ACTIVE', '40.00'),
(2, 9, 'ACTIVE', '40.00'),
(2, 10, 'ACTIVE', '100.00'),
(2, 11, 'ACTIVE', '100.00'),
(2, 12, 'ACTIVE', '100.00'),
(2, 13, 'ACTIVE', '100.00'),
(2, 14, 'ACTIVE', '100.00'),
(2, 15, 'ACTIVE', '100.00'),
(2, 16, 'ACTIVE', '100.00'),
(2, 17, 'ACTIVE', '100.00'),
(2, 18, 'ACTIVE', '100.00'),
(2, 19, 'ACTIVE', '100.00'),
(3, 1, 'ACTIVE', '100.00'),
(3, 2, 'ACTIVE', '100.00'),
(3, 3, 'ACTIVE', '100.00'),
(3, 4, 'ACTIVE', '100.00'),
(3, 5, 'ACTIVE', '100.00'),
(3, 6, 'ACTIVE', '100.00'),
(3, 7, 'ACTIVE', '0.00'),
(3, 8, 'ACTIVE', '0.00'),
(3, 9, 'ACTIVE', '0.00'),
(3, 10, 'ACTIVE', '100.00'),
(3, 11, 'ACTIVE', '100.00'),
(3, 12, 'ACTIVE', '100.00'),
(3, 13, 'ACTIVE', '100.00'),
(3, 14, 'ACTIVE', '100.00'),
(3, 15, 'ACTIVE', '100.00'),
(3, 16, 'ACTIVE', '100.00'),
(3, 17, 'ACTIVE', '100.00'),
(3, 18, 'ACTIVE', '100.00'),
(3, 19, 'ACTIVE', '100.00');

--
-- Volcar la base de datos para la tabla 'subject_period_activity_type'
--

INSERT INTO subject_period_activity_type (serial_att, serial_prd, serial_sbc, weight_spa, status_spa) VALUES
(2, 1, 14, '25.00', 'ACTIVE'),
(2, 1, 15, '25.00', 'ACTIVE'),
(2, 1, 18, '25.00', 'ACTIVE'),
(2, 1, 19, '25.00', 'ACTIVE'),
(2, 2, 12, '25.00', 'ACTIVE'),
(2, 2, 14, '25.00', 'ACTIVE'),
(2, 2, 15, '25.00', 'ACTIVE'),
(2, 2, 18, '25.00', 'ACTIVE'),
(2, 2, 19, '25.00', 'ACTIVE'),
(2, 3, 1, '0.00', 'INACTIVE'),
(2, 3, 2, '0.00', 'INACTIVE'),
(2, 3, 3, '0.00', 'INACTIVE'),
(2, 3, 4, '0.00', 'INACTIVE'),
(2, 3, 5, '0.00', 'INACTIVE'),
(2, 3, 6, '0.00', 'INACTIVE'),
(2, 3, 7, '0.00', 'INACTIVE'),
(2, 3, 8, '0.00', 'INACTIVE'),
(2, 3, 9, '0.00', 'INACTIVE'),
(2, 3, 12, '25.00', 'ACTIVE'),
(2, 3, 14, '0.00', 'INACTIVE'),
(2, 3, 15, '0.00', 'INACTIVE'),
(2, 3, 18, '0.00', 'INACTIVE'),
(2, 3, 19, '0.00', 'INACTIVE'),
(3, 1, 1, '50.00', 'ACTIVE'),
(3, 1, 2, '50.00', 'ACTIVE'),
(3, 1, 3, '50.00', 'ACTIVE'),
(3, 1, 4, '50.00', 'ACTIVE'),
(3, 1, 5, '50.00', 'ACTIVE'),
(3, 1, 6, '50.00', 'ACTIVE'),
(3, 1, 7, '50.00', 'ACTIVE'),
(3, 1, 8, '50.00', 'ACTIVE'),
(3, 1, 9, '50.00', 'ACTIVE'),
(3, 1, 10, '75.00', 'ACTIVE'),
(3, 1, 11, '75.00', 'ACTIVE'),
(3, 1, 12, '75.00', 'ACTIVE'),
(3, 1, 13, '75.00', 'ACTIVE'),
(3, 1, 14, '50.00', 'ACTIVE'),
(3, 1, 15, '50.00', 'ACTIVE'),
(3, 1, 16, '75.00', 'ACTIVE'),
(3, 1, 17, '75.00', 'ACTIVE'),
(3, 1, 18, '50.00', 'ACTIVE'),
(3, 1, 19, '50.00', 'ACTIVE'),
(3, 2, 7, '100.00', 'ACTIVE'),
(3, 2, 12, '50.00', 'ACTIVE'),
(3, 2, 14, '50.00', 'ACTIVE'),
(3, 2, 15, '50.00', 'ACTIVE'),
(3, 2, 18, '50.00', 'ACTIVE'),
(3, 2, 19, '50.00', 'ACTIVE'),
(3, 3, 1, '100.00', 'ACTIVE'),
(3, 3, 2, '100.00', 'ACTIVE'),
(3, 3, 3, '100.00', 'ACTIVE'),
(3, 3, 4, '100.00', 'ACTIVE'),
(3, 3, 5, '100.00', 'ACTIVE'),
(3, 3, 6, '100.00', 'ACTIVE'),
(3, 3, 7, '100.00', 'ACTIVE'),
(3, 3, 8, '100.00', 'ACTIVE'),
(3, 3, 9, '100.00', 'ACTIVE'),
(3, 3, 12, '50.00', 'ACTIVE'),
(3, 3, 14, '100.00', 'ACTIVE'),
(3, 3, 15, '100.00', 'ACTIVE'),
(3, 3, 18, '100.00', 'ACTIVE'),
(3, 3, 19, '100.00', 'ACTIVE'),
(4, 1, 1, '50.00', 'ACTIVE'),
(4, 1, 2, '50.00', 'ACTIVE'),
(4, 1, 3, '50.00', 'ACTIVE'),
(4, 1, 4, '50.00', 'ACTIVE'),
(4, 1, 5, '50.00', 'ACTIVE'),
(4, 1, 6, '50.00', 'ACTIVE'),
(4, 1, 7, '50.00', 'ACTIVE'),
(4, 1, 8, '50.00', 'ACTIVE'),
(4, 1, 9, '50.00', 'ACTIVE'),
(4, 1, 10, '25.00', 'ACTIVE'),
(4, 1, 11, '25.00', 'ACTIVE'),
(4, 1, 12, '25.00', 'ACTIVE'),
(4, 1, 13, '25.00', 'ACTIVE'),
(4, 1, 14, '25.00', 'ACTIVE'),
(4, 1, 15, '25.00', 'ACTIVE'),
(4, 1, 16, '25.00', 'ACTIVE'),
(4, 1, 17, '25.00', 'ACTIVE'),
(4, 1, 18, '25.00', 'ACTIVE'),
(4, 1, 19, '25.00', 'ACTIVE'),
(4, 2, 12, '25.00', 'ACTIVE'),
(4, 2, 14, '25.00', 'ACTIVE'),
(4, 2, 15, '25.00', 'ACTIVE'),
(4, 2, 18, '25.00', 'ACTIVE'),
(4, 2, 19, '25.00', 'ACTIVE'),
(4, 3, 1, '0.00', 'INACTIVE'),
(4, 3, 2, '0.00', 'INACTIVE'),
(4, 3, 3, '0.00', 'INACTIVE'),
(4, 3, 4, '0.00', 'INACTIVE'),
(4, 3, 5, '0.00', 'INACTIVE'),
(4, 3, 6, '0.00', 'INACTIVE'),
(4, 3, 7, '0.00', 'INACTIVE'),
(4, 3, 8, '0.00', 'INACTIVE'),
(4, 3, 9, '0.00', 'INACTIVE'),
(4, 3, 12, '25.00', 'ACTIVE'),
(4, 3, 14, '0.00', 'INACTIVE'),
(4, 3, 15, '0.00', 'INACTIVE'),
(4, 3, 18, '0.00', 'INACTIVE'),
(4, 3, 19, '0.00', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'subject_year_activity_criteria_period'
--

INSERT INTO subject_year_activity_criteria_period (serial_att, serial_prd, serial_sbc, serial_sbj, serial_gct, status_acp) VALUES
(2, 2, 12, 5, 2, 'ACTIVE'),
(2, 2, 12, 5, 3, 'ACTIVE'),
(2, 3, 1, 3, 2, 'INACTIVE'),
(2, 3, 1, 3, 4, 'INACTIVE'),
(2, 3, 1, 3, 5, 'INACTIVE'),
(2, 3, 2, 3, 2, 'INACTIVE'),
(2, 3, 2, 3, 4, 'INACTIVE'),
(2, 3, 2, 3, 5, 'INACTIVE'),
(2, 3, 3, 3, 2, 'INACTIVE'),
(2, 3, 3, 3, 4, 'INACTIVE'),
(2, 3, 3, 3, 5, 'INACTIVE'),
(2, 3, 4, 2, 2, 'INACTIVE'),
(2, 3, 4, 2, 4, 'INACTIVE'),
(2, 3, 4, 2, 5, 'INACTIVE'),
(2, 3, 5, 2, 2, 'INACTIVE'),
(2, 3, 5, 2, 4, 'INACTIVE'),
(2, 3, 5, 2, 5, 'INACTIVE'),
(2, 3, 6, 2, 2, 'INACTIVE'),
(2, 3, 6, 2, 4, 'INACTIVE'),
(2, 3, 6, 2, 5, 'INACTIVE'),
(2, 3, 7, 1, 2, 'INACTIVE'),
(2, 3, 7, 1, 4, 'INACTIVE'),
(2, 3, 7, 1, 5, 'INACTIVE'),
(2, 3, 8, 1, 2, 'INACTIVE'),
(2, 3, 8, 1, 4, 'INACTIVE'),
(2, 3, 8, 1, 5, 'INACTIVE'),
(2, 3, 9, 1, 2, 'INACTIVE'),
(2, 3, 9, 1, 4, 'INACTIVE'),
(2, 3, 9, 1, 5, 'INACTIVE'),
(2, 3, 12, 5, 2, 'ACTIVE'),
(2, 3, 12, 5, 3, 'ACTIVE'),
(3, 1, 1, 3, 2, 'ACTIVE'),
(3, 1, 1, 3, 4, 'ACTIVE'),
(3, 1, 1, 3, 5, 'ACTIVE'),
(3, 1, 2, 3, 2, 'ACTIVE'),
(3, 1, 2, 3, 4, 'ACTIVE'),
(3, 1, 2, 3, 5, 'ACTIVE'),
(3, 1, 3, 3, 2, 'ACTIVE'),
(3, 1, 3, 3, 4, 'ACTIVE'),
(3, 1, 3, 3, 5, 'ACTIVE'),
(3, 1, 4, 2, 2, 'ACTIVE'),
(3, 1, 4, 2, 4, 'ACTIVE'),
(3, 1, 4, 2, 5, 'ACTIVE'),
(3, 1, 5, 2, 2, 'ACTIVE'),
(3, 1, 5, 2, 4, 'ACTIVE'),
(3, 1, 5, 2, 5, 'ACTIVE'),
(3, 1, 6, 2, 2, 'ACTIVE'),
(3, 1, 6, 2, 4, 'ACTIVE'),
(3, 1, 6, 2, 5, 'ACTIVE'),
(3, 1, 7, 1, 2, 'ACTIVE'),
(3, 1, 7, 1, 4, 'ACTIVE'),
(3, 1, 7, 1, 5, 'ACTIVE'),
(3, 1, 8, 1, 2, 'ACTIVE'),
(3, 1, 8, 1, 4, 'ACTIVE'),
(3, 1, 8, 1, 5, 'ACTIVE'),
(3, 1, 9, 1, 2, 'ACTIVE'),
(3, 1, 9, 1, 4, 'ACTIVE'),
(3, 1, 9, 1, 5, 'ACTIVE'),
(3, 1, 10, 4, 2, 'ACTIVE'),
(3, 1, 10, 4, 3, 'ACTIVE'),
(3, 1, 11, 4, 2, 'ACTIVE'),
(3, 1, 11, 4, 3, 'ACTIVE'),
(3, 1, 12, 5, 2, 'ACTIVE'),
(3, 1, 12, 5, 3, 'ACTIVE'),
(3, 1, 13, 5, 2, 'ACTIVE'),
(3, 1, 13, 5, 3, 'ACTIVE'),
(3, 2, 7, 1, 2, 'ACTIVE'),
(3, 2, 7, 1, 4, 'ACTIVE'),
(3, 2, 7, 1, 5, 'ACTIVE'),
(3, 2, 12, 5, 2, 'ACTIVE'),
(3, 2, 12, 5, 3, 'ACTIVE'),
(3, 3, 1, 3, 2, 'ACTIVE'),
(3, 3, 1, 3, 4, 'ACTIVE'),
(3, 3, 1, 3, 5, 'ACTIVE'),
(3, 3, 2, 3, 2, 'ACTIVE'),
(3, 3, 2, 3, 4, 'ACTIVE'),
(3, 3, 2, 3, 5, 'ACTIVE'),
(3, 3, 3, 3, 2, 'ACTIVE'),
(3, 3, 3, 3, 4, 'ACTIVE'),
(3, 3, 3, 3, 5, 'ACTIVE'),
(3, 3, 4, 2, 2, 'ACTIVE'),
(3, 3, 4, 2, 4, 'ACTIVE'),
(3, 3, 4, 2, 5, 'ACTIVE'),
(3, 3, 5, 2, 2, 'ACTIVE'),
(3, 3, 5, 2, 4, 'ACTIVE'),
(3, 3, 5, 2, 5, 'ACTIVE'),
(3, 3, 6, 2, 2, 'ACTIVE'),
(3, 3, 6, 2, 4, 'ACTIVE'),
(3, 3, 6, 2, 5, 'ACTIVE'),
(3, 3, 7, 1, 2, 'ACTIVE'),
(3, 3, 7, 1, 4, 'ACTIVE'),
(3, 3, 7, 1, 5, 'ACTIVE'),
(3, 3, 8, 1, 2, 'ACTIVE'),
(3, 3, 8, 1, 4, 'ACTIVE'),
(3, 3, 8, 1, 5, 'ACTIVE'),
(3, 3, 9, 1, 2, 'ACTIVE'),
(3, 3, 9, 1, 4, 'ACTIVE'),
(3, 3, 9, 1, 5, 'ACTIVE'),
(3, 3, 12, 5, 2, 'ACTIVE'),
(3, 3, 12, 5, 3, 'ACTIVE'),
(4, 1, 1, 3, 2, 'ACTIVE'),
(4, 1, 1, 3, 4, 'ACTIVE'),
(4, 1, 1, 3, 5, 'ACTIVE'),
(4, 1, 2, 3, 2, 'ACTIVE'),
(4, 1, 2, 3, 4, 'ACTIVE'),
(4, 1, 2, 3, 5, 'ACTIVE'),
(4, 1, 3, 3, 2, 'ACTIVE'),
(4, 1, 3, 3, 4, 'ACTIVE'),
(4, 1, 3, 3, 5, 'ACTIVE'),
(4, 1, 4, 2, 2, 'ACTIVE'),
(4, 1, 4, 2, 4, 'ACTIVE'),
(4, 1, 4, 2, 5, 'ACTIVE'),
(4, 1, 5, 2, 2, 'ACTIVE'),
(4, 1, 5, 2, 4, 'ACTIVE'),
(4, 1, 5, 2, 5, 'ACTIVE'),
(4, 1, 6, 2, 2, 'ACTIVE'),
(4, 1, 6, 2, 4, 'ACTIVE'),
(4, 1, 6, 2, 5, 'ACTIVE'),
(4, 1, 7, 1, 2, 'ACTIVE'),
(4, 1, 7, 1, 4, 'ACTIVE'),
(4, 1, 7, 1, 5, 'INACTIVE'),
(4, 1, 8, 1, 2, 'ACTIVE'),
(4, 1, 8, 1, 4, 'ACTIVE'),
(4, 1, 8, 1, 5, 'ACTIVE'),
(4, 1, 9, 1, 2, 'ACTIVE'),
(4, 1, 9, 1, 4, 'ACTIVE'),
(4, 1, 9, 1, 5, 'ACTIVE'),
(4, 1, 10, 4, 2, 'ACTIVE'),
(4, 1, 10, 4, 3, 'ACTIVE'),
(4, 1, 11, 4, 2, 'ACTIVE'),
(4, 1, 11, 4, 3, 'ACTIVE'),
(4, 1, 12, 5, 2, 'ACTIVE'),
(4, 1, 12, 5, 3, 'ACTIVE'),
(4, 1, 13, 5, 2, 'ACTIVE'),
(4, 1, 13, 5, 3, 'ACTIVE'),
(4, 2, 12, 5, 2, 'ACTIVE'),
(4, 2, 12, 5, 3, 'ACTIVE'),
(4, 3, 1, 3, 2, 'INACTIVE'),
(4, 3, 1, 3, 4, 'INACTIVE'),
(4, 3, 1, 3, 5, 'INACTIVE'),
(4, 3, 2, 3, 2, 'INACTIVE'),
(4, 3, 2, 3, 4, 'INACTIVE'),
(4, 3, 2, 3, 5, 'INACTIVE'),
(4, 3, 3, 3, 2, 'INACTIVE'),
(4, 3, 3, 3, 4, 'INACTIVE'),
(4, 3, 3, 3, 5, 'INACTIVE'),
(4, 3, 4, 2, 2, 'INACTIVE'),
(4, 3, 4, 2, 4, 'INACTIVE'),
(4, 3, 4, 2, 5, 'INACTIVE'),
(4, 3, 5, 2, 2, 'INACTIVE'),
(4, 3, 5, 2, 4, 'INACTIVE'),
(4, 3, 5, 2, 5, 'INACTIVE'),
(4, 3, 6, 2, 2, 'INACTIVE'),
(4, 3, 6, 2, 4, 'INACTIVE'),
(4, 3, 6, 2, 5, 'INACTIVE'),
(4, 3, 7, 1, 2, 'INACTIVE'),
(4, 3, 7, 1, 4, 'INACTIVE'),
(4, 3, 7, 1, 5, 'INACTIVE'),
(4, 3, 8, 1, 2, 'INACTIVE'),
(4, 3, 8, 1, 4, 'INACTIVE'),
(4, 3, 8, 1, 5, 'INACTIVE'),
(4, 3, 9, 1, 2, 'INACTIVE'),
(4, 3, 9, 1, 4, 'INACTIVE'),
(4, 3, 9, 1, 5, 'INACTIVE'),
(4, 3, 12, 5, 2, 'ACTIVE'),
(4, 3, 12, 5, 3, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'subject_year_grade_criteria'
--

INSERT INTO subject_year_grade_criteria (serial_sbj, serial_gct, status_sgc) VALUES
(1, 2, 'ACTIVE'),
(1, 4, 'ACTIVE'),
(1, 5, 'ACTIVE'),
(2, 2, 'ACTIVE'),
(2, 4, 'ACTIVE'),
(2, 5, 'ACTIVE'),
(3, 2, 'ACTIVE'),
(3, 4, 'ACTIVE'),
(3, 5, 'ACTIVE'),
(4, 2, 'ACTIVE'),
(4, 3, 'ACTIVE'),
(5, 2, 'ACTIVE'),
(5, 3, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'syllabus_files'
--


--
-- Volcar la base de datos para la tabla 'syllabus_files_change_log'
--


--
-- Volcar la base de datos para la tabla 'taxes'
--

INSERT INTO taxes (serial_tax, name_tax, description_tax, status_tax) VALUES
(1, 'IVA', 'el ivaff', 'ACTIVE'),
(2, 'ICE', 'Impuesto a Consumos Especiales ááá &lt;input type=&quot;text&quot; name=&quot;test&quot; id=&quot;test&quot; value=&quot;TEST!&quot;&gt;', 'ACTIVE'),
(3, '$%&/(()', 'test caracteres especiales nombre', 'INACTIVE');

--
-- Volcar la base de datos para la tabla 'teacher_degree'
--

INSERT INTO teacher_degree (serial_tdg, name_tdg, status_tdg) VALUES
(1, 'Licenciado en Ciencias de la Educación', 'ACTIVE'),
(2, 'Profesores de segunda enseñanza', 'ACTIVE'),
(3, 'Otros Títulos en CCEE con 4 o más años de estudio', 'ACTIVE'),
(4, 'Profesores de Primaria(Ins.Pedagógico)', 'ACTIVE'),
(5, 'Tecnológico Educativo', 'ACTIVE'),
(6, 'Auxiliar Pedagógico', 'ACTIVE'),
(7, 'Asistente Pedagógico', 'ACTIVE'),
(8, 'Facilitador Pedagógico', 'ACTIVE'),
(9, 'Bachiller en Ciencias de la Educación', 'ACTIVE'),
(10, 'Normalista rural', 'ACTIVE'),
(11, 'Doctorado en ciencias de la educación', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'teacher_hours_year'
--


--
-- Volcar la base de datos para la tabla 'teacher_master_degree'
--

INSERT INTO teacher_master_degree (serial_tmd, name_tmd, status_tmd) VALUES
(1, 'Máster y/o Phd en ciencias de la educación', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'teacher_specialty'
--

INSERT INTO teacher_specialty (serial_tst, name_tst, status_tst) VALUES
(1, 'Administración educativa', 'ACTIVE'),
(2, 'Artes aplicadas', 'ACTIVE'),
(3, 'Auxiliar de laboratorio de ciencias naturales y Biología', 'ACTIVE'),
(4, 'Ciencias exactas', 'ACTIVE'),
(5, 'Ciencias sociales', 'ACTIVE'),
(6, 'Comercio ya dministración', 'ACTIVE'),
(7, 'Comunicación educativa', 'ACTIVE'),
(8, 'Contabilidad y administración', 'ACTIVE'),
(9, 'Diseño y dibujo', 'ACTIVE'),
(10, 'Docencia y desarrollo comunitario', 'ACTIVE'),
(11, 'Docencia y gestión en educación básica', 'ACTIVE'),
(12, 'Ecoturismo', 'ACTIVE'),
(13, 'Educación artística', 'ACTIVE'),
(14, 'Educación primaria', 'ACTIVE'),
(15, 'Educación especial', 'ACTIVE'),
(16, 'Educación inicial', 'ACTIVE'),
(17, 'Educación parvularia', 'ACTIVE'),
(18, 'Educación superior', 'ACTIVE'),
(19, 'Electricidad', 'ACTIVE'),
(20, 'Filosofía y pedagogía', 'ACTIVE'),
(21, 'Físico matemáticas', 'ACTIVE'),
(22, 'Gerencia educativa', 'ACTIVE'),
(23, 'Idiomas', 'ACTIVE'),
(24, 'Informática', 'ACTIVE'),
(25, 'Informática y programación', 'ACTIVE'),
(26, 'Inglés y plurilingue', 'ACTIVE'),
(27, 'Laboratorio de ciencias naturales', 'ACTIVE'),
(28, 'Liderazgo educativo', 'ACTIVE'),
(29, 'Literatura y castellano', 'ACTIVE'),
(30, 'Mecánica industrial', 'ACTIVE'),
(31, 'Monitor de actividad física', 'ACTIVE'),
(32, 'Pedagogía y gerencia educativa', 'ACTIVE'),
(33, 'Promoción y educación para la salud', 'ACTIVE'),
(34, 'Psicología educativa y orientación vocacional', 'ACTIVE'),
(35, 'Psicología infantil', 'ACTIVE'),
(36, 'Psicopedagogía infantil', 'ACTIVE'),
(37, 'Químico biológicas', 'ACTIVE'),
(38, 'Supervisión y administración educativa', 'ACTIVE'),
(39, 'Turismo histórico y cultural', 'ACTIVE'),
(40, 'Administación', 'ACTIVE'),
(41, 'Informática', 'ACTIVE'),
(42, 'Comunicación', 'ACTIVE'),
(43, 'Agronomía', 'ACTIVE'),
(44, 'Medicina', 'ACTIVE'),
(45, 'Civil/arquitectura', 'ACTIVE'),
(46, 'Teología', 'ACTIVE'),
(47, 'Administración y supervisión educativa', 'ACTIVE'),
(48, 'Asignaturas secretariales', 'ACTIVE'),
(49, 'Bellas artes', 'ACTIVE'),
(50, 'Ciencias naturales', 'ACTIVE'),
(51, 'Ciencias socioeconómicas y políticas', 'ACTIVE'),
(52, 'Computación', 'ACTIVE'),
(53, 'Contabilidad', 'ACTIVE'),
(54, 'Cultura fisica', 'ACTIVE'),
(55, 'Docencia primaria', 'ACTIVE'),
(56, 'Docencia y gestión en bachillerato', 'ACTIVE'),
(57, 'Docencia y gestión en educación parvularia', 'ACTIVE'),
(58, 'Educación ambiental', 'ACTIVE'),
(59, 'Educación básica', 'ACTIVE'),
(60, 'Educación de adultos', 'ACTIVE'),
(61, 'Educación física,deportes y recreación', 'ACTIVE'),
(62, 'Educación intercultural bilingüe', 'ACTIVE'),
(63, 'Educación preescolar', 'ACTIVE'),
(64, 'Educación y estudios interculturales', 'ACTIVE'),
(65, 'Filosofía y ciencias psicosociales', 'ACTIVE'),
(66, 'Filosofía,sociología y economía', 'ACTIVE'),
(67, 'Geografía y ecología', 'ACTIVE'),
(68, 'Historia y geografía', 'ACTIVE'),
(69, 'Idiomas y lingüística', 'ACTIVE'),
(70, 'Informática educativa', 'ACTIVE'),
(71, 'Inglés', 'ACTIVE'),
(72, 'Investigación y planificación educativa', 'ACTIVE'),
(73, 'Lengua y literatura', 'ACTIVE'),
(74, 'Lingüística(inglés-francés,inglés-italiano,inglés-alemán)', 'ACTIVE'),
(75, 'Mecánica automotriz', 'ACTIVE'),
(76, 'Mercadotecnia y publicidad', 'ACTIVE'),
(77, 'Opciones prácticas', 'ACTIVE'),
(78, 'Planificación y diseño curricular', 'ACTIVE'),
(79, 'Psicología del adolescente y orientación', 'ACTIVE'),
(80, 'Psicología gerontológico', 'ACTIVE'),
(81, 'Psicología y pedagogía', 'ACTIVE'),
(82, 'Psicorehabilitación y educación especial', 'ACTIVE'),
(83, 'Secretariado en español', 'ACTIVE'),
(84, 'Teatro y arte dramatico', 'ACTIVE'),
(85, 'Otras especializaciones de títulos docentes', 'ACTIVE'),
(86, 'Economía', 'ACTIVE'),
(87, 'Derecho', 'ACTIVE'),
(88, 'Medicina veterinaria', 'ACTIVE'),
(89, 'Geología', 'ACTIVE'),
(90, 'Antropología', 'ACTIVE'),
(91, 'Otras ingenierías', 'ACTIVE'),
(92, 'Artes', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'university'
--

INSERT INTO university (serial_unv, name_unv, status_unv) VALUES
(1, 'Escuela Politécnica del Ejército', 'ACTIVE'),
(2, 'Escuela Politécnica Nacional', 'ACTIVE'),
(3, 'Universidad Central del Ecuador', 'ACTIVE'),
(4, 'Universidad Tecnológica Equinoccial', 'ACTIVE'),
(5, 'Escuela Politécnica Javeriana', 'ACTIVE'),
(6, 'Universidad Autónoma de Quito', 'ACTIVE'),
(7, 'Universidad Del Pacífico', 'ACTIVE'),
(8, 'Universidad Tecnológica America', 'ACTIVE'),
(9, 'Universidad Tecnológica Israel', 'ACTIVE'),
(10, 'Universidad De Especialidades Turisticas', 'ACTIVE'),
(11, 'Universidad de las Americas', 'ACTIVE'),
(12, 'Universidad Internacional del Ecuador', 'ACTIVE'),
(13, 'Universidad Internacional SEK', 'ACTIVE'),
(14, 'Universidad San Francisco de Quito', 'ACTIVE'),
(15, 'Universidad Politécnica Salesiana', 'ACTIVE'),
(16, 'Pontificia Universidad Catolica del Ecuador', 'ACTIVE'),
(17, 'Universidad Tecnológica Indoamérica', 'ACTIVE'),
(18, 'Otra', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'user'
--

INSERT INTO user (serial_usr, serial_emp, serial_grd, serial_std, username_usr, password_usr, photo_usr, status_usr) VALUES
(1, NULL, NULL, NULL, 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, 'ACTIVE'),
(2, 1, 1, NULL, 'padre', 'e10adc3949ba59abbe56e057f20f883e', NULL, 'ACTIVE'),
(3, 2, NULL, NULL, 'fejiméne', NULL, NULL, 'ACTIVE'),
(4, 3, 2, NULL, 'frmiño', NULL, 'f42804.jpg', 'ACTIVE'),
(5, 4, NULL, NULL, 'elgonzal', NULL, NULL, 'ACTIVE'),
(6, 5, NULL, NULL, 'mógonzal', NULL, '7512ed.jpg', 'ACTIVE'),
(7, NULL, 3, NULL, 'magonzal', NULL, '9e344e.jpg', 'ACTIVE'),
(8, 6, NULL, NULL, 'caperez', NULL, '782e72.jpg', 'ACTIVE'),
(9, 7, NULL, NULL, 'femerchá', NULL, '692cb9.jpg', 'ACTIVE'),
(10, NULL, NULL, 1, 'nemandel', NULL, NULL, 'ACTIVE'),
(11, NULL, NULL, 2, 'osguayas', NULL, NULL, 'ACTIVE'),
(12, NULL, 4, NULL, 'osguayas1', NULL, '9b1717.jpeg', 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'user_profile'
--

INSERT INTO user_profile (serial_usr, serial_prf, status_upr) VALUES
(1, 1, 'ACTIVE'),
(2, 2, 'ACTIVE'),
(2, 4, 'ACTIVE'),
(3, 4, 'ACTIVE'),
(4, 4, 'ACTIVE'),
(5, 4, 'INACTIVE'),
(4, 5, 'ACTIVE'),
(5, 5, 'INACTIVE'),
(4, 2, 'INACTIVE'),
(6, 4, 'ACTIVE'),
(6, 5, 'ACTIVE'),
(7, 2, 'ACTIVE'),
(8, 5, 'ACTIVE'),
(9, 4, 'ACTIVE'),
(9, 6, 'ACTIVE'),
(10, 3, 'ACTIVE'),
(11, 3, 'ACTIVE');

--
-- Volcar la base de datos para la tabla 'year_concept_taxes'
--


--
-- Volcar la base de datos para la tabla 'year_level_specialty_payment_concept'
--
SET FOREIGN_KEY_CHECKS =1;
