-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Servidor: localhost -- Tiempo de generación: 27-01-2011 a las 23:22:42 -- 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', 'Área de Matemáticas', 'ACTIVE'), (2, 'Sociales', 'Sociales', 'ACTIVE'), (3, 'Música', 'música', 'ACTIVE'), (4, 'Deportes', 'Deportes', 'ACTIVE'), (5, 'Lenguaje', 'Lenguaje', 'ACTIVE'), (6, 'Ciencias', 'Biología\r\nQuímica', 'ACTIVE'), (7, 'Idiomas', 'Idiomas', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `access_log` -- INSERT INTO `access_log` (`serial_alg`, `serial_usr`, `serial_prf`, `login_date_alg`) VALUES (1, 1, 1, '2011-01-27 14:44:19'); -- -- 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_policy_violations` -- -- -- 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, 'Examen', 'examen', 'ACTIVE'), (3, 'Deber', 'Deber', 'ACTIVE'); -- -- 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', 'Calentador #40', 30, 'ACTIVE'), (2, 'ART-002', 'Busos Colegio #40', 30, 'ACTIVE'), (3, 'ART-003', 'Camisetas Deporte #40', 30, 'ACTIVE'), (4, 'ART-004', 'Libro de Matemáticas', 20, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `authority` -- -- -- 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 `bus` -- INSERT INTO `bus` (`serial_bus`, `code_bus`, `plate_num_bus`, `description_bus`, `capacity_bus`, `status_bus`) VALUES (1, 'B-001', 'Pbz-756', 'Bus # 1', 100, 'ACTIVE'), (2, 'B-002', 'gye-890', 'Bus #2', 25, 'ACTIVE'), (3, 'B-003', 'ppp-555', 'bus 3', 40, 'ACTIVE'), (4, 'B-004', 'pbc-820', 'bus 4', 20, 'ACTIVE'), (5, 'B-005', 'Xbz-336', 'bus 5', 35, 'ACTIVE'), (6, 'B-006 INACTIV', 'bus-741', 'bus inactivo', 20, '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, '789456123', 'Nelsinho', 'Fury', '123456', '', '789456', '', '', 'Rumipamba 555', 'A', '2015-12-17', 'ACTIVE'), (2, '7894561230', 'Sebastian', 'Vettel', '123456', '', '951951', '', '', 'su casa 555', 'AB', '2012-12-31', 'ACTIVE'), (3, '7894561231', 'Peter', 'Parker', '7538691', '', '156987420', '', '', 'alemania 741', 'Senior', '2010-12-24', 'ACTIVE'), (4, '7894561232', 'Chofer', 'Inactivo', '789456', '', '12301323', '', '', 'nose', 'A', '2010-12-19', 'INACTIVE'), (5, '7894561233', 'Tony', 'Stark', '4561234', '', '456123546', '', '', 'calle 11 y calle 19', 'Senior', '2011-12-29', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `bus_shift_year` -- INSERT INTO `bus_shift_year` (`serial_bdr`, `serial_rot`, `serial_scy`, `serial_bus`, `serial_sft`, `bus_serial_bdr`, `status_bpy`) VALUES (2, 1, 1, 1, 1, 1, 'ACTIVE'), (3, 1, 1, 2, 1, NULL, 'ACTIVE'), (5, 2, 1, 4, 1, NULL, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `bus_year_user` -- INSERT INTO `bus_year_user` (`serial_usr`, `serial_rot`, `serial_scy`, `serial_bus`, `serial_sft`, `status_byu`) VALUES (11, 1, 1, 2, 1, 'ACTIVE'), (13, 1, 1, 2, 1, 'ACTIVE'), (9, 1, 1, 1, 1, 'ACTIVE'), (5, 2, 1, 4, 1, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `cat_period` -- INSERT INTO `cat_period` (`serial_cpd`, `name_cpd`, `description_cpd`, `status_cpd`) VALUES (1, 'Trimestre', 'Trimestral', 'ACTIVE'), (2, 'Bimestre', 'Bimestral', 'ACTIVE'), (3, 'Semestre Inactivo', 'Semestre Inactivo', '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, 1, 1, 'MA-001', 'Matemática', 'ACTIVE'), (2, 1, 1, 1, 'MA-001-001', 'Básica', 'ACTIVE'), (3, 1, 1, 1, 'MA-001-002', 'Avanzada', 'ACTIVE'), (4, NULL, 1, 1, 'MA-002', 'Geometría', 'ACTIVE'), (5, NULL, 5, 1, 'Le-001', 'Gramática', 'ACTIVE'), (6, NULL, 5, 1, 'Le-002', 'Literatura', 'ACTIVE'), (7, NULL, 4, 1, 'De-001', 'Deportes', 'ACTIVE'), (8, 7, 4, 1, 'De-001-001', 'Fútbol', 'ACTIVE'), (9, 7, 4, 1, 'De-001-002', 'Basquet', 'ACTIVE'), (10, 7, 4, 1, 'De-001-003', 'Atletismo', 'ACTIVE'), (11, 7, 4, 1, 'De-001-004', 'Gimnasia', 'ACTIVE'), (12, NULL, 3, 1, 'Mu-001', 'Música', 'ACTIVE'), (13, 12, 3, 1, 'Mu-001-001', 'Guitarra', 'ACTIVE'), (14, 12, 3, 1, 'Mu-001-002', 'Pandereta', 'ACTIVE'), (15, 12, 3, 1, 'Mu-001-003', 'Clásica', 'ACTIVE'), (16, NULL, 6, 1, 'C-001', 'Química', 'ACTIVE'), (17, 16, 6, 1, 'C-001-001', 'Teoría', 'ACTIVE'), (18, 16, 6, 1, 'C-001-002', 'Laboratorio', 'ACTIVE'), (19, NULL, 2, 2, 'S-001', 'History', 'ACTIVE'), (20, NULL, 2, 2, 'S-002', 'Geography', 'ACTIVE'), (21, NULL, 2, 1, 'S-003', 'Cívica', 'ACTIVE'), (22, NULL, 7, 2, 'I-001', 'English', 'ACTIVE'), (23, 22, 7, 2, 'I-001-001', 'Grammar', 'ACTIVE'), (24, 22, 7, 2, 'I-001-002', 'Speaking', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `change_reason` -- INSERT INTO `change_reason` (`serial_chr`, `name_chr`, `type_chr`, `status_chr`) VALUES (1, 'Exclusión de Actividad', 'ACTIVITY', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `classroom` -- -- -- 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', 'A', 'ACTIVE'), (2, 'B', 'B', 'ACTIVE'), (3, 'C', 'C', 'ACTIVE'), (4, 'D INACTIVO', 'D', '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', 'ACTIVE'), (4, 'Antigua and barbuda', 'ACTIVE'), (5, 'Anguilla', 'ACTIVE'), (6, 'Albania', 'ACTIVE'), (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', 'ACTIVE'), (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, 1, 1, 1, 'DAY', 'ACTIVE'), (2, 2, 1, 1, 1, 1, 'DAY', 'ACTIVE'), (3, 1, 1, 2, 1, 1, 'DAY', 'ACTIVE'), (4, 2, 1, 2, 1, 1, 'DAY', 'ACTIVE'), (5, 3, 1, 2, 1, 1, 'DAY', 'ACTIVE'), (6, 3, 3, 4, 1, 2, 'CLASS', 'ACTIVE'), (7, 1, 2, 4, 1, 2, 'CLASS', 'ACTIVE'), (8, 2, 2, 4, 1, 2, 'CLASS', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `course_director` -- -- -- Volcar la base de datos para la tabla `credit_card` -- -- -- 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 `current_deferred` -- -- -- 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 `discount` -- -- -- Volcar la base de datos para la tabla `discount_payment_concept` -- -- -- 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, 3, NULL, NULL, 15, 61, 1, NULL, NULL, NULL, NULL, '123456789001', 'TEACHING', 'ACTIVE', 'Gonzalo', 'Chila', '', 'MALE', 'UNMARRIED PARTNERS', '1987-12-09', 'Vasco de Contreras 555', 'Morona', '', '', '3327019', '', '', '', '', 0, 0, NULL, NULL, '2010-12-08'), (2, NULL, 4, NULL, NULL, 8, 61, 1, NULL, NULL, NULL, NULL, '123456789002', 'TEACHING', 'ACTIVE', 'Ángel', 'Cheme', '', 'MALE', 'MARRIED', '1984-12-24', '12 de octubre y amazonas', 'San Lorenzo', '', '', '7894561', '', '', '', '', 0, 0, NULL, NULL, '2010-12-08'), (3, NULL, 5, NULL, NULL, 240, 217, 14, NULL, NULL, NULL, NULL, '123456789003', 'TEACHING', 'ACTIVE', 'María', 'Fernandez', '', 'FEMALE', 'DIVORCED', '1987-09-04', 'av. 6 de diciembre y Shyris', 'New York', '', '', '7410852', '', '', '', '', 0, 0, NULL, NULL, '2010-12-08'), (4, NULL, 6, NULL, NULL, 19, 61, 1, NULL, NULL, NULL, NULL, '123456789004', 'TEACHING', 'ACTIVE', 'Cristina', 'Jácome', '', 'FEMALE', 'SINGLE', '1983-04-06', 'av de la prensa 123', 'Quito', '', '', '7539510', '', '', '', '', 0, 0, NULL, NULL, '2010-12-08'); -- -- 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, 2, 'NO', 'ACTIVE'), (4, 1, 'NO', 'ACTIVE'), (5, 4, 'NO', 'ACTIVE'), (6, 4, 'NO', 'ACTIVE'), (7, 3, 'NO', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `financial_institution` -- -- -- 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 `general_discipline_log` -- -- -- 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, 'Presentación', 'presentación', 'ACTIVE'), (3, 'Desarrollo', 'desarrollo de la actividad', 'ACTIVE'), (4, 'Criterio INACTIVO', 'INACTIVO', 'INACTIVE'); -- -- Volcar la base de datos para la tabla `grade_score_change_log` -- -- -- Volcar la base de datos para la tabla `grade_subject_score` -- -- -- Volcar la base de datos para la tabla `group_hour` -- INSERT INTO `group_hour` (`serial_gph`, `name_gph`, `description_gph`, `status_gph`) VALUES (1, 'Grupo 1', 'Primer Grupo de Horas', 'ACTIVE'); -- -- 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 (1, 1, 1, 1, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 2, 1, 1, 'MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY', 'ACTIVE'), (1, 4, 1, 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`, `occupation_grd`, `company_name_grd`, `company_activity_grd`, `company_phone_grd`, `email_grd`, `status_grd`) VALUES (1, 2, NULL, '1715492656', 'Nelson', 'Mandela', '1986-02-12', 'MALE', 'casa', '222222222', NULL, NULL, NULL, NULL, NULL, 'ACTIVE'), (2, 8, NULL, '123456789010', 'Miguel', 'Andrade', '1960-12-08', 'MALE', 'calle A Manzana 7', '123456', 'Gerente', '', '', '', NULL, 'ACTIVE'), (3, 10, NULL, '123456789012', 'Juan', 'Ortega', '1978-12-21', 'MALE', 'valle de los chillos', '789456789', 'Docente', '', '', '', NULL, 'ACTIVE'), (4, 12, NULL, '123456789013', 'Alex', 'Aguilar', '1975-12-07', 'MALE', '10 de agosto', '7418529', 'Diseñador Gráfico', '', '', '', NULL, 'ACTIVE'), (5, 14, NULL, '123456789014', 'Andrés', 'Fernandez', '1979-12-07', 'MALE', '12 de cotubre', '55551201', 'Guía Turístico', '', '', '', NULL, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `guest` -- -- -- Volcar la base de datos para la tabla `hour` -- INSERT INTO `hour` (`serial_hrs`, `start_hrs`, `end_hrs`, `status_hrs`) VALUES (1, '07:00:00', '09:00:00', 'ACTIVE'), (2, '09:00:00', '09:30:00', 'ACTIVE'), (3, '09:30:00', '11:30:00', 'ACTIVE'), (4, '11:30:00', '12:15:00', 'ACTIVE'), (5, '12:15:00', '14: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'); -- -- Volcar la base de datos para la tabla `incident` -- -- -- Volcar la base de datos para la tabla `income_stock` -- -- -- Volcar la base de datos para la tabla `invoice` -- -- -- Volcar la base de datos para la tabla `invoice_detail` -- -- -- Volcar la base de datos para la tabla `item_category` -- -- -- 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, 'Primer Grado', 'Primer Grado..', 'ACTIVE'), (2, 'Segundo Grado', 'Segundo Grado', 'ACTIVE'), (3, 'Tercer Grado INACTIVO', 'INACTIVO', 'INACTIVE'), (4, 'Sexto Curso', 'Sexto Curso', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `level_optional_group` -- -- -- Volcar la base de datos para la tabla `level_optional_group_detail` -- -- -- Volcar la base de datos para la tabla `level_section_year` -- INSERT INTO `level_section_year` (`serial_pgy`, `serial_lvl`, `discipline_lsy`, `supervisor_grade_weight_lsy`, `teacher_grade_weight_lsy`, `order_lsy`, `serial_scy`, `serial_set`, `status_lsy`) VALUES (1, 1, NULL, NULL, NULL, NULL, 1, 1, 'ACTIVE'), (1, 2, NULL, NULL, NULL, NULL, 1, 1, 'ACTIVE'), (1, 4, NULL, NULL, NULL, NULL, 1, 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, 1, 1, 1, 'ACTIVE'), (1, 2, 1, 1, 'ACTIVE'), (2, 4, 1, 2, 'ACTIVE'), (3, 4, 1, 2, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `maintenance_item` -- -- -- 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_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'); -- -- 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 `ministry_resit_change_log` -- -- -- Volcar la base de datos para la tabla `ministry_resit_student` -- INSERT INTO `ministry_resit_student` (`serial_msb`, `serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`, `required_grade_mrs`, `grade_mrs`, `status_mrs`) VALUES (1, 1, 2, 4, 1, 2, '15.00', '20.00', 'ACTIVE'), (1, 2, 2, 4, 1, 2, '15.00', '20.00', 'ACTIVE'), (2, 1, 2, 4, 1, 2, '15.00', '20.00', 'ACTIVE'), (3, 1, 2, 4, 1, 2, '15.00', '20.00', 'ACTIVE'), (4, 1, 2, 4, 1, 2, '15.00', '20.00', 'ACTIVE'), (5, 2, 2, 4, 1, 2, '15.00', '20.00', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `ministry_subject` -- INSERT INTO `ministry_subject` (`serial_msb`, `name_msb`, `description_msb`, `grade_type_msb`, `status_msb`) VALUES (1, 'Matematica Grado', 'Matematica', 'QUALITATIVE', 'ACTIVE'), (2, 'Lenguaje Grado', 'Lenguaje', 'QUALITATIVE', 'ACTIVE'), (3, 'Ingles Grado', 'Ingles', 'QUANTITATIVE', 'ACTIVE'), (4, 'Quimica Grado', 'Quimica', 'QUALITATIVE', 'ACTIVE'), (5, 'Materia ministerio', 'Materia Prueba', 'QUANTITATIVE', 'ACTIVE'); -- -- 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_pgy`, `serial_csb`, `per_serial_pgy`, `serial_aca`, `serial_emp`, `status_osb`, `grade_type_sbc`) VALUES (1, 1, 15, NULL, 3, 2, '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, 2, 4, 1, 2, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `optional_subject_period` -- INSERT INTO `optional_subject_period` (`serial_prd`, `serial_osb`, `status_osp`) VALUES (1, 1, 'ACTIVE'), (2, 1, 'ACTIVE'), (4, 1, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `optional_subject_retest` -- -- -- Volcar la base de datos para la tabla `optional_subject_retest_student` -- -- -- 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` -- -- -- Volcar la base de datos para la tabla `opt_subject_retest_change_log` -- -- -- Volcar la base de datos para la tabla `opt_subject_year_activity_criteria_period` -- -- -- 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'), (3, 1, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `payment_concept` -- INSERT INTO `payment_concept` (`serial_pct`, `name_pct`, `status_pct`) VALUES (1, 'Pensión', 'ACTIVE'), (2, 'Uniformes', 'ACTIVE'), (3, 'Extras', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `payment_detail` -- -- -- Volcar la base de datos para la tabla `payment_method` -- INSERT INTO `payment_method` (`serial_pym`, `name_pym`, `requires_owner_info_pym`, `requires_financial_pym`, `requires_credit_card_pym`, `status_pym`) VALUES (1, 'Diferido Corriente', 'NO', 'NO', 'NO', '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', '2011-01-03', '2011-03-04', '2011-02-02', 'ACTIVE', '8.00', '20.00', '12.00', '30.00'), (2, 1, 'Segundo Bimestre', '2011-03-07', '2011-05-06', '2011-05-03', 'ACTIVE', '8.00', '20.00', '12.00', '30.00'), (3, 1, 'Bimestre Inactivo', '2011-05-09', '2011-05-14', '2011-05-11', 'INACTIVE', '8.00', '20.00', '10.00', '10.00'), (4, 1, 'Tercer Bimestre', '2011-05-16', '2011-07-08', '2011-07-06', '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, 1, 2, 'Grupo I', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `pre_registration` -- -- -- 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-12-08', '2010-12-31', 'OPEN'); -- -- Volcar la base de datos para la tabla `pre_registration_required_documment` -- -- -- 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, 199, '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, 134, 'Actividades', '#', '116.0', 'LOCKABLE'), (120, 119, 'Nueva Actividad (obsoleta)', '#', '1.0', 'LOCKABLE'), (121, 119, 'Actualizar Actividad (obsoleta)', '#', '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, 199, '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'), (139, 134, 'Ver Planes de Estudio', 'modules/download_subject_syllabus/fDownloadSubjectSyllabus', '1.0', 'LOCKABLE'), (140, 119, 'Calendario Actividades Alumno', 'modules/activity/fStudentCalendarActivity', '0.5', 'LOCKABLE'), (141, 119, 'Calendario Representante', 'modules/activity/fGuardianCalendarActivity', '0.5', 'LOCKABLE'), (142, 119, 'Calendario Actividades Profesor', '#', '0.5', 'LOCKABLE'), (143, 199, 'Disciplina', '#', '143.0', '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, 'Curso u 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'), (160, 147, 'Comunicaciones', '#', '1.0', 'LOCKABLE'), (161, 160, 'Enviar Comunicación', 'modules/message/fSendCommunication', '1.0', 'LOCKABLE'), (162, 1, 'Razones de Cambio', '#', '49.3', '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/fUpdateStudentInfo', '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, 'Nuevo 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.0', '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, 'Año Lectivo', '#', '45.0', 'LOCKABLE'), (200, 1, 'Materias del Ministerio', '#', '48.9', 'LOCKABLE'), (201, 200, 'Nueva Materia', 'modules/ministry_subject/fNewMinistrySubject', '1.0', 'LOCKABLE'), (202, 200, 'Actualizar Materia', 'modules/ministry_subject/fSearchMinistrySubject', '2.0', 'LOCKABLE'), (203, 39, 'Materias del Ministerio', '#', '203.0', 'LOCKABLE'), (204, 203, 'Definir Equivalencias', 'modules/subject_ministry_equivalence/fNewSubjectMinistryEquivalence', '1.0', 'LOCKABLE'), (205, 199, 'Registro de Novedades', '#', '205.0', 'LOCKABLE'), (206, 205, 'Registrar Novedad', 'modules/incident/fNewIncident', '1.0', 'LOCKABLE'), (207, NULL, 'Centro Médico', '#', '207.0', 'LOCKABLE'), (208, 207, 'Registrar Visita', 'modules/visits_medical_center/fNewVisit', '1.0', 'LOCKABLE'), (209, 142, 'Actividades Obligatorias', 'modules/activity/fTeacherCalendarActivity', '1.0', 'LOCKABLE'), (210, 142, 'Actividades Optativas', 'modules/opt_activity/fTeacherCalendarOptionalActivity', '1.0', 'LOCKABLE'), (211, 39, 'Disciplina', '#', '211.0', 'LOCKABLE'), (212, 211, 'Modo Calificación x Nivel', 'modules/level_section_year/fSearchYear', '1.0', 'LOCKABLE'), (213, 160, 'Crear Act. General', 'modules/general_activity/fGeneralCalendarActivity', '1.0', 'LOCKABLE'), (214, 149, 'Actividades', '#', '1.0', 'LOCKABLE'), (215, 214, 'Actividades x Curso o Materia Optativa', 'modules/reports/activity/fViewActivitiesByCourseOrSubject', '1.0', 'LOCKABLE'), (216, 156, 'Selección de Rubros para el Año', 'modules/student_year_debts/fSearchStudentdForSettingDebts', '1.0', 'LOCKABLE'), (217, 156, 'Anular Factura', 'modules/student_year_debts/fSearchInvoiceToVoid', '3.0', 'LOCKABLE'), (218, 134, 'Exámenes de Recuperación', '#', '218.0', 'LOCKABLE'), (219, 218, 'Materias Obligatorias', '#', '1.0', 'LOCKABLE'), (220, 219, 'Configurar Exámenes', 'modules/subject_course_retest/fNewSubjectCourseRetest', '1.0', 'LOCKABLE'), (221, 219, 'Calififcar Exámenes', 'modules/subject_course_retest_student/fNewSubjectCourseRetestStudent', '2.0', 'LOCKABLE'), (222, 218, 'Materias Optativas', '#', '2.0', 'LOCKABLE'), (223, 222, 'Configurar Exámenes', 'modules/optional_subject_retest/fNewOptionalSubjectRetest', '1.0', 'LOCKABLE'), (224, 222, 'Calififcar Exámenes', 'modules/optional_subject_retest_student/fNewOptionalSubjectRetestStudent', '2.0', 'LOCKABLE'), (225, 199, 'Supletorios', '#', '225.0', 'LOCKABLE'), (226, 225, 'Calificar Exámenes', 'modules/resit_student/fGradeResitExam', '1.0', 'LOCKABLE'), (227, 199, 'Registro de Hermanos', '#', '227.0', 'LOCKABLE'), (228, 227, 'Ingresar Solicitud', 'modules/relationship_application/fSelectStudent', '1.0', 'LOCKABLE'), (229, 45, 'Aprobar Solicitud de Hermanos', 'modules/relationship_application/fRelationshipApproval', '229.0', 'LOCKABLE'), (230, 1, 'Descuentos', '#', '51.3', 'LOCKABLE'), (231, 230, 'Nuevo Descuento', 'modules/discount/fNewDiscount', '1.0', 'LOCKABLE'), (232, 230, 'Actualizar Descuento', 'modules/discount/fSearchDiscount', '2.0', 'LOCKABLE'), (233, 39, 'Descuentos', '#', '115.0', 'LOCKABLE'), (234, 233, 'Iniciar/Continuar', 'modules/year_discount/fAssignYearDiscount', '1.0', 'LOCKABLE'), (235, 1, 'Documentos Habilitantes', '#', '51.3', 'LOCKABLE'), (236, 235, 'Nuevo Documento', 'modules/qualifying_document/fNewQualifyingDocument', '1.0', 'LOCKABLE'), (237, 235, 'Actualizar Documento', 'modules/qualifying_document/fSearchQualifyingDocument', '2.0', 'LOCKABLE'), (238, 39, 'Documentos Habilitantes', '#', '51.3', 'LOCKABLE'), (239, 238, 'Iniciar/Continuar', 'modules/year_qualifying_document/fYearQualifyingDocument', '1.0', '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.0', 'LOCKABLE'), (243, 199, 'Descuentos', '#', '45.1', 'LOCKABLE'), (244, 243, 'Asignar a Estudiante', 'modules/student_year_discount_values/fSearchStudentForAssignDiscounts', '1.0', 'LOCKABLE'), (245, 156, 'Mantenimiento', '#', '4.0', 'LOCKABLE'), (246, 245, 'Ingreso de Stock', 'modules/income_stock/fNewIncomeStock', '1.0', 'LOCKABLE'), (247, 245, 'Salida de Stock', 'modules/stock_request/fNewStockRequest', '1.0', 'LOCKABLE'), (248, 199, 'Calendario Actvidades Empleados', 'modules/employee/general/fActivitiesForEmployee', '248.0', 'LOCKABLE'), (249, 149, 'Ministerio', '#', '4.0', 'LOCKABLE'), (250, 249, 'Contrato de Servicios', 'modules/reports/ministry/fServiceContract', '1.0', 'LOCKABLE'), (251, 249, 'Estudiantes Matriculados', 'modules/reports/student_matriculated/fViewMatriculatedStudents', '2.0', 'LOCKABLE'), (252, 249, 'Acta de Matrícula', 'modules/reports/ministry/fRegistrationCertificate', '3.0', 'LOCKABLE'), (253, 249, 'Acta de Grado', 'modules/reports/school_certificate/fNewSchoolCertificate', '4.0', 'LOCKABLE'), (254, 167, 'Mínimo de Supletorios Ministerio', 'modules/year_resit_exam_ranges_ministry/fNewYearResitExamRangesMinistry', '3.0', '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, 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'), (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, 229, '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'), (2, 46, 'ACTIVE'), (2, 47, 'ACTIVE'), (2, 101, 'ACTIVE'), (2, 139, 'ACTIVE'), (2, 141, 'ACTIVE'), (2, 148, 'ACTIVE'), (2, 216, 'ACTIVE'), (2, 228, 'ACTIVE'), (3, 131, 'ACTIVE'), (3, 132, 'ACTIVE'), (3, 139, 'ACTIVE'), (3, 140, 'ACTIVE'), (3, 148, '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'), (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'), (5, 148, 'ACTIVE'), (5, 248, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `provider` -- -- -- Volcar la base de datos para la tabla `psychological_file` -- -- -- Volcar la base de datos para la tabla `qualifying_document` -- -- -- Volcar la base de datos para la tabla `qualitative_equivalence` -- -- -- Volcar la base de datos para la tabla `related_student` -- -- -- Volcar la base de datos para la tabla `relationship_application` -- -- -- Volcar la base de datos para la tabla `request_detail` -- -- -- Volcar la base de datos para la tabla `resit_change_log` -- -- -- Volcar la base de datos para la tabla `resit_student` -- -- -- Volcar la base de datos para la tabla `route` -- INSERT INTO `route` (`serial_rot`, `code_rot`, `description_rot`, `status_rot`) VALUES (1, 'RUT-001', 'Ruta 1', 'ACTIVE'), (2, 'RUT-002', 'Ruta 2', 'ACTIVE'), (3, 'RUT-003', 'ruta 3', 'ACTIVE'), (4, 'RUT-004 IN', 'ruta inactiva', '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 X', 'Quito', 'Av 10 de Agosto y Gaspar de Villaroel', '1237894', NULL, NULL, 'Juan Pérez', '099555555', '50ebb0.jpeg', NULL, '0a2ac7', '000000'); -- -- 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`, `invoice_due_max_day_scy`, `ministry_max_grade_scy`) VALUES (1, '2011-01-03', '2012-10-03', 'NEW', '2011-2012', 2, NULL, '0.00'); -- -- 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 en la Mañana', 'ACTIVE', 'DAY'), (2, 'Secundaria', 'Secundaria Diurna', 'ACTIVE', 'DAY'), (3, 'Kinder INACTIVO', 'Kinder inactivo', 'INACTIVE', 'DAY'), (4, 'Secundaria', 'Secundaria Vespertina', 'ACTIVE', 'EVENING'), (5, 'Primaria INACTIVA', 'primaria vespertina inactiva', '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 (1, 1, 'ACTIVE'), (1, 2, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `shift` -- INSERT INTO `shift` (`serial_sft`, `name_sft`, `description_sft`, `status_sft`) VALUES (1, 'Mañana', 'Mañana', 'ACTIVE'), (2, 'Tarde', 'Tarde', 'ACTIVE'), (3, 'Noche', 'Noche', 'ACTIVE'), (4, 'Medio día INACTIVO', 'Turno desactivado', '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', 'Física\r\nMatemática\r\nGeometría', 'ACTIVE'), (3, 'Químico-Biólogo', 'Química\r\nBiología', 'ACTIVE'), (4, 'Sociales INACTIVA', 'INACTIVA', 'INACTIVE'); -- -- Volcar la base de datos para la tabla `special_grade_change_log` -- -- -- 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 `stock_request` -- -- -- Volcar la base de datos para la tabla `student` -- INSERT INTO `student` (`serial_std`, `serial_ste`, `serial_usr`, `serial_nnt`, `id_std`, `first_name_std`, `last_name_std`, `birthdate_std`, `birthcity_std`, `gender_std`, `address_std`, `phone_std`, `type_std`, `email_std`, `status_std`) VALUES (1, NULL, 7, 13, 'STD1', 'Miguel', 'Andrade', '1994-10-01', NULL, 'MALE', 'calle A Manzana 7', '123456', 'NEW', NULL, 'ACTIVE'), (2, NULL, 9, 1, 'STD2', 'Catalina', 'Ortega', '1994-12-06', NULL, 'FEMALE', 'valle de los chillos', '789456789', 'NEW', NULL, 'ACTIVE'), (3, NULL, 11, 1, 'STD3', 'Marcelo', 'Aguilar', '1994-12-14', NULL, 'MALE', '10 de agosto', '1478529', 'NEW', NULL, 'ACTIVE'), (4, NULL, 13, 1, 'STD4', 'Santiago', 'Fernandez', '1994-12-07', NULL, 'MALE', '12 de octubre', '7899630', 'NEW', NULL, '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, 7, 'ACTIVE'), (2, 8, 'ACTIVE'), (3, 7, 'ACTIVE'), (4, 8, '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, 2, 'PARENT', 'YES', 'ACTIVE'), (2, 3, 'PARENT', 'YES', 'ACTIVE'), (3, 4, 'PARENT', 'YES', 'ACTIVE'), (4, 5, 'PARENT', 'YES', 'ACTIVE'); -- -- Volcar la base de datos para la tabla `student_optional_subject` -- INSERT INTO `student_optional_subject` (`serial_osb`, `serial_std`, `serial_prd`, `serial_lop`, `status_sos`) VALUES (1, 1, 0, 0, 'ACTIVE'), (1, 2, 0, 0, 'ACTIVE'), (1, 3, 0, 0, 'ACTIVE'), (1, 4, 0, 0, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `student_subject_period_average` -- -- -- Volcar la base de datos para la tabla `student_year` -- INSERT INTO `student_year` (`folio_number_sty`, `matricule_number_sty`, `is_listener_sty`, `serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`, `status_sty`) VALUES (NULL, 'STD1', 'NO', 1, 2, 4, 1, 2, 'REGISTERED'), (NULL, 'STD2', 'NO', 2, 2, 4, 1, 2, 'REGISTERED'), (NULL, 'STD3', 'NO', 3, 2, 4, 1, 2, 'REGISTERED'), (NULL, 'STD4', 'NO', 4, 2, 4, 1, 2, 'REGISTERED'); -- -- Volcar la base de datos para la tabla `student_year_debts` -- -- -- Volcar la base de datos para la tabla `student_year_discount` -- -- -- Volcar la base de datos para la tabla `student_year_discount_values` -- -- -- Volcar la base de datos para la tabla `student_year_document` -- -- -- Volcar la base de datos para la tabla `student_year_special_grade` -- -- -- 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, 8, 1, 1, 1, 1, 'ACTIVE'), (2, 9, 1, 1, 1, 1, 'ACTIVE'), (3, 2, 1, 1, 1, 1, 'ACTIVE'), (4, 5, 1, 1, 1, 1, 'ACTIVE'), (5, 13, 1, 1, 1, 1, 'ACTIVE'), (6, 24, 1, 1, 1, 1, 'ACTIVE'), (7, 2, 1, 2, 1, 1, 'ACTIVE'), (8, 8, 1, 2, 1, 1, 'ACTIVE'), (9, 9, 1, 2, 1, 1, 'ACTIVE'), (10, 21, 1, 2, 1, 1, 'ACTIVE'), (11, 13, 1, 2, 1, 1, 'ACTIVE'), (12, 23, 1, 2, 1, 1, 'ACTIVE'), (13, 24, 1, 2, 1, 1, 'ACTIVE'), (14, 3, 2, 4, 1, 2, 'ACTIVE'), (15, 4, 2, 4, 1, 2, 'ACTIVE'), (16, 6, 2, 4, 1, 2, 'ACTIVE'), (17, 8, 2, 4, 1, 2, 'INACTIVE'), (18, 9, 2, 4, 1, 2, 'INACTIVE'), (19, 15, 2, 4, 1, 2, 'INACTIVE'), (20, 10, 2, 4, 1, 2, 'ACTIVE'), (21, 19, 2, 4, 1, 2, 'ACTIVE'), (22, 20, 2, 4, 1, 2, 'ACTIVE'), (23, 2, 3, 4, 1, 2, 'ACTIVE'), (24, 17, 3, 4, 1, 2, 'ACTIVE'), (25, 18, 3, 4, 1, 2, 'ACTIVE'), (26, 8, 3, 4, 1, 2, 'INACTIVE'), (27, 9, 3, 4, 1, 2, 'INACTIVE'), (28, 6, 3, 4, 1, 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, 4, 1, 5, 4, 'ACTIVE', 'QUANTITATIVE', 5), (2, 4, 2, 5, 4, 'ACTIVE', 'QUANTITATIVE', 5), (3, 3, 1, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (4, 3, 2, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (5, 1, 1, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (6, 1, 2, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (7, 2, 1, 4, 1, 'ACTIVE', 'QUANTITATIVE', 1), (8, 2, 2, 4, 1, 'ACTIVE', 'QUANTITATIVE', 1), (9, 5, 1, 3, 2, 'ACTIVE', 'QUANTITATIVE', 3), (10, 5, 2, 3, 2, 'ACTIVE', 'QUANTITATIVE', 3), (11, 10, 3, 2, 3, 'ACTIVE', 'QUANTITATIVE', 3), (12, 10, 4, 2, 3, 'ACTIVE', 'QUANTITATIVE', 3), (13, 10, 5, 2, 3, 'ACTIVE', 'QUANTITATIVE', 3), (14, 7, 3, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (15, 7, 4, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (16, 7, 5, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (17, 8, 3, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (18, 8, 4, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (19, 8, 5, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (20, 9, 3, 4, 1, 'ACTIVE', 'QUANTITATIVE', 1), (21, 9, 4, 4, 1, 'ACTIVE', 'QUANTITATIVE', 1), (22, 9, 5, 4, 1, 'ACTIVE', 'QUANTITATIVE', 1), (23, 11, 3, 3, 2, 'ACTIVE', 'QUANTITATIVE', 2), (24, 11, 4, 3, 2, 'ACTIVE', 'QUANTITATIVE', 2), (25, 11, 5, 3, 2, 'ACTIVE', 'QUANTITATIVE', 2), (26, 15, 7, 1, 2, 'ACTIVE', 'QUANTITATIVE', 3), (27, 15, 8, 1, 2, 'ACTIVE', 'QUANTITATIVE', 3), (28, 16, 7, 5, 4, 'ACTIVE', 'QUANTITATIVE', 3), (29, 16, 8, 5, 4, 'ACTIVE', 'QUANTITATIVE', 3), (30, 14, 7, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (31, 14, 8, 1, 2, 'ACTIVE', 'QUANTITATIVE', 5), (32, 20, 7, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (33, 20, 8, 4, 1, 'ACTIVE', 'QUANTITATIVE', 2), (34, 28, 6, 5, 4, 'ACTIVE', 'QUANTITATIVE', 3), (35, 23, 6, 1, 2, 'ACTIVE', 'QUANTITATIVE', 3), (36, 24, 6, 6, 4, 'ACTIVE', 'QUANTITATIVE', 3), (37, 25, 6, 6, 4, 'ACTIVE', 'QUANTITATIVE', 3); -- -- 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', '100.00'), (1, 5, 'ACTIVE', '50.00'), (1, 6, 'ACTIVE', '50.00'), (1, 7, 'ACTIVE', '50.00'), (1, 8, 'ACTIVE', '50.00'), (1, 9, 'ACTIVE', '100.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', '50.00'), (1, 18, 'ACTIVE', '50.00'), (1, 19, 'ACTIVE', '50.00'), (1, 20, 'ACTIVE', '50.00'), (1, 21, 'ACTIVE', '50.00'), (1, 22, 'ACTIVE', '50.00'), (1, 23, 'ACTIVE', '100.00'), (1, 24, 'ACTIVE', '100.00'), (1, 25, 'ACTIVE', '100.00'), (1, 26, 'ACTIVE', '100.00'), (1, 27, 'ACTIVE', '100.00'), (1, 28, 'ACTIVE', '100.00'), (1, 29, 'ACTIVE', '100.00'), (1, 30, 'ACTIVE', '100.00'), (1, 31, 'ACTIVE', '100.00'), (1, 32, 'ACTIVE', '100.00'), (1, 33, 'ACTIVE', '100.00'), (1, 34, 'ACTIVE', '100.00'), (1, 35, 'ACTIVE', '100.00'), (1, 36, 'ACTIVE', '60.00'), (1, 37, 'ACTIVE', '40.00'), (2, 1, 'ACTIVE', '100.00'), (2, 2, 'ACTIVE', '100.00'), (2, 3, 'ACTIVE', '100.00'), (2, 4, 'ACTIVE', '100.00'), (2, 5, 'ACTIVE', '50.00'), (2, 6, 'ACTIVE', '50.00'), (2, 7, 'ACTIVE', '50.00'), (2, 8, 'ACTIVE', '50.00'), (2, 9, 'ACTIVE', '100.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', '50.00'), (2, 18, 'ACTIVE', '50.00'), (2, 19, 'ACTIVE', '50.00'), (2, 20, 'ACTIVE', '50.00'), (2, 21, 'ACTIVE', '50.00'), (2, 22, 'ACTIVE', '50.00'), (2, 23, 'ACTIVE', '100.00'), (2, 24, 'ACTIVE', '100.00'), (2, 25, 'ACTIVE', '100.00'), (2, 26, 'ACTIVE', '100.00'), (2, 27, 'ACTIVE', '100.00'), (2, 28, 'ACTIVE', '100.00'), (2, 29, 'ACTIVE', '100.00'), (2, 30, 'ACTIVE', '100.00'), (2, 31, 'ACTIVE', '100.00'), (2, 32, 'ACTIVE', '100.00'), (2, 33, 'ACTIVE', '100.00'), (2, 34, 'ACTIVE', '100.00'), (2, 35, 'ACTIVE', '100.00'), (2, 36, 'ACTIVE', '60.00'), (2, 37, 'ACTIVE', '40.00'), (4, 1, 'ACTIVE', '100.00'), (4, 2, 'ACTIVE', '100.00'), (4, 3, 'ACTIVE', '100.00'), (4, 4, 'ACTIVE', '100.00'), (4, 5, 'ACTIVE', '50.00'), (4, 6, 'ACTIVE', '50.00'), (4, 7, 'ACTIVE', '50.00'), (4, 8, 'ACTIVE', '50.00'), (4, 9, 'ACTIVE', '100.00'), (4, 10, 'ACTIVE', '100.00'), (4, 11, 'ACTIVE', '100.00'), (4, 12, 'ACTIVE', '100.00'), (4, 13, 'ACTIVE', '100.00'), (4, 14, 'ACTIVE', '100.00'), (4, 15, 'ACTIVE', '100.00'), (4, 16, 'ACTIVE', '100.00'), (4, 17, 'ACTIVE', '50.00'), (4, 18, 'ACTIVE', '50.00'), (4, 19, 'ACTIVE', '50.00'), (4, 20, 'ACTIVE', '50.00'), (4, 21, 'ACTIVE', '50.00'), (4, 22, 'ACTIVE', '50.00'), (4, 23, 'ACTIVE', '100.00'), (4, 24, 'ACTIVE', '100.00'), (4, 25, 'ACTIVE', '100.00'), (4, 26, 'ACTIVE', '100.00'), (4, 27, 'ACTIVE', '100.00'), (4, 28, 'ACTIVE', '100.00'), (4, 29, 'ACTIVE', '100.00'), (4, 30, 'ACTIVE', '100.00'), (4, 31, 'ACTIVE', '100.00'), (4, 32, 'ACTIVE', '100.00'), (4, 33, 'ACTIVE', '100.00'), (4, 34, 'ACTIVE', '100.00'), (4, 35, 'ACTIVE', '100.00'), (4, 36, 'ACTIVE', '40.00'), (4, 37, 'ACTIVE', '60.00'); -- -- Volcar la base de datos para la tabla `subject_course_retest` -- -- -- Volcar la base de datos para la tabla `subject_course_retest_student` -- -- -- Volcar la base de datos para la tabla `subject_ministry_equivalence` -- -- -- 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`, `due_min_days_spa`, `due_max_grade_spa`, `status_spa`) VALUES (2, 1, 1, '50.00', 0, 0, 'ACTIVE'), (2, 1, 2, '50.00', 0, 0, 'ACTIVE'), (2, 1, 3, '50.00', 0, 0, 'ACTIVE'), (2, 1, 4, '50.00', 0, 0, 'ACTIVE'), (2, 1, 5, '100.00', 0, 0, 'ACTIVE'), (2, 1, 6, '100.00', 0, 0, 'ACTIVE'), (2, 1, 7, '50.00', 0, 0, 'ACTIVE'), (2, 1, 8, '100.00', 0, 0, 'ACTIVE'), (2, 1, 9, '50.00', 0, 0, 'ACTIVE'), (2, 1, 10, '50.00', 0, 0, 'ACTIVE'), (2, 1, 26, '50.00', 0, 0, 'ACTIVE'), (2, 1, 27, '50.00', 0, 0, 'ACTIVE'), (2, 1, 28, '50.00', 0, 0, 'ACTIVE'), (2, 1, 29, '50.00', 0, 0, 'ACTIVE'), (2, 1, 30, '50.00', 0, 0, 'ACTIVE'), (2, 1, 31, '50.00', 0, 0, 'ACTIVE'), (2, 1, 32, '100.00', 0, 0, 'ACTIVE'), (2, 1, 33, '100.00', 0, 0, 'ACTIVE'), (2, 1, 34, '50.00', 0, 0, 'ACTIVE'), (2, 1, 35, '50.00', 0, 0, 'ACTIVE'), (2, 1, 36, '50.00', 0, 0, 'ACTIVE'), (2, 1, 37, '50.00', 0, 0, 'ACTIVE'), (2, 2, 1, '50.00', 0, 0, 'ACTIVE'), (2, 2, 2, '50.00', 0, 0, 'ACTIVE'), (2, 2, 3, '50.00', 0, 0, 'ACTIVE'), (2, 2, 4, '50.00', 0, 0, 'ACTIVE'), (2, 2, 5, '100.00', 0, 0, 'ACTIVE'), (2, 2, 6, '100.00', 0, 0, 'ACTIVE'), (2, 2, 7, '100.00', 0, 0, 'ACTIVE'), (2, 2, 8, '100.00', 0, 0, 'ACTIVE'), (2, 2, 9, '50.00', 0, 0, 'ACTIVE'), (2, 2, 10, '50.00', 0, 0, 'ACTIVE'), (2, 2, 26, '50.00', 0, 0, 'ACTIVE'), (2, 2, 27, '50.00', 0, 0, 'ACTIVE'), (2, 2, 28, '50.00', 0, 0, 'ACTIVE'), (2, 2, 29, '50.00', 0, 0, 'ACTIVE'), (2, 2, 30, '50.00', 0, 0, 'ACTIVE'), (2, 2, 31, '50.00', 0, 0, 'ACTIVE'), (2, 2, 32, '100.00', 0, 0, 'ACTIVE'), (2, 2, 33, '100.00', 0, 0, 'ACTIVE'), (2, 2, 34, '50.00', 0, 0, 'ACTIVE'), (2, 2, 35, '50.00', 0, 0, 'ACTIVE'), (2, 2, 36, '50.00', 0, 0, 'ACTIVE'), (2, 2, 37, '50.00', 0, 0, 'ACTIVE'), (2, 4, 1, '50.00', 0, 0, 'ACTIVE'), (2, 4, 2, '50.00', 0, 0, 'ACTIVE'), (2, 4, 3, '50.00', 0, 0, 'ACTIVE'), (2, 4, 4, '50.00', 0, 0, 'ACTIVE'), (2, 4, 5, '100.00', 0, 0, 'ACTIVE'), (2, 4, 6, '100.00', 0, 0, 'ACTIVE'), (2, 4, 7, '100.00', 0, 0, 'ACTIVE'), (2, 4, 8, '100.00', 0, 0, 'ACTIVE'), (2, 4, 9, '50.00', 0, 0, 'ACTIVE'), (2, 4, 10, '50.00', 0, 0, 'ACTIVE'), (2, 4, 26, '50.00', 0, 0, 'ACTIVE'), (2, 4, 27, '50.00', 0, 0, 'ACTIVE'), (2, 4, 28, '50.00', 0, 0, 'ACTIVE'), (2, 4, 29, '50.00', 0, 0, 'ACTIVE'), (2, 4, 30, '50.00', 0, 0, 'ACTIVE'), (2, 4, 31, '50.00', 0, 0, 'ACTIVE'), (2, 4, 32, '100.00', 0, 0, 'ACTIVE'), (2, 4, 33, '100.00', 0, 0, 'ACTIVE'), (2, 4, 34, '50.00', 0, 0, 'ACTIVE'), (2, 4, 35, '50.00', 0, 0, 'ACTIVE'), (2, 4, 36, '50.00', 0, 0, 'ACTIVE'), (2, 4, 37, '50.00', 0, 0, 'ACTIVE'), (3, 1, 1, '50.00', 0, 0, 'ACTIVE'), (3, 1, 2, '50.00', 0, 0, 'ACTIVE'), (3, 1, 3, '50.00', 0, 0, 'ACTIVE'), (3, 1, 4, '50.00', 0, 0, 'ACTIVE'), (3, 1, 5, '0.00', 0, 0, 'INACTIVE'), (3, 1, 6, '0.00', 0, 0, 'INACTIVE'), (3, 1, 7, '50.00', 0, 0, 'ACTIVE'), (3, 1, 8, '0.00', 0, 0, 'INACTIVE'), (3, 1, 9, '50.00', 0, 0, 'ACTIVE'), (3, 1, 10, '50.00', 0, 0, 'ACTIVE'), (3, 1, 26, '50.00', 0, 0, 'ACTIVE'), (3, 1, 27, '50.00', 0, 0, 'ACTIVE'), (3, 1, 28, '50.00', 0, 0, 'ACTIVE'), (3, 1, 29, '50.00', 0, 0, 'ACTIVE'), (3, 1, 30, '50.00', 0, 0, 'ACTIVE'), (3, 1, 31, '50.00', 0, 0, 'ACTIVE'), (3, 1, 32, '0.00', 0, 0, 'INACTIVE'), (3, 1, 33, '0.00', 0, 0, 'INACTIVE'), (3, 1, 34, '50.00', 0, 0, 'ACTIVE'), (3, 1, 35, '50.00', 0, 0, 'ACTIVE'), (3, 1, 36, '50.00', 0, 0, 'ACTIVE'), (3, 1, 37, '50.00', 0, 0, 'ACTIVE'), (3, 2, 1, '50.00', 0, 0, 'ACTIVE'), (3, 2, 2, '50.00', 0, 0, 'ACTIVE'), (3, 2, 3, '50.00', 0, 0, 'ACTIVE'), (3, 2, 4, '50.00', 0, 0, 'ACTIVE'), (3, 2, 5, '0.00', 0, 0, 'INACTIVE'), (3, 2, 6, '0.00', 0, 0, 'INACTIVE'), (3, 2, 7, '0.00', 0, 0, 'INACTIVE'), (3, 2, 8, '0.00', 0, 0, 'INACTIVE'), (3, 2, 9, '50.00', 0, 0, 'ACTIVE'), (3, 2, 10, '50.00', 0, 0, 'ACTIVE'), (3, 2, 26, '50.00', 0, 0, 'ACTIVE'), (3, 2, 27, '50.00', 0, 0, 'ACTIVE'), (3, 2, 28, '50.00', 0, 0, 'ACTIVE'), (3, 2, 29, '50.00', 0, 0, 'ACTIVE'), (3, 2, 30, '50.00', 0, 0, 'ACTIVE'), (3, 2, 31, '50.00', 0, 0, 'ACTIVE'), (3, 2, 32, '0.00', 0, 0, 'INACTIVE'), (3, 2, 33, '0.00', 0, 0, 'INACTIVE'), (3, 2, 34, '50.00', 0, 0, 'ACTIVE'), (3, 2, 35, '50.00', 0, 0, 'ACTIVE'), (3, 2, 36, '50.00', 0, 0, 'ACTIVE'), (3, 2, 37, '50.00', 0, 0, 'ACTIVE'), (3, 4, 1, '50.00', 0, 0, 'ACTIVE'), (3, 4, 2, '50.00', 0, 0, 'ACTIVE'), (3, 4, 3, '50.00', 0, 0, 'ACTIVE'), (3, 4, 4, '50.00', 0, 0, 'ACTIVE'), (3, 4, 5, '0.00', 0, 0, 'INACTIVE'), (3, 4, 6, '0.00', 0, 0, 'INACTIVE'), (3, 4, 7, '0.00', 0, 0, 'INACTIVE'), (3, 4, 8, '0.00', 0, 0, 'INACTIVE'), (3, 4, 9, '50.00', 0, 0, 'ACTIVE'), (3, 4, 10, '50.00', 0, 0, 'ACTIVE'), (3, 4, 26, '50.00', 0, 0, 'ACTIVE'), (3, 4, 27, '50.00', 0, 0, 'ACTIVE'), (3, 4, 28, '50.00', 0, 0, 'ACTIVE'), (3, 4, 29, '50.00', 0, 0, 'ACTIVE'), (3, 4, 30, '50.00', 0, 0, 'ACTIVE'), (3, 4, 31, '50.00', 0, 0, 'ACTIVE'), (3, 4, 32, '0.00', 0, 0, 'INACTIVE'), (3, 4, 33, '0.00', 0, 0, 'INACTIVE'), (3, 4, 34, '50.00', 0, 0, 'ACTIVE'), (3, 4, 35, '50.00', 0, 0, 'ACTIVE'), (3, 4, 36, '50.00', 0, 0, 'ACTIVE'), (3, 4, 37, '50.00', 0, 0, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `subject_retest_change_log` -- -- -- 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, 1, 1, 4, 2, 'ACTIVE'), (2, 1, 1, 4, 3, 'ACTIVE'), (2, 1, 2, 4, 2, 'ACTIVE'), (2, 1, 2, 4, 3, 'ACTIVE'), (2, 1, 3, 3, 2, 'ACTIVE'), (2, 1, 3, 3, 3, 'ACTIVE'), (2, 1, 4, 3, 2, 'ACTIVE'), (2, 1, 4, 3, 3, 'ACTIVE'), (2, 1, 5, 1, 2, 'INACTIVE'), (2, 1, 5, 1, 3, 'ACTIVE'), (2, 1, 6, 1, 2, 'ACTIVE'), (2, 1, 6, 1, 3, 'ACTIVE'), (2, 1, 7, 2, 2, 'INACTIVE'), (2, 1, 7, 2, 3, 'ACTIVE'), (2, 1, 8, 2, 2, 'ACTIVE'), (2, 1, 8, 2, 3, 'ACTIVE'), (2, 1, 9, 5, 2, 'ACTIVE'), (2, 1, 9, 5, 3, 'ACTIVE'), (2, 1, 10, 5, 2, 'ACTIVE'), (2, 1, 10, 5, 3, 'ACTIVE'), (2, 2, 1, 4, 2, 'ACTIVE'), (2, 2, 1, 4, 3, 'ACTIVE'), (2, 2, 2, 4, 2, 'ACTIVE'), (2, 2, 2, 4, 3, 'ACTIVE'), (2, 2, 3, 3, 2, 'ACTIVE'), (2, 2, 3, 3, 3, 'ACTIVE'), (2, 2, 4, 3, 2, 'ACTIVE'), (2, 2, 4, 3, 3, 'ACTIVE'), (2, 2, 5, 1, 2, 'INACTIVE'), (2, 2, 5, 1, 3, 'ACTIVE'), (2, 2, 6, 1, 2, 'ACTIVE'), (2, 2, 6, 1, 3, 'ACTIVE'), (2, 2, 7, 2, 2, 'INACTIVE'), (2, 2, 7, 2, 3, 'ACTIVE'), (2, 2, 8, 2, 2, 'ACTIVE'), (2, 2, 8, 2, 3, 'ACTIVE'), (2, 2, 9, 5, 2, 'ACTIVE'), (2, 2, 9, 5, 3, 'ACTIVE'), (2, 2, 10, 5, 2, 'ACTIVE'), (2, 2, 10, 5, 3, 'ACTIVE'), (2, 4, 1, 4, 2, 'ACTIVE'), (2, 4, 1, 4, 3, 'ACTIVE'), (2, 4, 2, 4, 2, 'ACTIVE'), (2, 4, 2, 4, 3, 'ACTIVE'), (2, 4, 3, 3, 2, 'ACTIVE'), (2, 4, 3, 3, 3, 'ACTIVE'), (2, 4, 4, 3, 2, 'ACTIVE'), (2, 4, 4, 3, 3, 'ACTIVE'), (2, 4, 5, 1, 2, 'INACTIVE'), (2, 4, 5, 1, 3, 'ACTIVE'), (2, 4, 6, 1, 2, 'ACTIVE'), (2, 4, 6, 1, 3, 'ACTIVE'), (2, 4, 7, 2, 2, 'INACTIVE'), (2, 4, 7, 2, 3, 'ACTIVE'), (2, 4, 8, 2, 2, 'ACTIVE'), (2, 4, 8, 2, 3, 'ACTIVE'), (2, 4, 9, 5, 2, 'ACTIVE'), (2, 4, 9, 5, 3, 'ACTIVE'), (2, 4, 10, 5, 2, 'ACTIVE'), (2, 4, 10, 5, 3, 'ACTIVE'), (3, 1, 1, 4, 2, 'ACTIVE'), (3, 1, 1, 4, 3, 'ACTIVE'), (3, 1, 2, 4, 2, 'ACTIVE'), (3, 1, 2, 4, 3, 'ACTIVE'), (3, 1, 3, 3, 2, 'ACTIVE'), (3, 1, 3, 3, 3, 'ACTIVE'), (3, 1, 4, 3, 2, 'ACTIVE'), (3, 1, 4, 3, 3, 'ACTIVE'), (3, 1, 5, 1, 2, 'INACTIVE'), (3, 1, 5, 1, 3, 'INACTIVE'), (3, 1, 6, 1, 2, 'INACTIVE'), (3, 1, 6, 1, 3, 'INACTIVE'), (3, 1, 7, 2, 2, 'INACTIVE'), (3, 1, 7, 2, 3, 'ACTIVE'), (3, 1, 8, 2, 2, 'INACTIVE'), (3, 1, 8, 2, 3, 'INACTIVE'), (3, 1, 9, 5, 2, 'ACTIVE'), (3, 1, 9, 5, 3, 'ACTIVE'), (3, 1, 10, 5, 2, 'ACTIVE'), (3, 1, 10, 5, 3, 'ACTIVE'), (3, 2, 1, 4, 2, 'ACTIVE'), (3, 2, 1, 4, 3, 'ACTIVE'), (3, 2, 2, 4, 2, 'ACTIVE'), (3, 2, 2, 4, 3, 'ACTIVE'), (3, 2, 3, 3, 2, 'ACTIVE'), (3, 2, 3, 3, 3, 'ACTIVE'), (3, 2, 4, 3, 2, 'ACTIVE'), (3, 2, 4, 3, 3, 'ACTIVE'), (3, 2, 5, 1, 2, 'INACTIVE'), (3, 2, 5, 1, 3, 'INACTIVE'), (3, 2, 6, 1, 2, 'INACTIVE'), (3, 2, 6, 1, 3, 'INACTIVE'), (3, 2, 7, 2, 2, 'INACTIVE'), (3, 2, 7, 2, 3, 'ACTIVE'), (3, 2, 8, 2, 2, 'INACTIVE'), (3, 2, 8, 2, 3, 'INACTIVE'), (3, 2, 9, 5, 2, 'ACTIVE'), (3, 2, 9, 5, 3, 'ACTIVE'), (3, 2, 10, 5, 2, 'ACTIVE'), (3, 2, 10, 5, 3, 'ACTIVE'), (3, 4, 1, 4, 2, 'ACTIVE'), (3, 4, 1, 4, 3, 'ACTIVE'), (3, 4, 2, 4, 2, 'ACTIVE'), (3, 4, 2, 4, 3, 'ACTIVE'), (3, 4, 3, 3, 2, 'ACTIVE'), (3, 4, 3, 3, 3, 'ACTIVE'), (3, 4, 4, 3, 2, 'ACTIVE'), (3, 4, 4, 3, 3, 'ACTIVE'), (3, 4, 5, 1, 2, 'INACTIVE'), (3, 4, 5, 1, 3, 'INACTIVE'), (3, 4, 6, 1, 2, 'INACTIVE'), (3, 4, 6, 1, 3, 'INACTIVE'), (3, 4, 7, 2, 2, 'INACTIVE'), (3, 4, 7, 2, 3, 'ACTIVE'), (3, 4, 8, 2, 2, 'INACTIVE'), (3, 4, 8, 2, 3, 'INACTIVE'), (3, 4, 9, 5, 2, 'ACTIVE'), (3, 4, 9, 5, 3, 'ACTIVE'), (3, 4, 10, 5, 2, 'ACTIVE'), (3, 4, 10, 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, 3, 'ACTIVE'), (2, 2, 'ACTIVE'), (2, 3, 'ACTIVE'), (3, 2, 'ACTIVE'), (3, 3, 'ACTIVE'), (4, 2, 'ACTIVE'), (4, 3, 'ACTIVE'), (5, 2, 'ACTIVE'), (5, 3, 'ACTIVE'), (6, 2, 'ACTIVE'), (6, 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', 'Impuesto al Valor Agregado', 'ACTIVE'), (2, 'ICE', 'Impuesto a Consumos Especiales', 'ACTIVE'); -- -- 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` -- INSERT INTO `teacher_hours_year` (`serial_thy`, `serial_emp`, `serial_scy`, `start_hour_thy`, `end_hour_thy`, `status_thy`, `labor_day_thy`) VALUES (1, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'MONDAY'), (2, 1, 1, '09:30:00', '11:00:00', 'ACTIVE', 'MONDAY'), (3, 1, 1, '07:00:00', '09:00:00', 'ACTIVE', 'TUESDAY'), (4, 1, 1, '09:30:00', '11:00:00', 'ACTIVE', 'TUESDAY'), (5, 1, 1, '12:15:00', '14:00:00', 'ACTIVE', 'WEDNESDAY'), (6, 1, 1, '12:00:00', '14:00:00', 'ACTIVE', 'THURSDAY'), (7, 1, 1, '12:00:00', '14:00:00', 'ACTIVE', 'FRIDAY'), (8, 3, 1, '07:00:00', '12:00:00', 'ACTIVE', 'MONDAY'), (9, 3, 1, '07:00:00', '12:00:00', 'ACTIVE', 'TUESDAY'), (10, 3, 1, '07:00:00', '12:00:00', 'ACTIVE', 'WEDNESDAY'), (11, 3, 1, '07:00:00', '12:00:00', 'ACTIVE', 'THURSDAY'), (12, 3, 1, '07:00:00', '12:00:00', 'ACTIVE', 'FRIDAY'), (13, 4, 1, '07:00:00', '09:00:00', 'ACTIVE', 'MONDAY'), (14, 4, 1, '07:00:00', '09:00:00', 'ACTIVE', 'TUESDAY'), (15, 4, 1, '07:00:00', '09:00:00', 'ACTIVE', 'WEDNESDAY'), (16, 4, 1, '07:00:00', '09:00:00', 'ACTIVE', 'THURSDAY'), (17, 4, 1, '07:00:00', '09:00:00', 'ACTIVE', 'FRIDAY'), (18, 2, 1, '10:00:00', '14:00:00', 'ACTIVE', 'MONDAY'), (19, 2, 1, '10:00:00', '14:00:00', 'ACTIVE', 'TUESDAY'), (20, 2, 1, '10:00:00', '14:00:00', 'ACTIVE', 'WEDNESDAY'), (21, 2, 1, '10:00:00', '14:00:00', 'ACTIVE', 'THURSDAY'), (22, 2, 1, '10:00:00', '14:00:00', 'ACTIVE', 'FRIDAY'); -- -- 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, NULL, 1, NULL, 'padre', 'e10adc3949ba59abbe56e057f20f883e', NULL, 'ACTIVE'), (3, 1, NULL, NULL, 'gochilla', NULL, NULL, 'ACTIVE'), (4, 2, NULL, NULL, 'Áncheme', NULL, '7608f7.jpeg', 'ACTIVE'), (5, 3, NULL, NULL, 'mafernan', NULL, 'a3affa.jpg', 'ACTIVE'), (6, 4, NULL, NULL, 'crjácome', NULL, NULL, 'ACTIVE'), (7, NULL, NULL, 1, 'miandrad', NULL, NULL, 'ACTIVE'), (8, NULL, 2, NULL, 'miandrad1', NULL, NULL, 'ACTIVE'), (9, NULL, NULL, 2, 'caortega', NULL, NULL, 'ACTIVE'), (10, NULL, 3, NULL, 'juortega', NULL, NULL, 'ACTIVE'), (11, NULL, NULL, 3, 'maaguila', NULL, NULL, 'ACTIVE'), (12, NULL, 4, NULL, 'alaguila', NULL, NULL, 'ACTIVE'), (13, NULL, NULL, 4, 'safernan', NULL, NULL, 'ACTIVE'), (14, NULL, 5, NULL, 'anfernan', NULL, NULL, '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'), (3, 4, 'ACTIVE'), (4, 4, 'ACTIVE'), (5, 4, 'ACTIVE'), (6, 4, 'ACTIVE'), (7, 3, 'ACTIVE'), (9, 3, 'ACTIVE'), (11, 3, 'ACTIVE'), (13, 3, 'ACTIVE'); -- -- Volcar la base de datos para la tabla `use_destination` -- -- -- Volcar la base de datos para la tabla `visits_medical_center` -- -- -- Volcar la base de datos para la tabla `web_pre_registration` -- -- -- Volcar la base de datos para la tabla `web_user` -- -- -- Volcar la base de datos para la tabla `year_concept_taxes` -- INSERT INTO `year_concept_taxes` (`serial_tax`, `value_yct`, `status_yct`, `serial_pct`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`) VALUES (1, '12.00', 'ACTIVE', 1, 2, 4, 1, 2), (1, '12.00', 'ACTIVE', 2, 2, 4, 1, 2); -- -- Volcar la base de datos para la tabla `year_discount` -- -- -- Volcar la base de datos para la tabla `year_grade_subject` -- -- -- Volcar la base de datos para la tabla `year_level_specialty_payment_concept` -- INSERT INTO `year_level_specialty_payment_concept` (`serial_art`, `serial_pct`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`, `value_ypc`, `frequency_ypc`, `repetitions_number_ypc`, `enabling_concept_ypc`, `mandatory_ypc`, `student_type_ypc`) VALUES (NULL, 1, 2, 4, 1, 2, '50.00', 'MONTHLY', 9, 'YES', 'YES', 'BOTH'), (1, 2, 2, 4, 1, 2, '60.00', 'ANNUAL', 1, 'NO', 'YES', 'BOTH'); -- -- Volcar la base de datos para la tabla `year_pre_registration_document` -- -- -- Volcar la base de datos para la tabla `year_qualifying_document` -- -- -- Volcar la base de datos para la tabla `year_report_comment` -- -- -- Volcar la base de datos para la tabla `year_resit_exam_ranges` -- -- -- Volcar la base de datos para la tabla `year_special_grade` -- -- -- Volcar la base de datos para la tabla `year_subject_classroom` -- SET FOREIGN_KEY_CHECKS =1;