/**
 * Joom!Fish - Multi Lingual extention and translation manager for Joomla!
 * Copyright (C) 2003-2006 Think Network GmbH, Munich
 * 
 * All rights reserved.  The Joom!Fish project is a set of extentions for 
 * the content management system Joomla!. It enables Joomla! 
 * to manage multi lingual sites especially in all dynamic information 
 * which are stored in the database.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.
 *
 * The "GNU Lesser General Public License" (LGPL) is available at
 * http: *www.gnu.org/copyleft/lgpl.html
 * -----------------------------------------------------------------------------
 * $Id: ReadMe,v 1.2 2005/03/15 11:07:01 akede Exp $
 *
*/

/** SQL Script to create the structure and main information of JoomFish **/

DROP TABLE IF EXISTS `jos_jf_content`;
CREATE TABLE `jos_jf_content` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '0',
  `reference_id` int(11) NOT NULL default '0',
  `reference_table` varchar(100) NOT NULL default '',
  `reference_field` varchar(100) NOT NULL default '',
  `value` mediumtext NOT NULL default '',
  `original_value` varchar(255) default NULL,
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified_by` int(11) unsigned NOT NULL default '0',
  `published` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `jos_languages`;
CREATE TABLE `jos_languages` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  `iso` varchar(10) default NULL,
  `code` varchar(20) NOT NULL default '',
  `image` varchar(100) default NULL,
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;


INSERT INTO `jos_languages` VALUES (1, 'English', 1, 'en', 'english', '', 0);

DROP TABLE IF EXISTS `jos_jf_tableinfo`;
CREATE TABLE `jos_jf_tableinfo` (
  `id` int(11) NOT NULL auto_increment,
  `joomlatablename` varchar(100) collate latin1_general_ci NOT NULL default '',
  `tablepkID` varchar(100) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;


/** These commands only for absolute manual installation on clean install!

INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`)
 VALUES (20, 'Joom!Fish', 'com_joomfish', 0, 0, 'option=com_joomfish', 'Joom!Fish', 'com_joomfish', 0, 'js/ThemeOffice/joomfish.png', 0, ''),
(21, '<b>Tłumaczenia</b>', '', 0, 20, 'option=com_joomfish&act=translate', 'Translation', 'com_joomfish', 1, 'js/ThemeOffice/content.png', 0, ''),
(22, '<b>KOnfiguracja</b>', '', 0, 20, 'option=com_joomfish&act=config_component&&hidemainmenu=1', 'Configuration', 'com_joomfish', 2, 'js/ThemeOffice/config.png', 0, ''),
(23, '> Języki', '', 0, 20, 'option=com_joomfish&act=config_language', 'Language configuration', 'com_joomfish', 3, 'js/ThemeOffice/language.png', 0, ''),
(24, '> Zawartość', '', 0, 20, 'option=com_joomfish&act=config_elements', 'Content configuration', 'com_joomfish', 4, 'js/ThemeOffice/controlpanel.png', 0, ''),
(25, 'O komponencie', '', 0, 20, 'option=com_joomfish&act=credits', 'About', 'com_joomfish', 5, 'js/ThemeOffice/credits.png', 0, '');

INSERT INTO `jos_modules` (`title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES ('JoomFish language selection', '', 2, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_jflanguageselection', 0, 0, 0, 'inc_jf_css=1\nmoduleclass_sfx=\ncache=0\ntype=images\nspacer=\nshow_acitve=1', 0, 0);

INSERT INTO `jos_mambots` (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) 
  VALUES ('multi lingual content searchbot', 'jfcontent.searchbot', 'search', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
			('Multi lingual abstraction layer bot', 'jfdatabase.systembot', 'system', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');

INSERT INTO `jos_mambots` VALUES (20, 'multi lingual content searchbot', 'jfcontent.searchbot', 'search', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
INSERT INTO `jos_mambots` VALUES (21, 'Multi lingual abstraction layer bot', 'jfdatabase.systembot', 'system', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');


*/