uEkvnr2S

1CREATE TABLE IF NOT EXISTS BsSsPacketCounters ( bsSsPacketCountersSourceServiceFlowId INTEGER UNSIGNED NOT NULL, wmanIfBsSsMacSduCount BIGINT UNSIGNED NOT NULL, wmanIfBsSsOctetCount BIGINT UNSIGNED NOT NULL, recordTime DATETIME NOT NULL, isValid BOOLEAN NOT NULL DEFAULT true,  INDEX (recordTime), INDEX (bsSsPacketCountersSourceServiceFlowId, recordTime)) ENGINE=innoDB PARTITION BY RANGE (TO_DAYS(recordTime))(PARTITION `P2011-11-11` VALUES LESS THAN (TO_DAYS('2011-11-11')),PARTITION `P2011-11-12` VALUES LESS THAN (TO_DAYS('2011-11-12')),PARTITION `P2011-11-13` VALUES LESS THAN (TO_DAYS('2011-11-13')),PARTITION PMAX VALUES LESS THAN MAXVALUE