sqlite> .schema
CREATE TABLE chanvars (
callid INTEGER default 0,
varname TEXT NOT NULL,
varvalue TEXT default ""
);
CREATE TABLE freeswitchcdr (
callid INTEGER PRIMARY KEY AUTOINCREMENT,
callstartdate INTEGER NOT NULL,
callanswerdate INTEGER NOT NULL,
calltransferdate INTEGER NOT NULL,
callenddate INTEGER NOT NULL,
originated INTEGER default 0,
clid TEXT default "Freeswitch - Unknown",
src TEXT NOT NULL,
dst TEXT NOT NULL,
ani TEXT default "",
aniii TEXT default "",
dialplan TEXT default "",
myuuid TEXT NOT NULL,
destuuid TEXT NOT NULL,
srcchannel TEXT NOT NULL,
dstchannel TEXT NOT NULL,
network_addr TEXT,
lastapp TEXT default "",
lastdata TEXT default "",
billusec INTEGER default 0,
disposition INTEGER default 0,
hangupcause INTEGER default 0,
amaflags INTEGER default 0
, The_Kow INTEGER, username TEXT);