[cvsnt] Re: What are the values in the Audit Log tables

[NELSON Jeff]

Thanks,


-----Original Message-----
From: cvsnt-bounces at cvsnt.org [mailto:cvsnt-bounces at cvsnt.org] On Behalf
Of Olaf Groeger
Sent: Saturday, January 21, 2006 9:27 AM
To: cvsnt at cvsnt.org
Subject: RE: [cvsnt] Re: What are the values in the Audit Log tables

Take a look at the "-x type" parameter of the history command:
http://www.cvsnt.org/manual/html/history.html

Olaf

> Thanks Bo,
> 
> I found the .sql files that provide the table definitions.  What I am
> looking for is the value definitions for the 'Typpe' columns.  What
are
> the possible values and what do they mean.
> 
> I figured out the 'M' is Modify, 'A' is Add, 'R' is Remove or Delete.
> It seems that there are other values such as 'U', 'O', etc.
> 
> 
> -----Original Message-----
> From: cvsnt-bounces at cvsnt.org [mailto:cvsnt-bounces at cvsnt.org] On
Behalf
> Of Bo Berglund
> Sent: Friday, January 20, 2006 2:30 PM
> To: cvsnt at cvsnt.org
> Subject: [cvsnt] Re: What are the values in the Audit Log tables
> 
> On Fri, 20 Jan 2006 17:26:24 -0500, "NELSON Jeff"
> <JNELSON at covansys.com> wrote:
> 
>>Can you point me to a document that shows the definition of the Audit
>>tables and the values that are possible for the fields?  As an
example,
>>what are the valid values for the commitlog.type column and what do
the
>>values mean?
> 
>>From the create_tables_mssql.sql file that is deposited in a CVSNT
> install:
> 
> -- MS SQL specific configuration script
> 
> Create Table SessionLog (Id Integer Identity Primary Key Not Null,
> Command nvarchar(32),
> Date datetime,
> Hostname nvarchar(256),
> Username nvarchar(256),
> SessionId nvarchar(32),
> VirtRepos nvarchar(256),
> PhysRepos nvarchar(256),
> Client nvarchar(64));
> 
> Create Table CommitLog (Id Integer Identity Primary Key Not Null,
> SessionId Integer,
> Directory nvarchar(256),
> Message text,
> Type char(1),
> Filename nvarchar(256),
> Tag nvarchar(64),
> BugId nvarchar(64),
> OldRev nvarchar(64),
> NewRev nvarchar(64),
> Added Integer,
> Removed Integer,
> Diff text);
> 
> Create Index Commit_SessionId On CommitLog(SessionId);
> 
> Create Table HistoryLog (Id Integer Identity Primary Key Not Null,
> SessionId Integer,
> Type char(1),
> WorkDir nvarchar(256),
> Revs nvarchar(64),
> Name nvarchar(256),
> BugId nvarchar(64),
> Message text);
> 
> Create Index History_SessionId on HistoryLog(SessionId);
> 
> Create Table TagLog (Id Integer Identity Primary Key Not Null,
> SessionId Integer,
> Directory nvarchar(256),
> Filename nvarchar(256),
> Tag nvarchar(64),
> Revision nvarchar(64),
> Message text,
> Action nvarchar(32),
> Type char(1));
> 
> Create Index Tag_SessionId on TagLog(SessionId);
> 
> 
> /Bo
> (Bo Berglund, developer in Sweden)
> _______________________________________________
> cvsnt mailing list
> cvsnt at cvsnt.org
> http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt
> Confidentiality Statement:
> 
> This message is intended only for the individual or entity to which it
is
> addressed. It may contain privileged, confidential information which
is
> exempt from disclosure under applicable laws. If you are not the
intended
> recipient, please note that you are strictly prohibited from
disseminating
> or distributing this information (other than to the intended
recipient) or
> copying this information. If you have received this communication in
> error, please notify us immediately by return email.

_______________________________________________
cvsnt mailing list
cvsnt at cvsnt.org
http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt
Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.