Upgrade Notes

 <?php

include_once("pimcore/cli/startup.php");

$classList = new Object_Class_List();
$classes = $classList->load();
if(is_array($classes)){
    foreach($classes as $class){
        $class->save();
    }
}

$list = new Object_Fieldcollection_Definition_List();
$list = $list->load();
foreach ($list as $fc) {
    $fc->save();
}


$list = new Object_Objectbrick_Definition_List();
$list = $list->load();
foreach ($list as $fc) {
    $fc->save();
}

update properties set name = "navigation_name_legacy" where name = "navigation_name";
update properties set name = "navigation_target_legacy" where name = "navigation_target";
update properties set name = "navigation_accesskey_legacy" where name = "navigation_accesskey_name";
update properties set name = "navigation_parameters_legacy" where name = "navigation_parameters";
update properties set name = "navigation_relation_legacy" where name = "navigation_relation";
update properties set name = "navigation_anchor_legacy" where name = "navigation_anchor";
update properties set name = "navigation_tabindex_legacy" where name = "navigation_tabindex";
update properties set name = "navigation_exclude_legacy" where name = "navigation_exclude";

insert into properties
select p.id as cid,  "document" as ctype, concat(d.path, d.key) as cpath,"navigation_name" as name, "text" as `type`, p.name as  `data`, "0" as inheritable
from  documents_page p
left join documents d on p.id = d.id
where p.name is not null and p.name!="";

insert into properties
select p.id as cid,  "document" as ctype, concat(d.path, d.key) as cpath, "navigation_name" as name, "text" as `type`, p.name as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.name is not null and p.name!="";

insert into properties
select p.id as cid, "document" as ctype, concat(d.path, d.key) as cpath,  "navigation_target" as name, "text" as `type`, p.target as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.target is not null and p.target!="";

insert into properties
select p.id as cid, "document" as ctype, concat(d.path, d.key) as cpath,  "navigation_accesskey" as name, "text" as `type`, p.accesskey as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.accesskey is not null and p.accesskey!="";

insert into properties
select p.id as cid,"document" as ctype, concat(d.path, d.key) as cpath,  "navigation_parameters" as name, "text" as `type`, p.parameters as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.parameters is not null  and p.parameters!="";

insert into properties
select p.id as cid, "document" as ctype,  concat(d.path, d.key) as cpath, "navigation_relation" as name, "text" as `type`, p.rel as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.rel is not null  and p.rel!="";

insert into properties
select p.id as cid,  "document" as ctype, concat(d.path, d.key) as cpath, "navigation_anchor" as name, "text" as `type`, p.anchor as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.anchor is not null  and p.anchor!="";

insert into properties
select p.id as cid, "document" as ctype, concat(d.path, d.key) as cpath, "navigation_title" as name, "text" as `type`, p.title as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.title is not null  and p.title!="";

insert into properties
select p.id as cid, "document" as ctype, concat(d.path, d.key) as cpath, "navigation_tabindex" as name, "text" as `type`, p.tabindex as  `data`, "0" as inheritable
from  documents_link p
left join documents d on p.id = d.id
where p.tabindex is not null  and p.tabindex!="";


alter table documents_page change name DEPRECATED_name varchar(255);
alter table documents_link change name DEPRECATED_name varchar(255);
alter table documents_link change target DEPRECATED_target varchar(255);
alter table documents_link change accesskey DEPRECATED_accesskey varchar(255);
alter table documents_link change parameters DEPRECATED_parameters varchar(255);
alter table documents_link change rel DEPRECATED_rel varchar(255) ;
alter table documents_link change anchor DEPRECATED_anchor varchar(255);
alter table documents_link change title DEPRECATED_title varchar(255);
alter table documents_link change tabindex DEPRECATED_tabindex varchar(255);