createdb-mysql.sql

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

#
# If you are installing Linux Monitor for the first time, you can simply
# direct this file to mysql as STDIN:
#
# $ mysql --user=root --password=<MySQL-root-password> < createdb-mysql.sql
#
# If you are upgrading from a previous version, you will need to comment
# out the the user creation steps below, as well as the schemas for any
# tables that already exist.

CONNECT mysql;

REPLACE INTO user (host, user, password)
    VALUES (
        'localhost',
        'linuxmond',
  -- IMPORTANT: Change this password!
        password('r4k8u7')
    );

REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
                 delete_priv, create_priv, drop_priv)
    VALUES (
        'localhost',
        'linuxmond',
        'linuxmond',
        'Y', 'Y', 'Y', 'Y',
        'Y', 'Y'
    );

FLUSH PRIVILEGES;

# MySQL 3.23.x appears to have "CREATE DATABASE IF NOT EXISTS" and
# "CREATE TABLE IF NOT EXISTS" which would be a nice way to handle
# reinstalls gracefully (someday).  For now, use mysql_drop.sql first
# to avoid CREATE errors.

CREATE DATABASE linuxmond;

CONNECT linuxmond;

CREATE TABLE log (
    nro 	   int AUTO_INCREMENT not null primary key,
    status 	   varchar(3) not null default 'ACT',
    time	   datetime not null,
    machine	   varchar(50) not null,
    Amachine	   varchar(50) not null,
    severity 	   varchar(9) not null,
    error 	   MEDIUMTEXT,
    comment	   MEDIUMTEXT,
    modby	   varchar(30),
    lastedited	   datetime,
    closetime	   datetime,
    category	   varchar(15),
    priority	   varchar(7),
    actionid	   varchar(5),
    action_status  varchar(5),
    Sstate 	   varchar(7),
    service 	   varchar(10),
    custID	   varchar(20),
    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)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON log TO linuxmond@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON Idata TO linuxmond@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON Iinfo TO linuxmond@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON customer TO linuxmond@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON users TO linuxmond@localhost;
GRANT SELECT, INSERT, UPDATE, DELETE ON Downhistory TO linuxmond@localhost;
FLUSH PRIVILEGES;

# Done!