MySQL Create Table SQL
Table Structure: okayapi_srcms_hall：/tablelist/okayapi_srcms_hall.html
-- MySQL Table okayapi_srcms_hall
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_hall` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_srcms_hall_name` varchar(255) NOT NULL COMMENT '名人堂昵称',
`team` varchar(255) NOT NULL DEFAULT 'Unknown' COMMENT '团队名称',
`url` varchar(100) NOT NULL COMMENT '名人堂头像URL',
`des` varchar(100) NOT NULL COMMENT '名人堂介绍',
KEY `okayapi_srcms_hall_name` (`okayapi_srcms_hall_name`),
KEY `team` (`team`),
KEY `url` (`url`),
KEY `des` (`des`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-名人堂';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| okayapi_srcms_hall_name | varchar(255) | 否 | 名人堂昵称 | |||
| team | varchar(255) | Unknown | 否 | 团队名称 | Unknown | |
| url | varchar(100) | 否 | 名人堂头像URL | |||
| des | varchar(100) | 否 | 名人堂介绍 |
