MySQL Create Table SQL
Table Structure: okayapi_srcms_setting:/tablelist/okayapi_srcms_setting.html
-- MySQL Table okayapi_srcms_setting
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_setting` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_srcms_setting_value` varchar(255) NOT NULL COMMENT '配置内容',
`key1` varchar(255) NOT NULL COMMENT '配置数据',
`key2` varchar(255) NOT NULL COMMENT '配置数据',
`key3` varchar(255) NOT NULL COMMENT '配置数据',
`key4` varchar(255) NOT NULL COMMENT '配置数据',
`key5` varchar(255) NOT NULL COMMENT '配置数据',
`key6` varchar(255) NOT NULL COMMENT '配置数据',
KEY `okayapi_srcms_setting_value` (`okayapi_srcms_setting_value`),
KEY `key1` (`key1`),
KEY `key2` (`key2`),
KEY `key3` (`key3`),
KEY `key4` (`key4`),
KEY `key5` (`key5`),
KEY `key6` (`key6`),
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-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_srcms_setting_value | varchar(255) | 否 | 配置内容 | |||
key1 | varchar(255) | 否 | 配置数据 | |||
key2 | varchar(255) | 否 | 配置数据 | |||
key3 | varchar(255) | 否 | 配置数据 | |||
key4 | varchar(255) | 否 | 配置数据 | |||
key5 | varchar(255) | 否 | 配置数据 | |||
key6 | varchar(255) | 否 | 配置数据 |