upgrade to 6.7.1

Problems with installing LogicalDOC? No problems, the solution is closer than you think.

Moderator: car031

fainthoy
Posts: 1
Joined: Wed Jul 17, 2013 8:01 pm

upgrade to 6.7.1

Wed Jul 17, 2013 8:10 pm

Hello All,

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 */
Cordially,

Return to “Installation”

Who is online

Users browsing this forum: No registered users and 3 guests