bambi7-service-fireworx

ESDSA-signed firework A/D service for BambiCTF7 in 2022
git clone https://git.sinitax.com/sinitax/bambi7-service-fireworx
Log | Files | Refs | README | LICENSE | sfeed.txt

init.sql (593B)

      1CREATE TABLE IF NOT EXISTS users(
      2	id INTEGER PRIMARY KEY AUTOINCREMENT,
      3	delet INTEGER DEFAULT NULL,
      4	name TEXT UNIQUE,
      5	p TEXT,
      6	q TEXT,
      7	g TEXT,
      8	x TEXT,
      9	y TEXT
     10);
     11
     12CREATE TABLE IF NOT EXISTS events(
     13	id INTEGER PRIMARY KEY AUTOINCREMENT,
     14	userid INTEGER SECONDARY KEY,
     15	time TEXT,
     16	wish TEXT,
     17	x FLOAT,
     18	y FLOAT,
     19	FOREIGN KEY(userid) REFERENCES users(id) ON DELETE CASCADE
     20);
     21
     22CREATE INDEX IF NOT EXISTS users_name ON users(name);
     23
     24CREATE TRIGGER IF NOT EXISTS users_delete_by
     25AFTER INSERT ON users
     26BEGIN
     27    UPDATE users SET delet = strftime("%s", "now") + 780 WHERE delet IS NULL;
     28END;