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

[<sh...@us...>]

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.