cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
25
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

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:

http://www.audiumcentral.com/supportcenter/viewtopic.php?t=1077

Regards,
Geoff
Getting Started

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:

Quick Links