[Mrbs-commits] SF.net SVN: mrbs:[1437] mrbs/trunk

[cimorrison]

Revision: 1437
          http://mrbs.svn.sourceforge.net/mrbs/?rev=1437&view=rev
Author:   cimorrison
Date:     2010-09-02 13:08:53 +0000 (Thu, 02 Sep 2010)

Log Message:
-----------
Added a table prefix to PostgreSQL index names to make them unique.  

Modified Paths:
--------------
    mrbs/trunk/tables.pg.pre73.sql
    mrbs/trunk/tables.pg.sql

Modified: mrbs/trunk/tables.pg.pre73.sql
===================================================================
--- mrbs/trunk/tables.pg.pre73.sql      2010-09-02 10:21:40 UTC (rev 1436)
+++ mrbs/trunk/tables.pg.pre73.sql      2010-09-02 13:08:53 UTC (rev 1437)
@@ -55,7 +55,7 @@
   room_admin_email  text,
   custom_html       text
 );
-create index idxSortKey on mrbs_room(sort_key);
+create index mrbs_idxSortKey on mrbs_room(sort_key);
 
 CREATE TABLE mrbs_entry
 (
@@ -77,8 +77,8 @@
   info_user   varchar(80),
   info_text   text
 );
-create index idxStartTime on mrbs_entry(start_time);
-create index idxEndTime on mrbs_entry(end_time);
+create index mrbs_idxStartTime on mrbs_entry(start_time);
+create index mrbs_idxEndTime on mrbs_entry(end_time);
 
 CREATE TABLE mrbs_repeat
 (

Modified: mrbs/trunk/tables.pg.sql
===================================================================
--- mrbs/trunk/tables.pg.sql    2010-09-02 10:21:40 UTC (rev 1436)
+++ mrbs/trunk/tables.pg.sql    2010-09-02 13:08:53 UTC (rev 1437)
@@ -68,7 +68,7 @@
   room_admin_email  text,
   custom_html       text
 );
-create index idxSortKey on mrbs_room(sort_key);
+create index mrbs_idxSortKey on mrbs_room(sort_key);
 
 CREATE TABLE mrbs_entry
 (
@@ -90,8 +90,8 @@
   info_user   varchar(80),
   info_text   text
 );
-create index idxStartTime on mrbs_entry(start_time);
-create index idxEndTime on mrbs_entry(end_time);
+create index mrbs_idxStartTime on mrbs_entry(start_time);
+create index mrbs_idxEndTime on mrbs_entry(end_time);
 
 CREATE TABLE mrbs_repeat
 (


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
Mrbs-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-commits