+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fl_searchword:/tablelist/okayapi_fl_searchword.html


-- MySQL Table okayapi_fl_searchword
-- From: OkayAPI.com
CREATE TABLE `okayapi_fl_searchword` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(36) NOT NULL COMMENT '名称',
    `title` varchar(60) NOT NULL COMMENT 'SEO标题',
    `keywords` varchar(100) NOT NULL COMMENT '关键词',
    `description` varchar(250) NOT NULL COMMENT '描述',
    `content` mediumtext NOT NULL COMMENT '内容',
    `click` int(11) NOT NULL DEFAULT '0' COMMENT '点击量',
    `litpic` varchar(150) NOT NULL COMMENT '缩略图或封面',
    `template` varchar(30) NOT NULL COMMENT '模板名称',
    `filename` varchar(60) NOT NULL COMMENT '别名',
    `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态,0正常,1禁用',
    KEY `name` (`name`),
    KEY `title` (`title`),
    KEY `keywords` (`keywords`),
    KEY `description` (`description`),
    KEY `content` (`content`),
    KEY `click` (`click`),
    KEY `litpic` (`litpic`),
    KEY `template` (`template`),
    KEY `filename` (`filename`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CMS建站系统-搜索关键词表';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
namevarchar(36)名称
titlevarchar(60)SEO标题
keywordsvarchar(100)关键词
descriptionvarchar(250)描述
contentmediumtext内容
clickint(11)0点击量0
litpicvarchar(150)缩略图或封面
templatevarchar(30)模板名称
filenamevarchar(60)别名
statustinyint(1)0状态,0正常,1禁用0

Guess You Like

MySQL Table Design okayapi_kite_addons

MySQL Table Design okayapi_kite_auth_role

MySQL Table Design okayapi_kite_auth_rule

MySQL Table Design okayapi_kite_auth_user

MySQL Table Design okayapi_kite_block

MySQL Table Design okayapi_kite_document_category

MySQL Table Design okayapi_kite_document_comments

MySQL Table Design okayapi_kite_document_comments_like

MySQL Table Design okayapi_kite_document_content

MySQL Table Design okayapi_kite_document_content_extra

MySQL Table Design okayapi_kite_document_content_like

MySQL Table Design okayapi_kite_document_field

MySQL Table Design okayapi_kite_document_model

MySQL Table Design okayapi_kite_document_model_field

MySQL Table Design okayapi_kite_feedback

MySQL Table Design okayapi_kite_hooks

MySQL Table Design okayapi_kite_language

MySQL Table Design okayapi_kite_link

MySQL Table Design okayapi_kite_log

MySQL Table Design okayapi_kite_message

TOP ↑