追加予定(未チェック)
CREATE VIEW sumtrafficphp AS SELECT min(dtime), max(dtime), count(*), fileid, snode, soffset,sla, slo, scountry, scity, sport, dnode, doffset, dla, dlo, dcountry, dcity, dport, mes FROM trafficphp
GROUP BY fileid, snode, soffset, sla, slo, scountry, scity, sport, dnode, doffset, dla, dlo, dcountry, dcity, dport, mes;
CREATE VIEW sumtrafficphpnotoffset AS SELECT min(dtime), max(dtime), count(*), fileid, snode, min(soffset), max(soffset), sla, slo, scountry, scity, sport, dnode, min(doffset), max(doffset), dla, dlo, dcountry, dcity, dport, mes FROM trafficphp
GROUP BY fileid, snode, sla, slo, scountry, scity, sport, dnode, dla, dlo, dcountry, dcity, dport, mes;
CREATE VIEW sumtrafficphpnotoffset AS SELECT min(dtime), max(dtime), count(*), fileid, snode, min(soffset) AS minso, max(soffset) AS maxso, sla, slo, scountry, scity, sport, dnode, min(doffset) AS mindo, max(doffset) AS maxdo, dla, dlo, dcountry, dcity, dport, mes FROM trafficphp
GROUP BY fileid, snode, sla, slo, scountry, scity, sport, dnode, dla, dlo, dcountry, dcity, dport, mes;