SET FOREIGN_KEY_CHECKS =0;

/*==============================================================*/
/*Table: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'),
(46, 314, 'Nueva Inscripci�n', 'modules/pre_registration/fNewPreRegistration', '45.0', 'LOCKABLE'),
(47, 314, 'Actualizar Inscripci�n', 'modules/pre_registration/fSelectPreRegisteredToUpdate', '45.1', 'LOCKABLE'),
(48, 321, 'Revisar Inscripciones', 'modules/pre_registration/documents/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, NULL, 'Usuarios', '#', '40.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, 314, 'Documentaci�n de Aprobados', 'modules/student_documents/fRegisterRequiredDocuments', '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'),
(122, 199, 'Calificar Actividad', '#', '302', 'LOCKABLE'),
(123, 199, 'Recalificar Actividad', '#', '134.1', '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'),
(130, 310, 'Ver Actividades', '#', '134.3', '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'),
(135, 199, 'Plan de Estudios', 'modules/syllabus_files/fAssignSyllabusFiles', '304.0', 'LOCKABLE'),
(136, 199, 'Plan de Estudios Profesores', 'modules/syllabus_files_change_log/fChangeSyllabusFiles', '134', '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'),
(139, 311, 'Pensum de Estudios', 'modules/student_details/fSyllabusFilesDetail', '3.0', 'LOCKABLE'),
(140, 310, 'Calendario Actividades', 'modules/activity/fStudentCalendarActivity', '0.5', 'LOCKABLE'),
(141, 310, 'Calendario Representante', 'modules/activity/fGuardianCalendarActivity', '0.5', 'LOCKABLE'),
(142, 199, 'Calendario Actividades', '#', '300', 'LOCKABLE'),
(143, 365, 'Disciplina', '#', '2', 'LOCKABLE'),
(144, 143, 'Disciplina General', 'modules/discipline/fDisciplineGeneralGrade', '1.0', 'LOCKABLE'),
(145, 143, 'Disciplina x Materia', 'modules/student_criteria_grade/fGradeDisciplineByCourse', '1.0', 'LOCKABLE'),
(146, 143, 'Recalificar Disciplina x Materia', 'modules/student_criteria_grade/fGradeDisciplineByCourseLog', '1.0', 'LOCKABLE'),
(147, NULL, 'Mensajer�a', '#', '147.0', 'LOCKABLE'),
(148, 147, 'Bandeja', 'modules/message/fInbox', '1.0', 'LOCKABLE'),
(149, NULL, 'Reportes', '#', '149.0', 'LOCKABLE'),
(150, 149, 'Profesores', '#', '1.0', 'LOCKABLE'),
(151, 149, 'Estudiantes', '#', '2.0', 'LOCKABLE'),
(152, 150, 'Area Acad�mica', 'modules/reports/employee/teacher/fViewTeachersByArea', '1.0', 'LOCKABLE'),
(153, 151, 'Lista detallada Curso/Optativa', 'modules/reports/student/fViewStudentsByCourseOrOptSubject', '1.0', 'LOCKABLE'),
(154, 1, 'Mensajer�a', '#', '69.0', 'LOCKABLE'),
(155, 154, 'Configurar Receptor', 'modules/message/fMessagesBetweenProfiles', '1.0', 'LOCKABLE'),
(156, NULL, 'Financiero', '#', '148.0', 'LOCKABLE'),
(157, 156, 'Realizar Cobro', 'modules/student_year_debts/fSearchStudentForPayingDebts', '2.0', 'LOCKABLE'),
(158, 149, 'Usuarios', '#', '3.0', 'LOCKABLE'),
(159, 158, 'Ingreso al Sistema', 'modules/reports/user/fUserAccessLog', '1.0', 'LOCKABLE'),
(161, 147, 'Enviar Comunicaci�n', 'modules/message/fSendCommunication', '2.0', 'LOCKABLE'),
(162, 1, 'Razones de Cambio', '#', '49.4', 'LOCKABLE'),
(163, 162, 'Nueva Raz�n', 'modules/change_reason/fNewChangeReason', '1.0', 'LOCKABLE'),
(164, 162, 'Actualizar Raz�n', 'modules/change_reason/fSearchChangeReason', '2.0', 'LOCKABLE'),
(165, 39, 'Dirigentes de Curso', '#', '59.1', 'LOCKABLE'),
(166, 165, 'Iniciar/Continuar', 'modules/course_director/fNewCourseDirector', '1.0', 'LOCKABLE'),
(167, 39, 'Definici�n de Notas', '#', '59.1', 'LOCKABLE'),
(168, 167, 'Equivalencia de Cualitativas', 'modules/qualitative_equivalence/fNewQualitativeEquivalence', '1.0', 'LOCKABLE'),
(169, 167, 'M�nimo de Supletorios', 'modules/year_resit_exam_ranges/fNewYearResitExamRanges', '2.0', 'LOCKABLE'),
(170, 39, 'Asignaci�n de aulas', '#', '59.2', 'LOCKABLE'),
(171, 170, 'Iniciar/Continuar', 'modules/year_subject_classroom/fAssignClassroomsToSubjects', '1.0', 'LOCKABLE'),
(172, 52, 'Estudiantes', '#', '56.2', 'LOCKABLE'),
(173, 172, 'Actualizar Datos', 'modules/student/fSelectStudent', '1.0', 'LOCKABLE'),
(174, 172, 'Actualizar Representantes', 'modules/student_guardian/fAssignGuardiansToStudent', '1.1', 'LOCKABLE'),
(175, 1, 'Mantenimiento', '#', '175.0', 'LOCKABLE'),
(176, 175, 'Categor�a de Art�culos', '#', '1.0', 'LOCKABLE'),
(177, 176, 'Nueva Categor�a', 'modules/item_category/fNewItemCategory', '1.0', 'LOCKABLE'),
(178, 176, 'Actualizar Categor�a', 'modules/item_category/fSearchItemCategory', '1.1', 'LOCKABLE'),
(179, 175, 'Proveedores', '#', '1.1', 'LOCKABLE'),
(180, 179, 'Nuevo Proveedor', 'modules/provider/fNewProvider', '1.0', 'LOCKABLE'),
(181, 179, 'Actualizar Proveedor', 'modules/provider/fSearchProvider', '1.1', 'LOCKABLE'),
(182, 39, 'Materias de Grado', '#', '182.0', 'LOCKABLE'),
(183, 182, 'Definir Materias Disponibles', 'modules/year_grade_subject/fSelectSchoolYear', '1.0', 'LOCKABLE'),
(184, 182, 'Selecci�n Materia x Estudiante', 'modules/grade_subject_score/fSelectSchoolYear', '1.1', 'LOCKABLE'),
(185, 39, 'Calificaciones Especiales', '#', '185.0', 'LOCKABLE'),
(186, 185, 'Iniciar/Continuar', 'modules/year_special_grade_setup/index', '1.0', 'LOCKABLE'),
(187, 175, 'Destinos de Uso', '#', '3.0', 'LOCKABLE'),
(188, 187, 'Nuevo Destino de Uso', 'modules/use_destination/fNewUseDestination', '1.0', 'LOCKABLE'),
(189, 187, 'Actualizar Destino de Uso', 'modules/use_destination/fSearchUseDestination', '1.1', 'LOCKABLE'),
(190, 1, 'Instituciones Financieras', '#', '51.3', 'LOCKABLE'),
(191, 190, 'Nueva Instituci�n', 'modules/financial_institution/fNewFinancialInstitution', '1.0', 'LOCKABLE'),
(192, 190, 'Actualizar Instituci�n', 'modules/financial_institution/fSearchFinancialInstitution', '1.1', 'LOCKABLE'),
(193, 1, 'Tarjetas de Cr�dito', '#', '51.3', 'LOCKABLE'),
(194, 193, 'Nueva Tarjeta', 'modules/credit_card/fNewCreditCard', '1.0', 'LOCKABLE'),
(195, 193, 'Actualizar Tarjeta', 'modules/credit_card/fSearchCreditCard', '1.1', 'LOCKABLE'),
(196, 175, 'Art�culos de Mantenimiento', '#', '4', 'LOCKABLE'),
(197, 196, 'Nuevo Art�culo', 'modules/maintenance_item/fNewMaintenanceItem', '1.0', 'LOCKABLE'),
(198, 196, 'Actualizar Art�culo', 'modules/maintenance_item/fSearchMaintenanceItem', '1.1', 'LOCKABLE'),
(199, NULL, 'Gesti�n Acad�mica', '#', '45', 'LOCKABLE'),
(200, 1, 'Materias del Ministerio', '#', '48.9', 'LOCKABLE'),
(201, 200, 'Nueva Materia', 'modules/ministry_subject/fNewMinistrySubject', '1', 'LOCKABLE'),
(202, 200, 'Actualizar Materia', 'modules/ministry_subject/fSearchMinistrySubject', '2', 'LOCKABLE'),
(203, 39, 'Materias del Ministerio', '#', '203', 'LOCKABLE'),
(204, 203, 'Definir Equivalencias', 'modules/subject_ministry_equivalence/fNewSubjectMinistryEquivalence', '1', 'LOCKABLE'),
(205, 199, 'Registro de Novedades', '#', '205', 'LOCKABLE'),
(206, 205, 'Registrar Novedad', 'modules/incident/fNewIncident', '1', 'LOCKABLE'),
(207, NULL, 'Centro M�dico', '#', '207', 'LOCKABLE'),
(208, 207, 'Registrar Visita', 'modules/visits_medical_center/fNewVisit', '1', 'LOCKABLE'),
(209, 142, 'Materias Obligatorias', 'modules/activity/fTeacherCalendarActivity', '1', 'LOCKABLE'),
(210, 142, 'Materias Optativas', 'modules/opt_activity/fTeacherCalendarOptionalActivity', '1', 'LOCKABLE'),
(211, 39, 'Disciplina', '#', '211', 'LOCKABLE'),
(212, 211, 'Modo Calificaci�n x Nivel', 'modules/level_section_year/fSearchYear', '1', 'LOCKABLE'),
(213, 147, 'Crear Act. General', 'modules/general_activity/fGeneralCalendarActivity', '3', 'LOCKABLE'),
(214, 149, 'Actividades', '#', '1', 'LOCKABLE'),
(215, 214, 'Actividades x Curso o Materia Optativa', 'modules/reports/activity/fViewActivitiesByCourseOrSubject', '1', 'LOCKABLE'),
(216, 314, 'Selecci�n de Rubros para el A�o', 'modules/student_year_debts/fChooseStudentForSettingDebts', '1', 'LOCKABLE'),
(217, 156, 'Anular Factura', 'modules/student_year_debts/fSearchInvoiceToVoid', '3', 'LOCKABLE'),
(218, 199, 'Ex�menes de Recuperaci�n', '#', '306', 'LOCKABLE'),
(219, 218, 'Materias Obligatorias', '#', '1', 'LOCKABLE'),
(220, 219, 'Configurar Ex�menes', 'modules/subject_course_retest/fNewSubjectCourseRetest', '1', 'LOCKABLE'),
(221, 219, 'Calififcar Ex�menes', 'modules/subject_course_retest_student/fNewSubjectCourseRetestStudent', '2', 'LOCKABLE'),
(222, 218, 'Materias Optativas', '#', '2', 'LOCKABLE'),
(223, 222, 'Configurar Ex�menes', 'modules/optional_subject_retest/fNewOptionalSubjectRetest', '1', 'LOCKABLE'),
(224, 222, 'Calififcar Ex�menes', 'modules/optional_subject_retest_student/fNewOptionalSubjectRetestStudent', '2', 'LOCKABLE'),
(225, 199, 'Supletorios', '#', '400', 'LOCKABLE'),
(226, 225, 'Calificar Ex�menes', 'modules/resit_student/fGradeResitExam', '1', 'LOCKABLE'),
(227, 199, 'Registro de Hermanos', '#', '227', 'LOCKABLE'),
(230, 1, 'Descuentos', '#', '51.3', 'LOCKABLE'),
(231, 230, 'Nuevo Descuento', 'modules/discount/fNewDiscount', '1', 'LOCKABLE'),
(232, 230, 'Actualizar Descuento', 'modules/discount/fSearchDiscount', '2', 'LOCKABLE'),
(233, 39, 'Descuentos', '#', '115', 'LOCKABLE'),
(234, 233, 'Iniciar/Continuar', 'modules/year_discount/fAssignYearDiscount', '1', 'LOCKABLE'),
(235, 1, 'Documentos Habilitantes', '#', '51.3', 'LOCKABLE'),
(236, 235, 'Nuevo Documento', 'modules/qualifying_document/fNewQualifyingDocument', '1', 'LOCKABLE'),
(237, 235, 'Actualizar Documento', 'modules/qualifying_document/fSearchQualifyingDocument', '2', 'LOCKABLE'),
(238, 39, 'Documentos Requeridos', '#', '51.3', 'LOCKABLE'),
(239, 238, 'Matr�cula', 'modules/year_qualifying_document/fYearQualifyingDocument', '2', 'LOCKABLE'),
(240, 225, 'Determinar Supletorios', 'modules/resit_student/fSelectLevel', '0.1', 'LOCKABLE'),
(241, 199, 'Ex�menes de Grado', '#', '225.1', 'LOCKABLE'),
(242, 241, 'Calificar Ex�menes', 'modules/grade_subject_score/fSelectSchoolYearToSetScore', '1', 'LOCKABLE'),
(244, 156, 'Asignar Descuentos', 'modules/student_year_discount_values/fSearchStudentForAssignDiscounts', '1.5', 'LOCKABLE'),
(245, 156, 'Mantenimiento', '#', '4', 'LOCKABLE'),
(246, 245, 'Ingreso de Stock', 'modules/income_stock/fNewIncomeStock', '1', 'LOCKABLE'),
(247, 245, 'Salida de Stock', 'modules/stock_request/fNewStockRequest', '1', 'LOCKABLE'),
(248, 199, 'Calendario Actvidades Empleados', 'modules/employee/general/fActivitiesForEmployee', '248', 'LOCKABLE'),
(249, 149, 'Ministerio', '#', '4', 'LOCKABLE'),
(250, 249, 'Contrato de Servicios', 'modules/reports/ministry/fServiceContract', '1', 'LOCKABLE'),
(251, 249, 'Estudiantes Matriculados', 'modules/reports/student_matriculated/fViewMatriculatedStudents', '2', 'LOCKABLE'),
(252, 249, 'Acta de Matr�cula', 'modules/reports/ministry/fRegistrationCertificate', '3', 'LOCKABLE'),
(253, 249, 'Acta de Grado', 'modules/reports/school_certificate/fNewSchoolCertificate', '4', 'LOCKABLE'),
(254, 167, 'M�nimo de Supletorios Ministerio', 'modules/year_resit_exam_ranges_ministry/fNewYearResitExamRangesMinistry', '3', 'LOCKABLE'),
(255, 151, 'Notas por Per�odo', 'modules/reports/student_grade/fViewStudentsGradesByPeriod', '1.1', 'LOCKABLE'),
(256, 225, 'Determinar Supletorios Ministerio', 'modules/resit_student/fSelectLevelForMinistryResits', '0.2', 'LOCKABLE'),
(257, 39, 'Orden de Niveles', 'modules/level_section_year/fDefineLevelOrder', '40.1', 'LOCKABLE'),
(258, 249, 'Notas Materias de Grado', 'modules/reports/ministry/fSelectSchoolYearToGradeSubjectReport', '5', 'LOCKABLE'),
(259, 249, 'Certificado de Matr�cula', 'modules/reports/ministry/fSelectSchoolYearToRegistrationRecord', '6', 'LOCKABLE'),
(260, 249, 'Calificaciones Finales', 'modules/reports/ministry/fViewFinalStudentGrades', '7', 'LOCKABLE'),
(261, 321, 'Preaprobaci�n Inscritos', 'modules/pre_registration/academic_board/fSelectLevel', '49', 'LOCKABLE'),
(262, 249, 'Ex�menes Supletorios', 'modules/reports/ministry/fResitTestScoreReport', '8', 'LOCKABLE'),
(263, 52, 'Administraci�n General de Usuario', 'modules/user/fUserGeneralSearch', '100', 'LOCKABLE'),
(264, 249, 'Certificado Notas Finales', 'modules/reports/ministry/fNewFinalSubjectScores', '9', 'LOCKABLE'),
(265, 321, 'Aprobaci�n Inscritos', 'modules/pre_registration/principal/fSelectLevel', '49.2', 'LOCKABLE'),
(266, 238, 'Preinscripci�n', 'modules/year_pre_registration_document/fYearPreRegistrationDocument', '1', 'LOCKABLE'),
(267, 39, 'Replicar Configuraci�n de A�o', 'modules/replicate_configuration/fNewReplication', '213', 'LOCKABLE'),
(268, 1, 'M�todos de Pago', '#', '51.4', 'LOCKABLE'),
(269, 268, 'Nuevo M�todo', 'modules/payment_method/fNewPaymentMethod', '269', 'LOCKABLE'),
(270, 268, 'Actualizar M�todo', 'modules/payment_method/fSearchPaymentMethod', '270', 'LOCKABLE'),
(271, 52, 'Restablecer Contrase�a', 'modules/user/fSearchUserToPasswordReset', '271', 'LOCKABLE'),
(273, 321, 'Nueva Inscripci�n', 'modules/pre_registration/school/fNewPreRegistration', '47.1', 'LOCKABLE'),
(274, 321, 'Actualizar Inscripci�n', 'modules/pre_registration/school/fSelectLevel', '47.2', 'LOCKABLE'),
(275, 321, 'Validar Documentos Requeridos', 'modules/student_year_document/fStudentYearDocument', '49.3', 'LOCKABLE'),
(277, 365, 'Registro Asistencia', 'modules/attendance/fRegisterAttendance', '2', 'LOCKABLE'),
(278, 199, 'Promoci�n de Estudiantes', 'modules/studentPromotion/fNewStudentPromotion', '278', 'LOCKABLE'),
(279, 151, 'Lista Simple x Curso', 'modules/reports/student/fSelectSchoolYearToStudentListByCourse', '279', 'LOCKABLE'),
(280, 151, 'Lista Representates y Representados', 'modules/reports/guardian/fSelectSchoolYearToGuardiansReport', '280', 'LOCKABLE'),
(281, 151, 'Calificaciones Finales', 'modules/reports/report_card/fFinalSchoolScores', '281', 'LOCKABLE'),
(282, 151, 'Informe de Evaluaci�n', 'modules/reports/period_evaluation/fEvaluationReport', '282', 'LOCKABLE'),
(283, 151, 'Lista de Contactos x Curso', 'modules/reports/contacts_by_student/fStudentsContactsByCourse', '283', 'LOCKABLE'),
(284, 151, 'Lista de Contactos x Estudiante', 'modules/reports/contacts_by_student/fContactsListByStudent', '284', 'LOCKABLE'),
(285, 249, 'Certificado de Promoci�n', 'modules/reports/ministry/fYearPromotionCertificate', '285', 'LOCKABLE'),
(286, 249, 'Certificado de Aptitud', 'modules/reports/ministry/fCertificateOfAttainment', '286', 'LOCKABLE'),
(287, NULL, 'Biblioteca', '#', '287', 'LOCKABLE'),
(288, 287, 'Secciones', '#', '1', 'LOCKABLE'),
(289, 288, 'Nueva Secci�n', 'modules/library_section/fNewLibrarySection', '1', 'LOCKABLE'),
(290, 288, 'Actualizar Secci�n', 'modules/library_section/fSearchLibrarySection', '2', 'LOCKABLE'),
(291, 287, 'Categor�a de Libro', '#', '2', 'LOCKABLE'),
(292, 291, 'Nueva Categor�a', 'modules/book_category/fNewBookCategory', '1', 'LOCKABLE'),
(293, 291, 'Actualizar Categor�a', 'modules/book_category/fSearchBookCategory', '2', 'LOCKABLE'),
(294, 287, 'Registrar Libro', 'modules/book/fRegisterBook', '3', 'LOCKABLE'),
(295, 287, 'Busqueda de Libro', 'modules/loan/fNewBookSearch', '4', 'LOCKABLE'),
(296, 287, 'Prestamos', '#', '5', 'LOCKABLE'),
(297, 296, 'Libros', 'modules/loan/fNewBookLoan', '1', 'LOCKABLE'),
(298, 296, 'Equipos y Aulas', 'modules/loan/fNewEquipmentOrStudyPlaceLoan', '2', 'LOCKABLE'),
(299, 287, 'Devoluciones', 'modules/loan_return/fNewLoanReturn', '6', 'LOCKABLE'),
(300, 351, 'Reporte Ficha M�dica', 'modules/reports/medical_file/fMedicalFile', '2', 'LOCKABLE'),
(301, 287, 'Equipos', '#', '0.1', 'LOCKABLE'),
(302, 301, 'Nuevo Equipo', 'modules/equipment/fNewEquipment', '1', 'LOCKABLE'),
(303, 301, 'Actualizar Equipo', 'modules/equipment/fSearchEquipment', '2', 'LOCKABLE'),
(304, 287, 'Lugares de estudio', '#', '0.2', 'LOCKABLE'),
(305, 304, 'Nuevo Lugar', 'modules/study_place/fNewStudyPlace', '1', 'LOCKABLE'),
(306, 304, 'Actualizar Lugar', 'modules/study_place/fSearchStudyPlace', '2', 'LOCKABLE'),
(307, 39, 'Horarios', '#', '59.3', 'LOCKABLE'),
(308, 39, 'Arrancar A�o Lectivo', 'modules/school_year/fStartSchoolYear', '211.5', 'LOCKABLE'),
(309, NULL, 'Desempe�o Escolar', '#', '0.1', 'LOCKABLE'),
(310, NULL, 'Agenda', '#', '0.1', 'LOCKABLE'),
(311, NULL, 'Informaci�n General', '#', '0.1', 'LOCKABLE'),
(312, NULL, 'Estado de Cuenta', '#', '0.1', 'LOCKABLE'),
(314, NULL, 'Inscripciones', '#', '0.1', 'LOCKABLE'),
(315, 309, 'Calificaciones', 'modules/student_details/fGradesByStudent', '1', 'LOCKABLE'),
(316, 309, 'Asistencia', 'modules/student_details/fAttendanceDetail', '2', 'LOCKABLE'),
(317, 311, 'Compa�eros', 'modules/student_details/fClassmateDetail', '1', 'LOCKABLE'),
(318, 311, 'Transporte', 'modules/student_details/fTransportationDetail', '2', 'LOCKABLE'),
(319, 311, 'Horario', 'modules/student_details/fScheduleDetail', '4', 'LOCKABLE'),
(320, 312, 'Ver Cuenta', 'modules/guardian/account_balance/fViewAccountBalance', '1', 'LOCKABLE'),
(321, 52, 'Proceso de Inscripci�n', '#', '103', 'LOCKABLE'),
(324, 156, 'Venta de Art�culos', 'modules/student_year_debts/fSearchStudentForShopping', '3', 'LOCKABLE'),
(325, 321, 'Selecci�n de rubros', 'modules/student_year_debts/fChooseStudentForOptionalDebts', '49.4', 'LOCKABLE'),
(326, 52, 'Inscripci�n Directa', 'modules/registration/fNewRegistration', '102', 'LOCKABLE'),
(327, 149, 'Colegio', '#', '327', 'LOCKABLE'),
(328, 327, 'Valores Pagados', 'modules/reports/payed_debts/fViewPayedDebts', '1', 'LOCKABLE'),
(329, 327, 'Notas Finales', 'modules/reports/student_grade/fViewFinalStudentsGrades', '2', 'LOCKABLE'),
(330, 1, 'Grupos de Convenio de Pago', '#', '330', 'LOCKABLE'),
(331, 330, 'Nuevo Grupo', 'modules/payment_agreement_group/fNewPaymentAgreementGroup', '1', 'LOCKABLE'),
(332, 330, 'Actualizar Grupo', 'modules/payment_agreement_group/fSearchPaymentAgreementGroup', '2', 'LOCKABLE'),
(333, 156, 'Asignar Convenio de Pago', 'modules/payment_agreement_group/fSelectSchoolYearToAssignPaymentAgreement', '3.15', 'LOCKABLE'),
(334, 327, 'Facturas Sin Pagar', 'modules/reports/unpayed_debts/fViewUnpayedDebts', '3', 'LOCKABLE'),
(335, 327, 'Estudiantes por Rubro', 'modules/reports/students_by_debts/fSelectSchoolYearToStudentsByDebtsReport', '4', 'LOCKABLE'),
(336, 321, 'Verificaci�n de Pagos Habilitantes', 'modules/student_year_mandatory_payment/fCheckPaymentByStudent', '336', 'LOCKABLE'),
(337, 147, 'Premiaci�n Alumnos Destacados', 'modules/top_students_awards/fNewTopStudentsAwards', '4', 'LOCKABLE'),
(338, 149, 'Acta de Compromiso', 'modules/reports/letter_of_commitment/fLetterOfCommitment', '5', 'LOCKABLE'),
(339, 287, 'Registrar ejemplar de Libro', 'modules/book/fRegisterBookCopy', '3.1', 'LOCKABLE'),
(340, 156, 'Cambiar Nombre Facturas', 'modules/invoice/fChooseStudentToChangeInvoiceData', '3.1', 'LOCKABLE'),
(341, 156, 'Impresi�n Facturas en Bloque ', 'modules/invoice/fSelectSchoolYearToPrintInvoices', '3.2', 'LOCKABLE'),
(342, 327, 'Acta Matr�cula', 'modules/reports/school_certificate/fRegistrationCertificate', '0.1', 'LOCKABLE'),
(343, 61, 'Cambio de Paralelo', 'modules/class_group/fChangeStudentClassGroup', '62.6', 'LOCKABLE'),
(344, 156, 'Registro corriente diferido', 'modules/student_year_debts/fSearchStudentForCurrentDeferred', '2.1', 'LOCKABLE'),
(345, 156, 'Impresi�n de Factura', 'modules/invoice/fSelectSchoolYearToPrintInvoice', '3.2', 'LOCKABLE'),
(346, 156, 'Selecci�n Rubros Adicionales', 'modules/student_year_debts/fChooseStudentForOptionalDebts', '1', 'LOCKABLE'),
(347, 61, 'Cambio de Nivel/Especialidad', 'modules/level/fChangeStudentLevel', '62.7', 'LOCKABLE'),
(348, 207, 'Visitantes', '#', '2.0', 'LOCKABLE'),
(349, 348, 'Nuevo Visitante', 'modules/guest/fNewGuest', '1', 'LOCKABLE'),
(350, 348, 'Actualizar Visitante', 'modules/guest/fSearchGuest', '2', 'LOCKABLE'),
(351, 207, 'Ficha M�dica', '#', '62.7', 'LOCKABLE'),
(352, 351, 'Nueva/Actualizar', 'modules/medical_file/fSelectPatient', '1.0', 'LOCKABLE'),
(353, 1, 'Destrezas', '#', '49.3', 'LOCKABLE'),
(354, 353, 'Nueva Destreza', 'modules/skills/fNewSkill', '1.0', 'LOCKABLE'),
(355, 353, 'Actualizar Destreza', 'modules/skills/fSearchSkill', '2.0', 'LOCKABLE'),
(356, 39, 'Observaciones Acad�micas Por Nivel', 'modules/user_course_comment_setup/fUserCourseCommentSetup', '40.2', 'LOCKABLE'),
(357, 307, 'Configuraci�n Manual', 'modules/schedule/fScheduleDefinition', '1', 'LOCKABLE'),
(358, 307, 'Generaci�n Autom�tica', '#', '2', 'LOCKABLE'),
(359, 358, 'Ejecutar Proceso', 'modules/schedule/fAutoScheduleDefinition', '1', 'LOCKABLE'),
(360, 358, 'Selecci�n de Resultados', '', '2', 'LOCKABLE'),
(361, 199, 'Registro de Observaciones Acad�micas', 'modules/user_course_comment_setup/fSetCommentByCourse', '135', 'LOCKABLE'),
(362, 39, 'Ver Configuraci�n Actual', 'modules/school_year/fViewCurrentConfiguration', '212', 'LOCKABLE'),
(363, 199, 'Examen por Periodo', '#', '226', 'LOCKABLE'),
(364, 363, 'Calificar Examen', 'modules/student_period_exam/fGradePeriodExam', '1', 'LOCKABLE'),
(365, NULL, 'Asistencia y Disciplina', '#', '47', 'LOCKABLE'),
(366, 40, 'Habilitar Proceso Matriculaci�n', 'modules/school_year/fSelectYearToRegistrationWizard', '45', 'LOCKABLE'),
(367, 39, 'Destrezas', '#', '57.3', 'LOCKABLE'),
(368, 367, 'Iniciar/Continuar', 'modules/year_skill_setup/index', '1', 'LOCKABLE'),
(369, 199, 'Destrezas', '#', '369', 'LOCKABLE'),
(370, 369, 'Calificar Destrezas', 'modules/year_skill_setup/fGradeSkillCriteria', '369', 'LOCKABLE'),
(371, 151, 'Notas por Per�odo', 'modules/reports/grade_period_report/fViewStudentsGradesByPeriod', '1.2', 'LOCKABLE'),
(372, 193, 'Asignar Instituci�n Financiera', 'modules/financial_institution_card/fAssignCreditCardToFinancialInstitution', '1.2', 'LOCKABLE'),
(373, 199, 'Observaciones por Estudiante', 'modules/user_course_comment_setup/fSetCommentByCourse', '373', 'LOCKABLE'),
(374, 199, 'Habilitar Estudiantes Promovidos', 'modules/student_year/fEnablePromotedStudents', '374', 'LOCKABLE'),
(375, 117, 'Desasignar', 'modules/year_level_specialty_payment_concept/fDisablePaymentConcept', '375', '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');

--
-- 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, 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, 133, 'ACTIVE'),
(1, 136, 'ACTIVE'),
(1, 137, 'ACTIVE'),
(1, 138, 'ACTIVE'),
(1, 144, 'ACTIVE'),
(1, 146, 'ACTIVE'),
(1, 148, 'ACTIVE'),
(1, 152, 'ACTIVE'),
(1, 153, 'ACTIVE'),
(1, 155, 'ACTIVE'),
(1, 157, 'ACTIVE'),
(1, 159, 'ACTIVE'),
(1, 161, 'ACTIVE'),
(1, 163, 'ACTIVE'),
(1, 164, 'ACTIVE'),
(1, 166, 'ACTIVE'),
(1, 168, 'ACTIVE'),
(1, 169, 'ACTIVE'),
(1, 171, 'ACTIVE'),
(1, 173, 'ACTIVE'),
(1, 174, 'ACTIVE'),
(1, 177, 'ACTIVE'),
(1, 178, 'ACTIVE'),
(1, 180, 'ACTIVE'),
(1, 181, 'ACTIVE'),
(1, 183, 'ACTIVE'),
(1, 184, 'ACTIVE'),
(1, 186, 'ACTIVE'),
(1, 188, 'ACTIVE'),
(1, 189, 'ACTIVE'),
(1, 191, 'ACTIVE'),
(1, 192, 'ACTIVE'),
(1, 194, 'ACTIVE'),
(1, 195, 'ACTIVE'),
(1, 197, 'ACTIVE'),
(1, 198, 'ACTIVE'),
(1, 201, 'ACTIVE'),
(1, 202, 'ACTIVE'),
(1, 204, 'ACTIVE'),
(1, 206, 'ACTIVE'),
(1, 208, 'ACTIVE'),
(1, 212, 'ACTIVE'),
(1, 213, 'ACTIVE'),
(1, 215, 'ACTIVE'),
(1, 217, 'ACTIVE'),
(1, 231, 'ACTIVE'),
(1, 232, 'ACTIVE'),
(1, 234, 'ACTIVE'),
(1, 236, 'ACTIVE'),
(1, 237, 'ACTIVE'),
(1, 239, 'ACTIVE'),
(1, 240, 'ACTIVE'),
(1, 242, 'ACTIVE'),
(1, 244, 'ACTIVE'),
(1, 246, 'ACTIVE'),
(1, 247, 'ACTIVE'),
(1, 250, 'ACTIVE'),
(1, 251, 'ACTIVE'),
(1, 252, 'ACTIVE'),
(1, 253, 'ACTIVE'),
(1, 254, 'ACTIVE'),
(1, 255, 'ACTIVE'),
(1, 256, 'ACTIVE'),
(1, 257, 'ACTIVE'),
(1, 258, 'ACTIVE'),
(1, 259, 'ACTIVE'),
(1, 260, 'ACTIVE'),
(1, 261, 'ACTIVE'),
(1, 262, 'ACTIVE'),
(1, 263, 'ACTIVE'),
(1, 264, 'ACTIVE'),
(1, 265, 'ACTIVE'),
(1, 266, 'ACTIVE'),
(1,267	,'ACTIVE'),
(1,269,'ACTIVE'),
(1,270,'ACTIVE'),
(1,271,'ACTIVE'),
(1,273,'ACTIVE'),
(1,274,'ACTIVE'),
(1,275,'ACTIVE'),
(1,277,'ACTIVE'),
(1,278,'ACTIVE'),
(1,279,'ACTIVE'),
(1,280,'ACTIVE'),
(1,281,'ACTIVE'),
(1,282,'ACTIVE'),
(1,283,'ACTIVE'),
(1,284,'ACTIVE'),
(1,285,'ACTIVE'),
(1,286,'ACTIVE'),
(1,289,'ACTIVE'),
(1,290,'ACTIVE'),
(1,292,'ACTIVE'),
(1,293,'ACTIVE'),
(1,294,'ACTIVE'),
(1,295,'ACTIVE'),
(1,297,'ACTIVE'),
(1,298,'ACTIVE'),
(1,299,'ACTIVE'),
(1,300,'ACTIVE'),
(1,302,'ACTIVE'),
(1,303,'ACTIVE'),
(1,305,'ACTIVE'),
(1,306,'ACTIVE'),
(1,308,'ACTIVE'),
(1,324,'ACTIVE'),
(1,325,'ACTIVE'),
(1,326,'ACTIVE'),
(1,328,'ACTIVE'),
(1,329,'ACTIVE'),
(1,331,'ACTIVE'),
(1,332,'ACTIVE'),
(1,333,'ACTIVE'),
(1,334,'ACTIVE'),
(1,335,'ACTIVE'),
(1,336,'ACTIVE'),
(1,337,'ACTIVE'),
(1,338,'ACTIVE'),
(1,339,'ACTIVE'),
(1,340,'ACTIVE'),
(1,341,'ACTIVE'),
(1,342,'ACTIVE'),
(1,343,'ACTIVE'),
(1,344,'ACTIVE'),
(1,345,'ACTIVE'),
(1,346,'ACTIVE'),
(1,347,'ACTIVE'),
(1,349,'ACTIVE'),
(1,350,'ACTIVE'),
(1,352,'ACTIVE'),
(1,354,'ACTIVE'),
(1,355,'ACTIVE'),
(1,356,'ACTIVE'),
(1,357,'ACTIVE'),
(1,359,'ACTIVE'),
(1,360,'ACTIVE'),
(1,361,'ACTIVE'),
(1,362,'ACTIVE'),
(1,364,'ACTIVE'),
(1,366,'ACTIVE'),
(1,368,'ACTIVE'),
(1,371,'ACTIVE'),
(1,372,'ACTIVE'),
(1,374,'ACTIVE'),
(1,375, 'ACTIVE'),
(2, 46, 'ACTIVE'),
(2, 47, 'ACTIVE'),
(2, 101, 'ACTIVE'),
(2, 139, 'ACTIVE'),
(2, 141, 'ACTIVE'),
(2, 148, 'ACTIVE'),
(2, 216, 'ACTIVE'),
(2, 315, 'ACTIVE'),
(2, 316, 'ACTIVE'),
(2, 317, 'ACTIVE'),
(2, 318, 'ACTIVE'),
(2, 319, 'ACTIVE'),
(2, 320, 'ACTIVE'),
(3, 131, 'ACTIVE'),
(3, 132, 'ACTIVE'),
(3, 139, 'ACTIVE'),
(3, 140, 'ACTIVE'),
(3, 148, 'ACTIVE'),
(3, 315, 'ACTIVE'),
(3, 316, 'ACTIVE'),
(3, 317, 'ACTIVE'),
(3, 318, 'ACTIVE'),
(3, 319, 'ACTIVE'),
(4, 126, 'ACTIVE'),
(4, 127, 'ACTIVE'),
(4, 135, 'ACTIVE'),
(4, 145, 'ACTIVE'),
(4, 148, 'ACTIVE'),
(4, 209, 'ACTIVE'),
(4, 210, 'ACTIVE'),
(4, 220, 'ACTIVE'),
(4, 221, 'ACTIVE'),
(4, 223, 'ACTIVE'),
(4, 224, 'ACTIVE'),
(4, 226, 'ACTIVE'),
(4, 370, 'ACTIVE'),
(4, 373, 'ACTIVE'),
(5, 148, 'ACTIVE'),
(5, 248, 'ACTIVE'),
(5, 48, 'ACTIVE');



/*==============================================================*/
/*Table:country*/
/*==============================================================*/

