schema.sql 1.2 KB

12345678910111213141516171819202122232425
  1. -- version 0.0.0
  2. CREATE TABLE `pages` (
  3. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'AI',
  4. `parent` int(11) NOT NULL DEFAULT '0' COMMENT 'Parent page id',
  5. `user` int(11) NOT NULL COMMENT 'User id',
  6. `name` varchar(255) NOT NULL COMMENT 'Page name',
  7. `slug` varchar(255) NOT NULL COMMENT 'Page url part',
  8. `content` text NOT NULL COMMENT 'Page content',
  9. `meta_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Page meta title',
  10. `meta_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'Page meta keywords',
  11. `meta_description` varchar(510) NOT NULL DEFAULT '' COMMENT 'Page meta description',
  12. `datetime` datetime NOT NULL COMMENT 'Creation date/time',
  13. `status` enum('draft','public','trash') NOT NULL COMMENT 'Page status',
  14. PRIMARY KEY (`id`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  16. CREATE TABLE `users` (
  17. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'AI',
  18. `first_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'User first name',
  19. `last_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'User last name',
  20. `email` varchar(64) NOT NULL COMMENT 'User email',
  21. `password` varchar(32) NOT NULL COMMENT 'User password (MD5)',
  22. PRIMARY KEY (`id`)
  23. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;