Skip to content
File

Blob: kv/sqlite3/migrations/0001-initial-schema.sql

sql27 lines
1CREATE TABLE IF NOT EXISTS `key_trackers` (
2 `key` blob,
3 `hash` integer,
4 `flags` integer,
5 PRIMARY KEY (`key`)
6);
7 
8CREATE INDEX IF NOT EXISTS `idx_hash` ON `key_trackers` (`hash` ASC);
9 
10CREATE TABLE IF NOT EXISTS `simple_entries` (
11 `key` blob,
12 `value` blob,
13 PRIMARY KEY (`key`)
14);
15 
16CREATE TABLE IF NOT EXISTS `prefix_entries` (
17 `prefix` blob,
18 `child` blob,
19 PRIMARY KEY (`prefix`, `child`)
20);
21 
22CREATE TABLE IF NOT EXISTS `lease_entries` (
23 `owner` blob,
24 `token` integer,
25 PRIMARY KEY (`owner`)
26);