+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_srcms_record:/tablelist/okayapi_srcms_record.html


-- MySQL Table okayapi_srcms_record
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_record` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_srcms_record_type` int(10) NOT NULL COMMENT '操作类型',
    `okayapi_srcms_record_name` varchar(255) NOT NULL COMMENT '操作名称',
    `content` varchar(255) NOT NULL COMMENT '操作内容',
    `okayapi_srcms_record_time` varchar(255) NOT NULL COMMENT '操作时间',
    `okayapi_srcms_record_user` varchar(255) NOT NULL COMMENT '变动用户',
    `userid` int(10) NOT NULL DEFAULT '0' COMMENT '变动用户ID',
    `operator` varchar(255) NOT NULL DEFAULT '暂无' COMMENT '操作人',
    KEY `okayapi_srcms_record_type` (`okayapi_srcms_record_type`),
    KEY `okayapi_srcms_record_name` (`okayapi_srcms_record_name`),
    KEY `content` (`content`),
    KEY `okayapi_srcms_record_time` (`okayapi_srcms_record_time`),
    KEY `okayapi_srcms_record_user` (`okayapi_srcms_record_user`),
    KEY `userid` (`userid`),
    KEY `operator` (`operator`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-操作记录';

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


MySQL database table structure design

Displaying 1-7 of 7 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_srcms_record_typeint(10)操作类型
okayapi_srcms_record_namevarchar(255)操作名称
contentvarchar(255)操作内容
okayapi_srcms_record_timevarchar(255)操作时间
okayapi_srcms_record_uservarchar(255)变动用户
useridint(10)0变动用户ID0
operatorvarchar(255)暂无操作人暂无

Guess You Like

MySQL Table Design okayapi_srcms_blog

MySQL Table Design okayapi_srcms_category

MySQL Table Design okayapi_srcms_comment

MySQL Table Design okayapi_srcms_hall

MySQL Table Design okayapi_srcms_info

MySQL Table Design okayapi_srcms_links

MySQL Table Design okayapi_srcms_manager

MySQL Table Design okayapi_srcms_member

MySQL Table Design okayapi_srcms_notes

MySQL Table Design okayapi_srcms_order

MySQL Table Design okayapi_srcms_page

MySQL Table Design okayapi_srcms_post

MySQL Table Design okayapi_srcms_setting

TOP ↑