<?php
/**
* BreezingForms - A Joomla Forms Application
* @version 1.8
* @package BreezingForms
* @copyright (C) 2008-2012 by Markus Bopp
* @license Released under the terms of the GNU General Public License
**/
defined( '_JEXEC' ) or die( 'Direct Access to this location is not allowed.' );

$_1 = "DROP TABLE IF EXISTS `#__facileforms_config`;";

$_2 = "CREATE TABLE `#__facileforms_config` (
  `id` varchar(30) NOT NULL default '',
  `value` text,
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_3 = "DROP TABLE IF EXISTS `#__facileforms_packages`";


$_4 = "CREATE TABLE `#__facileforms_packages` (
  `id` varchar(30) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `version` varchar(30) NOT NULL default '',
  `created` varchar(20) NOT NULL default '',
  `title` varchar(50) NOT NULL default '',
  `author` varchar(50) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `url` varchar(50) NOT NULL default '',
  `description` varchar(100) NOT NULL default '',
  `copyright` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_5 = "INSERT INTO `#__facileforms_packages` VALUES (
  '',
  'mypck_001',
  '0.0.1',
  '2005-07-31 22:21:23',
  'My First Package',
  'My Name',
  'my.name@my.domain',
  'http://www.my.domain',
  'This is the first package that I created',
  'This FacileForms package is released under the GNU/GPL license'
)";

$_6 = "DROP TABLE IF EXISTS `#__facileforms_compmenus`";

$_7 = "CREATE TABLE `#__facileforms_compmenus` (
  `id` int(11) NOT NULL auto_increment,
  `package` VARCHAR( 30 ) NOT NULL default '',
  `parent` int(11) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '0',
  `img`  varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `page` int(11) NOT NULL default '1',
  `frame` tinyint(1) NOT NULL default '0',
  `border` tinyint(1) NOT NULL default '0',
  `params`  text,
  PRIMARY KEY  (`id`)
)  AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_8 = "DROP TABLE IF EXISTS `#__facileforms_forms`";

