Facebook
From me, 1 Month ago, written in Python.
Embed
Download Paste or View Raw
Hits: 200
  1.  create_drivers = """
  2.        CREATE Table IF NOT EXISTS DriverDB (
  3.            DriverID Integer PRIMARY KEY,
  4.            DriverName String,
  5.            DriverNumber String,
  6.            TeamName String,
  7.            Wins Integer
  8.        )"""
  9.     create_teams = """
  10.        CREATE Table IF NOT EXISTS TeamDB (
  11.            TeamID Integer PRIMARY KEY,
  12.            TeamName String,
  13.            NumOfDrivers Integer,
  14.            ChampionshipWins Integer
  15.        )"""
  16.     create_results = """
  17.        CREATE Table IF NOT EXISTS ResultsDB (
  18.            ResultID Integer PRIMARY KEY,
  19.            DriverName String,
  20.            DriverID Integer,
  21.            Event String,
  22.            Position Sring
  23.        )"""
  24.     create_users = """
  25.        CREATE Table IF NOT EXISTS UserDB (
  26.            UserID Integer PRIMARY KEY,
  27.            Username String,
  28.            HashedPassword String
  29.        )"""
  30.     create_sessions = """
  31.        CREATE Table IF NOT EXISTS SessionDB (
  32.            SessionID Integer PRIMARY KEY,
  33.            UserID Integer,
  34.            SessionHash String,
  35.            SessionExpire String
  36.        )"""