[daisy] SVN trunk users warning: database change to be applied

[Bruno Dumon]

Hi,

With the merge of BRANCH_DEREF, the following change is needed to the
database schema:

alter table document_variants
   add column link_search VARCHAR(100) not null after lang_id,
   add index (link_search)
;
show warnings;

update document_variants set link_search = concat(doc_id, '-', ns_id, '@', branch_id, ':', lang_id);
show warnings;



Also added to http://cocoondev.org/daisyscratchpad/g3/354.html

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org