[phpwebapp-commits] CVS: top10/docs database.xmi,1.1,1.2 ToDo.txt,1.11,1.12

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/phpwebapp/top10/docs
In directory sc8-pr-cvs1:/tmp/cvs-serv31213/docs

Modified Files:
	database.xmi ToDo.txt 
Log Message:

Index: database.xmi
===================================================================
RCS file: /cvsroot/phpwebapp/top10/docs/database.xmi,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** database.xmi	23 Sep 2003 14:52:40 -0000	1.1
--- database.xmi	5 Jan 2004 14:42:00 -0000	1.2
***************
*** 1,15 ****
  <?xml version="1.0" encoding="UTF-8"?>
  <XMI xmlns:UML="org.omg/standards/UML" verified="false" timestamp="" xmi.version="1.2" >
! <XMI.header>
! <XMI.documentation>
! <XMI.exporter>umbrello uml modeller http://uml.sf.net</XMI.exporter>
!    <XMI.exporterVersion>1.1</XMI.exporterVersion>  </XMI.documentation>
!   <XMI.model xmi.name="database" href="/var/www/html/top10/docs/database.xmi" />
!   <XMI.metamodel xmi.name="UML" href="UML.xml" xmi.version="1.3" /> </XMI.header>
   <XMI.content>
! <docsettings viewid="1" documentation="" uniqueid="45" />
    <umlobjects>
! <UML:Class stereotype="" package="" xmi.id="2" abstract="0" documentation="" name="proj_list" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="9" value="" type="string" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="10" value="" type="string" abstract="0" documentation="" name="proj_name" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="11" value="" type="string" abstract="0" documentation="" name="proj_descr" static="0" scope="200" />
--- 1,17 ----
  <?xml version="1.0" encoding="UTF-8"?>
  <XMI xmlns:UML="org.omg/standards/UML" verified="false" timestamp="" xmi.version="1.2" >
!  <XMI.header>
!   <XMI.documentation>
!    <XMI.exporter>umbrello uml modeller http://uml.sf.net</XMI.exporter>
!    <XMI.exporterVersion>1.1</XMI.exporterVersion>
!   </XMI.documentation>
!   <XMI.model xmi.name="database" href="/var/www/html/phpwebapp/top10/docs/database.xmi" />
!   <XMI.metamodel xmi.name="UML" href="UML.xml" xmi.version="1.3" />
!  </XMI.header>
   <XMI.content>
!   <docsettings viewid="1" documentation="" uniqueid="46" />
    <umlobjects>
!    <UML:Class stereotype="" package="" xmi.id="2" abstract="0" documentation="" name="proj_list" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="9" value="" type="string" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="10" value="" type="string" abstract="0" documentation="" name="proj_name" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="11" value="" type="string" abstract="0" documentation="" name="proj_descr" static="0" scope="200" />
***************
*** 20,39 ****
      <UML:Attribute stereotype="" package="" xmi.id="16" value="" type="int" abstract="0" documentation="" name="register_date" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="17" value="" type="int" abstract="0" documentation="" name="group_id" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="18" value="" type="int" abstract="0" documentation="" name="points" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="3" abstract="0" documentation="" name="preference_list" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="19" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="20" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="21" value="" type="int" abstract="0" documentation="" name="position" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="4" abstract="0" documentation="" name="proj_members" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="22" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="23" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="5" abstract="0" documentation="" name="categories" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="24" value="" type="int" abstract="0" documentation="" name="category" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="6" abstract="0" documentation="" name="languages" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="25" value="" type="int" abstract="0" documentation="" name="prog_lang" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="7" abstract="0" documentation="" name="licenses" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="26" value="" type="int" abstract="0" documentation="" name="license" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="8" abstract="0" documentation="" name="requests" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="27" value="" type="int" abstract="0" documentation="" name="request_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="28" value="" type="int" abstract="0" documentation="" name="time" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="29" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
