DROP TABLE IF EXISTS `jos_smartsef_urls`;
CREATE TABLE `jos_smartsef_urls` (
`id` int(10) unsigned NOT NULL auto_increment,
`url_sef` varchar(255) NOT NULL default '',
`url_orginal` varchar(255) NOT NULL default '',
`cache` text NOT NULL,
`published` tinyint(3) unsigned NOT NULL default '0',
`temp_key` varchar(10) NOT NULL default '',
`vars` varchar(255) NOT NULL default '',
`delete_locked` tinyint(1) unsigned NOT NULL,
`valid` tinyint(3) unsigned NOT NULL,
`remarks` text NOT NULL,
`ordering` int(10) unsigned NOT NULL,
`block_rewrite` tinyint(1) unsigned NOT NULL default '0',
`sef_tmp_url` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `url_sef` (`url_sef`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

DROP TABLE IF EXISTS `jos_smartsef_router_setting`;
CREATE TABLE `jos_smartsef_router_setting` (
`id` int(10) unsigned NOT NULL auto_increment,
`router_type` int(10) unsigned NOT NULL default '0',
`rewrite_rule` int(10) unsigned NOT NULL default '0',
`component_alias` varchar(255) NOT NULL default '',
`component` varchar(45) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARACTER SET `utf8`;

DROP TABLE IF EXISTS `jos_smartsef_plugins`;
CREATE TABLE `jos_smartsef_plugins` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`published` tinyint(3) unsigned NOT NULL default '0',
`params` text NOT NULL,
`author` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`version` varchar(10) NOT NULL,
`author_url` varchar(255) NOT NULL,
`plugin` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARACTER SET `utf8`;
INSERT INTO `jos_smartsef_plugins` (`id`, `name`, `published`, `params`, `author
`, `description`, `version`, `author_url`, `plugin`) VALUES
(1, 'Smartsefplugin-Newsfeeds', 1, 'url_prefix_path=newsfeeds\nCategory numbers 
allowed in URL=1\n\n', 'Richard@josmlatwork.com', 'Smartsef plugin for the newsf
eeds SEF urls', '1.0', 'www.smartsef.org', 'plg_com_newsfeeds'),
(2, 'Smartsefplugin-weblinks', 1, '', 'Richard@josmlatwork.com', 'Smartsef plugi
n for the weblinks SEF urls', '1.0', 'www.smartsef.org', 'plg_com_weblinks'),
(3, 'Smartsefplugin-user', 1, '', 'Richard@josmlatwork.com', 'Smartsef plugin fo
r the user SEF urls', '1.0', 'www.smartsef.org', 'plg_com_user'),
(4, 'Smartsefplugin-mailto', 1, '', 'Richard@josmlatwork.com', 'Smartsef plugin 
for the mailto SEF urls', '1.0', 'www.smartsef.org', 'plg_com_mailto'),
(5, 'Smartsefplugin-search', 1, '', 'Richard@josmlatwork.com', 'Smartsef plugin 
for the search SEF urls', '1.0', 'www.smartsef.org', 'plg_com_search');
INSERT INTO `jos_plugins` ( `name`, `element`, `folder`, `access`, `ordering`, `
published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) 
VALUES ('System - Smartsef', 'smartsef', 'system', 0, 7, 1, 0, 0, 0, '0000-00-00
 00:00:00', '');