00001
00002 --
00003 -- Table structure for table `#__admin_menu`
00004 --
00005
00006 CREATE TABLE IF NOT EXISTS `#__admin_menu` (
00007 `id` int(11) NOT NULL auto_increment,
00008 `name` varchar(255) NOT NULL default '',
00009 `link` text NOT NULL default '',
00010 `type` varchar(255) NOT NULL default '',
00011 `published` tinyint(1) NOT NULL default '0',
00012 `parent` int(11) unsigned NOT NULL default '0',
00013 `component` varchar(255) NOT NULL default '',
00014 `componentid` int(11) unsigned NOT NULL default '0',
00015 `sublevel` int(11) default '0',
00016 `ordering` int(11) default '0',
00017 `checked_out` int(11) unsigned NOT NULL default '0',
00018 `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
00019 `browserNav` tinyint(4) default '0',
00020 `params` text NOT NULL default '',
00021 `xmlfile` varchar(255) NOT NULL default '',
00022 PRIMARY KEY (`id`),
00023 KEY `componentid` (`componentid`,`published`)
00024 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00025
00026 INSERT INTO `#__admin_menu` (`id`, `name`, `link`, `type`, `published`, `parent`, `component`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `params`, `xmlfile`) VALUES
00027 (1, 'Home', '', 'core', 1, 0, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00028 (2, 'Manage Site', 'index.php?placeholder=manage_site', 'placeholder', 1, 0, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00029 (3, 'Plugins', 'index.php?core=cor_mambots', 'core', 1, 0, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00030 (4, 'Display Boxes', 'index.php?placeholder=view_panels', 'placeholder', 1, 0, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00031 (5, 'Themes', 'index.php?core=cor_templates', 'core', 1, 2, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00032 (6, 'Applications', 'index.php?placeholder=manage_applications', 'placeholder', 1, 0, 'components', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00033 (7, 'Installer', 'index.php?core=cor_installer', 'core', 1, 9, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00034 (8, 'Information', 'index.php?placeholder=information', 'placeholder', 1, 0, '', 0, 0, 10, 0, '0000-00-00 00:00:00', 0, '', ''),
00035 (9, 'Extensions', 'index.php?core=cor_extensions', 'core', 1, 0, '', 0, 0, 2, 0, '0000-00-00 00:00:00', 0, '', ''),
00036 (10, 'Folders', 'index.php?core=cor_folders', 'core', 1, 2, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00037 (11, 'Menus', 'index.php?core=cor_menutypes', 'core', 1, 2, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00038 (12, 'Help', 'index.php?core=cor_help', 'core', 1, 8, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00039 (13, 'System', 'index.php?core=cor_sysinfo', 'core', 1, 8, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00040 (14, 'Main menu', 'index.php?core=cor_menus&task=list&menutype=mainmenu', 'core', 1, 11, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00041 (15, 'Other Menu', 'index.php?core=cor_menus&task=list&menutype=othermenu', 'core', 1, 11, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00042 (16, 'Top Menu', 'index.php?core=cor_menus&task=list&menutype=topmenu', 'core', 1, 11, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00043 (17, 'User Menu', 'index.php?core=cor_menus&task=list&menutype=usermenu', 'core', 1, 11, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00044 (18, 'User Boxes', 'index.php?core=cor_modules&client=user', 'core', 1, 4, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00045 (19, 'Admin Boxes', 'index.php?core=cor_modules&client=admin', 'core', 1, 4, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00046 (20, 'Configuration', 'index.php?core=cor_config', 'core', 1, 2, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00047 (21, 'Error reports', 'index.php?core=cor_errors', 'core', 1, 2, 'cor_errors', 0, 0, 6, 0, '0000-00-00 00:00:00', 0, '', ''),
00048 (22, 'Page 404 reports', 'index.php?core=cor_err404', 'core', 1, 2, 'cor_err404', 0, 0, 6, 0, '0000-00-00 00:00:00', 0, '', ''),
00049 (23, 'Languages', 'index.php?core=cor_languages', 'core', 1, 2, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00050 (24, 'SEF', 'index.php?core=cor_sef', 'core', 1, 2, '', 0, 0, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00051 (25, 'URI list', 'index.php?core=cor_sef&act=uri', 'core', 1, 24, '', 0, 1, 0, 0, '0000-00-00 00:00:00', 0, '', ''),
00052 (26, 'Metadata', 'index.php?core=cor_sef&act=metadata', 'core', 1, 24, '', 0, 1, 0, 0, '0000-00-00 00:00:00', 0, '', '')
00053 ON DUPLICATE KEY UPDATE name = name;
00054
00055 -- --------------------------------------------------------
00056
00057 --
00058 -- Table structure for table `#__assignments`
00059 --
00060
00061 CREATE TABLE IF NOT EXISTS `#__assignments` (
00062 `id` int(11) NOT NULL auto_increment,
00063 `access_type` varchar(60) NOT NULL,
00064 `access_id` text NOT NULL,
00065 `role` varchar(60) NOT NULL,
00066 PRIMARY KEY (`id`),
00067 KEY `access_type` (`access_type`,`access_id`(60),`role`)
00068 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00069
00070 -- --------------------------------------------------------
00071
00072 --
00073 -- Table structure for table `#__classmap`
00074 --
00075
00076 CREATE TABLE IF NOT EXISTS `#__classmap` (
00077 `id` int(11) NOT NULL auto_increment,
00078 `type` varchar(100) NOT NULL default '',
00079 `formalname` varchar(100) NOT NULL default '',
00080 `side` varchar(12) NOT NULL default '',
00081 `filename` varchar(255) NOT NULL default '',
00082 `classname` varchar(255) NOT NULL default '',
00083 PRIMARY KEY (`id`)
00084 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00085
00086 -- --------------------------------------------------------
00087
00088 --
00089 -- Table structure for table `#__components`
00090 --
00091
00092 CREATE TABLE IF NOT EXISTS `#__components` (
00093 `id` int(11) NOT NULL auto_increment,
00094 `name` varchar(255) NOT NULL default '',
00095 `extformalname` varchar(100) NOT NULL default '',
00096 `option` varchar(100) NOT NULL default '',
00097 `ordering` int(11) NOT NULL default '0',
00098 `class` varchar(255) NOT NULL default '',
00099 `adminclass` varchar(255) NOT NULL default '',
00100 `menuclass` varchar(255) NOT NULL default '',
00101 `params` text NOT NULL default '',
00102 PRIMARY KEY (`id`)
00103 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00104
00105 -- --------------------------------------------------------
00106
00107 --
00108 -- Table structure for table `#__extensions`
00109 --
00110
00111 CREATE TABLE IF NOT EXISTS `#__extensions` (
00112 `id` int(11) NOT NULL auto_increment,
00113 `type` varchar(100) NOT NULL default '',
00114 `formalname` varchar(100) NOT NULL default '',
00115 `name` varchar(255) NOT NULL default '',
00116 `admin` smallint(5) unsigned NOT NULL default '0',
00117 `author` varchar(255) NOT NULL default '',
00118 `version` varchar(255) NOT NULL default '',
00119 `date` varchar(24) NOT NULL default '',
00120 `authoremail` varchar(255) NOT NULL default '',
00121 `authorurl` text NOT NULL default '',
00122 `description` text NOT NULL default '',
00123 `class` varchar(255) NOT NULL default '',
00124 `adminclass` varchar(255) NOT NULL default '',
00125 `menuclass` varchar(255) NOT NULL default '',
00126 `default_template` smallint(6) unsigned NOT NULL default '0',
00127 `inner` smallint(6) unsigned NOT NULL default '0',
00128 `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
00129 `xmlfile` varchar(255) NOT NULL default '',
00130 PRIMARY KEY (`id`)
00131 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00132
00133 -- --------------------------------------------------------
00134
00135 --
00136 -- Table structure for table `#__mambots`
00137 --
00138
00139 CREATE TABLE IF NOT EXISTS `#__mambots` (
00140 `id` int(11) NOT NULL auto_increment,
00141 `name` varchar(255) NOT NULL default '',
00142 `element` varchar(100) NOT NULL default '',
00143 `class` varchar(255) NOT NULL default '',
00144 `triggers` text NOT NULL default '',
00145 `ordering` int(11) NOT NULL default '0',
00146 `published` tinyint(3) NOT NULL default '0',
00147 `checked_out` int(11) unsigned NOT NULL default '0',
00148 `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
00149 `params` text NOT NULL default '',
00150 PRIMARY KEY (`id`),
00151 KEY `idx_folder` (`published`)
00152 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00153
00154 -- --------------------------------------------------------
00155
00156 --
00157 -- Table structure for table `#__menu`
00158 --
00159
00160 CREATE TABLE IF NOT EXISTS `#__menu` (
00161 `id` int(11) NOT NULL auto_increment,
00162 `menutype` varchar(100) NOT NULL default '',
00163 `name` varchar(255) NOT NULL default '',
00164 `link` text NOT NULL default '',
00165 `type` varchar(100) NOT NULL default '',
00166 `published` tinyint(1) NOT NULL default '0',
00167 `parent` int(11) unsigned NOT NULL default '0',
00168 `component` varchar(100) NOT NULL default '',
00169 `componentid` int(11) unsigned NOT NULL default '0',
00170 `ordering` int(11) NOT NULL default '0',
00171 `checked_out` int(11) unsigned NOT NULL default '0',
00172 `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
00173 `browserNav` tinyint(4) NOT NULL default '0',
00174 `xmlfile` varchar(255) NOT NULL default '',
00175 `params` text NOT NULL default '',
00176 PRIMARY KEY (`id`),
00177 KEY `componentid` (`componentid`,`menutype`,`published`),
00178 KEY `menutype` (`menutype`)
00179 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00180
00181 -- --------------------------------------------------------
00182
00183 --
00184 -- Table structure for table `#__modules`
00185 --
00186
00187 CREATE TABLE IF NOT EXISTS `#__modules` (
00188 `id` int(11) NOT NULL auto_increment,
00189 `title` text NOT NULL default '',
00190 `suffix` varchar(100) NOT NULL default '',
00191 `ordering` int(11) NOT NULL default '0',
00192 `position` varchar(100) NOT NULL default '',
00193 `checked_out` int(11) unsigned NOT NULL default '0',
00194 `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
00195 `published` tinyint(1) NOT NULL default '0',
00196 `module` varchar(100) NOT NULL default '',
00197 `showtitle` tinyint(3) unsigned NOT NULL default '1',
00198 `admin` tinyint(3) unsigned NOT NULL default '0',
00199 `class` varchar(255) NOT NULL default '',
00200 `adminclass` varchar(255) NOT NULL default '',
00201 `params` text NOT NULL default '',
00202 `customcontent` text NOT NULL default '',
00203 PRIMARY KEY (`id`),
00204 KEY `published` (`published`),
00205 KEY `newsfeeds` (`module`,`published`)
00206 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00207
00208 -- --------------------------------------------------------
00209
00210 --
00211 -- Table structure for table `#__modules_menu`
00212 --
00213
00214 CREATE TABLE IF NOT EXISTS `#__modules_menu` (
00215 `moduleid` int(11) NOT NULL default '0',
00216 `menuid` int(11) NOT NULL default '0',
00217 PRIMARY KEY (`moduleid`,`menuid`)
00218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00219
00220 -- --------------------------------------------------------
00221
00222 --
00223 -- Table structure for table `#__orphan_data`
00224 --
00225
00226 CREATE TABLE IF NOT EXISTS `#__orphan_data` (
00227 `session_id` varchar(32) NOT NULL,
00228 `orphandata` text NOT NULL,
00229 PRIMARY KEY (`session_id`)
00230 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00231
00232 -- --------------------------------------------------------
00233
00234 --
00235 -- Table structure for table `#__permissions`
00236 --
00237
00238 CREATE TABLE IF NOT EXISTS `#__permissions` (
00239 `id` int(11) NOT NULL auto_increment,
00240 `role` varchar(60) NOT NULL,
00241 `control` tinyint(3) unsigned NOT NULL default '0',
00242 `action` varchar(60) NOT NULL,
00243 `subject_type` varchar(60) NOT NULL,
00244 `subject_id` text NOT NULL,
00245 `system` smallint(5) unsigned NOT NULL default '0',
00246 PRIMARY KEY (`id`),
00247 KEY `role_type` (`role`,`action`,`subject_type`,`subject_id`(60)),
00248 KEY `subaction` (`subject_type`,`action`,`subject_id`(60))
00249 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00250
00251 INSERT INTO `#__permissions` (`id`, `role`, `control`, `action`, `subject_type`, `subject_id`, `system`) VALUES
00252 (1, 'Manager', 2, 'access', 'adminSide', '*', 1),
00253 (2, 'Administrator', 2, 'access', 'adminSide', '*', 1),
00254 (3, 'Super Administrator', 3, 'access', 'adminSide', '*', 1),
00255 (4, 'Super Administrator', 3, 'administer', 'Administrator', '*', 1),
00256 (5, 'Super Administrator', 3, 'administer', 'Author', '*', 1),
00257 (6, 'Super Administrator', 3, 'administer', 'Editor', '*', 1),
00258 (7, 'Super Administrator', 3, 'administer', 'Manager', '*', 1),
00259 (8, 'Super Administrator', 3, 'administer', 'Publisher', '*', 1),
00260 (9, 'Super Administrator', 3, 'administer', 'Registered', '*', 1),
00261 (10, 'Super Administrator', 3, 'administer', 'Super Administrator', '*', 1),
00262 (11, 'Super Administrator', 3, 'block', 'aUser', '*', 1),
00263 (12, 'Super Administrator', 3, 'edit', 'aliroComponent', '*', 1),
00264 (13, 'Super Administrator', 3, 'edit', 'aliroMambot', '*', 1),
00265 (14, 'Super Administrator', 3, 'edit', 'aliroModule', '*', 1),
00266 (15, 'Super Administrator', 3, 'emailEvents', 'aUser', '*', 1),
00267 (16, 'Super Administrator', 3, 'install', 'aliroComponent', '*', 1),
00268 (17, 'Super Administrator', 3, 'install', 'aliroMambot', '*', 1),
00269 (18, 'Super Administrator', 3, 'install', 'aliroModule', '*', 1),
00270 (19, 'Super Administrator', 3, 'manage', 'aConfig', '*', 1),
00271 (20, 'Super Administrator', 3, 'manage', 'aLanguage', '*', 1),
00272 (21, 'Super Administrator', 3, 'manage', 'aliroMenu', '*', 1),
00273 (22, 'Super Administrator', 3, 'manage', 'aliroTemplate', '*', 1),
00274 (23, 'Super Administrator', 3, 'manage', 'aliroTrash', '*', 1),
00275 (24, 'Super Administrator', 3, 'manage', 'aUser', '*', 1),
00276 (25, 'Super Administrator', 3, 'massMail', 'aUser', '*', 1) ON DUPLICATE KEY UPDATE system = 1;
00277
00278 -- --------------------------------------------------------
00279 --
00280 -- Table structure for table `#__query_stats`
00281 --
00282
00283 CREATE TABLE IF NOT EXISTS `#__query_stats` (
00284 `id` int(11) NOT NULL auto_increment,
00285 `count` smallint(6) NOT NULL default '0',
00286 `mean` float NOT NULL default '0',
00287 `median` float NOT NULL default '0',
00288 `stdev` float NOT NULL default '0',
00289 `best` float NOT NULL default '0',
00290 `worst` float NOT NULL default '0',
00291 `total` float NOT NULL default '0',
00292 `elapsed` float NOT NULL default '0',
00293 `memory` int(11) NOT NULL default '0',
00294 `uri` text character set latin1 collate latin1_general_ci NOT NULL,
00295 `stamp` timestamp,
00296 PRIMARY KEY (`id`)
00297 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00298
00299 -- --------------------------------------------------------
00300 --
00301 -- Table structure for table `#__query_slow`
00302 --
00303
00304 CREATE TABLE IF NOT EXISTS `#__query_slow` (
00305 `id` int(11) NOT NULL auto_increment,
00306 `queryid` int(11) NOT NULL default '0',
00307 `time` float NOT NULL default '0',
00308 `trace` text NOT NULL,
00309 `querytext` text NOT NULL,
00310 PRIMARY KEY (`id`)
00311 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00312
00313 -- --------------------------------------------------------
00314 --
00315 -- Table structure for table `#__role_link`
00316 --
00317
00318 CREATE TABLE IF NOT EXISTS `#__role_link` (
00319 `role` varchar(60) NOT NULL default '',
00320 `implied` varchar(60) NOT NULL default '',
00321 PRIMARY KEY (`role`, `implied`)
00322 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00323
00324 INSERT INTO `#__role_link` (`role`, `implied`) VALUES
00325 ('Administrator', 'Manager'),
00326 ('Author', 'Registered'),
00327 ('Editor', 'Author'),
00328 ('Manager', 'Publisher'),
00329 ('Publisher', 'Editor'),
00330 ('Super Administrator', 'Administrator') ON DUPLICATE KEY UPDATE role = role;
00331
00332 -- --------------------------------------------------------
00333
00334 --
00335 -- Table structure for table `#__session`
00336 --
00337
00338 CREATE TABLE IF NOT EXISTS `#__session` (
00339 `username` varchar(50) NOT NULL default '',
00340 `time` int(11) NOT NULL default '0',
00341 `session_id` varchar(32) NOT NULL default '',
00342 `isadmin` tinyint(3) unsigned NOT NULL default '0',
00343 `guest` tinyint(4) NOT NULL default '1',
00344 `userid` int(11) NOT NULL default '0',
00345 `usertype` varchar(100) NOT NULL default '',
00346 `gid` tinyint(3) unsigned NOT NULL default '0',
00347 `marker` smallint(6) NOT NULL default '0',
00348 `httphost` varchar(255) NOT NULL,
00349 `servername` varchar(255) NOT NULL,
00350 `ipaddress` varchar(15) NOT NULL,
00351 PRIMARY KEY (`session_id`),
00352 KEY `whosonline` (`guest`,`usertype`)
00353 ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
00354
00355 -- --------------------------------------------------------
00356
00357 --
00358 -- Table structure for table `#__session_data`
00359 --
00360
00361 CREATE TABLE IF NOT EXISTS `#__session_data` (
00362 `session_id` varchar(32) NOT NULL,
00363 `timestamp` varchar(14) NOT NULL,
00364 `session_data` text NOT NULL,
00365 PRIMARY KEY (`session_id`)
00366 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00367
00368 -- --------------------------------------------------------
00369
00370
00371 --
00372 -- Table structure for table `#__core_users`
00373 --
00374
00375 CREATE TABLE IF NOT EXISTS `#__core_users` (
00376 `id` int(11) NOT NULL auto_increment,
00377 `password` varchar(255) NOT NULL default '',
00378 `salt` varchar (40) NOT NULL default '',
00379 `activation` varchar(100) NOT NULL default '',
00380 PRIMARY KEY (`id`),
00381 KEY `activate` (`activation`)
00382 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00383
00384 -- --------------------------------------------------------
00385
00386 --
00387 -- Table structure for table `#__mail_log`
00388 --
00389
00390 CREATE TABLE IF NOT EXISTS `#__mail_log` (
00391 `id` int(11) NOT NULL auto_increment,
00392 `userid` int(11) NOT NULL default '0',
00393 `date` datetime NOT NULL default '0000-00-00 00:00:00',
00394 `transport` char (10) NOT NULL default '',
00395 `recipient` varchar (255) NOT NULL default '',
00396 `query` text NOT NULL default '',
00397 `post` text NOT NULL default '',
00398 PRIMARY KEY (`id`)
00399 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00400
00401 -- --------------------------------------------------------
00402
00403 --
00404 -- Table structure for table `#__error_log`
00405 --
00406
00407 CREATE TABLE IF NOT EXISTS `#__error_log` (
00408 `id` int(11) NOT NULL auto_increment,
00409 `timestamp` datetime NOT NULL,
00410 `smessage` varchar(255) NOT NULL,
00411 `dbname` varchar(255) NOT NULL default '',
00412 `dberror` varchar(255) NOT NULL default '',
00413 `dbmessage` varchar(255) NOT NULL default '',
00414 `dbtrace` text NOT NULL default '',
00415 `sql` text NOT NULL default '',
00416 `lmessage` text NOT NULL default '',
00417 `errorkey` text NOT NULL default '',
00418 `referer` text NOT NULL default '',
00419 `get` text NOT NULL default '',
00420 `post` text NOT NULL default '',
00421 `trace` text NOT NULL default '',
00422 PRIMARY KEY (`id`)
00423 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00424
00425 -- --------------------------------------------------------
00426
00427 --
00428 -- Table structure for table `#__error_404`
00429 --
00430
00431 CREATE TABLE IF NOT EXISTS `#__error_404` (
00432 `uri` text NOT NULL,
00433 `timestamp` datetime NOT NULL,
00434 `referer` text NOT NULL,
00435 `post` text NOT NULL,
00436 `trace` text NOT NULL,
00437 PRIMARY KEY (`uri`(250))
00438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
