blob: 54568c692d59ba3aff80c1cb467b77ff04987861 (
plain)
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
|
<?php
namespace Kanboard\Plugin\Customizer\Schema;
use PDO;
const VERSION = 1;
function version_1(PDO $pdo)
{
$pdo->exec("
CREATE TABLE customizer_files (
id SERIAL PRIMARY KEY,
custom_id INTEGER NOT NULL,
name VARCHAR(255) NOT NULL,
path VARCHAR(255) NOT NULL,
is_image BOOLEAN DEFAULT '0',
size INTEGER DEFAULT 0 NOT NULL,
user_id INTEGER DEFAULT 0 NOT NULL,
date INTEGER DEFAULT 0 NOT NULL
)"
);
}
|
