tInitiate database on start - scoreboard - Interactive scoreboard for CTF-like games
(HTM) git clone git://git.z3bra.org/scoreboard.git
(DIR) Log
(DIR) Files
(DIR) Refs
---
(DIR) commit 8abd5edce6b5776b4288254ea3f19fd4d7406c18
(DIR) parent 7689f88f24595ca9afe38cecab41bfc4e3c29473
(HTM) Author: Willy Goiffon <contact@z3bra.org>
Date: Mon, 5 Dec 2022 14:09:59 +0100
Initiate database on start
Diffstat:
M db.go | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
---
(DIR) diff --git a/db.go b/db.go
t@@ -22,7 +22,6 @@ import (
const (
// DB queries
DB_CREATE string = `
- DROP TABLE score;
CREATE TABLE IF NOT EXISTS score(id INTEGER PRIMARY KEY, name TEXT, token TEXT, flag INT, score INT, ts INT);
`
DB_FILL string = `
t@@ -34,7 +33,8 @@ const (
INSERT INTO score(name,token,flag,score,ts) VALUES ('UKN', 'token4', 2, 200, 200);
INSERT INTO score(name,token,flag,score,ts) VALUES ('JFK', 'token5', 3, 600, 200);
INSERT INTO score(name,token,flag,score,ts) VALUES ('NTM', 'token6', 4, 800, 100);
- INSERT INTO score(name,token,flag,score,ts) VALUES ('BOB', 'token7', 1, 100, 25);
+ INSERT INTO score(name,token,flag,score,ts) VALUES ('BOB', 'token7', 1, 200, 25);
+ INSERT INTO score(name,token,flag,score,ts) VALUES ('AAA', 'token8', 1, 100, 13);
`
)
t@@ -53,7 +53,7 @@ func (a *Application) db_init(file string) error {
if err != nil {
return err
}
- /*
+ ///*
_, err = a.db.Exec(DB_FILL)
if err != nil {
panic(err)