MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_logs:/tablelist/okayapi_jieqi_system_logs.html
-- MySQL Table okayapi_jieqi_system_logs
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_logs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`targetname` varchar(60) NOT NULL COMMENT '',
`targetid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`targettitle` varchar(60) NOT NULL COMMENT '',
`logurl` varchar(100) NOT NULL COMMENT '',
`logcode` int(11) NOT NULL DEFAULT '0' COMMENT '',
`logtitle` varchar(100) NOT NULL COMMENT '',
`logdata` text NOT NULL COMMENT '',
`lognote` text NOT NULL COMMENT '',
`fromdata` text NOT NULL COMMENT '',
`todata` text NOT NULL COMMENT '',
`siteid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`logtype` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`loglevel` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
`logtime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`userid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`username` varchar(30) NOT NULL COMMENT '',
`userip` varchar(25) NOT NULL COMMENT '',
KEY `targetname` (`targetname`),
KEY `targetid` (`targetid`),
KEY `targettitle` (`targettitle`),
KEY `logurl` (`logurl`),
KEY `logcode` (`logcode`),
KEY `logtitle` (`logtitle`),
KEY `logdata` (`logdata`),
KEY `lognote` (`lognote`),
KEY `fromdata` (`fromdata`),
KEY `todata` (`todata`),
KEY `siteid` (`siteid`),
KEY `logtype` (`logtype`),
KEY `loglevel` (`loglevel`),
KEY `logtime` (`logtime`),
KEY `userid` (`userid`),
KEY `username` (`username`),
KEY `userip` (`userip`),
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-17 of 17 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
targetname | varchar(60) | 否 | ||||
targetid | int(11) | 0 | 否 | 0 | ||
targettitle | varchar(60) | 否 | ||||
logurl | varchar(100) | 否 | ||||
logcode | int(11) | 0 | 否 | 0 | ||
logtitle | varchar(100) | 否 | ||||
logdata | text | 否 | ||||
lognote | text | 否 | ||||
fromdata | text | 否 | ||||
todata | text | 否 | ||||
siteid | int(11) | 0 | 否 | 0 | ||
logtype | tinyint(3) | 0 | 否 | Normal Index | 0 | |
loglevel | tinyint(3) | 0 | 否 | Normal Index | 0 | |
logtime | int(11) | 0 | 否 | 0 | ||
userid | int(11) | 0 | 否 | Normal Index | 0 | |
username | varchar(30) | 否 | ||||
userip | varchar(25) | 否 |