From 5205010d39340622ba8a85878cfe5e5aecf3dcfc Mon Sep 17 00:00:00 2001
From: Andreas Habel <mail@exceptionfault.de>
Date: Tue, 18 Nov 2008 09:35:59 +0100
Subject: Fixed a bug in tmw_world_states table script reported by
 YellowShadow. Modified column value to be nullable according to the sqlite
 table specification.

---
 src/sql/mysql/createTables.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/sql/mysql/createTables.sql')

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 7951079..9eda05a 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -149,7 +149,7 @@ AUTO_INCREMENT=1 ;
 CREATE TABLE IF NOT EXISTS `tmw_world_states` (
     `state_name`   varchar(100)          NOT NULL,
     `map_id`       int(10)      unsigned default NULL,
-    `value`        varchar(255)          NOT NULL,
+    `value`        varchar(255)          default NULL,
     `moddate`      int(10)      unsigned NOT NULL,
     --
     KEY `state_name` (`state_name`)
-- 
cgit 

