summaryrefslogtreecommitdiff
path: root/plugins/Customizer/Schema/Sqlite.php
blob: e8da08c17146029d1680b2d4f6076c9b03c304c9 (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 INTEGER PRIMARY KEY,
            custom_id INTEGER NOT NULL,
            name TEXT COLLATE NOCASE NOT NULL,
            path TEXT NOT NULL,
            is_image INTEGER DEFAULT 0,
            size INTEGER DEFAULT 0 NOT NULL,
            user_id INTEGER DEFAULT 0 NOT NULL,
            date INTEGER DEFAULT 0 NOT NULL
        )"
    );
    
}