INSERT INTO country(`serial_cou`,`name_cou`)
VALUES(NULL,'Andorra'),
(NULL,'United arab emirates'),
(NULL,'Afghanistan'),
(NULL,'Antigua and barbuda'),
(NULL,'Anguilla'),
(NULL,'Albania'),
(NULL,'Armenia'),
(NULL,'Netherlands antilles'),
(NULL,'Angola'),
(NULL,'Antarctica'),
(NULL,'Argentina'),
(NULL,'Americansamoa'),
(NULL,'Austria'),
(NULL,'Australia'),
(NULL,'Aruba'),
(NULL,'Azerbaijan'),
(NULL,'Bosnia and herzegovina'),
(NULL,'Barbados'),
(NULL,'Bangladesh'),
(NULL,'Belgium'),
(NULL,'Burkinafaso'),
(NULL,'Bulgaria'),
(NULL,'Bahrain'),
(NULL,'Burundi'),
(NULL,'Benin'),
(NULL,'Bermuda'),
(NULL,'Bruneida russalam'),
(NULL,'Bolivia'),
(NULL,'Brazil'),
(NULL,'Bahamas'),
(NULL,'Bhutan'),
(NULL,'Bouvetisland'),
(NULL,'Botswana'),
(NULL,'Belarus'),
(NULL,'Belize'),
(NULL,'Canada'),
(NULL,'Cocos(keeling)islands'),
(NULL,'Congo'),
(NULL,'Central african republic'),
(NULL,'Congo'),
(NULL,'Switzerland'),
(NULL,'Coted''ivoire'),
(NULL,'Cookislands'),
(NULL,'Chile'),
(NULL,'Cameroon'),
(NULL,'China'),
(NULL,'Colombia'),
(NULL,'Costarica'),
(NULL,'Serbia and montenegro'),
(NULL,'Cuba'),
(NULL,'Capeverde'),
(NULL,'Christmas island'),
(NULL,'Cyprus'),
(NULL,'Czech republic'),
(NULL,'Germany'),
(NULL,'Djibouti'),
(NULL,'Denmark'),
(NULL,'Dominica'),
(NULL,'Dominican republic'),
(NULL,'Algeria'),
(NULL,'Ecuador'),
(NULL,'Estonia'),
(NULL,'Egypt'),
(NULL,'Western sahara'),
(NULL,'Eritrea'),
(NULL,'Spain'),
(NULL,'Ethiopia'),
(NULL,'Finland'),
(NULL,'Fiji'),
(NULL,'Micronesia'),
(NULL,'Faroe islands'),
(NULL,'France'),
(NULL,'Gabon'),
(NULL,'United kingdom'),
(NULL,'Grenada'),
(NULL,'Georgia'),
(NULL,'French guiana'),
(NULL,'Ghana'),
(NULL,'Gibraltar'),
(NULL,'Greenland'),
(NULL,'Gambia'),
(NULL,'Guinea'),
(NULL,'Guadeloupe'),
(NULL,'Equatorial guinea'),
(NULL,'Greece'),
(NULL,'Guatemala'),
(NULL,'Guam'),
(NULL,'Guinea-bissau'),
(NULL,'Guyana'),
(NULL,'Hong kong'),
(NULL,'Honduras'),
(NULL,'Croatia'),
(NULL,'Haiti'),
(NULL,'Hungary'),
(NULL,'Indonesia'),
(NULL,'Ireland'),
(NULL,'Israel'),
(NULL,'India'),
(NULL,'Iraq'),
(NULL,'Iran,islamic republic of'),
(NULL,'Iceland'),
(NULL,'Italy'),
(NULL,'Jamaica'),
(NULL,'Jordan'),
(NULL,'Japan'),
(NULL,'Kenya'),
(NULL,'Kyrgyzstan'),
(NULL,'Cambodia'),
(NULL,'Kiribati'),
(NULL,'Comoros'),
(NULL,'Saint kitts and nevis'),
(NULL,'Korea'),
(NULL,'Korea,republic of'),
(NULL,'Kuwait'),
(NULL,'Cayman islands'),
(NULL,'Kazakhstan'),
(NULL,'Lao'),
(NULL,'Lebanon'),
(NULL,'Saint lucia'),
(NULL,'Liechtenstein'),
(NULL,'Srilanka'),
(NULL,'Liberia'),
(NULL,'Lesotho'),
(NULL,'Lithuania'),
(NULL,'Luxembourg'),
(NULL,'Latvia'),
(NULL,'Libyanarabjamahiriya'),
(NULL,'Morocco'),
(NULL,'Monaco'),
(NULL,'Moldova,republic of'),
(NULL,'Madagascar'),
(NULL,'Marshall islands'),
(NULL,'Macedonia'),
(NULL,'Mali'),
(NULL,'Myanmar'),
(NULL,'Mongolia'),
(NULL,'Macao'),
(NULL,'Northern mariana islands'),
(NULL,'Martinique'),
(NULL,'Mauritania'),
(NULL,'Montserrat'),
(NULL,'Malta'),
(NULL,'Mauritius'),
(NULL,'Maldives'),
(NULL,'Malawi'),
(NULL,'Mexico'),
(NULL,'Malaysia'),
(NULL,'Mozambique'),
(NULL,'Namibia'),
(NULL,'New caledonia'),
(NULL,'Niger'),
(NULL,'Norfolk island'),
(NULL,'Nigeria'),
(NULL,'Nicaragua'),
(NULL,'Netherlands'),
(NULL,'Norway'),
(NULL,'Nepal'),
(NULL,'Nauru'),
(NULL,'Niue'),
(NULL,'New zealand'),
(NULL,'Oman'),
(NULL,'Panama'),
(NULL,'Peru'),
(NULL,'French polynesia'),
(NULL,'Papua new guinea'),
(NULL,'Philippines'),
(NULL,'Pakistan'),
(NULL,'Poland'),
(NULL,'Saint pierre and miquelon'),
(NULL,'Pitcairn'),
(NULL,'Puerto rico'),
(NULL,'Palestina'),
(NULL,'Portugal'),
(NULL,'Palau'),
(NULL,'Paraguay'),
(NULL,'Qatar'),
(NULL,'Reunion'),
(NULL,'Romania'),
(NULL,'Russian federation'),
(NULL,'Rwanda'),
(NULL,'Saudi arabia'),
(NULL,'Solomon islands'),
(NULL,'Seychelles'),
(NULL,'Sudan'),
(NULL,'Sweden'),
(NULL,'Singapore'),
(NULL,'Saint helena'),
(NULL,'Slovenia'),
(NULL,'Svalbard and janmayen'),
(NULL,'Slovakia'),
(NULL,'Sierra leone'),
(NULL,'San marino'),
(NULL,'Senegal'),
(NULL,'Somalia'),
(NULL,'Suriname'),
(NULL,'Saotome and principe'),
(NULL,'El salvador'),
(NULL,'Syrian arab republic'),
(NULL,'Swaziland'),
(NULL,'Turks and caicos islands'),
(NULL,'Chad'),
(NULL,'Togo'),
(NULL,'Thailand'),
(NULL,'Tajikistan'),
(NULL,'Tokelau'),
(NULL,'Timor-leste'),
(NULL,'Turkmenistan'),
(NULL,'Tunisia'),
(NULL,'Tonga'),
(NULL,'Turkey'),
(NULL,'Trinidad and tobago'),
(NULL,'Tuvalu'),
(NULL,'Taiwan,province of china'),
(NULL,'Tanzania,united republic of'),
(NULL,'Ukraine'),
(NULL,'Uganda'),
(NULL,'United states'),
(NULL,'Uruguay'),
(NULL,'Uzbekistan'),
(NULL,'Holysee(vatican city state)'),
(NULL,'Venezuela'),
(NULL,'Virgin islands,british'),
(NULL,'Virgin islands,u.s.'),
(NULL,'Vietnam'),
(NULL,'Vanuatu'),
(NULL,'Wallis and futuna'),
(NULL,'Samoa'),
(NULL,'Yemen'),
(NULL,'Mayotte'),
(NULL,'South africa'),
(NULL,'Zambia'),
(NULL,'Zimbabwe');

/*==============================================================*/
/*Table:state*/
/*==============================================================*/

INSERT INTO `state`(`serial_ste`,`serial_cou`,`name_ste`) VALUES
(NULL,61,'Azuay'),
(NULL,61,'Bol�var'),
(NULL,61,'Ca�ar'),
(NULL,61,'Carchi'),
(NULL,61,'Chimborazo'),
(NULL,61,'Cotopaxi'),
(NULL,61,'El Oro'),
(NULL,61,'Esmeraldas'),
(NULL,61,'Gal�pagos'),
(NULL,61,'Guayas'),
(NULL,61,'Imbabura'),
(NULL,61,'Loja'),
(NULL,61,'Los R�os'),
(NULL,61,'Manab�'),
(NULL,61,'Morona Santiago'),
(NULL,61,'Napo'),
(NULL,61,'Orellana'),
(NULL,61,'Pastaza'),
(NULL,61,'Pichincha'),
(NULL,61,'Santa Elena'),
(NULL,61,'Sto.Domingo de los Ts�chilas'),
(NULL,61,'Sucumb�os'),
(NULL,61,'Tungurahua'),
(NULL,61,'Zamora Chinchipe'),
(NULL,217,'Alabama'),
(NULL,217,'Alaska'),
(NULL,217,'Arizona'),
(NULL,217,'Arkansas'),
(NULL,217,'California'),
(NULL,217,'Colorado'),
(NULL,217,'Connecticut'),
(NULL,217,'Delaware'),
(NULL,217,'Dist. of Columbia'),
(NULL,217,'Florida'),
(NULL,217,'Georgia'),
(NULL,217,'Guam'),
(NULL,217,'Hawaii'),
(NULL,217,'Idaho'),
(NULL,217,'Illinois'),
(NULL,217,'Indiana'),
(NULL,217,'Iowa'),
(NULL,217,'Kansas'),
(NULL,217,'Kentucky'),
(NULL,217,'Louisiana'),
(NULL,217,'Maine'),
(NULL,217,'Maryland'),
(NULL,217,'Massachusetts'),
(NULL,217,'Michigan'),
(NULL,217,'Minnesota'),
(NULL,217,'Mississippi'),
(NULL,217,'Missouri'),
(NULL,217,'Montana'),
(NULL,217,'Nebraska'),
(NULL,217,'Nevada'),
(NULL,217,'New Hampshire'),
(NULL,217,'New Jersey'),
(NULL,217,'New Mexico'),
(NULL,217,'New York'),
(NULL,217,'North Carolina'),
(NULL,217,'North Dakota'),
(NULL,217,'Ohio'),
(NULL,217,'Oklahoma'),
(NULL,217,'Oregon'),
(NULL,217,'Pennsylvania'),
(NULL,217,'Puerto Rico'),
(NULL,217,'Rhode Island'),
(NULL,217,'South Carolina'),
(NULL,217,'South Dakota'),
(NULL,217,'Tennessee'),
(NULL,217,'Texas'),
(NULL,217,'Utah'),
(NULL,217,'Vermont'),
(NULL,217,'Virginia'),
(NULL,217,'Virgin Islands'),
(NULL,217,'Washington'),
(NULL,217,'West Virginia'),
(NULL,217,'Wisconsin'),
(NULL,217,'Wyoming'),
(NULL,50,'Pinar del R�o'),
(NULL,50,'Artemisa'),
(NULL,50,'La Habana'),
(NULL,50,'Mayabeque'),
(NULL,50,'Matanzas'),
(NULL,50,'Cienfuegos'),
(NULL,50,'Villa Clara'),
(NULL,50,'Sancti Sp�ritus'),
(NULL,50,'Ciego de �vila'),
(NULL,50,'Camag�ey'),
(NULL,50,'Las Tunas'),
(NULL,50,'Granma'),
(NULL,50,'Holgu�n'),
(NULL,50,'Santiago de Cuba'),
(NULL,50,'Guant�namo'),
(NULL,50,'Isla de la Juventud'),
(NULL,55,'Baden-Wurttemberg'),
(NULL,55,'Bavaria'),
(NULL,55,'Berlin'),
(NULL,55,'Brandenburg'),
(NULL,55,'Bremen'),
(NULL,55,'Hamburg'),
(NULL,55,'Hesse'),
(NULL,55,'Lower Saxony'),
(NULL,55,'Mecklenburg-West Pomerania'),
(NULL,55,'North Rhine-Westphalia'),
(NULL,55,'Rhineland-Palatinate'),
(NULL,55,'Saarland'),
(NULL,55,'Saxony'),
(NULL,55,'Saxony-Anhalt'),
(NULL,55,'Schleswig-Holstein'),
(NULL,55,'Thuringia'),
(NULL,1,'Otra'),
(NULL,2,'Otra'),
(NULL,3,'Otra'),
(NULL,4,'Otra'),
(NULL,5,'Otra'),
(NULL,6,'Otra'),
(NULL,7,'Otra'),
(NULL,8,'Otra'),
(NULL,9,'Otra'),
(NULL,10,'Otra'),
(NULL,11,'Otra'),
(NULL,12,'Otra'),
(NULL,13,'Otra'),
(NULL,14,'Otra'),
(NULL,15,'Otra'),
(NULL,16,'Otra'),
(NULL,17,'Otra'),
(NULL,18,'Otra'),
(NULL,19,'Otra'),
(NULL,20,'Otra'),
(NULL,21,'Otra'),
(NULL,22,'Otra'),
(NULL,23,'Otra'),
(NULL,24,'Otra'),
(NULL,25,'Otra'),
(NULL,26,'Otra'),
(NULL,27,'Otra'),
(NULL,28,'Otra'),
(NULL,29,'Otra'),
(NULL,30,'Otra'),
(NULL,31,'Otra'),
(NULL,32,'Otra'),
(NULL,33,'Otra'),
(NULL,34,'Otra'),
(NULL,35,'Otra'),
(NULL,36,'Otra'),
(NULL,37,'Otra'),
(NULL,38,'Otra'),
(NULL,39,'Otra'),
(NULL,40,'Otra'),
(NULL,41,'Otra'),
(NULL,42,'Otra'),
(NULL,43,'Otra'),
(NULL,44,'Otra'),
(NULL,45,'Otra'),
(NULL,46,'Otra'),
(NULL,47,'Otra'),
(NULL,48,'Otra'),
(NULL,49,'Otra'),
(NULL,51,'Otra'),
(NULL,52,'Otra'),
(NULL,53,'Otra'),
(NULL,54,'Otra'),
(NULL,56,'Otra'),
(NULL,57,'Otra'),
(NULL,58,'Otra'),
(NULL,59,'Otra'),
(NULL,60,'Otra'),
(NULL,62,'Otra'),
(NULL,63,'Otra'),
(NULL,64,'Otra'),
(NULL,65,'Otra'),
(NULL,66,'Otra'),
(NULL,67,'Otra'),
(NULL,68,'Otra'),
(NULL,69,'Otra'),
(NULL,70,'Otra'),
(NULL,71,'Otra'),
(NULL,72,'Otra'),
(NULL,73,'Otra'),
(NULL,74,'Otra'),
(NULL,75,'Otra'),
(NULL,76,'Otra'),
(NULL,77,'Otra'),
(NULL,78,'Otra'),
(NULL,79,'Otra'),
(NULL,80,'Otra'),
(NULL,81,'Otra'),
(NULL,82,'Otra'),
(NULL,83,'Otra'),
(NULL,84,'Otra'),
(NULL,85,'Otra'),
(NULL,86,'Otra'),
(NULL,87,'Otra'),
(NULL,88,'Otra'),
(NULL,89,'Otra'),
(NULL,90,'Otra'),
(NULL,91,'Otra'),
(NULL,92,'Otra'),
(NULL,93,'Otra'),
(NULL,94,'Otra'),
(NULL,95,'Otra'),
(NULL,96,'Otra'),
(NULL,97,'Otra'),
(NULL,98,'Otra'),
(NULL,99,'Otra'),
(NULL,100,'Otra'),
(NULL,101,'Otra'),
(NULL,102,'Otra'),
(NULL,103,'Otra'),
(NULL,104,'Otra'),
(NULL,105,'Otra'),
(NULL,106,'Otra'),
(NULL,107,'Otra'),
(NULL,108,'Otra'),
(NULL,109,'Otra'),
(NULL,110,'Otra'),
(NULL,111,'Otra'),
(NULL,112,'Otra'),
(NULL,113,'Otra'),
(NULL,114,'Otra'),
(NULL,115,'Otra'),
(NULL,116,'Otra'),
(NULL,117,'Otra'),
(NULL,118,'Otra'),
(NULL,119,'Otra'),
(NULL,120,'Otra'),
(NULL,121,'Otra'),
(NULL,122,'Otra'),
(NULL,123,'Otra'),
(NULL,124,'Otra'),
(NULL,125,'Otra'),
(NULL,126,'Otra'),
(NULL,127,'Otra'),
(NULL,128,'Otra'),
(NULL,129,'Otra'),
(NULL,130,'Otra'),
(NULL,131,'Otra'),
(NULL,132,'Otra'),
(NULL,133,'Otra'),
(NULL,134,'Otra'),
(NULL,135,'Otra'),
(NULL,136,'Otra'),
(NULL,137,'Otra'),
(NULL,138,'Otra'),
(NULL,139,'Otra'),
(NULL,140,'Otra'),
(NULL,141,'Otra'),
(NULL,142,'Otra'),
(NULL,143,'Otra'),
(NULL,144,'Otra'),
(NULL,145,'Otra'),
(NULL,146,'Otra'),
(NULL,147,'Otra'),
(NULL,148,'Otra'),
(NULL,149,'Otra'),
(NULL,150,'Otra'),
(NULL,151,'Otra'),
(NULL,152,'Otra'),
(NULL,153,'Otra'),
(NULL,154,'Otra'),
(NULL,155,'Otra'),
(NULL,156,'Otra'),
(NULL,157,'Otra'),
(NULL,158,'Otra'),
(NULL,159,'Otra'),
(NULL,160,'Otra'),
(NULL,161,'Otra'),
(NULL,162,'Otra'),
(NULL,163,'Otra'),
(NULL,164,'Otra'),
(NULL,165,'Otra'),
(NULL,166,'Otra'),
(NULL,167,'Otra'),
(NULL,168,'Otra'),
(NULL,169,'Otra'),
(NULL,170,'Otra'),
(NULL,171,'Otra'),
(NULL,172,'Otra'),
(NULL,173,'Otra'),
(NULL,174,'Otra'),
(NULL,175,'Otra'),
(NULL,176,'Otra'),
(NULL,177,'Otra'),
(NULL,178,'Otra'),
(NULL,179,'Otra'),
(NULL,180,'Otra'),
(NULL,181,'Otra'),
(NULL,182,'Otra'),
(NULL,183,'Otra'),
(NULL,184,'Otra'),
(NULL,185,'Otra'),
(NULL,186,'Otra'),
(NULL,187,'Otra'),
(NULL,188,'Otra'),
(NULL,189,'Otra'),
(NULL,190,'Otra'),
(NULL,191,'Otra'),
(NULL,192,'Otra'),
(NULL,193,'Otra'),
(NULL,194,'Otra'),
(NULL,195,'Otra'),
(NULL,196,'Otra'),
(NULL,197,'Otra'),
(NULL,198,'Otra'),
(NULL,199,'Otra'),
(NULL,200,'Otra'),
(NULL,201,'Otra'),
(NULL,202,'Otra'),
(NULL,203,'Otra'),
(NULL,204,'Otra'),
(NULL,205,'Otra'),
(NULL,206,'Otra'),
(NULL,207,'Otra'),
(NULL,208,'Otra'),
(NULL,209,'Otra'),
(NULL,210,'Otra'),
(NULL,211,'Otra'),
(NULL,212,'Otra'),
(NULL,213,'Otra'),
(NULL,214,'Otra'),
(NULL,215,'Otra'),
(NULL,216,'Otra'),
(NULL,218,'Otra'),
(NULL,219,'Otra'),
(NULL,220,'Otra'),
(NULL,221,'Otra'),
(NULL,222,'Otra'),
(NULL,223,'Otra'),
(NULL,224,'Otra'),
(NULL,225,'Otra'),
(NULL,226,'Otra'),
(NULL,227,'Otra'),
(NULL,228,'Otra'),
(NULL,229,'Otra'),
(NULL,230,'Otra'),
(NULL,231,'Otra'),
(NULL,232,'Otra');

