+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_theme:/tablelist/okayapi_fie_theme.html


-- MySQL Table okayapi_fie_theme
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_theme` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '安装时间',
    `okayapi_fie_theme_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '模板状态,1:正在使用;0:未使用',
    `is_compiled` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否为已编译模板',
    `theme` varchar(20) NOT NULL COMMENT '主题目录名,用于主题的维一标识',
    `okayapi_fie_theme_name` varchar(20) NOT NULL COMMENT '主题名称',
    `version` varchar(20) NOT NULL COMMENT '主题版本号',
    `demo_url` varchar(50) NOT NULL COMMENT '演示地址,带协议',
    `thumbnail` varchar(100) NOT NULL COMMENT '缩略图',
    `author` varchar(20) NOT NULL COMMENT '主题作者',
    `author_url` varchar(50) NOT NULL COMMENT '作者网站链接',
    `lang` varchar(10) NOT NULL COMMENT '支持语言',
    `keywords` varchar(50) NOT NULL COMMENT '主题关键字',
    `description` varchar(100) NOT NULL COMMENT '主题描述',
    KEY `create_time` (`create_time`),
    KEY `okayapi_fie_theme_status` (`okayapi_fie_theme_status`),
    KEY `is_compiled` (`is_compiled`),
    KEY `theme` (`theme`),
    KEY `okayapi_fie_theme_name` (`okayapi_fie_theme_name`),
    KEY `version` (`version`),
    KEY `demo_url` (`demo_url`),
    KEY `thumbnail` (`thumbnail`),
    KEY `author` (`author`),
    KEY `author_url` (`author_url`),
    KEY `lang` (`lang`),
    KEY `keywords` (`keywords`),
    KEY `description` (`description`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-主题';

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


MySQL database table structure design

Displaying 1-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
create_timeint(10)0安装时间0
okayapi_fie_theme_statustinyint(3)0模板状态,1:正在使用;0:未使用0
is_compiledtinyint(3)0是否为已编译模板0
themevarchar(20)主题目录名,用于主题的维一标识
okayapi_fie_theme_namevarchar(20)主题名称
versionvarchar(20)主题版本号
demo_urlvarchar(50)演示地址,带协议
thumbnailvarchar(100)缩略图
authorvarchar(20)主题作者
author_urlvarchar(50)作者网站链接
langvarchar(10)支持语言
keywordsvarchar(50)主题关键字
descriptionvarchar(100)主题描述

Guess You Like

MySQL Table Design okayapi_message

MySQL Table Design okayapi_article

MySQL Table Design okayapi_fie_admin_menu

MySQL Table Design okayapi_fie_asset

MySQL Table Design okayapi_fie_auth_access

MySQL Table Design okayapi_fie_auth_rule

MySQL Table Design okayapi_fie_comment

MySQL Table Design okayapi_fie_hook

MySQL Table Design okayapi_fie_hook_plugin

MySQL Table Design okayapi_fie_link

MySQL Table Design okayapi_fie_nav

MySQL Table Design okayapi_fie_nav_menu

MySQL Table Design okayapi_fie_option

MySQL Table Design okayapi_fie_plugin

MySQL Table Design okayapi_fie_portal_category

MySQL Table Design okayapi_fie_portal_category_post

MySQL Table Design okayapi_fie_portal_post

MySQL Table Design okayapi_fie_portal_tag

MySQL Table Design okayapi_fie_portal_tag_post

MySQL Table Design okayapi_fie_recycle_bin

TOP ↑