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.
#	Content
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	#
16	# Host: localhost Database : co600_10_db
17	#
18
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	#
34	# Dumping data for table 'cpu'
35	#
36
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	disk_free bigint(20) DEFAULT '0',
47	disk_total bigint(20) DEFAULT '0',
48	mount varchar(31),
49	label varchar(31),
50	KEY id (id)
51	);
52
53	#
54	# Dumping data for table 'disk'
55	#
56
57
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	server_data bigint(20) DEFAULT '0' NOT NULL,
69	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
87	#
88	# Dumping data for table 'packet'
89	#