2
Sample grant for SQLite
4
CREATE ROLE queue LOGIN
6
NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
11
-- Table structure for table `queue`
16
queue_id INTEGER PRIMARY KEY AUTOINCREMENT,
17
queue_name VARCHAR(100) NOT NULL,
18
timeout INTEGER NOT NULL DEFAULT 30
24
-- --------------------------------------------------------
26
-- Table structure for table `message`
31
message_id INTEGER PRIMARY KEY AUTOINCREMENT,
32
queue_id INTEGER PRIMARY KEY,
34
body VARCHAR(8192) NOT NULL,
35
md5 CHAR(32) NOT NULL,
38
FOREIGN KEY (queue_id) REFERENCES queue(queue_id)