[Sommaire] [Imprimer]

   1  # $Id: joomla.sql 6072 2006-12-20 02:09:09Z robs $
   2  
   3  #
   4  # Table structure for table `#__banner`
   5  #
   6  
   7  CREATE TABLE `#__banner` (
   8    `bid` int(11) NOT NULL auto_increment,
   9    `cid` int(11) NOT NULL default '0',
  10    `type` varchar(10) NOT NULL default 'banner',
  11    `name` varchar(50) NOT NULL default '',
  12    `imptotal` int(11) NOT NULL default '0',
  13    `impmade` int(11) NOT NULL default '0',
  14    `clicks` int(11) NOT NULL default '0',
  15    `imageurl` varchar(100) NOT NULL default '',
  16    `clickurl` varchar(200) NOT NULL default '',
  17    `date` datetime default NULL,
  18    `showBanner` tinyint(1) NOT NULL default '0',
  19    `checked_out` tinyint(1) NOT NULL default '0',
  20    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  21    `editor` varchar(50) default NULL,
  22    `custombannercode` text,
  23    PRIMARY KEY  (`bid`),
  24    KEY `viewbanner` (`showBanner`)
  25  ) TYPE=MyISAM AUTO_INCREMENT=1 ;
  26  
  27  #
  28  # Table structure for table `#__bannerclient`
  29  #
  30  
  31  CREATE TABLE `#__bannerclient` (
  32    `cid` int(11) NOT NULL auto_increment,
  33    `name` varchar(60) NOT NULL default '',
  34    `contact` varchar(60) NOT NULL default '',
  35    `email` varchar(60) NOT NULL default '',
  36    `extrainfo` text NOT NULL,
  37    `checked_out` tinyint(1) NOT NULL default '0',
  38    `checked_out_time` time default NULL,
  39    `editor` varchar(50) default NULL,
  40    PRIMARY KEY  (`cid`)
  41  ) TYPE=MyISAM;
  42  
  43  #
  44  # Table structure for table `#__bannerfinish`
  45  #
  46  
  47  CREATE TABLE `#__bannerfinish` (
  48    `bid` int(11) NOT NULL auto_increment,
  49    `cid` int(11) NOT NULL default '0',
  50    `type` varchar(10) NOT NULL default '',
  51    `name` varchar(50) NOT NULL default '',
  52    `impressions` int(11) NOT NULL default '0',
  53    `clicks` int(11) NOT NULL default '0',
  54    `imageurl` varchar(50) NOT NULL default '',
  55    `datestart` datetime default NULL,
  56    `dateend` datetime default NULL,
  57    PRIMARY KEY  (`bid`)
  58  ) TYPE=MyISAM;
  59  
  60  #
  61  # Table structure for table `#__categories`
  62  #
  63  
  64  CREATE TABLE `#__categories` (
  65    `id` int(11) NOT NULL auto_increment,
  66    `parent_id` int(11) NOT NULL default 0,
  67    `title` varchar(50) NOT NULL default '',
  68    `name` varchar(255) NOT NULL default '',
  69    `image` varchar(100) NOT NULL default '',
  70    `section` varchar(50) NOT NULL default '',
  71    `image_position` varchar(10) NOT NULL default '',
  72    `description` text NOT NULL,
  73    `published` tinyint(1) NOT NULL default '0',
  74    `checked_out` int(11) unsigned NOT NULL default '0',
  75    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  76    `editor` varchar(50) default NULL,
  77    `ordering` int(11) NOT NULL default '0',
  78    `access` tinyint(3) unsigned NOT NULL default '0',
  79    `count` int(11) NOT NULL default '0',
  80    `params` text NOT NULL,
  81    PRIMARY KEY  (`id`),
  82    KEY `cat_idx` (`section`,`published`,`access`),
  83    KEY `idx_section` (`section`),
  84    KEY `idx_access` (`access`),
  85    KEY `idx_checkout` (`checked_out`)
  86  ) TYPE=MyISAM;
  87  
  88  #
  89  # Table structure for table `#__components`
  90  #
  91  
  92  CREATE TABLE `#__components` (
  93    `id` int(11) NOT NULL auto_increment,
  94    `name` varchar(50) NOT NULL default '',
  95    `link` varchar(255) NOT NULL default '',
  96    `menuid` int(11) unsigned NOT NULL default '0',
  97    `parent` int(11) unsigned NOT NULL default '0',
  98    `admin_menu_link` varchar(255) NOT NULL default '',
  99    `admin_menu_alt` varchar(255) NOT NULL default '',
 100    `option` varchar(50) NOT NULL default '',
 101    `ordering` int(11) NOT NULL default '0',
 102    `admin_menu_img` varchar(255) NOT NULL default '',
 103    `iscore` tinyint(4) NOT NULL default '0',
 104    `params` text NOT NULL,
 105    PRIMARY KEY  (`id`)
 106  ) TYPE=MyISAM;
 107  
 108  #
 109  # Dumping data for table `#__components`
 110  #
 111  
 112  INSERT INTO `#__components` VALUES (1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '');
 113  INSERT INTO `#__components` VALUES (2, 'Manage Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '');
 114  INSERT INTO `#__components` VALUES (3, 'Manage Clients', '', 0, 1, 'option=com_banners&task=listclients', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '');
 115  INSERT INTO `#__components` VALUES (4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, '');
 116  INSERT INTO `#__components` VALUES (5, 'Web Link Items', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '');
 117  INSERT INTO `#__components` VALUES (6, 'Web Link Categories', '', 0, 4, 'option=categories&section=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '');
 118  INSERT INTO `#__components` VALUES (7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '');
 119  INSERT INTO `#__components` VALUES (8, 'Manage Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '');
 120  INSERT INTO `#__components` VALUES (9, 'Contact Categories', '', 0, 7, 'option=categories&section=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '');
 121  INSERT INTO `#__components` VALUES (10, 'Front Page', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '');
 122  INSERT INTO `#__components` VALUES (11, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '');
 123  INSERT INTO `#__components` VALUES (12, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '');
 124  INSERT INTO `#__components` VALUES (13, 'Manage News Feeds', '', 0, 12, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '');
 125  INSERT INTO `#__components` VALUES (14, 'Manage Categories', '', 0, 12, 'option=com_categories&section=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '');
 126  INSERT INTO `#__components` VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '');
 127  INSERT INTO `#__components` VALUES (16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '');
 128  INSERT INTO `#__components` VALUES (17, 'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Manage Syndication Settings','com_syndicate',0,'js/ThemeOffice/component.png',0,'');
 129  INSERT INTO `#__components` VALUES (18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Send Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, '');
 130  # --------------------------------------------------------
 131  
 132  #
 133  # Table structure for table `#__contact_details`
 134  #
 135  
 136  CREATE TABLE `#__contact_details` (
 137    `id` int(11) NOT NULL auto_increment,
 138    `name` varchar(100) NOT NULL default '',
 139    `con_position` varchar(50) default NULL,
 140    `address` text,
 141    `suburb` varchar(50) default NULL,
 142    `state` varchar(20) default NULL,
 143    `country` varchar(50) default NULL,
 144    `postcode` varchar(10) default NULL,
 145    `telephone` varchar(25) default NULL,
 146    `fax` varchar(25) default NULL,
 147    `misc` mediumtext,
 148    `image` varchar(100) default NULL,
 149    `imagepos` varchar(20) default NULL,
 150    `email_to` varchar(100) default NULL,
 151    `default_con` tinyint(1) unsigned NOT NULL default '0',
 152    `published` tinyint(1) unsigned NOT NULL default '0',
 153    `checked_out` int(11) unsigned NOT NULL default '0',
 154    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 155    `ordering` int(11) NOT NULL default '0',
 156    `params` text NOT NULL,
 157    `user_id` int(11) NOT NULL default '0',
 158    `catid` int(11) NOT NULL default '0',
 159    `access` tinyint(3) unsigned NOT NULL default '0',
 160    PRIMARY KEY  (`id`)
 161  ) TYPE=MyISAM;
 162  
 163  #
 164  # Table structure for table `#__content`
 165  #
 166  
 167  CREATE TABLE `#__content` (
 168    `id` int(11) unsigned NOT NULL auto_increment,
 169    `title` varchar(100) NOT NULL default '',
 170    `title_alias` varchar(100) NOT NULL default '',
 171    `introtext` mediumtext NOT NULL,
 172    `fulltext` mediumtext NOT NULL,
 173    `state` tinyint(3) NOT NULL default '0',
 174    `sectionid` int(11) unsigned NOT NULL default '0',
 175    `mask` int(11) unsigned NOT NULL default '0',
 176    `catid` int(11) unsigned NOT NULL default '0',
 177    `created` datetime NOT NULL default '0000-00-00 00:00:00',
 178    `created_by` int(11) unsigned NOT NULL default '0',
 179    `created_by_alias` varchar(100) NOT NULL default '',
 180    `modified` datetime NOT NULL default '0000-00-00 00:00:00',
 181    `modified_by` int(11) unsigned NOT NULL default '0',
 182    `checked_out` int(11) unsigned NOT NULL default '0',
 183    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 184    `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
 185    `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
 186    `images` text NOT NULL,
 187    `urls` text NOT NULL,
 188    `attribs` text NOT NULL,
 189    `version` int(11) unsigned NOT NULL default '1',
 190    `parentid` int(11) unsigned NOT NULL default '0',
 191    `ordering` int(11) NOT NULL default '0',
 192    `metakey` text NOT NULL,
 193    `metadesc` text NOT NULL,
 194    `access` int(11) unsigned NOT NULL default '0',
 195    `hits` int(11) unsigned NOT NULL default '0',
 196    PRIMARY KEY  (`id`),
 197    KEY `idx_section` (`sectionid`),
 198    KEY `idx_access` (`access`),
 199    KEY `idx_checkout` (`checked_out`),
 200    KEY `idx_state` (`state`),
 201    KEY `idx_catid` (`catid`),
 202    KEY `idx_mask` (`mask`)
 203  ) TYPE=MyISAM;
 204  
 205  #
 206  # Table structure for table `#__content_frontpage`
 207  #
 208  
 209  CREATE TABLE `#__content_frontpage` (
 210    `content_id` int(11) NOT NULL default '0',
 211    `ordering` int(11) NOT NULL default '0',
 212    PRIMARY KEY  (`content_id`)
 213  ) TYPE=MyISAM;
 214  
 215  #
 216  # Table structure for table `#__content_rating`
 217  #
 218  
 219  CREATE TABLE `#__content_rating` (
 220    `content_id` int(11) NOT NULL default '0',
 221    `rating_sum` int(11) unsigned NOT NULL default '0',
 222    `rating_count` int(11) unsigned NOT NULL default '0',
 223    `lastip` varchar(50) NOT NULL default '',
 224    PRIMARY KEY  (`content_id`)
 225  ) TYPE=MyISAM;
 226  
 227  #
 228  # Table structure for table `#__core_log_items`
 229  #
 230  # To be implemented
 231  
 232  CREATE TABLE `#__core_log_items` (
 233    `time_stamp` date NOT NULL default '0000-00-00',
 234    `item_table` varchar(50) NOT NULL default '',
 235    `item_id` int(11) unsigned NOT NULL default '0',
 236    `hits` int(11) unsigned NOT NULL default '0'
 237  ) TYPE=MyISAM;
 238  
 239  #
 240  # Table structure for table `#__core_log_searches`
 241  #
 242  # To be implemented
 243  
 244  CREATE TABLE `#__core_log_searches` (
 245    `search_term` varchar(128) NOT NULL default '',
 246    `hits` int(11) unsigned NOT NULL default '0'
 247  ) TYPE=MyISAM;
 248  
 249  #
 250  # Table structure for table `#__groups`
 251  #
 252  
 253  CREATE TABLE `#__groups` (
 254    `id` tinyint(3) unsigned NOT NULL default '0',
 255    `name` varchar(50) NOT NULL default '',
 256    PRIMARY KEY  (`id`)
 257  ) TYPE=MyISAM;
 258  
 259  #
 260  # Dumping data for table `#__groups`
 261  #
 262  
 263  INSERT INTO `#__groups` VALUES (0, 'Public');
 264  INSERT INTO `#__groups` VALUES (1, 'Registered');
 265  INSERT INTO `#__groups` VALUES (2, 'Special');
 266  # --------------------------------------------------------
 267  
 268  #
 269  # Table structure for table `#__mambots`
 270  #
 271  
 272  CREATE TABLE `#__mambots` (
 273    `id` int(11) NOT NULL auto_increment,
 274    `name` varchar(100) NOT NULL default '',
 275    `element` varchar(100) NOT NULL default '',
 276    `folder` varchar(100) NOT NULL default '',
 277    `access` tinyint(3) unsigned NOT NULL default '0',
 278    `ordering` int(11) NOT NULL default '0',
 279    `published` tinyint(3) NOT NULL default '0',
 280    `iscore` tinyint(3) NOT NULL default '0',
 281    `client_id` tinyint(3) NOT NULL default '0',
 282    `checked_out` int(11) unsigned NOT NULL default '0',
 283    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 284    `params` text NOT NULL,
 285    PRIMARY KEY  (`id`),
 286    KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
 287  ) TYPE=MyISAM;
 288  
 289  INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
 290  INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','');
 291  INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','');
 292  INSERT INTO `#__mambots` VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
 293  INSERT INTO `#__mambots` VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
 294  INSERT INTO `#__mambots` VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','');
 295  INSERT INTO `#__mambots` VALUES (7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','');
 296  INSERT INTO `#__mambots` VALUES (8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00','');
 297  INSERT INTO `#__mambots` VALUES (9,'No WYSIWYG Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','');
 298  INSERT INTO `#__mambots` VALUES (10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced');
 299  INSERT INTO `#__mambots` VALUES (11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
 300  INSERT INTO `#__mambots` VALUES (12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
 301  INSERT INTO `#__mambots` VALUES (13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','');
 302  INSERT INTO `#__mambots` VALUES (14, 'Search Categories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 303  INSERT INTO `#__mambots` VALUES (15, 'Search Sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 304  INSERT INTO `#__mambots` VALUES (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 305  INSERT INTO `#__mambots` VALUES (17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', '');
 306  INSERT INTO `#__mambots` VALUES (18, 'Search Newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 307  INSERT INTO `#__mambots` VALUES (19, 'Load Module Positions', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 308  # --------------------------------------------------------
 309  
 310  #
 311  # Table structure for table `#__menu`
 312  #
 313  
 314  CREATE TABLE `#__menu` (
 315    `id` int(11) NOT NULL auto_increment,
 316    `menutype` varchar(25) default NULL,
 317    `name` varchar(100) default NULL,
 318    `link` text,
 319    `type` varchar(50) NOT NULL default '',
 320    `published` tinyint(1) NOT NULL default '0',
 321    `parent` int(11) unsigned NOT NULL default '0',
 322    `componentid` int(11) unsigned NOT NULL default '0',
 323    `sublevel` int(11) default '0',
 324    `ordering` int(11) default '0',
 325    `checked_out` int(11) unsigned NOT NULL default '0',
 326    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 327    `pollid` int(11) NOT NULL default '0',
 328    `browserNav` tinyint(4) default '0',
 329    `access` tinyint(3) unsigned NOT NULL default '0',
 330    `utaccess` tinyint(3) unsigned NOT NULL default '0',
 331    `params` text NOT NULL,
 332    PRIMARY KEY  (`id`),
 333    KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
 334    KEY `menutype` (`menutype`)
 335  ) TYPE=MyISAM;
 336  
 337  INSERT INTO `#__menu` VALUES (1, 'mainmenu', 'Home', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Welcome to the Frontpage\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0');
 338  # --------------------------------------------------------
 339  
 340  #
 341  # Table structure for table `#__messages`
 342  #
 343  
 344  CREATE TABLE `#__messages` (
 345    `message_id` int(10) unsigned NOT NULL auto_increment,
 346    `user_id_from` int(10) unsigned NOT NULL default '0',
 347    `user_id_to` int(10) unsigned NOT NULL default '0',
 348    `folder_id` int(10) unsigned NOT NULL default '0',
 349    `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
 350    `state` int(11) NOT NULL default '0',
 351    `priority` int(1) unsigned NOT NULL default '0',
 352    `subject` varchar(230) NOT NULL default '',
 353    `message` text NOT NULL,
 354    PRIMARY KEY  (`message_id`)
 355  ) TYPE=MyISAM;
 356  
 357  #
 358  # Table structure for table `#__messages_cfg`
 359  #
 360  
 361  CREATE TABLE `#__messages_cfg` (
 362    `user_id` int(10) unsigned NOT NULL default '0',
 363    `cfg_name` varchar(100) NOT NULL default '',
 364    `cfg_value` varchar(255) NOT NULL default '',
 365    UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
 366  ) TYPE=MyISAM;
 367  
 368  #
 369  # Table structure for table `#__modules`
 370  #
 371  
 372  CREATE TABLE `#__modules` (
 373    `id` int(11) NOT NULL auto_increment,
 374    `title` text NOT NULL,
 375    `content` text NOT NULL,
 376    `ordering` int(11) NOT NULL default '0',
 377    `position` varchar(10) default NULL,
 378    `checked_out` int(11) unsigned NOT NULL default '0',
 379    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 380    `published` tinyint(1) NOT NULL default '0',
 381    `module` varchar(50) default NULL,
 382    `numnews` int(11) NOT NULL default '0',
 383    `access` tinyint(3) unsigned NOT NULL default '0',
 384    `showtitle` tinyint(3) unsigned NOT NULL default '1',
 385    `params` text NOT NULL,
 386    `iscore` tinyint(4) NOT NULL default '0',
 387    `client_id` tinyint(4) NOT NULL default '0',
 388    PRIMARY KEY  (`id`),
 389    KEY `published` (`published`,`access`),
 390    KEY `newsfeeds` (`module`,`published`)
 391  ) TYPE=MyISAM;
 392  
 393  #
 394  # Dumping data for table `#__modules`
 395  #
 396  
 397  INSERT INTO `#__modules` VALUES (0, 'Polls', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_poll', 0, 0, 1, '', 0, 0);
 398  INSERT INTO `#__modules` VALUES (0, 'User Menu', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0);
 399  INSERT INTO `#__modules` VALUES (0, 'Main Menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu', 1, 0);
 400  INSERT INTO `#__modules` VALUES (0, 'Login Form', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 0);
 401  INSERT INTO `#__modules` VALUES (0, 'Syndicate', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_rssfeed', 0, 0, 1, '', 1, 0);
 402  INSERT INTO `#__modules` VALUES (0, 'Latest News', '', 4, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, '', 1, 0);
 403  INSERT INTO `#__modules` VALUES (0, 'Statistics', '', 4, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_stats', 0, 0, 1, 'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=', 0, 0);
 404  INSERT INTO `#__modules` VALUES (0, 'Who\'s Online', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0);
 405  INSERT INTO `#__modules` VALUES (0, 'Popular', '', 6, 'user2', 0, '0000-00-00 00:00:00', 1, 'mod_mostread', 0, 0, 1, '', 0, 0);
 406  INSERT INTO `#__modules` VALUES (0, 'Template Chooser','',6,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser', 0, 0, 1, 'show_preview=1', 0, 0);
 407  INSERT INTO `#__modules` VALUES (0, 'Archive', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0);
 408  INSERT INTO `#__modules` VALUES (0, 'Sections', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0);
 409  INSERT INTO `#__modules` VALUES (0, 'Newsflash', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0);
 410  INSERT INTO `#__modules` VALUES (0, 'Related Items', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0);
 411  INSERT INTO `#__modules` VALUES (0, 'Search', '', 1, 'user4', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, '', 0, 0);
 412  INSERT INTO `#__modules` VALUES (0, 'Random Image', '', 9, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 0, 0);
 413  INSERT INTO `#__modules` VALUES (0, 'Top Menu', '', 1, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0', 1, 0);
 414  INSERT INTO `#__modules` VALUES (0, 'Banners', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0);
 415  INSERT INTO `#__modules` VALUES (0,'Components','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',1, 1);
 416  INSERT INTO `#__modules` VALUES (0,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',0, 1);
 417  INSERT INTO `#__modules` VALUES (0,'Latest Items','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',0, 1);
 418  INSERT INTO `#__modules` VALUES (0,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',0, 1);
 419  INSERT INTO `#__modules` VALUES (0,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',1, 1);
 420  INSERT INTO `#__modules` VALUES (0,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',1, 1);
 421  INSERT INTO `#__modules` VALUES (0,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',1, 1);
 422  INSERT INTO `#__modules` VALUES (0,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',1, 1);
 423  INSERT INTO `#__modules` VALUES (0,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',1, 1);
 424  INSERT INTO `#__modules` VALUES (0,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',1, 1);
 425  INSERT INTO `#__modules` VALUES (0,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1);
 426  INSERT INTO `#__modules` VALUES (0, 'Other Menu', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=othermenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=', 0, 0);
 427  INSERT INTO `#__modules` VALUES (0,'Wrapper','',10,'left',0,'0000-00-00 00:00:00',0,'mod_wrapper',0,0,1,'',0, 0);
 428  INSERT INTO `#__modules` VALUES (0,'Logged','',0,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,99,1,'',0,1);
 429  
 430  # --------------------------------------------------------
 431  
 432  #
 433  # Table structure for table `#__modules_menu`
 434  #
 435  
 436  CREATE TABLE `#__modules_menu` (
 437    `moduleid` int(11) NOT NULL default '0',
 438    `menuid` int(11) NOT NULL default '0',
 439    PRIMARY KEY  (`moduleid`,`menuid`)
 440  ) TYPE=MyISAM;
 441  
 442  #
 443  # Dumping data for table `#__modules_menu`
 444  #
 445  
 446  INSERT INTO `#__modules_menu` VALUES (1,1);
 447  INSERT INTO `#__modules_menu` VALUES (2,0);
 448  INSERT INTO `#__modules_menu` VALUES (3,0);
 449  INSERT INTO `#__modules_menu` VALUES (4,1);
 450  INSERT INTO `#__modules_menu` VALUES (5,1);
 451  INSERT INTO `#__modules_menu` VALUES (6,1);
 452  INSERT INTO `#__modules_menu` VALUES (6,2);
 453  INSERT INTO `#__modules_menu` VALUES (6,4);
 454  INSERT INTO `#__modules_menu` VALUES (6,27);
 455  INSERT INTO `#__modules_menu` VALUES (6,36);
 456  INSERT INTO `#__modules_menu` VALUES (8,1);
 457  INSERT INTO `#__modules_menu` VALUES (9,1);
 458  INSERT INTO `#__modules_menu` VALUES (9,2);
 459  INSERT INTO `#__modules_menu` VALUES (9,4);
 460  INSERT INTO `#__modules_menu` VALUES (9,27);
 461  INSERT INTO `#__modules_menu` VALUES (9,36);
 462  INSERT INTO `#__modules_menu` VALUES (10,1);
 463  INSERT INTO `#__modules_menu` VALUES (13,0);
 464  INSERT INTO `#__modules_menu` VALUES (15,0);
 465  INSERT INTO `#__modules_menu` VALUES (17,0);
 466  INSERT INTO `#__modules_menu` VALUES (18,0);
 467  INSERT INTO `#__modules_menu` VALUES (30,0);
 468  
 469  # --------------------------------------------------------
 470  
 471  #
 472  # Table structure for table `#__newsfeeds`
 473  #
 474  
 475  CREATE TABLE `#__newsfeeds` (
 476    `catid` int(11) NOT NULL default '0',
 477    `id` int(11) NOT NULL auto_increment,
 478    `name` text NOT NULL,
 479    `link` text NOT NULL,
 480    `filename` varchar(200) default NULL,
 481    `published` tinyint(1) NOT NULL default '0',
 482    `numarticles` int(11) unsigned NOT NULL default '1',
 483    `cache_time` int(11) unsigned NOT NULL default '3600',
 484    `checked_out` tinyint(3) unsigned NOT NULL default '0',
 485    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 486    `ordering` int(11) NOT NULL default '0',
 487    PRIMARY KEY  (`id`),
 488    KEY `published` (`published`)
 489  ) TYPE=MyISAM;
 490  
 491  #
 492  # Table structure for table `#__poll_data`
 493  #
 494  
 495  CREATE TABLE `#__poll_data` (
 496    `id` int(11) NOT NULL auto_increment,
 497    `pollid` int(4) NOT NULL default '0',
 498    `text` text NOT NULL,
 499    `hits` int(11) NOT NULL default '0',
 500    PRIMARY KEY  (`id`),
 501    KEY `pollid` (`pollid`,`text`(1))
 502  ) TYPE=MyISAM;
 503  
 504  #
 505  # Table structure for table `#__poll_date`
 506  #
 507  
 508  CREATE TABLE `#__poll_date` (
 509    `id` bigint(20) NOT NULL auto_increment,
 510    `date` datetime NOT NULL default '0000-00-00 00:00:00',
 511    `vote_id` int(11) NOT NULL default '0',
 512    `poll_id` int(11) NOT NULL default '0',
 513    PRIMARY KEY  (`id`),
 514    KEY `poll_id` (`poll_id`)
 515  ) TYPE=MyISAM;
 516  
 517  #
 518  # Table structure for table `#__polls`
 519  #
 520  
 521  CREATE TABLE `#__polls` (
 522    `id` int(11) unsigned NOT NULL auto_increment,
 523    `title` varchar(100) NOT NULL default '',
 524    `voters` int(9) NOT NULL default '0',
 525    `checked_out` int(11) NOT NULL default '0',
 526    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 527    `published` tinyint(1) NOT NULL default '0',
 528    `access` int(11) NOT NULL default '0',
 529    `lag` int(11) NOT NULL default '0',
 530    PRIMARY KEY  (`id`)
 531  ) TYPE=MyISAM;
 532  
 533  #
 534  # Table structure for table `#__poll_menu`
 535  #
 536  
 537  CREATE TABLE `#__poll_menu` (
 538    `pollid` int(11) NOT NULL default '0',
 539    `menuid` int(11) NOT NULL default '0',
 540    PRIMARY KEY  (`pollid`,`menuid`)
 541  ) TYPE=MyISAM;
 542  
 543  #
 544  # Table structure for table `#__sections`
 545  #
 546  
 547  CREATE TABLE `#__sections` (
 548    `id` int(11) NOT NULL auto_increment,
 549    `title` varchar(50) NOT NULL default '',
 550    `name` varchar(255) NOT NULL default '',
 551    `image` varchar(100) NOT NULL default '',
 552    `scope` varchar(50) NOT NULL default '',
 553    `image_position` varchar(10) NOT NULL default '',
 554    `description` text NOT NULL,
 555    `published` tinyint(1) NOT NULL default '0',
 556    `checked_out` int(11) unsigned NOT NULL default '0',
 557    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 558    `ordering` int(11) NOT NULL default '0',
 559    `access` tinyint(3) unsigned NOT NULL default '0',
 560    `count` int(11) NOT NULL default '0',
 561    `params` text NOT NULL,
 562    PRIMARY KEY  (`id`),
 563    KEY `idx_scope` (`scope`)
 564  ) TYPE=MyISAM;
 565  
 566  #
 567  # Table structure for table `#__session`
 568  #
 569  
 570  CREATE TABLE `#__session` (
 571    `username` varchar(50) default '',
 572    `time` varchar(14) default '',
 573    `session_id` varchar(200) NOT NULL default '0',
 574    `guest` tinyint(4) default '1',
 575    `userid` int(11) default '0',
 576    `usertype` varchar(50) default '',
 577    `gid` tinyint(3) unsigned NOT NULL default '0',
 578    PRIMARY KEY  (`session_id`),
 579    KEY `whosonline` (`guest`,`usertype`)
 580  ) TYPE=MyISAM;
 581  
 582  #
 583  # Table structure for table `#__stats_agents`
 584  #
 585  
 586  CREATE TABLE `#__stats_agents` (
 587    `agent` varchar(255) NOT NULL default '',
 588    `type` tinyint(1) unsigned NOT NULL default '0',
 589    `hits` int(11) unsigned NOT NULL default '1'
 590  ) TYPE=MyISAM;
 591  
 592  #
 593  # Table structure for table `#__templates_menu`
 594  #
 595  
 596  CREATE TABLE `#__templates_menu` (
 597    `template` varchar(50) NOT NULL default '',
 598    `menuid` int(11) NOT NULL default '0',
 599    `client_id` tinyint(4) NOT NULL default '0',
 600    PRIMARY KEY  (`template`,`menuid`)
 601  ) TYPE=MyISAM;
 602  
 603  # Dumping data for table `#__templates_menu`
 604  
 605  INSERT INTO `#__templates_menu` VALUES ('rhuk_solarflare_ii', '0', '0');
 606  INSERT INTO `#__templates_menu` VALUES ('joomla_admin', '0', '1');
 607  
 608  # --------------------------------------------------------
 609  
 610  #
 611  # Table structure for table `#__template_positions`
 612  #
 613  
 614  CREATE TABLE `#__template_positions` (
 615    `id` int(11) NOT NULL auto_increment,
 616    `position` varchar(10) NOT NULL default '',
 617    `description` varchar(255) NOT NULL default '',
 618    PRIMARY KEY  (`id`)
 619  ) TYPE=MyISAM;
 620  
 621  #
 622  # Dumping data for table `#__template_positions`
 623  #
 624  
 625  INSERT INTO `#__template_positions` VALUES (0, 'left', '');
 626  INSERT INTO `#__template_positions` VALUES (0, 'right', '');
 627  INSERT INTO `#__template_positions` VALUES (0, 'top', '');
 628  INSERT INTO `#__template_positions` VALUES (0, 'bottom', '');
 629  INSERT INTO `#__template_positions` VALUES (0, 'inset', '');
 630  INSERT INTO `#__template_positions` VALUES (0, 'banner', '');
 631  INSERT INTO `#__template_positions` VALUES (0, 'header', '');
 632  INSERT INTO `#__template_positions` VALUES (0, 'footer', '');
 633  INSERT INTO `#__template_positions` VALUES (0, 'newsflash', '');
 634  INSERT INTO `#__template_positions` VALUES (0, 'legals', '');
 635  INSERT INTO `#__template_positions` VALUES (0, 'pathway', '');
 636  INSERT INTO `#__template_positions` VALUES (0, 'toolbar', '');
 637  INSERT INTO `#__template_positions` VALUES (0, 'cpanel', '');
 638  INSERT INTO `#__template_positions` VALUES (0, 'user1', '');
 639  INSERT INTO `#__template_positions` VALUES (0, 'user2', '');
 640  INSERT INTO `#__template_positions` VALUES (0, 'user3', '');
 641  INSERT INTO `#__template_positions` VALUES (0, 'user4', '');
 642  INSERT INTO `#__template_positions` VALUES (0, 'user5', '');
 643  INSERT INTO `#__template_positions` VALUES (0, 'user6', '');
 644  INSERT INTO `#__template_positions` VALUES (0, 'user7', '');
 645  INSERT INTO `#__template_positions` VALUES (0, 'user8', '');
 646  INSERT INTO `#__template_positions` VALUES (0, 'user9', '');
 647  INSERT INTO `#__template_positions` VALUES (0, 'advert1', '');
 648  INSERT INTO `#__template_positions` VALUES (0, 'advert2', '');
 649  INSERT INTO `#__template_positions` VALUES (0, 'advert3', '');
 650  INSERT INTO `#__template_positions` VALUES (0, 'icon', '');
 651  INSERT INTO `#__template_positions` VALUES (0, 'debug', '');
 652  # --------------------------------------------------------
 653  
 654  #
 655  # Table structure for table `#__users`
 656  #
 657  
 658  CREATE TABLE `#__users` (
 659    `id` int(11) NOT NULL auto_increment,
 660    `name` varchar(50) NOT NULL default '',
 661    `username` varchar(25) NOT NULL default '',
 662    `email` varchar(100) NOT NULL default '',
 663    `password` varchar(100) NOT NULL default '',
 664    `usertype` varchar(25) NOT NULL default '',
 665    `block` tinyint(4) NOT NULL default '0',
 666    `sendEmail` tinyint(4) default '0',
 667    `gid` tinyint(3) unsigned NOT NULL default '1',
 668    `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
 669    `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
 670    `activation` varchar(100) NOT NULL default '',
 671    `params` text NOT NULL,
 672    PRIMARY KEY  (`id`),
 673    KEY `usertype` (`usertype`),
 674    KEY `idx_name` (`name`)
 675  ) TYPE=MyISAM;
 676  
 677  #
 678  # Table structure for table `#__usertypes`
 679  #
 680  
 681  CREATE TABLE `#__usertypes` (
 682    `id` tinyint(3) unsigned NOT NULL default '0',
 683    `name` varchar(50) NOT NULL default '',
 684    `mask` varchar(11) NOT NULL default '',
 685    PRIMARY KEY  (`id`)
 686  ) TYPE=MyISAM;
 687  
 688  #
 689  # Dumping data for table `#__usertypes`
 690  #
 691  
 692  INSERT INTO `#__usertypes` VALUES (0, 'superadministrator', '');
 693  INSERT INTO `#__usertypes` VALUES (1, 'administrator', '');
 694  INSERT INTO `#__usertypes` VALUES (2, 'editor', '');
 695  INSERT INTO `#__usertypes` VALUES (3, 'user', '');
 696  INSERT INTO `#__usertypes` VALUES (4, 'author', '');
 697  INSERT INTO `#__usertypes` VALUES (5, 'publisher', '');
 698  INSERT INTO `#__usertypes` VALUES (6, 'manager', '');
 699  # --------------------------------------------------------
 700  
 701  #
 702  # Table structure for table `#__weblinks`
 703  #
 704  
 705  CREATE TABLE `#__weblinks` (
 706    `id` int(11) unsigned NOT NULL auto_increment,
 707    `catid` int(11) NOT NULL default '0',
 708    `sid` int(11) NOT NULL default '0',
 709    `title` varchar(250) NOT NULL default '',
 710    `url` varchar(250) NOT NULL default '',
 711    `description` varchar(250) NOT NULL default '',
 712    `date` datetime NOT NULL default '0000-00-00 00:00:00',
 713    `hits` int(11) NOT NULL default '0',
 714    `published` tinyint(1) NOT NULL default '0',
 715    `checked_out` int(11) NOT NULL default '0',
 716    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 717    `ordering` int(11) NOT NULL default '0',
 718    `archived` tinyint(1) NOT NULL default '0',
 719    `approved` tinyint(1) NOT NULL default '1',
 720    `params` text NOT NULL,
 721    PRIMARY KEY  (`id`),
 722    KEY `catid` (`catid`,`published`,`archived`)
 723  ) TYPE=MyISAM;
 724  
 725  #
 726  # Table structure for table `#__core_acl_aro`
 727  #
 728  
 729  CREATE TABLE `#__core_acl_aro` (
 730    `aro_id` int(11) NOT NULL auto_increment,
 731    `section_value` varchar(240) NOT NULL default '0',
 732    `value` varchar(240) NOT NULL default '',
 733    `order_value` int(11) NOT NULL default '0',
 734    `name` varchar(255) NOT NULL default '',
 735    `hidden` int(11) NOT NULL default '0',
 736    PRIMARY KEY  (`aro_id`),
 737    UNIQUE KEY `#__gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
 738    KEY `#__gacl_hidden_aro` (`hidden`)
 739  ) TYPE=MyISAM;
 740  
 741  #
 742  # Table structure for table `#__core_acl_aro_groups`
 743  #
 744  CREATE TABLE `#__core_acl_aro_groups` (
 745    `group_id` int(11) NOT NULL auto_increment,
 746    `parent_id` int(11) NOT NULL default '0',
 747    `name` varchar(255) NOT NULL default '',
 748    `lft` int(11) NOT NULL default '0',
 749    `rgt` int(11) NOT NULL default '0',
 750    PRIMARY KEY  (`group_id`),
 751    KEY `parent_id_aro_groups` (`parent_id`),
 752    KEY `#__gacl_parent_id_aro_groups` (`parent_id`),
 753    KEY `#__gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
 754  ) TYPE=MyISAM;
 755  
 756  #
 757  # Dumping data for table `#__core_acl_aro_groups`
 758  #
 759  INSERT INTO `#__core_acl_aro_groups` VALUES (17,0,'ROOT',1,22);
 760  INSERT INTO `#__core_acl_aro_groups` VALUES (28,17,'USERS',2,21);
 761  INSERT INTO `#__core_acl_aro_groups` VALUES (29,28,'Public Frontend',3,12);
 762  INSERT INTO `#__core_acl_aro_groups` VALUES (18,29,'Registered',4,11);
 763  INSERT INTO `#__core_acl_aro_groups` VALUES (19,18,'Author',5,10);
 764  INSERT INTO `#__core_acl_aro_groups` VALUES (20,19,'Editor',6,9);
 765  INSERT INTO `#__core_acl_aro_groups` VALUES (21,20,'Publisher',7,8);
 766  INSERT INTO `#__core_acl_aro_groups` VALUES (30,28,'Public Backend',13,20);
 767  INSERT INTO `#__core_acl_aro_groups` VALUES (23,30,'Manager',14,19);
 768  INSERT INTO `#__core_acl_aro_groups` VALUES (24,23,'Administrator',15,18);
 769  INSERT INTO `#__core_acl_aro_groups` VALUES (25,24,'Super Administrator',16,17);
 770  
 771  #
 772  # Table structure for table `#__core_acl_groups_aro_map`
 773  #
 774  CREATE TABLE `#__core_acl_groups_aro_map` (
 775    `group_id` int(11) NOT NULL default '0',
 776    `section_value` varchar(240) NOT NULL default '',
 777    `aro_id` int(11) NOT NULL default '0',
 778    UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
 779  ) TYPE=MyISAM;
 780  
 781  #
 782  # Table structure for table `#__core_acl_aro_sections`
 783  #
 784  CREATE TABLE `#__core_acl_aro_sections` (
 785    `section_id` int(11) NOT NULL auto_increment,
 786    `value` varchar(230) NOT NULL default '',
 787    `order_value` int(11) NOT NULL default '0',
 788    `name` varchar(230) NOT NULL default '',
 789    `hidden` int(11) NOT NULL default '0',
 790    PRIMARY KEY  (`section_id`),
 791    UNIQUE KEY `value_aro_sections` (`value`),
 792    UNIQUE KEY `#__gacl_value_aro_sections` (`value`),
 793    KEY `hidden_aro_sections` (`hidden`),
 794    KEY `#__gacl_hidden_aro_sections` (`hidden`)
 795  ) TYPE=MyISAM;
 796  
 797  INSERT INTO `#__core_acl_aro_sections` VALUES (10,'users',1,'Users',0);