--- 22,47 ----
      <UML:Attribute stereotype="" package="" xmi.id="16" value="" type="int" abstract="0" documentation="" name="register_date" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="17" value="" type="int" abstract="0" documentation="" name="group_id" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="18" value="" type="int" abstract="0" documentation="" name="points" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="3" abstract="0" documentation="" name="preference_list" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="19" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="20" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="21" value="" type="int" abstract="0" documentation="" name="position" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="4" abstract="0" documentation="" name="proj_members" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="22" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="23" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="5" abstract="0" documentation="" name="categories" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="24" value="" type="int" abstract="0" documentation="" name="category" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="6" abstract="0" documentation="" name="languages" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="25" value="" type="int" abstract="0" documentation="" name="prog_lang" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="7" abstract="0" documentation="" name="licenses" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="26" value="" type="int" abstract="0" documentation="" name="license" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="8" abstract="0" documentation="" name="requests" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="27" value="" type="int" abstract="0" documentation="" name="request_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="28" value="" type="int" abstract="0" documentation="" name="time" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="29" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
***************
*** 41,56 ****
      <UML:Attribute stereotype="" package="" xmi.id="31" value="" type="int" abstract="0" documentation="" name="type" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="32" value="" type="int" abstract="0" documentation="" name="data" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="33" value="" type="int" abstract="0" documentation="" name="status" static="0" scope="200" />   </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="34" abstract="0" documentation="" name="comments" static="0" scope="200" >
! <UML:Attribute stereotype="" package="" xmi.id="35" value="" type="int" abstract="0" documentation="" name="comment_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="36" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="37" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="38" value="" type="int" abstract="0" documentation="" name="comment" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="39" value="" type="int" abstract="0" documentation="" name="date" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="40" value="" type="int" abstract="0" documentation="" name="ip" static="0" scope="200" />   </UML:Class>  </umlobjects>
    <diagrams>
! <diagram snapgrid="0" showattsig="0" fillcolor="#ffffc0" showgrid="0" showopsig="0" usefillcolor="1" snapx="10" snapy="10" showatts="1" xmi.id="1" documentation="" type="402" showops="0" showpackage="0" name="database diagram" localid="30000" showstereotype="0" showscope="0" font="Sans,10,-1,5,50,0,0,0,0,0" linecolor="#ff0000" >
! <widgets>
! <UML:ConceptWidget usesdiagramfillcolour="0" width="94" showattsigs="603" usesdiagramusefillcolour="0" x="42" linecolour="#ff0000" y="93" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="187" usefillcolor="1" showattributes="1" xmi.id="2" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:ConceptWidget usesdiagramfillcolour="0" width="105" showattsigs="603" usesdiagramusefillcolour="0" x="246" linecolour="#ff0000" y="183" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="68" usefillcolor="1" showattributes="1" xmi.id="3" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:ConceptWidget usesdiagramfillcolour="0" width="104" showattsigs="603" usesdiagramusefillcolour="0" x="244" linecolour="#ff0000" y="96" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="51" usefillcolor="1" showattributes="1" xmi.id="4" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
--- 49,68 ----
      <UML:Attribute stereotype="" package="" xmi.id="31" value="" type="int" abstract="0" documentation="" name="type" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="32" value="" type="int" abstract="0" documentation="" name="data" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="33" value="" type="int" abstract="0" documentation="" name="status" static="0" scope="200" />
!    </UML:Class>
     <UML:Class stereotype="" package="" xmi.id="34" abstract="0" documentation="" name="comments" static="0" scope="200" >
!     <UML:Attribute stereotype="" package="" xmi.id="35" value="" type="int" abstract="0" documentation="" name="comment_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="36" value="" type="int" abstract="0" documentation="" name="proj_id" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="37" value="" type="int" abstract="0" documentation="" name="username" static="0" scope="200" />
+     <UML:Attribute stereotype="" package="" xmi.id="46" value="" type="string" abstract="0" documentation="" name="title" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="38" value="" type="int" abstract="0" documentation="" name="comment" static="0" scope="200" />
      <UML:Attribute stereotype="" package="" xmi.id="39" value="" type="int" abstract="0" documentation="" name="date" static="0" scope="200" />
!     <UML:Attribute stereotype="" package="" xmi.id="40" value="" type="int" abstract="0" documentation="" name="ip" static="0" scope="200" />
!    </UML:Class>
!   </umlobjects>
    <diagrams>
