[WTF CVS] wtf/db next_rel_004.sql,1.2,1.3 schema.xml,1.3,1.4

[Gryphon S. <gry...@us...>]

Update of /cvsroot/wtf-tracker/wtf/db
In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv9489/db

Modified Files:
	next_rel_004.sql schema.xml 
Log Message:
Changes to support full Table Data administration features

Index: next_rel_004.sql
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/db/next_rel_004.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** next_rel_004.sql	7 Nov 2006 16:20:49 -0000	1.2
--- next_rel_004.sql	28 Nov 2006 18:47:50 -0000	1.3
***************
*** 43,44 ****
--- 43,47 ----
  	description = 'User can view the activity summary report detailing monthly summaries of activity by percent for each employee. Typically, this authorization is granted to finance and accounting teams.';
  
+ ALTER TABLE team ADD COLUMN ordering TINYINT UNSIGNED NOT NULL AFTER name;
+ UPDATE team SET ordering = id;
+ 

Index: schema.xml
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/db/schema.xml,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** schema.xml	11 Nov 2006 21:42:15 -0000	1.3
--- schema.xml	28 Nov 2006 18:47:50 -0000	1.4
***************
*** 2,6 ****
  <DBMODEL Version="4.0">
  <SETTINGS>
! <GLOBALSETTINGS ModelName="wtf" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="\\pecan\LaserJet 4200 PCL 6 South Workroom" HPageCount="5.14572864321608" PageAspectRatio="1.328971962616822" PageOrientation="0" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="0" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" />
  <DATATYPEGROUPS>
  <DATATYPEGROUP Name="Numeric Types" Icon="1" />
--- 2,6 ----
  <DBMODEL Version="4.0">
  <SETTINGS>
! <GLOBALSETTINGS ModelName="wtf" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="120" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="\\pecan\LaserJet 4200 PCL 6 South Workroom" HPageCount="5.14572864321608" PageAspectRatio="1.328971962616822" PageOrientation="0" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="0" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" />
  <DATATYPEGROUPS>
  <DATATYPEGROUP Name="Numeric Types" Icon="1" />
***************
*** 586,590 ****
  </INDICES>
  </TABLE>
! <TABLE ID="1205" Tablename="team" PrevTableName="Table_08" XPos="529" YPos="368" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" >
  <COLUMNS>
  <COLUMN ID="1207" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
--- 586,590 ----
  </INDICES>
  </TABLE>
! <TABLE ID="1205" Tablename="team" PrevTableName="Table_08" XPos="536" YPos="344" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" >
  <COLUMNS>
  <COLUMN ID="1207" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
***************
*** 605,608 ****
--- 605,614 ----
  </OPTIONSELECTED>
  </COLUMN>
+ <COLUMN ID="1318" ColName="ordering" PrevColName="" Pos="3" idDatatype="1" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
+ <OPTIONSELECTED>
+ <OPTIONSELECT Value="1" />
+ <OPTIONSELECT Value="0" />
+ </OPTIONSELECTED>
+ </COLUMN>
  </COLUMNS>
  <RELATIONS_START>