SQL Database Publication Addition
1. Overview and Context
Once the publication has been released, a record of the book needs to be added to the SQL Database so metrics can be collated on it.
2. Triggers
The execution of this procedure is usually triggered by:
3. Steps to Be Performed
- Add a new line to the Book_Correlation_Table via the SQL tab of phpMyAdmin. Enter the following line, substituting PBN, title, ISBNs, and website URL:
INSERT INTO `Book_Correlation_Table`(`RecordReference`, `BookTitle`, `PrintISBN`, `EbookISBN`, `Website`, `workId`) VALUES ("0400","The Way Things Go","9781685711184","9781685711191","https://punctumbooks.com/titles/the-way-things-go/","242cdb6d-1d99-41ac-b9d9-4dfdb403cc2b");
- Click Go. The table is now updated.
4. Additional Information
5. Document Control
| Document ID | PRO-010 |
| Document Owner | Vincent |
| Version | 1.0 |
| Last Date of Change | October 2, 2025 |
| Next Review Due Date | |
| Version & Change Tracking |