okayapi_saixs_ad_admin - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_saixs_ad_admin：/tablelist/okayapi_saixs_ad_admin.html


-- MySQL Table okayapi_saixs_ad_admin
-- From: OkayAPI.com
CREATE TABLE `okayapi_saixs_ad_admin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_name` tinytext NULL COMMENT '用户名',
    `okayapi_saixs_ad_admin_password` tinytext NULL COMMENT '密码',
    `limits` varchar(300) NULL COMMENT '权限',
    `state` int(11) NULL DEFAULT '0' COMMENT '状态',
    `add_user` tinytext NULL COMMENT '添加用户',
    KEY `user_name` (`user_name`),
    KEY `okayapi_saixs_ad_admin_password` (`okayapi_saixs_ad_admin_password`),
    KEY `limits` (`limits`),
    KEY `state` (`state`),
    KEY `add_user` (`add_user`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'saixs广告管理-管理员';

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	Demo Data
user_name	tinytext		是	用户名
okayapi_saixs_ad_admin_password	tinytext		是	密码
limits	varchar(300)		是	权限
state	int(11)	0	是	状态	0
add_user	tinytext		是	添加用户