Advamced DB operations (Create Table, Update, etc) in Tiki 9.1? Posted by JustKen 23 Oct 2012 18:45 UTC Hi all, Is there documentation for updating the Tiki database using plugins? Like creating my own tables and populating them? Does anyone actually do this? Thanks, JK
Posted by Louis-Philippe Huberdeau 23 Oct 2012 18:52 UTC You can use the same database patch system used by Tiki itself. Some documentation is available: Database Schema Upgrade You will also find hundreds of sample patches in the source tree. Essentially, all of Tiki's patches have an _tiki suffix. You can drop in files without that suffix and the installer will apply them automatically on update or clean install.
Posted by JustKen 23 Oct 2012 22:44 UTC Thanks, lphuberdeau, I realized on the drive home today that some examples of database updates might be found in the source code. I'll check out the Database Schema Upgrade. Hopefully I'll be able to come up with methods to store information in the database without breaking my Tiki. JK