CREATE TABLE IF NOT EXISTS `#__adodisblog_blogs` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `catid` int(11) NOT NULL,
  `published` tinyint(3) NOT NULL,
  `access` tinyint(3) NOT NULL,
  `ordering` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `hits` int(11) NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `language` char(7) NOT NULL,
  `name` varchar(255) NOT NULL,
  `e_mail` varchar(255) NOT NULL,
  `gender` tinyint(3) NOT NULL,
  `image` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `modified_by` varchar(255) NOT NULL,
  `isgood` tinyint(6) NOT NULL,
  `isbad` tinyint(6) NOT NULL,
  `rated_ids` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `#__adodisblog_comments` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `comment` text NOT NULL,
  `blog_id` int(11) NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `published` tinyint(3) NOT NULL,
  `language` char(7) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `gender` tinyint(3) NOT NULL,
  `website` varchar(255) NOT NULL,
  `access` tinyint(3) NOT NULL,
  `modified_by` varchar(255) NOT NULL,
  `isgood` tinyint(6) NOT NULL,
  `isbad` tinyint(6) NOT NULL,
  `rated_ids` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `#__adodisblog_settings` (
  `id` int(11) NOT NULL auto_increment,
  `title_page` varchar(255) NOT NULL,
  `show_title` tinyint(3) NOT NULL,
  `description_page` text NOT NULL,
  `show_description` tinyint(3) NOT NULL,
  `orderby` varchar(100) NOT NULL,
  `sortby` varchar(100) NOT NULL,
  `bg_color` varchar(255) NOT NULL,
  `mail_admin_temp` text NOT NULL,
  `mail_user_temp` text NOT NULL,
  `mail_admin_sub` varchar(255) NOT NULL,
  `mail_user_sub` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `#__adodisblog_users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `usergroups` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `block` tinyint(3) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;