MySQL Create Table SQL
Table Structure: okayapi_file_uploads:/tablelist/okayapi_file_uploads.html
-- MySQL Table okayapi_file_uploads
-- From: OkayAPI.com
CREATE TABLE `okayapi_file_uploads` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`drive` varchar(50) NOT NULL COMMENT '驱动',
`upload_type` varchar(10) NOT NULL COMMENT '上传类型',
`specific_type` varchar(100) NOT NULL COMMENT '类别',
`base_url` varchar(100) NOT NULL COMMENT 'url',
`path` varchar(100) NOT NULL COMMENT '本地路径',
`name` varchar(100) NOT NULL COMMENT '文件原始名',
`extension` varchar(50) NOT NULL COMMENT '扩展名',
`size` int(11) NOT NULL DEFAULT '0' COMMENT '长度',
`year` int(10) NOT NULL DEFAULT '0' COMMENT '年份',
`month` int(10) NOT NULL DEFAULT '0' COMMENT '月份',
`day` int(10) NOT NULL DEFAULT '0' COMMENT '日',
`upload_ip` varchar(16) NOT NULL COMMENT '上传者ip',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
KEY `drive` (`drive`),
KEY `upload_type` (`upload_type`),
KEY `specific_type` (`specific_type`),
KEY `base_url` (`base_url`),
KEY `path` (`path`),
KEY `name` (`name`),
KEY `extension` (`extension`),
KEY `size` (`size`),
KEY `year` (`year`),
KEY `month` (`month`),
KEY `day` (`day`),
KEY `upload_ip` (`upload_ip`),
KEY `status` (`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-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
drive | varchar(50) | 否 | 驱动 | |||
upload_type | varchar(10) | 否 | 上传类型 | |||
specific_type | varchar(100) | 否 | 类别 | |||
base_url | varchar(100) | 否 | url | |||
path | varchar(100) | 否 | 本地路径 | |||
name | varchar(100) | 否 | 文件原始名 | |||
extension | varchar(50) | 否 | 扩展名 | |||
size | int(11) | 0 | 否 | 长度 | 0 | |
year | int(10) | 0 | 否 | 年份 | 0 | |
month | int(10) | 0 | 否 | 月份 | 0 | |
day | int(10) | 0 | 否 | 日 | 0 | |
upload_ip | varchar(16) | 否 | 上传者ip | |||
status | tinyint(4) | 1 | 否 | 状态[-1:删除;0:禁用;1启用] | 1 |