summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--Changelog-Trunk.txt1
-rw-r--r--sql-files/main.sql2
2 files changed, 2 insertions, 1 deletions
diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt
index ddee23428..bc3439012 100644
--- a/Changelog-Trunk.txt
+++ b/Changelog-Trunk.txt
@@ -4,6 +4,7 @@ AS OF SVN REV. 5091, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO
IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK.
2007/10/29
+ * Updated the mail db structure on main.sql [Zephyrus]
* Makefile creating the conf/import forder. [FlavioJS]
* command code cleaning (refer to topic:169759) [ultramage]
- separated the execution part of command code into interface part
diff --git a/sql-files/main.sql b/sql-files/main.sql
index d03f67548..90c989443 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -479,7 +479,7 @@ CREATE TABLE `mail` (
`title` varchar(45) NOT NULL default '',
`message` varchar(255) NOT NULL default '',
`time` int(11) unsigned NOT NULL default '0',
- `read_flag` tinyint(1) unsigned NOT NULL default '0',
+ `status` tinyint(2) unsigned NOT NULL default '0',
`zeny` int(11) unsigned NOT NULL default '0',
`nameid` int(11) unsigned NOT NULL default '0',
`amount` int(11) unsigned NOT NULL default '0',