00001
00002 --
00003 -- Table structure for table `#__categories`
00004 --
00005
00006 CREATE TABLE IF NOT EXISTS `#__categories` (
00007 `id` int(11) NOT NULL auto_increment,
00008 `parent_id` int(11) NOT NULL default '0',
00009 `title` varchar(50) NOT NULL default '',
00010 `name` varchar(255) NOT NULL default '',
00011 `image` varchar(100) NOT NULL default '',
00012 `section` varchar(50) NOT NULL default '',
00013 `image_position` varchar(10) NOT NULL default '',
00014 `description` text NOT NULL default '',
00015 `published` tinyint(1) NOT NULL default '0',
00016 `checked_out` int(11) unsigned NOT NULL default '0',
00017 `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
00018 `editor` varchar(50) default NULL,
00019 `ordering` int(11) NOT NULL default '0',
00020 `access` tinyint(3) unsigned NOT NULL default '0',
00021 `count` int(11) NOT NULL default '0',
00022 `params` text NOT NULL default '',
00023 PRIMARY KEY (`id`),
00024 KEY `cat_idx` (`section`,`published`,`access`),
00025 KEY `idx_section` (`section`),
00026 KEY `idx_access` (`access`),
00027 KEY `idx_checkout` (`checked_out`)
00028 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00029
00030 -- --------------------------------------------------------
00031
00032 --
00033 -- Table structure for table `#__configurations`
00034 --
00035
00036 CREATE TABLE IF NOT EXISTS `#__configurations` (
00037 `id` int(11) NOT NULL auto_increment,
00038 `system` varchar(100) NOT NULL default '',
00039 `component` varchar(100) NOT NULL default '',
00040 `property` varchar(100) NOT NULL default '',
00041 `value` text NOT NULL default '',
00042 PRIMARY KEY (`id`),
00043 KEY `owner` (`system`,`component`)
00044 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00045
00046 -- --------------------------------------------------------
00047
00048 --
00049 -- Table structure for table `#__core_acl_aro_groups`
00050 --
00051
00052 CREATE TABLE IF NOT EXISTS `#__core_acl_aro_groups` (
00053 `group_id` int(11) NOT NULL auto_increment,
00054 `parent_id` int(11) NOT NULL default '0',
00055 `name` varchar(255) NOT NULL default '',
00056 `lft` int(11) NOT NULL default '0',
00057 `rgt` int(11) NOT NULL default '0',
00058 PRIMARY KEY (`group_id`),
00059 KEY `parent_id_aro_groups` (`parent_id`),
00060 KEY `al_gacl_parent_id_aro_groups` (`parent_id`),
00061 KEY `al_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
00062 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
00063
00064 INSERT INTO `#__core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES
00065 (17, 0, 'ROOT', 1, 22),
00066 (28, 17, 'USERS', 2, 21),
00067 (29, 28, 'Public Frontend', 3, 12),
00068 (18, 29, 'Registered', 4, 11),
00069 (19, 18, 'Author', 5, 10),
00070 (20, 19, 'Editor', 6, 9),
00071 (21, 20, 'Publisher', 7, 8),
00072 (30, 28, 'Public Backend', 13, 20),
00073 (23, 30, 'Manager', 14, 19),
00074 (24, 23, 'Administrator', 15, 18),
00075 (25, 24, 'Super Administrator', 16, 17) ON DUPLICATE KEY UPDATE name = name;
00076
00077 -- --------------------------------------------------------
00078
00079 --
00080 -- Table structure for table `#__core_log_items`
00081 --
00082
00083 CREATE TABLE IF NOT EXISTS `#__core_log_items` (
00084 `time_stamp` date NOT NULL default '0000-00-00',
00085 `item_table` varchar(50) NOT NULL default '',
00086 `item_id` int(11) unsigned NOT NULL default '0',
00087 `hits` int(11) unsigned NOT NULL default '0',
00088 PRIMARY KEY (`time_stamp`,`item_table`,`item_id`)
00089 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00090
00091 -- --------------------------------------------------------
00092
00093 --
00094 -- Table structure for table `#__folders`
00095 --
00096
00097 CREATE TABLE IF NOT EXISTS `#__folders` (
00098 `id` int(11) NOT NULL auto_increment,
00099 `parentid` int(11) NOT NULL default '0',
00100 `ordering` int(11) NOT NULL default '0',
00101 `published` smallint(6) NOT NULL default '0',
00102 `childcount` int(11) NOT NULL default '0',
00103 `name` varchar(100) NOT NULL default '',
00104 `title` varchar(100) NOT NULL default '',
00105 `windowtitle` varchar(100) NOT NULL default '',
00106 `keywords` varchar(255) NOT NULL default '',
00107 `icon` varchar(25) NOT NULL default '',
00108 `description` text NOT NULL default '',
00109 `image` varchar(255) NOT NULL default '',
00110 `image_position` varchar(100) NOT NULL default '',
00111 PRIMARY KEY (`id`)
00112 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00113
00114 -- --------------------------------------------------------
00115
00116 --
00117 -- Table structure for table `#__tags`
00118 --
00119 CREATE TABLE IF NOT EXISTS `#__tags` (
00120 `id` int(11) NOT NULL auto_increment,
00121 `ordering` int(11) NOT NULL default '0',
00122 `frequency` int(11) NOT NULL default '0',
00123 `published` tinyint(3) unsigned NOT NULL default '0',
00124 `hidden` tinyint(3) unsigned NOT NULL default '0',
00125 `type` varchar(50) NOT NULL,
00126 `name` varchar(100) NOT NULL,
00127 `description` text NOT NULL,
00128 PRIMARY KEY (`id`),
00129 FULLTEXT KEY `searchname` (`name`)
00130 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00131
00132 -- --------------------------------------------------------
00133
00134 --
00135 -- Table structure for table `#__groups`
00136 --
00137
00138 CREATE TABLE IF NOT EXISTS `#__groups` (
00139 `id` tinyint(3) unsigned NOT NULL default '0',
00140 `name` varchar(100) NOT NULL default '',
00141 PRIMARY KEY (`id`)
00142 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00143
00144 INSERT INTO `#__groups` (`id`, `name`) VALUES
00145 (0, 'Public'),
00146 (1, 'Registered'),
00147 (2, 'Special');
00148
00149 -- --------------------------------------------------------
00150
00151 --
00152 -- Table structure for table `#__messages`
00153 --
00154
00155 CREATE TABLE IF NOT EXISTS `#__messages` (
00156 `message_id` int(10) unsigned NOT NULL auto_increment,
00157 `user_id_from` int(10) unsigned NOT NULL default '0',
00158 `user_id_to` int(10) unsigned NOT NULL default '0',
00159 `folder_id` int(10) unsigned NOT NULL default '0',
00160 `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
00161 `state` int(11) NOT NULL default '0',
00162 `priority` int(1) unsigned NOT NULL default '0',
00163 `subject` varchar(255) NOT NULL default '',
00164 `message` text NOT NULL default '',
00165 PRIMARY KEY (`message_id`)
00166 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00167
00168 -- --------------------------------------------------------
00169
00170 --
00171 -- Table structure for table `#__messages_cfg`
00172 --
00173
00174 CREATE TABLE IF NOT EXISTS `#__messages_cfg` (
00175 `user_id` int(10) unsigned NOT NULL default '0',
00176 `cfg_name` varchar(100) NOT NULL default '',
00177 `cfg_value` varchar(255) NOT NULL default '',
00178 UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
00179 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00180
00181 -- --------------------------------------------------------
00182
00183 --
00184 -- Table structure for table `#__parameters`
00185 --
00186
00187 CREATE TABLE IF NOT EXISTS `#__parameters` (
00188 `id` int(11) NOT NULL auto_increment,
00189 `param_name` varchar(100) NOT NULL default '',
00190 `param_file` varchar(255) NOT NULL default '',
00191 `param_version` varchar(50) NOT NULL default '',
00192 `params` text NOT NULL default '',
00193 PRIMARY KEY (`id`),
00194 KEY `names` (`param_name`,`param_version`)
00195 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00196
00197 -- --------------------------------------------------------
00198
00199 --
00200 -- Table structure for table `#__sections`
00201 --
00202
00203 CREATE TABLE IF NOT EXISTS `#__sections` (
00204 `id` int(11) NOT NULL auto_increment,
00205 `title` varchar(50) NOT NULL default '',
00206 `name` varchar(255) NOT NULL default '',
00207 `image` varchar(100) NOT NULL default '',
00208 `scope` varchar(50) NOT NULL default '',
00209 `image_position` varchar(10) NOT NULL default '',
00210 `description` text NOT NULL default '',
00211 `published` tinyint(1) NOT NULL default '0',
00212 `checked_out` int(11) unsigned NOT NULL default '0',
00213 `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
00214 `ordering` int(11) NOT NULL default '0',
00215 `access` tinyint(3) unsigned NOT NULL default '0',
00216 `count` int(11) NOT NULL default '0',
00217 `params` text NOT NULL default '',
00218 PRIMARY KEY (`id`),
00219 KEY `idx_scope` (`scope`)
00220 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00221
00222 -- --------------------------------------------------------
00223
00224 --
00225 -- Table structure for table `#__users`
00226 --
00227
00228 CREATE TABLE IF NOT EXISTS `#__users` (
00229 `id` int(11) NOT NULL,
00230 `name` varchar(255) NOT NULL default '',
00231 `username` varchar(100) NOT NULL default '',
00232 `email` varchar(255) NOT NULL default '',
00233 `usertype` varchar(100) NOT NULL default '',
00234 `block` tinyint(4) NOT NULL default '0',
00235 `sendEmail` tinyint(4) NOT NULL default '0',
00236 `gid` tinyint(3) unsigned NOT NULL default '1',
00237 `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
00238 `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
00239 `params` text NOT NULL default '',
00240 PRIMARY KEY (`id`),
00241 UNIQUE KEY `idx_username` (`username`),
00242 KEY `idx_email` (`email`),
00243 KEY `idx_name` (`name`)
00244 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00245
00246 --
00247 -- Table structure for table `#__remosef_config`
00248 --
00249
00250 CREATE TABLE IF NOT EXISTS `#__remosef_config` (
00251 `id` int(11) NOT NULL auto_increment,
00252 `type` varchar(20) NOT NULL default '',
00253 `name` text NOT NULL default '',
00254 `modified` text NOT NULL default '',
00255 PRIMARY KEY (`id`),
00256 KEY `sequence` (`type`,`name`(50))
00257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00258
00259 --
00260 -- Table structure for table `#__remosef_uri`
00261 --
00262
00263 CREATE TABLE IF NOT EXISTS `#__remosef_uri` (
00264 `id` int(11) NOT NULL auto_increment,
00265 `sef` text NOT NULL,
00266 `uri` text NOT NULL,
00267 `refreshed` int(11) NOT NULL default '0',
00268 PRIMARY KEY (`id`),
00269 KEY `sef` (`sef`(60)),
00270 KEY `uri` (`uri`(250))
00271 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00272
00273 --
00274 -- Table structure for table `#__remosef_metadata`
00275 --
00276
00277 CREATE TABLE IF NOT EXISTS `#__remosef_metadata` (
00278 `id` int(11) NOT NULL auto_increment,
00279 `type` varchar(10) NOT NULL,
00280 `uri` text NOT NULL,
00281 `htmltitle` varchar(255) NOT NULL,
00282 `robots` varchar(255) NOT NULL,
00283 `keywords` text NOT NULL,
00284 `description` text NOT NULL,
00285 PRIMARY KEY (`id`),
00286 KEY `finduri` (`uri`(60))
00287 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00288
