MySQL Create Table SQL
Table Structure: okayapi_landi_message：/tablelist/okayapi_landi_message.html
-- MySQL Table okayapi_landi_message
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_message` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ctime` date NULL COMMENT '',
`ntime` date NULL COMMENT '',
`okayapi_landi_message_type` int(11) NULL COMMENT '',
`userid` int(10) NULL DEFAULT '0' COMMENT '',
`content` varchar(256) NULL COMMENT '',
`state` int(11) NULL COMMENT '',
KEY `ctime` (`ctime`),
KEY `ntime` (`ntime`),
KEY `okayapi_landi_message_type` (`okayapi_landi_message_type`),
KEY `userid` (`userid`),
KEY `content` (`content`),
KEY `state` (`state`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-通知';
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 |
|---|---|---|---|---|---|---|
| ctime | date | 否 | ||||
| ntime | date | 否 | ||||
| okayapi_landi_message_type | int(11) | 否 | ||||
| userid | int(10) | 0 | 否 | Normal Index | 0 | |
| content | varchar(256) | 是 | ||||
| state | int(11) | 是 |
