SQL Database Publication Addition

1. Overview and Context

Once the publication has been released, thea ISBN recordsrecord of boththe book needs to be added to the PDFSQL andDatabase Printso bookmetrics can be updatedcollated inon the ISBN Management platform.it.

2. Triggers

The execution of this procedure is usually triggered byby:

• Book Publication

3. Steps to Be Performed

• Upload Book Cover Image
• Add Publicationa Date
  
new
• Set Title Status to Active Record
• Set Target Audienceline to the ScholarlyBook_Correlation_Table &via Professionalthe 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");

• SetClick BookGo. PriceThe (book pricetable is 0now for PDF)updated.

4. Additional Information

5. Document Control

Document ID	PRO-009010
Document Owner	Vincent
Version	1.0
Last Date of Change	October 2, 2025
Next Review Due Date
Version & Change Tracking