forked from offensive-security/masscan-web-ui
-
Notifications
You must be signed in to change notification settings - Fork 0
/
db-structure-mysql.sql
executable file
·16 lines (16 loc) · 838 Bytes
/
db-structure-mysql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
DROP TABLE IF EXISTS `data`;
CREATE TABLE IF NOT EXISTS `data` (
`id` bigint(20) unsigned NOT NULL,
`ip` int(10) unsigned NOT NULL DEFAULT '0',
`port_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`scanned_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`protocol` enum('tcp','udp') NOT NULL,
`state` varchar(10) NOT NULL DEFAULT '',
`reason` varchar(255) NOT NULL DEFAULT '',
`reason_ttl` int(10) unsigned NOT NULL DEFAULT '0',
`service` varchar(100) NOT NULL DEFAULT '',
`banner` text NOT NULL,
`title` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
ALTER TABLE `data` ADD PRIMARY KEY (`id`), ADD KEY `scanned_ts` (`scanned_ts`), ADD KEY `ip` (`ip`), ADD FULLTEXT KEY `banner` (`banner`,`title`);
ALTER TABLE `data` MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;