Revize 763
Přidáno uživatelem Michal Kliment před téměř 14 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_187.php | ||
|---|---|---|
|
"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 (
|
||
|
id INT(10) NOT NULL
|
||
|
, account_id INT(10) NOT NULL
|
||
|
, account_nr VARCHAR(254)
|
||
|
, bank_nr VARCHAR(10)
|
||
|
, IBAN VARCHAR(254)
|
||
|
, SWIFT VARCHAR(254)
|
||
|
, PRIMARY KEY (id)
|
||
|
, INDEX (account_id)
|
||
|
, CONSTRAINT FK_bank_accounts_1 FOREIGN KEY (account_id)
|
||
|
REFERENCES DEFAULT_SCHEMA.accounts (id)
|
||
|
);",
|
||
|
id INT(11) NOT NULL,
|
||
|
account_id INT(11) NOT NULL,
|
||
|
account_nr VARCHAR(254),
|
||
|
bank_nr VARCHAR(10),
|
||
|
IBAN VARCHAR(254),
|
||
|
SWIFT VARCHAR(254),
|
||
|
PRIMARY KEY (id),
|
||
|
INDEX (account_id)
|
||
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;",
|
||
|
|
||
|
//"DELETE FROM money_transfer_bank_infos;",
|
||
|
//"DELETE FROM money_transfer;",
|
||
Také k dispozici: Unified diff
Opravena mensi chyba ve starsim upgrade SQL dotazu, ktera zabranovala uspesne instalaci.