xref: /dports/www/tikiwiki/tiki-21.2/installer/schema/20100104_tiki_p_tracker_revote_ratings_tiki.sql

SET @pcant=0;
SELECT (@pcant:=count(*)) FROM users_permissions WHERE `permName` = 'tiki_p_tracker_revote_ratings';
INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_tracker_revote_ratings', 'Can re-vote a rating for tracker items', 'registered', 'trackers');
INSERT INTO users_objectpermissions (`groupName`, `permName`,`objectType`, `objectId`)  select `groupName`, 'tiki_p_tracker_revote_ratings', `objectType` , `objectId` FROM users_objectpermissions where `permName`='tiki_p_tracker_vote_ratings' AND @pcant=0;
INSERT INTO users_grouppermissions (`groupName`, `permName`)  select `groupName`, 'tiki_p_tracker_revote_ratings' FROM users_grouppermissions where `permName`='tiki_p_tracker_vote_ratings' AND @pcant=0;