From 1e8329986ef4d06a9bb7550e24f4dacc7715fb5b Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 4 May 2021 17:32:26 +0200
Subject: [main+Session] Move session from /tmp/ to session table

---
 modules-available/main/install.inc.php | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'modules-available/main/install.inc.php')

diff --git a/modules-available/main/install.inc.php b/modules-available/main/install.inc.php
index 92ad4db1..fe572487 100644
--- a/modules-available/main/install.inc.php
+++ b/modules-available/main/install.inc.php
@@ -48,6 +48,17 @@ $res[] = tableCreate('user', "
 	UNIQUE KEY `login` (`login`)
 ");
 
+$res[] = tableCreate('session', "
+	`sid` char(50) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
+	`userid` int(10) unsigned NOT NULL,
+	`dateline` int(10) unsigned NOT NULL DEFAULT '0',
+	`lastip` varchar(45) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
+	`fixedip` tinyint(1) unsigned NOT NULL DEFAULT '0',
+	`data` blob NOT NULL,
+	PRIMARY KEY (`sid`),
+	KEY `dateline` (`dateline`)
+");
+
 // Update path
 
 // #######################
-- 
cgit v1.2.3-55-g7522