doc/mysql.table

   1 CREATE TABLE ulog (     id              INT UNSIGNED AUTO_INCREMENT UNIQUE,
   2
   3                         raw_mac         VARCHAR(80),
   4
   5                         oob_time_sec    INT UNSIGNED,
   6                         oob_time_usec   INT UNSIGNED,
   7                         oob_prefix      VARCHAR(32),
   8                         oob_mark        INT UNSIGNED,
   9                         oob_in          VARCHAR(32),
  10                         oob_out         VARCHAR(32),
  11
  12                         ip_saddr        INT UNSIGNED,
  13                         ip_daddr        INT UNSIGNED,
  14                         ip_protocol     TINYINT UNSIGNED,
  15                         ip_tos          TINYINT UNSIGNED,
  16                         ip_ttl          TINYINT UNSIGNED,
  17                         ip_totlen       SMALLINT UNSIGNED,
  18                         ip_ihl          TINYINT UNSIGNED,
  19                         ip_csum         SMALLINT UNSIGNED,
  20                         ip_id           SMALLINT UNSIGNED,
  21                         ip_fragoff      SMALLINT UNSIGNED,
  22
  23                         tcp_sport       SMALLINT UNSIGNED,
  24                         tcp_dport       SMALLINT UNSIGNED,
  25                         tcp_seq         INT UNSIGNED,
  26                         tcp_ackseq      INT UNSIGNED,
  27                         tcp_window      SMALLINT UNSIGNED,
  28                         tcp_urg         TINYINT,
  29                         tcp_urgp        SMALLINT UNSIGNED,
  30                         tcp_ack         TINYINT,
  31                         tcp_psh         TINYINT,
  32                         tcp_rst         TINYINT,
  33                         tcp_syn         TINYINT,
  34                         tcp_fin         TINYINT,
  35
  36                         udp_sport       SMALLINT UNSIGNED,
  37                         udp_dport       SMALLINT UNSIGNED,
  38                         udp_len         SMALLINT UNSIGNED,
  39
  40                         icmp_type       TINYINT UNSIGNED,
  41                         icmp_code       TINYINT UNSIGNED,
  42                         icmp_echoid     SMALLINT UNSIGNED,
  43                         icmp_echoseq    SMALLINT UNSIGNED,
  44                         icmp_gateway    INT UNSIGNED,
  45                         icmp_fragmtu    SMALLINT UNSIGNED,
  46
  47                         pwsniff_user    VARCHAR(30),
  48                         pwsniff_pass    VARCHAR(30),
  49
  50                         ahesp_spi       INT UNSIGNED,
  51
  52                         KEY index_id    (id)
  53                 );
  54
  55