/*==============================================================*/
/*Table:currency*/
/*==============================================================*/
INSERT INTO `currency`(`serial_crr`,`abrevation_crr`,`name_crr`)VALUES
(NULL,'ARS','Argentine Peso'),
(NULL,'AUD','Australian Dollar'),
(NULL,'BHD','Bahrain Dinar'),
(NULL,'BWP','Botswana Pula'),
(NULL,'BRL','Brazilian Real'),
(NULL,'BND','Brunei Dollar'),
(NULL,'CAD','Canadian Dollar'),
(NULL,'CLP','Chilean Peso'),
(NULL,'CNY','Chinese Yuan'),
(NULL,'COP','Colombian Peso'),
(NULL,'CYP','Cyprus Pound'),
(NULL,'CZK','Czech Koruna'),
(NULL,'DKK','Danish Krone'),
(NULL,'EUR','Euro'),
(NULL,'HUF','Hungarian Forint'),
(NULL,'ISK','Icelandic Krona'),
(NULL,'INR','Indian Rupee'),
(NULL,'IDR','Indonesian Rupiah'),
(NULL,'IRR','Iranian Rial'),
(NULL,'ILS','Israeli New Sheqel'),
(NULL,'JPY','Japanese Yen'),
(NULL,'KRW','Korean Won'),
(NULL,'KWD','Kuwaiti Dinar'),
(NULL,'LYD','Libyan Dinar'),
(NULL,'MYR','Malaysian Ringgit'),
(NULL,'MTL','Maltese Lira'),
(NULL,'MUR','Mauritian Rupee'),
(NULL,'MXN','Mexican Peso'),
(NULL,'NPR','Nepalese Rupee'),
(NULL,'NZD','New Zealand Dollar'),
(NULL,'NOK','Norwegian Krone'),
(NULL,'OMR','Omani Rial'),
(NULL,'PKR','Pakistan Rupee'),
(NULL,'PLN','Polish Zloty'),
(NULL,'GBP','Pound Sterling'),
(NULL,'QAR','Qatar Riyal'),
(NULL,'SAR','Saudi Arabian Riyal'),
(NULL,'SGD','Singapore Dollar'),
(NULL,'SIT','Slovenian Tolar'),
(NULL,'ZAR','South African Rand'),
(NULL,'LKR','Sri Lanka Rupee'),
(NULL,'SEK','Swedish Krona'),
(NULL,'CHF','Swiss Franc'),
(NULL,'THB','Thai Baht'),
(NULL,'TTD','Trinidad and Tobago Dollar'),
(NULL,'AED','U.A.E.Dirham'),
(NULL,'USD','U.S.Dollar'),
(NULL,'VEB','Venezuelan Bolivar');

