You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by at...@apache.org on 2007/07/08 22:06:43 UTC
svn commit: r554425 -
/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
Author: ate
Date: Sun Jul 8 13:06:43 2007
New Revision: 554425
URL: http://svn.apache.org/viewvc?view=rev&rev=554425
Log:
Derby DDL for JS2-724: Audit logs for administrative actions
Modified:
portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
Modified: portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
URL: http://svn.apache.org/viewvc/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql?view=diff&rev=554425&r1=554424&r2=554425
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql Sun Jul 8 13:06:43 2007
@@ -136,4 +136,32 @@
TIME_STAMP TIMESTAMP,
STATUS INTEGER,
ELAPSED_TIME BIGINT);
+
+-----------------------------------------------------------------------------
+-- ADMIN_ACTIVITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE ADMIN_ACTIVITY
+(
+ ACTIVITY VARCHAR(40),
+ CATEGORY VARCHAR(40),
+ ADMIN VARCHAR(80),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ IPADDRESS VARCHAR(80),
+ ATTR_NAME VARCHAR(40),
+ ATTR_VALUE VARCHAR(80),
+ DESCRIPTION VARCHAR(128));
+-----------------------------------------------------------------------------
+-- USER_ACTIVITY
+-----------------------------------------------------------------------------
+
+CREATE TABLE USER_ACTIVITY
+(
+ ACTIVITY VARCHAR(40),
+ CATEGORY VARCHAR(40),
+ USER_NAME VARCHAR(80),
+ TIME_STAMP TIMESTAMP,
+ IPADDRESS VARCHAR(80),
+ DESCRIPTION VARCHAR(128));
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org