ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `part_type` VARCHAR(10) NOT NULL DEFAULT '' COMMENT 'cpu/gpu/ssd/hdd/ram';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `brand` VARCHAR(30) NOT NULL DEFAULT '';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `model_name` VARCHAR(190) NOT NULL DEFAULT '';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `user_rating` SMALLINT NOT NULL DEFAULT 0 COMMENT 'percent';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `value_score` DECIMAL(6,1) NOT NULL DEFAULT 0.0 COMMENT 'percent';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `avg_bench` DECIMAL(6,1) NOT NULL DEFAULT 0.0 COMMENT 'percent';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `market_share` DECIMAL(6,2) NOT NULL DEFAULT 0.00 COMMENT 'percent';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `age_months` SMALLINT NOT NULL DEFAULT 0;
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `price_krw` INT NOT NULL DEFAULT 0;
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `sample_count` INT NOT NULL DEFAULT 0;
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `source_site` VARCHAR(30) NOT NULL DEFAULT '';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `source_id` VARCHAR(80) NOT NULL DEFAULT '';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `source_url` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `last_sync_at` DATETIME NULL;
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `cpu_mem_pts` DECIMAL(6,1) NOT NULL DEFAULT 0.0;
ALTER TABLE `rebuilder_write_pc_benchmark` ADD COLUMN `cpu_8core_pts` DECIMAL(6,1) NOT NULL DEFAULT 0.0;
CREATE INDEX bb_idx_part_type ON `rebuilder_write_pc_benchmark` (part_type);
CREATE INDEX bb_idx_brand ON `rebuilder_write_pc_benchmark` (brand);
CREATE INDEX bb_idx_price ON `rebuilder_write_pc_benchmark` (price_krw);
CREATE INDEX bb_idx_avg_bench ON `rebuilder_write_pc_benchmark` (avg_bench);
CREATE INDEX bb_idx_value_score ON `rebuilder_write_pc_benchmark` (value_score);
CREATE UNIQUE INDEX bb_uid_source ON `rebuilder_write_pc_benchmark` (source_site, source_id);