okayapi_jieqi_system_modules - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jieqi_system_modules：/tablelist/okayapi_jieqi_system_modules.html


-- MySQL Table okayapi_jieqi_system_modules
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_modules` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_jieqi_system_modules_name` varchar(50) NOT NULL COMMENT '',
    `caption` varchar(50) NOT NULL COMMENT '',
    `description` text NOT NULL COMMENT '',
    `version` smallint(5) NOT NULL DEFAULT '100' COMMENT '',
    `vtype` varchar(30) NOT NULL COMMENT '',
    `lastupdate` int(10) NOT NULL DEFAULT '0' COMMENT '',
    `weight` smallint(5) NOT NULL DEFAULT '0' COMMENT '',
    `publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `modtype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    KEY `okayapi_jieqi_system_modules_name` (`okayapi_jieqi_system_modules_name`),
    KEY `caption` (`caption`),
    KEY `description` (`description`),
    KEY `version` (`version`),
    KEY `vtype` (`vtype`),
    KEY `lastupdate` (`lastupdate`),
    KEY `weight` (`weight`),
    KEY `publish` (`publish`),
    KEY `modtype` (`modtype`),
    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-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Demo Data
okayapi_jieqi_system_modules_name	varchar(50)		否
caption	varchar(50)		否
description	text		否
version	smallint(5)	100	否	100
vtype	varchar(30)		否
lastupdate	int(10)	0	否	0
weight	smallint(5)	0	否	0
publish	tinyint(1)	0	否	0
modtype	tinyint(1)	0	否	0