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.8' '-r1.9' -u '/v/ossp/cvs/ossp-pkg/as/as-db/bres/bres-history.sql,v' 2>/dev/null --- bres-history.sql 2003/06/06 13:33:43 1.8 +++ bres-history.sql 2003/06/06 13:40:46 1.9 @@ -426,29 +426,12 @@ -- # 6th another new name "bar3" valid for usertime frame 200 upto n. i. 300 -- whole test data injected -INSERT INTO as_hs_st (st_oid,st_beg) VALUES (10, '2001-01-01'); -INSERT INTO as_hs_ut VALUES (10, '0100-01-01', '0200-01-01', currval('as_hs_st_seq')); -INSERT INTO as_account VALUES (10, 'foo', currval('as_hs_st_seq')); - -INSERT INTO as_hs_st (st_oid,st_beg) VALUES (10, '2002-01-01'); -INSERT INTO as_hs_ut VALUES (10, '0200-01-01', '0300-01-01', currval('as_hs_st_seq')); -INSERT INTO as_account VALUES (10, 'bar', currval('as_hs_st_seq')); - -INSERT INTO as_hs_st (st_oid,st_beg) VALUES (10, '2004-01-01'); -INSERT INTO as_hs_ut VALUES (10, '0100-01-01', 'infinity', currval('as_hs_st_seq')); -INSERT INTO as_account VALUES (10, 'foo', currval('as_hs_st_seq')); - -INSERT INTO as_hs_st (st_oid,st_beg) VALUES (20, '2005-01-01'); -INSERT INTO as_hs_ut VALUES (20, '0100-01-01', 'infinity', currval('as_hs_st_seq')); -INSERT INTO as_account VALUES (20, 'bar1', currval('as_hs_st_seq')); - -INSERT INTO as_hs_st (st_oid,st_beg) VALUES (20, '2006-01-01'); -INSERT INTO as_hs_ut VALUES (20, '0200-01-01', 'infinity', currval('as_hs_st_seq')); -INSERT INTO as_account VALUES (20, 'bar2', currval('as_hs_st_seq')); - -INSERT INTO as_hs_st (st_oid,st_beg) VALUES (20, '2007-01-01'); -INSERT INTO as_hs_ut VALUES (20, '0200-01-01', '0300-01-01', currval('as_hs_st_seq')); -INSERT INTO as_account VALUES (20, 'bar3', currval('as_hs_st_seq')); +INSERT INTO as_account VALUES (10, 'foo', as_hs_make(10, '0100-01-01', '0200-01-01', '2001-01-01')); +INSERT INTO as_account VALUES (10, 'bar', as_hs_make(10, '0200-01-01', '0300-01-01', '2002-01-01')); +INSERT INTO as_account VALUES (10, 'foo', as_hs_make(10, '0100-01-01', 'infinity', '2004-01-01')); +INSERT INTO as_account VALUES (20, 'bar1', as_hs_make(20, '0100-01-01', 'infinity', '2005-01-01')); +INSERT INTO as_account VALUES (20, 'bar2', as_hs_make(20, '0200-01-01', 'infinity', '2006-01-01')); +INSERT INTO as_account VALUES (20, 'bar3', as_hs_make(20, '0200-01-01', '0300-01-01', '2007-01-01')); -- ## -- ## Data Dump