+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_appver_ios_version:/tablelist/okayapi_appver_ios_version.html


-- MySQL Table okayapi_appver_ios_version
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_ios_version` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `app_id` int(10) NOT NULL DEFAULT '0' COMMENT 'APPID',
    `app_version` varchar(32) NOT NULL COMMENT '版本号',
    `update_type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0:强制更新 1:一般更新 2:静默更新 3:可忽略更新  4:静默可忽略更新 ',
    `version_description` text NOT NULL COMMENT '更新描述',
    `allow_lowest_version` varchar(32) NOT NULL COMMENT '允许最低版本(低于这个要强制更新)',
    `version_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '发布状态(0-未上架;1-已上架)',
    `app_store_url` varchar(500) NOT NULL COMMENT 'APP STORE的地址',
    `gray_released` tinyint(3) NOT NULL DEFAULT '0' COMMENT '灰度发布(0-无;1-白名单发布;2-IP发布)',
    `white_list_id` int(11) NOT NULL DEFAULT '0' COMMENT '白名单ID',
    `ip_list_id` int(10) NOT NULL DEFAULT '0' COMMENT 'IP段发布的list ID',
    `created_by` varchar(64) NOT NULL COMMENT '创建人',
    `del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否被删除',
    `updated_by` varchar(32) NOT NULL COMMENT '更新人',
    KEY `app_id` (`app_id`),
    KEY `app_version` (`app_version`),
    KEY `update_type` (`update_type`),
    KEY `version_description` (`version_description`),
    KEY `allow_lowest_version` (`allow_lowest_version`),
    KEY `version_status` (`version_status`),
    KEY `app_store_url` (`app_store_url`),
    KEY `gray_released` (`gray_released`),
    KEY `white_list_id` (`white_list_id`),
    KEY `ip_list_id` (`ip_list_id`),
    KEY `created_by` (`created_by`),
    KEY `del_flag` (`del_flag`),
    KEY `updated_by` (`updated_by`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-iOS版本';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
app_idint(10)0APPID0
app_versionvarchar(32)版本号
update_typetinyint(3)10:强制更新 1:一般更新 2:静默更新 3:可忽略更新 4:静默可忽略更新 1
version_descriptiontext更新描述
allow_lowest_versionvarchar(32)允许最低版本(低于这个要强制更新)
version_statustinyint(3)0发布状态(0-未上架;1-已上架)0
app_store_urlvarchar(500)APP STORE的地址
gray_releasedtinyint(3)0灰度发布(0-无;1-白名单发布;2-IP发布)0
white_list_idint(11)0白名单ID0
ip_list_idint(10)0IP段发布的list ID0
created_byvarchar(64)创建人
del_flagtinyint(1)0是否被删除0
updated_byvarchar(32)更新人

Guess You Like

MySQL Table Design okayapi_appver_access_log

MySQL Table Design okayapi_appver_android_version

MySQL Table Design okayapi_appver_apk

MySQL Table Design okayapi_appver_apk_download_record

MySQL Table Design okayapi_appver_app

MySQL Table Design okayapi_appver_channel

MySQL Table Design okayapi_appver_chat_bot

MySQL Table Design okayapi_appver_custom_api

MySQL Table Design okayapi_appver_operation_record_log

MySQL Table Design okayapi_appver_rn_package

MySQL Table Design okayapi_appver_rn_route

MySQL Table Design okayapi_appver_user

MySQL Table Design okayapi_appver_user_app_rel

TOP ↑