+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_app_version:/tablelist/okayapi_app_version.html


-- MySQL Table okayapi_app_version
-- From: OkayAPI.com
CREATE TABLE `okayapi_app_version` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `version` varchar(255) NULL COMMENT '版本号',
    `release_time` datetime NULL COMMENT '发布时间',
    `release_type` varchar(255) NULL COMMENT '发布类型',
    `description` varchar(255) NULL COMMENT '版本描述',
    `update_information` text NULL COMMENT '更新信息',
    `download_source_1` varchar(255) NULL COMMENT '下载支链1',
    `download_source_2` varchar(255) NULL COMMENT ' 下载支链2',
    `download_source_manual` varchar(255) NULL COMMENT '手动下载源',
    `md5` varchar(255) NULL COMMENT '校验md5',
    `tag` varchar(255) NULL COMMENT '标签',
    KEY `version` (`version`),
    KEY `release_time` (`release_time`),
    KEY `release_type` (`release_type`),
    KEY `description` (`description`),
    KEY `update_information` (`update_information`),
    KEY `download_source_1` (`download_source_1`),
    KEY `download_source_2` (`download_source_2`),
    KEY `download_source_manual` (`download_source_manual`),
    KEY `md5` (`md5`),
    KEY `tag` (`tag`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '软件版本更新';

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


MySQL database table structure design

Displaying 1-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
versionvarchar(255)版本号
release_timedatetime发布时间
release_typevarchar(255)发布类型
descriptionvarchar(255)版本描述
update_informationtext更新信息
download_source_1varchar(255)下载支链1
download_source_2varchar(255) 下载支链2
download_source_manualvarchar(255)手动下载源
md5varchar(255)校验md5
tagvarchar(255)标签

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_tea

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_moment

MySQL Table Design okayapi_tea_order

MySQL Table Design okayapi_tea_user

MySQL Table Design okayapi_tea_shopcar

MySQL Table Design okayapi_zheng_cms_article

MySQL Table Design okayapi_zheng_cms_article_category

MySQL Table Design okayapi_zheng_cms_article_tag

MySQL Table Design okayapi_zheng_cms_category

MySQL Table Design okayapi_zheng_cms_comment

MySQL Table Design okayapi_zheng_cms_page

MySQL Table Design okayapi_zheng_cms_setting

MySQL Table Design okayapi_zheng_cms_system

MySQL Table Design okayapi_zheng_cms_tag

MySQL Table Design okayapi_zheng_cms_topic

MySQL Table Design okayapi_zheng_pay_in_order

MySQL Table Design okayapi_zheng_pay_in_order_detail

MySQL Table Design okayapi_zheng_pay_mch

TOP ↑