core: Separate SQL current and upgrade scripts

[quassel.git] / src / core / SQL / SQLite / 14 / upgrade_010_create_networktable.sql

diff --git a/src/core/SQL/SQLite/14/upgrade_010_create_networktable.sql b/src/core/SQL/SQLite/14/upgrade_010_create_networktable.sql
deleted file mode 100644 (file)
index c4e864e..0000000
--- a/src/core/SQL/SQLite/14/upgrade_010_create_networktable.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-CREATE TABLE network (
-       networkid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-       userid INTEGER NOT NULL,
-       networkname TEXT NOT NULL,
-       identityid INTEGER NOT NULL DEFAULT 1,
-       encodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
-       decodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
-       servercodec TEXT NOT NULL DEFAULT "",
-       userandomserver INTEGER NOT NULL DEFAULT 0, -- BOOL
-       perform TEXT,
-       useautoidentify INTEGER NOT NULL DEFAULT 0, -- BOOL
-       autoidentifyservice TEXT,
-       autoidentifypassword TEXT,
-       useautoreconnect INTEGER NOT NULL DEFAULT 0, -- BOOL
-       autoreconnectinterval INTEGER NOT NULL DEFAULT 0,
-       autoreconnectretries INTEGER NOT NULL DEFAULT 0,
-       unlimitedconnectretries INTEGER NOT NULL DEFAULT 0, -- BOOL
-       rejoinchannels INTEGER NOT NULL DEFAULT 0, -- BOOL
-       connected INTEGER NOT NULL DEFAULT 0, -- BOOL
-       usermode TEXT, -- user mode to restore
-       awaymessage TEXT, -- away message to restore (empty if not away)
-       attachperform TEXT, -- perform list for on attach
-       detachperform TEXT, -- perform list for on detach
-       UNIQUE (userid, networkname)
-)