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

[Andreas Deininger (JIRA)]

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


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