/trunk/doc/bdd/referentiel.sql |
---|
1,42 → 1,33 |
CREATE TABLE ref_triple ( |
id_triple INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
ressource VARCHAR(255) NULL , |
propriete VARCHAR(255) NULL , |
valeur TEXT NULL , |
PRIMARY KEY(id_triple) , |
INDEX ressource(ressource) , |
INDEX propriete(propriete)); |
CREATE TABLE IF NOT EXISTS `ref_triple` ( |
`id_triple` int(10) unsigned NOT NULL auto_increment, |
`ressource` varchar(255) default NULL, |
`propriete` varchar(255) default NULL, |
`valeur` text, |
PRIMARY KEY (`id_triple`), |
KEY `ressource` (`ressource`), |
KEY `propriete` (`propriete`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
CREATE TABLE IF NOT EXISTS `ref_traitement` ( |
`id_traitement` int(10) unsigned NOT NULL auto_increment, |
`referentiel_code` varchar(50) default NULL, |
`script` varchar(50) default NULL COMMENT 'Nom du script à lancer.', |
`nom` varchar(100) default NULL, |
`date_debut` datetime default NULL, |
`date_fin` datetime default NULL, |
`duree` time default NULL, |
`meta_date_creation` datetime default NULL, |
PRIMARY KEY (`id_traitement`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
CREATE TABLE ref_traitement ( |
id_traitement INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
referentiel_code VARCHAR(50) NULL , |
nom VARCHAR(100) NULL , |
date_debut DATETIME NULL , |
date_fin DATETIME NULL , |
meta_date_creation DATETIME NULL , |
PRIMARY KEY(id_traitement)); |
CREATE TABLE ref_resultat ( |
id_resultat INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
ce_traitement INTEGER UNSIGNED NULL , |
nom VARCHAR(100) NULL , |
description TEXT NULL , |
resultat BOOL NULL , |
message MEDIUMTEXT NULL , |
meta_date_creation DATETIME NULL , |
PRIMARY KEY(id_resultat) , |
INDEX ce_traitement(ce_traitement)); |
CREATE TABLE IF NOT EXISTS `ref_resultat` ( |
`id_resultat` int(10) unsigned NOT NULL auto_increment, |
`ce_traitement` int(10) unsigned default NULL, |
`nom` varchar(100) default NULL, |
`description` text, |
`resultat` tinyint(1) default NULL, |
`message` mediumtext, |
`meta_date_creation` datetime default NULL, |
PRIMARY KEY (`id_resultat`), |
KEY `ce_traitement` (`ce_traitement`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
/trunk/doc/bdd/referentiel.xml |
---|
260,8 → 260,8 |
</SETTINGS> |
<METADATA> |
<REGIONS> |
<REGION ID="27985" RegionName="Traitements" XPos="28" YPos="24" Width="691" Height="530" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Tables permettant de r\195\169aliser des traitments sur les donn\195\169es des r\195\169f\195\169rentiels." IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" /> |
<REGION ID="28021" RegionName="Exemple BDNT" XPos="743" YPos="25" Width="668" Height="529" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" /> |
<REGION ID="27985" RegionName="Traitements" XPos="28" YPos="24" Width="691" Height="530" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="Tables permettant de r\195\169aliser des traitments sur les donn\195\169es des r\195\169f\195\169rentiels." IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" /> |
</REGIONS> |
<TABLES> |
<TABLE ID="27977" Tablename="ref_traitement" PrevTableName="Table_01" XPos="87" YPos="74" 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="2" > |
279,6 → 279,12 |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="28049" ColName="script" PrevColName="type_2" Pos="7" idDatatype="20" DatatypeParams="(50)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du script \195\160 lancer."> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="0" /> |
<OPTIONSELECT Value="0" /> |
</OPTIONSELECTED> |
</COLUMN> |
<COLUMN ID="27984" ColName="nom" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="Nom du traitement"> |
<OPTIONSELECTED> |
<OPTIONSELECT Value="0" /> |
313,7 → 319,7 |
</INDEX> |
</INDICES> |
</TABLE> |
<TABLE ID="27986" Tablename="ref_resultat" PrevTableName="Table_02" XPos="87" YPos="240" 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="4" > |
<TABLE ID="27986" Tablename="ref_resultat" PrevTableName="Table_02" XPos="86" YPos="289" 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="4" > |
<COLUMNS> |
<COLUMN ID="27988" ColName="id_resultat" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> |
<OPTIONSELECTED> |