MySQL Create Table SQL
Table Structure: okayapi_appver_apk:/tablelist/okayapi_appver_apk.html
-- MySQL Table okayapi_appver_apk
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_apk` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '渠道ID',
`app_id` int(11) NOT NULL DEFAULT '0' COMMENT 'AppId',
`version_id` int(11) NOT NULL DEFAULT '0' COMMENT '版本ID',
`md5` varchar(64) NOT NULL COMMENT 'APK文件的MD5值',
`oss_url` varchar(500) NOT NULL COMMENT 'apk文件oss存储地址',
`delivery_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '标记渠道版本的安装包是否已上架(0-未上架;1-已上架)',
`created_by` varchar(32) NOT NULL COMMENT '创建人',
`del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
`updated_by` varchar(32) NOT NULL COMMENT '更新人',
KEY `channel_id` (`channel_id`),
KEY `app_id` (`app_id`),
KEY `version_id` (`version_id`),
KEY `md5` (`md5`),
KEY `oss_url` (`oss_url`),
KEY `delivery_status` (`delivery_status`),
KEY `created_by` (`created_by`),
KEY `del_flag` (`del_flag`),
KEY `updated_by` (`updated_by`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-安卓APK';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
channel_id | int(11) | 0 | 否 | 渠道ID | 0 | |
app_id | int(11) | 0 | 否 | AppId | 0 | |
version_id | int(11) | 0 | 否 | 版本ID | 0 | |
md5 | varchar(64) | 否 | APK文件的MD5值 | |||
oss_url | varchar(500) | 否 | apk文件oss存储地址 | |||
delivery_status | tinyint(1) | 0 | 否 | 标记渠道版本的安装包是否已上架(0-未上架;1-已上架) | 0 | |
created_by | varchar(32) | 否 | 创建人 | |||
del_flag | tinyint(1) | 0 | 否 | 是否删除 | 0 | |
updated_by | varchar(32) | 否 | 更新人 |