$_9 = "CREATE TABLE `#__facileforms_forms` (
  `id` int(11) NOT NULL auto_increment,
  `alt_mailfrom` TEXT,
  `alt_fromname` TEXT,
  `mb_alt_mailfrom` TEXT,
  `mb_alt_fromname` TEXT,
  `mailchimp_email_field` VARCHAR( 255 ) NOT NULL DEFAULT '',
  `mailchimp_checkbox_field` VARCHAR( 255 ) NOT NULL DEFAULT '',
  `mailchimp_api_key` VARCHAR( 255 ) NOT NULL DEFAULT '',
  `mailchimp_list_id` VARCHAR( 255 ) NOT NULL DEFAULT '',
  `mailchimp_double_optin` TINYINT( 1 ) NOT NULL DEFAULT 1,
  `mailchimp_mergevars` TEXT,
  `mailchimp_text_html_mobile_field` VARCHAR( 255 ) NOT NULL DEFAULT '',
  `mailchimp_send_errors` TINYINT( 1 ) NOT NULL DEFAULT 0,
  `mailchimp_default_type` VARCHAR( 255 ) NOT NULL DEFAULT 'text',
  `mailchimp_delete_member` TINYINT( 1 ) NOT NULL DEFAULT 0,
  `mailchimp_unsubscribe_field` VARCHAR( 255 ) NOT NULL DEFAULT '',
  
    `salesforce_token` VARCHAR( 255 ) NOT NULL DEFAULT '',
    `salesforce_username` VARCHAR( 255 ) NOT NULL DEFAULT '',
    `salesforce_password` VARCHAR( 255 ) NOT NULL DEFAULT '',
    `salesforce_type` VARCHAR( 255 ) NOT NULL DEFAULT '',
    `salesforce_fields` text,
    `salesforce_enabled` TINYINT( 1 ) NOT NULL DEFAULT 0,
    
    `dropbox_email` VARCHAR( 255 ) NOT NULL DEFAULT '',
    `dropbox_password` VARCHAR( 255 ) NOT NULL DEFAULT '',
    `dropbox_folder` TEXT,
    `dropbox_submission_enabled` TINYINT( 1 ) NOT NULL DEFAULT 0,
    `dropbox_submission_types` VARCHAR( 255 ) NOT NULL DEFAULT 'pdf',

    `tags_content` text NOT NULL,
    `tags_content_template` mediumtext NOT NULL,
    `tags_content_template_default_element` int(11) NOT NULL DEFAULT '0',
    `tags_form` text NOT NULL,
    `tags_content_default_category` int(11) NOT NULL DEFAULT '0',
    `tags_content_default_state` int(11) NOT NULL DEFAULT '1',
    `tags_content_default_access` int(11) NOT NULL DEFAULT '1',
    `tags_content_default_language` VARCHAR( 7 ) NOT NULL DEFAULT '*',
    `tags_content_default_featured` int(11) NOT NULL DEFAULT '0',
    `tags_content_default_publishup` VARCHAR( 255 ) NOT NULL DEFAULT '0000-00-00 00:00:00',
    `tags_content_default_publishdown` VARCHAR( 255 ) NOT NULL DEFAULT '0000-00-00 00:00:00',
    `autoheight` TINYINT( 1 ) NOT NULL DEFAULT '0',
    
  `package` VARCHAR( 30 ) NOT NULL default '',
  `template_code` longtext NOT NULL,
  `template_code_processed` longtext NOT NULL,
  `template_areas` longtext NOT NULL,
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '0',
  `runmode` tinyint(1) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `custom_mail_subject` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` text,
  `class1` varchar(30),
  `class2` varchar(30),
  `width` int(11) NOT NULL default '0',
  `widthmode` tinyint(1) NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL default '0',
  `heightmode` tinyint(1) NOT NULL DEFAULT '0',
  `pages` int(11) NOT NULL default '1',
  `emailntf` tinyint(1) NOT NULL default '1',
  `mb_emailntf` tinyint(1) NOT NULL default '1',
  `emaillog` tinyint(1) NOT NULL default '1',
  `mb_emaillog` tinyint(1) NOT NULL default '1',
  `emailxml` tinyint(1) NOT NULL default '0',
  `mb_emailxml` tinyint(1) NOT NULL default '0',
  `email_type` tinyint(1) NOT NULL DEFAULT '0',
  `mb_email_type` tinyint(1) NOT NULL DEFAULT '0',
  `email_custom_template` text,
  `mb_email_custom_template` text,
  `email_custom_html` tinyint(1) NOT NULL DEFAULT '0',
  `mb_email_custom_html` tinyint(1) NOT NULL DEFAULT '0',
  `emailadr` text,
  `dblog` tinyint(1) NOT NULL default '1',
  `script1cond` tinyint(1) NOT NULL default '0',
  `script1id` int(11) default NULL,
  `script1code` text,
  `script2cond` tinyint(1) NOT NULL default '0',
  `script2id` int(11) default NULL,
  `script2code` text,
  `piece1cond` tinyint(1) NOT NULL default '0',
  `piece1id` int(11) default NULL,
  `piece1code` text,
  `piece2cond` tinyint(1) NOT NULL default '0',
  `piece2id` int(11) default NULL,
  `piece2code` text,
  `piece3cond` tinyint(1) NOT NULL default '0',
  `piece3id` int(11) default NULL,
  `piece3code` text,
  `piece4cond` tinyint(1) NOT NULL default '0',
  `piece4id` int(11) default NULL,
  `piece4code` text,
  `prevmode` tinyint(1) NOT NULL default '2',
  `prevwidth` int(11),
  
  `double_opt` tinyint(1) NOT NULL DEFAULT '0',
  `opt_mail` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_9_1 = "ALTER TABLE `#__facileforms_forms`
  ADD KEY `double_opt` (`double_opt`),
  ADD KEY `opt_mail` (`opt_mail`)";

$_9_2 = "ALTER TABLE `#__facileforms_records`
  ADD KEY `opted` (`opted`),
  ADD KEY `opt_ip` (`opt_ip`),
  ADD KEY `opt_date` (`opt_date`),
  ADD KEY `opt_token` (`opt_token`)";

$_10 = "DROP TABLE IF EXISTS `#__facileforms_elements`";

