FreenetIS

<?php

$upgrade_sql[241] = array(

"UPDATE `acl` SET `note` = 'Administratori systemu mohou spravovat zneni prekladu a veskere nastaveni.' WHERE `acl`.`id` = 57 LIMIT 1;",

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

(130, 'Settings_Controller', 'economy', 0, 'Ekonomika', 0);",

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

(57, 'Settings_Controller', 'economy');"

);

?>

"INSERT INTO `enum_type_names` (`id`, `type_names`) VALUES (6, `Fees types`);",

"INSERT INTO `enum_types` (`id`, `type_id`, `value`) VALUES

(35, 6, 'regular member fee'),

(36, 6, 'entrance fee'),

(37, 6, 'transfer fee'),

(38, 6, 'bank transfer fee'),

(39, 6, 'penalty');",

"INSERT INTO `translations` (`id`, `original_term`, `translated_term`, `lang`) VALUES

(14, 'regular member fee', 'pravidelný členský příspěvek', 'cs'),

(15, 'entrance fee', 'vstupní příspěvek', 'cs'),

(16, 'transfer fee', 'poplatek za transakci', 'cs'),

(17, 'bank transfer fee', 'poplatek za bankovní transakci', 'cs'),

(18, 'penalty', 'pokuta', 'cs');",

"DROP TABLE `bank_fees`",

"CREATE TABLE IF NOT EXISTS `fees` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`fee` int(11) NOT NULL,

`from` datetime NOT NULL,

`to` datetime NOT NULL,

`type_id` tinyint(4) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;",

"ALTER TABLE `money_transfers` CHANGE `timestamp` `datetime` DATETIME NOT NULL"