ossp-pkg/as/as-db/bres/bres-history.sql 1.4 -> 1.5
--- bres-history.sql 2003/06/05 12:43:21 1.4
+++ bres-history.sql 2003/06/05 12:45:55 1.5
@@ -17,6 +17,7 @@
DROP TABLE st CASCADE;
CREATE TABLE st (
st_oid INTEGER,
+ -- redundant stored oid to avoid additional joins on query
st_hid INTEGER DEFAULT nextval('st_seq') NOT NULL,
-- discrete monton increasing value assigned to system time
st_beg INTEGER
|
|