Sql - Como criar um CMS com CakePHP 2

gistfile1.txt

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `paginas`;
CREATE TABLE `paginas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu` varchar(512) DEFAULT NULL,
  `corpo` text,
  `title` varchar(512) DEFAULT NULL,
  `descricao` text,
  `tags` varchar(512) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `paginas` (`id`, `menu`, `corpo`, `title`, `descricao`, `tags`, `url`, `parent_id`, `lft`, `rght`, `created`, `modified`) VALUES
(1,	'1',	NULL,	'Home',	NULL,	NULL,	NULL,	0,	1,	2,	'2015-05-27 18:30:55',	'2015-05-27 18:30:55');

DROP TABLE IF EXISTS `seos`;
CREATE TABLE `seos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `robots` text,
  `sitemap` text,
  `google_confirm` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `seos` (`id`, `robots`, `sitemap`, `google_confirm`) VALUES
(1,	'User-agent: *\r\n								Disallow: /admin',	NULL,	NULL);

DROP TABLE IF EXISTS `sliders`;
CREATE TABLE `sliders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imagem` varchar(250) DEFAULT NULL,
  `titulo` varchar(250) DEFAULT NULL,
  `descricao` text,
  `parent_id` int(11) DEFAULT NULL,
  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  `pagina_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `usuarios`;
CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(250) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `email` varchar(500) DEFAULT NULL,
  `password` varchar(60) DEFAULT NULL,
  `titulo` text,
  `acessos` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;