Ideone.com

fork download

copy

/* =========================================================
   TẠO LẠI CSDL DKYTINCHI
========================================================= */
 
DROP DATABASE IF EXISTS DkyTinChi;
CREATE DATABASE DkyTinChi CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE DkyTinChi;
 
/* =========================================================
   1. HEADQUARTER
   Lưu thông tin trụ sở/cơ sở đào tạo
========================================================= */
 
CREATE TABLE headquarter
(
    ID_headquarter varchar(20) NOT NULL,
    name_headquarter varchar(100) NOT NULL,
    address varchar(200) NOT NULL,
 
    -- Chống trùng mã trụ sở
    CONSTRAINT PK_headquarter PRIMARY KEY (ID_headquarter),
 
    -- Chống trùng tên trụ sở
    CONSTRAINT UQ_headquarter_name UNIQUE (name_headquarter)
);
 
/* =========================================================
   2. DEPARTMENT
   Lưu thông tin khoa thuộc từng trụ sở
========================================================= */
 
CREATE TABLE department
(
    ID_department varchar(20) NOT NULL,
    name_department varchar(100) NOT NULL,
    ID_headquarter varchar(20) NOT NULL,
 
    -- Chống trùng mã khoa
    CONSTRAINT PK_department PRIMARY KEY (ID_department),
 
    -- Mỗi khoa phải thuộc một trụ sở hợp lệ
    CONSTRAINT FK_department_headquarter
        FOREIGN KEY (ID_headquarter)
        REFERENCES headquarter(ID_headquarter),
 
    -- Không trùng tên khoa trong cùng một trụ sở
    CONSTRAINT UQ_department_headquarter_name
        UNIQUE (ID_headquarter, name_department)
);
 
/* =========================================================
   3. SUBJECT
   Danh mục môn học/học phần dùng chung toàn hệ thống
========================================================= */
 
CREATE TABLE subject
(
    ID_subject varchar(20) NOT NULL,
    name_subject varchar(100) NOT NULL,
    number_of_credit int NOT NULL,
 
    -- Chống trùng mã môn học
    CONSTRAINT PK_subject PRIMARY KEY (ID_subject),
 
    -- Chống trùng tên môn học
    CONSTRAINT UQ_subject_name UNIQUE (name_subject),
 
    -- Số tín chỉ phải lớn hơn 0
    CONSTRAINT CK_subject_credit CHECK (number_of_credit > 0)
);
 
/* =========================================================
   4. CURRICULUM
   Chương trình đào tạo dùng chung toàn hệ thống
========================================================= */
 
CREATE TABLE curriculum
(
    ID_curriculum varchar(20) NOT NULL,
    curriculum_name varchar(100) NOT NULL,
    total_credits_required int NOT NULL,
 
    -- Chống trùng mã chương trình đào tạo
    CONSTRAINT PK_curriculum PRIMARY KEY (ID_curriculum),
 
    -- Chống trùng tên chương trình đào tạo
    CONSTRAINT UQ_curriculum_name UNIQUE (curriculum_name),
 
    -- Tổng tín chỉ yêu cầu phải lớn hơn 0
    CONSTRAINT CK_curriculum_total_credit CHECK (total_credits_required > 0)
);
 
/* =========================================================
   5. CURRICULUM_SUBJECT
   Bảng trung gian giữa chương trình đào tạo và môn học
========================================================= */
 
CREATE TABLE curriculum_subject
(
    ID_curriculum varchar(20) NOT NULL,
    ID_subject varchar(20) NOT NULL,
    is_required tinyint(1) NOT NULL,
 
    -- Một môn không được lặp trong cùng một chương trình đào tạo
    CONSTRAINT PK_curriculum_subject
        PRIMARY KEY (ID_curriculum, ID_subject),
 
    -- Chương trình đào tạo phải tồn tại
    CONSTRAINT FK_curriculum_subject_curriculum
        FOREIGN KEY (ID_curriculum)
        REFERENCES curriculum(ID_curriculum),
 
    -- Môn học phải tồn tại
    CONSTRAINT FK_curriculum_subject_subject
        FOREIGN KEY (ID_subject)
        REFERENCES subject(ID_subject)
);
 
/* =========================================================
   6. PREREQUISITE
   Lưu môn học tiên quyết
========================================================= */
 
CREATE TABLE prerequisite
(
    ID_subject varchar(20) NOT NULL,
    ID_prereq_subject varchar(20) NOT NULL,
    min_grade float NULL,
    note varchar(200) NULL,
 
    -- Chống trùng cặp môn học - môn tiên quyết
    CONSTRAINT PK_prerequisite
        PRIMARY KEY (ID_subject, ID_prereq_subject),
 
    -- Môn học chính phải tồn tại
    CONSTRAINT FK_prerequisite_subject
        FOREIGN KEY (ID_subject)
        REFERENCES subject(ID_subject),
 
    -- Môn tiên quyết cũng phải tồn tại trong bảng subject
    CONSTRAINT FK_prerequisite_prereq_subject
        FOREIGN KEY (ID_prereq_subject)
        REFERENCES subject(ID_subject),
 
    -- Một môn không được là tiên quyết của chính nó
    CONSTRAINT CK_prerequisite_not_self
        CHECK (ID_subject <> ID_prereq_subject),
 
    -- Điểm tối thiểu nếu có phải nằm trong khoảng 0 đến 10
    CONSTRAINT CK_prerequisite_min_grade
        CHECK (min_grade IS NULL OR min_grade BETWEEN 0 AND 10)
);
 
/* =========================================================
   7. TERM
   Lưu học kỳ, năm học, thời gian mở/đóng đăng ký
========================================================= */
 
CREATE TABLE term
(
    ID_term varchar(20) NOT NULL,
    name_term varchar(100) NOT NULL,
    year_start int NOT NULL,
    term_no int NOT NULL,
    start_date date NOT NULL,
    end_date date NOT NULL,
    reg_open datetime NOT NULL,
    reg_close datetime NOT NULL,
 
    -- Chống trùng mã học kỳ
    CONSTRAINT PK_term PRIMARY KEY (ID_term),
 
    -- Học kỳ chỉ nhận 1, 2 hoặc 3
    CONSTRAINT CK_term_no
        CHECK (term_no BETWEEN 1 AND 3),
 
    -- Ngày bắt đầu phải trước ngày kết thúc
    CONSTRAINT CK_term_date
        CHECK (start_date < end_date),
 
    -- Thời gian mở đăng ký phải trước thời gian đóng đăng ký
    CONSTRAINT CK_term_register_time
        CHECK (reg_open < reg_close)
);
 
/* =========================================================
   8. TIMESLOT
   Lưu ca học dùng chung toàn hệ thống
========================================================= */
 
CREATE TABLE timeslot
(
    ID_timeslot varchar(20) NOT NULL,
    shift_no int NOT NULL,
    start_time time NOT NULL,
    end_time time NOT NULL,
 
    -- Chống trùng mã ca học
    CONSTRAINT PK_timeslot PRIMARY KEY (ID_timeslot),
 
    -- Chống trùng số ca học
    CONSTRAINT UQ_timeslot_shift_no
        UNIQUE (shift_no),
 
    -- Giờ bắt đầu phải trước giờ kết thúc
    CONSTRAINT CK_timeslot_time
        CHECK (start_time < end_time)
);
 
/* =========================================================
   9. TEACHER
   Lưu thông tin giảng viên
========================================================= */
 
CREATE TABLE teacher
(
    ID_teacher varchar(20) NOT NULL,
    name_teacher varchar(100) NOT NULL,
    degree varchar(100) NULL,
    address_teacher varchar(200) NULL,
    phone_teacher varchar(15) NULL,
    gender_teacher varchar(10) NULL,
    ID_department varchar(20) NOT NULL,
 
    -- Chống trùng mã giảng viên
    CONSTRAINT PK_teacher PRIMARY KEY (ID_teacher),
 
    -- Giảng viên phải thuộc một khoa hợp lệ
    CONSTRAINT FK_teacher_department
        FOREIGN KEY (ID_department)
        REFERENCES department(ID_department),
 
    -- Chống trùng số điện thoại giảng viên (MySQL cho phép nhiều dòng NULL)
    CONSTRAINT UQ_teacher_phone UNIQUE (phone_teacher)
);
 
/* =========================================================
   10. STUDENT
   Lưu thông tin sinh viên
========================================================= */
 
CREATE TABLE student
(
    ID_student varchar(20) NOT NULL,
    name_student varchar(100) NOT NULL,
    date_of_birth date NULL,
    gender_student varchar(10) NULL,
    address_student varchar(200) NULL,
    phone_student varchar(15) NULL,
    year_of_admission int NOT NULL,
    ID_department varchar(20) NOT NULL,
    ID_curriculum varchar(20) NOT NULL,
 
    -- Chống trùng mã sinh viên
    CONSTRAINT PK_student PRIMARY KEY (ID_student),
 
    -- Sinh viên phải thuộc một khoa hợp lệ
    CONSTRAINT FK_student_department
        FOREIGN KEY (ID_department)
        REFERENCES department(ID_department),
 
    -- Sinh viên phải theo một chương trình đào tạo hợp lệ
    CONSTRAINT FK_student_curriculum
        FOREIGN KEY (ID_curriculum)
        REFERENCES curriculum(ID_curriculum),
 
    -- Năm nhập học không quá nhỏ
    CONSTRAINT CK_student_year_admission
        CHECK (year_of_admission >= 2000),
 
    -- Chống trùng số điện thoại sinh viên (MySQL cho phép nhiều dòng NULL)
    CONSTRAINT UQ_student_phone UNIQUE (phone_student)
);
 
/* =========================================================
   11. ROOM
   Lưu thông tin phòng học theo từng trụ sở
========================================================= */
 
