207 lines
20 KiB
SQL
Executable File
207 lines
20 KiB
SQL
Executable File
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_self (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库主表' ;
|
|
ALTER TABLE hi_emarketing_self ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_self ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_self ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_self ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_self ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_self ADD `title` VARCHAR(255) NOT NULL COMMENT '标题' ;
|
|
ALTER TABLE hi_emarketing_self ADD `keywords` VARCHAR(255) NOT NULL COMMENT '供检索的关键词串' ;
|
|
ALTER TABLE hi_emarketing_self ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_self ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_self ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_self ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_self ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_self ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_self ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_self ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_self ADD INDEX`siteid` (`siteid`);
|
|
ALTER TABLE hi_emarketing_self ADD INDEX`uniacid` (`uniacid`);
|
|
ALTER TABLE hi_emarketing_self ADD INDEX`shopid` (`shopid`);
|
|
ALTER TABLE hi_emarketing_self ADD INDEX`keywords` (`keywords`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_form (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库实例表' ;
|
|
ALTER TABLE hi_emarketing_form ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `s_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应主表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `partnerid` INT(11) UNSIGNED NOT NULL COMMENT '所属合作商户编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `uid` INT(11) UNSIGNED NOT NULL COMMENT '所属后台用户编码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `title` VARCHAR(255) NOT NULL COMMENT '标题' ;
|
|
ALTER TABLE hi_emarketing_form ADD `value` TEXT NOT NULL COMMENT '具体内容或描述' ;
|
|
ALTER TABLE hi_emarketing_form ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_form ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_form ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_form ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_form ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_form ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_form ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_form ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_form ADD INDEX`s_sn` (`s_sn`);
|
|
ALTER TABLE hi_emarketing_form ADD INDEX`siteid` (`siteid`);
|
|
ALTER TABLE hi_emarketing_form ADD INDEX`uniacid` (`uniacid`);
|
|
ALTER TABLE hi_emarketing_form ADD INDEX`title` (`title`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_param (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=MyISAM CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库主参数表' ;
|
|
ALTER TABLE hi_emarketing_param ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `s_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应主表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `f_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应实例表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `partnerid` INT(11) UNSIGNED NOT NULL COMMENT '所属合作商户编码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `setfor` VARCHAR(50) NOT NULL COMMENT '参数归属类别' ;
|
|
ALTER TABLE hi_emarketing_param ADD `title` VARCHAR(255) NOT NULL COMMENT '参数标题' ;
|
|
ALTER TABLE hi_emarketing_param ADD `key` VARCHAR(255) NOT NULL COMMENT '参数键值' ;
|
|
ALTER TABLE hi_emarketing_param ADD `value` TEXT NOT NULL COMMENT '参数具体值' ;
|
|
ALTER TABLE hi_emarketing_param ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_param ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_param ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_param ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_param ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_param ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_param ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_param ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_param ADD INDEX`s_sn` (`s_sn`);
|
|
ALTER TABLE hi_emarketing_param ADD INDEX`setfor` (`setfor`);
|
|
ALTER TABLE hi_emarketing_param ADD INDEX`title` (`title`);
|
|
ALTER TABLE hi_emarketing_param ADD INDEX`key` (`key`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_order (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=InnoDB CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库数据提交/收集表单表' ;
|
|
ALTER TABLE hi_emarketing_order ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `s_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应主表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `f_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应实例表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `partnerid` INT(11) UNSIGNED NOT NULL COMMENT '所属合作商户编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `mid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台会员编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `fid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台粉丝(非注册用户)编码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `title` VARCHAR(255) NOT NULL COMMENT '标题' ;
|
|
ALTER TABLE hi_emarketing_order ADD `value` TEXT NOT NULL COMMENT '具体内容或描述' ;
|
|
ALTER TABLE hi_emarketing_order ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_order ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_order ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_order ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_order ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_order ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_order ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_order ADD INDEX`siteid` (`siteid`);
|
|
ALTER TABLE hi_emarketing_order ADD INDEX`uniacid` (`uniacid`);
|
|
ALTER TABLE hi_emarketing_order ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_order ADD INDEX`s_sn` (`s_sn`);
|
|
ALTER TABLE hi_emarketing_order ADD INDEX`f_sn` (`f_sn`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_addon (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=MyISAM CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库附加参数表' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `s_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应主表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `f_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应实例表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `o_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应数据提交表单的记录编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `partnerid` INT(11) UNSIGNED NOT NULL COMMENT '所属合作商户编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `mid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台会员编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `fid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台粉丝(非注册用户)编码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `setfor` VARCHAR(50) NOT NULL COMMENT '参数归属类别' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `title` VARCHAR(255) NOT NULL COMMENT '参数标题' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `key` VARCHAR(255) NOT NULL COMMENT '参数键值' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `value` TEXT NOT NULL COMMENT '参数具体值' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_addon ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_addon ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_addon ADD INDEX`o_sn` (`o_sn`);
|
|
ALTER TABLE hi_emarketing_addon ADD INDEX`setfor` (`setfor`);
|
|
ALTER TABLE hi_emarketing_addon ADD INDEX`title` (`title`);
|
|
ALTER TABLE hi_emarketing_addon ADD INDEX`key` (`key`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_data (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=MyISAM CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库具体数据表' ;
|
|
ALTER TABLE hi_emarketing_data ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `s_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应主表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `f_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应实例表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `o_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应数据提交表单的记录编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `partnerid` INT(11) UNSIGNED NOT NULL COMMENT '所属合作商户编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `mid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台会员编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `fid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台粉丝(非注册用户)编码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `setfor` VARCHAR(50) NOT NULL COMMENT '参数归属类别' ;
|
|
ALTER TABLE hi_emarketing_data ADD `title` VARCHAR(255) NOT NULL COMMENT '参数标题' ;
|
|
ALTER TABLE hi_emarketing_data ADD `key` VARCHAR(255) NOT NULL COMMENT '参数键值' ;
|
|
ALTER TABLE hi_emarketing_data ADD `value` TEXT NOT NULL COMMENT '参数具体值' ;
|
|
ALTER TABLE hi_emarketing_data ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_data ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_data ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_data ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_data ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_data ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_data ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_data ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_data ADD INDEX`o_sn` (`o_sn`);
|
|
ALTER TABLE hi_emarketing_data ADD INDEX`mid` (`mid`);
|
|
ALTER TABLE hi_emarketing_data ADD INDEX`setfor` (`setfor`);
|
|
ALTER TABLE hi_emarketing_data ADD INDEX`title` (`title`);
|
|
ALTER TABLE hi_emarketing_data ADD INDEX`key` (`key`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_attr (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=MyISAM CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库数据属性微调表' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '与其他表进行关联的唯一记录编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `t_sn` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应数据表的记录编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `platid` INT(11) UNSIGNED NOT NULL COMMENT '所属平台编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `shopid` INT(11) UNSIGNED NOT NULL COMMENT '所属商铺编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `partnerid` INT(11) UNSIGNED NOT NULL COMMENT '所属合作商户编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `uid` INT(11) UNSIGNED NOT NULL COMMENT '所属后台会员编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `mid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台会员编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `fid` INT(11) UNSIGNED NOT NULL COMMENT '所属前台粉丝(非注册用户)编码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `suffix` VARCHAR(50) NOT NULL COMMENT '对应表后缀(用于区分表)' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `setfor` VARCHAR(50) NOT NULL COMMENT '参数归属类别' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `title` VARCHAR(255) NOT NULL COMMENT '参数标题' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `key` VARCHAR(255) NOT NULL COMMENT '参数键值' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `value` TEXT NOT NULL COMMENT '参数具体值' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `displayorder` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序权重' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `updatetime` INT(11) UNSIGNED NOT NULL COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_attr ADD `update_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_attr ADD INDEX`sn` (`sn`);
|
|
ALTER TABLE hi_emarketing_attr ADD INDEX`t_sn` (`t_sn`);
|
|
ALTER TABLE hi_emarketing_attr ADD INDEX`uid` (`uid`);
|
|
ALTER TABLE hi_emarketing_attr ADD INDEX`mid` (`mid`);
|
|
ALTER TABLE hi_emarketing_attr ADD INDEX`setfor` (`setfor`);
|
|
|
|
CREATE TABLE IF NOT EXISTS hi_emarketing_pre (`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表记录序号ID', PRIMARY KEY (`id`) USING BTREE) ENGINE=MyISAM CHARSET=utf8 COLLATE utf8_general_ci COMMENT='营销库数据表预编辑操作记录' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `tid` BIGINT(20) UNSIGNED NOT NULL COMMENT '对应数据表的记录id' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `siteid` INT(11) UNSIGNED NOT NULL COMMENT '所属安装站点编码' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `uniacid` INT(11) UNSIGNED NOT NULL COMMENT '所属公众号编码' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `uid` INT(11) UNSIGNED NOT NULL COMMENT '操作者所属后台会员编码' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `mid` INT(11) UNSIGNED NOT NULL COMMENT '操作者所属前台会员编码' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `fid` INT(11) UNSIGNED NOT NULL COMMENT '操作者所属前台粉丝(非注册用户)编码' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `suffix` VARCHAR(50) NOT NULL COMMENT '对应表后缀(用于区分表)' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `setfor` VARCHAR(50) NOT NULL COMMENT '对应字段' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `value` TEXT NOT NULL COMMENT '参数具体值' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '站内状态代码' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除(1是0否)' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `createtime` INT(11) UNSIGNED NOT NULL COMMENT '记录创建时间' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `statuscode` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '全站状态代码(-128~127)' ;
|
|
ALTER TABLE hi_emarketing_pre ADD `create_at`TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录更新时间' ;
|
|
ALTER TABLE hi_emarketing_pre ADD INDEX`tid` (`tid`);
|
|
ALTER TABLE hi_emarketing_pre ADD INDEX`uid` (`uid`);
|
|
ALTER TABLE hi_emarketing_pre ADD INDEX`mid` (`mid`);
|
|
ALTER TABLE hi_emarketing_pre ADD INDEX`siteid` (`siteid`);
|
|
ALTER TABLE hi_emarketing_pre ADD INDEX`setfor` (`setfor`); |