sippeers_populating <PosrtgreSQL_9.5>

sippeers_populating.sql

DELETE FROM sippeers;

INSERT INTO sippeers (id,name,host,type,context,permit,deny,secret,transport,dtmfmode,directmedia,nat,disallow,allow,progressinband,callerid,callcounter,qualify,qualifyfreq,allowtransfer)
SELECT
row_number()  OVER (),
'7999'::integer + row_number()  OVER () ,
'dynamic',
'friend',
'default',
'0.0.0.0',
'',
CONCAT(7999+ row_number()  OVER ()) ,
'udp',
'rfc2833',
'no',
'no',
'all',
'ulaw,alaw',
'yes',
CONCAT('7999'::integer + row_number()  OVER (), '<', '7999'::integer + row_number()  OVER (), '>')
,'yes',
'yes',
'100',
'yes'

FROM information_schema.columns c
LIMIT 20