Update of /cvs/scoop/scoop/struct/patch-files/current In directory lithium.sabren.com:/tmp/cvs-serv31932/struct/patch-files/current Modified Files: README patch-30-TagEnhancements.sql Added Files: patch-31-TagPermUpdate.sql Log Message: Removing Sourceforge references from the default scoop.sql file, removing some junk from patch-30, and adding a patch for a perm that was missing from patch 30. Ooops. -j Index: README =================================================================== RCS file: /cvs/scoop/scoop/struct/patch-files/current/README,v retrieving revision 1.118 retrieving revision 1.119 diff -C2 -d -r1.118 -r1.119 *** README 15 Jan 2006 19:01:44 -0000 1.118 --- README 15 Jan 2006 22:31:42 -0000 1.119 *************** *** 142,145 **** --- 142,150 ---- "comment_controls" box is a good place. + Jan 15 14:53 patch-31-TagPermUpdate.sql + Adds a perm, 'edit_story_tags', that was left out of patch 30. If you + wish to allow trusted users, but not others, edit story tags, add + 'edit_story_tags' to the var 'tu_perms'. + Any problems, email scoop-help at lists.kuro5hin.org (don't forget to join!) join here: http://lists.kuro5hin.org/mailman/listinfo/scoop-help --- NEW FILE: patch-31-TagPermUpdate.sql --- UPDATE vars SET value = CONCAT(value,',\nedit_story_tags') where name = 'perms'; UPDATE perm_groups SET group_perms = CONCAT(group_perms,',edit_story_tags') WHERE perm_group_id IN ('Superuser','Admins','Editors'); Index: patch-30-TagEnhancements.sql =================================================================== RCS file: /cvs/scoop/scoop/struct/patch-files/current/patch-30-TagEnhancements.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** patch-30-TagEnhancements.sql 15 Jan 2006 19:01:44 -0000 1.1 --- patch-30-TagEnhancements.sql 15 Jan 2006 22:31:42 -0000 1.2 *************** *** 53,80 **** /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - -- MySQL dump 10.9 - -- - -- Host: 10.250.27.101 Database: thebes - -- ------------------------------------------------------ - -- Server version 4.1.11-Debian_3-log - /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; - /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; - /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */; - /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - - -- - -- Dumping data for table `blocks` - -- - -- WHERE: block in ('tag_template', 'story_template') - - - /*!40000 ALTER TABLE `blocks` DISABLE KEYS */; - LOCK TABLES `blocks` WRITE; - UNLOCK TABLES; - /*!40000 ALTER TABLE `blocks` ENABLE KEYS */; - - /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; - /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; - /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; - /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - --- 53,54 ----