createdb-pgsql.sql

Linux内核监控工具。 Linux内核监控工具。 Linux内核监控工具。

CREATE DATABASE linuxmond;
\c linuxmond

CREATE TABLE log ( nro serial not null,
	status varchar(3) not null default 'ACT',
	time timestamp not null default 'now',
	machine varchar(50) not null,
	Amachine varchar(50) not null,
	severity varchar(9) not null,
	error varchar(300) not null,
	comment varchar(1024),
	modby varchar(30),
	lastedited timestamp,
	closetime timestamp,
	category varchar(15),
	priority varchar(7),
	actionid varchar(5),
	action_status varchar(5),
	Sstate varchar(7),
	service varchar(10),
        customer varchar(60),
        prize varchar(16),
        billed varchar(6)
);

CREATE TABLE Downhistory ( Amachine varchar(50),
        service varchar(10),
	down timestamp not null default 'now',
	up timestamp
);

CREATE TABLE Idata ( machine varchar(50),
	data varchar(255)
);

CREATE TABLE Iinfo ( machine varchar(50),
        time varchar(30)
);

CREATE TABLE customer ( custID varchar(20),
        company varchar(60),
        contact1 varchar(80),
        contact1email varchar(80),
        contact2 varchar(80),
        contact2email varchar(80),
        phone varchar(20),
        fax varchar(20),
        address varchar(100)
);

CREATE TABLE users ( name varchar(80),
        nick varchar(30),
        phone varchar(20),
        email varchar(80),
        login varchar(30),
        passwd varchar(40),
        grants varchar(30),
        status varchar(10),
        rftime varchar(5),
        statusf varchar(50),
        machinef varchar(100),
        nrof varchar(20)
);

create user linuxmond with password 'r4k8u7';

grant select,insert,update,delete on log to linuxmond;
grant select,insert,update,delete on log_nro_seq to linuxmond;
grant select,insert,update,delete on Idata to linuxmond;
grant select,insert,update,delete on Iinfo to linuxmond;
grant select,insert,update,delete on customer to linuxmond;
grant select,insert,update,delete on users to linuxmond;
grant select,insert,update,delete on Downhistory to linuxmond;