123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782 |
- -- MySQL dump 10.13 Distrib 5.5.29, for debian-linux-gnu (i686)
- --
- -- Host: localhost Database: chamilo1884
- -- ------------------------------------------------------
- -- Server version 5.5.29-0ubuntu0.12.10.1
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `announcement`
- --
- DROP TABLE IF EXISTS `announcement`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `announcement` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `title` text,
- `content` mediumtext,
- `end_date` date DEFAULT NULL,
- `display_order` mediumint(9) NOT NULL DEFAULT '0',
- `email_sent` tinyint(4) DEFAULT '0',
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `announcement_attachment`
- --
- DROP TABLE IF EXISTS `announcement_attachment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `announcement_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `path` varchar(255) NOT NULL,
- `comment` text,
- `size` int(11) NOT NULL DEFAULT '0',
- `announcement_id` int(11) NOT NULL,
- `filename` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `attendance`
- --
- DROP TABLE IF EXISTS `attendance`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `attendance` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` text NOT NULL,
- `description` text,
- `active` tinyint(4) NOT NULL DEFAULT '1',
- `attendance_qualify_title` varchar(255) DEFAULT NULL,
- `attendance_qualify_max` int(11) NOT NULL DEFAULT '0',
- `attendance_weight` float(6,2) NOT NULL DEFAULT '0.00',
- `session_id` int(11) NOT NULL DEFAULT '0',
- `locked` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`),
- KEY `active` (`active`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `attendance_calendar`
- --
- DROP TABLE IF EXISTS `attendance_calendar`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `attendance_calendar` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `attendance_id` int(11) NOT NULL,
- `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `done_attendance` tinyint(4) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `attendance_id` (`attendance_id`),
- KEY `done_attendance` (`done_attendance`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `attendance_result`
- --
- DROP TABLE IF EXISTS `attendance_result`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `attendance_result` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `attendance_id` int(11) NOT NULL,
- `score` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `attendance_id` (`attendance_id`),
- KEY `user_id` (`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `attendance_sheet`
- --
- DROP TABLE IF EXISTS `attendance_sheet`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `attendance_sheet` (
- `user_id` int(11) NOT NULL,
- `attendance_calendar_id` int(11) NOT NULL,
- `presence` tinyint(4) NOT NULL DEFAULT '0',
- PRIMARY KEY (`user_id`,`attendance_calendar_id`),
- KEY `presence` (`presence`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `attendance_sheet_log`
- --
- DROP TABLE IF EXISTS `attendance_sheet_log`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `attendance_sheet_log` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `attendance_id` int(11) NOT NULL DEFAULT '0',
- `lastedit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `lastedit_type` varchar(200) NOT NULL,
- `lastedit_user_id` int(11) NOT NULL DEFAULT '0',
- `calendar_date_value` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog`
- --
- DROP TABLE IF EXISTS `blog`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog` (
- `blog_id` smallint(6) NOT NULL AUTO_INCREMENT,
- `blog_name` varchar(250) NOT NULL DEFAULT '',
- `blog_subtitle` varchar(250) DEFAULT NULL,
- `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `visibility` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`blog_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with blogs in this course';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_attachment`
- --
- DROP TABLE IF EXISTS `blog_attachment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_attachment` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `path` varchar(255) NOT NULL COMMENT 'the real filename',
- `comment` text,
- `size` int(11) NOT NULL DEFAULT '0',
- `post_id` int(11) NOT NULL,
- `filename` varchar(255) NOT NULL COMMENT 'the user s file name',
- `blog_id` int(11) NOT NULL,
- `comment_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_comment`
- --
- DROP TABLE IF EXISTS `blog_comment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_comment` (
- `comment_id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(250) NOT NULL DEFAULT '',
- `comment` longtext NOT NULL,
- `author_id` int(11) NOT NULL DEFAULT '0',
- `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `blog_id` mediumint(9) NOT NULL DEFAULT '0',
- `post_id` int(11) NOT NULL DEFAULT '0',
- `task_id` int(11) DEFAULT NULL,
- `parent_comment_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`comment_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with comments on posts in a blog';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_post`
- --
- DROP TABLE IF EXISTS `blog_post`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_post` (
- `post_id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(250) NOT NULL DEFAULT '',
- `full_text` longtext NOT NULL,
- `date_creation` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `blog_id` mediumint(9) NOT NULL DEFAULT '0',
- `author_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`post_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with posts / blog.';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_rating`
- --
- DROP TABLE IF EXISTS `blog_rating`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_rating` (
- `rating_id` int(11) NOT NULL AUTO_INCREMENT,
- `blog_id` int(11) NOT NULL DEFAULT '0',
- `rating_type` enum('post','comment') NOT NULL DEFAULT 'post',
- `item_id` int(11) NOT NULL DEFAULT '0',
- `user_id` int(11) NOT NULL DEFAULT '0',
- `rating` mediumint(9) NOT NULL DEFAULT '0',
- PRIMARY KEY (`rating_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with ratings for post/comments in a certain blog';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_rel_user`
- --
- DROP TABLE IF EXISTS `blog_rel_user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_rel_user` (
- `blog_id` int(11) NOT NULL DEFAULT '0',
- `user_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`blog_id`,`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table representing users subscribed to a blog';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_task`
- --
- DROP TABLE IF EXISTS `blog_task`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_task` (
- `task_id` mediumint(9) NOT NULL AUTO_INCREMENT,
- `blog_id` mediumint(9) NOT NULL DEFAULT '0',
- `title` varchar(250) NOT NULL DEFAULT '',
- `description` text NOT NULL,
- `color` varchar(10) NOT NULL DEFAULT '',
- `system_task` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`task_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with tasks for a blog';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `blog_task_rel_user`
- --
- DROP TABLE IF EXISTS `blog_task_rel_user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `blog_task_rel_user` (
- `blog_id` mediumint(9) NOT NULL DEFAULT '0',
- `user_id` int(11) NOT NULL DEFAULT '0',
- `task_id` mediumint(9) NOT NULL DEFAULT '0',
- `target_date` date NOT NULL DEFAULT '0000-00-00',
- PRIMARY KEY (`blog_id`,`user_id`,`task_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with tasks assigned to a user in a blog';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `calendar_event`
- --
- DROP TABLE IF EXISTS `calendar_event`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `calendar_event` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL,
- `content` text,
- `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `parent_event_id` int(11) DEFAULT NULL,
- `session_id` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `calendar_event_attachment`
- --
- DROP TABLE IF EXISTS `calendar_event_attachment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `calendar_event_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `path` varchar(255) NOT NULL,
- `comment` text,
- `size` int(11) NOT NULL DEFAULT '0',
- `agenda_id` int(11) NOT NULL,
- `filename` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `calendar_event_repeat`
- --
- DROP TABLE IF EXISTS `calendar_event_repeat`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `calendar_event_repeat` (
- `cal_id` int(11) NOT NULL DEFAULT '0',
- `cal_type` varchar(20) DEFAULT NULL,
- `cal_end` int(11) DEFAULT NULL,
- `cal_frequency` int(11) DEFAULT '1',
- `cal_days` char(7) DEFAULT NULL,
- PRIMARY KEY (`cal_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `calendar_event_repeat_not`
- --
- DROP TABLE IF EXISTS `calendar_event_repeat_not`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `calendar_event_repeat_not` (
- `cal_id` int(11) NOT NULL,
- `cal_date` int(11) NOT NULL,
- PRIMARY KEY (`cal_id`,`cal_date`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `chat_connected`
- --
- DROP TABLE IF EXISTS `chat_connected`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `chat_connected` (
- `user_id` int(10) unsigned NOT NULL DEFAULT '0',
- `last_connection` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `session_id` int(11) NOT NULL DEFAULT '0',
- `to_group_id` int(11) NOT NULL DEFAULT '0',
- KEY `char_connected_index` (`user_id`,`session_id`,`to_group_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `course_description`
- --
- DROP TABLE IF EXISTS `course_description`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `course_description` (
- `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(255) DEFAULT NULL,
- `content` text,
- `session_id` smallint(6) DEFAULT '0',
- `description_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `progress` int(11) NOT NULL DEFAULT '0',
- UNIQUE KEY `id` (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `course_setting`
- --
- DROP TABLE IF EXISTS `course_setting`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `course_setting` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `variable` varchar(255) NOT NULL DEFAULT '',
- `subkey` varchar(255) DEFAULT NULL,
- `type` varchar(255) DEFAULT NULL,
- `category` varchar(255) DEFAULT NULL,
- `value` varchar(255) NOT NULL DEFAULT '',
- `title` varchar(255) NOT NULL DEFAULT '',
- `comment` varchar(255) DEFAULT NULL,
- `subkeytext` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `document`
- --
- DROP TABLE IF EXISTS `document`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `document` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `path` varchar(255) NOT NULL DEFAULT '',
- `comment` text,
- `title` varchar(255) DEFAULT NULL,
- `filetype` set('file','folder') NOT NULL DEFAULT 'file',
- `size` int(11) NOT NULL DEFAULT '0',
- `readonly` tinyint(3) unsigned NOT NULL,
- `session_id` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `dropbox_category`
- --
- DROP TABLE IF EXISTS `dropbox_category`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dropbox_category` (
- `cat_id` int(11) NOT NULL AUTO_INCREMENT,
- `cat_name` text NOT NULL,
- `received` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `sent` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `user_id` int(11) NOT NULL DEFAULT '0',
- `session_id` smallint(6) NOT NULL DEFAULT '0',
- PRIMARY KEY (`cat_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `dropbox_feedback`
- --
- DROP TABLE IF EXISTS `dropbox_feedback`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dropbox_feedback` (
- `feedback_id` int(11) NOT NULL AUTO_INCREMENT,
- `file_id` int(11) NOT NULL DEFAULT '0',
- `author_user_id` int(11) NOT NULL DEFAULT '0',
- `feedback` text NOT NULL,
- `feedback_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`feedback_id`),
- KEY `file_id` (`file_id`),
- KEY `author_user_id` (`author_user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `dropbox_file`
- --
- DROP TABLE IF EXISTS `dropbox_file`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dropbox_file` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `uploader_id` int(10) unsigned NOT NULL DEFAULT '0',
- `filename` varchar(250) NOT NULL DEFAULT '',
- `filesize` int(10) unsigned NOT NULL,
- `title` varchar(250) DEFAULT '',
- `description` varchar(250) DEFAULT '',
- `author` varchar(250) DEFAULT '',
- `upload_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `last_upload_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `cat_id` int(11) NOT NULL DEFAULT '0',
- `session_id` smallint(5) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UN_filename` (`filename`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `dropbox_person`
- --
- DROP TABLE IF EXISTS `dropbox_person`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dropbox_person` (
- `file_id` int(10) unsigned NOT NULL,
- `user_id` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`file_id`,`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `dropbox_post`
- --
- DROP TABLE IF EXISTS `dropbox_post`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `dropbox_post` (
- `file_id` int(10) unsigned NOT NULL,
- `dest_user_id` int(10) unsigned NOT NULL DEFAULT '0',
- `feedback_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `feedback` text,
- `cat_id` int(11) NOT NULL DEFAULT '0',
- `session_id` smallint(5) unsigned NOT NULL,
- PRIMARY KEY (`file_id`,`dest_user_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_attachment`
- --
- DROP TABLE IF EXISTS `forum_attachment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_attachment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `path` varchar(255) NOT NULL,
- `comment` text,
- `size` int(11) NOT NULL DEFAULT '0',
- `post_id` int(11) NOT NULL,
- `filename` varchar(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_category`
- --
- DROP TABLE IF EXISTS `forum_category`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_category` (
- `cat_id` int(11) NOT NULL AUTO_INCREMENT,
- `cat_title` varchar(255) NOT NULL DEFAULT '',
- `cat_comment` text,
- `cat_order` int(11) NOT NULL DEFAULT '0',
- `locked` int(11) NOT NULL DEFAULT '0',
- `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`cat_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_forum`
- --
- DROP TABLE IF EXISTS `forum_forum`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_forum` (
- `forum_id` int(11) NOT NULL AUTO_INCREMENT,
- `forum_title` varchar(255) NOT NULL DEFAULT '',
- `forum_comment` text,
- `forum_threads` int(11) DEFAULT '0',
- `forum_posts` int(11) DEFAULT '0',
- `forum_last_post` int(11) DEFAULT '0',
- `forum_category` int(11) DEFAULT NULL,
- `allow_anonymous` int(11) DEFAULT NULL,
- `allow_edit` int(11) DEFAULT NULL,
- `approval_direct_post` varchar(20) DEFAULT NULL,
- `allow_attachments` int(11) DEFAULT NULL,
- `allow_new_threads` int(11) DEFAULT NULL,
- `default_view` varchar(20) DEFAULT NULL,
- `forum_of_group` varchar(20) DEFAULT NULL,
- `forum_group_public_private` varchar(20) DEFAULT 'public',
- `forum_order` int(11) DEFAULT NULL,
- `locked` int(11) NOT NULL DEFAULT '0',
- `session_id` int(11) NOT NULL DEFAULT '0',
- `forum_image` varchar(255) NOT NULL DEFAULT '',
- `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`forum_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_mailcue`
- --
- DROP TABLE IF EXISTS `forum_mailcue`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_mailcue` (
- `thread_id` int(11) DEFAULT NULL,
- `user_id` int(11) DEFAULT NULL,
- `post_id` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_notification`
- --
- DROP TABLE IF EXISTS `forum_notification`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_notification` (
- `user_id` int(11) DEFAULT NULL,
- `forum_id` int(11) DEFAULT NULL,
- `thread_id` int(11) DEFAULT NULL,
- `post_id` int(11) DEFAULT NULL,
- KEY `user_id` (`user_id`),
- KEY `forum_id` (`forum_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_post`
- --
- DROP TABLE IF EXISTS `forum_post`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_post` (
- `post_id` int(11) NOT NULL AUTO_INCREMENT,
- `post_title` varchar(250) DEFAULT NULL,
- `post_text` text,
- `thread_id` int(11) DEFAULT '0',
- `forum_id` int(11) DEFAULT '0',
- `poster_id` int(11) DEFAULT '0',
- `poster_name` varchar(100) DEFAULT '',
- `post_date` datetime DEFAULT '0000-00-00 00:00:00',
- `post_notification` tinyint(4) DEFAULT '0',
- `post_parent_id` int(11) DEFAULT '0',
- `visible` tinyint(4) DEFAULT '1',
- PRIMARY KEY (`post_id`),
- KEY `poster_id` (`poster_id`),
- KEY `forum_id` (`forum_id`),
- KEY `idx_forum_post_thread_id` (`thread_id`),
- KEY `idx_forum_post_visible` (`visible`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_thread`
- --
- DROP TABLE IF EXISTS `forum_thread`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_thread` (
- `thread_id` int(11) NOT NULL AUTO_INCREMENT,
- `thread_title` varchar(255) DEFAULT NULL,
- `forum_id` int(11) DEFAULT NULL,
- `thread_replies` int(11) DEFAULT '0',
- `thread_poster_id` int(11) DEFAULT NULL,
- `thread_poster_name` varchar(100) DEFAULT '',
- `thread_views` int(11) DEFAULT '0',
- `thread_last_post` int(11) DEFAULT NULL,
- `thread_date` datetime DEFAULT '0000-00-00 00:00:00',
- `thread_sticky` tinyint(3) unsigned DEFAULT '0',
- `locked` int(11) NOT NULL DEFAULT '0',
- `session_id` int(10) unsigned DEFAULT NULL,
- `thread_title_qualify` varchar(255) DEFAULT '',
- `thread_qualify_max` float(6,2) unsigned NOT NULL DEFAULT '0.00',
- `thread_close_date` datetime DEFAULT '0000-00-00 00:00:00',
- `thread_weight` float(6,2) unsigned NOT NULL DEFAULT '0.00',
- PRIMARY KEY (`thread_id`),
- KEY `idx_forum_thread_forum_id` (`forum_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_thread_qualify`
- --
- DROP TABLE IF EXISTS `forum_thread_qualify`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_thread_qualify` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(10) unsigned NOT NULL,
- `thread_id` int(11) NOT NULL,
- `qualify` float(6,2) NOT NULL DEFAULT '0.00',
- `qualify_user_id` int(11) DEFAULT NULL,
- `qualify_time` datetime DEFAULT '0000-00-00 00:00:00',
- `session_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `user_id` (`user_id`,`thread_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `forum_thread_qualify_log`
- --
- DROP TABLE IF EXISTS `forum_thread_qualify_log`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forum_thread_qualify_log` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(10) unsigned NOT NULL,
- `thread_id` int(11) NOT NULL,
- `qualify` float(6,2) NOT NULL DEFAULT '0.00',
- `qualify_user_id` int(11) DEFAULT NULL,
- `qualify_time` datetime DEFAULT '0000-00-00 00:00:00',
- `session_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `user_id` (`user_id`,`thread_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `glossary`
- --
- DROP TABLE IF EXISTS `glossary`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `glossary` (
- `glossary_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `description` text NOT NULL,
- `display_order` int(11) DEFAULT NULL,
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`glossary_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `group_category`
- --
- DROP TABLE IF EXISTS `group_category`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `group_category` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL DEFAULT '',
- `description` text NOT NULL,
- `doc_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `calendar_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `work_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `announcements_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `forum_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `wiki_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `chat_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `max_student` smallint(5) unsigned NOT NULL DEFAULT '8',
- `self_reg_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `self_unreg_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `groups_per_user` smallint(5) unsigned NOT NULL DEFAULT '0',
- `display_order` smallint(5) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `group_info`
- --
- DROP TABLE IF EXISTS `group_info`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `group_info` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(100) DEFAULT NULL,
- `category_id` int(10) unsigned NOT NULL DEFAULT '0',
- `description` text,
- `max_student` smallint(5) unsigned NOT NULL DEFAULT '8',
- `doc_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `calendar_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `work_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `announcements_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `forum_state` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `wiki_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `chat_state` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `secret_directory` varchar(255) DEFAULT NULL,
- `self_registration_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `self_unregistration_allowed` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `group_rel_tutor`
- --
- DROP TABLE IF EXISTS `group_rel_tutor`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `group_rel_tutor` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `group_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `group_rel_user`
- --
- DROP TABLE IF EXISTS `group_rel_user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `group_rel_user` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(10) unsigned NOT NULL,
- `group_id` int(10) unsigned NOT NULL DEFAULT '0',
- `status` int(11) NOT NULL DEFAULT '0',
- `role` char(50) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `item_property`
- --
- DROP TABLE IF EXISTS `item_property`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `item_property` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `tool` varchar(100) NOT NULL DEFAULT '',
- `insert_user_id` int(10) unsigned NOT NULL DEFAULT '0',
- `insert_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `lastedit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `ref` int(11) NOT NULL DEFAULT '0',
- `lastedit_type` varchar(100) NOT NULL DEFAULT '',
- `lastedit_user_id` int(10) unsigned NOT NULL DEFAULT '0',
- `to_group_id` int(10) unsigned DEFAULT NULL,
- `to_user_id` int(10) unsigned DEFAULT NULL,
- `visibility` tinyint(4) NOT NULL DEFAULT '1',
- `start_visible` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `end_visible` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `id_session` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `idx_item_property_toolref` (`tool`,`ref`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `link`
- --
- DROP TABLE IF EXISTS `link`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `link` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `url` text NOT NULL,
- `title` varchar(150) DEFAULT NULL,
- `description` text,
- `category_id` smallint(5) unsigned DEFAULT NULL,
- `display_order` smallint(5) unsigned NOT NULL DEFAULT '0',
- `on_homepage` enum('0','1') NOT NULL DEFAULT '0',
- `target` char(10) DEFAULT '_self',
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `link_category`
- --
- DROP TABLE IF EXISTS `link_category`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `link_category` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
- `category_title` varchar(255) NOT NULL,
- `description` text,
- `display_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `lp`
- --
- DROP TABLE IF EXISTS `lp`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lp` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `lp_type` smallint(5) unsigned NOT NULL,
- `name` varchar(255) NOT NULL,
- `ref` tinytext,
- `description` text,
- `path` text NOT NULL,
- `force_commit` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `default_view_mod` char(32) NOT NULL DEFAULT 'embedded',
- `default_encoding` char(32) NOT NULL DEFAULT 'UTF-8',
- `display_order` int(10) unsigned NOT NULL DEFAULT '0',
- `content_maker` tinytext NOT NULL,
- `content_local` varchar(32) NOT NULL DEFAULT 'local',
- `content_license` text NOT NULL,
- `prevent_reinit` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `js_lib` tinytext NOT NULL,
- `debug` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `theme` varchar(255) NOT NULL DEFAULT '',
- `preview_image` varchar(255) NOT NULL DEFAULT '',
- `author` varchar(255) NOT NULL DEFAULT '',
- `session_id` int(10) unsigned NOT NULL DEFAULT '0',
- `prerequisite` int(10) unsigned NOT NULL DEFAULT '0',
- `use_max_score` int(10) unsigned NOT NULL DEFAULT '1',
- `autolunch` int(10) unsigned NOT NULL DEFAULT '0',
- `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `publicated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `expired_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `lp_item`
- --
- DROP TABLE IF EXISTS `lp_item`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lp_item` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `lp_id` int(10) unsigned NOT NULL,
- `item_type` char(32) NOT NULL DEFAULT 'dokeos_document',
- `ref` tinytext NOT NULL,
- `title` varchar(511) NOT NULL,
- `description` varchar(511) NOT NULL DEFAULT '',
- `path` text NOT NULL,
- `min_score` float unsigned NOT NULL DEFAULT '0',
- `max_score` float unsigned DEFAULT '100',
- `mastery_score` float unsigned DEFAULT NULL,
- `parent_item_id` int(10) unsigned NOT NULL DEFAULT '0',
- `previous_item_id` int(10) unsigned NOT NULL DEFAULT '0',
- `next_item_id` int(10) unsigned NOT NULL DEFAULT '0',
- `display_order` int(10) unsigned NOT NULL DEFAULT '0',
- `prerequisite` text,
- `parameters` text,
- `launch_data` text NOT NULL,
- `max_time_allowed` char(13) DEFAULT '',
- `terms` text,
- `search_did` int(11) DEFAULT NULL,
- `audio` varchar(250) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `lp_id` (`lp_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `lp_item_view`
- --
- DROP TABLE IF EXISTS `lp_item_view`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lp_item_view` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `lp_item_id` int(10) unsigned NOT NULL,
- `lp_view_id` int(10) unsigned NOT NULL,
- `view_count` int(10) unsigned NOT NULL DEFAULT '0',
- `start_time` int(10) unsigned NOT NULL,
- `total_time` int(10) unsigned NOT NULL DEFAULT '0',
- `score` float unsigned NOT NULL DEFAULT '0',
- `status` char(32) NOT NULL DEFAULT 'not attempted',
- `suspend_data` text,
- `lesson_location` text,
- `core_exit` varchar(32) NOT NULL DEFAULT 'none',
- `max_score` varchar(8) DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `lp_item_id` (`lp_item_id`),
- KEY `lp_view_id` (`lp_view_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `lp_iv_interaction`
- --
- DROP TABLE IF EXISTS `lp_iv_interaction`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lp_iv_interaction` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `order_id` smallint(5) unsigned NOT NULL DEFAULT '0',
- `lp_iv_id` bigint(20) unsigned NOT NULL,
- `interaction_id` varchar(255) NOT NULL DEFAULT '',
- `interaction_type` varchar(255) NOT NULL DEFAULT '',
- `weighting` double NOT NULL DEFAULT '0',
- `completion_time` varchar(16) NOT NULL DEFAULT '',
- `correct_responses` text NOT NULL,
- `student_response` text NOT NULL,
- `result` varchar(255) NOT NULL DEFAULT '',
- `latency` varchar(16) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `lp_iv_id` (`lp_iv_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `lp_iv_objective`
- --
- DROP TABLE IF EXISTS `lp_iv_objective`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lp_iv_objective` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `lp_iv_id` bigint(20) unsigned NOT NULL,
- `order_id` smallint(5) unsigned NOT NULL DEFAULT '0',
- `objective_id` varchar(255) NOT NULL DEFAULT '',
- `score_raw` float unsigned NOT NULL DEFAULT '0',
- `score_max` float unsigned NOT NULL DEFAULT '0',
- `score_min` float unsigned NOT NULL DEFAULT '0',
- `status` char(32) NOT NULL DEFAULT 'not attempted',
- PRIMARY KEY (`id`),
- KEY `lp_iv_id` (`lp_iv_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `lp_view`
- --
- DROP TABLE IF EXISTS `lp_view`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lp_view` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `lp_id` int(10) unsigned NOT NULL,
- `user_id` int(10) unsigned NOT NULL,
- `view_count` smallint(5) unsigned NOT NULL DEFAULT '0',
- `last_item` int(10) unsigned NOT NULL DEFAULT '0',
- `progress` int(10) unsigned DEFAULT '0',
- `session_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `lp_id` (`lp_id`),
- KEY `user_id` (`user_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `notebook`
- --
- DROP TABLE IF EXISTS `notebook`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `notebook` (
- `notebook_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(10) unsigned NOT NULL,
- `course` varchar(40) NOT NULL,
- `session_id` int(11) NOT NULL DEFAULT '0',
- `title` varchar(255) NOT NULL,
- `description` text NOT NULL,
- `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `update_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `status` int(11) DEFAULT NULL,
- PRIMARY KEY (`notebook_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `online_connected`
- --
- DROP TABLE IF EXISTS `online_connected`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `online_connected` (
- `user_id` int(10) unsigned NOT NULL,
- `last_connection` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `online_link`
- --
- DROP TABLE IF EXISTS `online_link`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `online_link` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
- `name` char(50) NOT NULL DEFAULT '',
- `url` char(100) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `permission_group`
- --
- DROP TABLE IF EXISTS `permission_group`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `permission_group` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `group_id` int(11) NOT NULL DEFAULT '0',
- `tool` varchar(250) NOT NULL DEFAULT '',
- `action` varchar(250) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `permission_task`
- --
- DROP TABLE IF EXISTS `permission_task`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `permission_task` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `task_id` int(11) NOT NULL DEFAULT '0',
- `tool` varchar(250) NOT NULL DEFAULT '',
- `action` varchar(250) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `permission_user`
- --
- DROP TABLE IF EXISTS `permission_user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `permission_user` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL DEFAULT '0',
- `tool` varchar(250) NOT NULL DEFAULT '',
- `action` varchar(250) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `quiz`
- --
- DROP TABLE IF EXISTS `quiz`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `quiz` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL,
- `description` text,
- `sound` varchar(255) DEFAULT NULL,
- `type` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `random` smallint(6) NOT NULL DEFAULT '0',
- `random_answers` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `active` tinyint(4) NOT NULL DEFAULT '0',
- `results_disabled` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `access_condition` text,
- `max_attempt` int(11) NOT NULL DEFAULT '0',
- `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `end_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `feedback_type` int(11) NOT NULL DEFAULT '0',
- `expired_time` int(11) NOT NULL DEFAULT '0',
- `session_id` smallint(6) DEFAULT '0',
- `propagate_neg` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `quiz_answer`
- --
- DROP TABLE IF EXISTS `quiz_answer`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `quiz_answer` (
- `id` mediumint(8) unsigned NOT NULL,
- `question_id` mediumint(8) unsigned NOT NULL,
- `answer` text NOT NULL,
- `correct` mediumint(8) unsigned DEFAULT NULL,
- `comment` text,
- `ponderation` float(6,2) NOT NULL DEFAULT '0.00',
- `position` mediumint(8) unsigned NOT NULL DEFAULT '1',
- `hotspot_coordinates` text,
- `hotspot_type` enum('square','circle','poly','delineation','oar') DEFAULT NULL,
- `destination` text NOT NULL,
- `id_auto` int(11) NOT NULL AUTO_INCREMENT,
- PRIMARY KEY (`id`,`question_id`),
- UNIQUE KEY `id_auto` (`id_auto`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `quiz_question`
- --
- DROP TABLE IF EXISTS `quiz_question`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `quiz_question` (
- `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- `question` text NOT NULL,
- `description` text,
- `ponderation` float(6,2) NOT NULL DEFAULT '0.00',
- `position` mediumint(8) unsigned NOT NULL DEFAULT '1',
- `type` tinyint(3) unsigned NOT NULL DEFAULT '2',
- `picture` varchar(50) DEFAULT NULL,
- `level` int(10) unsigned NOT NULL DEFAULT '0',
- `extra` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `position` (`position`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `quiz_question_option`
- --
- DROP TABLE IF EXISTS `quiz_question_option`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `quiz_question_option` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `question_id` int(11) NOT NULL,
- `name` varchar(255) DEFAULT NULL,
- `position` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `quiz_rel_question`
- --
- DROP TABLE IF EXISTS `quiz_rel_question`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `quiz_rel_question` (
- `question_id` mediumint(8) unsigned NOT NULL,
- `exercice_id` mediumint(8) unsigned NOT NULL,
- `question_order` mediumint(8) unsigned NOT NULL DEFAULT '1',
- PRIMARY KEY (`question_id`,`exercice_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `resource`
- --
- DROP TABLE IF EXISTS `resource`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `resource` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `source_type` varchar(50) DEFAULT NULL,
- `source_id` int(10) unsigned DEFAULT NULL,
- `resource_type` varchar(50) DEFAULT NULL,
- `resource_id` int(10) unsigned DEFAULT NULL,
- UNIQUE KEY `id` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `role`
- --
- DROP TABLE IF EXISTS `role`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role` (
- `role_id` int(11) NOT NULL AUTO_INCREMENT,
- `role_name` varchar(250) NOT NULL DEFAULT '',
- `role_comment` text,
- `default_role` tinyint(4) DEFAULT '0',
- PRIMARY KEY (`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `role_group`
- --
- DROP TABLE IF EXISTS `role_group`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role_group` (
- `role_id` int(11) NOT NULL DEFAULT '0',
- `scope` varchar(20) NOT NULL DEFAULT 'course',
- `group_id` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `role_permissions`
- --
- DROP TABLE IF EXISTS `role_permissions`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role_permissions` (
- `role_id` int(11) NOT NULL DEFAULT '0',
- `tool` varchar(250) NOT NULL DEFAULT '',
- `action` varchar(50) NOT NULL DEFAULT '',
- `default_perm` tinyint(4) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `role_user`
- --
- DROP TABLE IF EXISTS `role_user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role_user` (
- `role_id` int(11) NOT NULL DEFAULT '0',
- `scope` varchar(20) NOT NULL DEFAULT 'course',
- `user_id` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `student_publication`
- --
- DROP TABLE IF EXISTS `student_publication`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `student_publication` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `url` varchar(255) DEFAULT NULL,
- `title` varchar(255) DEFAULT NULL,
- `description` text,
- `author` varchar(255) DEFAULT NULL,
- `active` tinyint(4) DEFAULT NULL,
- `accepted` tinyint(4) DEFAULT '0',
- `post_group_id` int(11) NOT NULL DEFAULT '0',
- `sent_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `filetype` set('file','folder') NOT NULL DEFAULT 'file',
- `has_properties` int(10) unsigned NOT NULL DEFAULT '0',
- `view_properties` tinyint(4) DEFAULT NULL,
- `qualification` float(6,2) unsigned NOT NULL DEFAULT '0.00',
- `date_of_qualification` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
- `qualificator_id` int(10) unsigned NOT NULL DEFAULT '0',
- `weight` float(6,2) unsigned NOT NULL DEFAULT '0.00',
- `session_id` int(10) unsigned NOT NULL DEFAULT '0',
- `user_id` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `student_publication_assignment`
- --
- DROP TABLE IF EXISTS `student_publication_assignment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `student_publication_assignment` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `ends_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `add_to_calendar` tinyint(4) NOT NULL,
- `enable_qualification` tinyint(4) NOT NULL,
- `publication_id` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `survey`
- --
- DROP TABLE IF EXISTS `survey`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `survey` (
- `survey_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `code` varchar(20) DEFAULT NULL,
- `title` text,
- `subtitle` text,
- `author` varchar(20) DEFAULT NULL,
- `lang` varchar(20) DEFAULT NULL,
- `avail_from` date DEFAULT NULL,
- `avail_till` date DEFAULT NULL,
- `is_shared` char(1) DEFAULT '1',
- `template` varchar(20) DEFAULT NULL,
- `intro` text,
- `surveythanks` text,
- `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `invited` int(11) NOT NULL,
- `answered` int(11) NOT NULL,
- `invite_mail` text NOT NULL,
- `reminder_mail` text NOT NULL,
- `mail_subject` varchar(255) NOT NULL,
- `anonymous` enum('0','1') NOT NULL DEFAULT '0',
- `access_condition` text,
- `shuffle` tinyint(1) NOT NULL DEFAULT '0',
- `one_question_per_page` tinyint(1) NOT NULL DEFAULT '0',
- `survey_version` varchar(255) NOT NULL DEFAULT '',
- `parent_id` int(10) unsigned NOT NULL,
- `survey_type` int(11) NOT NULL DEFAULT '0',
- `show_form_profile` int(11) NOT NULL DEFAULT '0',
- `form_fields` text NOT NULL,
- `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`survey_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `survey_answer`
- --
- DROP TABLE IF EXISTS `survey_answer`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `survey_answer` (
- `answer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `survey_id` int(10) unsigned NOT NULL,
- `question_id` int(10) unsigned NOT NULL,
- `option_id` text NOT NULL,
- `value` int(10) unsigned NOT NULL,
- `user` varchar(250) NOT NULL,
- PRIMARY KEY (`answer_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `survey_group`
- --
- DROP TABLE IF EXISTS `survey_group`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `survey_group` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(20) NOT NULL,
- `description` varchar(255) NOT NULL,
- `survey_id` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `survey_invitation`
- --
- DROP TABLE IF EXISTS `survey_invitation`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `survey_invitation` (
- `survey_invitation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `survey_code` varchar(20) NOT NULL,
- `user` varchar(250) NOT NULL,
- `invitation_code` varchar(250) NOT NULL,
- `invitation_date` datetime NOT NULL,
- `reminder_date` datetime NOT NULL,
- `answered` int(11) NOT NULL DEFAULT '0',
- `session_id` smallint(5) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`survey_invitation_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `survey_question`
- --
- DROP TABLE IF EXISTS `survey_question`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `survey_question` (
- `question_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `survey_id` int(10) unsigned NOT NULL,
- `survey_question` text NOT NULL,
- `survey_question_comment` text NOT NULL,
- `type` varchar(250) NOT NULL,
- `display` varchar(10) NOT NULL,
- `sort` int(11) NOT NULL,
- `shared_question_id` int(11) DEFAULT NULL,
- `max_value` int(11) DEFAULT NULL,
- `survey_group_pri` int(10) unsigned NOT NULL DEFAULT '0',
- `survey_group_sec1` int(10) unsigned NOT NULL DEFAULT '0',
- `survey_group_sec2` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`question_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `survey_question_option`
- --
- DROP TABLE IF EXISTS `survey_question_option`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `survey_question_option` (
- `question_option_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `question_id` int(10) unsigned NOT NULL,
- `survey_id` int(10) unsigned NOT NULL,
- `option_text` text NOT NULL,
- `sort` int(11) NOT NULL,
- `value` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`question_option_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `thematic`
- --
- DROP TABLE IF EXISTS `thematic`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `thematic` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL,
- `content` text,
- `display_order` int(10) unsigned NOT NULL DEFAULT '0',
- `active` tinyint(4) NOT NULL DEFAULT '0',
- `session_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `active` (`active`,`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `thematic_advance`
- --
- DROP TABLE IF EXISTS `thematic_advance`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `thematic_advance` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `thematic_id` int(11) NOT NULL,
- `attendance_id` int(11) NOT NULL DEFAULT '0',
- `content` text,
- `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `duration` int(11) NOT NULL DEFAULT '0',
- `done_advance` tinyint(4) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `thematic_id` (`thematic_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `thematic_plan`
- --
- DROP TABLE IF EXISTS `thematic_plan`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `thematic_plan` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `thematic_id` int(11) NOT NULL,
- `title` varchar(255) NOT NULL,
- `description` text,
- `description_type` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `thematic_id` (`thematic_id`,`description_type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `tool`
- --
- DROP TABLE IF EXISTS `tool`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `tool` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `link` varchar(255) NOT NULL,
- `image` varchar(255) DEFAULT NULL,
- `visibility` tinyint(3) unsigned DEFAULT '0',
- `admin` varchar(255) DEFAULT NULL,
- `address` varchar(255) DEFAULT NULL,
- `added_tool` tinyint(3) unsigned DEFAULT '1',
- `target` enum('_self','_blank') NOT NULL DEFAULT '_self',
- `category` varchar(20) NOT NULL DEFAULT 'authoring',
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `tool_intro`
- --
- DROP TABLE IF EXISTS `tool_intro`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `tool_intro` (
- `id` varchar(50) NOT NULL,
- `intro_text` text NOT NULL,
- `session_id` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`,`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `userinfo_content`
- --
- DROP TABLE IF EXISTS `userinfo_content`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `userinfo_content` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` int(10) unsigned NOT NULL,
- `definition_id` int(10) unsigned NOT NULL,
- `editor_ip` varchar(39) DEFAULT NULL,
- `edition_time` datetime DEFAULT NULL,
- `content` text NOT NULL,
- PRIMARY KEY (`id`),
- KEY `user_id` (`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `userinfo_def`
- --
- DROP TABLE IF EXISTS `userinfo_def`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `userinfo_def` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(80) NOT NULL DEFAULT '',
- `comment` text,
- `line_count` tinyint(3) unsigned NOT NULL DEFAULT '5',
- `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `wiki`
- --
- DROP TABLE IF EXISTS `wiki`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wiki` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `page_id` int(11) NOT NULL DEFAULT '0',
- `reflink` varchar(255) NOT NULL DEFAULT 'index',
- `title` varchar(255) NOT NULL,
- `content` mediumtext NOT NULL,
- `user_id` int(11) NOT NULL DEFAULT '0',
- `group_id` int(11) DEFAULT NULL,
- `dtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `addlock` int(11) NOT NULL DEFAULT '1',
- `editlock` int(11) NOT NULL DEFAULT '0',
- `visibility` int(11) NOT NULL DEFAULT '1',
- `addlock_disc` int(11) NOT NULL DEFAULT '1',
- `visibility_disc` int(11) NOT NULL DEFAULT '1',
- `ratinglock_disc` int(11) NOT NULL DEFAULT '1',
- `assignment` int(11) NOT NULL DEFAULT '0',
- `comment` text NOT NULL,
- `progress` text NOT NULL,
- `score` int(11) DEFAULT '0',
- `version` int(11) DEFAULT NULL,
- `is_editing` int(11) NOT NULL DEFAULT '0',
- `time_edit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `hits` int(11) DEFAULT '0',
- `linksto` text NOT NULL,
- `tag` text NOT NULL,
- `user_ip` varchar(39) NOT NULL,
- `session_id` smallint(6) DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `reflink` (`reflink`),
- KEY `group_id` (`group_id`),
- KEY `page_id` (`page_id`),
- KEY `session_id` (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `wiki_conf`
- --
- DROP TABLE IF EXISTS `wiki_conf`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wiki_conf` (
- `page_id` int(11) NOT NULL DEFAULT '0',
- `task` text NOT NULL,
- `feedback1` text NOT NULL,
- `feedback2` text NOT NULL,
- `feedback3` text NOT NULL,
- `fprogress1` varchar(3) NOT NULL,
- `fprogress2` varchar(3) NOT NULL,
- `fprogress3` varchar(3) NOT NULL,
- `max_size` int(11) DEFAULT NULL,
- `max_text` int(11) DEFAULT NULL,
- `max_version` int(11) DEFAULT NULL,
- `startdate_assig` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `enddate_assig` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `delayedsubmit` int(11) NOT NULL DEFAULT '0',
- KEY `page_id` (`page_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `wiki_discuss`
- --
- DROP TABLE IF EXISTS `wiki_discuss`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wiki_discuss` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `publication_id` int(11) NOT NULL DEFAULT '0',
- `userc_id` int(11) NOT NULL DEFAULT '0',
- `comment` text NOT NULL,
- `p_score` varchar(255) DEFAULT NULL,
- `dtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Table structure for table `wiki_mailcue`
- --
- DROP TABLE IF EXISTS `wiki_mailcue`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `wiki_mailcue` (
- `id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `type` text NOT NULL,
- `group_id` int(11) DEFAULT NULL,
- `session_id` smallint(6) DEFAULT '0',
- KEY `id` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2013-03-27 11:48:31
|