From 7d05004c8264eeee8aa1e9a5f0bc6a1126bc793a Mon Sep 17 00:00:00 2001 From: David Athay Date: Tue, 1 Apr 2008 17:10:01 +0000 Subject: Consolidated public and private channels into one, which also includes guild channels. Channels now have a joinable field, which is true for channels that are created by users, and false for guild channels. Chatting in guild channels now works, and non-guild members can no longer join guild channels --- src/account-server/dalstoragesql.hpp | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'src/account-server/dalstoragesql.hpp') diff --git a/src/account-server/dalstoragesql.hpp b/src/account-server/dalstoragesql.hpp index 16d0067e..ea7f620e 100644 --- a/src/account-server/dalstoragesql.hpp +++ b/src/account-server/dalstoragesql.hpp @@ -263,17 +263,20 @@ static char const *SQL_CHANNELS_TABLE = "id INTEGER PRIMARY KEY," "name VARCHAR(32) NOT NULL UNIQUE," "announcement VARCHAR(256) NOT NULL," - "password VARCHAR(32) NOT NULL" + "password VARCHAR(32) NOT NULL," + "joinable INTEGER NOT NULL" #elif defined (SQLITE_SUPPORT) "id INTEGER PRIMARY KEY," "name TEXT NOT NULL UNIQUE," "announcement TEXT NOT NULL," - "password TEXT NOT NULL" + "password TEXT NOT NULL," + "joinable INTEGER NOT NULL" #elif defined (POSTGRESQL_SUPPORT) "id SERIAL PRIMARY KEY," "name TEXT NOT NULL UNIQUE," "announcement TEXT NOT NULL," - "password TEXT NOT NULL" + "password TEXT NOT NULL," + "joinable INTEGER NOT NULL" #endif ");"; -- cgit v1.2.3-60-g2f50