CVS update: sierra/src/sql

From: cvs@openprivacy.org
Date: Wed Mar 07 2001 - 01:04:04 PST

  • Next message: cvs@openprivacy.org: "CVS update: openprivacy/htdocs/papers"

    Date: Wednesday March 7, 19101 @ 1:04
    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-serv14717

    Modified Files:
            org_openprivacy_sierra_store_talon_implementations_simple.sql
    Log Message:
    properties table...

    *****************************************************************
    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.3

    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.3&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.3&r2=1.2

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

    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.2 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.2 Tue Mar 6 20:23:21 2001
    +++ sierra/src/sql/org_openprivacy_sierra_store_talon_implementations_simple.sql Wed Mar 7 01:04:04 2001
    @@ -1,6 +1,6 @@
     ---------------------------------------------------------------------------------
    ---- Last-Modified: $Date: 2001/03/07 04:23:21 $
    ---- Version: $Id: org_openprivacy_sierra_store_talon_implementations_simple.sql,v 1.2 2001/03/07 04:23:21 burton Exp $
    +--- 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 $
     --- Author: Kevin A. Burton ( burton@apache.org | burton@openprivacy.org )
     ---------------------------------------------------------------------------------
     --
    @@ -17,11 +17,25 @@
     
     
     -- keep track of property identifier/namespaces.
    -drop table identifiers;
    +drop table if exists identifiers;
     
     -- identifiers table holds all
     create table if not exists identifiers
    - ( pk int NOT NULL AUTO_INCREMENT,
    - PRIMARY KEY (pk) );
    + ( pk int NOT NULL AUTO_INCREMENT,
    + uri varchar(255),
    + PRIMARY KEY (pk) );
    +
    +drop table if exists properties;
    +
    +create table if not exists properties
    + ( pk int NOT NULL AUTO_INCREMENT,
    + reputation int,
    + name varchar(255),
    + value varchar(255),
    + type varchar(255),
    + PRIMARY KEY(pk),
    + KEY(reputation) );
    +
    +show tables;
     
     --select * from identifiers;

    This archive was generated by hypermail 2b30 : Wed Mar 07 2001 - 01:04:05 PST