blob: 78e6dbdde225403d6a0f29609ca9ec1067bf6f6d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
DROP TABLE IF EXISTS `mail`;
CREATE TABLE `mail` (
`id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Identifier',
`messageType` int(11) unsigned NOT NULL default '0',
`sender` bigint(20) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
`receiver` bigint(20) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
`subject` longtext,
`itemPageId` int(11) unsigned NOT NULL default '0',
`item_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Mail Item Global Unique Identifier',
`item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
`time` int(11) unsigned NOT NULL default '0',
`money` int(11) unsigned NOT NULL default '0',
`cod` bigint(11) unsigned NOT NULL default '0',
`checked` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_receiver` (`receiver`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
|
