+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
drivevarchar(50)驱动
upload_typevarchar(10)上传类型
specific_typevarchar(100)类别
base_urlvarchar(100)url
pathvarchar(100)本地路径
namevarchar(100)文件原始名
extensionvarchar(50)扩展名
sizeint(11)0长度0
yearint(10)0年份0
monthint(10)0月份0
dayint(10)00
upload_ipvarchar(16)上传者ip
statustinyint(4)1状态[-1:删除;0:禁用;1启用]1

Guess You Like

MySQL Table Design okayapi_framework_log

MySQL Table Design okayapi_provinces_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_datas_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_message

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_menu_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_sys_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