diff options
| author | wizputer <wizputer@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2004-11-27 19:32:30 +0000 |
|---|---|---|
| committer | wizputer <wizputer@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2004-11-27 19:32:30 +0000 |
| commit | 486b4f2a12b41507b67a1a93ae5871b3be447914 (patch) | |
| tree | 8196d22d0fce973ac6e53b24735776ba9dcaf77f /sql-files/mail.sql | |
| parent | ecb15e6101bc1912bb2520151c45ed69af80feb8 (diff) | |
| parent | f0da8da932031212f34aa97eff882f72cb69cc2a (diff) | |
| download | hercules-486b4f2a12b41507b67a1a93ae5871b3be447914.tar.gz hercules-486b4f2a12b41507b67a1a93ae5871b3be447914.tar.bz2 hercules-486b4f2a12b41507b67a1a93ae5871b3be447914.tar.xz hercules-486b4f2a12b41507b67a1a93ae5871b3be447914.zip | |
correct directory structure
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@387 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/mail.sql')
| -rw-r--r-- | sql-files/mail.sql | 14 |
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; |