Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 239

Přidáno uživatelem Michal Kliment před asi 15 roky(ů)

U tabulky accounts predelany typ uctu z enum na klic do tabulky enum_types.

Zobrazit rozdíly:

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