MySQL Create Table SQL
Table Structure: okayapi_topic:/tablelist/okayapi_topic.html
-- MySQL Table okayapi_topic
-- From: OkayAPI.com
CREATE TABLE `okayapi_topic` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`topic_title` varchar(64) NULL COMMENT '话题标题',
`discuss_count` int(11) NULL DEFAULT '0' COMMENT '讨论计数',
`topic_description` text NULL COMMENT '话题描述',
`topic_pic` varchar(255) NULL COMMENT '话题图片',
`topic_lock` tinyint(2) NULL DEFAULT '0' COMMENT '话题是否锁定 1 锁定 0 未锁定',
`focus_count` int(11) NULL DEFAULT '0' COMMENT '关注计数',
`seo_title` varchar(255) NULL COMMENT '',
`parent_id` int(10) NULL DEFAULT '0' COMMENT '',
`is_parent` tinyint(1) NULL DEFAULT '0' COMMENT '',
KEY `topic_title` (`topic_title`),
KEY `discuss_count` (`discuss_count`),
KEY `topic_description` (`topic_description`),
KEY `topic_pic` (`topic_pic`),
KEY `topic_lock` (`topic_lock`),
KEY `focus_count` (`focus_count`),
KEY `seo_title` (`seo_title`),
KEY `parent_id` (`parent_id`),
KEY `is_parent` (`is_parent`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '话题';
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 | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
topic_title | varchar(64) | 是 | 话题标题 | |||
discuss_count | int(11) | 0 | 是 | 讨论计数 | 0 | |
topic_description | text | 是 | 话题描述 | |||
topic_pic | varchar(255) | 是 | 话题图片 | |||
topic_lock | tinyint(2) | 0 | 否 | 话题是否锁定 1 锁定 0 未锁定 | 0 | |
focus_count | int(11) | 0 | 是 | 关注计数 | 0 | |
seo_title | varchar(255) | 是 | ||||
parent_id | int(10) | 0 | 是 | 0 | ||
is_parent | tinyint(1) | 0 | 是 | 0 |