1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 |
- DROP TABLE IF EXISTS `lm_user`;
- CREATE TABLE `lm_user` (
- `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user` varchar (128) NULL DEFAULT '' COMMENT '用户',
- `name` varchar (128) NULL DEFAULT '' COMMENT '呢称',
- `pwd` varchar (255) NULL DEFAULT '' COMMENT '密码',
- `openid` varchar (255) NULL DEFAULT '' COMMENT '微信登录openid',
- `token` varchar (255) NULL DEFAULT '' COMMENT 'token',
- `money` decimal (20,2) NULL DEFAULT '0' COMMENT '账号余额',
- `push_money` decimal (20,2) NULL DEFAULT '0' COMMENT '发布余额',
- `status` int (1) NULL DEFAULT '0' COMMENT '0 正常 1 禁止登录',
- `status_time` varchar (20) NULL DEFAULT '' COMMENT '封号时间',
- `create_time` varchar (20) NULL DEFAULT '' COMMENT '创建时间',
- `vip_time` varchar (20) NULL DEFAULT '' COMMENT '会员到期时间',
- `vip_level` int (1) NULL DEFAULT 0 COMMENT '0 普通会员 1 周卡 2月卡 3 年卡 ',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = Compact;
- DROP TABLE IF EXISTS `lm_task`;
- CREATE TABLE `lm_task` (
- `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` int (11) DEFAULT 0 COMMENT '0 实名制 1 下载注册 2 网页注册 3 关注投票 4 分享转发 5电子商务 6多天任务 7 特单任务',
- `user_id` int (11) DEFAULT 0 COMMENT '用户id',
- `name` varchar (128) DEFAULT '' COMMENT '任务名称',
- `explain` varchar (255) DEFAULT '' COMMENT '任务说明',
- `text` text DEFAULT '' COMMENT '任务步骤',
- `num` int (11) DEFAULT 0 COMMENT '剩余数量',
- `nums` int (11) DEFAULT 0 COMMENT '总数量',
- `money` decimal (11,2) DEFAULT 0 COMMENT '实际金额',
- `put_money` decimal (11,2) DEFAULT 0 COMMENT '上架金额',
- `status` int (11) DEFAULT 0 COMMENT '0 审核中 1 审核通过 2 审核失败 3 已完成 4 已禁止',
- `msg` varchar (128) DEFAULT '' COMMENT '审核失败原因 ',
- `repeat` int (11) DEFAULT 0 COMMENT '0 可以重复做 1 不可以 ',
- `end_task_time` varchar (20) NULL DEFAULT '' COMMENT '设置的结束时间',
- `push_time` varchar (20) NULL DEFAULT '' COMMENT '提交时间',
- `examine_time` varchar (20) NULL DEFAULT '' COMMENT '审核时长时间',
- `create_time` varchar (20) NULL DEFAULT '' COMMENT '创建时间',
- `update_time` varchar (20) NULL DEFAULT '' COMMENT '更新时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '任务列表' ROW_FORMAT = Compact;
- DROP TABLE IF EXISTS `lm_task_order`;
- CREATE TABLE `lm_task_order` (
- `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` int (11) DEFAULT 0 COMMENT '用户id',
- `user_id` int (11) DEFAULT 0 COMMENT '商户id',
- `task_id` int (11) DEFAULT 0 COMMENT '任务id',
- `push` int (32) DEFAULT 0 COMMENT '提交时长',
- `examine` int (32) DEFAULT 0 COMMENT '审核时长',
- `add_time` varchar (20) DEFAULT 0 COMMENT '添加时间',
- `push_time` varchar (20) DEFAULT 0 COMMENT '提交任务时间',
- `content` text DEFAULT '' COMMENT '驳回数据',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '订单列表' ROW_FORMAT = Compact;
|