+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
targetnamevarchar(60)
targetidint(11)00
targettitlevarchar(60)
logurlvarchar(100)
logcodeint(11)00
logtitlevarchar(100)
logdatatext
lognotetext
fromdatatext
todatatext
siteidint(11)00
logtypetinyint(3)0Normal Index0
logleveltinyint(3)0Normal Index0
logtimeint(11)00
useridint(11)0Normal Index0
usernamevarchar(30)
useripvarchar(25)

Guess You Like

MySQL Table Design okayapi_xwx_author

MySQL Table Design okayapi_xwx_banner

MySQL Table Design okayapi_xwx_book

MySQL Table Design okayapi_xwx_category

MySQL Table Design okayapi_xwx_chapter

MySQL Table Design okayapi_xwx_tag

MySQL Table Design okayapi_xwx_admin

MySQL Table Design okayapi_xwx_friendship_link

MySQL Table Design okayapi_jieqi_system_adminmenu

MySQL Table Design okayapi_jieqi_system_blockconfigs

MySQL Table Design okayapi_jieqi_system_blocks

MySQL Table Design okayapi_jieqi_system_configs

MySQL Table Design okayapi_jieqi_system_defaultmenu

MySQL Table Design okayapi_jieqi_system_friends

MySQL Table Design okayapi_jieqi_system_groups

MySQL Table Design okayapi_jieqi_system_honors

MySQL Table Design okayapi_jieqi_system_mainmenu

MySQL Table Design okayapi_jieqi_system_mblock

MySQL Table Design okayapi_jieqi_system_message

MySQL Table Design okayapi_jieqi_system_modules

TOP ↑