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!
#

#
# 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.4
Committed:	Tue Dec 5 10:49:30 2000 UTC (23 years, 9 months ago) by pjm2
Branch:	MAIN
Changes since 1.3:	+44 -51 lines
Log Message:	Now reflects our new design for the database structure. Also includes test tables.
#	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
8			#
9	pjm2	1.4	# This reflects our revised design for the structure
10			# of the database.
11	pjm2	1.1	#
12
13			# Host: localhost Database : co600_10_db
14
15			# --------------------------------------------------------
16			#
17	pjm2	1.4	# Table structure for table 'packet'
18	pjm2	1.1	#
19
20	pjm2	1.4	CREATE TABLE packet (
21			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
22			ip varchar(15) NOT NULL,
23			machine_name varchar(31) NOT NULL,
24			seq_no bigint(20) DEFAULT '0' NOT NULL,
25			sent_date bigint(20) DEFAULT '0' NOT NULL,
26			receipt_date bigint(20) DEFAULT '0' NOT NULL,
27			PRIMARY KEY (id),
28	pjm2	1.1	KEY id (id),
29	pjm2	1.4	UNIQUE id_2 (id)
30	pjm2	1.1	);
31
32	pjm2	1.4
33			# --------------------------------------------------------
34	pjm2	1.2	#
35	pjm2	1.4	# Table structure for table 'packet_test'
36	pjm2	1.2	#
37	pjm2	1.1
38	pjm2	1.4	CREATE TABLE packet_test (
39			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
40			ip varchar(15) NOT NULL,
41			machine_name varchar(31) NOT NULL,
42			seq_no bigint(20) DEFAULT '0' NOT NULL,
43			sent_date bigint(20) DEFAULT '0' NOT NULL,
44			receipt_date bigint(20) DEFAULT '0' NOT NULL,
45			PRIMARY KEY (id),
46			KEY id (id),
47			UNIQUE id_2 (id)
48			);
49
50	pjm2	1.1
51			# --------------------------------------------------------
52			#
53	pjm2	1.4	# Table structure for table 'parameter'
54	pjm2	1.1	#
55
56	pjm2	1.4	CREATE TABLE parameter (
57			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
58			packet_id bigint(20) DEFAULT '0' NOT NULL,
59			name varchar(63) NOT NULL,
60			value varchar(63) NOT NULL,
61			PRIMARY KEY (id),
62			KEY id (id),
63			UNIQUE id_2 (id)
64	pjm2	1.1	);
65
66
67			# --------------------------------------------------------
68			#
69	pjm2	1.4	# Table structure for table 'parameter_test'
70	pjm2	1.1	#
71
72	pjm2	1.4	CREATE TABLE parameter_test (
73	pjm2	1.1	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
74	pjm2	1.4	packet_id bigint(20) DEFAULT '0' NOT NULL,
75			name varchar(63) NOT NULL,
76			value varchar(63) NOT NULL,
77	pjm2	1.1	PRIMARY KEY (id),
78			KEY id (id),
79			UNIQUE id_2 (id)
80			);
81	pjm2	1.2
82	pjm2	1.4	# end!