MySQL Create Table SQL
Table Structure: okayapi_fl_tag:/tablelist/okayapi_fl_tag.html
-- MySQL Table okayapi_fl_tag
-- From: OkayAPI.com
CREATE TABLE `okayapi_fl_tag` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(36) NOT NULL COMMENT '名称',
`title` varchar(100) NOT NULL COMMENT '标题',
`keywords` varchar(100) NOT NULL COMMENT '关键词',
`description` varchar(150) 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建站系统-TAG标签表';
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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
name | varchar(36) | 否 | 名称 | |||
title | varchar(100) | 否 | 标题 | |||
keywords | varchar(100) | 否 | 关键词 | |||
description | varchar(150) | 否 | 描述 | |||
content | mediumtext | 是 | 内容 | |||
click | int(11) | 0 | 否 | 点击量 | 0 | |
litpic | varchar(150) | 否 | 缩略图或封面 | |||
template | varchar(30) | 否 | 模板名称 | |||
filename | varchar(60) | 否 | 别名 | |||
status | tinyint(1) | 0 | 否 | 0正常,1禁用 | 0 |