CREATE TABLE IF NOT EXISTS `#__sobipro_counter` (
	`sid`        INT(11)  NOT NULL,
	`counter`    INT(11)  NOT NULL,
	`lastUpdate` DATETIME NOT NULL,
	PRIMARY KEY (`sid`)
);

CREATE TABLE IF NOT EXISTS `#__sobipro_view_cache` (
	`cid`        INT(11)      NOT NULL AUTO_INCREMENT,
	`section`    INT(11)      NOT NULL,
	`sid`        INT(11)      NOT NULL,
	`fileName`   VARCHAR(100) NOT NULL,
	`task`       VARCHAR(100) NOT NULL,
	`site`       INT(11)      NOT NULL,
	`request`    VARCHAR(255) NOT NULL,
	`language`   VARCHAR(15)  NOT NULL,
	`template`   VARCHAR(150) NOT NULL,
	`configFile` TEXT         NOT NULL,
	`userGroups` VARCHAR(200) NOT NULL,
	`created`    DATETIME     NOT NULL,
	PRIMARY KEY (`cid`),
	KEY `sid` (`sid`),
	KEY `section` (`section`),
	KEY `language` (`language`),
	KEY `task` (`task`),
	KEY `request` (`request`),
	KEY `site` (`site`),
	KEY `userGroups` (`userGroups`)
);

CREATE TABLE IF NOT EXISTS `#__sobipro_view_cache_relation` (
	`cid` INT(11) NOT NULL,
	`sid` INT(11) NOT NULL,
	PRIMARY KEY (`cid`, `sid`)
);

CREATE TABLE IF NOT EXISTS `#__sobipro_crawler` (
	`url`   VARCHAR(255) NOT NULL,
	`crid`  INT(11)      NOT NULL AUTO_INCREMENT,
	`state` TINYINT(1)   NOT NULL,
	PRIMARY KEY (`crid`),
	UNIQUE KEY `url` (`url`)
)
	ENGINE = MyISAM
	DEFAULT CHARSET = utf8;


