MySQL Create Table SQL
Table Structure: okayapi_box_setting:/tablelist/okayapi_box_setting.html
-- MySQL Table okayapi_box_setting
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_setting` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`param` varchar(255) NULL COMMENT '',
`value` text NULL COMMENT '',
`public` tinyint(1) NULL DEFAULT '0' COMMENT '',
`category` varchar(255) NULL COMMENT '',
`hash` varchar(255) NULL COMMENT '',
KEY `param` (`param`),
KEY `value` (`value`),
KEY `public` (`public`),
KEY `category` (`category`),
KEY `hash` (`hash`),
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-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
param | varchar(255) | 是 | Unique Index | |||
value | text | 是 | ||||
public | tinyint(1) | 0 | 是 | 0 | ||
category | varchar(255) | 是 | ||||
hash | varchar(255) | 是 |