-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql.php
28 lines (26 loc) · 1.06 KB
/
schema.sql.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?php
/*
* This file is part of wulacms.
*
* (c) Leo Ning <windywany@gmail.com>
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
defined('APPROOT') or header('Page Not Found', true, 404) || die();
$tables['1.0.0'][] = "CREATE TABLE `{prefix}media` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传用户',
`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
`filename` varchar(1024) NOT NULL COMMENT '文件名',
`type` varchar(45) NOT NULL COMMENT '类型',
`url` varchar(1024) NOT NULL COMMENT '可直接访问的URL',
`filepath` varchar(1024) NOT NULL COMMENT '实际物理路径',
`size` int(10) NOT NULL DEFAULT '0' COMMENT '大小',
`width` int(10) NOT NULL DEFAULT '0',
`height` int(10) NOT NULL DEFAULT '0',
`deleted` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `IDX_UID` (`uid`),
KEY `IDX_TYPE` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='媒体库'";