voip.sql - projectvoip - VoIP honeypot similar to ssh honeypot, using asterisk as the backend.
 (HTM) git clone git://jay.scot/projectvoip
 (DIR) Log
 (DIR) Files
 (DIR) Refs
 (DIR) README
       ---
       voip.sql (1594B)
       ---
            1 
            2 
            3 DROP TABLE IF EXISTS `caller`;
            4 CREATE TABLE IF NOT EXISTS `caller` (
            5   `id` int(15) NOT NULL AUTO_INCREMENT,
            6   `uid` varchar(15) NOT NULL,
            7   `number` varchar(100) DEFAULT NULL,
            8   `agent` varchar(100) DEFAULT NULL,
            9   `channel` varchar(100) DEFAULT NULL,
           10   `capture` longblob NOT NULL,
           11   `recording` longblob NOT NULL,
           12   `timestamp` datetime NOT NULL,
           13   `dumped` int(1) NOT NULL DEFAULT '0',
           14   `honeypot` int(11) NOT NULL,
           15   PRIMARY KEY (`id`),
           16   KEY `uid` (`uid`)
           17 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
           18 
           19 DROP TABLE IF EXISTS `information`;
           20 CREATE TABLE IF NOT EXISTS `information` (
           21   `id` int(15) NOT NULL AUTO_INCREMENT,
           22   `ip_address` varchar(15) NOT NULL,
           23   `asn` varchar(100) DEFAULT NULL,
           24   `as_path` varchar(100) DEFAULT NULL,
           25   `prefix` varchar(100) DEFAULT NULL,
           26   `as_org_name` varchar(100) DEFAULT NULL,
           27   `org_name` varchar(100) DEFAULT NULL,
           28   `country` varchar(100) DEFAULT NULL,
           29   `net_name` varchar(100) DEFAULT NULL,
           30   `lon` float(10,6) DEFAULT NULL,
           31   `lat` float(10,6) DEFAULT NULL,
           32   `city` varchar(100) DEFAULT NULL,
           33   `region` varchar(100) DEFAULT NULL,
           34   `traceroute` varchar(400) DEFAULT NULL,
           35   `reported` int(1) NOT NULL DEFAULT '0',
           36   PRIMARY KEY (`id`),
           37   KEY `ip_address` (`ip_address`)
           38 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
           39 
           40 DROP TABLE IF EXISTS `report`;
           41 CREATE TABLE IF NOT EXISTS `report` (
           42   `id` int(15) NOT NULL AUTO_INCREMENT,
           43   `uid` varchar(15) NOT NULL,
           44   `email` varchar(200) DEFAULT NULL,
           45   `last_contact` datetime DEFAULT NULL,
           46   `total_contact` int(2) DEFAULT NULL,
           47   `reply` text,
           48   PRIMARY KEY (`id`)
           49 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;