/*==============================================================*/
/*Table:user*/
/*==============================================================*/
INSERT INTO `user`(`serial_usr`,`serial_grd`,`serial_std`,`serial_emp`,`username_usr`,`password_usr`,`photo_usr`) VALUES(NULL,NULL,NULL,NULL,'admin',MD5('123456'),NULL);
/*==============================================================*/
/*Table:user_profile*/
/*==============================================================*/
INSERT INTO `user_profile`(`serial_prf`,`serial_usr`) VALUES
('1','1');

/*==============================================================*/
/*Table:specialty*/
/*==============================================================*/
INSERT INTO `specialty`(`serial_spt`,`name_spt`,`description_spt`,`status_spt`)VALUES(NULL,'* Ninguna','Opci�n para todo nivel que no tiene una especializaci�n','ACTIVE');
/*==============================================================*/
/*Table:nationality*/
/*==============================================================*/
INSERT INTO `nationality`(`serial_nnt`,`name_nnt`) VALUES
(NULL,'ECUATORIANA'),
(NULL,'AFGANA'),
(NULL,'ALBANA'),
(NULL,'ALEMANA'),
(NULL,'ARGENTINA'),
(NULL,'BAHAMES'),
(NULL,'BELGA'),
(NULL,'BOLIVIANA'),
(NULL,'BRASILE�A'),
(NULL,'CHILENA'),
(NULL,'COLOMBIANA'),
(NULL,'COSTARRICENSE'),
(NULL,'ESPA�OLA'),
(NULL,'ESTADOUNIDENSE'),
(NULL,'ITALIANA'),
(NULL,'MEXICANA'),
(NULL,'PARAGUAYA'),
(NULL,'PERUANA'),
(NULL,'PORTUGUESA'),
(NULL,'PUERTORRIQUE�A'),
(NULL,'SUIZA'),
(NULL,'VENEZOLANA'),
(NULL,'CUBANA'),
(NULL,'ARABE'),
(NULL,'AUSTRALIANA'),
(NULL,'CAMBOYANA'),
(NULL,'CANADIENSE'),
(NULL,'CHINA'),
(NULL,'COREANA'),
(NULL,'COSTARRICENSE'),
(NULL,'DANESA'),
(NULL,'EGIPCIA'),
(NULL,'SALVADORE�A'),
(NULL,'ESTONIA'),
(NULL,'ETIOPE'),
(NULL,'FILIPINA'),
(NULL,'FINLANDESA'),
(NULL,'FRANCESA'),
(NULL,'GALESA'),
(NULL,'GRIEGA'),
(NULL,'GUATEMALTECA'),
(NULL,'HAITIANA'),
(NULL,'HOLANDESA'),
(NULL,'HONDURE�A'),
(NULL,'INDONESA'),
(NULL,'INGLESA'),
(NULL,'IRLANDESA'),
(NULL,'ISRAELI'),
(NULL,'JAPONESA'),
(NULL,'JORDANA'),
(NULL,'LAOSIANA'),
(NULL,'LETONA'),
(NULL,'LETONESA'),
(NULL,'MALAYA'),
(NULL,'MARROQUI'),
(NULL,'NICARAG�ENSE'),
(NULL,'NORUEGA'),
(NULL,'NEOCELANDESA'),
(NULL,'PANAME�A'),
(NULL,'RUMANA'),
(NULL,'RUSA'),
(NULL,'ECUATORIANA-INGLESA'),
(NULL,'ECUATORIANA-ESTADOUNIDENSE'),
(NULL,'ECUATORIANA-ARGENTINA'),
(NULL,'ECUATORIANA-ITALIANA'),
(NULL,'ECUATORIANA-ESTADOUNIDENSE-INGLESA'),
(NULL,'ECUATORIANA-MEXICANA'),
(NULL,'ECUATORIANA-ALEMANA'),
(NULL,'ECUATORIANA-ESPA�OLA'),
(NULL,'ECUATORIANA-COLOMBIANA'),
(NULL,'ECUATORIANA-CHILENA'),
(NULL,'ECUATORIANA-PERUANA'),
(NULL,'ECUATORIANA-URUGUAYA'),
(NULL,'ECUATORIANA-PARAGUAYA');


