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

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bd_activity_receive`  红包领取记录
-- ----------------------------
DROP TABLE IF EXISTS `bd_activity_receive`;
CREATE TABLE `bd_activity_receive` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `activity_id` int(11) NOT NULL COMMENT '活动编号',
  `source_id` int(11) NOT NULL COMMENT '获取来源ID',
  `amount` decimal(10,2) NOT NULL COMMENT '金额',
  `receive_at` int(11) NOT NULL COMMENT '领取时间',
  `valid_at` int(11) NOT NULL COMMENT '有效时间',
  `updated_at` int(11) NOT NULL COMMENT '最后修改时间',
  `status` tinyint(4) NOT NULL COMMENT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;