Add a new table "sectionAuthors" that links the authorname to the section table so we can handle cases where there are multiple authors in a single section. The table would look like:
DROP TABLE IF EXISTS sectionAuthors;
CREATE TABLE sectionAuthors (
section_id int(11) NOT NULL AUTO_INCREMENT,
given_name varchar(255) DEFAULT NULL,
family_name varchar(255) DEFAULT NULL,
KEY section_id (section_id),
CONSTRAINT section_ibfk_1 FOREIGN KEY (section_id) REFERENCES section (section_id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Also, drop the given_name, family_name from section table
Need to adjust digester assignments to handle this...
Add a new table "sectionAuthors" that links the authorname to the section table so we can handle cases where there are multiple authors in a single section. The table would look like:
DROP TABLE IF EXISTS sectionAuthors; CREATE TABLE
sectionAuthors(section_idint(11) NOT NULL AUTO_INCREMENT,given_namevarchar(255) DEFAULT NULL,family_namevarchar(255) DEFAULT NULL, KEYsection_id(section_id), CONSTRAINTsection_ibfk_1FOREIGN KEY (section_id) REFERENCESsection(section_id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;Also, drop the given_name, family_name from section table
Need to adjust digester assignments to handle this...