20220606.sql 665 B

123456789
  1. CREATE TABLE `tb_order_dinner_set` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `status` varchar(2) DEFAULT '1' COMMENT '状态1-开启;0-关闭',
  4. `orgId` int(11) DEFAULT NULL COMMENT '项目',
  5. `userId` int(11) DEFAULT NULL COMMENT '用户',
  6. PRIMARY KEY (`id`) USING BTREE
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订餐设置表';
  8. ALTER TABLE `tb_lingling_currentset` ADD COLUMN `orderAffirm` tinyint(3) DEFAULT 0 COMMENT '预约信息确认:1-开启;0-关闭;';