MySQL Create Table SQL
Table Structure: okayapi_cmdb_auth_permission:/tablelist/okayapi_cmdb_auth_permission.html
-- MySQL Table okayapi_cmdb_auth_permission
-- From: OkayAPI.com
CREATE TABLE `okayapi_cmdb_auth_permission` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_cmdb_auth_permission_name` varchar(255) NOT NULL COMMENT '',
`content_type_id` int(11) NOT NULL COMMENT '',
`codename` varchar(100) NOT NULL COMMENT '',
KEY `okayapi_cmdb_auth_permission_name` (`okayapi_cmdb_auth_permission_name`),
KEY `content_type_id` (`content_type_id`),
KEY `codename` (`codename`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CMDB管理-认证权限';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_cmdb_auth_permission_name | varchar(255) | 否 | ||||
content_type_id | int(11) | 否 | ||||
codename | varchar(100) | 否 |