$_11 = "CREATE TABLE `#__facileforms_elements` (
  `id` int(11) NOT NULL auto_increment,
  `form` int(11) NOT NULL default '0',
  `page` int(11) NOT NULL default '1',
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `type` varchar(50) NOT NULL default '',
  `class1` VARCHAR(30),
  `class2` VARCHAR(30),
  `logging` tinyint(1) NOT NULL default '1',
  `posx` int(11) default NULL,
  `posxmode` TINYINT(1) NOT NULL DEFAULT '0',
  `posy` int(11) default NULL,
  `posymode` TINYINT(1) NOT NULL DEFAULT '0',
  `width` int(11) default NULL,
  `widthmode` TINYINT(1) NOT NULL DEFAULT '0',
  `height` int(11) default NULL,
  `heightmode` TINYINT(1) NOT NULL DEFAULT '0',
  `flag1` tinyint(1) NOT NULL default '0',
  `flag2` tinyint(1) NOT NULL default '0',
  `data1` text,
  `data2` text,
  `data3` text,
  `script1cond` tinyint(1) NOT NULL default '0',
  `script1id` int(11) default NULL,
  `script1code` text,
  `script1flag1` tinyint(1) NOT NULL default '0',
  `script1flag2` tinyint(1) NOT NULL default '0',
  `script2cond` tinyint(1) NOT NULL default '0',
  `script2id` int(11) default NULL,
  `script2code` text,
  `script2flag1` tinyint(1) NOT NULL default '0',
  `script2flag2` tinyint(1) NOT NULL default '0',
  `script2flag3` tinyint(1) NOT NULL default '0',
  `script2flag4` tinyint(1) NOT NULL default '0',
  `script2flag5` tinyint(1) NOT NULL default '0',
  `script3cond` tinyint(1) NOT NULL default '0',
  `script3id` int(11) default NULL,
  `script3code` text,
  `script3msg` text,
  `mailback` tinyint(1) NOT NULL default '0',
  `mailbackfile` text NOT NULL,
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_12 = "DROP TABLE IF EXISTS `#__facileforms_scripts`";

$_13 = "CREATE TABLE `#__facileforms_scripts` (
  `id` int(11) NOT NULL auto_increment,
  `published` tinyint(1) NOT NULL default '0',
  `package` VARCHAR( 30 ) NOT NULL default '',
  `name` varchar(30) NOT NULL default '',
  `title` varchar(50) NOT NULL default '',
  `description` text,
  `type` varchar(30) NOT NULL default '',
  `code` text,
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_14 = "DROP TABLE IF EXISTS `#__facileforms_pieces`";

$_15 = "CREATE TABLE `#__facileforms_pieces` (
  `id` int(11) NOT NULL auto_increment,
  `published` tinyint(1) NOT NULL default '0',
  `package` VARCHAR( 30 ) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` text,
  `type` varchar(30) NOT NULL default '',
  `code` text,
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_16 = "DROP TABLE IF EXISTS `#__facileforms_records`";

$_17 = "CREATE TABLE `#__facileforms_records` (
  `id` int(11) NOT NULL auto_increment,
  `submitted` datetime NOT NULL default '0000-00-00 00:00:00',
  `form` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `ip` varchar(30) NOT NULL default '',
  `browser` varchar(255) NOT NULL default '',
  `opsys` varchar(255) NOT NULL default '',
  `provider` varchar(255) NOT NULL default '',
  `viewed` tinyint(1) NOT NULL default '0',
  `exported` tinyint(1) NOT NULL default '0',
  `archived` tinyint(1) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `user_full_name` varchar(255) NOT NULL default '',
  `paypal_tx_id` varchar(255) NOT NULL default '',
  `paypal_payment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `paypal_testaccount` tinyint(1) NOT NULL default '0',
  `paypal_download_tries` int(11) NOT NULL default '0',
  `opted` tinyint(1) NOT NULL DEFAULT '0',
  `opt_ip` varchar(255) NOT NULL DEFAULT '',
  `opt_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `opt_token` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_18 = "DROP TABLE IF EXISTS `#__facileforms_subrecords`";
    
$_19 = "CREATE TABLE `#__facileforms_subrecords` (
  `id` int(11) NOT NULL auto_increment,
  `record` int(11) NOT NULL default '0',
  `element` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `value` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_20 = "DROP TABLE IF EXISTS `#__facileforms_integrator_criteria_fixed`";

