summaryrefslogtreecommitdiff
path: root/install.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install.sql')
-rw-r--r--install.sql20
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`
+--
-- --------------------------------------------------------