/*==============================================================*/
/*Table:teacher_degree*/
/*==============================================================*/
INSERT INTO `teacher_degree`(`serial_tdg`,`name_tdg`) VALUES
(NULL,'Licenciado en Ciencias de la Educaci�n'),
(NULL,'Profesores de segunda ense�anza'),
(NULL,'Otros T�tulos en CCEE con 4 o m�s a�os de estudio'),
(NULL,'Profesores de Primaria(Ins.Pedag�gico)'),
(NULL,'Tecnol�gico Educativo'),
(NULL,'Auxiliar Pedag�gico'),
(NULL,'Asistente Pedag�gico'),
(NULL,'Facilitador�Pedag�gico'),
(NULL,'Bachiller en Ciencias de la Educaci�n'),
(NULL,'Normalista rural'),
(NULL,'Doctorado en ciencias de la educaci�n');

/*==============================================================*/
/*Table:teacher_master_degree*/
/*==============================================================*/
INSERT INTO `teacher_master_degree`(`serial_tmd`,`name_tmd`)VALUES
(NULL,'M�ster y/o Phd en�ciencias de la educaci�n');
/*==============================================================*/
/*Table:teacher_specialty*/
/*==============================================================*/
INSERT INTO `teacher_specialty`(`serial_tst`,`name_tst`)VALUES
(NULL,'Administraci�n educativa'),
(NULL,'Artes aplicadas'),
(NULL,'Auxiliar de laboratorio de ciencias naturales y Biolog�a'),
(NULL,'Ciencias exactas'),
(NULL,'Ciencias sociales'),
(NULL,'Comercio ya dministraci�n'),
(NULL,'Comunicaci�n educativa'),
(NULL,'Contabilidad y administraci�n'),
(NULL,'Dise�o y dibujo'),
(NULL,'Docencia y desarrollo comunitario'),
(NULL,'Docencia y gesti�n en educaci�n b�sica'),
(NULL,'Ecoturismo'),
(NULL,'Educaci�n art�stica'),
(NULL,'Educaci�n primaria'),
(NULL,'Educaci�n especial'),
(NULL,'Educaci�n inicial'),
(NULL,'Educaci�n parvularia'),
(NULL,'Educaci�n superior'),
(NULL,'Electricidad'),
(NULL,'Filosof�a y pedagog�a'),
(NULL,'F�sico matem�ticas'),
(NULL,'Gerencia educativa'),
(NULL,'Idiomas'),
(NULL,'Inform�tica'),
(NULL,'Inform�tica y programaci�n'),
(NULL,'Ingl�s y plurilingue'),
(NULL,'Laboratorio de ciencias naturales'),
(NULL,'Liderazgo educativo'),
(NULL,'Literatura y castellano'),
(NULL,'Mec�nica industrial'),
(NULL,'Monitor de actividad f�sica'),
(NULL,'Pedagog�a y gerencia educativa'),
(NULL,'Promoci�n y educaci�n para la salud'),
(NULL,'Psicolog�a educativa y orientaci�n vocacional'),
(NULL,'Psicolog�a infantil'),
(NULL,'Psicopedagog�a infantil'),
(NULL,'Qu�mico biol�gicas'),
(NULL,'Supervisi�n y administraci�n educativa'),
(NULL,'Turismo hist�rico y cultural'),
(NULL,'Administaci�n'),
(NULL,'Inform�tica'),
(NULL,'Comunicaci�n'),
(NULL,'Agronom�a'),
(NULL,'Medicina'),
(NULL,'Civil/arquitectura'),
(NULL,'Teolog�a'),
(NULL,'Administraci�n y supervisi�n educativa'),
(NULL,'Asignaturas secretariales'),
(NULL,'Bellas artes'),
(NULL,'Ciencias naturales'),
(NULL,'Ciencias socioecon�micas y pol�ticas'),
(NULL,'Computaci�n'),
(NULL,'Contabilidad'),
(NULL,'Cultura fisica'),
(NULL,'Docencia primaria'),
(NULL,'Docencia y gesti�n en bachillerato'),
(NULL,'Docencia y gesti�n en educaci�n parvularia'),
(NULL,'Educaci�n ambiental'),
(NULL,'Educaci�n b�sica'),
(NULL,'Educaci�n de adultos'),
(NULL,'Educaci�n f�sica,deportes y recreaci�n'),
(NULL,'Educaci�n intercultural�biling�e'),
(NULL,'Educaci�n preescolar'),
(NULL,'Educaci�n y estudios interculturales'),
(NULL,'Filosof�a y ciencias psicosociales'),
(NULL,'Filosof�a,sociolog�a y econom�a'),
(NULL,'Geograf�a y ecolog�a'),
(NULL,'Historia y geograf�a'),
(NULL,'Idiomas y ling��stica'),
(NULL,'Inform�tica educativa'),
(NULL,'Ingl�s'),
(NULL,'Investigaci�n y planificaci�n educativa'),
(NULL,'Lengua y literatura'),
(NULL,'Ling��stica(ingl�s-franc�s,ingl�s-italiano,ingl�s-alem�n)'),
(NULL,'Mec�nica automotriz'),
(NULL,'Mercadotecnia y publicidad'),
(NULL,'Opciones pr�cticas'),
(NULL,'Planificaci�n y dise�o curricular'),
(NULL,'Psicolog�a del adolescente y orientaci�n'),
(NULL,'Psicolog�a gerontol�gico'),
(NULL,'Psicolog�a y pedagog�a'),
(NULL,'Psicorehabilitaci�n y educaci�n especial'),
(NULL,'Secretariado en espa�ol'),
(NULL,'Teatro y arte dramatico'),
(NULL,'Otras especializaciones de t�tulos docentes'),
(NULL,'Econom�a'),
(NULL,'Derecho'),
(NULL,'Medicina veterinaria'),
(NULL,'Geolog�a'),
(NULL,'Antropolog�a'),
(NULL,'Otras ingenier�as'),
(NULL,'Artes');
/*==============================================================*/
/*Table:degree													*/
/*==============================================================*/
INSERT INTO `degree`(`serial_dgr`,`name_dgr`) VALUES
(NULL,'Artes aplicadas'),
(NULL,'Auxiliar de laboratorio de ciencias naturales y Biolog�a'),
(NULL,'Ciencias exactas'),
(NULL,'Ciencias sociales'),
(NULL,'Comercio y administraci�n'),
(NULL,'Comunicaci�n educativa'),
(NULL,'Contabilidad y administraci�n'),
(NULL,'Dise�o y dibujo'),
(NULL,'Docencia y desarrollo comunitario'),
(NULL,'Docencia y gesti�n en educaci�n b�sica'),
(NULL,'Ecoturismo'),
(NULL,'Educaci�n art�stica'),
(NULL,'Educaci�n primaria'),
(NULL,'Educaci�n especial'),
(NULL,'Educaci�n inicial'),
(NULL,'Educaci�n parvularia'),
(NULL,'Educaci�n superior'),
(NULL,'Electricidad');
/*==============================================================*/
/*Table:master_degree											*/
/*==============================================================*/
INSERT INTO `degree`(`serial_dgr`,`name_dgr`) VALUES
(NULL,'Diplomado'),
(NULL,'Especialista'),
(NULL,'Phd'),
(NULL,'M�ster');

