Home . Extensions . Repository
Sponsors
Extension Repository
The official extension repository only consists of freely available extensions. New documentation is rendered once a day.
Partner Management
-
- Icon
- Title
- Partner Management
- Extension key
- ( partner )
- State
- beta, Not reviewed!
- Extension Details
-
- Author
- David Bruehlmeier
- Category
- be
- Version
- 0.5.21
- Manual
- Read online
- Downloads (total / this version)
- 5536 / 394
- Rating
- none
-
- Updated
- 25.05.2009
- Upload comment
- * Fixed issue when using extension FPDF > 0.2.0 * Fixed issue #3280
-
- Description
- This extension includes everything you need to manage partners (persons and organisations). You can save everything from addresses to occupations, from legal forms to birth dates. Unlimited contact information records (e.g. phone numbers) can be managed f
- Extension Details
-
- Dependencies
-
- depends on php 3.0.0-0.0.0
- depends on typo3 3.8.1-0.0.0
- depends on static_info_tables
- Reverse dependencies
The following extension versions depend on this extension:
-
- Version history
- 0.5.20: Migrated the locallang*.php files to xml files. Thanks to Fabien Udriot for his contribution!
- 0.5.19: Minor code-level improvements (no new features)
- 0.5.18: Bugfix in birthday list.
- 0.5.17: Bugfix (telephone extension '0' was not displayed)
- 0.5.16: Added support for mm-fields in reports
-
- Download extension
-
Preview for file partner-0.5.21-doc__partner_demo_data__sql:Filename Size View Date Download class.ext_update.php 6.2 K View 01.04.2009 Download constants.txt 1.6 K View 01.04.2009 Download ext_conf_template.txt 1.4 K View 01.04.2009 Download ext_icon.gif 0.9 K View 01.04.2009 Download ext_localconf.php 5.5 K View 20.04.2009 Download ext_php_api.dat 48 K 01.04.2009 Download ext_tables.php 14.0 K View 20.04.2009 Download ext_tables.sql 12.2 K View 01.04.2009 Download flexform_ds.xml 18.4 K View 20.04.2009 Download locallang_db.xml 63 K View 20.04.2009 Download tca.php 54 K View 20.04.2009 Download api/class.tx_partner_contact_info.php 3.6 K View 01.04.2009 Download api/class.tx_partner_div.php 42 K View 19.05.2009 Download api/class.tx_partner_lang.php 2.9 K View 20.04.2009 Download api/class.tx_partner_main.php 6.8 K View 01.04.2009 Download api/class.tx_partner_query.php 36 K View 01.04.2009 Download api/class.tx_partner_relationship.php 10.9 K View 01.04.2009 Download cli/conf.php 182 View 01.04.2009 Download cli/create_report.php 3.1 K View 01.04.2009 Download csh/locallang_csh_MOD_partner.xml 6.8 K View 20.04.2009 Download csh/locallang_csh_tx_partner_contact_info.xml 5.1 K View 20.04.2009 Download csh/locallang_csh_tx_partner_main.xml 30 K View 20.04.2009 Download csh/locallang_csh_tx_partner_relationships.xml 4.9 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_contact_permissions.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_courses.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_hobbies.xml 9.2 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_legal_forms.xml 9.9 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_marital_status.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_occupations.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_org_types.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_rel_types.xml 12.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_religions.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_status.xml 10.0 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_titles.xml 10.5 K View 20.04.2009 Download csh/img/field_visibility_default_settings.png 6.2 K View 01.04.2009 Download doc/TODO.txt 9.6 K View 01.04.2009 Download doc/TODO_new_ext.txt 1.1 K View 01.04.2009 Download doc/empty_partner_tables.sql 732 View 01.04.2009 Download doc/manual.sxw 191 K 25.05.2009 Download doc/partner_demo_data.sql 40 K View 01.04.2009 Download icons/icon_tx_partner_contact_info.gif 887 View 01.04.2009 Download icons/icon_tx_partner_contact_info_email.gif 877 View 01.04.2009 Download icons/icon_tx_partner_contact_info_fax.gif 893 View 01.04.2009 Download icons/icon_tx_partner_contact_info_mobile.gif 884 View 01.04.2009 Download icons/icon_tx_partner_contact_info_phone.gif 887 View 01.04.2009 Download icons/icon_tx_partner_contact_info_url.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_main.gif 864 View 01.04.2009 Download icons/icon_tx_partner_main_organisation.gif 145 View 01.04.2009 Download icons/icon_tx_partner_main_person.gif 164 View 01.04.2009 Download icons/icon_tx_partner_relationships.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_contact_permissions.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_courses.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_hobbies.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_legal_forms.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_marital_status.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_occupations.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_org_types.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_rel_types.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_religions.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_status.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_titles.gif 0.9 K View 01.04.2009 Download icons/icon_web_txpartnerM1.gif 880 View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_0.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_1.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_2.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_3.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_4.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_default.gif 878 View 01.04.2009 Download icons/selicon_tx_partner_main_type_0.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_main_type_1.gif 0.9 K View 01.04.2009 Download inc/class.tx_partner_download_report.php 10.8 K View 20.04.2009 Download inc/class.tx_partner_format.php 39 K View 20.05.2009 Download inc/class.tx_partner_select.php 4.8 K View 20.04.2009 Download inc/class.tx_partner_tce_user.php 27 K View 20.04.2009 Download inc/class.tx_partner_tcemainprocdm.php 12.7 K View 01.04.2009 Download inc/class.tx_partner_user_fields.php 3.7 K View 01.04.2009 Download inc/class.ux_sc_mod_tools_em_index.php 1.2 K View 01.04.2009 Download inc/class.ux_t3lib_tcemain.php 10.5 K View 01.04.2009 Download mod1/clear.gif 46 View 01.04.2009 Download mod1/conf.php 1.4 K View 20.04.2009 Download mod1/index.php 9.0 K View 20.04.2009 Download modfunc1/class.tx_partner_reports.php 7.2 K View 20.04.2009 Download modfunc1/class.tx_partner_reports_birthdaylist.php 4.9 K View 20.04.2009 Download modfunc1/class.tx_partner_reports_email.php 7.9 K View 20.04.2009 Download modfunc1/class.tx_partner_reports_relationships.php 8.2 K View 19.05.2009 Download modfunc1/class.tx_partner_search.php 9.4 K View 20.04.2009 Download modfunc1/class.tx_partner_tools.php 3.3 K View 01.04.2009 Download modfunc1/class.tx_partner_tools_assignfeusers.php 13.6 K View 20.04.2009 Download modfunc1/class.tx_partner_tools_massrelationships.php 35 K View 20.04.2009 Download modfunc1/class.tx_partner_tools_reportdesigner.php 4.3 K View 20.04.2009 Download INSERT INTO `tx_partner_contact_info` VALUES (28,1,1118762346,1118762346,1,0,0,'32',0,0,1,'* Phone P: +41 031 494 20 20',41,'','031 494 20 20','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (29,1,1118762492,1118762373,1,0,0,'32',3,0,1,'* E-Mail P: peter.korbmeister@mails.ch',0,'','','','peter.korbmeister@mails.ch','','');
INSERT INTO `tx_partner_contact_info` VALUES (30,1,1118762446,1118762430,1,0,0,'32',3,0,0,'E-Mail P: peter.korbmeister@mybusiness.com',0,'','','','peter.korbmeister@mybusiness.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (31,1,1118762733,1118762733,1,0,0,'33',0,0,1,'* Phone P: +41 031 494 20 20',41,'','031 494 20 20','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (32,1,1118762762,1118762750,1,0,0,'33',3,0,1,'* E-Mail P: jessy@gmail.com',0,'','','','jessy@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (33,1,1118812962,1118812962,1,0,0,'36',0,0,1,'* Phone P: +41 026 449 29 19',41,'','026 449 29 19','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (34,1,1118813219,1118813207,1,0,0,'37',3,0,1,'* E-Mail P: ursli@gmail.com',0,'','','','ursli@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (35,1,1118813435,1118813420,1,0,0,'38',3,0,1,'* E-Mail P: soccerman@yahoo.com',0,'','','','soccerman@yahoo.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (36,1,1118813647,1118813632,1,0,0,'39',3,0,1,'* E-Mail P: mastertom@gmail.com',0,'','','','mastertom@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (37,1,1118813679,1118813679,1,0,0,'39',0,0,1,'* Phone P: +41 031 209 39 10',41,'','031 209 39 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (38,1,1118813713,1118813696,1,0,0,'39',1,0,1,'* Mobile Phone P: +41 079 302 77 50',41,'','079 302 77 50','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (39,1,1118814084,1118813960,1,0,0,'40',0,0,1,'* Phone P: +41 031 600 29 13',41,'','031 600 29 13','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (40,1,1118814013,1118814013,1,0,0,'40',0,1,0,'Phone B: +41 026 499 09 29',41,'','026 499 09 29','302','','','Use only for emgergencies');
INSERT INTO `tx_partner_contact_info` VALUES (41,1,1118814131,1118814107,1,0,0,'40',3,1,0,'E-Mail B: reto.rundumbacher@fn.ch',0,'','','','reto.rundumbacher@fn.ch','','');
INSERT INTO `tx_partner_contact_info` VALUES (42,1,1118814169,1118814151,1,0,0,'40',3,0,1,'* E-Mail P: rundi@rundi.ch',0,'','','','rundi@rundi.ch','','');
INSERT INTO `tx_partner_contact_info` VALUES (43,1,1118814628,1118814628,1,0,0,'41',0,0,1,'* Phone P: +41 031 499 20 10',41,'','031 499 20 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (44,1,1118814677,1118814660,1,0,0,'41',3,0,1,'* E-Mail P: abby@switzerland.org',0,'','','','abby@switzerland.org','','');
INSERT INTO `tx_partner_contact_info` VALUES (45,1,1118814800,1118814772,1,0,0,'42',3,0,1,'* E-Mail P: pchristen@soccer.com',0,'','','','pchristen@soccer.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (46,1,1118814920,1118814905,1,0,0,'43',3,0,1,'* E-Mail P: tomdry@soccer.com',0,'','','','tomdry@soccer.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (47,1,1119455067,1118815047,1,0,0,'44',3,0,1,'* E-Mail P: eggy@eggy.com',0,'','','','eggy@eggy.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (48,1,1118815190,1118815190,1,0,0,'45',0,0,1,'* Phone P: +41 031 299 39 10',41,'','031 299 39 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (49,1,1118815221,1118815206,1,0,0,'45',3,0,1,'* E-Mail P: andy.finn@gmail.com',0,'','','','andy.finn@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (50,1,1118847757,1118847757,1,0,0,'46',0,0,1,'* Phone P: +41 031 410 33 87',41,'','031 410 33 87','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (51,1,1118847796,1118847779,1,0,0,'46',3,0,1,'* E-Mail P: tobig@gmail.com',0,'','','','tobig@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (52,1,1118847926,1118847916,1,0,0,'47',3,0,1,'* E-Mail P: b.hauser@swissmail.ch',0,'','','','b.hauser@swissmail.ch','','');
INSERT INTO `tx_partner_contact_info` VALUES (53,1,1118848055,1118848043,1,0,0,'48',3,0,0,'E-Mail P: bitzi88@gmail.com',0,'','','','bitzi88@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (54,1,1118848083,1118848070,1,0,0,'48',4,0,1,'* URL P: www.bitzi.ch',0,'','','','','www.bitzi.ch','');
INSERT INTO `tx_partner_contact_info` VALUES (55,1,1118848161,1118848114,1,0,0,'48',3,0,1,'* E-Mail P: werni@bitzi.ch',0,'','','','werni@bitzi.ch','','');
INSERT INTO `tx_partner_contact_info` VALUES (56,1,1118848190,1118848190,1,0,0,'48',0,0,1,'* Phone P: +41 026 493 19 88',41,'','026 493 19 88','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (57,1,1118848432,1118848415,1,0,0,'49',3,0,1,'* E-Mail P: larsilein@switzerland.org',0,'','','','larsilein@switzerland.org','','');
INSERT INTO `tx_partner_contact_info` VALUES (58,1,1118848603,1118848590,1,0,0,'50',3,0,1,'* E-Mail P: n.langer@yahoo.com',0,'','','','n.langer@yahoo.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (59,1,1118848634,1118848622,1,0,0,'50',1,0,1,'* Mobile Phone P: +41 076 392 19 19',41,'','076 392 19 19','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (60,1,1118848815,1118848815,1,0,0,'51',0,0,1,'* Phone P: +41 031 299 38 10',41,'','031 299 38 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (61,1,1118848847,1118848833,1,0,0,'51',3,0,1,'* E-Mail P: tom.neuherr@gmail.com',0,'','','','tom.neuherr@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (62,1,1118849009,1118848998,1,0,0,'52',3,0,1,'* E-Mail P: paeduswiss@gmail.com',0,'','','','paeduswiss@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (63,1,1118849158,1118849145,1,0,0,'53',3,0,1,'* E-Mail P: plautzi@gmail.com',0,'','','','plautzi@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (64,1,1118849480,1118849480,1,0,0,'54',0,0,1,'* Phone P: +41 031 500 29 15',41,'','031 500 29 15','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (65,1,1118849509,1118849498,1,0,0,'54',3,0,1,'* E-Mail P: irmiv@gmail.com',0,'','','','irmiv@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (66,1,1118849840,1118849827,1,0,0,'56',3,0,1,'* E-Mail P: ruedi.tanner@yahoo.de',0,'','','','ruedi.tanner@yahoo.de','','');
INSERT INTO `tx_partner_contact_info` VALUES (67,1,1118849962,1118849945,1,0,0,'57',1,0,1,'* Mobile Phone P: +41 078 881 81 33',41,'','078 881 81 33','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (68,1,1118849992,1118849981,1,0,0,'57',3,0,1,'* E-Mail P: ulmi@gmail.com',0,'','','','ulmi@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (69,1,1118850149,1118850149,1,0,0,'58',0,0,1,'* Phone P: +41 031 420 94 81',41,'','031 420 94 81','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (70,1,1118850178,1118850169,1,0,0,'58',3,0,1,'* E-Mail P: pvock@switzerland.org',0,'','','','pvock@switzerland.org','','');
INSERT INTO `tx_partner_contact_info` VALUES (71,1,1118850294,1118850284,1,0,0,'59',3,0,1,'* E-Mail P: mwander@gmail.com',0,'','','','mwander@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (72,1,1118850465,1118850453,1,0,0,'60',3,0,1,'* E-Mail P: soccerstar@gmail.com',0,'','','','soccerstar@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (73,1,1118850669,1118850654,1,0,0,'61',3,0,1,'* E-Mail P: yasomiwa@gmail.com',0,'','','','yasomiwa@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (74,1,1118850698,1118850698,1,0,0,'61',0,0,1,'* Phone P: +41 032 310 00 76',41,'','032 310 00 76','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (75,1,1118850847,1118850835,1,0,0,'62',3,0,1,'* E-Mail P: conny.zurkinden@gmail.com',0,'','','','conny.zurkinden@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (76,1,1118850879,1118850879,1,0,0,'62',0,0,1,'* Phone P: +41 032 892 19 12',41,'','032 892 19 12','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (77,1,1118850909,1118850896,1,0,0,'62',1,0,1,'* Mobile Phone P: +41 079 599 29 19',41,'','079 599 29 19','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (78,1,1118851072,1118851059,1,0,0,'63',3,0,0,'E-Mail P: markus.abby@gmail.com',0,'','','','markus.abby@gmail.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (79,1,1118851815,1118851815,1,0,0,'63',0,0,0,'Phone P: 031 499 20 10',0,'','031 499 20 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (80,1,1118851848,1118851848,1,0,0,'63',0,1,1,'* Phone B: +41 044 291 19 33',41,'','044 291 19 33','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (81,1,1118851884,1118851871,1,0,0,'63',3,1,1,'* E-Mail B: markus.abderhalden@ubs.com',0,'','','','markus.abderhalden@ubs.com','','');
INSERT INTO `tx_partner_contact_info` VALUES (82,1,1118852078,1118852078,1,0,0,'64',0,0,1,'* Phone P: +41 031 499 20 10',41,'','031 499 20 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (83,1,1118852114,1118852101,1,0,0,'64',3,0,1,'* E-Mail P: eva.abderhalden@switzerland.org',0,'','','','eva.abderhalden@switzerland.org','','');
INSERT INTO `tx_partner_contact_info` VALUES (84,1,1119417005,1119367998,1,0,0,'69',0,0,1,'* Phone P: +41 026 411 00 29',41,'','026 411 00 29','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (85,1,1119454935,1119454783,1,0,0,'44',1,0,1,'* Mobile Phone P: +41 079 529 10 10',41,'','079 529 10 10','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (86,1,1119455050,1119454950,1,0,0,'44',4,0,1,'* URL P: http://www.eggy.com',0,'','','','','http://www.eggy.com','');
INSERT INTO `tx_partner_contact_info` VALUES (87,1,1119455106,1119455087,1,0,0,'44',0,0,1,'* Phone P: +41 031 411 39 22',41,'','031 411 39 22','','','','');
INSERT INTO `tx_partner_contact_info` VALUES (88,1,1120022711,1120022695,2,0,0,'41',1,0,1,'* Mobile Phone P: +41 079 772 30 44',41,'','079 772 30 44','','','','');
INSERT INTO `tx_partner_main` VALUES (32,1,1119023305,1118762100,1,0,0,'0','Korbmeister, Peter - Bern',3,'','',0,'18','','',3,'','Peter','','','Korbmeister','','','','',0,0,'','','','','Grossbrunnenweg 7','','3000','Bern','',41,'',0,'','','',0,0,0,0,'',0,'',1,3,41,0,43,0,978303600,0,2,3,0,0,0,0,'<phparray>\n\t<tx_partner_main-birth_date type=\"array\">\n\t\t<value>RESTRICTED</value>\n\t\t<table>tx_partner_main</table>\n\t\t<field>birth_date</field>\n\t\t<default type=\"boolean\"></default>\n\t</tx_partner_main-birth_date>\n</phparray>','');
INSERT INTO `tx_partner_main` VALUES (33,1,1118762859,1118762182,1,0,0,'0','Korbmeister-Meier, Jessica - Bern',4,'','',0,'','','',2,'','Jessica','','','Korbmeister-Meier','','','','',0,0,'','','','','Grossbrunnenweg 7','','3000','Bern','',41,'',0,'','','',0,0,0,19771203,'',0,'',1,3,41,0,43,0,1080943200,0,0,0,0,0,0,0,'','Agreed to the new bylaws on 2007-02-18.');
INSERT INTO `tx_partner_main` VALUES (34,1,1118762906,1118762249,1,0,0,'0','Korbmeister, Gustav - Bern',4,'','',0,'','','',3,'','Gustav','','','Korbmeister','','','','',0,0,'','','','','Grossbrunnenweg 7','','3000','Bern','',41,'',0,'','','',0,0,0,20021014,'',0,'',1,4,41,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (35,1,1118812670,1118812534,1,0,0,'0','Korbmeister, Paula - Bern',4,'','',0,'','','',1,'','Paula','','','Korbmeister','','','','',0,0,'','','','','Grossbrunnenweg 7','','3000','Bern','',41,'',0,'','','',0,0,0,20040505,'',0,'',2,4,41,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (36,1,1118812972,1118812833,1,0,0,'0','Korbmeister, Walter - Düdingen',3,'','',0,'','','',3,'','Walter','','','Korbmeister','','','','',0,0,'','','','','Gauenengasse 29','','3186','Düdingen','',41,'',0,'','','',0,0,0,19391017,'',0,'',1,1,41,0,0,0,426117600,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (37,1,1118813229,1118813191,1,0,0,'0','Beyeler, Urs - Bern',3,'','',0,'','','',3,'','Urs','','','Beyeler','','','','',0,0,'','','','','Bahnhofstrasse 13','','3000','Bern','',41,'',0,'','','',0,0,0,19831010,'',0,'',1,4,41,0,0,0,0,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (38,1,1118813475,1118813394,1,0,0,'0','Baumgartner, Bruno - Bern',3,'','',0,'','','',3,'','Bruno','','','Baumgartner','','','','',0,0,'','','','','Tronnstrasse 13','','3000','Bern','',41,'',0,'','','',0,0,0,19870405,'',0,'',1,4,41,0,0,0,1057269600,0,1,4,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (39,1,1118813738,1118813601,1,0,0,'0','Miller, Tom - Bern',3,'','',0,'','','',3,'','Tom','','','Miller','','','','',0,0,'','','','','Waldweg 33','','3000','Bern','',41,'',0,'','','',0,0,0,19870810,'',0,'',1,4,220,0,0,0,1115071200,0,2,2,1,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (40,1,1118814185,1118813878,1,0,0,'0','Rundumbacher, Reto - Bern',3,'','',0,'','','',3,'','Reto','','','Rundumbacher','','','','',0,0,'','','','','Aufderblattten 1','','3000','Bern','',41,'',0,'','','',0,0,0,19870401,'',0,'',1,4,41,0,0,0,981068400,0,2,0,1,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (41,1,1120022766,1118814589,1,0,0,'0','Abderhalden, Klaus - Bern',3,'','',0,'20','','',3,'','Klaus','','','Abderhalden','','','','',0,0,'','','','','Postgasse 1','','3000','Bern','',41,'',0,'','','',0,0,0,19860103,'',0,'',1,4,41,0,0,0,967932000,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (42,1,1118814817,1118814756,1,0,0,'0','Christen, Paul - Bern',3,'','',0,'','','',3,'','Paul','','','Christen','','','','',0,0,'','','','','Neuhofstrasse 1','','3000','Bern','',41,'',0,'','','',0,0,0,19870601,'',0,'',1,4,41,0,0,0,1081029600,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (43,1,1118814948,1118814887,1,0,0,'0','Dürrenmatt, Thomas - Bern',3,'','',0,'','','',3,'','Thomas','','','Dürrenmatt','','','','',0,0,'','','','','Bahnhofstrasse 143','','3000','Bern','',41,'',0,'','','',0,0,0,19881212,'',0,'',1,4,41,0,0,0,1106089200,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (44,1,1119455143,1118815025,1,0,0,'0','Egolfinger, Erich - Bern',3,'','',0,'19','','',3,'','Erich','','','Egolfinger','','','','',0,0,'','','','','Adlerstrasse 1','','3000','Bern','',41,'',0,'','','',0,0,0,19860101,'',0,'',1,4,41,0,0,0,946681200,0,2,0,1,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (45,1,1118815233,1118815163,1,0,0,'0','Finn, Andreas - Bern',3,'','',0,'','','',3,'','Andreas','','','Finn','','','','',0,0,'','','','','Meisenstrasse 1','','3000','Bern','',41,'',0,'','','',0,0,0,19881020,'',0,'',1,4,41,0,0,0,1042498800,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (46,1,1118847818,1118847724,1,0,0,'0','Grandjean, Tobias - Oberhausen',3,'','',0,'','','',3,'','Tobias','','','Grandjean','','','','',0,0,'','','','','Poststrasse 12','','3012','Oberhausen','',41,'',0,'','','',0,0,0,19871113,'',0,'',1,4,41,0,0,0,1115244000,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (47,1,1118847940,1118847900,1,0,0,'0','Hauser, Bruno - Düdingen',3,'','',0,'','','',3,'','Bruno','','','Hauser','','','','',0,0,'','','','','Bonnstrasse 33','','3186','Düdingen','',41,'',0,'','','',0,0,0,19870228,'',0,'',1,4,41,0,0,0,1042153200,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (48,1,1118848318,1118848019,1,0,0,'0','Inderbitzin, Werner - Mariahilf',3,'','',0,'4','','',3,'','Werner','','','Inderbitzin','','','','',0,0,'','','','','Heimatli 1','','3186','Mariahilf','',41,'',0,'','','',0,0,0,19880320,'',0,'',1,4,41,0,0,0,938901600,0,1,4,1,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (49,1,1118848476,1118848399,1,0,0,'0','Jakobsen, Lars - Bern',3,'','',0,'5','','',3,'','Lars','','','Jakobsen','','','','',0,0,'','','','','Neuenfeld 33','','3000','Bern','',41,'',0,'','','',0,0,0,19881232,'',0,'',1,4,186,0,0,0,1046732400,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (50,1,1118848680,1118848572,1,0,0,'0','Langer, Norbert - Bern',3,'','',0,'6','','',3,'','Norbert','','','Langer','','','','',0,0,'','','','','Bahnhofstrasse 198','','3000','Bern','',41,'',0,'','','',0,0,0,19880603,'',0,'',0,0,41,0,0,0,1095458400,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (51,1,1118848860,1118848761,1,0,0,'0','Neuherr, Thomas - Bern',3,'','',0,'7','','',3,'','Thomas','','','Neuherr','','','','',0,0,'','','','','Oblattenstrasse 3','','3000','Bern','',41,'',0,'','','',0,0,0,19870722,'',0,'',1,0,41,0,0,0,1081029600,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (52,1,1118849023,1118848950,1,0,0,'0','Oberholzer, Patrick - Hinterkachelhofen',3,'','',0,'8','','',3,'','Patrick','','','Oberholzer','','','','',0,0,'','','','','Amselstrasse 1','','3019','Hinterkachelhofen','',41,'',0,'','','',0,0,0,19860901,'',0,'',1,4,41,0,0,0,1018216800,0,1,0,0,0,0,0,'','Agreed to the new bylaws on 2007-01-24.');
INSERT INTO `tx_partner_main` VALUES (53,1,1118849175,1118849089,1,0,0,'0','Plautz, Armin - Bern',3,'','',0,'9','','',3,'','Armin','','','Plautz','','','','',0,0,'','','','','Rundgasse 3','','3000','Bern','',41,'',0,'','','',0,0,0,19870210,'',0,'',1,0,41,0,0,0,1020463200,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (54,1,1118849605,1118849452,1,0,0,'0','Qurcici, Irmiv - Bern',3,'','',0,'10','','',3,'','Irmiv','','','Qurcici','','','','',0,0,'','','','','Alte Weggasse 3','','3000','Bern','',41,'',0,'','','',0,0,0,19880309,'',0,'',1,4,6,0,0,0,1104966000,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (55,1,1118849702,1118849702,1,0,0,'0','Sauber, Peter - Zürich',2,'','',0,'','','',3,'','Peter','','','Sauber','','','','',0,0,'','','','','Paradeplatz 1','','8000','Zürich','',41,'',0,'','','',0,0,0,0,'',0,'',9,0,41,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (56,1,1118849851,1118849808,1,0,0,'0','Tanner, Ruedi - Hinterbünzlikofen',3,'','',0,'','','',3,'','Ruedi','','','Tanner','','','','',0,0,'','','','','Tannholzstrasse 33','','3044','Hinterbünzlikofen','',41,'',0,'','','',0,0,0,19861209,'',0,'',1,4,41,0,0,0,1015110000,0,1,0,0,0,0,0,'','Agreed to the new bylaws on 2007-02-03.');
INSERT INTO `tx_partner_main` VALUES (57,1,1118850037,1118849926,1,0,0,'0','Ulmer, Erwin - Bern',3,'','',0,'11','','',3,'','Erwin','','','Ulmer','','','','',0,0,'','','','','Traumgasse 3','','3000','Bern','',41,'',0,'','','',0,0,0,19873010,'',0,'',1,4,41,0,0,0,1062626400,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (58,1,1118850189,1118850120,1,0,0,'0','Vock, Peter - Bern',3,'','',0,'','','',3,'','Peter','','','Vock','','','','',0,0,'','','','','Lauenenhalde 19','','3000','Bern','',41,'',0,'','','',0,0,0,19870404,'',0,'',1,4,41,0,0,0,1073516400,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (59,1,1118850344,1118850271,1,0,0,'0','Wander, Michael - Neuenegg',3,'','',0,'12','','',3,'','Michael','','','Wander','','','','',0,0,'','','','','Bahnhofstrasse 92','','3048','Neuenegg','',41,'',0,'','','',0,0,0,19870314,'',0,'',0,4,41,0,0,0,1031090400,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (60,1,1118850544,1118850434,1,0,0,'0','Xahiri, Ragidu - Bern-Bümpliz',3,'','',0,'13','','',3,'','Ragidu','','','Xahiri','','','','',0,0,'','','','','Mooseggstrasse 34','','3011','Bern-Bümpliz','',41,'',0,'','','',0,0,0,19861108,'',0,'',1,4,218,0,0,0,1113602400,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (61,1,1118850738,1118850629,1,0,0,'0','Yasomiwa, Mawabi - Bern',3,'','',0,'14','','',3,'','Mawabi','','','Yasomiwa','','','','',0,0,'','','','','Gurkenstrasse 7','','3000','Bern','',41,'',0,'','','',0,0,0,19870307,'',0,'',1,4,218,0,0,0,1105225200,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (62,1,1118850957,1118850821,1,0,0,'0','Zurkinden, Cornelius - Bern',3,'','',0,'15','','',3,'','Cornelius','','','Zurkinden','','','','',0,0,'','','','','Chlausenweg 3','','3000','Bern','',41,'',0,'','','',0,0,0,19870620,'',0,'',1,4,41,0,0,0,1019167200,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (63,1,1118851739,1118851041,1,0,0,'0','Abderhalden, Markus - Bern',3,'','',0,'16','','',3,'','Markus','','','Abderhalden','','','','',0,0,'','','','','Postgasse 1','','3000','Bern','',41,'',0,'','','',0,0,0,19571013,'',0,'',1,3,41,0,0,0,432684000,0,3,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (64,1,1118852285,1118852003,1,0,0,'0','Abderhalden, Eva - Bern',4,'','',0,'17','','',2,'','Eva','','','Abderhalden','','','','',0,0,'','','','','Postgasse 1','','3000','Bern','',41,'',0,'','','',0,0,0,19580301,'',0,'',1,3,41,0,0,0,0,0,1,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (65,1,1118900029,1118852603,1,0,0,'1','Youth Teams',3,'','',0,'','','',0,'','','','','','','','','Youth Teams',3,0,'','','','','','','','','',0,'',0,'','','',0,0,0,0,'',0,'',9,0,0,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (66,1,1118900302,1118852683,1,0,0,'1','Youth Team Blue',3,'','',0,'','','',0,'','','','','','','','','Youth Team Blue',3,0,'','','','','','','','','',0,'',0,'','','',0,0,0,0,'',0,'',9,0,0,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (67,1,1118852732,1118852718,1,0,0,'1','Youth Team Red',3,'','',0,'','','',0,'','','','','','','','','Youth Team Red',3,0,'','','','','','','','','',0,'',0,'','','',0,0,0,0,'',0,'',9,0,0,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (68,1,1118899873,1118852743,1,0,0,'1','Sporty Sporters - Bern',3,'','',0,'','','',0,'','','','','','','','','Sporty Sporters',2,0,'','','','','Neufeldstrasse 31','','3000','Bern','',41,'',0,'','','',0,0,0,0,'',0,'',9,0,0,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (69,1,1119417010,1119367830,1,0,0,'0','Neuenschwander, Robert - Düdingen',3,'','',0,'','','',3,'','Robert','','','Neuenschwander','','','','',0,0,'','','','','Neuenhofstrasse 110','','3186','Düdingen','',41,'',0,'','','',0,0,0,19560201,'',0,'',1,4,41,0,43,0,140824800,0,1,1,0,0,0,0,'','');
INSERT INTO `tx_partner_main` VALUES (70,1,1119417026,1119368363,1,1,0,'0','Test, Testing',3,'','',0,'','','',0,'','Testing','','','Test','','','','',0,0,'','','','','','','','','',0,'',0,'','','',0,0,0,0,'',0,'',9,0,0,0,0,0,0,0,0,0,0,0,0,0,'','');
INSERT INTO `tx_partner_main_courses_mm` VALUES (39,1,'',1);
INSERT INTO `tx_partner_main_courses_mm` VALUES (40,1,'',1);
INSERT INTO `tx_partner_main_courses_mm` VALUES (48,1,'',1);
INSERT INTO `tx_partner_main_courses_mm` VALUES (44,1,'',1);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (32,3,'',3);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (32,5,'',2);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (32,6,'',1);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (38,1,'',4);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (38,3,'',3);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (38,5,'',2);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (38,6,'',1);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (39,4,'',2);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (39,6,'',1);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (48,1,'',4);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (48,2,'',3);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (48,4,'',2);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (48,6,'',1);
INSERT INTO `tx_partner_main_hobbies_mm` VALUES (69,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (32,5,'',2);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (32,7,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (36,4,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (37,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (38,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (39,2,'',2);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (39,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (40,2,'',2);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (40,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (41,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (42,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (43,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (44,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (45,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (46,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (47,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (48,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (49,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (50,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (51,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (52,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (53,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (54,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (56,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (57,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (58,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (59,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (60,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (61,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (62,6,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (63,3,'',3);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (63,4,'',2);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (63,5,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (64,2,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (69,7,'',1);
INSERT INTO `tx_partner_main_occupations_mm` VALUES (44,2,'',2);
INSERT INTO `tx_partner_relationships` VALUES (3,1,1118762541,1118762541,1,0,0,4,32,33,3,899503200,0,'');
INSERT INTO `tx_partner_relationships` VALUES (4,1,1118762574,1118762574,1,0,0,3,32,34,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (5,1,1118762802,1118762802,1,0,0,3,33,34,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (6,1,1118812585,1118812585,1,0,0,3,33,35,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (7,1,1118812653,1118812614,1,0,0,3,32,35,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (8,1,1118812937,1118812870,1,0,0,3,36,32,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (9,1,1118851152,1118851152,1,0,0,3,63,41,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (10,1,1118852175,1118852150,1,0,0,3,64,41,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (11,1,1118852262,1118852262,1,0,0,4,41,64,3,431474400,0,'');
INSERT INTO `tx_partner_relationships` VALUES (12,1,1118852894,1118852866,1,1,0,5,68,66,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (13,1,1118852952,1118852918,1,0,0,5,68,65,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (14,1,1118899968,1118899945,1,0,0,5,65,66,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (15,1,1118900014,1118899985,1,0,0,5,65,67,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (16,1,1118900283,1118900283,1,0,0,5,66,46,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (17,1,1118900283,1118900283,1,0,0,5,66,49,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (18,1,1118900283,1118900283,1,0,0,5,66,43,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (19,1,1118900283,1118900283,1,0,0,5,66,45,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (20,1,1118900283,1118900283,1,0,0,5,66,50,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (21,1,1118900283,1118900283,1,0,0,5,66,48,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (22,1,1118900283,1118900283,1,0,0,5,66,54,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (23,1,1118900283,1118900283,1,0,0,5,66,57,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (24,1,1118900283,1118900283,1,0,0,5,66,39,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (25,1,1118900283,1118900283,1,0,0,5,66,51,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (26,1,1118900283,1118900283,1,0,0,5,66,62,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (27,1,1118900283,1118900283,1,0,0,5,66,42,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (28,1,1118900283,1118900283,1,0,0,5,67,38,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (29,1,1118900283,1118900283,1,0,0,5,67,58,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (30,1,1118900283,1118900283,1,0,0,5,67,40,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (31,1,1118900283,1118900283,1,0,0,5,67,59,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (32,1,1118900283,1118900283,1,0,0,5,67,61,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (33,1,1118900283,1118900283,1,0,0,5,67,47,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (34,1,1118900283,1118900283,1,0,0,5,67,53,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (35,1,1118900283,1118900283,1,0,0,5,67,56,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (36,1,1118900283,1118900283,1,0,0,5,67,60,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (37,1,1118900283,1118900283,1,0,0,5,67,52,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (38,1,1118900283,1118900283,1,0,0,5,67,41,3,0,0,'');
INSERT INTO `tx_partner_relationships` VALUES (39,1,1118900283,1118900283,1,0,0,5,67,44,3,0,0,'');
INSERT INTO `tx_partner_reports` VALUES (2,1,1119366508,1118936601,1,256,0,0,'All Partners from Bern','postal_code = \'3000\'','field_selection','0',1,0,0,'CSV,PDF','<?xml version="1.0\" encoding=\"iso-8859-1\" standalone=\"yes\" ?>\n<T3FlexForms>\n <data type=\"array\">\n <CSV type=\"array\">\n <lDEF type=\"array\">\n <delimiter type=\"array\">\n <vDEF>;</vDEF>\n </delimiter>\n <wrap type=\"array\">\n <vDEF>"</vDEF>\n </wrap>\n <line_end type=\"array\">\n <vDEF>1</vDEF>\n </line_end>\n <include_field_names type=\"array\">\n <vDEF>1</vDEF>\n </include_field_names>\n <include_table_names type=\"array\">\n <vDEF>1</vDEF>\n </include_table_names>\n </lDEF>\n </CSV>\n <PDF type=\"array\">\n <lDEF type=\"array\">\n <orientation type=\"array\">\n <vDEF>portrait</vDEF>\n </orientation>\n <unit type=\"array\">\n <vDEF>pt</vDEF>\n </unit>\n <format type=\"array\">\n <vDEF>A3</vDEF>\n </format>\n <margin_left type=\"array\">\n <vDEF type=\"boolean\"></vDEF>\n </margin_left>\n <margin_top type=\"array\">\n <vDEF type=\"boolean\"></vDEF>\n </margin_top>\n <margin_right type=\"array\">\n <vDEF type=\"boolean\"></vDEF>\n </margin_right>\n <font type=\"array\">\n <vDEF></vDEF>\n </font>\n <font_size type=\"array\">\n <vDEF>8</vDEF>\n </font_size>\n <fill_color type=\"array\">\n <vDEF>20</vDEF>\n </fill_color>\n <picture_position type=\"array\">\n <vDEF>top_left</vDEF>\n </picture_position>\n <picture_width type=\"array\">\n <vDEF type=\"boolean\"></vDEF>\n </picture_width>\n <picture_margin_top type=\"array\">\n <vDEF type=\"boolean\"></vDEF>\n </picture_margin_top>\n <template type=\"array\">\n <vDEF></vDEF>\n </template>\n </lDEF>\n </PDF>\n <BE_module type=\"array\">\n <lDEF type=\"array\">\n <editReport type=\"array\">\n <vDEF>1</vDEF>\n </editReport>\n <editPartner type=\"array\">\n <vDEF>1</vDEF>\n </editPartner>\n <mailLink type=\"array\">\n <vDEF>0</vDEF>\n </mailLink>\n </lDEF>\n </BE_module>\n </data>\n</T3FlexForms>','<phparray>\n\t<tx_partner_main type=\"array\">\n\t\t<label type=\"array\">\n\t\t\t<screen>1</screen>\n\t\t\t<length>50</length>\n\t\t</label>\n\t\t<first_name type=\"array\">\n\t\t\t<length>48</length>\n\t\t\t<file>1</file>\n\t\t</first_name>\n\t\t<last_name type=\"array\">\n\t\t\t<length>48</length>\n\t\t\t<file>1</file>\n\t\t</last_name>\n\t\t<street type=\"array\">\n\t\t\t<length>48</length>\n\t\t\t<file>1</file>\n\t\t</street>\n\t\t<postal_code type=\"array\">\n\t\t\t<length>12</length>\n\t\t\t<file>1</file>\n\t\t</postal_code>\n\t\t<locality type=\"array\">\n\t\t\t<length>48</length>\n\t\t\t<file>1</file>\n\t\t</locality>\n\t</tx_partner_main>\n</phparray>');
INSERT INTO `tx_partner_val_contact_permissions` VALUES (1,1,1117777409,1117777409,1,256,'Forbidden','Forbidden');
INSERT INTO `tx_partner_val_contact_permissions` VALUES (2,1,1117777409,1117777409,1,128,'Restricted','Restricted - Call Peter first');
INSERT INTO `tx_partner_val_contact_permissions` VALUES (3,1,1117777409,1117777409,1,64,'Unrestricted','Unrestricted');
INSERT INTO `tx_partner_val_courses` VALUES (1,1,1117777409,1117777409,1,256,'TYPO3-1/2005','Introduction to TYPO3','Introduction to TYPO3 for Editors',1104534000,1104793200);
INSERT INTO `tx_partner_val_courses` VALUES (2,1,1117777410,1117777410,1,128,'Goalie Two','Goalie for Advanced Players','- What is a Team?\r\n- What is a Referee?',1114725600,1114812000);
INSERT INTO `tx_partner_val_courses` VALUES (3,1,1117777410,1117777410,1,64,'Golie One','Golie Beginners Course','What is a ball?\r\nWhat is a goal?',1107385200,1108767600);
INSERT INTO `tx_partner_val_hobbies` VALUES (1,1,1117777409,1117777409,1,256,'Jogging','Jogging');
INSERT INTO `tx_partner_val_hobbies` VALUES (2,1,1117777409,1117777409,1,128,'Hiking','Hiking');
INSERT INTO `tx_partner_val_hobbies` VALUES (3,1,1117777409,1117777409,1,64,'Skiing','Skiing');
INSERT INTO `tx_partner_val_hobbies` VALUES (4,1,1117777409,1117777409,1,32,'Computers','Computers');
INSERT INTO `tx_partner_val_hobbies` VALUES (5,1,1117777409,1117777409,1,16,'Reading','Reading');
INSERT INTO `tx_partner_val_hobbies` VALUES (6,1,1117777409,1117777409,1,8,'Soccer','Soccer');
INSERT INTO `tx_partner_val_legal_forms` VALUES (1,1,1117777409,1117777409,1,256,'AG','Akt.ges.','Aktiengesellschaft');
INSERT INTO `tx_partner_val_legal_forms` VALUES (2,1,1117777409,1117777409,1,128,'Ltd','Limited','Limited');
INSERT INTO `tx_partner_val_marital_status` VALUES (1,1,1117777409,1117777409,1,256,'Widowed','Widowed');
INSERT INTO `tx_partner_val_marital_status` VALUES (2,1,1117777409,1117777409,1,128,'Divorced','Divorced');
INSERT INTO `tx_partner_val_marital_status` VALUES (3,1,1117777409,1117777409,1,64,'Married','Married');
INSERT INTO `tx_partner_val_marital_status` VALUES (4,1,1117777409,1117777409,1,32,'Single','Single');
INSERT INTO `tx_partner_val_occupations` VALUES (1,1,1117777409,1117777409,1,256,'Web-Admin','Website Administrator');
INSERT INTO `tx_partner_val_occupations` VALUES (2,1,1117777409,1117777409,1,128,'Web-Editor','Website Editor');
INSERT INTO `tx_partner_val_occupations` VALUES (3,1,1117777409,1117777409,1,64,'Translator','Translator');
INSERT INTO `tx_partner_val_occupations` VALUES (4,1,1117777409,1117777409,1,32,'Fundraiser','Fundraiser');
INSERT INTO `tx_partner_val_occupations` VALUES (5,1,1117777409,1117777409,1,16,'Teamleader','Teamleader');
INSERT INTO `tx_partner_val_occupations` VALUES (6,1,1117777409,1117777409,1,8,'Player','Player');
INSERT INTO `tx_partner_val_occupations` VALUES (7,1,1117777409,1117777409,1,4,'Coach','Coach');
INSERT INTO `tx_partner_val_org_types` VALUES (1,1,1117777409,1117777409,1,256,'Federation','Federation');
INSERT INTO `tx_partner_val_org_types` VALUES (2,1,1117777409,1117777409,1,128,'Club','Club');
INSERT INTO `tx_partner_val_org_types` VALUES (3,1,1117777409,1117777409,1,64,'Team','Team');
INSERT INTO `tx_partner_val_rel_types` VALUES (1,1,1117777410,1117777410,1,256,'Is Owner of','Is Owner of','1,3','Is Owner of','Is owned by');
INSERT INTO `tx_partner_val_rel_types` VALUES (3,1,1117777410,1117777410,1,64,'Has Child','Has Child','0','Has Child','Is Child of');
INSERT INTO `tx_partner_val_rel_types` VALUES (4,1,1117777410,1117777410,1,32,'Has Wife','Has Wife','0','Has Wife','Is Wife of');
INSERT INTO `tx_partner_val_rel_types` VALUES (5,1,1118852567,1118852567,1,16,'Has Member','Has Member','2,3','Has Member','Is Member of');
INSERT INTO `tx_partner_val_religions` VALUES (1,1,1117777409,1117777409,1,256,'Lutheran','Lutheran');
INSERT INTO `tx_partner_val_religions` VALUES (2,1,1117777409,1117777409,1,128,'Rom. Cath.','Roman Catholic');
INSERT INTO `tx_partner_val_status` VALUES (1,1,1117777409,1117777409,1,256,'Inactive','Inactive','tx_partner_relationships');
INSERT INTO `tx_partner_val_status` VALUES (2,1,1117777409,1117777409,1,128,'Hon. Member','Honorary Member','tx_partner_main');
INSERT INTO `tx_partner_val_status` VALUES (3,1,1118761966,1117777409,1,16,'Active','Active','tx_partner_main,tx_partner_relationships');
INSERT INTO `tx_partner_val_status` VALUES (4,1,1117777409,1117777409,1,32,'Supp. Member','Supporting Member','tx_partner_main');
INSERT INTO `tx_partner_val_titles` VALUES (1,1,1117777409,1117777409,1,256,'Miss','Miss','Dear Miss');
INSERT INTO `tx_partner_val_titles` VALUES (2,1,1117777409,1117777409,1,128,'Mrs.','Mrs.','Dear Mrs.');
INSERT INTO `tx_partner_val_titles` VALUES (3,1,1117777409,1117777409,1,64,'Mr.','Mister','Dear Mr.');
INSERT INTO `fe_groups` VALUES (1,1,1121147868,'Members',0,'',0,'','','');
INSERT INTO `fe_users` VALUES (4,1,1118848255,'bitzi','init','1',0,0,0,'Werner Inderbitzin','','','','werni@bitzi.ch',1118848255,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (5,1,1118848460,'larsilein','init','1',0,0,0,'Lars Jakobsen','','','','larsilein@switzerland.org',1118848460,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (6,1,1118848662,'nlanger','init','1',0,0,0,'Norbert Langer','','','','n.langer@yahoo.com',1118848662,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (7,1,1118848788,'thneuherr','init','1',0,0,0,'Thomas Neuherr','','','','tom.neuherr@gmail.com',1118848788,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (8,1,1118848974,'paedu','init','1',0,0,0,'Patrick Oberholzer','','','','paeduswiss@gmail.com',1118848974,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (9,1,1118849115,'armin','init','1',0,0,0,'Armin Plautz','','','','plautzi@gmail.com',1118849115,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (10,1,1118849589,'irmiv','init','1',0,0,0,'Irmiv Qurcici','','','','irmiv@gmail.com',1118849589,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (11,1,1118850019,'ulmi','init','1',0,0,0,'Erwin Ulmer','','','','ulmi@gmail.com',1118850019,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (12,1,1118850326,'mwander','init','1',0,0,0,'Michael Wander','','','','mwander@gmail.com',1118850326,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (13,1,1118850524,'soccerstar','init','1',0,0,0,'Ragidu Xahiri','','','','soccerstar@gmail.com',1118850499,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (14,1,1118850722,'yasomiwa','init','1',0,0,0,'Mawabi Yasomiwa','','','','yasomiwa@gmail.com',1118850722,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (15,1,1118850939,'czurkinden','init','1',0,0,0,'Cornelius Zurkinden','','','','conny.zurkinden@gmail.com',1118850939,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (16,1,1118851098,'mabby','init','1',0,0,0,'Markus Abderhalden','','','','markus.abderhalden@ubs.com',1118851098,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (17,1,1118852034,'eabderhalden','init','1',0,0,0,'Eva Abderhalden','','','','eva.abderhalden@switzerland.org',1118852034,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (18,1,1118938441,'pkorbmeister','init','1',0,0,0,'Peter Korbmeister','','','','peter.korbmeister@mails.ch',1118938441,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (19,1,1119454760,'egolfinger','init','1',0,0,0,'Erich Egolfinger','','','','eggy@eggy.com',1119454760,1,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `fe_users` VALUES (20,1,1120022738,'abby','init','1',0,0,0,'Klaus Abderhalden','','','','abby@switzerland.org',1120022738,2,'',0,'','','','','','','','','',0,0,0);
INSERT INTO `pages` VALUES (1,0,0,0,0,'',0,0,0,0,0,0,1172412334,256,0,1,0,31,27,0,0,1172412328,1,'Partner',254,'',0,0,0,0,'',0,0,0,1,0,0,0,'','',0,'','',0,'',0,0,'',0,0,'','',0,'','','',0,0,0,0,'',0,0);
