+++ /dev/null
-\r
-# SCORM language : some of it is still in svn and should be moved in here.\r
-\r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_browse','Browse',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_credit','Credit',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_credit_mode','Credit Mode:',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_credit_mode_info','This is the answer given to the learning objects when they ask whether the learner is taking this particular package for credit.',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_lesson_mode','Lesson Mode:',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_lesson_mode_info','This is the answer given to the learning objects when they ask whether the learner is just browsing or not.',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_normal','Normal',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_no_credit','No Credit',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_packages','SCORM Packages',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','scorm_sco_is_running','Running',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','package_scorm_1_2_rte_loading','Loading SCORM-1.2 RTE<br />Please be patient ...',NOW(),'');\r
-INSERT INTO `language_text` VALUES ('en', '_module','packages_auto_advance_info','The first time a Learning Object signalizes that you have completed it, the RTE can start the next Learning Object. You might find this convenient if you want to complete all Learning Objects in a package in a sequential manner.',NOW(),'');\r
-INSERT INTO `language_text` VALUES ('en', '_module','packages_show_rte_communication','Show RTE Communication',NOW(),'');\r
-INSERT INTO `language_text` VALUES ('en', '_module','packages_show_rte_communication_info','You can monitor the communication between Learning Objects and the RTE. You may want to switch on this option for a while just for informational purposes.',NOW(),'');\r
-\r
-INSERT INTO `language_text` VALUES ('en', '_module','AT_ERROR_SCORM_ITEM_HREF_MISSING','The file you tried to import is not a scorm-1.2 package. The required href attribute is missing for some resource(s).',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','AT_ERROR_SCORM_ITEM_SCORMTYPE_MISSING','The file you tried to import is not a scorm-1.2 package. The required adlcp:scormtype is missing for some resource(s).',NOW(),''); \r
-INSERT INTO `language_text` VALUES ('en', '_module','AT_FEEDBACK_SCORM_SETTINGS_SAVED','The package settings have been saved.',NOW(),'');\r
-INSERT INTO `language_text` VALUES ('en', '_module','AT_WARNING_SCORM_ITEM_CLUSTER_HAS_OBJECT','Some node(s) has content attached to it. The next version of the SCORM specification does not allow nodes to have attached content.',NOW(),'');\r
-\r
-\r
-# ----------------\r
-# SCORM RTE tables\r
-\r
-CREATE TABLE `packages` (\r
- `package_id` mediumint(8) unsigned NOT NULL auto_increment,\r
- `source` varchar(255) NOT NULL,\r
- `time` datetime NOT NULL,\r
- `course_id` mediumint(8) unsigned NOT NULL,\r
- `ptype` varchar(63) NOT NULL,\r
- PRIMARY KEY (package_id)\r
-) TYPE=MyISAM;\r
-\r
-CREATE TABLE `scorm_1_2_org` (\r
- `org_id` mediumint(8) unsigned NOT NULL auto_increment,\r
- `package_id` mediumint(8) unsigned NOT NULL,\r
-\r
- `title` varchar(255) NOT NULL,\r
- `credit` varchar(15) not null default 'no-credit',\r
- `lesson_mode` varchar(15) not null default 'browse',\r
-\r
- PRIMARY KEY (org_id),\r
- KEY (package_id)\r
-) TYPE=MyISAM;\r
-\r
-CREATE TABLE `scorm_1_2_item` (\r
- `item_id` mediumint(8) unsigned NOT NULL auto_increment,\r
- `org_id` mediumint(8) unsigned NOT NULL,\r
- `idx` varchar(15) NOT NULL,\r
- `title` varchar(255),\r
- `href` varchar(255),\r
- `scormtype` varchar(15),\r
- `prerequisites` varchar(255),\r
- `maxtimeallowed` varchar(255),\r
- `timelimitaction` varchar(255),\r
- `datafromlms` varchar(255),\r
- `masteryscore` mediumint(8),\r
-\r
- PRIMARY KEY (item_id),\r
- KEY (org_id)\r
-)TYPE=MyISAM;\r
-\r
-\r
-CREATE TABLE `cmi` (\r
- `cmi_id` mediumint(8) unsigned NOT NULL auto_increment,\r
- `item_id` mediumint(8) unsigned NOT NULL,\r
- `member_id` mediumint unsigned NOT NULL ,\r
- `lvalue` varchar(63) NOT NULL,\r
- `rvalue` blob,\r
- PRIMARY KEY (cmi_id),\r
- UNIQUE KEY (item_id, member_id,lvalue)\r
-)TYPE=MyISAM;\r