MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_userlink:/tablelist/okayapi_jieqi_system_userlink.html
-- MySQL Table okayapi_jieqi_system_userlink
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_userlink` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ultitle` varchar(60) NOT NULL COMMENT '',
`ulurl` varchar(100) NOT NULL COMMENT '',
`ulinfo` varchar(255) NOT NULL COMMENT '',
`userid` int(11) NOT NULL DEFAULT '0' COMMENT '',
`username` varchar(30) NOT NULL COMMENT '',
`score` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
`weight` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
`toptime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`addtime` int(11) NOT NULL DEFAULT '0' COMMENT '',
`allvisit` int(11) NOT NULL DEFAULT '0' COMMENT '',
KEY `ultitle` (`ultitle`),
KEY `ulurl` (`ulurl`),
KEY `ulinfo` (`ulinfo`),
KEY `userid` (`userid`),
KEY `username` (`username`),
KEY `score` (`score`),
KEY `weight` (`weight`),
KEY `toptime` (`toptime`),
KEY `addtime` (`addtime`),
KEY `allvisit` (`allvisit`),
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-10 of 10 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
ultitle | varchar(60) | 否 | ||||
ulurl | varchar(100) | 否 | ||||
ulinfo | varchar(255) | 否 | ||||
userid | int(11) | 0 | 否 | Normal Index | 0 | |
username | varchar(30) | 否 | ||||
score | tinyint(1) | 0 | 否 | 0 | ||
weight | smallint(6) | 0 | 否 | 0 | ||
toptime | int(11) | 0 | 否 | 0 | ||
addtime | int(11) | 0 | 否 | 0 | ||
allvisit | int(11) | 0 | 否 | 0 |