summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorzephyrus <zephyrus@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-10-30 03:41:23 +0000
committerzephyrus <zephyrus@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-10-30 03:41:23 +0000
commit793e93c0c5eeb34f43c391a1a82175aa57300d14 (patch)
tree399d5654473d8927cdbea7cccd2aa00c7e720e7b
parent7fc7aae783200862e4791691736abf3d6f46e09b (diff)
downloadhercules-793e93c0c5eeb34f43c391a1a82175aa57300d14.tar.gz
hercules-793e93c0c5eeb34f43c391a1a82175aa57300d14.tar.bz2
hercules-793e93c0c5eeb34f43c391a1a82175aa57300d14.tar.xz
hercules-793e93c0c5eeb34f43c391a1a82175aa57300d14.zip
- Updated the mail sql structure in main.sql.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11617 54d463be-8e91-2dee-dedb-b68131a5f0ec
-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',