ALTER TABLE  `ts_shop` ADD  `shop_num` int(11) NOT NULL DEFAULT '1' AFTER `shop_ico`;
ALTER TABLE  `ts_shop` ADD  `credit_type` char(15)  NULL DEFAULT NULL AFTER `use_cont`;

UPDATE `ts_system_config` SET `value` = 'a:4:{s:3:"key";a:9:{s:3:"sid";s:3:"sid";s:9:"shop_name";s:9:"shop_name";s:8:"shop_ico";s:8:"shop_ico";s:8:"shop_num";s:8:"shop_num";s:11:"credit_type";s:11:"credit_type";s:6:"credit";s:6:"credit";s:6:"people";s:6:"people";s:7:"endtime";s:7:"endtime";s:8:"DOACTION";s:8:"DOACTION";}s:8:"key_name";a:9:{s:3:"sid";s:8:"商品ID";s:9:"shop_name";s:9:"商品名";s:8:"shop_ico";s:12:"商品图片";s:8:"shop_num";s:12:"商品数量";s:11:"credit_type";s:12:"积分类型";s:6:"credit";s:12:"兑换积分";s:6:"people";s:12:"兑换人数";s:7:"endtime";s:12:"结束时间";s:8:"DOACTION";s:6:"操作";}s:10:"key_hidden";a:9:{s:3:"sid";s:1:"0";s:9:"shop_name";s:1:"0";s:8:"shop_ico";s:1:"0";s:8:"shop_num";s:1:"0";s:11:"credit_type";s:1:"0";s:6:"credit";s:1:"0";s:6:"people";s:1:"0";s:7:"endtime";s:1:"0";s:8:"DOACTION";s:1:"0";}s:14:"key_javascript";a:9:{s:3:"sid";s:0:"";s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:6:"people";s:0:"";s:7:"endtime";s:0:"";s:8:"DOACTION";s:0:"";}}' WHERE `key` ='shop_Admin_index';
UPDATE `ts_system_config` SET `value` = 'a:6:{s:3:"key";a:7:{s:9:"shop_name";s:9:"shop_name";s:8:"shop_ico";s:8:"shop_ico";s:8:"shop_num";s:8:"shop_num";s:8:"use_cont";s:8:"use_cont";s:11:"credit_type";s:11:"credit_type";s:6:"credit";s:6:"credit";s:7:"endtime";s:7:"endtime";}s:8:"key_name";a:7:{s:9:"shop_name";s:12:"商品名称";s:8:"shop_ico";s:12:"商品图片";s:8:"shop_num";s:12:"商品数量";s:8:"use_cont";s:6:"介绍";s:11:"credit_type";s:18:"兑换积分类型";s:6:"credit";s:18:"兑换所需积分";s:7:"endtime";s:12:"结束时间";}s:8:"key_type";a:7:{s:9:"shop_name";s:4:"text";s:8:"shop_ico";s:5:"image";s:8:"shop_num";s:4:"text";s:8:"use_cont";s:6:"editor";s:11:"credit_type";s:5:"radio";s:6:"credit";s:4:"text";s:7:"endtime";s:4:"date";}s:11:"key_default";a:7:{s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:8:"use_cont";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:7:"endtime";s:0:"";}s:9:"key_tishi";a:7:{s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:8:"use_cont";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:7:"endtime";s:0:"";}s:14:"key_javascript";a:7:{s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:8:"use_cont";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:7:"endtime";s:0:"";}}' WHERE `key` ='shop_Admin_addshop';
UPDATE `ts_system_config` SET `value` = 'a:6:{s:3:"key";a:8:{s:3:"sid";s:3:"sid";s:9:"shop_name";s:9:"shop_name";s:8:"shop_ico";s:8:"shop_ico";s:8:"shop_num";s:8:"shop_num";s:8:"use_cont";s:8:"use_cont";s:11:"credit_type";s:11:"credit_type";s:6:"credit";s:6:"credit";s:7:"endtime";s:7:"endtime";}s:8:"key_name";a:8:{s:3:"sid";s:8:"商品ID";s:9:"shop_name";s:9:"商品名";s:8:"shop_ico";s:12:"商品图片";s:8:"shop_num";s:12:"商品数量";s:8:"use_cont";s:6:"介绍";s:11:"credit_type";s:18:"兑换积分类型";s:6:"credit";s:18:"兑换所需积分";s:7:"endtime";s:12:"结束时间";}s:8:"key_type";a:8:{s:3:"sid";s:6:"hidden";s:9:"shop_name";s:4:"text";s:8:"shop_ico";s:5:"image";s:8:"shop_num";s:4:"text";s:8:"use_cont";s:6:"editor";s:11:"credit_type";s:5:"radio";s:6:"credit";s:4:"text";s:7:"endtime";s:4:"date";}s:11:"key_default";a:8:{s:3:"sid";s:0:"";s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:8:"use_cont";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:7:"endtime";s:0:"";}s:9:"key_tishi";a:8:{s:3:"sid";s:0:"";s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:8:"use_cont";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:7:"endtime";s:0:"";}s:14:"key_javascript";a:8:{s:3:"sid";s:0:"";s:9:"shop_name";s:0:"";s:8:"shop_ico";s:0:"";s:8:"shop_num";s:0:"";s:8:"use_cont";s:0:"";s:11:"credit_type";s:0:"";s:6:"credit";s:0:"";s:7:"endtime";s:0:"";}}' WHERE `key` ='shop_Admin_editshop';
UPDATE `ts_system_config` SET `value` = 'a:4:{s:3:"key";a:7:{s:3:"cid";s:3:"cid";s:3:"uid";s:3:"uid";s:3:"sid";s:3:"sid";s:8:"dateline";s:8:"dateline";s:8:"shop_num";s:8:"shop_num";s:3:"get";s:3:"get";s:6:"setget";s:6:"setget";}s:8:"key_name";a:7:{s:3:"cid";s:6:"序号";s:3:"uid";s:9:"用户名";s:3:"sid";s:8:"商品ID";s:8:"dateline";s:12:"兑换时间";s:8:"shop_num";s:12:"兑换数量";s:3:"get";s:12:"领取状态";s:6:"setget";s:6:"操作";}s:10:"key_hidden";a:7:{s:3:"cid";s:1:"0";s:3:"uid";s:1:"0";s:3:"sid";s:1:"0";s:8:"dateline";s:1:"0";s:8:"shop_num";s:1:"0";s:3:"get";s:1:"0";s:6:"setget";s:1:"0";}s:14:"key_javascript";a:7:{s:3:"cid";s:0:"";s:3:"uid";s:0:"";s:3:"sid";s:0:"";s:8:"dateline";s:0:"";s:8:"shop_num";s:0:"";s:3:"get";s:0:"";s:6:"setget";s:0:"";}}' WHERE `key` ='shop_Admin_convert';
INSERT INTO `ts_system_config` (`list`, `key`, `value`, `mtime`) VALUES ('pageKey', 'shop_Admin_update', 'a:6:{s:3:"key";a:1:{s:8:"doupdate";s:8:"doupdate";}s:8:"key_name";a:1:{s:8:"doupdate";s:27:"确定要升级软件吗？";}s:8:"key_type";a:1:{s:8:"doupdate";s:5:"radio";}s:11:"key_default";a:1:{s:8:"doupdate";s:0:"";}s:9:"key_tishi";a:1:{s:8:"doupdate";s:84:"如果是最新版本，升级软件可能会造成数据丢失！请谨慎升级！";}s:14:"key_javascript";a:1:{s:8:"doupdate";s:0:"";}}', '2013-09-01 22:10:59');