1 files changed, 14 insertions, 0 deletions
diff --git a/sql-files/mail.sql b/sql-files/mail.sql
new file mode 100644
index 000000000..201142d59
--- /dev/null
+++ b/sql-files/mail.sql
@@ -0,0 +1,14 @@
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ragnarok`;
+USE `ragnarok`;
+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;