Mambo API

[Summary view] [Print] [Text view]

   1  #

   2  # Table structure for table `#__categories`

   3  #

   4  
   5  CREATE TABLE `#__categories` (
   6    `id` int(11) NOT NULL auto_increment,
   7    `parent_id` int(11) NOT NULL default 0,
   8    `title` varchar(50) NOT NULL default '',
   9    `name` varchar(255) NOT NULL default '',
  10    `image` varchar(100) NOT NULL default '',
  11    `section` varchar(50) NOT NULL default '',
  12    `image_position` varchar(10) NOT NULL default '',
  13    `description` text NOT NULL,
  14    `published` tinyint(1) NOT NULL default '0',
  15    `checked_out` int(11) unsigned NOT NULL default '0',
  16    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  17    `editor` varchar(50) default NULL,
  18    `ordering` int(11) NOT NULL default '0',
  19    `access` tinyint(3) unsigned NOT NULL default '0',
  20    `count` int(11) NOT NULL default '0',
  21    `params` text NOT NULL,
  22    PRIMARY KEY  (`id`),
  23    KEY `cat_idx` (`section`,`published`,`access`),
  24    KEY `idx_section` (`section`),
  25    KEY `idx_access` (`access`),
  26    KEY `idx_checkout` (`checked_out`)
  27  ) TYPE=MyISAM;
  28  
  29  #

  30  # Table structure for table `#__components`

  31  #

  32  
  33  CREATE TABLE `#__components` (
  34    `id` int(11) NOT NULL auto_increment,
  35    `name` varchar(50) NOT NULL default '',
  36    `link` varchar(255) NOT NULL default '',
  37    `menuid` int(11) unsigned NOT NULL default '0',
  38    `parent` int(11) unsigned NOT NULL default '0',
  39    `admin_menu_link` varchar(255) NOT NULL default '',
  40    `admin_menu_alt` varchar(255) NOT NULL default '',
  41    `option` varchar(50) NOT NULL default '',
  42    `ordering` int(11) NOT NULL default '0',
  43    `admin_menu_img` varchar(255) NOT NULL default '',
  44    `iscore` tinyint(4) NOT NULL default '0',
  45    `params` text,
  46    PRIMARY KEY  (`id`)
  47  ) TYPE=MyISAM;
  48  
  49  #

  50  # Dumping data for table `#__components`

  51  #

  52  
  53  INSERT INTO `#__components` VALUES (7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '');
  54  INSERT INTO `#__components` VALUES (8, 'Manage Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '');
  55  INSERT INTO `#__components` VALUES (9, 'Contact Categories', '', 0, 7, 'option=com_categories&section=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '');
  56  INSERT INTO `#__components` VALUES (10, 'FrontPage', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '');
  57  INSERT INTO `#__components` VALUES (14, 'Manage Categories', '', 0, 12, 'option=com_categories&section=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '');
  58  INSERT INTO `#__components` VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '');
  59  INSERT INTO `#__components` VALUES (16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '');
  60  INSERT INTO `#__components` VALUES (17, 'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Manage Syndication Settings','com_syndicate',0,'js/ThemeOffice/component.png',0,'');
  61  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, '');
  62  #INSERT INTO `#__components` VALUES (20, 'Mambo Containers', 'option=com_containers', 0, 0, 'option=com_containers', 'Mambo Containers', 'com_containers', 0, 'js/ThemeOffice/component.png', 0, '');

  63  
  64  # --------------------------------------------------------

  65  
  66  #

  67  # Table structure for table `#__contact_details`

  68  #

  69  
  70  CREATE TABLE `#__contact_details` (
  71    `id` int(11) NOT NULL auto_increment,
  72    `name` varchar(100) NOT NULL default '',
  73    `con_position` varchar(50) default NULL,
  74    `address` text,
  75    `suburb` varchar(50) default NULL,
  76    `state` varchar(50) default NULL,
  77    `country` varchar(50) default NULL,
  78    `postcode` varchar(10) default NULL,
  79    `telephone` varchar(25) default NULL,
  80    `fax` varchar(25) default NULL,
  81    `misc` mediumtext,
  82    `image` varchar(100) default NULL,
  83    `imagepos` varchar(20) default NULL,
  84    `email_to` varchar(100) default NULL,
  85    `default_con` tinyint(1) unsigned NOT NULL default '0',
  86    `published` tinyint(1) unsigned NOT NULL default '0',
  87    `checked_out` int(11) unsigned NOT NULL default '0',
  88    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  89    `ordering` int(11) NOT NULL default '0',
  90    `params` text NOT NULL,
  91    `user_id` int(11) NOT NULL default '0',
  92    `catid` int(11) NOT NULL default '0',
  93    `access` tinyint(3) unsigned NOT NULL default '0',
  94    PRIMARY KEY  (`id`)
  95  ) TYPE=MyISAM;
  96  
  97  #

  98  # Table structure for table `#__containers`

  99  #

 100  
 101  CREATE TABLE `#__containers` (
 102    `id` int(11) NOT NULL auto_increment,
 103    `parentid` int(11) NOT NULL default '0',
 104    `ordering` int(11) NOT NULL default '0',
 105    `published` smallint(6) NOT NULL default '0',
 106    `childcount` int(11) NOT NULL default '0',
 107    `name` varchar(100) NOT NULL default '',
 108    `title` varchar(100) NOT NULL default '',
 109    `windowtitle` varchar(50) NOT NULL default '',
 110    `keywords` varchar(255) NOT NULL default '',
 111    `icon` varchar(25) NOT NULL default '',
 112    `description` text NOT NULL,
 113    PRIMARY KEY  (`id`)
 114  );
 115  
 116  
 117  #

 118  # Table structure for table `#__content`

 119  #

 120  
 121  CREATE TABLE `#__content` (
 122    `id` int(11) unsigned NOT NULL auto_increment,
 123    `title` varchar(100) NOT NULL default '',
 124    `title_alias` varchar(100) NOT NULL default '',
 125    `introtext` mediumtext NOT NULL,
 126    `fulltext` mediumtext NOT NULL,
 127    `state` tinyint(3) NOT NULL default '0',
 128    `sectionid` int(11) unsigned NOT NULL default '0',
 129    `mask` int(11) unsigned NOT NULL default '0',
 130    `catid` int(11) unsigned NOT NULL default '0',
 131    `created` datetime NOT NULL default '0000-00-00 00:00:00',
 132    `created_by` int(11) unsigned NOT NULL default '0',
 133    `created_by_alias` varchar(100) NOT NULL default '',
 134    `modified` datetime NOT NULL default '0000-00-00 00:00:00',
 135    `modified_by` int(11) unsigned NOT NULL default '0',
 136    `checked_out` int(11) unsigned NOT NULL default '0',
 137    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 138    `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
 139    `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
 140    `images` text NOT NULL,
 141    `urls` text NOT NULL,
 142    `attribs` text NOT NULL,
 143    `version` int(11) unsigned NOT NULL default '1',
 144    `parentid` int(11) unsigned NOT NULL default '0',
 145    `ordering` int(11) NOT NULL default '0',
 146    `metakey` text NOT NULL,
 147    `metadesc` text NOT NULL,
 148    `access` int(11) unsigned NOT NULL default '0',
 149    `hits` int(11) unsigned NOT NULL default '0',
 150    PRIMARY KEY  (`id`),
 151    KEY `idx_section` (`sectionid`),
 152    KEY `idx_access` (`access`),
 153    KEY `idx_checkout` (`checked_out`),
 154    KEY `idx_state` (`state`),
 155    KEY `idx_catid` (`catid`),
 156    KEY `idx_mask` (`mask`)
 157  ) TYPE=MyISAM;
 158  
 159  #

 160  # Table structure for table `#__content_frontpage`

 161  #

 162  
 163  CREATE TABLE `#__content_frontpage` (
 164    `content_id` int(11) NOT NULL default '0',
 165    `ordering` int(11) NOT NULL default '0',
 166    PRIMARY KEY  (`content_id`)
 167  ) TYPE=MyISAM;
 168  
 169  #

 170  # Table structure for table `#__content_rating`

 171  #

 172  
 173  CREATE TABLE `#__content_rating` (
 174    `content_id` int(11) NOT NULL default '0',
 175    `rating_sum` int(11) unsigned NOT NULL default '0',
 176    `rating_count` int(11) unsigned NOT NULL default '0',
 177    `lastip` varchar(50) NOT NULL default '',
 178    PRIMARY KEY  (`content_id`)
 179  ) TYPE=MyISAM;
 180  
 181  #

 182  # Table structure for table `#__core_log_items`

 183  #

 184  # To be implemented in Version 4.6

 185  
 186  CREATE TABLE `#__core_log_items` (
 187    `time_stamp` date NOT NULL default '0000-00-00',
 188    `item_table` varchar(50) NOT NULL default '',
 189    `item_id` int(11) unsigned NOT NULL default '0',
 190    `hits` int(11) unsigned NOT NULL default '0'
 191  ) TYPE=MyISAM;
 192  
 193  #

 194  # Table structure for table `#__core_log_searches`

 195  #

 196  # To be implemented in Version 4.6

 197  
 198  CREATE TABLE `#__core_log_searches` (
 199    `search_term` varchar(128) NOT NULL default '',
 200    `hits` int(11) unsigned NOT NULL default '0'
 201  ) TYPE=MyISAM;
 202  
 203  #

 204  # Table structure for table `#__groups`

 205  #

 206  
 207  CREATE TABLE `#__groups` (
 208    `id` tinyint(3) unsigned NOT NULL default '0',
 209    `name` varchar(50) NOT NULL default '',
 210    PRIMARY KEY  (`id`)
 211  ) TYPE=MyISAM;
 212  
 213  #

 214  # Dumping data for table `#__groups`

 215  #

 216  
 217  INSERT INTO `#__groups` VALUES (0, 'Public');
 218  INSERT INTO `#__groups` VALUES (1, 'Registered');
 219  INSERT INTO `#__groups` VALUES (2, 'Special');
 220  # --------------------------------------------------------

 221  
 222  #

 223  # Table structure for table `#__mambots`

 224  #

 225  
 226  CREATE TABLE `#__mambots` (
 227    `id` int(11) NOT NULL auto_increment,
 228    `name` varchar(100) NOT NULL default '',
 229    `element` varchar(100) NOT NULL default '',
 230    `folder` varchar(100) NOT NULL default '',
 231    `access` tinyint(3) unsigned NOT NULL default '0',
 232    `ordering` int(11) NOT NULL default '0',
 233    `published` tinyint(3) NOT NULL default '0',
 234    `iscore` tinyint(3) NOT NULL default '0',
 235    `client_id` tinyint(3) NOT NULL default '0',
 236    `checked_out` int(11) unsigned NOT NULL default '0',
 237    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 238    `params` text,
 239    PRIMARY KEY  (`id`),
 240    KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
 241  ) TYPE=MyISAM;
 242  
 243  INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
 244  INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','');
 245  INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','');
 246  INSERT INTO `#__mambots` VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
 247  INSERT INTO `#__mambots` VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','');
 248  INSERT INTO `#__mambots` VALUES (9,'No WYSIWYG Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','');
 249  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','');
 250  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','');
 251  INSERT INTO `#__mambots` VALUES (13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','');
 252  INSERT INTO `#__mambots` VALUES (14, 'Search Categories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 253  INSERT INTO `#__mambots` VALUES (15, 'Search Sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 254  INSERT INTO `#__mambots` VALUES (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 255  INSERT INTO `#__mambots` VALUES (19, 'Load Module Positions', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 256  INSERT INTO `#__mambots` VALUES (21, 'User Authenticator', 'mosvaliduserbot', 'authenticator', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
 257  
 258  # --------------------------------------------------------

 259  
 260  #

 261  # Table structure for table `#__menu`

 262  #

 263  
 264  CREATE TABLE `#__menu` (
 265    `id` int(11) NOT NULL auto_increment,
 266    `menutype` varchar(25) default NULL,
 267    `name` varchar(100) default NULL,
 268    `link` text,
 269    `type` varchar(50) NOT NULL default '',
 270    `published` tinyint(1) NOT NULL default '0',
 271    `parent` int(11) unsigned NOT NULL default '0',
 272    `componentid` int(11) unsigned NOT NULL default '0',
 273    `sublevel` int(11) default '0',
 274    `ordering` int(11) default '0',
 275    `checked_out` int(11) unsigned NOT NULL default '0',
 276    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 277    `pollid` int(11) NOT NULL default '0',
 278    `browserNav` tinyint(4) default '0',
 279    `access` tinyint(3) unsigned NOT NULL default '0',
 280    `utaccess` tinyint(3) unsigned NOT NULL default '0',
 281    `params` text,
 282    PRIMARY KEY  (`id`),
 283    KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
 284    KEY `menutype` (`menutype`)
 285  ) TYPE=MyISAM;
 286  
 287  INSERT INTO `#__menu` VALUES (1, 'mainmenu', 'Home', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nheader=\npage_title=0\nback_button=\nleading=1\nintro=2\ncolumns=2\nlink=3\norderby_pri=\norderby_sec=front\npagination=2\npagination_results=0\nimage=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0');
 288  
 289  # --------------------------------------------------------

 290  
 291  #

 292  # Table structure for table `#__messages`

 293  #

 294  
 295  CREATE TABLE `#__messages` (
 296    `message_id` int(10) unsigned NOT NULL auto_increment,
 297    `user_id_from` int(10) unsigned NOT NULL default '0',
 298    `user_id_to` int(10) unsigned NOT NULL default '0',
 299    `folder_id` int(10) unsigned NOT NULL default '0',
 300    `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
 301    `state` int(11) NOT NULL default '0',
 302    `priority` int(1) unsigned NOT NULL default '0',
 303    `subject` varchar(230) NOT NULL default '',
 304    `message` text NOT NULL,
 305    PRIMARY KEY  (`message_id`)
 306  ) TYPE=MyISAM;
 307  
 308  #

 309  # Table structure for table `#__messages_cfg`

 310  #

 311  
 312  CREATE TABLE `#__messages_cfg` (
 313    `user_id` int(10) unsigned NOT NULL default '0',
 314    `cfg_name` varchar(100) NOT NULL default '',
 315    `cfg_value` varchar(255) NOT NULL default '',
 316    UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
 317  ) TYPE=MyISAM;
 318  
 319  #

 320  # Table structure for table `#__modules`

 321  #

 322  
 323  CREATE TABLE `#__modules` (
 324    `id` int(11) NOT NULL auto_increment,
 325    `title` text NOT NULL,
 326    `content` text NOT NULL,
 327    `ordering` int(11) NOT NULL default '0',
 328    `position` varchar(10) default NULL,
 329    `checked_out` int(11) unsigned NOT NULL default '0',
 330    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 331    `published` tinyint(1) NOT NULL default '0',
 332    `module` varchar(50) default NULL,
 333    `numnews` int(11) NOT NULL default '0',
 334    `access` tinyint(3) unsigned NOT NULL default '0',
 335    `showtitle` tinyint(3) unsigned NOT NULL default '1',
 336    `params` text,
 337    `iscore` tinyint(4) NOT NULL default '0',
 338    `client_id` tinyint(4) NOT NULL default '0',
 339    `groups` text NOT NULL,
 340    PRIMARY KEY  (`id`),
 341    KEY `published` (`published`,`access`),
 342    KEY `newsfeeds` (`module`,`published`)
 343  ) TYPE=MyISAM;
 344  
 345  #

 346  # Dumping data for table `#__modules`

 347  #

 348  
 349  INSERT INTO `#__modules` VALUES (2, 'User Menu', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0, '');
 350  INSERT INTO `#__modules` VALUES (3, 'Main Menu', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=\nmoduleclass_sfx=\nmenutype=mainmenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0, '');
 351  INSERT INTO `#__modules` VALUES (4, 'Login Form', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 0, '');
 352  INSERT INTO `#__modules` VALUES (5, 'Syndicate', '', 5, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_rssfeed', 0, 0, 1, 'text=\ncache=0\nmoduleclass_sfx=\nrss091=1\nrss10=1\nrss20=1\natom=1\nopml=1\nrss091_image=\nrss10_image=\nrss20_image=\natom_image=\nopml_image=', 1, 0, '');
 353  INSERT INTO `#__modules` VALUES (7, 'Statistics', '', 6, '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, '');
 354  INSERT INTO `#__modules` VALUES (11, 'Archive', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0, '');
 355  INSERT INTO `#__modules` VALUES (12, 'Sections', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0, '');
 356  INSERT INTO `#__modules` VALUES (13, 'Newsflash', '', 1, 'newsflash', 0, '0000-00-00 00:00:00', 1, 'mod_newsflash', 0, 0, 0, 'catid=3\nstyle=random\nimage=0\nlink_titles=\nreadmore=0\nitem_title=0\nitems=\ncache=0\nmoduleclass_sfx=', 0, 0, '');
 357  INSERT INTO `#__modules` VALUES (15, 'Search', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nwidth=20\ntext=\nbutton=\nbutton_pos=right\nbutton_text=', 0, 0, '');
 358  INSERT INTO `#__modules` VALUES (17, 'Top Menu', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=-nav\nmoduleclass_sfx=\nmenutype=topmenu\nmenu_style=list_flat\ncache=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0, '');
 359  INSERT INTO `#__modules` VALUES (19, 'Components', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_components', 0, 99, 1, '', 1, 1, '');
 360  INSERT INTO `#__modules` VALUES (21, 'Latest Items', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 99, 1, '', 0, 1, '');
 361  INSERT INTO `#__modules` VALUES (22, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 99, 1, '', 0, 1, '');
 362  INSERT INTO `#__modules` VALUES (23, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 99, 1, '', 1, 1, '');
 363  INSERT INTO `#__modules` VALUES (24, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 99, 1, '', 1, 1, '');
 364  INSERT INTO `#__modules` VALUES (25, 'Full Menu', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_fullmenu', 0, 99, 1, '', 1, 1, '');
 365  INSERT INTO `#__modules` VALUES (26, 'Pathway', '', 1, 'pathway', 0, '0000-00-00 00:00:00', 1, 'mod_pathway', 0, 99, 1, '', 1, 1, '');
 366  INSERT INTO `#__modules` VALUES (27, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 99, 1, '', 1, 1, '');
 367  INSERT INTO `#__modules` VALUES (28, 'System Message', '', 1, 'inset', 0, '0000-00-00 00:00:00', 1, 'mod_mosmsg', 0, 99, 1, '', 1, 1, '');
 368  INSERT INTO `#__modules` VALUES (29, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 99, 1, '', 1, 1, '');
 369  INSERT INTO `#__modules` VALUES (31, 'Other Menu', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, '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, '');
 370  INSERT INTO `#__modules` VALUES (32, 'Wrapper', '', 11, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0, '');
 371  INSERT INTO `#__modules` VALUES (33, 'Logged', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 99, 1, '', 0, 1, '');
 372  
 373  
 374  # --------------------------------------------------------

 375  
 376  #

 377  # Table structure for table `#__modules_menu`

 378  #

 379  
 380  CREATE TABLE `#__modules_menu` (
 381    `moduleid` int(11) NOT NULL default '0',
 382    `menuid` int(11) NOT NULL default '0',
 383    PRIMARY KEY  (`moduleid`,`menuid`)
 384  ) TYPE=MyISAM;
 385  
 386  #

 387  # Dumping data for table `#__modules_menu`

 388  #

 389  
 390  INSERT INTO `#__modules_menu` VALUES (1, 1);
 391  INSERT INTO `#__modules_menu` VALUES (2, 0);
 392  INSERT INTO `#__modules_menu` VALUES (3, 0);
 393  INSERT INTO `#__modules_menu` VALUES (4, 1);
 394  INSERT INTO `#__modules_menu` VALUES (5, 1);
 395  INSERT INTO `#__modules_menu` VALUES (6, 1);
 396  INSERT INTO `#__modules_menu` VALUES (6, 27);
 397  INSERT INTO `#__modules_menu` VALUES (8, 1);
 398  INSERT INTO `#__modules_menu` VALUES (9, 1);
 399  INSERT INTO `#__modules_menu` VALUES (9, 27);
 400  INSERT INTO `#__modules_menu` VALUES (10, 1);
 401  INSERT INTO `#__modules_menu` VALUES (13, 0);
 402  INSERT INTO `#__modules_menu` VALUES (15, 0);
 403  INSERT INTO `#__modules_menu` VALUES (17, 0);
 404  INSERT INTO `#__modules_menu` VALUES (18, 0);
 405  INSERT INTO `#__modules_menu` VALUES (31, 0);
 406  
 407  # --------------------------------------------------------

 408  
 409  #

 410  # Table structure for table `#__sections`

 411  #

 412  
 413  CREATE TABLE `#__sections` (
 414    `id` int(11) NOT NULL auto_increment,
 415    `title` varchar(50) NOT NULL default '',
 416    `name` varchar(255) NOT NULL default '',
 417    `image` varchar(100) NOT NULL default '',
 418    `scope` varchar(50) NOT NULL default '',
 419    `image_position` varchar(10) NOT NULL default '',
 420    `description` text NOT NULL,
 421    `published` tinyint(1) NOT NULL default '0',
 422    `checked_out` int(11) unsigned NOT NULL default '0',
 423    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
 424    `ordering` int(11) NOT NULL default '0',
 425    `access` tinyint(3) unsigned NOT NULL default '0',
 426    `count` int(11) NOT NULL default '0',
 427    `params` text NOT NULL,
 428    PRIMARY KEY  (`id`),
 429    KEY `idx_scope` (`scope`)
 430  ) TYPE=MyISAM;
 431  
 432  #

 433  # Table structure for table `#__session`

 434  #

 435  
 436  CREATE TABLE `#__session` (
 437    `username` varchar(50) default '',
 438    `time` varchar(14) default '',
 439    `session_id` varchar(200) NOT NULL default '0',
 440    `guest` tinyint(4) default '1',
 441    `userid` int(11) default '0',
 442    `usertype` varchar(50) default '',
 443    `gid` tinyint(3) unsigned NOT NULL default '0',
 444    PRIMARY KEY  (`session_id`),
 445    KEY `whosonline` (`guest`,`usertype`)
 446  ) TYPE=MyISAM;
 447  
 448  #

 449  # Table structure for table `#__stats_agents`

 450  #

 451  
 452  CREATE TABLE `#__stats_agents` (
 453    `agent` varchar(255) NOT NULL default '',
 454    `type` tinyint(1) unsigned NOT NULL default '0',
 455    `hits` int(11) unsigned NOT NULL default '1'
 456  ) TYPE=MyISAM;
 457  
 458  #

 459  # Table structure for table `#__templates_menu`

 460  #

 461  
 462  CREATE TABLE `#__templates_menu` (
 463    `template` varchar(50) NOT NULL default '',
 464    `menuid` int(11) NOT NULL default '0',
 465    `client_id` tinyint(4) NOT NULL default '0',
 466    PRIMARY KEY  (`template`,`menuid`)
 467  ) TYPE=MyISAM;
 468  
 469  # Dumping data for table `#__templates_menu`

 470  
 471  INSERT INTO `#__templates_menu` VALUES ('waterandstone', 0, 0);
 472  INSERT INTO `#__templates_menu` VALUES ('mambo_admin_blue', 0, 1);
 473  
 474  # --------------------------------------------------------

 475  
 476  #

 477  # Table structure for table `#__template_positions`

 478  #

 479  
 480  CREATE TABLE `#__template_positions` (
 481    `id` int(11) NOT NULL auto_increment,
 482    `position` varchar(10) NOT NULL default '',
 483    `description` varchar(255) NOT NULL default '',
 484    PRIMARY KEY  (`id`)
 485  ) TYPE=MyISAM;
 486  
 487  #

 488  # Dumping data for table `#__template_positions`

 489  #

 490  
 491  INSERT INTO `#__template_positions` VALUES (1, 'left', '');
 492  INSERT INTO `#__template_positions` VALUES (2, 'right', '');
 493  INSERT INTO `#__template_positions` VALUES (3, 'top', '');
 494  INSERT INTO `#__template_positions` VALUES (4, 'bottom', '');
 495  INSERT INTO `#__template_positions` VALUES (5, 'inset', '');
 496  INSERT INTO `#__template_positions` VALUES (6, 'banner', '');
 497  INSERT INTO `#__template_positions` VALUES (7, 'header', '');
 498  INSERT INTO `#__template_positions` VALUES (8, 'footer', '');
 499  INSERT INTO `#__template_positions` VALUES (9, 'newsflash', '');
 500  INSERT INTO `#__template_positions` VALUES (10, 'legals', '');
 501  INSERT INTO `#__template_positions` VALUES (11, 'pathway', '');
 502  INSERT INTO `#__template_positions` VALUES (12, 'toolbar', '');
 503  INSERT INTO `#__template_positions` VALUES (13, 'cpanel', '');
 504  INSERT INTO `#__template_positions` VALUES (14, 'user1', '');
 505  INSERT INTO `#__template_positions` VALUES (15, 'user2', '');
 506  INSERT INTO `#__template_positions` VALUES (16, 'user3', '');
 507  INSERT INTO `#__template_positions` VALUES (17, 'user4', '');
 508  INSERT INTO `#__template_positions` VALUES (18, 'user5', '');
 509  INSERT INTO `#__template_positions` VALUES (19, 'user6', '');
 510  INSERT INTO `#__template_positions` VALUES (20, 'user7', '');
 511  INSERT INTO `#__template_positions` VALUES (21, 'user8', '');
 512  INSERT INTO `#__template_positions` VALUES (22, 'user9', '');
 513  INSERT INTO `#__template_positions` VALUES (23, 'advert1', '');
 514  INSERT INTO `#__template_positions` VALUES (24, 'advert2', '');
 515  INSERT INTO `#__template_positions` VALUES (25, 'advert3', '');
 516  INSERT INTO `#__template_positions` VALUES (26, 'icon', '');
 517  INSERT INTO `#__template_positions` VALUES (27, 'debug', '');
 518  
 519  # --------------------------------------------------------

 520  
 521  #

 522  # Table structure for table `#__users`

 523  #

 524  
 525  CREATE TABLE `#__users` (
 526    `id` int(11) NOT NULL auto_increment,
 527    `name` varchar(50) NOT NULL default '',
 528    `username` varchar(25) NOT NULL default '',
 529    `email` varchar(100) NOT NULL default '',
 530    `password` varchar(100) NOT NULL default '',
 531    `usertype` varchar(25) NOT NULL default '',
 532    `block` tinyint(4) NOT NULL default '0',
 533    `sendEmail` tinyint(4) default '0',
 534    `gid` tinyint(3) unsigned NOT NULL default '1',
 535    `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
 536    `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
 537    `activation` varchar(100) NOT NULL default '',
 538    `params` text NOT NULL,
 539    PRIMARY KEY  (`id`),
 540    KEY `usertype` (`usertype`),
 541    KEY `idx_name` (`name`)
 542  ) TYPE=MyISAM;
 543  
 544  #

 545  # Table structure for table `#__usertypes`

 546  #

 547  
 548  CREATE TABLE `#__usertypes` (
 549    `id` tinyint(3) unsigned NOT NULL default '0',
 550    `name` varchar(50) NOT NULL default '',
 551    `mask` varchar(11) NOT NULL default '',
 552    PRIMARY KEY  (`id`)
 553  ) TYPE=MyISAM;
 554  
 555  #

 556  # Dumping data for table `#__usertypes`

 557  #

 558  
 559  INSERT INTO `#__usertypes` VALUES (0, 'superadministrator', '');
 560  INSERT INTO `#__usertypes` VALUES (1, 'administrator', '');
 561  INSERT INTO `#__usertypes` VALUES (2, 'editor', '');
 562  INSERT INTO `#__usertypes` VALUES (3, 'user', '');
 563  INSERT INTO `#__usertypes` VALUES (4, 'author', '');
 564  INSERT INTO `#__usertypes` VALUES (5, 'publisher', '');
 565  INSERT INTO `#__usertypes` VALUES (6, 'manager', '');
 566  # --------------------------------------------------------

 567  
 568  
 569  #

 570  # Table structure for table `#__parameters`

 571  #

 572  
 573  CREATE TABLE `#__parameters` (
 574    `id` int(11) NOT NULL auto_increment,
 575    `param_name` varchar(50) NOT NULL default '',
 576    `param_file` varchar(50) NOT NULL default '',
 577    `param_version` varchar(50) NOT NULL default '',
 578    `params` text NOT NULL,
 579    PRIMARY KEY  (`id`),
 580    KEY `names` (`param_name`, `param_version`)
 581  ) TYPE=MyISAM;
 582  
 583  #

 584  # Table structure for table `#__core_acl_aro`

 585  #

 586  
 587  CREATE TABLE `#__core_acl_aro` (
 588  `aro_id` int(11) NOT NULL auto_increment,
 589  `section_value` varchar(240) NOT NULL default '0',
 590  `value` varchar(240) NOT NULL default '',
 591  `order_value` int(11) NOT NULL default '0',
 592  `name` varchar(255) NOT NULL default '',
 593  `hidden` int(11) NOT NULL default '0',
 594  PRIMARY KEY (`aro_id`),
 595  UNIQUE KEY `#__gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
 596  KEY `#__gacl_hidden_aro` (`hidden`)
 597  ) TYPE=MyISAM;
 598  
 599  #

 600  # Table structure for table `#__core_acl_aro_groups`

 601  #

 602  CREATE TABLE `#__core_acl_aro_groups` (
 603    `group_id` int(11) NOT NULL auto_increment,
 604    `parent_id` int(11) NOT NULL default '0',
 605    `name` varchar(255) NOT NULL default '',
 606    `lft` int(11) NOT NULL default '0',
 607    `rgt` int(11) NOT NULL default '0',
 608    PRIMARY KEY  (`group_id`),
 609    KEY `parent_id_aro_groups` (`parent_id`),
 610    KEY `#__gacl_parent_id_aro_groups` (`parent_id`),
 611    KEY `#__gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
 612  ) TYPE=MyISAM;
 613  
 614  #

 615  # Dumping data for table `#__core_acl_aro_groups`

 616  #

 617  INSERT INTO `#__core_acl_aro_groups` VALUES (17,0,'ROOT',1,22);
 618  INSERT INTO `#__core_acl_aro_groups` VALUES (28,17,'USERS',2,21);
 619  INSERT INTO `#__core_acl_aro_groups` VALUES (29,28,'Public Frontend',3,12);
 620  INSERT INTO `#__core_acl_aro_groups` VALUES (18,29,'Registered',4,11);
 621  INSERT INTO `#__core_acl_aro_groups` VALUES (19,18,'Author',5,10);
 622  INSERT INTO `#__core_acl_aro_groups` VALUES (20,19,'Editor',6,9);
 623  INSERT INTO `#__core_acl_aro_groups` VALUES (21,20,'Publisher',7,8);
 624  INSERT INTO `#__core_acl_aro_groups` VALUES (30,28,'Public Backend',13,20);
 625  INSERT INTO `#__core_acl_aro_groups` VALUES (23,30,'Manager',14,19);
 626  INSERT INTO `#__core_acl_aro_groups` VALUES (24,23,'Administrator',15,18);
 627  INSERT INTO `#__core_acl_aro_groups` VALUES (25,24,'Super Administrator',16,17);
 628  
 629  #

 630  # Table structure for table `#__core_acl_groups_aro_map`

 631  #

 632  CREATE TABLE `#__core_acl_groups_aro_map` (
 633    `group_id` int(11) NOT NULL default '0',
 634    `section_value` varchar(240) NOT NULL default '',
 635    `aro_id` int(11) NOT NULL default '0',
 636    UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
 637  ) TYPE=MyISAM;
 638  
 639  #

 640  # Table structure for table `#__core_acl_aro_sections`

 641  #

 642  CREATE TABLE `#__core_acl_aro_sections` (
 643    `section_id` int(11) NOT NULL auto_increment,
 644    `value` varchar(230) NOT NULL default '',
 645    `order_value` int(11) NOT NULL default '0',
 646    `name` varchar(230) NOT NULL default '',
 647    `hidden` int(11) NOT NULL default '0',
 648    PRIMARY KEY  (`section_id`),
 649    UNIQUE KEY `value_aro_sections` (`value`),
 650    UNIQUE KEY `#__gacl_value_aro_sections` (`value`),
 651    KEY `hidden_aro_sections` (`hidden`),
 652    KEY `#__gacl_hidden_aro_sections` (`hidden`)
 653  ) TYPE=MyISAM;
 654  
 655  INSERT INTO `#__core_acl_aro_sections` VALUES (10,'users',1,'Users',0);