ContactBridge

Log | Files | Refs | README

db.sql (837B)

      1 CREATE TABLE IF NOT EXISTS messages (
      2     id INTEGER PRIMARY KEY AUTOINCREMENT,
      3     name TEXT NOT NULL,
      4     email TEXT NOT NULL,
      5     subject TEXT,
      6     content TEXT NOT NULL,
      7     timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
      8     relevance NUMERIC
      9 );
     10 
     11 CREATE TABLE IF NOT EXISTS spam (
     12     id INTEGER PRIMARY KEY AUTOINCREMENT,
     13     name TEXT NOT NULL,
     14     email TEXT NOT NULL,
     15     subject TEXT,
     16     content TEXT NOT NULL,
     17     timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
     18     relevance NUMERIC
     19 );
     20 
     21 CREATE TABLE IF NOT EXISTS users (
     22     id INTEGER PRIMARY KEY AUTOINCREMENT,
     23     username TEXT UNIQUE NOT NULL,
     24     email TEXT UNIQUE NOT NULL,
     25     hashed_password TEXT NOT NULL,
     26     salt TEXT NOT NULL,
     27     created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
     28     updated_at DATETIME,
     29     last_login DATETIME,
     30     is_admin BOOLEAN DEFAULT FALSE
     31 );