summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndreas Habel <mail@exceptionfault.de>2008-11-18 09:35:59 +0100
committerBjørn Lindeijer <bjorn@lindeijer.nl>2008-11-18 17:02:26 +0100
commit5205010d39340622ba8a85878cfe5e5aecf3dcfc (patch)
tree5813870433baa49653fc565b08d0cbcdf84f01c4
parent08919f3338bb5af8f8803acb6f2914dfe21816d2 (diff)
downloadmanaserv-5205010d39340622ba8a85878cfe5e5aecf3dcfc.tar.gz
manaserv-5205010d39340622ba8a85878cfe5e5aecf3dcfc.tar.bz2
manaserv-5205010d39340622ba8a85878cfe5e5aecf3dcfc.tar.xz
manaserv-5205010d39340622ba8a85878cfe5e5aecf3dcfc.zip
Fixed a bug in tmw_world_states table script reported by YellowShadow. Modified column value to be nullable according to the sqlite table specification.
-rw-r--r--src/sql/mysql/createTables.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 79510792..9eda05a9 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`)