CREATE ALGORITHM=UNDEFINED DEFINER=tidbdba@127.0.0.1 SQL SECURITY DEFINER VIEW tt_advertiser (id, advertiser_id, name, description, email, contacter, phonenumber, role, status, telephone, address, license_url, license_no, license_province, license_city, company, brand, promotion_area, promotion_center_province, promotion_center_city, industry, reason, balance, create_time, second_industry_name, first_industry_name, is_child_agent, project_id, open_date, remark, platform_agency_id, source, update_user, create_user, update_time, today_granted) AS SELECT mbg_core.tt_advertiser.id AS id,mbg_core.tt_advertiser.advertiser_id AS advertiser_id,mbg_core.tt_advertiser.name AS name,mbg_core.tt_advertiser.description AS description,mbg_core.tt_advertiser.email AS email,mbg_core.tt_advertiser.contacter AS contacter,mbg_core.tt_advertiser.phonenumber AS phonenumber,mbg_core.tt_advertiser.role AS role,mbg_core.tt_advertiser.status AS status,mbg_core.tt_advertiser.telephone AS telephone,mbg_core.tt_advertiser.address AS address,mbg_core.tt_advertiser.license_url AS license_url,mbg_core.tt_advertiser.license_no AS license_no,mbg_core.tt_advertiser.license_province AS license_province,mbg_core.tt_advertiser.license_city AS license_city,mbg_core.tt_advertiser.company AS company,mbg_core.tt_advertiser.brand AS brand,mbg_core.tt_advertiser.promotion_area AS promotion_area,mbg_core.tt_advertiser.promotion_center_province AS promotion_center_province,mbg_core.tt_advertiser.promotion_center_city AS promotion_center_city,mbg_core.tt_advertiser.industry AS industry,mbg_core.tt_advertiser.reason AS reason,mbg_core.tt_advertiser.balance AS balance,mbg_core.tt_advertiser.create_time AS create_time,mbg_core.tt_advertiser.second_industry_name AS second_industry_name,mbg_core.tt_advertiser.first_industry_name AS first_industry_name,mbg_core.tt_advertiser.is_child_agent AS is_child_agent,mbg_core.tt_advertiser.project_id AS project_id,mbg_core.tt_advertiser.open_date AS open_date,mbg_core.tt_advertiser.remark AS remark,mbg_core.tt_advertiser.platform_agency_id AS platform_agency_id,mbg_core.tt_advertiser.source AS source,mbg_core.tt_advertiser.update_user AS update_user,mbg_core.tt_advertiser.create_user AS create_user,mbg_core.tt_advertiser.update_time AS update_time,mbg_core.tt_advertiser.today_granted AS today_granted FROM mbg_core.tt_advertiser
CREATE TABLE tt_advertiser (
id bigint(20) NOT NULL AUTO_INCREMENT,
…
UNIQUE KEY uq_adver_agency_id (advertiser_id,platform_agency_id),
KEY status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin