Revision 7de4d7b8
Correction des fichiers SQL de test pour correspondre au Model
git-svn-id: https://vigilo-dev.si.c-s.fr/svn@505 b22e2e97-25c9-44ff-b637-2e5ceca36478
| bdd_vigiboard_schema.sql | ||
|---|---|---|
| 59 | 59 |
idevent integer NOT NULL, |
| 60 | 60 |
hostname character varying(100) NOT NULL, |
| 61 | 61 |
servicename character varying(100), |
| 62 |
server_source character varying(100), |
|
| 63 | 62 |
severity integer NOT NULL, |
| 64 | 63 |
status character varying(12) DEFAULT 'None'::character varying NOT NULL, |
| 65 | 64 |
active boolean, |
| 66 | 65 |
"timestamp" timestamp without time zone, |
| 67 | 66 |
output text NOT NULL, |
| 68 |
event_timestamp timestamp without time zone, |
|
| 69 |
last_check timestamp without time zone, |
|
| 70 |
recover_output text, |
|
| 71 | 67 |
timestamp_active timestamp without time zone, |
| 72 |
timestamp_cleared timestamp without time zone, |
|
| 73 | 68 |
trouble_ticket character varying(20), |
| 74 | 69 |
occurence integer, |
| 75 | 70 |
impact integer, |
Also available in: Unified diff