Revize 290
Přidáno uživatelem Tomáš Dulík před asi 15 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
}
|
||
|
|
||
|
|
||
|
$upgrade_sql[get_SVN_rev()] = array("
|
||
|
CREATE TABLE `freenetis`.`accounts_bank_accounts` (
|
||
|
`account_id` INT NOT NULL ,
|
||
|
`bank_account_id` INT NOT NULL ,
|
||
|
PRIMARY KEY ( `account_id` , `bank_account_id` )
|
||
|
) ENGINE = InnoDB;
|
||
|
"
|
||
|
$upgrade_sql[get_SVN_rev()] = array(
|
||
|
"DROP TABLE accounts_bank_accounts",
|
||
|
"RENAME TABLE money_transfers TO transfers",
|
||
|
"RENAME TABLE money_transfer_bank_infos TO bank_transfers",
|
||
|
"ALTER TABLE bank_transfers
|
||
|
ADD origin_id INT NOT NULL COMMENT 'id of the source bank account in the bank_accounts table' AFTER `id` ,
|
||
|
ADD destination_id INT NOT NULL COMMENT 'id of the destination bank account in the bank_accounts table' AFTER `origin_id`",
|
||
|
"ALTER TABLE `bank_accounts` DROP `account_id`",
|
||
|
"ALTER TABLE `bank_accounts`
|
||
|
ADD `name` VARCHAR(254) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL AFTER `id` ,
|
||
|
ADD `member_id` INT NOT NULL AFTER `name` ",
|
||
|
"CREATE TABLE cash (
|
||
|
`id` INT NOT NULL AUTO_INCREMENT ,
|
||
|
`member_id` INT NOT NULL ,
|
||
|
`transfer_id` INT NOT NULL ,
|
||
|
PRIMARY KEY ( `id` )
|
||
|
) ENGINE = InnoDB COMMENT = 'implements cash deposits and withdrawals ';"
|
||
|
);
|
||
|
|
||
|
?>
|
||
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_287.php | ||
|---|---|---|
|
<?php
|
||
|
|
||
|
$upgrade_sql[287] = array("
|
||
|
CREATE TABLE `freenetis`.`accounts_bank_accounts` (
|
||
|
`account_id` INT NOT NULL ,
|
||
|
`bank_account_id` INT NOT NULL ,
|
||
|
PRIMARY KEY ( `account_id` , `bank_account_id` )
|
||
|
) ENGINE = InnoDB;
|
||
|
"
|
||
|
);
|
||
|
|
||
|
?>
|
||
Také k dispozici: Unified diff
Vcerejsi zmena databaze byla zbytecna, rano jsem vymyslel lepsi alternativu: oddeleni bankovnich a podvojnych uctu a prevodu mezi nimi.
K tomu je potreba zmena sloupcu v tabulkach bank_account a money_transfers_bank_infos
Kdyz uz jsme u tech velkych zmen, prejmenovali jsme tabulku money_transfers na transfers a money_transfers_bank_infos na bank_transfers.
Taky jsme pridali tabulku cash, ktera obsahuje hotovostni vklady a vybery do pokladny sdruzeni.