haoshengxin/datas/新增表/bd_red_activity.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:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bd_red_activity` 红包活动
-- ----------------------------
DROP TABLE IF EXISTS `bd_red_activity`;
CREATE TABLE `bd_red_activity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL COMMENT '标题',
  `rule_id` int(11) NOT NULL COMMENT '规则id',
  `created_at` int(11) NOT NULL,
  `province` varchar(32) NOT NULL,
  `city` varchar(32) NOT NULL COMMENT '城市',
  `type` tinyint(4) NOT NULL COMMENT '类型',
  `total_amount` decimal(10,2) NOT NULL COMMENT '总金额',
  `price_interval` varchar(32) NOT NULL COMMENT '单个红包金额区间',
  `number` int(11) NOT NULL COMMENT '个数/工地',
  `valid_at` int(11) NOT NULL COMMENT '有效时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bd_red_activity
-- ----------------------------