SQL=Table ‘jos_banner’ already exists: - - - - - - - - - - # $Id: joomla.sql 677 2005-10-27 02:13:29Z spacemonkey $ # Table structure for table jos_banner CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_bannerclient CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_bannerfinish CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_categories CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_components CREATE TABLE jos_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: - - - - - - - - - - # Dumping data for table jos_components INSERT INTO jos_components VALUES (1, ‘Banery’, ‘’, 0, 0, ‘’, ‘Zarządzaj banerami’, ‘com_banners’, 0, ‘js/ThemeOffice/component.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘2’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (2, ‘Wykaz banerów’, ‘’, 0, 1, ‘option=com_banners’, ‘Aktywuj banery, zobacz statystykę’, ‘com_banners’, 1, ‘js/ThemeOffice/edit.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘3’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (3, ‘Klienci’, ‘’, 0, 1, ‘option=com_banners&task=listclients’, ‘Zarządzaj zamówieniami’, ‘com_banners’, 2, ‘js/ThemeOffice/categories.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘4’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (4, ‘Katalog linków’, ‘option=com_weblinks’, 0, 0, ‘’, ‘Zarządzaj adresami URL’, ‘com_weblinks’, 0, ‘js/ThemeOffice/globe2.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘5’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (5, ‘Odnośniki’, ‘’, 0, 4, ‘option=com_weblinks’, ‘Zarządzaj zbiórem odnośników’, ‘com_weblinks’, 1, ‘js/ThemeOffice/edit.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘6’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (6, ‘Kategorie odnośników’, ‘’, 0, 4, ‘option=categories§ion=com_weblinks’, ‘Zarządzaj kategoriami odnośników’, ‘’, 2, ‘js/ThemeOffice/categories.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘7’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (7, ‘Kontakty’, ‘option=com_contact’, 0, 0, ‘’, ‘Edytuj szczegóły kontaktów’, ‘com_contact’, 0, ‘js/ThemeOffice/user.png’, 1, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘8’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (8, ‘Katalog kontaktów’, ‘’, 0, 7, ‘option=com_contact’, ‘Edytuj szczegóły kontaktów’, ‘com_contact’, 0, ‘js/ThemeOffice/edit.png’, 1, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘9’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (9, ‘Kategorie kontaktów’, ‘’, 0, 7, ‘option=categories§ion=com_contact_details’, ‘Zarządzaj kategoriami kontaktów’, ‘’, 2, ‘js/ThemeOffice/categories.png’, 1, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘10’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (10, ‘Strona startowa’, ‘option=com_frontpage’, 0, 0, ‘’, ‘Dobierz pozycje na stronę startową’, ‘com_frontpage’, 0, ‘js/ThemeOffice/component.png’, 1, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘11’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (11, ‘Sondy’, ‘option=com_poll’, 0, 0, ‘option=com_poll’, ‘Zarządzaj sondami’, ‘com_poll’, 0, ‘js/ThemeOffice/component.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘12’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (12, ‘Spinacz RSS’, ‘option=com_newsfeeds’, 0, 0, ‘’, ‘Zarządzaj nagłówkami RSS’, ‘com_newsfeeds’, 0, ‘js/ThemeOffice/component.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘13’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (13, ‘Kanały RSS’, ‘’, 0, 12, ‘option=com_newsfeeds’, ‘Zarządzaj nagłówkami RSS’, ‘com_newsfeeds’, 1, ‘js/ThemeOffice/edit.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘14’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (14, ‘Kategorie RSS’, ‘’, 0, 12, ‘option=com_categories§ion=com_newsfeeds’, ‘Zarządzaj kategoriami RSS’, ‘’, 2, ‘js/ThemeOffice/categories.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘15’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (15, ‘Logowanie’, ‘option=com_login’, 0, 0, ‘’, ‘’, ‘com_login’, 0, ‘’, 1, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘16’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (16, ‘Wyszukiwarka’, ‘option=com_search’, 0, 0, ‘’, ‘’, ‘com_search’, 0, ‘’, 1, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘17’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (17, ‘Syndicate’, ‘’, 0, 0, ‘option=com_syndicate&hidemainmenu=1’, ‘Zarządzaj ustawieniami kolportera RSS’, ‘com_syndicate’, 0, ‘js/ThemeOffice/component.png’, 0, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘18’ for key 1: - - - - - - - - - - INSERT INTO jos_components VALUES (18, ‘Korespondencja seryjna’, ‘’, 0, 0, ‘option=com_massmail&hidemainmenu=1’, ‘Wyślij pocztę elektronicznš do użytkowników’, ‘com_massmail’, 0, ‘js/ThemeOffice/mass_email.png’, 0, ‘’) = = = = = = = = = = SQL=Table ‘jos_contact_details’ already exists: - - - - - - - - - - # Table structure for table jos_contact_details CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_content CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_content_frontpage CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_content_rating CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_core_log_items # To be implemented in Version 4.6 CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_core_log_searches # To be implemented in Version 4.6 CREATE TABLE jos_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: - - - - - - - - - - # Table structure for table jos_groups CREATE TABLE jos_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: - - - - - - - - - - # Dumping data for table jos_groups INSERT INTO jos_groups VALUES (0, ‘Public’) = = = = = = = = = = SQL=Duplicate entry ‘1’ for key 1: - - - - - - - - - - INSERT INTO jos_groups VALUES (1, ‘Registered’) = = = = = = = = = = SQL=Duplicate entry ‘2’ for key 1: - - - - - - - - - - INSERT INTO jos_groups VALUES (2, ‘Special’) = = = = = = = = = = SQL=Table ‘jos_mambots’ already exists: - - - - - - - - - - # Table structure for table jos_mambots CREATE TABLE jos_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: - - - - - - - - - - INSERT INTO jos_mambots VALUES (1, ‘Wstawianie obrazków [inserImage, MOSImage]’, ‘mosimage’, ‘content’, 0, -10000, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘2’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (2, ‘Stronicowanie [Pagination]’, ‘mospaging’, ‘content’, 0, 10000, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘3’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (3, ‘Dawne dodatki [LegacyBots]’, ‘legacybots’, ‘content’, 0, 1, 0, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘4’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (4, ‘Wsparcie wyszukiwarek SEF’, ‘mossef’, ‘content’, 0, 3, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘5’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (5, ‘Ocenianie [Voting]’, ‘mosvote’, ‘content’, 0, 4, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘6’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (6, ‘Szukaj w Artykułach [Content searchbot]’, ‘content.searchbot’, ‘search’, 0, 1, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘7’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (7, ‘Szukaj w Katalogu linków [Weblinks searchbot]’, ‘weblinks.searchbot’, ‘search’, 0, 2, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘8’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (8, ‘Formatowanie kodu [Code Support]’, ‘moscode’, ‘content’, 0, 2, 0, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘9’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (9, ‘Edytor - zwykły [No WYSIWYG Editor]’, ‘none’, ‘editors’, 0, 1, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘10’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (10,‘Edytor WYSIWYG TinyMCE’,‘tinymce’,‘editors’,0,0,1,1,0,0,‘0000-00-00 00:00:00’,‘theme=advanced’) = = = = = = = = = = SQL=Duplicate entry ‘11’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (11, ‘Przycisk - Wstaw obrazek [insertImage]’, ‘mosimage.btn’, ‘editors-xtd’, 0, 0, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘12’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (12, ‘Przycisk - Podziel artykuł [insertPageBreak]’, ‘mospage.btn’, ‘editors-xtd’, 0, 0, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘13’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (13, ‘Szukaj w Kontaktach [Contacts searchbot]’, ‘contacts.searchbot’, ‘search’, 0, 3, 1, 1, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘14’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (14, ‘Szukaj w Kategoriach [Categories searchbot]’, ‘categories.searchbot’, ‘search’, 0, 4, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘15’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (15, ‘Szukaj w Sekcjach [sections searchbot]’, ‘sections.searchbot’, ‘search’, 0, 5, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘16’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (16, ‘Maskowanie adresów e-mail [Email Cloaking]’, ‘mosemailcloak’, ‘content’, 0, 5, 0, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘17’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (17, ‘Kolorowanie składni [GeSHi]’, ‘geshi’, ‘content’, 0, 5, 0, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘18’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (18, ‘Szukaj w Spinaczu RSS [Newsfeeds searchbot]’, ‘newsfeeds.searchbot’, ‘search’, 0, 6, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘19’ for key 1: - - - - - - - - - - INSERT INTO jos_mambots VALUES (19, ‘Wpinacz modułów [MosLoadPosition]’, ‘mosloadposition’, ‘content’, 0, 6, 1, 0, 0, 0, ‘0000-00-00 00:00:00’, ‘’) = = = = = = = = = = SQL=Table ‘jos_menu’ already exists: - - - - - - - - - - # Table structure for table jos_menu CREATE TABLE jos_menu ( id int(11) NOT NULL auto_increment, menutype varchar(25) default NULL, name varchar(100) default NULL, link text, type varchar(50) NOT NULL default ‘’, published tinyint(1) NOT NULL default ‘0’, parent int(11) unsigned NOT NULL default ‘0’, componentid int(11) unsigned NOT NULL default ‘0’, sublevel int(11) default ‘0’, ordering int(11) default ‘0’, checked_out int(11) unsigned NOT NULL default ‘0’, checked_out_time datetime NOT NULL default ‘0000-00-00 00:00:00’, pollid int(11) NOT NULL default ‘0’, browserNav tinyint(4) default ‘0’, access tinyint(3) unsigned NOT NULL default ‘0’, utaccess tinyint(3) unsigned NOT NULL default ‘0’, params text NOT NULL, PRIMARY KEY (id), KEY componentid (componentid,menutype,published,access), KEY menutype (menutype) ) TYPE=MyISAM = = = = = = = = = = SQL=Duplicate entry ‘1’ for key 1: - - - - - - - - - - INSERT INTO jos_menu VALUES (1, ‘mainmenu’, ‘Start’, ‘index.php?option=com_frontpage’, ‘components’, 1, 0, 10, 0, 1, 0, ‘0000-00-00 00:00:00’, 0, 0, 0, 3, ‘leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Witamy na stronie startowej\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0’) = = = = = = = = = = SQL=Table ‘jos_messages’ already exists: - - - - - - - - - - # Table structure for table jos_messages CREATE TABLE jos_messages ( message_id int(10) unsigned NOT NULL auto_increment, user_id_from int(10) unsigned NOT NULL default ‘0’, user_id_to int(10) unsigned NOT NULL default ‘0’, folder_id int(10) unsigned NOT NULL default ‘0’, date_time datetime NOT NULL default ‘0000-00-00 00:00:00’, state int(11) NOT NULL default ‘0’, priority int(1) unsigned NOT NULL default ‘0’, subject varchar(230) NOT NULL default ‘’, message text NOT NULL, PRIMARY KEY (message_id) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_messages_cfg’ already exists: - - - - - - - - - - # Table structure for table jos_messages_cfg CREATE TABLE jos_messages_cfg ( user_id int(10) unsigned NOT NULL default ‘0’, cfg_name varchar(100) NOT NULL default ‘’, cfg_value varchar(255) NOT NULL default ‘’, UNIQUE idx_user_var_name (user_id,cfg_name) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_modules’ already exists: - - - - - - - - - - # Table structure for table jos_modules CREATE TABLE jos_modules ( id int(11) NOT NULL auto_increment, title text NOT NULL, content text NOT NULL, ordering int(11) NOT NULL default ‘0’, position varchar(10) default NULL, checked_out int(11) unsigned NOT NULL default ‘0’, checked_out_time datetime NOT NULL default ‘0000-00-00 00:00:00’, published tinyint(1) NOT NULL default ‘0’, module varchar(50) default NULL, numnews int(11) NOT NULL default ‘0’, access tinyint(3) unsigned NOT NULL default ‘0’, showtitle tinyint(3) unsigned NOT NULL default ‘1’, params text NOT NULL, iscore tinyint(4) NOT NULL default ‘0’, client_id tinyint(4) NOT NULL default ‘0’, PRIMARY KEY (id), KEY published (published,access), KEY newsfeeds (module,published) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_modules_menu’ already exists: - - - - - - - - - - # Table structure for table jos_modules_menu CREATE TABLE jos_modules_menu ( moduleid int(11) NOT NULL default ‘0’, menuid int(11) NOT NULL default ‘0’, PRIMARY KEY (moduleid,menuid) ) TYPE=MyISAM = = = = = = = = = = SQL=Duplicate entry ‘1-1’ for key 1: - - - - - - - - - - # Dumping data for table jos_modules_menu INSERT INTO jos_modules_menu VALUES (1,1) = = = = = = = = = = SQL=Duplicate entry ‘2-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (2,0) = = = = = = = = = = SQL=Duplicate entry ‘3-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (3,0) = = = = = = = = = = SQL=Duplicate entry ‘4-1’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (4,1) = = = = = = = = = = SQL=Duplicate entry ‘5-1’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (5,1) = = = = = = = = = = SQL=Duplicate entry ‘6-1’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (6,1) = = = = = = = = = = SQL=Duplicate entry ‘6-2’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (6,2) = = = = = = = = = = SQL=Duplicate entry ‘6-4’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (6,4) = = = = = = = = = = SQL=Duplicate entry ‘6-27’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (6,27) = = = = = = = = = = SQL=Duplicate entry ‘6-36’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (6,36) = = = = = = = = = = SQL=Duplicate entry ‘8-1’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (8,1) = = = = = = = = = = SQL=Duplicate entry ‘9-1’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (9,1) = = = = = = = = = = SQL=Duplicate entry ‘9-2’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (9,2) = = = = = = = = = = SQL=Duplicate entry ‘9-4’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (9,4) = = = = = = = = = = SQL=Duplicate entry ‘9-27’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (9,27) = = = = = = = = = = SQL=Duplicate entry ‘9-36’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (9,36) = = = = = = = = = = SQL=Duplicate entry ‘10-1’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (10,1) = = = = = = = = = = SQL=Duplicate entry ‘13-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (13,0) = = = = = = = = = = SQL=Duplicate entry ‘15-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (15,0) = = = = = = = = = = SQL=Duplicate entry ‘17-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (17,0) = = = = = = = = = = SQL=Duplicate entry ‘18-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (18,0) = = = = = = = = = = SQL=Duplicate entry ‘30-0’ for key 1: - - - - - - - - - - INSERT INTO jos_modules_menu VALUES (30,0) = = = = = = = = = = SQL=Table ‘jos_newsfeeds’ already exists: - - - - - - - - - - # Table structure for table jos_newsfeeds CREATE TABLE jos_newsfeeds ( catid int(11) NOT NULL default ‘0’, id int(11) NOT NULL auto_increment, name text NOT NULL, link text NOT NULL, filename varchar(200) default NULL, published tinyint(1) NOT NULL default ‘0’, numarticles int(11) unsigned NOT NULL default ‘1’, cache_time int(11) unsigned NOT NULL default ‘3600’, checked_out tinyint(3) 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’, PRIMARY KEY (id), KEY published (published) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_poll_data’ already exists: - - - - - - - - - - # Table structure for table jos_poll_data CREATE TABLE jos_poll_data ( id int(11) NOT NULL auto_increment, pollid int(4) NOT NULL default ‘0’, text text NOT NULL default ‘’, hits int(11) NOT NULL default ‘0’, PRIMARY KEY (id), KEY pollid (pollid,text(1)) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_poll_date’ already exists: - - - - - - - - - - # Table structure for table jos_poll_date CREATE TABLE jos_poll_date ( id bigint(20) NOT NULL auto_increment, date datetime NOT NULL default ‘0000-00-00 00:00:00’, vote_id int(11) NOT NULL default ‘0’, poll_id int(11) NOT NULL default ‘0’, PRIMARY KEY (id), KEY poll_id (poll_id) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_polls’ already exists: - - - - - - - - - - # Table structure for table jos_polls CREATE TABLE jos_polls ( id int(11) unsigned NOT NULL auto_increment, title varchar(100) NOT NULL default ‘’, voters int(9) NOT NULL default ‘0’, checked_out int(11) NOT NULL default ‘0’, checked_out_time datetime NOT NULL default ‘0000-00-00 00:00:00’, published tinyint(1) NOT NULL default ‘0’, access int(11) NOT NULL default ‘0’, lag int(11) NOT NULL default ‘0’, PRIMARY KEY (id) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_poll_menu’ already exists: - - - - - - - - - - # Table structure for table jos_poll_menu CREATE TABLE jos_poll_menu ( pollid int(11) NOT NULL default ‘0’, menuid int(11) NOT NULL default ‘0’, PRIMARY KEY (pollid,menuid) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_sections’ already exists: - - - - - - - - - - # Table structure for table jos_sections CREATE TABLE jos_sections ( id int(11) NOT NULL auto_increment, title varchar(50) NOT NULL default ‘’, name varchar(255) NOT NULL default ‘’, image varchar(100) NOT NULL default ‘’, scope 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’, 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 idx_scope (scope) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_session’ already exists: - - - - - - - - - - # Table structure for table jos_session CREATE TABLE jos_session ( username varchar(50) default ‘’, time varchar(14) default ‘’, session_id varchar(200) NOT NULL default ‘0’, guest tinyint(4) default ‘1’, userid int(11) default ‘0’, usertype varchar(50) default ‘’, gid tinyint(3) unsigned NOT NULL default ‘0’, PRIMARY KEY (session_id), KEY whosonline (guest,usertype) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_stats_agents’ already exists: - - - - - - - - - - # Table structure for table jos_stats_agents CREATE TABLE jos_stats_agents ( agent varchar(255) NOT NULL default ‘’, type tinyint(1) unsigned NOT NULL default ‘0’, hits int(11) unsigned NOT NULL default ‘1’ ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_templates_menu’ already exists: - - - - - - - - - - # Table structure for table jos_templates_menu CREATE TABLE jos_templates_menu ( template varchar(50) NOT NULL default ‘’, menuid int(11) NOT NULL default ‘0’, client_id tinyint(4) NOT NULL default ‘0’, PRIMARY KEY (template,menuid) ) TYPE=MyISAM = = = = = = = = = = SQL=Duplicate entry ‘em108-0’ for key 1: - - - - - - - - - - INSERT INTO jos_templates_menu VALUES (‘em108’, 0, 0) = = = = = = = = = = SQL=Duplicate entry ‘joomla_admin-0’ for key 1: - - - - - - - - - - INSERT INTO jos_templates_menu VALUES (‘joomla_admin’, 0, 1) = = = = = = = = = = SQL=Table ‘jos_template_positions’ already exists: - - - - - - - - - - # Table structure for table jos_template_positions CREATE TABLE jos_template_positions ( id int(11) NOT NULL auto_increment, position varchar(10) NOT NULL default ‘’, description varchar(255) NOT NULL default ‘’, PRIMARY KEY (id) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_users’ already exists: - - - - - - - - - - # Table structure for table jos_users CREATE TABLE jos_users ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default ‘’, username varchar(25) NOT NULL default ‘’, email varchar(100) NOT NULL default ‘’, password varchar(100) NOT NULL default ‘’, usertype varchar(25) NOT NULL default ‘’, block tinyint(4) NOT NULL default ‘0’, sendEmail tinyint(4) default ‘0’, gid tinyint(3) unsigned NOT NULL default ‘1’, registerDate datetime NOT NULL default ‘0000-00-00 00:00:00’, lastvisitDate datetime NOT NULL default ‘0000-00-00 00:00:00’, activation varchar(100) NOT NULL default ‘’, params text NOT NULL, PRIMARY KEY (id), KEY usertype (usertype), KEY idx_name (name) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_usertypes’ already exists: - - - - - - - - - - # Table structure for table jos_usertypes CREATE TABLE jos_usertypes ( id tinyint(3) unsigned NOT NULL default ‘0’, name varchar(50) NOT NULL default ‘’, mask varchar(11) NOT NULL default ‘’, PRIMARY KEY (id) ) TYPE=MyISAM = = = = = = = = = = SQL=Duplicate entry ‘0’ for key 1: - - - - - - - - - - # Dumping data for table jos_usertypes INSERT INTO jos_usertypes VALUES (0, ‘superadministrator’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘1’ for key 1: - - - - - - - - - - INSERT INTO jos_usertypes VALUES (1, ‘administrator’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘2’ for key 1: - - - - - - - - - - INSERT INTO jos_usertypes VALUES (2, ‘editor’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘3’ for key 1: - - - - - - - - - - INSERT INTO jos_usertypes VALUES (3, ‘user’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘4’ for key 1: - - - - - - - - - - INSERT INTO jos_usertypes VALUES (4, ‘author’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘5’ for key 1: - - - - - - - - - - INSERT INTO jos_usertypes VALUES (5, ‘publisher’, ‘’) = = = = = = = = = = SQL=Duplicate entry ‘6’ for key 1: - - - - - - - - - - INSERT INTO jos_usertypes VALUES (6, ‘manager’, ‘’) = = = = = = = = = = SQL=Table ‘jos_weblinks’ already exists: - - - - - - - - - - # Table structure for table jos_weblinks CREATE TABLE jos_weblinks ( id int(11) unsigned NOT NULL auto_increment, catid int(11) NOT NULL default ‘0’, sid int(11) NOT NULL default ‘0’, title varchar(250) NOT NULL default ‘’, url varchar(250) NOT NULL default ‘’, description varchar(250) NOT NULL default ‘’, date datetime NOT NULL default ‘0000-00-00 00:00:00’, hits int(11) NOT NULL default ‘0’, published tinyint(1) NOT NULL default ‘0’, checked_out int(11) NOT NULL default ‘0’, checked_out_time datetime NOT NULL default ‘0000-00-00 00:00:00’, ordering int(11) NOT NULL default ‘0’, archived tinyint(1) NOT NULL default ‘0’, approved tinyint(1) NOT NULL default ‘1’, params text NOT NULL, PRIMARY KEY (id), KEY catid (catid,published,archived) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_core_acl_aro’ already exists: - - - - - - - - - - # Table structure for table jos_core_acl_aro CREATE TABLE jos_core_acl_aro ( aro_id int(11) NOT NULL auto_increment, section_value varchar(240) NOT NULL default ‘0’, value varchar(240) NOT NULL default ‘’, order_value int(11) NOT NULL default ‘0’, name varchar(255) NOT NULL default ‘’, hidden int(11) NOT NULL default ‘0’, PRIMARY KEY (aro_id), UNIQUE KEY jos_gacl_section_value_value_aro (section_value(100),value(100)), KEY jos_gacl_hidden_aro (hidden) ) TYPE=MyISAM = = = = = = = = = = SQL=Table ‘jos_core_acl_aro_groups’ already exists: - - - - - - - - - - # Table structure for table jos_core_acl_aro_groups CREATE TABLE jos_core_acl_aro_groups ( group_id int(11) NOT NULL auto_increment, parent_id int(11) NOT NULL default ‘0’, name varchar(255) NOT NULL default ‘’, lft int(11) NOT NULL default ‘0’, rgt int(11) NOT NULL default ‘0’, PRIMARY KEY (group_id), KEY parent_id_aro_groups (parent_id), KEY jos_gacl_parent_id_aro_groups (parent_id), KEY jos_gacl_lft_rgt_aro_groups (lft,rgt) ) TYPE=MyISAM = = = = = = = = = = SQL=Duplicate entry ‘17’ for key 1: - - - - - - - - - - # Dumping data for table jos_core_acl_aro_groups INSERT INTO jos_core_acl_aro_groups VALUES (17,0,‘ROOT’,1,22) = = = = = = = = = = SQL=Duplicate entry ‘28’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (28,17,‘USERS’,2,21) = = = = = = = = = = SQL=Duplicate entry ‘29’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (29,28,‘Public Frontend’,3,12) = = = = = = = = = = SQL=Duplicate entry ‘18’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (18,29,‘Registered’,4,11) = = = = = = = = = = SQL=Duplicate entry ‘19’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (19,18,‘Author’,5,10) = = = = = = = = = = SQL=Duplicate entry ‘20’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (20,19,‘Editor’,6,9) = = = = = = = = = = SQL=Duplicate entry ‘21’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (21,20,‘Publisher’,7,Cool = = = = = = = = = = SQL=Duplicate entry ‘30’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (30,28,‘Public Backend’,13,20) = = = = = = = = = = SQL=Duplicate entry ‘23’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (23,30,‘Manager’,14,19) = = = = = = = = = = SQL=Duplicate entry ‘24’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (24,23,‘Administrator’,15,1Cool = = = = = = = = = = SQL=Duplicate entry ‘25’ for key 1: - - - - - - - - - - INSERT INTO jos_core_acl_aro_groups VALUES (25,24,‘Super Administrator’,16,17) = = = = = = = = = = SQL=Table ‘jos_core_acl_groups_aro_map’ already exists: - - - - - - - - - - # Table structure for table jos_core_acl_groups_aro_map CREATE TABLE jos_core_acl_groups_aro_map ( group_id int(11) NOT NULL default ‘0’, section_value varchar(240) NOT NULL default ‘’, aro_id int(11) NOT NULL default ‘0’, UNIQUE KEY group_id_aro_id_groups_aro_map (group_id,section_value,aro_id) ) TYPE=MyISAM = = = = = = = = = =