diff options
| author | Huynh Tran <nthuynh75@gmail.com> | 2005-06-21 19:38:37 +0000 |
|---|---|---|
| committer | Huynh Tran <nthuynh75@gmail.com> | 2005-06-21 19:38:37 +0000 |
| commit | 816d8acd16faeb20713c3d09466003a444940f6f (patch) | |
| tree | bb25a9f471e9748f0188b6769751a037a08439c5 | |
| parent | d3970eb90caa538c88e44609130d9e159e01d60f (diff) | |
| download | manaserv-816d8acd16faeb20713c3d09466003a444940f6f.tar.gz manaserv-816d8acd16faeb20713c3d09466003a444940f6f.tar.bz2 manaserv-816d8acd16faeb20713c3d09466003a444940f6f.tar.xz manaserv-816d8acd16faeb20713c3d09466003a444940f6f.zip | |
Account names and character names must be unique.
| -rw-r--r-- | src/dalstoragesql.h | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/dalstoragesql.h b/src/dalstoragesql.h index 1e24f09e..26a3e455 100644 --- a/src/dalstoragesql.h +++ b/src/dalstoragesql.h @@ -92,7 +92,7 @@ const std::string SQL_ACCOUNTS_TABLE( "CREATE TABLE tmw_accounts (" #if defined (MYSQL_SUPPORT) "id INTEGER PRIMARY KEY AUTO_INCREMENT," - "username VARCHAR(32) NOT NULL," + "username VARCHAR(32) NOT NULL UNIQUE," "password VARCHAR(32) NOT NULL," "email VARCHAR(64) NOT NULL," "level TINYINT UNSIGNED NOT NULL," @@ -100,7 +100,7 @@ const std::string SQL_ACCOUNTS_TABLE( "INDEX (id)" #elif defined (SQLITE_SUPPORT) "id INTEGER PRIMARY KEY," - "username TEXT NOT NULL," + "username TEXT NOT NULL UNIQUE," "password TEXT NOT NULL," "email TEXT NOT NULL," "level INTEGER NOT NULL," @@ -125,7 +125,7 @@ const std::string SQL_CHARACTERS_TABLE( #if defined (MYSQL_SUPPORT) "id INTEGER PRIMARY KEY AUTO_INCREMENT," "user_id INTEGER UNSIGNED NOT NULL," - "name VARCHAR(32) NOT NULL," + "name VARCHAR(32) NOT NULL UNIQUE," // general information about the character "gender TINYINT UNSIGNED NOT NULL," "level TINYINT UNSIGNED NOT NULL," @@ -148,7 +148,7 @@ const std::string SQL_CHARACTERS_TABLE( #elif defined (SQLITE_SUPPORT) "id INTEGER PRIMARY KEY," "user_id INTEGER NOT NULL," - "name TEXT NOT NULL," + "name TEXT NOT NULL UNIQUE," // general information about the character "gender INTEGER NOT NULL," "level INTEGER NOT NULL," @@ -230,7 +230,7 @@ const std::string SQL_WORLD_ITEMS_TABLE( /** - * TABLE: tmw_inventory. + * TABLE: tmw_inventories. */ const std::string INVENTORIES_TBL_NAME("tmw_inventories"); const std::string SQL_INVENTORIES_TABLE( |