Files
mod-azerothshard/data/sql/db-characters/mail_external.sql
2021-12-07 18:53:30 +07:00

13 lines
458 B
SQL

CREATE TABLE IF NOT EXISTS `mail_external` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`receiver` int(10) unsigned NOT NULL,
`subject` varchar(200) DEFAULT 'Support Message',
`message` varchar(400) DEFAULT NULL,
`money` int(10) unsigned NOT NULL DEFAULT '0',
`item` int(10) unsigned NOT NULL DEFAULT '0',
`item_count` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=61578 DEFAULT CHARSET=utf8;