mysql db schema

[CS Lee]

hi Carter,

This is the one I'm currently testing -

mysql> SHOW CREATE TABLE tbl_test \G;
*************************** 1. row ***************************
       Table: tbl_test
Create Table: CREATE TABLE `tbl_test` (
  `autoid` int(11) NOT NULL AUTO_INCREMENT,
  `stime` int(10) unsigned DEFAULT NULL,
  `srcid` varchar(64) NOT NULL DEFAULT '',
  `proto` varchar(16) NOT NULL,
  `saddr` int(10) unsigned NOT NULL DEFAULT '0',
  `sport` smallint(5) unsigned NOT NULL DEFAULT '0',
  `dir` varchar(3) DEFAULT NULL,
  `daddr` int(10) unsigned NOT NULL DEFAULT '0',
  `dport` smallint(5) unsigned NOT NULL DEFAULT '0',
  `pkts` bigint(20) DEFAULT NULL,
  `bytes` bigint(20) DEFAULT NULL,
  `appbytes` bigint(20) DEFAULT NULL,
  `state` varchar(32) DEFAULT NULL,
  `flgs` varchar(32) DEFAULT NULL,
  `dur` double(18,6) NOT NULL,
  `spkts` bigint(20) DEFAULT NULL,
  `dpkts` bigint(20) DEFAULT NULL,
  `sbytes` bigint(20) DEFAULT NULL,
  `dbytes` bigint(20) DEFAULT NULL,
  `sappbytes` bigint(20) DEFAULT NULL,
  `dappbytes` bigint(20) DEFAULT NULL,
  `smaxsz` smallint(5) unsigned DEFAULT NULL,
  `dmaxsz` smallint(5) unsigned DEFAULT NULL,
  `sminsz` smallint(5) unsigned DEFAULT NULL,
  `dminsz` smallint(5) unsigned DEFAULT NULL,
  `smac` varchar(24) DEFAULT NULL,
  `dmac` varchar(24) DEFAULT NULL,
  `sco` varchar(2) DEFAULT NULL,
  `dco` varchar(2) DEFAULT NULL,
  `sas` int(10) unsigned DEFAULT NULL,
  `das` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`autoid`,`srcid`,`proto`,`saddr`,`sport`,`daddr`,`dport`)
) ENGINE=InnoDB AUTO_INCREMENT=910612 DEFAULT CHARSET=latin1

I haven't checked through the default data type for other field yet unless
I'm including them. The most obvious changes here are stime,
saddr,daddr,sport,dport are all integer and not string data type anymore.

By the way regarding your question about whether command line or rarc
taking precedence, I'm with you where command line specification is always
priority.

-- 
Best Regards,

CS Lee<geek00L[at]gmail.com>

http://geek00l.blogspot.com
http://defcraft.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20120628/bbe18648/attachment.html>