View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000599 | NOALYSS | Code Cleaning | public | 2012-06-01 14:28 | 2012-06-30 01:20 |
| Reporter | danydb | Assigned To | danydb | ||
| Priority | normale | Severity | mineur | Reproducibility | non essayé |
| Status | fermé | Resolution | corrigé | ||
| Product Version | Next Release | ||||
| Target Version | 6.5 | Fixed in Version | 6.5 | ||
| Summary | 0000599: Table action_gestion_related | ||||
| Description | Les actions liées sont actuellement hiérarchiques, il faudrait toutes les placer dans action_gestion_related et supprimer dans action_gestion la colonne ag_ref_ag_id | ||||
| Tags | No tags attached. | ||||
| Extension Noalyss | |||||
|
|
Création de 2 tables CREATE TABLE link_action_type ( l_id bigserial NOT NULL, -- PK l_desc character varying, CONSTRAINT link_action_type_pkey PRIMARY KEY (l_id ) ); CREATE TABLE action_gestion_related ( aga_id bigserial NOT NULL, -- pk aga_least bigint NOT NULL, -- fk to action_gestion, smallest ag_id aga_greatest bigint NOT NULL, -- fk to action_gestion greatest ag_id aga_type bigint, -- Type de liens CONSTRAINT action_gestion_related_pkey PRIMARY KEY (aga_id ), CONSTRAINT action_gestion_related_aga_greatest_fkey FOREIGN KEY (aga_greatest) REFERENCES action_gestion (ag_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT action_gestion_related_aga_least_fkey FOREIGN KEY (aga_least) REFERENCES action_gestion (ag_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT action_gestion_related_aga_type_fkey FOREIGN KEY (aga_type) REFERENCES link_action_type (l_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT ux_aga_least_aga_greatest UNIQUE (aga_least , aga_greatest ) ); |
|
|
Pour l'instant il n'y a pas de type de liens |
|
|
Version publiée |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-06-01 14:28 | danydb | New Issue | |
| 2012-06-01 20:22 | danydb | Note Added: 0001188 | |
| 2012-06-02 11:36 | danydb | Note Added: 0001189 | |
| 2012-06-02 11:36 | danydb | Status | new => resolved |
| 2012-06-02 11:36 | danydb | Fixed in Version | => Next Release |
| 2012-06-02 11:36 | danydb | Resolution | open => fixed |
| 2012-06-02 11:36 | danydb | Assigned To | => danydb |
| 2012-06-30 01:16 | danydb | Fixed in Version | Next Release => 6.5 |
| 2012-06-30 01:17 | danydb | Target Version | Next Release => 6.5 |
| 2012-06-30 01:20 | danydb | Note Added: 0001300 | |
| 2012-06-30 01:20 | danydb | Status | resolved => closed |
