CREATE TABLE IF NOT EXISTS nosql ( uid VARCHAR(120) PRIMARY KEY
                              , k VARCHAR(1000) NOT NULL
                              , v BLOB
                              , create_ts TIMESTAMP NOT NULL
                              , mod_ts TIMESTAMP NOT NULL
                              , UNIQUE(k)
                              , INDEX USING BTREE(k)
                              , INDEX USING BTREE(ts) );
DELIMITER //
DROP TRIGGER IF EXISTS `nosql_before_insert`//
CREATE TRIGGER `nosql_before_insert`
BEFORE INSERT ON `nosql`
FOR EACH ROW
BEGIN
    SET NEW.create_ts = NOW();
    SET NEW.mod_ts = NOW();
    SET NEW.uid = UUID();
END;//
DELIMITER;

DELIMITER //
DROP TRIGGER IF EXISTS `nosql_before_update`//
CREATE TRIGGER `nosql_before_update`
BEFORE UPDATE ON `nosql`
FOR EACH ROW
BEGIN
    SET NEW.mod_ts = NOW();
END;//
DELIMITER;