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
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
DROP DATABASE IF EXISTS test;
CREATE DATABASE test;
USE test;
CREATE TABLE `test`.`t1` (
id INT AUTO_INCREMENT PRIMARY KEY,
f2 VARCHAR(25) NOT NULL,
f3 INT,
f4 timestamp
) Engine=RocksDB;
INSERT INTO `t1` VALUES
(1,'Henry Stanley',583532949,'2017-02-07 12:12:54'),
(2,'Kathy Franklin',960400044,'2017-10-10 18:06:57'),
(3,'Mr. Dr. Anthony Howard',174461349,'2017-11-16 06:06:11'),
(4,'Janice Foster I II III IV',443038240,'2016-12-07 13:01:35'),
(5,'Sharon Daniels',169641627,'2017-01-09 15:03:40'),
(6,'Alice Tucker',1012579941,'2017-06-16 06:06:28'),
(7,'Theresa Allen',894954174,'2017-07-17 10:10:00'),
(8,'Elizabeth Fowler',1938641144,'2017-03-27 14:02:24'),
(9,'Rebecca Lee',1279764421,'2017-03-06 10:10:08'),
(10,'Anne Kennedy I II III IV ',159121576,'2017-08-15 09:09:16'),
(11,'Christina Arnold',1113045364,'2017-08-18 19:07:02'),
(12,'Mrs. Ms. Miss Cheryl Garc',278843827,'2017-07-23 00:12:00'),
(13,'Louis Harvey',161885407,'2016-12-23 08:08:21'),
(14,'Julie Bishop',1592388661,'2016-11-28 01:01:03'),
(15,'Todd Ramirez',362850921,'2017-02-20 04:04:26'),
(16,'Gary Kennedy',1795393312,'2017-03-25 23:11:43'),
(17,'Roger Hart',1400528216,'2017-04-24 10:10:17'),
(18,'Lois Henry',1104948011,'2017-08-29 10:10:25'),
(19,'Debra Stanley',1103860241,'2017-08-30 16:04:47'),
(20,'Amy Cook',2001779440,'2017-03-04 14:02:36'),
(21,'Rose Vasquez I II III IV ',1025398331,'2017-01-15 05:05:04'),
(22,'David Flores',540200823,'2017-05-13 09:09:48'),
(23,'Brian Crawford',1617053422,'2017-10-14 07:07:47'),
(24,'Kelly Freeman',1361426130,'2017-04-01 04:04:17'),
(25,'Sarah Palmer',1139691470,'2017-10-23 18:06:49'),
(26,'Dorothy Shaw',900404079,'2017-10-17 10:10:01'),
(27,'Kelly Wagner',1982163577,'2016-12-01 04:04:37'),
(28,'Diane Hall',369511081,'2017-07-28 01:01:18'),
(29,'Mr. Dr. Harold Dean',811105176,'2017-11-19 13:01:31'),
(30,'Edward Ferguson',1914574524,'2017-10-14 03:03:49'),
(31,'Dorothy Arnold',1899568350,'2017-08-29 14:02:41'),
(32,'Judith Cox',17691206,'2016-12-11 04:04:20'),
(33,'Elizabeth Johnson',1685990258,'2017-06-22 20:08:50'),
(34,'Carolyn Edwards',1168962838,'2017-04-08 18:06:00'),
(35,'Ruby Chapman',1688473058,'2017-04-16 04:04:24'),
(36,'Amanda Welch I II III IV ',193262041,'2017-04-13 14:02:18'),
(37,'Larry Porter Jr. Sr. I II',75666836,'2017-04-16 16:04:09'),
(38,'Kevin George',887309316,'2017-06-13 12:12:47'),
(39,'Maria Brown',1751136810,'2017-06-08 17:05:37'),
(40,'Tammy Ramos',1588294845,'2017-07-22 11:11:24'),
(41,'Denise Ellis',1545291805,'2017-08-20 10:10:45'),
(42,'Kelly Williamson',861653714,'2017-10-10 03:03:38'),
(43,'Carolyn Patterson',2114635136,'2017-07-03 16:04:20'),
(44,'Amanda Sullivan',505888065,'2017-04-09 18:06:10'),
(45,'Scott White',2053562943,'2017-04-16 02:02:03'),
(46,'Mrs. Ms. Miss Janet Richa',273248685,'2017-01-23 14:02:17'),
(47,'Henry Davis Jr. Sr. I II ',1807469649,'2017-07-20 22:10:52'),
(48,'Sandra Powell',425895561,'2017-05-16 06:06:02'),
(49,'Roger Morrison',519405919,'2017-07-25 20:08:28'),
(50,'Henry Murray Jr. Sr. I II',2095628347,'2017-09-09 02:02:44'),
(51,'Bonnie Wood',632299815,'2017-01-21 09:09:43'),
(52,'Kevin Riley',1337811955,'2017-09-01 00:12:01'),
(53,'Cheryl Lewis',1183760979,'2017-07-10 04:04:41'),
(54,'Craig Oliver',415886351,'2017-08-27 14:02:11'),
(55,'Peter Elliott',1441905738,'2017-01-25 16:04:06'),
(56,'Sarah Henderson',1398808230,'2017-09-14 18:06:22'),
(57,'Angela Olson',73529235,'2017-02-11 19:07:04'),
(58,'Martin Hunt',828130434,'2017-04-11 23:11:01'),
(59,'Ann Grant I II III IV V M',960124334,'2017-08-01 22:10:52'),
(60,'Joe Hudson',1729961064,'2017-10-10 13:01:00'),
(61,'Mrs. Ms. Miss Shirley Rod',2124381773,'2017-05-27 20:08:23'),
(62,'Stephen Long',374271961,'2017-09-08 12:12:02'),
(63,'Gerald Butler',165044727,'2017-10-23 00:12:06'),
(64,'Tammy Hernandez',805042592,'2016-12-17 06:06:23'),
(65,'Marie Armstrong I II III ',342177736,'2017-03-16 01:01:52'),
(66,'Michelle Perry',1879564383,'2017-09-28 15:03:25'),
(67,'Albert Stevens Jr. Sr. I ',294854430,'2016-11-30 00:12:59'),
(68,'Jason Tucker',725774075,'2016-11-28 00:12:17'),
(69,'Philip Parker',482904842,'2017-08-13 06:06:22'),
(70,'Heather Stone',651794709,'2017-02-27 18:06:37'),
(71,'Mr. Dr. Keith Stone',581063673,'2017-10-31 21:09:54'),
(72,'Joseph Hicks',776452583,'2017-07-17 20:08:21'),
(73,'Judith Martinez',2056678762,'2017-04-01 06:06:00'),
(74,'Roger Fields',1025075771,'2017-09-11 03:03:03'),
(75,'Russell Alvarez',2058724771,'2017-08-28 21:09:05'),
(76,'Judith Shaw',439257644,'2016-12-06 09:09:25'),
(77,'Louis Johnston Jr. Sr. I ',1887594525,'2017-06-24 19:07:06'),
(78,'Richard Butler',39227130,'2017-07-05 16:04:22'),
(79,'Wayne Watkins Jr. Sr. I I',503442129,'2017-01-24 14:02:10'),
(80,'Patricia Stewart',286838439,'2017-11-16 06:06:24'),
(81,'Kelly Oliver',1069073876,'2017-02-24 02:02:17'),
(82,'Mrs. Ms. Miss Phyllis Fre',1053443872,'2017-05-31 04:04:19'),
(83,'Wanda Spencer',1685359738,'2017-09-27 08:08:33'),
(84,'William Harris Jr. Sr. I ',1117708440,'2017-07-24 03:03:22'),
(85,'Eugene Sanders',1605154172,'2017-09-29 13:01:06'),
(86,'Peter Sims Jr. Sr. I II I',213620615,'2017-09-06 18:06:19'),
(87,'Melissa Riley',923001454,'2017-09-30 10:10:47'),
(88,'Mr. Dr. Jonathan Lee',137651089,'2017-07-29 07:07:59'),
(89,'Donald Burke',1268762182,'2017-08-30 15:03:35'),
(90,'Adam Long',971993341,'2017-10-27 23:11:26'),
(91,'Theresa Taylor',20073496,'2017-07-26 21:09:23'),
(92,'Heather Matthews',910759132,'2017-02-19 19:07:58'),
(93,'Jerry King Jr. Sr. I II I',2055915105,'2017-06-25 15:03:29'),
(94,'Sara Hawkins',1178751968,'2017-03-29 22:10:59'),
(95,'Ruby Long',998718314,'2017-07-29 16:04:18'),
(96,'Billy Cooper',190019474,'2017-02-04 12:12:41'),
(97,'Jose Wheeler',1922987914,'2017-11-02 21:09:08'),
(98,'Clarence Weaver',364986423,'2017-09-10 00:12:31'),
(99,'Gary Riley',524227310,'2017-09-03 16:04:16'),
(100,'Melissa Parker',1833910235,'2017-10-03 05:05:26');
DROP TABLE IF EXISTS test.checksums;
CREATE TABLE test.checksums (
db CHAR(64) NOT NULL,
tbl CHAR(64) NOT NULL,
chunk INT NOT NULL,
chunk_time FLOAT NULL,
chunk_index VARCHAR(200) NULL,
lower_boundary TEXT NULL,
upper_boundary TEXT NULL,
this_crc CHAR(40) NOT NULL,
this_cnt INT NOT NULL,
master_crc CHAR(40) NULL,
master_cnt INT NULL,
ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (db, tbl, chunk),
INDEX ts_db_tbl (ts, db, tbl)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO test.checksums VALUES('test', 't1', 1,0,'','','100', '', 0,'',0,NOW());
|
