Upgrade Procedures

If you do not start with a clean install, but update form a previous corinis release here are some infos.

Upgrade to 3.0.8

Use following sql files (for mysql) to upgrade the db-schema accordingly. also make sure to run the setup.jsp

alter table coriniscmsfilemanager add realfilename varchar(255) default NULL;
alter table coriniscmsqmfilemanager add realfilename varchar(255) default NULL;
alter table coriniscmslifefilemanager add realfilename varchar(255) default NULL;
# fill the filename
update coriniscmsfilemanager set realfilename=filename where entrytype > 1 and realfilename=NULL;
update coriniscmslifefilemanager cl, coriniscmsfilemanager c  set cl.realfilename = c.realfilename where cl.id = c.id ;
alter table coriniscmsfilemanager change state filestate int(11);
alter table coriniscmslifefilemanager change state filestate int(11);
alter table coriniscmsqmfilemanager change state filestate int(11);
alter table coriniscmsedit change type fieldtype int(11);
alter table coriniscmslifeedit change type fieldtype int(11);
alter table coriniscmsqmedit change type fieldtype int(11);
alter table coriniscmshistory change type fieldtype int(11);
alter table coriniscmsfilemanager change top cmstop bigint(20);
alter table coriniscmslifefilemanager change top cmstop bigint(20);
alter table coriniscmsqmfilemanager change top cmstop bigint(20);
alter table coriniscmsedit change top cmstop bigint(20);
alter table coriniscmslifeedit change top cmstop bigint(20);
alter table coriniscmsqmedit change top cmstop bigint(20);
alter table coriniscmshistory change top cmstop bigint(20);
alter table coriniscmslink change internal internallink char(1);
alter table corinisvoting change value votevalue int(11);
alter table corinisdynamicfielddata change foreignId foreignid bigint(20);
alter table coriniscmsmodels add defaultDocType int(3) default -1;