okayapi_jieqi_system_configs - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jieqi_system_configs：/tablelist/okayapi_jieqi_system_configs.html


-- MySQL Table okayapi_jieqi_system_configs
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_configs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `modname` varchar(50) NOT NULL COMMENT '',
    `cname` varchar(50) NOT NULL COMMENT '',
    `ctitle` varchar(50) NOT NULL COMMENT '',
    `cvalue` text NOT NULL COMMENT '',
    `cdescription` text NOT NULL COMMENT '',
    `cdefine` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `ctype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_jieqi_system_configs_options` text NOT NULL COMMENT '',
    `catorder` int(10) NOT NULL DEFAULT '0' COMMENT '',
    `catname` varchar(50) NOT NULL COMMENT '',
    KEY `modname` (`modname`),
    KEY `cname` (`cname`),
    KEY `ctitle` (`ctitle`),
    KEY `cvalue` (`cvalue`),
    KEY `cdescription` (`cdescription`),
    KEY `cdefine` (`cdefine`),
    KEY `ctype` (`ctype`),
    KEY `okayapi_jieqi_system_configs_options` (`okayapi_jieqi_system_configs_options`),
    KEY `catorder` (`catorder`),
    KEY `catname` (`catname`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-配置';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-10 of 10 results.

Field Name	Field Type	Default	IS NULL	Index	Demo Data
modname	varchar(50)		否
cname	varchar(50)		否
ctitle	varchar(50)		否
cvalue	text		否
cdescription	text		否
cdefine	tinyint(1)	0	否	Normal Index	0
ctype	tinyint(1)	0	否		0
okayapi_jieqi_system_configs_options	text		否
catorder	int(10)	0	否	Normal Index	0
catname	varchar(50)		否	Normal Index