[db] Introduce a VLR database here

This is not a proper VLR yet, specially the (subscriber_)id
used might not be the proper one in a real network.

1 files changed, 7 insertions, 0 deletions

diff --git a/src/db.c b/src/db.c
index 87b41bd85..f2f691e11 100644
--- a/src/db.c
+++ b/src/db.c
@@ -79,6 +79,13 @@ static char *create_stmts[] = {
 		"header NUMERIC, "
 		"text TEXT NOT NULL "
 		")",
+	"CREATE TABLE IF NOT EXISTS VLR ("
+		"id INTEGER PRIMARY KEY AUTOINCREMENT, "
+		"created TIMESTAMP NOT NULL, "
+		"updated TIMESTAMP NOT NULL, "
+		"subscriber_id NUMERIC UNIQUE NOT NULL, "
+		"last_bts NUMERIC NOT NULL "
+		")",
 };
 
 void db_error_func(dbi_conn conn, void* data) {