From ad242347a4d41d8db008fc06be2df23aae49d0d8 Mon Sep 17 00:00:00 2001
From: uckelman <uckelman@nomic.net>
Date: Tue, 27 Apr 2010 20:54:58 +0000
Subject: Restructure posts table.

git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6768 67b53d14-2c14-4ace-a08f-0dab2b34000c
---
 test/BridgeTest.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/test/BridgeTest.php b/test/BridgeTest.php
index e181f1c..0473042 100644
--- a/test/BridgeTest.php
+++ b/test/BridgeTest.php
@@ -21,8 +21,9 @@ class BridgeTest extends PHPUnit_Framework_TestCase {
       'post_id MEDIUMINT UNSIGNED, ' .
       'message_id VARCHAR(255) NOT NULL, ' .
       'in_reply_to VARCHAR(255), ' .
-      'UNIQUE KEY (post_id), ' .
-      'UNIQUE KEY (message_id))'
+      'when TIMESTAMP, ' .
+      'PRIMARY KEY (message_id)), ' .
+      'INDEX (post_id)' .
     );
 
     $this->db->exec(
-- 
cgit v1.2.3