(SQL) Tabela Users - CakePHP 1.3 + AuthComponent

gistfile1.sql

CREATE TABLE users (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(200) NOT NULL,
  username VARCHAR(20) NOT NULL,
  password VARCHAR(100) NOT NULL,
  created DATETIME NULL,
  modified DATETIME NULL,
  active TINYINT(1) NOT NULL DEFAULT 1,
  PRIMARY KEY(id),
  UNIQUE(username)
);