<?php
//升级数据表
pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_card_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '门店id',
`price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额',
`cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡的id',
`type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值',
`time` int(10) NOT NULL DEFAULT '0' COMMENT '时间',
`cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员',
`paytype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1现金2微信支付3支付宝4银行卡',
`money` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='办卡充值记录';
");
if(!pdo_fieldexists('dy_card_log','id')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");}
if(!pdo_fieldexists('dy_card_log','sid')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `sid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '门店id'");}
if(!pdo_fieldexists('dy_card_log','price')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额'");}
if(!pdo_fieldexists('dy_card_log','cid')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡的id'");}
if(!pdo_fieldexists('dy_card_log','type')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值'");}
if(!pdo_fieldexists('dy_card_log','time')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间'");}
if(!pdo_fieldexists('dy_card_log','cashier')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员'");}
if(!pdo_fieldexists('dy_card_log','paytype')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `paytype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1现金2微信支付3支付宝4银行卡'");}
if(!pdo_fieldexists('dy_card_log','money')) {pdo_query("ALTER TABLE ".tablename('dy_card_log')." ADD `money` int(10) NOT NULL DEFAULT '0'");}
pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_card_order` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '门店id',
`cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡id',
`type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值 3消费 4冲正',
`time` int(10) NOT NULL DEFAULT '0' COMMENT '时间',
`price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额',
`ons` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1店内2手机',
`cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='会员卡办卡消费充值记录';
");
if(!pdo_fieldexists('dy_card_order','id')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");}
if(!pdo_fieldexists('dy_card_order','sid')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '门店id'");}
if(!pdo_fieldexists('dy_card_order','cid')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '会员卡id'");}
if(!pdo_fieldexists('dy_card_order','type')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1办卡 2充值 3消费 4冲正'");}
if(!pdo_fieldexists('dy_card_order','time')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间'");}
if(!pdo_fieldexists('dy_card_order','price')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金额'");}
if(!pdo_fieldexists('dy_card_order','ons')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `ons` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1店内2手机'");}
if(!pdo_fieldexists('dy_card_order','cashier')) {pdo_query("ALTER TABLE ".tablename('dy_card_order')." ADD `cashier` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '收银员id'");}
pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_desk` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家',
`cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
`number` varchar(32) NOT NULL DEFAULT '' COMMENT '桌台号',
`people` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '可座人数',
`sort` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '空闲挂单付款0 1 2',
`reserve` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '预订 1开0关',
`type` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COMMENT='餐桌';
");
if(!pdo_fieldexists('dy_desk','id')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");}
if(!pdo_fieldexists('dy_desk','sid')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家'");}
if(!pdo_fieldexists('dy_desk','cid')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id'");}
if(!pdo_fieldexists('dy_desk','number')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `number` varchar(32) NOT NULL DEFAULT '' COMMENT '桌台号'");}
if(!pdo_fieldexists('dy_desk','people')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `people` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '可座人数'");}
if(!pdo_fieldexists('dy_desk','sort')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `sort` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '排序'");}
if(!pdo_fieldexists('dy_desk','status')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '空闲挂单付款0 1 2'");}
if(!pdo_fieldexists('dy_desk','reserve')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `reserve` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '预订 1开0关'");}
if(!pdo_fieldexists('dy_desk','type')) {pdo_query("ALTER TABLE ".tablename('dy_desk')." ADD `type` tinyint(1) NOT NULL DEFAULT '0'");}
pdo_query("CREATE TABLE IF NOT EXISTS `ims_dy_desk_cate` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家id',
`cate` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称',
`minimum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最低消费',
`imprest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '预付款',
`tea_money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '茶水费',
`additional` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '小于最低收取',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='餐桌分类';
");
if(!pdo_fieldexists('dy_desk_cate','id')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT");}
if(!pdo_fieldexists('dy_desk_cate','sid')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商家id'");}
if(!pdo_fieldexists('dy_desk_cate','cate')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `cate` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称'");}
if(!pdo_fieldexists('dy_desk_cate','minimum')) {pdo_query("ALTER TABLE ".tablename('dy_desk_cate')." ADD `minimum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最低消费'");}
if(!pdo_fieldexists('dy_desk_cate','i