CREATE TABLE room
(
    ID_room varchar(20) NOT NULL,
    name_room varchar(50) NOT NULL,
    capacity int NOT NULL,
    ID_headquarter varchar(20) NOT NULL,
 
    -- Chống trùng mã phòng
    CONSTRAINT PK_room PRIMARY KEY (ID_room),
 
    -- Phòng học phải thuộc một trụ sở hợp lệ
    CONSTRAINT FK_room_headquarter
        FOREIGN KEY (ID_headquarter)
        REFERENCES headquarter(ID_headquarter),
 
    -- Không trùng tên phòng trong cùng một trụ sở
    CONSTRAINT UQ_room_headquarter_name
        UNIQUE (ID_headquarter, name_room),
 
    -- Sức chứa phòng phải lớn hơn 0
    CONSTRAINT CK_room_capacity
        CHECK (capacity > 0)
);
 
/* =========================================================
   12. CLASS
   Lưu lớp học phần được mở trong từng học kỳ
========================================================= */
 
CREATE TABLE `class`
(
    ID_class varchar(20) NOT NULL,
    ID_subject varchar(20) NOT NULL,
    ID_teacher varchar(20) NOT NULL,
    ID_term varchar(20) NOT NULL,
    group_number int NOT NULL,
    min_students int NOT NULL,
    max_students int NOT NULL,
 
    -- Số lượng sinh viên đã đăng ký, mặc định là 0
    number_of_registration int NOT NULL DEFAULT 0,
 
    -- Trạng thái lớp học phần, mặc định là OPEN
    class_status varchar(20) NOT NULL DEFAULT 'OPEN',
 
    -- Chống trùng mã lớp học phần
    CONSTRAINT PK_class PRIMARY KEY (ID_class),
 
    -- Lớp học phần phải thuộc một môn học hợp lệ
    CONSTRAINT FK_class_subject
        FOREIGN KEY (ID_subject)
        REFERENCES subject(ID_subject),
 
    -- Lớp học phần phải có giảng viên phụ trách hợp lệ
    CONSTRAINT FK_class_teacher
        FOREIGN KEY (ID_teacher)
        REFERENCES teacher(ID_teacher),
 
    -- Lớp học phần phải thuộc một học kỳ hợp lệ
    CONSTRAINT FK_class_term
        FOREIGN KEY (ID_term)
        REFERENCES term(ID_term),
 
    -- Nhóm lớp học phần phải lớn hơn 0
    CONSTRAINT CK_class_group_number
        CHECK (group_number > 0),
 
    -- Sĩ số tối thiểu không được âm
    CONSTRAINT CK_class_min_students
        CHECK (min_students >= 0),
 
    -- Sĩ số tối đa phải lớn hơn 0
    CONSTRAINT CK_class_max_students
        CHECK (max_students > 0),
 
    -- Sĩ số tối thiểu không được lớn hơn sĩ số tối đa
    CONSTRAINT CK_class_min_max
        CHECK (min_students <= max_students),
 
    -- Số lượng đăng ký không được âm và không được vượt sĩ số tối đa
    CONSTRAINT CK_class_number_registration
        CHECK (number_of_registration >= 0 AND number_of_registration <= max_students),
 
    -- Trạng thái lớp chỉ được thuộc các giá trị hợp lệ
    CONSTRAINT CK_class_status
        CHECK (class_status IN ('OPEN', 'CLOSED', 'CANCELLED')),
 
    -- Chống trùng lớp cùng môn, cùng học kỳ, cùng nhóm
    CONSTRAINT UQ_class_subject_term_group
        UNIQUE (ID_subject, ID_term, group_number)
);
 
/* =========================================================
   13. SESSION
   Lưu lịch học/buổi học cụ thể của lớp học phần
========================================================= */
 
CREATE TABLE `session`
(
    ID_session varchar(20) NOT NULL,
    study_date date NOT NULL,
    day_of_week tinyint NOT NULL,
    note varchar(200) NULL,
    ID_class varchar(20) NOT NULL,
    ID_room varchar(20) NOT NULL,
    ID_timeslot varchar(20) NOT NULL,
 
    -- Chống trùng mã buổi học
    CONSTRAINT PK_session PRIMARY KEY (ID_session),
 
    -- Buổi học phải thuộc một lớp học phần hợp lệ
    CONSTRAINT FK_session_class
        FOREIGN KEY (ID_class)
        REFERENCES `class`(ID_class),
 
    -- Buổi học phải diễn ra tại một phòng hợp lệ
    CONSTRAINT FK_session_room
        FOREIGN KEY (ID_room)
        REFERENCES room(ID_room),
 
    -- Buổi học phải thuộc một ca học hợp lệ
    CONSTRAINT FK_session_timeslot
        FOREIGN KEY (ID_timeslot)
        REFERENCES timeslot(ID_timeslot),
 
    -- Thứ trong tuần từ 2 đến 8
    CONSTRAINT CK_session_day_of_week
        CHECK (day_of_week BETWEEN 2 AND 8),
 
    -- Một phòng không được xếp cho 2 lớp cùng ngày, cùng ca
    CONSTRAINT UQ_session_room_time 
        UNIQUE (ID_room, study_date, ID_timeslot)
);
 
/* =========================================================
   14. REGISTRATION
   Lưu thông tin đăng ký học phần của sinh viên
========================================================= */
 
CREATE TABLE registration
(
    ID_registration varchar(20) NOT NULL,
    ID_student varchar(20) NOT NULL,
    ID_class varchar(20) NOT NULL,
 
    -- Thời gian đăng ký, mặc định là thời điểm hiện tại
    registered_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
 
    cancelled_at datetime NULL,
 
    -- Trạng thái đăng ký, mặc định là REGISTERED
    registration_status varchar(20) NOT NULL DEFAULT 'REGISTERED',
 
    -- Cột ảo thay thế Filtered Index của SQL Server để kiểm soát trùng lặp khi trạng thái là REGISTERED
    active_uid varchar(50) GENERATED ALWAYS AS (
        CASE WHEN registration_status = 'REGISTERED' THEN CONCAT(ID_student, '_', ID_class) ELSE NULL END
    ) VIRTUAL,
 
    -- Chống trùng mã đăng ký
    CONSTRAINT PK_registration PRIMARY KEY (ID_registration),
 
    -- Đăng ký phải thuộc sinh viên hợp lệ
    CONSTRAINT FK_registration_student
        FOREIGN KEY (ID_student)
        REFERENCES student(ID_student),
 
    -- Đăng ký phải thuộc lớp học phần hợp lệ
    CONSTRAINT FK_registration_class
        FOREIGN KEY (ID_class)
        REFERENCES `class`(ID_class),
 
    -- Trạng thái đăng ký chỉ nhận giá trị hợp lệ
    CONSTRAINT CK_registration_status
        CHECK (registration_status IN ('REGISTERED', 'CANCELLED')),
 
    -- Nếu có thời gian hủy thì thời gian hủy phải sau thời gian đăng ký
    CONSTRAINT CK_registration_cancelled_at
        CHECK (cancelled_at IS NULL OR cancelled_at >= registered_at),
 
    -- Thực thi Unique ràng buộc qua cột ảo active_uid
    CONSTRAINT UQ_registration_active UNIQUE (active_uid)
);
 
/* =========================================================
   15. INDEX PHỤ TRỢ
========================================================= */
 
CREATE INDEX IX_department_headquarter ON department(ID_headquarter);
CREATE INDEX IX_teacher_department ON teacher(ID_department);
CREATE INDEX IX_student_department ON student(ID_department);
CREATE INDEX IX_student_curriculum ON student(ID_curriculum);
CREATE INDEX IX_room_headquarter ON room(ID_headquarter);
CREATE INDEX IX_class_subject ON `class`(ID_subject);
CREATE INDEX IX_class_teacher ON `class`(ID_teacher);
CREATE INDEX IX_class_term ON `class`(ID_term);
CREATE INDEX IX_session_class ON `session`(ID_class);
CREATE INDEX IX_registration_student ON registration(ID_student);
CREATE INDEX IX_registration_class ON registration(ID_class);
 
 
/* =========================================================
   16. PROCEDURE ĐĂNG KÝ HỌC PHẦN
========================================================= */
 
DELIMITER //
 
DROP PROCEDURE IF EXISTS usp_RegisterClass//
 
CREATE PROCEDURE usp_RegisterClass (
    IN p_ID_registration varchar(20),
    IN p_ID_student varchar(20),
    IN p_ID_class varchar(20)
)
BEGIN
    DECLARE msg TEXT;
 
    -- Xử lý ngoại lệ để Rollback tự động và đẩy thông báo lỗi ra ngoài
    DECLARE EXIT HANDLER FOR SQLEXCEPTION
    BEGIN
        GET DIAGNOSTICS CONDITION 1 msg = MESSAGE_TEXT;
        ROLLBACK;
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = msg;
    END;
 
    START TRANSACTION;
 
    -- Kiểm tra sinh viên có tồn tại không
    IF NOT EXISTS (
        SELECT 1
        FROM student
        WHERE ID_student = p_ID_student
    ) THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Sinh viên không tồn tại.';
    END IF;
 
    -- Kiểm tra lớp có mở đăng ký và còn trong thời gian đăng ký không
    IF NOT EXISTS (
        SELECT 1
        FROM `class` c
        JOIN term t ON c.ID_term = t.ID_term
        WHERE c.ID_class = p_ID_class
          AND c.class_status = 'OPEN'
          AND NOW() BETWEEN t.reg_open AND t.reg_close
    ) THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Lớp không mở đăng ký hoặc ngoài thời gian đăng ký.';
    END IF;
 
    -- Chống sinh viên đăng ký trùng cùng một lớp học phần
    IF EXISTS (
        SELECT 1
        FROM registration
        WHERE ID_student = p_ID_student
          AND ID_class = p_ID_class
          AND registration_status = 'REGISTERED'
    ) THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Sinh viên đã đăng ký lớp học phần này.';
    END IF;
 
    -- Chống sinh viên đăng ký 2 lớp bị trùng lịch học
    IF EXISTS (
        SELECT 1
        FROM registration r
        JOIN `session` s_old ON r.ID_class = s_old.ID_class
        JOIN `session` s_new ON s_old.study_date = s_new.study_date
                              AND s_old.ID_timeslot = s_new.ID_timeslot
        WHERE r.ID_student = p_ID_student
          AND r.registration_status = 'REGISTERED'
          AND s_new.ID_class = p_ID_class
    ) THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Lịch học bị trùng với lớp học phần đã đăng ký.';
    END IF;
 
    -- Tăng sĩ số nếu lớp còn chỗ (MySQL tự động Row Lock dòng này khi UPDATE)
    UPDATE `class`
    SET number_of_registration = number_of_registration + 1
    WHERE ID_class = p_ID_class
      AND class_status = 'OPEN'
      AND number_of_registration < max_students;
 
    -- Nếu không update được dòng nào nghĩa là lớp đã đầy
    IF ROW_COUNT() = 0 THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Lớp học phần đã đủ sĩ số.';
    END IF;
 
    -- Thêm bản ghi đăng ký
    INSERT INTO registration (ID_registration, ID_student, ID_class)
    VALUES (p_ID_registration, p_ID_student, p_ID_class);
 
    COMMIT;
