Differences

This shows you the differences between two versions of the page.

--- axmls:setprefix [2015/12/19 01:58] – mnewnham
+++ axmls:setprefix [2015/12/19 17:01] – mnewnham
@@ Line 12: / Line 12: @@
 Sets a prefix for database objects
-Call this method to set a standard prefix that will be prepended to all database tables and indices. If the optional $addUnderscore parameter is set, an underscore is automatically appended to the prefix.
+Call this method to set a standard prefix that will be prepended to **all database tables and indexes**.
+If the optional ''$addUnderscore'' parameter is set, an underscore is automatically appended to the prefix.
+===== Usage =====
+<code php>
+/*
+* Assuming xml schema contains tables a,b,c
+*/
+$axmls->setPrefix('test');
+/*
+* tables will be created as 'test_a','test_b','test_c'
+*/
+$axmls->setPrefix('test',false);
+/*
+* tables will be created as 'testa','testb','testc'
+*/
+</code>
+===== Note =====
+Some database restrict the length of table and index names. Ensure that the total length of prefix + table name does not exceed that limit.