Open unissoft-bj opened 9 years ago
DROP TABLE IF EXISTS eth_packet; /_!40101 SET @saved_cs_client = @@character_setclient */; /!40101 SET character_setclient = utf8 /; CREATE TABLE eth_packet ( id int(11) NOT NULL AUTO_INCREMENT, mac varchar(17) DEFAULT NULL, pkttime varchar(10) DEFAULT NULL, srcip varchar(16) DEFAULT NULL, destip varchar(16) DEFAULT NULL, uri varchar(4096) DEFAULT NULL, create_t datetime DEFAULT NULL, src_ip_mac varchar(17) DEFAULT NULL, PRIMARY KEY (id), KEY packettime (pkttime), KEY mac (mac) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /_!40101 SET character_set_client = @saved_cs_client */;
eth_packet
id
mac
pkttime
srcip
destip
uri
create_t
src_ip_mac
packettime
DROP TABLE IF EXISTS
eth_packet; /_!40101 SET @saved_cs_client = @@character_setclient */; /!40101 SET character_setclient = utf8 /; CREATE TABLEeth_packet(idint(11) NOT NULL AUTO_INCREMENT,macvarchar(17) DEFAULT NULL,pkttimevarchar(10) DEFAULT NULL,srcipvarchar(16) DEFAULT NULL,destipvarchar(16) DEFAULT NULL,urivarchar(4096) DEFAULT NULL,create_tdatetime DEFAULT NULL,src_ip_macvarchar(17) DEFAULT NULL, PRIMARY KEY (id), KEYpackettime(pkttime), KEYmac(mac) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /_!40101 SET character_set_client = @saved_cs_client */;