Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Changeset 5021

Show
Ignore:
Timestamp:
07/23/08 18:45:08 (6 months ago)
Author:
bwolfe
Message:

Fixing update sql script to account for databases that have View Patient Programs role already defined - #931

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • openmrs/trunk/metadata/model/update-to-latest-db.mysqldiff.sql

    r4845 r5021  
    994994         
    995995        set FOREIGN_KEY_CHECKS = 0; 
    996     insert into role_privilege (role, privilege) select distinct role, 'View Patient Programs' from role_privilege where privilege = 'Manage Patient Programs'; 
    997         insert into role_privilege (role, privilege) select distinct role, 'Edit Patient Programs' from role_privilege where privilege = 'Manage Patient Programs'; 
     996         
     997    insert into role_privilege (role, privilege) select distinct role, 'View Patient Programs' from role_privilege rp where privilege = 'Manage Patient Programs' and not exists (select * from role_privilege where role = rp.role and privilege = 'View Patient Programs'); 
     998        insert into role_privilege (role, privilege) select distinct role, 'Edit Patient Programs' from role_privilege rp where privilege = 'Manage Patient Programs' and not exists (select * from role_privilege where role = rp.role and privilege = 'Edit Patient Programs'); 
    998999        update role_privilege set privilege = 'Delete Patient Programs' where privilege = 'Manage Patient Programs'; 
    9991000