Index: ossp-pkg/as/as-db/bres/bres-history.sql RCS File: /v/ossp/cvs/ossp-pkg/as/as-db/bres/bres-history.sql,v rcsdiff -q -kk '-r1.3' '-r1.4' -u '/v/ossp/cvs/ossp-pkg/as/as-db/bres/bres-history.sql,v' 2>/dev/null --- bres-history.sql 2003/06/05 12:38:37 1.3 +++ bres-history.sql 2003/06/05 12:43:21 1.4 @@ -25,17 +25,17 @@ DROP TABLE ut CASCADE; CREATE TABLE ut ( - ut_oid INTEGER, -- - ut_beg INTEGER, -- - ut_end INTEGER, -- - ut_hid INTEGER -- + ut_oid INTEGER, -- oid + ut_beg INTEGER, -- user time begin (inclusive) + ut_end INTEGER, -- user time end (exclusive) + ut_hid INTEGER -- user time history id (system time when this entry was made) ); DROP TABLE ut_no CASCADE; CREATE TABLE ut_no ( ut_oid INTEGER, -- oid - ut_beg INTEGER, -- user time begin - ut_end INTEGER, -- user time end + ut_beg INTEGER, -- user time begin (inclusive) + ut_end INTEGER, -- user time end (exclusive) ut_hid INTEGER, -- user time history id (system time when this entry was made) ut_hid_max INTEGER -- user time history id (system time until which this entry is valid) );