MySQL Create Table SQL
Table Structure: okayapi_zd_auth_info：/tablelist/okayapi_zd_auth_info.html
-- MySQL Table okayapi_zd_auth_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_zd_auth_info` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`auth_name` varchar(50) NOT NULL COMMENT '权限名',
`auth_desc` varchar(100) NOT NULL COMMENT '权限说明',
`can_edit` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否可编辑 0=否 1=是',
`create_uid` bigint(20) NOT NULL COMMENT '创建人用户ID',
`auth_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '权限类型 0=隐藏权限 1=可使用',
KEY `auth_name` (`auth_name`),
KEY `auth_desc` (`auth_desc`),
KEY `can_edit` (`can_edit`),
KEY `create_uid` (`create_uid`),
KEY `auth_type` (`auth_type`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WIKI-权限信息表';
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 |
|---|---|---|---|---|---|---|
| auth_name | varchar(50) | 是 | 权限名 | |||
| auth_desc | varchar(100) | 是 | 权限说明 | |||
| can_edit | tinyint(4) | 1 | 是 | 是否可编辑 0=否 1=是 | 1 | |
| create_uid | bigint(20) | 是 | 创建人用户ID | |||
| auth_type | tinyint(4) | 0 | 否 | 权限类型 0=隐藏权限 1=可使用 | 0 |
