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

[Olaf Groeger]

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.