Database Table structure

Table users

CREATE TABLE users
(
  id        INT AUTO_INCREMENT
    PRIMARY KEY,
  uname     VARCHAR(45)  NULL,
  pwhash    VARCHAR(255) NULL,
  email     VARCHAR(255) NOT NULL,
  lastlogin VARCHAR(10)  NULL,
  pwchange  VARCHAR(10)  NULL
)
  ENGINE = InnoDB;

Table snippets

CREATE TABLE snippets
(
  id          INT AUTO_INCREMENT
    PRIMARY KEY,
  title       VARCHAR(150) NOT NULL,
  description VARCHAR(250) NULL,
  language    VARCHAR(20)  NOT NULL,
  tags        VARCHAR(250) NULL,
  author_id   INT          NULL,
  author_name VARCHAR(45)  NULL,
  status      TINYINT      NULL,
  date        VARCHAR(10)  NULL
)
  ENGINE = InnoDB;

Table reviews

CREATE TABLE reviews
(
  id                  INT AUTO_INCREMENT
    PRIMARY KEY,
  snippet_id          INT   NOT NULL,
  rating_security     FLOAT NULL,
  rating_cleanliness  FLOAT NULL,
  rating_total        FLOAT NULL,
  security_comment    TEXT  NULL,
  cleanliness_comment TEXT  NULL,
  total_comment       TEXT  NOT NULL,
  author_id           INT   NOT NULL
)
  ENGINE = InnoDB;