Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Created by: Cory Wright on 05-05-2006 07:55:40 PM Janine wrote in and asked the following:
Where would I find the database schema for the database created by the importlogs script?
--- I thought others might also want to see the answer when it comes up, so I'm posting it here...
Thanks, Cory
Subject: RE: Database Schema question from script Replied by: Michael Bochynski on 08-05-2006 03:58:09 PM Hi,
The activity importer script creates only one table - activity_log. The column specification is as follows (MySQL): [code:1:e286fbceb9] +---------------+--------------+------+-----+---------------------+-------+ Field Type Null Key Default Extra +---------------+--------------+------+-----+---------------------+-------+ session_id varchar(100) activity_time datetime 0000-00-00 00:00:00 element varchar(100) YES NULL category varchar(50) YES NULL action varchar(50) YES NULL value varchar(100) YES NULL +---------------+--------------+------+-----+---------------------+-------+ [/code:1:e286fbceb9]
Note that I have also entered this issue into our internal bug tracking system to add this description to our documentation.
Thanks for pointing it out!
Regards, Michael
Subject: RE: Database Schema question from script Replied by: null on 08-05-2006 09:25:18 PM I had noted the structure of the activity_log table for SQL Server in the following thread:
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: