okayapi_jieqi_system_userlog - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jieqi_system_userlog：/tablelist/okayapi_jieqi_system_userlog.html


-- MySQL Table okayapi_jieqi_system_userlog
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_userlog` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
    `logtime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `fromid` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `fromname` varchar(30) NOT NULL COMMENT '',
    `toid` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `toname` varchar(30) NOT NULL COMMENT '',
    `reason` text NOT NULL COMMENT '',
    `chginfo` text NOT NULL COMMENT '',
    `chglog` text NOT NULL COMMENT '',
    `isdel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `userlog` mediumtext NOT NULL COMMENT '',
    KEY `siteid` (`siteid`),
    KEY `logtime` (`logtime`),
    KEY `fromid` (`fromid`),
    KEY `fromname` (`fromname`),
    KEY `toid` (`toid`),
    KEY `toname` (`toname`),
    KEY `reason` (`reason`),
    KEY `chginfo` (`chginfo`),
    KEY `chglog` (`chglog`),
    KEY `isdel` (`isdel`),
    KEY `userlog` (`userlog`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-用户日志';

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

MySQL database table structure design

Displaying 1-11 of 11 results.

Field Name	Field Type	Default	IS NULL	Index	Demo Data
siteid	smallint(6)	0	否		0
logtime	int(11)	0	否	Normal Index	0
fromid	int(11)	0	否	Normal Index	0
fromname	varchar(30)		否	Normal Index
toid	int(11)	0	否	Normal Index	0
toname	varchar(30)		否	Normal Index
reason	text		否
chginfo	text		否
chglog	text		否
isdel	tinyint(1)	0	否	Normal Index	0
userlog	mediumtext		否