jdwdiVwT

1DROP TABLE IF EXISTS `cms_pm_report`;
2CREATE TABLE `cms_pm_report` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `reported_pm` int(11) DEFAULT NULL,
5  `reported_by` int(11) DEFAULT NULL,
6  `reason` varchar(255) DEFAULT NULL,
7  `handled_by` int(11) DEFAULT NULL,
8  `solved` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '0',
9  PRIMARY KEY (`id`)
10) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
11
12ALTER TABLE permissions_ranks ADD pm_reports enum('1','0') collate utf8_unicode_ci NOT NULL default '0';
13ALTER TABLE permissions_users ADD pm_reports enum('1','0') collate utf8_unicode_ci NOT NULL default '0';
14
15
16SET FOREIGN_KEY_CHECKS=0;
17-- ----------------------------
18-- Table structure for `cms_pm`
19-- ----------------------------
20DROP TABLE IF EXISTS `cms_pm`;
21CREATE TABLE `cms_pm` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `toid` int(11) DEFAULT NULL,
24  `fromid` int(11) DEFAULT NULL,
25  `timestamp_sent` int(11) DEFAULT NULL,
26  `timestamp_received` int(11) DEFAULT NULL,
27  `subject` char(100) DEFAULT NULL,
28  `message` text,
29  `folder` char(10) DEFAULT NULL,
30  `read` enum('1','0') DEFAULT '0',
31  PRIMARY KEY (`id`)
32) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;
33
34-- ----------------------------
35-- Records of cms_pm
36-- ----------------------------