text: DROP TABLE IF EXISTS users;
  
  CREATE TABLE users (
  	id INTEGER GENERATED BY DEFAULT AS IDENTITY,
  	username VARCHAR NOT NULL,
  	pw VARCHAR NOT NULL,
  	super INT NOT NULL DEFAULT 0,
  	PRIMARY KEY (id)
    );
  
  CREATE UNIQUE INDEX users_username ON users (username);
  
  INSERT INTO users (username, pw) VALUES ('jjolie', 'PBKDF2$sha256$901$pN94c3+KCcNvIV1v$LWEyzG6v/gtvTrjx551sNcWWfwIZKAg0');
  INSERT INTO users (username, pw) VALUES ('a', 'PBKDF2$sha256$901$XPkOwNbd05p5XsUn$1uPtR6hMKBedWE44nqdVg+2NPKvyGst8');
  INSERT INTO users (username, pw, super)
  	VALUES ('su1',
  	'PBKDF2$sha256$901$chEZ4HcSmKtlV0kf$yRh2N62uq6cHoAB6FIrxIN2iihYqNIJp',
  	1);
  INSERT INTO users (username, pw, super)
  	VALUES ('S1',
  	'PBKDF2$sha256$901$sdMgoJD3GaRlTF7y$D7Krjx14Wk745bH36KBzVwHwRQg0a+z6',
  	1);
  INSERT INTO users (username, pw, super)
  	VALUES ('m1',
  	'PBKDF2$sha256$2$NLu+mJ3GwOpS7JLk$eITPuWG/+WMf6F3bhsT5YlYPY6MmJHvM',
  	0);
  -- PSK
  INSERT INTO users (username, pw, super)
  	VALUES ('ps1',
  	'deaddead',
  	0);
  
  DROP TABLE IF EXISTS acls;
  
  CREATE TABLE acls (
  	id INTEGER GENERATED BY DEFAULT AS IDENTITY,
  	username VARCHAR NOT NULL,
  	topic VARCHAR NOT NULL,
  	rw INTEGER NOT NULL DEFAULT 1,	-- 1: read-only, 2: read-write
  	PRIMARY KEY (id)
  	);
  CREATE UNIQUE INDEX acls_user_topic ON acls (username, topic);
  
  INSERT INTO acls (username, topic, rw) VALUES ('jjolie', 'loc/jjolie', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('jjolie', 'loc/ro', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('jjolie', 'loc/rw', 2);
  INSERT INTO acls (username, topic, rw) VALUES ('jjolie', '$SYS/something', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('a', 'loc/test/#', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('a', '$SYS/broker/log/+', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('su1', 'mega/secret', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('nop', 'mega/secret', 1);
  
  INSERT INTO acls (username, topic, rw) VALUES ('jog', 'loc/#', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('m1', 'loc/#', 1);
  
  INSERT INTO acls (username, topic, rw) VALUES ('ps1', 'x', 1);
  INSERT INTO acls (username, topic, rw) VALUES ('ps1', 'blabla/%c/priv/#', 1);
  
  