Database Setup - romnempire/dice2m33tU GitHub Wiki

  • a6_Session:

  • url VARCHAR(255)

  • PRIMARY KEY (url)

  • a6_Board (includes toy box):

  • bid INT

  • session VARCHAR(255)

  • background VARCHAR(255)

  • length INT

  • width INT

  • PRIMARY KEY (bid)

  • FOREIGN KEY (session) REFERENCES a6_Session(url) ON DELETE CASCADE

  • a6_User:

  • name VARCHAR(255)

  • session VARCHAR(255)

  • PRIMARY KEY (name)

  • FOREIGN KEY (session) REFERENCES a6_Session(url) ON DELETE CASCADE

  • a6_Piece:

  • image VARCHAR(255)

  • session VARCHAR(255)

  • board INT

  • locationX INT (check constraint?)

  • locationY INT (check constraint?)

  • sizeX INT (check constraint?)

  • sizeY INT (check constraint?)

  • PRIMARY KEY (image)

  • FOREIGN KEY (session) REFERENCES a6_Session(url) ON DELETE CASCADE

  • FOREIGN KEY (board) REFERENCES a6_Board(bid) ON DELETE CASCADE

  • a6_Message:

  • mid INT AUTO_INCREMENT

  • session VARCHAR(255) (check constraint?)

  • timestamp TIMESTAMP

  • text TEXT

  • user VARCHAR(255) (check constraint?)

  • PRIMARY KEY (mid)

  • FOREIGN KEY (session) REFERENCES a6_Session(url) ON DELETE CASCADE

  • FOREIGN KEY (user) REFERENCES a6_User(name) ON DELETE CASCADE