You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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...
The text was updated successfully, but these errors were encountered:
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
) 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...
The text was updated successfully, but these errors were encountered: