--- /dev/null
+SELECT networkid
+FROM network
+WHERE userid = :userid AND connected = 1
--- /dev/null
+SELECT buffername, key
+FROM buffer
+WHERE userid = :userid AND networkid = :networkid AND buffertype = 2
--- /dev/null
+UPDATE buffer
+SET joined = :joined
+WHERE userid = :userid AND networkid = :networkid AND buffercname = :buffercname AND buffertype = 2
--- /dev/null
+UPDATE buffer
+SET key = :key
+WHERE userid = :userid AND networkid = :networkid AND buffercname = :buffercname AND buffertype = 2
--- /dev/null
+UPDATE network
+SET connected = :connected
+WHERE userid = :userid AND networkid = :networkid
--- /dev/null
+ALTER TABLE network
+ADD COLUMN connected INTEGER NOT NULL DEFAULT 1
--- /dev/null
+ALTER TABLE buffer
+ADD COLUMN key TEXT
--- /dev/null
+ALTER TABLE buffer
+ADD COLUMN joined INTEGER NOT NULL DEFAULT 0
--- /dev/null
+UPDATE buffer
+SET joined = 1
+WHERE buffertype = 2
--- /dev/null
+UPDATE coreinfo
+SET value = '8'
+WHERE key = 'schemaversion'