File indexing completed on 2024-04-28 13:54:22
0001 0002 INSERT INTO `pling`.`tag_group` (`group_id`, `group_name`, `group_display_name`, `is_multi_select`) VALUES ('34', 'desktop-environments', 'Desktop Environments KDE/GNOME/XFCE...', '0'); 0003 0004 0005 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-kde', 'KDE Plasma', '1'); 0006 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-gnome', 'GNOME', '1'); 0007 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-xfce', 'XFCE', '1'); 0008 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-cinnamon', 'Cinnamon', '1'); 0009 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-mate', 'Mate', '1'); 0010 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-next', 'Next', '1'); 0011 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-budgie', 'Budgie', '1'); 0012 INSERT INTO `tag` (`tag_name`, `tag_fullname`, `is_active`) VALUES ('desktop-env-enlightenment', 'Enlightenment', '1'); 0013 0014 0015 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5741); 0016 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5742); 0017 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5743); 0018 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5744); 0019 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5745); 0020 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5746); 0021 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5747); 0022 insert into tag_group_item(tag_group_id,tag_id) values( 34, 5748); 0023 0024 0025 0026 CREATE TABLE `tag_rating` ( 0027 `tag_rating_id` INT(11) NOT NULL AUTO_INCREMENT, 0028 `project_id` INT(11) NOT NULL, 0029 `member_id` INT(11) NOT NULL, 0030 `tag_id` INT(11) NOT NULL, 0031 `comment_id` INT(11) NOT NULL, 0032 `vote` INT(1) NOT NULL comment '1 = like -1 = dislike 0=neutral', 0033 `is_deleted` INT(1) NOT NULL DEFAULT 0, 0034 `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, 0035 `deleted_at` TIMESTAMP NULL DEFAULT NULL, 0036 PRIMARY KEY (`tag_rating_id`) 0037 ) 0038 ; 0039 0040 0041 ALTER TABLE `tag_rating` 0042 ADD INDEX `idx_tag_rating_1` (`comment_id`); 0043