BiTel

    + "min_cost float(10,5) NOT NULL,"

| log_session_12_201503 | CREATE TABLE `log_session_12_201503` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_id` int(11) NOT NULL,
  `hour` datetime NOT NULL,
  `cdr_id` int(11) NOT NULL,
  `session_start` datetime NOT NULL,
  `session_time` int(11) NOT NULL,
  `round_session_time` int(11) NOT NULL,
  `from_number` varchar(20) NOT NULL,
  `from_number_164` varchar(20) NOT NULL,
  `to_number` varchar(20) NOT NULL,
  `to_number_164` varchar(20) NOT NULL,
  `cid` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `dest_id` int(11) NOT NULL,
  `sid` int(11) NOT NULL,
  `min_cost` float(10,5) NOT NULL,
  `cost` decimal(10,5) NOT NULL,
  `zone` int(11) NOT NULL,
  `oper_round_session_time` int(11) NOT NULL,
  `oper_cost_map_item_id` int(11) NOT NULL DEFAULT '0',
  `oper_cost` decimal(10,5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `session_start` (`session_start`),
  KEY `log` (`source_id`,`hour`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `item_id` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26555 DEFAULT CHARSET=cp1251 |