dokeos_main.sql 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797
  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. PRIMARY KEY (`id`),
  290. UNIQUE KEY `name` (`name`)
  291. );
  292. -- --------------------------------------------------------
  293. --
  294. -- Table structure for table `session_rel_course`
  295. --
  296. DROP TABLE IF EXISTS `session_rel_course`;
  297. CREATE TABLE `session_rel_course` (
  298. `id_session` smallint(5) unsigned NOT NULL default '0',
  299. `course_code` char(40) NOT NULL default '',
  300. `id_coach` int(10) unsigned NOT NULL default '0',
  301. `nbr_users` smallint(5) unsigned NOT NULL default '0',
  302. PRIMARY KEY (`id_session`,`course_code`),
  303. KEY `course_code` (`course_code`)
  304. );
  305. -- --------------------------------------------------------
  306. --
  307. -- Table structure for table `session_rel_course_rel_user`
  308. --
  309. DROP TABLE IF EXISTS `session_rel_course_rel_user`;
  310. CREATE TABLE `session_rel_course_rel_user` (
  311. `id_session` smallint(5) unsigned NOT NULL default '0',
  312. `course_code` char(40) NOT NULL default '',
  313. `id_user` int(10) unsigned NOT NULL default '0',
  314. PRIMARY KEY (`id_session`,`course_code`,`id_user`),
  315. KEY `id_user` (`id_user`),
  316. KEY `course_code` (`course_code`)
  317. );
  318. -- --------------------------------------------------------
  319. --
  320. -- Table structure for table `session_rel_user`
  321. --
  322. DROP TABLE IF EXISTS `session_rel_user`;
  323. CREATE TABLE `session_rel_user` (
  324. `id_session` mediumint(8) unsigned NOT NULL default '0',
  325. `id_user` mediumint(8) unsigned NOT NULL default '0',
  326. PRIMARY KEY (`id_session`,`id_user`)
  327. );
  328. --
  329. -- Table structure for table `settings_current`
  330. --
  331. DROP TABLE IF EXISTS `settings_current`;
  332. CREATE TABLE `settings_current` (
  333. `id` int(10) unsigned NOT NULL auto_increment,
  334. `variable` varchar(255) default NULL,
  335. `subkey` varchar(255) default NULL,
  336. `type` varchar(255) default NULL,
  337. `category` varchar(255) default NULL,
  338. `selected_value` varchar(255) default NULL,
  339. `title` varchar(255) NOT NULL default '',
  340. `comment` varchar(255) default NULL,
  341. `scope` varchar(50) default NULL,
  342. `subkeytext` varchar(255) default NULL,
  343. UNIQUE KEY `id` (`id`)
  344. );
  345. --
  346. -- Dumping data for table `settings_current`
  347. --
  348. /*!40000 ALTER TABLE `settings_current` DISABLE KEYS */;
  349. LOCK TABLES `settings_current` WRITE;
  350. INSERT INTO `settings_current` VALUES
  351. (1,'Institution',NULL,'textfield','Platform','{ORGANISATIONNAME}','InstitutionTitle','InstitutionComment','platform',NULL),
  352. (2,'InstitutionUrl',NULL,'textfield','Platform','{ORGANISATIONURL}','InstitutionUrlTitle','InstitutionUrlComment',NULL,NULL),
  353. (3,'siteName',NULL,'textfield','Platform','{CAMPUSNAME}','SiteNameTitle','SiteNameComment',NULL,NULL),
  354. (4,'emailAdministrator',NULL,'textfield','Platform','{ADMINEMAIL}','emailAdministratorTitle','emailAdministratorComment',NULL,NULL),
  355. (5,'administratorSurname',NULL,'textfield','Platform','{ADMINLASTNAME}','administratorSurnameTitle','administratorSurnameComment',NULL,NULL),
  356. (6,'administratorName',NULL,'textfield','Platform','{ADMINFIRSTNAME}','administratorNameTitle','administratorNameComment',NULL,NULL),
  357. (7,'show_administrator_data',NULL,'radio','Platform','true','ShowAdministratorDataTitle','ShowAdministratorDataComment',NULL,NULL),
  358. (8,'homepage_view',NULL,'radio','Course','activity','HomepageViewTitle','HomepageViewComment',NULL,NULL),
  359. (9,'show_toolshortcuts',NULL,'radio','Course','false','ShowToolShortcutsTitle','ShowToolShortcutsComment',NULL,NULL),
  360. (10,'show_student_view',NULL,'radio','Course','false','ShowStudentViewTitle','ShowStudentViewComment',NULL,NULL),
  361. (11,'allow_group_categories',NULL,'radio','Course','false','AllowGroupCategories','AllowGroupCategoriesComment',NULL,NULL),
  362. (12,'server_type',NULL,'radio','Platform','production','ServerStatusTitle','ServerStatusComment',NULL,NULL),
  363. (13,'platformLanguage',NULL,'link','Languages','{PLATFORMLANGUAGE}','PlatformLanguageTitle','PlatformLanguageComment',NULL,NULL),
  364. (14,'showonline','world','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineWorld'),
  365. (15,'showonline','users','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineUsers'),
  366. (16,'showonline','course','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineCourse'),
  367. (17,'profile','name','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'name'),
  368. (18,'profile','officialcode','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'officialcode'),
  369. (19,'profile','email','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Email'),
  370. (20,'profile','picture','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPicture'),
  371. (21,'profile','login','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Login'),
  372. (22,'profile','password','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPassword'),
  373. (23,'profile','language','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'Language'),
  374. (24,'default_document_quotum',NULL,'textfield','Course','50000000','DefaultDocumentQuotumTitle','DefaultDocumentQuotumComment',NULL,NULL),
  375. (25,'registration','officialcode','checkbox','User','false','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'OfficialCode'),
  376. (26,'registration','email','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Email'),
  377. (27,'registration','language','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Language'),
  378. (28,'default_group_quotum',NULL,'textfield','Course','5000000','DefaultGroupQuotumTitle','DefaultGroupQuotumComment',NULL,NULL),
  379. (29,'allow_registration',NULL,'radio','Platform','{ALLOWSELFREGISTRATION}','AllowRegistrationTitle','AllowRegistrationComment',NULL,NULL),
  380. (30,'allow_registration_as_teacher',NULL,'radio','Platform','{ALLOWTEACHERSELFREGISTRATION}','AllowRegistrationAsTeacherTitle','AllowRegistrationAsTeacherComment',NULL,NULL),
  381. (31,'allow_lostpassword',NULL,'radio','Platform','true','AllowLostPasswordTitle','AllowLostPasswordComment',NULL,NULL),
  382. (32,'allow_user_headings',NULL,'radio','Course','false','AllowUserHeadings','AllowUserHeadingsComment',NULL,NULL),
  383. (33,'course_create_active_tools','course_description','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'CourseDescription'),
  384. (34,'course_create_active_tools','agenda','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Agenda'),
  385. (35,'course_create_active_tools','documents','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Documents'),
  386. (36,'course_create_active_tools','learning_path','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'LearningPath'),
  387. (37,'course_create_active_tools','links','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Links'),
  388. (38,'course_create_active_tools','announcements','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Announcements'),
  389. (39,'course_create_active_tools','forums','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Forums'),
  390. (40,'course_create_active_tools','dropbox','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Dropbox'),
  391. (41,'course_create_active_tools','quiz','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Quiz'),
  392. (42,'course_create_active_tools','users','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Users'),
  393. (43,'course_create_active_tools','groups','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Groups'),
  394. (44,'course_create_active_tools','chat','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Chat'),
  395. (45,'course_create_active_tools','online_conference','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'OnlineConference'),
  396. (46,'course_create_active_tools','student_publications','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'StudentPublications'),
  397. (47,'allow_personal_agenda',NULL,'radio','User','false','AllowPersonalAgendaTitle','AllowPersonalAgendaComment',NULL,NULL),
  398. (48,'display_coursecode_in_courselist',NULL,'radio','Platform','true','DisplayCourseCodeInCourselistTitle','DisplayCourseCodeInCourselistComment',NULL,NULL),
  399. (49,'display_teacher_in_courselist',NULL,'radio','Platform','true','DisplayTeacherInCourselistTitle','DisplayTeacherInCourselistComment',NULL,NULL),
  400. (50,'use_document_title',NULL,'radio','Tools','false','UseDocumentTitleTitle','UseDocumentTitleComment',NULL,NULL),
  401. (51,'permanently_remove_deleted_files',NULL,'radio','Tools','false','PermanentlyRemoveFilesTitle','PermanentlyRemoveFilesComment',NULL,NULL),
  402. (52,'dropbox_allow_overwrite',NULL,'radio','Tools','true','DropboxAllowOverwriteTitle','DropboxAllowOverwriteComment',NULL,NULL),
  403. (53,'dropbox_max_filesize',NULL,'textfield','Tools','100000000','DropboxMaxFilesizeTitle','DropboxMaxFilesizeComment',NULL,NULL),
  404. (54,'dropbox_allow_just_upload',NULL,'radio','Tools','true','DropboxAllowJustUploadTitle','DropboxAllowJustUploadComment',NULL,NULL),
  405. (55,'dropbox_allow_student_to_student',NULL,'radio','Tools','true','DropboxAllowStudentToStudentTitle','DropboxAllowStudentToStudentComment',NULL,NULL),
  406. (56,'dropbox_allow_group',NULL,'radio','Tools','true','DropboxAllowGroupTitle','DropboxAllowGroupComment',NULL,NULL),
  407. (57,'dropbox_allow_mailing',NULL,'radio','Tools','false','DropboxAllowMailingTitle','DropboxAllowMailingComment',NULL,NULL),
  408. (58,'administratorTelephone',NULL,'textfield','Platform','(000) 001 02 03','administratorTelephoneTitle','administratorTelephoneComment',NULL,NULL),
  409. (59,'extended_profile',NULL,'radio','User','true','ExtendedProfileTitle','ExtendedProfileComment',NULL,NULL),
  410. (60,'student_view_enabled',NULL,'radio','Platform','true','StudentViewEnabledTitle','StudentViewEnabledComment',NULL,NULL),
  411. (61,'show_navigation_menu',NULL,'radio','Course','false','ShowNavigationMenuTitle','ShowNavigationMenuComment',NULL,NULL),
  412. (62,'enable_tool_introduction',NULL,'radio','course','false','EnableToolIntroductionTitle','EnableToolIntroductionComment',NULL,NULL),
  413. (63, 'page_after_login', NULL, 'radio','Platform','user_portal.php', 'PageAfterLoginTitle','PageAfterLoginComment', NULL, NULL),
  414. (64, 'time_limit_whosonline', NULL, 'textfield','Platform','30', 'TimeLimitWhosonlineTitle','TimeLimitWhosonlineComment', NULL, NULL),
  415. (65, 'breadcrumbs_course_homepage', NULL, 'radio','Course','course_title', 'BreadCrumbsCourseHomepageTitle','BreadCrumbsCourseHomepageComment', NULL, NULL),
  416. (66, 'example_material_course_creation', NULL, 'radio','Platform','true', 'ExampleMaterialCourseCreationTitle','ExampleMaterialCourseCreationComment', NULL, NULL),
  417. (67,'account_valid_duration',NULL, 'textfield','Platform','3660', 'AccountValidDurationTitle','AccountValidDurationComment', NULL, NULL),
  418. (68, 'use_session_mode', NULL, 'radio','Platform','false', 'UseSessionModeTitle','UseSessionModeComment', NULL, NULL),
  419. (69, 'allow_email_editor', NULL, 'radio', 'Tools', 'false', 'AllowEmailEditorTitle', 'AllowEmailEditorComment', NULL, NULL),
  420. (70, 'registered', NULL, 'textfield', NULL, 'false', NULL, NULL, NULL, NULL),
  421. (71, 'donotlistcampus', NULL, 'textfield', NULL, 'false', NULL, NULL, NULL, NULL),
  422. (72, 'show_email_addresses', NULL,'radio','Platform','false','ShowEmailAddresses','ShowEmailAddressesComment',NULL,NULL),
  423. (73,'profile','phone','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'phone'),
  424. (75, 'service_visio', 'active', 'radio',NULL,'false', 'visio_actived','', NULL, NULL),
  425. (76, 'service_visio', 'visioconference_url', 'textfield',NULL,'', 'visio_url','', NULL, NULL),
  426. (77, 'service_visio', 'visioclassroom_url', 'textfield',NULL,'', 'visio_url','', NULL, NULL),
  427. (78, 'service_ppt2lp', 'active', 'radio',NULL,'false', 'ppt2lp_actived','', NULL, NULL),
  428. (79, 'service_ppt2lp', 'host', 'textfield', NULL, NULL, 'Host', NULL, NULL, NULL),
  429. (80, 'service_ppt2lp', 'user', 'textfield', NULL, NULL, 'UserOnHost', NULL, NULL, NULL),
  430. (81, 'service_ppt2lp', 'ftp_password', 'textfield', NULL, NULL, 'FtpPassword', NULL, NULL, NULL),
  431. (82, 'service_ppt2lp', 'path_to_lzx', 'textfield', NULL, NULL, '', NULL, NULL, NULL),
  432. (84, 'service_ppt2lp', 'size', 'radio', NULL, '720x540', '', NULL, NULL, NULL),
  433. (85, 'wcag_anysurfer_public_pages', NULL, 'radio','Platform','false','PublicPagesComplyToWAITitle','PublicPagesComplyToWAIComment', NULL, NULL),
  434. (86, 'stylesheets', NULL, 'textfield','stylesheets','default_with_tabs','',NULL, NULL, NULL),
  435. (87, 'upload_extensions_list_type', NULL, 'radio', 'Security', 'blacklist', 'UploadExtensionsListType', 'UploadExtensionsListTypeComment', NULL, NULL),
  436. (88, 'upload_extensions_blacklist', NULL, 'textfield', 'Security', '', 'UploadExtensionsBlacklist', 'UploadExtensionsBlacklistComment', NULL, NULL),
  437. (89, 'upload_extensions_whitelist', NULL, 'textfield', 'Security', 'htm;html;jpg;jpeg;gif;png;swf;avi;mpg;mpeg', 'UploadExtensionsWhitelist', 'UploadExtensionsWhitelistComment', NULL, NULL),
  438. (90, 'upload_extensions_skip', NULL, 'radio', 'Security', 'true', 'UploadExtensionsSkip', 'UploadExtensionsSkipComment', NULL, NULL),
  439. (91, 'upload_extensions_replace_by', NULL, 'textfield', 'Security', 'dangerous', 'UploadExtensionsReplaceBy', 'UploadExtensionsReplaceByComment', NULL, NULL),
  440. (92, 'service_visio', 'visio_rtmp_host_local', 'textfield',NULL,'', 'VisioHostLocal','', NULL, NULL),
  441. (93, 'service_visio', 'visio_is_web_rtmp', 'radio',NULL,'false', 'VisioRTMPIsWeb','', NULL, NULL),
  442. (94, 'service_visio', 'visio_rtmp_port', 'textfield',NULL,'1935', 'VisioRTMPPort','', NULL, NULL),
  443. (95, 'service_visio', 'visio_rtmp_tunnel_port', 'textfield',NULL,'80', 'VisioRTMPTunnelPort','', NULL, NULL),
  444. (96, 'show_number_of_courses', NULL, 'radio','Platform','false', 'ShowNumberOfCourses','ShowNumberOfCoursesComment', NULL, NULL),
  445. (97, 'show_empty_course_categories', NULL, 'radio','Platform','true', 'ShowEmptyCourseCategories','ShowEmptyCourseCategoriesComment', NULL, NULL),
  446. (98, 'show_back_link_on_top_of_tree', NULL, 'radio','Platform','false', 'ShowBackLinkOnTopOfCourseTree','ShowBackLinkOnTopOfCourseTreeComment', NULL, NULL),
  447. (99, 'show_different_course_language', NULL, 'radio','Platform','true', 'ShowDifferentCourseLanguage','ShowDifferentCourseLanguageComment', NULL, NULL),
  448. (100, 'split_users_upload_directory', NULL, 'radio','Tuning','false', 'SplitUsersUploadDirectory','SplitUsersUploadDirectoryComment', NULL, NULL),
  449. (101, 'hide_dltt_markup', NULL, 'radio','Platform','true', 'HideDLTTMarkup','HideDLTTMarkupComment', NULL, NULL),
  450. (102, 'display_categories_on_homepage',NULL,'radio','Platform','false','DisplayCategoriesOnHomepageTitle','DisplayCategoriesOnHomepageComment',NULL,NULL),
  451. (103, 'permissions_for_new_directories', NULL, 'textfield', 'Security', '0777', 'PermissionsForNewDirs', 'PermissionsForNewDirsComment', NULL, NULL),
  452. (104, 'permissions_for_new_files', NULL, 'textfield', 'Security', '0666', 'PermissionsForNewFiles', 'PermissionsForNewFilesComment', NULL, NULL),
  453. (105, 'show_tabs', 'campus_homepage', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsCampusHomepage'),
  454. (106, 'show_tabs', 'my_courses', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyCourses'),
  455. (107, 'show_tabs', 'reporting', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsReporting'),
  456. (108, 'show_tabs', 'platform_administration', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsPlatformAdministration'),
  457. (109, 'show_tabs', 'my_agenda', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyAgenda'),
  458. (110, 'show_tabs', 'my_profile', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyProfile'),
  459. (111, 'default_forum_view', NULL, 'radio', 'Course', 'flat', 'DefaultForumViewTitle','DefaultForumViewComment',NULL,NULL),
  460. (112, 'platform_charset',NULL,'textfield','Platform','iso-8859-15','PlatformCharsetTitle','PlatformCharsetComment','platform',NULL);
  461. UNLOCK TABLES;
  462. /*!40000 ALTER TABLE `settings_current` ENABLE KEYS */;
  463. --
  464. -- Table structure for table `settings_options`
  465. --
  466. DROP TABLE IF EXISTS `settings_options`;
  467. CREATE TABLE `settings_options` (
  468. `id` int(10) unsigned NOT NULL auto_increment,
  469. `variable` varchar(255) default NULL,
  470. `value` varchar(255) default NULL,
  471. `display_text` varchar(255) NOT NULL default '',
  472. PRIMARY KEY (`id`),
  473. UNIQUE KEY `id` (`id`)
  474. );
  475. --
  476. -- Dumping data for table `settings_options`
  477. --
  478. /*!40000 ALTER TABLE `settings_options` DISABLE KEYS */;
  479. LOCK TABLES `settings_options` WRITE;
  480. INSERT INTO `settings_options` VALUES
  481. (11,'show_administrator_data','true','Yes'),
  482. (12,'show_administrator_data','false','No'),
  483. (13,'homepage_view','activity','HomepageViewActivity'),
  484. (14,'homepage_view','2column','HomepageView2column'),
  485. (15,'homepage_view','3column','HomepageView3column'),
  486. (16,'show_toolshortcuts','true','Yes'),
  487. (17,'show_toolshortcuts','false','No'),
  488. (18,'show_student_view','true','Yes'),
  489. (19,'show_student_view','false','No'),
  490. (20,'allow_group_categories','true','Yes'),
  491. (21,'allow_group_categories','false','No'),
  492. (22,'server_type','production','ProductionServer'),
  493. (23,'server_type','test','TestServer'),
  494. (26,'allow_name_change','true','Yes'),
  495. (27,'allow_name_change','false','No'),
  496. (28,'allow_officialcode_change','true','Yes'),
  497. (29,'allow_officialcode_change','false','No'),
  498. (30,'allow_registration','true','Yes'),
  499. (31,'allow_registration','false','No'),
  500. (32,'allow_registration','approval','AfterApproval'),
  501. (33,'allow_registration_as_teacher','true','Yes'),
  502. (34,'allow_registration_as_teacher','false','No'),
  503. (35,'allow_lostpassword','true','Yes'),
  504. (36,'allow_lostpassword','false','No'),
  505. (37,'allow_user_headings','true','Yes'),
  506. (38,'allow_user_headings','false','No'),
  507. (39,'allow_personal_agenda','true','Yes'),
  508. (40,'allow_personal_agenda','false','No'),
  509. (41,'display_coursecode_in_courselist','true','Yes'),
  510. (42,'display_coursecode_in_courselist','false','No'),
  511. (43,'display_teacher_in_courselist','true','Yes'),
  512. (44,'display_teacher_in_courselist','false','No'),
  513. (45,'use_document_title','true','Yes'),
  514. (46,'use_document_title','false','No'),
  515. (47,'permanently_remove_deleted_files','true','Yes'),
  516. (48,'permanently_remove_deleted_files','false','No'),
  517. (49,'dropbox_allow_overwrite','true','Yes'),
  518. (50,'dropbox_allow_overwrite','false','No'),
  519. (51,'dropbox_allow_just_upload','true','Yes'),
  520. (52,'dropbox_allow_just_upload','false','No'),
  521. (53,'dropbox_allow_student_to_student','true','Yes'),
  522. (54,'dropbox_allow_student_to_student','false','No'),
  523. (55,'dropbox_allow_group','true','Yes'),
  524. (56,'dropbox_allow_group','false','No'),
  525. (57,'dropbox_allow_mailing','true','Yes'),
  526. (58,'dropbox_allow_mailing','false','No'),
  527. (59,'extended_profile','true','Yes'),
  528. (60,'extended_profile','false','No'),
  529. (61,'student_view_enabled','true','Yes'),
  530. (62,'student_view_enabled','false','No'),
  531. (63,'show_navigation_menu','false','No'),
  532. (64,'show_navigation_menu','icons','IconsOnly'),
  533. (65,'show_navigation_menu','text','TextOnly'),
  534. (66,'show_navigation_menu','iconstext','IconsText'),
  535. (67,'enable_tool_introduction','true','Yes'),
  536. (68,'enable_tool_introduction','false','No'),
  537. (69, 'page_after_login', 'index.php', 'CampusHomepage'),
  538. (70, 'page_after_login', 'user_portal.php', 'MyCourses'),
  539. (71,'breadcrumbs_course_homepage', 'get_lang', 'CourseHomepage'),
  540. (72,'breadcrumbs_course_homepage', 'course_code', 'CourseCode'),
  541. (73,'breadcrumbs_course_homepage', 'course_title', 'CourseTitle'),
  542. (74,'example_material_course_creation', 'true', 'Yes'),
  543. (75,'example_material_course_creation', 'false', 'No'),
  544. (76,'use_session_mode', 'true', 'Yes'),
  545. (77,'use_session_mode', 'false', 'No'),
  546. (78,'allow_email_editor', 'true' ,'Yes'),
  547. (79,'allow_email_editor', 'false', 'No'),
  548. (80,'show_email_addresses','true','Yes'),
  549. (81,'show_email_addresses','false','No'),
  550. (82,'wcag_anysurfer_public_pages', 'true', 'Yes'),
  551. (83,'wcag_anysurfer_public_pages', 'false', 'No'),
  552. (84, 'upload_extensions_list_type', 'blacklist', 'Blacklist'),
  553. (85, 'upload_extensions_list_type', 'whitelist', 'Whitelist'),
  554. (86, 'upload_extensions_skip', 'true', 'Remove'),
  555. (87, 'upload_extensions_skip', 'false', 'Rename'),
  556. (88, 'visio_rtmp_host_local', 'true', 'Web'),
  557. (89, 'visio_rtmp_host_local', 'false', 'Not web'),
  558. (90, 'show_number_of_courses', 'true', 'Yes'),
  559. (91, 'show_number_of_courses', 'false', 'No'),
  560. (92, 'show_empty_course_categories', 'true', 'Yes'),
  561. (93, 'show_empty_course_categories', 'false', 'No'),
  562. (94, 'show_back_link_on_top_of_tree', 'true', 'Yes'),
  563. (95, 'show_back_link_on_top_of_tree', 'false', 'No'),
  564. (96, 'show_different_course_language', 'true', 'Yes'),
  565. (97, 'show_different_course_language', 'false', 'No'),
  566. (98, 'split_users_upload_directory', 'true', 'Yes'),
  567. (99, 'split_users_upload_directory', 'false', 'No'),
  568. (100, 'hide_dltt_markup', 'false', 'No'),
  569. (101, 'hide_dltt_markup', 'true', 'Yes'),
  570. (102, 'display_categories_on_homepage','true','Yes'),
  571. (103, 'display_categories_on_homepage','false','No'),
  572. (104, 'default_forum_view', 'flat', 'Flat'),
  573. (105, 'default_forum_view', 'threaded', 'Threaded'),
  574. (106, 'default_forum_view', 'nested', 'Nested');
  575. UNLOCK TABLES;
  576. /*!40000 ALTER TABLE `settings_options` ENABLE KEYS */;
  577. --
  578. -- Table structure for table `sys_announcement`
  579. --
  580. DROP TABLE IF EXISTS `sys_announcement`;
  581. CREATE TABLE `sys_announcement` (
  582. id int(10) unsigned NOT NULL auto_increment,
  583. date_start datetime NOT NULL default '0000-00-00 00:00:00',
  584. date_end datetime NOT NULL default '0000-00-00 00:00:00',
  585. visible_teacher tinyint NOT NULL default 0,
  586. visible_student tinyint NOT NULL default 0,
  587. visible_guest tinyint NOT NULL default 0,
  588. title varchar(250) NOT NULL default '',
  589. content text NOT NULL,
  590. lang varchar(70) NULL default NULL,
  591. PRIMARY KEY (`id`)
  592. );
  593. --
  594. -- Dumping data for table `sys_announcement`
  595. --
  596. /*!40000 ALTER TABLE `sys_announcement` DISABLE KEYS */;
  597. LOCK TABLES `sys_announcement` WRITE;
  598. UNLOCK TABLES;
  599. /*!40000 ALTER TABLE `sys_announcement` ENABLE KEYS */;
  600. --
  601. -- Table structure for table `user`
  602. --
  603. DROP TABLE IF EXISTS `user`;
  604. CREATE TABLE `user` (
  605. `user_id` int(10) unsigned NOT NULL auto_increment,
  606. `lastname` varchar(60) default NULL,
  607. `firstname` varchar(60) default NULL,
  608. `username` varchar(20) NOT NULL default '',
  609. `password` varchar(50) NOT NULL default '',
  610. `auth_source` varchar(50) default 'platform',
  611. `email` varchar(100) default NULL,
  612. `status` tinyint(4) NOT NULL default '5',
  613. `official_code` varchar(40) default NULL,
  614. `phone` varchar(30) default NULL,
  615. `picture_uri` varchar(250) default NULL,
  616. `creator_id` int(10) unsigned default NULL,
  617. `competences` text,
  618. `diplomas` text,
  619. `openarea` text,
  620. `teach` text,
  621. `productions` varchar(250) default NULL,
  622. `chatcall_user_id` int(10) unsigned NOT NULL default '0',
  623. `chatcall_date` datetime NOT NULL default '0000-00-00 00:00:00',
  624. `chatcall_text` varchar(50) NOT NULL default '',
  625. `language` varchar(40) default NULL,
  626. `registration_date` datetime NOT NULL default '0000-00-00 00:00:00',
  627. `expiration_date` datetime NOT NULL default '0000-00-00 00:00:00',
  628. `active` tinyint unsigned NOT NULL default 1,
  629. PRIMARY KEY (`user_id`),
  630. UNIQUE KEY `username` (`username`)
  631. );
  632. ALTER TABLE user ADD INDEX (status);
  633. --
  634. -- Dumping data for table `user`
  635. --
  636. /*!40000 ALTER TABLE `user` DISABLE KEYS */;
  637. LOCK TABLES `user` WRITE;
  638. INSERT INTO `user` VALUES (1,'{ADMINLASTNAME}','{ADMINFIRSTNAME}','{ADMINLOGIN}','{ADMINPASSWORD}','{PLATFORM_AUTH_SOURCE}','{ADMINEMAIL}',1,'ADMIN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'0000-00-00 00:00:00','',NULL,NOW(),'0000-00-00 00:00:00','1');
  639. -- Insert anonymous user
  640. INSERT INTO user(lastname, firstname, username, password, auth_source, email, status, official_code, creator_id, registration_date, expiration_date,active) VALUES ('Anonymous', 'Joe', '', '', 'platform', 'anonymous@localhost', 6, 'anonymous', 1, NOW(), '0000-00-00 00:00:00', 1);
  641. UNLOCK TABLES;
  642. /*!40000 ALTER TABLE `user` ENABLE KEYS */;
  643. --
  644. -- Table structure for `shared_survey`
  645. --
  646. CREATE TABLE `shared_survey` (
  647. `survey_id` int(10) unsigned NOT NULL auto_increment,
  648. `code` varchar(20) default NULL,
  649. `title` text default NULL,
  650. `subtitle` text default NULL,
  651. `author` varchar(250) default NULL,
  652. `lang` varchar(20) default NULL,
  653. `template` varchar(20) default NULL,
  654. `intro` text,
  655. `surveythanks` text,
  656. `creation_date` datetime NOT NULL default '0000-00-00 00:00:00',
  657. `course_code` varchar(40) NOT NULL default '',
  658. PRIMARY KEY (`survey_id`),
  659. UNIQUE KEY `id` (`survey_id`)
  660. );
  661. -- --------------------------------------------------------
  662. --
  663. -- Table structure for `shared_survey_question`
  664. --
  665. CREATE TABLE `shared_survey_question` (
  666. `question_id` int(11) NOT NULL auto_increment,
  667. `survey_id` int(11) NOT NULL default '0',
  668. `survey_question` text NOT NULL,
  669. `survey_question_comment` text NOT NULL,
  670. `type` varchar(250) NOT NULL default '',
  671. `display` varchar(10) NOT NULL default '',
  672. `sort` int(11) NOT NULL default '0',
  673. `code` varchar(40) NOT NULL default '',
  674. `max_value` int(11) NOT NULL,
  675. PRIMARY KEY (`question_id`)
  676. );
  677. -- --------------------------------------------------------
  678. --
  679. -- Table structure for `shared_survey_question_option`
  680. --
  681. CREATE TABLE `shared_survey_question_option` (
  682. `question_option_id` int(11) NOT NULL auto_increment,
  683. `question_id` int(11) NOT NULL default '0',
  684. `survey_id` int(11) NOT NULL default '0',
  685. `option_text` text NOT NULL,
  686. `sort` int(11) NOT NULL default '0',
  687. PRIMARY KEY (`question_option_id`)
  688. );
  689. -- --------------------------------------------------------
  690. --
  691. -- Table structure for `templates` (User's FCKEditor templates)
  692. --
  693. CREATE TABLE `templates` (
  694. `id` int(11) NOT NULL auto_increment,
  695. `title` varchar(100) NOT NULL,
  696. `description` varchar(250) NOT NULL,
  697. `course_code` varchar(40) NOT NULL,
  698. `user_id` int(11) NOT NULL,
  699. `ref_doc` int(11) NOT NULL,
  700. PRIMARY KEY (`id`)
  701. );