haoshengxin/datas/新增表/bd_red_rule.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : building

Target Server Type    : MYSQL
Target Server Version : 50540
File Encoding         : 65001

Date: 2017-08-04 14:03:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bd_red_rule` 红包规则
-- ----------------------------
DROP TABLE IF EXISTS `bd_red_rule`;
CREATE TABLE `bd_red_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `red_id` int(11) NOT NULL COMMENT '红包活动id',
  `usecount` int(11) NOT NULL COMMENT '红包被打开次数',
  `joincount` int(11) NOT NULL DEFAULT '0' COMMENT '可参与该活动次数',
  `created_at` int(11) NOT NULL COMMENT '创建时间',
  `start_price` decimal(10,2) NOT NULL COMMENT '红包最小金额',
  `end_price` decimal(10,2) NOT NULL COMMENT '最大金额',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bd_red_rule
-- ----------------------------