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 (23 years, 2 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.
#	Content
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	);