From 301ffe1048fb23548f72759b6ed0ca98e9109ff4 Mon Sep 17 00:00:00 2001 From: David Athay Date: Tue, 26 Jun 2007 19:50:02 +0000 Subject: Merged guilds-and-parties branch to trunk --- src/account-server/dalstoragesql.hpp | 49 ++++++++++++++++++++++++++++++++++++ 1 file changed, 49 insertions(+) (limited to 'src/account-server/dalstoragesql.hpp') diff --git a/src/account-server/dalstoragesql.hpp b/src/account-server/dalstoragesql.hpp index c4a433af..df141f69 100644 --- a/src/account-server/dalstoragesql.hpp +++ b/src/account-server/dalstoragesql.hpp @@ -334,6 +334,55 @@ const std::string SQL_CHANNELS_TABLE( ");" ); +/** + * TABLE: tmw_guilds. + * Store player guilds + */ +const std::string GUILDS_TBL_NAME("tmw_guilds"); +const std::string SQL_GUILDS_TABLE( + "CREATE TABLE tmw_guilds (" +#if defined (MYSQL_SUPPORT) + "id INTEGER PRIMARY KEY AUTO_INCREMENT," + "name VARCHAR(32) NOT NULL UNIQUE," + "FOREIGN KEY (name) REFERENCES tmw_characters(name)" +#elif defined (SQLITE_SUPPORT) + "id INTEGER PRIMARY KEY," + "name TEXT NOT NULL UNIQUE," + "FOREIGN KEY (name) REFERENCES tmw_characters(name)" +#elif defined (POSTGRESQL_SUPPORT) + "id SERIAL PRIMARY KEY," + "name TEXT NOT NULL UNIQUE," + "FOREIGN KEY (name) REFERENCES tmw_characters(name)" +#endif + ");" +); + +/** + * TABLE: tmw_guild_members. + * Store guild members + */ +const std::string GUILD_MEMBERS_TBL_NAME("tmw_guild_members"); +const std::string SQL_GUILD_MEMBERS_TABLE( + "CREATE TABLE tmw_guild_members (" +#if defined (MYSQL_SUPPORT) + "guild_id INTEGER NOT NULL," + "member_name VARCHAR(32) NOT NULL," + "FOREIGN KEY (guild_id) REFERENCES tmw_guilds(id)," + "FOREIGN KEY (member_name) REFERENCES tmw_characters(name)" +#elif defined (SQLITE_SUPPORT) + "guild_id INTEGER NOT NULL," + "member_name TEXT NOT NULL," + "FOREIGN KEY (guild_id) REFERENCES tmw_guilds(id)," + "FOREIGN KEY (member_name) REFERENCES tmw_characters(name)" +#elif defined (POSTGRESQL_SUPPORT) + "guild_id INTEGER NOT NULL," + "member_name TEXT NOT NULL," + "FOREIGN KEY (guild_id) REFERENCES tmw_guilds(id)," + "FOREIGN KEY (member_name) REFERENCES tmw_characters(name)" +#endif + ");" +); + } // anonymous namespace -- cgit v1.2.3-60-g2f50