Subversion Repositories Applications.gtt

Compare Revisions

Ignore whitespace Rev 109 → Rev 110

/trunk/documentation/gtt_maj_001.sql
New file
0,0 → 1,9
ALTER TABLE `gestion_projet` ADD `gp_duree_finance` FLOAT NOT NULL AFTER `gp_duree_prevue` ;
 
ALTER TABLE `gestion_utilisateur` ADD `gu_tdt_lundi` FLOAT NOT NULL DEFAULT '0' AFTER `gu_temps_de_travail_mois` ,
ADD `gu_tdt_mardi` FLOAT NOT NULL DEFAULT '0' AFTER `gu_tdt_lundi` ,
ADD `gu_tdt_mercredi` FLOAT NOT NULL DEFAULT '0' AFTER `gu_tdt_mardi` ,
ADD `gu_tdt_jeudi` FLOAT NOT NULL DEFAULT '0' AFTER `gu_tdt_mercredi` ,
ADD `gu_tdt_vendredi` FLOAT NOT NULL DEFAULT '0' AFTER `gu_tdt_jeudi` ,
ADD `gu_tdt_samedi` FLOAT NOT NULL DEFAULT '0' AFTER `gu_tdt_vendredi` ,
ADD `gu_tdt_dimanche` FLOAT NOT NULL DEFAULT '0' AFTER `gu_tdt_samedi` ;
/trunk/documentation/gtt_v4.xml
554,6 → 554,11
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1787" ColName="gp_duree_finance" PrevColName="" Pos="9" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Dur\195\169e en jour financ\195\169 pour le projet.">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1459" ColName="gp_avancement" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="Pourcentage d\aavancement du projet.">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
711,11 → 716,51
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1489" ColName="gu_temps_de_travail" PrevColName="" Pos="13" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
<COLUMN ID="1489" ColName="gu_temps_de_travail_jour" PrevColName="gu_temps_de_travail" Pos="13" idDatatype="7" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1789" ColName="gu_temps_de_travail_mois" PrevColName="" Pos="23" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1779" ColName="gu_tdt_lundi" PrevColName="" Pos="16" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1780" ColName="gu_tdt_mardi" PrevColName="" Pos="17" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1781" ColName="gu_tdt_mercredi" PrevColName="" Pos="18" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1782" ColName="gu_tdt_jeudi" PrevColName="" Pos="19" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1783" ColName="gu_tdt_vendredi" PrevColName="" Pos="20" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1784" ColName="gu_tdt_samedi" PrevColName="" Pos="21" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1785" ColName="gu_tdt_dimanche" PrevColName="" Pos="22" idDatatype="7" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="1490" ColName="gu_mark_admin" PrevColName="" Pos="14" idDatatype="22" DatatypeParams="" Width="0" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
<OPTIONSELECTED>
</OPTIONSELECTED>