MySQL Create Table SQL
Table Structure: okayapi_jieqi_system_right：/tablelist/okayapi_jieqi_system_right.html
-- MySQL Table okayapi_jieqi_system_right
-- From: OkayAPI.com
CREATE TABLE `okayapi_jieqi_system_right` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`modname` varchar(50) NOT NULL COMMENT '',
`rname` varchar(50) NOT NULL COMMENT '',
`rtitle` varchar(50) NOT NULL COMMENT '',
`rdescription` text NOT NULL COMMENT '',
`rhonors` text NOT NULL COMMENT '',
KEY `modname` (`modname`),
KEY `rname` (`rname`),
KEY `rtitle` (`rtitle`),
KEY `rdescription` (`rdescription`),
KEY `rhonors` (`rhonors`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-权限';
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 |
|---|---|---|---|---|---|---|
| modname | varchar(50) | 否 | Normal Index | |||
| rname | varchar(50) | 否 | ||||
| rtitle | varchar(50) | 否 | ||||
| rdescription | text | 否 | ||||
| rhonors | text | 否 |
