Plugins directory and local modifications

1 files changed, 23 insertions, 0 deletions

diff --git a/plugins/Customizer/Schema/Mysql.php b/plugins/Customizer/Schema/Mysql.php
new file mode 100644
index 00000000..978ceb0a
--- /dev/null
+++ b/plugins/Customizer/Schema/Mysql.php
@@ -0,0 +1,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"
+    );
+}