From b8fa0246803dab40cf57d40b45984c53046f2d55 Mon Sep 17 00:00:00 2001
From: "Dzial Techniczny WMW Projekt s.c" <techniczna@wmwprojekt.pl>
Date: Tue, 10 Dec 2019 11:34:53 +0100
Subject: Plugins directory and local modifications

---
 plugins/Customizer/Schema/Postgres.php | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 plugins/Customizer/Schema/Postgres.php

(limited to 'plugins/Customizer/Schema/Postgres.php')

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
+        )"
+    );
+    
+}
-- 
cgit v1.2.3