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! |