[daisy] [JIRA] Resolved: (DSY-302) Bug in database update script "daisy-1_5-to-2_0_M1.sql"

[Bruno Dumon (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-302?page=all ]
     
Bruno Dumon resolved DSY-302:
-----------------------------

    Fix Version: public - 2.0
     Resolution: Fixed

> Bug in database update script  "daisy-1_5-to-2_0_M1.sql"
> --------------------------------------------------------
>
>          Key: DSY-302
>          URL: http://issues.cocoondev.org//browse/DSY-302
>      Project: Daisy
>         Type: Bug
>   Components: Repository
>     Versions: public - 2.0
>  Environment: Latest SVN
>     Reporter: Andreas Deininger
>     Priority: Minor
>      Fix For: public - 2.0

>
> Database update script  "daisy-1_5-to-2_0_M1.sql" is buggy:
> line 164 ff:
> alter table thefields
>    drop primary key,
>    add column ns_id BIGINT not null after doc_id,
>    add column link_nsid BIGINT after link_docid,
>    add column link_searchdocid VARCHAR(50) after link_nsid,
>    add index (link_searchdocid),
>    add foreign key(linkns_id) references daisy_namespaces(id),
>    add primary key (doc_id,ns_id,branch_id,lang_id,version_id,fieldtype_id,value_seq);
> second line from the bottom should read:
> add foreign key(link_nsid) references daisy_namespaces(id),

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira