DROP TABLE IF EXISTS `idx_default_field`;
CREATE TABLE IF NOT EXISTS `idx_default_field` (
  `field_name` varchar(64) NOT NULL,
  `required` char(1) NOT NULL,
  `visible` char(1) NOT NULL default '1',
  `searchable` char(1) NOT NULL default '1'
);

INSERT INTO `idx_default_field` (`field_name`, `required`, `visible`, `searchable`) VALUES
('title', '1', '1', '1'),
('url', '1', '1', '1'),
('description', '1', '1', '1'),
('keywords', '1', '1', '0'),
('contact_name', '1', '1', '1'),
('email', '1', '1', '1'),
('reciprocal_url', '0', '1', '1');

DROP TABLE IF EXISTS `idx_cronjobs`;
CREATE TABLE IF NOT EXISTS `idx_cronjobs` (
  `cronjobs_id` int(11) NOT NULL auto_increment,
  `cronjobs_name` varchar(255) default NULL,
  `filename` varchar(255) NOT NULL,
  `schedule` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `execution` varchar(1) NOT NULL,
  PRIMARY KEY  (`cronjobs_id`)
);

INSERT INTO `idx_cronjobs` (`cronjobs_id`, `cronjobs_name`, `filename`, `schedule`, `time`, `execution`) VALUES
(1, NULL, 'clear_templates_c.php', '1,*,*,*,*', '0000-00-00 00:00:00', ''),
(2, NULL, 'update_tag_cloud.php', '*,24,*,*,*', '0000-00-00 00:00:00', ''),
(3, NULL, 'clear_rss_cache.php', '*,24,*,*,*', '0000-00-00 00:00:00', '');

INSERT INTO `idx_email_template` (`email_template_id`, `name`, `subject`, `body`, `altbody`) VALUES
(35, 'send_activation_link', 'Your activation link', '<div style="font-family:arial;font-size:12px;">\r\nHere is your activation link\r\n<p>\r\nActivation Link  : <A href="<%$activation_link%>"><%$activation_link%></a>\r\n<p>\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>', 'Here is your activation link\r\nActivation Link  : <%$activation_link%>\r\nRegards,\r\n<%$site_name%> Team\r\n'),
(36, 'send_activated_account', 'Your account had been activated', '<div style="font-family:arial;font-size:12px;">\r\nYour account had been activated. Now you can login.\r\n<p>\r\nRegards,\r\n<p>\r\n<b><%$site_name%></b> Team\r\n</div>', 'Your account had been activated. Now you can login.\r\n\r\nRegards,\r\n<%$site_name%> Team\r\n');

ALTER TABLE `idx_custom_field` CHANGE `field_type` `field_type` ENUM( 'TEXT', 'TEXTAREA', 'SELECT', 'MULTISELECT', 'CHECKBOX', 'RADIO', 'FILE', 'IMAGE', 'DATE', 'DATETIME', 'RICHEDITOR' ) NOT NULL DEFAULT 'TEXT';