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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_srcms_record_type | int(10) | 否 | 操作类型 | |||
okayapi_srcms_record_name | varchar(255) | 否 | 操作名称 | |||
content | varchar(255) | 否 | 操作内容 | |||
okayapi_srcms_record_time | varchar(255) | 否 | 操作时间 | |||
okayapi_srcms_record_user | varchar(255) | 否 | 变动用户 | |||
userid | int(10) | 0 | 否 | 变动用户ID | 0 | |
operator | varchar(255) | 暂无 | 否 | 操作人 | 暂无 |