<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">Hello,</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">if you put the sql to create the table
in share/kamailio/mysql/customtable-create.sql</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">then you can run:</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">kamdbctl add-tables customtable</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">This has to be done after the kamdbctl
create command.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">If you plan for long term, also taking
in consideration the option to add management of customtable
records in the cli, I can recommend to look at kamcli:</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"> * <a class="moz-txt-link-freetext" href="https://github.com/kamailio/kamcli">https://github.com/kamailio/kamcli</a></div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">It can also create the customtable
using:</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">kamcli db create-tables-group
customtable</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">The 'kamcli db' offers what old
'kamdbctl' and 'kamctl db ...' do.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">But then you can just add your own
python file in 'kamcli/commands/cmd_customtable.py' to manage
records in that table (for example, you can use cmd_aliasdb.py as
a starting point).</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Cheers,<br>
Daniel<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 05.11.20 13:40,
<a class="moz-txt-link-abbreviated" href="mailto:me.projects@yahoo.com">me.projects@yahoo.com</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:726839589.1975832.1604580046422@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="yahoo-style-wrap" style="font-family:Helvetica Neue,
Helvetica, Arial, sans-serif;font-size:16px;">
<div dir="ltr" data-setdir="false">Hi,</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">I want add some custom Table
Creation during installation of Kamailio. </div>
<div dir="ltr" data-setdir="false"><span><br>
</span></div>
<div dir="ltr" data-setdir="false"><span>I want to add my Custom
Table during the execution of </span></div>
<div dir="ltr" data-setdir="false"><span><br>
</span></div>
<div dir="ltr" data-setdir="false"><span><b>kamdbctl create</b></span><span><br>
</span></div>
<div dir="ltr" data-setdir="false"><span><br>
</span></div>
<div dir="ltr" data-setdir="false"><span>command. Currently I am
adding my script in </span></div>
<div dir="ltr" data-setdir="false"><span><br>
</span></div>
<div dir="ltr" data-setdir="false"><span><b>share/kamailio/mysql/auth_db-create.sql</b></span></div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">Thanks,</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Funding: <a class="moz-txt-link-freetext" href="https://www.paypal.me/dcmierla">https://www.paypal.me/dcmierla</a></pre>
</body>
</html>