schema differences between fresh 3 and upgrade to 3

steve_tekell — Mon, 05 Jan 2009 20:42:57 GMT

in the process of sort through 2.1-3c upgrade problems, I generated a schema diff between my upgraded database and fresh install.FWIW this 2.1 had been upgraded from 2.0 and 1.4 before that.I ignored differences in NULLABILITY since it might be required for added columns and a few trivial things in

Re: schema differences between fresh 3 and upgrade to 3

steve_tekell — Tue, 06 Jan 2009 17:25:29 GMT

In case anyone is interested, here's generated script to sync such an upgraded database to be like a fresh install. (still ignoring NULLABILITY, etc).




–
– FOREIGN KEYS [DROP]
– 

ALTER TABLE JBPM_MESSAGE DROP CONSTRAINT FK_CMD_ACTION;
ALTER TABLE JBPM_MESSAGE DROP CONSTRAINT FK_CMD_NODE;
ALTER TABLE JBPM_MESSAGE DROP CONSTRAINT FK_CMD_TASKINST;
ALTER TABLE JBPM_MESSAGE DROP CONSTRAINT FK_MSG_TOKEN;
ALTER TABLE JBPM_TIMER DROP CONSTRAINT FK_TIMER_ACTION;
ALTER TABLE JBPM_TIMER DROP CONSTRAINT FK_TIMER_PRINST;
ALTER TABLE JBPM_TIMER DROP CONSTRAINT FK_TIMER_TOKEN;
ALTER TABLE JBPM_TIMER DROP CONSTRAINT FK_TIMER_TSKINST;

–
– alf_access_control_entry
– 

ALTER TABLE alf_access_control_entry ALTER COLUMN applies DROP DEFAULT;

–
– alf_access_control_list
– 

ALTER TABLE alf_access_control_list ALTER COLUMN acl_id DROP DEFAULT;
ALTER TABLE alf_access_control_list ALTER COLUMN latest DROP DEFAULT;
ALTER TABLE alf_access_control_list ALTER COLUMN acl_version DROP DEFAULT;
ALTER TABLE alf_access_control_list ALTER COLUMN type DROP DEFAULT;
ALTER TABLE alf_access_control_list ALTER COLUMN is_versioned DROP DEFAULT;
ALTER TABLE alf_access_control_list ALTER COLUMN requires_version DROP DEFAULT;

–
– alf_ace_context
– 

ALTER TABLE alf_ace_context CHANGE COLUMN class_context class_context TEXT NULL COMMENT '';
ALTER TABLE alf_ace_context CHANGE COLUMN property_context property_context TEXT NULL COMMENT '';
ALTER TABLE alf_ace_context CHANGE COLUMN kvp_context kvp_context TEXT NULL COMMENT '';

–
– alf_attributes
– 


–
– alf_locale
– 

ALTER TABLE alf_locale ALTER COLUMN version DROP DEFAULT;

–
– alf_node_properties
– 

ALTER TABLE alf_node_properties CHANGE COLUMN list_index list_index INT NOT NULL COMMENT '';

–
– JBPM_MESSAGE
– 

DROP TABLE JBPM_MESSAGE;

–
– JBPM_PROCESSINSTANCE
– 

CREATE INDEX IDX_PROCIN_KEY ON JBPM_PROCESSINSTANCE (KEY_ ASC);

–
– JBPM_TIMER
– 

DROP TABLE JBPM_TIMER;


–
– FOREIGN KEYS [CREATE]
– 

ALTER TABLE alf_attributes ADD CONSTRAINT fk_alf_attr_acl FOREIGN KEY (acl_id) REFERENCES alf_access_control_list (id)
                                                          ON DELETE NO ACTION
                                                          ON UPDATE NO ACTION;
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic Re: schema differences between fresh 3 and upgrade to 3 in Alfresco Archive

schema differences between fresh 3 and upgrade to 3

Re: schema differences between fresh 3 and upgrade to 3