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