| 1 | -- Server version 4.1.13 |
|---|
| 2 | |
|---|
| 3 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|---|
| 4 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
|---|
| 5 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
|---|
| 6 | /*!40101 SET NAMES utf8 */; |
|---|
| 7 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
|---|
| 8 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
|---|
| 9 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
|---|
| 10 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|---|
| 11 | |
|---|
| 12 | -- |
|---|
| 13 | -- Table structure for table `FLOWS` |
|---|
| 14 | -- |
|---|
| 15 | |
|---|
| 16 | DROP TABLE IF EXISTS `FLOWS`; |
|---|
| 17 | CREATE TABLE `FLOWS` ( |
|---|
| 18 | `RECNUM` bigint(20) unsigned zerofill NOT NULL auto_increment, |
|---|
| 19 | `PROBE` varchar(16) NOT NULL default '', |
|---|
| 20 | `TIME_RECEIVED` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 21 | `FLOW_VERSION` tinyint(4) NOT NULL default '0', |
|---|
| 22 | `SEQUENCE` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000', |
|---|
| 23 | `SOURCE_IP` varchar(16) NOT NULL default '', |
|---|
| 24 | `SOURCE_PORT` int(11) NOT NULL default '0', |
|---|
| 25 | `DEST_IP` varchar(16) NOT NULL default '', |
|---|
| 26 | `DEST_PORT` int(11) NOT NULL default '0', |
|---|
| 27 | `NEXT_HOP` varchar(16) NOT NULL default '', |
|---|
| 28 | `PROTOCOL` int(11) NOT NULL default '0', |
|---|
| 29 | `TCP_FLAGS` int(11) NOT NULL default '0', |
|---|
| 30 | `TOS` int(11) NOT NULL default '0', |
|---|
| 31 | `BYTES` bigint(20) unsigned NOT NULL default '0', |
|---|
| 32 | `PACKETS` bigint(20) unsigned NOT NULL default '0', |
|---|
| 33 | `FLOW_BEGIN` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 34 | `FLOW_END` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 35 | `SOURCE_AS` int(11) NOT NULL default '0', |
|---|
| 36 | `DEST_AS` int(11) NOT NULL default '0', |
|---|
| 37 | `SOURCE_MASK` smallint(6) NOT NULL default '0', |
|---|
| 38 | `DEST_MASK` smallint(6) NOT NULL default '0', |
|---|
| 39 | PRIMARY KEY (`RECNUM`), |
|---|
| 40 | KEY `k_begin` (`FLOW_BEGIN`), |
|---|
| 41 | KEY `k_end` (`FLOW_END`), |
|---|
| 42 | KEY `k_time` (`TIME_RECEIVED`), |
|---|
| 43 | KEY `k_src` (`SOURCE_IP`), |
|---|
| 44 | KEY `k_dst` (`DEST_IP`) |
|---|
| 45 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
|---|
| 46 | |
|---|
| 47 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
|---|
| 48 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
|---|
| 49 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
|---|
| 50 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
|---|
| 51 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
|---|
| 52 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|---|
| 53 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
|---|
