dokeos_main.sql 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944
  1. -- MySQL dump 10.9
  2. --
  3. -- Host: localhost Database: dokeos_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 admin
  16. --
  17. DROP TABLE IF EXISTS admin;
  18. CREATE TABLE admin (
  19. user_id int(10) unsigned NOT NULL default '0',
  20. UNIQUE KEY user_id (user_id)
  21. );
  22. --
  23. -- Dumping data for table admin
  24. --
  25. /*!40000 ALTER TABLE admin DISABLE KEYS */;
  26. LOCK TABLES admin WRITE;
  27. INSERT INTO admin VALUES (1);
  28. UNLOCK TABLES;
  29. /*!40000 ALTER TABLE admin ENABLE KEYS */;
  30. --
  31. -- Table structure for table class
  32. --
  33. DROP TABLE IF EXISTS class;
  34. CREATE TABLE class (
  35. id mediumint(8) unsigned NOT NULL auto_increment,
  36. code varchar(40) default '',
  37. name text NOT NULL,
  38. PRIMARY KEY (id)
  39. );
  40. --
  41. -- Dumping data for table class
  42. --
  43. /*!40000 ALTER TABLE class DISABLE KEYS */;
  44. LOCK TABLES class WRITE;
  45. UNLOCK TABLES;
  46. /*!40000 ALTER TABLE class ENABLE KEYS */;
  47. --
  48. -- Table structure for table class_user
  49. --
  50. DROP TABLE IF EXISTS class_user;
  51. CREATE TABLE class_user (
  52. class_id mediumint(8) unsigned NOT NULL default '0',
  53. user_id int(10) unsigned NOT NULL default '0',
  54. PRIMARY KEY (class_id,user_id)
  55. );
  56. --
  57. -- Dumping data for table class_user
  58. --
  59. /*!40000 ALTER TABLE class_user DISABLE KEYS */;
  60. LOCK TABLES class_user WRITE;
  61. UNLOCK TABLES;
  62. /*!40000 ALTER TABLE class_user ENABLE KEYS */;
  63. --
  64. -- Table structure for table course
  65. --
  66. DROP TABLE IF EXISTS course;
  67. CREATE TABLE course (
  68. code varchar(40) NOT NULL,
  69. directory varchar(40) default NULL,
  70. db_name varchar(40) default NULL,
  71. course_language varchar(20) default NULL,
  72. title varchar(250) default NULL,
  73. description text,
  74. category_code varchar(40) default NULL,
  75. visibility tinyint(4) default '0',
  76. show_score int(11) NOT NULL default '1',
  77. tutor_name varchar(200) default NULL,
  78. visual_code varchar(40) default NULL,
  79. department_name varchar(30) default NULL,
  80. department_url varchar(180) default NULL,
  81. disk_quota int(10) unsigned default NULL,
  82. last_visit datetime default NULL,
  83. last_edit datetime default NULL,
  84. creation_date datetime default NULL,
  85. expiration_date datetime default NULL,
  86. target_course_code varchar(40) default NULL,
  87. subscribe tinyint(4) NOT NULL default '1',
  88. unsubscribe tinyint(4) NOT NULL default '1',
  89. registration_code varchar(255) NOT NULL default '',
  90. PRIMARY KEY (code)
  91. );
  92. --
  93. -- Dumping data for table course
  94. --
  95. /*!40000 ALTER TABLE course DISABLE KEYS */;
  96. LOCK TABLES course WRITE;
  97. UNLOCK TABLES;
  98. /*!40000 ALTER TABLE course ENABLE KEYS */;
  99. --
  100. -- Table structure for table course_category
  101. --
  102. DROP TABLE IF EXISTS course_category;
  103. CREATE TABLE course_category (
  104. id int(10) unsigned NOT NULL auto_increment,
  105. name varchar(100) NOT NULL default '',
  106. code varchar(40) NOT NULL default '',
  107. parent_id varchar(40) default NULL,
  108. tree_pos int(10) unsigned default NULL,
  109. children_count smallint(6) default NULL,
  110. auth_course_child enum('TRUE','FALSE') default 'TRUE',
  111. auth_cat_child enum('TRUE','FALSE') default 'TRUE',
  112. PRIMARY KEY (id),
  113. UNIQUE KEY code (code),
  114. KEY parent_id (parent_id),
  115. KEY tree_pos (tree_pos)
  116. );
  117. --
  118. -- Dumping data for table course_category
  119. --
  120. /*!40000 ALTER TABLE course_category DISABLE KEYS */;
  121. LOCK TABLES course_category WRITE;
  122. 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');
  123. UNLOCK TABLES;
  124. /*!40000 ALTER TABLE course_category ENABLE KEYS */;
  125. --
  126. -- Table structure for table course_module
  127. --
  128. DROP TABLE IF EXISTS course_module;
  129. CREATE TABLE course_module (
  130. id int(10) unsigned NOT NULL auto_increment,
  131. name varchar(100) NOT NULL,
  132. link varchar(255) NOT NULL,
  133. image varchar(100) default NULL,
  134. row int(10) unsigned NOT NULL default '0',
  135. column int(10) unsigned NOT NULL default '0',
  136. position varchar(20) NOT NULL default 'basic',
  137. PRIMARY KEY (id)
  138. );
  139. --
  140. -- Dumping data for table course_module
  141. --
  142. /*!40000 ALTER TABLE course_module DISABLE KEYS */;
  143. LOCK TABLES course_module WRITE;
  144. INSERT INTO course_module VALUES
  145. (1,'calendar_event','calendar/agenda.php','agenda.gif',1,1,'basic'),
  146. (2,'link','link/link.php','links.gif',4,1,'basic'),
  147. (3,'document','document/document.php','documents.gif',3,1,'basic'),
  148. (4,'student_publication','work/work.php','works.gif',3,2,'basic'),
  149. (5,'announcement','announcements/announcements.php','valves.gif',2,1,'basic'),
  150. (6,'user','user/user.php','members.gif',2,3,'basic'),
  151. (7,'forum','forum/index.php','forum.gif',1,2,'basic'),
  152. (8,'quiz','exercice/exercice.php','quiz.gif',2,2,'basic'),
  153. (9,'group','group/group.php','group.gif',3,3,'basic'),
  154. (10,'course_description','course_description/','info.gif',1,3,'basic'),
  155. (11,'chat','chat/chat.php','chat.gif',0,0,'external'),
  156. (12,'dropbox','dropbox/index.php','dropbox.gif',4,2,'basic'),
  157. (13,'tracking','tracking/courseLog.php','statistics.gif',1,3,'courseadmin'),
  158. (14,'homepage_link','link/link.php?action=addlink','npage.gif',1,1,'courseadmin'),
  159. (15,'course_setting','course_info/infocours.php','reference.gif',1,1,'courseadmin'),
  160. (16,'External','','external.gif',0,0,'external'),
  161. (17,'AddedLearnpath','','scormbuilder.gif',0,0,'external'),
  162. (18,'conference','conference/index.php?type=conference','conf.gif',0,0,'external'),
  163. (19,'conference','conference/index.php?type=classroom','conf.gif',0,0,'external'),
  164. (20,'learnpath','newscorm/lp_controller.php','scorm.gif',5,1,'basic'),
  165. (21,'blog','blog/blog.php','blog.gif',1,2,'basic'),
  166. (22,'blog_management','blog/blog_admin.php','blog_admin.gif',1,2,'courseadmin'),
  167. (23,'course_maintenance','course_info/maintenance.php','backup.gif',2,3,'courseadmin'),
  168. (24,'survey','survey/survey_list.php','survey.gif',2,1,'courseadmin');
  169. UNLOCK TABLES;
  170. /*!40000 ALTER TABLE course_module ENABLE KEYS */;
  171. --
  172. -- Table structure for table course_rel_class
  173. --
  174. DROP TABLE IF EXISTS course_rel_class;
  175. CREATE TABLE course_rel_class (
  176. course_code char(40) NOT NULL,
  177. class_id mediumint(8) unsigned NOT NULL,
  178. PRIMARY KEY (course_code,class_id)
  179. );
  180. --
  181. -- Dumping data for table course_rel_class
  182. --
  183. /*!40000 ALTER TABLE course_rel_class DISABLE KEYS */;
  184. LOCK TABLES course_rel_class WRITE;
  185. UNLOCK TABLES;
  186. /*!40000 ALTER TABLE course_rel_class ENABLE KEYS */;
  187. --
  188. -- Table structure for table course_rel_user
  189. --
  190. DROP TABLE IF EXISTS course_rel_user;
  191. CREATE TABLE course_rel_user (
  192. course_code varchar(40) NOT NULL,
  193. user_id int(10) unsigned NOT NULL default '0',
  194. status tinyint(4) NOT NULL default '5',
  195. role varchar(60) default NULL,
  196. group_id int(11) NOT NULL default '0',
  197. tutor_id int(10) unsigned NOT NULL default '0',
  198. sort int(11) default NULL,
  199. user_course_cat int(11) default '0',
  200. PRIMARY KEY (course_code,user_id)
  201. );
  202. --
  203. -- Dumping data for table course_rel_user
  204. --
  205. /*!40000 ALTER TABLE course_rel_user DISABLE KEYS */;
  206. LOCK TABLES course_rel_user WRITE;
  207. UNLOCK TABLES;
  208. /*!40000 ALTER TABLE course_rel_user ENABLE KEYS */;
  209. --
  210. -- Table structure for table language
  211. --
  212. DROP TABLE IF EXISTS language;
  213. CREATE TABLE language (
  214. id tinyint(3) unsigned NOT NULL auto_increment,
  215. original_name varchar(255) default NULL,
  216. english_name varchar(255) default NULL,
  217. isocode varchar(10) default NULL,
  218. dokeos_folder varchar(250) default NULL,
  219. available tinyint(4) NOT NULL default '1',
  220. PRIMARY KEY (id)
  221. );
  222. --
  223. -- Dumping data for table language
  224. --
  225. /*!40000 ALTER TABLE language DISABLE KEYS */;
  226. LOCK TABLES language WRITE;
  227. INSERT INTO language VALUES
  228. (1,'Arabija (el)','arabic','ar','arabic',0),
  229. (2,'Português (Brazil)','brazilian','pt-BR','brazilian',1),
  230. (3,'Balgarski','bulgarian','bg','bulgarian',0),
  231. (4,'Català','catalan','ca','catalan',0),
  232. (5,'Hrvatski','croatian','hr','croatian',0),
  233. (6,'Dansk','danish','da','danish',0),
  234. (7,'Nederlands','dutch','nl','dutch',1),
  235. (8,'English','english','en','english',1),
  236. (9,'Suomi','finnish','fi','finnish',0),
  237. (10,'Français','french','fr','french',1),
  238. (11,'Galego','galician','gl','galician',0),
  239. (12,'Deutsch','german','de','german',1),
  240. (13,'Ellinika','greek','el','greek',0),
  241. (14,'Magyar','hungarian','hu','hungarian',1),
  242. (15,'Indonesia (Bahasa I.)','indonesian','id','indonesian',1),
  243. (16,'Italiano','italian','it','italian',1),
  244. (17,'Nihongo','japanese','ja','japanese',0),
  245. (18,'Melayu (Bahasa M.)','malay','ms','malay',0),
  246. (19,'Polski','polish','pl','polish',0),
  247. (20,'Português (Portugal)','portuguese','pt','portuguese',1),
  248. (21,'Russkij','russian','ru','russian',0),
  249. (22,'Chinese (simplified)','simpl_chinese','zh','simpl_chinese',0),
  250. (23,'Slovenscina','slovenian','sl','slovenian',1),
  251. (24,'Español','spanish','es','spanish',1),
  252. (25,'Svenska','swedish','sv','swedish',0),
  253. (26,'Thai','thai','th','thai',0),
  254. (27,'Türkçe','turkce','tr','turkce',0),
  255. (28,'Viêt (Tiêng V.)','vietnamese','vi','vietnamese',0),
  256. (29,'Norsk','norwegian','no','norwegian',0),
  257. (30,'Farsi','persian','fa','persian',0),
  258. (31,'Srpski','serbian','sr','serbian',0),
  259. (32,'Bosanski','bosnian',NULL,'bosnian',1),
  260. (33,'Swahili (kiSw.)','swahili','sw','swahili',0),
  261. (34,'Esperanto','esperanto','eo','esperanto',0);
  262. UNLOCK TABLES;
  263. /*!40000 ALTER TABLE language ENABLE KEYS */;
  264. --
  265. -- Table structure for table php_session
  266. --
  267. DROP TABLE IF EXISTS php_session;
  268. CREATE TABLE php_session (
  269. session_id varchar(32) NOT NULL default '',
  270. session_name varchar(10) NOT NULL default '',
  271. session_time int(11) NOT NULL default '0',
  272. session_start int(11) NOT NULL default '0',
  273. session_value text NOT NULL,
  274. PRIMARY KEY (session_id)
  275. );
  276. --
  277. -- Table structure for table session
  278. --
  279. DROP TABLE IF EXISTS session;
  280. CREATE TABLE session (
  281. id smallint(5) unsigned NOT NULL auto_increment,
  282. id_coach int(10) unsigned NOT NULL default '0',
  283. name char(50) NOT NULL default '',
  284. nbr_courses smallint(5) unsigned NOT NULL default '0',
  285. nbr_users mediumint(8) unsigned NOT NULL default '0',
  286. nbr_classes mediumint(8) unsigned NOT NULL default '0',
  287. date_start date NOT NULL default '0000-00-00',
  288. date_end date NOT NULL default '0000-00-00',
  289. session_admin_id INT UNSIGNED NOT NULL,
  290. PRIMARY KEY (id),
  291. INDEX (session_admin_id),
  292. UNIQUE KEY name (name)
  293. );
  294. -- --------------------------------------------------------
  295. --
  296. -- Table structure for table session_rel_course
  297. --
  298. DROP TABLE IF EXISTS session_rel_course;
  299. CREATE TABLE session_rel_course (
  300. id_session smallint(5) unsigned NOT NULL default '0',
  301. course_code char(40) NOT NULL default '',
  302. id_coach int(10) unsigned NOT NULL default '0',
  303. nbr_users smallint(5) unsigned NOT NULL default '0',
  304. PRIMARY KEY (id_session,course_code),
  305. KEY course_code (course_code)
  306. );
  307. -- --------------------------------------------------------
  308. --
  309. -- Table structure for table session_rel_course_rel_user
  310. --
  311. DROP TABLE IF EXISTS session_rel_course_rel_user;
  312. CREATE TABLE session_rel_course_rel_user (
  313. id_session smallint(5) unsigned NOT NULL default '0',
  314. course_code char(40) NOT NULL default '',
  315. id_user int(10) unsigned NOT NULL default '0',
  316. PRIMARY KEY (id_session,course_code,id_user),
  317. KEY id_user (id_user),
  318. KEY course_code (course_code)
  319. );
  320. -- --------------------------------------------------------
  321. --
  322. -- Table structure for table session_rel_user
  323. --
  324. DROP TABLE IF EXISTS session_rel_user;
  325. CREATE TABLE session_rel_user (
  326. id_session mediumint(8) unsigned NOT NULL default '0',
  327. id_user mediumint(8) unsigned NOT NULL default '0',
  328. PRIMARY KEY (id_session,id_user)
  329. );
  330. --
  331. -- Table structure for table settings_current
  332. --
  333. DROP TABLE IF EXISTS settings_current;
  334. CREATE TABLE settings_current (
  335. id int(10) unsigned NOT NULL auto_increment,
  336. variable varchar(255) default NULL,
  337. subkey varchar(255) default NULL,
  338. type varchar(255) default NULL,
  339. category varchar(255) default NULL,
  340. selected_value varchar(255) default NULL,
  341. title varchar(255) NOT NULL default '',
  342. comment varchar(255) default NULL,
  343. scope varchar(50) default NULL,
  344. subkeytext varchar(255) default NULL,
  345. UNIQUE KEY id (id)
  346. );
  347. --
  348. -- Dumping data for table settings_current
  349. --
  350. /*!40000 ALTER TABLE settings_current DISABLE KEYS */;
  351. LOCK TABLES settings_current WRITE;
  352. INSERT INTO settings_current
  353. (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext)
  354. VALUES
  355. ('Institution',NULL,'textfield','Platform','{ORGANISATIONNAME}','InstitutionTitle','InstitutionComment','platform',NULL),
  356. ('InstitutionUrl',NULL,'textfield','Platform','{ORGANISATIONURL}','InstitutionUrlTitle','InstitutionUrlComment',NULL,NULL),
  357. ('siteName',NULL,'textfield','Platform','{CAMPUSNAME}','SiteNameTitle','SiteNameComment',NULL,NULL),
  358. ('emailAdministrator',NULL,'textfield','Platform','{ADMINEMAIL}','emailAdministratorTitle','emailAdministratorComment',NULL,NULL),
  359. ('administratorSurname',NULL,'textfield','Platform','{ADMINLASTNAME}','administratorSurnameTitle','administratorSurnameComment',NULL,NULL),
  360. ('administratorName',NULL,'textfield','Platform','{ADMINFIRSTNAME}','administratorNameTitle','administratorNameComment',NULL,NULL),
  361. ('show_administrator_data',NULL,'radio','Platform','true','ShowAdministratorDataTitle','ShowAdministratorDataComment',NULL,NULL),
  362. ('homepage_view',NULL,'radio','Course','activity','HomepageViewTitle','HomepageViewComment',NULL,NULL),
  363. ('show_toolshortcuts',NULL,'radio','Course','false','ShowToolShortcutsTitle','ShowToolShortcutsComment',NULL,NULL),
  364. ('allow_group_categories',NULL,'radio','Course','false','AllowGroupCategories','AllowGroupCategoriesComment',NULL,NULL),
  365. ('server_type',NULL,'radio','Platform','production','ServerStatusTitle','ServerStatusComment',NULL,NULL),
  366. ('platformLanguage',NULL,'link','Languages','{PLATFORMLANGUAGE}','PlatformLanguageTitle','PlatformLanguageComment',NULL,NULL),
  367. ('showonline','world','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineWorld'),
  368. ('showonline','users','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineUsers'),
  369. ('showonline','course','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineCourse'),
  370. ('profile','name','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'name'),
  371. ('profile','officialcode','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'officialcode'),
  372. ('profile','email','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Email'),
  373. ('profile','picture','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPicture'),
  374. ('profile','login','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Login'),
  375. ('profile','password','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPassword'),
  376. ('profile','language','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'Language'),
  377. ('default_document_quotum',NULL,'textfield','Course','50000000','DefaultDocumentQuotumTitle','DefaultDocumentQuotumComment',NULL,NULL),
  378. ('registration','officialcode','checkbox','User','false','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'OfficialCode'),
  379. ('registration','email','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Email'),
  380. ('registration','language','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Language'),
  381. ('default_group_quotum',NULL,'textfield','Course','5000000','DefaultGroupQuotumTitle','DefaultGroupQuotumComment',NULL,NULL),
  382. ('allow_registration',NULL,'radio','Platform','{ALLOWSELFREGISTRATION}','AllowRegistrationTitle','AllowRegistrationComment',NULL,NULL),
  383. ('allow_registration_as_teacher',NULL,'radio','Platform','{ALLOWTEACHERSELFREGISTRATION}','AllowRegistrationAsTeacherTitle','AllowRegistrationAsTeacherComment',NULL,NULL),
  384. ('allow_lostpassword',NULL,'radio','Platform','true','AllowLostPasswordTitle','AllowLostPasswordComment',NULL,NULL),
  385. ('allow_user_headings',NULL,'radio','Course','false','AllowUserHeadings','AllowUserHeadingsComment',NULL,NULL),
  386. ('course_create_active_tools','course_description','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'CourseDescription'),
  387. ('course_create_active_tools','agenda','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Agenda'),
  388. ('course_create_active_tools','documents','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Documents'),
  389. ('course_create_active_tools','learning_path','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'LearningPath'),
  390. ('course_create_active_tools','links','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Links'),
  391. ('course_create_active_tools','announcements','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Announcements'),
  392. ('course_create_active_tools','forums','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Forums'),
  393. ('course_create_active_tools','dropbox','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Dropbox'),
  394. ('course_create_active_tools','quiz','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Quiz'),
  395. ('course_create_active_tools','users','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Users'),
  396. ('course_create_active_tools','groups','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Groups'),
  397. ('course_create_active_tools','chat','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Chat'),
  398. ('course_create_active_tools','online_conference','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'OnlineConference'),
  399. ('course_create_active_tools','student_publications','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'StudentPublications'),
  400. ('allow_personal_agenda',NULL,'radio','User','false','AllowPersonalAgendaTitle','AllowPersonalAgendaComment',NULL,NULL),
  401. ('display_coursecode_in_courselist',NULL,'radio','Platform','true','DisplayCourseCodeInCourselistTitle','DisplayCourseCodeInCourselistComment',NULL,NULL),
  402. ('display_teacher_in_courselist',NULL,'radio','Platform','true','DisplayTeacherInCourselistTitle','DisplayTeacherInCourselistComment',NULL,NULL),
  403. ('use_document_title',NULL,'radio','Tools','false','UseDocumentTitleTitle','UseDocumentTitleComment',NULL,NULL),
  404. ('permanently_remove_deleted_files',NULL,'radio','Tools','false','PermanentlyRemoveFilesTitle','PermanentlyRemoveFilesComment',NULL,NULL),
  405. ('dropbox_allow_overwrite',NULL,'radio','Tools','true','DropboxAllowOverwriteTitle','DropboxAllowOverwriteComment',NULL,NULL),
  406. ('dropbox_max_filesize',NULL,'textfield','Tools','100000000','DropboxMaxFilesizeTitle','DropboxMaxFilesizeComment',NULL,NULL),
  407. ('dropbox_allow_just_upload',NULL,'radio','Tools','true','DropboxAllowJustUploadTitle','DropboxAllowJustUploadComment',NULL,NULL),
  408. ('dropbox_allow_student_to_student',NULL,'radio','Tools','true','DropboxAllowStudentToStudentTitle','DropboxAllowStudentToStudentComment',NULL,NULL),
  409. ('dropbox_allow_group',NULL,'radio','Tools','true','DropboxAllowGroupTitle','DropboxAllowGroupComment',NULL,NULL),
  410. ('dropbox_allow_mailing',NULL,'radio','Tools','false','DropboxAllowMailingTitle','DropboxAllowMailingComment',NULL,NULL),
  411. ('administratorTelephone',NULL,'textfield','Platform','(000) 001 02 03','administratorTelephoneTitle','administratorTelephoneComment',NULL,NULL),
  412. ('extended_profile',NULL,'radio','User','true','ExtendedProfileTitle','ExtendedProfileComment',NULL,NULL),
  413. ('student_view_enabled',NULL,'radio','Platform','true','StudentViewEnabledTitle','StudentViewEnabledComment',NULL,NULL),
  414. ('show_navigation_menu',NULL,'radio','Course','false','ShowNavigationMenuTitle','ShowNavigationMenuComment',NULL,NULL),
  415. ('enable_tool_introduction',NULL,'radio','course','false','EnableToolIntroductionTitle','EnableToolIntroductionComment',NULL,NULL),
  416. ('page_after_login', NULL, 'radio','Platform','user_portal.php', 'PageAfterLoginTitle','PageAfterLoginComment', NULL, NULL),
  417. ('time_limit_whosonline', NULL, 'textfield','Platform','30', 'TimeLimitWhosonlineTitle','TimeLimitWhosonlineComment', NULL, NULL),
  418. ('breadcrumbs_course_homepage', NULL, 'radio','Course','course_title', 'BreadCrumbsCourseHomepageTitle','BreadCrumbsCourseHomepageComment', NULL, NULL),
  419. ('example_material_course_creation', NULL, 'radio','Platform','true', 'ExampleMaterialCourseCreationTitle','ExampleMaterialCourseCreationComment', NULL, NULL),
  420. ('account_valid_duration',NULL, 'textfield','Platform','3660', 'AccountValidDurationTitle','AccountValidDurationComment', NULL, NULL),
  421. ('use_session_mode', NULL, 'radio','Platform','true', 'UseSessionModeTitle','UseSessionModeComment', NULL, NULL),
  422. ('allow_email_editor', NULL, 'radio', 'Tools', 'false', 'AllowEmailEditorTitle', 'AllowEmailEditorComment', NULL, NULL),
  423. ('registered', NULL, 'textfield', NULL, 'false', NULL, NULL, NULL, NULL),
  424. ('donotlistcampus', NULL, 'textfield', NULL, 'false', NULL, NULL, NULL, NULL),
  425. ('show_email_addresses', NULL,'radio','Platform','false','ShowEmailAddresses','ShowEmailAddressesComment',NULL,NULL),
  426. ('profile','phone','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'phone'),
  427. ('service_visio', 'active', 'radio',NULL,'false', 'VisioEnable','', NULL, NULL),
  428. ('service_visio', 'visio_host', 'textfield',NULL,'', 'VisioHost','', NULL, NULL),
  429. ('service_visio', 'visio_port', 'textfield',NULL,'1935', 'VisioPort','', NULL, NULL),
  430. ('service_visio', 'visio_pass', 'textfield',NULL,'', 'VisioPassword','', NULL, NULL),
  431. ('service_ppt2lp', 'active', 'radio',NULL,'false', 'ppt2lp_actived','', NULL, NULL),
  432. ('service_ppt2lp', 'host', 'textfield', NULL, NULL, 'Host', NULL, NULL, NULL),
  433. ('service_ppt2lp', 'port', 'textfield', NULL, 2002, 'Port', NULL, NULL, NULL),
  434. ('service_ppt2lp', 'user', 'textfield', NULL, NULL, 'UserOnHost', NULL, NULL, NULL),
  435. ('service_ppt2lp', 'ftp_password', 'textfield', NULL, NULL, 'FtpPassword', NULL, NULL, NULL),
  436. ('service_ppt2lp', 'path_to_lzx', 'textfield', NULL, NULL, '', NULL, NULL, NULL),
  437. ('service_ppt2lp', 'size', 'radio', NULL, '720x540', '', NULL, NULL, NULL),
  438. ('wcag_anysurfer_public_pages', NULL, 'radio','Platform','false','PublicPagesComplyToWAITitle','PublicPagesComplyToWAIComment', NULL, NULL),
  439. ('stylesheets', NULL, 'textfield','stylesheets','default_with_tabs','',NULL, NULL, NULL),
  440. ('upload_extensions_list_type', NULL, 'radio', 'Security', 'blacklist', 'UploadExtensionsListType', 'UploadExtensionsListTypeComment', NULL, NULL),
  441. ('upload_extensions_blacklist', NULL, 'textfield', 'Security', '', 'UploadExtensionsBlacklist', 'UploadExtensionsBlacklistComment', NULL, NULL),
  442. ('upload_extensions_whitelist', NULL, 'textfield', 'Security', 'htm;html;jpg;jpeg;gif;png;swf;avi;mpg;mpeg', 'UploadExtensionsWhitelist', 'UploadExtensionsWhitelistComment', NULL, NULL),
  443. ('upload_extensions_skip', NULL, 'radio', 'Security', 'true', 'UploadExtensionsSkip', 'UploadExtensionsSkipComment', NULL, NULL),
  444. ('upload_extensions_replace_by', NULL, 'textfield', 'Security', 'dangerous', 'UploadExtensionsReplaceBy', 'UploadExtensionsReplaceByComment', NULL, NULL),
  445. ('show_number_of_courses', NULL, 'radio','Platform','false', 'ShowNumberOfCourses','ShowNumberOfCoursesComment', NULL, NULL),
  446. ('show_empty_course_categories', NULL, 'radio','Platform','true', 'ShowEmptyCourseCategories','ShowEmptyCourseCategoriesComment', NULL, NULL),
  447. ('show_back_link_on_top_of_tree', NULL, 'radio','Platform','false', 'ShowBackLinkOnTopOfCourseTree','ShowBackLinkOnTopOfCourseTreeComment', NULL, NULL),
  448. ('show_different_course_language', NULL, 'radio','Platform','true', 'ShowDifferentCourseLanguage','ShowDifferentCourseLanguageComment', NULL, NULL),
  449. ('split_users_upload_directory', NULL, 'radio','Tuning','false', 'SplitUsersUploadDirectory','SplitUsersUploadDirectoryComment', NULL, NULL),
  450. ('hide_dltt_markup', NULL, 'radio','Platform','true', 'HideDLTTMarkup','HideDLTTMarkupComment', NULL, NULL),
  451. ('display_categories_on_homepage',NULL,'radio','Platform','false','DisplayCategoriesOnHomepageTitle','DisplayCategoriesOnHomepageComment',NULL,NULL),
  452. ('permissions_for_new_directories', NULL, 'textfield', 'Security', '0777', 'PermissionsForNewDirs', 'PermissionsForNewDirsComment', NULL, NULL),
  453. ('permissions_for_new_files', NULL, 'textfield', 'Security', '0666', 'PermissionsForNewFiles', 'PermissionsForNewFilesComment', NULL, NULL),
  454. ('show_tabs', 'campus_homepage', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsCampusHomepage'),
  455. ('show_tabs', 'my_courses', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyCourses'),
  456. ('show_tabs', 'reporting', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsReporting'),
  457. ('show_tabs', 'platform_administration', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsPlatformAdministration'),
  458. ('show_tabs', 'my_agenda', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyAgenda'),
  459. ('show_tabs', 'my_profile', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyProfile'),
  460. ('default_forum_view', NULL, 'radio', 'Course', 'flat', 'DefaultForumViewTitle','DefaultForumViewComment',NULL,NULL),
  461. ('platform_charset',NULL,'textfield','Platform','iso-8859-15','PlatformCharsetTitle','PlatformCharsetComment','platform',NULL),
  462. ('noreply_email_address', '', 'textfield', 'Platform', '', 'NoReplyEmailAddress', 'NoReplyEmailAddressComment', NULL, NULL),
  463. ('survey_email_sender_noreply', '', 'radio', 'Course', 'coach', 'SurveyEmailSenderNoReply', 'SurveyEmailSenderNoReplyComment', NULL, NULL),
  464. ('openid_authentication',NULL,'radio','Security','false','OpenIdAuthentication','OpenIdAuthenticationComment',NULL,NULL),
  465. ('profile','openid','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'OpenIDURL'),
  466. ('gradebook_enable',NULL,'radio','Gradebook','false','GradebookActivation','GradebookActivationComment',NULL,NULL),
  467. ('show_tabs','my_gradebook','checkbox','Platform','true','ShowTabsTitle','ShowTabsComment',NULL,'TabsMyGradebook'),
  468. ('gradebook_score_display_coloring','my_display_coloring','checkbox','Gradebook','false','GradebookScoreDisplayColoring','GradebookScoreDisplayColoringComment',NULL,'TabsGradebookEnableColoring'),
  469. ('gradebook_score_display_custom','my_display_custom','checkbox','Gradebook','false','GradebookScoreDisplayCustom','GradebookScoreDisplayCustomComment',NULL,'TabsGradebookEnableCustom'),
  470. ('gradebook_score_display_colorsplit',NULL,'textfield','Gradebook','50','GradebookScoreDisplayColorSplit','GradebookScoreDisplayColorSplitComment',NULL,NULL),
  471. ('gradebook_score_display_upperlimit','my_display_upperlimit','checkbox','Gradebook','false','GradebookScoreDisplayUpperLimit','GradebookScoreDisplayUpperLimitComment',NULL,'TabsGradebookEnableUpperLimit'),
  472. ('user_selected_theme',NULL,'radio','Platform','false','UserThemeSelection','UserThemeSelectionComment',NULL,NULL),
  473. ('profile','theme','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserTheme'),
  474. ('allow_course_theme',NULL,'radio','Course','true','AllowCourseThemeTitle','AllowCourseThemeComment',NULL,NULL),
  475. ('display_mini_month_calendar',NULL,'radio','Tools', 'true', 'DisplayMiniMonthCalendarTitle', 'DisplayMiniMonthCalendarComment', NULL, NULL),
  476. ('display_upcoming_events',NULL,'radio','Tools','true','DisplayUpcomingEventsTitle','DisplayUpcomingEventsComment',NULL,NULL),
  477. ('number_of_upcoming_events',NULL,'textfield','Tools','1','NumberOfUpcomingEventsTitle','NumberOfUpcomingEventsComment',NULL,NULL),
  478. ('show_closed_courses',NULL,'radio','Platform','false','ShowClosedCoursesTitle','ShowClosedCoursesComment',NULL,NULL),
  479. ('ldap_main_server_address', NULL, 'textfield', 'LDAP', 'localhost', 'LDAPMainServerAddressTitle', 'LDAPMainServerAddressComment', NULL, NULL),
  480. ('ldap_main_server_port', NULL, 'textfield', 'LDAP', '389', 'LDAPMainServerPortTitle', 'LDAPMainServerPortComment', NULL, NULL),
  481. ('ldap_domain', NULL, 'textfield', 'LDAP', 'dc=nodomain', 'LDAPDomainTitle', 'LDAPDomainComment', NULL, NULL),
  482. ('ldap_replicate_server_address', NULL, 'textfield', 'LDAP', 'localhost', 'LDAPReplicateServerAddressTitle', 'LDAPReplicateServerAddressComment', NULL, NULL),
  483. ('ldap_replicate_server_port', NULL, 'textfield', 'LDAP', '389', 'LDAPReplicateServerPortTitle', 'LDAPReplicateServerPortComment', NULL, NULL),
  484. ('ldap_search_term', NULL, 'textfield', 'LDAP', '', 'LDAPSearchTermTitle', 'LDAPSearchTermComment', NULL, NULL),
  485. ('ldap_version', NULL, 'radio', 'LDAP', '3', 'LDAPVersionTitle', 'LDAPVersionComment', NULL, ''),
  486. ('ldap_filled_tutor_field', NULL, 'textfield', 'LDAP', 'employeenumber', 'LDAPFilledTutorFieldTitle', 'LDAPFilledTutorFieldComment', NULL, ''),
  487. ('ldap_authentication_login', NULL, 'textfield', 'LDAP', '', 'LDAPAuthenticationLoginTitle', 'LDAPAuthenticationLoginComment', NULL, ''),
  488. ('ldap_authentication_password', NULL, 'textfield', 'LDAP', '', 'LDAPAuthenticationPasswordTitle', 'LDAPAuthenticationPasswordComment', NULL, '');
  489. UNLOCK TABLES;
  490. /*!40000 ALTER TABLE settings_current ENABLE KEYS */;
  491. --
  492. -- Table structure for table settings_options
  493. --
  494. DROP TABLE IF EXISTS settings_options;
  495. CREATE TABLE settings_options (
  496. id int(10) unsigned NOT NULL auto_increment,
  497. variable varchar(255) default NULL,
  498. value varchar(255) default NULL,
  499. display_text varchar(255) NOT NULL default '',
  500. PRIMARY KEY (id),
  501. UNIQUE KEY id (id)
  502. );
  503. --
  504. -- Dumping data for table settings_options
  505. --
  506. /*!40000 ALTER TABLE settings_options DISABLE KEYS */;
  507. LOCK TABLES settings_options WRITE;
  508. INSERT INTO settings_options
  509. (variable, value, display_text)
  510. VALUES
  511. ('show_administrator_data','true','Yes'),
  512. ('show_administrator_data','false','No'),
  513. ('homepage_view','activity','HomepageViewActivity'),
  514. ('homepage_view','2column','HomepageView2column'),
  515. ('homepage_view','3column','HomepageView3column'),
  516. ('show_toolshortcuts','true','Yes'),
  517. ('show_toolshortcuts','false','No'),
  518. ('allow_group_categories','true','Yes'),
  519. ('allow_group_categories','false','No'),
  520. ('server_type','production','ProductionServer'),
  521. ('server_type','test','TestServer'),
  522. ('allow_name_change','true','Yes'),
  523. ('allow_name_change','false','No'),
  524. ('allow_officialcode_change','true','Yes'),
  525. ('allow_officialcode_change','false','No'),
  526. ('allow_registration','true','Yes'),
  527. ('allow_registration','false','No'),
  528. ('allow_registration','approval','AfterApproval'),
  529. ('allow_registration_as_teacher','true','Yes'),
  530. ('allow_registration_as_teacher','false','No'),
  531. ('allow_lostpassword','true','Yes'),
  532. ('allow_lostpassword','false','No'),
  533. ('allow_user_headings','true','Yes'),
  534. ('allow_user_headings','false','No'),
  535. ('allow_personal_agenda','true','Yes'),
  536. ('allow_personal_agenda','false','No'),
  537. ('display_coursecode_in_courselist','true','Yes'),
  538. ('display_coursecode_in_courselist','false','No'),
  539. ('display_teacher_in_courselist','true','Yes'),
  540. ('display_teacher_in_courselist','false','No'),
  541. ('use_document_title','true','Yes'),
  542. ('use_document_title','false','No'),
  543. ('permanently_remove_deleted_files','true','Yes'),
  544. ('permanently_remove_deleted_files','false','No'),
  545. ('dropbox_allow_overwrite','true','Yes'),
  546. ('dropbox_allow_overwrite','false','No'),
  547. ('dropbox_allow_just_upload','true','Yes'),
  548. ('dropbox_allow_just_upload','false','No'),
  549. ('dropbox_allow_student_to_student','true','Yes'),
  550. ('dropbox_allow_student_to_student','false','No'),
  551. ('dropbox_allow_group','true','Yes'),
  552. ('dropbox_allow_group','false','No'),
  553. ('dropbox_allow_mailing','true','Yes'),
  554. ('dropbox_allow_mailing','false','No'),
  555. ('extended_profile','true','Yes'),
  556. ('extended_profile','false','No'),
  557. ('student_view_enabled','true','Yes'),
  558. ('student_view_enabled','false','No'),
  559. ('show_navigation_menu','false','No'),
  560. ('show_navigation_menu','icons','IconsOnly'),
  561. ('show_navigation_menu','text','TextOnly'),
  562. ('show_navigation_menu','iconstext','IconsText'),
  563. ('enable_tool_introduction','true','Yes'),
  564. ('enable_tool_introduction','false','No'),
  565. ('page_after_login', 'index.php', 'CampusHomepage'),
  566. ('page_after_login', 'user_portal.php', 'MyCourses'),
  567. ('breadcrumbs_course_homepage', 'get_lang', 'CourseHomepage'),
  568. ('breadcrumbs_course_homepage', 'course_code', 'CourseCode'),
  569. ('breadcrumbs_course_homepage', 'course_title', 'CourseTitle'),
  570. ('example_material_course_creation', 'true', 'Yes'),
  571. ('example_material_course_creation', 'false', 'No'),
  572. ('use_session_mode', 'true', 'Yes'),
  573. ('use_session_mode', 'false', 'No'),
  574. ('allow_email_editor', 'true' ,'Yes'),
  575. ('allow_email_editor', 'false', 'No'),
  576. ('show_email_addresses','true','Yes'),
  577. ('show_email_addresses','false','No'),
  578. ('wcag_anysurfer_public_pages', 'true', 'Yes'),
  579. ('wcag_anysurfer_public_pages', 'false', 'No'),
  580. ('upload_extensions_list_type', 'blacklist', 'Blacklist'),
  581. ('upload_extensions_list_type', 'whitelist', 'Whitelist'),
  582. ('upload_extensions_skip', 'true', 'Remove'),
  583. ('upload_extensions_skip', 'false', 'Rename'),
  584. ('show_number_of_courses', 'true', 'Yes'),
  585. ('show_number_of_courses', 'false', 'No'),
  586. ('show_empty_course_categories', 'true', 'Yes'),
  587. ('show_empty_course_categories', 'false', 'No'),
  588. ('show_back_link_on_top_of_tree', 'true', 'Yes'),
  589. ('show_back_link_on_top_of_tree', 'false', 'No'),
  590. ('show_different_course_language', 'true', 'Yes'),
  591. ('show_different_course_language', 'false', 'No'),
  592. ('split_users_upload_directory', 'true', 'Yes'),
  593. ('split_users_upload_directory', 'false', 'No'),
  594. ('hide_dltt_markup', 'false', 'No'),
  595. ('hide_dltt_markup', 'true', 'Yes'),
  596. ('display_categories_on_homepage','true','Yes'),
  597. ('display_categories_on_homepage','false','No'),
  598. ('default_forum_view', 'flat', 'Flat'),
  599. ('default_forum_view', 'threaded', 'Threaded'),
  600. ('default_forum_view', 'nested', 'Nested'),
  601. ('survey_email_sender_noreply', 'coach', 'CourseCoachEmailSender'),
  602. ('survey_email_sender_noreply', 'noreply', 'NoReplyEmailSender'),
  603. ('openid_authentication','true','Yes'),
  604. ('openid_authentication','false','No'),
  605. ('gradebook_enable','true','Yes'),
  606. ('gradebook_enable','false','No'),
  607. ('user_selected_theme','true','Yes'),
  608. ('user_selected_theme','false','No'),
  609. ('allow_course_theme','true','Yes'),
  610. ('allow_course_theme','false','No'),
  611. ('display_mini_month_calendar', 'true', 'Yes'),
  612. ('display_mini_month_calendar', 'false', 'No'),
  613. ('display_upcoming_events', 'true', 'Yes'),
  614. ('display_upcoming_events', 'false', 'No'),
  615. ('show_closed_courses', 'true', 'Yes'),
  616. ('show_closed_courses', 'false', 'No'),
  617. ('ldap_version', '2', 'LDAPVersion2'),
  618. ('ldap_version', '3', 'LDAPVersion3');
  619. UNLOCK TABLES;
  620. /*!40000 ALTER TABLE settings_options ENABLE KEYS */;
  621. --
  622. -- Table structure for table sys_announcement
  623. --
  624. DROP TABLE IF EXISTS sys_announcement;
  625. CREATE TABLE sys_announcement (
  626. id int(10) unsigned NOT NULL auto_increment,
  627. date_start datetime NOT NULL default '0000-00-00 00:00:00',
  628. date_end datetime NOT NULL default '0000-00-00 00:00:00',
  629. visible_teacher tinyint NOT NULL default 0,
  630. visible_student tinyint NOT NULL default 0,
  631. visible_guest tinyint NOT NULL default 0,
  632. title varchar(250) NOT NULL default '',
  633. content text NOT NULL,
  634. lang varchar(70) NULL default NULL,
  635. PRIMARY KEY (id)
  636. );
  637. --
  638. -- Dumping data for table sys_announcement
  639. --
  640. /*!40000 ALTER TABLE sys_announcement DISABLE KEYS */;
  641. LOCK TABLES sys_announcement WRITE;
  642. UNLOCK TABLES;
  643. /*!40000 ALTER TABLE sys_announcement ENABLE KEYS */;
  644. --
  645. -- Table structure for table user
  646. --
  647. DROP TABLE IF EXISTS user;
  648. CREATE TABLE user (
  649. user_id int(10) unsigned NOT NULL auto_increment,
  650. lastname varchar(60) default NULL,
  651. firstname varchar(60) default NULL,
  652. username varchar(20) NOT NULL default '',
  653. password varchar(50) NOT NULL default '',
  654. auth_source varchar(50) default 'platform',
  655. email varchar(100) default NULL,
  656. status tinyint(4) NOT NULL default '5',
  657. official_code varchar(40) default NULL,
  658. phone varchar(30) default NULL,
  659. picture_uri varchar(250) default NULL,
  660. creator_id int(10) unsigned default NULL,
  661. competences text,
  662. diplomas text,
  663. openarea text,
  664. teach text,
  665. productions varchar(250) default NULL,
  666. chatcall_user_id int(10) unsigned NOT NULL default '0',
  667. chatcall_date datetime NOT NULL default '0000-00-00 00:00:00',
  668. chatcall_text varchar(50) NOT NULL default '',
  669. language varchar(40) default NULL,
  670. registration_date datetime NOT NULL default '0000-00-00 00:00:00',
  671. expiration_date datetime NOT NULL default '0000-00-00 00:00:00',
  672. active tinyint unsigned NOT NULL default 1,
  673. openid varchar(255) DEFAULT NULL,
  674. theme varchar(255) DEFAULT NULL,
  675. hr_dept_id smallint unsigned NOT NULL default 0,
  676. PRIMARY KEY (user_id),
  677. UNIQUE KEY username (username)
  678. );
  679. ALTER TABLE user ADD INDEX (status);
  680. --
  681. -- Dumping data for table user
  682. --
  683. /*!40000 ALTER TABLE user DISABLE KEYS */;
  684. LOCK TABLES user WRITE;
  685. INSERT INTO user (lastname, firstname, username, password, auth_source, email, status, official_code, creator_id, registration_date, expiration_date,active,openid) VALUES ('{ADMINLASTNAME}','{ADMINFIRSTNAME}','{ADMINLOGIN}','{ADMINPASSWORD}','{PLATFORM_AUTH_SOURCE}','{ADMINEMAIL}',1,'ADMIN',1,NOW(),'0000-00-00 00:00:00','1',NULL);
  686. -- Insert anonymous user
  687. INSERT INTO user (lastname, firstname, username, password, auth_source, email, status, official_code, creator_id, registration_date, expiration_date,active,openid) VALUES ('Anonymous', 'Joe', '', '', 'platform', 'anonymous@localhost', 6, 'anonymous', 1, NOW(), '0000-00-00 00:00:00', 1,NULL);
  688. UNLOCK TABLES;
  689. /*!40000 ALTER TABLE user ENABLE KEYS */;
  690. --
  691. -- Table structure for shared_survey
  692. --
  693. CREATE TABLE shared_survey (
  694. survey_id int(10) unsigned NOT NULL auto_increment,
  695. code varchar(20) default NULL,
  696. title text default NULL,
  697. subtitle text default NULL,
  698. author varchar(250) default NULL,
  699. lang varchar(20) default NULL,
  700. template varchar(20) default NULL,
  701. intro text,
  702. surveythanks text,
  703. creation_date datetime NOT NULL default '0000-00-00 00:00:00',
  704. course_code varchar(40) NOT NULL default '',
  705. PRIMARY KEY (survey_id),
  706. UNIQUE KEY id (survey_id)
  707. );
  708. -- --------------------------------------------------------
  709. --
  710. -- Table structure for shared_survey_question
  711. --
  712. CREATE TABLE shared_survey_question (
  713. question_id int(11) NOT NULL auto_increment,
  714. survey_id int(11) NOT NULL default '0',
  715. survey_question text NOT NULL,
  716. survey_question_comment text NOT NULL,
  717. type varchar(250) NOT NULL default '',
  718. display varchar(10) NOT NULL default '',
  719. sort int(11) NOT NULL default '0',
  720. code varchar(40) NOT NULL default '',
  721. max_value int(11) NOT NULL,
  722. PRIMARY KEY (question_id)
  723. );
  724. -- --------------------------------------------------------
  725. --
  726. -- Table structure for shared_survey_question_option
  727. --
  728. CREATE TABLE shared_survey_question_option (
  729. question_option_id int(11) NOT NULL auto_increment,
  730. question_id int(11) NOT NULL default '0',
  731. survey_id int(11) NOT NULL default '0',
  732. option_text text NOT NULL,
  733. sort int(11) NOT NULL default '0',
  734. PRIMARY KEY (question_option_id)
  735. );
  736. -- --------------------------------------------------------
  737. --
  738. -- Table structure for templates (User's FCKEditor templates)
  739. --
  740. CREATE TABLE templates (
  741. id int NOT NULL auto_increment,
  742. title varchar(100) NOT NULL,
  743. description varchar(250) NOT NULL,
  744. course_code varchar(40) NOT NULL,
  745. user_id int NOT NULL,
  746. ref_doc int NOT NULL,
  747. PRIMARY KEY (id)
  748. );
  749. --
  750. -- --------------------------------------------------------
  751. --
  752. -- Table structure of openid_association (keep info on openid servers)
  753. --
  754. CREATE TABLE IF NOT EXISTS openid_association (
  755. id int NOT NULL auto_increment,
  756. idp_endpoint_uri text NOT NULL,
  757. session_type varchar(30) NOT NULL,
  758. assoc_handle text NOT NULL,
  759. assoc_type text NOT NULL,
  760. expires_in bigint NOT NULL,
  761. mac_key text NOT NULL,
  762. created bigint NOT NULL,
  763. PRIMARY KEY (id)
  764. );
  765. --
  766. -- --------------------------------------------------------
  767. --
  768. -- Tables for gradebook
  769. --
  770. CREATE TABLE gradebook_category (
  771. id int NOT NULL auto_increment,
  772. name text NOT NULL,
  773. description text,
  774. user_id int NOT NULL,
  775. course_code varchar(40) default NULL,
  776. parent_id int default NULL,
  777. weight smallint NOT NULL,
  778. visible tinyint NOT NULL,
  779. certif_min_score int DEFAULT NULL,
  780. PRIMARY KEY (id)
  781. );
  782. CREATE TABLE gradebook_evaluation (
  783. id int unsigned NOT NULL auto_increment,
  784. name text NOT NULL,
  785. description text,
  786. user_id int NOT NULL,
  787. course_code varchar(40) default NULL,
  788. category_id int default NULL,
  789. date int default 0,
  790. weight smallint NOT NULL,
  791. max float unsigned NOT NULL,
  792. visible tinyint NOT NULL,
  793. PRIMARY KEY (id)
  794. );
  795. CREATE TABLE gradebook_link (
  796. id int NOT NULL auto_increment,
  797. type int NOT NULL,
  798. ref_id int NOT NULL,
  799. user_id int NOT NULL,
  800. course_code varchar(40) NOT NULL,
  801. category_id int NOT NULL,
  802. date int default NULL,
  803. weight smallint NOT NULL,
  804. visible tinyint NOT NULL,
  805. PRIMARY KEY (id)
  806. );
  807. CREATE TABLE gradebook_result (
  808. id int NOT NULL auto_increment,
  809. user_id int NOT NULL,
  810. evaluation_id int NOT NULL,
  811. date int NOT NULL,
  812. score float unsigned default NULL,
  813. PRIMARY KEY (id)
  814. );
  815. CREATE TABLE gradebook_score_display (
  816. id int NOT NULL auto_increment,
  817. score float unsigned NOT NULL,
  818. display varchar(40) NOT NULL,
  819. PRIMARY KEY (id)
  820. );
  821. CREATE TABLE user_field (
  822. id INT NOT NULL auto_increment,
  823. field_type int NOT NULL DEFAULT 1,
  824. field_variable varchar(64) NOT NULL,
  825. field_display_text varchar(64),
  826. field_default_value text,
  827. field_order int,
  828. field_visible tinyint default 0,
  829. field_changeable tinyint default 0,
  830. tms TIMESTAMP,
  831. PRIMARY KEY(id)
  832. );
  833. CREATE TABLE user_field_options (
  834. id int NOT NULL auto_increment,
  835. field_id int NOT NULL,
  836. option_value text,
  837. option_display_text varchar(64),
  838. option_order int,
  839. tms TIMESTAMP,
  840. PRIMARY KEY (id)
  841. );
  842. CREATE TABLE user_field_values(
  843. id int NOT NULL auto_increment,
  844. user_id int NOT NULL,
  845. field_id int NOT NULL,
  846. field_value text,
  847. tms TIMESTAMP,
  848. PRIMARY KEY(id)
  849. );