Revize 470
Přidáno uživatelem Jiří Sviták před asi 15 roky(ů)
| freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
|---|---|---|
|
;
|
||
|
",
|
||
|
|
||
|
"UPDATE `aro_groups` SET `name` = 'All' WHERE `aro_groups`.`id` = 21 AND `aro_groups`.`value` = 'all' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Regular members', `value` = 'regular_members' WHERE `aro_groups`.`id` = 22 AND `aro_groups`.`value` = 'radni_clenove' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Registered applicants', `value` = 'registered_applicants' WHERE `aro_groups`.`id` = 23 AND `aro_groups`.`value` = 'registrovani_zajemci' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Auditing comittee', `value` = 'auditing_comittee' WHERE `aro_groups`.`id` = 24 AND `aro_groups`.`value` = 'revizni_komise' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Executive counsil', `value` = 'executive_counsil' WHERE `aro_groups`.`id` = 25 AND `aro_groups`.`value` = 'spravni_rada' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Engineers', `value` = 'engineers' WHERE `aro_groups`.`id` = 26 AND `aro_groups`.`value` = 'technici' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Chairman and agent', `value` = 'chairman_and_agent' WHERE `aro_groups`.`id` = 28 AND `aro_groups`.`value` = 'predseda_jednatel' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Certified engineers', `value` = 'certified_engineers' WHERE `aro_groups`.`id` = 29 AND `aro_groups`.`value` = 'certifikovani_technici' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'System administrators', `value` = 'admins' WHERE `aro_groups`.`id` = 32 AND `aro_groups`.`value` = 'admins' LIMIT 1;
|
||
|
UPDATE `aro_groups` SET `name` = 'Users of regular members', `value` = 'users' WHERE `aro_groups`.`id` = 33 AND `aro_groups`.`value` = 'uzivatele' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'All' WHERE `aro_groups`.`id` = 21 AND `aro_groups`.`value` = 'all' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Regular members', `value` = 'regular_members' WHERE `aro_groups`.`id` = 22 AND `aro_groups`.`value` = 'radni_clenove' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Registered applicants', `value` = 'registered_applicants' WHERE `aro_groups`.`id` = 23 AND `aro_groups`.`value` = 'registrovani_zajemci' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Auditing comittee', `value` = 'auditing_comittee' WHERE `aro_groups`.`id` = 24 AND `aro_groups`.`value` = 'revizni_komise' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Executive counsil', `value` = 'executive_counsil' WHERE `aro_groups`.`id` = 25 AND `aro_groups`.`value` = 'spravni_rada' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Engineers', `value` = 'engineers' WHERE `aro_groups`.`id` = 26 AND `aro_groups`.`value` = 'technici' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Chairman and agent', `value` = 'chairman_and_agent' WHERE `aro_groups`.`id` = 28 AND `aro_groups`.`value` = 'predseda_jednatel' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Certified engineers', `value` = 'certified_engineers' WHERE `aro_groups`.`id` = 29 AND `aro_groups`.`value` = 'certifikovani_technici' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'System administrators', `value` = 'admins' WHERE `aro_groups`.`id` = 32 AND `aro_groups`.`value` = 'admins' LIMIT 1;",
|
||
|
"UPDATE `aro_groups` SET `name` = 'Users of regular members', `value` = 'users' WHERE `aro_groups`.`id` = 33 AND `aro_groups`.`value` = 'uzivatele' LIMIT 1;",
|
||
|
|
||
|
"ALTER TABLE `devices` DROP `GPS` ,
|
||
|
DROP `location_address` ,
|
||
Také k dispozici: Unified diff
Oprava chyby v upgradu sql.