/[rserv]/misc/master.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /misc/master.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by dpavlin, Fri Aug 15 23:01:36 2003 UTC revision 1.3 by dpavlin, Sat Aug 16 09:41:34 2003 UTC
# Line 43  create table _RSERV_LOG_ Line 43  create table _RSERV_LOG_
43                  on delete cascade on update cascade,                  on delete cascade on update cascade,
44          logid   int4 not null,  -- xid of last update xaction          logid   int4 not null,  -- xid of last update xaction
45          logtime timestamp not null, -- last update xaction start time          logtime timestamp not null, -- last update xaction start time
46          deleted smallint,       -- deleted or inserted/updated          delete  smallint,       -- deleted
47          update  smallint,       -- deleted or inserted/updated          update  smallint,       -- updated
48          delete  smallint,       -- deleted or inserted/updated          insert  smallint,       -- inserted
49          key     text,           -- primary key in table          key     text,           -- primary key in table
50          constraint only_one check (insert+update+delete=1)          constraint only_one check (insert+update+delete=1)
51  );  );
52    
53  -- This is to speedup lookup deleted, updated and inserted tuples  -- This is to speedup lookup deleted, updated and inserted tuples
54  create index _RSERV_LOG_INDX_DLT_ID_ on _RSERV_LOG_ (deleted, logid)  create index _RSERV_LOG_INDX_DLT_ID_ on _RSERV_LOG_ (delete, logid)
55          where delete = 1;          where delete = 1;
56    
57  create index _RSERV_LOG_INDX_UPD_ID_ on _RSERV_LOG_ (deleted, logid)  create index _RSERV_LOG_INDX_UPD_ID_ on _RSERV_LOG_ (update, logid)
58          where update = 1;          where update = 1;
59    
60  create index _RSERV_LOG_INDX_INS_ID_ on _RSERV_LOG_ (deleted, logid)  create index _RSERV_LOG_INDX_INS_ID_ on _RSERV_LOG_ (insert, logid)
61          where insert = 1;          where insert = 1;
62    
63  -- This is to speedup cleanup  -- This is to speedup cleanup
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.26