<?xml version="1.0"?>
<?xml-stylesheet type="text/css" href="http://docs.joomla.org/skins/common/feed.css?303"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;feed=atom&amp;action=history</id>
		<title>Detailed list of fields - Revision history</title>
		<link rel="self" type="application/atom+xml" href="http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;feed=atom&amp;action=history"/>
		<link rel="alternate" type="text/html" href="http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;action=history"/>
		<updated>2013-05-25T18:36:07Z</updated>
		<subtitle>Revision history for this page on the wiki</subtitle>
		<generator>MediaWiki 1.19.3</generator>

	<entry>
		<id>http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;diff=30790&amp;oldid=prev</id>
		<title>Batch1211 at 12:36, 19 September 2010</title>
		<link rel="alternate" type="text/html" href="http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;diff=30790&amp;oldid=prev"/>
				<updated>2010-09-19T12:36:15Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class='diff diff-contentalign-left'&gt;
				&lt;col class='diff-marker' /&gt;
				&lt;col class='diff-content' /&gt;
				&lt;col class='diff-marker' /&gt;
				&lt;col class='diff-content' /&gt;
			&lt;tr valign='top'&gt;
			&lt;td colspan='2' style=&quot;background-color: white; color:black;&quot;&gt;← Older revision&lt;/td&gt;
			&lt;td colspan='2' style=&quot;background-color: white; color:black;&quot;&gt;Revision as of 12:36, 19 September 2010&lt;/td&gt;
			&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 725:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 725:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&amp;lt;/code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;background: #cfc; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;color: red; font-weight: bold; text-decoration: none;&quot;&gt;[http://www.example.com link title]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;background: #cfc; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;color: red; font-weight: bold; text-decoration: none;&quot;&gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;background: #cfc; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;color: red; font-weight: bold; text-decoration: none;&quot;&gt;[[Category:Working Groups]]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Batch1211</name></author>	</entry>

	<entry>
		<id>http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;diff=9826&amp;oldid=prev</id>
		<title>Elin at 18:26, 2 August 2008</title>
		<link rel="alternate" type="text/html" href="http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;diff=9826&amp;oldid=prev"/>
				<updated>2008-08-02T18:26:19Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class='diff diff-contentalign-left'&gt;
				&lt;col class='diff-marker' /&gt;
				&lt;col class='diff-content' /&gt;
				&lt;col class='diff-marker' /&gt;
				&lt;col class='diff-content' /&gt;
			&lt;tr valign='top'&gt;
			&lt;td colspan='2' style=&quot;background-color: white; color:black;&quot;&gt;← Older revision&lt;/td&gt;
			&lt;td colspan='2' style=&quot;background-color: white; color:black;&quot;&gt;Revision as of 18:26, 2 August 2008&lt;/td&gt;
			&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;background: #cfc; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;color: red; font-weight: bold; text-decoration: none;&quot;&gt;{{stub}}&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&amp;#160;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;background: #cfc; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;color: red; font-weight: bold; text-decoration: none;&quot;&gt;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&amp;lt;code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&amp;lt;code&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 5:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 7:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;--&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;--&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;background: #ffa; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&lt;del class=&quot;diffchange diffchange-inline&quot;&gt; -- --------------------------------------------------------&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;background: #cfc; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;&amp;#160;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;--&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background: #eee; color:black; font-size: smaller;&quot;&gt;&lt;div&gt;--&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Elin</name></author>	</entry>

	<entry>
		<id>http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;diff=9825&amp;oldid=prev</id>
		<title>Elin: Joomla! 1.5 database structure.</title>
		<link rel="alternate" type="text/html" href="http://docs.joomla.org/index.php?title=Detailed_list_of_fields&amp;diff=9825&amp;oldid=prev"/>
				<updated>2008-08-02T18:23:23Z</updated>
		
		<summary type="html">&lt;p&gt;Joomla! 1.5 database structure.&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;code&amp;gt;&lt;br /&gt;
