G6te22V7

1
2CREATE TABLE IF NOT EXISTS `minecms_messages` (
3  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Auto Incremented ID',
4  `from_id` int(10) NOT NULL COMMENT 'User ID of sender',
5  `from_user` varchar(256) NOT NULL COMMENT 'Clean username of sender',
6  `to_id` int(10) NOT NULL COMMENT 'User ID of recipient',
7  `to_user` varchar(256) NOT NULL COMMENT 'Clean username of recipient',
8  `subject` text NOT NULL COMMENT 'Subject Line',
9  `message` longtext NOT NULL COMMENT 'Message Body',
10  `timestamp` int(16) NOT NULL COMMENT 'Unix Timestamp',
11  `read` int(1) NOT NULL COMMENT '1:read 0:unread',
12  `reply_to` int(10) NOT NULL DEFAULT '0' COMMENT 'ID of message this is a reply to. 0 for no reply',
13  `sent_from` int(1) NOT NULL COMMENT '0: Website, 1: Server',
14  PRIMARY KEY (`id`)
15) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;