From af045b4818333b4360f14981c695817c4c8adb21 Mon Sep 17 00:00:00 2001 From: Roderic Morris Date: Tue, 3 Jun 2008 16:31:32 +0000 Subject: stop storing channels in the db, send channel announcements --- src/account-server/dalstoragesql.hpp | 28 ---------------------------- 1 file changed, 28 deletions(-) (limited to 'src/account-server/dalstoragesql.hpp') diff --git a/src/account-server/dalstoragesql.hpp b/src/account-server/dalstoragesql.hpp index ea7f620e..ee77d8f2 100644 --- a/src/account-server/dalstoragesql.hpp +++ b/src/account-server/dalstoragesql.hpp @@ -252,34 +252,6 @@ static char const *SQL_INVENTORIES_TABLE = #endif ");"; -/** - * TABLE: tmw_channels. - * Keeps opened public Channel list - */ -static char const *CHANNELS_TBL_NAME = "tmw_channels"; -static char const *SQL_CHANNELS_TABLE = - "CREATE TABLE tmw_channels (" -#if defined (MYSQL_SUPPORT) - "id INTEGER PRIMARY KEY," - "name VARCHAR(32) NOT NULL UNIQUE," - "announcement VARCHAR(256) 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," - "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," - "joinable INTEGER NOT NULL" -#endif - ");"; - /** * TABLE: tmw_guilds. * Store player guilds -- cgit v1.2.3-60-g2f50