Revize 183
Přidáno uživatelem Tomáš Dulík před více než 15 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
}
|
||
|
|
||
|
$upgrade_sql[get_SVN_rev()] = array(
|
||
|
"ALTER TABLE `money_transfer_bank_infos` ADD COLUMN `comment` VARCHAR(255) after `date_time`;",
|
||
|
"UPDATE `freenetis`.`aco` SET `value` = 'administration',
|
||
|
`name` = 'Freenetis administration' WHERE `aco`.`id` =31 LIMIT 1 ;",
|
||
|
"INSERT INTO `aco_map` (`acl_id`, `section_value`, `value`) VALUES
|
||
|
(26, 'menu', 'administration'),
|
||
|
(26, 'menu', 'reports'),
|
||
|
(26, 'menu', 'registration_admin');",
|
||
|
"ALTER TABLE `money_transfer_bank_infos` ADD COLUMN `comment` VARCHAR(255) after `date_time`;",
|
||
|
"ALTER TABLE `accounts` DROP COLUMN `number` VARCHAR(255) after `name`;",
|
||
|
"ALTER TABLE `accounts` CHANGE `owner_id` `member_id` INT( 11 ) NULL DEFAULT NULL ;",
|
||
|
"CREATE TABLE bank_accounts (
|
||
Také k dispozici: Unified diff
Uprava databaze - přidání práv administrátorům Freenetisu na nové menu "Administration"