From 2082b554255519b0c82c883037ff2b40e75f30d2 Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Tue, 19 Feb 2008 15:26:03 +0000 Subject: [PATCH] fixed creation of buffer schema --- src/core/SQL/SQLite/7/setup_030_buffer.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/core/SQL/SQLite/7/setup_030_buffer.sql b/src/core/SQL/SQLite/7/setup_030_buffer.sql index c9f82859..ea1c3ff1 100644 --- a/src/core/SQL/SQLite/7/setup_030_buffer.sql +++ b/src/core/SQL/SQLite/7/setup_030_buffer.sql @@ -5,5 +5,6 @@ CREATE TABLE buffer ( networkid INTEGER NOT NULL, buffername TEXT NOT NULL, buffercname TEXT NOT NULL, -- CANONICAL BUFFER NAME (lowercase version) - buffertype INTEGER NOT NULL DEFAULT 0 + buffertype INTEGER NOT NULL DEFAULT 0, + lastseen INTEGER NOT NULL DEFAULT 0 ) -- 2.20.1