Detailed list of fields

-- Table structure for table 'jos_banner'
--

Create TABLE jos_banner (
 bid int(11) NOT NULL auto_increment,
 cid int(11) NOT NULL default '0',
 `type` varchar(30) NOT NULL default 'banner',
 `name` varchar(255) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 imptotal int(11) NOT NULL default '0',
 impmade int(11) NOT NULL default '0',
 clicks int(11) NOT NULL default '0',
 imageurl varchar(100) NOT NULL default ,
 clickurl varchar(200) NOT NULL default ,
 `date` datetime default NULL,
 showBanner tinyint(1) NOT NULL default '0',
 checked_out tinyint(1) NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 editor varchar(50) default NULL,
 custombannercode text,
 catid int(10) unsigned NOT NULL default '0',
 description text NOT NULL,
 sticky tinyint(1) unsigned NOT NULL default '0',
 ordering int(11) NOT NULL default '0',
 publish_up datetime NOT NULL default '0000-00-00 00:00:00',
 publish_down datetime NOT NULL default '0000-00-00 00:00:00',
 tags text NOT NULL,
 params text NOT NULL,
 PRIMARY KEY  (bid),
 KEY viewbanner (showBanner),
 KEY idx_banner_catid (catid)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

  -- --------------------------------------------------------

--
 -- Table structure for table 'jos_bannerclient'
--

Create TABLE jos_bannerclient (
 cid int(11) NOT NULL auto_increment,
 `name` varchar(255) NOT NULL default ,
 contact varchar(255) NOT NULL default ,
 email varchar(255) NOT NULL default ,
 extrainfo text NOT NULL,
 checked_out tinyint(1) NOT NULL default '0',
 checked_out_time time default NULL,
 editor varchar(50) default NULL,
 PRIMARY KEY  (cid)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

  -- --------------------------------------------------------

--
 -- Table structure for table 'jos_bannertrack'
--

Create TABLE jos_bannertrack (
 track_date date NOT NULL,
 track_type int(10) unsigned NOT NULL,
 banner_id int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

  -- --------------------------------------------------------

 --
-- Table structure for table 'jos_categories'
 --

Create TABLE jos_categories (
 id int(11) NOT NULL auto_increment,
 parent_id int(11) NOT NULL default '0',
 title varchar(255) NOT NULL default ,
 `name` varchar(255) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 image varchar(255) NOT NULL default ,
 section varchar(50) NOT NULL default ,
 image_position varchar(30) NOT NULL default ,
 description text NOT NULL,
 published tinyint(1) NOT NULL default '0',
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 editor varchar(50) default NULL,
 ordering int(11) NOT NULL default '0',
 access tinyint(3) unsigned NOT NULL default '0',
 count int(11) NOT NULL default '0',
 params text NOT NULL,
 PRIMARY KEY  (id),
 KEY cat_idx (section,published,access),
 KEY idx_access (access),
 KEY idx_checkout (checked_out)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

  -- --------------------------------------------------------

--
-- Table structure for table 'jos_components'
--

Create TABLE jos_components (
 id int(11) NOT NULL auto_increment,
 `name` varchar(50) NOT NULL default ,
 link varchar(255) NOT NULL default ,
 menuid int(11) unsigned NOT NULL default '0',
 parent int(11) unsigned NOT NULL default '0',
 admin_menu_link varchar(255) NOT NULL default ,
 admin_menu_alt varchar(255) NOT NULL default ,
 `option` varchar(50) NOT NULL default ,
 ordering int(11) NOT NULL default '0',
 admin_menu_img varchar(255) NOT NULL default ,
 iscore tinyint(4) NOT NULL default '0',
 params text NOT NULL,
 enabled tinyint(4) NOT NULL default '1',
 PRIMARY KEY  (id),
 KEY parent_option (parent,`option`(32))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_contact_details'
--

Create TABLE jos_contact_details (
 id int(11) NOT NULL auto_increment,
 `name` varchar(255) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 con_position varchar(255) default NULL,
 address text,
 suburb varchar(100) default NULL,
 state varchar(100) default NULL,
 country varchar(100) default NULL,
 postcode varchar(100) default NULL,
 telephone varchar(255) default NULL,
 fax varchar(255) default NULL,
 misc mediumtext,
 image varchar(255) default NULL,
 imagepos varchar(20) default NULL,
 email_to varchar(255) default NULL,
 default_con tinyint(1) unsigned NOT NULL default '0',
 published tinyint(1) unsigned NOT NULL default '0',
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 ordering int(11) NOT NULL default '0',
 params text NOT NULL,
 user_id int(11) NOT NULL default '0',
 catid int(11) NOT NULL default '0',
 access tinyint(3) unsigned NOT NULL default '0',
 mobile varchar(255) NOT NULL default ,
 webpage varchar(255) NOT NULL default ,
 PRIMARY KEY  (id),
 KEY catid (catid)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_content'
--

Create TABLE jos_content (
 id int(11) unsigned NOT NULL auto_increment,
 title varchar(255) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 title_alias varchar(255) NOT NULL default ,
 introtext mediumtext NOT NULL,
 `fulltext` mediumtext NOT NULL,
 state tinyint(3) NOT NULL default '0',
 sectionid int(11) unsigned NOT NULL default '0',
 mask int(11) unsigned NOT NULL default '0',
 catid int(11) unsigned NOT NULL default '0',
  Created datetime NOT NULL default '0000-00-00 00:00:00',
  Created_by int(11) unsigned NOT NULL default '0',
  Created_by_alias varchar(255) NOT NULL default ,
 modified datetime NOT NULL default '0000-00-00 00:00:00',
 modified_by int(11) unsigned NOT NULL default '0',
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 publish_up datetime NOT NULL default '0000-00-00 00:00:00',
 publish_down datetime NOT NULL default '0000-00-00 00:00:00',
 images text NOT NULL,
 urls text NOT NULL,
 attribs text NOT NULL,
 version int(11) unsigned NOT NULL default '1',
 parentid int(11) unsigned NOT NULL default '0',
 ordering int(11) NOT NULL default '0',
 metakey text NOT NULL,
 metadesc text NOT NULL,
 access int(11) unsigned NOT NULL default '0',
 hits int(11) unsigned NOT NULL default '0',
 metadata text NOT NULL,
 PRIMARY KEY  (id),
 KEY idx_section (sectionid),
 KEY idx_access (access),
 KEY idx_checkout (checked_out),
 KEY idx_state (state),
 KEY idx_catid (catid),
 KEY idx_ Createdby ( Created_by)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_content_frontpage'
--

Create TABLE jos_content_frontpage (
 content_id int(11) NOT NULL default '0',
 ordering int(11) NOT NULL default '0',
 PRIMARY KEY  (content_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_content_rating'
--

Create TABLE jos_content_rating (
 content_id int(11) NOT NULL default '0',
 rating_sum int(11) unsigned NOT NULL default '0',
 rating_count int(11) unsigned NOT NULL default '0',
 lastip varchar(50) NOT NULL default ,
 PRIMARY KEY  (content_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_acl_aro'
--

Create TABLE jos_core_acl_aro (
 id int(11) NOT NULL auto_increment,
 section_value varchar(240) NOT NULL default '0',
 `value` varchar(240) NOT NULL default ,
 order_value int(11) NOT NULL default '0',
 `name` varchar(255) NOT NULL default ,
 hidden int(11) NOT NULL default '0',
 PRIMARY KEY  (id),
 UNIQUE KEY jos_section_value_value_aro (section_value(100),`value`(100)),
 KEY jos_gacl_hidden_aro (hidden)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_acl_aro_groups'
--

Create TABLE jos_core_acl_aro_groups (
 id int(11) NOT NULL auto_increment,
 parent_id int(11) NOT NULL default '0',
 `name` varchar(255) NOT NULL default ,
 lft int(11) NOT NULL default '0',
 rgt int(11) NOT NULL default '0',
 `value` varchar(255) NOT NULL default ,
 PRIMARY KEY  (id),
 KEY jos_gacl_parent_id_aro_groups (parent_id),
 KEY jos_gacl_lft_rgt_aro_groups (lft,rgt)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_acl_aro_map'
--

Create TABLE jos_core_acl_aro_map (
 acl_id int(11) NOT NULL default '0',
 section_value varchar(230) NOT NULL default '0',
 `value` varchar(100) NOT NULL,
 PRIMARY KEY  (acl_id,section_value,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_acl_aro_sections'
--

Create TABLE jos_core_acl_aro_sections (
 id int(11) NOT NULL auto_increment,
 `value` varchar(230) NOT NULL default ,
 order_value int(11) NOT NULL default '0',
 `name` varchar(230) NOT NULL default ,
 hidden int(11) NOT NULL default '0',
 PRIMARY KEY  (id),
 UNIQUE KEY jos_gacl_value_aro_sections (`value`),
 KEY jos_gacl_hidden_aro_sections (hidden)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_acl_groups_aro_map'
--

Create TABLE jos_core_acl_groups_aro_map (
 group_id int(11) NOT NULL default '0',
 section_value varchar(240) NOT NULL default ,
 aro_id int(11) NOT NULL default '0',
 UNIQUE KEY group_id_aro_id_groups_aro_map (group_id,section_value,aro_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_log_items'
--

Create TABLE jos_core_log_items (
 time_stamp date NOT NULL default '0000-00-00',
 item_table varchar(50) NOT NULL default ,
 item_id int(11) unsigned NOT NULL default '0',
 hits int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_core_log_searches'
--

Create TABLE jos_core_log_searches (
 search_term varchar(128) NOT NULL default ,
 hits int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_groups'
--

Create TABLE jos_groups (
 id tinyint(3) unsigned NOT NULL default '0',
 `name` varchar(50) NOT NULL default ,
 PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 -- --------------------------------------------------------

--
-- Table structure for table 'jos_menu'
--

Create TABLE jos_menu (
 id int(11) NOT NULL auto_increment,
 menutype varchar(75) default NULL,
 `name` varchar(255) default NULL,
 alias varchar(255) NOT NULL default ,
 link text,
 `type` varchar(50) NOT NULL default ,
 published tinyint(1) NOT NULL default '0',
 parent int(11) unsigned NOT NULL default '0',
 componentid int(11) unsigned NOT NULL default '0',
 sublevel int(11) default '0',
 ordering int(11) default '0',
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 pollid int(11) NOT NULL default '0',
 browserNav tinyint(4) default '0',
 access tinyint(3) unsigned NOT NULL default '0',
 utaccess tinyint(3) unsigned NOT NULL default '0',
 params text NOT NULL,
 lft int(11) unsigned NOT NULL default '0',
 rgt int(11) unsigned NOT NULL default '0',
 home int(1) unsigned NOT NULL default '0',
 PRIMARY KEY  (id),
 KEY componentid (componentid,menutype,published,access),
 KEY menutype (menutype)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--

-- Table structure for table 'jos_menu_types'

--

Create TABLE jos_menu_types (
 id int(10) unsigned NOT NULL auto_increment,
 menutype varchar(75) NOT NULL default ,
 title varchar(255) NOT NULL default ,
 description varchar(255) NOT NULL default ,
 PRIMARY KEY  (id),
 UNIQUE KEY menutype (menutype)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_messages'
--

Create TABLE jos_messages (
 message_id int(10) unsigned NOT NULL auto_increment,
 user_id_from int(10) unsigned NOT NULL default '0',
 user_id_to int(10) unsigned NOT NULL default '0',
 folder_id int(10) unsigned NOT NULL default '0',
 date_time datetime NOT NULL default '0000-00-00 00:00:00',
 state int(11) NOT NULL default '0',
 priority int(1) unsigned NOT NULL default '0',
 `subject` text NOT NULL,
 message text NOT NULL,
 PRIMARY KEY  (message_id),
 KEY useridto_state (user_id_to,state)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_messages_cfg'
--

Create TABLE jos_messages_cfg (
 user_id int(10) unsigned NOT NULL default '0',
 cfg_name varchar(100) NOT NULL default ,
 cfg_value varchar(255) NOT NULL default ,
 UNIQUE KEY idx_user_var_name (user_id,cfg_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_migration_backlinks'
--

Create TABLE jos_migration_backlinks (
 itemid int(11) NOT NULL,
 `name` varchar(100) NOT NULL,
 url text NOT NULL,
 sefurl text NOT NULL,
 newurl text NOT NULL,
 PRIMARY KEY  (itemid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_modules'
--

Create TABLE jos_modules (
 id int(11) NOT NULL auto_increment,
 title text NOT NULL,
 content text NOT NULL,
 ordering int(11) NOT NULL default '0',
 position varchar(50) default NULL,
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 published tinyint(1) NOT NULL default '0',
 module varchar(50) default NULL,
 numnews int(11) NOT NULL default '0',
 access tinyint(3) unsigned NOT NULL default '0',
 showtitle tinyint(3) unsigned NOT NULL default '1',
 params text NOT NULL,
 iscore tinyint(4) NOT NULL default '0',
 client_id tinyint(4) NOT NULL default '0',
 control text NOT NULL,
 PRIMARY KEY  (id),
 KEY published (published,access),
 KEY newsfeeds (module,published)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_modules_menu'
--

Create TABLE jos_modules_menu (
 moduleid int(11) NOT NULL default '0',
 menuid int(11) NOT NULL default '0',
 PRIMARY KEY  (moduleid,menuid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_newsfeeds'
--

Create TABLE jos_newsfeeds (
 catid int(11) NOT NULL default '0',
 id int(11) NOT NULL auto_increment,
 `name` text NOT NULL,
 alias varchar(255) NOT NULL default ,
 link text NOT NULL,
 filename varchar(200) default NULL,
 published tinyint(1) NOT NULL default '0',
 numarticles int(11) unsigned NOT NULL default '1',
 cache_time int(11) unsigned NOT NULL default '3600',
 checked_out tinyint(3) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 ordering int(11) NOT NULL default '0',
 rtl tinyint(4) NOT NULL default '0',
 PRIMARY KEY  (id),
 KEY published (published),
 KEY catid (catid)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_plugins'
--

Create TABLE jos_plugins (
 id int(11) NOT NULL auto_increment,
 `name` varchar(100) NOT NULL default ,
 element varchar(100) NOT NULL default ,
 folder varchar(100) NOT NULL default ,
 access tinyint(3) unsigned NOT NULL default '0',
 ordering int(11) NOT NULL default '0',
 published tinyint(3) NOT NULL default '0',
 iscore tinyint(3) NOT NULL default '0',
 client_id tinyint(3) NOT NULL default '0',
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 params text NOT NULL,
 PRIMARY KEY  (id),
 KEY idx_folder (published,client_id,access,folder)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_polls'
--

Create TABLE jos_polls (
 id int(11) unsigned NOT NULL auto_increment,
 title varchar(255) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 voters int(9) NOT NULL default '0',
 checked_out int(11) NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 published tinyint(1) NOT NULL default '0',
 access int(11) NOT NULL default '0',
 lag int(11) NOT NULL default '0',
 PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_poll_data'
--

Create TABLE jos_poll_data (
 id int(11) NOT NULL auto_increment,
 pollid int(11) NOT NULL default '0',
 `text` text NOT NULL,
 hits int(11) NOT NULL default '0',
 PRIMARY KEY  (id),
 KEY pollid (pollid,`text`(1))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_poll_date'
--

Create TABLE jos_poll_date (
 id bigint(20) NOT NULL auto_increment,
 `date` datetime NOT NULL default '0000-00-00 00:00:00',
 vote_id int(11) NOT NULL default '0',
 poll_id int(11) NOT NULL default '0',
 PRIMARY KEY  (id),
 KEY poll_id (poll_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_poll_menu'
--

Create TABLE jos_poll_menu (
 pollid int(11) NOT NULL default '0',
 menuid int(11) NOT NULL default '0',
 PRIMARY KEY  (pollid,menuid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_sections'
--

Create TABLE jos_sections (
 id int(11) NOT NULL auto_increment,
 title varchar(255) NOT NULL default ,
 `name` varchar(255) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 image text NOT NULL,
 scope varchar(50) NOT NULL default ,
 image_position varchar(30) NOT NULL default ,
 description text NOT NULL,
 published tinyint(1) NOT NULL default '0',
 checked_out int(11) unsigned NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 ordering int(11) NOT NULL default '0',
 access tinyint(3) unsigned NOT NULL default '0',
 count int(11) NOT NULL default '0',
 params text NOT NULL,
 PRIMARY KEY  (id),
 KEY idx_scope (scope)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_session'
--

Create TABLE jos_session (
 username varchar(150) default ,
 `time` varchar(14) default ,
 session_id varchar(200) NOT NULL default '0',
 guest tinyint(4) default '1',
 userid int(11) default '0',
 usertype varchar(50) default ,
 gid tinyint(3) unsigned NOT NULL default '0',
 client_id tinyint(3) unsigned NOT NULL default '0',
 `data` longtext,
 PRIMARY KEY  (session_id(64)),
 KEY whosonline (guest,usertype),
 KEY userid (userid),
 KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_stats_agents'
--

Create TABLE jos_stats_agents (
 agent varchar(255) NOT NULL default ,
 `type` tinyint(1) unsigned NOT NULL default '0',
 hits int(11) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_templates_menu'
--

Create TABLE jos_templates_menu (
 template varchar(255) NOT NULL default ,
 menuid int(11) NOT NULL default '0',
 client_id tinyint(4) NOT NULL default '0',
 PRIMARY KEY  (menuid,client_id,template)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_users'
--

Create TABLE jos_users (
 id int(11) NOT NULL auto_increment,
 `name` varchar(255) NOT NULL default ,
 username varchar(150) NOT NULL default ,
 email varchar(100) NOT NULL default ,
 `password` varchar(100) NOT NULL default ,
 usertype varchar(25) NOT NULL default ,
 `block` tinyint(4) NOT NULL default '0',
 sendEmail tinyint(4) default '0',
 gid tinyint(3) unsigned NOT NULL default '1',
 registerDate datetime NOT NULL default '0000-00-00 00:00:00',
 lastvisitDate datetime NOT NULL default '0000-00-00 00:00:00',
 activation varchar(100) NOT NULL default ,
 params text NOT NULL,
 PRIMARY KEY  (id),
 KEY usertype (usertype),
 KEY idx_name (`name`),
 KEY gid_block (gid,`block`),
 KEY username (username),
 KEY email (email)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table 'jos_weblinks'
--

Create TABLE jos_weblinks (
 id int(11) unsigned NOT NULL auto_increment,
 catid int(11) NOT NULL default '0',
 sid int(11) NOT NULL default '0',
 title varchar(250) NOT NULL default ,
 alias varchar(255) NOT NULL default ,
 url varchar(250) NOT NULL default ,
 description text NOT NULL,
 `date` datetime NOT NULL default '0000-00-00 00:00:00',
 hits int(11) NOT NULL default '0',
 published tinyint(1) NOT NULL default '0',
 checked_out int(11) NOT NULL default '0',
 checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
 ordering int(11) NOT NULL default '0',
 archived tinyint(1) NOT NULL default '0',
 approved tinyint(1) NOT NULL default '1',
 params text NOT NULL,
 PRIMARY KEY  (id),
 KEY catid (catid,published,archived)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;