Revision: 1439
http://mrbs.svn.sourceforge.net/mrbs/?rev=1439&view=rev
Author: cimorrison
Date: 2010-09-02 13:59:58 +0000 (Thu, 02 Sep 2010)
Log Message:
-----------
- Added a table prefix to PostgreSQL index name to make it unique.
- Fixed a bug which would have resulted in a failure to upgrade if using
PostgreSQL and other than the default table prefix
Modified Paths:
--------------
mrbs/trunk/web/upgrade/8/pgsql.sql
Modified: mrbs/trunk/web/upgrade/8/pgsql.sql
===================================================================
--- mrbs/trunk/web/upgrade/8/pgsql.sql 2010-09-02 13:35:10 UTC (rev 1438)
+++ mrbs/trunk/web/upgrade/8/pgsql.sql 2010-09-02 13:59:58 UTC (rev 1439)
@@ -3,5 +3,5 @@
ALTER TABLE %DB_TBL_PREFIX%room
ADD COLUMN sort_key varchar(25) DEFAULT '' NOT NULL;
-create index idxSortKey on mrbs_room(sort_key);
+create index %DB_TBL_PREFIX%idxSortKey on %DB_TBL_PREFIX%room(sort_key);
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
