 # Version 0.7b5
 # http://cocoamysql.sourceforge.net
 #
-# Host: localhost (MySQL 5.0.45)
-# Database: test
-# Generation Time: 2007-11-25 21:56:15 +0100
+# Host: localhost (MySQL 5.0.51a)
+# Database: s7ncms
+# Generation Time: 2008-04-12 02:15:29 +0200
 # ************************************************************
 
-# Dump of table content
+# Dump of table config
 # ------------------------------------------------------------
 
-CREATE TABLE `content` (
+CREATE TABLE `config` (
   `id` int(11) NOT NULL auto_increment,
-  `version` int(11) default NULL,
-  `title` varchar(200) default NULL,
-  `uri` varchar(200) default NULL,
-  `intro` text,
-  `body` text,
-  `publish_on` datetime default NULL,
-  `created_on` datetime default NULL,
-  `created_by` int(11) default NULL,
-  `modified_on` datetime default NULL,
-  `modified_by` int(11) default NULL,
-  `tags` text,
-  `status` enum('published','draft','secured') default 'published',
-  `comment_status` enum('open','closed') default 'open',
-  `password` varchar(200) default NULL,
-  `view` varchar(200) default NULL,
+  `context` varchar(200) NOT NULL,
+  `key` varchar(200) NOT NULL,
+  `value` varchar(200) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
 
-INSERT INTO `content` (`id`,`version`,`title`,`uri`,`intro`,`body`,`publish_on`,`created_on`,`created_by`,`modified_on`,`modified_by`,`tags`,`status`,`comment_status`,`password`,`view`) VALUES ('1','1','Home','home','<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.</p>\n<p>Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.</p>','<p>&nbsp;</p>','2007-11-25 13:36:10','2007-11-25 13:36:10','1','2007-11-25 13:36:10','1',NULL,'published','closed',NULL,NULL);
-INSERT INTO `content` (`id`,`version`,`title`,`uri`,`intro`,`body`,`publish_on`,`created_on`,`created_by`,`modified_on`,`modified_by`,`tags`,`status`,`comment_status`,`password`,`view`) VALUES ('2','1','Products','products','<h2>Product A</h2>\n<p>Beschreibung zum Produkt A</p>\n<h2>Produkt B</h2>\n<p>Beschreibung zum Produkt B</p>','<p>&nbsp;</p>','2007-11-25 13:36:39','2007-11-25 13:36:39','1','2007-11-25 13:36:39','1',NULL,'published','closed',NULL,NULL);
-INSERT INTO `content` (`id`,`version`,`title`,`uri`,`intro`,`body`,`publish_on`,`created_on`,`created_by`,`modified_on`,`modified_by`,`tags`,`status`,`comment_status`,`password`,`view`) VALUES ('3','1','About Me','about-me','<p>Hello, my Name is Max Mustermann. I live in Sydney.</p>','<p>&nbsp;</p>','2007-11-25 13:37:13','2007-11-25 13:37:13','1','2007-11-25 13:37:13','1',NULL,'published','closed',NULL,NULL);
-INSERT INTO `content` (`id`,`version`,`title`,`uri`,`intro`,`body`,`publish_on`,`created_on`,`created_by`,`modified_on`,`modified_by`,`tags`,`status`,`comment_status`,`password`,`view`) VALUES ('4','1','Contact Me','contact-me','<p>E-Mail: max.mustermann@example.com<br />ICQ: 123456789</p>\n<p>Max Mustermann<br />Muster Avenue 12<br />12345 City</p>','<p>&nbsp;</p>','2007-11-25 13:37:46','2007-11-25 13:37:46','1','2007-11-25 13:37:46','1',NULL,'published','closed',NULL,NULL);
+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

  PRIMARY KEY  (`id`),
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO `roles` (`id`,`name`,`description`) VALUES ('1','login','Login privileges, granted after account confirmation');
INSERT INTO `roles` (`id`,`name`,`description`) VALUES ('2','admin','Administrative user, has access to everything.');


# Dump of table settings
# ------------------------------------------------------------

CREATE TABLE `settings` (
  `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 `settings` (`id`,`context`,`key`,`value`) VALUES ('1','s7n','default_uri','home');
INSERT INTO `settings` (`id`,`context`,`key`,`value`) VALUES ('2','page','views','default, extended');


# Dump of table users


CREATE TABLE `pages` (
  `id` int(11) NOT NULL auto_increment,
  `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=36 DEFAULT CHARSET=utf8;


# Dump of table roles
