wiki个人名片数据库变更

数据库

shuidi_data

SQL

use shuidi_data;
ALTER TABLE `tb_id_card_name` DROP `remote_result`;
ALTER TABLE `tb_id_card_name` ADD `mobile` VARCHAR(11)  NOT NULL  DEFAULT ''  COMMENT '手机号码'  AFTER `name`;
ALTER TABLE `tb_id_card_name` ADD  INDEX `idx_phone_name_id_card` (`id_card`, `name`, `mobile`);
ALTER table `tb_id_card_name` drop index uni_id_card;

数据库

wiki

SQL

use wiki;
ALTER TABLE `tb_company_personal_card` DROP `position_id`;
DROP TABLE tb_wiki_personal_card_position;
CREATE TABLE `tb_wiki_personal_card_qualification` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `agent_name` varchar(55) NOT NULL DEFAULT '' COMMENT '渠道名称',
  `company_name` varchar(255) NOT NULL DEFAULT '' COMMENT '公司名称',
  `company_name_digest` varchar(32) NOT NULL DEFAULT '' COMMENT 'digest',
  `status` tinyint(4) unsigned NOT NULL COMMENT '状态，1为有效，2为无效',
  `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '企业相关内容信息',
  `category` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '展位类别 1为两个展位 2为500个展位',
  `max_num` smallint(5) unsigned NOT NULL DEFAULT '2' COMMENT '名片展位上线',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_agent` (`agent_name`(20)),
  KEY `idx_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='个人名片赠送资格表';

Job

每天凌晨跑一次，检查过期名片和过期百科企业

php run.php Bin_Wiki_PersonalCardExpireUpdate