MySQL Create Table SQL
Table Structure: okayapi_mobile：/tablelist/okayapi_mobile.html
-- MySQL Table okayapi_mobile
-- From: OkayAPI.com
CREATE TABLE `okayapi_mobile` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`mobile` varchar(11) NULL COMMENT '手机号码（中国）',
`mobile_status` tinyint(3) NULL DEFAULT '0' COMMENT '手机号状态，自定义，0~100',
KEY `mobile` (`mobile`),
KEY `mobile_status` (`mobile_status`),
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-2 of 2 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| mobile | varchar(11) | 是 | 手机号码（中国） | Unique Index | 13800138000 | |
| mobile_status | tinyint(3) | 0 | 是 | 手机号状态，自定义，0~100 | 0 |
