Revize 1239
Přidáno uživatelem Jiří Sviták před asi 13 roky(ů)
| freenetis/branches/testing/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
|
||
|
|
||
|
/**
|
||
|
* Changes work report table, adds column added_by_id and it's forein key.
|
||
|
* Added transaction_code column to distinguish unique bank transfers from statements.
|
||
|
*
|
||
|
* @author Ondřej Fibich
|
||
|
* @author Jiri Svitak
|
||
|
*/
|
||
|
$upgrade_sql[get_SVN_rev()] = array
|
||
|
(
|
||
|
"ALTER TABLE `job_reports` ADD `added_by_id` INT( 11 ) AFTER `user_id`;",
|
||
|
|
||
|
"ALTER TABLE `job_reports` ADD INDEX ( `added_by_id` );",
|
||
|
|
||
|
"ALTER TABLE `job_reports` ADD FOREIGN KEY ( `added_by_id` ) REFERENCES `users` ( `id` ) ON DELETE SET NULL;"
|
||
|
"ALTER TABLE `bank_transfers` ADD `transaction_code` BIGINT NULL AFTER `bank_statement_id` ",
|
||
|
"ALTER TABLE `bank_transfers` CHANGE `number` `number` INT( 11 ) NULL COMMENT 'Line number or number of the bank listing item'"
|
||
|
);
|
||
| freenetis/branches/testing/application/upgrade_sql/upgrade_sql_1234.php | ||
|---|---|---|
|
<?php
|
||
|
/**
|
||
|
* Changes work report table, adds column added_by_id and it's forein key.
|
||
|
*
|
||
|
* @author Ondřej Fibich
|
||
|
*/
|
||
|
$upgrade_sql[1234] = array
|
||
|
(
|
||
|
"ALTER TABLE `job_reports` ADD `added_by_id` INT( 11 ) AFTER `user_id`;",
|
||
|
|
||
|
"ALTER TABLE `job_reports` ADD INDEX ( `added_by_id` );",
|
||
|
|
||
|
"ALTER TABLE `job_reports` ADD FOREIGN KEY ( `added_by_id` ) REFERENCES `users` ( `id` ) ON DELETE SET NULL;"
|
||
|
);
|
||
|
?>
|
||
Také k dispozici: Unified diff
Pridana moznost ulozit jednoznacny kod bankovni transakce - pro usnadneni detekce importu duplicitnich polozek.