$_21 = "CREATE TABLE  `#__facileforms_integrator_criteria_fixed` (
  `id` int(11) NOT NULL auto_increment,
  `rule_id` int(11) NOT NULL,
  `reference_column` varchar(255)  NOT NULL,
  `operator` varchar(255)  NOT NULL,
  `fixed_value` text  NOT NULL,
  `andor` varchar(3)  NOT NULL default 'AND',
  PRIMARY KEY  (`id`)
)  AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_22 = "DROP TABLE IF EXISTS `#__facileforms_integrator_criteria_form`";

$_23 = "CREATE TABLE `#__facileforms_integrator_criteria_form` (
  `id` int(11) NOT NULL auto_increment,
  `rule_id` int(11) NOT NULL,
  `reference_column` varchar(255)  NOT NULL,
  `operator` varchar(255)  NOT NULL,
  `element_id` varchar(255)  NOT NULL,
  `andor` varchar(3)  NOT NULL default 'AND',
  PRIMARY KEY  (`id`)
)  AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_24 = "DROP TABLE IF EXISTS `#__facileforms_integrator_criteria_joomla`";

$_25 = "CREATE TABLE `#__facileforms_integrator_criteria_joomla` (
  `id` int(11) NOT NULL auto_increment,
  `rule_id` int(11) NOT NULL,
  `reference_column` varchar(255)  NOT NULL,
  `operator` varchar(255)  NOT NULL,
  `joomla_object` varchar(255)  NOT NULL,
  `andor` varchar(3)  NOT NULL default 'AND',
  PRIMARY KEY  (`id`)
)  AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_26 = "DROP TABLE IF EXISTS `#__facileforms_integrator_items`";

$_27 = "CREATE TABLE `#__facileforms_integrator_items` (
  `id` int(11) NOT NULL auto_increment,
  `rule_id` int(11) NOT NULL,
  `element_id` int(11) NOT NULL,
  `reference_column` varchar(255)  NOT NULL,
  `code` text  NOT NULL,
  `published` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$_28 = "DROP TABLE IF EXISTS `#__facileforms_integrator_rules`";

$_29 = "CREATE TABLE `#__facileforms_integrator_rules` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255)  NOT NULL,
  `form_id` int(11) NOT NULL,
  `reference_table` varchar(255)  NOT NULL,
  `type` varchar(255)  NOT NULL default 'insert',
  `published` tinyint(1) NOT NULL default '1',
  `finalize_code` TEXT NOT NULL,
  PRIMARY KEY  (`id`)
)  AUTO_INCREMENT=1  DEFAULT CHARACTER SET utf8   
 COLLATE utf8_general_ci";

$db = JFactory::getDBO();

$db->setQuery($_1);
$db->query();

$db->setQuery($_2);
$db->query();

$db->setQuery($_3);
$db->query();

$db->setQuery($_4);
$db->query();

$db->setQuery($_5);
$db->query();

$db->setQuery($_6);
$db->query();

$db->setQuery($_7);
$db->query();

$db->setQuery($_8);
$db->query();

$db->setQuery($_9);
$db->query();

$db->setQuery($_10);
$db->query();

$db->setQuery($_11);
$db->query();

$db->setQuery($_12);
$db->query();

$db->setQuery($_13);
$db->query();

$db->setQuery($_14);
$db->query();

$db->setQuery($_15);
$db->query();

$db->setQuery($_16);
$db->query();

$db->setQuery($_17);
$db->query();

$db->setQuery($_18);
$db->query();

$db->setQuery($_19);
$db->query();

$db->setQuery($_20);
$db->query();

$db->setQuery($_21);
$db->query();

$db->setQuery($_22);
$db->query();

$db->setQuery($_23);
$db->query();

$db->setQuery($_24);
$db->query();

$db->setQuery($_25);
$db->query();

$db->setQuery($_26);
$db->query();

$db->setQuery($_27);
$db->query();

$db->setQuery($_28);
$db->query();

$db->setQuery($_29);
$db->query();

$db->setQuery($_9_1);
$db->query();

$db->setQuery($_9_2);
$db->query();