Add alternate index as a comment to support stupid cisco SIP softswitches

diff --git a/src/billing/cisco_h323_db_schema-postgres.sql b/src/billing/cisco_h323_db_schema-postgres.sql
index 28f29f0..ded39e7 100644 (file)
--- a/src/billing/cisco_h323_db_schema-postgres.sql
+++ b/src/billing/cisco_h323_db_schema-postgres.sql
@@ -82,6 +82,13 @@ CREATE TABLE StopVoIP (
        H323ConfID              VARCHAR(35) NOT NULL
 );
 create UNIQUE index stopvoipcombo on stopvoip (h323SetupTime, nasipaddress, h323ConfID);
+/*
+ * Some Cisco CSPS do not have complete VSA details. If you have one of these you will want
+ * to use the following index, as the one above will drop records.
+ * 
+ *  create UNIQUE index stopvoipcombo on stopvoip (h323DisconnectTime, nasipaddress, CalledStationId);
+ *
+ */
 
 
 CREATE TABLE StopTelephony (