CVS update: sierra/src/sql

From: cvs@openprivacy.org
Date: Tue Mar 13 2001 - 15:43:50 PST

  • Next message: cvs@openprivacy.org: "CVS update: sierra/docs"

    Date: Tuesday March 13, 19101 @ 15:43
    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-serv371/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.9

    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.9&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.9&r2=1.8

    -----------------------------------

    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.8 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.8 Wed Mar 7 22:29:11 2001
    +++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Tue Mar 13 15:43:50 2001
    @@ -1,6 +1,6 @@
     ---------------------------------------------------------------------------------
    ---- 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 $
    +--- 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 $
     --- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
     ---------------------------------------------------------------------------------
     --
    @@ -14,6 +14,8 @@
     -- correctly.
     
     -- create the database we need for
    +
    +-- FIXME: should we use a shorter db name?
     create database if not exists org_openprivacy_sierra_store_talon_implementations_simple;
     
     -- make sure we select the correct db.
    @@ -23,12 +25,13 @@
     -- keep track of property identifier/namespaces.
     drop table if exists identifiers;
     
    --- identifiers table holds all
    +-- identifiers table holds all payload identifiers.
     create table if not exists identifiers
         ( pk int NOT NULL AUTO_INCREMENT,
           uri varchar(255),
           PRIMARY KEY (pk),
    - UNIQUE INDEX indx_pk(pk) );
    + UNIQUE INDEX indx_pk(pk),
    + UNIQUE INDEX indx_tbl_identifiers_col_uri(uri) );
     
     drop table if exists reputations;
     
    @@ -39,7 +42,7 @@
           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) );
    + UNIQUE INDEX indx_tbl_reputations_col_uri(uri) );
     
     drop table if exists properties;
     

    This archive was generated by hypermail 2b30 : Tue Mar 13 2001 - 15:45:52 PST