From: cvs@openprivacy.orgCVS update: sierra/src/sql
Date: Wednesday March 7, 19101 @ 12:14
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-serv15466
Modified Files:
org_openprivacy_sierra_store_talon_implementations_simple.sql
Log Message:
indexes correctly setup
*****************************************************************
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.6
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.6&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.6&r2=1.5
-----------------------------------
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.5 sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.6
--- sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.5 Wed Mar 7 11:46:34 2001
+++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Wed Mar 7 12:14:52 2001
@@ -1,6 +1,6 @@
---------------------------------------------------------------------------------
---- 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 $
+--- Last-Modified: $Date: 2001/03/07 20:14:52 $
+--- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.6 2001/03/07 20:14:52 burton Exp $
--- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
---------------------------------------------------------------------------------
--
@@ -28,7 +28,8 @@
create table if not exists identifiers
( pk int NOT NULL AUTO_INCREMENT,
uri varchar(255),
- PRIMARY KEY (pk) );
+ PRIMARY KEY (pk),
+ UNIQUE INDEX indx_pk(pk) );
drop table if exists properties;
@@ -42,9 +43,13 @@
value varchar(250),
type ENUM( 'boolean', 'string' ), --
PRIMARY KEY(pk),
+-- FOREIGN KEY
KEY(reputation),
KEY(identifier),
- INDEX indx_properties_name_identifier(name, value) );
+ 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_tbl_properties_col_name_col_identifier(name, value) );
drop table if exists reputations;
@@ -53,7 +58,9 @@
reference varchar(250),
uri varchar(250),
PRIMARY KEY(pk),
- INDEX indx_reputations_reference(reference) );
+ UNIQUE INDEX indx_pk_tbl_reputations_col_pk(pk),
+ INDEX indx_tbl_reputations_col_reference(reference),
+ INDEX indx_tbl_reputations_col_uri(uri) );
show tables;
This archive was generated by hypermail 2b30 : Wed Mar 07 2001 - 12:14:53 PST