[PATCH 1/2] openvpn: Create database schema if not exists

[Michael Tremer <michael.tremer@ipfire.org>]

[-- Attachment #1: Type: text/plain, Size: 1030 bytes --]

Signed-off-by: Michael Tremer <michael.tremer(a)ipfire.org>
---
 html/cgi-bin/logs.cgi/ovpnclients.dat | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

diff --git a/html/cgi-bin/logs.cgi/ovpnclients.dat b/html/cgi-bin/logs.cgi/ovpnclients.dat
index 2009990ec..a064893a1 100755
--- a/html/cgi-bin/logs.cgi/ovpnclients.dat
+++ b/html/cgi-bin/logs.cgi/ovpnclients.dat
@@ -95,6 +95,21 @@ unless ($to_datestring ge $from_datestring) {
 	$errormessage = "$Lang::tr{'error the to date has to be later than the from date'}";
 }
 
+# Initialise database
+my $cursor = $database_handle->prepare("
+	CREATE TABLE IF NOT EXISTS sessions(
+		common_name TEXT NOT NULL,
+		connected_at TEXT NOT NULL,
+		disconnected_at TEXT,
+		bytes_received INTEGER,
+		bytes_sent INTEGER
+	);
+
+	-- Create index for speeding up searches
+	CREATE INDEX IF NOT EXISTS sessions_common_name ON sessions(common_name);
+");
+$cursor->execute();
+
 my $database_query = qq(
 	SELECT
         common_name, SUM(
-- 
2.12.2