| /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> |