server/db/empty.sql


#
# This is the full definition of our (initially empty)
# SQL database for i-scream logging.  This includes
# test tables which (unsuprisingly) are for testing!
#
# $Author:  $
# $Id:  $

#
# This reflects our revised design for the structure
# of the database.
#

# Host: localhost Database : co600_10_db

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

CREATE TABLE packet (
   id bigint(20) DEFAULT '0' NOT NULL auto_increment,
   ip varchar(15) NOT NULL,
   machine_name varchar(31) NOT NULL,
   seq_no bigint(20) DEFAULT '0' NOT NULL,
   sent_date bigint(20) DEFAULT '0' NOT NULL,
   receipt_date bigint(20) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);


# --------------------------------------------------------
#
# Table structure for table 'packet_test'
#

CREATE TABLE packet_test (
   id bigint(20) DEFAULT '0' NOT NULL auto_increment,
   ip varchar(15) NOT NULL,
   machine_name varchar(31) NOT NULL,
   seq_no bigint(20) DEFAULT '0' NOT NULL,
   sent_date bigint(20) DEFAULT '0' NOT NULL,
   receipt_date bigint(20) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);


# --------------------------------------------------------
#
# Table structure for table 'parameter'
#

CREATE TABLE parameter (
   id bigint(20) DEFAULT '0' NOT NULL auto_increment,
   packet_id bigint(20) DEFAULT '0' NOT NULL,
   name varchar(63) NOT NULL,
   value varchar(63) NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);


# --------------------------------------------------------
#
# Table structure for table 'parameter_test'
#

CREATE TABLE parameter_test (
   id bigint(20) DEFAULT '0' NOT NULL auto_increment,
   packet_id bigint(20) DEFAULT '0' NOT NULL,
   name varchar(63) NOT NULL,
   value varchar(63) NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);

# end!
Revision:	1.5
Committed:	Tue Dec 5 10:51:07 2000 UTC (23 years, 9 months ago) by pjm2
Branch:	MAIN
Changes since 1.4:	+2 -0 lines
Log Message:	Added CVS tags near the top of the document.
#	User	Rev	Content
1	pjm2	1.1
2			#
3			# This is the full definition of our (initially empty)
4	pjm2	1.4	# SQL database for i-scream logging. This includes
5			# test tables which (unsuprisingly) are for testing!
6	pjm2	1.1	#
7	pjm2	1.5	# $Author: $
8			# $Id: $
9	pjm2	1.1
10			#
11	pjm2	1.4	# This reflects our revised design for the structure
12			# of the database.
13	pjm2	1.1	#
14
15			# Host: localhost Database : co600_10_db
16
17			# --------------------------------------------------------
18			#
19	pjm2	1.4	# Table structure for table 'packet'
20	pjm2	1.1	#
21
22	pjm2	1.4	CREATE TABLE packet (
23			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
24			ip varchar(15) NOT NULL,
25			machine_name varchar(31) NOT NULL,
26			seq_no bigint(20) DEFAULT '0' NOT NULL,
27			sent_date bigint(20) DEFAULT '0' NOT NULL,
28			receipt_date bigint(20) DEFAULT '0' NOT NULL,
29			PRIMARY KEY (id),
30	pjm2	1.1	KEY id (id),
31	pjm2	1.4	UNIQUE id_2 (id)
32	pjm2	1.1	);
33
34	pjm2	1.4
35			# --------------------------------------------------------
36	pjm2	1.2	#
37	pjm2	1.4	# Table structure for table 'packet_test'
38	pjm2	1.2	#
39	pjm2	1.1
40	pjm2	1.4	CREATE TABLE packet_test (
41			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
42			ip varchar(15) NOT NULL,
43			machine_name varchar(31) NOT NULL,
44			seq_no bigint(20) DEFAULT '0' NOT NULL,
45			sent_date bigint(20) DEFAULT '0' NOT NULL,
46			receipt_date bigint(20) DEFAULT '0' NOT NULL,
47			PRIMARY KEY (id),
48			KEY id (id),
49			UNIQUE id_2 (id)
50			);
51
52	pjm2	1.1
53			# --------------------------------------------------------
54			#
55	pjm2	1.4	# Table structure for table 'parameter'
56	pjm2	1.1	#
57
58	pjm2	1.4	CREATE TABLE parameter (
59			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
60			packet_id bigint(20) DEFAULT '0' NOT NULL,
61			name varchar(63) NOT NULL,
62			value varchar(63) NOT NULL,
63			PRIMARY KEY (id),
64			KEY id (id),
65			UNIQUE id_2 (id)
66	pjm2	1.1	);
67
68
69			# --------------------------------------------------------
70			#
71	pjm2	1.4	# Table structure for table 'parameter_test'
72	pjm2	1.1	#
73
74	pjm2	1.4	CREATE TABLE parameter_test (
75	pjm2	1.1	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
76	pjm2	1.4	packet_id bigint(20) DEFAULT '0' NOT NULL,
77			name varchar(63) NOT NULL,
78			value varchar(63) NOT NULL,
79	pjm2	1.1	PRIMARY KEY (id),
80			KEY id (id),
81			UNIQUE id_2 (id)
82			);
83	pjm2	1.2
84	pjm2	1.4	# end!