[cvsnt] Re: Repository auditing with Oracle

[Tony Hoyle]

Paulo Soares wrote:
> The problem is not creating the tables in plsql or with toad. First of
> all, there no docs about the tables itself and second that would
> apparently not work anyway because of the identity that must be returned
> from the row. I'll have to look at the source.

There's a visio file in the source directory plus the various *.sql 
files that get installed for other databases.  There's really only one 
key, and that's the ID that gets created in the session table, which 
links to all the other tables.  The ID columns in the other tables are 
for consistency - you could get away without implementing them (at the 
moment anyway).

The identity columns are always called ID - a habit I picked up years 
ago and don't plan on breaking in the future - so you could use the 
column name reliably in the code to identify them.   The trick is 
getting the correct one after the insert (since on a busy server many 
clients may be creating rows at the same time).

Tony