Revize 235
Přidáno uživatelem Tomáš Dulík před více než 15 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
return $svnid;
|
||
|
}
|
||
|
|
||
|
|
||
|
$upgrade_sql[get_SVN_rev()] = array(
|
||
|
"INSERT INTO `axo_map` (`acl_id`, `section_value`, `value`) VALUES
|
||
|
(57, 'Settings_Controller', 'access_rights');"
|
||
|
"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'
|
||
|
);
|
||
|
"
|
||
|
);
|
||
|
|
||
|
|
||
|
?>
|
||
Také k dispozici: Unified diff
SQL dotaz pro vytvoreni nove tabulky enum_type_names