ViewVC Help

View File | Revision Log | Show Annotations | Revision Graph | Root Listing

root/i-scream/projects/cms/source/server/db/empty.sql

Comparing projects/cms/source/server/db/empty.sql (file contents):
Revision 1.4 by pjm2, Tue Dec 5 10:49:30 2000 UTC vs.
Revision 1.6 by pjm2, Thu Mar 1 19:24:27 2001 UTC

#	Line 1 | Line 1
1
2		#
3		# This is the full definition of our (initially empty)
4	<	# SQL database for i-scream logging.  This includes
5	<	# test tables which (unsuprisingly) are for testing!
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	<
10	>	# $Author$
11	>	# $Id$
12		#
9	–	# This reflects our revised design for the structure
10	–	# of the database.
11	–	#
12	–
13		# Host: localhost Database : co600_10_db
14	–
15	–	# --------------------------------------------------------
14		#
17	–	# Table structure for table 'packet'
15		#
16	<
20	<	CREATE TABLE packet (
21	<	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
22	<	ip varchar(15) NOT NULL,
23	<	machine_name varchar(31) NOT NULL,
24	<	seq_no bigint(20) DEFAULT '0' NOT NULL,
25	<	sent_date bigint(20) DEFAULT '0' NOT NULL,
26	<	receipt_date bigint(20) DEFAULT '0' NOT NULL,
27	<	PRIMARY KEY (id),
28	<	KEY id (id),
29	<	UNIQUE id_2 (id)
30	<	);
31	<
32	<
33	<	# --------------------------------------------------------
16	>	# Table structure for table 'ipacket'
17		#
35	–	# Table structure for table 'packet_test'
36	–	#
18
19	<	CREATE TABLE packet_test (
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(31) NOT NULL,
42	<	seq_no bigint(20) DEFAULT '0' 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		);
49	–
50	–
51	–	# --------------------------------------------------------
52	–	#
53	–	# Table structure for table 'parameter'
54	–	#
55	–
56	–	CREATE TABLE parameter (
57	–	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
58	–	packet_id bigint(20) DEFAULT '0' NOT NULL,
59	–	name varchar(63) NOT NULL,
60	–	value varchar(63) NOT NULL,
61	–	PRIMARY KEY (id),
62	–	KEY id (id),
63	–	UNIQUE id_2 (id)
64	–	);
65	–
66	–
67	–	# --------------------------------------------------------
68	–	#
69	–	# Table structure for table 'parameter_test'
70	–	#
71	–
72	–	CREATE TABLE parameter_test (
73	–	id bigint(20) DEFAULT '0' NOT NULL auto_increment,
74	–	packet_id bigint(20) DEFAULT '0' NOT NULL,
75	–	name varchar(63) NOT NULL,
76	–	value varchar(63) NOT NULL,
77	–	PRIMARY KEY (id),
78	–	KEY id (id),
79	–	UNIQUE id_2 (id)
80	–	);
81	–
82	–	# end!

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines