CREATE TABLE `ey_shop_goods_label_bind` (
`bind_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID' ,
`aid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID(archives 表 aid 字段)' ,
`label_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品服務(wù)標(biāo)簽ID(shop_goods_label 表 label_id 字段)' ,
`add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '新增時(shí)間' ,
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間' ,
PRIMARY KEY (`bind_id`),
INDEX `aid` (`aid`) USING BTREE ,
INDEX `label_id` (`label_id`) USING BTREE
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
CHECKSUM=0
ROW_FORMAT=Fixed
DELAY_KEY_WRITE=0
;
可以SQL里面執(zhí)行這段 數(shù)據(jù)庫(kù)里面(記得備份)