CREATE TABLE netflowa
(idauto
int(11) unsigned NOT NULL AUTO_INCREMENT,TimeSeconds
int(11) DEFAULT NULL,parsedDate
datetime DEFAULT NULL,dateTimeStr
bigint(20) DEFAULT NULL,ipLayerProtocol
tinyint(2) DEFAULT NULL,ipLayerProtocolCode
varchar(10) DEFAULT NULL,firstSeenSrcIp
varchar(20) DEFAULT NULL,firstSeenDestIp
varchar(20) DEFAULT NULL,firstSeenSrcPort
int(5) DEFAULT NULL,firstSeenDestPort
int(5) DEFAULT NULL,moreFragments
tinyint(2) DEFAULT NULL,contFragments
tinyint(2) DEFAULT NULL,durationSeconds
smallint(5) DEFAULT NULL,firstSeenSrcPayloadBytes
int(11) DEFAULT NULL,firstSeenDestPayloadBytes
int(11) DEFAULT NULL,firstSeenSrcTotalBytes
int(11) DEFAULT NULL,firstSeenDestTotalBytes
int(11) DEFAULT NULL,firstSeenSrcPacketCount
int(11) DEFAULT NULL,firstSeenDestPacketCount
int(11) DEFAULT NULL,recordForceOut
tinyint(2) DEFAULT NULL,slot1min
int(11) DEFAULT NULL,slot5min
int(11) DEFAULT NULL,slot30min
int(11) DEFAULT NULL,slot60min
int(11) DEFAULT NULL,
PRIMARY KEY (idauto
),
KEY index_nfa_sip
(firstSeenSrcIp
),
KEY index_nfa_sport
(firstSeenSrcPort
),
KEY index_nfa_dip
(firstSeenDestIp
),
KEY index_nfa_dport
(firstSeenDestPort
),
KEY index_nfa_slot1min
(slot1min
),
KEY index_nfa_slot5min
(slot5min
),
KEY index_nfa_slot30min
(slot30min
),
KEY index_nfa_slot60min
(slot60min
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
请帮我将这段MYsql的建表语句翻译成SQL sever语句,红色字两边有单引号
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-