MySQL Create Table SQL
Table Structure: okayapi_srcms_manager：/tablelist/okayapi_srcms_manager.html
-- MySQL Table okayapi_srcms_manager
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_manager` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL COMMENT '',
`email` varchar(100) NOT NULL DEFAULT '暂无' COMMENT '',
`okayapi_srcms_manager_password` varchar(32) NOT NULL DEFAULT '暂无' COMMENT '',
`token` varchar(255) NOT NULL DEFAULT '暂无' COMMENT 'token',
`login_ip` varchar(20) NOT NULL DEFAULT '暂无' COMMENT '',
`create_at` varchar(11) NOT NULL DEFAULT '暂无' COMMENT '',
`update_at` varchar(11) NOT NULL DEFAULT '暂无' COMMENT '',
KEY `username` (`username`),
KEY `email` (`email`),
KEY `okayapi_srcms_manager_password` (`okayapi_srcms_manager_password`),
KEY `token` (`token`),
KEY `login_ip` (`login_ip`),
KEY `create_at` (`create_at`),
KEY `update_at` (`update_at`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-管理员';
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 |
|---|---|---|---|---|---|---|
| username | varchar(20) | 否 | ||||
| varchar(100) | 暂无 | 否 | 暂无 | |||
| okayapi_srcms_manager_password | varchar(32) | 暂无 | 否 | 暂无 | ||
| token | varchar(255) | 暂无 | 否 | token | 暂无 | |
| login_ip | varchar(20) | 暂无 | 否 | 暂无 | ||
| create_at | varchar(11) | 暂无 | 否 | 暂无 | ||
| update_at | varchar(11) | 暂无 | 否 | 暂无 |
