From: cvs@openprivacy.orgCVS update: sierra/src/sql
Date: Wednesday March 7, 19101 @ 11:38
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-serv15398
Modified Files:
org_openprivacy_sierra_store_talon_implementations_simple.sql
Log Message:
type is now an enum
*****************************************************************
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.4
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.4&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.4&r2=1.3
-----------------------------------
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.3 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.3 Wed Mar 7 01:04:04 2001
+++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Wed Mar 7 11:38:11 2001
@@ -1,6 +1,6 @@
---------------------------------------------------------------------------------
---- Last-Modified: $Date: 2001/03/07 09:04:04 $
---- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.3 2001/03/07 09:04:04 burton Exp $
+--- 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 $
--- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
---------------------------------------------------------------------------------
--
@@ -9,6 +9,11 @@
--
---------------------------------------------------------------------------------
+-- FIXME:
+--
+-- - how do I create foreign keys with MySQL? I need to join these tables
+-- correctly.
+
-- create the database we need for
create database if not exists org_openprivacy_sierra_store_talon_implementations_simple;
@@ -27,14 +32,26 @@
drop table if exists properties;
+--NOTE that column sizes for name and value need to be 250 because mysql can't
+-- handle too large of a index.
create table if not exists properties
( pk int NOT NULL AUTO_INCREMENT,
- reputation int,
- name varchar(255),
- value varchar(255),
- type varchar(255),
+ reputation int NOT NULL,
+ identifier int NOT NULL,
+ name varchar(250),
+ value varchar(250),
+ type ENUM( 'boolean', 'string' ), --
PRIMARY KEY(pk),
- KEY(reputation) );
+ KEY(reputation),
+ KEY(identifier) );
+
+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);
show tables;
This archive was generated by hypermail 2b30 : Wed Mar 07 2001 - 11:38:12 PST