1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
USE test;
DROP TABLE IF EXISTS query_review;
CREATE TABLE query_review (
checksum CHAR(32) NOT NULL PRIMARY KEY, -- md5 of fingerprint
fingerprint TEXT NOT NULL,
sample TEXT NOT NULL,
first_seen DATETIME,
last_seen DATETIME,
reviewed_by VARCHAR(20),
reviewed_on DATETIME,
comments VARCHAR(100)
);
INSERT INTO query_review VALUES
('538CA093E701E0CBA20C29AF174CE545', 'select col from foo_tbl', 'SELECT col FROM foo_tbl', '2007-12-18 11:48:27', '2007-12-18 11:48:27', NULL, NULL, NULL),
('3E4FB43148C4B07CD4CD74934382A184', 'select col from bar_tbl', 'SELECT col FROM bar_tbl', '2005-12-19 16:56:31', '2006-12-20 11:48:57', NULL, NULL, NULL);
|
