بابهت: كێشهیهك له دامهزراندن
سڵاو..
بهڕێزان جوملهم ئهپلۆد كردوو ئێستا دایئهمهزرێنم بهڵام له ستێپی دووهم ئهم كێشهیهم ههیه :
SQL=Table \'jos_banner\' already exists SQL=# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $\n\n# Table structure for table `jos_banner`\n\nCREATE TABLE `jos_banner` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'banner\',\n `name` varchar(50) NOT NULL default \'\',\n `imptotal` int(11) NOT NULL default \'0\',\n `impmade` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(100) NOT NULL default \'\',\n `clickurl` varchar(200) NOT NULL default \'\',\n `date` datetime default NULL,\n `showBanner` tinyint(1) NOT NULL default \'0\',\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `custombannercode` text,\n PRIMARY KEY (`bid`),\n KEY `viewbanner` (`showBanner`)\n) TYPE=MyISAM AUTO_INCREMENT=1:
- - - - - - - - - -
# $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $
# Table structure for table `#__banner`
CREATE TABLE `#__banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM AUTO_INCREMENT=1
= = = = = = = = = =
SQL=Table \'jos_bannerclient\' already exists SQL=# Table structure for table `jos_bannerclient`\n\nCREATE TABLE `jos_bannerclient` (\n `cid` int(11) NOT NULL auto_increment,\n `name` varchar(60) NOT NULL default \'\',\n `contact` varchar(60) NOT NULL default \'\',\n `email` varchar(60) NOT NULL default \'\',\n `extrainfo` text NOT NULL,\n `checked_out` tinyint(1) NOT NULL default \'0\',\n `checked_out_time` time default NULL,\n `editor` varchar(50) default NULL,\n PRIMARY KEY (`cid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerclient`
CREATE TABLE `#__bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_bannerfinish\' already exists SQL=# Table structure for table `jos_bannerfinish`\n\nCREATE TABLE `jos_bannerfinish` (\n `bid` int(11) NOT NULL auto_increment,\n `cid` int(11) NOT NULL default \'0\',\n `type` varchar(10) NOT NULL default \'\',\n `name` varchar(50) NOT NULL default \'\',\n `impressions` int(11) NOT NULL default \'0\',\n `clicks` int(11) NOT NULL default \'0\',\n `imageurl` varchar(50) NOT NULL default \'\',\n `datestart` datetime default NULL,\n `dateend` datetime default NULL,\n PRIMARY KEY (`bid`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__bannerfinish`
CREATE TABLE `#__bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_categories\' already exists SQL=# Table structure for table `jos_categories`\n\nCREATE TABLE `jos_categories` (\n `id` int(11) NOT NULL auto_increment,\n `parent_id` int(11) NOT NULL default 0,\n `title` varchar(50) NOT NULL default \'\',\n `name` varchar(255) NOT NULL default \'\',\n `image` varchar(100) NOT NULL default \'\',\n `section` varchar(50) NOT NULL default \'\',\n `image_position` varchar(10) NOT NULL default \'\',\n `description` text NOT NULL,\n `published` tinyint(1) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `editor` varchar(50) default NULL,\n `ordering` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `count` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `cat_idx` (`section`,`published`,`access`),\n KEY `idx_section` (`section`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__categories`
CREATE TABLE `#__categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_components\' already exists SQL=# Table structure for table `jos_components`\n\nCREATE TABLE `jos_components` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(50) NOT NULL default \'\',\n `link` varchar(255) NOT NULL default \'\',\n `menuid` int(11) unsigned NOT NULL default \'0\',\n `parent` int(11) unsigned NOT NULL default \'0\',\n `admin_menu_link` varchar(255) NOT NULL default \'\',\n `admin_menu_alt` varchar(255) NOT NULL default \'\',\n `option` varchar(50) NOT NULL default \'\',\n `ordering` int(11) NOT NULL default \'0\',\n `admin_menu_img` varchar(255) NOT NULL default \'\',\n `iscore` tinyint(4) NOT NULL default \'0\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__components`
CREATE TABLE `#__components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=# Dumping data for table `jos_components`\n\nINSERT INTO `jos_components` VALUES (1, \'Banners\', \'\', 0, 0, \'\', \'Banner Management\', \'com_banners\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
# Dumping data for table `#__components`
INSERT INTO `#__components` VALUES (1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_components` VALUES (2, \'Manage Banners\', \'\', 0, 1, \'option=com_banners\', \'Active Banners\', \'com_banners\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (2, 'Manage Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_components` VALUES (3, \'Manage Clients\', \'\', 0, 1, \'option=com_banners&task=listclients\', \'Manage Clients\', \'com_banners\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (3, 'Manage Clients', '', 0, 1, 'option=com_banners&task=listclients', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_components` VALUES (4, \'Web Links\', \'option=com_weblinks\', 0, 0, \'\', \'Manage Weblinks\', \'com_weblinks\', 0, \'js/ThemeOffice/globe2.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_components` VALUES (5, \'Weblink Items\', \'\', 0, 4, \'option=com_weblinks\', \'View existing weblinks\', \'com_weblinks\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (5, 'Weblink Items', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_components` VALUES (6, \'Weblink Categories\', \'\', 0, 4, \'option=categories§ion=com_weblinks\', \'Manage weblink categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (6, 'Weblink Categories', '', 0, 4, 'option=categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_components` VALUES (7, \'Contacts\', \'option=com_contact\', 0, 0, \'\', \'Edit contact details\', \'com_contact\', 0, \'js/ThemeOffice/user.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_components` VALUES (8, \'Manage Contacts\', \'\', 0, 7, \'option=com_contact\', \'Edit contact details\', \'com_contact\', 0, \'js/ThemeOffice/edit.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (8, 'Manage Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_components` VALUES (9, \'Contact Categories\', \'\', 0, 7, \'option=categories§ion=com_contact_details\', \'Manage contact categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (9, 'Contact Categories', '', 0, 7, 'option=categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'10\' for key 1 SQL=INSERT INTO `jos_components` VALUES (10, \'FrontPage\', \'option=com_frontpage\', 0, 0, \'\', \'Manage Front Page Items\', \'com_frontpage\', 0, \'js/ThemeOffice/component.png\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (10, 'FrontPage', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'11\' for key 1 SQL=INSERT INTO `jos_components` VALUES (11, \'Polls\', \'option=com_poll\', 0, 0, \'option=com_poll\', \'Manage Polls\', \'com_poll\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (11, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'12\' for key 1 SQL=INSERT INTO `jos_components` VALUES (12, \'News Feeds\', \'option=com_newsfeeds\', 0, 0, \'\', \'News Feeds Management\', \'com_newsfeeds\', 0, \'js/ThemeOffice/component.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (12, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'13\' for key 1 SQL=INSERT INTO `jos_components` VALUES (13, \'Manage News Feeds\', \'\', 0, 12, \'option=com_newsfeeds\', \'Manage News Feeds\', \'com_newsfeeds\', 1, \'js/ThemeOffice/edit.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (13, 'Manage News Feeds', '', 0, 12, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'14\' for key 1 SQL=INSERT INTO `jos_components` VALUES (14, \'Manage Categories\', \'\', 0, 12, \'option=com_categories§ion=com_newsfeeds\', \'Manage Categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 0, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (14, 'Manage Categories', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '')
= = = = = = = = = =
SQL=Duplicate entry \'15\' for key 1 SQL=INSERT INTO `jos_components` VALUES (15, \'Login\', \'option=com_login\', 0, 0, \'\', \'\', \'com_login\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'16\' for key 1 SQL=INSERT INTO `jos_components` VALUES (16, \'Search\', \'option=com_search\', 0, 0, \'\', \'\', \'com_search\', 0, \'\', 1, \'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '')
= = = = = = = = = =
SQL=Duplicate entry \'17\' for key 1 SQL=INSERT INTO `jos_components` VALUES (17, \'Syndicate\',\'\',0,0,\'option=com_syndicate&hidemainmenu=1\',\'Manage Syndication Settings\',\'com_syndicate\',0,\'js/ThemeOffice/component.png\',0,\'\'):
- - - - - - - - - -
INSERT INTO `#__components` VALUES (17, 'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Manage Syndication Settings','com_syndicate',0,'js/ThemeOffice/component.png',0,'')
= = = = = = = = = =
SQL=Duplicate entry \'18\' for key 1 SQL=INSERT INTO `jos_components` VALUES (18, \'Mass Mail\', \'\', 0, 0, \'option=com_massmail&hidemainmenu=1\', \'Send Mass Mail\', \'com_massmail\', 0, \'js/ThemeOffice/mass_email.png\', 0, \'\'):
- - - - - - - - - -
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, '')
= = = = = = = = = =
SQL=Table \'jos_contact_details\' already exists SQL=# Table structure for table `jos_contact_details`\n\nCREATE TABLE `jos_contact_details` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default \'\',\n `con_position` varchar(50) default NULL,\n `address` text,\n `suburb` varchar(50) default NULL,\n `state` varchar(20) default NULL,\n `country` varchar(50) default NULL,\n `postcode` varchar(10) default NULL,\n `telephone` varchar(25) default NULL,\n `fax` varchar(25) default NULL,\n `misc` mediumtext,\n `image` varchar(100) default NULL,\n `imagepos` varchar(20) default NULL,\n `email_to` varchar(100) default NULL,\n `default_con` tinyint(1) unsigned NOT NULL default \'0\',\n `published` tinyint(1) unsigned NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `ordering` int(11) NOT NULL default \'0\',\n `params` text NOT NULL,\n `user_id` int(11) NOT NULL default \'0\',\n `catid` int(11) NOT NULL default \'0\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__contact_details`
CREATE TABLE `#__contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content\' already exists SQL=# Table structure for table `jos_content`\n\nCREATE TABLE `jos_content` (\n `id` int(11) unsigned NOT NULL auto_increment,\n `title` varchar(100) NOT NULL default \'\',\n `title_alias` varchar(100) NOT NULL default \'\',\n `introtext` mediumtext NOT NULL,\n `fulltext` mediumtext NOT NULL,\n `state` tinyint(3) NOT NULL default \'0\',\n `sectionid` int(11) unsigned NOT NULL default \'0\',\n `mask` int(11) unsigned NOT NULL default \'0\',\n `catid` int(11) unsigned NOT NULL default \'0\',\n `created` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `created_by` int(11) unsigned NOT NULL default \'0\',\n `created_by_alias` varchar(100) NOT NULL default \'\',\n `modified` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `modified_by` int(11) unsigned NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `publish_up` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `publish_down` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `images` text NOT NULL,\n `urls` text NOT NULL,\n `attribs` text NOT NULL,\n `version` int(11) unsigned NOT NULL default \'1\',\n `parentid` int(11) unsigned NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `metakey` text NOT NULL,\n `metadesc` text NOT NULL,\n `access` int(11) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'0\',\n PRIMARY KEY (`id`),\n KEY `idx_section` (`sectionid`),\n KEY `idx_access` (`access`),\n KEY `idx_checkout` (`checked_out`),\n KEY `idx_state` (`state`),\n KEY `idx_catid` (`catid`),\n KEY `idx_mask` (`mask`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content`
CREATE TABLE `#__content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content_frontpage\' already exists SQL=# Table structure for table `jos_content_frontpage`\n\nCREATE TABLE `jos_content_frontpage` (\n `content_id` int(11) NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n PRIMARY KEY (`content_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_frontpage`
CREATE TABLE `#__content_frontpage` (
`content_id` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_content_rating\' already exists SQL=# Table structure for table `jos_content_rating`\n\nCREATE TABLE `jos_content_rating` (\n `content_id` int(11) NOT NULL default \'0\',\n `rating_sum` int(11) unsigned NOT NULL default \'0\',\n `rating_count` int(11) unsigned NOT NULL default \'0\',\n `lastip` varchar(50) NOT NULL default \'\',\n PRIMARY KEY (`content_id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__content_rating`
CREATE TABLE `#__content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '0',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_core_log_items\' already exists SQL=# Table structure for table `jos_core_log_items`\n# To be implemented in Version 4.6\n\nCREATE TABLE `jos_core_log_items` (\n `time_stamp` date NOT NULL default \'0000-00-00\',\n `item_table` varchar(50) NOT NULL default \'\',\n `item_id` int(11) unsigned NOT NULL default \'0\',\n `hits` int(11) unsigned NOT NULL default \'0\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_items`
# To be implemented in Version 4.6
CREATE TABLE `#__core_log_items` (
`time_stamp` date NOT NULL default '0000-00-00',
`item_table` varchar(50) NOT NULL default '',
`item_id` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_core_log_searches\' already exists SQL=# Table structure for table `jos_core_log_searches`\n# To be implemented in Version 4.6\n\nCREATE TABLE `jos_core_log_searches` (\n `search_term` varchar(128) NOT NULL default \'\',\n `hits` int(11) unsigned NOT NULL default \'0\'\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__core_log_searches`
# To be implemented in Version 4.6
CREATE TABLE `#__core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table \'jos_groups\' already exists SQL=# Table structure for table `jos_groups`\n\nCREATE TABLE `jos_groups` (\n `id` tinyint(3) unsigned NOT NULL default \'0\',\n `name` varchar(50) NOT NULL default \'\',\n PRIMARY KEY (`id`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__groups`
CREATE TABLE `#__groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'0\' for key 1 SQL=# Dumping data for table `jos_groups`\n\nINSERT INTO `jos_groups` VALUES (0, \'Public\'):
- - - - - - - - - -
# Dumping data for table `#__groups`
INSERT INTO `#__groups` VALUES (0, 'Public')
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (1, \'Registered\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (1, 'Registered')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_groups` VALUES (2, \'Special\'):
- - - - - - - - - -
INSERT INTO `#__groups` VALUES (2, 'Special')
= = = = = = = = = =
SQL=Table \'jos_mambots\' already exists SQL=# Table structure for table `jos_mambots`\n\nCREATE TABLE `jos_mambots` (\n `id` int(11) NOT NULL auto_increment,\n `name` varchar(100) NOT NULL default \'\',\n `element` varchar(100) NOT NULL default \'\',\n `folder` varchar(100) NOT NULL default \'\',\n `access` tinyint(3) unsigned NOT NULL default \'0\',\n `ordering` int(11) NOT NULL default \'0\',\n `published` tinyint(3) NOT NULL default \'0\',\n `iscore` tinyint(3) NOT NULL default \'0\',\n `client_id` tinyint(3) NOT NULL default \'0\',\n `checked_out` int(11) unsigned NOT NULL default \'0\',\n `checked_out_time` datetime NOT NULL default \'0000-00-00 00:00:00\',\n `params` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__mambots`
CREATE TABLE `#__mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=Duplicate entry \'1\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (1,\'MOS Image\',\'mosimage\',\'content\',0,-10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'2\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (2,\'MOS Pagination\',\'mospaging\',\'content\',0,10000,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'3\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (3,\'Legacy Mambot Includer\',\'legacybots\',\'content\',0,1,0,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'4\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (4,\'SEF\',\'mossef\',\'content\',0,3,1,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'5\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (5,\'MOS Rating\',\'mosvote\',\'content\',0,4,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'6\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (6,\'Search Content\',\'content.searchbot\',\'search\',0,1,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'7\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (7,\'Search Weblinks\',\'weblinks.searchbot\',\'search\',0,2,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'8\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (8,\'Code support\',\'moscode\',\'content\',0,2,0,0,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =
SQL=Duplicate entry \'9\' for key 1 SQL=INSERT INTO `jos_mambots` VALUES (9,\'No WYSIWYG Editor\',\'none\',\'editors\',0,0,1,1,0,0,\'0000-00-00 00:00:00\',\'\'):
- - - - - - - - - -
INSERT INTO `#__mambots` VALUES (9,'No WYSIWYG Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','')
= = = = = = = = = =SQL=Duplicزۆر تریشه بهڵام جێگهی نابێتهوه
تكایه یارمهتی