Thread: [Hw4mdl-svn] SF.net SVN: hw4mdl: [7] trunk/moodle/mod/liveclassroom/db
Brought to you by:
jhlinder,
trollinger
Menu
▾
▴
hw4mdl-svn
|
From: <hu...@us...> - 2006-04-20 14:50:23
|
Revision: 7 Author: hugues Date: 2006-04-20 07:50:17 -0700 (Thu, 20 Apr 2006) ViewCVS: http://svn.sourceforge.net/hw4mdl/?rev=7&view=rev Log Message: ----------- Postgresql stuff for the LC Added Paths: ----------- trunk/moodle/mod/liveclassroom/db/postgres7.php trunk/moodle/mod/liveclassroom/db/postgres7.sql Added: trunk/moodle/mod/liveclassroom/db/postgres7.php =================================================================== --- trunk/moodle/mod/liveclassroom/db/postgres7.php (rev 0) +++ trunk/moodle/mod/liveclassroom/db/postgres7.php 2006-04-20 14:50:17 UTC (rev 7) @@ -0,0 +1,18 @@ +<?PHP + +function liveclassroom_upgrade($oldversion) { +/// This function does anything necessary to upgrade +/// older versions to match current functionality + + global $CFG; + + if ($oldversion < 2003092800) { + + # Do something ... + + } + + return true; +} + +?> Added: trunk/moodle/mod/liveclassroom/db/postgres7.sql =================================================================== --- trunk/moodle/mod/liveclassroom/db/postgres7.sql (rev 0) +++ trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-04-20 14:50:17 UTC (rev 7) @@ -0,0 +1,18 @@ +# This file contains a complete database schema for all the +# tables used by this module, written in SQL + +# It may also contain INSERT statements for particular data +# that may be used, especially new entries in the table log_display + +CREATE TABLE prefix_liveclassroom ( + id SERIAL PRIMARY KEY, + course integer NOT NULL default '0', + name varchar(255) NOT NULL default '', + timemodified integer NOT NULL default '0' +); + +CREATE INDEX prefix_liveclassroom_course_idx ON prefix_liveclassroom (course); +# -------------------------------------------------------- + +# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'view', 'liveclassroom', 'name'); +# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'add', 'liveclassroom', 'name'); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <sh...@us...> - 2006-10-10 12:24:25
|
Revision: 80
http://svn.sourceforge.net/hw4mdl/?rev=80&view=rev
Author: shazan
Date: 2006-10-10 05:24:19 -0700 (Tue, 10 Oct 2006)
Log Message:
-----------
database update
Modified Paths:
--------------
trunk/moodle/mod/liveclassroom/db/mysql.sql
trunk/moodle/mod/liveclassroom/db/postgres7.sql
Modified: trunk/moodle/mod/liveclassroom/db/mysql.sql
===================================================================
--- trunk/moodle/mod/liveclassroom/db/mysql.sql 2006-10-10 12:24:04 UTC (rev 79)
+++ trunk/moodle/mod/liveclassroom/db/mysql.sql 2006-10-10 12:24:19 UTC (rev 80)
@@ -33,21 +33,32 @@
# It may also contain INSERT statements for particular data
# that may be used, especially new entries in the table log_display
+# --------------------------------------------------------
+
+#
+# Table structure for table `liveclassroom`
+#
+
CREATE TABLE `prefix_liveclassroom` (
`id` int(10) unsigned NOT NULL auto_increment,
`course` int(10) unsigned NOT NULL default '0',
`type` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
- `description` text NOT NULL default '',
`timemodified` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) COMMENT='Defines liveclassroom';
+# --------------------------------------------------------
+
+#
+# Table structure for table `liveclassroom_rooms`
+#
+
+
CREATE TABLE `prefix_liveclassroom_rooms` (
`id` int(10) unsigned NOT NULL auto_increment,
`course` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
- `lc_id` int(10) unsigned NOT NULL default '0',
`room_id` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) COMMENT='Defines liveclassroom rooms';
Modified: trunk/moodle/mod/liveclassroom/db/postgres7.sql
===================================================================
--- trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-10-10 12:24:04 UTC (rev 79)
+++ trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-10-10 12:24:19 UTC (rev 80)
@@ -33,15 +33,38 @@
# It may also contain INSERT statements for particular data
# that may be used, especially new entries in the table log_display
+# --------------------------------------------------------
+
+#
+# Table structure for table `liveclassroom`
+#
+
CREATE TABLE prefix_liveclassroom (
- id SERIAL PRIMARY KEY,
+ id SERIAL,
course integer NOT NULL default '0',
+ type varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
- timemodified integer NOT NULL default '0'
+ timemodified integer NOT NULL default '0',
+ PRIMARY KEY (id)
);
CREATE INDEX prefix_liveclassroom_course_idx ON prefix_liveclassroom (course);
+
# --------------------------------------------------------
+#
+# Table structure for table `liveclassroom_rooms`
+#
+
+CREATE TABLE prefix_liveclassroom_rooms (
+ id SERIAL,
+ course integer NOT NULL default '0',
+ name varchar(255) NOT NULL default '',
+ room_id varchar(255) NOT NULL default '',
+ PRIMARY KEY (id)
+);
+
+# --------------------------------------------------------
+
# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'view', 'liveclassroom', 'name');
# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'add', 'liveclassroom', 'name');
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <sh...@us...> - 2006-10-13 12:34:38
|
Revision: 82
http://svn.sourceforge.net/hw4mdl/?rev=82&view=rev
Author: shazan
Date: 2006-10-13 05:34:26 -0700 (Fri, 13 Oct 2006)
Log Message:
-----------
only one database now
Modified Paths:
--------------
trunk/moodle/mod/liveclassroom/db/mysql.sql
trunk/moodle/mod/liveclassroom/db/postgres7.sql
Modified: trunk/moodle/mod/liveclassroom/db/mysql.sql
===================================================================
--- trunk/moodle/mod/liveclassroom/db/mysql.sql 2006-10-10 12:27:07 UTC (rev 81)
+++ trunk/moodle/mod/liveclassroom/db/mysql.sql 2006-10-13 12:34:26 UTC (rev 82)
@@ -48,22 +48,4 @@
PRIMARY KEY (`id`)
) COMMENT='Defines liveclassroom';
-# --------------------------------------------------------
-#
-# Table structure for table `liveclassroom_rooms`
-#
-
-
-CREATE TABLE `prefix_liveclassroom_rooms` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `course` int(10) unsigned NOT NULL default '0',
- `name` varchar(255) NOT NULL default '',
- `room_id` varchar(255) NOT NULL default '',
- PRIMARY KEY (`id`)
-) COMMENT='Defines liveclassroom rooms';
-
-# --------------------------------------------------------
-
-# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'view', 'liveclassroom', 'name');
-# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'add', 'liveclassroom', 'name');
Modified: trunk/moodle/mod/liveclassroom/db/postgres7.sql
===================================================================
--- trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-10-10 12:27:07 UTC (rev 81)
+++ trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-10-13 12:34:26 UTC (rev 82)
@@ -50,21 +50,3 @@
CREATE INDEX prefix_liveclassroom_course_idx ON prefix_liveclassroom (course);
-# --------------------------------------------------------
-
-#
-# Table structure for table `liveclassroom_rooms`
-#
-
-CREATE TABLE prefix_liveclassroom_rooms (
- id SERIAL,
- course integer NOT NULL default '0',
- name varchar(255) NOT NULL default '',
- room_id varchar(255) NOT NULL default '',
- PRIMARY KEY (id)
-);
-
-# --------------------------------------------------------
-
-# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'view', 'liveclassroom', 'name');
-# INSERT INTO prefix_log_display VALUES ('liveclassroom', 'add', 'liveclassroom', 'name');
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <sh...@us...> - 2006-12-08 09:27:03
|
Revision: 107
http://svn.sourceforge.net/hw4mdl/?rev=107&view=rev
Author: shazan
Date: 2006-12-08 01:26:55 -0800 (Fri, 08 Dec 2006)
Log Message:
-----------
add "secton" to the liveclassroom database to manage the activities sections update
Modified Paths:
--------------
trunk/moodle/mod/liveclassroom/db/mysql.sql
trunk/moodle/mod/liveclassroom/db/postgres7.sql
Modified: trunk/moodle/mod/liveclassroom/db/mysql.sql
===================================================================
--- trunk/moodle/mod/liveclassroom/db/mysql.sql 2006-12-07 16:08:14 UTC (rev 106)
+++ trunk/moodle/mod/liveclassroom/db/mysql.sql 2006-12-08 09:26:55 UTC (rev 107)
@@ -44,6 +44,7 @@
`course` int(10) unsigned NOT NULL default '0',
`type` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
+ `section` int(10) unsigned NOT NULL default '0',
`timemodified` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) COMMENT='Defines liveclassroom';
Modified: trunk/moodle/mod/liveclassroom/db/postgres7.sql
===================================================================
--- trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-12-07 16:08:14 UTC (rev 106)
+++ trunk/moodle/mod/liveclassroom/db/postgres7.sql 2006-12-08 09:26:55 UTC (rev 107)
@@ -44,6 +44,7 @@
course integer NOT NULL default '0',
type varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
+ section integer NOT NULL default '0',
timemodified integer NOT NULL default '0',
PRIMARY KEY (id)
);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <sh...@us...> - 2006-12-22 15:16:31
|
Revision: 125
http://svn.sourceforge.net/hw4mdl/?rev=125&view=rev
Author: shazan
Date: 2006-12-22 07:16:30 -0800 (Fri, 22 Dec 2006)
Log Message:
-----------
manage the database creation on moodle 1.7
Added Paths:
-----------
trunk/moodle/mod/liveclassroom/db/install.xml
trunk/moodle/mod/liveclassroom/db/migrate2utf8.php
trunk/moodle/mod/liveclassroom/db/migrate2utf8.xml
Added: trunk/moodle/mod/liveclassroom/db/install.xml
===================================================================
--- trunk/moodle/mod/liveclassroom/db/install.xml (rev 0)
+++ trunk/moodle/mod/liveclassroom/db/install.xml 2006-12-22 15:16:30 UTC (rev 125)
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<XMLDB PATH="mod/liveclassroom/db" VERSION="20060812" COMMENT="XMLDB file for Moodle mod/liveclassroom">
+ <TABLES>
+ <TABLE NAME="liveclassroom" COMMENT="Defines liveclassroom">
+ <FIELDS>
+ <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="course"/>
+ <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="type"/>
+ <FIELD NAME="type" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="course" NEXT="name"/>
+ <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="type" NEXT="section"/>
+ <FIELD NAME="section" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="timemodified"/>
+ <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="section"/>
+ </FIELDS>
+ <KEYS>
+ <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for liveclassroom"/>
+ </KEYS>
+ <INDEXES>
+ <INDEX NAME="course" UNIQUE="false" FIELDS="course"/>
+ </INDEXES>
+ </TABLE>
+ </TABLES>
+
+</XMLDB>
\ No newline at end of file
Property changes on: trunk/moodle/mod/liveclassroom/db/install.xml
___________________________________________________________________
Name: svn:mime-type
+ text/xml
Name: svn:keywords
+ Date Revision Author Id
Name: svn:eol-style
+ native
Added: trunk/moodle/mod/liveclassroom/db/migrate2utf8.php
===================================================================
--- trunk/moodle/mod/liveclassroom/db/migrate2utf8.php (rev 0)
+++ trunk/moodle/mod/liveclassroom/db/migrate2utf8.php 2006-12-22 15:16:30 UTC (rev 125)
@@ -0,0 +1,157 @@
+<?php // $Id$
+function migrate2utf8_wiki_name($recordid){
+ global $CFG, $globallang;
+
+/// Some trivial checks
+ if (empty($recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if (!$wiki = get_record('wiki','id',$recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if ($globallang) {
+ $fromenc = $globallang;
+ } else {
+ $sitelang = $CFG->lang;
+ $courselang = get_course_lang($wiki->course); //Non existing!
+ $userlang = get_main_teacher_lang($wiki->course); //N.E.!!
+
+ $fromenc = get_original_encoding($sitelang, $courselang, $userlang);
+ }
+
+/// We are going to use textlib facilities
+
+/// Convert the text
+ if (($fromenc != 'utf-8') && ($fromenc != 'UTF-8')) {
+ $result = utfconvert($wiki->name, $fromenc);
+
+ $newwiki = new object;
+ $newwiki->id = $recordid;
+ $newwiki->name = $result;
+ migrate2utf8_update_record('wiki',$newwiki);
+ }
+/// And finally, just return the converted field
+ return $result;
+}
+
+function migrate2utf8_wiki_summary($recordid){
+ global $CFG, $globallang;
+
+/// Some trivial checks
+ if (empty($recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if (!$wiki = get_record('wiki','id',$recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if ($globallang) {
+ $fromenc = $globallang;
+ } else {
+ $sitelang = $CFG->lang;
+ $courselang = get_course_lang($wiki->course); //Non existing!
+ $userlang = get_main_teacher_lang($wiki->course); //N.E.!!
+
+ $fromenc = get_original_encoding($sitelang, $courselang, $userlang);
+ }
+
+/// We are going to use textlib facilities
+
+/// Convert the text
+ if (($fromenc != 'utf-8') && ($fromenc != 'UTF-8')) {
+ $result = utfconvert($wiki->summary, $fromenc);
+
+ $newwiki = new object;
+ $newwiki->id = $recordid;
+ $newwiki->summary = $result;
+ migrate2utf8_update_record('wiki',$newwiki);
+ }
+/// And finally, just return the converted field
+ return $result;
+}
+
+function migrate2utf8_wiki_pagename($recordid){
+ global $CFG, $globallang;
+
+/// Some trivial checks
+ if (empty($recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if (!$wiki = get_record('wiki','id',$recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if ($globallang) {
+ $fromenc = $globallang;
+ } else {
+ $sitelang = $CFG->lang;
+ $courselang = get_course_lang($wiki->course); //Non existing!
+ $userlang = get_main_teacher_lang($wiki->course); //N.E.!!
+
+ $fromenc = get_original_encoding($sitelang, $courselang, $userlang);
+ }
+
+/// We are going to use textlib facilities
+
+/// Convert the text
+ if (($fromenc != 'utf-8') && ($fromenc != 'UTF-8')) {
+ $result = utfconvert($wiki->pagename, $fromenc);
+
+ $newwiki = new object;
+ $newwiki->id = $recordid;
+ $newwiki->pagename = $result;
+ migrate2utf8_update_record('wiki',$newwiki);
+ }
+/// And finally, just return the converted field
+ return $result;
+}
+
+function migrate2utf8_wiki_initialcontent($recordid){
+ global $CFG, $globallang;
+
+/// Some trivial checks
+ if (empty($recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+
+ if (!$wiki = get_record('wiki','id',$recordid)) {
+ log_the_problem_somewhere();
+ return false;
+ }
+ if ($globallang) {
+ $fromenc = $globallang;
+ } else {
+ $sitelang = $CFG->lang;
+ $courselang = get_course_lang($wiki->course); //Non existing!
+ $userlang = get_main_teacher_lang($wiki->course); //N.E.!!
+
+ $fromenc = get_original_encoding($sitelang, $courselang, $userlang);
+ }
+
+/// We are going to use textlib facilities
+
+/// Convert the text
+ if (($fromenc != 'utf-8') && ($fromenc != 'UTF-8')) {
+ $result = utfconvert($wiki->initialcontent, $fromenc);
+
+ $newwiki = new object;
+ $newwiki->id = $recordid;
+ $newwiki->initialcontent = $result;
+ migrate2utf8_update_record('wiki',$newwiki);
+ }
+/// And finally, just return the converted field
+ return $result;
+}
+
+?>
Property changes on: trunk/moodle/mod/liveclassroom/db/migrate2utf8.php
___________________________________________________________________
Name: svn:mime-type
+ text/plain
Name: svn:keywords
+ Date Revision Author Id
Name: svn:eol-style
+ native
Added: trunk/moodle/mod/liveclassroom/db/migrate2utf8.xml
===================================================================
--- trunk/moodle/mod/liveclassroom/db/migrate2utf8.xml (rev 0)
+++ trunk/moodle/mod/liveclassroom/db/migrate2utf8.xml 2006-12-22 15:16:30 UTC (rev 125)
@@ -0,0 +1,126 @@
+<DBMIGRATION type="mod/wiki" VERSION="2005120100">
+ <TABLES>
+ <TABLE name="wiki_entries">
+ <FIELDS>
+ <FIELD name="pagename" method="PLAIN_SQL_UPDATE" type="varchar" length="255" dropindex="pagename" addindex="pagename(pagename(255))">
+ <SQL_DETECT_USER>
+ SELECT we.userid
+ FROM {$CFG->prefix}wiki_entries we
+ WHERE we.id=RECORDID
+ </SQL_DETECT_USER>
+ <SQL_DETECT_COURSE>
+ SELECT w.course
+ FROM {$CFG->prefix}wiki w,
+ {$CFG->prefix}wiki_entries we
+ WHERE w.id = we.wikiid
+ AND we.id = RECORDID
+ </SQL_DETECT_COURSE>
+ </FIELD>
+ </FIELDS>
+ </TABLE>
+ <TABLE name="wiki_pages">
+ <FIELDS>
+ <FIELD name="pagename" method="PLAIN_SQL_UPDATE" type="varchar" length="160" dropindex="wiki_pages_uk" addindex="wiki_pages_uk(pagename(160), version, wiki)">
+ <SQL_DETECT_USER>
+ SELECT wp.userid
+ FROM {$CFG->prefix}wiki_pages wp
+ WHERE wp.id=RECORDID
+ </SQL_DETECT_USER>
+ <SQL_DETECT_COURSE>
+ SELECT w.course
+ FROM {$CFG->prefix}wiki w,
+ {$CFG->prefix}wiki_pages wp
+ WHERE w.id = wp.wiki
+ AND wp.id = RECORDID
+ </SQL_DETECT_COURSE>
+ </FIELD>
+ <FIELD name="content" method="PLAIN_SQL_UPDATE" type="mediumtext" length="0">
+ <SQL_DETECT_USER>
+ SELECT wp.userid
+ FROM {$CFG->prefix}wiki_pages wp
+ WHERE wp.id=RECORDID
+ </SQL_DETECT_USER>
+ <SQL_DETECT_COURSE>
+ SELECT w.course
+ FROM {$CFG->prefix}wiki w,
+ {$CFG->prefix}wiki_pages wp
+ WHERE w.id = wp.wiki
+ AND wp.id = RECORDID
+ </SQL_DETECT_COURSE>
+ </FIELD>
+ <FIELD name="author" method="PLAIN_SQL_UPDATE" type="varchar" length="100" default="ewiki">
+ <SQL_DETECT_USER>
+ SELECT wp.userid
+ FROM {$CFG->prefix}wiki_pages wp
+ WHERE wp.id=RECORDID
+ </SQL_DETECT_USER>
+ <SQL_DETECT_COURSE>
+ SELECT w.course
+ FROM {$CFG->prefix}wiki w,
+ {$CFG->prefix}wiki_pages wp
+ WHERE w.id = wp.wiki
+ AND wp.id = RECORDID
+ </SQL_DETECT_COURSE>
+ </FIELD>
+ <FIELD name="refs" method="PLAIN_SQL_UPDATE" type="mediumtext" length="0">
+ <SQL_DETECT_USER>
+ SELECT wp.userid
+ FROM {$CFG->prefix}wiki_pages wp
+ WHERE wp.id=RECORDID
+ </SQL_DETECT_USER>
+ <SQL_DETECT_COURSE>
+ SELECT w.course
+ FROM {$CFG->prefix}wiki w,
+ {$CFG->prefix}wiki_pages wp
+ WHERE w.id = wp.wiki
+ AND wp.id = RECORDID
+ </SQL_DETECT_COURSE>
+ </FIELD>
+ <FIELD name="meta" method="NO_CONV" type="mediumtext" length="0" />
+ </FIELDS>
+ </TABLE>
+ <TABLE name="wiki">
+ <FIELDS>
+ <FIELD name="name" method="PHP_FUNCTION" type="varchar" length="255">
+ <PHP_FUNCTION>
+ migrate2utf8_wiki_name(RECORDID)
+ </PHP_FUNCTION>
+ </FIELD>
+ <FIELD name="summary" method="PHP_FUNCTION" type="text" length="0">
+ <PHP_FUNCTION>
+ migrate2utf8_wiki_summary(RECORDID)
+ </PHP_FUNCTION>
+ </FIELD>
+ <FIELD name="pagename" method="PHP_FUNCTION" type="varchar" length="255">
+ <PHP_FUNCTION>
+ migrate2utf8_wiki_pagename(RECORDID)
+ </PHP_FUNCTION>
+ </FIELD>
+ <FIELD name="wtype" method="NO_CONV" type="enum('teacher', 'group', 'student')" length="0" default="group" />
+ <FIELD name="initialcontent" method="PHP_FUNCTION" type="varchar" length="255">
+ <PHP_FUNCTION>
+ migrate2utf8_wiki_initialcontent(RECORDID)
+ </PHP_FUNCTION>
+ </FIELD>
+ </FIELDS>
+ </TABLE>
+ <TABLE name="wiki_locks">
+ <FIELDS>
+ <FIELD name="pagename" method="PLAIN_SQL_UPDATE" type="varchar" length="255">
+ <SQL_DETECT_USER>
+ SELECT wl.userid
+ FROM {$CFG->prefix}wiki_locks wl
+ WHERE wl.id=RECORDID
+ </SQL_DETECT_USER>
+ <SQL_DETECT_COURSE>
+ SELECT w.course
+ FROM {$CFG->prefix}wiki w,
+ {$CFG->prefix}wiki_locks wl
+ WHERE w.id = wl.wikiid
+ AND wl.id = RECORDID
+ </SQL_DETECT_COURSE>
+ </FIELD>
+ </FIELDS>
+ </TABLE>
+ </TABLES>
+</DBMIGRATION>
Property changes on: trunk/moodle/mod/liveclassroom/db/migrate2utf8.xml
___________________________________________________________________
Name: svn:mime-type
+ text/xml
Name: svn:keywords
+ Date Revision Author Id
Name: svn:eol-style
+ native
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
Thanks for helping keep SourceForge clean.
X