--- projects/cms/source/server/db/empty.sql	2000/12/05 10:49:30	1.4
+++ projects/cms/source/server/db/empty.sql	2001/03/01 19:24:27	1.6
@@ -1,82 +1,33 @@
 
 #
 # This is the full definition of our (initially empty)
-# SQL database for i-scream logging.  This includes
-# test tables which (unsuprisingly) are for testing!
+# 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 $
 #
-# 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 'ipacket'
 #
-# Table structure for table 'packet_test'
-#
 
-CREATE TABLE packet_test (
+# 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(31) NOT NULL,
-   seq_no bigint(20) DEFAULT '0' 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)
 );
-
-
-# --------------------------------------------------------
-#
-# 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!