&lt;br /&gt;
--&lt;br /&gt;
-- Database: 'joomla155'&lt;br /&gt;
--&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
--&lt;br /&gt;
 -- Table structure for table 'jos_banner'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_banner (&lt;br /&gt;
  bid int(11) NOT NULL auto_increment,&lt;br /&gt;
  cid int(11) NOT NULL default '0',&lt;br /&gt;
  `type` varchar(30) NOT NULL default 'banner',&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  imptotal int(11) NOT NULL default '0',&lt;br /&gt;
  impmade int(11) NOT NULL default '0',&lt;br /&gt;
  clicks int(11) NOT NULL default '0',&lt;br /&gt;
  imageurl varchar(100) NOT NULL default '',&lt;br /&gt;
  clickurl varchar(200) NOT NULL default '',&lt;br /&gt;
  `date` datetime default NULL,&lt;br /&gt;
  showBanner tinyint(1) NOT NULL default '0',&lt;br /&gt;
  checked_out tinyint(1) NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  editor varchar(50) default NULL,&lt;br /&gt;
  custombannercode text,&lt;br /&gt;
  catid int(10) unsigned NOT NULL default '0',&lt;br /&gt;
  description text NOT NULL,&lt;br /&gt;
  sticky tinyint(1) unsigned NOT NULL default '0',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  publish_up datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  publish_down datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  tags text NOT NULL,&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (bid),&lt;br /&gt;
  KEY viewbanner (showBanner),&lt;br /&gt;
  KEY idx_banner_catid (catid)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
   -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
  -- Table structure for table 'jos_bannerclient'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_bannerclient (&lt;br /&gt;
  cid int(11) NOT NULL auto_increment,&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  contact varchar(255) NOT NULL default '',&lt;br /&gt;
  email varchar(255) NOT NULL default '',&lt;br /&gt;
  extrainfo text NOT NULL,&lt;br /&gt;
  checked_out tinyint(1) NOT NULL default '0',&lt;br /&gt;
  checked_out_time time default NULL,&lt;br /&gt;
  editor varchar(50) default NULL,&lt;br /&gt;
  PRIMARY KEY  (cid)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
   -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
  -- Table structure for table 'jos_bannertrack'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_bannertrack (&lt;br /&gt;
  track_date date NOT NULL,&lt;br /&gt;
  track_type int(10) unsigned NOT NULL,&lt;br /&gt;
  banner_id int(10) unsigned NOT NULL&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
   -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
  --&lt;br /&gt;
 -- Table structure for table 'jos_categories'&lt;br /&gt;
  --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_categories (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  parent_id int(11) NOT NULL default '0',&lt;br /&gt;
  title varchar(255) NOT NULL default '',&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  image varchar(255) NOT NULL default '',&lt;br /&gt;
  section varchar(50) NOT NULL default '',&lt;br /&gt;
  image_position varchar(30) NOT NULL default '',&lt;br /&gt;
  description text NOT NULL,&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  editor varchar(50) default NULL,&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  access tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  count int(11) NOT NULL default '0',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY cat_idx (section,published,access),&lt;br /&gt;
  KEY idx_access (access),&lt;br /&gt;
  KEY idx_checkout (checked_out)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
   -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_components'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_components (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  `name` varchar(50) NOT NULL default '',&lt;br /&gt;
  link varchar(255) NOT NULL default '',&lt;br /&gt;
  menuid int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  parent int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  admin_menu_link varchar(255) NOT NULL default '',&lt;br /&gt;
  admin_menu_alt varchar(255) NOT NULL default '',&lt;br /&gt;
  `option` varchar(50) NOT NULL default '',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  admin_menu_img varchar(255) NOT NULL default '',&lt;br /&gt;
  iscore tinyint(4) NOT NULL default '0',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  enabled tinyint(4) NOT NULL default '1',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY parent_option (parent,`option`(32))&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_contact_details'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_contact_details (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  con_position varchar(255) default NULL,&lt;br /&gt;
  address text,&lt;br /&gt;
  suburb varchar(100) default NULL,&lt;br /&gt;
  state varchar(100) default NULL,&lt;br /&gt;
  country varchar(100) default NULL,&lt;br /&gt;
  postcode varchar(100) default NULL,&lt;br /&gt;
  telephone varchar(255) default NULL,&lt;br /&gt;
  fax varchar(255) default NULL,&lt;br /&gt;
  misc mediumtext,&lt;br /&gt;
  image varchar(255) default NULL,&lt;br /&gt;
  imagepos varchar(20) default NULL,&lt;br /&gt;
  email_to varchar(255) default NULL,&lt;br /&gt;
  default_con tinyint(1) unsigned NOT NULL default '0',&lt;br /&gt;
  published tinyint(1) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  user_id int(11) NOT NULL default '0',&lt;br /&gt;
  catid int(11) NOT NULL default '0',&lt;br /&gt;
  access tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  mobile varchar(255) NOT NULL default '',&lt;br /&gt;
  webpage varchar(255) NOT NULL default '',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY catid (catid)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_content'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_content (&lt;br /&gt;
  id int(11) unsigned NOT NULL auto_increment,&lt;br /&gt;
  title varchar(255) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  title_alias varchar(255) NOT NULL default '',&lt;br /&gt;
  introtext mediumtext NOT NULL,&lt;br /&gt;
  `fulltext` mediumtext NOT NULL,&lt;br /&gt;
  state tinyint(3) NOT NULL default '0',&lt;br /&gt;
  sectionid int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  mask int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  catid int(11) unsigned NOT NULL default '0',&lt;br /&gt;
   Created datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
   Created_by int(11) unsigned NOT NULL default '0',&lt;br /&gt;
   Created_by_alias varchar(255) NOT NULL default '',&lt;br /&gt;
  modified datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  modified_by int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  publish_up datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  publish_down datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  images text NOT NULL,&lt;br /&gt;
  urls text NOT NULL,&lt;br /&gt;
  attribs text NOT NULL,&lt;br /&gt;
  version int(11) unsigned NOT NULL default '1',&lt;br /&gt;
  parentid int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  metakey text NOT NULL,&lt;br /&gt;
  metadesc text NOT NULL,&lt;br /&gt;
  access int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  hits int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  metadata text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY idx_section (sectionid),&lt;br /&gt;
  KEY idx_access (access),&lt;br /&gt;
  KEY idx_checkout (checked_out),&lt;br /&gt;
  KEY idx_state (state),&lt;br /&gt;
  KEY idx_catid (catid),&lt;br /&gt;
  KEY idx_ Createdby ( Created_by)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_content_frontpage'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_content_frontpage (&lt;br /&gt;
  content_id int(11) NOT NULL default '0',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (content_id)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_content_rating'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_content_rating (&lt;br /&gt;
  content_id int(11) NOT NULL default '0',&lt;br /&gt;
  rating_sum int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  rating_count int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  lastip varchar(50) NOT NULL default '',&lt;br /&gt;
  PRIMARY KEY  (content_id)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_acl_aro'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_acl_aro (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  section_value varchar(240) NOT NULL default '0',&lt;br /&gt;
  `value` varchar(240) NOT NULL default '',&lt;br /&gt;
  order_value int(11) NOT NULL default '0',&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  hidden int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  UNIQUE KEY jos_section_value_value_aro (section_value(100),`value`(100)),&lt;br /&gt;
  KEY jos_gacl_hidden_aro (hidden)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_acl_aro_groups'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_acl_aro_groups (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  parent_id int(11) NOT NULL default '0',&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  lft int(11) NOT NULL default '0',&lt;br /&gt;
  rgt int(11) NOT NULL default '0',&lt;br /&gt;
  `value` varchar(255) NOT NULL default '',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY jos_gacl_parent_id_aro_groups (parent_id),&lt;br /&gt;
  KEY jos_gacl_lft_rgt_aro_groups (lft,rgt)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_acl_aro_map'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_acl_aro_map (&lt;br /&gt;
  acl_id int(11) NOT NULL default '0',&lt;br /&gt;
  section_value varchar(230) NOT NULL default '0',&lt;br /&gt;
  `value` varchar(100) NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (acl_id,section_value,`value`)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_acl_aro_sections'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_acl_aro_sections (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  `value` varchar(230) NOT NULL default '',&lt;br /&gt;
  order_value int(11) NOT NULL default '0',&lt;br /&gt;
  `name` varchar(230) NOT NULL default '',&lt;br /&gt;
  hidden int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  UNIQUE KEY jos_gacl_value_aro_sections (`value`),&lt;br /&gt;
  KEY jos_gacl_hidden_aro_sections (hidden)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_acl_groups_aro_map'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_acl_groups_aro_map (&lt;br /&gt;
  group_id int(11) NOT NULL default '0',&lt;br /&gt;
  section_value varchar(240) NOT NULL default '',&lt;br /&gt;
  aro_id int(11) NOT NULL default '0',&lt;br /&gt;
  UNIQUE KEY group_id_aro_id_groups_aro_map (group_id,section_value,aro_id)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_log_items'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_log_items (&lt;br /&gt;
  time_stamp date NOT NULL default '0000-00-00',&lt;br /&gt;
  item_table varchar(50) NOT NULL default '',&lt;br /&gt;
  item_id int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  hits int(11) unsigned NOT NULL default '0'&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_core_log_searches'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_core_log_searches (&lt;br /&gt;
  search_term varchar(128) NOT NULL default '',&lt;br /&gt;
  hits int(11) unsigned NOT NULL default '0'&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_groups'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_groups (&lt;br /&gt;
  id tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  `name` varchar(50) NOT NULL default '',&lt;br /&gt;
  PRIMARY KEY  (id)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
  -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_menu'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_menu (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  menutype varchar(75) default NULL,&lt;br /&gt;
  `name` varchar(255) default NULL,&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  link text,&lt;br /&gt;
  `type` varchar(50) NOT NULL default '',&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  parent int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  componentid int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  sublevel int(11) default '0',&lt;br /&gt;
  ordering int(11) default '0',&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  pollid int(11) NOT NULL default '0',&lt;br /&gt;
  browserNav tinyint(4) default '0',&lt;br /&gt;
  access tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  utaccess tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  lft int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  rgt int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  home int(1) unsigned NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY componentid (componentid,menutype,published,access),&lt;br /&gt;
  KEY menutype (menutype)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
--&lt;br /&gt;
 -- Table structure for table 'jos_menu_types'&lt;br /&gt;
--&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_menu_types (&lt;br /&gt;
  id int(10) unsigned NOT NULL auto_increment,&lt;br /&gt;
  menutype varchar(75) NOT NULL default '',&lt;br /&gt;
  title varchar(255) NOT NULL default '',&lt;br /&gt;
  description varchar(255) NOT NULL default '',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  UNIQUE KEY menutype (menutype)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_messages'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_messages (&lt;br /&gt;
  message_id int(10) unsigned NOT NULL auto_increment,&lt;br /&gt;
  user_id_from int(10) unsigned NOT NULL default '0',&lt;br /&gt;
  user_id_to int(10) unsigned NOT NULL default '0',&lt;br /&gt;
  folder_id int(10) unsigned NOT NULL default '0',&lt;br /&gt;
  date_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  state int(11) NOT NULL default '0',&lt;br /&gt;
  priority int(1) unsigned NOT NULL default '0',&lt;br /&gt;
  `subject` text NOT NULL,&lt;br /&gt;
  message text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (message_id),&lt;br /&gt;
  KEY useridto_state (user_id_to,state)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_messages_cfg'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_messages_cfg (&lt;br /&gt;
  user_id int(10) unsigned NOT NULL default '0',&lt;br /&gt;
  cfg_name varchar(100) NOT NULL default '',&lt;br /&gt;
  cfg_value varchar(255) NOT NULL default '',&lt;br /&gt;
  UNIQUE KEY idx_user_var_name (user_id,cfg_name)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_migration_backlinks'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_migration_backlinks (&lt;br /&gt;
  itemid int(11) NOT NULL,&lt;br /&gt;
  `name` varchar(100) NOT NULL,&lt;br /&gt;
  url text NOT NULL,&lt;br /&gt;
  sefurl text NOT NULL,&lt;br /&gt;
  newurl text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (itemid)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_modules'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_modules (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  title text NOT NULL,&lt;br /&gt;
  content text NOT NULL,&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  position varchar(50) default NULL,&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  module varchar(50) default NULL,&lt;br /&gt;
  numnews int(11) NOT NULL default '0',&lt;br /&gt;
  access tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  showtitle tinyint(3) unsigned NOT NULL default '1',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  iscore tinyint(4) NOT NULL default '0',&lt;br /&gt;
  client_id tinyint(4) NOT NULL default '0',&lt;br /&gt;
  control text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY published (published,access),&lt;br /&gt;
  KEY newsfeeds (module,published)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_modules_menu'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_modules_menu (&lt;br /&gt;
  moduleid int(11) NOT NULL default '0',&lt;br /&gt;
  menuid int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (moduleid,menuid)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_newsfeeds'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_newsfeeds (&lt;br /&gt;
  catid int(11) NOT NULL default '0',&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  `name` text NOT NULL,&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  link text NOT NULL,&lt;br /&gt;
  filename varchar(200) default NULL,&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  numarticles int(11) unsigned NOT NULL default '1',&lt;br /&gt;
  cache_time int(11) unsigned NOT NULL default '3600',&lt;br /&gt;
  checked_out tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  rtl tinyint(4) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY published (published),&lt;br /&gt;
  KEY catid (catid)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_plugins'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_plugins (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  `name` varchar(100) NOT NULL default '',&lt;br /&gt;
  element varchar(100) NOT NULL default '',&lt;br /&gt;
  folder varchar(100) NOT NULL default '',&lt;br /&gt;
  access tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  published tinyint(3) NOT NULL default '0',&lt;br /&gt;
  iscore tinyint(3) NOT NULL default '0',&lt;br /&gt;
  client_id tinyint(3) NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY idx_folder (published,client_id,access,folder)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_polls'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_polls (&lt;br /&gt;
  id int(11) unsigned NOT NULL auto_increment,&lt;br /&gt;
  title varchar(255) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  voters int(9) NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  access int(11) NOT NULL default '0',&lt;br /&gt;
  lag int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_poll_data'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_poll_data (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  pollid int(11) NOT NULL default '0',&lt;br /&gt;
  `text` text NOT NULL,&lt;br /&gt;
  hits int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY pollid (pollid,`text`(1))&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_poll_date'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_poll_date (&lt;br /&gt;
  id bigint(20) NOT NULL auto_increment,&lt;br /&gt;
  `date` datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  vote_id int(11) NOT NULL default '0',&lt;br /&gt;
  poll_id int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY poll_id (poll_id)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_poll_menu'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_poll_menu (&lt;br /&gt;
  pollid int(11) NOT NULL default '0',&lt;br /&gt;
  menuid int(11) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (pollid,menuid)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_sections'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_sections (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  title varchar(255) NOT NULL default '',&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  image text NOT NULL,&lt;br /&gt;
  scope varchar(50) NOT NULL default '',&lt;br /&gt;
  image_position varchar(30) NOT NULL default '',&lt;br /&gt;
  description text NOT NULL,&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) unsigned NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  access tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  count int(11) NOT NULL default '0',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY idx_scope (scope)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_session'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_session (&lt;br /&gt;
  username varchar(150) default '',&lt;br /&gt;
  `time` varchar(14) default '',&lt;br /&gt;
  session_id varchar(200) NOT NULL default '0',&lt;br /&gt;
  guest tinyint(4) default '1',&lt;br /&gt;
  userid int(11) default '0',&lt;br /&gt;
  usertype varchar(50) default '',&lt;br /&gt;
  gid tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  client_id tinyint(3) unsigned NOT NULL default '0',&lt;br /&gt;
  `data` longtext,&lt;br /&gt;
  PRIMARY KEY  (session_id(64)),&lt;br /&gt;
  KEY whosonline (guest,usertype),&lt;br /&gt;
  KEY userid (userid),&lt;br /&gt;
  KEY `time` (`time`)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_stats_agents'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_stats_agents (&lt;br /&gt;
  agent varchar(255) NOT NULL default '',&lt;br /&gt;
  `type` tinyint(1) unsigned NOT NULL default '0',&lt;br /&gt;
  hits int(11) unsigned NOT NULL default '1'&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_templates_menu'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_templates_menu (&lt;br /&gt;
  template varchar(255) NOT NULL default '',&lt;br /&gt;
  menuid int(11) NOT NULL default '0',&lt;br /&gt;
  client_id tinyint(4) NOT NULL default '0',&lt;br /&gt;
  PRIMARY KEY  (menuid,client_id,template)&lt;br /&gt;
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_users'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_users (&lt;br /&gt;
  id int(11) NOT NULL auto_increment,&lt;br /&gt;
  `name` varchar(255) NOT NULL default '',&lt;br /&gt;
  username varchar(150) NOT NULL default '',&lt;br /&gt;
  email varchar(100) NOT NULL default '',&lt;br /&gt;
  `password` varchar(100) NOT NULL default '',&lt;br /&gt;
  usertype varchar(25) NOT NULL default '',&lt;br /&gt;
  `block` tinyint(4) NOT NULL default '0',&lt;br /&gt;
  sendEmail tinyint(4) default '0',&lt;br /&gt;
  gid tinyint(3) unsigned NOT NULL default '1',&lt;br /&gt;
  registerDate datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  lastvisitDate datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  activation varchar(100) NOT NULL default '',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY usertype (usertype),&lt;br /&gt;
  KEY idx_name (`name`),&lt;br /&gt;
  KEY gid_block (gid,`block`),&lt;br /&gt;
  KEY username (username),&lt;br /&gt;
  KEY email (email)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
 -- --------------------------------------------------------&lt;br /&gt;
&lt;br /&gt;
 --&lt;br /&gt;
 -- Table structure for table 'jos_weblinks'&lt;br /&gt;
 --&lt;br /&gt;
&lt;br /&gt;
 Create TABLE jos_weblinks (&lt;br /&gt;
  id int(11) unsigned NOT NULL auto_increment,&lt;br /&gt;
  catid int(11) NOT NULL default '0',&lt;br /&gt;
  sid int(11) NOT NULL default '0',&lt;br /&gt;
  title varchar(250) NOT NULL default '',&lt;br /&gt;
  alias varchar(255) NOT NULL default '',&lt;br /&gt;
  url varchar(250) NOT NULL default '',&lt;br /&gt;
  description text NOT NULL,&lt;br /&gt;
  `date` datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  hits int(11) NOT NULL default '0',&lt;br /&gt;
  published tinyint(1) NOT NULL default '0',&lt;br /&gt;
  checked_out int(11) NOT NULL default '0',&lt;br /&gt;
  checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',&lt;br /&gt;
  ordering int(11) NOT NULL default '0',&lt;br /&gt;
  archived tinyint(1) NOT NULL default '0',&lt;br /&gt;
  approved tinyint(1) NOT NULL default '1',&lt;br /&gt;
  params text NOT NULL,&lt;br /&gt;
  PRIMARY KEY  (id),&lt;br /&gt;
  KEY catid (catid,published,archived)&lt;br /&gt;
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;/div&gt;</summary>
		<author><name>Elin</name></author>	</entry>

	</feed>