Index: create_tables_db2.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/create_tables_db2.sql,v
retrieving revision 1.1.2.2.4.3
diff -c -r1.1.2.2.4.3 create_tables_db2.sql
*** create_tables_db2.sql	5 Sep 2008 08:10:48 -0000	1.1.2.2.4.3
--- create_tables_db2.sql	9 Sep 2008 23:53:10 -0000
***************
*** 4,9 ****
--- 4,16 ----
  
  Insert Into %PREFIX%SchemaVersion (Version) Values (4);
  
+ Create Table %PREFIX%AuditReport (ReportName varchar(32), ReportDesc varchar(256), ReportResults Integer, ReportSQL clob);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
  Create Table %PREFIX%SessionLog (Id Integer Generated Always As Identity Primary Key,
  	Command varchar(32),
  	StartTime Timestamp,
Index: create_tables_mssql.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/create_tables_mssql.sql,v
retrieving revision 1.1.2.2.4.3
diff -c -r1.1.2.2.4.3 create_tables_mssql.sql
*** create_tables_mssql.sql	5 Sep 2008 08:10:48 -0000	1.1.2.2.4.3
--- create_tables_mssql.sql	9 Sep 2008 23:53:59 -0000
***************
*** 4,9 ****
--- 4,16 ----
  
  Insert Into %PREFIX%SchemaVersion (Version) Values (4);
  
+ Create Table %PREFIX%AuditReport (ReportName nvarchar(32), ReportDesc nvarchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
  Create Table %PREFIX%SessionLog (Id Integer Identity Primary Key Not Null,
  	Command nvarchar(32),
  	StartTime Datetime,
Index: create_tables_mysql.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/create_tables_mysql.sql,v
retrieving revision 1.1.2.4.4.3
diff -c -r1.1.2.4.4.3 create_tables_mysql.sql
*** create_tables_mysql.sql	5 Sep 2008 08:10:48 -0000	1.1.2.4.4.3
--- create_tables_mysql.sql	9 Sep 2008 23:54:29 -0000
***************
*** 4,9 ****
--- 4,16 ----
  
  Insert Into %PREFIX%SchemaVersion (Version) Values (4);
  
+ Create Table %PREFIX%AuditReport (ReportName varchar(32), ReportName varchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
  Create Table %PREFIX%SessionLog (Id Integer Auto_Increment Primary Key Not Null,
  	Command varchar(32),
  	StartTime datetime,
Index: create_tables_oracle.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/create_tables_oracle.sql,v
retrieving revision 1.3.2.4
diff -c -r1.3.2.4 create_tables_oracle.sql
*** create_tables_oracle.sql	5 Sep 2008 08:10:48 -0000	1.3.2.4
--- create_tables_oracle.sql	9 Sep 2008 23:56:42 -0000
***************
*** 6,11 ****
--- 6,20 ----
  
  Grant Select On %SCHEMA%SchemaVersion To Public;
  
+ Create Table %SCHEMA%AuditReport (ReportName nvarchar2(32), ReportDesc nvarchar2(256), ReportResults Number, ReportSQL nclob) %TABLESPACE%;
+ 
+ Insert Into %SCHEMA%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %SCHEMA%AuditReport order by 1');
+ Insert Into %SCHEMA%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %SCHEMA%CommitLog, %SCHEMA%SessionLog where %SCHEMA%CommitLog.SessionId = %SCHEMA%SessionLog.Id group by Username order by 1 desc');
+ 
+ Grant Select On %SCHEMA%AuditReport To Public;
+ 
  Create Table %SCHEMA%SessionLog (Id Number Not Null,
  	Command nvarchar2(32),
  	StartTime Timestamp,
Index: create_tables_pgsql.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/create_tables_pgsql.sql,v
retrieving revision 1.1.2.2.4.3
diff -c -r1.1.2.2.4.3 create_tables_pgsql.sql
*** create_tables_pgsql.sql	5 Sep 2008 08:10:48 -0000	1.1.2.2.4.3
--- create_tables_pgsql.sql	9 Sep 2008 23:55:32 -0000
***************
*** 4,9 ****
--- 4,16 ----
  
  Insert Into %SCHEMA%SchemaVersion (Version) Values (4);
  
+ Create Table %PREFIX%AuditReport (ReportName varchar(32), ReportName varchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
  Create Table %SCHEMA%SessionLog (Id Serial Primary Key Not Null,
  	Command varchar(32),
  	StartTime Timestamp,
Index: create_tables_sqlite.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/create_tables_sqlite.sql,v
retrieving revision 1.1.2.3.4.5
diff -c -r1.1.2.3.4.5 create_tables_sqlite.sql
*** create_tables_sqlite.sql	5 Sep 2008 08:10:48 -0000	1.1.2.3.4.5
--- create_tables_sqlite.sql	9 Sep 2008 23:56:01 -0000
***************
*** 4,9 ****
--- 4,16 ----
  
  Insert Into %PREFIX%SchemaVersion (Version) Values (4);
  
+ Create Table %PREFIX%AuditReport (ReportName nvarchar(32), ReportName nvarchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
  Create Table %PREFIX%SessionLog (Id Integer Primary Key Not Null,
  	Command nvarchar(32),
  	StartTime datetime,
Index: upgrade_3_db2.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/upgrade_3_db2.sql,v
retrieving revision 1.1.2.2
diff -c -r1.1.2.2 upgrade_3_db2.sql
*** upgrade_3_db2.sql	9 Sep 2008 08:03:35 -0000	1.1.2.2
--- upgrade_3_db2.sql	9 Sep 2008 23:57:20 -0000
***************
*** 6,8 ****
--- 6,15 ----
  Alter Table %PREFIX%CommitLog Add Column Merge2 varchar(64);
  Alter Table %PREFIX%CommitLog Add Column Author varchar(256);
  
+ Create Table %PREFIX%AuditReport (ReportName varchar(32), ReportDesc varchar(256), ReportResults Integer, ReportSQL clob);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
Index: upgrade_3_mssql.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/upgrade_3_mssql.sql,v
retrieving revision 1.1.2.3
diff -c -r1.1.2.3 upgrade_3_mssql.sql
*** upgrade_3_mssql.sql	9 Sep 2008 08:03:35 -0000	1.1.2.3
--- upgrade_3_mssql.sql	9 Sep 2008 23:57:55 -0000
***************
*** 5,7 ****
--- 5,15 ----
  Alter Table %PREFIX%CommitLog Add Column Merge1 nvarchar(64);
  Alter Table %PREFIX%CommitLog Add Column Merge2 nvarchar(64);
  Alter Table %PREFIX%CommitLog Add Column Author nvarchar(256);
+ 
+ Create Table %PREFIX%AuditReport (ReportName nvarchar(32), ReportDesc nvarchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
Index: upgrade_3_mysql.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/upgrade_3_mysql.sql,v
retrieving revision 1.1.2.3
diff -c -r1.1.2.3 upgrade_3_mysql.sql
*** upgrade_3_mysql.sql	9 Sep 2008 08:03:35 -0000	1.1.2.3
--- upgrade_3_mysql.sql	9 Sep 2008 23:58:23 -0000
***************
*** 6,8 ****
--- 6,15 ----
  Alter Table %PREFIX%CommitLog Add Column Merge2 varchar(64);
  Alter Table %PREFIX%CommitLog Add Column Author varchar(256);
  
+ Create Table %PREFIX%AuditReport (ReportName varchar(32), ReportName varchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
Index: upgrade_3_oracle.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/upgrade_3_oracle.sql,v
retrieving revision 1.1.2.3
diff -c -r1.1.2.3 upgrade_3_oracle.sql
*** upgrade_3_oracle.sql	9 Sep 2008 08:03:35 -0000	1.1.2.3
--- upgrade_3_oracle.sql	9 Sep 2008 23:58:52 -0000
***************
*** 6,8 ****
--- 6,17 ----
  Alter Table %SCHEMA%CommitLog Add Column Merge2 varchar(64);
  Alter Table %SCHEMA%CommitLog Add Column Author nvarchar2(256);
  
+ Create Table %SCHEMA%AuditReport (ReportName nvarchar2(32), ReportDesc nvarchar2(256), ReportResults Number, ReportSQL nclob) %TABLESPACE%;
+ 
+ Insert Into %SCHEMA%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %SCHEMA%AuditReport order by 1');
+ Insert Into %SCHEMA%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %SCHEMA%CommitLog, %SCHEMA%SessionLog where %SCHEMA%CommitLog.SessionId = %SCHEMA%SessionLog.Id group by Username order by 1 desc');
+ 
+ Grant Select On %SCHEMA%AuditReport To Public;
+ 
Index: upgrade_3_pgsql.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/upgrade_3_pgsql.sql,v
retrieving revision 1.1.2.3
diff -c -r1.1.2.3 upgrade_3_pgsql.sql
*** upgrade_3_pgsql.sql	9 Sep 2008 08:03:35 -0000	1.1.2.3
--- upgrade_3_pgsql.sql	9 Sep 2008 23:59:17 -0000
***************
*** 6,8 ****
--- 6,15 ----
  Alter Table %PREFIX%CommitLog Add Column Merge2 varchar(64);
  Alter Table %PREFIX%CommitLog Add Column Author varchar(256);
  
+ Create Table %PREFIX%AuditReport (ReportName varchar(32), ReportName varchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+ 
Index: upgrade_3_sqlite.sql
===================================================================
RCS file: /cvs/cvsnt/triggers/sql/upgrade_3_sqlite.sql,v
retrieving revision 1.1.2.3
diff -c -r1.1.2.3 upgrade_3_sqlite.sql
*** upgrade_3_sqlite.sql	9 Sep 2008 08:03:35 -0000	1.1.2.3
--- upgrade_3_sqlite.sql	9 Sep 2008 23:59:40 -0000
***************
*** 6,10 ****
--- 6,17 ----
  Alter Table %PREFIX%CommitLog Add Column Merge2 nvarchar(64);
  Alter Table %PREFIX%CommitLog Add Column Author nvarchar(256);
  
+ Create Table %PREFIX%AuditReport (ReportName nvarchar(32), ReportName nvarchar(256), ReportResults Integer, ReportSQL text);
+ 
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('Reports','Audit Reports',2,'select ReportName,ReportDesc from %PREFIX%AuditReport order by 1');
+ Insert Into %PREFIX%AuditReport (ReportName,ReportDesc,ReportResults,ReportSQL) 
+       Values ('UsersLines','Users by lines of code changed',2,'select sum(added)+sum(removed),Username from %PREFIX%CommitLog, %PREFIX%SessionLog where %PREFIX%CommitLog.SessionId = %PREFIX%SessionLog.Id group by Username order by 1 desc');
+