okayapi_jieqi_system_honors - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jieqi_system_honors：/tablelist/okayapi_jieqi_system_honors.html


-- MySQL Table okayapi_jieqi_system_honors
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_honors` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `caption` varchar(250) NOT NULL COMMENT '',
    `minscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `maxscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `setting` text NOT NULL COMMENT '',
    `honortype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    KEY `caption` (`caption`),
    KEY `minscore` (`minscore`),
    KEY `maxscore` (`maxscore`),
    KEY `setting` (`setting`),
    KEY `honortype` (`honortype`),
    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-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
caption	varchar(250)		否
minscore	int(11)	0	否		Normal Index	0
maxscore	int(11)	0	否			0
setting	text		否
honortype	tinyint(1)	0	否			0

Guess You Like

MySQL Table Design okayapi_xwx_author

MySQL Table Design okayapi_xwx_banner

MySQL Table Design okayapi_xwx_book

MySQL Table Design okayapi_xwx_category

MySQL Table Design okayapi_xwx_chapter

MySQL Table Design okayapi_xwx_tag

MySQL Table Design okayapi_xwx_admin

MySQL Table Design okayapi_xwx_friendship_link

MySQL Table Design okayapi_jieqi_system_adminmenu

MySQL Table Design okayapi_jieqi_system_blockconfigs

MySQL Table Design okayapi_jieqi_system_blocks

MySQL Table Design okayapi_jieqi_system_configs

MySQL Table Design okayapi_jieqi_system_defaultmenu

MySQL Table Design okayapi_jieqi_system_friends

MySQL Table Design okayapi_jieqi_system_groups

MySQL Table Design okayapi_jieqi_system_logs

MySQL Table Design okayapi_jieqi_system_mainmenu

MySQL Table Design okayapi_jieqi_system_mblock

MySQL Table Design okayapi_jieqi_system_message

MySQL Table Design okayapi_jieqi_system_modules