core: Separate SQL current and upgrade scripts

[quassel.git] / src / core / SQL / SQLite / 21 / upgrade_003_create_table_buffer_new.sql

diff --git a/src/core/SQL/SQLite/21/upgrade_003_create_table_buffer_new.sql b/src/core/SQL/SQLite/21/upgrade_003_create_table_buffer_new.sql
deleted file mode 100644 (file)
index d0f54e1..0000000
--- a/src/core/SQL/SQLite/21/upgrade_003_create_table_buffer_new.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE buffer_new (
-        bufferid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-        userid INTEGER NOT NULL,
-        groupid INTEGER,
-        networkid INTEGER NOT NULL,
-        buffername TEXT NOT NULL,
-        buffercname TEXT NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
-        buffertype INTEGER NOT NULL DEFAULT 0,
-        lastmsgid INTEGER NOT NULL DEFAULT 0,
-        lastseenmsgid INTEGER NOT NULL DEFAULT 0,
-        markerlinemsgid INTEGER NOT NULL DEFAULT 0,
-        key TEXT,
-        joined INTEGER NOT NULL DEFAULT 0, -- BOOL
-        CHECK (lastseenmsgid <= lastmsgid)
-);