X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F21%2Fupgrade_003_create_table_buffer_new.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F21%2Fupgrade_003_create_table_buffer_new.sql;h=0000000000000000000000000000000000000000;hb=3cf5c49e7753be48a994917fe898730add4292b1;hp=d0f54e1bda4ad3939c323373835c46114fdc5b74;hpb=e4fc79c07f5301ce2c7888e709ada0945b675c4f;p=quassel.git

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
index d0f54e1b..00000000
--- 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)
-);