From: cvs@openprivacy.orgCVS update: sierra/src/sql
Date: Wednesday March 7, 19101 @ 11:46
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-serv15425
Modified Files:
org_openprivacy_sierra_store_talon_implementations_simple.sql
Log Message:
...
*****************************************************************
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.5
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.5&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.5&r2=1.4
-----------------------------------
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.4 sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.5
--- sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.4 Wed Mar 7 11:38:11 2001
+++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Wed Mar 7 11:46:34 2001
@@ -1,6 +1,6 @@
---------------------------------------------------------------------------------
---- Last-Modified: $Date: 2001/03/07 19:38:11 $
---- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.4 2001/03/07 19:38:11 burton Exp $
+--- Last-Modified: $Date: 2001/03/07 19:46:34 $
+--- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.5 2001/03/07 19:46:34 burton Exp $
--- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
---------------------------------------------------------------------------------
--
@@ -43,15 +43,17 @@
type ENUM( 'boolean', 'string' ), --
PRIMARY KEY(pk),
KEY(reputation),
- KEY(identifier) );
+ KEY(identifier),
+ INDEX indx_properties_name_identifier(name, value) );
drop table if exists reputations;
create table if not exists reputations
( pk int NOT NULL AUTO_INCREMENT,
- PRIMARY KEY(pk) );
-
-create index properties_name_identifier on properties (name, value);
+ reference varchar(250),
+ uri varchar(250),
+ PRIMARY KEY(pk),
+ INDEX indx_reputations_reference(reference) );
show tables;
This archive was generated by hypermail 2b30 : Wed Mar 07 2001 - 11:46:35 PST