[SR-Users] database scheme generation and synchronization
Daniel-Constantin Mierla
miconda at gmail.com
Fri Nov 21 14:49:26 CET 2014
Hello,
the sql scripts to create the tables are in
utils/kamctl/{mysql|postgres|...}
The one you were looking at are probably from ser side and should be
removed.
Cheers,
Daniel
On 21/11/14 02:13, Måns Nilsson wrote:
> Greetings,
>
> I'm fighting a number of errors in the 'acc' table like so:
>
> Nov 21 01:43:05 landsort postgres[53327]: [4-1] ERROR: column "time" of relation "acc" does not exist at character 78
>
> That is, I believe, the default column name.
>
> Thing is, though, that the DDL that I used to build the table, is the
> one in in scripts/ and it does not does not contain that string:
> (on master but it is the same in 4.2 which is what I've got in production)
>
> $ for d in mysql oracle postgres ; do egrep '\btime\b' scripts/${d}/*create* ; done
> $
>
> How are those files generated?
>
> How do I come about to submitting an useful patch?
>
> What is the desired datatype for the time column?
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141121/f9b2d2e1/attachment.html>
More information about the sr-users
mailing list