MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_liuyan：/tablelist/okayapi_lvyou_jee_liuyan.html
-- MySQL Table okayapi_lvyou_jee_liuyan
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_liuyan` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(5) NULL COMMENT '',
`user_name` varchar(20) NULL COMMENT '',
`content` text NULL COMMENT '',
`contents` text NULL COMMENT '',
`admin_name` varchar(20) NULL COMMENT '',
`user_time` datetime NULL COMMENT '',
`admin_time` datetime NULL COMMENT '',
KEY `user_id` (`user_id`),
KEY `user_name` (`user_name`),
KEY `content` (`content`),
KEY `contents` (`contents`),
KEY `admin_name` (`admin_name`),
KEY `user_time` (`user_time`),
KEY `admin_time` (`admin_time`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-留言';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | int(5) | 否 | ||||
| user_name | varchar(20) | 否 | ||||
| content | text | 否 | ||||
| contents | text | 是 | ||||
| admin_name | varchar(20) | 是 | ||||
| user_time | datetime | 否 | ||||
| admin_time | datetime | 是 |
