13 lines
7.2 KiB
SQL
13 lines
7.2 KiB
SQL
alter table shop_page_app add column app_template_id int default NULL COMMENT '模板编号';
|
||
|
||
alter table shop_page_app add column is_pay char(1) not null default '0' COMMENT '是否收费0否，1是';
|
||
|
||
alter table shop_page_app add column is_pulish char(1) not null default '0' COMMENT '是否发布0否，1是';
|
||
alter table shop_page_app add column app_market_images varchar(5000) default "" COMMENT '市场展示图片';
|
||
|
||
alter table shop_page_app drop index tpl_id;
|
||
|
||
INSERT INTO account_base_config
|
||
(config_key, config_value, config_type, config_enable, config_comment, config_datatype, config_name, config_formater)
|
||
VALUES('service_app_tpl', '{"cmd_id":-100,"status":200,"msg":"success","code":0,"data":{"page":1,"total":1,"records":30,"items":[{"tpl_id":101,"tpl_label":"shop1","tpl_cat_name":"","tpl_name":"商超卖场","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/normal.png","app_id":0,"id":101},{"tpl_id":102,"tpl_label":"shop2","tpl_cat_name":"","tpl_name":"母婴婴童","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/baby.png","app_id":0,"id":102},{"tpl_id":103,"tpl_label":"shop3","tpl_cat_name":"","tpl_name":"食品生鲜","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/food.png","app_id":0,"id":103},{"tpl_id":104,"tpl_label":"shop4","tpl_cat_name":"","tpl_name":"服装鞋帽","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/clothes.png","app_id":0,"id":104},{"tpl_id":105,"tpl_label":"shop5","tpl_cat_name":"","tpl_name":"综合电商","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/zonghe.png","app_id":0,"id":105},{"tpl_id":106,"tpl_label":"shop6","tpl_cat_name":"","tpl_name":"餐饮外卖","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/waimai.png","app_id":0,"id":106},{"tpl_id":107,"tpl_label":"shop7","tpl_cat_name":"","tpl_name":"DIY模板","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/diy.png","app_id":0,"id":107},{"tpl_id":109,"tpl_label":"shop9","tpl_cat_name":"","tpl_name":"丽人","user_id":0,"tpl_buildin":0,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/liren.png","app_id":0,"id":109},{"tpl_id":1001,"tpl_label":1001,"tpl_cat_name":"生活服务","tpl_name":"4S中心","user_id":10001,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1001.png","app_id":1001,"id":1001},{"tpl_id":1002,"tpl_label":1002,"tpl_cat_name":"生活服务","tpl_name":"KTV","user_id":10001,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1002.png","app_id":1001,"id":1002},{"tpl_id":1003,"tpl_label":1003,"tpl_cat_name":"生活服务","tpl_name":"童话乐园","user_id":10001,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1003.png","app_id":1002,"id":1003},{"tpl_id":1004,"tpl_label":1004,"tpl_cat_name":"生活服务","tpl_name":"宠物医院","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1004.png","app_id":0,"id":1004},{"tpl_id":1005,"tpl_label":1005,"tpl_cat_name":"生活服务","tpl_name":"房产","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1005.png","app_id":0,"id":1005},{"tpl_id":1006,"tpl_label":1006,"tpl_cat_name":"生活服务","tpl_name":"家政服务","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1006.png","app_id":0,"id":1006},{"tpl_id":1007,"tpl_label":1007,"tpl_cat_name":"生活服务","tpl_name":"家装","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1007.png","app_id":0,"id":1007},{"tpl_id":1008,"tpl_label":1008,"tpl_cat_name":"生活服务","tpl_name":"丽人","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1008.png","app_id":0,"id":1008},{"tpl_id":1009,"tpl_label":1009,"tpl_cat_name":"生活服务","tpl_name":"运动健身","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1009.png","app_id":0,"id":1009},{"tpl_id":1010,"tpl_label":1010,"tpl_cat_name":"生活服务","tpl_name":"早教中心","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1010.png","app_id":0,"id":1010},{"tpl_id":1011,"tpl_label":1011,"tpl_cat_name":"生活服务","tpl_name":"婚纱摄影","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1011.png","app_id":0,"id":1011},{"tpl_id":1012,"tpl_label":1012,"tpl_cat_name":"零售电商","tpl_name":"综合电商","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1012.png","app_id":0,"id":1012},{"tpl_id":1013,"tpl_label":1013,"tpl_cat_name":"零售电商","tpl_name":"花卉","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1013.png","app_id":0,"id":1013},{"tpl_id":1014,"tpl_label":1014,"tpl_cat_name":"生活服务","tpl_name":"酒店","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1014.png","app_id":0,"id":1014},{"tpl_id":1015,"tpl_label":1015,"tpl_cat_name":"零售电商","tpl_name":"图书影像","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1015.png","app_id":0,"id":1015},{"tpl_id":1016,"tpl_label":1016,"tpl_cat_name":"零售电商","tpl_name":"玩具","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1016.png","app_id":0,"id":1016},{"tpl_id":1017,"tpl_label":1017,"tpl_cat_name":"零售电商","tpl_name":"美妆","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1017.png","app_id":0,"id":1017},{"tpl_id":1018,"tpl_label":1018,"tpl_cat_name":"零售电商","tpl_name":"水果","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1018.png","app_id":0,"id":1018},{"tpl_id":1019,"tpl_label":1019,"tpl_cat_name":"生活服务","tpl_name":"餐厅","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1019.png","app_id":0,"id":1019},{"tpl_id":1020,"tpl_label":1020,"tpl_cat_name":"企业园区","tpl_name":"企业官网","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1020.png","app_id":0,"id":1020},{"tpl_id":1021,"tpl_label":1021,"tpl_cat_name":"企业园区","tpl_name":"孵化园区","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1021.png","app_id":0,"id":1021},{"tpl_id":1022,"tpl_label":1022,"tpl_cat_name":"生活服务","tpl_name":"餐饮美食","user_id":0,"tpl_buildin":1,"tpl_type":3,"tpl_image":"https:\/\/static.shopsuite.cn\/xcxfile\/preview\/1022.png","app_id":0,"id":1022}]}}', 'service', 1, '', 'json', '', '');
|