[Logicampus-svn] SF.net SVN: logicampus:[1311] logicampus/trunk/data/pbdo.xml

[<if...@us...>]

Revision: 1311
          http://logicampus.svn.sourceforge.net/logicampus/?rev=1311&view=rev
Author:   iflaah
Date:     2010-02-26 11:00:21 +0000 (Fri, 26 Feb 2010)

Log Message:
-----------
student evaluation form

Modified Paths:
--------------
    logicampus/trunk/data/pbdo.xml

Modified: logicampus/trunk/data/pbdo.xml
===================================================================
--- logicampus/trunk/data/pbdo.xml	2010-02-26 10:58:34 UTC (rev 1310)
+++ logicampus/trunk/data/pbdo.xml	2010-02-26 11:00:21 UTC (rev 1311)
@@ -929,5 +929,84 @@
             size="11"
             type="INTEGER"/>
   </table>
+  <table  name="evaluation_form">
+      <column name="serial_no"
+              required="true"
+              primaryKey="true"
+              size="11"
+              type="INTEGER"/>
+      <column name="question"              
+              size="255"
+              default="NULL"
+              type="VARCHAR"/>
+      <column name="visible"              
+              size="1"
+              required="true"
+              default="0"
+              type="TINYINT"/>
+      <column name="excellent"              
+		    size="1"		    
+		    default="1"
+              type="TINYINT"/>
+      <column name="very_good"              
+       		    size="1"		    
+       		    default="1"
+              type="TINYINT"/>
+      <column name="good"              
+		    size="1"		    
+		    default="1"
+              type="TINYINT"/>
+	<column name="satisfactory"
+       		    size="1"		    
+       		    default="1"
+              type="TINYINT"/>        
+	<column name="unsatisfactory"
+       		    size="1"		    
+       		    default="1"
+              type="TINYINT"/>                   
+	<column name="date_created"       		    
+       		    default="NULL"
+              type="DATETIME"/>                
+	<column name="weightage"       		    
+       		    default="0"
+              type="INTEGER"/>                                   
+  </table>
+  <table  name="evaluationform_flag">
+        <column name="eval_form"
+                default="NULL"                
+                size="20"
+                type="VARCHAR"/>
+        <column name="flag"                            
+                default="0"
+                size="1"
+                type="BINARY"/>
+        <column name="start"              
+                default="0000-00-00 00:00:00"
+                type="DATETIME"/>
+         <column name="end"              
+	        default="0000-00-00 00:00:00"
+                type="DATETIME"/>                                    
+  </table>
+  <table  name="student_evaluation_form">
+          <column name="id"
+                  default="NULL"                
+                  required="true"
+                  size="10"
+                  type="INTEGER"/>
+          <column name="student_id"                            
+                  default="0"
+                  required="true"
+                  size="11"
+                  type="INTEGER"/>
+          <column name="id_classes"                        		
+                  size="11"
+                  type="INTEGER"/>
+           <column name="serial_no"              
+  	        size="5"
+                  type="INTEGER"/>                                    
+            <column name="rank"              
+	           size="5"
+                  type="INTEGER"/>               
+  </table>
 </database>
 <!-- END OF MYSQL2TURBINE DUMP -->


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.