mysql指定符号化セット
39288 ワード
DROP TABLE app_info
CREATE TABLE `app_info`
(
`app_id` VARCHAR(20) NOT NULL COMMENT ' ID',
`app_name` VARCHAR(100) NOT NULL COMMENT ' ',
`source_market` VARCHAR(50) COMMENT ' ',
`version` VARCHAR(10) COMMENT ' ',
`update_time` INT DEFAULT 0 COMMENT ' ',
`donwload_times` INT DEFAULT 0 COMMENT ' ',
`evaluation_index` VARCHAR(20) COMMENT ' ',
`app_down_url` VARCHAR(200) COMMENT ' ',
`app_org` VARCHAR(100) COMMENT ' ',
`app_market_url` VARCHAR(200) COMMENT ' ',
`org_tel` VARCHAR(20) COMMENT ' ',
`org_mail` VARCHAR(50) COMMENT ' ',
`app_devp` VARCHAR(50) COMMENT ' ',
`devp_url` VARCHAR(200) COMMENT ' ',
`devp_tel` VARCHAR(20) COMMENT ' ',
`devp_mail` VARCHAR(50) COMMENT ' ',
`is_illegal` BIT COMMENT ' ',
`illegal_reason` VARCHAR(200) COMMENT ' '
) ENGINE=INNODB AUTO_INCREMENT=1695497 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
転載先:https://www.cnblogs.com/duanjt/p/8872290.html
DROP TABLE app_info
CREATE TABLE `app_info`
(
`app_id` VARCHAR(20) NOT NULL COMMENT ' ID',
`app_name` VARCHAR(100) NOT NULL COMMENT ' ',
`source_market` VARCHAR(50) COMMENT ' ',
`version` VARCHAR(10) COMMENT ' ',
`update_time` INT DEFAULT 0 COMMENT ' ',
`donwload_times` INT DEFAULT 0 COMMENT ' ',
`evaluation_index` VARCHAR(20) COMMENT ' ',
`app_down_url` VARCHAR(200) COMMENT ' ',
`app_org` VARCHAR(100) COMMENT ' ',
`app_market_url` VARCHAR(200) COMMENT ' ',
`org_tel` VARCHAR(20) COMMENT ' ',
`org_mail` VARCHAR(50) COMMENT ' ',
`app_devp` VARCHAR(50) COMMENT ' ',
`devp_url` VARCHAR(200) COMMENT ' ',
`devp_tel` VARCHAR(20) COMMENT ' ',
`devp_mail` VARCHAR(50) COMMENT ' ',
`is_illegal` BIT COMMENT ' ',
`illegal_reason` VARCHAR(200) COMMENT ' '
) ENGINE=INNODB AUTO_INCREMENT=1695497 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;