MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_hot_words：/tablelist/okayapi_xbinstore_tb_hot_words.html
-- MySQL Table okayapi_xbinstore_tb_hot_words
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_hot_words` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`category` varchar(3) NULL COMMENT '热门词分类 1-加红 2-搜索框显示 null-正常',
`okayapi_xbinstore_tb_hot_words_name` varchar(200) NULL COMMENT '热门词',
`url` varchar(100) NULL COMMENT '跳转网页',
`search` tinyint(4) NULL DEFAULT '1' COMMENT '热门词状态，1-搜索，2-指定网页',
`created` datetime NULL COMMENT '',
`updated` datetime NULL COMMENT '',
KEY `category` (`category`),
KEY `okayapi_xbinstore_tb_hot_words_name` (`okayapi_xbinstore_tb_hot_words_name`),
KEY `url` (`url`),
KEY `search` (`search`),
KEY `created` (`created`),
KEY `updated` (`updated`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-热门关键词';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| category | varchar(3) | 是 | 热门词分类 1-加红 2-搜索框显示 null-正常 | |||
| okayapi_xbinstore_tb_hot_words_name | varchar(200) | 是 | 热门词 | |||
| url | varchar(100) | 是 | 跳转网页 | |||
| search | tinyint(4) | 1 | 否 | 热门词状态，1-搜索，2-指定网页 | 1 | |
| created | datetime | 是 | ||||
| updated | datetime | 是 | Normal Index |
