Revize 277
Přidáno uživatelem Tomáš Dulík před více než 15 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
"DELETE FROM enum_types WHERE id IN (40, 41)",
|
||
|
|
||
|
"INSERT INTO enum_types (type_id, value)
|
||
|
VALUES ('5', 'credit'),
|
||
|
('5', 'debit'),
|
||
|
VALUES ('5', 'debit'),
|
||
|
('5', 'tax'),
|
||
|
('5', 'non-tax'),
|
||
|
('7', 'balance sheet '),
|
||
| ... | ... | |
|
"UPDATE account_attributes SET kind = ( SELECT id FROM enum_types WHERE value = 'income statement' )
|
||
|
WHERE kind =2",
|
||
|
|
||
|
"UPDATE account_attributes SET kind = ( SELECT id FROM enum_types WHERE value = 'income statement' )
|
||
|
WHERE type =1",
|
||
|
|
||
|
"UPDATE account_attributes SET type = ( SELECT id FROM enum_types WHERE value = 'debit' )
|
||
|
WHERE type =1",
|
||
|
|
||
Také k dispozici: Unified diff
odstraněna položka "credit" z enum_types