```[sql] -- ---------------------------- -- Table structure for ns_promotion_freeshipping -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_freeshipping`; CREATE TABLE `ns_promotion_freeshipping` ( `freeshipping_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '金额', `area_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '地区ids', `area_names` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '地区名称', `surplus_area_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`freeshipping_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '满额包邮' ROW_FORMAT = Compact;