[Hw4mdl-svn] SF.net SVN: hw4mdl: [7] trunk/moodle/mod/liveclassroom/db

[<hu...@us...>]

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.