superdesk_superservice/sql/longmeizhen/20220606.sql

CREATE TABLE `tb_order_dinner_set` (
                                       `id` int(11) NOT NULL AUTO_INCREMENT,
                                       `status` varchar(2) DEFAULT '1' COMMENT '状态1-开启；0-关闭',
                                       `orgId` int(11) DEFAULT NULL COMMENT '项目',
                                       `userId` int(11) DEFAULT NULL COMMENT '用户',
                                       PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订餐设置表';

ALTER TABLE `tb_lingling_currentset` ADD COLUMN `orderAffirm` tinyint(3) DEFAULT 0 COMMENT '预约信息确认:1-开启；0-关闭；';


ALTER TABLE `tb_user` ADD COLUMN `isPushState` tinyint(3) DEFAULT 1 COMMENT '是否开启订餐提醒:1-开启；0-关闭；';