   `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');
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  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
