Skip to content

GitLab

Closed
Created by 姚坤@yaokDeveloper

添加表tb_company_power_partner

数据库：ucs

表名：tb_company_power_partner

sql：

CREATE TABLE `tb_company_power_partner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name_digest` varchar(255) NOT NULL,
  `partner_company_name` varchar(255) NOT NULL,
  `partner_company_name_digest` varchar(255) NOT NULL,
  `describe` varchar(1000) NOT NULL,
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8

涉及的查询语句

select partner_company_name,partner_company_name_digest,describe from tb_company_power_partner  where company_name_digest=?