!    <diagram snapgrid="0" showattsig="0" fillcolor="#ffffc0" showgrid="0" showopsig="0" usefillcolor="1" snapx="10" snapy="10" showatts="1" xmi.id="1" documentation="" type="402" showops="0" showpackage="0" name="database diagram" localid="30000" showstereotype="0" showscope="0" font="Sans,10,-1,5,50,0,0,0,0,0" linecolor="#ff0000" >
!     <widgets>
!      <UML:ConceptWidget usesdiagramfillcolour="0" width="94" showattsigs="603" usesdiagramusefillcolour="0" x="42" linecolour="#ff0000" y="93" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="187" usefillcolor="1" showattributes="1" xmi.id="2" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:ConceptWidget usesdiagramfillcolour="0" width="105" showattsigs="603" usesdiagramusefillcolour="0" x="246" linecolour="#ff0000" y="183" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="68" usefillcolor="1" showattributes="1" xmi.id="3" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:ConceptWidget usesdiagramfillcolour="0" width="104" showattsigs="603" usesdiagramusefillcolour="0" x="244" linecolour="#ff0000" y="96" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="51" usefillcolor="1" showattributes="1" xmi.id="4" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
***************
*** 59,128 ****
       <UML:ConceptWidget usesdiagramfillcolour="1" width="65" showattsigs="603" usesdiagramusefillcolour="1" x="421" linecolour="none" y="237" showopsigs="603" usesdiagramlinecolour="1" fillcolour="none" height="34" usefillcolor="1" showattributes="1" xmi.id="7" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:ConceptWidget usesdiagramfillcolour="0" width="79" showattsigs="603" usesdiagramusefillcolour="0" x="275" linecolour="#ff0000" y="335" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="136" usefillcolor="1" showattributes="1" xmi.id="8" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
!      <UML:ConceptWidget usesdiagramfillcolour="0" width="91" showattsigs="603" usesdiagramusefillcolour="0" x="44" linecolour="#ff0000" y="355" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="119" usefillcolor="1" showattributes="1" xmi.id="34" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:NoteWidget usesdiagramfillcolour="1" width="149" usesdiagramusefillcolour="1" x="573" linecolour="none" y="151" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="42" text="Helper tables used by listbox-es." font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:NoteWidget usesdiagramfillcolour="1" width="179" usesdiagramusefillcolour="1" x="443" linecolour="none" y="365" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="44" text="Keeps the requests that require confirmation." font="Sans,10,-1,5,50,0,0,0,0,0" />
!      <UML:FloatingTextWidget usesdiagramfillcolour="1" width="285" usesdiagramusefillcolour="1" x="220" linecolour="none" y="26" operation="" usesdiagramlinecolour="1" role="700" fillcolour="none" height="28" usefillcolor="1" seqnum="" xmi.id="45" text="The database diagram of Top10" font="Sans,14,-1,5,50,0,0,0,0,0" />    </widgets>
      <messages/>
      <associations>
! <UML:AssocWidget totalcounta="3" indexa="1" totalcountb="2" indexb="1" widgetbid="4" widgetaid="2" documentation="" type="503" >
! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="132" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="212" linecolour="none" y="123" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1..n" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="190" linecolour="none" y="138" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <linepath>
! <startpoint startx="136" starty="155" />
!        <endpoint endx="244" endy="121" />      </linepath>     </UML:AssocWidget>
       <UML:AssocWidget totalcounta="3" indexa="2" totalcountb="2" indexb="1" widgetbid="3" widgetaid="2" documentation="" type="503" >
! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="214" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="191" linecolour="none" y="217" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <linepath>
! <startpoint startx="136" starty="217" />
!        <endpoint endx="246" endy="217" />      </linepath>     </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="34" widgetaid="2" documentation="" type="503" >
! <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="283" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" />
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="333" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" />
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="89" linecolour="none" y="318" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <linepath>
! <startpoint startx="89" starty="280" />
!        <endpoint endx="89" endy="355" />      </linepath>     </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="1" widgetbid="42" widgetaid="5" documentation="" type="513" >
! <linepath>
! <startpoint startx="490" starty="116" />
!        <endpoint endx="573" endy="163" />      </linepath>     </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="2" widgetbid="42" widgetaid="6" documentation="" type="513" >
! <linepath>
! <startpoint startx="494" starty="183" />
!        <endpoint endx="573" endy="176" />      </linepath>     </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="3" widgetbid="42" widgetaid="7" documentation="" type="513" >
! <linepath>
! <startpoint startx="453" starty="237" />
!        <endpoint endx="573" endy="188" />      </linepath>     </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="44" widgetaid="8" documentation="" type="513" >
! <linepath>
! <startpoint startx="354" starty="403" />
!        <endpoint endx="443" endy="390" />      </linepath>     </UML:AssocWidget>    </associations>   </diagram>  </diagrams>
    <listview>
! <listitem open="1" type="800" id="-1" label="Views" >
! <listitem open="1" type="801" id="-1" label="Logical View" >
! <listitem open="1" type="813" id="5" label="categories" >
! <listitem open="0" type="814" id="24" label="category" />     </listitem>
       <listitem open="0" type="807" id="1" label="class diagram" />
       <listitem open="1" type="813" id="34" label="comments" >
! <listitem open="0" type="814" id="38" label="comment" />
        <listitem open="0" type="814" id="35" label="comment_id" />
        <listitem open="0" type="814" id="39" label="date" />
        <listitem open="0" type="814" id="40" label="ip" />
        <listitem open="0" type="814" id="36" label="proj_id" />
!       <listitem open="0" type="814" id="37" label="username" />     </listitem>
       <listitem open="1" type="813" id="6" label="languages" >
! <listitem open="0" type="814" id="25" label="prog_lang" />     </listitem>
       <listitem open="1" type="813" id="7" label="licenses" >
! <listitem open="0" type="814" id="26" label="license" />     </listitem>
       <listitem open="1" type="813" id="3" label="preference_list" >
! <listitem open="0" type="814" id="21" label="position" />
        <listitem open="0" type="814" id="19" label="proj_id" />
!       <listitem open="0" type="814" id="20" label="username" />     </listitem>
       <listitem open="1" type="813" id="2" label="proj_list" >
! <listitem open="0" type="814" id="12" label="category" />
        <listitem open="0" type="814" id="17" label="group_id" />
        <listitem open="0" type="814" id="14" label="license" />
--- 71,164 ----
       <UML:ConceptWidget usesdiagramfillcolour="1" width="65" showattsigs="603" usesdiagramusefillcolour="1" x="421" linecolour="none" y="237" showopsigs="603" usesdiagramlinecolour="1" fillcolour="none" height="34" usefillcolor="1" showattributes="1" xmi.id="7" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:ConceptWidget usesdiagramfillcolour="0" width="79" showattsigs="603" usesdiagramusefillcolour="0" x="275" linecolour="#ff0000" y="335" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="136" usefillcolor="1" showattributes="1" xmi.id="8" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
!      <UML:ConceptWidget usesdiagramfillcolour="0" width="91" showattsigs="603" usesdiagramusefillcolour="0" x="44" linecolour="#ff0000" y="354" showopsigs="603" usesdiagramlinecolour="0" fillcolour="#ffffc0" height="136" usefillcolor="1" showattributes="1" xmi.id="34" showoperations="0" showpackage="0" showscope="0" showstereotype="0" font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:NoteWidget usesdiagramfillcolour="1" width="149" usesdiagramusefillcolour="1" x="573" linecolour="none" y="151" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="42" text="Helper tables used by listbox-es." font="Sans,10,-1,5,50,0,0,0,0,0" />
       <UML:NoteWidget usesdiagramfillcolour="1" width="179" usesdiagramusefillcolour="1" x="443" linecolour="none" y="365" usesdiagramlinecolour="1" fillcolour="none" height="50" usefillcolor="1" xmi.id="44" text="Keeps the requests that require confirmation." font="Sans,10,-1,5,50,0,0,0,0,0" />
