vuzscript.sql

CREATE TABLE ADDRESS (
	ADDRESS_ID int auto_increment primary key NOT NULL,
	SETTLEMENT_ID int NULL,
	ADDRESS varchar(75) NULL
);

CREATE TABLE AREA (
	AREA_ID int auto_increment primary key NOT NULL,
	REGION_ID int NOT NULL,
	NAME varchar(50) NOT NULL
);

CREATE TABLE BASE_DISCIPLINE (
	BASE_DISCIPLINE_ID int auto_increment primary key NOT NULL,
	SUBFACULTY_ID int NOT NULL,
	NAME varchar(75) NOT NULL
);

CREATE TABLE BENEFITS (
	BENEFIT_ID int auto_increment primary key NOT NULL,
	NAME varchar(50) NULL
);

CREATE TABLE CARD (
	CARD_ID int auto_increment primary key NOT NULL,
	COURSE smallint NOT NULL,
	SEMESTER bit NOT NULL,
	YYEAR smallint NOT NULL
);

CREATE TABLE COUNTRY (
	COUNTRY_ID int auto_increment primary key NOT NULL,
	NAME varchar(30) NOT NULL
);

CREATE TABLE DEPARTAMENT (
	DEPARTMANENT_ID int auto_increment primary key NOT NULL,
	NAME varchar(50) NOT NULL
);

CREATE TABLE DISCIPLINE (
	DISCIPLINE_ID int auto_increment primary key NOT NULL,
	EDUCATION_PLAN_ID int NULL,
	BASE_DISCIPLINE_ID int NULL,
	HOURS smallint NOT NULL,
	Independent_Hours smallint NULL,
	Audience_Hours smallint NULL,
	SEMESTER bit NOT NULL,
	COURSE smallint NOT NULL,
	YYEAR smallint NOT NULL,
	CHECKING_FORM smallint NOT NULL
);

CREATE TABLE DISCIPLINE_TEACHER (
	DISCIPLINE_TEACHER_ID int auto_increment primary key NOT NULL,
	TEACHER_ID int NOT NULL,
	DISCIPLINE_ID int NOT NULL
);

CREATE TABLE EDUCATION_PLAN (
	EDUCATION_PLAN_ID int auto_increment primary key NOT NULL,
	SPECIALITY_ID int NOT NULL,
	DATA_START TIMESTAMP NULL,
	DATA_END TIMESTAMP NULL
);

CREATE TABLE EXAM_LIST (
	EXAM_LIST_ID int auto_increment primary key NOT NULL,
	NUMBER varchar(15) NULL,
	TYPE smallint NULL,
	DATE_CREATION TIMESTAMP NOT NULL
);

CREATE TABLE EXAM_MARK (
	EXAM_MARK_ID int auto_increment primary key NOT NULL,
	EXAM_LIST_ID int NOT NULL,
	STUDENT_GROUP_ID int NOT NULL,
	DISCIPLINE_ID int NOT NULL,
	STUDENT_ID int NOT NULL,
	VVALUE smallint NULL
);

CREATE TABLE FACULTY (
	FACULTY_ID int auto_increment primary key NOT NULL,
	NAME varchar(50) NOT NULL,
	SHORT_NAME varchar(7) NOT NULL,
	FACULTY_CODE smallint NULL
);

CREATE TABLE FACULTY_GROUP_CODE (
	FACULTY_GROUP_CODE_ID int auto_increment primary key NOT NULL,
	FACULTY_ID int NULL,
	COMMENT varchar(50) NULL
);

CREATE TABLE HOSPICE (
	HOSPICE_ID int auto_increment primary key NOT NULL,
	NAME varchar(75) NULL,
	STREET varchar(50) NULL,
	HOUSE smallint NULL,
	BUILDING smallint NULL
);

CREATE TABLE LANGUAGES (
	LANGUAGE_ID int auto_increment primary key NOT NULL,
	NAME varchar(25) NULL
);

CREATE TABLE MARK (
	MARK_ID int auto_increment primary key NOT NULL,
	DISCIPLINE_ID int NOT NULL,
	EXAM_LIST_ID int NULL,
	STUDENT_ID int NOT NULL,
	STUDENT_GROUP_ID int NOT NULL,
	VVALUE smallint NULL
);

CREATE TABLE NOTE (
	NOTE_ID int auto_increment primary key NOT NULL,
	STUDENT_ID int NOT NULL,
	CARD_ID int NOT NULL,
	STUDENT_GROUP_ID int NOT NULL,
	FREE_ATTENDANCE BOOLEAN NULL,
	REBUKE varchar(12) NULL,
	LAST_EXAM_DATE TIMESTAMP NULL,
	SESSION_PROLONGATION_DATE TIMESTAMP NULL,
	SESSION_CLOSING_DATE TIMESTAMP NULL,
	STUDENTGRANT varchar(7) NULL,
	PRACTICE varchar(7) NULL
);

CREATE TABLE OFFICE_ORDER (
	OFFICE_ORDER_ID int auto_increment primary key NOT NULL,
	ORDER_CATEGORY_ID int NOT NULL,
	PATH_TO_FILE varchar(100) NULL,
	EXTERNAL_NUMBER varchar(25) NULL,
	REASON varchar(512) NULL,
	SUBJECT varchar(2048) NULL,
	DATE_ORDER TIMESTAMP NULL,
	ISSIGNED BOOLEAN NULL,
	SIGNER_POSITION varchar(50) NULL,
	SIGNER_NAME varchar(100) NULL,
	MAKER_POSITION varchar(50) NULL,
	MAKER_NAME varchar(100) NULL,
	COORDINATOR1_POSITION varchar(50) NULL,
	COORDINATOR1_NAME varchar(100) NULL,
	COORDINATOR2_POSITION varchar(50) NULL,
	COORDINATOR2_NAME varchar(100) NULL,
	COORDINATOR3_POSITION varchar(50) NULL,
	COORDINATOR3_NAME varchar(100) NULL,
	COORDINATOR4_POSITION varchar(50) NULL,
	COORDINATOR4_NAME varchar(100) NULL,
	COORDINATOR5_POSITION varchar(50) NULL,
	COORDINATOR5_NAME varchar(100) NULL,
	COORDINATOR6_POSITION varchar(50) NULL,
	COORDINATOR6_NAME varchar(100) NULL
);

CREATE TABLE ORDER_CATEGORY (
	ORDER_CATEGORY_ID int auto_increment primary key NOT NULL,
	ORDER_CATEGORY varchar(100) NULL
);

CREATE TABLE PERSONAL (
	PERSONAL_ID int auto_increment primary key NOT NULL,
	POSITION_ID int NOT NULL,
	DEPARTMANENT_ID int NOT NULL,
	NAME varchar(25) NULL,
	PATRONYMIC varchar(25) NULL,
	FAMILY_NAME varchar(50) NULL
);

CREATE TABLE POSITION (
	POSITION_ID int auto_increment primary key NOT NULL,
	NAME varchar(50) NULL
);

CREATE TABLE REGION (
	REGION_ID int auto_increment primary key NOT NULL,
	COUNTRY_ID int NOT NULL,
	NAME varchar(50) NOT NULL
);

CREATE TABLE SETTLEMENT (
	SETTLEMENT_ID int auto_increment primary key NOT NULL,
	SETTLEMENT_DEFINITION_ID int NULL,
	AREA_ID int NULL,
	NAME varchar(50) NOT NULL
);

CREATE TABLE SETTLEMENT_DEFINITION (
	SETTLEMENT_DEFINITION_ID int auto_increment primary key NOT NULL,
	NAME varchar(25) NOT NULL
);

