Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 516

Přidáno uživatelem Tomáš Dulík před téměř 15 roky(ů)

jobs.description bylo omezeno na 255 znaků, takže se nedal udělat rozumný výkaz. Zvětšeno na 65535

Zobrazit rozdíly:

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