END//
 
DELIMITER ;
 
 
/* =========================================================
   17. PROCEDURE HỦY ĐĂNG KÝ
========================================================= */
 
DELIMITER //
 
DROP PROCEDURE IF EXISTS usp_CancelRegistration//
 
CREATE PROCEDURE usp_CancelRegistration (
    IN p_ID_registration varchar(20)
)
BEGIN
    DECLARE v_ID_class varchar(20) DEFAULT NULL;
    DECLARE msg TEXT;
 
    -- Xử lý ngoại lệ để Rollback tự động
    DECLARE EXIT HANDLER FOR SQLEXCEPTION
    BEGIN
        GET DIAGNOSTICS CONDITION 1 msg = MESSAGE_TEXT;
        ROLLBACK;
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = msg;
    END;
 
    START TRANSACTION;
 
    -- Khóa bản ghi đăng ký cần hủy và lấy ID_class bằng FOR UPDATE
    SELECT ID_class INTO v_ID_class
    FROM registration
    WHERE ID_registration = p_ID_registration
      AND registration_status = 'REGISTERED'
    FOR UPDATE;
 
    -- Nếu không tìm thấy đăng ký hợp lệ thì báo lỗi
    IF v_ID_class IS NULL THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Không tìm thấy đăng ký hợp lệ để hủy.';
    END IF;
 
    -- Cập nhật trạng thái hủy
    UPDATE registration
    SET registration_status = 'CANCELLED',
        cancelled_at = NOW()
    WHERE ID_registration = p_ID_registration;
 
    -- Giảm sĩ số lớp sau khi hủy
    UPDATE `class`
    SET number_of_registration = number_of_registration - 1
    WHERE ID_class = v_ID_class
      AND number_of_registration > 0;
 
    COMMIT;
END//
 
DELIMITER ;

LyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIFThuqBPIEzhuqBJIENTREwgREtZVElOQ0hJCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKRFJPUCBEQVRBQkFTRSBJRiBFWElTVFMgRGt5VGluQ2hpOwpDUkVBVEUgREFUQUJBU0UgRGt5VGluQ2hpIENIQVJBQ1RFUiBTRVQgdXRmOG1iNCBDT0xMQVRFIHV0ZjhtYjRfdW5pY29kZV9jaTsKVVNFIERreVRpbkNoaTsKCi8qID09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQogICAxLiBIRUFEUVVBUlRFUgogICBMxrB1IHRow7RuZyB0aW4gdHLhu6Ugc+G7ny9jxqEgc+G7nyDEkcOgbyB04bqhbwo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0gKi8KCkNSRUFURSBUQUJMRSBoZWFkcXVhcnRlcgooCiAgICBJRF9oZWFkcXVhcnRlciB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIG5hbWVfaGVhZHF1YXJ0ZXIgdmFyY2hhcigxMDApIE5PVCBOVUxMLAogICAgYWRkcmVzcyB2YXJjaGFyKDIwMCkgTk9UIE5VTEwsCgogICAgLS0gQ2jhu5FuZyB0csO5bmcgbcOjIHRy4bulIHPhu58KICAgIENPTlNUUkFJTlQgUEtfaGVhZHF1YXJ0ZXIgUFJJTUFSWSBLRVkgKElEX2hlYWRxdWFydGVyKSwKCiAgICAtLSBDaOG7kW5nIHRyw7luZyB0w6puIHRy4bulIHPhu58KICAgIENPTlNUUkFJTlQgVVFfaGVhZHF1YXJ0ZXJfbmFtZSBVTklRVUUgKG5hbWVfaGVhZHF1YXJ0ZXIpCik7CgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgMi4gREVQQVJUTUVOVAogICBMxrB1IHRow7RuZyB0aW4ga2hvYSB0aHXhu5ljIHThu6tuZyB0cuG7pSBz4bufCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKQ1JFQVRFIFRBQkxFIGRlcGFydG1lbnQKKAogICAgSURfZGVwYXJ0bWVudCB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIG5hbWVfZGVwYXJ0bWVudCB2YXJjaGFyKDEwMCkgTk9UIE5VTEwsCiAgICBJRF9oZWFkcXVhcnRlciB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKCiAgICAtLSBDaOG7kW5nIHRyw7luZyBtw6Mga2hvYQogICAgQ09OU1RSQUlOVCBQS19kZXBhcnRtZW50IFBSSU1BUlkgS0VZIChJRF9kZXBhcnRtZW50KSwKCiAgICAtLSBN4buXaSBraG9hIHBo4bqjaSB0aHXhu5ljIG3hu5l0IHRy4bulIHPhu58gaOG7o3AgbOG7hwogICAgQ09OU1RSQUlOVCBGS19kZXBhcnRtZW50X2hlYWRxdWFydGVyCiAgICAgICAgRk9SRUlHTiBLRVkgKElEX2hlYWRxdWFydGVyKQogICAgICAgIFJFRkVSRU5DRVMgaGVhZHF1YXJ0ZXIoSURfaGVhZHF1YXJ0ZXIpLAoKICAgIC0tIEtow7RuZyB0csO5bmcgdMOqbiBraG9hIHRyb25nIGPDuW5nIG3hu5l0IHRy4bulIHPhu58KICAgIENPTlNUUkFJTlQgVVFfZGVwYXJ0bWVudF9oZWFkcXVhcnRlcl9uYW1lCiAgICAgICAgVU5JUVVFIChJRF9oZWFkcXVhcnRlciwgbmFtZV9kZXBhcnRtZW50KQopOwoKLyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIDMuIFNVQkpFQ1QKICAgRGFuaCBt4bulYyBtw7RuIGjhu41jL2jhu41jIHBo4bqnbiBkw7luZyBjaHVuZyB0b8OgbiBo4buHIHRo4buRbmcKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpDUkVBVEUgVEFCTEUgc3ViamVjdAooCiAgICBJRF9zdWJqZWN0IHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgbmFtZV9zdWJqZWN0IHZhcmNoYXIoMTAwKSBOT1QgTlVMTCwKICAgIG51bWJlcl9vZl9jcmVkaXQgaW50IE5PVCBOVUxMLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIG3DoyBtw7RuIGjhu41jCiAgICBDT05TVFJBSU5UIFBLX3N1YmplY3QgUFJJTUFSWSBLRVkgKElEX3N1YmplY3QpLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIHTDqm4gbcO0biBo4buNYwogICAgQ09OU1RSQUlOVCBVUV9zdWJqZWN0X25hbWUgVU5JUVVFIChuYW1lX3N1YmplY3QpLAoKICAgIC0tIFPhu5EgdMOtbiBjaOG7iSBwaOG6o2kgbOG7m24gaMahbiAwCiAgICBDT05TVFJBSU5UIENLX3N1YmplY3RfY3JlZGl0IENIRUNLIChudW1iZXJfb2ZfY3JlZGl0ID4gMCkKKTsKCi8qID09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQogICA0LiBDVVJSSUNVTFVNCiAgIENoxrDGoW5nIHRyw6xuaCDEkcOgbyB04bqhbyBkw7luZyBjaHVuZyB0b8OgbiBo4buHIHRo4buRbmcKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpDUkVBVEUgVEFCTEUgY3VycmljdWx1bQooCiAgICBJRF9jdXJyaWN1bHVtIHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgY3VycmljdWx1bV9uYW1lIHZhcmNoYXIoMTAwKSBOT1QgTlVMTCwKICAgIHRvdGFsX2NyZWRpdHNfcmVxdWlyZWQgaW50IE5PVCBOVUxMLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIG3DoyBjaMawxqFuZyB0csOsbmggxJHDoG8gdOG6oW8KICAgIENPTlNUUkFJTlQgUEtfY3VycmljdWx1bSBQUklNQVJZIEtFWSAoSURfY3VycmljdWx1bSksCgogICAgLS0gQ2jhu5FuZyB0csO5bmcgdMOqbiBjaMawxqFuZyB0csOsbmggxJHDoG8gdOG6oW8KICAgIENPTlNUUkFJTlQgVVFfY3VycmljdWx1bV9uYW1lIFVOSVFVRSAoY3VycmljdWx1bV9uYW1lKSwKCiAgICAtLSBU4buVbmcgdMOtbiBjaOG7iSB5w6p1IGPhuqd1IHBo4bqjaSBs4bubbiBoxqFuIDAKICAgIENPTlNUUkFJTlQgQ0tfY3VycmljdWx1bV90b3RhbF9jcmVkaXQgQ0hFQ0sgKHRvdGFsX2NyZWRpdHNfcmVxdWlyZWQgPiAwKQopOwoKLyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIDUuIENVUlJJQ1VMVU1fU1VCSkVDVAogICBC4bqjbmcgdHJ1bmcgZ2lhbiBnaeG7r2EgY2jGsMahbmcgdHLDrG5oIMSRw6BvIHThuqFvIHbDoCBtw7RuIGjhu41jCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKQ1JFQVRFIFRBQkxFIGN1cnJpY3VsdW1fc3ViamVjdAooCiAgICBJRF9jdXJyaWN1bHVtIHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgSURfc3ViamVjdCB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIGlzX3JlcXVpcmVkIHRpbnlpbnQoMSkgTk9UIE5VTEwsCgogICAgLS0gTeG7mXQgbcO0biBraMO0bmcgxJHGsOG7o2MgbOG6t3AgdHJvbmcgY8O5bmcgbeG7mXQgY2jGsMahbmcgdHLDrG5oIMSRw6BvIHThuqFvCiAgICBDT05TVFJBSU5UIFBLX2N1cnJpY3VsdW1fc3ViamVjdAogICAgICAgIFBSSU1BUlkgS0VZIChJRF9jdXJyaWN1bHVtLCBJRF9zdWJqZWN0KSwKCiAgICAtLSBDaMawxqFuZyB0csOsbmggxJHDoG8gdOG6oW8gcGjhuqNpIHThu5NuIHThuqFpCiAgICBDT05TVFJBSU5UIEZLX2N1cnJpY3VsdW1fc3ViamVjdF9jdXJyaWN1bHVtCiAgICAgICAgRk9SRUlHTiBLRVkgKElEX2N1cnJpY3VsdW0pCiAgICAgICAgUkVGRVJFTkNFUyBjdXJyaWN1bHVtKElEX2N1cnJpY3VsdW0pLAoKICAgIC0tIE3DtG4gaOG7jWMgcGjhuqNpIHThu5NuIHThuqFpCiAgICBDT05TVFJBSU5UIEZLX2N1cnJpY3VsdW1fc3ViamVjdF9zdWJqZWN0CiAgICAgICAgRk9SRUlHTiBLRVkgKElEX3N1YmplY3QpCiAgICAgICAgUkVGRVJFTkNFUyBzdWJqZWN0KElEX3N1YmplY3QpCik7CgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgNi4gUFJFUkVRVUlTSVRFCiAgIEzGsHUgbcO0biBo4buNYyB0acOqbiBxdXnhur90Cj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKQ1JFQVRFIFRBQkxFIHByZXJlcXVpc2l0ZQooCiAgICBJRF9zdWJqZWN0IHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgSURfcHJlcmVxX3N1YmplY3QgdmFyY2hhcigyMCkgTk9UIE5VTEwsCiAgICBtaW5fZ3JhZGUgZmxvYXQgTlVMTCwKICAgIG5vdGUgdmFyY2hhcigyMDApIE5VTEwsCgogICAgLS0gQ2jhu5FuZyB0csO5bmcgY+G6t3AgbcO0biBo4buNYyAtIG3DtG4gdGnDqm4gcXV54bq/dAogICAgQ09OU1RSQUlOVCBQS19wcmVyZXF1aXNpdGUKICAgICAgICBQUklNQVJZIEtFWSAoSURfc3ViamVjdCwgSURfcHJlcmVxX3N1YmplY3QpLAoKICAgIC0tIE3DtG4gaOG7jWMgY2jDrW5oIHBo4bqjaSB04buTbiB04bqhaQogICAgQ09OU1RSQUlOVCBGS19wcmVyZXF1aXNpdGVfc3ViamVjdAogICAgICAgIEZPUkVJR04gS0VZIChJRF9zdWJqZWN0KQogICAgICAgIFJFRkVSRU5DRVMgc3ViamVjdChJRF9zdWJqZWN0KSwKCiAgICAtLSBNw7RuIHRpw6puIHF1eeG6v3QgY8WpbmcgcGjhuqNpIHThu5NuIHThuqFpIHRyb25nIGLhuqNuZyBzdWJqZWN0CiAgICBDT05TVFJBSU5UIEZLX3ByZXJlcXVpc2l0ZV9wcmVyZXFfc3ViamVjdAogICAgICAgIEZPUkVJR04gS0VZIChJRF9wcmVyZXFfc3ViamVjdCkKICAgICAgICBSRUZFUkVOQ0VTIHN1YmplY3QoSURfc3ViamVjdCksCgogICAgLS0gTeG7mXQgbcO0biBraMO0bmcgxJHGsOG7o2MgbMOgIHRpw6puIHF1eeG6v3QgY+G7p2EgY2jDrW5oIG7DswogICAgQ09OU1RSQUlOVCBDS19wcmVyZXF1aXNpdGVfbm90X3NlbGYKICAgICAgICBDSEVDSyAoSURfc3ViamVjdCA8PiBJRF9wcmVyZXFfc3ViamVjdCksCgogICAgLS0gxJBp4buDbSB04buRaSB0aGnhu4N1IG7hur91IGPDsyBwaOG6o2kgbuG6sW0gdHJvbmcga2hv4bqjbmcgMCDEkeG6v24gMTAKICAgIENPTlNUUkFJTlQgQ0tfcHJlcmVxdWlzaXRlX21pbl9ncmFkZQogICAgICAgIENIRUNLIChtaW5fZ3JhZGUgSVMgTlVMTCBPUiBtaW5fZ3JhZGUgQkVUV0VFTiAwIEFORCAxMCkKKTsKCi8qID09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQogICA3LiBURVJNCiAgIEzGsHUgaOG7jWMga+G7sywgbsSDbSBo4buNYywgdGjhu51pIGdpYW4gbeG7ny/EkcOzbmcgxJHEg25nIGvDvQo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0gKi8KCkNSRUFURSBUQUJMRSB0ZXJtCigKICAgIElEX3Rlcm0gdmFyY2hhcigyMCkgTk9UIE5VTEwsCiAgICBuYW1lX3Rlcm0gdmFyY2hhcigxMDApIE5PVCBOVUxMLAogICAgeWVhcl9zdGFydCBpbnQgTk9UIE5VTEwsCiAgICB0ZXJtX25vIGludCBOT1QgTlVMTCwKICAgIHN0YXJ0X2RhdGUgZGF0ZSBOT1QgTlVMTCwKICAgIGVuZF9kYXRlIGRhdGUgTk9UIE5VTEwsCiAgICByZWdfb3BlbiBkYXRldGltZSBOT1QgTlVMTCwKICAgIHJlZ19jbG9zZSBkYXRldGltZSBOT1QgTlVMTCwKCiAgICAtLSBDaOG7kW5nIHRyw7luZyBtw6MgaOG7jWMga+G7swogICAgQ09OU1RSQUlOVCBQS190ZXJtIFBSSU1BUlkgS0VZIChJRF90ZXJtKSwKCiAgICAtLSBI4buNYyBr4buzIGNo4buJIG5o4bqtbiAxLCAyIGhv4bq3YyAzCiAgICBDT05TVFJBSU5UIENLX3Rlcm1fbm8KICAgICAgICBDSEVDSyAodGVybV9ubyBCRVRXRUVOIDEgQU5EIDMpLAoKICAgIC0tIE5nw6B5IGLhuq90IMSR4bqndSBwaOG6o2kgdHLGsOG7m2MgbmfDoHkga+G6v3QgdGjDumMKICAgIENPTlNUUkFJTlQgQ0tfdGVybV9kYXRlCiAgICAgICAgQ0hFQ0sgKHN0YXJ0X2RhdGUgPCBlbmRfZGF0ZSksCgogICAgLS0gVGjhu51pIGdpYW4gbeG7nyDEkcSDbmcga8O9IHBo4bqjaSB0csaw4bubYyB0aOG7nWkgZ2lhbiDEkcOzbmcgxJHEg25nIGvDvQogICAgQ09OU1RSQUlOVCBDS190ZXJtX3JlZ2lzdGVyX3RpbWUKICAgICAgICBDSEVDSyAocmVnX29wZW4gPCByZWdfY2xvc2UpCik7CgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgOC4gVElNRVNMT1QKICAgTMawdSBjYSBo4buNYyBkw7luZyBjaHVuZyB0b8OgbiBo4buHIHRo4buRbmcKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpDUkVBVEUgVEFCTEUgdGltZXNsb3QKKAogICAgSURfdGltZXNsb3QgdmFyY2hhcigyMCkgTk9UIE5VTEwsCiAgICBzaGlmdF9ubyBpbnQgTk9UIE5VTEwsCiAgICBzdGFydF90aW1lIHRpbWUgTk9UIE5VTEwsCiAgICBlbmRfdGltZSB0aW1lIE5PVCBOVUxMLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIG3DoyBjYSBo4buNYwogICAgQ09OU1RSQUlOVCBQS190aW1lc2xvdCBQUklNQVJZIEtFWSAoSURfdGltZXNsb3QpLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIHPhu5EgY2EgaOG7jWMKICAgIENPTlNUUkFJTlQgVVFfdGltZXNsb3Rfc2hpZnRfbm8KICAgICAgICBVTklRVUUgKHNoaWZ0X25vKSwKCiAgICAtLSBHaeG7nSBi4bqvdCDEkeG6p3UgcGjhuqNpIHRyxrDhu5tjIGdp4budIGvhur90IHRow7pjCiAgICBDT05TVFJBSU5UIENLX3RpbWVzbG90X3RpbWUKICAgICAgICBDSEVDSyAoc3RhcnRfdGltZSA8IGVuZF90aW1lKQopOwoKLyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIDkuIFRFQUNIRVIKICAgTMawdSB0aMO0bmcgdGluIGdp4bqjbmcgdmnDqm4KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpDUkVBVEUgVEFCTEUgdGVhY2hlcgooCiAgICBJRF90ZWFjaGVyIHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgbmFtZV90ZWFjaGVyIHZhcmNoYXIoMTAwKSBOT1QgTlVMTCwKICAgIGRlZ3JlZSB2YXJjaGFyKDEwMCkgTlVMTCwKICAgIGFkZHJlc3NfdGVhY2hlciB2YXJjaGFyKDIwMCkgTlVMTCwKICAgIHBob25lX3RlYWNoZXIgdmFyY2hhcigxNSkgTlVMTCwKICAgIGdlbmRlcl90ZWFjaGVyIHZhcmNoYXIoMTApIE5VTEwsCiAgICBJRF9kZXBhcnRtZW50IHZhcmNoYXIoMjApIE5PVCBOVUxMLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIG3DoyBnaeG6o25nIHZpw6puCiAgICBDT05TVFJBSU5UIFBLX3RlYWNoZXIgUFJJTUFSWSBLRVkgKElEX3RlYWNoZXIpLAoKICAgIC0tIEdp4bqjbmcgdmnDqm4gcGjhuqNpIHRodeG7mWMgbeG7mXQga2hvYSBo4bujcCBs4buHCiAgICBDT05TVFJBSU5UIEZLX3RlYWNoZXJfZGVwYXJ0bWVudAogICAgICAgIEZPUkVJR04gS0VZIChJRF9kZXBhcnRtZW50KQogICAgICAgIFJFRkVSRU5DRVMgZGVwYXJ0bWVudChJRF9kZXBhcnRtZW50KSwKICAgICAgICAKICAgIC0tIENo4buRbmcgdHLDuW5nIHPhu5EgxJFp4buHbiB0aG/huqFpIGdp4bqjbmcgdmnDqm4gKE15U1FMIGNobyBwaMOpcCBuaGnhu4F1IGTDsm5nIE5VTEwpCiAgICBDT05TVFJBSU5UIFVRX3RlYWNoZXJfcGhvbmUgVU5JUVVFIChwaG9uZV90ZWFjaGVyKQopOwoKLyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIDEwLiBTVFVERU5UCiAgIEzGsHUgdGjDtG5nIHRpbiBzaW5oIHZpw6puCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKQ1JFQVRFIFRBQkxFIHN0dWRlbnQKKAogICAgSURfc3R1ZGVudCB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIG5hbWVfc3R1ZGVudCB2YXJjaGFyKDEwMCkgTk9UIE5VTEwsCiAgICBkYXRlX29mX2JpcnRoIGRhdGUgTlVMTCwKICAgIGdlbmRlcl9zdHVkZW50IHZhcmNoYXIoMTApIE5VTEwsCiAgICBhZGRyZXNzX3N0dWRlbnQgdmFyY2hhcigyMDApIE5VTEwsCiAgICBwaG9uZV9zdHVkZW50IHZhcmNoYXIoMTUpIE5VTEwsCiAgICB5ZWFyX29mX2FkbWlzc2lvbiBpbnQgTk9UIE5VTEwsCiAgICBJRF9kZXBhcnRtZW50IHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgSURfY3VycmljdWx1bSB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKCiAgICAtLSBDaOG7kW5nIHRyw7luZyBtw6Mgc2luaCB2acOqbgogICAgQ09OU1RSQUlOVCBQS19zdHVkZW50IFBSSU1BUlkgS0VZIChJRF9zdHVkZW50KSwKCiAgICAtLSBTaW5oIHZpw6puIHBo4bqjaSB0aHXhu5ljIG3hu5l0IGtob2EgaOG7o3AgbOG7hwogICAgQ09OU1RSQUlOVCBGS19zdHVkZW50X2RlcGFydG1lbnQKICAgICAgICBGT1JFSUdOIEtFWSAoSURfZGVwYXJ0bWVudCkKICAgICAgICBSRUZFUkVOQ0VTIGRlcGFydG1lbnQoSURfZGVwYXJ0bWVudCksCgogICAgLS0gU2luaCB2acOqbiBwaOG6o2kgdGhlbyBt4buZdCBjaMawxqFuZyB0csOsbmggxJHDoG8gdOG6oW8gaOG7o3AgbOG7hwogICAgQ09OU1RSQUlOVCBGS19zdHVkZW50X2N1cnJpY3VsdW0KICAgICAgICBGT1JFSUdOIEtFWSAoSURfY3VycmljdWx1bSkKICAgICAgICBSRUZFUkVOQ0VTIGN1cnJpY3VsdW0oSURfY3VycmljdWx1bSksCgogICAgLS0gTsSDbSBuaOG6rXAgaOG7jWMga2jDtG5nIHF1w6Egbmjhu48KICAgIENPTlNUUkFJTlQgQ0tfc3R1ZGVudF95ZWFyX2FkbWlzc2lvbgogICAgICAgIENIRUNLICh5ZWFyX29mX2FkbWlzc2lvbiA+PSAyMDAwKSwKICAgICAgICAKICAgIC0tIENo4buRbmcgdHLDuW5nIHPhu5EgxJFp4buHbiB0aG/huqFpIHNpbmggdmnDqm4gKE15U1FMIGNobyBwaMOpcCBuaGnhu4F1IGTDsm5nIE5VTEwpCiAgICBDT05TVFJBSU5UIFVRX3N0dWRlbnRfcGhvbmUgVU5JUVVFIChwaG9uZV9zdHVkZW50KQopOwoKLyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIDExLiBST09NCiAgIEzGsHUgdGjDtG5nIHRpbiBwaMOybmcgaOG7jWMgdGhlbyB04burbmcgdHLhu6Ugc+G7nwo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0gKi8KCkNSRUFURSBUQUJMRSByb29tCigKICAgIElEX3Jvb20gdmFyY2hhcigyMCkgTk9UIE5VTEwsCiAgICBuYW1lX3Jvb20gdmFyY2hhcig1MCkgTk9UIE5VTEwsCiAgICBjYXBhY2l0eSBpbnQgTk9UIE5VTEwsCiAgICBJRF9oZWFkcXVhcnRlciB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKCiAgICAtLSBDaOG7kW5nIHRyw7luZyBtw6MgcGjDsm5nCiAgICBDT05TVFJBSU5UIFBLX3Jvb20gUFJJTUFSWSBLRVkgKElEX3Jvb20pLAoKICAgIC0tIFBow7JuZyBo4buNYyBwaOG6o2kgdGh14buZYyBt4buZdCB0cuG7pSBz4bufIGjhu6NwIGzhu4cKICAgIENPTlNUUkFJTlQgRktfcm9vbV9oZWFkcXVhcnRlcgogICAgICAgIEZPUkVJR04gS0VZIChJRF9oZWFkcXVhcnRlcikKICAgICAgICBSRUZFUkVOQ0VTIGhlYWRxdWFydGVyKElEX2hlYWRxdWFydGVyKSwKCiAgICAtLSBLaMO0bmcgdHLDuW5nIHTDqm4gcGjDsm5nIHRyb25nIGPDuW5nIG3hu5l0IHRy4bulIHPhu58KICAgIENPTlNUUkFJTlQgVVFfcm9vbV9oZWFkcXVhcnRlcl9uYW1lCiAgICAgICAgVU5JUVVFIChJRF9oZWFkcXVhcnRlciwgbmFtZV9yb29tKSwKCiAgICAtLSBT4bupYyBjaOG7qWEgcGjDsm5nIHBo4bqjaSBs4bubbiBoxqFuIDAKICAgIENPTlNUUkFJTlQgQ0tfcm9vbV9jYXBhY2l0eQogICAgICAgIENIRUNLIChjYXBhY2l0eSA+IDApCik7CgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgMTIuIENMQVNTCiAgIEzGsHUgbOG7m3AgaOG7jWMgcGjhuqduIMSRxrDhu6NjIG3hu58gdHJvbmcgdOG7q25nIGjhu41jIGvhu7MKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpDUkVBVEUgVEFCTEUgYGNsYXNzYAooCiAgICBJRF9jbGFzcyB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIElEX3N1YmplY3QgdmFyY2hhcigyMCkgTk9UIE5VTEwsCiAgICBJRF90ZWFjaGVyIHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgSURfdGVybSB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIGdyb3VwX251bWJlciBpbnQgTk9UIE5VTEwsCiAgICBtaW5fc3R1ZGVudHMgaW50IE5PVCBOVUxMLAogICAgbWF4X3N0dWRlbnRzIGludCBOT1QgTlVMTCwKCiAgICAtLSBT4buRIGzGsOG7o25nIHNpbmggdmnDqm4gxJHDoyDEkcSDbmcga8O9LCBt4bq3YyDEkeG7i25oIGzDoCAwCiAgICBudW1iZXJfb2ZfcmVnaXN0cmF0aW9uIGludCBOT1QgTlVMTCBERUZBVUxUIDAsCgogICAgLS0gVHLhuqFuZyB0aMOhaSBs4bubcCBo4buNYyBwaOG6p24sIG3hurdjIMSR4buLbmggbMOgIE9QRU4KICAgIGNsYXNzX3N0YXR1cyB2YXJjaGFyKDIwKSBOT1QgTlVMTCBERUZBVUxUICdPUEVOJywKCiAgICAtLSBDaOG7kW5nIHRyw7luZyBtw6MgbOG7m3AgaOG7jWMgcGjhuqduCiAgICBDT05TVFJBSU5UIFBLX2NsYXNzIFBSSU1BUlkgS0VZIChJRF9jbGFzcyksCgogICAgLS0gTOG7m3AgaOG7jWMgcGjhuqduIHBo4bqjaSB0aHXhu5ljIG3hu5l0IG3DtG4gaOG7jWMgaOG7o3AgbOG7hwogICAgQ09OU1RSQUlOVCBGS19jbGFzc19zdWJqZWN0CiAgICAgICAgRk9SRUlHTiBLRVkgKElEX3N1YmplY3QpCiAgICAgICAgUkVGRVJFTkNFUyBzdWJqZWN0KElEX3N1YmplY3QpLAoKICAgIC0tIEzhu5twIGjhu41jIHBo4bqnbiBwaOG6o2kgY8OzIGdp4bqjbmcgdmnDqm4gcGjhu6UgdHLDoWNoIGjhu6NwIGzhu4cKICAgIENPTlNUUkFJTlQgRktfY2xhc3NfdGVhY2hlcgogICAgICAgIEZPUkVJR04gS0VZIChJRF90ZWFjaGVyKQogICAgICAgIFJFRkVSRU5DRVMgdGVhY2hlcihJRF90ZWFjaGVyKSwKCiAgICAtLSBM4bubcCBo4buNYyBwaOG6p24gcGjhuqNpIHRodeG7mWMgbeG7mXQgaOG7jWMga+G7syBo4bujcCBs4buHCiAgICBDT05TVFJBSU5UIEZLX2NsYXNzX3Rlcm0KICAgICAgICBGT1JFSUdOIEtFWSAoSURfdGVybSkKICAgICAgICBSRUZFUkVOQ0VTIHRlcm0oSURfdGVybSksCgogICAgLS0gTmjDs20gbOG7m3AgaOG7jWMgcGjhuqduIHBo4bqjaSBs4bubbiBoxqFuIDAKICAgIENPTlNUUkFJTlQgQ0tfY2xhc3NfZ3JvdXBfbnVtYmVyCiAgICAgICAgQ0hFQ0sgKGdyb3VwX251bWJlciA+IDApLAoKICAgIC0tIFPEqSBz4buRIHThu5FpIHRoaeG7g3Uga2jDtG5nIMSRxrDhu6NjIMOibQogICAgQ09OU1RSQUlOVCBDS19jbGFzc19taW5fc3R1ZGVudHMKICAgICAgICBDSEVDSyAobWluX3N0dWRlbnRzID49IDApLAoKICAgIC0tIFPEqSBz4buRIHThu5FpIMSRYSBwaOG6o2kgbOG7m24gaMahbiAwCiAgICBDT05TVFJBSU5UIENLX2NsYXNzX21heF9zdHVkZW50cwogICAgICAgIENIRUNLIChtYXhfc3R1ZGVudHMgPiAwKSwKCiAgICAtLSBTxKkgc+G7kSB04buRaSB0aGnhu4N1IGtow7RuZyDEkcaw4bujYyBs4bubbiBoxqFuIHPEqSBz4buRIHThu5FpIMSRYQogICAgQ09OU1RSQUlOVCBDS19jbGFzc19taW5fbWF4CiAgICAgICAgQ0hFQ0sgKG1pbl9zdHVkZW50cyA8PSBtYXhfc3R1ZGVudHMpLAoKICAgIC0tIFPhu5EgbMaw4bujbmcgxJHEg25nIGvDvSBraMO0bmcgxJHGsOG7o2Mgw6JtIHbDoCBraMO0bmcgxJHGsOG7o2Mgdsaw4bujdCBzxKkgc+G7kSB04buRaSDEkWEKICAgIENPTlNUUkFJTlQgQ0tfY2xhc3NfbnVtYmVyX3JlZ2lzdHJhdGlvbgogICAgICAgIENIRUNLIChudW1iZXJfb2ZfcmVnaXN0cmF0aW9uID49IDAgQU5EIG51bWJlcl9vZl9yZWdpc3RyYXRpb24gPD0gbWF4X3N0dWRlbnRzKSwKCiAgICAtLSBUcuG6oW5nIHRow6FpIGzhu5twIGNo4buJIMSRxrDhu6NjIHRodeG7mWMgY8OhYyBnacOhIHRy4buLIGjhu6NwIGzhu4cKICAgIENPTlNUUkFJTlQgQ0tfY2xhc3Nfc3RhdHVzCiAgICAgICAgQ0hFQ0sgKGNsYXNzX3N0YXR1cyBJTiAoJ09QRU4nLCAnQ0xPU0VEJywgJ0NBTkNFTExFRCcpKSwKCiAgICAtLSBDaOG7kW5nIHRyw7luZyBs4bubcCBjw7luZyBtw7RuLCBjw7luZyBo4buNYyBr4buzLCBjw7luZyBuaMOzbQogICAgQ09OU1RSQUlOVCBVUV9jbGFzc19zdWJqZWN0X3Rlcm1fZ3JvdXAKICAgICAgICBVTklRVUUgKElEX3N1YmplY3QsIElEX3Rlcm0sIGdyb3VwX251bWJlcikKKTsKCi8qID09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQogICAxMy4gU0VTU0lPTgogICBMxrB1IGzhu4tjaCBo4buNYy9ideG7lWkgaOG7jWMgY+G7pSB0aOG7gyBj4bunYSBs4bubcCBo4buNYyBwaOG6p24KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpDUkVBVEUgVEFCTEUgYHNlc3Npb25gCigKICAgIElEX3Nlc3Npb24gdmFyY2hhcigyMCkgTk9UIE5VTEwsCiAgICBzdHVkeV9kYXRlIGRhdGUgTk9UIE5VTEwsCiAgICBkYXlfb2Zfd2VlayB0aW55aW50IE5PVCBOVUxMLAogICAgbm90ZSB2YXJjaGFyKDIwMCkgTlVMTCwKICAgIElEX2NsYXNzIHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgSURfcm9vbSB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIElEX3RpbWVzbG90IHZhcmNoYXIoMjApIE5PVCBOVUxMLAoKICAgIC0tIENo4buRbmcgdHLDuW5nIG3DoyBideG7lWkgaOG7jWMKICAgIENPTlNUUkFJTlQgUEtfc2Vzc2lvbiBQUklNQVJZIEtFWSAoSURfc2Vzc2lvbiksCgogICAgLS0gQnXhu5VpIGjhu41jIHBo4bqjaSB0aHXhu5ljIG3hu5l0IGzhu5twIGjhu41jIHBo4bqnbiBo4bujcCBs4buHCiAgICBDT05TVFJBSU5UIEZLX3Nlc3Npb25fY2xhc3MKICAgICAgICBGT1JFSUdOIEtFWSAoSURfY2xhc3MpCiAgICAgICAgUkVGRVJFTkNFUyBgY2xhc3NgKElEX2NsYXNzKSwKCiAgICAtLSBCdeG7lWkgaOG7jWMgcGjhuqNpIGRp4buFbiByYSB04bqhaSBt4buZdCBwaMOybmcgaOG7o3AgbOG7hwogICAgQ09OU1RSQUlOVCBGS19zZXNzaW9uX3Jvb20KICAgICAgICBGT1JFSUdOIEtFWSAoSURfcm9vbSkKICAgICAgICBSRUZFUkVOQ0VTIHJvb20oSURfcm9vbSksCgogICAgLS0gQnXhu5VpIGjhu41jIHBo4bqjaSB0aHXhu5ljIG3hu5l0IGNhIGjhu41jIGjhu6NwIGzhu4cKICAgIENPTlNUUkFJTlQgRktfc2Vzc2lvbl90aW1lc2xvdAogICAgICAgIEZPUkVJR04gS0VZIChJRF90aW1lc2xvdCkKICAgICAgICBSRUZFUkVOQ0VTIHRpbWVzbG90KElEX3RpbWVzbG90KSwKCiAgICAtLSBUaOG7qSB0cm9uZyB0deG6p24gdOG7qyAyIMSR4bq/biA4CiAgICBDT05TVFJBSU5UIENLX3Nlc3Npb25fZGF5X29mX3dlZWsKICAgICAgICBDSEVDSyAoZGF5X29mX3dlZWsgQkVUV0VFTiAyIEFORCA4KSwKICAgICAgICAKICAgIC0tIE3hu5l0IHBow7JuZyBraMO0bmcgxJHGsOG7o2MgeOG6v3AgY2hvIDIgbOG7m3AgY8O5bmcgbmfDoHksIGPDuW5nIGNhCiAgICBDT05TVFJBSU5UIFVRX3Nlc3Npb25fcm9vbV90aW1lIAogICAgICAgIFVOSVFVRSAoSURfcm9vbSwgc3R1ZHlfZGF0ZSwgSURfdGltZXNsb3QpCik7CgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgMTQuIFJFR0lTVFJBVElPTgogICBMxrB1IHRow7RuZyB0aW4gxJHEg25nIGvDvSBo4buNYyBwaOG6p24gY+G7p2Egc2luaCB2acOqbgo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0gKi8KCkNSRUFURSBUQUJMRSByZWdpc3RyYXRpb24KKAogICAgSURfcmVnaXN0cmF0aW9uIHZhcmNoYXIoMjApIE5PVCBOVUxMLAogICAgSURfc3R1ZGVudCB2YXJjaGFyKDIwKSBOT1QgTlVMTCwKICAgIElEX2NsYXNzIHZhcmNoYXIoMjApIE5PVCBOVUxMLAoKICAgIC0tIFRo4budaSBnaWFuIMSRxINuZyBrw70sIG3hurdjIMSR4buLbmggbMOgIHRo4budaSDEkWnhu4NtIGhp4buHbiB04bqhaQogICAgcmVnaXN0ZXJlZF9hdCBkYXRldGltZSBOT1QgTlVMTCBERUZBVUxUIENVUlJFTlRfVElNRVNUQU1QLAoKICAgIGNhbmNlbGxlZF9hdCBkYXRldGltZSBOVUxMLAoKICAgIC0tIFRy4bqhbmcgdGjDoWkgxJHEg25nIGvDvSwgbeG6t2MgxJHhu4tuaCBsw6AgUkVHSVNURVJFRAogICAgcmVnaXN0cmF0aW9uX3N0YXR1cyB2YXJjaGFyKDIwKSBOT1QgTlVMTCBERUZBVUxUICdSRUdJU1RFUkVEJywKICAgIAogICAgLS0gQ+G7mXQg4bqjbyB0aGF5IHRo4bq/IEZpbHRlcmVkIEluZGV4IGPhu6dhIFNRTCBTZXJ2ZXIgxJHhu4Mga2nhu4NtIHNvw6F0IHRyw7luZyBs4bq3cCBraGkgdHLhuqFuZyB0aMOhaSBsw6AgUkVHSVNURVJFRAogICAgYWN0aXZlX3VpZCB2YXJjaGFyKDUwKSBHRU5FUkFURUQgQUxXQVlTIEFTICgKICAgICAgICBDQVNFIFdIRU4gcmVnaXN0cmF0aW9uX3N0YXR1cyA9ICdSRUdJU1RFUkVEJyBUSEVOIENPTkNBVChJRF9zdHVkZW50LCAnXycsIElEX2NsYXNzKSBFTFNFIE5VTEwgRU5ECiAgICApIFZJUlRVQUwsCgogICAgLS0gQ2jhu5FuZyB0csO5bmcgbcOjIMSRxINuZyBrw70KICAgIENPTlNUUkFJTlQgUEtfcmVnaXN0cmF0aW9uIFBSSU1BUlkgS0VZIChJRF9yZWdpc3RyYXRpb24pLAoKICAgIC0tIMSQxINuZyBrw70gcGjhuqNpIHRodeG7mWMgc2luaCB2acOqbiBo4bujcCBs4buHCiAgICBDT05TVFJBSU5UIEZLX3JlZ2lzdHJhdGlvbl9zdHVkZW50CiAgICAgICAgRk9SRUlHTiBLRVkgKElEX3N0dWRlbnQpCiAgICAgICAgUkVGRVJFTkNFUyBzdHVkZW50KElEX3N0dWRlbnQpLAoKICAgIC0tIMSQxINuZyBrw70gcGjhuqNpIHRodeG7mWMgbOG7m3AgaOG7jWMgcGjhuqduIGjhu6NwIGzhu4cKICAgIENPTlNUUkFJTlQgRktfcmVnaXN0cmF0aW9uX2NsYXNzCiAgICAgICAgRk9SRUlHTiBLRVkgKElEX2NsYXNzKQogICAgICAgIFJFRkVSRU5DRVMgYGNsYXNzYChJRF9jbGFzcyksCgogICAgLS0gVHLhuqFuZyB0aMOhaSDEkcSDbmcga8O9IGNo4buJIG5o4bqtbiBnacOhIHRy4buLIGjhu6NwIGzhu4cKICAgIENPTlNUUkFJTlQgQ0tfcmVnaXN0cmF0aW9uX3N0YXR1cwogICAgICAgIENIRUNLIChyZWdpc3RyYXRpb25fc3RhdHVzIElOICgnUkVHSVNURVJFRCcsICdDQU5DRUxMRUQnKSksCgogICAgLS0gTuG6v3UgY8OzIHRo4budaSBnaWFuIGjhu6d5IHRow6wgdGjhu51pIGdpYW4gaOG7p3kgcGjhuqNpIHNhdSB0aOG7nWkgZ2lhbiDEkcSDbmcga8O9CiAgICBDT05TVFJBSU5UIENLX3JlZ2lzdHJhdGlvbl9jYW5jZWxsZWRfYXQKICAgICAgICBDSEVDSyAoY2FuY2VsbGVkX2F0IElTIE5VTEwgT1IgY2FuY2VsbGVkX2F0ID49IHJlZ2lzdGVyZWRfYXQpLAogICAgICAgIAogICAgLS0gVGjhu7FjIHRoaSBVbmlxdWUgcsOgbmcgYnXhu5ljIHF1YSBj4buZdCDhuqNvIGFjdGl2ZV91aWQKICAgIENPTlNUUkFJTlQgVVFfcmVnaXN0cmF0aW9uX2FjdGl2ZSBVTklRVUUgKGFjdGl2ZV91aWQpCik7CgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgMTUuIElOREVYIFBI4bukIFRS4buiCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKQ1JFQVRFIElOREVYIElYX2RlcGFydG1lbnRfaGVhZHF1YXJ0ZXIgT04gZGVwYXJ0bWVudChJRF9oZWFkcXVhcnRlcik7CkNSRUFURSBJTkRFWCBJWF90ZWFjaGVyX2RlcGFydG1lbnQgT04gdGVhY2hlcihJRF9kZXBhcnRtZW50KTsKQ1JFQVRFIElOREVYIElYX3N0dWRlbnRfZGVwYXJ0bWVudCBPTiBzdHVkZW50KElEX2RlcGFydG1lbnQpOwpDUkVBVEUgSU5ERVggSVhfc3R1ZGVudF9jdXJyaWN1bHVtIE9OIHN0dWRlbnQoSURfY3VycmljdWx1bSk7CkNSRUFURSBJTkRFWCBJWF9yb29tX2hlYWRxdWFydGVyIE9OIHJvb20oSURfaGVhZHF1YXJ0ZXIpOwpDUkVBVEUgSU5ERVggSVhfY2xhc3Nfc3ViamVjdCBPTiBgY2xhc3NgKElEX3N1YmplY3QpOwpDUkVBVEUgSU5ERVggSVhfY2xhc3NfdGVhY2hlciBPTiBgY2xhc3NgKElEX3RlYWNoZXIpOwpDUkVBVEUgSU5ERVggSVhfY2xhc3NfdGVybSBPTiBgY2xhc3NgKElEX3Rlcm0pOwpDUkVBVEUgSU5ERVggSVhfc2Vzc2lvbl9jbGFzcyBPTiBgc2Vzc2lvbmAoSURfY2xhc3MpOwpDUkVBVEUgSU5ERVggSVhfcmVnaXN0cmF0aW9uX3N0dWRlbnQgT04gcmVnaXN0cmF0aW9uKElEX3N0dWRlbnQpOwpDUkVBVEUgSU5ERVggSVhfcmVnaXN0cmF0aW9uX2NsYXNzIE9OIHJlZ2lzdHJhdGlvbihJRF9jbGFzcyk7CgoKLyogPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CiAgIDE2LiBQUk9DRURVUkUgxJDEgk5HIEvDnSBI4buMQyBQSOG6pk4KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09ICovCgpERUxJTUlURVIgLy8KCkRST1AgUFJPQ0VEVVJFIElGIEVYSVNUUyB1c3BfUmVnaXN0ZXJDbGFzcy8vCgpDUkVBVEUgUFJPQ0VEVVJFIHVzcF9SZWdpc3RlckNsYXNzICgKICAgIElOIHBfSURfcmVnaXN0cmF0aW9uIHZhcmNoYXIoMjApLAogICAgSU4gcF9JRF9zdHVkZW50IHZhcmNoYXIoMjApLAogICAgSU4gcF9JRF9jbGFzcyB2YXJjaGFyKDIwKQopCkJFR0lOCiAgICBERUNMQVJFIG1zZyBURVhUOwogICAgCiAgICAtLSBY4butIGzDvSBuZ2/huqFpIGzhu4cgxJHhu4MgUm9sbGJhY2sgdOG7sSDEkeG7mW5nIHbDoCDEkeG6qXkgdGjDtG5nIGLDoW8gbOG7l2kgcmEgbmdvw6BpCiAgICBERUNMQVJFIEVYSVQgSEFORExFUiBGT1IgU1FMRVhDRVBUSU9OCiAgICBCRUdJTgogICAgICAgIEdFVCBESUFHTk9TVElDUyBDT05ESVRJT04gMSBtc2cgPSBNRVNTQUdFX1RFWFQ7CiAgICAgICAgUk9MTEJBQ0s7CiAgICAgICAgU0lHTkFMIFNRTFNUQVRFICc0NTAwMCcgU0VUIE1FU1NBR0VfVEVYVCA9IG1zZzsKICAgIEVORDsKCiAgICBTVEFSVCBUUkFOU0FDVElPTjsKCiAgICAtLSBLaeG7g20gdHJhIHNpbmggdmnDqm4gY8OzIHThu5NuIHThuqFpIGtow7RuZwogICAgSUYgTk9UIEVYSVNUUyAoCiAgICAgICAgU0VMRUNUIDEKICAgICAgICBGUk9NIHN0dWRlbnQKICAgICAgICBXSEVSRSBJRF9zdHVkZW50ID0gcF9JRF9zdHVkZW50CiAgICApIFRIRU4KICAgICAgICBTSUdOQUwgU1FMU1RBVEUgJzQ1MDAwJyBTRVQgTUVTU0FHRV9URVhUID0gJ1NpbmggdmnDqm4ga2jDtG5nIHThu5NuIHThuqFpLic7CiAgICBFTkQgSUY7CgogICAgLS0gS2nhu4NtIHRyYSBs4bubcCBjw7MgbeG7nyDEkcSDbmcga8O9IHbDoCBjw7JuIHRyb25nIHRo4budaSBnaWFuIMSRxINuZyBrw70ga2jDtG5nCiAgICBJRiBOT1QgRVhJU1RTICgKICAgICAgICBTRUxFQ1QgMQogICAgICAgIEZST00gYGNsYXNzYCBjCiAgICAgICAgSk9JTiB0ZXJtIHQgT04gYy5JRF90ZXJtID0gdC5JRF90ZXJtCiAgICAgICAgV0hFUkUgYy5JRF9jbGFzcyA9IHBfSURfY2xhc3MKICAgICAgICAgIEFORCBjLmNsYXNzX3N0YXR1cyA9ICdPUEVOJwogICAgICAgICAgQU5EIE5PVygpIEJFVFdFRU4gdC5yZWdfb3BlbiBBTkQgdC5yZWdfY2xvc2UKICAgICkgVEhFTgogICAgICAgIFNJR05BTCBTUUxTVEFURSAnNDUwMDAnIFNFVCBNRVNTQUdFX1RFWFQgPSAnTOG7m3Aga2jDtG5nIG3hu58gxJHEg25nIGvDvSBob+G6t2Mgbmdvw6BpIHRo4budaSBnaWFuIMSRxINuZyBrw70uJzsKICAgIEVORCBJRjsKCiAgICAtLSBDaOG7kW5nIHNpbmggdmnDqm4gxJHEg25nIGvDvSB0csO5bmcgY8O5bmcgbeG7mXQgbOG7m3AgaOG7jWMgcGjhuqduCiAgICBJRiBFWElTVFMgKAogICAgICAgIFNFTEVDVCAxCiAgICAgICAgRlJPTSByZWdpc3RyYXRpb24KICAgICAgICBXSEVSRSBJRF9zdHVkZW50ID0gcF9JRF9zdHVkZW50CiAgICAgICAgICBBTkQgSURfY2xhc3MgPSBwX0lEX2NsYXNzCiAgICAgICAgICBBTkQgcmVnaXN0cmF0aW9uX3N0YXR1cyA9ICdSRUdJU1RFUkVEJwogICAgKSBUSEVOCiAgICAgICAgU0lHTkFMIFNRTFNUQVRFICc0NTAwMCcgU0VUIE1FU1NBR0VfVEVYVCA9ICdTaW5oIHZpw6puIMSRw6MgxJHEg25nIGvDvSBs4bubcCBo4buNYyBwaOG6p24gbsOgeS4nOwogICAgRU5EIElGOwoKICAgIC0tIENo4buRbmcgc2luaCB2acOqbiDEkcSDbmcga8O9IDIgbOG7m3AgYuG7iyB0csO5bmcgbOG7i2NoIGjhu41jCiAgICBJRiBFWElTVFMgKAogICAgICAgIFNFTEVDVCAxCiAgICAgICAgRlJPTSByZWdpc3RyYXRpb24gcgogICAgICAgIEpPSU4gYHNlc3Npb25gIHNfb2xkIE9OIHIuSURfY2xhc3MgPSBzX29sZC5JRF9jbGFzcwogICAgICAgIEpPSU4gYHNlc3Npb25gIHNfbmV3IE9OIHNfb2xkLnN0dWR5X2RhdGUgPSBzX25ldy5zdHVkeV9kYXRlCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEFORCBzX29sZC5JRF90aW1lc2xvdCA9IHNfbmV3LklEX3RpbWVzbG90CiAgICAgICAgV0hFUkUgci5JRF9zdHVkZW50ID0gcF9JRF9zdHVkZW50CiAgICAgICAgICBBTkQgci5yZWdpc3RyYXRpb25fc3RhdHVzID0gJ1JFR0lTVEVSRUQnCiAgICAgICAgICBBTkQgc19uZXcuSURfY2xhc3MgPSBwX0lEX2NsYXNzCiAgICApIFRIRU4KICAgICAgICBTSUdOQUwgU1FMU1RBVEUgJzQ1MDAwJyBTRVQgTUVTU0FHRV9URVhUID0gJ0zhu4tjaCBo4buNYyBi4buLIHRyw7luZyB24bubaSBs4bubcCBo4buNYyBwaOG6p24gxJHDoyDEkcSDbmcga8O9Lic7CiAgICBFTkQgSUY7CgogICAgLS0gVMSDbmcgc8SpIHPhu5EgbuG6v3UgbOG7m3AgY8OybiBjaOG7lyAoTXlTUUwgdOG7sSDEkeG7mW5nIFJvdyBMb2NrIGTDsm5nIG7DoHkga2hpIFVQREFURSkKICAgIFVQREFURSBgY2xhc3NgCiAgICBTRVQgbnVtYmVyX29mX3JlZ2lzdHJhdGlvbiA9IG51bWJlcl9vZl9yZWdpc3RyYXRpb24gKyAxCiAgICBXSEVSRSBJRF9jbGFzcyA9IHBfSURfY2xhc3MKICAgICAgQU5EIGNsYXNzX3N0YXR1cyA9ICdPUEVOJwogICAgICBBTkQgbnVtYmVyX29mX3JlZ2lzdHJhdGlvbiA8IG1heF9zdHVkZW50czsKCiAgICAtLSBO4bq/dSBraMO0bmcgdXBkYXRlIMSRxrDhu6NjIGTDsm5nIG7DoG8gbmdoxKlhIGzDoCBs4bubcCDEkcOjIMSR4bqneQogICAgSUYgUk9XX0NPVU5UKCkgPSAwIFRIRU4KICAgICAgICBTSUdOQUwgU1FMU1RBVEUgJzQ1MDAwJyBTRVQgTUVTU0FHRV9URVhUID0gJ0zhu5twIGjhu41jIHBo4bqnbiDEkcOjIMSR4bunIHPEqSBz4buRLic7CiAgICBFTkQgSUY7CgogICAgLS0gVGjDqm0gYuG6o24gZ2hpIMSRxINuZyBrw70KICAgIElOU0VSVCBJTlRPIHJlZ2lzdHJhdGlvbiAoSURfcmVnaXN0cmF0aW9uLCBJRF9zdHVkZW50LCBJRF9jbGFzcykKICAgIFZBTFVFUyAocF9JRF9yZWdpc3RyYXRpb24sIHBfSURfc3R1ZGVudCwgcF9JRF9jbGFzcyk7CgogICAgQ09NTUlUOwpFTkQvLwoKREVMSU1JVEVSIDsKCgovKiA9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KICAgMTcuIFBST0NFRFVSRSBI4bumWSDEkMSCTkcgS8OdCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PSAqLwoKREVMSU1JVEVSIC8vCgpEUk9QIFBST0NFRFVSRSBJRiBFWElTVFMgdXNwX0NhbmNlbFJlZ2lzdHJhdGlvbi8vCgpDUkVBVEUgUFJPQ0VEVVJFIHVzcF9DYW5jZWxSZWdpc3RyYXRpb24gKAogICAgSU4gcF9JRF9yZWdpc3RyYXRpb24gdmFyY2hhcigyMCkKKQpCRUdJTgogICAgREVDTEFSRSB2X0lEX2NsYXNzIHZhcmNoYXIoMjApIERFRkFVTFQgTlVMTDsKICAgIERFQ0xBUkUgbXNnIFRFWFQ7CiAgICAKICAgIC0tIFjhu60gbMO9IG5nb+G6oWkgbOG7hyDEkeG7gyBSb2xsYmFjayB04buxIMSR4buZbmcKICAgIERFQ0xBUkUgRVhJVCBIQU5ETEVSIEZPUiBTUUxFWENFUFRJT04KICAgIEJFR0lOCiAgICAgICAgR0VUIERJQUdOT1NUSUNTIENPTkRJVElPTiAxIG1zZyA9IE1FU1NBR0VfVEVYVDsKICAgICAgICBST0xMQkFDSzsKICAgICAgICBTSUdOQUwgU1FMU1RBVEUgJzQ1MDAwJyBTRVQgTUVTU0FHRV9URVhUID0gbXNnOwogICAgRU5EOwoKICAgIFNUQVJUIFRSQU5TQUNUSU9OOwoKICAgIC0tIEtow7NhIGLhuqNuIGdoaSDEkcSDbmcga8O9IGPhuqduIGjhu6d5IHbDoCBs4bqleSBJRF9jbGFzcyBi4bqxbmcgRk9SIFVQREFURQogICAgU0VMRUNUIElEX2NsYXNzIElOVE8gdl9JRF9jbGFzcwogICAgRlJPTSByZWdpc3RyYXRpb24KICAgIFdIRVJFIElEX3JlZ2lzdHJhdGlvbiA9IHBfSURfcmVnaXN0cmF0aW9uCiAgICAgIEFORCByZWdpc3RyYXRpb25fc3RhdHVzID0gJ1JFR0lTVEVSRUQnCiAgICBGT1IgVVBEQVRFOwoKICAgIC0tIE7hur91IGtow7RuZyB0w6xtIHRo4bqleSDEkcSDbmcga8O9IGjhu6NwIGzhu4cgdGjDrCBiw6FvIGzhu5dpCiAgICBJRiB2X0lEX2NsYXNzIElTIE5VTEwgVEhFTgogICAgICAgIFNJR05BTCBTUUxTVEFURSAnNDUwMDAnIFNFVCBNRVNTQUdFX1RFWFQgPSAnS2jDtG5nIHTDrG0gdGjhuqV5IMSRxINuZyBrw70gaOG7o3AgbOG7hyDEkeG7gyBo4buneS4nOwogICAgRU5EIElGOwoKICAgIC0tIEPhuq1wIG5o4bqtdCB0cuG6oW5nIHRow6FpIGjhu6d5CiAgICBVUERBVEUgcmVnaXN0cmF0aW9uCiAgICBTRVQgcmVnaXN0cmF0aW9uX3N0YXR1cyA9ICdDQU5DRUxMRUQnLAogICAgICAgIGNhbmNlbGxlZF9hdCA9IE5PVygpCiAgICBXSEVSRSBJRF9yZWdpc3RyYXRpb24gPSBwX0lEX3JlZ2lzdHJhdGlvbjsKCiAgICAtLSBHaeG6o20gc8SpIHPhu5EgbOG7m3Agc2F1IGtoaSBo4buneQogICAgVVBEQVRFIGBjbGFzc2AKICAgIFNFVCBudW1iZXJfb2ZfcmVnaXN0cmF0aW9uID0gbnVtYmVyX29mX3JlZ2lzdHJhdGlvbiAtIDEKICAgIFdIRVJFIElEX2NsYXNzID0gdl9JRF9jbGFzcwogICAgICBBTkQgbnVtYmVyX29mX3JlZ2lzdHJhdGlvbiA+IDA7CgogICAgQ09NTUlUOwpFTkQvLwoKREVMSU1JVEVSIDs=

