A tumblelog CMS built on AJAX, PHP and MySQL.

gelato_db.sql 2.8KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. -- DB Gelato CMS v0.95
  2. CREATE TABLE `gel_data` (
  3. `id_post` int(11) NOT NULL auto_increment,
  4. `title` text NULL,
  5. `url` varchar(250) default NULL,
  6. `description` text NULL,
  7. `type` tinyint(4) NOT NULL default '1',
  8. `date` datetime NOT NULL,
  9. `id_user` int(10) NOT NULL,
  10. PRIMARY KEY (`id_post`)
  11. ) ENGINE = MYISAM ;
  12. CREATE TABLE `gel_users` (
  13. `id_user` int(10) unsigned NOT NULL auto_increment,
  14. `name` varchar(100) default NULL,
  15. `login` varchar(100) NOT NULL default '',
  16. `password` varchar(64) NOT NULL default '',
  17. `email` varchar(100) default NULL,
  18. `website` varchar(150) default NULL,
  19. `about` text,
  20. PRIMARY KEY (`id_user`)
  21. ) ENGINE = MYISAM ;
  22. CREATE TABLE `gel_config` (
  23. `posts_limit` int(3) NOT NULL,
  24. `title` varchar(250) NOT NULL,
  25. `description` text NOT NULL,
  26. `lang` varchar(10) NOT NULL,
  27. `template` varchar(100) NOT NULL,
  28. `url_installation` varchar(250) NOT NULL,
  29. PRIMARY KEY (`title`)
  30. ) ENGINE = MYISAM ;
  31. CREATE TABLE `gel_options` (
  32. `name` varchar(100) NOT NULL,
  33. `val` varchar(255) NOT NULL,
  34. PRIMARY KEY (`name`)
  35. ) ENGINE = MYISAM ;
  36. CREATE TABLE `gel_comments` (
  37. `id_comment` int(11) NOT NULL auto_increment,
  38. `id_post` int(11) NOT NULL,
  39. `username` varchar(50) NOT NULL,
  40. `email` varchar(100) NOT NULL,
  41. `web` varchar(250) default NULL,
  42. `content` text NOT NULL,
  43. `ip_user` varchar(50) NOT NULL,
  44. `comment_date` datetime NOT NULL,
  45. `spam` tinyint(4) NOT NULL,
  46. PRIMARY KEY (`id_comment`)
  47. ) ENGINE = MYISAM ;
  48. CREATE TABLE `gel_feeds` (
  49. `id_feed` int(11) NOT NULL auto_increment,
  50. `url` varchar(255) NOT NULL,
  51. `title` varchar(255) NOT NULL,
  52. `type` tinyint(4) NOT NULL default '1',
  53. `updated_at` datetime NOT NULL,
  54. `error` tinyint(1) NOT NULL default '0',
  55. `credits` int(1) NOT NULL default '0',
  56. `site_url` varchar(255) NOT NULL,
  57. `id_user` int(10) NOT NULL,
  58. PRIMARY KEY (`id_feed`)
  59. ) ENGINE=MyISAM ;
  60. -- Example data for table `gel_config`
  61. INSERT INTO `gel_config` VALUES (10, 'Tumble title', 'tumble description', 'en', 'tumblr', 'http://localhost/gelato');
  62. -- Example data for table `gel_users`
  63. -- The password is "demo" without the "
  64. INSERT INTO `gel_users` VALUES (1, 'System administrator', 'admin', 'fe01ce2a7fbac8fafaed7c982a04e229', 'correo@correo.com', 'page', 'about');
  65. -- Example data for table `gel_options`
  66. INSERT INTO `gel_options` VALUES ('url_friendly', '1');
  67. INSERT INTO `gel_options` VALUES ('rich_text', '0');
  68. INSERT INTO `gel_options` VALUES ('allow_comments', '0');
  69. INSERT INTO `gel_options` VALUES ('offset_city', 'Mexico/General');
  70. INSERT INTO `gel_options` VALUES ('offset_time', '-6');
  71. INSERT INTO `gel_options` VALUES ('shorten_links', '0');
  72. INSERT INTO `gel_options` VALUES ('rss_import_frec', '5 minutes');
  73. INSERT INTO `gel_options` VALUES ('active_plugins', '[{"total":0},[]]');