!      <UML:FloatingTextWidget usesdiagramfillcolour="1" width="285" usesdiagramusefillcolour="1" x="220" linecolour="none" y="26" operation="" usesdiagramlinecolour="1" role="700" fillcolour="none" height="28" usefillcolor="1" seqnum="" xmi.id="45" text="The database diagram of Top10" font="Sans,14,-1,5,50,0,0,0,0,0" />
!     </widgets>
      <messages/>
      <associations>
!      <UML:AssocWidget totalcounta="3" indexa="1" totalcountb="2" indexb="1" widgetbid="4" widgetaid="2" documentation="" type="503" >
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="132" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="212" linecolour="none" y="123" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="1..n" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="190" linecolour="none" y="138" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <linepath>
!        <startpoint startx="136" starty="155" />
!        <endpoint endx="244" endy="121" />
!       </linepath>
!      </UML:AssocWidget>
       <UML:AssocWidget totalcounta="3" indexa="2" totalcountb="2" indexb="1" widgetbid="3" widgetaid="2" documentation="" type="503" >
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="138" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="214" linecolour="none" y="219" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="191" linecolour="none" y="217" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <linepath>
!        <startpoint startx="136" starty="217" />
!        <endpoint endx="246" endy="217" />
!       </linepath>
!      </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="34" widgetaid="2" documentation="" type="503" >
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="282" operation="" usesdiagramlinecolour="1" role="701" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..1" font="Sans,10,-1,5,50,0,0,0,0,0" />
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="57" linecolour="none" y="331" operation="" usesdiagramlinecolour="1" role="702" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="0..n" font="Sans,10,-1,5,50,0,0,0,0,0" />
!       <UML:FloatingTextWidget usesdiagramfillcolour="1" width="0" usesdiagramusefillcolour="1" x="89" linecolour="none" y="317" operation="" usesdiagramlinecolour="1" role="703" fillcolour="none" height="0" usefillcolor="1" seqnum="" xmi.id="-1" text="" font="Sans,10,-1,5,50,0,0,0,0,0" />
        <linepath>
!        <startpoint startx="89" starty="280" />
!        <endpoint endx="89" endy="354" />
!       </linepath>
!      </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="1" widgetbid="42" widgetaid="5" documentation="" type="513" >
!       <linepath>
!        <startpoint startx="490" starty="116" />
!        <endpoint endx="573" endy="163" />
!       </linepath>
!      </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="2" widgetbid="42" widgetaid="6" documentation="" type="513" >
!       <linepath>
!        <startpoint startx="494" starty="183" />
!        <endpoint endx="573" endy="176" />
!       </linepath>
!      </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="4" indexb="3" widgetbid="42" widgetaid="7" documentation="" type="513" >
!       <linepath>
!        <startpoint startx="453" starty="237" />
!        <endpoint endx="573" endy="188" />
!       </linepath>
!      </UML:AssocWidget>
       <UML:AssocWidget totalcounta="2" indexa="1" totalcountb="2" indexb="1" widgetbid="44" widgetaid="8" documentation="" type="513" >
!       <linepath>
!        <startpoint startx="354" starty="403" />
!        <endpoint endx="443" endy="390" />
!       </linepath>
!      </UML:AssocWidget>
!     </associations>
!    </diagram>
!   </diagrams>
    <listview>
!    <listitem open="1" type="800" id="-1" label="Views" >
!     <listitem open="1" type="801" id="-1" label="Logical View" >
!      <listitem open="1" type="813" id="5" label="categories" >
!       <listitem open="0" type="814" id="24" label="category" />
!      </listitem>
       <listitem open="0" type="807" id="1" label="class diagram" />
       <listitem open="1" type="813" id="34" label="comments" >
!       <listitem open="0" type="814" id="38" label="comment" />
        <listitem open="0" type="814" id="35" label="comment_id" />
        <listitem open="0" type="814" id="39" label="date" />
        <listitem open="0" type="814" id="40" label="ip" />
        <listitem open="0" type="814" id="36" label="proj_id" />
!       <listitem open="0" type="814" id="46" label="title" />
!       <listitem open="0" type="814" id="37" label="username" />
!      </listitem>
       <listitem open="1" type="813" id="6" label="languages" >
