MySQL Create Table SQL
Table Structure: okayapi_friend：/tablelist/okayapi_friend.html
-- MySQL Table okayapi_friend
-- From: OkayAPI.com
CREATE TABLE `okayapi_friend` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`friend_uuid` varchar(32) NOT NULL COMMENT '好友uuid',
`friend_username` varchar(100) NOT NULL COMMENT '好友账号',
`friend_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '关系状态，0新好友，1正常，2黑名单',
`friend_note` varchar(50) NOT NULL COMMENT '好友备注',
`friend_group` varchar(50) NOT NULL COMMENT '好友分组',
`friend_message` varchar(100) NOT NULL COMMENT '添加留言',
`friend_add_direction` varchar(100) NOT NULL COMMENT '添加方式(in,out)',
KEY `friend_uuid` (`friend_uuid`),
KEY `friend_username` (`friend_username`),
KEY `friend_status` (`friend_status`),
KEY `friend_note` (`friend_note`),
KEY `friend_group` (`friend_group`),
KEY `friend_message` (`friend_message`),
KEY `friend_add_direction` (`friend_add_direction`),
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-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| friend_uuid | varchar(32) | 否 | 好友uuid | Normal Index | ||
| friend_username | varchar(100) | 否 | 好友账号 | |||
| friend_status | tinyint(4) | 1 | 否 | 关系状态，0新好友，1正常，2黑名单 | 1 | |
| friend_note | varchar(50) | 否 | 好友备注 | |||
| friend_group | varchar(50) | 否 | 好友分组 | |||
| friend_message | varchar(100) | 否 | 添加留言 | |||
| friend_add_direction | varchar(100) | 否 | 添加方式(in,out) |
