
ALTER TABLE `hjmall_action_log` MODIFY COLUMN `type`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '日志类型:1.操作日志 2.定时任务日志' AFTER `is_delete`;
ALTER TABLE `hjmall_diy_page` MODIFY COLUMN `title`  varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '页面标题' AFTER `store_id`;
ALTER TABLE `hjmall_diy_page` MODIFY COLUMN `template_id`  int(11) NOT NULL COMMENT '模板ID' AFTER `title`;
ALTER TABLE `hjmall_diy_page` MODIFY COLUMN `is_delete`  int(11) NOT NULL DEFAULT 0 AFTER `template_id`;
ALTER TABLE `hjmall_diy_page` MODIFY COLUMN `status`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0--禁用 1--启用' AFTER `addtime`;
ALTER TABLE `hjmall_diy_page` MODIFY COLUMN `is_index`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否覆盖首页 0--不覆盖 1--覆盖' AFTER `status`;
ALTER TABLE `hjmall_diy_template` MODIFY COLUMN `name`  varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名称' AFTER `store_id`;
ALTER TABLE `hjmall_diy_template` MODIFY COLUMN `template`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板数据' AFTER `name`;
ALTER TABLE `hjmall_diy_template` MODIFY COLUMN `is_delete`  tinyint(1) NOT NULL DEFAULT 0 AFTER `template`;
CREATE TABLE `hjmall_gwd_buy_list` (
`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`order_id`  int(11) NOT NULL ,
`user_id`  int(11) NOT NULL ,
`is_delete`  tinyint(4) NOT NULL DEFAULT 0 ,
`addtime`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) NOT NULL COMMENT '0.商城|1.秒杀|2.拼团' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Compact
;
CREATE TABLE `hjmall_gwd_like_list` (
`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`good_id`  int(11) NOT NULL ,
`is_delete`  tinyint(4) NOT NULL DEFAULT 0 ,
`addtime`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) NOT NULL COMMENT '0.商城|1.秒杀|2.拼团' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Compact
;
CREATE TABLE `hjmall_gwd_like_user` (
`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`like_id`  int(11) NOT NULL ,
`is_delete`  tinyint(4) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Compact
;
CREATE TABLE `hjmall_gwd_setting` (
`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`status`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Compact
;
ALTER TABLE `hjmall_plugin` MODIFY COLUMN `name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `data`;
ALTER TABLE `hjmall_plugin` MODIFY COLUMN `display_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `hjmall_plugin` MODIFY COLUMN `route`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `display_name`;
ALTER TABLE `hjmall_plugin` MODIFY COLUMN `addtime`  int(11) NOT NULL DEFAULT 0 AFTER `route`;
ALTER TABLE `hjmall_qrcode` MODIFY COLUMN `font`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字体设置\r\n{\r\n  \"size\":大小,\r\n  \"color\":\"r,g,b\"\r\n}' AFTER `font_position`;
ALTER TABLE `hjmall_setting` MODIFY COLUMN `share_condition`  int(11) NOT NULL DEFAULT 0 COMMENT '成为分销商的条件 \r\n0--无条件\r\n1--申请' AFTER `condition`;

ALTER TABLE `hjmall_task` MODIFY COLUMN `content`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务说明' AFTER `is_delete`;
INSERT INTO `hjmall_admin_permission` VALUES ('60', 'gwd', '购物单', '0', '1000');

UPDATE  `ims_modules` SET  `version` = '3.1.18.0',`author` = '春暖花开',`url` = 'http://www.we7.cc' WHERE `name` ='zjhj_mall';