CREATE TABLE IF NOT EXISTS `#__sobipro_category` (
	`id`            INT(11)             NOT NULL,
	`position`      INT(11) DEFAULT NULL,
	`description`   TEXT,
	`parseDesc`     ENUM('0', '1', '2') NOT NULL DEFAULT '2',
	`introtext`     VARCHAR(255)        NOT NULL,
	`showIntrotext` ENUM('0', '1', '2') NOT NULL DEFAULT '2',
	`icon`          VARCHAR(150) DEFAULT NULL,
	`showIcon`      ENUM('0', '1', '2') NOT NULL DEFAULT '2',
	PRIMARY KEY (`id`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_category` (`id`, `position`, `description`, `parseDesc`, `introtext`, `showIntrotext`, `icon`, `showIcon`) VALUES
(2, 1, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque  laoreet rhoncus tempor. Suspendisse dapibus vulputate dolor ut  tincidunt. Suspendisse tristique laoreet dui, ut tempor orci dictum ut.  Quisque aliquam urna ac justo tristique interdum. Aliquam in dui eget  lectus elementum lacinia eget eu sem. Nam eu felis tellus, ac cursus  velit. Etiam magna libero, condimentum at facilisis a, fermentum eget  leo.</p>', '2', '', '2', 'tmpl/default/laptop.png', '2'),
(3, 2, '', '2', '', '2', 'tmpl/default/Cardgame.png', '2'),
(4, 3, '', '2', '', '2', 'tmpl/default/virussafe.png', '2'),
(5, 4, '', '2', '', '2', 'tmpl/default/folder_home.png', '2'),
(6, 5, '', '2', '', '2', 'tmpl/default/knewsticker.png', '2'),
(7, 6, '', '2', '', '2', 'tmpl/default/view-barcode-add.png', '2'),
(8, 1, '', '2', '', '2', 'tmpl/default/kblogger.png', '2'),
(9, 0, '', '2', '', '2', 'tmpl/default/video-x-mng.png', '2'),
(10, 0, '', '2', '', '2', 'tmpl/default/media-flash.png', '2'),
(11, 0, '', '2', '', '2', 'tmpl/default/pda.png', '2'),
(12, 0, '', '2', '', '2', 'tmpl/default/multimedia.png', '2'),
(13, 0, '', '2', '', '2', 'tmpl/default/meeting-attending.png', '2'),
(14, 0, '', '2', '', '2', 'tmpl/default/applications-games.png', '2'),
(15, 2, '', '2', '', '2', 'tmpl/default/mouse.png', '2'),
(16, 3, '', '2', '', '2', 'tmpl/default/ksirtet.png', '2'),
(17, 4, '', '2', '', '2', 'tmpl/default/joystick.png', '2'),
(18, 1, '', '2', '', '2', 'tmpl/default/kcoloredit.png', '2'),
(19, 2, '', '2', '', '2', 'tmpl/default/agt_login.png', '2'),
(20, 3, '', '2', '', '2', 'tmpl/default/applications-education-science.png', '2'),
(21, 4, '', '2', '', '2', 'tmpl/default/cookie.png', '2'),
(22, 5, '', '2', '', '2', 'tmpl/default/applications-development.png', '2'),
(23, 6, '', '2', '', '2', 'tmpl/default/pack.png', '2'),
(24, 7, '', '2', '', '2', 'tmpl/default/spread.png', '2'),
(25, 8, '', '2', '', '2', 'tmpl/default/bird.png', '2'),
(26, 9, '', '2', '', '2', 'tmpl/default/chat.png', '2'),
(27, 10, '', '2', '', '2', 'tmpl/default/date.png', '2'),
(28, 0, '', '2', '', '2', 'tmpl/default/text-rdf.png', '2'),
(29, 12, '', '2', '', '2', 'tmpl/default/tv.png', '2'),
(30, 13, '', '2', '', '2', 'tmpl/default/weather.png', '2'),
(31, 0, '', '2', '', '2', 'tmpl/default/accessories-dictionary.png', '2'),
(32, 0, '', '2', '', '2', 'tmpl/default/multimedia.png', '2'),
(33, 0, '', '2', '', '2', 'tmpl/default/fork.png', '2'),
(34, 0, '', '2', '', '2', 'tmpl/default/applications-engineering.png', '2'),
(35, 7, '', '2', '', '2', 'tmpl/default/synaptic.png', '2'),
(36, 1, '', '2', '', '2', 'tmpl/default/ktron.png', '2');

CREATE TABLE IF NOT EXISTS `#__sobipro_config` (
	`sKey`     VARCHAR(150) NOT NULL DEFAULT '',
	`sValue`   TEXT,
	`section`  INT(11)      NOT NULL DEFAULT '0',
	`critical` TINYINT(1) DEFAULT NULL,
	`cSection` VARCHAR(30)  NOT NULL,
	PRIMARY KEY (`sKey`, `section`, `cSection`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_config` (`sKey`, `sValue`, `section`, `critical`, `cSection`) VALUES
('l3_enabled', '1', 0, 0, 'cache'),
('include_js_files', '1', 0, 0, 'cache'),
('include_css_files', '1', 0, 0, 'cache'),
('dec_point', ',', 0, 0, 'payments'),
('currency', '€', 0, 0, 'payments'),
('format', '%value %currency', 0, 0, 'payments'),
('vat', '7', 0, 0, 'payments'),
('vat_brutto', '1', 0, 0, 'payments'),
('discount_to_netto', '0', 0, 0, 'payments'),
('percent_format', '%number%sign', 0, 0, 'payments'),
('allowed_tags_array', 'YToxNzp7aTowO3M6MToiYSI7aToxO3M6MToicCI7aToyO3M6MjoiYnIiO2k6MztzOjI6ImhyIjtpOjQ7czozOiJkaXYiO2k6NTtzOjI6ImxpIjtpOjY7czoyOiJ1bCI7aTo3O3M6NDoic3BhbiI7aTo4O3M6NToidGFibGUiO2k6OTtzOjI6InRyIjtpOjEwO3M6MjoidGQiO2k6MTE7czozOiJpbWciO2k6MTI7czoyOiJoMSI7aToxMztzOjI6ImgyIjtpOjE0O3M6MjoiaDMiO2k6MTU7czoyOiJoNCI7aToxNjtzOjI6Img1Ijt9', 0, 0, 'html'),
('allowed_attributes_array', 'YTo4OntpOjA7czo1OiJjbGFzcyI7aToxO3M6MjoiaWQiO2k6MjtzOjU6InN0eWxlIjtpOjM7czo0OiJocmVmIjtpOjQ7czozOiJzcmMiO2k6NTtzOjQ6Im5hbWUiO2k6NjtzOjM6ImFsdCI7aTo3O3M6NToidGl0bGUiO30=', 0, 0, 'html'),
('name_field', '1', 1, 0, 'entry'),
('entries_ordering', 'position.asc', 1, 0, 'list'),
('maxCats', '5', 1, 0, 'entry'),
('publish_limit', '', 1, 0, 'entry'),
('show_icon', '1', 1, 0, 'category'),
('show_intro', '1', 1, 0, 'category'),
('show_desc', '1', 1, 0, 'category'),
('parse_desc', '0', 1, 0, 'category'),
('allowed_tags_array', 'YToxNzp7aTowO3M6MToiYSI7aToxO3M6MToicCI7aToyO3M6MjoiYnIiO2k6MztzOjI6ImhyIjtpOjQ7czozOiJkaXYiO2k6NTtzOjI6ImxpIjtpOjY7czoyOiJ1bCI7aTo3O3M6NDoic3BhbiI7aTo4O3M6NToidGFibGUiO2k6OTtzOjI6InRyIjtpOjEwO3M6MjoidGQiO2k6MTE7czozOiJpbWciO2k6MTI7czoyOiJoMSI7aToxMztzOjI6ImgyIjtpOjE0O3M6MjoiaDMiO2k6MTU7czoyOiJoNCI7aToxNjtzOjI6Img1Ijt9', 1, 0, 'html'),
('allowed_attributes_array', 'YTo4OntpOjA7czo1OiJjbGFzcyI7aToxO3M6MjoiaWQiO2k6MjtzOjU6InN0eWxlIjtpOjM7czo0OiJocmVmIjtpOjQ7czozOiJzcmMiO2k6NTtzOjQ6Im5hbWUiO2k6NjtzOjM6ImFsdCI7aTo3O3M6NToidGl0bGUiO30=', 1, 0, 'html'),
('template', 'default2', 1, 0, 'section'),
('top_menu', '1', 1, 0, 'general'),
('show', '1', 1, 0, 'alphamenu'),
('letters', 'A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,0-9', 1, 0, 'alphamenu'),
('verify', '1', 1, 0, 'alphamenu'),
('categories_in_line', '2', 1, 0, 'list'),
('categories_ordering', 'name.asc', 1, 0, 'list'),
('cat_desc', '0', 1, 0, 'list'),
('cat_meta', '0', 1, 0, 'list'),
('subcats', '1', 1, 0, 'list'),
('entries_limit', '10', 1, 0, 'list'),
('entries_in_line', '2', 1, 0, 'list'),
('entry_meta', '0', 1, 0, 'list'),
('entry_cats', '1', 1, 0, 'list'),
('show_pb', '1', 0, 0, 'general'),
('xml_raw', '0', 0, 0, 'debug'),
('display_errors', '0', 0, 0, 'debug'),
('level', '2', 0, 0, 'debug'),
('extra_fields_array', 'YTozOntpOjA7czoxOiIyIjtpOjE7czoxOiIzIjtpOjI7czoxOiI0Ijt9', 1, 0, 'alphamenu'),
('always_add_section', '0', 1, 0, 'meta'),
('num_subcats', '6', 1, 0, 'list'),
('primary_field', '1', 1, 0, 'alphamenu'),
('alphamenu_extra_fields_array', '', 1, 0, 'alphamenu_extra_fields_array'),
('always_add_search', '0', 1, 0, 'meta'),
('always_add_entryinput', '0', 1, 0, 'meta'),
('parse_template_content', '0', 1, 0, 'general'),
('xml_ip', '', 0, 0, 'debug'),
('multimode', '0', 0, 0, 'lang'),
('engb_preload', '1', 0, 0, 'lang'),
('compress_js', '0', 0, 0, 'cache'),
('alphamenu_extra_fields_array', '', 0, 0, 'alphamenu_extra_fields_array'),
('entries_ordering', 'disabled', 1, 0, 'search'),
('category_access_enabled', '0', 1, 0, 'redirects'),
('category_access_url', 'index.php', 1, 0, 'redirects'),
('category_access_msgtype', 'info', 1, 0, 'redirects'),
('category_access_msg', 'UNAUTHORIZED_ACCESS', 1, 0, 'redirects'),
('section_access_enabled', '0', 1, 0, 'redirects'),
('section_access_url', 'index.php', 1, 0, 'redirects'),
('section_access_msgtype', 'info', 1, 0, 'redirects'),
('section_access_msg', 'UNAUTHORIZED_ACCESS', 1, 0, 'redirects'),
('section_search_enabled', '0', 1, 0, 'redirects'),
('section_search_url', 'index.php', 1, 0, 'redirects'),
('section_search_msgtype', 'info', 1, 0, 'redirects'),
('section_search_msg', 'UNAUTHORIZED_ACCESS', 1, 0, 'redirects'),
('entry_access_enabled', '0', 1, 0, 'redirects'),
('entry_access_url', 'index.php', 1, 0, 'redirects'),
('entry_access_msgtype', 'info', 1, 0, 'redirects'),
('entry_access_msg', 'UNAUTHORIZED_ACCESS', 1, 0, 'redirects'),
('entry_add_enabled', '0', 1, 0, 'redirects'),
('entry_add_url', 'index.php', 1, 0, 'redirects'),
('entry_add_msgtype', 'info', 1, 0, 'redirects'),
('entry_add_msg', 'UNAUTHORIZED_ACCESS', 1, 0, 'redirects'),
('entry_save_enabled', '0', 1, 0, 'redirects'),
('entry_save_url', 'index.php', 1, 0, 'redirects'),
('entry_save_msgtype', 'info', 1, 0, 'redirects'),
('entry_save_msg', 'EN.ENTRY_SAVED_NA', 1, 0, 'redirects');

CREATE TABLE IF NOT EXISTS `#__sobipro_errors` (
	`eid`          INT(25)      NOT NULL AUTO_INCREMENT,
	`date`         DATETIME     NOT NULL,
	`errNum`       INT(5)       NOT NULL,
	`errCode`      INT(5)       NOT NULL,
	`errMsg`       TEXT         NOT NULL,
	`errFile`      VARCHAR(255) NOT NULL,
	`errLine`      INT(10)      NOT NULL,
	`errSect`      VARCHAR(50)  NOT NULL,
	`errUid`       INT(11)      NOT NULL,
	`errIp`        VARCHAR(15)  NOT NULL,
	`errRef`       VARCHAR(255) NOT NULL,
	`errUa`        VARCHAR(255) NOT NULL,
	`errReq`       VARCHAR(255) NOT NULL,
	`errCont`      TEXT         NOT NULL,
	`errBacktrace` TEXT         NOT NULL,
	PRIMARY KEY (`eid`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 1;


CREATE TABLE IF NOT EXISTS `#__sobipro_field` (
	`fid`               INT(11)                                    NOT NULL AUTO_INCREMENT,
	`nid`               VARCHAR(150)                               NOT NULL,
	`adminField`        TINYINT(1) DEFAULT NULL,
	`admList`           INT(10)                                    NOT NULL,
	`dataType`          INT(11) DEFAULT NULL,
	`enabled`           TINYINT(1) DEFAULT NULL,
	`fee`               DOUBLE DEFAULT NULL,
	`fieldType`         VARCHAR(50) DEFAULT NULL,
	`filter`            VARCHAR(150) DEFAULT NULL,
	`isFree`            TINYINT(1) DEFAULT NULL,
	`position`          INT(11) DEFAULT NULL,
	`priority`          INT(11)                                    NOT NULL,
	`required`          TINYINT(1) DEFAULT NULL,
	`section`           INT(11) DEFAULT NULL,
	`multiLang`         TINYINT(4) DEFAULT NULL,
	`uniqueData`        TINYINT(1) DEFAULT NULL,
	`validate`          TINYINT(1) DEFAULT NULL,
	`addToMetaDesc`     TINYINT(1) DEFAULT NULL,
	`addToMetaKeys`     TINYINT(1) DEFAULT '0',
	`editLimit`         INT(11)                                    NOT NULL DEFAULT '0',
	`editable`          TINYINT(4)                                 NOT NULL,
	`showIn`            ENUM('both', 'details', 'vcard', 'hidden') NOT NULL DEFAULT 'both',
	`allowedAttributes` TEXT                                       NOT NULL,
	`allowedTags`       TEXT                                       NOT NULL,
	`editor`            VARCHAR(255)                               NOT NULL,
	`inSearch`          TINYINT(4)                                 NOT NULL DEFAULT '1',
	`withLabel`         TINYINT(4)                                 NOT NULL,
	`cssClass`          VARCHAR(50)                                NOT NULL,
	`parse`             TINYINT(4)                                 NOT NULL,
	`template`          VARCHAR(255)                               NOT NULL,
	`notice`            VARCHAR(150)                               NOT NULL,
	`params`            TEXT                                       NOT NULL,
	`defaultValue`      TEXT                                       NOT NULL,
	`version`           INT(11)                                    NOT NULL DEFAULT '0',
	PRIMARY KEY (`fid`),
	KEY `enabled` (`enabled`),
	KEY `position` (`position`),
	KEY `section` (`section`)
)
	ENGINE = MyISAM
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_field` (`fid`, `nid`, `adminField`, `admList`, `dataType`, `enabled`, `fee`, `fieldType`, `filter`, `isFree`, `position`, `priority`, `required`, `section`, `multiLang`, `uniqueData`, `validate`, `addToMetaDesc`, `addToMetaKeys`, `editLimit`, `editable`, `showIn`, `allowedAttributes`, `allowedTags`, `editor`, `inSearch`, `withLabel`, `cssClass`, `parse`, `template`, `notice`, `params`, `defaultValue`, `version`) VALUES
(1, 'field_name', 0, 0, 0, 1, 0, 'inbox', '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, -1, 1, 'both', '', '', '', 1, 0, '', 0, '', '', 'YTozOntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7fQ==', '', 1),
(2, 'field_zip', 0, 0, 0, 1, 0, 'inbox', 'alphanum', 1, 7, 10, 1, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 1, 1, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7czoxNzoic2VhcmNoUmFuZ2VWYWx1ZXMiO3M6MDoiIjt9', '', 1),
(3, 'field_city', 0, 0, 0, 1, 0, 'inbox', '', 1, 8, 4, 1, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 1, 1, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6Njoic2VsZWN0IjtzOjE3OiJzZWFyY2hSYW5nZVZhbHVlcyI7czowOiIiO30=', '', 1),
(4, 'field_contact', 0, 0, 0, 1, 0, 'inbox', '', 1, 4, 8, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 1, 1, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7czoxNzoic2VhcmNoUmFuZ2VWYWx1ZXMiO3M6MDoiIjt9', '', 1),
(5, 'field_phone', 0, 0, 0, 1, 0, 'inbox', 'phone', 1, 10, 10, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 0, 1, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7czoxNzoic2VhcmNoUmFuZ2VWYWx1ZXMiO3M6MDoiIjt9', '', 1),
(6, 'field_fax', 0, 0, 0, 1, 0, 'inbox', 'phone', 1, 11, 10, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 0, 1, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7czoxNzoic2VhcmNoUmFuZ2VWYWx1ZXMiO3M6MDoiIjt9', '', 1),
(7, 'field_email', 0, 0, 0, 1, 0, 'inbox', 'email', 1, 5, 9, 1, 1, 0, 0, 0, 0, 0, -1, 1, 'hidden', '', '', '', 0, 0, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7czoxNzoic2VhcmNoUmFuZ2VWYWx1ZXMiO3M6MDoiIjt9', '', 1),
(8, 'field_short_description', 0, 0, 0, 1, 0, 'textarea', '', 1, 14, 6, 1, 1, 0, 0, 0, 1, 0, -1, 1, 'vcard', '', 'YTo0OntpOjA7czo0OiJzcGFuIjtpOjE7czoyOiJiciI7aToyO3M6MzoiZGl2IjtpOjM7czoxOiJwIjt9', '0', 1, 0, '', 0, '', '', 'YTo1OntzOjk6Im1heExlbmd0aCI7czozOiIzMDAiO3M6NToid2lkdGgiO3M6MzoiNTUwIjtzOjY6ImhlaWdodCI7czozOiIxMDAiO3M6NjoiZWRpdG9yIjtzOjE6IjAiO3M6OToiYWxsb3dIdG1sIjtzOjE6IjEiO30=', '', 1),
(9, 'field_full_description', 0, 0, 0, 1, 20, 'textarea', '', 0, 15, 7, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '1', 1, 0, '', 0, '', '', 'YTo1OntzOjk6Im1heExlbmd0aCI7czoxOiIwIjtzOjU6IndpZHRoIjtzOjM6IjU1MCI7czo2OiJoZWlnaHQiO3M6MzoiMTAwIjtzOjY6ImVkaXRvciI7czoxOiIxIjtzOjk6ImFsbG93SHRtbCI7czoxOiIxIjt9', '', 1),
(10, 'field_company_logo', 0, 0, 0, 1, 5, 'image', '', 0, 3, 10, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'both', '', '', '', 0, 0, '', 0, '', '', 'YToxNjp7czo1OiJ3aWR0aCI7czozOiIzNTAiO3M6ODoic2F2ZVBhdGgiO3M6Mjg6ImltYWdlcy9zb2JpcHJvL2VudHJpZXMve2lkfS8iO3M6OToiaW5EZXRhaWxzIjtzOjU6ImltYWdlIjtzOjc6ImluVmNhcmQiO3M6NToidGh1bWIiO3M6MTE6InRodW1iSGVpZ2h0IjtzOjM6IjEwMCI7czoxMDoidGh1bWJXaWR0aCI7czozOiIxMDAiO3M6OToidGh1bWJOYW1lIjtzOjE1OiJ0aHVtYl97b3JnbmFtZX0iO3M6Nzoia2VlcE9yZyI7czoxOiIxIjtzOjY6InJlc2l6ZSI7czoxOiIxIjtzOjc6Im1heFNpemUiO3M6NzoiMTA0ODU3NiI7czoxMToicmVzaXplV2lkdGgiO3M6MzoiMjAwIjtzOjEyOiJyZXNpemVIZWlnaHQiO3M6MzoiMjAwIjtzOjk6ImltYWdlTmFtZSI7czoxMzoiaW1nX3tvcmduYW1lfSI7czoxMzoiZ2VuZXJhdGVUaHVtYiI7czoxOiIxIjtzOjEwOiJ0aHVtYkZsb2F0IjtzOjU6InJpZ2h0IjtzOjEwOiJpbWFnZUZsb2F0IjtzOjU6InJpZ2h0Ijt9', '', 1),
(11, 'field_website', 0, 0, 0, 1, 10, 'url', 'title', 0, 12, 9, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 0, 1, '', 0, '', '', 'YTo5OntzOjg6Im93bkxhYmVsIjtzOjE6IjEiO3M6MTA6ImxhYmVsV2lkdGgiO3M6MzoiMzUwIjtzOjE0OiJsYWJlbE1heExlbmd0aCI7czozOiIxNTAiO3M6MTE6ImxhYmVsc0xhYmVsIjtzOjEzOiJXZWJzaXRlIFRpdGxlIjtzOjExOiJ2YWxpZGF0ZVVybCI7czoxOiIwIjtzOjE2OiJhbGxvd2VkUHJvdG9jb2xzIjthOjI6e2k6MDtzOjQ6Imh0dHAiO2k6MTtzOjU6Imh0dHBzIjt9czo5OiJuZXdXaW5kb3ciO3M6MToiMSI7czo5OiJtYXhMZW5ndGgiO3M6MzoiMTUwIjtzOjU6IndpZHRoIjtzOjM6IjM1MCI7fQ==', '', 1),
(12, 'field_business_days', 0, 0, 0, 1, 0, 'chbxgroup', '', 1, 13, 9, 1, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 1, 1, '', 0, '', '', 'YTo0OntzOjk6Im9wdEluTGluZSI7czoxOiIyIjtzOjk6ImxhYmVsU2l0ZSI7czo1OiJyaWdodCI7czo4OiJvcHRXaWR0aCI7czozOiIxNTAiO3M6MTI6InNlYXJjaE1ldGhvZCI7czo0OiJjaGJ4Ijt9', '', 1),
(13, 'field_country', 0, 0, 0, 1, 0, 'select', '', 1, 9, 3, 1, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 1, 1, '', 0, '', '', 'YTo2OntzOjU6IndpZHRoIjtzOjM6IjM1MCI7czo0OiJzaXplIjtzOjI6IjEwIjtzOjExOiJzZWxlY3RMYWJlbCI7czo5OiJTZWxlY3QgJXMiO3M6MTI6InNlYXJjaE1ldGhvZCI7czo3OiJtc2VsZWN0IjtzOjY6InN3aWR0aCI7czozOiIzNTAiO3M6NToic3NpemUiO3M6MjoiMTAiO30=', '', 1),
(14, 'field_street', 0, 0, 0, 1, 0, 'inbox', '', 1, 6, 5, 0, 1, 0, 0, 0, 0, 0, -1, 1, 'details', '', '', '', 0, 1, '', 0, '', '', 'YTo0OntzOjk6Im1heExlbmd0aCI7czozOiIxNTAiO3M6NToid2lkdGgiO3M6MzoiMzUwIjtzOjEyOiJzZWFyY2hNZXRob2QiO3M6NzoiZ2VuZXJhbCI7czoxNzoic2VhcmNoUmFuZ2VWYWx1ZXMiO3M6MDoiIjt9', '', 1),
(15, 'field_select_category', 0, 0, 0, 1, 0, 'category', '', 1, 2, 10, 1, 1, 0, 0, 0, 0, 0, -1, 1, 'hidden', '', '', '', 1, 0, '', 0, '', '', 'YToxOTp7czo2OiJtZXRob2QiO3M6NzoibXNlbGVjdCI7czo1OiJtb2RhbCI7czoxOiIwIjtzOjEyOiJjYXRzTWF4TGltaXQiO3M6MjoiMTAiO3M6MTQ6ImNhdHNXaXRoQ2hpbGRzIjtzOjE6IjEiO3M6NToid2lkdGgiO3M6MzoiMjIwIjtzOjY6ImhlaWdodCI7czozOiIyNTAiO3M6ODoiZml4ZWRDaWQiO047czoxMzoiX3NlbGVjdGVkQ2F0cyI7TjtzOjU6Il9jYXRzIjtOO3M6OToiaXNQcmltYXJ5IjtOO3M6MTI6InNlYXJjaE1ldGhvZCI7czo2OiJzZWxlY3QiO3M6MTE6InNlYXJjaFdpZHRoIjtzOjM6IjIyMCI7czoxMjoic2VhcmNoSGVpZ2h0IjtzOjE6IjAiO3M6NToiX2F0dHIiO047czo5OiJfc2VsZWN0ZWQiO047czo1OiJkVHlwZSI7TjtzOjY6Il9yZGF0YSI7TjtzOjg6ImNzc0NsYXNzIjtzOjA6IiI7czo5OiJzaG93TGFiZWwiO047fQ==', '', 1);

CREATE TABLE IF NOT EXISTS `#__sobipro_field_data` (
	`publishUp`   DATETIME DEFAULT NULL,
	`publishDown` DATETIME DEFAULT NULL,
	`fid`         INT(11)     NOT NULL DEFAULT '0',
	`sid`         INT(11)     NOT NULL DEFAULT '0',
	`section`     INT(11)     NOT NULL DEFAULT '0',
	`lang`        VARCHAR(50) NOT NULL DEFAULT '',
	`enabled`     TINYINT(1)  NOT NULL,
	`params`      TEXT,
	`options`     TEXT,
	`baseData`    TEXT,
	`approved`    TINYINT(1) DEFAULT NULL,
	`confirmed`   TINYINT(1) DEFAULT NULL,
	`createdTime` DATETIME DEFAULT NULL,
	`createdBy`   INT(11) DEFAULT NULL,
	`createdIP`   VARCHAR(15) DEFAULT NULL,
	`updatedTime` DATETIME DEFAULT NULL,
	`updatedBy`   INT(11) DEFAULT NULL,
	`updatedIP`   VARCHAR(15) DEFAULT NULL,
	`copy`        TINYINT(1)  NOT NULL DEFAULT '0',
	`editLimit`   INT(11),
	PRIMARY KEY (`fid`, `section`, `lang`, `sid`, `copy`),
	KEY `enabled` (`enabled`),
	KEY `copy` (`copy`),
	FULLTEXT KEY `baseData` (`baseData`)
)
	ENGINE = MyISAM
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_field_data` (`publishUp`, `publishDown`, `fid`, `sid`, `section`, `lang`, `enabled`, `params`, `options`, `baseData`, `approved`, `confirmed`, `createdTime`, `createdBy`, `createdIP`, `updatedTime`, `updatedBy`, `updatedIP`, `copy`, `editLimit`) VALUES
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 37, 1, 'en-GB', 1, '', '', 'Neo Electronics', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 4, 37, 1, 'en-GB', 1, '', '', 'John Doe', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 37, 1, 'en-GB', 1, '', '', 'example@example.com', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 37, 1, 'en-GB', 1, '', '', '1234', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 37, 1, 'en-GB', 1, '', '', 'Duckburg', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 37, 1, 'en-GB', 1, '', '', '+1 (0) 1234.567.890', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 6, 37, 1, 'en-GB', 1, '', '', '+1 (0) 1234.567.891', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 8, 37, 1, 'en-GB', 1, '', '', 'Morbi ornare porta eleifend. Praesent auctor urna eget nulla bibendum vestibulum. Phasellus eros est, adipiscing eu cursus fermentum, lacinia interdum felis. Vestibulum sit amet velit dui, a placerat dolor. Phasellus gravida, urna eu scelerisque venenatis, velit quam facilisis eros.', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 9, 37, 1, 'en-GB', 1, '', '', '<p>Morbi ornare porta eleifend. Praesent auctor urna eget nulla bibendum vestibulum. Phasellus eros est, adipiscing eu cursus fermentum, lacinia interdum felis. Vestibulum sit amet velit dui, a placerat dolor. Phasellus gravida, urna eu scelerisque venenatis, velit quam facilisis eros, sit amet pretium metus leo quis orci. Sed eget ultrices neque. Proin at elit nibh, in aliquam elit. Morbi euismod libero in sapien rutrum in blandit enim pharetra. Integer tincidunt sagittis pellentesque. Cras sed mauris vitae est convallis rhoncus sed sed ligula. Fusce cursus, tortor non pellentesque consequat, purus odio ultrices massa, a gravida libero nisl eget tellus. Donec mollis tincidunt ligula, at rhoncus libero suscipit ut. Integer sodales semper congue. Ut sagittis bibendum augue, et feugiat mauris gravida ac. Maecenas pellentesque orci vitae quam sagittis non gravida lorem egestas. Aenean at enim id orci facilisis fermentum. Pellentesque convallis tortor eget lorem blandit ornare. In purus nisi, tincidunt at ultricies ac, luctus auctor augue. Sed orci neque, commodo in lobortis sit amet, condimentum ac odio.</p>', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 37, 1, 'en-GB', 1, NULL, NULL, 'YTo0OntzOjU6ImltYWdlIjtzOjQ0OiJpbWFnZXMvc29iaXByby9lbnRyaWVzLzM3L2ltZ19hdWRpby1jYXJkLnBuZyI7czo1OiJ0aHVtYiI7czo0NjoiaW1hZ2VzL3NvYmlwcm8vZW50cmllcy8zNy90aHVtYl9hdWRpby1jYXJkLnBuZyI7czozOiJpY28iO3M6NDQ6ImltYWdlcy9zb2JpcHJvL2VudHJpZXMvMzcvaWNvX2F1ZGlvLWNhcmQucG5nIjtzOjg6Im9yaWdpbmFsIjtzOjk0OiJpbWFnZXMvc29iaXByby9lbnRyaWVzLzM3Ly92YXIvd3d3L3NvYmktcHJvL2h0bWwvcm9vdC9pbWFnZXMvc29iaXByby9lbnRyaWVzLzM3L2F1ZGlvLWNhcmQucG5nIjt9', 0, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 0, '0', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 11, 37, 1, 'en-GB', 1, NULL, NULL, 'YTozOntzOjU6ImxhYmVsIjtzOjIwOiJOZW8gRWxlY3Ryb25pY3MgU2hvcCI7czo4OiJwcm90b2NvbCI7czo0OiJodHRwIjtzOjM6InVybCI7czoxMjoiZXhhbXBsZS5jb20vIjt9', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 37, 1, 'en-GB', 1, NULL, NULL, '', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 38, 1, 'en-GB', 1, NULL, NULL, 'N-Communications', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 38, 1, 'en-GB', 1, NULL, NULL, 'YTo0OntzOjU6ImltYWdlIjtzOjQ3OiJpbWFnZXMvc29iaXByby9lbnRyaWVzLzM4L2ltZ19Gb2xkZXJOZXR3b3JrLnBuZyI7czo1OiJ0aHVtYiI7czo0OToiaW1hZ2VzL3NvYmlwcm8vZW50cmllcy8zOC90aHVtYl9Gb2xkZXJOZXR3b3JrLnBuZyI7czozOiJpY28iO3M6NDc6ImltYWdlcy9zb2JpcHJvL2VudHJpZXMvMzgvaWNvX2ZvbGRlcm5ldHdvcmsucG5nIjtzOjg6Im9yaWdpbmFsIjtzOjk3OiJpbWFnZXMvc29iaXByby9lbnRyaWVzLzM4Ly92YXIvd3d3L3NvYmktcHJvL2h0bWwvcm9vdC9pbWFnZXMvc29iaXByby9lbnRyaWVzLzM4L0ZvbGRlck5ldHdvcmsucG5nIjt9', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.68.227.138', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 4, 38, 1, 'en-GB', 1, NULL, NULL, 'Scrooge McDuck', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 38, 1, 'en-GB', 1, NULL, NULL, 'Scrooge@mcduck.com', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 38, 1, 'en-GB', 1, NULL, NULL, '7788', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 38, 1, 'en-GB', 1, NULL, NULL, 'Duckburg', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 38, 1, 'en-GB', 1, NULL, NULL, '+1 (0) 9934.567.899', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 6, 38, 1, 'en-GB', 1, NULL, NULL, '+1 (0) 9934.567.001', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 11, 38, 1, 'en-GB', 1, NULL, NULL, 'YTozOntzOjU6ImxhYmVsIjtzOjMxOiJXaWtpcGVkaWEgdGhlIGZyZWUgZW5jeWNsb3BlZGlhIjtzOjg6InByb3RvY29sIjtzOjQ6Imh0dHAiO3M6MzoidXJsIjtzOjE3OiJlbi53aWtpcGVkaWEub3JnLyI7fQ==', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 38, 1, 'en-GB', 1, NULL, NULL, '', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 8, 38, 1, 'en-GB', 1, NULL, NULL, 'Fusce vel felis et dolor sagittis volutpat. Nunc sit amet lacus sapien, ac imperdiet mi. Duis sed massa metus, venenatis dignissim odio. Proin dui urna, facilisis vitae venenatis non, vehicula id neque. Sed rutrum est eu diam suscipit elementum eget nec mi.', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 9, 38, 1, 'en-GB', 1, NULL, NULL, '<p>Morbi ornare porta eleifend. Praesent auctor urna eget nulla bibendum  vestibulum. Phasellus eros est, adipiscing eu cursus fermentum, lacinia  interdum felis. Vestibulum sit amet velit dui, a placerat dolor.  Phasellus gravida, urna eu scelerisque venenatis, velit quam facilisis  eros, sit amet pretium metus leo quis orci. Sed eget ultrices neque.  Proin at elit nibh, in aliquam elit. Morbi euismod libero in sapien  rutrum in blandit enim pharetra. Integer tincidunt sagittis  pellentesque. Cras sed mauris vitae est convallis rhoncus sed sed  ligula. Fusce cursus, tortor non pellentesque consequat, purus odio  ultrices massa, a gravida libero nisl eget tellus. Donec mollis  tincidunt ligula, at rhoncus libero suscipit ut. Integer sodales semper  congue. Ut sagittis bibendum augue, et feugiat mauris gravida ac.  Maecenas pellentesque orci vitae quam sagittis non gravida lorem  egestas. Aenean at enim id orci facilisis fermentum. Pellentesque  convallis tortor eget lorem blandit ornare. In purus nisi, tincidunt at  ultricies ac, luctus auctor augue. Sed orci neque, commodo in lobortis  sit amet, condimentum ac odio.</p>\r\n<p>Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere  cubilia Curae; Etiam elit massa, malesuada dictum pellentesque id,  vestibulum non risus. Maecenas adipiscing, nunc at ullamcorper  porttitor, libero turpis laoreet nisl, eu dapibus ipsum justo sed leo.  Mauris vel purus augue, ac ultricies nisi. In hac habitasse platea  dictumst. Nulla magna risus, venenatis sed ultricies vel, condimentum  nec turpis. Curabitur cursus luctus enim eu pharetra. Mauris elit nisi,  eleifend vitae condimentum vitae, ultricies ut justo. Aliquam mollis  lectus eu nulla tempor eget ultricies elit tincidunt. Aliquam erat  volutpat. Quisque eros lacus, iaculis a placerat et, fermentum et massa.  Ut tempor faucibus cursus. Nunc imperdiet vestibulum faucibus. Mauris  commodo, augue a cursus aliquet, mauris diam aliquam nisl, nec pharetra  massa nulla eget nibh. Integer egestas volutpat diam, quis malesuada dui  sollicitudin at. Mauris vehicula, metus quis posuere egestas, metus  lectus pulvinar sapien, non accumsan nulla sapien eget nulla. Quisque  imperdiet ultricies ipsum non fringilla. Curabitur pulvinar mi nec lacus  consectetur vel ullamcorper enim pretium. Pellentesque vitae  scelerisque sem. Morbi nunc ipsum, dignissim eu pellentesque quis,  sollicitudin vitae turpis.</p>', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 39, 1, 'en-GB', 1, NULL, NULL, 'Sun Bookstore', 1, 0, '2013-01-02 00:00:00', 0, '88.68.227.138', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 39, 1, 'en-GB', 1, NULL, NULL, 'YTo0OntzOjU6ImltYWdlIjtzOjQxOiJpbWFnZXMvc29iaXByby9lbnRyaWVzLzM5L2ltZ19OZXR3b3JrLnBuZyI7czo1OiJ0aHVtYiI7czo0MzoiaW1hZ2VzL3NvYmlwcm8vZW50cmllcy8zOS90aHVtYl9OZXR3b3JrLnBuZyI7czozOiJpY28iO3M6NDE6ImltYWdlcy9zb2JpcHJvL2VudHJpZXMvMzkvaWNvX25ldHdvcmsucG5nIjtzOjg6Im9yaWdpbmFsIjtzOjkxOiJpbWFnZXMvc29iaXByby9lbnRyaWVzLzM5Ly92YXIvd3d3L3NvYmktcHJvL2h0bWwvcm9vdC9pbWFnZXMvc29iaXByby9lbnRyaWVzLzM5L05ldHdvcmsucG5nIjt9', 0, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 0, '0', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 4, 39, 1, 'en-GB', 1, NULL, NULL, 'Carl  Sun', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 39, 1, 'en-GB', 1, NULL, NULL, 'example@example.com', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 39, 1, 'en-GB', 1, NULL, NULL, '7118', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 39, 1, 'en-GB', 1, NULL, NULL, 'Duckburg', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 5, 39, 1, 'en-GB', 1, NULL, NULL, '+1 (0) 567.899.11', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 6, 39, 1, 'en-GB', 1, NULL, NULL, '+1 (0) 567.899.99', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 11, 39, 1, 'en-GB', 1, NULL, NULL, 'YTozOntzOjU6ImxhYmVsIjtzOjEzOiJTdW4gQm9va3N0b3JlIjtzOjg6InByb3RvY29sIjtzOjQ6Imh0dHAiO3M6MzoidXJsIjtzOjExOiJleGFtcGxlLm9yZyI7fQ==', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 39, 1, 'en-GB', 1, NULL, NULL, '', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 8, 39, 1, 'en-GB', 1, NULL, NULL, 'Vivamus est leo, tempor at dictum in, pellentesque molestie velit. Sed lacinia, quam non malesuada porttitor, ante arcu ornare magna, vel lacinia nibh velit quis massa. Donec nec massa sit amet metus elementum porta. Duis a velit vitae leo accumsan sodales. Vestibulum convallis consectetur elit', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 9, 39, 1, 'en-GB', 1, NULL, NULL, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque  laoreet rhoncus tempor. Suspendisse dapibus vulputate dolor ut  tincidunt. Suspendisse tristique laoreet dui, ut tempor orci dictum ut.  Quisque aliquam urna ac justo tristique interdum. Aliquam in dui eget  lectus elementum lacinia eget eu sem. Nam eu felis tellus, ac cursus  velit. Etiam magna libero, condimentum at facilisis a, fermentum eget  leo. Nulla gravida imperdiet neque, accumsan auctor magna viverra a.  Aliquam eget augue a ante malesuada convallis a nec mi. Phasellus  mollis, urna et interdum congue, lacus ante lacinia ipsum, vitae  fringilla quam mi id ipsum.</p>', 1, 0, '2013-01-02 00:00:00', 0, '0', '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 37, 1, 'en-GB', 1, NULL, NULL, '', 1, 0, NULL, NULL, NULL, '2013-01-02 16:25:51', 791, '192.168.1.32', 0, 2),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 38, 1, 'en-GB', 1, NULL, NULL, '', 1, 0, NULL, NULL, NULL, '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 13, 39, 1, 'en-GB', 1, NULL, NULL, '', 1, 0, NULL, NULL, NULL, '2013-01-02 00:00:00', 63, '88.69.191.86', 0, NULL),
('0000-00-00 00:00:00', '0000-00-00 00:00:00', 14, 37, 1, 'en-GB', 1, '', '', '', 1, 0, NULL, NULL, NULL, '2013-01-02 16:25:51', 791, '192.168.1.32', 0, -1);


CREATE TABLE IF NOT EXISTS `#__sobipro_field_option` (
	`fid`       INT(11)      NOT NULL,
	`optValue`  VARCHAR(100) NOT NULL,
	`optPos`    INT(11)      NOT NULL,
	`img`       VARCHAR(150) NOT NULL,
	`optClass`  VARCHAR(50)  NOT NULL,
	`actions`   TEXT         NOT NULL,
	`class`     TEXT         NOT NULL,
	`optParent` VARCHAR(100) NOT NULL,
	PRIMARY KEY (`fid`, `optValue`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_field_option` (`fid`, `optValue`, `optPos`, `img`, `optClass`, `actions`, `class`, `optParent`) VALUES
(12, 'Monday', 1, '', '', '', '', ''),
(12, 'Tuesday', 2, '', '', '', '', ''),
(12, 'Wednesday', 3, '', '', '', '', ''),
(12, 'Thursday', 4, '', '', '', '', ''),
(12, 'Friday', 5, '', '', '', '', ''),
(12, 'Saturday', 6, '', '', '', '', ''),
(12, 'Sunday', 7, '', '', '', '', ''),
(13, 'africa', 1, '', '', '', '', ''),
(13, 'algeria', 2, '', '', '', '', 'africa'),
(13, 'angola', 3, '', '', '', '', 'africa'),
(13, 'benin', 4, '', '', '', '', 'africa'),
(13, 'botswana', 5, '', '', '', '', 'africa'),
(13, 'burkina-faso', 6, '', '', '', '', 'africa'),
(13, 'burundi', 7, '', '', '', '', 'africa'),
(13, 'cameroon', 8, '', '', '', '', 'africa'),
(13, 'cape-verde', 9, '', '', '', '', 'africa'),
(13, 'central-african-republic', 10, '', '', '', '', 'africa'),
(13, 'chad', 11, '', '', '', '', 'africa'),
(13, 'comoros', 12, '', '', '', '', 'africa'),
(13, 'congo-democratic', 13, '', '', '', '', 'africa'),
(13, 'congo-republic-of', 14, '', '', '', '', 'africa'),
(13, 'cote-d-ivoire', 15, '', '', '', '', 'africa'),
(13, 'djibouti', 16, '', '', '', '', 'africa'),
(13, 'egypt', 17, '', '', '', '', 'africa'),
(13, 'equatorial-guinea', 18, '', '', '', '', 'africa'),
(13, 'eritrea', 19, '', '', '', '', 'africa'),
(13, 'ethiopia', 20, '', '', '', '', 'africa'),
(13, 'gabon', 21, '', '', '', '', 'africa'),
(13, 'gambia', 22, '', '', '', '', 'africa'),
(13, 'ghana', 23, '', '', '', '', 'africa'),
(13, 'guinea', 24, '', '', '', '', 'africa'),
(13, 'guinea-bissau', 25, '', '', '', '', 'africa'),
(13, 'kenya', 26, '', '', '', '', 'africa'),
(13, 'lesotho', 27, '', '', '', '', 'africa'),
(13, 'liberia', 28, '', '', '', '', 'africa'),
(13, 'libya', 29, '', '', '', '', 'africa'),
(13, 'madagascar', 30, '', '', '', '', 'africa'),
(13, 'malawi', 31, '', '', '', '', 'africa'),
(13, 'mali', 32, '', '', '', '', 'africa'),
(13, 'mauritania', 33, '', '', '', '', 'africa'),
(13, 'mauritius', 34, '', '', '', '', 'africa'),
(13, 'mayotte', 35, '', '', '', '', 'africa'),
(13, 'morocco', 36, '', '', '', '', 'africa'),
(13, 'mozambique', 37, '', '', '', '', 'africa'),
(13, 'namibia', 38, '', '', '', '', 'africa'),
(13, 'niger', 39, '', '', '', '', 'africa'),
(13, 'nigeria', 40, '', '', '', '', 'africa'),
(13, 'reunion', 41, '', '', '', '', 'africa'),
(13, 'rwanda', 42, '', '', '', '', 'africa'),
(13, 'sao-tome-and-principe', 43, '', '', '', '', 'africa'),
(13, 'senegal', 44, '', '', '', '', 'africa'),
(13, 'seychelles', 45, '', '', '', '', 'africa'),
(13, 'sierra-leone', 46, '', '', '', '', 'africa'),
(13, 'somalia', 47, '', '', '', '', 'africa'),
(13, 'somaliland', 48, '', '', '', '', 'africa'),
(13, 'south-africa', 49, '', '', '', '', 'africa'),
(13, 'sudan', 50, '', '', '', '', 'africa'),
(13, 'swaziland', 51, '', '', '', '', 'africa'),
(13, 'tunisia', 52, '', '', '', '', 'africa'),
(13, 'uganda', 53, '', '', '', '', 'africa'),
(13, 'western-sahara', 54, '', '', '', '', 'africa'),
(13, 'zambia', 55, '', '', '', '', 'africa'),
(13, 'zimbabwe', 56, '', '', '', '', 'africa'),
(13, 'asia', 57, '', '', '', '', ''),
(13, 'abkhazia', 58, '', '', '', '', 'asia'),
(13, 'afghanistan', 59, '', '', '', '', 'asia'),
(13, 'akrotiri-and-dhekelia', 60, '', '', '', '', 'asia'),
(13, 'armenia', 61, '', '', '', '', 'asia'),
(13, 'azerbaijan', 62, '', '', '', '', 'asia'),
(13, 'bahrain', 63, '', '', '', '', 'asia'),
(13, 'bangladesh', 64, '', '', '', '', 'asia'),
(13, 'bhutan', 65, '', '', '', '', 'asia'),
(13, 'british-indian', 66, '', '', '', '', 'asia'),
(13, 'brunei', 67, '', '', '', '', 'asia'),
(13, 'cambodia', 68, '', '', '', '', 'asia'),
(13, 'china', 69, '', '', '', '', 'asia'),
(13, 'taiwan', 70, '', '', '', '', 'asia'),
(13, 'christmas-island', 71, '', '', '', '', 'asia'),
(13, 'cocos-islands', 72, '', '', '', '', 'asia'),
(13, 'cyprus', 73, '', '', '', '', 'asia'),
(13, 'georgia', 74, '', '', '', '', 'asia'),
(13, 'hong-kong', 75, '', '', '', '', 'asia'),
(13, 'india', 76, '', '', '', '', 'asia'),
(13, 'indonesia', 77, '', '', '', '', 'asia'),
(13, 'iran', 78, '', '', '', '', 'asia'),
(13, 'iraq', 79, '', '', '', '', 'asia'),
(13, 'israel', 80, '', '', '', '', 'asia'),
(13, 'japan', 81, '', '', '', '', 'asia'),
(13, 'jordan', 82, '', '', '', '', 'asia'),
(13, 'kazakhstan', 83, '', '', '', '', 'asia'),
(13, 'north-korea', 84, '', '', '', '', 'asia'),
(13, 'korea-republic', 85, '', '', '', '', 'asia'),
(13, 'kuwait', 86, '', '', '', '', 'asia'),
(13, 'kyrgyzstan', 87, '', '', '', '', 'asia'),
(13, 'laos', 88, '', '', '', '', 'asia'),
(13, 'lebanon', 89, '', '', '', '', 'asia'),
(13, 'macau', 90, '', '', '', '', 'asia'),
(13, 'malaysia', 91, '', '', '', '', 'asia'),
(13, 'maldives', 92, '', '', '', '', 'asia'),
(13, 'mongolia', 93, '', '', '', '', 'asia'),
(13, 'myanmar', 94, '', '', '', '', 'asia'),
(13, 'nagorno-karabakh', 95, '', '', '', '', 'asia'),
(13, 'northern-cyprus', 96, '', '', '', '', 'asia'),
(13, 'nepal', 97, '', '', '', '', 'asia'),
(13, 'oman', 98, '', '', '', '', 'asia'),
(13, 'pakistan', 99, '', '', '', '', 'asia'),
(13, 'palestinian-territories', 100, '', '', '', '', 'asia'),
(13, 'philippines', 101, '', '', '', '', 'asia'),
(13, 'qatar', 102, '', '', '', '', 'asia'),
(13, 'saudi-arabia', 103, '', '', '', '', 'asia'),
(13, 'singapore', 104, '', '', '', '', 'asia'),
(13, 'south-ossetia', 105, '', '', '', '', 'asia'),
(13, 'sri-lanka', 106, '', '', '', '', 'asia'),
(13, 'syria', 107, '', '', '', '', 'asia'),
(13, 'tajikistan', 108, '', '', '', '', 'asia'),
(13, 'thailand', 109, '', '', '', '', 'asia'),
(13, 'timor-leste', 110, '', '', '', '', 'asia'),
(13, 'turkey', 111, '', '', '', '', 'asia'),
(13, 'turkmenistan', 112, '', '', '', '', 'asia'),
(13, 'united-arab-emirates', 113, '', '', '', '', 'asia'),
(13, 'uzbekistan', 114, '', '', '', '', 'asia'),
(13, 'vietnam', 115, '', '', '', '', 'asia'),
(13, 'yemen', 116, '', '', '', '', 'asia'),
(13, 'europe', 117, '', '', '', '', ''),
(13, 'aland-islands', 118, '', '', '', '', 'europe'),
(13, 'albania', 119, '', '', '', '', 'europe'),
(13, 'andorra', 120, '', '', '', '', 'europe'),
(13, 'austria', 121, '', '', '', '', 'europe'),
(13, 'belarus', 122, '', '', '', '', 'europe'),
(13, 'belgium', 123, '', '', '', '', 'europe'),
(13, 'bosnia-herzegovina', 124, '', '', '', '', 'europe'),
(13, 'bulgaria', 125, '', '', '', '', 'europe'),
(13, 'croatia', 126, '', '', '', '', 'europe'),
(13, 'czech-republic', 127, '', '', '', '', 'europe'),
(13, 'denmark', 128, '', '', '', '', 'europe'),
(13, 'estonia', 129, '', '', '', '', 'europe'),
(13, 'faroe-islands', 130, '', '', '', '', 'europe'),
(13, 'finland', 131, '', '', '', '', 'europe'),
(13, 'france', 132, '', '', '', '', 'europe'),
(13, 'germany', 133, '', '', '', '', 'europe'),
(13, 'gibraltar', 134, '', '', '', '', 'europe'),
(13, 'greece', 135, '', '', '', '', 'europe'),
(13, 'guernsey', 136, '', '', '', '', 'europe'),
(13, 'hungary', 137, '', '', '', '', 'europe'),
(13, 'iceland', 138, '', '', '', '', 'europe'),
(13, 'ireland', 139, '', '', '', '', 'europe'),
(13, 'isle-of-man', 140, '', '', '', '', 'europe'),
(13, 'italy', 141, '', '', '', '', 'europe'),
(13, 'jersey', 142, '', '', '', '', 'europe'),
(13, 'kosovo', 143, '', '', '', '', 'europe'),
(13, 'latvia', 144, '', '', '', '', 'europe'),
(13, 'liechtenstein', 145, '', '', '', '', 'europe'),
(13, 'lithuania', 146, '', '', '', '', 'europe'),
(13, 'luxembourg', 147, '', '', '', '', 'europe'),
(13, 'macedonia', 148, '', '', '', '', 'europe'),
(13, 'malta', 149, '', '', '', '', 'europe'),
(13, 'moldova', 150, '', '', '', '', 'europe'),
(13, 'monaco', 151, '', '', '', '', 'europe'),
(13, 'montenegro', 152, '', '', '', '', 'europe'),
(13, 'netherlands', 153, '', '', '', '', 'europe'),
(13, 'norway', 154, '', '', '', '', 'europe'),
(13, 'poland', 155, '', '', '', '', 'europe'),
(13, 'portugal', 156, '', '', '', '', 'europe'),
(13, 'romania', 157, '', '', '', '', 'europe'),
(13, 'russia', 158, '', '', '', '', 'europe'),
(13, 'san-marino', 159, '', '', '', '', 'europe'),
(13, 'serbia', 160, '', '', '', '', 'europe'),
(13, 'slovakia', 161, '', '', '', '', 'europe'),
(13, 'slovenia', 162, '', '', '', '', 'europe'),
(13, 'spain', 163, '', '', '', '', 'europe'),
(13, 'svalbard', 164, '', '', '', '', 'europe'),
(13, 'sweden', 165, '', '', '', '', 'europe'),
(13, 'switzerland', 166, '', '', '', '', 'europe'),
(13, 'transnistria', 167, '', '', '', '', 'europe'),
(13, 'ukraine', 168, '', '', '', '', 'europe'),
(13, 'united-kingdom', 169, '', '', '', '', 'europe'),
(13, 'vatican', 170, '', '', '', '', 'europe'),
(13, 'north-america', 171, '', '', '', '', ''),
(13, 'anguilla', 172, '', '', '', '', 'north-america'),
(13, 'antigua-and-barbuda', 173, '', '', '', '', 'north-america'),
(13, 'aruba', 174, '', '', '', '', 'north-america'),
(13, 'bahamas', 175, '', '', '', '', 'north-america'),
(13, 'barbados', 176, '', '', '', '', 'north-america'),
(13, 'belize', 177, '', '', '', '', 'north-america'),
(13, 'bermuda', 178, '', '', '', '', 'north-america'),
(13, 'british-virgin-islands', 179, '', '', '', '', 'north-america'),
(13, 'canada', 180, '', '', '', '', 'north-america'),
(13, 'cayman-islands', 181, '', '', '', '', 'north-america'),
(13, 'clipperton-island', 182, '', '', '', '', 'north-america'),
(13, 'costa-rica', 183, '', '', '', '', 'north-america'),
(13, 'cuba', 184, '', '', '', '', 'north-america'),
(13, 'dominica', 185, '', '', '', '', 'north-america'),
(13, 'dominican-republic', 186, '', '', '', '', 'north-america'),
(13, 'el-salvador', 187, '', '', '', '', 'north-america'),
(13, 'greenland', 188, '', '', '', '', 'north-america'),
(13, 'grenada', 189, '', '', '', '', 'north-america'),
(13, 'guadeloupe', 190, '', '', '', '', 'north-america'),
(13, 'guatemala', 191, '', '', '', '', 'north-america'),
(13, 'haiti', 192, '', '', '', '', 'north-america'),
(13, 'honduras', 193, '', '', '', '', 'north-america'),
(13, 'jamaica', 194, '', '', '', '', 'north-america'),
(13, 'martinique', 195, '', '', '', '', 'north-america'),
(13, 'mexico', 196, '', '', '', '', 'north-america'),
(13, 'montserrat', 197, '', '', '', '', 'north-america'),
(13, 'navassa-island', 198, '', '', '', '', 'north-america'),
(13, 'netherlands-antilles', 199, '', '', '', '', 'north-america'),
(13, 'nicaragua', 200, '', '', '', '', 'north-america'),
(13, 'panama', 201, '', '', '', '', 'north-america'),
(13, 'puerto-rico', 202, '', '', '', '', 'north-america'),
(13, 'saint-barthelemy', 203, '', '', '', '', 'north-america'),
(13, 'saint-kitts-and-nevis', 204, '', '', '', '', 'north-america'),
(13, 'saint-lucia', 205, '', '', '', '', 'north-america'),
(13, 'saint-martin', 206, '', '', '', '', 'north-america'),
(13, 'saint-pierre-and-miquelon', 207, '', '', '', '', 'north-america'),
(13, 'saint-vincent-grenadines', 208, '', '', '', '', 'north-america'),
(13, 'trinidad-and-tobago', 209, '', '', '', '', 'north-america'),
(13, 'turks-and-caicos-islands', 210, '', '', '', '', 'north-america'),
(13, 'usa', 211, '', '', '', '', 'north-america'),
(13, 'virgin-islands', 212, '', '', '', '', 'north-america'),
(13, 'south-america', 213, '', '', '', '', ''),
(13, 'argentina', 214, '', '', '', '', 'south-america'),
(13, 'bolivia', 215, '', '', '', '', 'south-america'),
(13, 'brazil', 216, '', '', '', '', 'south-america'),
(13, 'chile', 217, '', '', '', '', 'south-america'),
(13, 'colombia', 218, '', '', '', '', 'south-america'),
(13, 'ecuador', 219, '', '', '', '', 'south-america'),
(13, 'falkland-islands', 220, '', '', '', '', 'south-america'),
(13, 'french-guiana', 221, '', '', '', '', 'south-america'),
(13, 'guyana', 222, '', '', '', '', 'south-america'),
(13, 'paraguay', 223, '', '', '', '', 'south-america'),
(13, 'peru', 224, '', '', '', '', 'south-america'),
(13, 'suriname', 225, '', '', '', '', 'south-america'),
(13, 'uruguay', 226, '', '', '', '', 'south-america'),
(13, 'venezuela', 227, '', '', '', '', 'south-america'),
(13, 'oceania', 228, '', '', '', '', ''),
(13, 'american-samoa', 229, '', '', '', '', 'oceania'),
(13, 'ashmore-and-cartier', 230, '', '', '', '', 'oceania'),
(13, 'australia', 231, '', '', '', '', 'oceania'),
(13, 'baker-island', 232, '', '', '', '', 'oceania'),
(13, 'cook-islands', 233, '', '', '', '', 'oceania'),
(13, 'coral-sea-islands', 234, '', '', '', '', 'oceania'),
(13, 'fiji', 235, '', '', '', '', 'oceania'),
(13, 'french-polynesia', 236, '', '', '', '', 'oceania'),
(13, 'guam', 237, '', '', '', '', 'oceania'),
(13, 'howland-island', 238, '', '', '', '', 'oceania'),
(13, 'jarvis-island', 239, '', '', '', '', 'oceania'),
(13, 'johnston-atoll', 240, '', '', '', '', 'oceania'),
(13, 'kingman-reef', 241, '', '', '', '', 'oceania'),
(13, 'kiribati', 242, '', '', '', '', 'oceania'),
(13, 'marshall-islands', 243, '', '', '', '', 'oceania'),
(13, 'micronesia', 244, '', '', '', '', 'oceania'),
(13, 'midway-atoll', 245, '', '', '', '', 'oceania'),
(13, 'nauru', 246, '', '', '', '', 'oceania'),
(13, 'new-caledonia', 247, '', '', '', '', 'oceania'),
(13, 'new-zealand', 248, '', '', '', '', 'oceania'),
(13, 'niue', 249, '', '', '', '', 'oceania'),
(13, 'norfolk-island', 250, '', '', '', '', 'oceania'),
(13, 'northern-mariana-islands', 251, '', '', '', '', 'oceania'),
(13, 'palau', 252, '', '', '', '', 'oceania'),
(13, 'palmyra-atoll', 253, '', '', '', '', 'oceania'),
(13, 'papua-new-guinea', 254, '', '', '', '', 'oceania'),
(13, 'pitcairn-islands', 255, '', '', '', '', 'oceania'),
(13, 'samoa', 256, '', '', '', '', 'oceania'),
(13, 'solomon-islands', 257, '', '', '', '', 'oceania'),
(13, 'tokelau', 258, '', '', '', '', 'oceania'),
(13, 'tonga', 259, '', '', '', '', 'oceania'),
(13, 'tuvalu', 260, '', '', '', '', 'oceania'),
(13, 'vanuatu', 261, '', '', '', '', 'oceania'),
(13, 'wake-island', 262, '', '', '', '', 'oceania'),
(13, 'wallis-and-futuna', 263, '', '', '', '', 'oceania'),
(13, 'antarctica', 264, '', '', '', '', ''),
(13, 'bouvet-island', 265, '', '', '', '', 'antarctica'),
(13, 'french-southern-territories', 266, '', '', '', '', 'antarctica'),
(13, 'heard-island-mcdonald-islands', 267, '', '', '', '', 'antarctica'),
(13, 'south-georgia-south-sandwich-islands', 268, '', '', '', '', 'antarctica');

CREATE TABLE IF NOT EXISTS `#__sobipro_field_option_selected` (
	`fid`      INT(11)      NOT NULL,
	`sid`      INT(11)      NOT NULL,
	`optValue` VARCHAR(100) NOT NULL,
	`params`   TEXT         NOT NULL,
	`copy`     TINYINT(1)   NOT NULL,
	PRIMARY KEY (`fid`, `sid`, `optValue`, `copy`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_field_option_selected` (`fid`, `sid`, `optValue`, `params`, `copy`) VALUES
(12, 37, 'Thursday', '', 0),
(12, 37, 'Wednesday', '', 0),
(12, 39, 'Thursday', '', 0),
(12, 39, 'Wednesday', '', 0),
(12, 39, 'Tuesday', '', 0),
(12, 37, 'Monday', '', 0),
(12, 37, 'Tuesday', '', 0),
(12, 38, 'Wednesday', '', 0),
(12, 38, 'Monday', '', 0),
(12, 38, 'Tuesday', '', 0),
(12, 37, 'Friday', '', 0),
(12, 38, 'Thursday', '', 0),
(12, 38, 'Friday', '', 0),
(12, 38, 'Saturday', '', 0),
(12, 39, 'Friday', '', 0),
(12, 39, 'Saturday', '', 0),
(13, 39, 'usa', '', 0),
(13, 37, 'france', '', 0),
(13, 38, 'germany', '', 0);

CREATE TABLE IF NOT EXISTS `#__sobipro_field_types` (
	`tid`    CHAR(50)     NOT NULL,
	`fType`  VARCHAR(50)  NOT NULL,
	`tGroup` VARCHAR(100) NOT NULL,
	`fPos`   INT(11)      NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`tid`, `tGroup`),
	UNIQUE KEY `pos` (`fPos`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 13;

INSERT IGNORE INTO `#__sobipro_field_types` (`tid`, `fType`, `tGroup`, `fPos`) VALUES
('inbox', 'Input Box', 'free_single_simple_data', 1),
('textarea', 'Text Area', 'free_single_simple_data', 2),
('multiselect', 'Multiple Select List', 'predefined_multi_data_multi_choice', 3),
('chbxgroup', 'Check Box Group', 'predefined_multi_data_multi_choice', 4),
('select', 'Single Select List', 'predefined_multi_data_single_choice', 7),
('radio', 'Radio Buttons', 'predefined_multi_data_single_choice', 8),
('image', 'Image', 'special', 9),
('url', 'URL', 'special', 10),
('category', 'Category', 'special', 11),
('email', 'Email', 'special', 12);

CREATE TABLE IF NOT EXISTS `#__sobipro_field_url_clicks` (
	`date`        DATETIME    NOT NULL,
	`uid`         INT(11)     NOT NULL,
	`sid`         INT(11)     NOT NULL,
	`fid`         VARCHAR(50) NOT NULL,
	`ip`          VARCHAR(15) NOT NULL,
	`section`     INT(11)     NOT NULL,
	`browserData` TEXT        NOT NULL,
	`osData`      TEXT        NOT NULL,
	`humanity`    INT(3)      NOT NULL,
	PRIMARY KEY (`date`, `sid`, `fid`, `ip`, `section`)
);


CREATE TABLE IF NOT EXISTS `#__sobipro_language` (
	`sKey`        VARCHAR(150) NOT NULL DEFAULT '',
	`sValue`      TEXT,
	`section`     INT(11) DEFAULT NULL,
	`language`    VARCHAR(50)  NOT NULL DEFAULT '',
	`oType`       VARCHAR(150) NOT NULL,
	`fid`         INT(11)      NOT NULL,
	`id`          INT(11)      NOT NULL DEFAULT '0',
	`params`      TEXT,
	`options`     TEXT,
	`explanation` TEXT,
	PRIMARY KEY (`sKey`, `language`, `id`, `fid`),
	KEY `sKey` (`sKey`),
	KEY `section` (`section`),
	KEY `language` (`language`),
	FULLTEXT KEY `sValue` (`sValue`)
)
	ENGINE = MyISAM
	DEFAULT CHARSET = utf8;


INSERT IGNORE INTO `#__sobipro_language` (`sKey`, `sValue`, `section`, `language`, `oType`, `fid`, `id`, `params`, `options`, `explanation`) VALUES
('description', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque laoreet rhoncus tempor. Suspendisse dapibus vulputate dolor ut tincidunt. Suspendisse tristique laoreet dui, ut tempor orci dictum ut. Quisque aliquam urna ac justo tristique interdum. Aliquam in dui eget lectus elementum lacinia eget eu sem. Nam eu felis tellus, ac cursus velit. Etiam magna libero, condimentum at facilisis a, fermentum eget leo. Nulla gravida imperdiet neque, accumsan auctor magna viverra a. Aliquam eget augue a ante malesuada convallis a nec mi. Phasellus mollis, urna et interdum congue, lacus ante lacinia ipsum, vitae fringilla quam mi id ipsum.</p>', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('name', 'Business Directory', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('name', 'Company Name', NULL, 'en-GB', 'field', 1, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 1, 0, NULL, NULL, NULL),
('description', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque  laoreet rhoncus tempor. Suspendisse dapibus vulputate dolor ut  tincidunt. Suspendisse tristique laoreet dui, ut tempor orci dictum ut.  Quisque aliquam urna ac justo tristique interdum. Aliquam in dui eget  lectus elementum lacinia eget eu sem. Nam eu felis tellus, ac cursus  velit. Etiam magna libero, condimentum at facilisis a, fermentum eget  leo. Nulla gravida imperdiet neque, accumsan auctor magna viverra a.  Aliquam eget augue a ante malesuada convallis a nec mi. Phasellus  mollis, urna et interdum congue, lacus ante lacinia ipsum, vitae  fringilla quam mi id ipsum.</p>', NULL, 'en-GB', 'category', 0, 2, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 2, NULL, NULL, NULL),
('name', 'Computers and Internet', NULL, 'en-GB', 'category', 0, 2, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 3, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 3, NULL, NULL, NULL),
('name', 'Games', NULL, 'en-GB', 'category', 0, 3, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 4, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 4, NULL, NULL, NULL),
('name', 'Health', NULL, 'en-GB', 'category', 0, 4, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 5, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 5, NULL, NULL, NULL),
('name', 'Home & Garden', NULL, 'en-GB', 'category', 0, 5, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 6, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 6, NULL, NULL, NULL),
('name', 'News', NULL, 'en-GB', 'category', 0, 6, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 7, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 7, NULL, NULL, NULL),
('name', 'Shopping', NULL, 'en-GB', 'category', 0, 7, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 8, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 8, NULL, NULL, NULL),
('name', 'Communications', NULL, 'en-GB', 'category', 0, 8, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 9, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 9, NULL, NULL, NULL),
('name', 'Graphics', NULL, 'en-GB', 'category', 0, 9, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 10, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 10, NULL, NULL, NULL),
('name', 'Hardware', NULL, 'en-GB', 'category', 0, 10, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 11, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 11, NULL, NULL, NULL),
('name', 'Mobile Computing', NULL, 'en-GB', 'category', 0, 11, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 12, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 12, NULL, NULL, NULL),
('name', 'Multimedia', NULL, 'en-GB', 'category', 0, 12, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 13, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 13, NULL, NULL, NULL),
('name', 'Open Source', NULL, 'en-GB', 'category', 0, 13, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 14, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 14, NULL, NULL, NULL),
('name', 'Card Games', NULL, 'en-GB', 'category', 0, 14, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 15, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 15, NULL, NULL, NULL),
('name', 'Computer Games', NULL, 'en-GB', 'category', 0, 15, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 16, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 16, NULL, NULL, NULL),
('name', 'Puzzles', NULL, 'en-GB', 'category', 0, 16, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 17, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 17, NULL, NULL, NULL),
('name', 'Video Games', NULL, 'en-GB', 'category', 0, 17, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 18, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 18, NULL, NULL, NULL),
('name', 'Beauty', NULL, 'en-GB', 'category', 0, 18, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 19, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 19, NULL, NULL, NULL),
('name', 'Fitness', NULL, 'en-GB', 'category', 0, 19, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 20, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 20, NULL, NULL, NULL),
('name', 'Pharmacy', NULL, 'en-GB', 'category', 0, 20, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 21, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 21, NULL, NULL, NULL),
('name', 'Weight Loss', NULL, 'en-GB', 'category', 0, 21, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 22, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 22, NULL, NULL, NULL),
('name', 'Do-It-Yourself', NULL, 'en-GB', 'category', 0, 22, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 23, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 23, NULL, NULL, NULL),
('name', 'Moving and Relocating', NULL, 'en-GB', 'category', 0, 23, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 24, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 24, NULL, NULL, NULL),
('name', 'Personal Finance', NULL, 'en-GB', 'category', 0, 24, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 25, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 25, NULL, NULL, NULL),
('name', 'Pets', NULL, 'en-GB', 'category', 0, 25, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 26, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 26, NULL, NULL, NULL),
('name', 'Chats and Forums', NULL, 'en-GB', 'category', 0, 26, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 27, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 27, NULL, NULL, NULL),
('name', 'Current Events', NULL, 'en-GB', 'category', 0, 27, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 28, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 28, NULL, NULL, NULL),
('name', 'Journalism', NULL, 'en-GB', 'category', 0, 28, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 29, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 29, NULL, NULL, NULL),
('name', 'Television', NULL, 'en-GB', 'category', 0, 29, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 30, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 30, NULL, NULL, NULL),
('name', 'Weather', NULL, 'en-GB', 'category', 0, 30, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 31, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 31, NULL, NULL, NULL),
('name', 'Books', NULL, 'en-GB', 'category', 0, 31, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 32, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 32, NULL, NULL, NULL),
('name', 'Movies & Music', NULL, 'en-GB', 'category', 0, 32, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 33, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 33, NULL, NULL, NULL),
('name', 'Toys', NULL, 'en-GB', 'category', 0, 33, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 34, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 34, NULL, NULL, NULL),
('name', 'Home Improvement', NULL, 'en-GB', 'category', 0, 34, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 35, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 35, NULL, NULL, NULL),
('name', 'Software', NULL, 'en-GB', 'category', 0, 35, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'category', 0, 36, NULL, NULL, NULL),
('introtext', '', NULL, 'en-GB', 'category', 0, 36, NULL, NULL, NULL),
('name', 'Autos', NULL, 'en-GB', 'category', 0, 36, NULL, NULL, NULL),
('name', 'Postcode', NULL, 'en-GB', 'field', 2, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 2, 0, NULL, NULL, NULL),
('name', 'City', NULL, 'en-GB', 'field', 3, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 3, 0, NULL, NULL, NULL),
('name', 'Contact Person', NULL, 'en-GB', 'field', 4, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 4, 0, NULL, NULL, NULL),
('name', 'Phone', NULL, 'en-GB', 'field', 5, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 5, 0, NULL, NULL, NULL),
('name', 'Fax', NULL, 'en-GB', 'field', 6, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 6, 0, NULL, NULL, NULL),
('name', 'Email', NULL, 'en-GB', 'field', 7, 0, NULL, NULL, NULL),
('description', 'The entered email address will not be visible for visitors', NULL, 'en-GB', 'field', 7, 0, NULL, NULL, NULL),
('name', 'Short Description', NULL, 'en-GB', 'field', 8, 0, NULL, NULL, NULL),
('description', 'Short company description. This text will be displayed at the category listing page. Maximal length 300 characters. ', NULL, 'en-GB', 'field', 8, 0, NULL, NULL, NULL),
('name', 'Full Description', NULL, 'en-GB', 'field', 9, 0, NULL, NULL, NULL),
('description', 'Full company description will be displayed at the details view page.', NULL, 'en-GB', 'field', 9, 0, NULL, NULL, NULL),
('name', 'Company Logo', NULL, 'en-GB', 'field', 10, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 10, 0, NULL, NULL, NULL),
('name', 'Website', NULL, 'en-GB', 'field', 11, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 11, 0, NULL, NULL, NULL),
('name', 'Business Days', NULL, 'en-GB', 'field', 12, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 12, 0, NULL, NULL, NULL),
('Sunday', 'Sunday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('Saturday', 'Saturday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('Friday', 'Friday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('Thursday', 'Thursday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('Wednesday', 'Wednesday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('Tuesday', 'Tuesday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('Monday', 'Monday', NULL, 'en-GB', 'field_option', 12, 0, NULL, NULL, NULL),
('name', 'No name', NULL, 'en-GB', 'entry', 0, 37, NULL, NULL, NULL),
('name', '', NULL, 'en-GB', 'entry', 0, 38, NULL, NULL, NULL),
('name', '', NULL, 'en-GB', 'entry', 0, 39, NULL, NULL, NULL),
('name', 'Country', NULL, 'en-GB', 'field', 13, 0, NULL, NULL, NULL),
('description', '', NULL, 'en-GB', 'field', 13, 0, NULL, NULL, NULL),
('johnston-atoll', 'Johnston Atoll', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('palau', 'Palau', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('jarvis-island', 'Jarvis Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('niue', 'Niue', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('howland-island', 'Howland Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('micronesia', 'Micronesia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('french-polynesia', 'French Polynesia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('nauru', 'Nauru', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kiribati', 'Kiribati', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('coral-sea-islands', 'Coral Sea Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guam', 'Guam', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cook-islands', 'Cook Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('baker-island', 'Baker Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('fiji', 'Fiji', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('ashmore-and-cartier', 'Ashmore and Cartier Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('american-samoa', 'American Samoa', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('oceania', ' Oceania', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('australia', 'Australia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('french-guiana', 'French Guiana', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('falkland-islands', 'Falkland Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('south-america', 'South America', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('venezuela', 'Venezuela', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('uruguay', 'Uruguay', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('suriname', 'Suriname', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('peru', 'Peru', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('paraguay', 'Paraguay', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guyana', 'Guyana', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('virgin-islands', 'United States Virgin Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('ecuador', 'Ecuador', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('colombia', 'Colombia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('brazil', 'Brazil', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('chile', 'Chile', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bolivia', 'Bolivia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('turks-and-caicos-islands', 'Turks and Caicos Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('argentina', 'Argentina', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('usa', 'United States', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('trinidad-and-tobago', 'Trinidad and Tobago', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saint-vincent-grenadines', 'Saint Vincent and the Grenadines', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saint-pierre-and-miquelon', 'Saint Pierre and Miquelon', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saint-martin', 'Saint Martin', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saint-lucia', 'Saint Lucia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saint-kitts-and-nevis', 'Saint Kitts and Nevis', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saint-barthelemy', 'Saint Barthélemy', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('puerto-rico', 'Puerto Rico', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('nicaragua', 'Nicaragua', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('panama', 'Panama', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('netherlands-antilles', 'Netherlands Antilles', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('navassa-island', 'Navassa Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('montserrat', 'Montserrat', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mexico', 'Mexico', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('martinique', 'Martinique', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('jamaica', 'Jamaica', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('honduras', 'Honduras', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('haiti', 'Haiti', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guatemala', 'Guatemala', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guadeloupe', 'Guadeloupe', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('grenada', 'Grenada', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('el-salvador', 'El Salvador', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('greenland', 'Greenland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('dominican-republic', 'Dominican Republic', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('dominica', 'Dominica', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cuba', 'Cuba', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('costa-rica', 'Costa Rica', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('clipperton-island', 'Clipperton Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('canada', 'Canada', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cayman-islands', 'Cayman Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('british-virgin-islands', 'British Virgin Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bermuda', 'Bermuda', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('belize', 'Belize', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('barbados', 'Barbados', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('aruba', 'Aruba', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bahamas', 'Bahamas', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('antigua-and-barbuda', 'Antigua and Barbuda', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('anguilla', 'Anguilla', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('north-america', 'North America', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('vatican', 'Vatican City', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('ukraine', 'Ukraine', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('transnistria', 'Transnistria', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('switzerland', 'Switzerland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('sweden', 'Sweden', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('svalbard', 'Svalbard', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('spain', 'Spain', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('slovenia', 'Slovenia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('serbia', 'Serbia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('slovakia', 'Slovakia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('russia', 'Russia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('united-kingdom', 'United Kingdom', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('romania', 'Romania', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('portugal', 'Portugal', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('poland', 'Poland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('norway', 'Norway', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('netherlands', 'Netherlands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('montenegro', 'Montenegro', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('monaco', 'Monaco', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kosovo', 'Kosovo', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('latvia', 'Latvia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('liechtenstein', 'Liechtenstein', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('lithuania', 'Lithuania', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('luxembourg', 'Luxembourg', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('macedonia', 'Macedonia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('malta', 'Malta', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('moldova', 'Moldova', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('jersey', 'Jersey', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('italy', 'Italy', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('ireland', 'Ireland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('san-marino', 'San Marino', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('iceland', 'Iceland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('hungary', 'Hungary', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guernsey', 'Guernsey', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('greece', 'Greece', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('gibraltar', 'Gibraltar', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('germany', 'Germany', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('isle-of-man', 'Isle of Man', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('france', 'France', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('finland', 'Finland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('estonia', 'Estonia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('denmark', 'Denmark', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('faroe-islands', 'Faroe Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('belgium', 'Belgium', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('czech-republic', 'Czech Republic', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('croatia', 'Croatia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bulgaria', 'Bulgaria', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('belarus', 'Belarus', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('andorra', 'Andorra', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('austria', 'Austria', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('albania', 'Albania', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('vietnam', 'Vietnam', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('yemen', 'Yemen', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bosnia-herzegovina', 'Bosnia and Herzegovina', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('uzbekistan', 'Uzbekistan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('aland-islands', 'Åland Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('turkmenistan', 'Turkmenistan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('turkey', 'Turkey', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('thailand', 'Thailand', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('timor-leste', 'Timor-Leste', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('tajikistan', 'Tajikistan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('europe', ' Europe', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('syria', 'Syria', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('singapore', 'Singapore', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('philippines', 'Philippines', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('qatar', 'Qatar', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('united-arab-emirates', 'United Arab Emirates', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('sri-lanka', 'Sri Lanka', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('pakistan', 'Pakistan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('nepal', 'Nepal', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('oman', 'Oman', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('south-ossetia', 'South Ossetia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('nagorno-karabakh', 'Nagorno-Karabakh', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('maldives', 'Maldives', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mongolia', 'Mongolia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('myanmar', 'Myanmar', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('macau', 'Macau', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('malaysia', 'Malaysia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('lebanon', 'Lebanon', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('laos', 'Laos', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('saudi-arabia', 'Saudi Arabia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kuwait', 'Kuwait', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kyrgyzstan', 'Kyrgyzstan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kazakhstan', 'Kazakhstan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('jordan', 'Jordan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('japan', 'Japan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('israel', 'Israel', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('iraq', 'Iraq', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('iran', 'Iran', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('palestinian-territories', 'Palestinian territories', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('india', 'India', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('indonesia', 'Indonesia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('georgia', 'Georgia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cyprus', 'Cyprus', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('taiwan', 'China, Republic of - Taiwan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('northern-cyprus', 'Northern Cyprus', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('china', 'China', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cambodia', 'Cambodia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('brunei', 'Brunei', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('korea-republic', 'Korea, Republic of', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bhutan', 'Bhutan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bangladesh', 'Bangladesh', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bahrain', 'Bahrain', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('azerbaijan', 'Azerbaijan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('armenia', 'Armenia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('north-korea', 'Korea, Democratic People''s Republic of', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('afghanistan', 'Afghanistan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('zambia', 'Zambia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('zimbabwe', 'Zimbabwe', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('asia', 'Asia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('abkhazia', 'Abkhazia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('hong-kong', 'Hong Kong', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('uganda', 'Uganda', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('tunisia', 'Tunisia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('swaziland', 'Swaziland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('sudan', 'Sudan', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('somalia', 'Somalia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('somaliland', 'Somaliland', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cocos-islands', 'Cocos (Keeling) Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('senegal', 'Senegal', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('seychelles', 'Seychelles', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('christmas-island', 'Christmas Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('rwanda', 'Rwanda', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('niger', 'Niger', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('nigeria', 'Nigeria', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('namibia', 'Namibia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mozambique', 'Mozambique', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mayotte', 'Mayotte', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('morocco', 'Morocco', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mauritius', 'Mauritius', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mauritania', 'Mauritania', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('mali', 'Mali', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('malawi', 'Malawi', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('madagascar', 'Madagascar', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('libya', 'Libya', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('liberia', 'Liberia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('lesotho', 'Lesotho', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kenya', 'Kenya', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guinea-bissau', 'Guinea-Bissau', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('guinea', 'Guinea', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('ghana', 'Ghana', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('gambia', 'Gambia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('gabon', 'Gabon', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('ethiopia', 'Ethiopia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('eritrea', 'Eritrea', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('british-indian', 'British Indian Ocean Territory', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('egypt', 'Egypt', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('djibouti', 'Djibouti', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('akrotiri-and-dhekelia', 'Akrotiri and Dhekelia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('western-sahara', 'Western Sahara', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('south-africa', 'South Africa', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('comoros', 'Comoros', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('chad', 'Chad', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('sierra-leone', 'Sierra Leone', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cameroon', 'Cameroon', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('burundi', 'Burundi', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('sao-tome-and-principe', 'Sao Tome and Principe', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('botswana', 'Botswana', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('benin', 'Benin', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('angola', 'Angola', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('algeria', 'Algeria', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('africa', 'Africa', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('reunion', 'Réunion', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('samoa', 'Samoa', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('equatorial-guinea', 'Equatorial Guinea', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('tokelau', 'Tokelau', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('tonga', 'Tonga', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('tuvalu', 'Tuvalu', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('vanuatu', 'Vanuatu', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cote-d-ivoire', 'Côte d''Ivoire', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('congo-republic-of', 'Congo, Republic of', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('congo-democratic', 'Congo, Democratic Republic of', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('central-african-republic', 'Central African Republic', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('burkina-faso', 'Burkina Faso', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('cape-verde', 'Cape Verde', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('kingman-reef', 'Kingman Reef', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('marshall-islands', 'Marshall Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('midway-atoll', 'Midway Atoll', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('new-caledonia', 'New Caledonia', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('new-zealand', 'New Zealand', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('norfolk-island', 'Norfolk Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('northern-mariana-islands', 'Northern Mariana Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('palmyra-atoll', 'Palmyra Atoll', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('papua-new-guinea', 'Papua New Guinea', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('pitcairn-islands', 'Pitcairn Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('solomon-islands', 'Solomon Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('wake-island', 'Wake Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('wallis-and-futuna', 'Wallis and Futuna', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('antarctica', ' Antarctica', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('bouvet-island', 'Bouvet Island', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('french-southern-territories', 'French Southern Territories', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('heard-island-mcdonald-islands', 'Heard Island and McDonald Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('south-georgia-south-sandwich-islands', 'South Georgia and the South Sandwich Islands', NULL, 'en-GB', 'field_option', 13, 0, NULL, NULL, NULL),
('suffix', '', NULL, 'en-GB', 'field', 6, 0, NULL, NULL, NULL),
('metaKeys', 'Business, Directory', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('metaDesc', 'Business Directory', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('name', 'Street', NULL, 'en-GB', 'field', 14, 0, NULL, NULL, NULL),
('name', 'Category', NULL, 'en-GB', 'field', 15, 0, NULL, NULL, NULL),
('bankdata', '<p>Payment Subject: "Entry in the {section.name} at the {cfg:site_name}. Entry id {entry.id}"</p>\r\n<ul>\r\n<li>Account Owner: Jon Doe </li>\r\n<li>Account No.: 8274230479 </li>\r\n<li>Bank No.: 8038012380 </li>\r\n<li>IBAN: 234242343018 </li>\r\n<li>BIC: 07979079779ABCDEFGH</li>\r\n</ul>', 1, 'en-GB', 'application', 0, 1, '', '', ''),
('ppexpl', '<p>Please click on the button below to pay via Paypal.</p>\r\n<p> </p>', 1, 'en-GB', 'application', 0, 1, '', '', ''),
('ppsubject', 'Entry in the {section.name} at the {cfg:site_name}. Entry id {entry.id}', 1, 'en-GB', 'application', 0, 1, '', '', ''),
('sfMetaKeys', 'search', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('sfMetaDesc', 'Search Business', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('efMetaKeys', 'add, edit', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('efMetaDesc', 'Add/Edit Business', NULL, 'en-GB', 'section', 0, 1, NULL, NULL, NULL),
('rejection-of-a-new-entry', 'Entry {entry.name} has been rejected as it does not comply with the rules.\n\nRejected by {user.name} at {date%F Y H:i:s}', 0, 'en-GB', 'rejections-templates', 0, 1, '', '', ''),
('rejection-of-changes', 'Changes in {entry.name} discarded as these changes violating rules. \n\nRejected by {user.name} at {date}', 0, 'en-GB', 'rejections-templates', 0, 1, '', '', '');


CREATE TABLE IF NOT EXISTS `#__sobipro_object` (
	`id`          INT(11)      NOT NULL AUTO_INCREMENT,
	`nid`         VARCHAR(255) NOT NULL,
	`name`        VARCHAR(250) DEFAULT NULL,
	`approved`    TINYINT(1) DEFAULT NULL,
	`confirmed`   TINYINT(1) DEFAULT NULL,
	`counter`     INT(11)      NOT NULL DEFAULT '0',
	`cout`        INT(11) DEFAULT NULL,
	`coutTime`    DATETIME DEFAULT NULL,
	`createdTime` DATETIME DEFAULT NULL,
	`defURL`      VARCHAR(250) DEFAULT NULL,
	`metaDesc`    TEXT,
	`metaKeys`    TEXT,
	`metaAuthor`  VARCHAR(150) NOT NULL,
	`metaRobots`  VARCHAR(150) NOT NULL,
	`options`     TEXT,
	`oType`       VARCHAR(50) DEFAULT NULL,
	`owner`       INT(11) DEFAULT NULL,
	`ownerIP`     VARCHAR(15) DEFAULT NULL,
	`params`      TEXT,
	`parent`      INT(11) DEFAULT NULL,
	`state`       TINYINT(4) DEFAULT NULL,
	`stateExpl`   VARCHAR(250) DEFAULT NULL,
	`updatedTime` DATETIME DEFAULT NULL,
	`updater`     INT(11) DEFAULT NULL,
	`updaterIP`   VARCHAR(15) DEFAULT NULL,
	`validSince`  DATETIME DEFAULT NULL,
	`validUntil`  DATETIME DEFAULT NULL,
	`version`     INT(11)      NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`),
	KEY `name` (`name`),
	KEY `oType` (`oType`),
	KEY `owner` (`owner`),
	KEY `parent` (`parent`),
	KEY `state` (`state`),
	KEY `validSince` (`validSince`),
	KEY `validUntil` (`validUntil`),
	KEY `version` (`version`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 54;

INSERT IGNORE INTO `#__sobipro_object` (`id`, `nid`, `name`, `approved`, `confirmed`, `counter`, `cout`, `coutTime`, `createdTime`, `defURL`, `metaDesc`, `metaKeys`, `metaAuthor`, `metaRobots`, `options`, `oType`, `owner`, `ownerIP`, `params`, `parent`, `state`, `stateExpl`, `updatedTime`, `updater`, `updaterIP`, `validSince`, `validUntil`, `version`) VALUES
(1, 'business-directory', 'Business Directory', 1, 1, 674, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', 'Business Directory', 'Business, Directory', 'Radek Suski', '', '', 'section', 63, '84.59.167.50', '', 0, 1, '', '2013-01-02 16:24:47', 791, '192.168.1.32', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(2, 'computers-and-internet', 'Computers and Internet', 1, 0, 104, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 1, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(3, 'games', 'Games', 1, 0, 15, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 1, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(4, 'health', 'Health', 1, 0, 13, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 1, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(5, 'home-garden', 'Home & Garden', 1, 0, 12, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 1, 1, '', '22013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(6, 'news', 'News', 1, 0, 13, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 1, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(7, 'shopping', 'Shopping', 1, 0, 37, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 1, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(8, 'communications', 'Communications', 1, 0, 20, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2010-08-24 21:23:32', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(9, 'graphics', 'Graphics', 1, 0, 10, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2010-08-24 21:15:14', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(10, 'hardware', 'Hardware', 1, 0, 8, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2010-08-24 21:16:49', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(11, 'mobile-computing', 'Mobile Computing', 1, 0, 7, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2010-08-24 21:18:03', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(12, 'multimedia', 'Multimedia', 1, 0, 11, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2010-08-24 21:18:41', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(13, 'open-source', 'Open Source', 1, 0, 5, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2010-08-24 21:19:55', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(14, 'card-games', 'Card Games', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 3, 1, '', '2010-08-24 21:20:52', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(15, 'computer-games', 'Computer Games', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 3, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 3),
(16, 'puzzles', 'Puzzles', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 3, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 3),
(17, 'video-games', 'Video Games', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 3, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(18, 'beauty', 'Beauty', 1, 0, 7, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 4, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(19, 'fitness', 'Fitness', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 4, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(20, 'pharmacy', 'Pharmacy', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 4, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(21, 'weight-loss', 'Weight Loss', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 4, 1, '', '2013-01-02 00:00:00', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(22, 'do-it-yourself', 'Do it Yourself', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 5, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(23, 'moving-and-relocating', 'Moving and Relocating', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 5, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(24, 'personal-finance', 'Personal Finance', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 5, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(25, 'pets', 'Pets', 1, 0, 7, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 5, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(26, 'chats-and-forums', 'Chats and Forums', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 6, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 3),
(27, 'current-events', 'Current Events', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 6, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 3),
(28, 'journalism', 'Journalism', 1, 0, 6, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 6, 1, '', '2010-08-24 21:33:04', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(29, 'television', 'Television', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 6, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(30, 'weather', 'Weather', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 6, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(31, 'books', 'Books', 1, 0, 6, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 7, 1, '', '2010-08-24 21:35:34', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(32, 'movies-music', 'Movies & Music', 1, 0, 7, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 7, 1, '', '2010-08-24 21:36:22', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(33, 'toys', 'Toys', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 7, 1, '', '2010-08-24 21:36:49', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(34, 'home-improvement', 'Home Improvement', 1, 0, 7, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 7, 1, '', '2010-08-24 21:37:49', 63, '84.59.167.50', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 1),
(35, 'software', 'Software', 1, 0, 4, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 2, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 4),
(36, 'autos', 'Autos', 1, 0, 6, 63, '2013-01-02 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'category', 63, '84.59.167.50', '', 7, 1, '', '2013-01-02 00:00:00', 63, '88.68.227.138', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 2),
(37, 'neo-electronics', '', 1, 0, 35, 0, '0000-00-00 00:00:00', '2013-01-02 17:26:12', '', '', '', '', '', '', 'entry', 0, '88.68.227.138', '', 2, 1, '', '2013-01-02 16:25:51', 791, '192.168.1.32', '2013-01-02 17:26:08', '0000-00-00 00:00:00', 4),
(38, 'n-communications', '', 1, 0, 114, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'entry', 0, '88.68.227.138', '', 8, 1, '', '2013-01-02 00:00:00', 63, '88.69.191.86', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 5),
(39, 'sun-bookstore', '', 1, 0, 68, 0, '0000-00-00 00:00:00', '2013-01-02 00:00:00', '', '', '', '', '', '', 'entry', 0, '88.68.227.138', '', 32, 1, '', '2013-01-02 00:00:00', 63, '88.69.191.86', '2013-01-02 00:00:00', '0000-00-00 00:00:00', 6);

CREATE TABLE IF NOT EXISTS `#__sobipro_payments` (
	`pid`        INT(11)      NOT NULL AUTO_INCREMENT,
	`refNum`     VARCHAR(50)  NOT NULL,
	`sid`        INT(11)      NOT NULL,
	`fid`        INT(11)      NOT NULL,
	`subject`    VARCHAR(150) NOT NULL,
	`dateAdded`  DATETIME     NOT NULL,
	`datePaid`   DATETIME     NOT NULL,
	`validUntil` DATETIME     NOT NULL,
	`paid`       TINYINT(4)   NOT NULL,
	`amount`     DOUBLE       NOT NULL,
	`params`     TEXT         NOT NULL,
	PRIMARY KEY (`pid`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 16;

INSERT IGNORE INTO `#__sobipro_payments` (`pid`, `refNum`, `sid`, `fid`, `subject`, `dateAdded`, `datePaid`, `validUntil`, `paid`, `amount`, `params`) VALUES
(1, '1282745518.37', 37, 9, 'Full Description', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 20, ''),
(2, '1282745518.37', 37, 10, 'Company Logo', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5, ''),
(3, '1282745518.37', 37, 11, 'Website', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 10, ''),
(4, '1282748655.38', 38, 10, 'Company Logo', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5, ''),
(5, '1282748655.38', 38, 11, 'Website', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 10, ''),
(6, '1282748655.38', 38, 9, 'Full Description', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 20, ''),
(7, '1282750744.39', 39, 10, 'Company Logo', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 5, ''),
(8, '1282750744.39', 39, 11, 'Website', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 10, ''),
(9, '1282750744.39', 39, 9, 'Full Description', '2013-01-02 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 20, '');

CREATE TABLE IF NOT EXISTS `#__sobipro_permissions` (
	`pid`       INT(11)     NOT NULL AUTO_INCREMENT,
	`subject`   VARCHAR(150) DEFAULT NULL,
	`action`    VARCHAR(50) DEFAULT NULL,
	`value`     VARCHAR(50) NOT NULL,
	`site`      VARCHAR(50) NOT NULL,
	`published` TINYINT(1)  NOT NULL,
	PRIMARY KEY (`pid`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 26;

INSERT IGNORE INTO `#__sobipro_permissions` (`pid`, `subject`, `action`, `value`, `site`, `published`) VALUES
(1, '*', '*', '*', 'front', 0),
(2, 'section', '*', '*', 'front', 0),
(3, 'section', 'access', '*', 'front', 1),
(4, 'section', 'access', 'valid', 'front', 1),
(6, 'category', '*', '*', 'front', 0),
(7, 'category', 'access', 'valid', 'front', 1),
(8, 'category', 'access', '*', 'front', 1),
(9, 'entry', '*', '*', 'front', 1),
(10, 'entry', 'access', 'valid', 'front', 1),
(11, 'entry', 'access', '*', 'front', 1),
(12, 'entry', 'access', 'unpublished_own', 'front', 1),
(13, 'entry', 'access', 'unapproved_own', 'front', 0),
(14, 'entry', 'access', 'unpublished_any', 'front', 1),
(15, 'entry', 'access', 'unapproved_any', 'front', 1),
(16, 'entry', 'add', 'own', 'front', 1),
(17, 'entry', 'edit', 'own', 'front', 1),
(18, 'entry', 'edit', '*', 'front', 1),
(19, 'entry', 'manage', '*', 'front', 1),
(20, 'entry', 'publish', '*', 'front', 1),
(21, 'entry', 'publish', 'own', 'front', 1),
(22, 'entry', 'adm_fields', '*', 'front', 0),
(23, 'entry', 'adm_fields', 'see', 'front', 0),
(24, 'entry', 'adm_fields', 'edit', 'front', 1),
(25, 'entry', 'payment', 'free', 'front', 1);

DELETE FROM `#__sobipro_permissions`
WHERE `pid` = 5;
ALTER TABLE `#__sobipro_permissions` ADD UNIQUE `uniquePermission` (`subject`, `action`, `value`, `site`);
INSERT IGNORE INTO `#__sobipro_permissions` (`pid`, `subject`, `action`, `value`, `site`, `published`) VALUES
(NULL, 'section', 'search', '*', 'front', 1),
(NULL, 'entry', 'delete', 'own', 'front', 1),
(NULL, 'entry', 'delete', '*', 'front', 1);

CREATE TABLE IF NOT EXISTS `#__sobipro_permissions_groups` (
	`rid` INT(11) NOT NULL,
	`gid` INT(11) NOT NULL,
	PRIMARY KEY (`rid`, `gid`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_permissions_groups` (`rid`, `gid`) VALUES
(1, 0),
(2, 2),
(2, 29);

CREATE TABLE IF NOT EXISTS `#__sobipro_permissions_map` (
	`rid` INT(11) NOT NULL,
	`sid` INT(11) NOT NULL,
	`pid` INT(11) NOT NULL,
	PRIMARY KEY (`rid`, `sid`, `pid`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_permissions_map` (`rid`, `sid`, `pid`) VALUES
(1, 1, 4),
(1, 1, 7),
(1, 1, 10),
(1, 1, 16),
(1, 1, 26),
(2, 1, 16),
(2, 1, 17);

CREATE TABLE IF NOT EXISTS `#__sobipro_permissions_rules` (
	`rid`        INT(11)      NOT NULL AUTO_INCREMENT,
	`name`       VARCHAR(250) NOT NULL,
	`nid`        VARCHAR(50)  NOT NULL,
	`validSince` DATETIME     NOT NULL,
	`validUntil` DATETIME     NOT NULL,
	`note`       VARCHAR(250) NOT NULL,
	`state`      TINYINT(4)   NOT NULL,
	PRIMARY KEY (`rid`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 3;

INSERT IGNORE INTO `#__sobipro_permissions_rules` (`rid`, `name`, `nid`, `validSince`, `validUntil`, `note`, `state`) VALUES
(1, 'Visitor', 'visitor', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 1),
(2, 'Registered', 'registered', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 1);

CREATE TABLE IF NOT EXISTS `#__sobipro_plugins` (
	`pid`         VARCHAR(50) NOT NULL,
	`name`        VARCHAR(150) DEFAULT NULL,
	`version`     VARCHAR(50) NOT NULL,
	`description` TEXT,
	`author`      VARCHAR(150) DEFAULT NULL,
	`authorURL`   VARCHAR(250) DEFAULT NULL,
	`authorMail`  VARCHAR(150) DEFAULT NULL,
	`enabled`     TINYINT(1) DEFAULT NULL,
	`type`        VARCHAR(250) DEFAULT NULL,
	`depend`      TEXT        NOT NULL,
	UNIQUE KEY `pid` (`pid`, `type`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_plugins` (`pid`, `name`, `version`, `description`, `author`, `authorURL`, `authorMail`, `enabled`, `type`, `depend`) VALUES
('bank_transfer', 'Offline Payment', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'payment', ''),
('paypal', 'PayPal', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'payment', ''),
('chbxgroup', 'Check Box Group', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('email', 'Email', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('image', 'Image', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('inbox', 'Input Box', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('multiselect', 'Multiple Select List', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('radio', 'Radio Buttons', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('select', 'Single Select List', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('textarea', 'Text Area', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('url', 'URL', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', ''),
('category', 'Category', '1.1', NULL, 'Sigsiu.NET GmbH', 'http://www.sigsiu.net/', 'sobi@sigsiu.net', 1, 'field', '');

CREATE TABLE IF NOT EXISTS `#__sobipro_plugin_section` (
	`section`  INT(11)     NOT NULL DEFAULT '0',
	`pid`      VARCHAR(50) NOT NULL DEFAULT '',
	`type`     VARCHAR(50) NOT NULL,
	`enabled`  TINYINT(1) DEFAULT NULL,
	`position` INT(11) DEFAULT NULL,
	PRIMARY KEY (`section`, `pid`, `type`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_plugin_section` (`section`, `pid`, `type`, `enabled`, `position`) VALUES
(71, 'bank_transfer', 'payment', 1, 1),
(71, 'paypal', 'payment', 1, 2),
(1, 'bank_transfer', 'payment', 1, 0),
(1, 'paypal', 'payment', 1, 0);

CREATE TABLE IF NOT EXISTS `#__sobipro_plugin_task` (
	`pid`      VARCHAR(50) NOT NULL DEFAULT '',
	`onAction` VARCHAR(150) DEFAULT NULL,
	`type`     VARCHAR(50) NOT NULL,
	UNIQUE KEY `pid` (`pid`, `onAction`, `type`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_plugin_task` (`pid`, `onAction`, `type`) VALUES
('bank_transfer', 'adm_menu', 'payment'),
('bank_transfer', 'entry.payment', 'payment'),
('bank_transfer', 'entry.save', 'payment'),
('bank_transfer', 'entry.submit', 'payment'),
('paypal', 'adm_menu', 'payment'),
('paypal', 'entry.payment', 'payment'),
('paypal', 'entry.save', 'payment'),
('paypal', 'entry.submit', 'payment');

CREATE TABLE IF NOT EXISTS `#__sobipro_registry` (
	`section`     VARCHAR(150) NOT NULL,
	`key`         VARCHAR(150) NOT NULL,
	`value`       TEXT         NOT NULL,
	`params`      TEXT         NOT NULL,
	`description` TEXT         NOT NULL,
	`options`     TEXT         NOT NULL
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_registry` (`section`, `key`, `value`, `params`, `description`, `options`) VALUES
('fields_filter', 'website_full', 'Website with Protocol', 'L15odHRwKHMpPzpcL1wvW1x3XC4tXStcLnsxfVthLXpBLVpdezIsNX0oXC9bXlxzXSopPyQv', 'Please enter a valid URL address in the $field field', ''),
('fields_filter', 'website', 'Website w/o Protocol', 'L15bXHdcLi1dK1wuezF9W2EtekEtWl17Miw1fShcL1teXHNdKik/JC8=', 'Please enter a valid website address without the protocol in the $field field', ''),
('fields_filter', 'title', 'Valid Title', 'L15bXHdcZF0rW1x3XGRccyFAXCRcJVwmXCpcIlwnXC1cK19dKiQv', 'The data entered in the $field field contains not allowed characters', 'custom'),
('fields_filter', 'single_letter', 'Single Letter', 'L15bYS16QS1aXSQv', 'This $field field accept only one letter value', ''),
('fields_filter', 'phone', 'Telephone Number', 'L14oXCtcZHsxLDN9XHM/KT8oXHM/XChbXGRdXClccz8pP1tcZFwtXHNcLl0rJC8=', 'Please enter a valid telephone number into $field field.', ''),
('fields_filter', 'integer', 'Decimal Value', 'L15cZCskLw==', 'Please enter a numeric value in the $field field', ''),
('fields_filter', 'float', 'Float Value', 'L15cZCsoXC5cZCopPyQv', 'Please enter a float value like 9.9 or 12.34 into the  $field field', ''),
('fields_filter', 'alphanum', 'Alphanumeric String', 'L15bYS16QS1aMC05XSskLw==', 'In the $field field only alphabetic and numeric characters are allowed', ''),
('fields_filter', 'email', 'Email Address', 'L15bXHdcLi1dK0BbXHdcLi1dK1wuW2EtekEtWl17Miw1fSQv', 'Please enter an email address into the $field field', ''),
('fields_filter', 'alpha', 'Alphabetic String', 'L15bYS16QS1aXSskLw==', 'In this $field field only letters are allowed', ''),
('paypal', 'ppcc', 'EUR', '', '', ''),
('paypal', 'pprurl', '{cfg:live_site}/index.php?option=com_sobipro&sid={section.id}', '', '', ''),
('paypal', 'ppurl', 'https://www.paypal.com/cgi-bin/webscr', '', '', ''),
('paypal', 'ppemail', 'change@me.com', '', '', ''),
('rejections-templates', 'rejection-of-a-new-entry', 'Rejection of a new entry', 'YTo0OntzOjE3OiJ0cmlnZ2VyLnVucHVibGlzaCI7YjoxO3M6MTc6InRyaWdnZXIudW5hcHByb3ZlIjtiOjA7czo5OiJ1bnB1Ymxpc2giO2I6MTtzOjc6ImRpc2NhcmQiO2I6MDt9', '', ''),
('rejections-templates', 'rejection-of-changes', 'Rejection of changes', 'YTo0OntzOjE3OiJ0cmlnZ2VyLnVucHVibGlzaCI7YjowO3M6MTc6InRyaWdnZXIudW5hcHByb3ZlIjtiOjE7czo5OiJ1bnB1Ymxpc2giO2I6MDtzOjc6ImRpc2NhcmQiO2I6MTt9', '', '');


CREATE TABLE IF NOT EXISTS `#__sobipro_relations` (
	`id`         INT(11)     NOT NULL DEFAULT '0',
	`pid`        INT(11)     NOT NULL DEFAULT '0',
	`oType`      VARCHAR(50) NOT NULL,
	`position`   INT(11) DEFAULT NULL,
	`validSince` DATETIME DEFAULT NULL,
	`validUntil` DATETIME DEFAULT NULL,
	`copy`       TINYINT(1)  NOT NULL,
	PRIMARY KEY (`id`, `pid`),
	KEY `oType` (`oType`)
)
	DEFAULT CHARSET = utf8;

INSERT IGNORE INTO `#__sobipro_relations` (`id`, `pid`, `oType`, `position`, `validSince`, `validUntil`, `copy`) VALUES
(1, 0, 'section', 1, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(2, 1, 'category', 1, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(3, 1, 'category', 2, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(4, 1, 'category', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(5, 1, 'category', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(6, 1, 'category', 5, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(7, 1, 'category', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(8, 2, 'category', 1, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(9, 2, 'category', 2, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(10, 2, 'category', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(11, 2, 'category', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(12, 2, 'category', 5, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(13, 2, 'category', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(14, 3, 'category', 1, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(15, 3, 'category', 2, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(16, 3, 'category', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(17, 3, 'category', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(18, 4, 'category', 1, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(19, 4, 'category', 2, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(20, 4, 'category', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(21, 4, 'category', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(22, 5, 'category', 5, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(23, 5, 'category', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(24, 5, 'category', 7, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(25, 5, 'category', 8, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(26, 6, 'category', 9, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(27, 6, 'category', 10, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(28, 6, 'category', 11, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(29, 6, 'category', 12, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(30, 6, 'category', 13, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(31, 7, 'category', 2, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(32, 7, 'category', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(33, 7, 'category', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(34, 7, 'category', 5, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(35, 2, 'category', 7, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(36, 7, 'category', 1, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(37, 2, 'entry', 5, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(37, 10, 'entry', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(37, 11, 'entry', 5, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(37, 12, 'entry', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(37, 35, 'entry', 3, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(38, 2, 'entry', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(38, 8, 'entry', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(38, 9, 'entry', 4, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(38, 11, 'entry', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(39, 31, 'entry', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(39, 32, 'entry', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(39, 33, 'entry', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0),
(39, 7, 'entry', 6, '2013-01-02 00:00:00', '0000-00-00 00:00:00', 0);

CREATE TABLE IF NOT EXISTS `#__sobipro_search` (
	`ssid`           DOUBLE    NOT NULL,
	`lastActive`     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`searchCreated`  TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
	`requestData`    TEXT      NOT NULL,
	`uid`            INT(11)   NOT NULL,
	`browserData`    TEXT      NOT NULL,
	`entriesResults` TEXT      NOT NULL,
	`catsResults`    TEXT      NOT NULL,
	PRIMARY KEY (`ssid`)
)
	DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `#__sobipro_section` (
	`id`          INT(11) NOT NULL,
	`description` TEXT
)
	DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `#__sobipro_users_relation` (
	`uid`        INT(11) NOT NULL DEFAULT '0',
	`gid`        INT(11) NOT NULL DEFAULT '0',
	`validSince` DATETIME DEFAULT NULL,
	`validUntil` DATETIME DEFAULT NULL,
	PRIMARY KEY (`uid`, `gid`, `validSince`)
)
	CHARSET = utf8;

DROP TABLE IF EXISTS `#__sobipro_user_group`;
CREATE TABLE `#__sobipro_user_group` (
	`description` TEXT,
	`gid`         INT(11)      NOT NULL AUTO_INCREMENT,
	`enabled`     INT(11)      NOT NULL,
	`pid`         INT(11)      NOT NULL,
	`groupName`   VARCHAR(150) NOT NULL,
	PRIMARY KEY (`gid`)
)
	DEFAULT CHARSET = utf8
	AUTO_INCREMENT = 5000;

CREATE TABLE IF NOT EXISTS `#__sobipro_history` (
  `revision` varchar(150) NOT NULL,
  `changedAt` datetime NOT NULL,
  `uid` int(11) NOT NULL,
  `userName` varchar(150) NOT NULL,
  `userEmail` varchar(150) NOT NULL,
  `change` varchar(150) NOT NULL,
  `site` enum('site','adm') NOT NULL,
  `sid` int(11) NOT NULL,
  `changes` text NOT NULL,
  `params` text NOT NULL,
  `reason` text NOT NULL,
  `language` varchar(50) NOT NULL,
  PRIMARY KEY (`revision`)
) DEFAULT CHARSET=utf8;
