Step 4 – The LMS Database – First Steps

I’m going to create a database table in my imaginary LMS to hold the SCORM variables without worrying too much about what they mean. I’ll simply store the variable name and variable value that the course passes to the API LMSSetValue(varname,varvalue) function.

As I noted before, I’m going to use MySQL for my database since that happens to be what’s readily available to me. But there’s nothing specific to MySQL in what I’m going to be doing.

Here’s a simple table with a minimal set of information.

CREATE TABLE `scormvars` (
  `varName` varchar(255) ,
  `varValue` text
) ;

That was easy!

Be Sociable, Share!
This entry was posted in Run Time Environment. Bookmark the permalink.

One Response to Step 4 – The LMS Database – First Steps

  1. Pingback: Desarrollando un LMS(con soporte de SCORM)

Leave a Reply

Your email address will not be published. Required fields are marked *