From: cvs@openprivacy.orgCVS update: sierra/src/sql
Date: Wednesday March 7, 19101 @ 22:29
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-serv15988/src/sql
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.8
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.8&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.8&r2=1.7
-----------------------------------
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.7 sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.8
--- sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql:1.7 Wed Mar 7 12:19:38 2001
+++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Wed Mar 7 22:29:11 2001
@@ -1,6 +1,6 @@
---------------------------------------------------------------------------------
---- Last-Modified: $Date: 2001/03/07 20:19:38 $
---- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.7 2001/03/07 20:19:38 burton Exp $
+--- Last-Modified: $Date: 2001/03/08 06:29:11 $
+--- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.8 2001/03/08 06:29:11 burton Exp $
--- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
---------------------------------------------------------------------------------
--
@@ -9,10 +9,9 @@
--
---------------------------------------------------------------------------------
--- FIXME:
--
-- - how do I create foreign keys with MySQL? I need to join these tables
--- correctly.
+-- correctly.
-- create the database we need for
create database if not exists org_openprivacy_sierra_store_talon_implementations_simple;
@@ -31,6 +30,17 @@
PRIMARY KEY (pk),
UNIQUE INDEX indx_pk(pk) );
+drop table if exists reputations;
+
+create table if not exists reputations
+ ( pk int NOT NULL AUTO_INCREMENT,
+ reference varchar(250),
+ uri varchar(250),
+ PRIMARY KEY(pk),
+ UNIQUE INDEX indx_pk_tbl_reputations_col_pk(pk),
+ INDEX indx_tbl_reputations_col_reference(reference),
+ INDEX indx_tbl_reputations_col_uri(uri) );
+
drop table if exists properties;
--NOTE that column sizes for name and value need to be 250 because mysql can't
@@ -41,26 +51,14 @@
identifier int NOT NULL,
name varchar(250),
value varchar(250),
- type ENUM( 'boolean', 'string' ), --
+ type ENUM( 'boolean', 'string' ),
PRIMARY KEY(pk),
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_tbl_properties_col_name_col_identifier(name, value),
- FOREIGN KEY indx_fk_tbl_properties_col_reputation (indx_pk_tbl_reputations_col_pk) );
-
-drop table if exists reputations;
-
-create table if not exists reputations
- ( pk int NOT NULL AUTO_INCREMENT,
- reference varchar(250),
- uri varchar(250),
- PRIMARY KEY(pk),
- UNIQUE INDEX indx_pk_tbl_reputations_col_pk(pk),
- INDEX indx_tbl_reputations_col_reference(reference),
- INDEX indx_tbl_reputations_col_uri(uri) );
+ INDEX indx_tbl_properties_col_name_col_identifier(name, value) );
show tables;
This archive was generated by hypermail 2b30 : Wed Mar 07 2001 - 22:29:43 PST