ZF2 blog simple schema

gistfile1.txt

CREATE TABLE post (
  id int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL,
  content TEXT NOT NULL,
  user_id int(11),
  category_id int(11),
  publish_date DATETIME,
  PRIMARY KEY (id)
);

CREATE TABLE user (
  id int(11) NOT NULL auto_increment,
  username varchar(100) NOT NULL,
  password varchar(60) NOT NULL,
  role_id int(11),
  PRIMARY KEY (id)
);

CREATE TABLE role (
  id int(11) NOT NULL auto_increment,
  role varchar(100) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE category (
  id int(11) NOT NULL auto_increment,
  category varchar(100) NOT NULL,
  PRIMARY KEY (id)
);