# This is a shell archive. Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file". Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
# ./asterisk-stat
# ./asterisk-stat/files
# ./asterisk-stat/files/cdr_pgsql.tbl
# ./asterisk-stat/files/patch-export_pdf.php
# ./asterisk-stat/files/cdr_mysql.tbl
# ./asterisk-stat/files/mysql::patch-cdr.php
# ./asterisk-stat/files/pgsql::patch-cdr.php
# ./asterisk-stat/files/mysql::patch-defines.php
# ./asterisk-stat/files/pgsql::patch-defines.php
# ./asterisk-stat/Makefile
# ./asterisk-stat/distinfo
# ./asterisk-stat/pkg-descr
# ./asterisk-stat/pkg-message
#
echo c - ./asterisk-stat
mkdir -p ./asterisk-stat > /dev/null 2>&1
echo c - ./asterisk-stat/files
mkdir -p ./asterisk-stat/files > /dev/null 2>&1
echo x - ./asterisk-stat/files/cdr_pgsql.tbl
sed 's/^X//' >./asterisk-stat/files/cdr_pgsql.tbl << 'END-of-./asterisk-stat/files/cdr_pgsql.tbl'
X
XCREATE TABLE cdr (
X calldate timestamp with time zone DEFAULT now() NOT NULL,
X clid varchar(80) NOT NULL default '',
X src varchar(80) NOT NULL default '',
X dst varchar(80) NOT NULL default '',
X dcontext varchar(80) NOT NULL default '',
X channel varchar(80) NOT NULL default '',
X dstchannel varchar(80) NOT NULL default '',
X lastapp varchar(80) NOT NULL default '',
X lastdata varchar(80) NOT NULL default '',
X duration int(11) NOT NULL default '0',
X billsec int(11) NOT NULL default '0',
X disposition varchar(45) NOT NULL default '',
X amaflags int(11) NOT NULL default '0',
X accountcode varchar(20) NOT NULL default '',
X uniqueid varchar(32) NOT NULL default '',
X userfield varchar(255) NOT NULL default ''
X);
X
XCREATE INDEX calldate_ind ON cdr USING btree (calldate);
XCREATE INDEX dst_ind ON cdr USING btree (dst);
XCREATE INDEX accountcode_ind ON cdr USING btree (accountcode);
END-of-./asterisk-stat/files/cdr_pgsql.tbl
echo x - ./asterisk-stat/files/patch-export_pdf.php
sed 's/^X//' >./asterisk-stat/files/patch-export_pdf.php << 'END-of-./asterisk-stat/files/patch-export_pdf.php'
X--- export_pdf.php.orig Thu Mar 3 00:11:32 2005
X+++ export_pdf.php Thu Jul 20 23:50:45 2006
X@@ -2,7 +2,7 @@
X include_once(dirname(__FILE__) . "/lib/defines.php");
X include_once(dirname(__FILE__) . "/lib/Class.Table.php");
X define(FPDF_FONTPATH,dirname(__FILE__).'/lib/font/');
X-include_once(dirname(__FILE__) . "/lib/fpdf.php');
X+include_once(dirname(__FILE__) . "/lib/fpdf.php");
X
X session_start();
X
END-of-./asterisk-stat/files/patch-export_pdf.php
echo x - ./asterisk-stat/files/cdr_mysql.tbl
sed 's/^X//' >./asterisk-stat/files/cdr_mysql.tbl << 'END-of-./asterisk-stat/files/cdr_mysql.tbl'
XUSE asterisk;
X
XCREATE TABLE cdr (
X calldate datetime NOT NULL default '0000-00-00 00:00:00',
X clid varchar(80) NOT NULL default '',
X src varchar(80) NOT NULL default '',
X dst varchar(80) NOT NULL default '',
X dcontext varchar(80) NOT NULL default '',
X channel varchar(80) NOT NULL default '',
X dstchannel varchar(80) NOT NULL default '',
X lastapp varchar(80) NOT NULL default '',
X lastdata varchar(80) NOT NULL default '',
X duration int(11) NOT NULL default '0',
X billsec int(11) NOT NULL default '0',
X disposition varchar(45) NOT NULL default '',
X amaflags int(11) NOT NULL default '0',
X accountcode varchar(20) NOT NULL default '',
X uniqueid varchar(32) NOT NULL default '',
X userfield varchar(255) NOT NULL default ''
X);
X
XALTER TABLE `cdr` ADD INDEX ( `calldate` );
XALTER TABLE `cdr` ADD INDEX ( `dst` );
XALTER TABLE `cdr` ADD INDEX ( `accountcode` );
END-of-./asterisk-stat/files/cdr_mysql.tbl
echo x - ./asterisk-stat/files/mysql::patch-cdr.php
sed 's/^X//' >./asterisk-stat/files/mysql::patch-cdr.php << 'END-of-./asterisk-stat/files/mysql::patch-cdr.php'
X--- cdr.php.orig Mon Mar 7 19:20:48 2005
X+++ cdr.php Thu Jul 20 23:47:46 2006
X@@ -36,7 +36,7 @@
X
X Asterisk CDR
X
X-
X+
X
X