summaryrefslogtreecommitdiff
path: root/sql-files/mail.sql
blob: 8e5beba3e36a9a920088f3bcb54ce344779e1519 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
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;