ViewVC Help
View File | Revision Log | Show Annotations | Revision Graph | Root Listing
root/i-scream/projects/cms/source/server/db/empty.sql
Revision: 1.5
Committed: Tue Dec 5 10:51:07 2000 UTC (23 years, 11 months ago) by pjm2
Branch: MAIN
Changes since 1.4: +2 -0 lines
Log Message:
Added CVS tags near the top of the document.

File Contents

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