server/db/ipacket.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$
# $Id$
#
# Host: localhost Database : co600_10_db
#
#
# Table structure for table '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.1
Committed:	Wed Mar 14 22:39:32 2001 UTC (24 years, 7 months ago) by tdb
Branch:	MAIN
CVS Tags:	PROJECT_COMPLETION, HEAD
Branch point for:	SERVER_PIRCBOT
Log Message:	SQL command files. ipacket.sql contains the structure for the ipacket table, and drop.sql can be used to drop an existing table with the same name.
#	User	Rev	Content
1	tdb	1.1	#
2			# This is the full definition of our (initially empty)
3			# SQL database for i-scream logging. This reflects the
4			# changes made after our original design proved to be
5			# too large after a short amount of time. Now, the
6			# original XML strings are stored in the database, keyed
7			# only by a few essential fields.
8			#
9			# $Author$
10			# $Id$
11			#
12			# Host: localhost Database : co600_10_db
13			#
14			#
15			# Table structure for table 'ipacket'
16			#
17
18			# Create the table.
19			CREATE TABLE ipacket (
20			id bigint(20) DEFAULT '0' NOT NULL auto_increment,
21			ip varchar(15) NOT NULL,
22			machine_name varchar(32) NOT NULL,
23			sent_date bigint(20) DEFAULT '0' NOT NULL,
24			receipt_date bigint(20) DEFAULT '0' NOT NULL,
25			xml mediumtext NOT NULL,
26			PRIMARY KEY (id),
27			KEY id (id),
28			UNIQUE id_2 (id)
29			);