/*==============================================================*/
/*Table:university											*/
/*==============================================================*/
INSERT INTO `university`(`serial_unv`,`name_unv`) VALUES
(NULL,'Escuela Polit�cnica del Ej�rcito'),
(NULL,'Escuela Polit�cnica Nacional'),
(NULL,'Universidad Central del Ecuador'),
(NULL,'Universidad Tecnol�gica Equinoccial'),
(NULL,'Escuela Polit�cnica Javeriana'),
(NULL,'Universidad Aut�noma de Quito'),
(NULL,'Universidad Del Pac�fico'),
(NULL,'Universidad Tecnol�gica America'),
(NULL,'Universidad Tecnol�gica Israel'),
(NULL,'Universidad De Especialidades Turisticas'),
(NULL,'Universidad de las Americas'),
(NULL,'Universidad Internacional del Ecuador'),
(NULL,'Universidad Internacional SEK'),
(NULL,'Universidad San Francisco de Quito'),
(NULL,'Universidad Polit�cnica Salesiana'),
(NULL,'Pontificia Universidad Catolica del Ecuador'),
(NULL,'Universidad Tecnol�gica Indoam�rica'),
(NULL,'Otra');

/*==============================================================*/
/*Table:language												*/
/*==============================================================*/
INSERT INTO `language`(`serial_lng`,`abbreviation_lng`,`name_lng`) VALUES
(NULL,'ES','Espa�ol'),
(NULL,'EN','Ingl�s');


