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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
uid | int(11) | 是 | ||||
site_id | int(11) | 是 | ||||
title | varchar(255) | 是 | 操作类型 | |||
content | varchar(255) | 是 | 操作内容 | |||
ip | char(32) | 是 | ||||
create_at | int(11) | 是 |