okayapi_opentrip_travel_admin - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opentrip_travel_admin：/tablelist/okayapi_opentrip_travel_admin.html


-- MySQL Table okayapi_opentrip_travel_admin
-- From: OkayAPI.com
CREATE TABLE `okayapi_opentrip_travel_admin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(10) NOT NULL COMMENT '用户名',
    `okayapi_opentrip_travel_admin_password` char(32) NOT NULL COMMENT '密码',
    `salt` char(6) NOT NULL COMMENT '密钥',
    `priv` int(1) NOT NULL DEFAULT '1' COMMENT '管理员权限，0为最高级权限，1为普通权限',
    KEY `username` (`username`),
    KEY `okayapi_opentrip_travel_admin_password` (`okayapi_opentrip_travel_admin_password`),
    KEY `salt` (`salt`),
    KEY `priv` (`priv`),
    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-4 of 4 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
username	varchar(10)		否	用户名	Unique Index
okayapi_opentrip_travel_admin_password	char(32)		否	密码
salt	char(6)		否	密钥
priv	int(1)	1	否	管理员权限，0为最高级权限，1为普通权限		1