Migration from 5.0.4 to 5.1.8
From OpenKM Documentation
Revision as of 13:18, 30 August 2011 by Pavila (talk | contribs) (Created page with '{{Warning|This migration process is under alfa state.}} Change table columns definition: <source lang="sql"> ALTER TABLE OKM_MAIL_ACCOUNT MODIFY COLUMN MA_ACTIVE char(1) NOT NU…')
 |
This migration process is under alfa state. |
Change table columns definition:
ALTER TABLE OKM_MAIL_ACCOUNT MODIFY COLUMN MA_ACTIVE char(1) NOT NULL;
ALTER TABLE OKM_QUERY_PARAMS MODIFY COLUMN QP_DASHBOARD char(1) NOT NULL;
ALTER TABLE OKM_ROLE MODIFY COLUMN ROL_ACTIVE char(1) NOT NULL;
ALTER TABLE OKM_TWITTER_ACCOUNT MODIFY COLUMN TA_ACTIVE char(1) NOT NULL;
ALTER TABLE OKM_USER MODIFY COLUMN USR_ACTIVE char(1) NOT NULL;
ALTER TABLE OKM_ACTIVITY MODIFY COLUMN ACT_ITEM varchar(127) NULL;
ALTER TABLE OKM_REPORT MODIFY COLUMN RP_ACTIVE char(1) NOT NULL;
ALTER TABLE OKM_CRON_TAB MODIFY COLUMN CT_ACTIVE char(1) NOT NULL;
Rename table columns:
ALTER TABLE OKM_EXTENSION CHANGE COLUMN EX_DESCRIPTION EXT_NAME varchar(255) NOT NULL;
ALTER TABLE OKM_EXTENSION CHANGE COLUMN EX_UUID EXT_UUID varchar(127) NOT NULL;
Remove deprecated table columns:
ALTER TABLE OKM_BOOKMARK DROP COLUMN BM_PATH;
ALTER TABLE OKM_REPORT DROP COLUMN RP_TYPE;
ALTER TABLE OKM_CRON_TAB DROP COLUMN CT_TYPE;
