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