Revize 239
Přidáno uživatelem Michal Kliment před asi 15 roky(ů)
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql_235.php | ||
---|---|---|
<?php
|
||
|
||
$upgrade_sql[235] = array(
|
||
"CREATE TABLE `enum_type_names` (
|
||
`id` INT NOT NULL AUTO_INCREMENT ,
|
||
`type_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
|
||
PRIMARY KEY ( `id` )
|
||
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_czech_ci;",
|
||
|
||
"INSERT INTO `enum_type_names` (
|
||
`type_name`
|
||
)
|
||
VALUES (
|
||
'Member types'
|
||
), (
|
||
'Device types'
|
||
), (
|
||
'User types'
|
||
), (
|
||
'Contact types'
|
||
),
|
||
(
|
||
'Account types'
|
||
);
|
||
"
|
||
);
|
||
|
||
|
||
?>
|
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
---|---|---|
|
||
|
||
$upgrade_sql[get_SVN_rev()] = array(
|
||
"CREATE TABLE `enum_type_names` (
|
||
`id` INT NOT NULL AUTO_INCREMENT ,
|
||
`type_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
|
||
PRIMARY KEY ( `id` )
|
||
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_czech_ci;",
|
||
"ALTER TABLE `accounts` CHANGE `type` `type_old` ENUM( 'bank', 'analytic', 'master', 'project', 'operating', 'infrastructure', 'suppliers', 'unidentified' ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL",
|
||
|
||
"INSERT INTO `enum_type_names` (
|
||
`type_name`
|
||
)
|
||
VALUES (
|
||
'Member types'
|
||
), (
|
||
'Device types'
|
||
), (
|
||
'User types'
|
||
), (
|
||
'Contact types'
|
||
),
|
||
(
|
||
'Account types'
|
||
);
|
||
"
|
||
"ALTER TABLE `accounts` ADD `type_id` INT( 11 ) NOT NULL AFTER `name`",
|
||
|
||
"INSERT INTO `enum_types` (`id`,`type_id`,`value`) VALUES
|
||
('27', '5', 'bank'),
|
||
('28', '5', 'analytic'),
|
||
('29', '5', 'master'),
|
||
('30', '5', 'project'),
|
||
('31', '5', 'operating'),
|
||
('32', '5', 'infrastructure'),
|
||
('33', '5', 'suppliers'),
|
||
('34', '5', 'unidentified');",
|
||
|
||
"UPDATE `accounts`, `enum_types` SET `accounts`.`type_id` = `enum_types`.`id` WHERE `accounts`.`type_old` = `enum_types`.`value`;",
|
||
|
||
"ALTER TABLE `accounts` DROP `type_old`, DROP `start_amount`;"
|
||
);
|
||
|
||
|
Také k dispozici: Unified diff
U tabulky accounts predelany typ uctu z enum na klic do tabulky enum_types.