1 --------------------------------------------------------------------------------
5 -- Description: Database definition for fsmon
6 -- Author: Andrew@ClearSCM.com
7 -- Created: Thu Dec 11 13:43:06 MST 2008
11 -- Copyright (c) 2008, General Dynamics, all rights reserved
13 --------------------------------------------------------------------------------
14 -- Warning: The following line will delete the old database!
15 drop database if exists fsmon;
17 -- Create a new database
18 create database fsmon;
20 -- Now let's focus on this new database
23 -- system: Contains information about the various machines that we are
24 -- monitoring file systems on
27 name varchar(255) not null,
47 -- filesystems: Describes the filesystems for a system
48 create table filesystems (
49 sysname varchar(255) not null,
50 mount varchar(255) not null,
53 primary key (sysname, mount)
56 -- fs: Contains a snapshot reading of a filesystem at a given date and time
58 sysname varchar(255) not null,
59 mount varchar(255) not null,
60 timestamp datetime not null,
66 primary key (sysname, mount, timestamp),
67 foreign key (sysname, mount)
68 references filesystems (sysname, mount)
76 identified by "fsmonadm" with grant option;
81 identified by "fsmon";