Developing (v7+)

Multiple tables in one db.xml?

Permalink 1 user found helpful February 14, 2013 at 6:32 AM

Hey there! Is it possible to define multiple tables in one db.xml? I am developing a custom block, and the block would store it's data in several tables. I don't really know how to do this. Can I just write several <schema> definitions or should I write several <table> definitions inside a single <schema>?

goutnet replied on Feb 14, 2013 at 7:48 am Permalink Best Answer Reply

Yes it is, but you just add multiple "table" tags, not schema :

http://www.concrete5.org/documentation/how-tos/developers/creating-...

szucslaszlo replied on Feb 14, 2013 at 7:51 am Permalink Reply

Thank you!

JohntheFish replied on Feb 14, 2013 at 11:46 am Permalink Reply

Bear in mind that you will need to co-ordinate the various secondary tables with the bID, and that the bID changes whenever a block is edited.

szucslaszlo replied on Feb 14, 2013 at 11:49 am Permalink Reply

Hey John! Thank you for your reminder on the bID changes. I surely would have missed that! You're cool!