MySQL Create Table SQL
Table Structure: okayapi_openant_setting：/tablelist/okayapi_openant_setting.html
-- MySQL Table okayapi_openant_setting
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_setting` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`param` varchar(255) NULL COMMENT '',
`setting_value` text NULL COMMENT '',
`public` tinyint(1) NULL DEFAULT '0' COMMENT '',
`category` varchar(255) NULL COMMENT '',
`setting_hash` varchar(255) NULL COMMENT '',
KEY `param` (`param`),
KEY `setting_value` (`setting_value`),
KEY `public` (`public`),
KEY `category` (`category`),
KEY `setting_hash` (`setting_hash`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-配置';
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 | |||
| setting_value | text | 是 | ||||
| public | tinyint(1) | 0 | 是 | 0 | ||
| category | varchar(255) | 是 | ||||
| setting_hash | varchar(255) | 是 |
