SET NAMES 'GBK';
DELIMITER ;//


/* ÍøÅÌÉó¼Æ±í */
DROP TABLE IF EXISTS SM_WEB_DISK;
CREATE TABLE SM_WEB_DISK (
  `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',
  `HOST` varchar(128) DEFAULT NULL,
  `HOST_DESC` varchar(128) DEFAULT NULL,
  `URL` varchar(1024) DEFAULT NULL,
  `FILE_NAME` varchar(1024) DEFAULT NULL,
  `FILE_SIZE` int(11) DEFAULT '0',
  `UP_OR_DOWN` int(11) DEFAULT '0',
  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`),
  KEY `IDX_SM_WEB_CLI_MAC` (`CLI_MAC`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk PARTITION BY HASH (PART_FD) PARTITIONS 100 ;

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