-
Notifications
You must be signed in to change notification settings - Fork 0
/
osmessage.sql
111 lines (97 loc) · 3.36 KB
/
osmessage.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50549
Source Host : localhost:3306
Source Database : osmessage
Target Server Type : MYSQL
Target Server Version : 50549
File Encoding : 65001
Date: 2019-01-30 17:30:16
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `buffer1`
-- ----------------------------
DROP TABLE IF EXISTS `buffer1`;
CREATE TABLE `buffer1` (
`buffer1_id` int(20) NOT NULL AUTO_INCREMENT,
`Message` varchar(200) NOT NULL,
`Data` varchar(200) NOT NULL,
`ContentNum` int(100) DEFAULT NULL,
`FreeSpaceNum` int(100) DEFAULT NULL,
PRIMARY KEY (`buffer1_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14426 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of buffer1
-- ----------------------------
-- ----------------------------
-- Table structure for `buffer2`
-- ----------------------------
DROP TABLE IF EXISTS `buffer2`;
CREATE TABLE `buffer2` (
`buffer2_id` int(20) NOT NULL AUTO_INCREMENT,
`Message` varchar(200) NOT NULL,
`Data` varchar(200) NOT NULL,
`ContentNum` int(100) DEFAULT NULL,
`FreeSpaceNum` int(100) DEFAULT NULL,
PRIMARY KEY (`buffer2_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8354 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of buffer2
-- ----------------------------
-- ----------------------------
-- Table structure for `buffer3`
-- ----------------------------
DROP TABLE IF EXISTS `buffer3`;
CREATE TABLE `buffer3` (
`buffer3_id` int(20) NOT NULL AUTO_INCREMENT,
`Message` varchar(200) NOT NULL,
`Data` varchar(200) NOT NULL,
`ContentNum` int(100) DEFAULT NULL,
`FreeSpaceNum` int(100) DEFAULT NULL,
PRIMARY KEY (`buffer3_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4175 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of buffer3
-- ----------------------------
-- ----------------------------
-- Table structure for `param`
-- ----------------------------
DROP TABLE IF EXISTS `param`;
CREATE TABLE `param` (
`p_id` int(10) NOT NULL AUTO_INCREMENT,
`buffer1Size` int(20) NOT NULL,
`buffer2Size` int(20) NOT NULL,
`buffer3Size` int(20) NOT NULL,
`putBuffer1Num` int(20) NOT NULL,
`moveBuffer2Num` int(20) NOT NULL,
`moveBuffer3Num` int(20) NOT NULL,
`getBuffer2Num` int(20) NOT NULL,
`getBuffer3Num` int(20) NOT NULL,
`putSpeed` int(50) NOT NULL,
`moveSpeed` int(50) NOT NULL,
`getSpeed` int(50) NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of param
-- ----------------------------
INSERT INTO `param` VALUES ('1', '4', '3', '3', '3', '2', '2', '3', '3', '20', '20', '20');
-- ----------------------------
-- Table structure for `result`
-- ----------------------------
DROP TABLE IF EXISTS `result`;
CREATE TABLE `result` (
`rs_id` int(100) NOT NULL AUTO_INCREMENT,
`Runtime` varchar(200) NOT NULL,
`BufferDataNum` int(200) NOT NULL,
`putInBufferNum` int(200) NOT NULL,
`getOutBufferNum` int(200) NOT NULL,
`AvgBufferNum` int(100) NOT NULL,
PRIMARY KEY (`rs_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of result
-- ----------------------------
INSERT INTO `result` VALUES ('1', '100057', '4', '34', '30', '1');