Skip to content
Snippets Groups Projects
Select Git revision
  • 21c26534fc8fab6fe6fb8963b9665050d3edd1b9
  • master default protected
  • test
  • release_10.3.0
  • feature_module_doctorant
  • feature_module_admission
  • feature_fiche_rncp
  • feature_convention_mel_template
  • release_10.2.0
  • release_10.1.1
  • feature_portfolio
  • ameliorations_index_rapporteur
  • feature_flux_diplomation
  • feature_formation_export_xls
  • feature_fichiers
  • api_inscription_admin
  • feature_module_unicaen_maintenance_mode
  • dev
  • feature_renderer_template_variables
  • feature_notif_forcage_correc
  • feature_wf_rapport_activite
  • 10.2.1
  • 10.2.0
  • 10.1.0
  • 10.0.3
  • 10.0.2
  • 10.0.1
  • 10.0.0
  • 9.4.1
  • 9.4.0
  • 9.3.1
  • 9.3.0
  • 9.2.1
  • 9.2.0
  • 9.1.1
  • 9.1.0
  • 9.0.1
  • 9.0.0
  • 8.6.0
  • 8.5.1
  • 8.5.0
41 results

create-version-file.sh

Blame
    • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    002.privilege.sql 3.33 KiB 
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
VALUES ('autoformindex','Autoform - Gestion de l''index',5000,'UnicaenAutoform\Provider\Privilege');
INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
WITH d(code, lib, ordre) AS (
    SELECT 'index', 'Afficher le menu', 10
)
SELECT cp.id, d.code, d.lib, d.ordre
FROM d
JOIN unicaen_privilege_categorie cp ON cp.CODE = 'autoformindex';

INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
VALUES ('autoformformulaire','Autoform - Gestion des formulaires',5100,'UnicaenAutoform\Provider\Privilege');
INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
WITH d(code, lib, ordre) AS (
    SELECT 'formulaire_index', 'Accéder à l''index', 10 UNION
    SELECT 'formulaire_afficher', 'Afficher', 20 UNION
    SELECT 'formulaire_ajouter', 'Ajouter', 30 UNION
    SELECT 'formulaire_modifier', 'Modifier', 40 UNION
    SELECT 'formulaire_historiser', 'Historiser/Restaurer', 50 UNION
    SELECT 'formulaire_supprimer', 'Supprimer', 60
)
SELECT cp.id, d.code, d.lib, d.ordre
FROM d
JOIN unicaen_privilege_categorie cp ON cp.CODE = 'autoformformulaire';

INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
VALUES ('autoformcategorie','Autoform - Gestion des catégories',5200,'UnicaenAutoform\Provider\Privilege');
INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
WITH d(code, lib, ordre) AS (
    SELECT 'categorief_index', 'Accéder à l''index', 10 UNION
    SELECT 'categorief_afficher', 'Afficher', 20 UNION
    SELECT 'categorief_ajouter', 'Ajouter', 30 UNION
    SELECT 'categorief_modifier', 'Modifier', 40 UNION
    SELECT 'categorief_historiser', 'Historiser/Restaurer', 50 UNION
    SELECT 'categorief_supprimer', 'Supprimer', 60
)
SELECT cp.id, d.code, d.lib, d.ordre
FROM d
JOIN unicaen_privilege_categorie cp ON cp.CODE = 'autoformcategorie';

INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
VALUES ('autoformchamp','Autoform - Gestion des champs',5300,'UnicaenAutoform\Provider\Privilege');
INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
WITH d(code, lib, ordre) AS (
    SELECT 'champ_index', 'Accéder à l''index', 10 UNION
    SELECT 'champ_afficher', 'Afficher', 20 UNION
    SELECT 'champ_ajouter', 'Ajouter', 30 UNION
    SELECT 'champ_modifier', 'Modifier', 40 UNION
    SELECT 'champ_historiser', 'Historiser/Restaurer', 50 UNION
    SELECT 'champ_supprimer', 'Supprimer', 60
)
SELECT cp.id, d.code, d.lib, d.ordre
FROM d
JOIN unicaen_privilege_categorie cp ON cp.CODE = 'autoformchamp';

INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
VALUES ('autoformvalidation','Autoform - Gestion des validations',5400,'UnicaenAutoform\Provider\Privilege');
INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
WITH d(code, lib, ordre) AS (
    SELECT 'validationf_index', 'Accéder à l''index', 10 UNION
    SELECT 'validationf_afficher', 'Afficher', 20 UNION
    SELECT 'validationf_ajouter', 'Ajouter', 30 UNION
    SELECT 'validationf_modifier', 'Modifier', 40 UNION
    SELECT 'validationf_historiser', 'Historiser/Restaurer', 50 UNION
    SELECT 'validationf_supprimer', 'Supprimer', 60
)
SELECT cp.id, d.code, d.lib, d.ordre
FROM d
JOIN unicaen_privilege_categorie cp ON cp.CODE = 'autoformchamp';