summaryrefslogtreecommitdiff
path: root/plugins/Customizer/Schema/Mysql.php
blob: 978ceb0acd1f2094d99586507a70f029f77827f0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php

namespace Kanboard\Plugin\Customizer\Schema;

use PDO;

const VERSION = 1;

function version_1(PDO $pdo)
{
   $pdo->exec("CREATE TABLE customizer_files (
        id INT NOT NULL AUTO_INCREMENT,
        custom_id INT NOT NULL,
        name VARCHAR(255),
        path VARCHAR(255),
        is_image TINYINT(1) DEFAULT 0,
        date INT NOT NULL DEFAULT 0,
        user_id INT NOT NULL DEFAULT 0,
        size INT NOT NULL DEFAULT 0,
        PRIMARY KEY (id)
    ) ENGINE=InnoDB CHARSET=utf8"
    );
}