MySQL Create Table SQL
Table Structure: okayapi_kite_language:/tablelist/okayapi_kite_language.html
-- MySQL Table okayapi_kite_language
-- From: OkayAPI.com
CREATE TABLE `okayapi_kite_language` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NULL COMMENT '语言名称',
`icon` varchar(255) NULL COMMENT '',
`sort` int(11) NULL DEFAULT '0' COMMENT '权重排序 越大越靠后',
`designation` varchar(255) NULL COMMENT '描述',
KEY `name` (`name`),
KEY `icon` (`icon`),
KEY `sort` (`sort`),
KEY `designation` (`designation`),
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-4 of 4 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(255) | 否 | 语言名称 | |||
icon | varchar(255) | 是 | ||||
sort | int(11) | 0 | 否 | 权重排序 越大越靠后 | 0 | |
designation | varchar(255) | 是 | 描述 |