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@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