CRC

CREATE TABLE `qjcx_product_permission` (

  `DATA_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `USER_ID` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id,crc',

  `PRODUCT_DATA_ID` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '产品id',

  `PROVIDER_DATA_ID` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '供应商data_id',

  `MODEL` char(10) NOT NULL DEFAULT '' COMMENT '型号',

  `IMPORTANCE_NAME_KEY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重要程度',

  `PRODUCT_USE_SCOPE_KEY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '型号领域key',

  `PRODUCT_USE_SCOPE_KEY_CRC` bigint(20) NOT NULL DEFAULT '0' COMMENT '型号领域key crc',

  `CATEGORY_KEY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '产品属性key',

  `LEVEL_CLASS_KEY` int(11) NOT NULL DEFAULT '0' COMMENT '产品层级key',

  PRIMARY KEY (`DATA_ID`),

  KEY `USER_ID` (`USER_ID`) USING BTREE,

  KEY `RPOVIDER_DATA_ID` (`PROVIDER_DATA_ID`) USING BTREE,

  KEY `UNI_TABLE_1` (`USER_ID`,`PROVIDER_DATA_ID`),

  KEY `UNI_TABLE_3` (`USER_ID`,`PRODUCT_USE_SCOPE_KEY`,`PROVIDER_DATA_ID`),

  KEY `UNI_TABLE_4` (`USER_ID`,`PROVIDER_DATA_ID`,`PRODUCT_USE_SCOPE_KEY_CRC`),

  KEY `UNI_TABLE_5` (`USER_ID`,`PROVIDER_DATA_ID`,`MODEL`),

  KEY `MPORTANCE_NAME_KEY` (`IMPORTANCE_NAME_KEY`),

  KEY `UNI_TABLE_2` (`USER_ID`,`IMPORTANCE_NAME_KEY`,`PROVIDER_DATA_ID`) USING BTREE

) ENGINE=MyISAM AUTO_INCREMENT=10049800 DEFAULT CHARSET=utf8 COMMENT='人员的产品权限';