summaryrefslogtreecommitdiff
path: root/plugins/Customizer/Schema/Mysql.php
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/Customizer/Schema/Mysql.php')
-rw-r--r--plugins/Customizer/Schema/Mysql.php23
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"
+ );
+}