Success #stdin #stdout #stderr 0.01s 5288KB

stdin

copy

Standard input is empty

stdout

copy

Standard output is empty

stderr

copy

Error: near line 5: near "DATABASE": syntax error
Error: near line 6: near "DATABASE": syntax error
Error: near line 7: near "USE": syntax error
Error: near line 419: near "GENERATED": syntax error
Error: near line 476: no such table: main.registration
Error: near line 477: no such table: main.registration
Error: near line 484: near "DELIMITER": syntax error
Error: near line 497: near "DECLARE": syntax error
Error: near line 500: cannot rollback - no transaction is active
Error: near line 501: near "SIGNAL": syntax error
Error: near line 502: cannot commit - no transaction is active
Error: near line 504: near "START": syntax error
Error: near line 507: near "IF": syntax error
Error: near line 513: near "IF": syntax error
Error: near line 516: near "IF": syntax error
Error: near line 525: near "IF": syntax error
Error: near line 528: near "IF": syntax error
Error: near line 536: near "IF": syntax error
Error: near line 539: near "IF": syntax error
Error: near line 550: near "IF": syntax error
Error: near line 553: no such column: p_ID_class
Error: near line 560: near "IF": syntax error
Error: near line 562: near "IF": syntax error
Error: near line 565: no such table: registration
Error: near line 568: cannot commit - no transaction is active
Error: near line 569: near "/": syntax error
Error: near line 578: near "DELIMITER": syntax error
Error: near line 587: near "DECLARE": syntax error
Error: near line 590: near "DECLARE": syntax error
Error: near line 593: cannot rollback - no transaction is active
Error: near line 594: near "SIGNAL": syntax error
Error: near line 595: cannot commit - no transaction is active
Error: near line 597: near "START": syntax error
Error: near line 600: near "INTO": syntax error
Error: near line 607: near "IF": syntax error
Error: near line 609: near "IF": syntax error
Error: near line 612: no such table: registration
Error: near line 618: no such column: v_ID_class
Error: near line 623: cannot commit - no transaction is active
Error: near line 624: near "/": syntax error

https://ideone.com/HanF8B

language:

SQLite (sqlite 3.27.2)

created:

visibility:

public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!

Discover > Sphere Engine API

Discover > IDE Widget

Choose your language