AnsweredAssumed Answered

alf_content_url and  content_url_crc field

Question asked by francesco.fornasari on Mar 7, 2018

Dear All,

about the alf_content_url table, have you any ideas how the content_url_crc is computed? If we have the necessity to change document store and modify the content_url field, how can we compute the new content_url_crc value?

I haven't found it in the alfresco source code (java side).

 

Thank you,

Francesco.

 

CREATE TABLE alf_content_url
(
id BIGINT NOT NULL AUTO_INCREMENT,
content_url VARCHAR(255) NOT NULL,
content_url_short VARCHAR(12) NOT NULL,
content_url_crc BIGINT NOT NULL,
content_size BIGINT NOT NULL,
orphan_time BIGINT NULL,
UNIQUE INDEX idx_alf_conturl_cr (content_url_short, content_url_crc),
INDEX idx_alf_conturl_ot (orphan_time),
INDEX idx_alf_conturl_sz (content_size),
PRIMARY KEY (id)

) ENGINE=InnoDB;

Outcomes