|
From: Michael K. <ko...@us...> - 2006-05-29 08:46:35
|
Update of /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv18647 Modified Files: course.xml course_date.xml course_lecturer.xml course_module.xml course_prog.xml course_progrel.xml Log Message: Index: course_date.xml =================================================================== RCS file: /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db/course_date.xml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- course_date.xml 24 Jun 2004 06:55:37 -0000 1.1 +++ course_date.xml 29 May 2006 08:46:30 -0000 1.2 @@ -5,6 +5,7 @@ <column name="did" type="int" primarykey="true"/> <column name="cid" type="int" notnull="true"/> <column name="dtype" type="char(1)"/> + <!-- 0=standard, 1=exercise, 2=central exercise --> <column name="dcycle" type="int"/> <!-- 0=single/dayly, 1=weekly, 2=biweekly --> <column name="dstartdate" type="date"/> Index: course_prog.xml =================================================================== RCS file: /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db/course_prog.xml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- course_prog.xml 24 Jun 2004 06:55:37 -0000 1.1 +++ course_prog.xml 29 May 2006 08:46:30 -0000 1.2 @@ -6,7 +6,6 @@ <column name="cpname" type="varchar(200)"/> <column name="cpname_en" type="varchar(200)"/> <column name="cplabel" type="varchar(20)"/> - <column name="cpsubproglabel" type="varchar(10)"/> <column name="cpcomment" type="varchar(250)"/> </tablelayout> Index: course.xml =================================================================== RCS file: /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db/course.xml,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- course.xml 22 Aug 2005 13:52:06 -0000 1.4 +++ course.xml 29 May 2006 08:46:30 -0000 1.5 @@ -12,22 +12,28 @@ <column name="cname_en" type="varchar(150)"/> <column name="ccomment" type="varchar(255)"/> <column name="clang" type="char(2)"/> - <column name="cgroup" type="int"/> <!--cgroup is categoryid --> <column name="curl" type="varchar(200)"/> - <column name="cparticipants" type="int"/> + <column name="ccapacity" type="int"/> <column name="cectscredits" type="float(6)"/> - + + <column name="cexaminerid" type="int"/> + <!-- reference to lecturer --> + <column name="chours_lec" type="int"/> <column name="chours_ex" type="int"/> <column name="chours_sem" type="int"/> <column name="chours_lab" type="int"/> + <column name="ctarget" type="text"/> + <column name="ctarget_en" type="text"/> <column name="ccontent" type="text"/> <column name="ccontent_en" type="text"/> <column name="cprerequ" type="text"/> <column name="cprerequ_en" type="text"/> - <column name="cprerequcert" type="text"/> - <column name="cprerequcert_en" type="text"/> + <column name="ccert" type="text"/> + <column name="ccert_en" type="text"/> + <column name="cdidactics" type="text"/> + <column name="cdidactics_en" type="text"/> <column name="clastupdateuserid" type="int"/> <column name="clastupdate" type="timestamp"/> Index: course_lecturer.xml =================================================================== RCS file: /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db/course_lecturer.xml,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- course_lecturer.xml 13 Dec 2005 09:05:02 -0000 1.4 +++ course_lecturer.xml 29 May 2006 08:46:30 -0000 1.5 @@ -10,10 +10,12 @@ <column name="llastname" type="varchar(20)"/> <column name="lurl" type="varchar(200)"/> <column name="limageurl" type="varchar(200)"/> - <column name="lgroup" type="int"/> <column name="lextid" type="varchar(40)"/> <column name="lhidden" type="int"/> + + <column name="luserid" type="int"/> + <!-- reference to cobricks user --> <index name="courselecturer_lid" unique="unique"> <colname>lid</colname> Index: course_progrel.xml =================================================================== RCS file: /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db/course_progrel.xml,v retrieving revision 1.2 retrieving revision 1.3 diff -u -d -r1.2 -r1.3 --- course_progrel.xml 22 Aug 2005 13:52:06 -0000 1.2 +++ course_progrel.xml 29 May 2006 08:46:30 -0000 1.3 @@ -7,6 +7,7 @@ <column name="cpstartsem" type="int"/> <column name="cpendsem" type="int"/> <column name="cptype" type="varchar(2)"/> + <column name="cpcomment" type="text"/> </tablelayout> </table> Index: course_module.xml =================================================================== RCS file: /cvsroot/cobricks/cobricks2/src/org/cobricks/course/db/course_module.xml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- course_module.xml 22 Aug 2005 13:52:06 -0000 1.1 +++ course_module.xml 29 May 2006 08:46:30 -0000 1.2 @@ -3,8 +3,8 @@ <tablelayout> <column name="cmid" type="int" primarykey="true"/> - <column name="cmparentid" type="int"/> - + <column name="cmsid" type="varchar(10)" /> + <column name="cmname" type="varchar(200)"/> <column name="cmname_en" type="varchar(200)"/> <column name="cmshortname" type="varchar(30)"/> @@ -16,20 +16,28 @@ <column name="cmhours_sem" type="int"/> <column name="cmhours_lab" type="int"/> + <column name="cmtarget" type="text"/> + <column name="cmtarget_en" type="text"/> <column name="cmcontent" type="text"/> <column name="cmcontent_en" type="text"/> <column name="cmprerequ" type="text"/> <column name="cmprerequ_en" type="text"/> - <column name="cmprerequcert" type="text"/> - <column name="cmprerequcert_en" type="text"/> + <column name="cmcert" type="text"/> + <column name="cmcert_en" type="text"/> + <column name="cmdidactics" type="text"/> + <column name="cmdidactics_en" type="text"/> <column name="cmimport" type="int"/> <column name="cmhidden" type="int"/> - <!-- 0=confirmed/show, 1=outdated/hidden, 2=not confirmed/hidden --> - <column name="cmcycle" type="int"/> - <column name="cmappdate" type="timestamp"/> - <column name="cmapplicant" type="varchar(150)"/> - <column name="cmexaminer" type="varchar(150)"/> + <!-- 0=confirmed/show, 1=archived/hidden, 2=not confirmed/hidden --> + <column name="cmcycle" type="varchar(10)"/> + + <column name="cmcapacity" type="int"/> + <column name="cmresponsible" type="int"/> + <!-- reference to lecturer --> + <column name="cmcomment" type="text"/> + + <column name="cmaddxml" type="text"/> <index name="coursemodule_cmid" unique="unique"> <colname>cmid</colname> |