diff options
Diffstat (limited to 'plugins/Customizer/Schema/Sqlite.php')
-rw-r--r-- | plugins/Customizer/Schema/Sqlite.php | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/plugins/Customizer/Schema/Sqlite.php b/plugins/Customizer/Schema/Sqlite.php new file mode 100644 index 00000000..e8da08c1 --- /dev/null +++ b/plugins/Customizer/Schema/Sqlite.php @@ -0,0 +1,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 + )" + ); + +} |