<p></p>
<h3>Description</h3>
<p>When I try to load kamailio schema into MySQL database I get an error "Duplicate entry 'dialog_vars' for key 'PRIMARY'".<br>
I have checked the duplicated <code>dialog_vars</code> table definition at</p>
<ol>
<li><a href="https://github.com/kamailio/kamailio/blob/master/utils/kamctl/mysql/dialog-create.sql#L32-L38">dialog-create.sql#L32-L38</a></li>
<li><a href="https://github.com/kamailio/kamailio/blob/master/utils/kamctl/mysql/ims_dialog-create.sql#L41-L49">ims_dialog-create.sql#L41-L49</a></li>
</ol>
<h4>Reproduction</h4>
<p>Load schemas from dialog-create.sql and from ims_dialog-create.sql.</p>
<h3>Possible Solutions</h3>
<p>Remove <code>dialog_vars</code> table definition from <code>ims_dialog-create.sql</code> shema file.</p>
<h3>Additional Information</h3>
<ul>
<li><strong>Kamailio Version</strong> - output of <code>kamailio -v</code></li>
</ul>
<pre><code>@safarov-dell:/usr/share/kamailio$ kamailio -v
version: kamailio 5.5.0-dev3 (x86_64/linux) 
flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: unknown 
compiled on 12:51:16 Dec  4 2020 with gcc 10.2.1
</code></pre>
<ul>
<li><strong>Operating System</strong>:</li>
</ul>
<pre><code>@safarov-dell:/usr/share/kamailio$ cat /etc/os-release 
NAME="Alpine Linux"
ID=alpine
VERSION_ID=3.13.0_alpha20200917
PRETTY_NAME="Alpine Linux edge"
HOME_URL="https://alpinelinux.org/"
BUG_REPORT_URL="https://bugs.alpinelinux.org/"
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/2575">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABO7UZKEXLOZYL4PMMAOVKTSTEG27ANCNFSM4UNVWBIQ">unsubscribe</a>.<img src="https://github.com/notifications/beacon/ABO7UZMAUGEOI2JPLWXTJTDSTEG27A5CNFSM4UNVWBI2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4LJCTQ5A.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/kamailio/kamailio/issues/2575",
"url": "https://github.com/kamailio/kamailio/issues/2575",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>