Added `pm` table

1 files changed, 20 insertions, 0 deletions

diff --git a/install.sql b/install.sql
index 7ee6b127..8c75095d 100644
--- a/install.sql
+++ b/install.sql
@@ -52,6 +52,26 @@ CREATE TABLE IF NOT EXISTS `bans` (
 -- Dumping data for table `bans`
 --
 
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `pms`
+--
+
+CREATE TABLE IF NOT EXISTS `pms` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `sender` int(11) NOT NULL,
+  `to` int(11) NOT NULL,
+  `message` text NOT NULL,
+  `time` int(11) NOT NULL,
+  `unread` tinyint(1) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `id` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `pms`
+--
 
 -- --------------------------------------------------------