- Added the new mail system. Requires optimization and tests.

- Updated the maildb sql structure.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11548 54d463be-8e91-2dee-dedb-b68131a5f0ec

1 files changed, 22 insertions, 11 deletions

diff --git a/sql-files/mail.sql b/sql-files/mail.sql
index 62cc9d65d..b5fd22ead 100644
--- a/sql-files/mail.sql
+++ b/sql-files/mail.sql
@@ -1,12 +1,23 @@
+DROP TABLE IF EXISTS `mail`;
 CREATE TABLE `mail` (
-  `message_id` int(11) NOT NULL auto_increment,
-  `to_account_id` int(11) NOT NULL default '0',
-  `to_char_name` varchar(24) NOT NULL default '',
-  `from_account_id` int(11) NOT NULL default '0',
-  `from_char_name` varchar(24) NOT NULL default '',
-  `message` varchar(80) NOT NULL default '',
-  `read_flag` tinyint(1) NOT NULL default '0',
-  `priority` tinyint(1) NOT NULL default '0',
-  `check_flag` tinyint(1) NOT NULL default '0',
-  PRIMARY KEY  (`message_id`)
-) TYPE=MyISAM;
+  `id` bigint(20) unsigned NOT NULL auto_increment,
+  `send_name` tinytext NOT NULL DEFAULT '',
+  `send_id` int(11) unsigned NOT NULL default '0',
+  `dest_name` tinytext NOT NULL DEFAULT '',
+  `dest_id` int(11) unsigned NOT NULL default '0',
+  `title` tinytext NOT NULL DEFAULT '',
+  `message` text NOT NULL DEFAULT '',
+  `time` int(11) unsigned NOT NULL default '0',
+  `read_flag` tinyint(1) 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',
+  `refine` tinyint(3) unsigned NOT NULL default '0',
+  `attribute` tinyint(4) unsigned NOT NULL default '0',
+  `identify` smallint(6) NOT NULL default '0',
+  `card0` smallint(11) NOT NULL default '0',
+  `card1` smallint(11) NOT NULL default '0',
+  `card2` smallint(11) NOT NULL default '0',
+  `card3` smallint(11) NOT NULL default '0',
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM;