MySQL Create Table SQL
Table Structure: okayapi_sys_authitem：/tablelist/okayapi_sys_authitem.html
-- MySQL Table okayapi_sys_authitem
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_authitem` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL COMMENT '权限管理表',
`type` int(11) NOT NULL COMMENT '',
`description` text NOT NULL COMMENT '',
`bizrule` text NOT NULL COMMENT '',
`data` text NOT NULL COMMENT '',
`deleted` tinyint(255) NOT NULL DEFAULT '0' COMMENT '0未删除，1删除',
KEY `name` (`name`),
KEY `type` (`type`),
KEY `description` (`description`),
KEY `bizrule` (`bizrule`),
KEY `data` (`data`),
KEY `deleted` (`deleted`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-权限_功能模块子项目';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| name | varchar(64) | 否 | 权限管理表 | |||
| type | int(11) | 否 | ||||
| description | text | 是 | ||||
| bizrule | text | 是 | ||||
| data | text | 是 | ||||
| deleted | tinyint(255) | 0 | 否 | 0未删除，1删除 | 0 |
