MikoPBX
Модули
Перевод этой страницы:
MikoPBX
Модули
Обратно, к основному разделу...
cd /storage/usbdisk1/mikopbx/astlogs/asterisk/
sqlite3 << EOF ATTACH DATABASE 'cdr.db' as 'new'; ATTACH DATABASE 'master.db' as 'old'; delete from new.cdr_general; INSERT INTO new.cdr_general ( src_num, dst_num, src_chan, dst_chan, start, answer, endtime, duration, billsec, disposition, UNIQUEID, did, linkedid, recordingfile ) SELECT src, dst, channel, dstchannel, start, answer, "end", duration, billsec, disposition, AcctId, origextension, linkedid, recordingfile FROM old.cdr; DETACH DATABASE 'new'; DETACH DATABASE 'old'; .exit EOF