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, 8 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.
#	Content
1
2	#
3	# This is the full definition of our (initially empty)
4	# 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	#
10	# $Author: pjm2 $
11	# $Id: empty.sql,v 1.6 2001/03/01 19:24:27 pjm2 Exp $
12	#
13	# Host: localhost Database : co600_10_db
14	#
15	#
16	# Table structure for table 'ipacket'
17	#
18
19	# Drop the table if it already exists.
20	DROP TABLE IF EXISTS ipacket;
21
22	# Create the table.
23	CREATE TABLE ipacket (
24	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
25	ip varchar(15) NOT NULL,
26	machine_name varchar(32) NOT NULL,
27	sent_date bigint(20) DEFAULT '0' NOT NULL,
28	receipt_date bigint(20) DEFAULT '0' NOT NULL,
29	xml mediumtext NOT NULL,
30	PRIMARY KEY (id),
31	KEY id (id),
32	UNIQUE id_2 (id)
33	);