MySQL Create Table SQL
Table Structure: okayapi_smpss_admin：/tablelist/okayapi_smpss_admin.html
-- MySQL Table okayapi_smpss_admin
-- From: OkayAPI.com
CREATE TABLE `okayapi_smpss_admin` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`admin_id` int(10) NOT NULL COMMENT '',
`admin_name` char(16) NOT NULL COMMENT '',
`admin_pwd` char(32) NOT NULL COMMENT '',
`gid` int(1) NOT NULL COMMENT '管理用户组ID',
`lastlogintime` int(10) NOT NULL COMMENT '最后登录时间',
KEY `admin_id` (`admin_id`),
KEY `admin_name` (`admin_name`),
KEY `admin_pwd` (`admin_pwd`),
KEY `gid` (`gid`),
KEY `lastlogintime` (`lastlogintime`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| admin_id | int(10) | 否 | ||||
| admin_name | char(16) | 否 | ||||
| admin_pwd | char(32) | 否 | ||||
| gid | int(1) | 否 | 管理用户组ID | |||
| lastlogintime | int(10) | 否 | 最后登录时间 |
