okayapi_eduwind_ew_upgrade_info - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_upgrade_info：/tablelist/okayapi_eduwind_ew_upgrade_info.html


-- MySQL Table okayapi_eduwind_ew_upgrade_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_upgrade_info` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `versionId` int(11) NOT NULL COMMENT '记录服务器上升级包的id',
    `version` varchar(32) NOT NULL COMMENT '版本号',
    `okayapi_eduwind_ew_upgrade_info_name` varchar(256) NOT NULL COMMENT '包名称',
    `description` text NOT NULL COMMENT '包描述',
    `addTime` int(11) NOT NULL COMMENT '包添加时间',
    `okayapi_eduwind_ew_upgrade_info_status` varchar(32) NOT NULL DEFAULT 'not installed' COMMENT '包状态：not installed, installed',
    KEY `versionId` (`versionId`),
    KEY `version` (`version`),
    KEY `okayapi_eduwind_ew_upgrade_info_name` (`okayapi_eduwind_ew_upgrade_info_name`),
    KEY `description` (`description`),
    KEY `addTime` (`addTime`),
    KEY `okayapi_eduwind_ew_upgrade_info_status` (`okayapi_eduwind_ew_upgrade_info_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'EW在线教育-用来记录网站升级包的信息';

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

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
versionId	int(11)		否	记录服务器上升级包的id	Unique Index
version	varchar(32)		否	版本号
okayapi_eduwind_ew_upgrade_info_name	varchar(256)		否	包名称
description	text		是	包描述
addTime	int(11)		否	包添加时间
okayapi_eduwind_ew_upgrade_info_status	varchar(32)	not installed	否	包状态：not installed, installed		not installed