I have created an sql upgrade script from logicaldoc 6.4.1 to logicaldoc 6.7.1. It is a modification of an older upgrade script.
Code: Select all
/* upgrade sql script */
alter table ld_generic change ld_integer1 ld_integer1 bigint null;
alter table ld_generic change ld_integer2 ld_integer2 bigint null;
alter table ld_generic drop index AK_GENERIC;
alter table ld_generic add column ld_qualifier bigint null;
alter table ld_generic add column ld_integer3 bigint null;
alter table ld_generic add column ld_string3 varchar(4000) null;
create unique index AK_GENERIC on ld_generic (ld_type, ld_subtype, ld_qualifier);
create index LD_HIST_NOT on ld_history (ld_notified);
create index LD_FHIST_NOT on ld_folder_history (ld_notified);
insert into ld_generic (ld_id, ld_lastmodified, ld_deleted, ld_type, ld_subtype, ld_qualifier, ld_string1, ld_integer1, ld_integer2, ld_integer3)
values (-50, CURRENT_TIMESTAMP, 0, 'usersetting', 'dashlet-1', 1, 0, 1, 0, 0);
insert into ld_generic (ld_id, ld_lastmodified, ld_deleted, ld_type, ld_subtype, ld_qualifier, ld_string1, ld_integer1, ld_integer2, ld_integer3)
values (-51, CURRENT_TIMESTAMP, 0, 'usersetting', 'dashlet-3', 1, 0, 3, 0, 1);
insert into ld_generic (ld_id, ld_lastmodified, ld_deleted, ld_type, ld_subtype, ld_qualifier, ld_string1, ld_integer1, ld_integer2, ld_integer3)
values (-52, CURRENT_TIMESTAMP, 0, 'usersetting', 'dashlet-6', 1, 0, 6, 1, 0);
/* End updates 6.6 */
alter table ld_folder add column ld_templocked int not null default 0;
alter table ld_user add column ld_passwordexpired int not null default 0;
/* End updates 6.6.1 */
/* NO DB updates for 6.6.2 */
/* db updates for 6.7.1 */
alter table ld_document add column ld_transactionid varchar(255) default null;
alter table ld_document add column ld_extresid varchar(255) default null;
alter table ld_document add column ld_tgs varchar(100) default null;
alter table ld_folder_history add column ld_titleold varchar(255) default null;
alter table ld_folder_history add column ld_pathold varchar(4000) default null;
alter table ld_folder_history add column ld_filenameold varchar(255) default null;
alter table ld_foldergroup add column ld_calendar int(11) not null default 0;
alter table ld_foldergroup drop primary key;
alter table ld_foldergroup add primary key (ld_folderid, ld_groupid, ld_write, ld_add, ld_security, ld_immutable, ld_delete, ld_rename, ld_import, ld_export, ld_sign, ld_archive, ld_workflow, ld_download, ld_calendar);
alter table ld_history add column ld_titleold varchar(255) default null;
alter table ld_history add column ld_pathold varchar(4000) default null;
alter table ld_history add column ld_filenameold varchar(255) default null;
alter table ld_recipient add column ld_read int(11) not null default 0;
alter table ld_user add column ld_ipwhitelist varchar(4000) default null;
alter table ld_user add column ld_ipblacklist varchar(4000) default null;
alter table ld_version add column ld_transactionid varchar(255) default null;
alter table ld_version add column ld_extresid varchar(255) default null;
/* End updates 6.7.1 */