Ghislain Loas
--- a/cosmogramme/sql/patch/patch_246.php
+++ b/cosmogramme/sql/patch/patch_246.php
+<?php
+$adapter = Zend_Registry::get('sql');
+
+$adapter->query("CREATE TABLE IF NOT EXISTS `permission` ( id INT(11) unsigned NOT NULL AUTO_INCREMENT, code varchar(255) NOT NULL, module varchar(255) NOT NULL, type varchar(255) NOT NULL, sorting int(11) NOT NULL, description text NULL, PRIMARY KEY (id), KEY (code), KEY (module), KEY (type), KEY (sorting)) ENGINE = MYISAM, character set=UTF8;");
+
+$adapter->query("insert into `permission` (code, module, type, sorting, description) SELECT 'CATEGORY', 'ARTICLE', 'Droits', 1, 'Créer des sous-catégories et des articles' from `permission` WHERE NOT EXISTS (SELECT * FROM `permission` WHERE code = 'CATEGORY') LIMIT 1;");