tuiHoneyPot

front and back end of my TUI honeypot
Log | Files | Refs | README

database_schema.sql (709B)

      1 
      2 CREATE TABLE users (
      3   id INTEGER PRIMARY KEY AUTOINCREMENT,
      4   username varchar(255) NOT NULL,
      5   password varchar(255) NOT NULL,
      6   isAdmin INTEGER DEFAULT 0 NOT NULL,
      7   isLoggedIn INTEGER DEFAULT 0 NOT NULL,
      8   isBanned INTEGER DEFAULT 0 NOT NULL
      9 );
     10 
     11 CREATE TABLE challenges (
     12   id INTEGER PRIMARY KEY AUTOINCREMENT,
     13   name varchar(255) NOT NULL,
     14   flag varchar(255) NOT NULL,
     15   enabled INTEGER DEFAULT 1 NOT NULL
     16 );
     17 
     18 CREATE TABLE solves (
     19   userId INTEGER NOT NULL,
     20   challengeId INTEGER NOT NULL,
     21   PRIMARY KEY(userId, challengeId)
     22 );
     23 
     24 INSERT INTO challenges (name, flag)
     25 VALUES
     26 ('challenge1', 'CTF{X55_15_345Y}'),
     27 ('challenge2', 'CTF{5QL_1NJ3CT10N_15_B055}'),
     28 ('challenge3', 'CTF{1D0R_G1V35_Y0U_R1GH75}');