Revize 516
Přidáno uživatelem Tomáš Dulík před téměř 15 roky(ů)
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_513.php | ||
---|---|---|
<?php
|
||
$upgrade_sql[get_SVN_rev()] = array(
|
||
"INSERT INTO `enum_types` (
|
||
`id` ,
|
||
`type_id` ,
|
||
`value` ,
|
||
`read_only`
|
||
)
|
||
VALUES (
|
||
NULL , '2', 'AP', '1'
|
||
);
|
||
",
|
||
|
||
"ALTER TABLE `members` DROP `street_number` ,
|
||
DROP `street` ,
|
||
DROP `town` ,
|
||
DROP `quarter` ,
|
||
DROP `ZIP_code` ;
|
||
",
|
||
|
||
"INSERT INTO `acl` (
|
||
`id` ,
|
||
`section_value` ,
|
||
`allow` ,
|
||
`enabled` ,
|
||
`return_value` ,
|
||
`note` ,
|
||
`updated_date`
|
||
)
|
||
VALUES (
|
||
'42', 'user', '1', '1', NULL , 'Regular members can see unidentified transfers.', '1248160179'
|
||
);",
|
||
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'42', 'freenetis', 'view_all'
|
||
);
|
||
",
|
||
|
||
"INSERT INTO `aro_groups_map` (
|
||
`acl_id` ,
|
||
`group_id`
|
||
)
|
||
VALUES (
|
||
'42', '22'
|
||
);
|
||
",
|
||
|
||
"INSERT INTO `axo_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'42', 'Accounts_Controller', 'unidentified_transfers'
|
||
);
|
||
",
|
||
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'34', 'menu', 'unidentified_transfers'
|
||
);"
|
||
|
||
);
|
||
|
||
?>
|
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
---|---|---|
|
||
// array of sql queries that upgrade database
|
||
$upgrade_sql[get_SVN_rev()] = array(
|
||
"INSERT INTO `enum_types` (
|
||
`id` ,
|
||
`type_id` ,
|
||
`value` ,
|
||
`read_only`
|
||
)
|
||
VALUES (
|
||
NULL , '2', 'AP', '1'
|
||
"ALTER TABLE `jobs` CHANGE `description` `description` VARCHAR(65535) NULL DEFAULT NULL"
|
||
);
|
||
",
|
||
|
||
"ALTER TABLE `members` DROP `street_number` ,
|
||
DROP `street` ,
|
||
DROP `town` ,
|
||
DROP `quarter` ,
|
||
DROP `ZIP_code` ;
|
||
",
|
||
|
||
"INSERT INTO `acl` (
|
||
`id` ,
|
||
`section_value` ,
|
||
`allow` ,
|
||
`enabled` ,
|
||
`return_value` ,
|
||
`note` ,
|
||
`updated_date`
|
||
)
|
||
VALUES (
|
||
'42', 'user', '1', '1', NULL , 'Regular members can see unidentified transfers.', '1248160179'
|
||
);",
|
||
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'42', 'freenetis', 'view_all'
|
||
);
|
||
",
|
||
|
||
"INSERT INTO `aro_groups_map` (
|
||
`acl_id` ,
|
||
`group_id`
|
||
)
|
||
VALUES (
|
||
'42', '22'
|
||
);
|
||
",
|
||
|
||
"INSERT INTO `axo_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'42', 'Accounts_Controller', 'unidentified_transfers'
|
||
);
|
||
",
|
||
|
||
"INSERT INTO `aco_map` (
|
||
`acl_id` ,
|
||
`section_value` ,
|
||
`value`
|
||
)
|
||
VALUES (
|
||
'34', 'menu', 'unidentified_transfers'
|
||
);"
|
||
|
||
);
|
||
|
||
?>
|
Také k dispozici: Unified diff
jobs.description bylo omezeno na 255 znaků, takže se nedal udělat rozumný výkaz. Zvětšeno na 65535