Advertisement
Darkolius

Untitled

May 13th, 2020
308
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.88 KB | None | 0 0
  1. c.EXECUTE("""CREATE TABLE IF NOT EXISTS gk_skills (
  2.                   id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  3.                   ref integer NOT NULL,
  4.                   pos integer NOT NULL,
  5.                   int integer NOT NULL,
  6.                   blc integer NOT NULL,
  7.                   org integer NOT NULL,
  8.                   goalkeeper_id integer NOT NULL,
  9.                   FOREIGN KEY (goalkeeper_id) REFERENCES goalkeeper (id)
  10.                   )""")
  11.  
  12.         c.EXECUTE("""CREATE TABLE IF NOT EXISTS train (
  13.                           id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  14.                           first_skill integer NOT NULL,
  15.                           second_skill integer NOT NULL,
  16.                           gk_skills integer NOT NULL,
  17.                           FOREIGN KEY (gk_skills) REFERENCES gk_skills (id)
  18.                           )""")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement