 
 CREATE TABLE `pages` (
   `id` int(11) NOT NULL auto_increment,
-  `content_id` int(11) default NULL,
-  `sidebar_content` text,
-  `meta_keywords` varchar(200) default NULL,
+  `keywords` varchar(200) default NULL,
+  `user_id` int(11) NOT NULL default '0',
+  `date` datetime NOT NULL default '0000-00-00 00:00:00',
+  `title` varchar(200) NOT NULL,
+  `excerpt` text,
+  `content` longtext NOT NULL,
+  `uri` varchar(200) NOT NULL,
+  `tags` text,
+  `view` varchar(200) default NULL,
+  `modified` datetime default NULL,
+  `password` varchar(200) default NULL,
+  `status` varchar(200) default 'published',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-
-INSERT INTO `pages` (`id`,`content_id`,`sidebar_content`,`meta_keywords`) VALUES ('1','1','<p>&nbsp;</p>','');
-INSERT INTO `pages` (`id`,`content_id`,`sidebar_content`,`meta_keywords`) VALUES ('2','2','<p>&nbsp;</p>','');
-INSERT INTO `pages` (`id`,`content_id`,`sidebar_content`,`meta_keywords`) VALUES ('3','3','<p>&nbsp;</p>','');
-INSERT INTO `pages` (`id`,`content_id`,`sidebar_content`,`meta_keywords`) VALUES ('4','4','<p>&nbsp;</p>','');
+) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
 
 
 # Dump of table roles

  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`user_id`,`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `users_roles` (`user_id`,`role_id`) VALUES ('1','1');
INSERT INTO `users_roles` (`user_id`,`role_id`) VALUES ('1','2');

# Version 0.7b5
# http://cocoamysql.sourceforge.net
#
# Host: localhost (MySQL 5.0.51a)
# Database: s7ncms
# Generation Time: 2008-04-12 02:15:29 +0200
# ************************************************************

# Dump of table config
# ------------------------------------------------------------

CREATE TABLE `config` (
  `id` int(11) NOT NULL auto_increment,
  `context` varchar(200) NOT NULL,
  `key` varchar(200) NOT NULL,
  `value` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO `config` (`id`,`context`,`key`,`value`) VALUES ('1','s7n','default_uri','home');
INSERT INTO `config` (`id`,`context`,`key`,`value`) VALUES ('2','s7n','page_views','default, extended');


# Dump of table pages
