From 4871897d9f2b2155bcc71c5dafd925983edf8127 Mon Sep 17 00:00:00 2001 From: Yohann Ferreira Date: Sun, 15 Jan 2006 23:25:51 +0000 Subject: Chat channeling commit part 1. Useful to get feedback before committing what's next --- src/dalstoragesql.h | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'src/dalstoragesql.h') diff --git a/src/dalstoragesql.h b/src/dalstoragesql.h index cc287fbe..84e1a57f 100644 --- a/src/dalstoragesql.h +++ b/src/dalstoragesql.h @@ -316,6 +316,26 @@ const std::string SQL_INVENTORIES_TABLE( ");" ); +/** + * TABLE: tmw_channels. + * Keeps opened public Channel list + */ +const std::string CHANNELS_TBL_NAME("tmw_channels"); +const std::string SQL_CHANNELS_TABLE( + "CREATE TABLE tmw_channels (" +#if defined (MYSQL_SUPPORT) + "id INTEGER PRIMARY KEY," + "name VARCHAR(32) NOT NULL UNIQUE" +#elif defined (SQLITE_SUPPORT) + "id INTEGER PRIMARY KEY," + "name TEXT NOT NULL UNIQUE" +#elif defined (POSTGRESQL_SUPPORT) + "id SERIAL PRIMARY KEY," + "name TEXT NOT NULL UNIQUE" +#endif + ");" +); + } // anonymous namespace -- cgit v1.2.3-70-g09d2