--
-- 这是扩展的表
-- 前缀都是以ims_ewei_shop_groups_开头
--

-- 扩展类配置文件 ， 为了后期维护先，先加载进去

DROP TABLE IF EXISTS `ims_ewei_shop_groups_extend_system`;

CREATE TABLE `ims_ewei_shop_groups_extend_system` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `param` decimal(5,3) NOT NULL comment '配置参数值',
    `name` varchar(255) NOT NULL comment '配置参数名称',
    PRIMARY KEY(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 团购的订单是否已经提现,提现的订单将出现在这个表中

DROP TABLE IF EXISTS `ims_ewei_shop_groups_extend_extracted`;

CREATE TABLE `ims_ewei_shop_groups_extend_extracted` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `openid` varchar(255) NOT NULL comment '提取余额的用户的openid',
    `groups_order_id` varchar(255) NOT NULL comment '团购订单的id',
    `status` enum('1','0','2') DEFAULT '0' NOT NULL comment '1: 审核成功 ， 0: 等待审核， 2: 审核失败 提醒管理员查看消息也是通过这个来进行的',
    `price` decimal(11,2) NOT NULL,
    `createtime` int(11) NOT NULL,
    `reason` varchar(255) default '' NOT NULL,
    PRIMARY KEY(`id`),
    key `openid` (`openid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `ims_ewei_shop_groups_extend_system` (`name`,`param`) VALUES ('m_off','10');

INSERT INTO `ims_ewei_shop_groups_extend_extracted` VALUES (1,'sns_wa_ogO535B13DAXOnXA9YtIGdLU4Mv4','PT20181203173823281660','0','1','1543829914','');
INSERT INTO `ims_ewei_shop_groups_extend_extracted` VALUES (2,'sns_wa_ogO535CCP_S9o-oM\XvMU1XsCPQAg','PT20181203173925464543','0','2','1543829978','');