"Fossies" - the Fresh Open Source Software Archive

Member "tiki-21.2/installer/schema/20081010_filter_perms_tiki.sql" (29 Jul 2020, 1817 Bytes) of package /linux/www/tiki-21.2.tar.xz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 # 2008-10-10 lphuberdeau
    2 ALTER TABLE users_permissions ADD COLUMN feature_check VARCHAR(50) NULL;
    3 
    4 UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE `permName` IN(
    5     'tiki_p_admin_wiki',
    6     'tiki_p_assign_perm_wiki_page',
    7     'tiki_p_edit',
    8     'tiki_p_export_wiki',
    9     'tiki_p_lock',
   10     'tiki_p_minor',
   11     'tiki_p_remove',
   12     'tiki_p_rename',
   13     'tiki_p_rollback',
   14     'tiki_p_view',
   15     'tiki_p_view_history',
   16     'tiki_p_view_source'
   17 );
   18 UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE `permName` = 'tiki_p_edit_copyrights';
   19 UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE `permName` = 'tiki_p_edit_structures';
   20 UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE `permName` = 'tiki_p_watch_structure';
   21 UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE `permName` = 'tiki_p_upload_picture';
   22 UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE `permName` = 'tiki_p_use_as_template';
   23 UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE `permName` = 'tiki_p_admin_attachments';
   24 UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE `permName` = 'tiki_p_attach_files';
   25 UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE `permName` = 'tiki_p_wiki_view_attachments';
   26 UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE `permName` = 'tiki_p_admin_ratings';
   27 UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE `permName` = 'tiki_p_wiki_view_ratings';
   28 UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE `permName` = 'tiki_p_wiki_vote_ratings';
   29 UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE `permName` = 'tiki_p_wiki_view_comments';
   30