CREATE TABLE SPECIALITY (
	SPECIALITY_ID int auto_increment primary key NOT NULL,
	FACULTY_ID int NULL,
	NUMBER varchar(10) NOT NULL,
	NAME varchar(75) NOT NULL,
	SHORTNAME varchar(7) NOT NULL
);

CREATE TABLE STUDENT (
	STUDENT_ID int auto_increment primary key NOT NULL,
	STUDENT_GROUP_ID int NULL,
	ADDRESS_ID int NOT NULL,
	HOSPICE_ID int NULL,
	STUDENT_STATUS_ID int NOT NULL,
	BENEFIT_ID int NOT NULL,
	COUNTRY_ID int NOT NULL,
	LANGUAGE_ID int NOT NULL,
	NAME varchar(20) NOT NULL,
	PATRONYMIC varchar(25) NOT NULL,
	FAMILY_NAME varchar(50) NOT NULL,
	STUDENT_NUMBER varchar(6) NULL,
	REGISTRATION varchar(150) NULL,
	PASSPORT_DATA varchar(150) NOT NULL,
	Passport_Number varchar(15) NULL,
	Passport_Series varchar(15) NULL,
	Passport_Delivery varchar(150) NULL,
	HOSPICE_NEEDED BOOLEAN NOT NULL,
	SEX bit NOT NULL,
	CONTRACT BOOLEAN NOT NULL,
	COURSE_LEADER BOOLEAN NULL,
	Prof_Leader BOOLEAN NULL,
	LAST_EDUCATION_PLACE varchar(20) NULL,
	YEAR_STARTING TIMESTAMP NOT NULL,
	START_SPECIALITY_ID int NULL
);

CREATE TABLE STUDENT_EVENT (
	EVENT_ID int auto_increment primary key NOT NULL,
	NAME varchar(50) NULL,
	COMMENT varchar(100) NULL
);

CREATE TABLE STUDENT_GROUP (
	STUDENT_GROUP_ID int auto_increment primary key NOT NULL,
	PERSONAL_ID int NULL,
	SPECIALITY_ID int NOT NULL,
	COURSE tinyint NOT NULL,
	EDUCATION_DURATION BOOLEAN NOT NULL,
	NUMBER varchar(7) NULL
);

CREATE TABLE STUDENT_HISTORY (
	STUDENT_HISTORY_ID int auto_increment primary key NOT NULL,
	EVENT_ID int NOT NULL,
	USER_ID int NULL,
	OFFICE_ORDER_ID int NULL,
	STUDENT_ID int NULL,
	COMMENT varchar(250) NULL,
	DATE_EVENT TIMESTAMP NULL
);

CREATE TABLE STUDENT_STATUS (
	STUDENT_STATUS_ID int auto_increment primary key NOT NULL,
	NAME varchar(50) NOT NULL
);

CREATE TABLE SUBFACULTY (
	SUBFACULTY_ID int auto_increment primary key NOT NULL,
	FACULTY_ID int NULL,
	NAME varchar(75) NOT NULL,
	SUBFACULTY_NUMBER varchar(10) NOT NULL
);

CREATE TABLE TEACHER (
	TEACHER_ID int auto_increment primary key NOT NULL,
	PERSONAL_ID int NOT NULL,
	SUBFACULTY_ID int NOT NULL
);

CREATE TABLE USER_ROLE (
	USER_ROLE_ID int auto_increment primary key NOT NULL,
	NAME varchar(25) NULL
);

CREATE TABLE USERS (
	USER_ID int auto_increment primary key NOT NULL,
	PERSONAL_ID int NULL,
	USER_ROLE_ID int NOT NULL,
	LOGIN varchar(15) NULL,
	PPASSWORD varchar(15) NULL
);


INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (1, 1, 'пр. Мира, 43');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (2, 2, 'пр.Пьехи , 17');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (3, 3, 'ул. Ленина, 25б');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (4, 4, 'пр. Держинского 32');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (5, 6, 'пер. Велосипедный, 6');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (6, 1, 'ул. Тверская, 25/38');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (7, 1, 'ул. Тверская, 123/4');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (8, 1, 'пр. Краснопресненский, 12/5');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (9, 1, 'ул. Петровка, 54/12');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (10, 1, 'Ленинградское шоссе, 60');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (11, 1, 'ул. Восточная, 47');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (12, 1, 'пр. Королева, 98');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (13, 1, 'ул. Гагарина, 80');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (14, NULL, 'ул. Киевская, 34/65');
INSERT INTO ADDRESS (ADDRESS_ID, SETTLEMENT_ID, ADDRESS) VALUES (15, 1, 'ул. Есенина, 76/53');
COMMIT;

INSERT INTO AREA (AREA_ID, REGION_ID, NAME) VALUES (1, 1, 'Краснопресненский ');
INSERT INTO AREA (AREA_ID, REGION_ID, NAME) VALUES (2, 4, 'имени Эдиты Пьехи ');
INSERT INTO AREA (AREA_ID, REGION_ID, NAME) VALUES (3, 2, 'Мирный');
INSERT INTO AREA (AREA_ID, REGION_ID, NAME) VALUES (4, 5, 'Слободский');
INSERT INTO AREA (AREA_ID, REGION_ID, NAME) VALUES (5, 6, 'Заднепровский');
INSERT INTO AREA (AREA_ID, REGION_ID, NAME) VALUES (6, 9, 'Смолевичский');
COMMIT;

INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (1, 1, 'Математика');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (2, 1, 'Физика');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (3, 1, 'ПЭВМ');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (4, 1, 'ОАиП');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (5, 1, 'АЛОВТ');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (6, 1, 'Теоретические основы геодезии');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (7, 1, 'Информатика');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (8, 1, 'Введение в специальность');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (9, 1, 'Начертательная геометрия');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (10, 1, 'Физкультура');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (11, 1, 'Инженерная графика');
INSERT INTO BASE_DISCIPLINE (BASE_DISCIPLINE_ID, SUBFACULTY_ID, NAME) VALUES (12, 1, 'Химия');
COMMIT;

INSERT INTO BENEFITS (BENEFIT_ID, NAME) VALUES (1, 'Сирота');
INSERT INTO BENEFITS (BENEFIT_ID, NAME) VALUES (2, 'Чернобылец');
INSERT INTO BENEFITS (BENEFIT_ID, NAME) VALUES (3, 'Беженец');
INSERT INTO BENEFITS (BENEFIT_ID, NAME) VALUES (4, 'Инвалид');
INSERT INTO BENEFITS (BENEFIT_ID, NAME) VALUES (5, 'Родители - пенсионеры');
INSERT INTO BENEFITS (BENEFIT_ID, NAME) VALUES (6, 'Нет');
COMMIT;

INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (1, 1, 1, 2005);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (2, 1, 1, 2004);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (3, 2, 0, 2003);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (4, 2, 1, 2004);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (5, 4, 1, 2006);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (6, 3, 0, 2003);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (7, 5, 0, 2005);
INSERT INTO CARD (CARD_ID, COURSE, SEMESTER, YYEAR) VALUES (8, 6, 1, 2006);
COMMIT;

INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (1, 'Россия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (2, 'Латвия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (3, 'Украина');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (4, 'Польша');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (5, 'Канада');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (6, 'Китай');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (7, 'Чили');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (8, 'Словакия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (9, 'Беларусь');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (10, 'Эстония');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (11, 'Ливия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (12, 'Казахстан');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (14, 'Литва');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (15, 'Япония');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (16, 'Египет');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (17, 'Индия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (18, 'Чехия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (19, 'Мальта');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (20, 'Кипр');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (21, 'Германия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (22, 'Голландия');
INSERT INTO COUNTRY (COUNTRY_ID, NAME) VALUES (23, 'Дания');
COMMIT;

INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (1, 'ЭВМ');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (2, 'АиТЧ');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (3, 'ЖОЗ');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (4, 'ФИТР');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (5, 'ПОИТ');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (6, 'РГЯ');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (7, 'СЛО');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (8, 'ММ');
INSERT INTO DEPARTAMENT (DEPARTMANENT_ID, NAME) VALUES (9, 'БУАиА');
COMMIT;

INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (1, 1, 1, 48, 1, 2, 1, 1, 2005, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (2, 1, 2, 64, 11, 2, 1, 1, 2005, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (3, 1, 3, 80, 1, 2, 1, 1, 2005, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (4, 1, 4, 12, 1, 2, 0, 1, 2005, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (5, 1, 7, 64, 1, 2, 1, 1, 2005, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (6, 1, 10, 72, 1, 2, 1, 3, 2005, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (7, 1, 9, 38, 1, 2, 1, 4, 2005, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (8, 1, 11, 60, 1, 2, 1, 2, 2005, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (9, 1, 8, 36, 1, 2, 0, 1, 2005, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (10, 3, 8, 44, 1, 2, 0, 1, 2006, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (11, 3, 6, 26, 1, 2, 1, 1, 2006, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (12, 3, 7, 30, 1, 2, 0, 1, 2006, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (13, 3, 12, 48, 1, 2, 0, 1, 2006, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (14, 3, 9, 62, 1, 2, 0, 1, 2006, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (15, 3, 10, 34, 1, 2, 0, 1, 2006, 0);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (16, 3, 5, 60, 1, 2, 1, 2, 2006, 1);
INSERT INTO DISCIPLINE (DISCIPLINE_ID, EDUCATION_PLAN_ID, BASE_DISCIPLINE_ID, HOURS, Independent_Hours, Audience_Hours, SEMESTER, COURSE, YYEAR, CHECKING_FORM) VALUES (17, 3, 11, 12, 1, 2, 1, 4, 2006, 1);
COMMIT;

INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (1, 1, 1);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (2, 4, 2);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (3, 10, 3);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (4, 7, 6);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (5, 11, 9);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (6, 5, 5);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (7, 6, 4);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (8, 3, 8);
INSERT INTO DISCIPLINE_TEACHER (DISCIPLINE_TEACHER_ID, TEACHER_ID, DISCIPLINE_ID) VALUES (9, 9, 7);
COMMIT;

INSERT INTO EDUCATION_PLAN (EDUCATION_PLAN_ID, SPECIALITY_ID, DATA_START, DATA_END) VALUES (1, 1, CAST('2004-01-01T00:00:00.000' AS TIMESTAMP), CAST('2007-01-01T00:00:00.000' AS TIMESTAMP));
INSERT INTO EDUCATION_PLAN (EDUCATION_PLAN_ID, SPECIALITY_ID, DATA_START, DATA_END) VALUES (3, 2, CAST('2006-08-01T00:00:00.000' AS TIMESTAMP), CAST('2006-08-31T00:00:00.000' AS TIMESTAMP));
COMMIT;

INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (1, '001', 0, CAST('2006-01-01T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (2, '2', 0, CAST('2006-02-01T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (3, '3', 1, CAST('2006-02-01T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (4, '105502', 0, CAST('2006-08-06T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (5, '105503', 1, CAST('2006-08-06T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (6, '105504', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (7, '105507', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (9, '105510', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (10, '15', 1, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (11, '105512', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (12, '105513', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (13, '105516', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (14, '105516', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (15, '105517', 1, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (16, '105520', 0, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (17, '105525', 1, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (18, '105520', 2, CAST('2006-08-07T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (19, '105507', 1, CAST('2006-08-08T00:00:00.000' AS TIMESTAMP));
INSERT INTO EXAM_LIST (EXAM_LIST_ID, NUMBER, TYPE, DATE_CREATION) VALUES (20, '12345678', 2, CAST('2006-08-08T00:00:00.000' AS TIMESTAMP));
COMMIT;

INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (1, 1, 4, 1, 1, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (4, 1, 4, 1, 2, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (7, 1, 4, 1, 3, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (12, 2, 4, 2, 1, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (13, 2, 4, 2, 2, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (14, 2, 4, 2, 3, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (15, 3, 4, 3, 1, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (16, 3, 4, 3, 2, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (17, 4, 4, 8, 1, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (18, 4, 4, 8, 2, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (19, 4, 4, 8, 3, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (20, 5, 4, 8, 1, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (21, 5, 4, 8, 2, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (22, 5, 4, 8, 3, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (23, 6, 4, 4, 9, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (24, 6, 4, 4, 13, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (25, 6, 4, 4, 16, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (26, 6, 4, 4, 18, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (27, 6, 4, 4, 19, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (28, 6, 4, 4, 20, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (29, 6, 4, 4, 21, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (30, 6, 4, 4, 26, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (31, 6, 4, 4, 27, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (32, 6, 4, 4, 28, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (33, 6, 4, 4, 29, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (34, 6, 4, 4, 30, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (35, 6, 4, 4, 1, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (36, 6, 4, 4, 2, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (37, 6, 4, 4, 3, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (38, 6, 4, 4, 7, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (39, 7, 4, 5, 9, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (40, 7, 4, 5, 13, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (41, 7, 4, 5, 16, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (42, 7, 4, 5, 18, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (43, 7, 4, 5, 19, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (44, 7, 4, 5, 20, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (45, 7, 4, 5, 21, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (46, 7, 4, 5, 26, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (47, 7, 4, 5, 27, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (48, 7, 4, 5, 28, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (49, 7, 4, 5, 29, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (50, 7, 4, 5, 30, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (51, 7, 4, 5, 1, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (52, 7, 4, 5, 2, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (53, 7, 4, 5, 3, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (54, 7, 4, 5, 7, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (71, 9, 4, 6, 9, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (72, 9, 4, 6, 13, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (73, 9, 4, 6, 16, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (74, 9, 4, 6, 18, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (75, 9, 4, 6, 19, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (76, 9, 4, 6, 20, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (77, 9, 4, 6, 21, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (78, 9, 4, 6, 26, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (79, 9, 4, 6, 27, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (80, 9, 4, 6, 28, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (81, 9, 4, 6, 29, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (82, 9, 4, 6, 30, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (83, 9, 4, 6, 1, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (84, 9, 4, 6, 2, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (85, 9, 4, 6, 3, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (86, 9, 4, 6, 7, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (87, 10, 4, 2, 9, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (88, 10, 4, 2, 13, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (89, 10, 4, 2, 16, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (90, 10, 4, 2, 18, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (91, 10, 4, 2, 19, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (92, 10, 4, 2, 20, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (93, 10, 4, 2, 21, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (94, 10, 4, 2, 26, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (95, 10, 4, 2, 27, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (96, 10, 4, 2, 28, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (97, 10, 4, 2, 29, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (98, 10, 4, 2, 30, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (99, 10, 4, 2, 1, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (100, 10, 4, 2, 2, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (101, 10, 4, 2, 3, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (102, 10, 4, 2, 7, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (103, 11, 5, 10, 8, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (104, 11, 5, 10, 10, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (105, 11, 5, 10, 11, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (106, 11, 5, 10, 12, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (107, 11, 5, 10, 14, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (108, 11, 5, 10, 15, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (109, 11, 5, 10, 17, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (110, 11, 5, 10, 22, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (111, 11, 5, 10, 23, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (112, 11, 5, 10, 24, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (113, 11, 5, 10, 25, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (114, 11, 5, 10, 31, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (115, 11, 5, 10, 32, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (116, 11, 5, 10, 33, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (117, 11, 5, 10, 34, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (118, 11, 5, 10, 5, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (119, 11, 5, 10, 6, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (120, 12, 5, 13, 8, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (121, 12, 5, 13, 10, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (122, 12, 5, 13, 11, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (123, 12, 5, 13, 12, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (124, 12, 5, 13, 14, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (125, 12, 5, 13, 15, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (126, 12, 5, 13, 17, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (127, 12, 5, 13, 22, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (128, 12, 5, 13, 23, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (129, 12, 5, 13, 24, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (130, 12, 5, 13, 25, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (131, 12, 5, 13, 31, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (132, 12, 5, 13, 32, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (133, 12, 5, 13, 33, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (134, 12, 5, 13, 34, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (135, 12, 5, 13, 5, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (136, 12, 5, 13, 6, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (137, 13, 5, 12, 8, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (138, 13, 5, 12, 10, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (139, 13, 5, 12, 11, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (140, 13, 5, 12, 12, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (141, 13, 5, 12, 14, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (142, 13, 5, 12, 15, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (143, 13, 5, 12, 17, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (144, 13, 5, 12, 22, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (145, 13, 5, 12, 23, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (146, 13, 5, 12, 24, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (147, 13, 5, 12, 25, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (148, 13, 5, 12, 31, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (149, 13, 5, 12, 32, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (150, 13, 5, 12, 33, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (151, 13, 5, 12, 34, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (152, 13, 5, 12, 5, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (153, 13, 5, 12, 6, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (154, 14, 5, 11, 8, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (155, 14, 5, 11, 10, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (156, 14, 5, 11, 11, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (157, 14, 5, 11, 12, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (158, 14, 5, 11, 14, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (159, 14, 5, 11, 15, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (160, 14, 5, 11, 17, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (161, 14, 5, 11, 22, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (162, 14, 5, 11, 23, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (163, 14, 5, 11, 24, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (164, 14, 5, 11, 25, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (165, 14, 5, 11, 31, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (166, 14, 5, 11, 32, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (167, 14, 5, 11, 33, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (168, 14, 5, 11, 34, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (169, 14, 5, 11, 5, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (170, 14, 5, 11, 6, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (171, 15, 5, 11, 8, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (172, 15, 5, 11, 10, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (173, 15, 5, 11, 11, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (174, 15, 5, 11, 12, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (175, 15, 5, 11, 14, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (176, 15, 5, 11, 15, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (177, 15, 5, 11, 17, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (178, 15, 5, 11, 22, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (179, 15, 5, 11, 23, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (180, 15, 5, 11, 24, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (181, 15, 5, 11, 25, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (182, 15, 5, 11, 31, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (183, 15, 5, 11, 32, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (184, 15, 5, 11, 33, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (185, 15, 5, 11, 34, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (186, 15, 5, 11, 5, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (187, 15, 5, 11, 6, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (188, 16, 5, 14, 8, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (189, 16, 5, 14, 10, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (190, 16, 5, 14, 11, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (191, 16, 5, 14, 12, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (192, 16, 5, 14, 14, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (193, 16, 5, 14, 15, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (194, 16, 5, 14, 17, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (195, 16, 5, 14, 22, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (196, 16, 5, 14, 23, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (197, 16, 5, 14, 24, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (198, 16, 5, 14, 25, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (199, 16, 5, 14, 31, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (200, 16, 5, 14, 32, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (201, 16, 5, 14, 33, 2);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (202, 16, 5, 14, 34, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (203, 16, 5, 14, 5, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (204, 16, 5, 14, 6, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (205, 17, 5, 15, 8, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (206, 17, 5, 15, 10, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (207, 17, 5, 15, 11, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (208, 17, 5, 15, 12, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (209, 17, 5, 15, 14, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (210, 17, 5, 15, 15, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (211, 17, 5, 15, 17, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (212, 17, 5, 15, 22, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (213, 17, 5, 15, 23, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (214, 17, 5, 15, 24, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (215, 17, 5, 15, 25, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (216, 17, 5, 15, 31, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (217, 17, 5, 15, 32, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (218, 17, 5, 15, 33, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (219, 17, 5, 15, 34, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (220, 17, 5, 15, 5, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (221, 17, 5, 15, 6, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (222, 18, 4, 5, 3, 3);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (223, 18, 5, 5, 8, 4);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (224, 18, 5, 5, 10, 5);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (225, 19, 4, 8, 9, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (226, 20, 4, 17, 1, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (227, 20, 4, 17, 2, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (228, 20, 4, 17, 3, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (229, 20, 4, 17, 21, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (230, 20, 5, 17, 22, 0);
INSERT INTO EXAM_MARK (EXAM_MARK_ID, EXAM_LIST_ID, STUDENT_GROUP_ID, DISCIPLINE_ID, STUDENT_ID, VVALUE) VALUES (231, 20, 5, 17, 23, 0);
COMMIT;

INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (1, 'Строительный', 'СФ', 1);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (2, 'Архитектурный', 'АФ', 2);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (3, 'Физический', 'ФФ', NULL);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (4, 'Механико-математический', 'ММФ', 4);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (5, 'Географический', 'ГФ', NULL);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (6, 'Моторо-строительный', 'МСФ', 9);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (7, 'Автотракторный', 'АТФ', 7);
INSERT INTO FACULTY (FACULTY_ID, NAME, SHORT_NAME, FACULTY_CODE) VALUES (8, 'Компьютерные системы и сети', 'КСИС', 8);
COMMIT;

INSERT INTO FACULTY_GROUP_CODE (FACULTY_GROUP_CODE_ID, FACULTY_ID, COMMENT) VALUES (1, 1, 'Корпус №15, 8 этаж');
INSERT INTO FACULTY_GROUP_CODE (FACULTY_GROUP_CODE_ID, FACULTY_ID, COMMENT) VALUES (2, 2, 'Корпус №4');
INSERT INTO FACULTY_GROUP_CODE (FACULTY_GROUP_CODE_ID, FACULTY_ID, COMMENT) VALUES (3, 4, 'Главный корпус');
INSERT INTO FACULTY_GROUP_CODE (FACULTY_GROUP_CODE_ID, FACULTY_ID, COMMENT) VALUES (4, 5, NULL);
INSERT INTO FACULTY_GROUP_CODE (FACULTY_GROUP_CODE_ID, FACULTY_ID, COMMENT) VALUES (5, 7, 'корпус закрыт на ремонт');
INSERT INTO FACULTY_GROUP_CODE (FACULTY_GROUP_CODE_ID, FACULTY_ID, COMMENT) VALUES (6, 3, 'ул.Курчатова, 15а');
COMMIT;

INSERT INTO HOSPICE (HOSPICE_ID, NAME, STREET, HOUSE, BUILDING) VALUES (1, 'Центральное общежитие', 'ул.Проспект Мира', 4, 2);
INSERT INTO HOSPICE (HOSPICE_ID, NAME, STREET, HOUSE, BUILDING) VALUES (2, 'Общежитие №1', 'ул.Муравьева', 30, NULL);
INSERT INTO HOSPICE (HOSPICE_ID, NAME, STREET, HOUSE, BUILDING) VALUES (3, 'Общежитие №3', 'ул.Октябрьская', 23, NULL);
INSERT INTO HOSPICE (HOSPICE_ID, NAME, STREET, HOUSE, BUILDING) VALUES (4, 'Общежитие №9', 'пр. Независимости', 44, 6);
INSERT INTO HOSPICE (HOSPICE_ID, NAME, STREET, HOUSE, BUILDING) VALUES (5, 'Общежитие №4', 'пр.Пушкина', 51, 4);
INSERT INTO HOSPICE (HOSPICE_ID, NAME, STREET, HOUSE, BUILDING) VALUES (6, 'Общежитие №6', 'пер. Михайловский', 17, 5);
COMMIT;

INSERT INTO LANGUAGES (LANGUAGE_ID, NAME) VALUES (1, 'Английский');
INSERT INTO LANGUAGES (LANGUAGE_ID, NAME) VALUES (2, 'Французский');
INSERT INTO LANGUAGES (LANGUAGE_ID, NAME) VALUES (7, 'Немецкий');
COMMIT;

INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (9, 1, 1, 1, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (2, 2, 10, 1, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (3, 3, 3, 1, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (4, 1, 1, 2, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (5, 2, 10, 2, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (6, 3, 3, 2, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (7, 1, 1, 3, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (8, 2, 10, 3, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (10, 8, 4, 1, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (11, 8, 4, 2, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (12, 8, 4, 3, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (13, 4, 6, 9, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (14, 4, 6, 13, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (45, 6, 9, 9, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (46, 6, 9, 13, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (47, 6, 9, 16, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (48, 6, 9, 18, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (49, 6, 9, 19, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (50, 6, 9, 20, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (51, 6, 9, 21, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (52, 6, 9, 26, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (53, 6, 9, 27, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (54, 6, 9, 28, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (55, 6, 9, 29, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (56, 6, 9, 30, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (57, 6, 9, 1, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (58, 6, 9, 2, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (59, 6, 9, 3, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (60, 6, 9, 7, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (61, 2, 10, 9, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (62, 2, 10, 13, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (63, 2, 10, 16, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (64, 2, 10, 18, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (65, 2, 10, 19, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (66, 2, 10, 20, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (67, 2, 10, 21, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (68, 2, 10, 26, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (69, 2, 10, 27, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (70, 2, 10, 28, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (71, 2, 10, 29, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (72, 2, 10, 30, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (73, 2, 10, 7, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (74, 10, 11, 8, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (75, 10, 11, 10, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (76, 10, 11, 11, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (77, 10, 11, 12, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (78, 10, 11, 14, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (79, 10, 11, 15, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (80, 10, 11, 17, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (81, 10, 11, 22, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (82, 10, 11, 23, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (83, 10, 11, 24, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (84, 10, 11, 25, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (85, 10, 11, 31, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (86, 10, 11, 32, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (87, 10, 11, 33, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (88, 10, 11, 34, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (89, 10, 11, 5, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (90, 10, 11, 6, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (91, 13, 12, 8, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (92, 13, 12, 10, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (93, 13, 12, 11, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (94, 13, 12, 12, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (95, 13, 12, 14, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (96, 13, 12, 15, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (97, 13, 12, 17, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (98, 13, 12, 22, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (99, 13, 12, 23, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (100, 13, 12, 24, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (101, 13, 12, 25, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (102, 13, 12, 31, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (103, 13, 12, 32, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (104, 13, 12, 33, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (105, 13, 12, 34, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (106, 13, 12, 5, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (107, 13, 12, 6, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (108, 12, 13, 8, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (109, 12, 13, 10, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (110, 12, 13, 11, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (111, 12, 13, 12, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (112, 12, 13, 14, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (113, 12, 13, 15, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (114, 12, 13, 17, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (115, 12, 13, 22, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (116, 12, 13, 23, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (117, 12, 13, 24, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (118, 12, 13, 25, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (119, 12, 13, 31, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (120, 12, 13, 32, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (121, 12, 13, 33, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (122, 12, 13, 34, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (123, 12, 13, 5, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (124, 12, 13, 6, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (125, 11, 15, 8, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (126, 11, 15, 10, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (127, 11, 15, 11, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (128, 11, 15, 12, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (129, 11, 15, 14, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (130, 11, 15, 15, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (131, 11, 15, 17, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (132, 11, 15, 22, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (133, 11, 15, 23, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (134, 11, 15, 24, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (135, 11, 15, 25, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (136, 11, 15, 31, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (137, 11, 15, 32, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (138, 11, 15, 33, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (139, 11, 15, 34, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (140, 11, 15, 5, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (141, 11, 15, 6, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (142, 14, 16, 8, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (143, 14, 16, 10, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (144, 14, 16, 11, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (145, 14, 16, 12, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (146, 14, 16, 14, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (147, 14, 16, 15, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (148, 14, 16, 17, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (149, 14, 16, 22, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (150, 14, 16, 23, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (151, 14, 16, 24, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (152, 14, 16, 25, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (153, 14, 16, 31, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (154, 14, 16, 32, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (155, 14, 16, 33, 5, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (156, 14, 16, 34, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (157, 14, 16, 5, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (158, 14, 16, 6, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (159, 15, 17, 8, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (160, 15, 17, 10, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (161, 15, 17, 11, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (162, 15, 17, 12, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (163, 15, 17, 14, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (164, 15, 17, 15, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (165, 15, 17, 17, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (166, 15, 17, 22, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (167, 15, 17, 23, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (168, 15, 17, 24, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (169, 15, 17, 25, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (170, 15, 17, 31, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (171, 15, 17, 32, 5, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (172, 15, 17, 33, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (173, 15, 17, 34, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (174, 15, 17, 5, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (175, 15, 17, 6, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (176, 5, 18, 8, 5, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (177, 5, 18, 10, 5, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (178, 8, 19, 9, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (179, 17, 20, 1, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (181, 17, 20, 3, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (182, 17, 20, 21, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (183, 17, 20, 22, 5, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (184, 17, 20, 23, 5, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (15, 4, 6, 16, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (16, 4, 6, 18, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (17, 4, 6, 19, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (18, 4, 6, 20, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (19, 4, 6, 21, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (20, 4, 6, 26, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (21, 4, 6, 27, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (22, 4, 6, 28, 4, 0);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (23, 4, 6, 29, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (24, 4, 6, 30, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (25, 4, 6, 1, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (26, 4, 6, 2, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (27, 4, 6, 3, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (28, 4, 6, 7, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (29, 5, 7, 9, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (30, 5, 7, 13, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (31, 5, 7, 16, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (32, 5, 7, 18, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (33, 5, 7, 19, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (34, 5, 7, 20, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (35, 5, 7, 21, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (36, 5, 7, 26, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (37, 5, 7, 27, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (38, 5, 7, 28, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (39, 5, 7, 29, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (40, 5, 7, 30, 4, 4);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (41, 5, 7, 1, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (42, 5, 7, 2, 4, 2);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (43, 5, 18, 3, 4, 3);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (44, 5, 7, 7, 4, 5);
INSERT INTO MARK (MARK_ID, DISCIPLINE_ID, EXAM_LIST_ID, STUDENT_ID, STUDENT_GROUP_ID, VVALUE) VALUES (180, 17, 20, 2, 4, 0);
COMMIT;

INSERT INTO NOTE (NOTE_ID, STUDENT_ID, CARD_ID, STUDENT_GROUP_ID, FREE_ATTENDANCE, REBUKE, LAST_EXAM_DATE, SESSION_PROLONGATION_DATE, SESSION_CLOSING_DATE, STUDENTGRANT, PRACTICE) VALUES (2, 1, 1, 4, 1, 'Да', NULL, NULL, NULL, NULL, NULL);
INSERT INTO NOTE (NOTE_ID, STUDENT_ID, CARD_ID, STUDENT_GROUP_ID, FREE_ATTENDANCE, REBUKE, LAST_EXAM_DATE, SESSION_PROLONGATION_DATE, SESSION_CLOSING_DATE, STUDENTGRANT, PRACTICE) VALUES (3, 2, 1, 4, 0, 'Нет', NULL, NULL, CAST('2006-06-06T00:00:00.000' AS TIMESTAMP), '3000', NULL);
INSERT INTO NOTE (NOTE_ID, STUDENT_ID, CARD_ID, STUDENT_GROUP_ID, FREE_ATTENDANCE, REBUKE, LAST_EXAM_DATE, SESSION_PROLONGATION_DATE, SESSION_CLOSING_DATE, STUDENTGRANT, PRACTICE) VALUES (4, 3, 1, 4, 1, 'Нет', NULL, NULL, NULL, NULL, NULL);
COMMIT;

INSERT INTO OFFICE_ORDER (OFFICE_ORDER_ID, ORDER_CATEGORY_ID, PATH_TO_FILE, EXTERNAL_NUMBER, REASON, SUBJECT, DATE_ORDER, ISSIGNED, SIGNER_POSITION, SIGNER_NAME, MAKER_POSITION, MAKER_NAME, COORDINATOR1_POSITION, COORDINATOR1_NAME, COORDINATOR2_POSITION, COORDINATOR2_NAME, COORDINATOR3_POSITION, COORDINATOR3_NAME, COORDINATOR4_POSITION, COORDINATOR4_NAME, COORDINATOR5_POSITION, COORDINATOR5_NAME, COORDINATOR6_POSITION, COORDINATOR6_NAME) VALUES (1, 2, NULL, '06-123', NULL, NULL, CAST('2006-03-17T00:00:00.000' AS TIMESTAMP), 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO OFFICE_ORDER (OFFICE_ORDER_ID, ORDER_CATEGORY_ID, PATH_TO_FILE, EXTERNAL_NUMBER, REASON, SUBJECT, DATE_ORDER, ISSIGNED, SIGNER_POSITION, SIGNER_NAME, MAKER_POSITION, MAKER_NAME, COORDINATOR1_POSITION, COORDINATOR1_NAME, COORDINATOR2_POSITION, COORDINATOR2_NAME, COORDINATOR3_POSITION, COORDINATOR3_NAME, COORDINATOR4_POSITION, COORDINATOR4_NAME, COORDINATOR5_POSITION, COORDINATOR5_NAME, COORDINATOR6_POSITION, COORDINATOR6_NAME) VALUES (2, 3, NULL, '06-128', NULL, NULL, CAST('2006-04-10T00:00:00.000' AS TIMESTAMP), 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO OFFICE_ORDER (OFFICE_ORDER_ID, ORDER_CATEGORY_ID, PATH_TO_FILE, EXTERNAL_NUMBER, REASON, SUBJECT, DATE_ORDER, ISSIGNED, SIGNER_POSITION, SIGNER_NAME, MAKER_POSITION, MAKER_NAME, COORDINATOR1_POSITION, COORDINATOR1_NAME, COORDINATOR2_POSITION, COORDINATOR2_NAME, COORDINATOR3_POSITION, COORDINATOR3_NAME, COORDINATOR4_POSITION, COORDINATOR4_NAME, COORDINATOR5_POSITION, COORDINATOR5_NAME, COORDINATOR6_POSITION, COORDINATOR6_NAME) VALUES (3, 1, NULL, '06-143', NULL, NULL, CAST('2006-06-08T00:00:00.000' AS TIMESTAMP), 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (1, 'Участие в конференции');
INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (2, 'Поощрение за отличную учебу');
INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (3, 'Перевод на другой курс');
INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (4, 'Отчисление');
INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (5, 'Выговор');
INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (6, 'Зачисление на военную кафедру');
INSERT INTO ORDER_CATEGORY (ORDER_CATEGORY_ID, ORDER_CATEGORY) VALUES (7, 'Перевод на заочную форму обучения');
COMMIT;

INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (1, 1, 1, 'Николай', 'Владимирович', 'Николаев');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (2, 5, 2, 'Иван', 'Валерьевич', 'Поступайло');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (3, 2, 4, 'Денис', 'Николаевич', 'Евтухович');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (4, 2, 5, 'Олег', 'Исидорович', 'Мельников');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (5, 4, 9, 'Леонид', 'Платонович', 'Примачук');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (6, 8, 3, 'Петр', 'Петрович', 'Староселец');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (7, 6, 8, 'Валерий', 'Владимирович', 'Курсов');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (8, 4, 6, 'Антон', 'Эдуардович', 'Григорьев');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (9, 7, 1, 'Римма', 'Витальевна', 'Поддубная');
INSERT INTO PERSONAL (PERSONAL_ID, POSITION_ID, DEPARTMANENT_ID, NAME, PATRONYMIC, FAMILY_NAME) VALUES (10, 5, 7, 'Екатерина', 'Владимировна', 'Никитенко');
COMMIT;

INSERT INTO POSITION (POSITION_ID, NAME) VALUES (1, 'Доцент');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (2, 'Профессор');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (3, 'Секретарь');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (4, 'Старший преподаватель');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (5, 'Лаборант');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (6, 'Декан');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (7, 'Ректор');
INSERT INTO POSITION (POSITION_ID, NAME) VALUES (8, 'Куратор');
COMMIT;

INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (1, 1, 'Москва');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (2, 1, 'Калужская обл.');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (4, 2, 'Riga regio');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (5, 1, 'Пермская обл.');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (6, 1, 'Смоленская обл.');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (7, 1, 'Вологодская обл.');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (8, 1, 'Саратовская обл.');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (9, 9, 'Минская обл.');
INSERT INTO REGION (REGION_ID, COUNTRY_ID, NAME) VALUES (10, 3, 'Киевская обл.');
COMMIT;

INSERT INTO SETTLEMENT (SETTLEMENT_ID, SETTLEMENT_DEFINITION_ID, AREA_ID, NAME) VALUES (1, 1, 1, 'Москва');
INSERT INTO SETTLEMENT (SETTLEMENT_ID, SETTLEMENT_DEFINITION_ID, AREA_ID, NAME) VALUES (2, 1, 2, 'Вильнюс');
INSERT INTO SETTLEMENT (SETTLEMENT_ID, SETTLEMENT_DEFINITION_ID, AREA_ID, NAME) VALUES (3, 1, 3, 'Калуга');
INSERT INTO SETTLEMENT (SETTLEMENT_ID, SETTLEMENT_DEFINITION_ID, AREA_ID, NAME) VALUES (4, 3, 6, 'Загорье');
INSERT INTO SETTLEMENT (SETTLEMENT_ID, SETTLEMENT_DEFINITION_ID, AREA_ID, NAME) VALUES (5, 1, 4, 'Тверь');
INSERT INTO SETTLEMENT (SETTLEMENT_ID, SETTLEMENT_DEFINITION_ID, AREA_ID, NAME) VALUES (6, 1, 5, 'Рыльск');
COMMIT;

INSERT INTO SETTLEMENT_DEFINITION (SETTLEMENT_DEFINITION_ID, NAME) VALUES (1, 'Город');
INSERT INTO SETTLEMENT_DEFINITION (SETTLEMENT_DEFINITION_ID, NAME) VALUES (2, 'Поселок');
INSERT INTO SETTLEMENT_DEFINITION (SETTLEMENT_DEFINITION_ID, NAME) VALUES (3, 'Деревня');
COMMIT;

INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (1, 1, '750', 'Металлонесущие конструкции', 'МНК');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (2, 1, '761', 'Экономическая деятельность', 'ЭД');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (3, 2, '654', 'Веб-дизайн', 'ВД');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (4, 2, '564', 'Архитектурная живопись', 'АЖ');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (5, 3, '899', 'Ядерная физика', 'ЯФ');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (6, 4, '235', 'Компьютерная математика', 'КМ');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (7, 4, '878', 'Механика', 'МЕХ');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (8, 5, '554', 'Туристическое дело', 'ТД');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (9, 7, '478', 'Автомеханика', 'АМ');
INSERT INTO SPECIALITY (SPECIALITY_ID, FACULTY_ID, NUMBER, NAME, SHORTNAME) VALUES (10, 5, '752', 'Картография', 'КГ');
COMMIT;

INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (1, 4, 2, 1, 1, 1, 1, 1, 'Иван', 'Иванович', 'Иванов', '504-1', 'ул. Проспект Мира, 15', 'Do not use me !!!', 'VY-1', NULL, NULL, 0, 0, 1, NULL, NULL, 'СПб колледж №45', CAST('2005-01-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (2, 4, 1, 1, 1, 2, 1, 1, 'Ирина', 'Петровна', 'Петрова', '504-2', 'ул. Проспект Мира, 15', 'Do not use me !!!', 'VY-1', NULL, NULL, 0, 1, 0, 1, NULL, 'СПб колледж №3', CAST('2006-01-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (3, 4, 2, NULL, 1, 3, 2, 2, 'Сидор', 'Сидорович', 'Сидоров', '504-3', 'ул. Новослободская , 20', 'Do not use me !!!', 'VY-1', NULL, NULL, 0, 0, 1, NULL, NULL, 'Moscow University', CAST('2004-01-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (4, NULL, 1, NULL, 1, 1, 3, 2, 'Федор', 'Федорович', 'Федоров', '501-3', 'ул. Проспект Мира, 15', 'Do not use me !!!', 'VY-1', NULL, NULL, 0, 0, 0, NULL, NULL, 'МГУ', CAST('2005-01-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (5, 5, 1, 2, 1, 3, 9, 1, 'Илья', 'Владимирович', 'Козлов', '422001', NULL, 'Do not use me !!!', 'HP1234567', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (6, 5, 8, 2, 1, 1, 1, 1, 'Владимир', 'Игоревич', 'Воробьев', '422105', NULL, 'Do not use me !!!', 'HP1391611', NULL, NULL, 0, 0, 1, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (7, 4, 9, 2, 1, 4, 1, 1, 'Ольга', 'Валерьевна', 'Федорова', '411441', NULL, 'Do not use me !!!', 'MP1819101', NULL, NULL, 0, 0, 0, 1, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (8, 5, 10, 3, 1, 5, 3, 1, 'Илья', 'Васильевич', 'Прохоренко', '467814', NULL, 'Do not use me !!!', 'MP1490965', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2006-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (9, 4, 11, 6, 3, 3, 12, 1, 'Мария', 'Викторовна', 'Андробайло', '400902', NULL, 'Do not use me !!!', 'MR1345234', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (10, 5, 15, 2, 2, 5, 1, 1, 'Роман', 'Петрович', 'Кузьменко', '547771', NULL, 'Do not use me !!!', 'HP14568234', NULL, NULL, 0, 0, 1, 0, NULL, NULL, CAST('2003-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (11, 5, 10, 3, 1, 5, 14, 1, 'Евгений', 'Николаевич', 'Гормаш', '443216', NULL, 'Do not use me !!!', 'PO2134592', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2002-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (12, 5, 8, 2, 3, 4, 1, 1, 'Светлана', 'Викентьевна', 'Котлярова', '422024', NULL, 'Do not use me !!!', 'TY1423890', NULL, NULL, 0, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (13, 4, 1, 2, 3, 4, 2, 1, 'Елена', 'Антоновна', 'Голод', '446713', NULL, 'Do not use me !!!', 'PM1230987', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (14, 5, 12, 1, 1, 5, 6, 7, 'Линь', 'Дзинь', 'Сяо', '510907', NULL, 'Do not use me !!!', 'PI1357832', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2003-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (15, 5, 12, 1, 1, 2, 9, 2, 'Михаил', 'Михаилович', 'Шубенок', '678023', NULL, 'Do not use me !!!', 'NM1298552', NULL, NULL, 1, 0, 1, 0, NULL, NULL, CAST('2002-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (16, 4, 13, 4, 2, 2, 9, 1, 'Дмитрий', 'Иванович', 'Сьянов', '456190', NULL, 'Do not use me !!!', 'MP1389096', NULL, NULL, 1, 0, 1, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (17, 5, 1, 2, 1, 1, 3, 1, 'Ксения', 'Всеволодовна', 'Колтун', '542020', NULL, 'Do not use me !!!', 'PM2121213', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (18, 4, 11, 6, 3, 2, 9, 7, 'Мария', 'Александровна', 'Борисова', '420900', NULL, 'Do not use me !!!', 'SA3165731', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (19, 4, 7, 2, 3, 4, 1, 1, 'Алеся', 'Максимовна', 'Лавреньтева', '313131', NULL, 'Do not use me !!!', 'HG6570931', NULL, NULL, 0, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (20, 4, 11, 5, 1, 1, 1, 1, 'Василий', 'Романович', 'Яговдик', '536978', NULL, 'Do not use me !!!', 'GT4452404', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (21, 4, 5, 2, 1, 5, 1, 7, 'Марина', 'Константиновна', 'Лобудева', '347312', NULL, 'Do not use me !!!', 'KN8532001', NULL, NULL, 0, 0, 1, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (22, 5, 13, 4, 1, 3, 12, 2, 'Руслан', 'Леонидович', 'Гаджиев', '734656', NULL, 'Do not use me !!!', 'HP1239039', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (23, 5, 12, 3, 3, 5, 1, 2, 'Валерий', 'Геннадьевич', 'Пигулевский', '575747', NULL, 'Do not use me !!!', 'GH5643303', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (24, 5, 10, 2, 2, 5, 1, 2, 'Дарья', 'Сергеевна', 'Стреминская', '597845', NULL, 'Do not use me !!!', 'UI4535902', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2004-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (25, 5, 13, 6, 1, 4, 1, 2, 'Виктор', 'Георгиевич', 'Войнилович', '224876', NULL, 'Do not use me !!!', 'PL3534633', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (26, 4, 12, 1, 1, 3, 6, 7, 'Фэй', 'Инь', 'Шу', '155677', NULL, 'Do not use me !!!', 'RT7662387', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (27, 4, 12, 1, 1, 1, 6, 7, 'Ми', 'Цао', 'Вэй', '364566', NULL, 'Do not use me !!!', 'KL5683362', NULL, NULL, 0, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (28, 4, 13, 5, 1, 5, 1, 1, 'Антон', 'Федорович', 'Атрохов', '565765', NULL, 'Do not use me !!!', 'HP2345630', NULL, NULL, 1, 0, 1, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (29, 4, 11, 6, 1, 3, 1, 1, 'Игорь', 'Всеволодович', 'Маковецкий', '675645', NULL, 'Do not use me !!!', 'BM8403030', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (30, 4, 10, 1, 1, 1, 1, 1, 'Виталий', 'Вячеславович', 'Акулич', '575465', NULL, 'Do not use me !!!', 'HJ8545451', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (31, 5, 12, 3, 1, 3, 1, 1, 'Мария', 'Никифоровна', 'Мархотко', '405641', NULL, 'Do not use me !!!', 'FT3832082', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (32, 5, 13, 4, 1, 3, 1, 1, 'Денис', 'Витальевич', 'Воюш', '102503', NULL, 'Do not use me !!!', 'HP1230108', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (33, 5, 11, 6, 1, 1, 1, 1, 'Максим', 'Евгеньевич', 'Масолбасов', '405400', NULL, 'Do not use me !!!', 'VP7490333', NULL, NULL, 1, 0, 0, 0, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
INSERT INTO STUDENT (STUDENT_ID, STUDENT_GROUP_ID, ADDRESS_ID, HOSPICE_ID, STUDENT_STATUS_ID, BENEFIT_ID, COUNTRY_ID, LANGUAGE_ID, NAME, PATRONYMIC, FAMILY_NAME, STUDENT_NUMBER, REGISTRATION, PASSPORT_DATA, Passport_Number, Passport_Series, Passport_Delivery, HOSPICE_NEEDED, SEX, CONTRACT, COURSE_LEADER, Prof_Leader, LAST_EDUCATION_PLACE, YEAR_STARTING, START_SPECIALITY_ID) VALUES (34, 5, 11, 2, 1, 5, 1, 1, 'Светлана', 'Васильевна', 'Григелис', '420210', NULL, 'Do not use me !!!', 'JT8490023', NULL, NULL, 1, 0, 0, 1, NULL, NULL, CAST('2005-09-01T00:00:00.000' AS TIMESTAMP), NULL);
COMMIT;

INSERT INTO STUDENT_EVENT (EVENT_ID, NAME, COMMENT) VALUES (1, 'Благодарность ', NULL);
INSERT INTO STUDENT_EVENT (EVENT_ID, NAME, COMMENT) VALUES (2, 'Замечание ', NULL);
INSERT INTO STUDENT_EVENT (EVENT_ID, NAME, COMMENT) VALUES (3, 'Непосещение занятий', NULL);
INSERT INTO STUDENT_EVENT (EVENT_ID, NAME, COMMENT) VALUES (4, 'Пререкания с преподавателем', NULL);
INSERT INTO STUDENT_EVENT (EVENT_ID, NAME, COMMENT) VALUES (5, 'Курение на семинаре', NULL);
INSERT INTO STUDENT_EVENT (EVENT_ID, NAME, COMMENT) VALUES (6, 'Неявка на экзамен', NULL);
COMMIT;

INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (1, 6, 3, 1, 1, '750501');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (2, 5, 6, 4, 0, '750502');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (3, NULL, 5, 2, 1, '750503');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (4, 1, 1, 4, 1, '750504');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (5, NULL, 2, 1, 1, '750505');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (6, 10, 7, 3, 0, '750506');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (7, NULL, 8, 1, 0, '750507');
INSERT INTO STUDENT_GROUP (STUDENT_GROUP_ID, PERSONAL_ID, SPECIALITY_ID, COURSE, EDUCATION_DURATION, NUMBER) VALUES (8, 7, 9, 4, 1, '750508');
COMMIT;

INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (1, 1, NULL, NULL, 1, 'помогал  настраивать сеть на кафедре ', CAST('2006-03-15T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (2, 2, NULL, NULL, 1, 'постоянное опаздывает на лекции', CAST('2006-04-19T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (3, 1, NULL, NULL, 2, 'хорошо организовывает работу группы, будучи куратором', CAST('2006-06-01T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (4, 1, NULL, 1, 2, NULL, CAST('2006-04-01T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (5, 1, NULL, 2, 3, NULL, CAST('2006-03-23T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (6, 2, NULL, NULL, NULL, 'впервые', CAST('2006-08-16T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (7, 5, NULL, NULL, NULL, 'впервые', CAST('2006-08-16T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (8, 1, NULL, NULL, NULL, 'за отличную учебу', CAST('2006-08-30T00:00:00.000' AS TIMESTAMP));
INSERT INTO STUDENT_HISTORY (STUDENT_HISTORY_ID, EVENT_ID, USER_ID, OFFICE_ORDER_ID, STUDENT_ID, COMMENT, DATE_EVENT) VALUES (9, 5, NULL, NULL, 7, NULL, CAST('2006-08-02T00:00:00.000' AS TIMESTAMP));
COMMIT;

INSERT INTO STUDENT_STATUS (STUDENT_STATUS_ID, NAME) VALUES (1, 'Учится');
INSERT INTO STUDENT_STATUS (STUDENT_STATUS_ID, NAME) VALUES (2, 'Отчислен');
INSERT INTO STUDENT_STATUS (STUDENT_STATUS_ID, NAME) VALUES (3, 'В академическом отпуске');
COMMIT;

INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (1, 1, 'ЭВМ', '700');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (2, 1, 'МО', '620');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (3, 2, 'ЖОЗ', '560');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (4, 2, 'АП', '550');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (5, 3, 'ФТТ', '405');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (6, 3, 'АЭ', '715');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (7, 4, 'ЧМиП', '645');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (8, 4, 'ДУ', '435');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (9, 4, 'АиТЧ', '255');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (10, 5, 'ТиГ', '395');
INSERT INTO SUBFACULTY (SUBFACULTY_ID, FACULTY_ID, NAME, SUBFACULTY_NUMBER) VALUES (11, 7, 'ПТ', '785');
COMMIT;

INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (1, 1, 1);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (2, 3, 6);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (3, 9, 7);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (4, 6, 8);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (5, 10, 2);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (6, 7, 9);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (7, 2, 10);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (8, 8, 5);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (9, 5, 4);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (10, 4, 7);
INSERT INTO TEACHER (TEACHER_ID, PERSONAL_ID, SUBFACULTY_ID) VALUES (11, 8, 8);
COMMIT;

INSERT INTO USER_ROLE (USER_ROLE_ID, NAME) VALUES (1, 'Администратор');
INSERT INTO USER_ROLE (USER_ROLE_ID, NAME) VALUES (2, 'Сотрудник деканата');
INSERT INTO USER_ROLE (USER_ROLE_ID, NAME) VALUES (3, 'Сотрудник подразд. ВУЗа');
INSERT INTO USER_ROLE (USER_ROLE_ID, NAME) VALUES (4, 'Гость');
COMMIT;

INSERT INTO USERS (USER_ID, PERSONAL_ID, USER_ROLE_ID, LOGIN, PPASSWORD) VALUES (1, 1, 1, 'admin', '123');
INSERT INTO USERS (USER_ID, PERSONAL_ID, USER_ROLE_ID, LOGIN, PPASSWORD) VALUES (2, 4, 2, 'melnikovoi', '12345');
INSERT INTO USERS (USER_ID, PERSONAL_ID, USER_ROLE_ID, LOGIN, PPASSWORD) VALUES (3, 3, 3, 'evtux', '3890');
INSERT INTO USERS (USER_ID, PERSONAL_ID, USER_ROLE_ID, LOGIN, PPASSWORD) VALUES (4, 6, 2, 'staroselecpp', 'cpp');
INSERT INTO USERS (USER_ID, PERSONAL_ID, USER_ROLE_ID, LOGIN, PPASSWORD) VALUES (5, 10, 4, 'nikita', 'nini');
INSERT INTO USERS (USER_ID, PERSONAL_ID, USER_ROLE_ID, LOGIN, PPASSWORD) VALUES (6, 8, 4, 'grig', '8');
COMMIT;