Changes to db structure
Posted by mholmes on 18 Nov 2019 in Activity log
After consultation with AC, and some data cleanup, I've removed some old fields that were no longer used:
- Text
- Illustrations
- OLD Illustrator
- Links
- Page-image Notes
as well as the old poem_search table.
ALTER TABLE `poems` DROP COLUMN `po_text`; ALTER TABLE `poems` DROP COLUMN `po_illustrations`; ALTER TABLE `poems` DROP COLUMN `po_illustrator`; ALTER TABLE `poems` DROP COLUMN `po_links`; ALTER TABLE `poems` DROP COLUMN `po_imageNotes`; DROP TABLE `poem_search`;
120 minutes.