CREATE TABLE `!PREFIX!_pi_user_forum` (`id_user_forum` int(11) NOT NULL auto_increment,`id_user_forum_parent` int(11) NOT NULL,`idart` int(11) NOT NULL default '0',`idcat` int(11) NOT NULL default '0',`idlang` int(5) NOT NULL default '0',`userid` int(6) NOT NULL default '0',`email` varchar(100) NOT NULL default '',`realname` varchar(50) NOT NULL default '',`forum` mediumtext NOT NULL,`forum_quote` mediumtext NOT NULL,`idclient` int(11) NOT NULL,`like` int(11) NOT NULL,`dislike` int(11) NOT NULL,`editedat` datetime NOT NULL default '0000-00-00 00:00:00',`editedby` varchar(50) NOT NULL default '',`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',`online` tinyint(1) NOT NULL,`moderated` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY  (`id_user_forum`)) ENGINE=MyISAM  AUTO_INCREMENT=1;
INSERT INTO `!PREFIX!_plugins` VALUES (1, 1, 'Smarty Wrapper', 'Provides smarty template engine for CONTENIDO Backend and Frontend', 'Bilal Arslan, Andreas Dieter', 'four for business AG', 'info@4fb.de', 'http://www.4fb.de', '1.0.0', 'smarty', '82b117e94bb2cbcbce4e56b79a7d0c23', 1, '2013-02-14 15:10:51', 1);
INSERT INTO `!PREFIX!_plugins` VALUES (2, 1, 'Form Assistant', 'Generating forms in backend, includes data storage and mailing', 'Marcus Gnaß (4fb)', 'four for business AG', 'marcus.gnass@4fb.de', 'http://www.4fb.de', '1.0.0', 'form_assistant', '34E59F15-606A-81F4-1520-59E86230BE37', 2, '2013-02-20 13:24:33', 1);
INSERT INTO `!PREFIX!_plugins` VALUES (3, 1, 'User Forum', 'Administration of user forum entries (Article comments)', 'Claus Schunk (4fb)', 'four for business AG', 'claus.schunk@4fb.de', 'http://www.4fb.de', '1.0.0', 'user_forum', '34E59F15-606A-81F4-1520-59E86230BE38', 3, '2013-05-15 14:29:01', 1);

-- form assistant
CREATE TABLE `!PREFIX!_pifa_contact_de` (`id` int(10) unsigned NOT NULL auto_increment COMMENT 'primary key',`salutation` varchar(255) default NULL,`first_name` varchar(255) default NULL,`last_name` varchar(255) default NULL,`company` varchar(255) default NULL,`street` varchar(255) default NULL,`street_number` varchar(255) default NULL,`plz` varchar(255) default NULL,`city` varchar(255) default NULL,`phone` varchar(255) default NULL,`email` varchar(255) default NULL,`message` text,`privacy` varchar(255) default NULL,PRIMARY KEY  (`id`)) ENGINE=MyISAM  AUTO_INCREMENT=11 ;
CREATE TABLE `!PREFIX!_pifa_contact_en` (`id` int(10) unsigned NOT NULL auto_increment COMMENT 'primary key',`salutation` varchar(255) default NULL,`first_name` varchar(255) default NULL,`last_name` varchar(255) default NULL,`company` varchar(255) default NULL,`street` varchar(255) default NULL,`street_number` varchar(255) default NULL,`plz` varchar(255) default NULL,`city` varchar(255) default NULL,`phone` varchar(255) default NULL,`email` varchar(255) default NULL,`message` text,`privacy` varchar(255) default NULL,PRIMARY KEY  (`id`)) ENGINE=MyISAM  AUTO_INCREMENT=11 ;
CREATE TABLE `!PREFIX!_pifa_field` (`idfield` int(10) unsigned NOT NULL auto_increment COMMENT 'unique identifier for a ConForm field',`idform` int(10) unsigned NOT NULL default '0' COMMENT 'foreign key for the ConForm form',`field_rank` int(10) unsigned NOT NULL default '0' COMMENT 'rank of a field in a form',`field_type` int(10) unsigned NOT NULL default '0' COMMENT 'id which defines type of form field',`column_name` varchar(64) NOT NULL COMMENT 'name of data table column to store values',`label` varchar(1023) default NULL COMMENT 'label to be shown in frontend',`display_label` int(1) NOT NULL default '0' COMMENT '1 means that the label will be displayed',`default_value` varchar(1023) default NULL COMMENT 'default value to be shown for form field',`option_labels` varchar(1023) default NULL COMMENT 'CSV of option labels',`option_values` varchar(1023) default NULL COMMENT 'CSV of option values',`option_class` varchar(1023) default NULL COMMENT 'class implementing external datasource',`help_text` text COMMENT 'help text to be shown for form field',`obligatory` int(1) NOT NULL default '0' COMMENT '1 means that a value is obligatory',`rule` varchar(1023) default NULL COMMENT 'regular expression to validate value',`error_message` varchar(1023) default NULL COMMENT 'error message to be shown for an invalid value',`css_class` varchar(1023) default NULL COMMENT 'CSS classes to be used for field wrapper',PRIMARY KEY  (`idfield`)) ENGINE=MyISAM COMMENT='contains meta data of PIFA fields' AUTO_INCREMENT=1 ;
INSERT INTO `!PREFIX!_pifa_field` VALUES (4, 1, 1, 6, 'salutation', 'Anrede', 1, NULL, 'Bitte wählen,Frau,Herr', ',Mrs,Mr', NULL, NULL, 1, NULL, 'Bitte wählen Sie die Anrede aus', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (5, 1, 2, 1, 'first_name', 'Vorname', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie Ihren Vornamen ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (6, 1, 3, 1, 'last_name', 'Nachname', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie Ihren Nachnamen ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (7, 1, 4, 1, 'company', 'Firma', 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (8, 1, 5, 1, 'street', 'Straße', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie die Straße ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (9, 1, 6, 1, 'street_number', 'Hausnummer', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie die Hausnummer ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (10, 1, 7, 1, 'plz', 'Postleitzahl', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie die Postleitzahl ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (11, 1, 8, 1, 'city', 'Ort', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie den Ort ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (12, 1, 10, 1, 'phone', 'Telefon', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie die Telefonnummer ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (13, 1, 11, 1, 'email', 'E-Mail-Adresse', 1, NULL, NULL, NULL, NULL, NULL, 1, '/^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9.-]+.[a-zA-Z]+$/', 'Bitte geben Sie eine gültige E-Mail Adresse ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (14, 1, 9, 2, 'message', 'Ihre Nachricht', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Bitte geben Sie die Nachricht ein', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (16, 1, 13, 13, '', 'Absenden', 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'button_red');
INSERT INTO `!PREFIX!_pifa_field` VALUES (17, 1, 14, 14, '', 'Zurücksetzen', 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'button_grey');
INSERT INTO `!PREFIX!_pifa_field` VALUES (18, 1, 12, 5, 'privacy', 'Datenschutzerklärung', 1, NULL, 'Ich akzeptiere die Datenschutzerklärung', '1', NULL, NULL, 1, NULL, 'Bitte bestätigen Sie die Datenschutzerklärung', 'privacy');

INSERT INTO `!PREFIX!_pifa_field` VALUES (19, 2, 1, 6, 'salutation', 'Salutiation', 1, NULL, 'Please select,Mrs,Mr', ',Mrs,Mr', NULL, NULL, 1, NULL, 'Please select the salutation', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (20, 2, 2, 1, 'first_name', 'First name', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your first name', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (21, 2, 3, 1, 'last_name', 'Last name', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your last name', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (22, 2, 4, 1, 'company', 'Company', 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (23, 2, 5, 1, 'street', 'Street', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your street name', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (24, 2, 6, 1, 'street_number', 'Street number', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your street number', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (25, 2, 7, 1, 'plz', 'Zip', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your zip code', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (26, 2, 8, 1, 'city', 'City', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your City', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (27, 2, 10, 1, 'phone', 'Phone', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your phone number', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (28, 2, 11, 1, 'email', 'E-Mail', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your e-mail address', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (29, 2, 9, 2, 'message', 'Your message', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Please insert your message', NULL);
INSERT INTO `!PREFIX!_pifa_field` VALUES (30, 2, 13, 13, '', 'Send', 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'button_red');
INSERT INTO `!PREFIX!_pifa_field` VALUES (31, 2, 14, 14, '', 'Cancel', 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'button_grey');
INSERT INTO `!PREFIX!_pifa_field` VALUES (32, 2, 12, 5, 'privacy', 'Privacy', 1, NULL, 'I accept the privacy policy', '1', NULL, NULL, 1, NULL, 'Please accept the privacy policy', 'privacy');

CREATE TABLE `!PREFIX!_pifa_form` (`idform` int(10) unsigned NOT NULL auto_increment COMMENT 'unique identifier for a ConForm form',`idclient` int(10) unsigned NOT NULL default '0' COMMENT 'id of form client',`idlang` int(10) unsigned NOT NULL default '0' COMMENT 'id of form language',`name` varchar(1023) NOT NULL default 'new form' COMMENT 'human readable name of form',`data_table` varchar(64) NOT NULL default '!PREFIX!_pifo_data' COMMENT 'unique name of data table',`method` enum('get','post') NOT NULL default 'post' COMMENT 'method to be used for form submission', with_timestamp BOOLEAN NOT NULL DEFAULT '1' COMMENT 'if data table records have a timestamp', PRIMARY KEY (`idform`)) ENGINE=MyISAM COMMENT='contains meta data of PIFA forms' AUTO_INCREMENT=1 ;
INSERT INTO `!PREFIX!_pifa_form` VALUES (1, 1, 1, 'contact', '!PREFIX!_pifa_contact_de', 'post', 1);
INSERT INTO `!PREFIX!_pifa_form` VALUES (2, 1, 2, 'contact', '!PREFIX!_pifa_contact_en', 'post', 1);

-- INSERT INTO `!PREFIX!_area` (idarea, parent_id, name, relevant, online, menuless) VALUES (100001, '0', 'form', 1, 1, 0);
-- INSERT INTO `!PREFIX!_area` (idarea, parent_id, name, relevant, online, menuless) VALUES (100002, '100001', 'form_ajax', 1, 1, 0);
INSERT INTO `!PREFIX!_area` (`idarea`, `parent_id`, `name`, `relevant`, `online`, `menuless`) VALUES (10061, '0', 'form', 1, 1, 0);
INSERT INTO `!PREFIX!_area` (`idarea`, `parent_id`, `name`, `relevant`, `online`, `menuless`) VALUES (10062, 'form', 'form_fields', 1, 1, 0);
INSERT INTO `!PREFIX!_area` (`idarea`, `parent_id`, `name`, `relevant`, `online`, `menuless`) VALUES (10063, 'form', 'form_data', 1, 1, 0);
INSERT INTO `!PREFIX!_area` (`idarea`, `parent_id`, `name`, `relevant`, `online`, `menuless`) VALUES (10064, 'form', 'form_ajax', 1, 1, 0);
INSERT INTO `!PREFIX!_area` (`idarea`, `parent_id`, `name`, `relevant`, `online`, `menuless`) VALUES (10065, 'form', 'form_export', 1, 1, 0);
INSERT INTO `!PREFIX!_area` (`idarea`, `parent_id`, `name`, `relevant`, `online`, `menuless`) VALUES (10066, 'form', 'form_import', 1, 1, 0);

-- INSERT INTO `!PREFIX!_nav_sub` (idnavs, idnavm, idarea, level, location, online) VALUES (100001, 3, 100001, 0, 'form_assistant/xml/lang_de_DE.xml;plugins/form_assistant/label', 1);
INSERT INTO `!PREFIX!_nav_sub` (`idnavs`, `idnavm`, `idarea`, `level`, `location`, `online`) VALUES (10045, 3, 10061, 0, 'form_assistant/xml/lang_de_DE.xml;plugins/form_assistant/label', 1);

-- INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100001, 100001, 'form_assistant/includes/include.left_top.php', 'main');
-- INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100002, 100001, 'form_assistant/includes/include.left_bottom.php', 'main');
-- INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100003, 100001, 'form_assistant/includes/include.right_top.php', 'main');
-- INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100004, 100001, 'form_assistant/includes/include.right_bottom.php', 'main');
-- INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100005, 100002, 'form_assistant/includes/include.ajax.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10094, 10061, 'form_assistant/includes/include.left_top.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10095, 10061, 'form_assistant/includes/include.left_bottom.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10096, 10061, 'form_assistant/includes/include.right_top.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10097, 10061, 'form_assistant/includes/include.right_bottom.form.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10098, 10062, 'form_assistant/includes/include.right_bottom.form_fields.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10099, 10063, 'form_assistant/includes/include.right_bottom.form_data.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10100, 10064, 'form_assistant/includes/include.right_bottom.form_ajax.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10101, 10065, 'form_assistant/includes/include.right_bottom.form_export.php', 'main');
INSERT INTO `!PREFIX!_files` (`idfile`, `idarea`, `filename`, `filetype`) VALUES (10102, 10066, 'form_assistant/includes/include.right_bottom.form_import.php', 'main');


-- INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100001, 100001, 1, 100001);
-- INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100002, 100001, 2, 100002);
-- INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100003, 100001, 3, 100003);
-- INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100004, 100001, 4, 100004);
-- INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100005, 100002, 4, 100005);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10094, 10061, 1, 10094);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10095, 10061, 2, 10095);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10096, 10061, 3, 10096);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10097, 10061, 4, 10097);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10098, 10062, 4, 10098);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10099, 10063, 4, 10099);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10100, 10064, 4, 10100);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10101, 10065, 4, 10101);
INSERT INTO `!PREFIX!_frame_files` (`idframefile`, `idarea`, `idframe`, `idfile`) VALUES (10102, 10066, 4, 10102);

INSERT INTO `!PREFIX!_type` (idtype, `type`, code, description, status, author, created, lastmodified) VALUES ('100001', 'CMS_PIFAFORM', '', 'PIFA form', '0', '', NOW(), NOW());

INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10103, 10061, '', 'pifa_show_form', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10104, 10061, '', 'pifa_store_form', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10105, 10061, '', 'pifa_delete_form', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10106, 10062, '', 'pifa_show_fields', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10107, 10063, '', 'pifa_show_data', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10108, 10064, '', 'pifa_get_field_form', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10109, 10064, '', 'pifa_post_field_form', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10110, 10064, '', 'pifa_reorder_fields', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10111, 10064, '', 'pifa_export_data', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10112, 10064, '', 'pifa_get_file', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10113, 10064, '', 'pifa_delete_field', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10114, 10064, '', 'pifa_get_option_row', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10115, 10066, '', 'pifa_import_form', '', '', 1);
INSERT INTO `!PREFIX!_actions` (`idaction`, `idarea`, `alt_name`, `name`, `code`, `location`, `relevant`) VALUES (10116, 10064, '', 'pifa_export_form', '', '', 1);

INSERT INTO `!PREFIX!_plugins_rel` VALUES(1, 10061, 2, 'area');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(2, 10062, 2, 'area');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(3, 10063, 2, 'area');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(4, 10064, 2, 'area');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(5, 10045, 2, 'navs');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(6, 100001, 2, 'ctype');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(7, 10103, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(8, 10104, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(9, 10105, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(10, 10106, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(11, 10107, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(12, 10108, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(13, 10109, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(14, 10110, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(15, 10111, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(16, 10112, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(17, 10113, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(18, 10114, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(19, 10115, 2, 'action');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(20, 10116, 2, 'action');


-- user forum
INSERT INTO `!PREFIX!_area` (idarea, parent_id, name, relevant, online, menuless) VALUES (100003, '0', 'user_forum', 1, 1, 0);
INSERT INTO `!PREFIX!_nav_sub` (idnavs, idnavm, idarea, level, location, online) VALUES (100002, 3, 100003, 0, 'user_forum/xml/lang_de_DE.xml;plugins/user_forum/label', 1);
INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100006, 100003, 'user_forum/includes/include.left_bottom.php', 'main');
INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100007, 100003, 'user_forum/includes/include.right_bottom.php', 'main');
INSERT INTO `!PREFIX!_files` (idfile, idarea, filename, filetype) VALUES (100008, 100003, 'user_forum/includes/include.left_top.php', 'main');
INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100006, 100003, 2, 100006);
INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100007, 100003, 4, 100007);
INSERT INTO `!PREFIX!_frame_files` (idframefile, idarea, idframe, idfile) VALUES (100008, 100003, 1, 100008);
INSERT INTO `!PREFIX!_type` (idtype, `type`, code, description, status, author, created, lastmodified) VALUES ('100002', 'CMS_USERFORUM', '', 'User forum', '0', '', NOW(), NOW());
INSERT INTO `!PREFIX!_plugins_rel` VALUES(21, 100003, 3, 'area');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(22, 100002, 3, 'navs');
INSERT INTO `!PREFIX!_plugins_rel` VALUES(23, 100002, 3, 'ctype');

-- Facebook SDK
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(24, 'fb-sdk', 'app-id', NULL);
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(25, 'fb-sdk', 'idart-channel', '87');
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(26, 'fb-sdk', 'kid-directed-site', 'false');
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(27, 'fb-sdk', 'locale', 'de_DE');
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(28, 'fb-sdk', 'status', 'false');
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(29, 'fb-sdk', 'template', 'jQuery');
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(30, 'fb-sdk', 'xfbml', 'true');
INSERT INTO `!PREFIX!_system_prop` (`idsystemprop`, `type`, `name`, `value`) VALUES(31, 'fb-sdk', 'html5', 'false');
