/bdd_vigiboard_schema.sql - Diff - Vigiboard - UNITY 360

Revision e0b69bf9

ID	e0b69bf969953bb0f9dfde0157223a190215300c
Parent	c051900b
Child	af532fa3

Added by Gabriel DE PERTHUIS almost 15 years ago

Use text fields.

-String(length=\d\+, convert_unicode=True, assert_unicode=None),
+UnicodeText(),

git-svn-id: https://vigilo-dev.si.c-s.fr/svn@545 b22e2e97-25c9-44ff-b637-2e5ceca36478

     -- PostgreSQL database dump
     --
     SET client_encoding = 'SQL_ASCII';
     SET client_encoding = 'UTF8';
     SET standard_conforming_strings = off;
     SET check_function_bodies = false;
     SET client_min_messages = warning;
-...
         idhistory integer NOT NULL,
         type_action character varying(27) NOT NULL,
         idevent integer NOT NULL,
         value character varying(255),
         value text,
         text text,
         "timestamp" timestamp without time zone,
         username character varying(255)
         username text
     );
-...
     CREATE TABLE events (
         idevent integer NOT NULL,
         hostname character varying(100) NOT NULL,
         servicename character varying(100),
         hostname text NOT NULL,
         servicename text,
         severity integer NOT NULL,
         status character varying(12) DEFAULT 'None'::character varying NOT NULL,
         active boolean,
         "timestamp" timestamp without time zone,
         output text NOT NULL,
         timestamp_active timestamp without time zone,
         trouble_ticket character varying(20),
         trouble_ticket text,
         occurence integer,
         impact integer,
         rawstate character varying(8)
-...
     --
     CREATE TABLE graph (
         name character varying(100) NOT NULL,
         template character varying(2500) NOT NULL,
         vlabel character varying(2500) NOT NULL
         name text NOT NULL,
         template text NOT NULL,
         vlabel text NOT NULL
     );
-...
     --
     CREATE TABLE graphgroups (
         name character varying(100) NOT NULL,
         name text NOT NULL,
         parent integer
     );
-...
     --
     CREATE TABLE graphtogroups (
         graphname character varying(100) NOT NULL,
         groupname character varying(100) NOT NULL
         graphname text NOT NULL,
         groupname text NOT NULL
     );
-...
     --
     CREATE TABLE grouppermissions (
         groupname character varying(100) NOT NULL,
         groupname text NOT NULL,
         idpermission integer NOT NULL
     );
-...
     --
     CREATE TABLE groups (
         name character varying(100) NOT NULL,
         parent character varying(100)
         name text NOT NULL,
         parent text
     );
-...
     --
     CREATE TABLE host (
         name character varying(255) NOT NULL,
         checkhostcmd character varying(255) NOT NULL,
         community character varying(255) NOT NULL,
         fqhn character varying(255) NOT NULL,
         hosttpl character varying(255) NOT NULL,
         mainip character varying(255) NOT NULL,
         name text NOT NULL,
         checkhostcmd text NOT NULL,
         community text NOT NULL,
         fqhn text NOT NULL,
         hosttpl text NOT NULL,
         mainip text NOT NULL,
         port integer NOT NULL,
         snmpoidsperpdu integer,
         snmpversion character varying(255)
         snmpversion text
     );
-...
     --
     CREATE TABLE hostgroups (
         hostname character varying(100) NOT NULL,
         groupname character varying(100) NOT NULL
         hostname text NOT NULL,
         groupname text NOT NULL
     );
-...
     --
     CREATE TABLE perfdatasource (
         hostname character varying(100) NOT NULL,
         servicename character varying(100) NOT NULL,
         graphname character varying(100) NOT NULL,
         type character varying(100) NOT NULL,
         label character varying(255),
         hostname text NOT NULL,
         servicename text NOT NULL,
         graphname text NOT NULL,
         type text NOT NULL,
         label text,
         factor double precision NOT NULL
     );
-...
     --
     CREATE TABLE service (
         name character varying(255) NOT NULL,
         type character varying(255) NOT NULL,
         command character varying(255) NOT NULL
         name text NOT NULL,
         type text NOT NULL,
         command text NOT NULL
     );
-...
     --
     CREATE TABLE servicegroups (
         servicename character varying(100) NOT NULL,
         groupname character varying(100) NOT NULL
         servicename text NOT NULL,
         groupname text NOT NULL
     );
-...
     --
     CREATE TABLE servicehautniveau (
         servicename character varying(100) NOT NULL,
         servicename_dep character varying(100) NOT NULL
         servicename text NOT NULL,
         servicename_dep text NOT NULL
     );
-...
     --
     CREATE TABLE servicetopo (
         servicename character varying(100) NOT NULL,
         function character varying(50) NOT NULL
         servicename text NOT NULL,
         function text NOT NULL
     );
-...
     CREATE TABLE state (
         idstat integer NOT NULL,
         hostname character varying(100) NOT NULL,
         servicename character varying(100),
         ip character varying(40),
         hostname text NOT NULL,
         servicename text,
         ip text,
         "timestamp" timestamp without time zone,
         statename character varying(8) DEFAULT 'OK'::character varying NOT NULL,
         type character varying(4) DEFAULT 'SOFT'::character varying NOT NULL,
-...
     --
     CREATE TABLE version (
         name character varying(255) NOT NULL,
         version character varying(255) NOT NULL
         name text NOT NULL,
         version text NOT NULL
     );

Also available in: Unified diff

Project

General

Profile

Revision e0b69bf9