GitLab

数据库：ucs

表名：tb_company_power_wall

sql：

CREATE TABLE `tb_company_power_wall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `power_id` int(11) NOT NULL,
  `company_name_digest` varchar(64) NOT NULL,
  `title_main` varchar(30) NOT NULL,
  `title_sub` varchar(30) NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '0代表待审核，1代表审核通过，2代表审核未通过，3代表已删除',
  `wall_sort` int(11) NOT NULL DEFAULT '0',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdadtetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8

涉及的查询语句

select title_main,title_sub,image from tb_company_power_wall  where status=1 and company_name_digest=? order by wall_sort