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!