+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_kite_log:/tablelist/okayapi_kite_log.html


-- MySQL Table okayapi_kite_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_kite_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `uid` int(11) NULL COMMENT '',
    `site_id` int(11) NULL COMMENT '',
    `title` varchar(255) NULL COMMENT '操作类型',
    `content` varchar(255) NULL COMMENT '操作内容',
    `ip` char(32) NULL COMMENT '',
    `create_at` int(11) NULL COMMENT '',
    KEY `uid` (`uid`),
    KEY `site_id` (`site_id`),
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `ip` (`ip`),
    KEY `create_at` (`create_at`),
    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-6 of 6 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
uidint(11)
site_idint(11)
titlevarchar(255)操作类型
contentvarchar(255)操作内容
ipchar(32)
create_atint(11)

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_message

MySQL Table Design okayapi_kite_navigation

TOP ↑