SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_awards
-- ----------------------------
DROP TABLE IF EXISTS `tbl_awards`;
CREATE TABLE `tbl_awards` (
`award_id` int(11) NOT NULL AUTO_INCREMENT,
`award_name` varchar(255) NOT NULL,
`contestant_id` int(11) NOT NULL,
`award_year` year(4) DEFAULT NULL,
`round_id` int(11) DEFAULT NULL,
PRIMARY KEY (`award_id`),
KEY `contestant_id` (`contestant_id`),
KEY `round_id` (`round_id`),
CONSTRAINT `tbl_awards_ibfk_1` FOREIGN KEY (`contestant_id`) REFERENCES `tbl_contestants` (`contestant_id`),
CONSTRAINT `tbl_awards_ibfk_2` FOREIGN KEY (`round_id`) REFERENCES `tbl_rounds` (`round_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_awards
-- ----------------------------
BEGIN;
INSERT INTO `tbl_awards` (`award_id`, `award_name`, `contestant_id`, `award_year`, `round_id`) VALUES (1, 'ขวัญใจช่างภาพ', 5, 2025, 3);
INSERT INTO `tbl_awards` (`award_id`, `award_name`, `contestant_id`, `award_year`, `round_id`) VALUES (2, 'Miss HartBeat', 3, 2025, 3);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_contestants
-- ----------------------------
DROP TABLE IF EXISTS `tbl_contestants`;
CREATE TABLE `tbl_contestants` (
`contestant_id` int(11) NOT NULL AUTO_INCREMENT,
`contestant_number` varchar(10) NOT NULL,
`full_name` varchar(255) NOT NULL,
`contestant_detail` varchar(255) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL,
PRIMARY KEY (`contestant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_contestants
-- ----------------------------
BEGIN;
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (1, 'MT01', 'อรอุมา สิทธิรักษ์', NULL, 1);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (2, 'MT02', 'นัฐฐชาช์ บุญประชม', NULL, 1);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (3, 'MT03', 'พรทิพย์ นาคหิรัญกนก', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (4, 'MT04', 'ชาริสา บัวทอง', NULL, 1);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (5, 'MT05', 'อรัญญา อุดมแก้ว', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (6, 'MT06', 'รุ่งทิวา วงศ์สว่าง', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (7, 'MT07', 'ชนิกา ลิขิตธนะสมบัติ', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (8, 'MT08', 'สุดารัตน์ น้อยสี', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (9, 'MT09', 'ณัฐชา อินทรวงศ์', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (10, 'MT10', 'กุลธิดา พลอยนารี', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_criteria
-- ----------------------------
DROP TABLE IF EXISTS `tbl_criteria`;
CREATE TABLE `tbl_criteria` (
`criteria_id` int(11) NOT NULL AUTO_INCREMENT,
`round_id` int(11) NOT NULL,
`criteria_name` varchar(255) NOT NULL,
`weight` decimal(5,2) NOT NULL,
PRIMARY KEY (`criteria_id`),
KEY `round_id` (`round_id`),
CONSTRAINT `tbl_criteria_ibfk_1` FOREIGN KEY (`round_id`) REFERENCES `tbl_rounds` (`round_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_criteria
-- ----------------------------
BEGIN;
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (1, 1, 'การเดิน', 10.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (2, 1, 'การโพสท่า', 10.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (3, 1, 'ความสง่างาม', 80.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (4, 2, 'ความสามารถ', 50.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (5, 2, 'การตอบคำถาม', 50.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (6, 3, 'การตอบ keyword', 100.00);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_judges
-- ----------------------------
DROP TABLE IF EXISTS `tbl_judges`;
CREATE TABLE `tbl_judges` (
`judge_id` int(11) NOT NULL AUTO_INCREMENT,
`full_name` varchar(255) NOT NULL,
PRIMARY KEY (`judge_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_judges
-- ----------------------------
BEGIN;
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (1, 'คนที่ 1');
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (2, 'คนที่ 2');
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (3, 'คนที่ 3');
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (4, 'คนที่ 4');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_rounds
-- ----------------------------
DROP TABLE IF EXISTS `tbl_rounds`;
CREATE TABLE `tbl_rounds` (
`round_id` int(11) NOT NULL AUTO_INCREMENT,
`name_contest` varchar(255) NOT NULL,
`round_name` varchar(100) NOT NULL,
`number_to_advance` int(11) NOT NULL,
`is_active` tinyint(1) NOT NULL,
PRIMARY KEY (`round_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_rounds
-- ----------------------------
BEGIN;
INSERT INTO `tbl_rounds` (`round_id`, `name_contest`, `round_name`, `number_to_advance`, `is_active`) VALUES (1, 'Freshy Contest 2005', 'รอบที่ 1: ชุดไทยและชุดราตรี', 10, 0);
INSERT INTO `tbl_rounds` (`round_id`, `name_contest`, `round_name`, `number_to_advance`, `is_active`) VALUES (2, 'Freshy Contest 2005', 'รอบที่ 2: ความสามารถและไหวพริบ', 7, 0);
INSERT INTO `tbl_rounds` (`round_id`, `name_contest`, `round_name`, `number_to_advance`, `is_active`) VALUES (3, 'Freshy Contest 2005', 'รอบที่ 3: ตอบคำถาม', 5, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tbl_scores
-- ----------------------------
DROP TABLE IF EXISTS `tbl_scores`;
CREATE TABLE `tbl_scores` (
`score_id` int(11) NOT NULL AUTO_INCREMENT,
`contestant_id` int(11) NOT NULL COMMENT 'ผู้เข้าประกวด',
`criteria_id` int(11) NOT NULL COMMENT 'เกณ์ข้อที่',
`judge_id` int(11) NOT NULL COMMENT 'กรรมการคนที่',
`round_id` int(11) NOT NULL COMMENT 'รอบที่',
`raw_score` decimal(3,1) NOT NULL,
PRIMARY KEY (`score_id`),
KEY `contestant_id` (`contestant_id`),
KEY `criteria_id` (`criteria_id`),
KEY `judge_id` (`judge_id`),
CONSTRAINT `tbl_scores_ibfk_1` FOREIGN KEY (`contestant_id`) REFERENCES `tbl_contestants` (`contestant_id`),
CONSTRAINT `tbl_scores_ibfk_2` FOREIGN KEY (`criteria_id`) REFERENCES `tbl_criteria` (`criteria_id`),
CONSTRAINT `tbl_scores_ibfk_3` FOREIGN KEY (`judge_id`) REFERENCES `tbl_judges` (`judge_id`)
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tbl_scores
-- ----------------------------
BEGIN;
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (1, 1, 1, 1, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (2, 1, 2, 1, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (3, 1, 3, 1, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (4, 2, 1, 1, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (5, 2, 2, 1, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (6, 2, 3, 1, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (7, 3, 1, 1, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (8, 3, 2, 1, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (9, 3, 3, 1, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (10, 4, 1, 1, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (11, 4, 2, 1, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (12, 4, 3, 1, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (13, 5, 1, 1, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (14, 5, 2, 1, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (15, 5, 3, 1, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (16, 6, 1, 1, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (17, 6, 2, 1, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (18, 6, 3, 1, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (19, 7, 1, 1, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (20, 7, 2, 1, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (21, 7, 3, 1, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (22, 8, 1, 1, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (23, 8, 2, 1, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (24, 8, 3, 1, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (25, 9, 1, 1, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (26, 9, 2, 1, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (27, 9, 3, 1, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (28, 10, 1, 1, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (29, 10, 2, 1, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (30, 10, 3, 1, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (31, 1, 1, 2, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (32, 1, 2, 2, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (33, 1, 3, 2, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (34, 2, 1, 2, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (35, 2, 2, 2, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (36, 2, 3, 2, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (37, 3, 1, 2, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (38, 3, 2, 2, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (39, 3, 3, 2, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (40, 4, 1, 2, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (41, 4, 2, 2, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (42, 4, 3, 2, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (43, 5, 1, 2, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (44, 5, 2, 2, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (45, 5, 3, 2, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (46, 6, 1, 2, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (47, 6, 2, 2, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (48, 6, 3, 2, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (49, 7, 1, 2, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (50, 7, 2, 2, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (51, 7, 3, 2, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (52, 8, 1, 2, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (53, 8, 2, 2, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (54, 8, 3, 2, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (55, 9, 1, 2, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (56, 9, 2, 2, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (57, 9, 3, 2, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (58, 10, 1, 2, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (59, 10, 2, 2, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (60, 10, 3, 2, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (61, 1, 1, 3, 1, 30.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (62, 1, 2, 3, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (63, 1, 3, 3, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (64, 2, 1, 3, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (65, 2, 2, 3, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (66, 2, 3, 3, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (67, 3, 1, 3, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (68, 3, 2, 3, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (69, 3, 3, 3, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (70, 4, 1, 3, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (71, 4, 2, 3, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (72, 4, 3, 3, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (73, 5, 1, 3, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (74, 5, 2, 3, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (75, 5, 3, 3, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (76, 6, 1, 3, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (77, 6, 2, 3, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (78, 6, 3, 3, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (79, 7, 1, 3, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (80, 7, 2, 3, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (81, 7, 3, 3, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (82, 8, 1, 3, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (83, 8, 2, 3, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (84, 8, 3, 3, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (85, 9, 1, 3, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (86, 9, 2, 3, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (87, 9, 3, 3, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (88, 10, 1, 3, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (89, 10, 2, 3, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (90, 10, 3, 3, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (91, 1, 1, 4, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (92, 1, 2, 4, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (93, 1, 3, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (94, 2, 1, 4, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (95, 2, 2, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (96, 2, 3, 4, 1, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (97, 3, 1, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (98, 3, 2, 4, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (99, 3, 3, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (100, 4, 1, 4, 1, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (101, 4, 2, 4, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (102, 4, 3, 4, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (103, 5, 1, 4, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (104, 5, 2, 4, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (105, 5, 3, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (106, 6, 1, 4, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (107, 6, 2, 4, 1, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (108, 6, 3, 4, 1, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (109, 7, 1, 4, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (110, 7, 2, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (111, 7, 3, 4, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (112, 8, 1, 4, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (113, 8, 2, 4, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (114, 8, 3, 4, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (115, 9, 1, 4, 1, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (116, 9, 2, 4, 1, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (117, 9, 3, 4, 1, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (118, 10, 1, 4, 1, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (119, 10, 2, 4, 1, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (120, 10, 3, 4, 1, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (121, 1, 4, 1, 2, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (122, 1, 5, 1, 2, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (123, 2, 4, 1, 2, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (124, 2, 5, 1, 2, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (127, 4, 4, 1, 2, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (128, 4, 5, 1, 2, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (133, 7, 4, 1, 2, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (134, 7, 5, 1, 2, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (139, 10, 4, 1, 2, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (140, 10, 5, 1, 2, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (141, 1, 4, 2, 2, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (142, 1, 5, 2, 2, 9.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (143, 2, 4, 2, 2, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (144, 2, 5, 2, 2, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (147, 4, 4, 2, 2, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (148, 4, 5, 2, 2, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (153, 7, 4, 2, 2, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (154, 7, 5, 2, 2, 8.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (159, 10, 4, 2, 2, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (160, 10, 5, 2, 2, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (161, 1, 4, 3, 2, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (162, 1, 5, 3, 2, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (163, 2, 4, 3, 2, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (164, 2, 5, 3, 2, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (167, 4, 4, 3, 2, 6.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (168, 4, 5, 3, 2, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (173, 7, 4, 3, 2, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (174, 7, 5, 3, 2, 1.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (179, 10, 4, 3, 2, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (180, 10, 5, 3, 2, 4.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (181, 1, 4, 4, 2, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (182, 1, 5, 4, 2, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (183, 2, 4, 4, 2, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (184, 2, 5, 4, 2, 10.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (187, 4, 4, 4, 2, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (188, 4, 5, 4, 2, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (193, 7, 4, 4, 2, 3.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (194, 7, 5, 4, 2, 5.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (199, 10, 4, 4, 2, 7.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (200, 10, 5, 4, 2, 2.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (201, 1, 1, 1, 3, 70.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (202, 2, 1, 1, 3, 80.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (203, 4, 1, 1, 3, 98.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (204, 1, 1, 2, 3, 95.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (205, 2, 1, 2, 3, 66.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (206, 4, 1, 2, 3, 80.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (207, 1, 1, 3, 3, 77.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (208, 2, 1, 3, 3, 88.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (209, 4, 1, 3, 3, 33.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (210, 1, 1, 4, 3, 77.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (211, 2, 1, 4, 3, 99.0);
INSERT INTO `tbl_scores` (`score_id`, `contestant_id`, `criteria_id`, `judge_id`, `round_id`, `raw_score`) VALUES (212, 4, 1, 4, 3, 64.0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
    SET FOREIGN_KEY_CHECKS = 0;
BEGIN;
INSERT INTO `tbl_rounds` (`round_id`, `name_contest`, `round_name`, `number_to_advance`, `is_active`) VALUES (1, 'Freshy Contest 2005', 'รอบที่ 1: ชุดไทยและชุดราตรี', 10, 0);
INSERT INTO `tbl_rounds` (`round_id`, `name_contest`, `round_name`, `number_to_advance`, `is_active`) VALUES (2, 'Freshy Contest 2005', 'รอบที่ 2: ความสามารถและไหวพริบ', 7, 0);
INSERT INTO `tbl_rounds` (`round_id`, `name_contest`, `round_name`, `number_to_advance`, `is_active`) VALUES (3, 'Freshy Contest 2005', 'รอบที่ 3: ตอบคำถาม', 5, 1);
COMMIT;

BEGIN;
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (1, 'คนที่ 1');
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (2, 'คนที่ 2');
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (3, 'คนที่ 3');
INSERT INTO `tbl_judges` (`judge_id`, `full_name`) VALUES (4, 'คนที่ 4');
COMMIT;

BEGIN;
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (1, 1, 'การเดิน', 10.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (2, 1, 'การโพสท่า', 10.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (3, 1, 'ความสง่างาม', 80.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (4, 2, 'ความสามารถ', 50.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (5, 2, 'การตอบคำถาม', 50.00);
INSERT INTO `tbl_criteria` (`criteria_id`, `round_id`, `criteria_name`, `weight`) VALUES (6, 3, 'การตอบ keyword', 100.00);
COMMIT;
BEGIN;
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (1, 'MT01', 'อรอุมา สิทธิรักษ์', NULL, 1);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (2, 'MT02', 'นัฐฐชาช์ บุญประชม', NULL, 1);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (3, 'MT03', 'พรทิพย์ นาคหิรัญกนก', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (4, 'MT04', 'ชาริสา บัวทอง', NULL, 1);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (5, 'MT05', 'อรัญญา อุดมแก้ว', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (6, 'MT06', 'รุ่งทิวา วงศ์สว่าง', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (7, 'MT07', 'ชนิกา ลิขิตธนะสมบัติ', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (8, 'MT08', 'สุดารัตน์ น้อยสี', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (9, 'MT09', 'ณัฐชา อินทรวงศ์', NULL, 0);
INSERT INTO `tbl_contestants` (`contestant_id`, `contestant_number`, `full_name`, `contestant_detail`, `is_active`) VALUES (10, 'MT10', 'กุลธิดา พลอยนารี', NULL, 0);
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;