1 files changed, 25 insertions, 0 deletions
diff --git a/plugins/Customizer/Schema/Postgres.php b/plugins/Customizer/Schema/Postgres.php
new file mode 100644
index 00000000..54568c69
--- /dev/null
+++ b/plugins/Customizer/Schema/Postgres.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 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
+        )"
+    );
+    
+}