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