MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_mblock:/tablelist/okayapi_jieqi_system_mblock.html
-- MySQL Table okayapi_jieqi_system_mblock
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_mblock` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`modules` varchar(10) NOT NULL COMMENT '',
`okayapi_jieqi_system_mblock_name` varchar(20) NOT NULL COMMENT '',
`okayapi_jieqi_system_mblock_file` varchar(20) NOT NULL COMMENT '',
`classname` varchar(20) NOT NULL COMMENT '',
`introduce` mediumtext NOT NULL COMMENT '',
`vars` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
KEY `modules` (`modules`),
KEY `okayapi_jieqi_system_mblock_name` (`okayapi_jieqi_system_mblock_name`),
KEY `okayapi_jieqi_system_mblock_file` (`okayapi_jieqi_system_mblock_file`),
KEY `classname` (`classname`),
KEY `introduce` (`introduce`),
KEY `vars` (`vars`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-m章节';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
modules | varchar(10) | 否 | ||||
okayapi_jieqi_system_mblock_name | varchar(20) | 否 | ||||
okayapi_jieqi_system_mblock_file | varchar(20) | 否 | ||||
classname | varchar(20) | 否 | ||||
introduce | mediumtext | 否 | ||||
vars | tinyint(1) | 1 | 否 | 1 |