[PlaneShift-svn] SF.net SVN: planeshift:[3562] trunk/src/server/database/mysql

[<Kha...@us...>]

Revision: 3562
          http://planeshift.svn.sourceforge.net/planeshift/?rev=3562&view=rev
Author:   KhakiLord
Date:     2009-04-26 13:06:28 +0000 (Sun, 26 Apr 2009)

Log Message:
-----------
Removed duplicates from sql.

Modified Paths:
--------------
    trunk/src/server/database/mysql/commonstrings.sql
    trunk/src/server/database/mysql/create_indexes.sql

Modified: trunk/src/server/database/mysql/commonstrings.sql
===================================================================
--- trunk/src/server/database/mysql/commonstrings.sql	2009-04-26 11:19:05 UTC (rev 3561)
+++ trunk/src/server/database/mysql/commonstrings.sql	2009-04-26 13:06:28 UTC (rev 3562)
@@ -163,7 +163,8 @@
 INSERT INTO common_strings VALUES("141","money#tria_01a_01");
 INSERT INTO common_strings VALUES("142","money#octa_01a_01");
 INSERT INTO common_strings VALUES("143","money#hexa_01a_01");
-INSERT INTO common_strings VALUES("144","money#circle_01a_01");
+# Duplicate
+# INSERT INTO common_strings VALUES("144","money#circle_01a_01");
 INSERT INTO common_strings VALUES("145","money#tria_01a_pile_01_01");
 INSERT INTO common_strings VALUES("146","money#octa_01a_pile_01_01");
 INSERT INTO common_strings VALUES("147","money#hexa_01a_pile_01_01");

Modified: trunk/src/server/database/mysql/create_indexes.sql
===================================================================
--- trunk/src/server/database/mysql/create_indexes.sql	2009-04-26 11:19:05 UTC (rev 3561)
+++ trunk/src/server/database/mysql/create_indexes.sql	2009-04-26 13:06:28 UTC (rev 3562)
@@ -1,7 +1,6 @@
 create unique index indx_sector_name on sectors (name);
 create index indx_AL_sectorname on action_locations (sectorname);
 create index indx_AL_master_id on action_locations (master_id);
-create unique index indx_quests_name on quests (name);
 create index indx_char_name on characters (name);
 create index indx_char_lastname on characters (lastname);
 create index indx_item_instance_flags on item_instances (flags);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.