FreenetIS

<?php

function get_SVN_rev() {

$svnid = '$Rev: 212 $';

$svnid = substr($svnid , 6);

$svnid = substr($svnid , 0, -2);

return $svnid;

}

$upgrade_sql[get_SVN_rev()] = array(

"INSERT INTO `acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES

(57, 'user', 1, 1, '', 'Administratori systemu mohou spravovat zneni prekladu a veskere nastaveni systemu.', 1245231523),

(58, 'user', 1, 1, '', 'Certifikovani technici mohou prohlizet, pridavat a editovat vsechny cleny.', 1245225441),

(59, 'user', 1, 1, '', 'Certifikovani technici maji pravo spravovat uzivatele.', 1245225558);",

"UPDATE `acl` set `note` = 'Certifikovani technici vidi v menu Sit a Cleny.' where `id` = 48 LIMIT 1;",

"UPDATE `acl_seq` SET `id` = 59 WHERE `acl_seq`.`id` = 56 LIMIT 1;",

"INSERT INTO `aco_map` (`acl_id`, `section_value`, `value`) VALUES

(48, 'menu', 'users_members'),

(57, 'freenetis', 'delete_all'),

(57, 'freenetis', 'edit_all'),

(57, 'freenetis', 'new_all'),

(57, 'freenetis', 'view_all'),

(58, 'freenetis', 'edit_all'),

(58, 'freenetis', 'new_all'),

(58, 'freenetis', 'view_all'),

(59, 'freenetis', 'delete_all'),

(59, 'freenetis', 'edit_all'),

(59, 'freenetis', 'new_all'),

(59, 'freenetis', 'view_all');",

"INSERT INTO `aro_groups_map` (`acl_id`, `group_id`) VALUES

(57, 32),

(58, 29),

(59, 29);",

"INSERT INTO `axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(126, 'Translations_Controller', 'translation', 0, 'Preklad', 0),

(127, 'Settings_Controller', 'system', 0, 'Nastaveni systemu', 0),

(128, 'Users_Controller', 'member', 0, 'Clen', 0);",

"INSERT INTO `axo_map` (`acl_id`, `section_value`, `value`) VALUES (38, 'Users_Controller', 'member');",

"INSERT INTO `axo_map` (`acl_id`, `section_value`, `value`) VALUES

(57, 'Settings_Controller', 'system'),

(57, 'Translations_Controller', 'translation'),

(58, 'Members_Controller', 'members'),

(59, 'Users_Controller', 'comment'),

(59, 'Users_Controller', 'name'),

(59, 'Users_Controller', 'password'),

(59, 'Users_Controller', 'surname'),

(59, 'Users_Controller', 'users');",

"INSERT INTO `axo_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES

(18, 'Translations_Controller', 1, 'Preklady', 0),

(19, 'Settings_Controller', 1, 'Nastaveni', 0);",

"UPDATE `axo_sections_seq` SET `id` = 19 WHERE `axo_sections_seq`.`id` =17 LIMIT 1;",

"UPDATE `axo_seq` SET `id` = 128 WHERE `axo_seq`.`id` =124 LIMIT 1;",

"ALTER TABLE `money_transfer_bank_infos` ADD COLUMN `transfer_id` INT( 11 ) AFTER `id`;",

"CREATE TABLE `membership_interrupts` (

`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`member_id` INT( 11 ) NOT NULL ,

`from` DATETIME NOT NULL ,

`to` DATETIME NOT NULL ,

`comment` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,

PRIMARY KEY ( `id` )

) ENGINE = InnoDB"

);

?>

"INSERT INTO `aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES (33, 22, 15, 16, 'Uzivatele radnych clenu', 'uzivatele');"