before.sql

CREATE TABLE "warehouse" (
            id INTEGER NOT NULL,
            item TEXT NOT NULL,
            PRIMARY KEY (id))
USING memtx DISTRIBUTED BY (id)
OPTION (TIMEOUT = 3.0);
CREATE USER "randy" WITH PASSWORD 'P@ssw0rd' USING md5 OPTION (TIMEOUT = 3.0);
GRANT WRITE ON TABLE "warehouse" to "randy";
GRANT READ ON TABLE "warehouse" to "randy";