db_main.sql 134 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815
  1. -- MySQL dump 10.9
  2. --
  3. -- Host: localhost Database: chamilo_main
  4. -- ------------------------------------------------------
  5. -- Server version 4.1.14
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  14. --
  15. -- Table structure for table user
  16. --
  17. DROP TABLE IF EXISTS user;
  18. CREATE TABLE user (
  19. user_id int unsigned NOT NULL auto_increment,
  20. lastname varchar(60) default NULL,
  21. firstname varchar(60) default NULL,
  22. username varchar(40) NOT NULL default '',
  23. password varchar(50) NOT NULL default '',
  24. auth_source varchar(50) default 'platform',
  25. email varchar(100) default NULL,
  26. status tinyint NOT NULL default '5',
  27. official_code varchar(40) default NULL,
  28. phone varchar(30) default NULL,
  29. picture_uri varchar(250) default NULL,
  30. creator_id int unsigned default NULL,
  31. competences text,
  32. diplomas text,
  33. openarea text,
  34. teach text,
  35. productions varchar(250) default NULL,
  36. chatcall_user_id int unsigned NOT NULL default '0',
  37. chatcall_date datetime NOT NULL default '0000-00-00 00:00:00',
  38. chatcall_text varchar(50) NOT NULL default '',
  39. language varchar(40) default NULL,
  40. registration_date datetime NOT NULL default '0000-00-00 00:00:00',
  41. expiration_date datetime NOT NULL default '0000-00-00 00:00:00',
  42. active tinyint unsigned NOT NULL default 1,
  43. openid varchar(255) DEFAULT NULL,
  44. theme varchar(255) DEFAULT NULL,
  45. hr_dept_id smallint unsigned NOT NULL default 0,
  46. PRIMARY KEY (user_id),
  47. UNIQUE KEY username (username)
  48. );
  49. ALTER TABLE user ADD INDEX (status);
  50. --
  51. -- Dumping data for table user
  52. --
  53. /*!40000 ALTER TABLE user DISABLE KEYS */;
  54. LOCK TABLES user WRITE;
  55. INSERT INTO user (lastname, firstname, username, password, auth_source, email, status, official_code,phone, creator_id, registration_date, expiration_date,active,openid,language) VALUES ('{ADMINLASTNAME}','{ADMINFIRSTNAME}','{ADMINLOGIN}','{ADMINPASSWORD}','{PLATFORM_AUTH_SOURCE}','{ADMINEMAIL}',1,'ADMIN','{ADMINPHONE}',1,NOW(),'0000-00-00 00:00:00','1',NULL,'{ADMINLANGUAGE}');
  56. -- Insert anonymous user
  57. INSERT INTO user (lastname, firstname, username, password, auth_source, email, status, official_code, creator_id, registration_date, expiration_date,active,openid,language) VALUES ('Anonymous', 'Joe', '', '', 'platform', 'anonymous@localhost', 6, 'anonymous', 1, NOW(), '0000-00-00 00:00:00', 1,NULL,'{ADMINLANGUAGE}');
  58. UNLOCK TABLES;
  59. /*!40000 ALTER TABLE user ENABLE KEYS */;
  60. --
  61. -- Table structure for table admin
  62. --
  63. DROP TABLE IF EXISTS admin;
  64. CREATE TABLE admin (
  65. user_id int unsigned NOT NULL default '0',
  66. UNIQUE KEY user_id (user_id)
  67. );
  68. --
  69. -- Dumping data for table admin
  70. --
  71. /*!40000 ALTER TABLE admin DISABLE KEYS */;
  72. LOCK TABLES admin WRITE;
  73. INSERT INTO admin VALUES (1);
  74. UNLOCK TABLES;
  75. /*!40000 ALTER TABLE admin ENABLE KEYS */;
  76. --
  77. -- Table structure for table class
  78. --
  79. DROP TABLE IF EXISTS class;
  80. CREATE TABLE class (
  81. id mediumint unsigned NOT NULL auto_increment,
  82. code varchar(40) default '',
  83. name text NOT NULL,
  84. PRIMARY KEY (id)
  85. );
  86. --
  87. -- Dumping data for table class
  88. --
  89. /*!40000 ALTER TABLE class DISABLE KEYS */;
  90. LOCK TABLES class WRITE;
  91. UNLOCK TABLES;
  92. /*!40000 ALTER TABLE class ENABLE KEYS */;
  93. --
  94. -- Table structure for table class_user
  95. --
  96. DROP TABLE IF EXISTS class_user;
  97. CREATE TABLE class_user (
  98. class_id mediumint unsigned NOT NULL default '0',
  99. user_id int unsigned NOT NULL default '0',
  100. PRIMARY KEY (class_id,user_id)
  101. );
  102. --
  103. -- Dumping data for table class_user
  104. --
  105. /*!40000 ALTER TABLE class_user DISABLE KEYS */;
  106. LOCK TABLES class_user WRITE;
  107. UNLOCK TABLES;
  108. /*!40000 ALTER TABLE class_user ENABLE KEYS */;
  109. --
  110. -- Table structure for table course
  111. --
  112. DROP TABLE IF EXISTS course;
  113. CREATE TABLE course (
  114. id int auto_increment,
  115. code varchar(40) NOT NULL,
  116. directory varchar(40) default NULL,
  117. db_name varchar(40) default NULL,
  118. course_language varchar(20) default NULL,
  119. title varchar(250) default NULL,
  120. description text,
  121. category_code varchar(40) default NULL,
  122. visibility tinyint default '0',
  123. show_score int NOT NULL default '1',
  124. tutor_name varchar(200) default NULL,
  125. visual_code varchar(40) default NULL,
  126. department_name varchar(30) default NULL,
  127. department_url varchar(180) default NULL,
  128. disk_quota int unsigned default NULL,
  129. last_visit datetime default NULL,
  130. last_edit datetime default NULL,
  131. creation_date datetime default NULL,
  132. expiration_date datetime default NULL,
  133. target_course_code varchar(40) default NULL,
  134. subscribe tinyint NOT NULL default '1',
  135. unsubscribe tinyint NOT NULL default '1',
  136. registration_code varchar(255) NOT NULL default '',
  137. legal TEXT NOT NULL,
  138. activate_legal INT NOT NULL DEFAULT 0,
  139. PRIMARY KEY (id),
  140. UNIQUE KEY code (code)
  141. );
  142. ALTER TABLE course ADD INDEX idx_course_category_code (category_code);
  143. ALTER TABLE course ADD INDEX idx_course_directory (directory(10));
  144. --
  145. -- Dumping data for table course
  146. --
  147. /*!40000 ALTER TABLE course DISABLE KEYS */;
  148. LOCK TABLES course WRITE;
  149. UNLOCK TABLES;
  150. /*!40000 ALTER TABLE course ENABLE KEYS */;
  151. --
  152. -- Table structure for table course_category
  153. --
  154. DROP TABLE IF EXISTS course_category;
  155. CREATE TABLE course_category (
  156. id int unsigned NOT NULL auto_increment,
  157. name varchar(100) NOT NULL default '',
  158. code varchar(40) NOT NULL default '',
  159. parent_id varchar(40) default NULL,
  160. tree_pos int unsigned default NULL,
  161. children_count smallint default NULL,
  162. auth_course_child enum('TRUE','FALSE') default 'TRUE',
  163. auth_cat_child enum('TRUE','FALSE') default 'TRUE',
  164. PRIMARY KEY (id),
  165. UNIQUE KEY code (code),
  166. KEY parent_id (parent_id),
  167. KEY tree_pos (tree_pos)
  168. );
  169. --
  170. -- Dumping data for table course_category
  171. --
  172. /*!40000 ALTER TABLE course_category DISABLE KEYS */;
  173. LOCK TABLES course_category WRITE;
  174. INSERT INTO course_category VALUES (1,'Language skills','LANG',NULL,1,0,'TRUE','TRUE'),(2,'PC Skills','PC',NULL,2,0,'TRUE','TRUE'),(3,'Projects','PROJ',NULL,3,0,'TRUE','TRUE');
  175. UNLOCK TABLES;
  176. /*!40000 ALTER TABLE course_category ENABLE KEYS */;
  177. --
  178. -- Table structure for table course_field
  179. --
  180. DROP TABLE IF EXISTS course_field;
  181. CREATE TABLE course_field (
  182. id int NOT NULL auto_increment,
  183. field_type int NOT NULL default 1,
  184. field_variable varchar(64) NOT NULL,
  185. field_display_text varchar(64),
  186. field_default_value text,
  187. field_order int,
  188. field_visible tinyint default 0,
  189. field_changeable tinyint default 0,
  190. field_filter tinyint default 0,
  191. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  192. PRIMARY KEY(id)
  193. );
  194. --
  195. -- Table structure for table course_field_values
  196. --
  197. DROP TABLE IF EXISTS course_field_values;
  198. CREATE TABLE course_field_values(
  199. id int NOT NULL auto_increment,
  200. course_code varchar(40) NOT NULL,
  201. field_id int NOT NULL,
  202. field_value text,
  203. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  204. PRIMARY KEY(id)
  205. );
  206. --
  207. -- Table structure for table course_module
  208. --
  209. DROP TABLE IF EXISTS course_module;
  210. CREATE TABLE course_module (
  211. id int unsigned NOT NULL auto_increment,
  212. name varchar(255) NOT NULL,
  213. link varchar(255) NOT NULL,
  214. image varchar(100) default NULL,
  215. `row` int unsigned NOT NULL default '0',
  216. `column` int unsigned NOT NULL default '0',
  217. position varchar(20) NOT NULL default 'basic',
  218. PRIMARY KEY (id)
  219. );
  220. --
  221. -- Dumping data for table course_module
  222. --
  223. /*!40000 ALTER TABLE course_module DISABLE KEYS */;
  224. LOCK TABLES course_module WRITE;
  225. INSERT INTO course_module VALUES
  226. (1,'calendar_event','calendar/agenda.php','agenda.gif',1,1,'basic'),
  227. (2,'link','link/link.php','links.gif',4,1,'basic'),
  228. (3,'document','document/document.php','documents.gif',3,1,'basic'),
  229. (4,'student_publication','work/work.php','works.gif',3,2,'basic'),
  230. (5,'announcement','announcements/announcements.php','valves.gif',2,1,'basic'),
  231. (6,'user','user/user.php','members.gif',2,3,'basic'),
  232. (7,'forum','forum/index.php','forum.gif',1,2,'basic'),
  233. (8,'quiz','exercice/exercice.php','quiz.gif',2,2,'basic'),
  234. (9,'group','group/group.php','group.gif',3,3,'basic'),
  235. (10,'course_description','course_description/','info.gif',1,3,'basic'),
  236. (11,'chat','chat/chat.php','chat.gif',0,0,'external'),
  237. (12,'dropbox','dropbox/index.php','dropbox.gif',4,2,'basic'),
  238. (13,'tracking','tracking/courseLog.php','statistics.gif',1,3,'courseadmin'),
  239. (14,'homepage_link','link/link.php?action=addlink','npage.gif',1,1,'courseadmin'),
  240. (15,'course_setting','course_info/infocours.php','reference.gif',1,1,'courseadmin'),
  241. (16,'External','','external.gif',0,0,'external'),
  242. (17,'AddedLearnpath','','scormbuilder.gif',0,0,'external'),
  243. (18,'conference','conference/index.php?type=conference','conf.gif',0,0,'external'),
  244. (19,'conference','conference/index.php?type=classroom','conf.gif',0,0,'external'),
  245. (20,'learnpath','newscorm/lp_controller.php','scorms.gif',5,1,'basic'),
  246. (21,'blog','blog/blog.php','blog.gif',1,2,'basic'),
  247. (22,'blog_management','blog/blog_admin.php','blog_admin.gif',1,2,'courseadmin'),
  248. (23,'course_maintenance','course_info/maintenance.php','backup.gif',2,3,'courseadmin'),
  249. (24,'survey','survey/survey_list.php','survey.gif',2,1,'basic'),
  250. (25,'wiki','wiki/index.php','wiki.gif',2,3,'basic'),
  251. (26,'gradebook','gradebook/index.php','gradebook.gif',2,2,'basic'),
  252. (27,'glossary','glossary/index.php','glossary.gif',2,1,'basic'),
  253. (28,'notebook','notebook/index.php','notebook.gif',2,1,'basic'),
  254. (29,'attendance','attendance/index.php','attendance.gif',2,1,'basic'),
  255. (30,'course_progress','course_progress/index.php','course_progress.gif',2,1,'basic');
  256. UNLOCK TABLES;
  257. /*!40000 ALTER TABLE course_module ENABLE KEYS */;
  258. --
  259. -- Table structure for table course_rel_class
  260. --
  261. DROP TABLE IF EXISTS course_rel_class;
  262. CREATE TABLE course_rel_class (
  263. course_code char(40) NOT NULL,
  264. class_id mediumint unsigned NOT NULL,
  265. PRIMARY KEY (course_code,class_id)
  266. );
  267. --
  268. -- Dumping data for table course_rel_class
  269. --
  270. /*!40000 ALTER TABLE course_rel_class DISABLE KEYS */;
  271. LOCK TABLES course_rel_class WRITE;
  272. UNLOCK TABLES;
  273. /*!40000 ALTER TABLE course_rel_class ENABLE KEYS */;
  274. --
  275. -- Table structure for table course_rel_user
  276. --
  277. DROP TABLE IF EXISTS course_rel_user;
  278. CREATE TABLE course_rel_user (
  279. course_code varchar(40) NOT NULL,
  280. user_id int unsigned NOT NULL default '0',
  281. status tinyint NOT NULL default '5',
  282. role varchar(60) default NULL,
  283. group_id int NOT NULL default '0',
  284. tutor_id int unsigned NOT NULL default '0',
  285. sort int default NULL,
  286. user_course_cat int default '0',
  287. relation_type int default 0,
  288. legal_agreement INTEGER DEFAULT 0,
  289. PRIMARY KEY (course_code,user_id,relation_type)
  290. );
  291. ALTER TABLE course_rel_user ADD INDEX (user_id);
  292. --
  293. -- Dumping data for table course_rel_user
  294. --
  295. /*!40000 ALTER TABLE course_rel_user DISABLE KEYS */;
  296. LOCK TABLES course_rel_user WRITE;
  297. UNLOCK TABLES;
  298. /*!40000 ALTER TABLE course_rel_user ENABLE KEYS */;
  299. --
  300. -- Table structure for table language
  301. --
  302. DROP TABLE IF EXISTS language;
  303. CREATE TABLE language (
  304. id tinyint unsigned NOT NULL auto_increment,
  305. original_name varchar(255) default NULL,
  306. english_name varchar(255) default NULL,
  307. isocode varchar(10) default NULL,
  308. dokeos_folder varchar(250) default NULL,
  309. available tinyint NOT NULL default 1,
  310. parent_id tinyint unsigned,
  311. PRIMARY KEY (id)
  312. );
  313. ALTER TABLE language ADD INDEX idx_language_dokeos_folder(dokeos_folder);
  314. --
  315. -- Dumping data for table language
  316. --
  317. /*!40000 ALTER TABLE language DISABLE KEYS */;
  318. LOCK TABLES language WRITE;
  319. INSERT INTO language (original_name, english_name, isocode, dokeos_folder, available) VALUES
  320. ('العربية','arabic','ar','arabic',0),
  321. ('Asturianu','asturian','ast','asturian',0),
  322. ('Български','bulgarian','bg','bulgarian',1),
  323. ('Bosanski','bosnian','bs','bosnian',1),
  324. ('Català','catalan','ca','catalan',0),
  325. ('中文(简体)','simpl_chinese','zh','simpl_chinese',0),
  326. ('繁體中文','trad_chinese','zh-TW','trad_chinese',0),
  327. ('Česky','czech','cs','czech',0),
  328. ('Dansk','danish','da','danish',0),
  329. ('دری','dari','prs','dari',0),
  330. ('Deutsch','german','de','german',1),
  331. ('Ελληνικά','greek','el','greek',0),
  332. ('English','english','en','english',1),
  333. ('Español','spanish','es','spanish',1),
  334. ('Esperanto','esperanto','eo','esperanto',0),
  335. ('Euskara','euskera','eu','euskera',0),
  336. ('فارسی','persian','fa','persian',0),
  337. ('Français','french','fr','french',1),
  338. ('Furlan','friulian','fur','friulian',0),
  339. ('Galego','galician','gl','galician',0),
  340. ('ქართული','georgian','ka','georgian',0),
  341. ('Hrvatski','croatian','hr','croatian',0),
  342. ('עברית','hebrew','he','hebrew',0),
  343. ('हिन्दी','hindi','hi','hindi',0),
  344. ('Bahasa Indonesia','indonesian','id','indonesian',1),
  345. ('Italiano','italian','it','italian',1),
  346. ('한국어','korean','ko','korean',0),
  347. ('Latviešu','latvian','lv','latvian',0),
  348. ('Lietuvių','lithuanian','lt','lithuanian',0),
  349. ('Македонски','macedonian','mk','macedonian',0),
  350. ('Magyar','hungarian','hu','hungarian',1),
  351. ('Bahasa Melayu','malay','ms','malay',0),
  352. ('Nederlands','dutch','nl','dutch',1),
  353. ('日本語','japanese','ja','japanese',0),
  354. ('Norsk','norwegian','no','norwegian',0),
  355. ('Occitan','occitan','oc','occitan',0),
  356. ('پښتو','pashto','ps','pashto',0),
  357. ('Polski','polish','pl','polish',0),
  358. ('Português europeu','portuguese','pt','portuguese',1),
  359. ('Português do Brasil','brazilian','pt-BR','brazilian',1),
  360. ('Română','romanian','ro','romanian',0),
  361. ('Runasimi','quechua_cusco','qu','quechua_cusco',0),
  362. ('Русский','russian','ru','russian',0),
  363. ('Slovenčina','slovak','sk','slovak',0),
  364. ('Slovenščina','slovenian','sl','slovenian',1),
  365. ('Srpski','serbian','sr','serbian',0),
  366. ('Suomi','finnish','fi','finnish',0),
  367. ('Svenska','swedish','sv','swedish',0),
  368. ('ไทย','thai','th','thai',0),
  369. ('Türkçe','turkce','tr','turkce',0),
  370. ('Українська','ukrainian','uk','ukrainian',0),
  371. ('Tiếng Việt','vietnamese','vi','vietnamese',0),
  372. ('Kiswahili','swahili','sw','swahili',0),
  373. ('Yorùbá','yoruba','yo','yoruba',0);
  374. -- The chosen during the installation platform language should be enabled.
  375. UPDATE language SET available=1 WHERE dokeos_folder = '{PLATFORMLANGUAGE}';
  376. UNLOCK TABLES;
  377. /*!40000 ALTER TABLE language ENABLE KEYS */;
  378. --
  379. -- Table structure for table php_session
  380. --
  381. DROP TABLE IF EXISTS php_session;
  382. CREATE TABLE php_session (
  383. session_id varchar(32) NOT NULL default '',
  384. session_name varchar(10) NOT NULL default '',
  385. session_time int NOT NULL default '0',
  386. session_start int NOT NULL default '0',
  387. session_value mediumtext NOT NULL,
  388. PRIMARY KEY (session_id)
  389. );
  390. --
  391. -- Table structure for table session
  392. --
  393. DROP TABLE IF EXISTS session;
  394. CREATE TABLE session (
  395. id smallint unsigned NOT NULL auto_increment,
  396. id_coach int unsigned NOT NULL default '0',
  397. name char(50) NOT NULL default '',
  398. nbr_courses smallint unsigned NOT NULL default '0',
  399. nbr_users mediumint unsigned NOT NULL default '0',
  400. nbr_classes mediumint unsigned NOT NULL default '0',
  401. date_start date NOT NULL default '0000-00-00',
  402. date_end date NOT NULL default '0000-00-00',
  403. nb_days_access_before_beginning TINYINT UNSIGNED NULL default '0',
  404. nb_days_access_after_end TINYINT UNSIGNED NULL default '0',
  405. session_admin_id INT UNSIGNED NOT NULL,
  406. visibility int NOT NULL default 1,
  407. session_category_id int NOT NULL,
  408. promotion_id INT NOT NULL,
  409. PRIMARY KEY (id),
  410. INDEX (session_admin_id),
  411. UNIQUE KEY name (name)
  412. );
  413. -- --------------------------------------------------------
  414. --
  415. -- Table structure for table session_rel_course
  416. --
  417. DROP TABLE IF EXISTS session_rel_course;
  418. CREATE TABLE session_rel_course (
  419. id_session smallint unsigned NOT NULL default '0',
  420. course_code char(40) NOT NULL default '',
  421. nbr_users smallint unsigned NOT NULL default '0',
  422. PRIMARY KEY (id_session,course_code),
  423. KEY course_code (course_code)
  424. );
  425. -- --------------------------------------------------------
  426. --
  427. -- Table structure for table session_rel_course_rel_user
  428. --
  429. DROP TABLE IF EXISTS session_rel_course_rel_user;
  430. CREATE TABLE session_rel_course_rel_user (
  431. id_session smallint unsigned NOT NULL default '0',
  432. course_code char(40) NOT NULL default '',
  433. id_user int unsigned NOT NULL default '0',
  434. visibility int NOT NULL default 1,
  435. status int NOT NULL default 0,
  436. legal_agreement INTEGER DEFAULT 0,
  437. PRIMARY KEY (id_session,course_code,id_user),
  438. KEY id_user (id_user),
  439. KEY course_code (course_code)
  440. );
  441. -- --------------------------------------------------------
  442. --
  443. -- Table structure for table session_rel_user
  444. --
  445. DROP TABLE IF EXISTS session_rel_user;
  446. CREATE TABLE session_rel_user (
  447. id_session mediumint unsigned NOT NULL default '0',
  448. id_user mediumint unsigned NOT NULL default '0',
  449. relation_type int default 0,
  450. PRIMARY KEY (id_session, id_user, relation_type)
  451. );
  452. DROP TABLE IF EXISTS session_field;
  453. CREATE TABLE session_field (
  454. id int NOT NULL auto_increment,
  455. field_type int NOT NULL default 1,
  456. field_variable varchar(64) NOT NULL,
  457. field_display_text varchar(64),
  458. field_default_value text,
  459. field_order int,
  460. field_visible tinyint default 0,
  461. field_changeable tinyint default 0,
  462. field_filter tinyint default 0,
  463. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  464. PRIMARY KEY(id)
  465. );
  466. DROP TABLE IF EXISTS session_field_values;
  467. CREATE TABLE session_field_values(
  468. id int NOT NULL auto_increment,
  469. session_id int NOT NULL,
  470. field_id int NOT NULL,
  471. field_value text,
  472. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  473. PRIMARY KEY(id)
  474. );
  475. --
  476. -- Table structure for table settings_current
  477. --
  478. DROP TABLE IF EXISTS settings_current;
  479. CREATE TABLE settings_current (
  480. id int unsigned NOT NULL auto_increment,
  481. variable varchar(255) default NULL,
  482. subkey varchar(255) default NULL,
  483. type varchar(255) default NULL,
  484. category varchar(255) default NULL,
  485. selected_value varchar(255) default NULL,
  486. title varchar(255) NOT NULL default '',
  487. comment varchar(255) default NULL,
  488. scope varchar(50) default NULL,
  489. subkeytext varchar(255) default NULL,
  490. access_url int unsigned not null default 1,
  491. access_url_changeable int unsigned not null default 0,
  492. PRIMARY KEY id (id),
  493. INDEX (access_url)
  494. );
  495. ALTER TABLE settings_current ADD UNIQUE unique_setting (variable(110), subkey(110), category(110), access_url);
  496. --
  497. -- Dumping data for table settings_current
  498. --
  499. /*!40000 ALTER TABLE settings_current DISABLE KEYS */;
  500. LOCK TABLES settings_current WRITE;
  501. INSERT INTO settings_current
  502. (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable)
  503. VALUES
  504. ('Institution',NULL,'textfield','Platform','{ORGANISATIONNAME}','InstitutionTitle','InstitutionComment','platform',NULL, 1),
  505. ('InstitutionUrl',NULL,'textfield','Platform','{ORGANISATIONURL}','InstitutionUrlTitle','InstitutionUrlComment',NULL,NULL, 1),
  506. ('siteName',NULL,'textfield','Platform','{CAMPUSNAME}','SiteNameTitle','SiteNameComment',NULL,NULL, 1),
  507. ('emailAdministrator',NULL,'textfield','Platform','{ADMINEMAIL}','emailAdministratorTitle','emailAdministratorComment',NULL,NULL, 1),
  508. ('administratorSurname',NULL,'textfield','Platform','{ADMINLASTNAME}','administratorSurnameTitle','administratorSurnameComment',NULL,NULL, 1),
  509. ('administratorName',NULL,'textfield','Platform','{ADMINFIRSTNAME}','administratorNameTitle','administratorNameComment',NULL,NULL, 1),
  510. ('show_administrator_data',NULL,'radio','Platform','true','ShowAdministratorDataTitle','ShowAdministratorDataComment',NULL,NULL, 1),
  511. ('show_tutor_data',NULL,'radio','Platform','true','ShowTutorDataTitle','ShowTutorDataComment',NULL,NULL, 1),
  512. ('show_teacher_data',NULL,'radio','Platform','true','ShowTeacherDataTitle','ShowTeacherDataComment',NULL,NULL, 1),
  513. ('homepage_view',NULL,'radio','Course','activity_big','HomepageViewTitle','HomepageViewComment',NULL,NULL, 0),
  514. ('show_toolshortcuts',NULL,'radio','Course','false','ShowToolShortcutsTitle','ShowToolShortcutsComment',NULL,NULL, 0),
  515. ('allow_group_categories',NULL,'radio','Course','false','AllowGroupCategories','AllowGroupCategoriesComment',NULL,NULL, 0),
  516. ('server_type',NULL,'radio','Platform','production','ServerStatusTitle','ServerStatusComment',NULL,NULL, 0),
  517. ('platformLanguage',NULL,'link','Languages','{PLATFORMLANGUAGE}','PlatformLanguageTitle','PlatformLanguageComment',NULL,NULL, 0),
  518. ('showonline','world','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineWorld', 0),
  519. ('showonline','users','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineUsers', 0),
  520. ('showonline','course','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineCourse', 0),
  521. ('profile','name','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'name', 0),
  522. ('profile','officialcode','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'officialcode', 0),
  523. ('profile','email','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Email', 0),
  524. ('profile','picture','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPicture', 0),
  525. ('profile','login','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Login', 0),
  526. ('profile','password','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPassword', 0),
  527. ('profile','language','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'Language', 0),
  528. ('default_document_quotum',NULL,'textfield','Course','100000000','DefaultDocumentQuotumTitle','DefaultDocumentQuotumComment',NULL,NULL, 0),
  529. ('registration','officialcode','checkbox','User','false','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'OfficialCode', 0),
  530. ('registration','email','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Email', 0),
  531. ('registration','language','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Language', 0),
  532. ('default_group_quotum',NULL,'textfield','Course','5000000','DefaultGroupQuotumTitle','DefaultGroupQuotumComment',NULL,NULL, 0),
  533. ('allow_registration',NULL,'radio','Platform','{ALLOWSELFREGISTRATION}','AllowRegistrationTitle','AllowRegistrationComment',NULL,NULL, 0),
  534. ('allow_registration_as_teacher',NULL,'radio','Platform','{ALLOWTEACHERSELFREGISTRATION}','AllowRegistrationAsTeacherTitle','AllowRegistrationAsTeacherComment',NULL,NULL, 0),
  535. ('allow_lostpassword',NULL,'radio','Platform','true','AllowLostPasswordTitle','AllowLostPasswordComment',NULL,NULL, 0),
  536. ('allow_user_headings',NULL,'radio','Course','false','AllowUserHeadings','AllowUserHeadingsComment',NULL,NULL, 0),
  537. ('course_create_active_tools','course_description','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'CourseDescription', 0),
  538. ('course_create_active_tools','agenda','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Agenda', 0),
  539. ('course_create_active_tools','documents','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Documents', 0),
  540. ('course_create_active_tools','learning_path','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'LearningPath', 0),
  541. ('course_create_active_tools','links','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Links', 0),
  542. ('course_create_active_tools','announcements','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Announcements', 0),
  543. ('course_create_active_tools','forums','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Forums', 0),
  544. ('course_create_active_tools','dropbox','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Dropbox', 0),
  545. ('course_create_active_tools','quiz','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Quiz', 0),
  546. ('course_create_active_tools','users','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Users', 0),
  547. ('course_create_active_tools','groups','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Groups', 0),
  548. ('course_create_active_tools','chat','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Chat', 0),
  549. ('course_create_active_tools','online_conference','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'OnlineConference', 0),
  550. ('course_create_active_tools','student_publications','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'StudentPublications', 0),
  551. ('allow_personal_agenda',NULL,'radio','User','false','AllowPersonalAgendaTitle','AllowPersonalAgendaComment',NULL,NULL, 0),
  552. ('display_coursecode_in_courselist',NULL,'radio','Platform','false','DisplayCourseCodeInCourselistTitle','DisplayCourseCodeInCourselistComment',NULL,NULL, 0),
  553. ('display_teacher_in_courselist',NULL,'radio','Platform','true','DisplayTeacherInCourselistTitle','DisplayTeacherInCourselistComment',NULL,NULL, 0),
  554. ('use_document_title',NULL,'radio','Tools','true','UseDocumentTitleTitle','UseDocumentTitleComment',NULL,NULL, 0),
  555. ('permanently_remove_deleted_files',NULL,'radio','Tools','false','PermanentlyRemoveFilesTitle','PermanentlyRemoveFilesComment',NULL,NULL, 0),
  556. ('dropbox_allow_overwrite',NULL,'radio','Tools','true','DropboxAllowOverwriteTitle','DropboxAllowOverwriteComment',NULL,NULL, 0),
  557. ('dropbox_max_filesize',NULL,'textfield','Tools','100000000','DropboxMaxFilesizeTitle','DropboxMaxFilesizeComment',NULL,NULL, 0),
  558. ('dropbox_allow_just_upload',NULL,'radio','Tools','true','DropboxAllowJustUploadTitle','DropboxAllowJustUploadComment',NULL,NULL, 0),
  559. ('dropbox_allow_student_to_student',NULL,'radio','Tools','true','DropboxAllowStudentToStudentTitle','DropboxAllowStudentToStudentComment',NULL,NULL, 0),
  560. ('dropbox_allow_group',NULL,'radio','Tools','true','DropboxAllowGroupTitle','DropboxAllowGroupComment',NULL,NULL, 0),
  561. ('dropbox_allow_mailing',NULL,'radio','Tools','false','DropboxAllowMailingTitle','DropboxAllowMailingComment',NULL,NULL, 0),
  562. ('administratorTelephone',NULL,'textfield','Platform','(000) 001 02 03','administratorTelephoneTitle','administratorTelephoneComment',NULL,NULL, 1),
  563. ('extended_profile',NULL,'radio','User','true','ExtendedProfileTitle','ExtendedProfileComment',NULL,NULL, 0),
  564. ('student_view_enabled',NULL,'radio','Platform','true','StudentViewEnabledTitle','StudentViewEnabledComment',NULL,NULL, 0),
  565. ('show_navigation_menu',NULL,'radio','Course','false','ShowNavigationMenuTitle','ShowNavigationMenuComment',NULL,NULL, 0),
  566. ('enable_tool_introduction',NULL,'radio','course','false','EnableToolIntroductionTitle','EnableToolIntroductionComment',NULL,NULL, 0),
  567. ('page_after_login', NULL, 'radio','Platform','user_portal.php', 'PageAfterLoginTitle','PageAfterLoginComment', NULL, NULL, 0),
  568. ('time_limit_whosonline', NULL, 'textfield','Platform','30', 'TimeLimitWhosonlineTitle','TimeLimitWhosonlineComment', NULL, NULL, 0),
  569. ('breadcrumbs_course_homepage', NULL, 'radio','Course','course_title', 'BreadCrumbsCourseHomepageTitle','BreadCrumbsCourseHomepageComment', NULL, NULL, 0),
  570. ('example_material_course_creation', NULL, 'radio','Platform','true', 'ExampleMaterialCourseCreationTitle','ExampleMaterialCourseCreationComment', NULL, NULL, 0),
  571. ('account_valid_duration',NULL, 'textfield','Platform','3660', 'AccountValidDurationTitle','AccountValidDurationComment', NULL, NULL, 0),
  572. ('use_session_mode', NULL, 'radio','Platform','true', 'UseSessionModeTitle','UseSessionModeComment', NULL, NULL, 0),
  573. ('allow_email_editor', NULL, 'radio', 'Tools', 'false', 'AllowEmailEditorTitle', 'AllowEmailEditorComment', NULL, NULL, 0),
  574. ('registered', NULL, 'textfield', NULL, 'false', NULL, NULL, NULL, NULL, 0),
  575. ('donotlistcampus', NULL, 'textfield', NULL, 'false', NULL, NULL, NULL, NULL,0 ),
  576. ('show_email_addresses', NULL,'radio','Platform','false','ShowEmailAddresses','ShowEmailAddressesComment',NULL,NULL, 1),
  577. ('profile','phone','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'phone', 0),
  578. ('service_visio', 'active', 'radio',NULL,'false', 'VisioEnable','', NULL, NULL, 0),
  579. ('service_visio', 'visio_host', 'textfield',NULL,'', 'VisioHost','', NULL, NULL, 0),
  580. ('service_visio', 'visio_port', 'textfield',NULL,'1935', 'VisioPort','', NULL, NULL, 0),
  581. ('service_visio', 'visio_pass', 'textfield',NULL,'', 'VisioPassword','', NULL, NULL, 0),
  582. ('service_ppt2lp', 'active', 'radio',NULL,'false', 'ppt2lp_actived','', NULL, NULL, 0),
  583. ('service_ppt2lp', 'host', 'textfield', NULL, NULL, 'Host', NULL, NULL, NULL, 0),
  584. ('service_ppt2lp', 'port', 'textfield', NULL, 2002, 'Port', NULL, NULL, NULL, 0),
  585. ('service_ppt2lp', 'user', 'textfield', NULL, NULL, 'UserOnHost', NULL, NULL, NULL, 0),
  586. ('service_ppt2lp', 'ftp_password', 'textfield', NULL, NULL, 'FtpPassword', NULL, NULL, NULL, 0),
  587. ('service_ppt2lp', 'path_to_lzx', 'textfield', NULL, NULL, '', NULL, NULL, NULL, 0),
  588. ('service_ppt2lp', 'size', 'radio', NULL, '720x540', '', NULL, NULL, NULL, 0),
  589. ('wcag_anysurfer_public_pages', NULL, 'radio','Editor','false','PublicPagesComplyToWAITitle','PublicPagesComplyToWAIComment', NULL, NULL, 0),
  590. ('stylesheets', NULL, 'textfield','stylesheets','chamilo','',NULL, NULL, NULL, 1),
  591. ('upload_extensions_list_type', NULL, 'radio', 'Security', 'blacklist', 'UploadExtensionsListType', 'UploadExtensionsListTypeComment', NULL, NULL, 0),
  592. ('upload_extensions_blacklist', NULL, 'textfield', 'Security', '', 'UploadExtensionsBlacklist', 'UploadExtensionsBlacklistComment', NULL, NULL, 0),
  593. ('upload_extensions_whitelist', NULL, 'textfield', 'Security', 'htm;html;jpg;jpeg;gif;png;swf;avi;mpg;mpeg;mov;flv;doc;docx;xls;xlsx;ppt;pptx;odt;odp;ods;pdf', 'UploadExtensionsWhitelist', 'UploadExtensionsWhitelistComment', NULL, NULL, 0),
  594. ('upload_extensions_skip', NULL, 'radio', 'Security', 'true', 'UploadExtensionsSkip', 'UploadExtensionsSkipComment', NULL, NULL, 0),
  595. ('upload_extensions_replace_by', NULL, 'textfield', 'Security', 'dangerous', 'UploadExtensionsReplaceBy', 'UploadExtensionsReplaceByComment', NULL, NULL, 0),
  596. ('show_number_of_courses', NULL, 'radio','Platform','false', 'ShowNumberOfCourses','ShowNumberOfCoursesComment', NULL, NULL, 0),
  597. ('show_empty_course_categories', NULL, 'radio','Platform','true', 'ShowEmptyCourseCategories','ShowEmptyCourseCategoriesComment', NULL, NULL, 0),
  598. ('show_back_link_on_top_of_tree', NULL, 'radio','Platform','false', 'ShowBackLinkOnTopOfCourseTree','ShowBackLinkOnTopOfCourseTreeComment', NULL, NULL, 0),
  599. ('show_different_course_language', NULL, 'radio','Platform','true', 'ShowDifferentCourseLanguage','ShowDifferentCourseLanguageComment', NULL, NULL, 1),
  600. ('split_users_upload_directory', NULL, 'radio','Tuning','false', 'SplitUsersUploadDirectory','SplitUsersUploadDirectoryComment', NULL, NULL, 0),
  601. ('hide_dltt_markup', NULL, 'radio','Languages','true', 'HideDLTTMarkup','HideDLTTMarkupComment', NULL, NULL, 0),
  602. ('display_categories_on_homepage',NULL,'radio','Platform','false','DisplayCategoriesOnHomepageTitle','DisplayCategoriesOnHomepageComment',NULL,NULL, 1),
  603. ('permissions_for_new_directories', NULL, 'textfield', 'Security', '0777', 'PermissionsForNewDirs', 'PermissionsForNewDirsComment', NULL, NULL, 0),
  604. ('permissions_for_new_files', NULL, 'textfield', 'Security', '0666', 'PermissionsForNewFiles', 'PermissionsForNewFilesComment', NULL, NULL, 0),
  605. ('show_tabs', 'campus_homepage', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsCampusHomepage', 1),
  606. ('show_tabs', 'my_courses', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyCourses', 1),
  607. ('show_tabs', 'reporting', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsReporting', 1),
  608. ('show_tabs', 'platform_administration', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsPlatformAdministration', 1),
  609. ('show_tabs', 'my_agenda', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyAgenda', 1),
  610. ('show_tabs', 'my_profile', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyProfile', 1),
  611. ('default_forum_view', NULL, 'radio', 'Course', 'flat', 'DefaultForumViewTitle','DefaultForumViewComment',NULL,NULL, 0),
  612. ('platform_charset',NULL,'textfield','Languages','UTF-8','PlatformCharsetTitle','PlatformCharsetComment','platform',NULL, 0),
  613. ('noreply_email_address', '', 'textfield', 'Platform', '', 'NoReplyEmailAddress', 'NoReplyEmailAddressComment', NULL, NULL, 0),
  614. ('survey_email_sender_noreply', '', 'radio', 'Course', 'coach', 'SurveyEmailSenderNoReply', 'SurveyEmailSenderNoReplyComment', NULL, NULL, 0),
  615. ('openid_authentication',NULL,'radio','Security','false','OpenIdAuthentication','OpenIdAuthenticationComment',NULL,NULL, 0),
  616. ('profile','openid','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'OpenIDURL', 0),
  617. ('gradebook_enable',NULL,'radio','Gradebook','false','GradebookActivation','GradebookActivationComment',NULL,NULL, 0),
  618. ('show_tabs','my_gradebook','checkbox','Platform','true','ShowTabsTitle','ShowTabsComment',NULL,'TabsMyGradebook', 1),
  619. ('gradebook_score_display_coloring','my_display_coloring','checkbox','Gradebook','false','GradebookScoreDisplayColoring','GradebookScoreDisplayColoringComment',NULL,'TabsGradebookEnableColoring', 0),
  620. ('gradebook_score_display_custom','my_display_custom','checkbox','Gradebook','false','GradebookScoreDisplayCustom','GradebookScoreDisplayCustomComment',NULL,'TabsGradebookEnableCustom', 0),
  621. ('gradebook_score_display_colorsplit',NULL,'textfield','Gradebook','50','GradebookScoreDisplayColorSplit','GradebookScoreDisplayColorSplitComment',NULL,NULL, 0),
  622. ('gradebook_score_display_upperlimit','my_display_upperlimit','checkbox','Gradebook','false','GradebookScoreDisplayUpperLimit','GradebookScoreDisplayUpperLimitComment',NULL,'TabsGradebookEnableUpperLimit', 0),
  623. ('gradebook_number_decimals', NULL, 'select', 'Gradebook', '0', 'GradebookNumberDecimals', 'GradebookNumberDecimalsComment', NULL, NULL, 0),
  624. ('user_selected_theme',NULL,'radio','Platform','false','UserThemeSelection','UserThemeSelectionComment',NULL,NULL, 0),
  625. ('profile','theme','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserTheme', 0),
  626. ('allow_course_theme',NULL,'radio','Course','true','AllowCourseThemeTitle','AllowCourseThemeComment',NULL,NULL, 0),
  627. ('display_mini_month_calendar',NULL,'radio','Tools', 'true', 'DisplayMiniMonthCalendarTitle', 'DisplayMiniMonthCalendarComment', NULL, NULL, 0),
  628. ('display_upcoming_events',NULL,'radio','Tools','true','DisplayUpcomingEventsTitle','DisplayUpcomingEventsComment',NULL,NULL, 0),
  629. ('number_of_upcoming_events',NULL,'textfield','Tools','1','NumberOfUpcomingEventsTitle','NumberOfUpcomingEventsComment',NULL,NULL, 0),
  630. ('show_closed_courses',NULL,'radio','Platform','false','ShowClosedCoursesTitle','ShowClosedCoursesComment',NULL,NULL, 0),
  631. ('ldap_main_server_address', NULL, 'textfield', 'LDAP', 'localhost', 'LDAPMainServerAddressTitle', 'LDAPMainServerAddressComment', NULL, NULL, 0),
  632. ('ldap_main_server_port', NULL, 'textfield', 'LDAP', '389', 'LDAPMainServerPortTitle', 'LDAPMainServerPortComment', NULL, NULL, 0),
  633. ('ldap_domain', NULL, 'textfield', 'LDAP', 'dc=nodomain', 'LDAPDomainTitle', 'LDAPDomainComment', NULL, NULL, 0),
  634. ('ldap_replicate_server_address', NULL, 'textfield', 'LDAP', 'localhost', 'LDAPReplicateServerAddressTitle', 'LDAPReplicateServerAddressComment', NULL, NULL, 0),
  635. ('ldap_replicate_server_port', NULL, 'textfield', 'LDAP', '389', 'LDAPReplicateServerPortTitle', 'LDAPReplicateServerPortComment', NULL, NULL, 0),
  636. ('ldap_search_term', NULL, 'textfield', 'LDAP', '', 'LDAPSearchTermTitle', 'LDAPSearchTermComment', NULL, NULL, 0),
  637. ('ldap_version', NULL, 'radio', 'LDAP', '3', 'LDAPVersionTitle', 'LDAPVersionComment', NULL, '', 0),
  638. ('ldap_filled_tutor_field', NULL, 'textfield', 'LDAP', 'employeenumber', 'LDAPFilledTutorFieldTitle', 'LDAPFilledTutorFieldComment', NULL, '', 0),
  639. ('ldap_authentication_login', NULL, 'textfield', 'LDAP', '', 'LDAPAuthenticationLoginTitle', 'LDAPAuthenticationLoginComment', NULL, '', 0),
  640. ('ldap_authentication_password', NULL, 'textfield', 'LDAP', '', 'LDAPAuthenticationPasswordTitle', 'LDAPAuthenticationPasswordComment', NULL, '', 0),
  641. ('service_visio', 'visio_use_rtmpt', 'radio',null,'false', 'VisioUseRtmptTitle','VisioUseRtmptComment', NULL, NULL, 0),
  642. ('extendedprofile_registration', 'mycomptetences', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyCompetences', 0),
  643. ('extendedprofile_registration', 'mydiplomas', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyDiplomas', 0),
  644. ('extendedprofile_registration', 'myteach', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyTeach', 0),
  645. ('extendedprofile_registration', 'mypersonalopenarea', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyPersonalOpenArea', 0),
  646. ('extendedprofile_registrationrequired', 'mycomptetences', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyCompetences', 0),
  647. ('extendedprofile_registrationrequired', 'mydiplomas', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyDiplomas', 0),
  648. ('extendedprofile_registrationrequired', 'myteach', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyTeach', 0),
  649. ('extendedprofile_registrationrequired', 'mypersonalopenarea', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyPersonalOpenArea', 0),
  650. ('ldap_filled_tutor_field_value', NULL, 'textfield', 'LDAP', '', 'LDAPFilledTutorFieldValueTitle', 'LDAPFilledTutorFieldValueComment', NULL, '', 0),
  651. ('registration','phone','textfield','User','false','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Phone', 0),
  652. ('add_users_by_coach',NULL,'radio','Security','false','AddUsersByCoachTitle','AddUsersByCoachComment',NULL,NULL, 0),
  653. ('extend_rights_for_coach',NULL,'radio','Security','false','ExtendRightsForCoachTitle','ExtendRightsForCoachComment',NULL,NULL, 0),
  654. ('extend_rights_for_coach_on_survey',NULL,'radio','Security','true','ExtendRightsForCoachOnSurveyTitle','ExtendRightsForCoachOnSurveyComment',NULL,NULL, 0),
  655. ('course_create_active_tools','wiki','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Wiki', 0),
  656. ('show_session_coach', NULL, 'radio','Platform','false', 'ShowSessionCoachTitle','ShowSessionCoachComment', NULL, NULL, 0),
  657. ('course_create_active_tools','gradebook','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Gradebook', 0),
  658. ('allow_users_to_create_courses',NULL,'radio','Platform','true','AllowUsersToCreateCoursesTitle','AllowUsersToCreateCoursesComment',NULL,NULL, 0),
  659. ('course_create_active_tools','survey','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Survey', 0),
  660. ('course_create_active_tools','glossary','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Glossary', 0),
  661. ('course_create_active_tools','notebook','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Notebook', 0),
  662. ('course_create_active_tools','attendances','checkbox','Tools','false','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Attendances', 0),
  663. ('course_create_active_tools','course_progress','checkbox','Tools','false','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'CourseProgress', 0),
  664. ('advanced_filemanager',NULL,'radio','Editor','true','AdvancedFileManagerTitle','AdvancedFileManagerComment',NULL,NULL, 1),
  665. ('allow_reservation', NULL, 'radio', 'Tools', 'false', 'AllowReservationTitle', 'AllowReservationComment', NULL, NULL, 0),
  666. ('profile','apikeys','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'ApiKeys', 0),
  667. ('allow_message_tool', NULL, 'radio', 'Tools', 'true', 'AllowMessageToolTitle', 'AllowMessageToolComment', NULL, NULL,1),
  668. ('allow_social_tool', NULL, 'radio', 'Tools', 'true', 'AllowSocialToolTitle', 'AllowSocialToolComment', NULL, NULL,1),
  669. ('allow_students_to_browse_courses',NULL,'radio','Platform','true','AllowStudentsToBrowseCoursesTitle','AllowStudentsToBrowseCoursesComment',NULL,NULL, 1),
  670. ('show_session_data', NULL, 'radio', 'Course', 'false', 'ShowSessionDataTitle', 'ShowSessionDataComment', NULL, NULL, 1),
  671. ('allow_use_sub_language', NULL, 'radio', 'Languages', 'false', 'AllowUseSubLanguageTitle', 'AllowUseSubLanguageComment', NULL, NULL,0),
  672. ('show_glossary_in_documents', NULL, 'radio', 'Course', 'none', 'ShowGlossaryInDocumentsTitle', 'ShowGlossaryInDocumentsComment', NULL, NULL,1),
  673. ('allow_terms_conditions', NULL, 'radio', 'Platform', 'false', 'AllowTermsAndConditionsTitle', 'AllowTermsAndConditionsComment', NULL, NULL,0),
  674. ('course_create_active_tools','enable_search','checkbox','Tools','false','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Search',0),
  675. ('search_enabled',NULL,'radio','Search','false','EnableSearchTitle','EnableSearchComment',NULL,NULL,1),
  676. ('search_prefilter_prefix',NULL, NULL,'Search','','SearchPrefilterPrefix','SearchPrefilterPrefixComment',NULL,NULL,0),
  677. ('search_show_unlinked_results',NULL,'radio','Search','true','SearchShowUnlinkedResultsTitle','SearchShowUnlinkedResultsComment',NULL,NULL,1),
  678. ('show_courses_descriptions_in_catalog', NULL, 'radio', 'Course', 'true', 'ShowCoursesDescriptionsInCatalogTitle', 'ShowCoursesDescriptionsInCatalogComment', NULL, NULL, 1),
  679. ('allow_coach_to_edit_course_session',NULL,'radio','Course','true','AllowCoachsToEditInsideTrainingSessions','AllowCoachsToEditInsideTrainingSessionsComment',NULL,NULL, 0),
  680. ('show_glossary_in_extra_tools', NULL, 'radio', 'Course', 'false', 'ShowGlossaryInExtraToolsTitle', 'ShowGlossaryInExtraToolsComment', NULL, NULL,1),
  681. ('send_email_to_admin_when_create_course',NULL,'radio','Platform','false','SendEmailToAdminTitle','SendEmailToAdminComment',NULL,NULL, 1),
  682. ('go_to_course_after_login',NULL,'radio','Course','false','GoToCourseAfterLoginTitle','GoToCourseAfterLoginComment',NULL,NULL, 0),
  683. ('math_mimetex',NULL,'radio','Editor','false','MathMimetexTitle','MathMimetexComment',NULL,NULL, 0),
  684. ('math_asciimathML',NULL,'radio','Editor','false','MathASCIImathMLTitle','MathASCIImathMLComment',NULL,NULL, 0),
  685. ('enabled_asciisvg',NULL,'radio','Editor','false','AsciiSvgTitle','AsciiSvgComment',NULL,NULL, 0),
  686. ('include_asciimathml_script',NULL,'radio','Editor','false','IncludeAsciiMathMlTitle','IncludeAsciiMathMlComment',NULL,NULL, 0),
  687. ('youtube_for_students',NULL,'radio','Editor','true','YoutubeForStudentsTitle','YoutubeForStudentsComment',NULL,NULL, 0),
  688. ('block_copy_paste_for_students',NULL,'radio','Editor','false','BlockCopyPasteForStudentsTitle','BlockCopyPasteForStudentsComment',NULL,NULL, 0),
  689. ('more_buttons_maximized_mode',NULL,'radio','Editor','true','MoreButtonsForMaximizedModeTitle','MoreButtonsForMaximizedModeComment',NULL,NULL, 0),
  690. ('students_download_folders',NULL,'radio','Tools','true','AllowStudentsDownloadFoldersTitle','AllowStudentsDownloadFoldersComment',NULL,NULL, 0),
  691. ('users_copy_files',NULL,'radio','Tools','true','AllowUsersCopyFilesTitle','AllowUsersCopyFilesComment',NULL,NULL, 1),
  692. ('show_tabs', 'social', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsSocial', 0),
  693. ('allow_students_to_create_groups_in_social',NULL,'radio','Tools','false','AllowStudentsToCreateGroupsInSocialTitle','AllowStudentsToCreateGroupsInSocialComment',NULL,NULL, 0),
  694. ('allow_send_message_to_all_platform_users',NULL,'radio','Tools','false','AllowSendMessageToAllPlatformUsersTitle','AllowSendMessageToAllPlatformUsersComment',NULL,NULL, 0),
  695. ('message_max_upload_filesize',NULL,'textfield','Tools','20971520','MessageMaxUploadFilesizeTitle','MessageMaxUploadFilesizeComment',NULL,NULL, 0),
  696. ('show_tabs', 'dashboard', 'checkbox', 'Platform', 'true', 'ShowTabsTitle', 'ShowTabsComment', NULL, 'TabsDashboard', 1),
  697. ('use_users_timezone', 'timezones', 'radio', 'Timezones', 'true', 'UseUsersTimezoneTitle','UseUsersTimezoneComment',NULL,'Timezones', 1),
  698. ('timezone_value', 'timezones', 'select', 'Timezones', '', 'TimezoneValueTitle','TimezoneValueComment',NULL,'Timezones', 1),
  699. ('allow_user_course_subscription_by_course_admin', NULL, 'radio', 'Security', 'true', 'AllowUserCourseSubscriptionByCourseAdminTitle', 'AllowUserCourseSubscriptionByCourseAdminComment', NULL, NULL, 1),
  700. ('show_link_bug_notification', NULL, 'radio', 'Platform', 'true', 'ShowLinkBugNotificationTitle', 'ShowLinkBugNotificationComment', NULL, NULL, 0),
  701. ('course_validation', NULL, 'radio', 'Platform', 'false', 'EnableCourseValidation', 'EnableCourseValidationComment', NULL, NULL, 1),
  702. ('course_validation_terms_and_conditions_url', NULL, 'textfield', 'Platform', '', 'CourseValidationTermsAndConditionsLink', 'CourseValidationTermsAndConditionsLinkComment', NULL, NULL, 1),
  703. ('sso_authentication',NULL,'radio','Security','false','EnableSSOTitle','EnableSSOComment',NULL,NULL,1),
  704. ('sso_authentication_domain',NULL,'textfield','Security','','SSOServerDomainTitle','SSOServerDomainComment',NULL,NULL,1),
  705. ('sso_authentication_auth_uri',NULL,'textfield','Security','/?q=user','SSOServerAuthURITitle','SSOServerAuthURIComment',NULL,NULL,1),
  706. ('sso_authentication_unauth_uri',NULL,'textfield','Security','/?q=logout','SSOServerUnAuthURITitle','SSOServerUnAuthURIComment',NULL,NULL,1),
  707. ('sso_authentication_protocol',NULL,'radio','Security','http://','SSOServerProtocolTitle','SSOServerProtocolComment',NULL,NULL,1),
  708. ('enabled_wiris',NULL,'radio','Editor','false','EnabledWirisTitle','EnabledWirisComment',NULL,NULL, 0),
  709. ('allow_spellcheck',NULL,'radio','Editor','false','AllowSpellCheckTitle','AllowSpellCheckComment',NULL,NULL, 0),
  710. ('force_wiki_paste_as_plain_text',NULL,'radio','Editor','false','ForceWikiPasteAsPlainTextTitle','ForceWikiPasteAsPlainTextComment',NULL,NULL, 0),
  711. ('enabled_googlemaps',NULL,'radio','Editor','false','EnabledGooglemapsTitle','EnabledGooglemapsComment',NULL,NULL, 0),
  712. ('enabled_imgmap',NULL,'radio','Editor','true','EnabledImageMapsTitle','EnabledImageMapsComment',NULL,NULL, 0),
  713. ('enabled_support_svg', NULL,'radio', 'Tools', 'true', 'EnabledSVGTitle','EnabledSVGComment',NULL,NULL, 0),
  714. ('pdf_export_watermark_enable', NULL,'radio', 'Platform', 'false','PDFExportWatermarkEnableTitle', 'PDFExportWatermarkEnableComment', 'platform',NULL, 1),
  715. ('pdf_export_watermark_by_course', NULL,'radio', 'Platform', 'false','PDFExportWatermarkByCourseTitle', 'PDFExportWatermarkByCourseComment','platform',NULL, 1),
  716. ('pdf_export_watermark_text', NULL,'textfield', 'Platform', '', 'PDFExportWatermarkTextTitle', 'PDFExportWatermarkTextComment', 'platform',NULL, 1),
  717. ('enabled_insertHtml', NULL,'radio', 'Editor', 'true','EnabledInsertHtmlTitle', 'EnabledInsertHtmlComment',NULL,NULL, 0),
  718. ('students_export2pdf', NULL,'radio', 'Tools', 'true', 'EnabledStudentExport2PDFTitle', 'EnabledStudentExport2PDFComment',NULL,NULL, 0),
  719. ('exercise_min_score', NULL,'textfield', 'Course', '', 'ExerciseMinScoreTitle', 'ExerciseMinScoreComment','platform',NULL, 1),
  720. ('exercise_max_score', NULL,'textfield', 'Course', '', 'ExerciseMaxScoreTitle', 'ExerciseMaxScoreComment','platform',NULL, 1),
  721. ('show_users_folders', NULL,'radio', 'Tools', 'true', 'ShowUsersFoldersTitle','ShowUsersFoldersComment',NULL,NULL, 0),
  722. ('show_default_folders', NULL,'radio', 'Tools', 'true', 'ShowDefaultFoldersTitle','ShowDefaultFoldersComment',NULL,NULL, 0),
  723. ('show_chat_folder', NULL,'radio', 'Tools', 'true', 'ShowChatFolderTitle','ShowChatFolderComment',NULL,NULL, 0),
  724. ('enabled_text2audio', NULL,'radio', 'Tools', 'false', 'Text2AudioTitle','Text2AudioComment',NULL,NULL, 0),
  725. ('course_hide_tools','course_description','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'CourseDescription', 1),
  726. ('course_hide_tools','calendar_event','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Agenda', 1),
  727. ('course_hide_tools','document','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Documents', 1),
  728. ('course_hide_tools','learnpath','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'LearningPath', 1),
  729. ('course_hide_tools','link','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Links', 1),
  730. ('course_hide_tools','announcement','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Announcements', 1),
  731. ('course_hide_tools','forum','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Forums', 1),
  732. ('course_hide_tools','dropbox','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Dropbox', 1),
  733. ('course_hide_tools','quiz','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Quiz', 1),
  734. ('course_hide_tools','user','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Users', 1),
  735. ('course_hide_tools','group','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Groups', 1),
  736. ('course_hide_tools','chat','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Chat', 1),
  737. ('course_hide_tools','student_publication','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'StudentPublications', 1),
  738. ('course_hide_tools','wiki','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Wiki', 1),
  739. ('course_hide_tools','gradebook','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Gradebook', 1),
  740. ('course_hide_tools','survey','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Survey', 1),
  741. ('course_hide_tools','glossary','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Glossary', 1),
  742. ('course_hide_tools','notebook','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Notebook', 1),
  743. ('course_hide_tools','attendance','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Attendances', 1),
  744. ('course_hide_tools','course_progress','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'CourseProgress', 1),
  745. ('course_hide_tools','blog_management','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Blog',1),
  746. ('course_hide_tools','tracking','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Stats',1),
  747. ('course_hide_tools','course_maintenance','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Maintenance',1),
  748. ('course_hide_tools','course_setting','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'CourseSettings',1),
  749. ('enabled_support_pixlr',NULL,'radio','Tools','false','EnabledPixlrTitle','EnabledPixlrComment',NULL,NULL, 0),
  750. ('show_groups_to_users',NULL,'radio','Platform','false','ShowGroupsToUsersTitle','ShowGroupsToUsersComment',NULL,NULL, 0),
  751. ('accessibility_font_resize',NULL,'radio','Platform','false','EnableAccessibilityFontResizeTitle','EnableAccessibilityFontResizeComment',NULL,NULL, 1),
  752. ('hide_courses_in_sessions',NULL,'radio', 'Platform','false','HideCoursesInSessionsTitle', 'HideCoursesInSessionsComment','platform',NULL, 1),
  753. ('enable_quiz_scenario', NULL,'radio','Course','false','EnableQuizScenarioTitle','EnableQuizScenarioComment',NULL,NULL, 1),
  754. ('enable_nanogong',NULL,'radio','Tools','false','EnableNanogongTitle','EnableNanogongComment',NULL,NULL, 0),
  755. ('filter_terms',NULL,'textarea','Security','','FilterTermsTitle','FilterTermsComment',NULL,NULL, 0),
  756. ('header_extra_content', NULL, 'textarea', 'Tracking', '', 'HeaderExtraContentTitle', 'HeaderExtraContentComment', NULL, NULL, 1),
  757. ('footer_extra_content', NULL, 'textarea', 'Tracking', '', 'FooterExtraContentTitle', 'FooterExtraContentComment', NULL, NULL, 1),
  758. ('show_documents_preview', NULL, 'radio', 'Tools', 'false', 'ShowDocumentPreviewTitle', 'ShowDocumentPreviewComment', NULL, NULL, 1),
  759. ('htmlpurifier_wiki', NULL, 'radio', 'Editor', 'false', 'HtmlPurifierWikiTitle', 'HtmlPurifierWikiComment', NULL, NULL, 0),
  760. ('cas_activate', NULL, 'radio', 'CAS', 'false', 'CasMainActivateTitle', 'CasMainActivateComment', NULL, NULL, 0),
  761. ('cas_server', NULL, 'textfield', 'CAS', '', 'CasMainServerTitle', 'CasMainServerComment', NULL, NULL, 0),
  762. ('cas_server_uri', NULL, 'textfield', 'CAS', '', 'CasMainServerURITitle', 'CasMainServerURIComment', NULL, NULL, 0),
  763. ('cas_port', NULL, 'textfield', 'CAS', '', 'CasMainPortTitle', 'CasMainPortComment', NULL, NULL, 0),
  764. ('cas_protocol', NULL, 'radio', 'CAS', '', 'CasMainProtocolTitle', 'CasMainProtocolComment', NULL, NULL, 0),
  765. ('cas_add_user_activate', NULL, 'radio', 'CAS', '', 'CasUserAddActivateTitle', 'CasUserAddActivateComment', NULL, NULL, 0),
  766. ('cas_add_user_login_attr', NULL, 'textfield', 'CAS', '', 'CasUserAddLoginAttributeTitle', 'CasUserAddLoginAttributeComment', NULL, NULL, 0),
  767. ('cas_add_user_email_attr', NULL, 'textfield', 'CAS', '', 'CasUserAddEmailAttributeTitle', 'CasUserAddEmailAttributeComment', NULL, NULL, 0),
  768. ('cas_add_user_firstname_attr', NULL, 'textfield', 'CAS', '', 'CasUserAddFirstnameAttributeTitle', 'CasUserAddFirstnameAttributeComment', NULL, NULL, 0),
  769. ('cas_add_user_lastname_attr', NULL, 'textfield', 'CAS', '', 'CasUserAddLastnameAttributeTitle', 'CasUserAddLastnameAttributeComment', NULL, NULL, 0),
  770. ('student_page_after_login', NULL, 'textfield', 'Platform', '', 'StudentPageAfterLoginTitle', 'StudentPageAfterLoginComment', NULL, NULL, 0),
  771. ('teacher_page_after_login', NULL, 'textfield', 'Platform', '', 'TeacherPageAfterLoginTitle', 'TeacherPageAfterLoginComment', NULL, NULL, 0),
  772. ('drh_page_after_login', NULL, 'textfield', 'Platform', '', 'DRHPageAfterLoginTitle', 'DRHPageAfterLoginComment', NULL, NULL, 0),
  773. ('sessionadmin_page_after_login', NULL, 'textfield', 'Platform', '', 'SessionAdminPageAfterLoginTitle', 'SessionAdminPageAfterLoginComment', NULL, NULL, 0),
  774. ('student_autosubscribe', NULL, 'textfield', 'Platform', '', 'StudentAutosubscribeTitle', 'StudentAutosubscribeComment', NULL, NULL, 0),
  775. ('teacher_autosubscribe', NULL, 'textfield', 'Platform', '', 'TeacherAutosubscribeTitle', 'TeacherAutosubscribeComment', NULL, NULL, 0),
  776. ('drh_autosubscribe', NULL, 'textfield', 'Platform', '', 'DRHAutosubscribeTitle', 'DRHAutosubscribeComment', NULL, NULL, 0),
  777. ('sessionadmin_autosubscribe', NULL, 'textfield', 'Platform', '', 'SessionadminAutosubscribeTitle', 'SessionadminAutosubscribeComment', NULL, NULL, 0),
  778. ('scorm_cumulative_session_time', NULL, 'radio', 'Course', 'true', 'ScormCumulativeSessionTimeTitle', 'ScormCumulativeSessionTimeComment', NULL, NULL, 0),
  779. ('allow_hr_skills_management', NULL, 'radio', 'Gradebook', 'true', 'AllowHRSkillsManagementTitle', 'AllowHRSkillsManagementComment', NULL, NULL, 1),
  780. ('chamilo_database_version',NULL,'textfield',NULL, '1.9.0.15858','DokeosDatabaseVersion','', NULL, NULL, 0);
  781. /*
  782. ('use_custom_pages',NULL,'radio','Platform','false','UseCustomPages','useCustomPagesComment','platform',NULL,0),
  783. ('show_tabs', 'custom_tab_1', 'checkbox', 'Platform', 'true', 'ShowTabsTitle', 'ShowTabsComment', NULL, 'TabsCustom1', 1),
  784. ('show_tabs', 'custom_tab_2', 'checkbox', 'Platform', 'false', 'ShowTabsTitle', 'ShowTabsComment', NULL, 'TabsCustom2', 1),
  785. ('show_tabs', 'custom_tab_3', 'checkbox', 'Platform', 'false', 'ShowTabsTitle', 'ShowTabsComment', NULL, 'TabsCustom3', 1),
  786. ('custom_tab_1_name', NULL, 'textfield', 'Platform', 'Reports', 'CustomTab1NameTitle', 'CustomTab1NameComment', NULL, NULL, 0),
  787. ('custom_tab_1_url', NULL, 'textfield', 'Platform', '/main/reports/', 'CustomTab1URLTitle', 'CustomTab1URLComment', NULL, NULL, 0),
  788. ('custom_tab_2_name', NULL, 'textfield', 'Platform', '', 'CustomTab2NameTitle', 'CustomTab2NameComment', NULL, NULL, 0),
  789. ('custom_tab_2_url', NULL, 'textfield', 'Platform', '', 'CustomTab2URLTitle', 'CustomTab2URLComment', NULL, NULL, 0),
  790. ('custom_tab_3_name', NULL, 'textfield', 'Platform', '', 'CustomTab3NameTitle', 'CustomTab3NameComment', NULL, NULL, 0),
  791. ('custom_tab_3_url', NULL, 'textfield', 'Platform', '', 'CustomTab3URLTitle', 'CustomTab3URLComment', NULL, NULL, 0),
  792. ('languagePriority1', NULL, 'radio', 'Languages', 'course_lang', 'LanguagePriority1Title', 'LanguagePriority1Comment', NULL, NULL, 0),
  793. ('languagePriority2', NULL, 'radio', 'Languages','user_profil_lang', 'LanguagePriority2Title', 'LanguagePriority2Comment', NULL, NULL, 0),
  794. ('languagePriority3', NULL, 'radio', 'Languages','user_selected_lang', 'LanguagePriority3Title', 'LanguagePriority3Comment', NULL, NULL, 0),
  795. ('languagePriority4', NULL, 'radio', 'Languages', 'platform_lang','LanguagePriority4Title', 'LanguagePriority4Comment', NULL, NULL, 0),
  796. ('activate_send_event_by_mail', NULL, 'radio', 'Platform', 'false', 'ActivateSendEventByMailTitle', 'ActivateSendEventByMailComment', NULL, NULL, 0),
  797. */
  798. UNLOCK TABLES;
  799. /*!40000 ALTER TABLE settings_current ENABLE KEYS */;
  800. --
  801. -- Table structure for table settings_options
  802. --
  803. DROP TABLE IF EXISTS settings_options;
  804. CREATE TABLE settings_options (
  805. id int unsigned NOT NULL auto_increment,
  806. variable varchar(255) default NULL,
  807. value varchar(255) default NULL,
  808. display_text varchar(255) NOT NULL default '',
  809. PRIMARY KEY (id),
  810. UNIQUE KEY id (id)
  811. );
  812. ALTER TABLE settings_options ADD UNIQUE unique_setting_option (variable(165), value(165));
  813. --
  814. -- Dumping data for table settings_options
  815. --
  816. /*!40000 ALTER TABLE settings_options DISABLE KEYS */;
  817. LOCK TABLES settings_options WRITE;
  818. INSERT INTO settings_options
  819. (variable, value, display_text)
  820. VALUES
  821. ('show_administrator_data','true','Yes'),
  822. ('show_administrator_data','false','No'),
  823. ('show_tutor_data','true','Yes'),
  824. ('show_tutor_data','false','No'),
  825. ('show_teacher_data','true','Yes'),
  826. ('show_teacher_data','false','No'),
  827. ('homepage_view','activity','HomepageViewActivity'),
  828. ('homepage_view','2column','HomepageView2column'),
  829. ('homepage_view','3column','HomepageView3column'),
  830. ('homepage_view','vertical_activity','HomepageViewVerticalActivity'),
  831. ('homepage_view','activity_big','HomepageViewActivityBig'),
  832. ('show_toolshortcuts','true','Yes'),
  833. ('show_toolshortcuts','false','No'),
  834. ('allow_group_categories','true','Yes'),
  835. ('allow_group_categories','false','No'),
  836. ('server_type','production','ProductionServer'),
  837. ('server_type','test','TestServer'),
  838. ('allow_name_change','true','Yes'),
  839. ('allow_name_change','false','No'),
  840. ('allow_officialcode_change','true','Yes'),
  841. ('allow_officialcode_change','false','No'),
  842. ('allow_registration','true','Yes'),
  843. ('allow_registration','false','No'),
  844. ('allow_registration','approval','AfterApproval'),
  845. ('allow_registration_as_teacher','true','Yes'),
  846. ('allow_registration_as_teacher','false','No'),
  847. ('allow_lostpassword','true','Yes'),
  848. ('allow_lostpassword','false','No'),
  849. ('allow_user_headings','true','Yes'),
  850. ('allow_user_headings','false','No'),
  851. ('allow_personal_agenda','true','Yes'),
  852. ('allow_personal_agenda','false','No'),
  853. ('display_coursecode_in_courselist','true','Yes'),
  854. ('display_coursecode_in_courselist','false','No'),
  855. ('display_teacher_in_courselist','true','Yes'),
  856. ('display_teacher_in_courselist','false','No'),
  857. ('use_document_title','true','Yes'),
  858. ('use_document_title','false','No'),
  859. ('permanently_remove_deleted_files','true','YesWillDeletePermanently'),
  860. ('permanently_remove_deleted_files','false','NoWillDeletePermanently'),
  861. ('dropbox_allow_overwrite','true','Yes'),
  862. ('dropbox_allow_overwrite','false','No'),
  863. ('dropbox_allow_just_upload','true','Yes'),
  864. ('dropbox_allow_just_upload','false','No'),
  865. ('dropbox_allow_student_to_student','true','Yes'),
  866. ('dropbox_allow_student_to_student','false','No'),
  867. ('dropbox_allow_group','true','Yes'),
  868. ('dropbox_allow_group','false','No'),
  869. ('dropbox_allow_mailing','true','Yes'),
  870. ('dropbox_allow_mailing','false','No'),
  871. ('extended_profile','true','Yes'),
  872. ('extended_profile','false','No'),
  873. ('student_view_enabled','true','Yes'),
  874. ('student_view_enabled','false','No'),
  875. ('show_navigation_menu','false','No'),
  876. ('show_navigation_menu','icons','IconsOnly'),
  877. ('show_navigation_menu','text','TextOnly'),
  878. ('show_navigation_menu','iconstext','IconsText'),
  879. ('enable_tool_introduction','true','Yes'),
  880. ('enable_tool_introduction','false','No'),
  881. ('page_after_login', 'index.php', 'CampusHomepage'),
  882. ('page_after_login', 'user_portal.php', 'MyCourses'),
  883. ('breadcrumbs_course_homepage', 'get_lang', 'CourseHomepage'),
  884. ('breadcrumbs_course_homepage', 'course_code', 'CourseCode'),
  885. ('breadcrumbs_course_homepage', 'course_title', 'CourseTitle'),
  886. ('example_material_course_creation', 'true', 'Yes'),
  887. ('example_material_course_creation', 'false', 'No'),
  888. ('use_session_mode', 'true', 'Yes'),
  889. ('use_session_mode', 'false', 'No'),
  890. ('allow_email_editor', 'true' ,'Yes'),
  891. ('allow_email_editor', 'false', 'No'),
  892. ('show_email_addresses','true','Yes'),
  893. ('show_email_addresses','false','No'),
  894. ('wcag_anysurfer_public_pages', 'true', 'Yes'),
  895. ('wcag_anysurfer_public_pages', 'false', 'No'),
  896. ('upload_extensions_list_type', 'blacklist', 'Blacklist'),
  897. ('upload_extensions_list_type', 'whitelist', 'Whitelist'),
  898. ('upload_extensions_skip', 'true', 'Remove'),
  899. ('upload_extensions_skip', 'false', 'Rename'),
  900. ('show_number_of_courses', 'true', 'Yes'),
  901. ('show_number_of_courses', 'false', 'No'),
  902. ('show_empty_course_categories', 'true', 'Yes'),
  903. ('show_empty_course_categories', 'false', 'No'),
  904. ('show_back_link_on_top_of_tree', 'true', 'Yes'),
  905. ('show_back_link_on_top_of_tree', 'false', 'No'),
  906. ('show_different_course_language', 'true', 'Yes'),
  907. ('show_different_course_language', 'false', 'No'),
  908. ('split_users_upload_directory', 'true', 'Yes'),
  909. ('split_users_upload_directory', 'false', 'No'),
  910. ('hide_dltt_markup', 'false', 'No'),
  911. ('hide_dltt_markup', 'true', 'Yes'),
  912. ('display_categories_on_homepage','true','Yes'),
  913. ('display_categories_on_homepage','false','No'),
  914. ('default_forum_view', 'flat', 'Flat'),
  915. ('default_forum_view', 'threaded', 'Threaded'),
  916. ('default_forum_view', 'nested', 'Nested'),
  917. ('survey_email_sender_noreply', 'coach', 'CourseCoachEmailSender'),
  918. ('survey_email_sender_noreply', 'noreply', 'NoReplyEmailSender'),
  919. ('openid_authentication','true','Yes'),
  920. ('openid_authentication','false','No'),
  921. ('gradebook_enable','true','Yes'),
  922. ('gradebook_enable','false','No'),
  923. ('user_selected_theme','true','Yes'),
  924. ('user_selected_theme','false','No'),
  925. ('allow_course_theme','true','Yes'),
  926. ('allow_course_theme','false','No'),
  927. ('display_mini_month_calendar', 'true', 'Yes'),
  928. ('display_mini_month_calendar', 'false', 'No'),
  929. ('display_upcoming_events', 'true', 'Yes'),
  930. ('display_upcoming_events', 'false', 'No'),
  931. ('show_closed_courses', 'true', 'Yes'),
  932. ('show_closed_courses', 'false', 'No'),
  933. ('ldap_version', '2', 'LDAPVersion2'),
  934. ('ldap_version', '3', 'LDAPVersion3'),
  935. ('visio_use_rtmpt','true','Yes'),
  936. ('visio_use_rtmpt','false','No'),
  937. ('add_users_by_coach', 'true', 'Yes'),
  938. ('add_users_by_coach', 'false', 'No'),
  939. ('extend_rights_for_coach', 'true', 'Yes'),
  940. ('extend_rights_for_coach', 'false', 'No'),
  941. ('extend_rights_for_coach_on_survey', 'true', 'Yes'),
  942. ('extend_rights_for_coach_on_survey', 'false', 'No'),
  943. ('show_session_coach', 'true', 'Yes'),
  944. ('show_session_coach', 'false', 'No'),
  945. ('allow_users_to_create_courses','true','Yes'),
  946. ('allow_users_to_create_courses','false','No'),
  947. ('breadcrumbs_course_homepage', 'session_name_and_course_title', 'SessionNameAndCourseTitle'),
  948. ('advanced_filemanager','true','Yes'),
  949. ('advanced_filemanager','false','No'),
  950. ('allow_reservation', 'true', 'Yes'),
  951. ('allow_reservation', 'false', 'No'),
  952. ('allow_message_tool', 'true', 'Yes'),
  953. ('allow_message_tool', 'false', 'No'),
  954. ('allow_social_tool', 'true', 'Yes'),
  955. ('allow_social_tool', 'false', 'No'),
  956. ('allow_students_to_browse_courses','true','Yes'),
  957. ('allow_students_to_browse_courses','false','No'),
  958. ('show_email_of_teacher_or_tutor ', 'true', 'Yes'),
  959. ('show_email_of_teacher_or_tutor ', 'false', 'No'),
  960. ('show_session_data ', 'true', 'Yes'),
  961. ('show_session_data ', 'false', 'No'),
  962. ('allow_use_sub_language', 'true', 'Yes'),
  963. ('allow_use_sub_language', 'false', 'No'),
  964. ('show_glossary_in_documents', 'none', 'ShowGlossaryInDocumentsIsNone'),
  965. ('show_glossary_in_documents', 'ismanual', 'ShowGlossaryInDocumentsIsManual'),
  966. ('show_glossary_in_documents', 'isautomatic', 'ShowGlossaryInDocumentsIsAutomatic'),
  967. ('allow_terms_conditions', 'true', 'Yes'),
  968. ('allow_terms_conditions', 'false', 'No'),
  969. ('search_enabled', 'true', 'Yes'),
  970. ('search_enabled', 'false', 'No'),
  971. ('search_show_unlinked_results', 'true', 'SearchShowUnlinkedResults'),
  972. ('search_show_unlinked_results', 'false', 'SearchHideUnlinkedResults'),
  973. ('show_courses_descriptions_in_catalog', 'true', 'Yes'),
  974. ('show_courses_descriptions_in_catalog', 'false', 'No'),
  975. ('allow_coach_to_edit_course_session','true','Yes'),
  976. ('allow_coach_to_edit_course_session','false','No'),
  977. ('show_glossary_in_extra_tools', 'true', 'Yes'),
  978. ('show_glossary_in_extra_tools', 'false', 'No'),
  979. ('send_email_to_admin_when_create_course','true','Yes'),
  980. ('send_email_to_admin_when_create_course','false','No'),
  981. ('go_to_course_after_login','true','Yes'),
  982. ('go_to_course_after_login','false','No'),
  983. ('math_mimetex','true','Yes'),
  984. ('math_mimetex','false','No'),
  985. ('math_asciimathML','true','Yes'),
  986. ('math_asciimathML','false','No'),
  987. ('enabled_asciisvg','true','Yes'),
  988. ('enabled_asciisvg','false','No'),
  989. ('include_asciimathml_script','true','Yes'),
  990. ('include_asciimathml_script','false','No'),
  991. ('youtube_for_students','true','Yes'),
  992. ('youtube_for_students','false','No'),
  993. ('block_copy_paste_for_students','true','Yes'),
  994. ('block_copy_paste_for_students','false','No'),
  995. ('more_buttons_maximized_mode','true','Yes'),
  996. ('more_buttons_maximized_mode','false','No'),
  997. ('students_download_folders','true','Yes'),
  998. ('students_download_folders','false','No'),
  999. ('users_copy_files','true','Yes'),
  1000. ('users_copy_files','false','No'),
  1001. ('allow_students_to_create_groups_in_social','true','Yes'),
  1002. ('allow_students_to_create_groups_in_social','false','No'),
  1003. ('allow_send_message_to_all_platform_users','true','Yes'),
  1004. ('allow_send_message_to_all_platform_users','false','No'),
  1005. ('use_users_timezone', 'true', 'Yes'),
  1006. ('use_users_timezone', 'false', 'No'),
  1007. ('allow_user_course_subscription_by_course_admin', 'true', 'Yes'),
  1008. ('allow_user_course_subscription_by_course_admin', 'false', 'No'),
  1009. ('show_link_bug_notification', 'true', 'Yes'),
  1010. ('show_link_bug_notification', 'false', 'No'),
  1011. ('course_validation', 'true', 'Yes'),
  1012. ('course_validation', 'false', 'No'),
  1013. ('sso_authentication', 'true', 'Yes'),
  1014. ('sso_authentication', 'false', 'No'),
  1015. ('sso_authentication_protocol', 'http://', 'http://'),
  1016. ('sso_authentication_protocol', 'https://', 'https://'),
  1017. ('enabled_wiris','true','Yes'),
  1018. ('enabled_wiris','false','No'),
  1019. ('allow_spellcheck','true','Yes'),
  1020. ('allow_spellcheck','false','No'),
  1021. ('force_wiki_paste_as_plain_text','true','Yes'),
  1022. ('force_wiki_paste_as_plain_text','false','No'),
  1023. ('enabled_googlemaps','true','Yes'),
  1024. ('enabled_googlemaps','false','No'),
  1025. ('enabled_imgmap','true','Yes'),
  1026. ('enabled_imgmap','false','No'),
  1027. ('enabled_support_svg','true','Yes'),
  1028. ('enabled_support_svg','false','No'),
  1029. ('pdf_export_watermark_enable','true','Yes'),
  1030. ('pdf_export_watermark_enable','false','No'),
  1031. ('pdf_export_watermark_by_course','true','Yes'),
  1032. ('pdf_export_watermark_by_course','false','No'),
  1033. ('enabled_insertHtml','true','Yes'),
  1034. ('enabled_insertHtml','false','No'),
  1035. ('students_export2pdf','true','Yes'),
  1036. ('students_export2pdf','false','No'),
  1037. ('show_users_folders','true','Yes'),
  1038. ('show_users_folders','false','No'),
  1039. ('show_default_folders','true','Yes'),
  1040. ('show_default_folders','false','No'),
  1041. ('show_chat_folder','true','Yes'),
  1042. ('show_chat_folder','false','No'),
  1043. ('enabled_text2audio','true','Yes'),
  1044. ('enabled_text2audio','false','No'),
  1045. ('enabled_support_pixlr','true','Yes'),
  1046. ('enabled_support_pixlr','false','No'),
  1047. ('show_groups_to_users','true','Yes'),
  1048. ('show_groups_to_users','false','No'),
  1049. ('accessibility_font_resize', 'true', 'Yes'),
  1050. ('accessibility_font_resize', 'false', 'No'),
  1051. ('hide_courses_in_sessions','true','Yes'),
  1052. ('hide_courses_in_sessions','false','No'),
  1053. ('enable_quiz_scenario', 'true', 'Yes'),
  1054. ('enable_quiz_scenario', 'false', 'No'),
  1055. ('enable_nanogong','true','Yes'),
  1056. ('enable_nanogong','false','No'),
  1057. ('show_documents_preview', 'true', 'Yes'),
  1058. ('show_documents_preview', 'false', 'No'),
  1059. ('htmlpurifier_wiki', 'true', 'Yes'),
  1060. ('htmlpurifier_wiki', 'false', 'No'),
  1061. ('cas_activate', 'true', 'Yes'),
  1062. ('cas_activate', 'false', 'No'),
  1063. ('cas_protocol', 'CAS1', 'CAS1Text'),
  1064. ('cas_protocol', 'CAS2', 'CAS2Text'),
  1065. ('cas_protocol', 'SAML', 'SAMLText'),
  1066. ('cas_add_user_activate', 'true', 'Yes'),
  1067. ('cas_add_user_activate', 'false', 'No'),
  1068. ('scorm_cumulative_session_time','true','Yes'),
  1069. ('scorm_cumulative_session_time','false','No'),
  1070. ('allow_hr_skills_management', 'true', 'Yes'),
  1071. ('allow_hr_skills_management', 'false', 'No');
  1072. /*
  1073. ('use_custom_pages','true','Yes'),
  1074. ('use_custom_pages','false','No'),
  1075. ('languagePriority1','platform_lang','PlatformLanguage'),
  1076. ('languagePriority1','user_profil_lang','UserLanguage'),
  1077. ('languagePriority1','user_selected_lang','UserSelectedLanguage'),
  1078. ('languagePriority1','course_lang','CourseLanguage'),
  1079. ('languagePriority2','platform_lang','PlatformLanguage'),
  1080. ('languagePriority2','user_profil_lang','UserLanguage'),
  1081. ('languagePriority2','user_selected_lang','UserSelectedLanguage'),
  1082. ('languagePriority2','course_lang','CourseLanguage'),
  1083. ('languagePriority3','platform_lang','PlatformLanguage'),
  1084. ('languagePriority3','user_profil_lang','UserLanguage'),
  1085. ('languagePriority3','user_selected_lang','UserSelectedLanguage'),
  1086. ('languagePriority3','course_lang','CourseLanguage'),
  1087. ('languagePriority4','platform_lang','PlatformLanguage'),
  1088. ('languagePriority4','user_profil_lang','UserLanguage'),
  1089. ('languagePriority4','user_selected_lang','UserSelectedLanguage'),
  1090. ('languagePriority4','course_lang','CourseLanguage'),
  1091. ('activate_send_event_by_mail', 'true', 'Yes'),
  1092. ('activate_send_event_by_mail', 'false', 'No'),
  1093. */
  1094. UNLOCK TABLES;
  1095. /*!40000 ALTER TABLE settings_options ENABLE KEYS */;
  1096. --
  1097. -- Table structure for table sys_announcement
  1098. --
  1099. DROP TABLE IF EXISTS sys_announcement;
  1100. CREATE TABLE sys_announcement (
  1101. id int unsigned NOT NULL auto_increment,
  1102. date_start datetime NOT NULL default '0000-00-00 00:00:00',
  1103. date_end datetime NOT NULL default '0000-00-00 00:00:00',
  1104. visible_teacher tinyint NOT NULL default 0,
  1105. visible_student tinyint NOT NULL default 0,
  1106. visible_guest tinyint NOT NULL default 0,
  1107. title varchar(250) NOT NULL default '',
  1108. content text NOT NULL,
  1109. lang varchar(70) NULL default NULL,
  1110. access_url_id INT NOT NULL default 1,
  1111. PRIMARY KEY (id)
  1112. );
  1113. --
  1114. -- Table structure for shared_survey
  1115. --
  1116. DROP TABLE IF EXISTS shared_survey;
  1117. CREATE TABLE shared_survey (
  1118. survey_id int unsigned NOT NULL auto_increment,
  1119. code varchar(20) default NULL,
  1120. title text default NULL,
  1121. subtitle text default NULL,
  1122. author varchar(250) default NULL,
  1123. lang varchar(20) default NULL,
  1124. template varchar(20) default NULL,
  1125. intro text,
  1126. surveythanks text,
  1127. creation_date datetime NOT NULL default '0000-00-00 00:00:00',
  1128. course_code varchar(40) NOT NULL default '',
  1129. PRIMARY KEY (survey_id),
  1130. UNIQUE KEY id (survey_id)
  1131. );
  1132. -- --------------------------------------------------------
  1133. --
  1134. -- Table structure for shared_survey_question
  1135. --
  1136. DROP TABLE IF EXISTS shared_survey_question;
  1137. CREATE TABLE shared_survey_question (
  1138. question_id int NOT NULL auto_increment,
  1139. survey_id int NOT NULL default '0',
  1140. survey_question text NOT NULL,
  1141. survey_question_comment text NOT NULL,
  1142. type varchar(250) NOT NULL default '',
  1143. display varchar(10) NOT NULL default '',
  1144. sort int NOT NULL default '0',
  1145. code varchar(40) NOT NULL default '',
  1146. max_value int NOT NULL,
  1147. PRIMARY KEY (question_id)
  1148. );
  1149. -- --------------------------------------------------------
  1150. --
  1151. -- Table structure for shared_survey_question_option
  1152. --
  1153. DROP TABLE IF EXISTS shared_survey_question_option;
  1154. CREATE TABLE shared_survey_question_option (
  1155. question_option_id int NOT NULL auto_increment,
  1156. question_id int NOT NULL default '0',
  1157. survey_id int NOT NULL default '0',
  1158. option_text text NOT NULL,
  1159. sort int NOT NULL default '0',
  1160. PRIMARY KEY (question_option_id)
  1161. );
  1162. -- --------------------------------------------------------
  1163. --
  1164. -- Table structure for templates (User's FCKEditor templates)
  1165. --
  1166. DROP TABLE IF EXISTS templates;
  1167. CREATE TABLE templates (
  1168. id int NOT NULL auto_increment,
  1169. title varchar(100) NOT NULL,
  1170. description varchar(250) NOT NULL,
  1171. course_code varchar(40) NOT NULL,
  1172. user_id int NOT NULL,
  1173. ref_doc int NOT NULL,
  1174. image varchar(250) NOT NULL,
  1175. PRIMARY KEY (id)
  1176. );
  1177. --
  1178. -- --------------------------------------------------------
  1179. --
  1180. -- Table structure of openid_association (keep info on openid servers)
  1181. --
  1182. DROP TABLE IF EXISTS openid_association;
  1183. CREATE TABLE IF NOT EXISTS openid_association (
  1184. id int NOT NULL auto_increment,
  1185. idp_endpoint_uri text NOT NULL,
  1186. session_type varchar(30) NOT NULL,
  1187. assoc_handle text NOT NULL,
  1188. assoc_type text NOT NULL,
  1189. expires_in bigint NOT NULL,
  1190. mac_key text NOT NULL,
  1191. created bigint NOT NULL,
  1192. PRIMARY KEY (id)
  1193. );
  1194. --
  1195. -- --------------------------------------------------------
  1196. --
  1197. -- Tables for gradebook
  1198. --
  1199. DROP TABLE IF EXISTS gradebook_category;
  1200. CREATE TABLE gradebook_category (
  1201. id int NOT NULL auto_increment,
  1202. name text NOT NULL,
  1203. description text,
  1204. user_id int NOT NULL,
  1205. course_code varchar(40) default NULL,
  1206. parent_id int default NULL,
  1207. weight smallint NOT NULL,
  1208. visible tinyint NOT NULL,
  1209. certif_min_score int DEFAULT NULL,
  1210. session_id int DEFAULT NULL,
  1211. document_id int unsigned DEFAULT NULL,
  1212. PRIMARY KEY (id)
  1213. );
  1214. DROP TABLE IF EXISTS gradebook_evaluation;
  1215. CREATE TABLE gradebook_evaluation (
  1216. id int unsigned NOT NULL auto_increment,
  1217. name text NOT NULL,
  1218. description text,
  1219. user_id int NOT NULL,
  1220. course_code varchar(40) default NULL,
  1221. category_id int default NULL,
  1222. created_at DATETIME NOT NULL default '0000-00-00 00:00:00',
  1223. weight smallint NOT NULL,
  1224. max float unsigned NOT NULL,
  1225. visible tinyint NOT NULL,
  1226. type varchar(40) NOT NULL default 'evaluation',
  1227. locked int NOT NULL DEFAULT 0,
  1228. PRIMARY KEY (id)
  1229. );
  1230. DROP TABLE IF EXISTS gradebook_link;
  1231. CREATE TABLE gradebook_link (
  1232. id int NOT NULL auto_increment,
  1233. type int NOT NULL,
  1234. ref_id int NOT NULL,
  1235. user_id int NOT NULL,
  1236. course_code varchar(40) NOT NULL,
  1237. category_id int NOT NULL,
  1238. created_at DATETIME NOT NULL default '0000-00-00 00:00:00',
  1239. weight smallint NOT NULL,
  1240. visible tinyint NOT NULL,
  1241. PRIMARY KEY (id)
  1242. );
  1243. DROP TABLE IF EXISTS gradebook_result;
  1244. CREATE TABLE gradebook_result (
  1245. id int NOT NULL auto_increment,
  1246. user_id int NOT NULL,
  1247. evaluation_id int NOT NULL,
  1248. created_at DATETIME NOT NULL default '0000-00-00 00:00:00',
  1249. score float unsigned default NULL,
  1250. PRIMARY KEY (id)
  1251. );
  1252. DROP TABLE IF EXISTS gradebook_score_display;
  1253. CREATE TABLE gradebook_score_display (
  1254. id int NOT NULL auto_increment,
  1255. score float unsigned NOT NULL,
  1256. display varchar(40) NOT NULL,
  1257. category_id int NOT NULL default 0,
  1258. score_color_percent float unsigned NOT NULL default 0,
  1259. PRIMARY KEY (id)
  1260. );
  1261. ALTER TABLE gradebook_score_display ADD INDEX(category_id);
  1262. DROP TABLE IF EXISTS user_field;
  1263. CREATE TABLE user_field (
  1264. id INT NOT NULL auto_increment,
  1265. field_type int NOT NULL DEFAULT 1,
  1266. field_variable varchar(64) NOT NULL,
  1267. field_display_text varchar(64),
  1268. field_default_value text,
  1269. field_order int,
  1270. field_visible tinyint default 0,
  1271. field_changeable tinyint default 0,
  1272. field_filter tinyint default 0,
  1273. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  1274. PRIMARY KEY(id)
  1275. );
  1276. DROP TABLE IF EXISTS user_field_options;
  1277. CREATE TABLE user_field_options (
  1278. id int NOT NULL auto_increment,
  1279. field_id int NOT NULL,
  1280. option_value text,
  1281. option_display_text varchar(64),
  1282. option_order int,
  1283. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  1284. PRIMARY KEY (id)
  1285. );
  1286. DROP TABLE IF EXISTS user_field_values;
  1287. CREATE TABLE user_field_values(
  1288. id bigint NOT NULL auto_increment,
  1289. user_id int unsigned NOT NULL,
  1290. field_id int NOT NULL,
  1291. field_value text,
  1292. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  1293. PRIMARY KEY(id)
  1294. );
  1295. ALTER TABLE user_field_values ADD INDEX (user_id, field_id);
  1296. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (1, 'legal_accept','Legal',0,0);
  1297. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (1, 'already_logged_in','Already logged in',0,0);
  1298. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (1, 'update_type','Update script type',0,0);
  1299. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (10, 'tags','tags',0,0);
  1300. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (1, 'rssfeeds','RSS',0,0);
  1301. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (1, 'dashboard', 'Dashboard', 0, 0);
  1302. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable) VALUES (11, 'timezone', 'Timezone', 0, 0);
  1303. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable, field_default_value) values (4, 'mail_notify_invitation', 'MailNotifyInvitation',1,1,'1');
  1304. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable, field_default_value) values (4, 'mail_notify_message', 'MailNotifyMessage',1,1,'1');
  1305. INSERT INTO user_field (field_type, field_variable, field_display_text, field_visible, field_changeable, field_default_value) values (4, 'mail_notify_group_message','MailNotifyGroupMessage',1,1,'1');
  1306. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (8, '1', 'AtOnce',1);
  1307. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (8, '8', 'Daily',2);
  1308. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (8, '0', 'No',3);
  1309. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (9, '1', 'AtOnce',1);
  1310. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (9, '8', 'Daily',2);
  1311. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (9, '0', 'No',3);
  1312. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (10, '1', 'AtOnce',1);
  1313. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (10, '8', 'Daily',2);
  1314. INSERT INTO user_field_options (field_id, option_value, option_display_text, option_order) values (10, '0', 'No',3);
  1315. DROP TABLE IF EXISTS gradebook_result_log;
  1316. CREATE TABLE gradebook_result_log (
  1317. id int NOT NULL auto_increment,
  1318. id_result int NOT NULL,
  1319. user_id int NOT NULL,
  1320. evaluation_id int NOT NULL,
  1321. created_at DATETIME NOT NULL default '0000-00-00 00:00:00',
  1322. score float unsigned default NULL,
  1323. PRIMARY KEY(id)
  1324. );
  1325. DROP TABLE IF EXISTS gradebook_linkeval_log;
  1326. CREATE TABLE gradebook_linkeval_log (
  1327. id int NOT NULL auto_increment,
  1328. id_linkeval_log int NOT NULL,
  1329. name text,
  1330. description text,
  1331. created_at DATETIME NOT NULL default '0000-00-00 00:00:00',
  1332. weight smallint default NULL,
  1333. visible tinyint default NULL,
  1334. type varchar(20) NOT NULL,
  1335. user_id_log int NOT NULL,
  1336. PRIMARY KEY (id)
  1337. );
  1338. --
  1339. -- --------------------------------------------------------
  1340. --
  1341. -- Tables for the access URL feature
  1342. --
  1343. DROP TABLE IF EXISTS access_url;
  1344. CREATE TABLE access_url(
  1345. id int unsigned NOT NULL auto_increment,
  1346. url varchar(255) NOT NULL,
  1347. description text,
  1348. active int unsigned not null default 0,
  1349. created_by int not null,
  1350. tms DATETIME NOT NULL default '0000-00-00 00:00:00',
  1351. PRIMARY KEY (id)
  1352. );
  1353. INSERT INTO access_url(url, description, active, created_by) VALUES ('http://localhost/',' ',1,1);
  1354. DROP TABLE IF EXISTS access_url_rel_user;
  1355. CREATE TABLE access_url_rel_user (
  1356. access_url_id int unsigned NOT NULL,
  1357. user_id int unsigned NOT NULL,
  1358. PRIMARY KEY (access_url_id, user_id)
  1359. );
  1360. ALTER TABLE access_url_rel_user ADD INDEX idx_access_url_rel_user_user (user_id);
  1361. ALTER TABLE access_url_rel_user ADD INDEX idx_access_url_rel_user_access_url(access_url_id);
  1362. ALTER TABLE access_url_rel_user ADD INDEX idx_access_url_rel_user_access_url_user (user_id,access_url_id);
  1363. DROP TABLE IF EXISTS access_url_rel_course;
  1364. CREATE TABLE access_url_rel_course (
  1365. access_url_id int unsigned NOT NULL,
  1366. course_code char(40) NOT NULL,
  1367. PRIMARY KEY (access_url_id, course_code)
  1368. );
  1369. DROP TABLE IF EXISTS access_url_rel_session;
  1370. CREATE TABLE access_url_rel_session (
  1371. access_url_id int unsigned NOT NULL,
  1372. session_id int unsigned NOT NULL,
  1373. PRIMARY KEY (access_url_id, session_id)
  1374. );
  1375. --
  1376. -- Table structure for table sys_calendar
  1377. --
  1378. CREATE TABLE IF NOT EXISTS sys_calendar (
  1379. id int unsigned NOT NULL auto_increment,
  1380. title varchar(255) NOT NULL,
  1381. content text,
  1382. start_date datetime NOT NULL default '0000-00-00 00:00:00',
  1383. end_date datetime NOT NULL default '0000-00-00 00:00:00',
  1384. access_url_id INT NOT NULL default 1,
  1385. all_day INT NOT NULL DEFAULT 0,
  1386. PRIMARY KEY (id)
  1387. );
  1388. CREATE TABLE IF NOT EXISTS system_template (
  1389. id int UNSIGNED NOT NULL auto_increment,
  1390. title varchar(250) NOT NULL,
  1391. comment text NOT NULL,
  1392. image varchar(250) NOT NULL,
  1393. content text NOT NULL,
  1394. PRIMARY KEY (id)
  1395. );
  1396. -- Adding the platform templates
  1397. INSERT INTO system_template (title, comment, image, content) VALUES
  1398. ('TemplateTitleCourseTitle', 'TemplateTitleCourseTitleDescription', 'coursetitle.gif', '
  1399. <head>
  1400. {CSS}
  1401. <style type="text/css">
  1402. .gris_title {
  1403. color: silver;
  1404. }
  1405. h1
  1406. {
  1407. text-align: right;
  1408. }
  1409. </style>
  1410. </head>
  1411. <body>
  1412. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1413. <tbody>
  1414. <tr>
  1415. <td style="vertical-align: middle; width: 50%;" colspan="1" rowspan="1">
  1416. <h1>TITULUS 1<br>
  1417. <span class="gris_title">TITULUS 2</span><br>
  1418. </h1>
  1419. </td>
  1420. <td style="width: 50%;">
  1421. <img style="width: 100px; height: 100px;" alt="dokeos logo" src="{COURSE_DIR}images/logo_dokeos.png"></td>
  1422. </tr>
  1423. </tbody>
  1424. </table>
  1425. <p><br>
  1426. <br>
  1427. </p>
  1428. </body>
  1429. ');
  1430. /*
  1431. INSERT INTO system_template (title, comment, image, content) VALUES
  1432. ('TemplateTitleCheckList', 'TemplateTitleCheckListDescription', 'checklist.gif', '
  1433. <head>
  1434. {CSS}
  1435. </head>
  1436. <body>
  1437. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1438. <tbody>
  1439. <tr>
  1440. <td style="vertical-align: top; width: 66%;">
  1441. <h3>Lorem ipsum dolor sit amet</h3>
  1442. <ul>
  1443. <li>consectetur adipisicing elit</li>
  1444. <li>sed do eiusmod tempor incididunt</li>
  1445. <li>ut labore et dolore magna aliqua</li>
  1446. </ul>
  1447. <h3>Ut enim ad minim veniam</h3>
  1448. <ul>
  1449. <li>quis nostrud exercitation ullamco</li>
  1450. <li>laboris nisi ut aliquip ex ea commodo consequat</li>
  1451. <li>Excepteur sint occaecat cupidatat non proident</li>
  1452. </ul>
  1453. <h3>Sed ut perspiciatis unde omnis</h3>
  1454. <ul>
  1455. <li>iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam</li>
  1456. <li>eaque ipsa quae ab illo inventore veritatis</li>
  1457. <li>et quasi architecto beatae vitae dicta sunt explicabo.&nbsp;</li>
  1458. </ul>
  1459. </td>
  1460. <td style="background: transparent url({IMG_DIR}postit.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 33%; text-align: center; vertical-align: bottom;">
  1461. <h3>Ut enim ad minima</h3>
  1462. Veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur.<br>
  1463. <h3>
  1464. <img style="width: 180px; height: 144px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_smile.png "><br></h3>
  1465. </td>
  1466. </tr>
  1467. </tbody>
  1468. </table>
  1469. <p><br>
  1470. <br>
  1471. </p>
  1472. </body>
  1473. ');
  1474. */
  1475. INSERT INTO system_template (title, comment, image, content) VALUES
  1476. ('TemplateTitleTeacher', 'TemplateTitleTeacherDescription', 'yourinstructor.gif', '
  1477. <head>
  1478. {CSS}
  1479. <style type="text/css">
  1480. .text
  1481. {
  1482. font-weight: normal;
  1483. }
  1484. </style>
  1485. </head>
  1486. <body>
  1487. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1488. <tbody>
  1489. <tr>
  1490. <td></td>
  1491. <td style="height: 33%;"></td>
  1492. <td></td>
  1493. </tr>
  1494. <tr>
  1495. <td style="width: 25%;"></td>
  1496. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right; font-weight: bold;" colspan="1" rowspan="1">
  1497. <span class="text">
  1498. <br>
  1499. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis pellentesque.</span>
  1500. </td>
  1501. <td style="width: 25%; font-weight: bold;">
  1502. <img style="width: 180px; height: 241px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_case.png "></td>
  1503. </tr>
  1504. </tbody>
  1505. </table>
  1506. <p><br>
  1507. <br>
  1508. </p>
  1509. </body>
  1510. ');
  1511. INSERT INTO system_template (title, comment, image, content) VALUES
  1512. ('TemplateTitleLeftList', 'TemplateTitleListLeftListDescription', 'leftlist.gif', '
  1513. <head>
  1514. {CSS}
  1515. </head>
  1516. <body>
  1517. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1518. <tbody>
  1519. <tr>
  1520. <td style="width: 66%;"></td>
  1521. <td style="vertical-align: bottom; width: 33%;" colspan="1" rowspan="4">&nbsp;<img style="width: 180px; height: 248px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_reads.png "><br>
  1522. </td>
  1523. </tr>
  1524. <tr align="right">
  1525. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">Lorem
  1526. ipsum dolor sit amet.
  1527. </td>
  1528. </tr>
  1529. <tr align="right">
  1530. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1531. Vivamus
  1532. a quam.&nbsp;<br>
  1533. </td>
  1534. </tr>
  1535. <tr align="right">
  1536. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1537. Proin
  1538. a est stibulum ante ipsum.</td>
  1539. </tr>
  1540. </tbody>
  1541. </table>
  1542. <p><br>
  1543. <br>
  1544. </p>
  1545. </body>
  1546. ');
  1547. INSERT INTO system_template (title, comment, image, content) VALUES
  1548. ('TemplateTitleLeftRightList', 'TemplateTitleLeftRightListDescription', 'leftrightlist.gif', '
  1549. <head>
  1550. {CSS}
  1551. </head>
  1552. <body>
  1553. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; height: 400px; width: 720px;" border="0" cellpadding="15" cellspacing="6">
  1554. <tbody>
  1555. <tr>
  1556. <td></td>
  1557. <td style="vertical-align: top;" colspan="1" rowspan="4">&nbsp;<img style="width: 180px; height: 294px;" alt="Trainer" src="{COURSE_DIR}images/trainer/trainer_join_hands.png "><br>
  1558. </td>
  1559. <td></td>
  1560. </tr>
  1561. <tr>
  1562. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">Lorem
  1563. ipsum dolor sit amet.
  1564. </td>
  1565. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: left;">
  1566. Convallis
  1567. ut.&nbsp;Cras dui magna.</td>
  1568. </tr>
  1569. <tr>
  1570. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">
  1571. Vivamus
  1572. a quam.&nbsp;<br>
  1573. </td>
  1574. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: left;">
  1575. Etiam
  1576. lacinia stibulum ante.<br>
  1577. </td>
  1578. </tr>
  1579. <tr>
  1580. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">
  1581. Proin
  1582. a est stibulum ante ipsum.</td>
  1583. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: left;">
  1584. Consectetuer
  1585. adipiscing elit. <br>
  1586. </td>
  1587. </tr>
  1588. </tbody>
  1589. </table>
  1590. <p><br>
  1591. <br>
  1592. </p>
  1593. </body>
  1594. ');
  1595. INSERT INTO system_template (title, comment, image, content) VALUES
  1596. ('TemplateTitleRightList', 'TemplateTitleRightListDescription', 'rightlist.gif', '
  1597. <head>
  1598. {CSS}
  1599. </head>
  1600. <body style="direction: ltr;">
  1601. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1602. <tbody>
  1603. <tr>
  1604. <td style="vertical-align: bottom; width: 50%;" colspan="1" rowspan="4"><img style="width: 300px; height: 199px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_points_right.png"><br>
  1605. </td>
  1606. <td style="width: 50%;"></td>
  1607. </tr>
  1608. <tr>
  1609. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 50%;">
  1610. Convallis
  1611. ut.&nbsp;Cras dui magna.</td>
  1612. </tr>
  1613. <tr>
  1614. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 50%;">
  1615. Etiam
  1616. lacinia.<br>
  1617. </td>
  1618. </tr>
  1619. <tr>
  1620. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 50%;">
  1621. Consectetuer
  1622. adipiscing elit. <br>
  1623. </td>
  1624. </tr>
  1625. </tbody>
  1626. </table>
  1627. <p><br>
  1628. <br>
  1629. </p>
  1630. </body>
  1631. ');
  1632. /*
  1633. INSERT INTO system_template (title, comment, image, content) VALUES
  1634. ('TemplateTitleComparison', 'TemplateTitleComparisonDescription', 'compare.gif', '
  1635. <head>
  1636. {CSS}
  1637. </head>
  1638. <body>
  1639. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1640. <tr>
  1641. <td style="height: 10%; width: 33%;"></td>
  1642. <td style="vertical-align: top; width: 33%;" colspan="1" rowspan="2">&nbsp;<img style="width: 180px; height: 271px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_standing.png "><br>
  1643. </td>
  1644. <td style="height: 10%; width: 33%;"></td>
  1645. </tr>
  1646. <tr>
  1647. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">
  1648. Lorem ipsum dolor sit amet.
  1649. </td>
  1650. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 33%;">
  1651. Convallis
  1652. ut.&nbsp;Cras dui magna.</td>
  1653. </tr>
  1654. </body>
  1655. ');
  1656. */
  1657. INSERT INTO system_template (title, comment, image, content) VALUES
  1658. ('TemplateTitleDiagram', 'TemplateTitleDiagramDescription', 'diagram.gif', '
  1659. <head>
  1660. {CSS}
  1661. </head>
  1662. <body>
  1663. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1664. <tbody>
  1665. <tr>
  1666. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; height: 33%; width: 33%;">
  1667. <br>
  1668. Etiam
  1669. lacinia stibulum ante.
  1670. Convallis
  1671. ut.&nbsp;Cras dui magna.</td>
  1672. <td colspan="1" rowspan="3">
  1673. <img style="width: 350px; height: 267px;" alt="Alaska chart" src="{COURSE_DIR}images/diagrams/alaska_chart.png "></td>
  1674. </tr>
  1675. <tr>
  1676. <td colspan="1" rowspan="1">
  1677. <img style="width: 300px; height: 199px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_points_right.png "></td>
  1678. </tr>
  1679. <tr>
  1680. </tr>
  1681. </tbody>
  1682. </table>
  1683. <p><br>
  1684. <br>
  1685. </p>
  1686. </body>
  1687. ');
  1688. INSERT INTO system_template (title, comment, image, content) VALUES
  1689. ('TemplateTitleDesc', 'TemplateTitleCheckListDescription', 'description.gif', '
  1690. <head>
  1691. {CSS}
  1692. </head>
  1693. <body>
  1694. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1695. <tbody>
  1696. <tr>
  1697. <td style="width: 50%; vertical-align: top;">
  1698. <img style="width: 48px; height: 49px; float: left;" alt="01" src="{COURSE_DIR}images/small/01.png " hspace="5"><br>Lorem ipsum dolor sit amet<br><br><br>
  1699. <img style="width: 48px; height: 49px; float: left;" alt="02" src="{COURSE_DIR}images/small/02.png " hspace="5">
  1700. <br>Ut enim ad minim veniam<br><br><br>
  1701. <img style="width: 48px; height: 49px; float: left;" alt="03" src="{COURSE_DIR}images/small/03.png " hspace="5">Duis aute irure dolor in reprehenderit<br><br><br>
  1702. <img style="width: 48px; height: 49px; float: left;" alt="04" src="{COURSE_DIR}images/small/04.png " hspace="5">Neque porro quisquam est</td>
  1703. <td style="vertical-align: top; width: 50%; text-align: right;" colspan="1" rowspan="1">
  1704. <img style="width: 300px; height: 291px;" alt="Gearbox" src="{COURSE_DIR}images/diagrams/gearbox.jpg "><br></td>
  1705. </tr><tr></tr>
  1706. </tbody>
  1707. </table>
  1708. <p><br>
  1709. <br>
  1710. </p>
  1711. </body>
  1712. ');
  1713. /*
  1714. INSERT INTO system_template (title, comment, image, content) VALUES
  1715. ('TemplateTitleObjectives', 'TemplateTitleObjectivesDescription', 'courseobjectives.gif', '
  1716. <head>
  1717. {CSS}
  1718. </head>
  1719. <body>
  1720. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1721. <tbody>
  1722. <tr>
  1723. <td style="vertical-align: bottom; width: 33%;" colspan="1" rowspan="2">
  1724. <img style="width: 180px; height: 271px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_chair.png "><br>
  1725. </td>
  1726. <td style="height: 10%; width: 66%;"></td>
  1727. </tr>
  1728. <tr>
  1729. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 66%;">
  1730. <h3>Lorem ipsum dolor sit amet</h3>
  1731. <ul>
  1732. <li>consectetur adipisicing elit</li>
  1733. <li>sed do eiusmod tempor incididunt</li>
  1734. <li>ut labore et dolore magna aliqua</li>
  1735. </ul>
  1736. <h3>Ut enim ad minim veniam</h3>
  1737. <ul>
  1738. <li>quis nostrud exercitation ullamco</li>
  1739. <li>laboris nisi ut aliquip ex ea commodo consequat</li>
  1740. <li>Excepteur sint occaecat cupidatat non proident</li>
  1741. </ul>
  1742. </td>
  1743. </tr>
  1744. </tbody>
  1745. </table>
  1746. <p><br>
  1747. <br>
  1748. </p>
  1749. </body>
  1750. ');
  1751. */
  1752. INSERT INTO system_template (title, comment, image, content) VALUES
  1753. ('TemplateTitleCycle', 'TemplateTitleCycleDescription', 'cyclechart.gif', '
  1754. <head>
  1755. {CSS}
  1756. <style>
  1757. .title
  1758. {
  1759. color: white; font-weight: bold;
  1760. }
  1761. </style>
  1762. </head>
  1763. <body>
  1764. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="8" cellspacing="6">
  1765. <tbody>
  1766. <tr>
  1767. <td style="text-align: center; vertical-align: bottom; height: 10%;" colspan="3" rowspan="1">
  1768. <img style="width: 250px; height: 76px;" alt="arrow" src="{COURSE_DIR}images/diagrams/top_arrow.png ">
  1769. </td>
  1770. </tr>
  1771. <tr>
  1772. <td style="height: 5%; width: 45%; vertical-align: top; background-color: rgb(153, 153, 153); text-align: center;">
  1773. <span class="title">Lorem ipsum</span>
  1774. </td>
  1775. <td style="height: 5%; width: 10%;"></td>
  1776. <td style="height: 5%; vertical-align: top; background-color: rgb(153, 153, 153); text-align: center;">
  1777. <span class="title">Sed ut perspiciatis</span>
  1778. </td>
  1779. </tr>
  1780. <tr>
  1781. <td style="background-color: rgb(204, 204, 255); width: 45%; vertical-align: top;">
  1782. <ul>
  1783. <li>dolor sit amet</li>
  1784. <li>consectetur adipisicing elit</li>
  1785. <li>sed do eiusmod tempor&nbsp;</li>
  1786. <li>adipisci velit, sed quia non numquam</li>
  1787. <li>eius modi tempora incidunt ut labore et dolore magnam</li>
  1788. </ul>
  1789. </td>
  1790. <td style="width: 10%;"></td>
  1791. <td style="background-color: rgb(204, 204, 255); width: 45%; vertical-align: top;">
  1792. <ul>
  1793. <li>ut enim ad minim veniam</li>
  1794. <li>quis nostrud exercitation</li><li>ullamco laboris nisi ut</li>
  1795. <li> Quis autem vel eum iure reprehenderit qui in ea</li>
  1796. <li>voluptate velit esse quam nihil molestiae consequatur,</li>
  1797. </ul>
  1798. </td>
  1799. </tr>
  1800. <tr align="center">
  1801. <td style="height: 10%; vertical-align: top;" colspan="3" rowspan="1">
  1802. <img style="width: 250px; height: 76px;" alt="arrow" src="{COURSE_DIR}images/diagrams/bottom_arrow.png ">&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;
  1803. </td>
  1804. </tr>
  1805. </tbody>
  1806. </table>
  1807. <p><br>
  1808. <br>
  1809. </p>
  1810. </body>
  1811. ');
  1812. /*
  1813. INSERT INTO system_template (title, comment, image, content) VALUES
  1814. ('TemplateTitleLearnerWonder', 'TemplateTitleLearnerWonderDescription', 'learnerwonder.gif', '
  1815. <head>
  1816. {CSS}
  1817. </head>
  1818. <body>
  1819. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1820. <tbody>
  1821. <tr>
  1822. <td style="width: 33%;" colspan="1" rowspan="4">
  1823. <img style="width: 120px; height: 348px;" alt="learner wonders" src="{COURSE_DIR}images/silhouette.png "><br>
  1824. </td>
  1825. <td style="width: 66%;"></td>
  1826. </tr>
  1827. <tr align="center">
  1828. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1829. Convallis
  1830. ut.&nbsp;Cras dui magna.</td>
  1831. </tr>
  1832. <tr align="center">
  1833. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1834. Etiam
  1835. lacinia stibulum ante.<br>
  1836. </td>
  1837. </tr>
  1838. <tr align="center">
  1839. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1840. Consectetuer
  1841. adipiscing elit. <br>
  1842. </td>
  1843. </tr>
  1844. </tbody>
  1845. </table>
  1846. <p><br>
  1847. <br>
  1848. </p>
  1849. </body>
  1850. ');
  1851. */
  1852. INSERT INTO system_template (title, comment, image, content) VALUES
  1853. ('TemplateTitleTimeline', 'TemplateTitleTimelineDescription', 'phasetimeline.gif', '
  1854. <head>
  1855. {CSS}
  1856. <style>
  1857. .title
  1858. {
  1859. font-weight: bold; text-align: center;
  1860. }
  1861. </style>
  1862. </head>
  1863. <body>
  1864. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="8" cellspacing="5">
  1865. <tbody>
  1866. <tr class="title">
  1867. <td style="vertical-align: top; height: 3%; background-color: rgb(224, 224, 224);">Lorem ipsum</td>
  1868. <td style="height: 3%;"></td>
  1869. <td style="vertical-align: top; height: 3%; background-color: rgb(237, 237, 237);">Perspiciatis</td>
  1870. <td style="height: 3%;"></td>
  1871. <td style="vertical-align: top; height: 3%; background-color: rgb(245, 245, 245);">Nemo enim</td>
  1872. </tr>
  1873. <tr>
  1874. <td style="vertical-align: top; width: 30%; background-color: rgb(224, 224, 224);">
  1875. <ul>
  1876. <li>dolor sit amet</li>
  1877. <li>consectetur</li>
  1878. <li>adipisicing elit</li>
  1879. </ul>
  1880. <br>
  1881. </td>
  1882. <td>
  1883. <img style="width: 32px; height: 32px;" alt="arrow" src="{COURSE_DIR}images/small/arrow.png ">
  1884. </td>
  1885. <td style="vertical-align: top; width: 30%; background-color: rgb(237, 237, 237);">
  1886. <ul>
  1887. <li>ut labore</li>
  1888. <li>et dolore</li>
  1889. <li>magni dolores</li>
  1890. </ul>
  1891. </td>
  1892. <td>
  1893. <img style="width: 32px; height: 32px;" alt="arrow" src="{COURSE_DIR}images/small/arrow.png ">
  1894. </td>
  1895. <td style="vertical-align: top; background-color: rgb(245, 245, 245); width: 30%;">
  1896. <ul>
  1897. <li>neque porro</li>
  1898. <li>quisquam est</li>
  1899. <li>qui dolorem&nbsp;&nbsp;</li>
  1900. </ul>
  1901. <br><br>
  1902. </td>
  1903. </tr>
  1904. </tbody>
  1905. </table>
  1906. <p><br>
  1907. <br>
  1908. </p>
  1909. </body>
  1910. ');
  1911. /*
  1912. INSERT INTO system_template (title, comment, image, content) VALUES
  1913. ('TemplateTitleStopAndThink', 'TemplateTitleStopAndThinkDescription', 'stopthink.gif', '
  1914. <head>
  1915. {CSS}
  1916. </head>
  1917. <body>
  1918. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1919. <tbody>
  1920. <tr>
  1921. <td style="vertical-align: bottom; width: 33%;" colspan="1" rowspan="2">
  1922. <img style="width: 180px; height: 169px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_staring.png ">
  1923. <br>
  1924. </td>
  1925. <td style="height: 10%; width: 66%;"></td>
  1926. </tr>
  1927. <tr>
  1928. <td style="background: transparent url({IMG_DIR}postit.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 66%; vertical-align: middle; text-align: center;">
  1929. <h3>Attentio sectetur adipisicing elit</h3>
  1930. <ul>
  1931. <li>sed do eiusmod tempor incididunt</li>
  1932. <li>ut labore et dolore magna aliqua</li>
  1933. <li>quis nostrud exercitation ullamco</li>
  1934. </ul><br></td>
  1935. </tr>
  1936. </tbody>
  1937. </table>
  1938. <p><br>
  1939. <br>
  1940. </p>
  1941. </body>
  1942. ');
  1943. */
  1944. INSERT INTO system_template (title, comment, image, content) VALUES
  1945. ('TemplateTitleTable', 'TemplateTitleCheckListDescription', 'table.gif', '
  1946. <head>
  1947. {CSS}
  1948. <style type="text/css">
  1949. .title
  1950. {
  1951. font-weight: bold; text-align: center;
  1952. }
  1953. .items
  1954. {
  1955. text-align: right;
  1956. }
  1957. </style>
  1958. </head>
  1959. <body>
  1960. <br />
  1961. <h2>A table</h2>
  1962. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px;" border="1" cellpadding="5" cellspacing="0">
  1963. <tbody>
  1964. <tr class="title">
  1965. <td>City</td>
  1966. <td>2005</td>
  1967. <td>2006</td>
  1968. <td>2007</td>
  1969. <td>2008</td>
  1970. </tr>
  1971. <tr class="items">
  1972. <td>Lima</td>
  1973. <td>10,40</td>
  1974. <td>8,95</td>
  1975. <td>9,19</td>
  1976. <td>9,76</td>
  1977. </tr>
  1978. <tr class="items">
  1979. <td>New York</td>
  1980. <td>18,39</td>
  1981. <td>17,52</td>
  1982. <td>16,57</td>
  1983. <td>16,60</td>
  1984. </tr>
  1985. <tr class="items">
  1986. <td>Barcelona</td>
  1987. <td>0,10</td>
  1988. <td>0,10</td>
  1989. <td>0,05</td>
  1990. <td>0,05</td>
  1991. </tr>
  1992. <tr class="items">
  1993. <td>Paris</td>
  1994. <td>3,38</td>
  1995. <td >3,63</td>
  1996. <td>3,63</td>
  1997. <td>3,54</td>
  1998. </tr>
  1999. </tbody>
  2000. </table>
  2001. <br>
  2002. </body>
  2003. ');
  2004. INSERT INTO system_template (title, comment, image, content) VALUES
  2005. ('TemplateTitleAudio', 'TemplateTitleAudioDescription', 'audiocomment.gif', '
  2006. <head>
  2007. {CSS}
  2008. </head>
  2009. <body>
  2010. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  2011. <tbody>
  2012. <tr>
  2013. <td>
  2014. <div align="center">
  2015. <span style="text-align: center;">
  2016. <embed type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" width="300" height="20" bgcolor="#FFFFFF" src="{REL_PATH}main/inc/lib/mediaplayer/player.swf" allowfullscreen="false" allowscriptaccess="always" flashvars="file={COURSE_DIR}audio/ListeningComprehension.mp3&amp;autostart=true"></embed>
  2017. </span></div>
  2018. <br>
  2019. </td>
  2020. <td colspan="1" rowspan="3"><br>
  2021. <img style="width: 300px; height: 341px; float: right;" alt="image" src="{COURSE_DIR}images/diagrams/head_olfactory_nerve.png "><br></td>
  2022. </tr>
  2023. <tr>
  2024. <td colspan="1" rowspan="1">
  2025. <img style="width: 180px; height: 271px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_glasses.png"><br></td>
  2026. </tr>
  2027. <tr>
  2028. </tr>
  2029. </tbody>
  2030. </table>
  2031. <p><br>
  2032. <br>
  2033. </p>
  2034. </body>
  2035. ');
  2036. INSERT INTO system_template (title, comment, image, content) VALUES
  2037. ('TemplateTitleVideo', 'TemplateTitleVideoDescription', 'video.gif', '
  2038. <head>
  2039. {CSS}
  2040. </head>
  2041. <body>
  2042. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  2043. <tbody>
  2044. <tr>
  2045. <td style="width: 50%; vertical-align: top;">
  2046. <div style="text-align: center;" id="player810625-parent">
  2047. <div style="border-style: none; overflow: hidden; width: 320px; height: 240px; background-color: rgb(220, 220, 220);">
  2048. <div id="player810625">
  2049. <div id="player810625-config" style="overflow: hidden; display: none; visibility: hidden; width: 0px; height: 0px;">url={REL_PATH}main/default_course_document/video/flv/example.flv width=320 height=240 loop=false play=false downloadable=false fullscreen=true displayNavigation=true displayDigits=true align=left dispPlaylist=none playlistThumbs=false</div>
  2050. </div>
  2051. <embed
  2052. type="application/x-shockwave-flash"
  2053. src="{REL_PATH}main/inc/lib/mediaplayer/player.swf"
  2054. width="320"
  2055. height="240"
  2056. id="single"
  2057. name="single"
  2058. quality="high"
  2059. allowfullscreen="true"
  2060. flashvars="width=320&height=240&autostart=false&file={REL_PATH}main/default_course_document/video/flv/example.flv&repeat=false&image=&showdownload=false&link={REL_PATH}main/default_course_document/video/flv/example.flv&showdigits=true&shownavigation=true&logo="
  2061. />
  2062. </div>
  2063. </div>
  2064. </td>
  2065. <td style="background: transparent url({IMG_DIR}faded_grey.png) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 50%;">
  2066. <h3><br>
  2067. </h3>
  2068. <h3>Lorem ipsum dolor sit amet</h3>
  2069. <ul>
  2070. <li>consectetur adipisicing elit</li>
  2071. <li>sed do eiusmod tempor incididunt</li>
  2072. <li>ut labore et dolore magna aliqua</li>
  2073. </ul>
  2074. <h3>Ut enim ad minim veniam</h3>
  2075. <ul>
  2076. <li>quis nostrud exercitation ullamco</li>
  2077. <li>laboris nisi ut aliquip ex ea commodo consequat</li>
  2078. <li>Excepteur sint occaecat cupidatat non proident</li>
  2079. </ul>
  2080. </td>
  2081. </tr>
  2082. </tbody>
  2083. </table>
  2084. <p><br>
  2085. <br>
  2086. </p>
  2087. <style type="text/css">body{}</style><!-- to fix a strange bug appearing with firefox when editing this template -->
  2088. </body>
  2089. ');
  2090. INSERT INTO system_template (title, comment, image, content) VALUES
  2091. ('TemplateTitleFlash', 'TemplateTitleFlashDescription', 'flash.gif', '
  2092. <head>
  2093. {CSS}
  2094. </head>
  2095. <body>
  2096. <center>
  2097. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 100%; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  2098. <tbody>
  2099. <tr>
  2100. <td align="center">
  2101. <embed width="700" height="300" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" src="{COURSE_DIR}flash/SpinEchoSequence.swf" play="true" loop="true" menu="true"></embed></span><br />
  2102. </td>
  2103. </tr>
  2104. </tbody>
  2105. </table>
  2106. <p><br>
  2107. <br>
  2108. </p>
  2109. </center>
  2110. </body>
  2111. ');
  2112. --
  2113. -- --------------------------------------------------------
  2114. --
  2115. -- Tables for reservation
  2116. --
  2117. --
  2118. -- Table structure for table reservation category
  2119. --
  2120. CREATE TABLE reservation_category (
  2121. id int unsigned NOT NULL auto_increment,
  2122. parent_id int NOT NULL default 0,
  2123. name varchar(128) NOT NULL default '',
  2124. PRIMARY KEY ( id )
  2125. );
  2126. -- --------------------------------------------------------
  2127. --
  2128. -- Table structure for table reservation category_rights
  2129. --
  2130. CREATE TABLE reservation_category_rights (
  2131. category_id int NOT NULL default 0,
  2132. class_id int NOT NULL default 0,
  2133. m_items tinyint NOT NULL default 0
  2134. );
  2135. -- --------------------------------------------------------
  2136. --
  2137. -- Table structure for table item reservation
  2138. --
  2139. CREATE TABLE reservation_item (
  2140. id int unsigned NOT NULL auto_increment,
  2141. category_id int unsigned NOT NULL default 0,
  2142. course_code varchar(40) NOT NULL default '',
  2143. name varchar(128) NOT NULL default '',
  2144. description text NOT NULL,
  2145. blackout tinyint NOT NULL default 0,
  2146. creator int unsigned NOT NULL default 0,
  2147. always_available TINYINT NOT NULL default 0,
  2148. PRIMARY KEY ( id )
  2149. );
  2150. -- --------------------------------------------------------
  2151. --
  2152. -- Table structure for table reservation item_rights
  2153. --
  2154. CREATE TABLE reservation_item_rights (
  2155. item_id int unsigned NOT NULL default 0,
  2156. class_id int unsigned NOT NULL default 0,
  2157. edit_right tinyint unsigned NOT NULL default 0,
  2158. delete_right tinyint unsigned NOT NULL default 0,
  2159. m_reservation tinyint unsigned NOT NULL default 0,
  2160. view_right tinyint NOT NULL default 0,
  2161. PRIMARY KEY ( item_id , class_id )
  2162. );
  2163. -- --------------------------------------------------------
  2164. --
  2165. -- Table structure for main reservation table
  2166. --
  2167. CREATE TABLE reservation_main (
  2168. id int unsigned NOT NULL auto_increment,
  2169. subid int unsigned NOT NULL default 0,
  2170. item_id int unsigned NOT NULL default 0,
  2171. auto_accept tinyint unsigned NOT NULL default 0,
  2172. max_users int unsigned NOT NULL default 1,
  2173. start_at datetime NOT NULL default '0000-00-00 00:00:00',
  2174. end_at datetime NOT NULL default '0000-00-00 00:00:00',
  2175. subscribe_from datetime NOT NULL default '0000-00-00 00:00:00',
  2176. subscribe_until datetime NOT NULL default '0000-00-00 00:00:00',
  2177. subscribers int unsigned NOT NULL default 0,
  2178. notes text NOT NULL,
  2179. timepicker tinyint NOT NULL default 0,
  2180. timepicker_min int NOT NULL default 0,
  2181. timepicker_max int NOT NULL default 0,
  2182. PRIMARY KEY ( id )
  2183. );
  2184. -- --------------------------------------------------------
  2185. --
  2186. -- Table structure for reservation subscription table
  2187. --
  2188. CREATE TABLE reservation_subscription (
  2189. dummy int unsigned NOT NULL auto_increment,
  2190. user_id int unsigned NOT NULL default 0,
  2191. reservation_id int unsigned NOT NULL default 0,
  2192. accepted tinyint unsigned NOT NULL default 0,
  2193. start_at datetime NOT NULL default '0000-00-00 00:00:00',
  2194. end_at datetime NOT NULL default '0000-00-00 00:00:00',
  2195. PRIMARY KEY ( dummy )
  2196. );
  2197. -- ---------------------------------------------------------
  2198. --
  2199. -- Table structure for table user_rel_user
  2200. --
  2201. CREATE TABLE user_rel_user (
  2202. id bigint unsigned not null auto_increment,
  2203. user_id int unsigned not null,
  2204. friend_user_id int unsigned not null,
  2205. relation_type int not null default 0,
  2206. last_edit DATETIME,
  2207. PRIMARY KEY(id)
  2208. );
  2209. ALTER TABLE user_rel_user ADD INDEX idx_user_rel_user__user (user_id);
  2210. ALTER TABLE user_rel_user ADD INDEX idx_user_rel_user__friend_user(friend_user_id);
  2211. ALTER TABLE user_rel_user ADD INDEX idx_user_rel_user__user_friend_user(user_id,friend_user_id);
  2212. --
  2213. -- Table structure for table user_friend_relation_type
  2214. --
  2215. CREATE TABLE user_friend_relation_type(
  2216. id int unsigned not null auto_increment,
  2217. title char(20),
  2218. PRIMARY KEY(id)
  2219. );
  2220. --
  2221. -- Table structure for MD5 API keys for users
  2222. --
  2223. CREATE TABLE user_api_key (
  2224. id int unsigned NOT NULL auto_increment,
  2225. user_id int unsigned NOT NULL,
  2226. api_key char(32) NOT NULL,
  2227. api_service char(10) NOT NULL default 'dokeos',
  2228. PRIMARY KEY (id)
  2229. );
  2230. ALTER TABLE user_api_key ADD INDEX idx_user_api_keys_user (user_id);
  2231. --
  2232. -- Table structure for table message
  2233. --
  2234. CREATE TABLE message(
  2235. id bigint unsigned not null auto_increment,
  2236. user_sender_id int unsigned not null,
  2237. user_receiver_id int unsigned not null,
  2238. msg_status tinyint unsigned not null default 0, -- 0 read, 1 unread, 3 deleted, 5 pending invitation, 6 accepted invitation, 7 invitation denied
  2239. send_date datetime not null default '0000-00-00 00:00:00',
  2240. title varchar(255) not null,
  2241. content text not null,
  2242. group_id int unsigned not null default 0,
  2243. parent_id int unsigned not null default 0,
  2244. update_date datetime not null default '0000-00-00 00:00:00',
  2245. PRIMARY KEY(id)
  2246. );
  2247. ALTER TABLE message ADD INDEX idx_message_user_sender(user_sender_id);
  2248. ALTER TABLE message ADD INDEX idx_message_user_receiver(user_receiver_id);
  2249. ALTER TABLE message ADD INDEX idx_message_user_sender_user_receiver(user_sender_id,user_receiver_id);
  2250. ALTER TABLE message ADD INDEX idx_message_group(group_id);
  2251. ALTER TABLE message ADD INDEX idx_message_parent(parent_id);
  2252. INSERT INTO user_friend_relation_type (id,title)
  2253. VALUES
  2254. (1,'SocialUnknow'),
  2255. (2,'SocialParent'),
  2256. (3,'SocialFriend'),
  2257. (4,'SocialGoodFriend'),
  2258. (5,'SocialEnemy'),
  2259. (6,'SocialDeleted');
  2260. --
  2261. -- Table structure for table legal (Terms & Conditions)
  2262. --
  2263. CREATE TABLE legal (
  2264. legal_id int NOT NULL auto_increment,
  2265. language_id int NOT NULL,
  2266. date int NOT NULL default 0,
  2267. content text,
  2268. type int NOT NULL,
  2269. changes text NOT NULL,
  2270. version int,
  2271. PRIMARY KEY (legal_id,language_id)
  2272. );
  2273. --
  2274. -- Table structure for certificate with gradebook
  2275. --
  2276. CREATE TABLE gradebook_certificate (
  2277. id bigint unsigned not null auto_increment,
  2278. cat_id int unsigned not null,
  2279. user_id int unsigned not null,
  2280. score_certificate float unsigned not null default 0,
  2281. created_at DATETIME NOT NULL default '0000-00-00 00:00:00',
  2282. path_certificate text null,
  2283. PRIMARY KEY(id)
  2284. );
  2285. ALTER TABLE gradebook_certificate ADD INDEX idx_gradebook_certificate_category_id(cat_id);
  2286. ALTER TABLE gradebook_certificate ADD INDEX idx_gradebook_certificate_user_id(user_id);
  2287. ALTER TABLE gradebook_certificate ADD INDEX idx_gradebook_certificate_category_id_user_id(cat_id,user_id);
  2288. --
  2289. -- Tables structure for search tool
  2290. --
  2291. -- specific fields tables
  2292. CREATE TABLE specific_field (
  2293. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  2294. code char(1) NOT NULL,
  2295. name VARCHAR(200) NOT NULL
  2296. );
  2297. CREATE TABLE specific_field_values (
  2298. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  2299. course_code VARCHAR(40) NOT NULL ,
  2300. tool_id VARCHAR(100) NOT NULL ,
  2301. ref_id INT NOT NULL ,
  2302. field_id INT NOT NULL ,
  2303. value VARCHAR(200) NOT NULL
  2304. );
  2305. ALTER TABLE specific_field ADD CONSTRAINT unique_specific_field__code UNIQUE (code);
  2306. -- search engine references to map dokeos resources
  2307. CREATE TABLE search_engine_ref (
  2308. id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  2309. course_code VARCHAR( 40 ) NOT NULL,
  2310. tool_id VARCHAR( 100 ) NOT NULL,
  2311. ref_id_high_level INT NOT NULL,
  2312. ref_id_second_level INT NULL,
  2313. search_did INT NOT NULL
  2314. );
  2315. --
  2316. -- Table structure for table sessions categories
  2317. --
  2318. CREATE TABLE session_category (
  2319. id int NOT NULL auto_increment,
  2320. name varchar(100) default NULL,
  2321. date_start date default NULL,
  2322. date_end date default NULL,
  2323. access_url_id INT NOT NULL default 1,
  2324. PRIMARY KEY (id)
  2325. );
  2326. --
  2327. -- Table structure for table user tag
  2328. --
  2329. CREATE TABLE tag (
  2330. id int NOT NULL auto_increment,
  2331. tag char(255) NOT NULL,
  2332. field_id int NOT NULL,
  2333. count int NOT NULL,
  2334. PRIMARY KEY (id)
  2335. );
  2336. CREATE TABLE user_rel_tag (
  2337. id int NOT NULL auto_increment,
  2338. user_id int NOT NULL,
  2339. tag_id int NOT NULL,
  2340. PRIMARY KEY (id)
  2341. );
  2342. --
  2343. -- Table structure for user platform groups
  2344. --
  2345. CREATE TABLE groups (
  2346. id int NOT NULL AUTO_INCREMENT,
  2347. name varchar(255) NOT NULL,
  2348. description varchar(255) NOT NULL,
  2349. picture_uri varchar(255) NOT NULL,
  2350. url varchar(255) NOT NULL,
  2351. visibility int NOT NULL,
  2352. updated_on varchar(255) NOT NULL,
  2353. created_on varchar(255) NOT NULL,
  2354. PRIMARY KEY (id)
  2355. );
  2356. CREATE TABLE group_rel_tag (
  2357. id int NOT NULL AUTO_INCREMENT,
  2358. tag_id int NOT NULL,
  2359. group_id int NOT NULL,
  2360. PRIMARY KEY (id)
  2361. );
  2362. ALTER TABLE group_rel_tag ADD INDEX ( group_id );
  2363. ALTER TABLE group_rel_tag ADD INDEX ( tag_id );
  2364. CREATE TABLE group_rel_user (
  2365. id int NOT NULL AUTO_INCREMENT,
  2366. group_id int NOT NULL,
  2367. user_id int NOT NULL,
  2368. relation_type int NOT NULL,
  2369. PRIMARY KEY (id)
  2370. );
  2371. ALTER TABLE group_rel_user ADD INDEX ( group_id );
  2372. ALTER TABLE group_rel_user ADD INDEX ( user_id );
  2373. ALTER TABLE group_rel_user ADD INDEX ( relation_type );
  2374. CREATE TABLE group_rel_group (
  2375. id int NOT NULL AUTO_INCREMENT,
  2376. group_id int NOT NULL,
  2377. subgroup_id int NOT NULL,
  2378. relation_type int NOT NULL,
  2379. PRIMARY KEY (id)
  2380. );
  2381. ALTER TABLE group_rel_group ADD INDEX ( group_id );
  2382. ALTER TABLE group_rel_group ADD INDEX ( subgroup_id );
  2383. ALTER TABLE group_rel_group ADD INDEX ( relation_type );
  2384. CREATE TABLE announcement_rel_group (
  2385. group_id int NOT NULL,
  2386. announcement_id int NOT NULL,
  2387. PRIMARY KEY (group_id, announcement_id)
  2388. );
  2389. --
  2390. -- Table structure for table message attachment
  2391. --
  2392. CREATE TABLE IF NOT EXISTS message_attachment (
  2393. id int NOT NULL AUTO_INCREMENT,
  2394. path varchar(255) NOT NULL,
  2395. comment text,
  2396. size int NOT NULL default 0,
  2397. message_id int NOT NULL,
  2398. filename varchar(255) NOT NULL,
  2399. PRIMARY KEY (id)
  2400. );
  2401. INSERT INTO course_field (field_type, field_variable, field_display_text, field_default_value, field_visible, field_changeable) values (10, 'special_course','Special course', 'Yes', 1 , 1);
  2402. --
  2403. -- Table structure for table block
  2404. --
  2405. CREATE TABLE IF NOT EXISTS block (
  2406. id INT NOT NULL AUTO_INCREMENT,
  2407. name VARCHAR(255) NULL,
  2408. description TEXT NULL,
  2409. path VARCHAR(255) NOT NULL,
  2410. controller VARCHAR(100) NOT NULL,
  2411. active TINYINT NOT NULL DEFAULT 1,
  2412. PRIMARY KEY(id)
  2413. );
  2414. ALTER TABLE block ADD UNIQUE(path);
  2415. --
  2416. -- Structure for table 'course_request' ("Course validation" feature)
  2417. --
  2418. DROP TABLE IF EXISTS course_request;
  2419. CREATE TABLE course_request (
  2420. id int NOT NULL AUTO_INCREMENT,
  2421. code varchar(40) NOT NULL,
  2422. user_id int unsigned NOT NULL default '0',
  2423. directory varchar(40) DEFAULT NULL,
  2424. db_name varchar(40) DEFAULT NULL,
  2425. course_language varchar(20) DEFAULT NULL,
  2426. title varchar(250) DEFAULT NULL,
  2427. description text,
  2428. category_code varchar(40) DEFAULT NULL,
  2429. tutor_name varchar(200) DEFAULT NULL,
  2430. visual_code varchar(40) DEFAULT NULL,
  2431. request_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  2432. objetives text,
  2433. target_audience text,
  2434. status int unsigned NOT NULL default '0',
  2435. info int unsigned NOT NULL default '0',
  2436. exemplary_content int unsigned NOT NULL default '0',
  2437. PRIMARY KEY (id),
  2438. UNIQUE KEY code (code)
  2439. );
  2440. --
  2441. -- Structure for Careers, Promotions and Usergroups
  2442. --
  2443. CREATE TABLE career (
  2444. id INT NOT NULL AUTO_INCREMENT,
  2445. name VARCHAR(255) NOT NULL ,
  2446. description TEXT NOT NULL,
  2447. status INT NOT NULL default '0',
  2448. created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  2449. updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  2450. PRIMARY KEY (id)
  2451. );
  2452. CREATE TABLE promotion (
  2453. id INT NOT NULL AUTO_INCREMENT,
  2454. name VARCHAR(255) NOT NULL ,
  2455. description TEXT NOT NULL,
  2456. career_id INT NOT NULL,
  2457. status INT NOT NULL default '0',
  2458. created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  2459. updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  2460. PRIMARY KEY(id)
  2461. );
  2462. CREATE TABLE usergroup (
  2463. id INT NOT NULL AUTO_INCREMENT,
  2464. name VARCHAR(255) NOT NULL,
  2465. description TEXT NOT NULL,
  2466. PRIMARY KEY (id)
  2467. );
  2468. CREATE TABLE usergroup_rel_user (
  2469. usergroup_id INT NOT NULL,
  2470. user_id INT NOT NULL
  2471. );
  2472. CREATE TABLE usergroup_rel_course (
  2473. usergroup_id INT NOT NULL,
  2474. course_id INT NOT NULL
  2475. );
  2476. CREATE TABLE usergroup_rel_session (
  2477. usergroup_id INT NOT NULL,
  2478. session_id INT NOT NULL
  2479. );
  2480. --
  2481. -- Structure for Mail notifications
  2482. --
  2483. CREATE TABLE notification (
  2484. id BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  2485. dest_user_id INT NOT NULL,
  2486. dest_mail CHAR(255),
  2487. title CHAR(255),
  2488. content CHAR(255),
  2489. send_freq SMALLINT DEFAULT 1,
  2490. created_at DATETIME NOT NULL,
  2491. sent_at DATETIME NULL
  2492. );
  2493. ALTER TABLE notification ADD index mail_notify_sent_index (sent_at);
  2494. ALTER TABLE notification ADD index mail_notify_freq_index (sent_at, send_freq, created_at);
  2495. -- Skills management
  2496. CREATE TABLE skill (
  2497. id int NOT NULL AUTO_INCREMENT,
  2498. name varchar(255) NOT NULL,
  2499. short_code varchar(100) NOT NULL,
  2500. description TEXT NOT NULL,
  2501. access_url_id int NOT NULL,
  2502. icon varchar(255) NOT NULL,
  2503. PRIMARY KEY (id)
  2504. );
  2505. INSERT INTO skill VALUES('Root');
  2506. CREATE TABLE skill_rel_gradebook (
  2507. id int NOT NULL AUTO_INCREMENT,
  2508. gradebook_id int NOT NULL,
  2509. skill_id int NOT NULL,
  2510. type varchar(10) NOT NULL,
  2511. PRIMARY KEY (id)
  2512. );
  2513. CREATE TABLE skill_rel_skill (
  2514. skill_id int NOT NULL,
  2515. parent_id int NOT NULL,
  2516. relation_type int NOT NULL,
  2517. level int NOT NULL,
  2518. );
  2519. INSERT INTO skill_rel_skill VALUES(1, 0, 0);
  2520. CREATE TABLE skill_rel_user (
  2521. id int NOT NULL AUTO_INCREMENT,
  2522. user_id int NOT NULL,
  2523. skill_id int NOT NULL,
  2524. acquired_skill_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  2525. assigned_by int NOT NULL,
  2526. PRIMARY KEY (id)
  2527. );
  2528. --
  2529. -- Table structure for event alert sending
  2530. -- Pending check and approval
  2531. -- CREATE TABLE event_type (
  2532. -- id int unsigned NOT NULL AUTO_INCREMENT,
  2533. -- name varchar(50) NOT NULL,
  2534. -- name_lang_var varchar(40) NOT NULL,
  2535. -- desc_lang_var varchar(50) NOT NULL,
  2536. -- PRIMARY KEY (id)
  2537. -- );
  2538. --
  2539. -- CREATE TABLE event_type_message (
  2540. -- id int unsigned NOT NULL AUTO_INCREMENT,
  2541. -- event_type_id int NOT NULL,
  2542. -- language_id int NOT NULL,
  2543. -- message varchar(200) NOT NULL,
  2544. -- subject varchar(60) NOT NULL,
  2545. -- PRIMARY KEY (id)
  2546. -- );
  2547. --
  2548. -- CREATE TABLE user_rel_event_type (
  2549. -- id int NOT NULL AUTO_INCREMENT,
  2550. -- user_id int unsigned NOT NULL,
  2551. -- event_type_id int unsigned NOT NULL,
  2552. -- PRIMARY KEY (id)
  2553. -- );
  2554. --
  2555. -- INSERT INTO event_type VALUES (1, 'course_deleted','courseDeletedTitle','courseDeletedComment'),(2,'course_created','courseCreatedTitle','courseCreatedComment'),(3,'user_deleted','userDeletedTitle','userDeletedComment'),(4,'user_created','userCreatedTitle','userCreatedComment'), (5, 'session_created','sessionCreatedTitle','sessionCreatedComment'), (6,'session_deleted','sessionDeletedTitle','sessionDeletedComment'), (7,'session_category_created','sessionCategoryCreatedTitle','sessionCategoryCreatedComment'),(8,'session_category_deleted','sessionCategoryDeletedTitle','sessionCategoryDeletedComment'),(9,'settings_changed','settingsChangedTitle','settingsChangedComment'),(10,'user_subscribed','userSubscribedTitle','userSubscribedComment'), (11,'user_unsubscribed','userUnsubscribedTitle','userUnsubscribedComment');
  2556. --
  2557. -- INSERT INTO event_type_message (id,event_type_id,language_id,message,subject) VALUES (1,4,10,'ReportMessageUserCreated',''),(2,1,10,'DeleteCourse',''),(3,2,10,'CreateCourse',''),(4,3,10,'ReportMessageUserDeleted',''),(6,5,10,'CreateSessionTest',''),(7,6,10,'DeleteSession',''),(8,7,10,'CreateSessionCategory',''),(9,8,10,'DeleteSessionCategory',''),(10,9,10,'ChangeSetting',''),(11,10,10,'Subscribe',''),(12,11,10,'Unsubscribe','');