Change bcms structure to include the version of the book
Up to now we were using an auto- increment id as an identifier for the books, bookComponents, collections, tocs. in the form of bcms1234. No we need to change that and include in that auto increment number the number of the version like that bcms1234.1 , bcms1234.2 etc. for each new version of books or bookComponents.
-
we need to change the alias to be a string instead of a integer for all the tables that alias field exists. books, bookComponent, Collection, Toc -
we add the version of the same book at the end of the string bcms1234 .1 when we have a new book
status and in the case we have a new version of a book we increase just the last number after the dot like this : bcms1234.2 , bcms1234.3