server/db/empty.sql


#
# This is the full definition of our (initially empty)
# SQL database for i-scream logging.
#


#
# Please note that as most records logged are stored
# over more than one table, it will be ESSENTIAL to
# place a write lock on all affected tables, removing
# it when done.
#

#
# Host: localhost Database : co600_10_db
#

# --------------------------------------------------------
#
# Table structure for table 'cpu'
#

CREATE TABLE cpu (
   id bigint(20) DEFAULT '0' NOT NULL,
   cpu_no tinyint(4) DEFAULT '0' NOT NULL,
   cpu_load float(10,2) DEFAULT '0.00' NOT NULL,
   KEY id (id),
   KEY id_2 (id),
   KEY id_3 (id)
);

#
# Dumping data for table 'cpu'
#


# --------------------------------------------------------
#
# Table structure for table 'disk'
#

CREATE TABLE disk (
   id bigint(20) DEFAULT '0' NOT NULL,
   p tinyint(4) DEFAULT '0' NOT NULL,
   disk_free bigint(20) DEFAULT '0',
   disk_total bigint(20) DEFAULT '0',
   mount varchar(31),
   label varchar(31),
   KEY id (id)
);

#
# Dumping data for table 'disk'
#


# --------------------------------------------------------
#
# Table structure for table 'packet'
#

CREATE TABLE packet (
   id bigint(20) DEFAULT '0' NOT NULL auto_increment,
   ip varchar(15) NOT NULL,
   seq_no bigint(20) DEFAULT '0' NOT NULL,
   date bigint(20) DEFAULT '0' NOT NULL,
   server_data bigint(20) DEFAULT '0' NOT NULL,
   machine_name varchar(31) NOT NULL,
   mac_address varchar(31),
   os_name varchar(63),
   os_version varchar(31),
   load1 float(10,2),
   load2 float(10,2),
   load3 float(10,2),
   mem_free bigint(20),
   mem_total bigint(20),
   swap_free bigint(20),
   swap_total bigint(20),
   users varchar(255),
   full_xml text,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);

#
# Dumping data for table 'packet'
#
Revision:	1.3
Committed:	Wed Nov 29 10:51:37 2000 UTC (23 years, 11 months ago) by pjm2
Branch:	MAIN
Changes since 1.2:	+1 -0 lines
Log Message:	Added a required field in the packet table for storing the time at which a packet arrives at the database. This time will pressumably come from the Java database interface.
#	User	Rev	Content
1	pjm2	1.1
2			#
3			# This is the full definition of our (initially empty)
4			# SQL database for i-scream logging.
5			#
6
7
8			#
9			# Please note that as most records logged are stored
10			# over more than one table, it will be ESSENTIAL to
11			# place a write lock on all affected tables, removing
12			# it when done.
13			#
14
15	pjm2	1.2	#
16	pjm2	1.1	# Host: localhost Database : co600_10_db
17	pjm2	1.2	#
18	pjm2	1.1
19			# --------------------------------------------------------
20			#
21			# Table structure for table 'cpu'
22			#
23
24			CREATE TABLE cpu (
25			id bigint(20) DEFAULT '0' NOT NULL,
26			cpu_no tinyint(4) DEFAULT '0' NOT NULL,
27			cpu_load float(10,2) DEFAULT '0.00' NOT NULL,
28			KEY id (id),
29			KEY id_2 (id),
30			KEY id_3 (id)
31			);
32
33	pjm2	1.2	#
34			# Dumping data for table 'cpu'
35			#
36	pjm2	1.1
37
38			# --------------------------------------------------------
39			#
40			# Table structure for table 'disk'
41			#
42
43			CREATE TABLE disk (
44			id bigint(20) DEFAULT '0' NOT NULL,
45			p tinyint(4) DEFAULT '0' NOT NULL,
46	pjm2	1.2	disk_free bigint(20) DEFAULT '0',
47			disk_total bigint(20) DEFAULT '0',
48			mount varchar(31),
49			label varchar(31),
50	pjm2	1.1	KEY id (id)
51			);
52
53	pjm2	1.2	#
54			# Dumping data for table 'disk'
55			#
56
57	pjm2	1.1
58			# --------------------------------------------------------
59			#
60			# Table structure for table 'packet'
61			#
62
63			CREATE TABLE packet (
64			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
65			ip varchar(15) NOT NULL,
66			seq_no bigint(20) DEFAULT '0' NOT NULL,
67			date bigint(20) DEFAULT '0' NOT NULL,
68	pjm2	1.3	server_data bigint(20) DEFAULT '0' NOT NULL,
69	pjm2	1.1	machine_name varchar(31) NOT NULL,
70			mac_address varchar(31),
71			os_name varchar(63),
72			os_version varchar(31),
73			load1 float(10,2),
74			load2 float(10,2),
75			load3 float(10,2),
76			mem_free bigint(20),
77			mem_total bigint(20),
78			swap_free bigint(20),
79			swap_total bigint(20),
80			users varchar(255),
81			full_xml text,
82			PRIMARY KEY (id),
83			KEY id (id),
84			UNIQUE id_2 (id)
85			);
86	pjm2	1.2
87			#
88			# Dumping data for table 'packet'
89			#