summaryrefslogtreecommitdiff
path: root/app/Schema
diff options
context:
space:
mode:
Diffstat (limited to 'app/Schema')
-rw-r--r--app/Schema/Mysql.php12
-rw-r--r--app/Schema/Postgres.php11
-rw-r--r--app/Schema/Sqlite.php11
3 files changed, 31 insertions, 3 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 5709b86d..32171d17 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -8,7 +8,17 @@ use PDO;
use Kanboard\Core\Security\Token;
use Kanboard\Core\Security\Role;
-const VERSION = 126;
+const VERSION = 127;
+
+function version_127(PDO $pdo)
+{
+ $pdo->exec("CREATE TABLE sessions (
+ id VARCHAR(255) NOT NULL,
+ expire_at INT NOT NULL,
+ data LONGTEXT,
+ PRIMARY KEY(id)
+ ) ENGINE=InnoDB CHARSET=utf8");
+}
function version_126(PDO $pdo)
{
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index bf9acaa7..8d5a68e5 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -8,7 +8,16 @@ use PDO;
use Kanboard\Core\Security\Token;
use Kanboard\Core\Security\Role;
-const VERSION = 105;
+const VERSION = 106;
+
+function version_106(PDO $pdo)
+{
+ $pdo->exec("CREATE TABLE sessions (
+ id TEXT PRIMARY KEY,
+ expire_at INTEGER NOT NULL,
+ data TEXT DEFAULT ''
+ )");
+}
function version_105(PDO $pdo)
{
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index 70d13b98..e40b2aeb 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -8,7 +8,16 @@ use Kanboard\Core\Security\Token;
use Kanboard\Core\Security\Role;
use PDO;
-const VERSION = 116;
+const VERSION = 117;
+
+function version_117(PDO $pdo)
+{
+ $pdo->exec("CREATE TABLE sessions (
+ id TEXT PRIMARY KEY,
+ expire_at INTEGER NOT NULL,
+ data TEXT DEFAULT ''
+ )");
+}
function version_116(PDO $pdo)
{