From: cvs@openprivacy.orgCVS update: sierra/src/sql
Date: Wednesday March 14, 19101 @ 16:51
Author: burton
CVSWEB Options: -------------------
Main CVSWeb: http://openprivacy.org/cgi-bin/cvsweb/cvsweb.cgi
View this module: http://openprivacy.org/cgi-bin/cvsweb/cvsweb.cgi/sierra/src/sql
-----------------------------------
Update of /usr/local/cvs/public/sierra/src/sql
In directory giga:/tmp/cvs-serv3967/src/sql
Modified Files:
org_openprivacy_sierra_store_talon_implementations_simple.sql
Log Message:
properties table was not accepting multiple properties for the same reputation because of unique index
*****************************************************************
File: sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql
CVSWEB Options: -------------------
CVSWeb: Annotate this file: http://openprivacy.org/cgi-bin/cvsweb/cvsweb.cgi/sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql?annotate=1.10
CVSWeb: View this file: http://openprivacy.org/cgi-bin/cvsweb/cvsweb.cgi/sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql?rev=1.10&content-type=text/x-cvsweb-markup
CVSWeb: Diff to previous version: http://openprivacy.org/cgi-bin/cvsweb/cvsweb.cgi/sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql.diff?r1=1.10&r2=1.9
-----------------------------------
Index: sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql
diff -u sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.9 sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.10
--- sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.9 Tue Mar 13 15:43:50 2001
+++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Wed Mar 14 16:51:13 2001
@@ -1,6 +1,6 @@
---------------------------------------------------------------------------------
---- Last-Modified: $Date: 2001/03/13 23:43:50 $
---- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.9 2001/03/13 23:43:50 burton Exp $
+--- Last-Modified: $Date: 2001/03/15 00:51:13 $
+--- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.10 2001/03/15 00:51:13 burton Exp $
--- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
---------------------------------------------------------------------------------
--
@@ -59,8 +59,8 @@
KEY(reputation),
KEY(identifier),
UNIQUE INDEX indx_pk_tbl_properties_col_pk(pk),
- UNIQUE INDEX indx_fk_tbl_properties_col_reputation(reputation),
- UNIQUE INDEX indx_fk_tbl_properties_col_identifier(identifier),
+ INDEX indx_fk_tbl_properties_col_reputation(reputation),
+ INDEX indx_fk_tbl_properties_col_identifier(identifier),
INDEX indx_tbl_properties_col_name_col_identifier(name, value) );
show tables;
This archive was generated by hypermail 2b30 : Wed Mar 14 2001 - 16:52:45 PST