Revision 1ebe6c7c
Erreur dans le schéma + ajout correct des données de test
git-svn-id: https://vigilo-dev.si.c-s.fr/svn@509 b22e2e97-25c9-44ff-b637-2e5ceca36478
| bdd_vigiboard_schema.sql | ||
|---|---|---|
| 36 | 36 |
-- |
| 37 | 37 |
|
| 38 | 38 |
CREATE SEQUENCE event_history_idhistory_seq |
| 39 |
START WITH 1 |
|
| 39 | 40 |
INCREMENT BY 1 |
| 40 | 41 |
NO MAXVALUE |
| 41 | 42 |
NO MINVALUE |
| ... | ... | |
| 68 | 69 |
trouble_ticket character varying(20), |
| 69 | 70 |
occurence integer, |
| 70 | 71 |
impact integer, |
| 71 |
rawstate character varying |
|
| 72 |
rawstate character varying(8)
|
|
| 72 | 73 |
); |
| 73 | 74 |
|
| 74 | 75 |
|
| ... | ... | |
| 79 | 80 |
-- |
| 80 | 81 |
|
| 81 | 82 |
CREATE SEQUENCE events_idevent_seq |
| 83 |
START WITH 1 |
|
| 82 | 84 |
INCREMENT BY 1 |
| 83 | 85 |
NO MAXVALUE |
| 84 | 86 |
NO MINVALUE |
| ... | ... | |
| 275 | 277 |
-- |
| 276 | 278 |
|
| 277 | 279 |
CREATE SEQUENCE state_idstat_seq |
| 280 |
START WITH 1 |
|
| 278 | 281 |
INCREMENT BY 1 |
| 279 | 282 |
NO MAXVALUE |
| 280 | 283 |
NO MINVALUE |
| ... | ... | |
| 444 | 447 |
|
| 445 | 448 |
|
| 446 | 449 |
-- |
| 450 |
-- Name: idstat; Type: DEFAULT; Schema: public; Owner: vigiboard |
|
| 451 |
-- |
|
| 452 |
|
|
| 453 |
ALTER TABLE state ALTER COLUMN idstat SET DEFAULT nextval('state_idstat_seq'::regclass);
|
|
| 454 |
|
|
| 455 |
|
|
| 456 |
-- |
|
| 447 | 457 |
-- Name: group_id; Type: DEFAULT; Schema: public; Owner: vigiboard |
| 448 | 458 |
-- |
| 449 | 459 |
|
| ... | ... | |
| 577 | 587 |
|
| 578 | 588 |
|
| 579 | 589 |
-- |
| 590 |
-- Name: state_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace: |
|
| 591 |
-- |
|
| 592 |
|
|
| 593 |
ALTER TABLE ONLY state |
|
| 594 |
ADD CONSTRAINT state_pkey PRIMARY KEY (idstat); |
|
| 595 |
|
|
| 596 |
|
|
| 597 |
-- |
|
| 580 | 598 |
-- Name: tg_group_group_name_key; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace: |
| 581 | 599 |
-- |
| 582 | 600 |
|
| ... | ... | |
| 633 | 651 |
|
| 634 | 652 |
|
| 635 | 653 |
-- |
| 654 |
-- Name: version_pkey; Type: CONSTRAINT; Schema: public; Owner: vigiboard; Tablespace: |
|
| 655 |
-- |
|
| 656 |
|
|
| 657 |
ALTER TABLE ONLY version |
|
| 658 |
ADD CONSTRAINT version_pkey PRIMARY KEY (name); |
|
| 659 |
|
|
| 660 |
|
|
| 661 |
-- |
|
| 636 | 662 |
-- Name: ix_event_history_idevent; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace: |
| 637 | 663 |
-- |
| 638 | 664 |
|
| ... | ... | |
| 710 | 736 |
|
| 711 | 737 |
|
| 712 | 738 |
-- |
| 739 |
-- Name: ix_state_hostname; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace: |
|
| 740 |
-- |
|
| 741 |
|
|
| 742 |
CREATE INDEX ix_state_hostname ON state USING btree (hostname); |
|
| 743 |
|
|
| 744 |
|
|
| 745 |
-- |
|
| 746 |
-- Name: ix_state_servicename; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace: |
|
| 747 |
-- |
|
| 748 |
|
|
| 749 |
CREATE INDEX ix_state_servicename ON state USING btree (servicename); |
|
| 750 |
|
|
| 751 |
|
|
| 752 |
-- |
|
| 753 |
-- Name: ix_version_name; Type: INDEX; Schema: public; Owner: vigiboard; Tablespace: |
|
| 754 |
-- |
|
| 755 |
|
|
| 756 |
CREATE INDEX ix_version_name ON version USING btree (name); |
|
| 757 |
|
|
| 758 |
|
|
| 759 |
-- |
|
| 713 | 760 |
-- Name: event_history_idevent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard |
| 714 | 761 |
-- |
| 715 | 762 |
|
| ... | ... | |
| 838 | 885 |
|
| 839 | 886 |
|
| 840 | 887 |
-- |
| 888 |
-- Name: state_hostname_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard |
|
| 889 |
-- |
|
| 890 |
|
|
| 891 |
ALTER TABLE ONLY state |
|
| 892 |
ADD CONSTRAINT state_hostname_fkey FOREIGN KEY (hostname) REFERENCES host(name); |
|
| 893 |
|
|
| 894 |
|
|
| 895 |
-- |
|
| 896 |
-- Name: state_servicename_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard |
|
| 897 |
-- |
|
| 898 |
|
|
| 899 |
ALTER TABLE ONLY state |
|
| 900 |
ADD CONSTRAINT state_servicename_fkey FOREIGN KEY (servicename) REFERENCES service(name); |
|
| 901 |
|
|
| 902 |
|
|
| 903 |
-- |
|
| 841 | 904 |
-- Name: tg_group_permission_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: vigiboard |
| 842 | 905 |
-- |
| 843 | 906 |
|
Also available in: Unified diff