From ad242347a4d41d8db008fc06be2df23aae49d0d8 Mon Sep 17 00:00:00 2001 From: uckelman 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(-) (limited to 'test/BridgeTest.php') 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