INSERT INTO `grade_criteria` (
`serial_gct` ,
`name_gct` ,
`description_gct` ,
`status_gct`
)
VALUES (
NULL , '* General', 'Criterio General,se usa cuando no se va a aplicar criterios de calificaci�n.', 'ACTIVE'
);

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

INSERT INTO `activity_type` (`serial_att`, `name_att`, `description_att`, `status_att`) VALUES (NULL, 'Disciplina', 'Disciplina', 'ACTIVE');

--
-- Volcar la base de datos para la tabla `message_between_profiles`
--

INSERT INTO `message_between_profiles` (`serial_prf`, `pro_serial_prf`, `status_mbp`) VALUES
(1, 1, 'ACTIVE'),
(1, 2, 'ACTIVE'),
(1, 3, 'ACTIVE'),
(1, 4, 'ACTIVE'),
(1, 5, 'ACTIVE'),
(2, 4, 'ACTIVE'),
(2, 5, 'ACTIVE'),
(3, 3, 'ACTIVE'),
(3, 4, 'ACTIVE'),
(4, 2, 'ACTIVE'),
(4, 3, 'ACTIVE'),
(4, 4, 'ACTIVE'),
(5, 3, 'ACTIVE'),
(5, 4, 'ACTIVE'),
(5, 5, 'ACTIVE');

INSERT INTO `change_reason` (`serial_chr`, `name_chr`, `type_chr`, `status_chr`) VALUES 
(NULL, 'Exclusi�n de Actividad', 'ACTIVITY', 'ACTIVE');

INSERT INTO `payment_method` (`serial_pym`, `name_pym`, `status_pym`) VALUES 
('1', 'Diferido Corriente', 'ACTIVE');


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

INSERT INTO `authority_charge` (`serial_atc`, `name_atc`, `description_atc`, `status_atc`) VALUES
(1, 'Rector', 'Rector', 'ACTIVE'),
(2, 'Vicerector', 'Vicerector', 'ACTIVE'),
(3, 'Secretaria', 'Secretaria', 'ACTIVE'),
(4, 'Secretaria General', 'Secretaria General', 'ACTIVE'),
(5, 'Primer Vocal', 'Primer Vocal', 'ACTIVE'),
(6, 'Segundo Vocal', 'Segundo Vocal', 'ACTIVE'),
(7, 'Tercer Vocal', 'Tercer Vocal', 'ACTIVE');


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

INSERT INTO `discount` (`serial_dsc`, `name_dsc`, `status_dsc`) VALUES
(1, 'Beca 1 Hermano', 'ACTIVE'),
(2, 'Beca 2 hermanos', 'ACTIVE'),
(3, 'Beca 3 hermanos', 'ACTIVE'),
(4, 'Beca 4 hermanos', 'ACTIVE'),
(5, 'Beca 5 hermanos', 'ACTIVE'),
(6, 'Beca 6 hermanos', 'ACTIVE'),
(7, 'Beca 7 hermanos', 'ACTIVE'),
(8, 'Beca 8 hermanos', 'ACTIVE'),
(9, 'Beca 9 hermanos', 'ACTIVE'),
(10, 'Beca 10 hermanos', 'ACTIVE'),
(11, 'Beca 11 hermanos', 'ACTIVE'),
(12, 'Beca 12 hermanos', 'ACTIVE'),
(13, 'Beca 13 hermanos', 'ACTIVE'),
(14, 'Beca 14 hermanos', 'ACTIVE'),
(15, 'Beca 15 hermanos', 'ACTIVE');

SET FOREIGN_KEY_CHECKS =1;