MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_blocks:/tablelist/okayapi_jieqi_system_blocks.html
-- MySQL Table okayapi_jieqi_system_blocks
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_blocks` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`blockname` varchar(50) NOT NULL COMMENT '',
`modname` varchar(50) NOT NULL COMMENT '',
`filename` varchar(50) NOT NULL COMMENT '',
`classname` varchar(50) NOT NULL COMMENT '',
`side` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`title` text NOT NULL COMMENT '',
`description` text NOT NULL COMMENT '',
`content` mediumtext NOT NULL COMMENT '',
`vars` text NOT NULL COMMENT '',
`template` varchar(50) NOT NULL COMMENT '',
`cachetime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`contenttype` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`weight` mediumint(8) NOT NULL DEFAULT '0' COMMENT '',
`showstatus` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`custom` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`canedit` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`hasvars` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
KEY `blockname` (`blockname`),
KEY `modname` (`modname`),
KEY `filename` (`filename`),
KEY `classname` (`classname`),
KEY `side` (`side`),
KEY `title` (`title`),
KEY `description` (`description`),
KEY `content` (`content`),
KEY `vars` (`vars`),
KEY `template` (`template`),
KEY `cachetime` (`cachetime`),
KEY `contenttype` (`contenttype`),
KEY `weight` (`weight`),
KEY `showstatus` (`showstatus`),
KEY `custom` (`custom`),
KEY `canedit` (`canedit`),
KEY `publish` (`publish`),
KEY `hasvars` (`hasvars`),
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-18 of 18 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
blockname | varchar(50) | 否 | ||||
modname | varchar(50) | 否 | Normal Index | |||
filename | varchar(50) | 否 | ||||
classname | varchar(50) | 否 | ||||
side | tinyint(3) | 0 | 否 | 0 | ||
title | text | 否 | ||||
description | text | 否 | ||||
content | mediumtext | 否 | ||||
vars | text | 否 | ||||
template | varchar(50) | 否 | ||||
cachetime | int(11) | 0 | 否 | 0 | ||
contenttype | tinyint(3) | 0 | 否 | 0 | ||
weight | mediumint(8) | 0 | 否 | 0 | ||
showstatus | tinyint(1) | 0 | 否 | 0 | ||
custom | tinyint(1) | 0 | 否 | 0 | ||
canedit | tinyint(1) | 0 | 否 | 0 | ||
publish | tinyint(1) | 0 | 否 | Normal Index | 0 | |
hasvars | tinyint(1) | 0 | 否 | 0 |