diff options
| author | Yohann Ferreira <bertram@cegetel.net> | 2006-01-15 23:25:51 +0000 |
|---|---|---|
| committer | Yohann Ferreira <bertram@cegetel.net> | 2006-01-15 23:25:51 +0000 |
| commit | 4871897d9f2b2155bcc71c5dafd925983edf8127 (patch) | |
| tree | 09057c61a4551cc83eefa828e55cdd25d3ebf7b7 /src/dalstoragesql.h | |
| parent | b61fc25de4bb543582bbb7c49e093007f5ca0f0e (diff) | |
| download | manaserv-4871897d9f2b2155bcc71c5dafd925983edf8127.tar.gz manaserv-4871897d9f2b2155bcc71c5dafd925983edf8127.tar.bz2 manaserv-4871897d9f2b2155bcc71c5dafd925983edf8127.tar.xz manaserv-4871897d9f2b2155bcc71c5dafd925983edf8127.zip | |
Chat channeling commit part 1. Useful to get feedback before committing what's next
Diffstat (limited to 'src/dalstoragesql.h')
| -rw-r--r-- | src/dalstoragesql.h | 20 |
1 files changed, 20 insertions, 0 deletions
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 |