portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r330599 - /portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml
Date Thu, 03 Nov 2005 18:18:57 GMT
Author: taylor
Date: Thu Nov  3 10:18:31 2005
New Revision: 330599

URL: http://svn.apache.org/viewcvs?rev=330599&view=rev
Log:
http://issues.apache.org/jira/browse/JS2-362
tables for storing statistics by page, portlet, user

Modified:
    portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml

Modified: portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml?rev=330599&r1=330598&r2=330599&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml Thu Nov  3 10:18:31 2005
@@ -93,5 +93,32 @@
         <column name="MEDIATYPE_ID" required="true" type="INTEGER"/>
         <column name="MIMETYPE_ID" required="true" type="INTEGER"/>
     </table>
-    
+
+	<table name='PORTLET_STATISTICS'>
+		<column name='IPADDRESS' type='VARCHAR' size="80"/>
+		<column name='USER_NAME' type='VARCHAR' size="80"/>
+		<column name='TIME_STAMP' type='TIMESTAMP'/>
+		<column name='PAGE' type='VARCHAR' size="80"/>
+		<column name='PORTLET' type='VARCHAR' size="80"/>
+		<column name='STATUS' type='INTEGER'/>
+		<column name='ELAPSED_TIME' type='INTEGER'/>
+	</table>    
+
+	<table name='PAGE_STATISTICS'>
+		<column name='IPADDRESS' type='VARCHAR' size="80"/>
+		<column name='USER_NAME' type='VARCHAR' size="80"/>
+		<column name='TIME_STAMP' type='TIMESTAMP'/>
+		<column name='PAGE' type='VARCHAR' size="80"/>
+		<column name='STATUS' type='INTEGER'/>
+		<column name='ELAPSED_TIME' type='INTEGER'/>
+	</table>    
+
+	<table name='USER_STATISTICS'>
+		<column name='IPADDRESS' type='VARCHAR' size="80"/>
+		<column name='USER_NAME' type='VARCHAR' size="80"/>
+		<column name='TIME_STAMP' type='TIMESTAMP'/>
+		<column name='STATUS' type='INTEGER'/>
+		<column name='ELAPSED_TIME' type='INTEGER'/>
+	</table>    
+	
 </database>



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Mime
View raw message