server/db/empty.sql


#
# This is the full definition of our (initially empty)
# SQL database for i-scream logging.  This reflects the
# changes made after our original design proved to be
# too large after a short amount of time.  Now, the
# original XML strings are stored in the database, keyed
# only by a few essential fields.
#
# $Author: pjm2 $
# $Id: empty.sql,v 1.6 2001/03/01 19:24:27 pjm2 Exp $
#
# Host: localhost Database : co600_10_db
#
#
# Table structure for table 'ipacket'
#

# Drop the table if it already exists.
DROP TABLE IF EXISTS ipacket;

# Create the table.
CREATE TABLE ipacket (
   id bigint(20) DEFAULT '0' NOT NULL auto_increment,
   ip varchar(15) NOT NULL,
   machine_name varchar(32) NOT NULL,
   sent_date bigint(20) DEFAULT '0' NOT NULL,
   receipt_date bigint(20) DEFAULT '0' NOT NULL,
   xml mediumtext NOT NULL,
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id)
);
Revision:	1.7
Committed:	Wed Mar 14 22:37:52 2001 UTC (23 years, 6 months ago) by tdb
Branch:	MAIN
CVS Tags:	HEAD
Changes since 1.6:	+1 -1 lines
State:	*FILE REMOVED*
Log Message:	Removed the add_table script, now replaced with a Makefile. The empty.sql file has been replaced by two seperate sql files.
#	User	Rev	Content
1	pjm2	1.1
2			#
3			# This is the full definition of our (initially empty)
4	pjm2	1.6	# SQL database for i-scream logging. This reflects the
5			# changes made after our original design proved to be
6			# too large after a short amount of time. Now, the
7			# original XML strings are stored in the database, keyed
8			# only by a few essential fields.
9	pjm2	1.1	#
10	pjm2	1.6	# $Author: pjm2 $
11	tdb	1.7	# $Id: empty.sql,v 1.6 2001/03/01 19:24:27 pjm2 Exp $
12	pjm2	1.1	#
13	pjm2	1.6	# Host: localhost Database : co600_10_db
14	pjm2	1.1	#
15			#
16	pjm2	1.6	# Table structure for table 'ipacket'
17	pjm2	1.1	#
18
19	pjm2	1.6	# Drop the table if it already exists.
20			DROP TABLE IF EXISTS ipacket;
21	pjm2	1.1
22	pjm2	1.6	# Create the table.
23			CREATE TABLE ipacket (
24	pjm2	1.4	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
25			ip varchar(15) NOT NULL,
26	pjm2	1.6	machine_name varchar(32) NOT NULL,
27	pjm2	1.4	sent_date bigint(20) DEFAULT '0' NOT NULL,
28			receipt_date bigint(20) DEFAULT '0' NOT NULL,
29	pjm2	1.6	xml mediumtext NOT NULL,
30	pjm2	1.4	PRIMARY KEY (id),
31			KEY id (id),
32			UNIQUE id_2 (id)
33			);