平面设计广告设计室内设计

<?php //升级数据表 pdo_query("CREATE TABLE IF NOT EXISTS `ims_ybshop_access_token` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `appid` varchar(255) NOT NULL COMMENT 'appid', `access_token` varchar(255) NOT NULL COMMENT 'access_token', `refresh_token` varchar(255) DEFAULT '' COMMENT 'refresh_token', `expire_time` int(11) NOT NULL DEFAULT '0' COMMENT '过期时间', `platform` tinyint(3) NOT NULL DEFAULT '0' COMMENT '所属平台: 0微信|1百度|2支付宝|3字节跳动|4公众号|5手机站|6QQ', `mch_id` int(11) NOT NULL COMMENT '应用id', `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '店铺ID', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='access_token表'; "); if(!pdo_fieldexists('ybshop_access_token','id')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id'");} if(!pdo_fieldexists('ybshop_access_token','appid')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `appid` varchar(255) NOT NULL COMMENT 'appid'");} if(!pdo_fieldexists('ybshop_access_token','access_token')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `access_token` varchar(255) NOT NULL COMMENT 'access_token'");} if(!pdo_fieldexists('ybshop_access_token','refresh_token')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `refresh_token` varchar(255) DEFAULT '' COMMENT 'refresh_token'");} if(!pdo_fieldexists('ybshop_access_token','expire_time')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `expire_time` int(11) NOT NULL DEFAULT '0' COMMENT '过期时间'");} if(!pdo_fieldexists('ybshop_access_token','platform')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `platform` tinyint(3) NOT NULL DEFAULT '0' COMMENT '所属平台: 0微信|1百度|2支付宝|3字节跳动|4公众号|5手机站|6QQ'");} if(!pdo_fieldexists('ybshop_access_token','mch_id')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `mch_id` int(11) NOT NULL COMMENT '应用id'");} if(!pdo_fieldexists('ybshop_access_token','shop_id')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '店铺ID'");} if(!pdo_fieldexists('ybshop_access_token','create_time')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间'");} if(!pdo_fieldexists('ybshop_access_token','update_time')) {pdo_query("ALTER TABLE ".tablename('ybshop_access_token')." ADD `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间'");} pdo_query("CREATE TABLE IF NOT EXISTS `ims_ybshop_activity_bargain` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `goods_id` int(11) NOT NULL COMMENT '商品id', `title` varchar(500) NOT NULL COMMENT '活动名称', `start_time` int(11) NOT NULL COMMENT '开始时间', `end_time` int(11) NOT NULL COMMENT '结束时间', `bottom_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '底价', `activity_stock` int(11) NOT NULL COMMENT '砍价库存', `quota` int(11) NOT NULL DEFAULT '0' COMMENT '限购数 0/不限购', `sales_volume` int(11) NOT NULL DEFAULT '0' COMMENT '销量', `cut_mode` tinyint(1) NOT NULL DEFAULT '1' COMMENT '砍价模式：1/砍到底价后购买 2/无需砍到底价即可购买', `complete_number` int(11) NOT NULL COMMENT '需要几个好友才能砍到底价', `visit_count` int(11) NOT NULL DEFAULT '0' COMMENT '访问人数', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 0/作废 1/正常', `is_recommend` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否推荐，0-否，1-是', `is_integral` tinyint(1) NOT NULL DEFAULT '0' COMMENT '购买计算积分 0/关闭 1/打开 2/默认', `give_integral` int(11) NOT NULL DEFAULT '0' COMMENT '赠送积分值', `is_growth_value` tinyint(1) NOT NULL DEFAULT '0' COMMENT '赠送成长值开关：0-关闭，1-开启，2-默认', `give_growth_value` int(11) NOT NULL DEFAULT '0' COMMENT '赠送成长值', `is_distribute` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否参与分销：0-不参与；1-参与', `is_member_count` tinyint(1) NOT NULL DEFAULT '1' COMMENT '人数统计开关：0-关闭，1-开启', `activity_explain` text COMMENT '活动说明', `mch_id` int(11) NOT NULL COMMENT '应用id', `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '店铺ID', `create_time` int(11) NOT NULL COMMENT '添加时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', `delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '删除时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品砍价活动表'; "); if(!pdo_fieldexists('ybshop_activity_bargain','id')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id'");} if(!pdo_fieldexists('ybshop_activity_bargain','goods_id')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `goods_id` int(11) NOT NULL COMMENT '商品id'");} if(!pdo_fieldexists('ybshop_activity_bargain','title')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `title` varchar(500) NOT NULL COMMENT '活动名称'");} if(!pdo_fieldexists('ybshop_activity_bargain','start_time')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `start_time` int(11) NOT NULL COMMENT '开始时间'");} if(!pdo_fieldexists('ybshop_activity_bargain','end_time')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `end_time` int(11) NOT NULL COMMENT '结束时间'");} if(!pdo_fieldexists('ybshop_activity_bargain','bottom_price')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `bottom_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '底价'");} if(!pdo_fieldexists('ybshop_activity_bargain','activity_stock')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `activity_stock` int(11) NOT NULL COMMENT '砍价库存'");} if(!pdo_fieldexists('ybshop_activity_bargain','quota')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `quota` int(11) NOT NULL DEFAULT '0' COMMENT '限购数 0/不限购'");} if(!pdo_fieldexists('ybshop_activity_bargain','sales_volume')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `sales_volume` int(11) NOT NULL DEFAULT '0' COMMENT '销量'");} if(!pdo_fieldexists('ybshop_activity_bargain','cut_mode')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `cut_mode` tinyint(1) NOT NULL DEFAULT '1' COMMENT '砍价模式：1/砍到底价后购买 2/无需砍到底价即可购买'");} if(!pdo_fieldexists('ybshop_activity_bargain','complete_number')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `complete_number` int(11) NOT NULL COMMENT '需要几个好友才能砍到底价'");} if(!pdo_fieldexists('ybshop_activity_bargain','visit_count')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `visit_count` int(11) NOT NULL DEFAULT '0' COMMENT '访问人数'");} if(!pdo_fieldexists('ybshop_activity_bargain','status')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 0/作废 1/正常'");} if(!pdo_fieldexists('ybshop_activity_bargain','is_recommend')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `is_recommend` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否推荐，0-否，1-是'");} if(!pdo_fieldexists('ybshop_activity_bargain','is_integral')) {pdo_query("ALTER TABLE ".tablename('ybshop_activity_bargain')." ADD `is_integral` tinyint(1) NOT NULL DEFAULT '0' COMMENT '购买计算积分 0/关闭 1/打开 2/默认'");} if(!pdo_fieldexist