okayapi_box_admin - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_admin：/tablelist/okayapi_box_admin.html


-- MySQL Table okayapi_box_admin
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_admin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role` varchar(30) NULL DEFAULT 'staff' COMMENT 'admin, staff',
    `admin_group_id` bigint(20) NULL DEFAULT '1' COMMENT '',
    `email` varchar(255) NULL COMMENT '',
    `pass` varchar(255) NULL COMMENT '',
    `salt` varchar(255) NULL COMMENT '',
    `name` varchar(255) NULL COMMENT '',
    `signature` varchar(255) NULL COMMENT '',
    `protected` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `status` varchar(30) NULL DEFAULT 'active' COMMENT 'active, inactive',
    `api_token` varchar(128) NULL COMMENT '',
    `permissions` text NULL COMMENT '',
    KEY `role` (`role`),
    KEY `admin_group_id` (`admin_group_id`),
    KEY `email` (`email`),
    KEY `pass` (`pass`),
    KEY `salt` (`salt`),
    KEY `name` (`name`),
    KEY `signature` (`signature`),
    KEY `protected` (`protected`),
    KEY `status` (`status`),
    KEY `api_token` (`api_token`),
    KEY `permissions` (`permissions`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-管理员';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-11 of 11 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
role	varchar(30)	staff	是	admin, staff		staff
admin_group_id	bigint(20)	1	是		Normal Index	1
email	varchar(255)		是		Unique Index
pass	varchar(255)		是
salt	varchar(255)		是
name	varchar(255)		是
signature	varchar(255)		是
protected	tinyint(1)	0	是			0
status	varchar(30)	active	是	active, inactive		active
api_token	varchar(128)		是
permissions	text		是