diff options
| author | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2007-10-27 09:48:27 +0000 |
|---|---|---|
| committer | ultramage <ultramage@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2007-10-27 09:48:27 +0000 |
| commit | c5887c263b96f9a3bf128b3b53e63d68ff6b9392 (patch) | |
| tree | a767807a4b7a4bf5878523bb8f196d6fb6a32d94 /sql-files/upgrade_svn11582.sql | |
| parent | 4ecca0e292aafef33fe168d59c1a4e013cc0cda6 (diff) | |
| download | hercules-c5887c263b96f9a3bf128b3b53e63d68ff6b9392.tar.gz hercules-c5887c263b96f9a3bf128b3b53e63d68ff6b9392.tar.bz2 hercules-c5887c263b96f9a3bf128b3b53e63d68ff6b9392.tar.xz hercules-c5887c263b96f9a3bf128b3b53e63d68ff6b9392.zip | |
Followup fixes to r11583:
* fixed wrong sql upgrade file name, added svn:eol-style native
* made 'status' variable directly use the mail_status enum
* replaced some hardcoded numbers in mail queries with references to the enum
* fixed a query which still used 'read_flag'
* fixed all new mails being displayed as 'already read'
* removed sd nullpo checks from parse_ functions as that can never happen
* fixed mapserver sending (and charserver saving) junk item fields when there is no item attached to a mail
* fixed wrong mail send packet interpretation saving random memory after message body ('body_len' doesn't include the terminating zero)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11584 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn11582.sql')
| -rw-r--r-- | sql-files/upgrade_svn11582.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn11582.sql b/sql-files/upgrade_svn11582.sql new file mode 100644 index 000000000..484a993db --- /dev/null +++ b/sql-files/upgrade_svn11582.sql @@ -0,0 +1 @@ +ALTER TABLE `mail` CHANGE `read_flag` `status` TINYINT(2) NOT NULL default 0; |