个人名片小程序预览版数据库变更

数据库

wiki
SQL

use wiki;
ALTER TABLE `tb_company_personal_card` ADD `source` TINYINT  NOT NULL  DEFAULT '1'  COMMENT '来源，1为个人中心，2为小程序'  AFTER `phone`;
ALTER TABLE `tb_company_personal_card` DROP `operator`;

create table `tb_company_wiki_user_clue`(
	`id` INT(11) unsigned NOT NULL auto_increment,
	`name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '姓名',
	`position` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '职务',
	`phone` VARCHAR(11) NOT NULL DEFAULT '' COMMENT '电话',
	`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY(`id`)
)ENGINE=INNODB DEFAULT CHARSET="utf8" COMMENT = "企业百科用户申请开通线索表";