MySQL Create Table SQL
Table Structure: okayapi_xwx_admin：/tablelist/okayapi_xwx_admin.html
-- MySQL Table okayapi_xwx_admin
-- From: OkayAPI.com
CREATE TABLE `okayapi_xwx_admin` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` char(32) NULL COMMENT '',
`okayapi_xwx_admin_password` char(32) NULL COMMENT '',
`create_time` int(11) NULL DEFAULT '0' COMMENT '',
`last_login_time` int(11) NULL DEFAULT '0' COMMENT '',
`last_login_ip` varchar(100) NULL COMMENT '',
KEY `username` (`username`),
KEY `okayapi_xwx_admin_password` (`okayapi_xwx_admin_password`),
KEY `create_time` (`create_time`),
KEY `last_login_time` (`last_login_time`),
KEY `last_login_ip` (`last_login_ip`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'xiaoshuo小说-管理员';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| username | char(32) | 否 | Unique Index | |||
| okayapi_xwx_admin_password | char(32) | 否 | ||||
| create_time | int(11) | 0 | 是 | 0 | ||
| last_login_time | int(11) | 0 | 是 | 0 | ||
| last_login_ip | varchar(100) | 是 |
