db_course2.sql 62 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782
  1. -- MySQL dump 10.13 Distrib 5.5.29, for debian-linux-gnu (i686)
  2. --
  3. -- Host: localhost Database: chamilo1884
  4. -- ------------------------------------------------------
  5. -- Server version 5.5.29-0ubuntu0.12.10.1
  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. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  11. /*!40103 SET TIME_ZONE='+00:00' */;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. --
  17. -- Table structure for table `announcement`
  18. --
  19. DROP TABLE IF EXISTS `announcement`;
  20. /*!40101 SET @saved_cs_client = @@character_set_client */;
  21. /*!40101 SET character_set_client = utf8 */;
  22. CREATE TABLE `announcement` (
  23. `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  24. `title` text,
  25. `content` mediumtext,
  26. `end_date` date DEFAULT NULL,
  27. `display_order` mediumint(9) NOT NULL DEFAULT '0',
  28. `email_sent` tinyint(4) DEFAULT '0',
  29. `session_id` smallint(6) DEFAULT '0',
  30. PRIMARY KEY (`id`),
  31. KEY `session_id` (`session_id`)
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  33. /*!40101 SET character_set_client = @saved_cs_client */;
  34. --
  35. -- Table structure for table `announcement_attachment`
  36. --
  37. DROP TABLE IF EXISTS `announcement_attachment`;
  38. /*!40101 SET @saved_cs_client = @@character_set_client */;
  39. /*!40101 SET character_set_client = utf8 */;
  40. CREATE TABLE `announcement_attachment` (
  41. `id` int(11) NOT NULL AUTO_INCREMENT,
  42. `path` varchar(255) NOT NULL,
  43. `comment` text,
  44. `size` int(11) NOT NULL DEFAULT '0',
  45. `announcement_id` int(11) NOT NULL,
  46. `filename` varchar(255) NOT NULL,
  47. PRIMARY KEY (`id`)
  48. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  49. /*!40101 SET character_set_client = @saved_cs_client */;
  50. --
  51. -- Table structure for table `attendance`
  52. --
  53. DROP TABLE IF EXISTS `attendance`;
  54. /*!40101 SET @saved_cs_client = @@character_set_client */;
  55. /*!40101 SET character_set_client = utf8 */;
  56. CREATE TABLE `attendance` (
  57. `id` int(11) NOT NULL AUTO_INCREMENT,
  58. `name` text NOT NULL,
  59. `description` text,
  60. `active` tinyint(4) NOT NULL DEFAULT '1',
  61. `attendance_qualify_title` varchar(255) DEFAULT NULL,
  62. `attendance_qualify_max` int(11) NOT NULL DEFAULT '0',
  63. `attendance_weight` float(6,2) NOT NULL DEFAULT '0.00',
  64. `session_id` int(11) NOT NULL DEFAULT '0',
  65. `locked` int(11) NOT NULL DEFAULT '0',
  66. PRIMARY KEY (`id`),
  67. KEY `session_id` (`session_id`),
  68. KEY `active` (`active`)
  69. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  70. /*!40101 SET character_set_client = @saved_cs_client */;
  71. --
  72. -- Table structure for table `attendance_calendar`
  73. --
  74. DROP TABLE IF EXISTS `attendance_calendar`;
  75. /*!40101 SET @saved_cs_client = @@character_set_client */;
  76. /*!40101 SET character_set_client = utf8 */;
  77. CREATE TABLE `attendance_calendar` (
  78. `id` int(11) NOT NULL AUTO_INCREMENT,
  79. `attendance_id` int(11) NOT NULL,
  80. `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  81. `done_attendance` tinyint(4) NOT NULL DEFAULT '0',
  82. PRIMARY KEY (`id`),
  83. KEY `attendance_id` (`attendance_id`),
  84. KEY `done_attendance` (`done_attendance`)
  85. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  86. /*!40101 SET character_set_client = @saved_cs_client */;
  87. --
  88. -- Table structure for table `attendance_result`
  89. --
  90. DROP TABLE IF EXISTS `attendance_result`;
  91. /*!40101 SET @saved_cs_client = @@character_set_client */;
  92. /*!40101 SET character_set_client = utf8 */;
  93. CREATE TABLE `attendance_result` (
  94. `id` int(11) NOT NULL AUTO_INCREMENT,
  95. `user_id` int(11) NOT NULL,
  96. `attendance_id` int(11) NOT NULL,
  97. `score` int(11) NOT NULL DEFAULT '0',
  98. PRIMARY KEY (`id`),
  99. KEY `attendance_id` (`attendance_id`),
  100. KEY `user_id` (`user_id`)
  101. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  102. /*!40101 SET character_set_client = @saved_cs_client */;
  103. --
  104. -- Table structure for table `attendance_sheet`
  105. --
  106. DROP TABLE IF EXISTS `attendance_sheet`;
  107. /*!40101 SET @saved_cs_client = @@character_set_client */;
  108. /*!40101 SET character_set_client = utf8 */;
  109. CREATE TABLE `attendance_sheet` (
  110. `user_id` int(11) NOT NULL,
  111. `attendance_calendar_id` int(11) NOT NULL,
  112. `presence` tinyint(4) NOT NULL DEFAULT '0',
  113. PRIMARY KEY (`user_id`,`attendance_calendar_id`),
  114. KEY `presence` (`presence`)
  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  116. /*!40101 SET character_set_client = @saved_cs_client */;
  117. --
  118. -- Table structure for table `attendance_sheet_log`
  119. --
  120. DROP TABLE IF EXISTS `attendance_sheet_log`;
  121. /*!40101 SET @saved_cs_client = @@character_set_client */;
  122. /*!40101 SET character_set_client = utf8 */;
  123. CREATE TABLE `attendance_sheet_log` (
  124. `id` int(11) NOT NULL AUTO_INCREMENT,
  125. `attendance_id` int(11) NOT NULL DEFAULT '0',
  126. `lastedit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  127. `lastedit_type` varchar(200) NOT NULL,
  128. `lastedit_user_id` int(11) NOT NULL DEFAULT '0',
  129. `calendar_date_value` datetime DEFAULT NULL,
  130. PRIMARY KEY (`id`)
  131. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  132. /*!40101 SET character_set_client = @saved_cs_client */;
  133. --
  134. -- Table structure for table `blog`
  135. --
  136. DROP TABLE IF EXISTS `blog`;
  137. /*!40101 SET @saved_cs_client = @@character_set_client */;
  138. /*!40101 SET character_set_client = utf8 */;
  139. CREATE TABLE `blog` (
  140. `blog_id` smallint(6) NOT NULL AUTO_INCREMENT,
  141. `blog_name` varchar(250) NOT NULL DEFAULT '',
  142. `blog_subtitle` varchar(250) DEFAULT NULL,
  143. `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  144. `visibility` tinyint(3) unsigned NOT NULL DEFAULT '0',
  145. `session_id` smallint(6) DEFAULT '0',
  146. PRIMARY KEY (`blog_id`),
  147. KEY `session_id` (`session_id`)
  148. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with blogs in this course';
  149. /*!40101 SET character_set_client = @saved_cs_client */;
  150. --
  151. -- Table structure for table `blog_attachment`
  152. --
  153. DROP TABLE IF EXISTS `blog_attachment`;
  154. /*!40101 SET @saved_cs_client = @@character_set_client */;
  155. /*!40101 SET character_set_client = utf8 */;
  156. CREATE TABLE `blog_attachment` (
  157. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  158. `path` varchar(255) NOT NULL COMMENT 'the real filename',
  159. `comment` text,
  160. `size` int(11) NOT NULL DEFAULT '0',
  161. `post_id` int(11) NOT NULL,
  162. `filename` varchar(255) NOT NULL COMMENT 'the user s file name',
  163. `blog_id` int(11) NOT NULL,
  164. `comment_id` int(11) NOT NULL DEFAULT '0',
  165. PRIMARY KEY (`id`)
  166. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  167. /*!40101 SET character_set_client = @saved_cs_client */;
  168. --
  169. -- Table structure for table `blog_comment`
  170. --
  171. DROP TABLE IF EXISTS `blog_comment`;
  172. /*!40101 SET @saved_cs_client = @@character_set_client */;
  173. /*!40101 SET character_set_client = utf8 */;
  174. CREATE TABLE `blog_comment` (
  175. `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  176. `title` varchar(250) NOT NULL DEFAULT '',
  177. `comment` longtext NOT NULL,
  178. `author_id` int(11) NOT NULL DEFAULT '0',
  179. `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  180. `blog_id` mediumint(9) NOT NULL DEFAULT '0',
  181. `post_id` int(11) NOT NULL DEFAULT '0',
  182. `task_id` int(11) DEFAULT NULL,
  183. `parent_comment_id` int(11) NOT NULL DEFAULT '0',
  184. PRIMARY KEY (`comment_id`)
  185. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with comments on posts in a blog';
  186. /*!40101 SET character_set_client = @saved_cs_client */;
  187. --
  188. -- Table structure for table `blog_post`
  189. --
  190. DROP TABLE IF EXISTS `blog_post`;
  191. /*!40101 SET @saved_cs_client = @@character_set_client */;
  192. /*!40101 SET character_set_client = utf8 */;
  193. CREATE TABLE `blog_post` (
  194. `post_id` int(11) NOT NULL AUTO_INCREMENT,
  195. `title` varchar(250) NOT NULL DEFAULT '',
  196. `full_text` longtext NOT NULL,
  197. `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  198. `blog_id` mediumint(9) NOT NULL DEFAULT '0',
  199. `author_id` int(11) NOT NULL DEFAULT '0',
  200. PRIMARY KEY (`post_id`)
  201. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with posts / blog.';
  202. /*!40101 SET character_set_client = @saved_cs_client */;
  203. --
  204. -- Table structure for table `blog_rating`
  205. --
  206. DROP TABLE IF EXISTS `blog_rating`;
  207. /*!40101 SET @saved_cs_client = @@character_set_client */;
  208. /*!40101 SET character_set_client = utf8 */;
  209. CREATE TABLE `blog_rating` (
  210. `rating_id` int(11) NOT NULL AUTO_INCREMENT,
  211. `blog_id` int(11) NOT NULL DEFAULT '0',
  212. `rating_type` enum('post','comment') NOT NULL DEFAULT 'post',
  213. `item_id` int(11) NOT NULL DEFAULT '0',
  214. `user_id` int(11) NOT NULL DEFAULT '0',
  215. `rating` mediumint(9) NOT NULL DEFAULT '0',
  216. PRIMARY KEY (`rating_id`)
  217. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with ratings for post/comments in a certain blog';
  218. /*!40101 SET character_set_client = @saved_cs_client */;
  219. --
  220. -- Table structure for table `blog_rel_user`
  221. --
  222. DROP TABLE IF EXISTS `blog_rel_user`;
  223. /*!40101 SET @saved_cs_client = @@character_set_client */;
  224. /*!40101 SET character_set_client = utf8 */;
  225. CREATE TABLE `blog_rel_user` (
  226. `blog_id` int(11) NOT NULL DEFAULT '0',
  227. `user_id` int(11) NOT NULL DEFAULT '0',
  228. PRIMARY KEY (`blog_id`,`user_id`)
  229. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table representing users subscribed to a blog';
  230. /*!40101 SET character_set_client = @saved_cs_client */;
  231. --
  232. -- Table structure for table `blog_task`
  233. --
  234. DROP TABLE IF EXISTS `blog_task`;
  235. /*!40101 SET @saved_cs_client = @@character_set_client */;
  236. /*!40101 SET character_set_client = utf8 */;
  237. CREATE TABLE `blog_task` (
  238. `task_id` mediumint(9) NOT NULL AUTO_INCREMENT,
  239. `blog_id` mediumint(9) NOT NULL DEFAULT '0',
  240. `title` varchar(250) NOT NULL DEFAULT '',
  241. `description` text NOT NULL,
  242. `color` varchar(10) NOT NULL DEFAULT '',
  243. `system_task` tinyint(3) unsigned NOT NULL DEFAULT '0',
  244. PRIMARY KEY (`task_id`)
  245. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with tasks for a blog';
  246. /*!40101 SET character_set_client = @saved_cs_client */;
  247. --
  248. -- Table structure for table `blog_task_rel_user`
  249. --
  250. DROP TABLE IF EXISTS `blog_task_rel_user`;
  251. /*!40101 SET @saved_cs_client = @@character_set_client */;
  252. /*!40101 SET character_set_client = utf8 */;
  253. CREATE TABLE `blog_task_rel_user` (
  254. `blog_id` mediumint(9) NOT NULL DEFAULT '0',
  255. `user_id` int(11) NOT NULL DEFAULT '0',
  256. `task_id` mediumint(9) NOT NULL DEFAULT '0',
  257. `target_date` date NOT NULL DEFAULT '0000-00-00',
  258. PRIMARY KEY (`blog_id`,`user_id`,`task_id`)
  259. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with tasks assigned to a user in a blog';
  260. /*!40101 SET character_set_client = @saved_cs_client */;
  261. --
  262. -- Table structure for table `calendar_event`
  263. --
  264. DROP TABLE IF EXISTS `calendar_event`;
  265. /*!40101 SET @saved_cs_client = @@character_set_client */;
  266. /*!40101 SET character_set_client = utf8 */;
  267. CREATE TABLE `calendar_event` (
  268. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  269. `title` varchar(255) NOT NULL,
  270. `content` text,
  271. `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  272. `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  273. `parent_event_id` int(11) DEFAULT NULL,
  274. `session_id` int(10) unsigned NOT NULL DEFAULT '0',
  275. PRIMARY KEY (`id`),
  276. KEY `session_id` (`session_id`)
  277. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  278. /*!40101 SET character_set_client = @saved_cs_client */;
  279. --
  280. -- Table structure for table `calendar_event_attachment`
  281. --
  282. DROP TABLE IF EXISTS `calendar_event_attachment`;
  283. /*!40101 SET @saved_cs_client = @@character_set_client */;
  284. /*!40101 SET character_set_client = utf8 */;
  285. CREATE TABLE `calendar_event_attachment` (
  286. `id` int(11) NOT NULL AUTO_INCREMENT,
  287. `path` varchar(255) NOT NULL,
  288. `comment` text,
  289. `size` int(11) NOT NULL DEFAULT '0',
  290. `agenda_id` int(11) NOT NULL,
  291. `filename` varchar(255) NOT NULL,
  292. PRIMARY KEY (`id`)
  293. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  294. /*!40101 SET character_set_client = @saved_cs_client */;
  295. --
  296. -- Table structure for table `calendar_event_repeat`
  297. --
  298. DROP TABLE IF EXISTS `calendar_event_repeat`;
  299. /*!40101 SET @saved_cs_client = @@character_set_client */;
  300. /*!40101 SET character_set_client = utf8 */;
  301. CREATE TABLE `calendar_event_repeat` (
  302. `cal_id` int(11) NOT NULL DEFAULT '0',
  303. `cal_type` varchar(20) DEFAULT NULL,
  304. `cal_end` int(11) DEFAULT NULL,
  305. `cal_frequency` int(11) DEFAULT '1',
  306. `cal_days` char(7) DEFAULT NULL,
  307. PRIMARY KEY (`cal_id`)
  308. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  309. /*!40101 SET character_set_client = @saved_cs_client */;
  310. --
  311. -- Table structure for table `calendar_event_repeat_not`
  312. --
  313. DROP TABLE IF EXISTS `calendar_event_repeat_not`;
  314. /*!40101 SET @saved_cs_client = @@character_set_client */;
  315. /*!40101 SET character_set_client = utf8 */;
  316. CREATE TABLE `calendar_event_repeat_not` (
  317. `cal_id` int(11) NOT NULL,
  318. `cal_date` int(11) NOT NULL,
  319. PRIMARY KEY (`cal_id`,`cal_date`)
  320. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  321. /*!40101 SET character_set_client = @saved_cs_client */;
  322. --
  323. -- Table structure for table `chat_connected`
  324. --
  325. DROP TABLE IF EXISTS `chat_connected`;
  326. /*!40101 SET @saved_cs_client = @@character_set_client */;
  327. /*!40101 SET character_set_client = utf8 */;
  328. CREATE TABLE `chat_connected` (
  329. `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  330. `last_connection` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  331. `session_id` int(11) NOT NULL DEFAULT '0',
  332. `to_group_id` int(11) NOT NULL DEFAULT '0',
  333. KEY `char_connected_index` (`user_id`,`session_id`,`to_group_id`)
  334. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  335. /*!40101 SET character_set_client = @saved_cs_client */;
  336. --
  337. -- Table structure for table `course_description`
  338. --
  339. DROP TABLE IF EXISTS `course_description`;
  340. /*!40101 SET @saved_cs_client = @@character_set_client */;
  341. /*!40101 SET character_set_client = utf8 */;
  342. CREATE TABLE `course_description` (
  343. `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  344. `title` varchar(255) DEFAULT NULL,
  345. `content` text,
  346. `session_id` smallint(6) DEFAULT '0',
  347. `description_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  348. `progress` int(11) NOT NULL DEFAULT '0',
  349. UNIQUE KEY `id` (`id`),
  350. KEY `session_id` (`session_id`)
  351. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  352. /*!40101 SET character_set_client = @saved_cs_client */;
  353. --
  354. -- Table structure for table `course_setting`
  355. --
  356. DROP TABLE IF EXISTS `course_setting`;
  357. /*!40101 SET @saved_cs_client = @@character_set_client */;
  358. /*!40101 SET character_set_client = utf8 */;
  359. CREATE TABLE `course_setting` (
  360. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  361. `variable` varchar(255) NOT NULL DEFAULT '',
  362. `subkey` varchar(255) DEFAULT NULL,
  363. `type` varchar(255) DEFAULT NULL,
  364. `category` varchar(255) DEFAULT NULL,
  365. `value` varchar(255) NOT NULL DEFAULT '',
  366. `title` varchar(255) NOT NULL DEFAULT '',
  367. `comment` varchar(255) DEFAULT NULL,
  368. `subkeytext` varchar(255) DEFAULT NULL,
  369. PRIMARY KEY (`id`)
  370. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  371. /*!40101 SET character_set_client = @saved_cs_client */;
  372. --
  373. -- Table structure for table `document`
  374. --
  375. DROP TABLE IF EXISTS `document`;
  376. /*!40101 SET @saved_cs_client = @@character_set_client */;
  377. /*!40101 SET character_set_client = utf8 */;
  378. CREATE TABLE `document` (
  379. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  380. `path` varchar(255) NOT NULL DEFAULT '',
  381. `comment` text,
  382. `title` varchar(255) DEFAULT NULL,
  383. `filetype` set('file','folder') NOT NULL DEFAULT 'file',
  384. `size` int(11) NOT NULL DEFAULT '0',
  385. `readonly` tinyint(3) unsigned NOT NULL,
  386. `session_id` int(10) unsigned NOT NULL DEFAULT '0',
  387. PRIMARY KEY (`id`)
  388. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  389. /*!40101 SET character_set_client = @saved_cs_client */;
  390. --
  391. -- Table structure for table `dropbox_category`
  392. --
  393. DROP TABLE IF EXISTS `dropbox_category`;
  394. /*!40101 SET @saved_cs_client = @@character_set_client */;
  395. /*!40101 SET character_set_client = utf8 */;
  396. CREATE TABLE `dropbox_category` (
  397. `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  398. `cat_name` text NOT NULL,
  399. `received` tinyint(3) unsigned NOT NULL DEFAULT '0',
  400. `sent` tinyint(3) unsigned NOT NULL DEFAULT '0',
  401. `user_id` int(11) NOT NULL DEFAULT '0',
  402. `session_id` smallint(6) NOT NULL DEFAULT '0',
  403. PRIMARY KEY (`cat_id`),
  404. KEY `session_id` (`session_id`)
  405. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  406. /*!40101 SET character_set_client = @saved_cs_client */;
  407. --
  408. -- Table structure for table `dropbox_feedback`
  409. --
  410. DROP TABLE IF EXISTS `dropbox_feedback`;
  411. /*!40101 SET @saved_cs_client = @@character_set_client */;
  412. /*!40101 SET character_set_client = utf8 */;
  413. CREATE TABLE `dropbox_feedback` (
  414. `feedback_id` int(11) NOT NULL AUTO_INCREMENT,
  415. `file_id` int(11) NOT NULL DEFAULT '0',
  416. `author_user_id` int(11) NOT NULL DEFAULT '0',
  417. `feedback` text NOT NULL,
  418. `feedback_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  419. PRIMARY KEY (`feedback_id`),
  420. KEY `file_id` (`file_id`),
  421. KEY `author_user_id` (`author_user_id`)
  422. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  423. /*!40101 SET character_set_client = @saved_cs_client */;
  424. --
  425. -- Table structure for table `dropbox_file`
  426. --
  427. DROP TABLE IF EXISTS `dropbox_file`;
  428. /*!40101 SET @saved_cs_client = @@character_set_client */;
  429. /*!40101 SET character_set_client = utf8 */;
  430. CREATE TABLE `dropbox_file` (
  431. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  432. `uploader_id` int(10) unsigned NOT NULL DEFAULT '0',
  433. `filename` varchar(250) NOT NULL DEFAULT '',
  434. `filesize` int(10) unsigned NOT NULL,
  435. `title` varchar(250) DEFAULT '',
  436. `description` varchar(250) DEFAULT '',
  437. `author` varchar(250) DEFAULT '',
  438. `upload_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  439. `last_upload_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  440. `cat_id` int(11) NOT NULL DEFAULT '0',
  441. `session_id` smallint(5) unsigned NOT NULL,
  442. PRIMARY KEY (`id`),
  443. UNIQUE KEY `UN_filename` (`filename`),
  444. KEY `session_id` (`session_id`)
  445. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  446. /*!40101 SET character_set_client = @saved_cs_client */;
  447. --
  448. -- Table structure for table `dropbox_person`
  449. --
  450. DROP TABLE IF EXISTS `dropbox_person`;
  451. /*!40101 SET @saved_cs_client = @@character_set_client */;
  452. /*!40101 SET character_set_client = utf8 */;
  453. CREATE TABLE `dropbox_person` (
  454. `file_id` int(10) unsigned NOT NULL,
  455. `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  456. PRIMARY KEY (`file_id`,`user_id`)
  457. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  458. /*!40101 SET character_set_client = @saved_cs_client */;
  459. --
  460. -- Table structure for table `dropbox_post`
  461. --
  462. DROP TABLE IF EXISTS `dropbox_post`;
  463. /*!40101 SET @saved_cs_client = @@character_set_client */;
  464. /*!40101 SET character_set_client = utf8 */;
  465. CREATE TABLE `dropbox_post` (
  466. `file_id` int(10) unsigned NOT NULL,
  467. `dest_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  468. `feedback_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  469. `feedback` text,
  470. `cat_id` int(11) NOT NULL DEFAULT '0',
  471. `session_id` smallint(5) unsigned NOT NULL,
  472. PRIMARY KEY (`file_id`,`dest_user_id`),
  473. KEY `session_id` (`session_id`)
  474. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  475. /*!40101 SET character_set_client = @saved_cs_client */;
  476. --
  477. -- Table structure for table `forum_attachment`
  478. --
  479. DROP TABLE IF EXISTS `forum_attachment`;
  480. /*!40101 SET @saved_cs_client = @@character_set_client */;
  481. /*!40101 SET character_set_client = utf8 */;
  482. CREATE TABLE `forum_attachment` (
  483. `id` int(11) NOT NULL AUTO_INCREMENT,
  484. `path` varchar(255) NOT NULL,
  485. `comment` text,
  486. `size` int(11) NOT NULL DEFAULT '0',
  487. `post_id` int(11) NOT NULL,
  488. `filename` varchar(255) NOT NULL,
  489. PRIMARY KEY (`id`)
  490. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  491. /*!40101 SET character_set_client = @saved_cs_client */;
  492. --
  493. -- Table structure for table `forum_category`
  494. --
  495. DROP TABLE IF EXISTS `forum_category`;
  496. /*!40101 SET @saved_cs_client = @@character_set_client */;
  497. /*!40101 SET character_set_client = utf8 */;
  498. CREATE TABLE `forum_category` (
  499. `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  500. `cat_title` varchar(255) NOT NULL DEFAULT '',
  501. `cat_comment` text,
  502. `cat_order` int(11) NOT NULL DEFAULT '0',
  503. `locked` int(11) NOT NULL DEFAULT '0',
  504. `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  505. PRIMARY KEY (`cat_id`),
  506. KEY `session_id` (`session_id`)
  507. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  508. /*!40101 SET character_set_client = @saved_cs_client */;
  509. --
  510. -- Table structure for table `forum_forum`
  511. --
  512. DROP TABLE IF EXISTS `forum_forum`;
  513. /*!40101 SET @saved_cs_client = @@character_set_client */;
  514. /*!40101 SET character_set_client = utf8 */;
  515. CREATE TABLE `forum_forum` (
  516. `forum_id` int(11) NOT NULL AUTO_INCREMENT,
  517. `forum_title` varchar(255) NOT NULL DEFAULT '',
  518. `forum_comment` text,
  519. `forum_threads` int(11) DEFAULT '0',
  520. `forum_posts` int(11) DEFAULT '0',
  521. `forum_last_post` int(11) DEFAULT '0',
  522. `forum_category` int(11) DEFAULT NULL,
  523. `allow_anonymous` int(11) DEFAULT NULL,
  524. `allow_edit` int(11) DEFAULT NULL,
  525. `approval_direct_post` varchar(20) DEFAULT NULL,
  526. `allow_attachments` int(11) DEFAULT NULL,
  527. `allow_new_threads` int(11) DEFAULT NULL,
  528. `default_view` varchar(20) DEFAULT NULL,
  529. `forum_of_group` varchar(20) DEFAULT NULL,
  530. `forum_group_public_private` varchar(20) DEFAULT 'public',
  531. `forum_order` int(11) DEFAULT NULL,
  532. `locked` int(11) NOT NULL DEFAULT '0',
  533. `session_id` int(11) NOT NULL DEFAULT '0',
  534. `forum_image` varchar(255) NOT NULL DEFAULT '',
  535. `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  536. `end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  537. PRIMARY KEY (`forum_id`)
  538. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  539. /*!40101 SET character_set_client = @saved_cs_client */;
  540. --
  541. -- Table structure for table `forum_mailcue`
  542. --
  543. DROP TABLE IF EXISTS `forum_mailcue`;
  544. /*!40101 SET @saved_cs_client = @@character_set_client */;
  545. /*!40101 SET character_set_client = utf8 */;
  546. CREATE TABLE `forum_mailcue` (
  547. `thread_id` int(11) DEFAULT NULL,
  548. `user_id` int(11) DEFAULT NULL,
  549. `post_id` int(11) DEFAULT NULL
  550. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  551. /*!40101 SET character_set_client = @saved_cs_client */;
  552. --
  553. -- Table structure for table `forum_notification`
  554. --
  555. DROP TABLE IF EXISTS `forum_notification`;
  556. /*!40101 SET @saved_cs_client = @@character_set_client */;
  557. /*!40101 SET character_set_client = utf8 */;
  558. CREATE TABLE `forum_notification` (
  559. `user_id` int(11) DEFAULT NULL,
  560. `forum_id` int(11) DEFAULT NULL,
  561. `thread_id` int(11) DEFAULT NULL,
  562. `post_id` int(11) DEFAULT NULL,
  563. KEY `user_id` (`user_id`),
  564. KEY `forum_id` (`forum_id`)
  565. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  566. /*!40101 SET character_set_client = @saved_cs_client */;
  567. --
  568. -- Table structure for table `forum_post`
  569. --
  570. DROP TABLE IF EXISTS `forum_post`;
  571. /*!40101 SET @saved_cs_client = @@character_set_client */;
  572. /*!40101 SET character_set_client = utf8 */;
  573. CREATE TABLE `forum_post` (
  574. `post_id` int(11) NOT NULL AUTO_INCREMENT,
  575. `post_title` varchar(250) DEFAULT NULL,
  576. `post_text` text,
  577. `thread_id` int(11) DEFAULT '0',
  578. `forum_id` int(11) DEFAULT '0',
  579. `poster_id` int(11) DEFAULT '0',
  580. `poster_name` varchar(100) DEFAULT '',
  581. `post_date` datetime DEFAULT '0000-00-00 00:00:00',
  582. `post_notification` tinyint(4) DEFAULT '0',
  583. `post_parent_id` int(11) DEFAULT '0',
  584. `visible` tinyint(4) DEFAULT '1',
  585. PRIMARY KEY (`post_id`),
  586. KEY `poster_id` (`poster_id`),
  587. KEY `forum_id` (`forum_id`),
  588. KEY `idx_forum_post_thread_id` (`thread_id`),
  589. KEY `idx_forum_post_visible` (`visible`)
  590. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  591. /*!40101 SET character_set_client = @saved_cs_client */;
  592. --
  593. -- Table structure for table `forum_thread`
  594. --
  595. DROP TABLE IF EXISTS `forum_thread`;
  596. /*!40101 SET @saved_cs_client = @@character_set_client */;
  597. /*!40101 SET character_set_client = utf8 */;
  598. CREATE TABLE `forum_thread` (
  599. `thread_id` int(11) NOT NULL AUTO_INCREMENT,
  600. `thread_title` varchar(255) DEFAULT NULL,
  601. `forum_id` int(11) DEFAULT NULL,
  602. `thread_replies` int(11) DEFAULT '0',
  603. `thread_poster_id` int(11) DEFAULT NULL,
  604. `thread_poster_name` varchar(100) DEFAULT '',
  605. `thread_views` int(11) DEFAULT '0',
  606. `thread_last_post` int(11) DEFAULT NULL,
  607. `thread_date` datetime DEFAULT '0000-00-00 00:00:00',
  608. `thread_sticky` tinyint(3) unsigned DEFAULT '0',
  609. `locked` int(11) NOT NULL DEFAULT '0',
  610. `session_id` int(10) unsigned DEFAULT NULL,
  611. `thread_title_qualify` varchar(255) DEFAULT '',
  612. `thread_qualify_max` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  613. `thread_close_date` datetime DEFAULT '0000-00-00 00:00:00',
  614. `thread_weight` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  615. PRIMARY KEY (`thread_id`),
  616. KEY `idx_forum_thread_forum_id` (`forum_id`)
  617. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  618. /*!40101 SET character_set_client = @saved_cs_client */;
  619. --
  620. -- Table structure for table `forum_thread_qualify`
  621. --
  622. DROP TABLE IF EXISTS `forum_thread_qualify`;
  623. /*!40101 SET @saved_cs_client = @@character_set_client */;
  624. /*!40101 SET character_set_client = utf8 */;
  625. CREATE TABLE `forum_thread_qualify` (
  626. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  627. `user_id` int(10) unsigned NOT NULL,
  628. `thread_id` int(11) NOT NULL,
  629. `qualify` float(6,2) NOT NULL DEFAULT '0.00',
  630. `qualify_user_id` int(11) DEFAULT NULL,
  631. `qualify_time` datetime DEFAULT '0000-00-00 00:00:00',
  632. `session_id` int(11) DEFAULT NULL,
  633. PRIMARY KEY (`id`),
  634. KEY `user_id` (`user_id`,`thread_id`)
  635. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  636. /*!40101 SET character_set_client = @saved_cs_client */;
  637. --
  638. -- Table structure for table `forum_thread_qualify_log`
  639. --
  640. DROP TABLE IF EXISTS `forum_thread_qualify_log`;
  641. /*!40101 SET @saved_cs_client = @@character_set_client */;
  642. /*!40101 SET character_set_client = utf8 */;
  643. CREATE TABLE `forum_thread_qualify_log` (
  644. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  645. `user_id` int(10) unsigned NOT NULL,
  646. `thread_id` int(11) NOT NULL,
  647. `qualify` float(6,2) NOT NULL DEFAULT '0.00',
  648. `qualify_user_id` int(11) DEFAULT NULL,
  649. `qualify_time` datetime DEFAULT '0000-00-00 00:00:00',
  650. `session_id` int(11) DEFAULT NULL,
  651. PRIMARY KEY (`id`),
  652. KEY `user_id` (`user_id`,`thread_id`)
  653. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  654. /*!40101 SET character_set_client = @saved_cs_client */;
  655. --
  656. -- Table structure for table `glossary`
  657. --
  658. DROP TABLE IF EXISTS `glossary`;
  659. /*!40101 SET @saved_cs_client = @@character_set_client */;
  660. /*!40101 SET character_set_client = utf8 */;
  661. CREATE TABLE `glossary` (
  662. `glossary_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  663. `name` varchar(255) NOT NULL,
  664. `description` text NOT NULL,
  665. `display_order` int(11) DEFAULT NULL,
  666. `session_id` smallint(6) DEFAULT '0',
  667. PRIMARY KEY (`glossary_id`),
  668. KEY `session_id` (`session_id`)
  669. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  670. /*!40101 SET character_set_client = @saved_cs_client */;
  671. --
  672. -- Table structure for table `group_category`
  673. --
  674. DROP TABLE IF EXISTS `group_category`;
  675. /*!40101 SET @saved_cs_client = @@character_set_client */;
  676. /*!40101 SET character_set_client = utf8 */;
  677. CREATE TABLE `group_category` (
  678. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  679. `title` varchar(255) NOT NULL DEFAULT '',
  680. `description` text NOT NULL,
  681. `doc_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  682. `calendar_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  683. `work_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  684. `announcements_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  685. `forum_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  686. `wiki_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  687. `chat_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  688. `max_student` smallint(5) unsigned NOT NULL DEFAULT '8',
  689. `self_reg_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
  690. `self_unreg_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
  691. `groups_per_user` smallint(5) unsigned NOT NULL DEFAULT '0',
  692. `display_order` smallint(5) unsigned NOT NULL DEFAULT '0',
  693. PRIMARY KEY (`id`)
  694. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  695. /*!40101 SET character_set_client = @saved_cs_client */;
  696. --
  697. -- Table structure for table `group_info`
  698. --
  699. DROP TABLE IF EXISTS `group_info`;
  700. /*!40101 SET @saved_cs_client = @@character_set_client */;
  701. /*!40101 SET character_set_client = utf8 */;
  702. CREATE TABLE `group_info` (
  703. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  704. `name` varchar(100) DEFAULT NULL,
  705. `category_id` int(10) unsigned NOT NULL DEFAULT '0',
  706. `description` text,
  707. `max_student` smallint(5) unsigned NOT NULL DEFAULT '8',
  708. `doc_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  709. `calendar_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  710. `work_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  711. `announcements_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  712. `forum_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  713. `wiki_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  714. `chat_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
  715. `secret_directory` varchar(255) DEFAULT NULL,
  716. `self_registration_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
  717. `self_unregistration_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
  718. `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  719. PRIMARY KEY (`id`),
  720. KEY `session_id` (`session_id`)
  721. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  722. /*!40101 SET character_set_client = @saved_cs_client */;
  723. --
  724. -- Table structure for table `group_rel_tutor`
  725. --
  726. DROP TABLE IF EXISTS `group_rel_tutor`;
  727. /*!40101 SET @saved_cs_client = @@character_set_client */;
  728. /*!40101 SET character_set_client = utf8 */;
  729. CREATE TABLE `group_rel_tutor` (
  730. `id` int(11) NOT NULL AUTO_INCREMENT,
  731. `user_id` int(11) NOT NULL,
  732. `group_id` int(11) NOT NULL DEFAULT '0',
  733. PRIMARY KEY (`id`)
  734. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  735. /*!40101 SET character_set_client = @saved_cs_client */;
  736. --
  737. -- Table structure for table `group_rel_user`
  738. --
  739. DROP TABLE IF EXISTS `group_rel_user`;
  740. /*!40101 SET @saved_cs_client = @@character_set_client */;
  741. /*!40101 SET character_set_client = utf8 */;
  742. CREATE TABLE `group_rel_user` (
  743. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  744. `user_id` int(10) unsigned NOT NULL,
  745. `group_id` int(10) unsigned NOT NULL DEFAULT '0',
  746. `status` int(11) NOT NULL DEFAULT '0',
  747. `role` char(50) NOT NULL,
  748. PRIMARY KEY (`id`)
  749. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  750. /*!40101 SET character_set_client = @saved_cs_client */;
  751. --
  752. -- Table structure for table `item_property`
  753. --
  754. DROP TABLE IF EXISTS `item_property`;
  755. /*!40101 SET @saved_cs_client = @@character_set_client */;
  756. /*!40101 SET character_set_client = utf8 */;
  757. CREATE TABLE `item_property` (
  758. `id` int(11) NOT NULL AUTO_INCREMENT,
  759. `tool` varchar(100) NOT NULL DEFAULT '',
  760. `insert_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  761. `insert_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  762. `lastedit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  763. `ref` int(11) NOT NULL DEFAULT '0',
  764. `lastedit_type` varchar(100) NOT NULL DEFAULT '',
  765. `lastedit_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  766. `to_group_id` int(10) unsigned DEFAULT NULL,
  767. `to_user_id` int(10) unsigned DEFAULT NULL,
  768. `visibility` tinyint(4) NOT NULL DEFAULT '1',
  769. `start_visible` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  770. `end_visible` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  771. `id_session` int(11) NOT NULL DEFAULT '0',
  772. PRIMARY KEY (`id`),
  773. KEY `idx_item_property_toolref` (`tool`,`ref`)
  774. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  775. /*!40101 SET character_set_client = @saved_cs_client */;
  776. --
  777. -- Table structure for table `link`
  778. --
  779. DROP TABLE IF EXISTS `link`;
  780. /*!40101 SET @saved_cs_client = @@character_set_client */;
  781. /*!40101 SET character_set_client = utf8 */;
  782. CREATE TABLE `link` (
  783. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  784. `url` text NOT NULL,
  785. `title` varchar(150) DEFAULT NULL,
  786. `description` text,
  787. `category_id` smallint(5) unsigned DEFAULT NULL,
  788. `display_order` smallint(5) unsigned NOT NULL DEFAULT '0',
  789. `on_homepage` enum('0','1') NOT NULL DEFAULT '0',
  790. `target` char(10) DEFAULT '_self',
  791. `session_id` smallint(6) DEFAULT '0',
  792. PRIMARY KEY (`id`),
  793. KEY `session_id` (`session_id`)
  794. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  795. /*!40101 SET character_set_client = @saved_cs_client */;
  796. --
  797. -- Table structure for table `link_category`
  798. --
  799. DROP TABLE IF EXISTS `link_category`;
  800. /*!40101 SET @saved_cs_client = @@character_set_client */;
  801. /*!40101 SET character_set_client = utf8 */;
  802. CREATE TABLE `link_category` (
  803. `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  804. `category_title` varchar(255) NOT NULL,
  805. `description` text,
  806. `display_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
  807. `session_id` smallint(6) DEFAULT '0',
  808. PRIMARY KEY (`id`),
  809. KEY `session_id` (`session_id`)
  810. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  811. /*!40101 SET character_set_client = @saved_cs_client */;
  812. --
  813. -- Table structure for table `lp`
  814. --
  815. DROP TABLE IF EXISTS `lp`;
  816. /*!40101 SET @saved_cs_client = @@character_set_client */;
  817. /*!40101 SET character_set_client = utf8 */;
  818. CREATE TABLE `lp` (
  819. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  820. `lp_type` smallint(5) unsigned NOT NULL,
  821. `name` varchar(255) NOT NULL,
  822. `ref` tinytext,
  823. `description` text,
  824. `path` text NOT NULL,
  825. `force_commit` tinyint(3) unsigned NOT NULL DEFAULT '0',
  826. `default_view_mod` char(32) NOT NULL DEFAULT 'embedded',
  827. `default_encoding` char(32) NOT NULL DEFAULT 'UTF-8',
  828. `display_order` int(10) unsigned NOT NULL DEFAULT '0',
  829. `content_maker` tinytext NOT NULL,
  830. `content_local` varchar(32) NOT NULL DEFAULT 'local',
  831. `content_license` text NOT NULL,
  832. `prevent_reinit` tinyint(3) unsigned NOT NULL DEFAULT '1',
  833. `js_lib` tinytext NOT NULL,
  834. `debug` tinyint(3) unsigned NOT NULL DEFAULT '0',
  835. `theme` varchar(255) NOT NULL DEFAULT '',
  836. `preview_image` varchar(255) NOT NULL DEFAULT '',
  837. `author` varchar(255) NOT NULL DEFAULT '',
  838. `session_id` int(10) unsigned NOT NULL DEFAULT '0',
  839. `prerequisite` int(10) unsigned NOT NULL DEFAULT '0',
  840. `use_max_score` int(10) unsigned NOT NULL DEFAULT '1',
  841. `autolunch` int(10) unsigned NOT NULL DEFAULT '0',
  842. `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  843. `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  844. `publicated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  845. `expired_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  846. PRIMARY KEY (`id`)
  847. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  848. /*!40101 SET character_set_client = @saved_cs_client */;
  849. --
  850. -- Table structure for table `lp_item`
  851. --
  852. DROP TABLE IF EXISTS `lp_item`;
  853. /*!40101 SET @saved_cs_client = @@character_set_client */;
  854. /*!40101 SET character_set_client = utf8 */;
  855. CREATE TABLE `lp_item` (
  856. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  857. `lp_id` int(10) unsigned NOT NULL,
  858. `item_type` char(32) NOT NULL DEFAULT 'dokeos_document',
  859. `ref` tinytext NOT NULL,
  860. `title` varchar(511) NOT NULL,
  861. `description` varchar(511) NOT NULL DEFAULT '',
  862. `path` text NOT NULL,
  863. `min_score` float unsigned NOT NULL DEFAULT '0',
  864. `max_score` float unsigned DEFAULT '100',
  865. `mastery_score` float unsigned DEFAULT NULL,
  866. `parent_item_id` int(10) unsigned NOT NULL DEFAULT '0',
  867. `previous_item_id` int(10) unsigned NOT NULL DEFAULT '0',
  868. `next_item_id` int(10) unsigned NOT NULL DEFAULT '0',
  869. `display_order` int(10) unsigned NOT NULL DEFAULT '0',
  870. `prerequisite` text,
  871. `parameters` text,
  872. `launch_data` text NOT NULL,
  873. `max_time_allowed` char(13) DEFAULT '',
  874. `terms` text,
  875. `search_did` int(11) DEFAULT NULL,
  876. `audio` varchar(250) DEFAULT NULL,
  877. PRIMARY KEY (`id`),
  878. KEY `lp_id` (`lp_id`)
  879. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  880. /*!40101 SET character_set_client = @saved_cs_client */;
  881. --
  882. -- Table structure for table `lp_item_view`
  883. --
  884. DROP TABLE IF EXISTS `lp_item_view`;
  885. /*!40101 SET @saved_cs_client = @@character_set_client */;
  886. /*!40101 SET character_set_client = utf8 */;
  887. CREATE TABLE `lp_item_view` (
  888. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  889. `lp_item_id` int(10) unsigned NOT NULL,
  890. `lp_view_id` int(10) unsigned NOT NULL,
  891. `view_count` int(10) unsigned NOT NULL DEFAULT '0',
  892. `start_time` int(10) unsigned NOT NULL,
  893. `total_time` int(10) unsigned NOT NULL DEFAULT '0',
  894. `score` float unsigned NOT NULL DEFAULT '0',
  895. `status` char(32) NOT NULL DEFAULT 'not attempted',
  896. `suspend_data` text,
  897. `lesson_location` text,
  898. `core_exit` varchar(32) NOT NULL DEFAULT 'none',
  899. `max_score` varchar(8) DEFAULT '',
  900. PRIMARY KEY (`id`),
  901. KEY `lp_item_id` (`lp_item_id`),
  902. KEY `lp_view_id` (`lp_view_id`)
  903. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  904. /*!40101 SET character_set_client = @saved_cs_client */;
  905. --
  906. -- Table structure for table `lp_iv_interaction`
  907. --
  908. DROP TABLE IF EXISTS `lp_iv_interaction`;
  909. /*!40101 SET @saved_cs_client = @@character_set_client */;
  910. /*!40101 SET character_set_client = utf8 */;
  911. CREATE TABLE `lp_iv_interaction` (
  912. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  913. `order_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  914. `lp_iv_id` bigint(20) unsigned NOT NULL,
  915. `interaction_id` varchar(255) NOT NULL DEFAULT '',
  916. `interaction_type` varchar(255) NOT NULL DEFAULT '',
  917. `weighting` double NOT NULL DEFAULT '0',
  918. `completion_time` varchar(16) NOT NULL DEFAULT '',
  919. `correct_responses` text NOT NULL,
  920. `student_response` text NOT NULL,
  921. `result` varchar(255) NOT NULL DEFAULT '',
  922. `latency` varchar(16) NOT NULL DEFAULT '',
  923. PRIMARY KEY (`id`),
  924. KEY `lp_iv_id` (`lp_iv_id`)
  925. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  926. /*!40101 SET character_set_client = @saved_cs_client */;
  927. --
  928. -- Table structure for table `lp_iv_objective`
  929. --
  930. DROP TABLE IF EXISTS `lp_iv_objective`;
  931. /*!40101 SET @saved_cs_client = @@character_set_client */;
  932. /*!40101 SET character_set_client = utf8 */;
  933. CREATE TABLE `lp_iv_objective` (
  934. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  935. `lp_iv_id` bigint(20) unsigned NOT NULL,
  936. `order_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  937. `objective_id` varchar(255) NOT NULL DEFAULT '',
  938. `score_raw` float unsigned NOT NULL DEFAULT '0',
  939. `score_max` float unsigned NOT NULL DEFAULT '0',
  940. `score_min` float unsigned NOT NULL DEFAULT '0',
  941. `status` char(32) NOT NULL DEFAULT 'not attempted',
  942. PRIMARY KEY (`id`),
  943. KEY `lp_iv_id` (`lp_iv_id`)
  944. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  945. /*!40101 SET character_set_client = @saved_cs_client */;
  946. --
  947. -- Table structure for table `lp_view`
  948. --
  949. DROP TABLE IF EXISTS `lp_view`;
  950. /*!40101 SET @saved_cs_client = @@character_set_client */;
  951. /*!40101 SET character_set_client = utf8 */;
  952. CREATE TABLE `lp_view` (
  953. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  954. `lp_id` int(10) unsigned NOT NULL,
  955. `user_id` int(10) unsigned NOT NULL,
  956. `view_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  957. `last_item` int(10) unsigned NOT NULL DEFAULT '0',
  958. `progress` int(10) unsigned DEFAULT '0',
  959. `session_id` int(11) NOT NULL DEFAULT '0',
  960. PRIMARY KEY (`id`),
  961. KEY `lp_id` (`lp_id`),
  962. KEY `user_id` (`user_id`),
  963. KEY `session_id` (`session_id`)
  964. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  965. /*!40101 SET character_set_client = @saved_cs_client */;
  966. --
  967. -- Table structure for table `notebook`
  968. --
  969. DROP TABLE IF EXISTS `notebook`;
  970. /*!40101 SET @saved_cs_client = @@character_set_client */;
  971. /*!40101 SET character_set_client = utf8 */;
  972. CREATE TABLE `notebook` (
  973. `notebook_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  974. `user_id` int(10) unsigned NOT NULL,
  975. `course` varchar(40) NOT NULL,
  976. `session_id` int(11) NOT NULL DEFAULT '0',
  977. `title` varchar(255) NOT NULL,
  978. `description` text NOT NULL,
  979. `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  980. `update_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  981. `status` int(11) DEFAULT NULL,
  982. PRIMARY KEY (`notebook_id`)
  983. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  984. /*!40101 SET character_set_client = @saved_cs_client */;
  985. --
  986. -- Table structure for table `online_connected`
  987. --
  988. DROP TABLE IF EXISTS `online_connected`;
  989. /*!40101 SET @saved_cs_client = @@character_set_client */;
  990. /*!40101 SET character_set_client = utf8 */;
  991. CREATE TABLE `online_connected` (
  992. `user_id` int(10) unsigned NOT NULL,
  993. `last_connection` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  994. PRIMARY KEY (`user_id`)
  995. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  996. /*!40101 SET character_set_client = @saved_cs_client */;
  997. --
  998. -- Table structure for table `online_link`
  999. --
  1000. DROP TABLE IF EXISTS `online_link`;
  1001. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1002. /*!40101 SET character_set_client = utf8 */;
  1003. CREATE TABLE `online_link` (
  1004. `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  1005. `name` char(50) NOT NULL DEFAULT '',
  1006. `url` char(100) NOT NULL,
  1007. PRIMARY KEY (`id`)
  1008. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1009. /*!40101 SET character_set_client = @saved_cs_client */;
  1010. --
  1011. -- Table structure for table `permission_group`
  1012. --
  1013. DROP TABLE IF EXISTS `permission_group`;
  1014. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1015. /*!40101 SET character_set_client = utf8 */;
  1016. CREATE TABLE `permission_group` (
  1017. `id` int(11) NOT NULL AUTO_INCREMENT,
  1018. `group_id` int(11) NOT NULL DEFAULT '0',
  1019. `tool` varchar(250) NOT NULL DEFAULT '',
  1020. `action` varchar(250) NOT NULL DEFAULT '',
  1021. PRIMARY KEY (`id`)
  1022. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1023. /*!40101 SET character_set_client = @saved_cs_client */;
  1024. --
  1025. -- Table structure for table `permission_task`
  1026. --
  1027. DROP TABLE IF EXISTS `permission_task`;
  1028. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1029. /*!40101 SET character_set_client = utf8 */;
  1030. CREATE TABLE `permission_task` (
  1031. `id` int(11) NOT NULL AUTO_INCREMENT,
  1032. `task_id` int(11) NOT NULL DEFAULT '0',
  1033. `tool` varchar(250) NOT NULL DEFAULT '',
  1034. `action` varchar(250) NOT NULL DEFAULT '',
  1035. PRIMARY KEY (`id`)
  1036. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1037. /*!40101 SET character_set_client = @saved_cs_client */;
  1038. --
  1039. -- Table structure for table `permission_user`
  1040. --
  1041. DROP TABLE IF EXISTS `permission_user`;
  1042. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1043. /*!40101 SET character_set_client = utf8 */;
  1044. CREATE TABLE `permission_user` (
  1045. `id` int(11) NOT NULL AUTO_INCREMENT,
  1046. `user_id` int(11) NOT NULL DEFAULT '0',
  1047. `tool` varchar(250) NOT NULL DEFAULT '',
  1048. `action` varchar(250) NOT NULL DEFAULT '',
  1049. PRIMARY KEY (`id`)
  1050. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1051. /*!40101 SET character_set_client = @saved_cs_client */;
  1052. --
  1053. -- Table structure for table `quiz`
  1054. --
  1055. DROP TABLE IF EXISTS `quiz`;
  1056. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1057. /*!40101 SET character_set_client = utf8 */;
  1058. CREATE TABLE `quiz` (
  1059. `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  1060. `title` varchar(255) NOT NULL,
  1061. `description` text,
  1062. `sound` varchar(255) DEFAULT NULL,
  1063. `type` tinyint(3) unsigned NOT NULL DEFAULT '1',
  1064. `random` smallint(6) NOT NULL DEFAULT '0',
  1065. `random_answers` tinyint(3) unsigned NOT NULL DEFAULT '0',
  1066. `active` tinyint(4) NOT NULL DEFAULT '0',
  1067. `results_disabled` tinyint(3) unsigned NOT NULL DEFAULT '0',
  1068. `access_condition` text,
  1069. `max_attempt` int(11) NOT NULL DEFAULT '0',
  1070. `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1071. `end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1072. `feedback_type` int(11) NOT NULL DEFAULT '0',
  1073. `expired_time` int(11) NOT NULL DEFAULT '0',
  1074. `session_id` smallint(6) DEFAULT '0',
  1075. `propagate_neg` int(11) NOT NULL DEFAULT '0',
  1076. PRIMARY KEY (`id`),
  1077. KEY `session_id` (`session_id`)
  1078. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1079. /*!40101 SET character_set_client = @saved_cs_client */;
  1080. --
  1081. -- Table structure for table `quiz_answer`
  1082. --
  1083. DROP TABLE IF EXISTS `quiz_answer`;
  1084. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1085. /*!40101 SET character_set_client = utf8 */;
  1086. CREATE TABLE `quiz_answer` (
  1087. `id` mediumint(8) unsigned NOT NULL,
  1088. `question_id` mediumint(8) unsigned NOT NULL,
  1089. `answer` text NOT NULL,
  1090. `correct` mediumint(8) unsigned DEFAULT NULL,
  1091. `comment` text,
  1092. `ponderation` float(6,2) NOT NULL DEFAULT '0.00',
  1093. `position` mediumint(8) unsigned NOT NULL DEFAULT '1',
  1094. `hotspot_coordinates` text,
  1095. `hotspot_type` enum('square','circle','poly','delineation','oar') DEFAULT NULL,
  1096. `destination` text NOT NULL,
  1097. `id_auto` int(11) NOT NULL AUTO_INCREMENT,
  1098. PRIMARY KEY (`id`,`question_id`),
  1099. UNIQUE KEY `id_auto` (`id_auto`)
  1100. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1101. /*!40101 SET character_set_client = @saved_cs_client */;
  1102. --
  1103. -- Table structure for table `quiz_question`
  1104. --
  1105. DROP TABLE IF EXISTS `quiz_question`;
  1106. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1107. /*!40101 SET character_set_client = utf8 */;
  1108. CREATE TABLE `quiz_question` (
  1109. `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  1110. `question` text NOT NULL,
  1111. `description` text,
  1112. `ponderation` float(6,2) NOT NULL DEFAULT '0.00',
  1113. `position` mediumint(8) unsigned NOT NULL DEFAULT '1',
  1114. `type` tinyint(3) unsigned NOT NULL DEFAULT '2',
  1115. `picture` varchar(50) DEFAULT NULL,
  1116. `level` int(10) unsigned NOT NULL DEFAULT '0',
  1117. `extra` varchar(255) DEFAULT NULL,
  1118. PRIMARY KEY (`id`),
  1119. KEY `position` (`position`)
  1120. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1121. /*!40101 SET character_set_client = @saved_cs_client */;
  1122. --
  1123. -- Table structure for table `quiz_question_option`
  1124. --
  1125. DROP TABLE IF EXISTS `quiz_question_option`;
  1126. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1127. /*!40101 SET character_set_client = utf8 */;
  1128. CREATE TABLE `quiz_question_option` (
  1129. `id` int(11) NOT NULL AUTO_INCREMENT,
  1130. `question_id` int(11) NOT NULL,
  1131. `name` varchar(255) DEFAULT NULL,
  1132. `position` int(10) unsigned NOT NULL,
  1133. PRIMARY KEY (`id`)
  1134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1135. /*!40101 SET character_set_client = @saved_cs_client */;
  1136. --
  1137. -- Table structure for table `quiz_rel_question`
  1138. --
  1139. DROP TABLE IF EXISTS `quiz_rel_question`;
  1140. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1141. /*!40101 SET character_set_client = utf8 */;
  1142. CREATE TABLE `quiz_rel_question` (
  1143. `question_id` mediumint(8) unsigned NOT NULL,
  1144. `exercice_id` mediumint(8) unsigned NOT NULL,
  1145. `question_order` mediumint(8) unsigned NOT NULL DEFAULT '1',
  1146. PRIMARY KEY (`question_id`,`exercice_id`)
  1147. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1148. /*!40101 SET character_set_client = @saved_cs_client */;
  1149. --
  1150. -- Table structure for table `resource`
  1151. --
  1152. DROP TABLE IF EXISTS `resource`;
  1153. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1154. /*!40101 SET character_set_client = utf8 */;
  1155. CREATE TABLE `resource` (
  1156. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1157. `source_type` varchar(50) DEFAULT NULL,
  1158. `source_id` int(10) unsigned DEFAULT NULL,
  1159. `resource_type` varchar(50) DEFAULT NULL,
  1160. `resource_id` int(10) unsigned DEFAULT NULL,
  1161. UNIQUE KEY `id` (`id`)
  1162. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1163. /*!40101 SET character_set_client = @saved_cs_client */;
  1164. --
  1165. -- Table structure for table `role`
  1166. --
  1167. DROP TABLE IF EXISTS `role`;
  1168. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1169. /*!40101 SET character_set_client = utf8 */;
  1170. CREATE TABLE `role` (
  1171. `role_id` int(11) NOT NULL AUTO_INCREMENT,
  1172. `role_name` varchar(250) NOT NULL DEFAULT '',
  1173. `role_comment` text,
  1174. `default_role` tinyint(4) DEFAULT '0',
  1175. PRIMARY KEY (`role_id`)
  1176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1177. /*!40101 SET character_set_client = @saved_cs_client */;
  1178. --
  1179. -- Table structure for table `role_group`
  1180. --
  1181. DROP TABLE IF EXISTS `role_group`;
  1182. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1183. /*!40101 SET character_set_client = utf8 */;
  1184. CREATE TABLE `role_group` (
  1185. `role_id` int(11) NOT NULL DEFAULT '0',
  1186. `scope` varchar(20) NOT NULL DEFAULT 'course',
  1187. `group_id` int(11) NOT NULL DEFAULT '0'
  1188. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1189. /*!40101 SET character_set_client = @saved_cs_client */;
  1190. --
  1191. -- Table structure for table `role_permissions`
  1192. --
  1193. DROP TABLE IF EXISTS `role_permissions`;
  1194. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1195. /*!40101 SET character_set_client = utf8 */;
  1196. CREATE TABLE `role_permissions` (
  1197. `role_id` int(11) NOT NULL DEFAULT '0',
  1198. `tool` varchar(250) NOT NULL DEFAULT '',
  1199. `action` varchar(50) NOT NULL DEFAULT '',
  1200. `default_perm` tinyint(4) NOT NULL DEFAULT '0'
  1201. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1202. /*!40101 SET character_set_client = @saved_cs_client */;
  1203. --
  1204. -- Table structure for table `role_user`
  1205. --
  1206. DROP TABLE IF EXISTS `role_user`;
  1207. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1208. /*!40101 SET character_set_client = utf8 */;
  1209. CREATE TABLE `role_user` (
  1210. `role_id` int(11) NOT NULL DEFAULT '0',
  1211. `scope` varchar(20) NOT NULL DEFAULT 'course',
  1212. `user_id` int(11) NOT NULL DEFAULT '0'
  1213. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1214. /*!40101 SET character_set_client = @saved_cs_client */;
  1215. --
  1216. -- Table structure for table `student_publication`
  1217. --
  1218. DROP TABLE IF EXISTS `student_publication`;
  1219. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1220. /*!40101 SET character_set_client = utf8 */;
  1221. CREATE TABLE `student_publication` (
  1222. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1223. `url` varchar(255) DEFAULT NULL,
  1224. `title` varchar(255) DEFAULT NULL,
  1225. `description` text,
  1226. `author` varchar(255) DEFAULT NULL,
  1227. `active` tinyint(4) DEFAULT NULL,
  1228. `accepted` tinyint(4) DEFAULT '0',
  1229. `post_group_id` int(11) NOT NULL DEFAULT '0',
  1230. `sent_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1231. `filetype` set('file','folder') NOT NULL DEFAULT 'file',
  1232. `has_properties` int(10) unsigned NOT NULL DEFAULT '0',
  1233. `view_properties` tinyint(4) DEFAULT NULL,
  1234. `qualification` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  1235. `date_of_qualification` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1236. `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  1237. `qualificator_id` int(10) unsigned NOT NULL DEFAULT '0',
  1238. `weight` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  1239. `session_id` int(10) unsigned NOT NULL DEFAULT '0',
  1240. `user_id` int(11) NOT NULL,
  1241. PRIMARY KEY (`id`),
  1242. KEY `session_id` (`session_id`)
  1243. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1244. /*!40101 SET character_set_client = @saved_cs_client */;
  1245. --
  1246. -- Table structure for table `student_publication_assignment`
  1247. --
  1248. DROP TABLE IF EXISTS `student_publication_assignment`;
  1249. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1250. /*!40101 SET character_set_client = utf8 */;
  1251. CREATE TABLE `student_publication_assignment` (
  1252. `id` int(11) NOT NULL AUTO_INCREMENT,
  1253. `expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1254. `ends_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1255. `add_to_calendar` tinyint(4) NOT NULL,
  1256. `enable_qualification` tinyint(4) NOT NULL,
  1257. `publication_id` int(11) NOT NULL,
  1258. PRIMARY KEY (`id`)
  1259. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1260. /*!40101 SET character_set_client = @saved_cs_client */;
  1261. --
  1262. -- Table structure for table `survey`
  1263. --
  1264. DROP TABLE IF EXISTS `survey`;
  1265. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1266. /*!40101 SET character_set_client = utf8 */;
  1267. CREATE TABLE `survey` (
  1268. `survey_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1269. `code` varchar(20) DEFAULT NULL,
  1270. `title` text,
  1271. `subtitle` text,
  1272. `author` varchar(20) DEFAULT NULL,
  1273. `lang` varchar(20) DEFAULT NULL,
  1274. `avail_from` date DEFAULT NULL,
  1275. `avail_till` date DEFAULT NULL,
  1276. `is_shared` char(1) DEFAULT '1',
  1277. `template` varchar(20) DEFAULT NULL,
  1278. `intro` text,
  1279. `surveythanks` text,
  1280. `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1281. `invited` int(11) NOT NULL,
  1282. `answered` int(11) NOT NULL,
  1283. `invite_mail` text NOT NULL,
  1284. `reminder_mail` text NOT NULL,
  1285. `mail_subject` varchar(255) NOT NULL,
  1286. `anonymous` enum('0','1') NOT NULL DEFAULT '0',
  1287. `access_condition` text,
  1288. `shuffle` tinyint(1) NOT NULL DEFAULT '0',
  1289. `one_question_per_page` tinyint(1) NOT NULL DEFAULT '0',
  1290. `survey_version` varchar(255) NOT NULL DEFAULT '',
  1291. `parent_id` int(10) unsigned NOT NULL,
  1292. `survey_type` int(11) NOT NULL DEFAULT '0',
  1293. `show_form_profile` int(11) NOT NULL DEFAULT '0',
  1294. `form_fields` text NOT NULL,
  1295. `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  1296. PRIMARY KEY (`survey_id`),
  1297. KEY `session_id` (`session_id`)
  1298. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1299. /*!40101 SET character_set_client = @saved_cs_client */;
  1300. --
  1301. -- Table structure for table `survey_answer`
  1302. --
  1303. DROP TABLE IF EXISTS `survey_answer`;
  1304. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1305. /*!40101 SET character_set_client = utf8 */;
  1306. CREATE TABLE `survey_answer` (
  1307. `answer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1308. `survey_id` int(10) unsigned NOT NULL,
  1309. `question_id` int(10) unsigned NOT NULL,
  1310. `option_id` text NOT NULL,
  1311. `value` int(10) unsigned NOT NULL,
  1312. `user` varchar(250) NOT NULL,
  1313. PRIMARY KEY (`answer_id`)
  1314. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1315. /*!40101 SET character_set_client = @saved_cs_client */;
  1316. --
  1317. -- Table structure for table `survey_group`
  1318. --
  1319. DROP TABLE IF EXISTS `survey_group`;
  1320. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1321. /*!40101 SET character_set_client = utf8 */;
  1322. CREATE TABLE `survey_group` (
  1323. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1324. `name` varchar(20) NOT NULL,
  1325. `description` varchar(255) NOT NULL,
  1326. `survey_id` int(10) unsigned NOT NULL,
  1327. PRIMARY KEY (`id`)
  1328. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1329. /*!40101 SET character_set_client = @saved_cs_client */;
  1330. --
  1331. -- Table structure for table `survey_invitation`
  1332. --
  1333. DROP TABLE IF EXISTS `survey_invitation`;
  1334. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1335. /*!40101 SET character_set_client = utf8 */;
  1336. CREATE TABLE `survey_invitation` (
  1337. `survey_invitation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1338. `survey_code` varchar(20) NOT NULL,
  1339. `user` varchar(250) NOT NULL,
  1340. `invitation_code` varchar(250) NOT NULL,
  1341. `invitation_date` datetime NOT NULL,
  1342. `reminder_date` datetime NOT NULL,
  1343. `answered` int(11) NOT NULL DEFAULT '0',
  1344. `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  1345. PRIMARY KEY (`survey_invitation_id`)
  1346. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1347. /*!40101 SET character_set_client = @saved_cs_client */;
  1348. --
  1349. -- Table structure for table `survey_question`
  1350. --
  1351. DROP TABLE IF EXISTS `survey_question`;
  1352. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1353. /*!40101 SET character_set_client = utf8 */;
  1354. CREATE TABLE `survey_question` (
  1355. `question_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1356. `survey_id` int(10) unsigned NOT NULL,
  1357. `survey_question` text NOT NULL,
  1358. `survey_question_comment` text NOT NULL,
  1359. `type` varchar(250) NOT NULL,
  1360. `display` varchar(10) NOT NULL,
  1361. `sort` int(11) NOT NULL,
  1362. `shared_question_id` int(11) DEFAULT NULL,
  1363. `max_value` int(11) DEFAULT NULL,
  1364. `survey_group_pri` int(10) unsigned NOT NULL DEFAULT '0',
  1365. `survey_group_sec1` int(10) unsigned NOT NULL DEFAULT '0',
  1366. `survey_group_sec2` int(10) unsigned NOT NULL DEFAULT '0',
  1367. PRIMARY KEY (`question_id`)
  1368. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1369. /*!40101 SET character_set_client = @saved_cs_client */;
  1370. --
  1371. -- Table structure for table `survey_question_option`
  1372. --
  1373. DROP TABLE IF EXISTS `survey_question_option`;
  1374. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1375. /*!40101 SET character_set_client = utf8 */;
  1376. CREATE TABLE `survey_question_option` (
  1377. `question_option_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1378. `question_id` int(10) unsigned NOT NULL,
  1379. `survey_id` int(10) unsigned NOT NULL,
  1380. `option_text` text NOT NULL,
  1381. `sort` int(11) NOT NULL,
  1382. `value` int(11) NOT NULL DEFAULT '0',
  1383. PRIMARY KEY (`question_option_id`)
  1384. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1385. /*!40101 SET character_set_client = @saved_cs_client */;
  1386. --
  1387. -- Table structure for table `thematic`
  1388. --
  1389. DROP TABLE IF EXISTS `thematic`;
  1390. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1391. /*!40101 SET character_set_client = utf8 */;
  1392. CREATE TABLE `thematic` (
  1393. `id` int(11) NOT NULL AUTO_INCREMENT,
  1394. `title` varchar(255) NOT NULL,
  1395. `content` text,
  1396. `display_order` int(10) unsigned NOT NULL DEFAULT '0',
  1397. `active` tinyint(4) NOT NULL DEFAULT '0',
  1398. `session_id` int(11) NOT NULL DEFAULT '0',
  1399. PRIMARY KEY (`id`),
  1400. KEY `active` (`active`,`session_id`)
  1401. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1402. /*!40101 SET character_set_client = @saved_cs_client */;
  1403. --
  1404. -- Table structure for table `thematic_advance`
  1405. --
  1406. DROP TABLE IF EXISTS `thematic_advance`;
  1407. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1408. /*!40101 SET character_set_client = utf8 */;
  1409. CREATE TABLE `thematic_advance` (
  1410. `id` int(11) NOT NULL AUTO_INCREMENT,
  1411. `thematic_id` int(11) NOT NULL,
  1412. `attendance_id` int(11) NOT NULL DEFAULT '0',
  1413. `content` text,
  1414. `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1415. `duration` int(11) NOT NULL DEFAULT '0',
  1416. `done_advance` tinyint(4) NOT NULL DEFAULT '0',
  1417. PRIMARY KEY (`id`),
  1418. KEY `thematic_id` (`thematic_id`)
  1419. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1420. /*!40101 SET character_set_client = @saved_cs_client */;
  1421. --
  1422. -- Table structure for table `thematic_plan`
  1423. --
  1424. DROP TABLE IF EXISTS `thematic_plan`;
  1425. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1426. /*!40101 SET character_set_client = utf8 */;
  1427. CREATE TABLE `thematic_plan` (
  1428. `id` int(11) NOT NULL AUTO_INCREMENT,
  1429. `thematic_id` int(11) NOT NULL,
  1430. `title` varchar(255) NOT NULL,
  1431. `description` text,
  1432. `description_type` int(11) NOT NULL,
  1433. PRIMARY KEY (`id`),
  1434. KEY `thematic_id` (`thematic_id`,`description_type`)
  1435. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1436. /*!40101 SET character_set_client = @saved_cs_client */;
  1437. --
  1438. -- Table structure for table `tool`
  1439. --
  1440. DROP TABLE IF EXISTS `tool`;
  1441. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1442. /*!40101 SET character_set_client = utf8 */;
  1443. CREATE TABLE `tool` (
  1444. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1445. `name` varchar(255) NOT NULL,
  1446. `link` varchar(255) NOT NULL,
  1447. `image` varchar(255) DEFAULT NULL,
  1448. `visibility` tinyint(3) unsigned DEFAULT '0',
  1449. `admin` varchar(255) DEFAULT NULL,
  1450. `address` varchar(255) DEFAULT NULL,
  1451. `added_tool` tinyint(3) unsigned DEFAULT '1',
  1452. `target` enum('_self','_blank') NOT NULL DEFAULT '_self',
  1453. `category` varchar(20) NOT NULL DEFAULT 'authoring',
  1454. `session_id` smallint(6) DEFAULT '0',
  1455. PRIMARY KEY (`id`),
  1456. KEY `session_id` (`session_id`)
  1457. ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
  1458. /*!40101 SET character_set_client = @saved_cs_client */;
  1459. --
  1460. -- Table structure for table `tool_intro`
  1461. --
  1462. DROP TABLE IF EXISTS `tool_intro`;
  1463. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1464. /*!40101 SET character_set_client = utf8 */;
  1465. CREATE TABLE `tool_intro` (
  1466. `id` varchar(50) NOT NULL,
  1467. `intro_text` text NOT NULL,
  1468. `session_id` int(11) NOT NULL DEFAULT '0',
  1469. PRIMARY KEY (`id`,`session_id`)
  1470. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1471. /*!40101 SET character_set_client = @saved_cs_client */;
  1472. --
  1473. -- Table structure for table `userinfo_content`
  1474. --
  1475. DROP TABLE IF EXISTS `userinfo_content`;
  1476. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1477. /*!40101 SET character_set_client = utf8 */;
  1478. CREATE TABLE `userinfo_content` (
  1479. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1480. `user_id` int(10) unsigned NOT NULL,
  1481. `definition_id` int(10) unsigned NOT NULL,
  1482. `editor_ip` varchar(39) DEFAULT NULL,
  1483. `edition_time` datetime DEFAULT NULL,
  1484. `content` text NOT NULL,
  1485. PRIMARY KEY (`id`),
  1486. KEY `user_id` (`user_id`)
  1487. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1488. /*!40101 SET character_set_client = @saved_cs_client */;
  1489. --
  1490. -- Table structure for table `userinfo_def`
  1491. --
  1492. DROP TABLE IF EXISTS `userinfo_def`;
  1493. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1494. /*!40101 SET character_set_client = utf8 */;
  1495. CREATE TABLE `userinfo_def` (
  1496. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1497. `title` varchar(80) NOT NULL DEFAULT '',
  1498. `comment` text,
  1499. `line_count` tinyint(3) unsigned NOT NULL DEFAULT '5',
  1500. `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  1501. PRIMARY KEY (`id`)
  1502. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1503. /*!40101 SET character_set_client = @saved_cs_client */;
  1504. --
  1505. -- Table structure for table `wiki`
  1506. --
  1507. DROP TABLE IF EXISTS `wiki`;
  1508. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1509. /*!40101 SET character_set_client = utf8 */;
  1510. CREATE TABLE `wiki` (
  1511. `id` int(11) NOT NULL AUTO_INCREMENT,
  1512. `page_id` int(11) NOT NULL DEFAULT '0',
  1513. `reflink` varchar(255) NOT NULL DEFAULT 'index',
  1514. `title` varchar(255) NOT NULL,
  1515. `content` mediumtext NOT NULL,
  1516. `user_id` int(11) NOT NULL DEFAULT '0',
  1517. `group_id` int(11) DEFAULT NULL,
  1518. `dtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1519. `addlock` int(11) NOT NULL DEFAULT '1',
  1520. `editlock` int(11) NOT NULL DEFAULT '0',
  1521. `visibility` int(11) NOT NULL DEFAULT '1',
  1522. `addlock_disc` int(11) NOT NULL DEFAULT '1',
  1523. `visibility_disc` int(11) NOT NULL DEFAULT '1',
  1524. `ratinglock_disc` int(11) NOT NULL DEFAULT '1',
  1525. `assignment` int(11) NOT NULL DEFAULT '0',
  1526. `comment` text NOT NULL,
  1527. `progress` text NOT NULL,
  1528. `score` int(11) DEFAULT '0',
  1529. `version` int(11) DEFAULT NULL,
  1530. `is_editing` int(11) NOT NULL DEFAULT '0',
  1531. `time_edit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1532. `hits` int(11) DEFAULT '0',
  1533. `linksto` text NOT NULL,
  1534. `tag` text NOT NULL,
  1535. `user_ip` varchar(39) NOT NULL,
  1536. `session_id` smallint(6) DEFAULT '0',
  1537. PRIMARY KEY (`id`),
  1538. KEY `reflink` (`reflink`),
  1539. KEY `group_id` (`group_id`),
  1540. KEY `page_id` (`page_id`),
  1541. KEY `session_id` (`session_id`)
  1542. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1543. /*!40101 SET character_set_client = @saved_cs_client */;
  1544. --
  1545. -- Table structure for table `wiki_conf`
  1546. --
  1547. DROP TABLE IF EXISTS `wiki_conf`;
  1548. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1549. /*!40101 SET character_set_client = utf8 */;
  1550. CREATE TABLE `wiki_conf` (
  1551. `page_id` int(11) NOT NULL DEFAULT '0',
  1552. `task` text NOT NULL,
  1553. `feedback1` text NOT NULL,
  1554. `feedback2` text NOT NULL,
  1555. `feedback3` text NOT NULL,
  1556. `fprogress1` varchar(3) NOT NULL,
  1557. `fprogress2` varchar(3) NOT NULL,
  1558. `fprogress3` varchar(3) NOT NULL,
  1559. `max_size` int(11) DEFAULT NULL,
  1560. `max_text` int(11) DEFAULT NULL,
  1561. `max_version` int(11) DEFAULT NULL,
  1562. `startdate_assig` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1563. `enddate_assig` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1564. `delayedsubmit` int(11) NOT NULL DEFAULT '0',
  1565. KEY `page_id` (`page_id`)
  1566. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1567. /*!40101 SET character_set_client = @saved_cs_client */;
  1568. --
  1569. -- Table structure for table `wiki_discuss`
  1570. --
  1571. DROP TABLE IF EXISTS `wiki_discuss`;
  1572. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1573. /*!40101 SET character_set_client = utf8 */;
  1574. CREATE TABLE `wiki_discuss` (
  1575. `id` int(11) NOT NULL AUTO_INCREMENT,
  1576. `publication_id` int(11) NOT NULL DEFAULT '0',
  1577. `userc_id` int(11) NOT NULL DEFAULT '0',
  1578. `comment` text NOT NULL,
  1579. `p_score` varchar(255) DEFAULT NULL,
  1580. `dtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1581. PRIMARY KEY (`id`)
  1582. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1583. /*!40101 SET character_set_client = @saved_cs_client */;
  1584. --
  1585. -- Table structure for table `wiki_mailcue`
  1586. --
  1587. DROP TABLE IF EXISTS `wiki_mailcue`;
  1588. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1589. /*!40101 SET character_set_client = utf8 */;
  1590. CREATE TABLE `wiki_mailcue` (
  1591. `id` int(11) NOT NULL,
  1592. `user_id` int(11) NOT NULL,
  1593. `type` text NOT NULL,
  1594. `group_id` int(11) DEFAULT NULL,
  1595. `session_id` smallint(6) DEFAULT '0',
  1596. KEY `id` (`id`)
  1597. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1598. /*!40101 SET character_set_client = @saved_cs_client */;
  1599. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  1600. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  1601. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  1602. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  1603. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1604. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1605. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  1606. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  1607. -- Dump completed on 2013-03-27 11:48:31