1 files changed, 3 insertions, 3 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index a48644b3..dc405d95 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -278,10 +278,10 @@ DEFAULT CHARSET=utf8;
 CREATE TABLE IF NOT EXISTS mana_world_states
 (
    state_name   varchar(100)NOT NULL,
-   map_id       INTEGER     NULL,
-   value        TEXT        NULL,
+   map_id       INTEGER     NOT NULL,
+   value        TEXT        NOT NULL,
    moddate      INTEGER     NOT NULL,
-   PRIMARY KEY (`state_name`)
+   PRIMARY KEY (`state_name`, `map_id`)
 );
 
 --