SET NAMES 'GBK';
DELIMITER ;//


/*QQÎÄ¼þÉó¼Æ±í*/
DROP TABLE IF EXISTS SM_QQ_FILE;
CREATE TABLE SM_QQ_FILE (
  `SU_SEQ` bigint(20) NOT NULL,
  `PART_FD` int(11) NOT NULL,
  `TIME_BEGIN` datetime DEFAULT NULL,
  `TIME_END` datetime DEFAULT NULL,
  `CLI_DID` bigint(20) NOT NULL DEFAULT '0',
  `CLI_IP` bigint(20) DEFAULT '0',
  `CLI_PORT` int(11) DEFAULT '-1',
  `CLI_MAC` varchar(17) DEFAULT NULL,
  `CLI_AREA_ID` bigint(20) unsigned DEFAULT '0',
  `CLI_DETAIL` varchar(256) DEFAULT NULL,
  `SRV_IP` bigint(20) DEFAULT '0',
  `SRV_PORT` int(11) DEFAULT '-1',
  `SRV_MAC` varchar(17) DEFAULT NULL,
  `SRV_AREA_ID` bigint(20) unsigned DEFAULT '0',
  `SRV_DETAIL` varchar(256) DEFAULT NULL,
  `SRV_DOMAIN` varchar(256) DEFAULT NULL,
  `SUBAPP_TYPE` int(11) DEFAULT '-1',
  `ACCOUNT` varchar(128) DEFAULT NULL,
  `NICKNAME` varchar(128) DEFAULT NULL,
  `FRIEND_ACCOUNT` varchar(1024) DEFAULT NULL,
  `FRIEND_NICKNAME` varchar(1024) DEFAULT NULL,
  `FRIEND_GROUP` varchar(512) DEFAULT NULL,
  `FILE_NAME` varchar(128) DEFAULT NULL,
  `FILE_SIZE` int(11) DEFAULT '0',
  `FILE_STATUS` int(11) DEFAULT NULL,
  `FILE_OPERATOR_TYPE` int(11) DEFAULT NULL,
  `SAVE_SEQ` bigint(20) DEFAULT NULL,
  KEY `SU_SEQ` (`SU_SEQ`),
  KEY `IDX_SM_QQ_FILE_CLI_IP` (`CLI_IP`),
  KEY `IDX_SM_QQ_FILE_SRV_IP` (`SRV_IP`),
  KEY `IDX_SM_WEB_CLI_DID` (`CLI_DID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk PARTITION BY HASH (PART_FD) PARTITIONS 100 ;

UPDATE CFG_PRODUCT_VARIABLES SET VALUE='1.1.3.1' WHERE VARIABLE_NAME='DB_VERSION';
