Skip to content
Snippets Groups Projects
Select Git revision
  • 15920a01bdb91cb338cd56c39ab0ec16a56db828
  • master default protected
  • release/8.0-perimetres
  • php84
  • detached3
  • 6.x
  • 7.x
  • detached2
  • detached
  • php82
  • 5.x
  • cherry-pick-bf3b5271
  • v5.x-test
  • laminas_migration
  • 7.2.8
  • 7.2.7
  • 7.2.6
  • 7.2.5
  • 7.2.4
  • 7.2.3
  • 7.2.2
  • 7.2.1
  • 7.2.0
  • 7.1.3
  • 7.1.2
  • 7.1.1
  • 7.1.0
  • 7.0.1
  • 7.0.0
  • 6.1.11
  • 6.1.10
  • 6.1.9
  • 6.1.8
  • 6.1.7
34 results

001_tables.sql

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    002_privileges.sql 1.85 KiB
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
    VALUES ('documentmacro', 'Gestion des macros ', 1000, 'UnicaenRenderer\Provider\Privilege');
    INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
    WITH d(code, lib, ordre) AS (
        SELECT 'documentmacro_index', 'Accéder à l''index', 0 UNION
        SELECT 'documentmacro_ajouter', 'Ajouter', 10 UNION
        SELECT 'documentmacro_modifier', 'Modifier', 20 UNION
        SELECT 'documentmacro_supprimer', 'Supprimer', 50
    )
    SELECT cp.id, d.code, d.lib, d.ordre
    FROM d
    JOIN unicaen_privilege_categorie cp ON cp.CODE = 'documentmacro';
    
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
    VALUES ('documenttemplate', 'Gestion des templates ', 1100, 'UnicaenRenderer\Provider\Privilege');
    INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
    WITH d(code, lib, ordre) AS (
        SELECT 'documenttemplate_index', 'Accéder à l''index', 0 UNION
        SELECT 'documenttemplate_ajouter', 'Ajouter', 10 UNION
        SELECT 'documenttemplate_modifier', 'Modifier', 20 UNION
        SELECT 'documenttemplate_supprimer', 'Supprimer', 50
    )
    SELECT cp.id, d.code, d.lib, d.ordre
    FROM d
    JOIN unicaen_privilege_categorie cp ON cp.CODE = 'documenttemplate';
    
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
    VALUES ('documentcontenu', 'Gestion des rendus ', 1200, 'UnicaenRenderer\Provider\Privilege');
    INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
    WITH d(code, lib, ordre) AS (
        SELECT 'documentcontenu_index', 'Accéder à l''index', 0 UNION
        SELECT 'documentcontenu_ajouter', 'Ajouter', 10 UNION
        SELECT 'documentcontenu_modifier', 'Modifier', 20 UNION
        SELECT 'documentcontenu_supprimer', 'Supprimer', 50
    )
    SELECT cp.id, d.code, d.lib, d.ordre
    FROM d
    JOIN unicaen_privilege_categorie cp ON cp.CODE = 'documentcontenu';