!       <listitem open="0" type="814" id="25" label="prog_lang" />
!      </listitem>
       <listitem open="1" type="813" id="7" label="licenses" >
!       <listitem open="0" type="814" id="26" label="license" />
!      </listitem>
       <listitem open="1" type="813" id="3" label="preference_list" >
!       <listitem open="0" type="814" id="21" label="position" />
        <listitem open="0" type="814" id="19" label="proj_id" />
!       <listitem open="0" type="814" id="20" label="username" />
!      </listitem>
       <listitem open="1" type="813" id="2" label="proj_list" >
!       <listitem open="0" type="814" id="12" label="category" />
        <listitem open="0" type="814" id="17" label="group_id" />
        <listitem open="0" type="814" id="14" label="license" />
***************
*** 133,142 ****
        <listitem open="0" type="814" id="10" label="proj_name" />
        <listitem open="0" type="814" id="16" label="register_date" />
!       <listitem open="0" type="814" id="13" label="status" />     </listitem>
       <listitem open="1" type="813" id="4" label="proj_members" >
! <listitem open="0" type="814" id="22" label="proj_id" />
!       <listitem open="0" type="814" id="23" label="username" />     </listitem>
       <listitem open="1" type="813" id="8" label="requests" >
! <listitem open="0" type="814" id="32" label="data" />
        <listitem open="0" type="814" id="30" label="ip" />
        <listitem open="0" type="814" id="27" label="request_id" />
--- 169,180 ----
        <listitem open="0" type="814" id="10" label="proj_name" />
        <listitem open="0" type="814" id="16" label="register_date" />
!       <listitem open="0" type="814" id="13" label="status" />
!      </listitem>
       <listitem open="1" type="813" id="4" label="proj_members" >
!       <listitem open="0" type="814" id="22" label="proj_id" />
!       <listitem open="0" type="814" id="23" label="username" />
!      </listitem>
       <listitem open="1" type="813" id="8" label="requests" >
!       <listitem open="0" type="814" id="32" label="data" />
        <listitem open="0" type="814" id="30" label="ip" />
        <listitem open="0" type="814" id="27" label="request_id" />
***************
*** 144,147 ****
        <listitem open="0" type="814" id="28" label="time" />
        <listitem open="0" type="814" id="31" label="type" />
!       <listitem open="0" type="814" id="29" label="username" />     </listitem>    </listitem>
!     <listitem open="1" type="802" id="-1" label="Use Case View" />   </listitem>  </listview> </XMI.content></XMI>
\ No newline at end of file
--- 182,191 ----
        <listitem open="0" type="814" id="28" label="time" />
        <listitem open="0" type="814" id="31" label="type" />
!       <listitem open="0" type="814" id="29" label="username" />
!      </listitem>
!     </listitem>
!     <listitem open="1" type="802" id="-1" label="Use Case View" />
!    </listitem>
!   </listview>
!  </XMI.content>
! </XMI>

Index: ToDo.txt
===================================================================
RCS file: /cvsroot/phpwebapp/top10/docs/ToDo.txt,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** ToDo.txt	29 Dec 2003 16:22:52 -0000	1.11
--- ToDo.txt	5 Jan 2004 14:42:00 -0000	1.12
***************
*** 1,14 ****

! - Check for malicious requests. Username is given by the user
!   and sometimes the project id as well; check their values so
!   that it is not possible for them to have a malicious value.

! - Using browse.php everybody can read the password of the database
!   and any other sensitive information.  Find out how to fix this.

! - Write a script that is executed periodically and updates the
!   status of old pending requests to 'expired'.

! - Make periodic backups for the database.

  ------------------------------------------------------------------
--- 1,15 ----

! - Add a hierarchical menu for selecting the category.

! - Add a module for the admin where he can change the categories,
!   languages, his password, etc.  

! - Add a module that can be accessed only by admin, where he can
!   manage the users of the application.

! -----
! 
! - Using browse.php everybody can read the password of the database
!   and any other sensitive information.  Find out how to fix this.

  ------------------------------------------------------------------