-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 23 Nov 2009 om 19:15
-- Server versie: 5.0.84
-- PHP Versie: 5.2.11-pl1-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `statutory_event`
--

--
-- Gegevens worden uitgevoerd voor tabel `CountryCodes`
--

INSERT INTO `CountryCodes` (`Code`, `Name`, `ISO_2`, `ISO_3`, `Postal`, `Continent`, `Fee`) VALUES
(16, 'AMERICAN SAMOA', 'AS', 'ASM', '', '', 'unknown'),
(20, 'ANDORRA', 'AD', 'AND', 'AND', 'EU', 'unknown'),
(24, 'ANGOLA', 'AO', 'AGO', '', 'AF', 'unknown'),
(660, 'ANGUILLA', 'AI', 'AIA', '', '', 'unknown'),
(10, 'ANTARCTICA', 'AQ', 'ATA', '', '', 'unknown'),
(28, 'ANTIGUA AND BARBUDA', 'AG', 'ATG', '', '', 'unknown'),
(32, 'ARGENTINA', 'AR', 'ARG', 'RA', 'SA', 'unknown'),
(51, 'ARMENIA', 'AM', 'ARM', 'ARM', 'EU', 'low'),
(533, 'ARUBA', 'AW', 'ABW', '', '', 'unknown'),
(36, 'AUSTRALIA', 'AU', 'AUS', 'AUS', 'AU', 'unknown'),
(40, 'AUSTRIA', 'AT', 'AUT', 'A', 'EU', 'high'),
(31, 'AZERBAIJAN', 'AZ', 'AZE', 'AZE', 'EU', 'low'),
(44, 'BAHAMAS', 'BS', 'BHS', 'BS', '', 'unknown'),
(48, 'BAHRAIN', 'BH', 'BHR', 'BRN', '', 'unknown'),
(50, 'BANGLADESH', 'BD', 'BGD', 'BD', 'AF', 'unknown'),
(52, 'BARBADOS', 'BB', 'BRB', 'BDS', '', 'unknown'),
(112, 'BELARUS', 'BY', 'BLR', 'BY', 'EU', 'low'),
(56, 'BELGIUM', 'BE', 'BEL', 'B', 'EU', 'high'),
(84, 'BELIZE', 'BZ', 'BLZ', 'BH', '', 'unknown'),
(204, 'BENIN', 'BJ', 'BEN', 'DY', '', 'unknown'),
(60, 'BERMUDA', 'BM', 'BMU', '', '', 'unknown'),
(64, 'BHUTAN', 'BT', 'BTN', '', '', 'unknown'),
(68, 'BOLIVIA', 'BO', 'BOL', 'BOL', '', 'unknown'),
(70, 'BOSNIA AND HERZEGOWINA', 'BA', 'BIH', 'BIH', 'EU', 'low'),
(72, 'BOTSWANA', 'BW', 'BWA', 'RB', 'AF', 'unknown'),
(74, 'BOUVET ISLAND', 'BV', 'BVT', '', '', 'unknown'),
(76, 'BRAZIL', 'BR', 'BRA', 'BR', 'SA', 'unknown'),
(86, 'BRITISH INDIAN OCEAN TERRITORY', 'IO', 'IOT', '', '', 'unknown'),
(96, 'BRUNEI DARUSSALAM', 'BN', 'BRN', 'BRU', '', 'unknown'),
(100, 'BULGARIA', 'BG', 'BGR', 'BG', 'EU', 'low'),
(854, 'BURKINA FASO', 'BF', 'BFA', '', '', 'unknown'),
(108, 'BURUNDI', 'BI', 'BDI', 'RU', 'AF', 'unknown'),
(116, 'CAMBODIA', 'KH', 'KHM', 'K', 'AS', 'unknown'),
(120, 'CAMEROON', 'CM', 'CMR', 'CAM', '', 'unknown'),
(124, 'CANADA', 'CA', 'CAN', 'CDN', 'NA', 'unknown'),
(132, 'CAPE VERDE', 'CV', 'CPV', '', '', 'unknown'),
(136, 'CAYMAN ISLANDS', 'KY', 'CYM', '', '', 'unknown'),
(140, 'CENTRAL AFRICAN REPUBLIC', 'CF', 'CAF', 'RCA', 'AF', 'unknown'),
(148, 'CHAD', 'TD', 'TCD', 'TD', '', 'unknown'),
(152, 'CHILE', 'CL', 'CHL', 'RCH', 'SA', 'unknown'),
(156, 'CHINA', 'CN', 'CHN', 'RC', 'AS', 'unknown'),
(162, 'CHRISTMAS ISLAND', 'CX', 'CXR', '', '', 'unknown'),
(166, 'COCOS KEELING ISLANDS', 'CC', 'CCK', '', '', 'unknown'),
(170, 'COLOMBIA', 'CO', 'COL', 'CO', 'SA', 'unknown'),
(174, 'COMOROS', 'KM', 'COM', '', '', 'unknown'),
(178, 'CONGO', 'CG', 'COG', '', 'AF', 'unknown'),
(180, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 'COD', 'RCB', 'AF', 'unknown'),
(184, 'COOK ISLANDS', 'CK', 'COK', '', '', 'unknown'),
(188, 'COSTA RICA', 'CR', 'CRI', 'CR', 'SA', 'unknown'),
(384, 'COTE D''IVOIRE', 'CI', 'CIV', 'CI', 'AF', 'unknown'),
(191, 'CROATIA', 'HR', 'HRV', 'HR', 'EU', 'low'),
(192, 'CUBA', 'CU', 'CUB', 'C', 'SA', 'unknown'),
(196, 'CYPRUS', 'CY', 'CYP', 'CY', 'EU', 'high'),
(203, 'CZECH REPUBLIC', 'CZ', 'CZE', 'CZ', 'EU', 'high'),
(208, 'DENMARK', 'DK', 'DNK', 'DK', 'EU', 'high'),
(262, 'DJIBOUTI', 'DJ', 'DJI', '', '', 'unknown'),
(212, 'DOMINICA', 'DM', 'DMA', 'WD', '', 'unknown'),
(214, 'DOMINICAN REPUBLIC', 'DO', 'DOM', 'DOM', '', 'unknown'),
(626, 'EAST TIMOR', 'TP', 'TMP', '', '', 'unknown'),
(218, 'ECUADOR', 'EC', 'ECU', 'EC', '', 'unknown'),
(818, 'EGYPT', 'EG', 'EGY', 'ET', 'AF', 'unknown'),
(222, 'EL SALVADOR', 'SV', 'SLV', 'ES', 'SA', 'unknown'),
(226, 'EQUATORIAL GUINEA', 'GQ', 'GNQ', '', '', 'unknown'),
(232, 'ERITREA', 'ER', 'ERI', '', 'AF', 'unknown'),
(233, 'ESTONIA', 'EE', 'EST', 'EE', 'EU', 'high'),
(231, 'ETHIOPIA', 'ET', 'ETH', 'ETH', 'AF', 'unknown'),
(238, 'FALKLAND ISLANDS', 'FK', 'FLK', '', '', 'unknown'),
(234, 'FAROE ISLANDS', 'FO', 'FRO', 'FR', '', 'unknown'),
(242, 'FIJI', 'FJ', 'FJI', 'FJI', '', 'unknown'),
(246, 'FINLAND', 'FI', 'FIN', 'FIN', 'EU', 'high'),
(250, 'FRANCE', 'FR', 'FRA', 'F', 'EU', 'high'),
(249, 'FRANCE METROPOLITAN', 'FX', 'FXX', '', '', 'unknown'),
(254, 'FRENCH GUIANA', 'GF', 'GUF', '', '', 'unknown'),
(258, 'FRENCH POLYNESIA', 'PF', 'PYF', '', '', 'unknown'),
(260, 'FRENCH SOUTHERN TERRITORIES', 'TF', 'ATF', '', '', 'unknown'),
(266, 'GABON', 'GA', 'GAB', 'GAB', '', 'unknown'),
(270, 'GAMBIA', 'GM', 'GMB', 'WAG', 'AF', 'unknown'),
(268, 'GEORGIA', 'GE', 'GEO', 'GEO', 'EU', 'low'),
(276, 'GERMANY', 'DE', 'DEU', 'D', 'EU', 'high'),
(288, 'GHANA', 'GH', 'GHA', 'GH', 'AF', 'unknown'),
(292, 'GIBRALTAR', 'GI', 'GIB', 'GBZ', '', 'unknown'),
(300, 'GREECE', 'GR', 'GRC', 'GR', 'EU', 'high'),
(304, 'GREENLAND', 'GL', 'GRL', '', '', 'unknown'),
(308, 'GRENADA', 'GD', 'GRD', 'WG', '', 'unknown'),
(312, 'GUADELOUPE', 'GP', 'GLP', '', '', 'unknown'),
(316, 'GUAM', 'GU', 'GUM', '', '', 'unknown'),
(320, 'GUATEMALA', 'GT', 'GTM', 'GCA', 'SA', 'unknown'),
(324, 'GUINEA', 'GN', 'GIN', 'RG', '', 'unknown'),
(624, 'GUINEA-BISSAU', 'GW', 'GNB', '', '', 'unknown'),
(328, 'GUYANA', 'GY', 'GUY', 'GUY', '', 'unknown'),
(332, 'HAITI', 'HT', 'HTI', 'RH', '', 'unknown'),
(334, 'HEARD AND MC DONALD ISLANDS', 'HM', 'HMD', '', '', 'unknown'),
(336, 'HOLY SEE VATICAN CITY STATE', 'VA', 'VAT', 'V', '', 'unknown'),
(340, 'HONDURAS', 'HN', 'HND', '', '', 'unknown'),
(344, 'HONG KONG', 'HK', 'HKG', 'HK', 'AS', 'unknown'),
(348, 'HUNGARY', 'HU', 'HUN', 'H', 'EU', 'high'),
(352, 'ICELAND', 'IS', 'ISL', 'IS', 'EU', 'high'),
(356, 'INDIA', 'IN', 'IND', 'IND', 'AS', 'unknown'),
(360, 'INDONESIA', 'ID', 'IDN', 'RI', 'AS', 'unknown'),
(364, 'IRAN ISLAMIC REPUBLIC OF', 'IR', 'IRN', 'IR', '', 'unknown'),
(368, 'IRAQ', 'IQ', 'IRQ', 'IRQ', '', 'unknown'),
(372, 'IRELAND', 'IE', 'IRL', 'IRL', 'EU', 'high'),
(376, 'ISRAEL', 'IL', 'ISR', 'IL', '', 'unknown'),
(380, 'ITALY', 'IT', 'ITA', 'I', 'EU', 'high'),
(388, 'JAMAICA', 'JM', 'JAM', 'JA', '', 'unknown'),
(392, 'JAPAN', 'JP', 'JPN', 'J', 'AS', 'unknown'),
(400, 'JORDAN', 'JO', 'JOR', 'HKJ', '', 'unknown'),
(398, 'KAZAKHSTAN', 'KZ', 'KAZ', 'KZ', 'EU', 'low'),
(404, 'KENYA', 'KE', 'KEN', 'EAK', 'AF', 'unknown'),
(296, 'KIRIBATI', 'KI', 'KIR', '', '', 'unknown'),
(408, 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'KP', 'PRK', '', 'AS', 'unknown'),
(410, 'KOREA, REPUBLIC OF', 'KR', 'KOR', 'ROK', 'AS', 'unknown'),
(414, 'KUWAIT', 'KW', 'KWT', 'KWT', '', 'unknown'),
(417, 'KYRGYZSTAN', 'KG', 'KGZ', 'KS', '', 'unknown'),
(418, 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'LA', 'LAO', 'LAO', '', 'unknown'),
(428, 'LATVIA', 'LV', 'LVA', 'LV', 'EU', 'high'),
(422, 'LEBANON', 'LB', 'LBN', 'RL', '', 'unknown'),
(426, 'LESOTHO', 'LS', 'LSO', 'LS', '', 'unknown'),
(430, 'LIBERIA', 'LR', 'LBR', 'LB', 'AF', 'unknown'),
(434, 'LIBYAN ARAB JAMAHIRIYA', 'LY', 'LBY', 'LAR', '', 'unknown'),
(438, 'LIECHTENSTEIN', 'LI', 'LIE', 'FL', 'EU', 'high'),
(440, 'LITHUANIA', 'LT', 'LTU', 'LTU', 'EU', 'high'),
(442, 'LUXEMBOURG', 'LU', 'LUX', 'L', 'EU', 'high'),
(446, 'MACAU', 'MO', 'MAC', '', '', 'unknown'),
(807, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'MK', 'MKD', 'MK', 'EU', 'low'),
(450, 'MADAGASCAR', 'MG', 'MDG', 'RM', '', 'unknown'),
(454, 'MALAWI', 'MW', 'MWI', 'MW', '', 'unknown'),
(458, 'MALAYSIA', 'MY', 'MYS', 'MAL', 'AS', 'unknown'),
(462, 'MALDIVES', 'MV', 'MDV', '', '', 'unknown'),
(466, 'MALI', 'ML', 'MLI', 'RMM', '', 'unknown'),
(470, 'MALTA', 'MT', 'MLT', 'M', 'EU', 'high'),
(584, 'MARSHALL ISLANDS', 'MH', 'MHL', '', '', 'unknown'),
(474, 'MARTINIQUE', 'MQ', 'MTQ', '', '', 'unknown'),
(478, 'MAURITANIA', 'MR', 'MRT', 'RIM', '', 'unknown'),
(480, 'MAURITIUS', 'MU', 'MUS', 'MS', '', 'unknown'),
(175, 'MAYOTTE', 'YT', 'MYT', '', '', 'unknown'),
(484, 'MEXICO', 'MX', 'MEX', 'MEX', 'SA', 'unknown'),
(583, 'MICRONESIA, FEDERATED STATES OF', 'FM', 'FSM', '', '', 'unknown'),
(498, 'MOLDOVA, REPUBLIC OF', 'MD', 'MDA', 'MD', 'EU', 'low'),
(492, 'MONACO', 'MC', 'MCO', 'MC', 'EU', 'unknown'),
(496, 'MONGOLIA', 'MN', 'MNG', '', '', 'unknown'),
(500, 'MONTSERRAT', 'MS', 'MSR', '', '', 'unknown'),
(504, 'MOROCCO', 'MA', 'MAR', 'MA', 'AF', 'unknown'),
(508, 'MOZAMBIQUE', 'MZ', 'MOZ', 'MOC', 'AF', 'unknown'),
(104, 'MYANMAR', 'MM', 'MMR', 'BUR', '', 'unknown'),
(516, 'NAMIBIA', 'NA', 'NAM', 'NAM', 'AF', 'unknown'),
(520, 'NAURU', 'NR', 'NRU', '', '', 'unknown'),
(524, 'NEPAL', 'NP', 'NPL', 'NEP', 'AS', 'unknown'),
(528, 'NETHERLANDS', 'NL', 'NLD', 'NL', 'EU', 'high'),
(530, 'NETHERLANDS ANTILLES', 'AN', 'ANT', 'NA', 'SA', 'unknown'),
(540, 'NEW CALEDONIA', 'NC', 'NCL', '', '', 'unknown'),
(554, 'NEW ZEALAND', 'NZ', 'NZL', 'NZ', 'AU', 'unknown'),
(558, 'NICARAGUA', 'NI', 'NIC', 'NIC', '', 'unknown'),
(562, 'NIGER', 'NE', 'NER', 'RN', 'AF', 'unknown'),
(566, 'NIGERIA', 'NG', 'NGA', 'WAN', 'AF', 'unknown'),
(570, 'NIUE', 'NU', 'NIU', '', '', 'unknown'),
(574, 'NORFOLK ISLAND', 'NF', 'NFK', '', '', 'unknown'),
(580, 'NORTHERN MARIANA ISLANDS', 'MP', 'MNP', '', '', 'unknown'),
(578, 'NORWAY', 'NO', 'NOR', 'N', 'EU', 'high'),
(512, 'OMAN', 'OM', 'OMN', '', '', 'unknown'),
(586, 'PAKISTAN', 'PK', 'PAK', 'PK', 'AS', 'unknown'),
(585, 'PALAU', 'PW', 'PLW', '', '', 'unknown'),
(591, 'PANAMA', 'PA', 'PAN', 'PA', '', 'unknown'),
(598, 'PAPUA NEW GUINEA', 'PG', 'PNG', 'PNG', '', 'unknown'),
(600, 'PARAGUAY', 'PY', 'PRY', 'PY', '', 'unknown'),
(604, 'PERU', 'PE', 'PER', 'PE', 'SA', 'unknown'),
(608, 'PHILIPPINES', 'PH', 'PHL', 'RP', '', 'unknown'),
(612, 'PITCAIRN', 'PN', 'PCN', '', '', 'unknown'),
(616, 'POLAND', 'PL', 'POL', 'PL', 'EU', 'high'),
(620, 'PORTUGAL', 'PT', 'PRT', 'P', 'EU', 'high'),
(630, 'PUERTO RICO', 'PR', 'PRI', '', 'SA', 'unknown'),
(634, 'QATAR', 'QA', 'QAT', 'QA', '', 'unknown'),
(638, 'REUNION', 'RE', 'REU', '', '', 'unknown'),
(642, 'ROMANIA', 'RO', 'ROM', 'RO', 'EU', 'high'),
(643, 'RUSSIAN FEDERATION', 'RU', 'RUS', 'RUS', 'EU', 'low'),
(646, 'RWANDA', 'RW', 'RWA', 'RWA', 'AF', 'unknown'),
(659, 'SAINT KITTS AND NEVIS', 'KN', 'KNA', '', '', 'unknown'),
(662, 'SAINT LUCIA', 'LC', 'LCA', '', '', 'unknown'),
(670, 'SAINT VINCENT AND THE GRENADINES', 'VC', 'VCT', '', '', 'unknown'),
(882, 'SAMOA', 'WS', 'WSM', 'WS', '', 'unknown'),
(674, 'SAN MARINO', 'SM', 'SMR', 'RSM', '', 'unknown'),
(678, 'SAO TOME AND PRINCIPE', 'ST', 'STP', '', '', 'unknown'),
(682, 'SAUDI ARABIA', 'SA', 'SAU', 'SA', '', 'unknown'),
(686, 'SENEGAL', 'SN', 'SEN', 'SN', '', 'unknown'),
(690, 'SEYCHELLES', 'SC', 'SYC', 'SY', '', 'unknown'),
(694, 'SIERRA LEONE', 'SL', 'SLE', 'WAL', 'AF', 'unknown'),
(702, 'SINGAPORE', 'SG', 'SGP', 'SGP', 'AS', 'unknown'),
(703, 'SLOVAKIA Slovak Republic', 'SK', 'SVK', 'SK', 'EU', 'low'),
(705, 'SLOVENIA', 'SI', 'SVN', 'SI', 'EU', 'high'),
(90, 'SOLOMON ISLANDS', 'SB', 'SLB', '', '', 'unknown'),
(706, 'SOMALIA', 'SO', 'SOM', 'SO', 'AF', 'unknown'),
(710, 'SOUTH AFRICA', 'ZA', 'ZAF', 'ZA', 'AF', 'unknown'),
(239, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 'SGS', '', '', 'unknown'),
(724, 'SPAIN', 'ES', 'ESP', 'E', 'EU', 'high'),
(144, 'SRI LANKA', 'LK', 'LKA', 'CL', 'AS', 'unknown'),
(654, 'ST. HELENA', 'SH', 'SHN', '', '', 'unknown'),
(666, 'ST. PIERRE AND MIQUELON', 'PM', 'SPM', '', '', 'unknown'),
(736, 'SUDAN', 'SD', 'SDN', 'SUD', 'AF', 'unknown'),
(740, 'SURINAME', 'SR', 'SUR', 'SME', 'SA', 'unknown'),
(744, 'SVALBARD AND JAN MAYEN ISLANDS', 'SJ', 'SJM', 'SD', '', 'unknown'),
(748, 'SWAZILAND', 'SZ', 'SWZ', '', '', 'unknown'),
(752, 'SWEDEN', 'SE', 'SWE', 'S', 'EU', 'high'),
(756, 'SWITZERLAND', 'CH', 'CHE', 'CH', 'EU', 'high'),
(760, 'SYRIAN ARAB REPUBLIC', 'SY', 'SYR', 'SYR', '', 'unknown'),
(158, 'TAIWAN PROVINCE OF CHINA', 'TW', 'TWN', 'RC', 'AS', 'unknown'),
(762, 'TAJIKISTAN', 'TJ', 'TJK', 'TJ', '', 'unknown'),
(834, 'TANZANIA UNITED REPUBLIC OF', 'TZ', 'TZA', 'EAT', 'AF', 'unknown'),
(764, 'THAILAND', 'TH', 'THA', 'T', 'AS', 'unknown'),
(768, 'TOGO', 'TG', 'TGO', 'TG', '', 'unknown'),
(772, 'TOKELAU', 'TK', 'TKL', '', '', 'unknown'),
(776, 'TONGA', 'TO', 'TON', '', '', 'unknown'),
(780, 'TRINIDAD AND TOBAGO', 'TT', 'TTO', 'TT', '', 'unknown'),
(788, 'TUNISIA', 'TN', 'TUN', 'TN', 'AF', 'unknown'),
(792, 'TURKEY', 'TR', 'TUR', 'TR', 'EU', 'low'),
(795, 'TURKMENISTAN', 'TM', 'TKM', 'TM', '', 'unknown'),
(796, 'TURKS AND CAICOS ISLANDS', 'TC', 'TCA', '', '', 'unknown'),
(798, 'TUVALU', 'TV', 'TUV', '', '', 'unknown'),
(800, 'UGANDA', 'UG', 'UGA', 'EAU', 'AF', 'unknown'),
(804, 'UKRAINE', 'UA', 'UKR', 'UA', 'EU', 'low'),
(784, 'UNITED ARAB EMIRATES', 'AE', 'ARE', 'UAE', '', 'unknown'),
(826, 'UNITED KINGDOM', 'GB', 'GBR', 'GB', 'EU', 'high'),
(840, 'UNITED STATES', 'US', 'USA', 'USA', 'NA', 'unknown'),
(581, 'UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 'UMI', '', '', 'unknown'),
(858, 'URUGUAY', 'UY', 'URY', 'ROU', '', 'unknown'),
(860, 'UZBEKISTAN', 'UZ', 'UZB', 'UZ', 'EU', 'low'),
(548, 'VANUATU', 'VU', 'VUT', '', '', 'unknown'),
(862, 'VENEZUELA', 'VE', 'VEN', 'YV', 'SA', 'unknown'),
(704, 'VIETNAM', 'VN', 'VNM', 'VN', 'AS', 'unknown'),
(92, 'VIRGIN ISLANDS BRITISH', 'VG', 'VGB', '', '', 'unknown'),
(850, 'VIRGIN ISLANDS U.S.', 'VI', 'VIR', 'BUI', '', 'unknown'),
(876, 'WALLIS AND FUTUNA ISLANDS', 'WF', 'WLF', '', '', 'unknown'),
(732, 'WESTERN SAHARA', 'EH', 'ESH', '', 'AF', 'unknown'),
(887, 'YEMEN', 'YE', 'YEM', 'YEM', '', 'unknown'),
(688, 'SERBIA', 'RS', 'SRB', 'SRB', 'EU', 'low'),
(894, 'ZAMBIA', 'ZM', 'ZMB', 'RNR', 'AF', 'unknown'),
(716, 'ZIMBABWE', 'ZW', 'ZWE', 'ZW', 'AF', 'unknown'),
(4, 'AFGHANISTAN', 'AF', 'AFG', 'AFG', 'AS', 'unknown'),
(8, 'ALBANIA', 'AL', 'ALB', 'AL', 'EU', 'low'),
(12, 'ALGERIA', 'DZ', 'DZA', 'DZ', 'AF', 'unknown'),
(0, '--- unknown ---', 'XX', 'XXX', 'XXX', '', 'unknown'),
(499, 'MONTENEGRO', 'ME', 'MNE', 'MNE', 'EU', 'low');

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `ISO_2`, `name`, `short`, `rate`) VALUES
(1, 'EU', 'Euro', '&euro;', 1.0000000000),
(2, 'BG', 'Lev (New) (BG)', 'BGN', 0.0000000000),
(3, 'CZ', 'Czech Koruna (CZ)', 'CZK', 0.0000000000),
(4, 'DK', 'Danish Krone (DK)', 'DKK', 0.0000000000),
(5, 'HU', 'Forint (HU)', 'HUF', 0.0000000000),
(6, 'PL', 'Zloty (PL)', 'PLN', 0.0000000000),
(7, 'RO', 'New Romanian Leu (RO)', 'RON', 0.0000000000),
(8, 'SE', 'Swedish Krona (SE)', 'SEK', 0.0000000000),
(9, 'GB', 'Pound Sterling (GB)', 'GBP', 0.0000000000),
(10, 'HR', 'Kuna (HR)', 'HRK', 0.0000000000),
(11, 'NO', 'Norwegian Krone (NO)', 'NOK', 0.0000000000),
(12, 'RU', 'New Rouble (RU)', 'RUB', 0.0000000000),
(13, 'CH', 'Swiss Franc (CH)', 'CHF', 0.0000000000),
(14, 'TR', 'Turkish Lira (new) (TR)', 'TRY', 0.0000000000),
(15, 'AL', 'Lek (AL)', 'ALL', 0.0000000000),
(16, 'AM', 'Dram (AM)', 'AMD', 0.0000000000),
(17, 'AZ', 'Azerbaijani Manat (AZ)', 'AZN', 0.0000000000),
(18, 'BY', 'Belarussian Rouble (BY)', 'BYR', 0.0000000000),
(19, 'BA', 'Bosnian Convertible Mark', 'BAM', 0.0000000000),
(20, 'GE', 'Lari (GE)', 'GEL', 0.0000000000),
(21, 'GI', 'Gibraltar pound (GI)', 'GIP', 0.0000000000),
(22, 'IS', 'Icelandic Króna (IS)', 'ISK', 0.0000000000),
(23, 'MK', 'Denar (MK)', 'MKD', 0.0000000000),
(24, 'MD', 'Moldovan Leu (MD)', 'MDL', 0.0000000000),
(25, 'RS', 'Serbian Dinar (RS)', 'RSD', 0.0000000000),
(26, 'UA', 'Hryvnia (UA)', 'UAH', 0.0000000000),
(27, 'US', 'US Dolar', '$', 0.0000000000);

--
-- Dumping data for table `functions`
--

INSERT INTO `functions` (`id`, `name`) VALUES
(1, 'body_view'),
(2, 'body_editplaces'),
(3, 'body_viewmemlist'),
(4, 'body_resetpassword'),
(5, 'body_acceptparticipant'),
(6, 'agoralist_view'),
(7, 'candidate_viewlist'),
(8, 'candidate_viewdetail'),
(9, 'candidate_edit'),
(10, 'candidate_approve'),
(11, 'candidate_viewpositions'),
(12, 'candidate_editpositions'),
(13, 'changelog_view'),
(15, 'application_viewlist'),
(14, 'help_view'),
(16, 'application_viewdetail'),
(17, 'application_edit'),
(18, 'application_accept'),
(19, 'application_confirm'),
(20, 'application_reject'),
(21, 'application_cancel'),
(22, 'application_register'),
(23, 'application_editonmemlist'),
(24, 'statistics_view'),
(25, 'application_editfee'),
(26, 'nummem_view'),
(27, 'application_new'),
(28, 'application_invite'),
(29, 'massmail_view'),
(30, 'massmail_sendaschair'),
(31, 'news_view'),
(32, 'news_edit'),
(33, 'log_view'),
(34, 'user_view'),
(35, 'user_edit'),
(36, 'workshop_view'),
(37, 'workshop_edit'),
(38, 'roles_view'),
(39, 'roles_edit'),
(40, 'application_editworkshop'),
(41, 'application_viewfee'),
(42, 'export_mailinglist'),
(43, 'setup_view'),
(44, 'application_viewworkshop'),
(45, 'application_viewvisa'),
(46, 'application_viewremarks'),
(47, 'application_viewgym'),
(48, 'application_editgym'),
(49, 'application_logadd'),
(50, 'massmail_sendaslocalorg'),
(51, 'applicationfield_personalview'),
(52, 'applicationfield_personaledit'),
(53, 'applicationfield_bodyview'),
(54, 'applicationfield_bodyedit'),
(55, 'applicationfield_visaview'),
(56, 'applicationfield_visaedit'),
(57, 'applicationfield_passportview'),
(58, 'applicationfield_passportedit'),
(59, 'applicationfield_participateview'),
(60, 'applicationfield_participateedit'),
(61, 'applicationfield_workshopview'),
(62, 'applicationfield_workshopedit'),
(63, 'applicationfield_addressview'),
(64, 'applicationfield_addressedit'),
(65, 'applicationfield_optionview'),
(66, 'applicationfield_optionedit'),
(67, 'applicationfield_remarksview'),
(68, 'applicationfield_remarksedit'),
(69, 'application_photoexport'),
(70, 'application_registerfull'),
(71, 'setup_audit'),
(72, 'setup_jc'),
(73, 'setup_registration'),
(74, 'setup_localorg'),
(75, 'setup_chair'),
(76, 'setup_admin'),
(77, 'application_viewonmemlist'),
(78, 'body_editmemlist'),
(79, 'applicationfield_commboardedit'),
(80, 'applicationfield_commboardview'),
(81, 'applicationfield_commnetcomedit'),
(82, 'applicationfield_commnetcomview'),
(83, 'application_setup_extra_q_view'),
(84, 'application_setup_extra_q_edit'),
(85, 'currencies_view'),
(86, 'currencies_edit'),
(87, 'export_fee'),
(88, 'export_voters'),
(89, 'export_openslides');

--
-- Dumping data for table `function_roles`
--

INSERT INTO `function_roles` (`role_id`, `function_id`) VALUES
(1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), (1, 7), (1, 8), (1, 9), (1, 10), (1, 11), (1, 12), (1, 13), (1, 14), (1, 15), (1, 16), (1, 17), (1, 18), (1, 19), (1, 20), (1, 21), (1, 22), (1, 23), (1, 24), (1, 25), (1, 26), (1, 27), (1, 28), (1, 29), (1, 30), (1, 31), (1, 32), (1, 33), (1, 34), (1, 35), (1, 36), (1, 37), (1, 38), (1, 39), (1, 40), (1, 41), (1, 43), (1, 44), (1, 45), (1, 46), (1, 47), (1, 48), (1, 49), (1, 50), (1, 51), (1, 52), (1, 53), (1, 54), (1, 55), (1, 56), (1, 57), (1, 58), (1, 59), (1, 60), (1, 61), (1, 62), (1, 63), (1, 64), (1, 65), (1, 66), (1, 67), (1, 68), (1, 69), (1, 70), (1, 76), (1, 77), (1, 78), (1, 79), (1, 80), (1, 81), (1, 82), (1, 83), (1, 84), (1, 85), (1, 86), (1, 87), (1, 88), (1, 89),
(2, 1), (2, 2), (2, 3), (2, 4), (2, 5), (2, 6), (2, 13), (2, 14), (2, 15), (2, 16), (2, 17), (2, 18), (2, 19), (2, 20), (2, 21), (2, 23), (2, 24), (2, 26), (2, 27), (2, 28), (2, 29), (2, 30), (2, 31), (2, 32), (2, 33), (2, 34), (2, 35), (2, 36), (2, 37), (2, 38), (2, 40), (2, 43), (2, 44), (2, 46), (2, 47), (2, 49), (2, 51), (2, 52), (2, 53), (2, 54), (2, 55), (2, 56), (2, 57), (2, 58), (2, 59), (2, 60), (2, 61), (2, 62), (2, 63), (2, 64), (2, 65), (2, 66), (2, 67), (2, 68), (2, 69), (2, 75), (2, 77), (2, 80), (2, 82), (2, 83), (2, 84), (2, 85), (2, 89),
(3, 1), (3, 13), (3, 14), (3, 15), (3, 16), (3, 17), (3, 19), (3, 21), (3, 22), (3, 24), (3, 25), (3, 29), (3, 33), (3, 34), (3, 36), (3, 38), (3, 41), (3, 43), (3, 44), (3, 45), (3, 46), (3, 47), (3, 48), (3, 49), (3, 50), (3, 51), (3, 52), (3, 53), (3, 54), (3, 55), (3, 56), (3, 57), (3, 58), (3, 59), (3, 60), (3, 61), (3, 62), (3, 63), (3, 64), (3, 65), (3, 66), (3, 67), (3, 68), (3, 69), (3, 70), (3, 74), (3, 77), (3, 85),
(4, 13), (4, 14), (4, 15), (4, 16), (4, 22), (4, 24), (4, 33), (4, 36), (4, 38), (4, 41), (4, 43), (4, 44), (4, 45), (4, 46), (4, 47), (4, 51), (4, 52), (4, 53), (4, 54), (4, 55), (4, 57), (4, 59), (4, 60), (4, 61), (4, 62), (4, 63), (4, 64), (4, 65), (4, 66), (4, 67), (4, 68), (4, 73), (4, 77), (4, 85), 
(5, 1), (5, 3), (5, 6), (5, 7), (5, 8), (5, 9), (5, 10), (5, 11), (5, 12), (5, 13), (5, 14), (5, 15), (5, 24), (5, 26), (5, 33), (5, 38), (5, 43), (5, 44), (5, 51), (5, 53), (5, 72), (5, 77), (5, 85), (5, 88),
(6, 1), (6, 3), (6, 6), (6, 13), (6, 14), (6, 15), (6, 24), (6, 26), (6, 33), (6, 38), (6, 43), (6, 44), (6, 51), (6, 53), (6, 71), (6, 85), (6, 87),
(7, 1), (7, 3), (7, 6), (7, 13), (7, 14), (7, 15), (7, 16), (7, 17), (7, 23), (7, 24), (7, 26), (7, 33), (7, 38), (7, 43), (7, 44), (7, 51), (7, 53), (7, 77), (7, 81), (7, 82), (7, 83), (7, 85),
(8, 1), (8, 3), (8, 4), (8, 6), (8, 13), (8, 14), (8, 15), (8, 23), (8, 24), (8, 26), (8, 33), (8, 38), (8, 43), (8, 44), (8, 51), (8, 53), (8, 77), (8, 78), (8, 83), (8, 85), (8, 86), (8, 87);

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`) VALUES
(1, 'Administrator'),
(2, 'Chair Team'),
(3, 'Local Organiser'),
(4, 'Registration desk'),
(5, 'Juridical Commission'),
(6, 'Audit Commission'),
(7, 'Network Commission'),
(8, 'Network Director'),
(0, 'No access');

--
-- Gegevens worden uitgevoerd voor tabel `setup`
--

INSERT INTO `setup` (`id`, `category`, `Name`, `Value`, `RegEx`, `Explanation`, `ac_view`, `ac_edit`, `ac_audit`, `ac_jc`, `ac_registration`, `ac_localorg`, `ac_chair`, `default`, `empty`) VALUES
(1, 'admin', 'SetupEventType', '', '[PM|EBM|EPM|AGORA|EVENT]', 'Set this to ''PM'', ''EBM'', ''EPM'', ''AGORA'' or to ''EVENT''', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(2, 'admin', 'SetupWSNumber', '', '[0|1|2]', 'Set to "0" (AGORA), "1" (Spring PM) or "2" (Autumn PM or EBM)', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(6, 'admin', 'WebmasterEmail', '', '[email]', 'The e-mail address of the webmaster. This will be showed on the page, as the person helping with technical problems', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(7, 'admin', 'MaxList', '100', '[int]', 'Maximum number of entries to show in a list by default', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '100', 'no'),
(8, 'participants', 'NoDelegatesDefault', '3', '[int]', 'Delegates for AGORAs (3), Chairperson for PMs (3)', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '3', 'no'),
(9, 'participants', 'NoEnvoysDefault', '3', '[int]', 'Envoys for AGORAs (3), Participants for PMs (8)', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '2', 'no'),
(10, 'participants', 'NoObserversDefault', '2', '[int]', 'Observers for AGORAs (0), empty for PMs (0)', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '2', 'no'),
(11, 'participants', 'NoVisitorsDefault', '30', '[int]', 'Visitor for AGORAs (2), Visitor for PMs (non-AEGEE persons for a PM) (0).\r\nPlease note that if you lower this number this will not mean people already preselected will be removed! Only after editing of the board they will be deleted.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '30', 'no'),
(12, 'event', 'EventSubject', '', '', 'Short title (title bar of browser)', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(14, 'admin', 'EventCode', '', '/(^[A-Z]{2}\\d{2}[A-Z]{3}\\d+$)/', 'The event code is issued via the Calendar of Events', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(15, 'event', 'EventOrganizer', '', '', 'Name of the organizing local (AEGEE-....)', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(16, 'preevent', 'EventPre1', '', '', 'Leave empty is non existent! For pre event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(123, 'admin', 'SetupBoardApproval', '', '[yes|no]', 'Does the board have to approve applications? If yes, board can assign delegate, envoy, visitor and observer status (as far as they are available for a body)', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(17, 'preevent', 'EventPre1Deadline', '', '[date]', 'Deadline for applying to the pre-event. After this date the interest checkbox in the application form is disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(18, 'preevent', 'EventPre1Email', '', '[email]', 'Leave empty is non existent! For pre event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(19, 'postevent', 'EventPost1', '', '', 'Leave empty is non existent! For POST event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(137, 'application', 'ApplShowMAC', 'false', '[bool]', 'Show the field ''MAC of network card'' in the application form. You have to enable ''ApplShowHasLaptop'' as well to enable this option', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(20, 'postevent', 'EventPost1Deadline', '', '[date]', 'Deadline for applying to the post-event. After this date the interest checkbox in the application form is disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(21, 'postevent', 'EventPost1Email', '', '[email]', 'Leave empty is non existent! For POST event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(22, 'event', 'EventAppResponsible', '', '', 'The responsible for the applications. Normally you should fill in the name of the participants responsible here', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(57, 'admin', 'ApplicationAdminOpen', 'false', '[bool]', 'This option can be used by the admin to lock the whole application until the Setup has been finished correctly.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', 'false', 'no'),
(24, 'event', 'EventDateStart', '', '[date]', 'Starting date of the statutory meeting\r\n\r\nDate format: Day.Month.Year with always two digits for day and month and four digits for the year!', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(25, 'event', 'EventDateEnd', '', '[date]', 'Ending date of the statutory meeting\r\n\r\nDate format: Day.Month.Year with always two digits for day and month and four digits for the year!', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(26, 'deadline', 'EventDateAppStart', '', '[date]', 'Start of web application', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(27, 'deadline', 'EventDateAppEndVisa', '', '[date]', 'Official end of web application for VISA (to be published). After this date the checkbox for visa will be disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(28, 'deadline', 'EventDateAppEnd', '', '[date]', 'Official end of web application (to be published). The application will still be reachable and open after this date', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(29, 'deadline', 'EventDateWorkshopFix', '', '[date]', 'After this date workshop preference cannot be changed anymore!', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(30, 'deadline', 'EventDateAppEndReal', '', '[date]', 'True end of web application (not published; after this date applying is not possible any more)', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(31, 'address', 'EventName', '', '', 'Address info: name of the event', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(32, 'address', 'EventCareOf', '', '', 'Address info: care of for the address, if non-existent, leave empty', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(33, 'address', 'EventStreet', '', '', 'Address info: the street of the address of the organizers', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(34, 'address', 'EventCity', '', '', 'Address info', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(35, 'address', 'EventZIP', '', '', 'Address info: ZIP part of the address of the organizers. Leave empty when there is no ZIP', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(36, 'address', 'EventCountryCode', '', '/(^[A-Z]{1,3}$)/', 'Address info', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(37, 'address', 'EventPhone', '', '[phone]', 'Address info', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(38, 'address', 'EventFax', '', '[phone]', 'Address info', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(39, 'event', 'EventEmail', '', '[email]', 'Standard e-mail address for questions', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(52, 'registration', 'UseWebRegister', 'yes', '[yes|no]', 'Will online registration system be used? If yes, people accepted but not registered will be shown as no-show after the event.', 'view', 'view', 'no', 'no', 'no', 'edit', 'edit', 'yes', 'no'),
(40, 'event', 'EventApplEmail', '', '[email]', 'E-mail address where applications should be send to (only used to inform organizers, not used for participants).\r\nThis is only active when InformMailOrganiser is set', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(41, 'event', 'EventApplVisaEmail', '', '[email]', 'E-mail address where visa applications should be send to. It''s used by the application page to send a mail when people apply and need visa.\r\nThis is only active when InformMailOrganiserVisa is set', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(42, 'event', 'EventApplFromEmail', '', '[email]', 'E-mail address to use as from when sending e-mails to participants (participants may reply to this address). This should contain the e-mail address of the organisers, as they are the primary contact for questions.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(43, 'event', 'EventErrorEmail', '', '[email]', 'E-mail address where delivery errors should be send to.\r\nErrors will be read and processed by the server. You''ll receive the unknown errors, and a summary of what has been done upon receiving of the error mail.', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(44, 'event', 'EventUrl', '', '[url]', 'The link to the webpage of the statutary event. It should start with http(s)://, and after the domain it should have at least a /. Example: http://www.aegee.org/', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(45, 'application', 'InformMailParticipantEdit', 'true', '[bool]', 'Whether to send e-mail with application data to participant when applying or not', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(46, 'application', 'InformMailBoardEdit', 'false', '[bool]', 'Wether to send e-mail to sending local informing about their members participation or not', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'false', 'no'),
(47, 'application', 'InformMailOrganiserEdit', '', '[bool]', 'Wether to send e-mail to local organiser when a person applies or not', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(48, 'application', 'InformMailOrganiserVisaEdit', '', '[bool]', 'Wether to send e-mail to organiser when a visa person applies or not', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(49, 'admin', 'MailFooter', '\\n\\n\\n===================================================\\nThis mail was send automatically by the application\\nform for AEGEE-Europe statutory events.', '', 'Text added to the end of every e-mail send by the system', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '\\n\\n\\n===================================================\\nThis mail was send automatically by the application\\nform for AEGEE-Europe statutory events.', 'no'),
(50, 'admin', 'WStimeLong', '8 h', '', 'Text for the time of a long workshop', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '8 h', 'no'),
(51, 'admin', 'WStimeShort', '4 h', '', 'Text for the time of a short workshop', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '4 h', 'no'),
(53, 'admin', 'Debug', 'false', '[bool]', 'Setting the debug mode on or off.\r\n\r\nWARNING: never set this to ''true'' in a running application, since it will produce extra output which is senseless to applicants', 'view', 'view', 'view', 'view', 'view', 'view', 'view', 'false', 'no'),
(54, 'preevent', 'EventPre2', '', '', 'Leave empty is non existent! For pre event 2 only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(55, 'preevent', 'EventPre2Deadline', '', '[date]', 'Deadline for applying to the pre-event 2. After this date the interest checkbox in the application form is disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(56, 'preevent', 'EventPre2Email', '', '[email]', 'Leave empty is non existent! For pre event 2 only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(59, 'admin', 'PrivacyVersion', '1.03', '', 'The version of the privacy statement', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '1.03', 'no'),
(60, 'registration', 'RegistrationFields', 'Sex,CountryCode,Visa,ParticipantType!,Meals!,FeeCheck!,Fee,FeePaid', '/^([a-zA-Z0-9_]*!?)(,[a-zA-Z0-9_]*!?)*$/', 'Fill in a comma seperated list with the fields you want to see in the registration page. If you put an exclamation mark (!) after a field name this field will be showed in bigger font.\r\nField names can be found in the mass mailer (use the names in between ''%'').', 'no', 'view', 'no', 'no', 'no', 'edit', 'view', 'Sex,CountryCode,Visa,ParticipantType!,Meals!,FeeCheck!,Fee,FeePaid', 'no'),
(192, 'application', 'ApplShowSubscribeANNOUNCE_L', 'true', '[bool]', 'Show the field ''Subscribe ANNOUNCE-L'' in the application form', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(61, 'registration', 'RegistrationCustField1', '', '', 'Fill here the title of the custom field 1 that will be shown at the Registration page for every participant.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(62, 'registration', 'RegistrationCustField2', '', '', 'Fill here the title of the custom field 2 that will be shown at the Registration page for every participant.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(63, 'registration', 'RegistrationCustField3', '', '', 'Fill here the title of the custom field 3 that will be shown at the Registration page for every participant.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(64, 'registration', 'RegistrationCustField1Option', '', '', 'You can provide a list in the form [opt1|opt2|opt3|....]. In case this is present, you''ll see radio buttons with the provided values, if empty the field RegistrationCustField1 will be free text (textbox).', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(65, 'registration', 'RegistrationCustField2Option', '', '', 'You can provide a list in the form [opt1|opt2|opt3|....]. In case this is present, you''ll see radio buttons with the provided values, if empty the field RegistrationCustField2 will be free text (textbox).', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(66, 'registration', 'RegistrationCustField3Option', '', '', 'You can provide a list in the form [opt1|opt2|opt3|....]. In case this is present, you''ll see radio buttons with the provided values, if empty the field RegistrationCustField3 will be free text (textbox).', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(67, 'admin', 'MailReturnpath', '', '[email]', 'The e-mail address where error mails from sending are collected. Normally ####_return@zeus.aegee.utwente.nl', 'no', 'no', 'no', 'no', 'no', 'no', 'no', '', 'no'),
(69, 'admin', 'DevelopmentVersion', 'false', '[bool]', 'Is this the development version? If yes, any mails generated by the system will be mailed to the webmaster instead of the intended recipient.', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'false', 'no'),
(70, 'participants', 'NoDelegatesAlumni', '0', '[int]', 'Default number of delegates the Alumni network bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(71, 'participants', 'NoDelegatesCD', '0', '[int]', 'Default number of delegates the Comité Directeur bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(72, 'participants', 'NoDelegatesCommissions', '0', '[int]', 'Default number of delegates the Commissions bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(73, 'participants', 'NoDelegatesConnections', '0', '[int]', 'Default number of delegates the Connections bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(74, 'participants', 'NoDelegatesContacts', '0', '[int]', 'Default number of delegates the Contacts bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(75, 'participants', 'NoDelegatesHonorary', '0', '[int]', 'Default number of delegates the Honorary Members bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(76, 'participants', 'NoDelegatesLiaison', '0', '[int]', 'Default number of delegates the Liaison Officers bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(77, 'participants', 'NoDelegatesLocal_A', '-1', '[int]', 'Default number of delegates the Locals (A) bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(78, 'participants', 'NoDelegatesLocal_CA', '0', '[int]', 'Default number of delegates the Locals (CA) bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(79, 'participants', 'NoDelegatesProjects', '0', '[int]', 'Default number of delegates the Projects bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(80, 'participants', 'NoDelegatesWG_A', '-1', '[int]', 'Default number of delegates the Working Groups (A) bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(81, 'participants', 'NoDelegatesWG_T', '0', '[int]', 'Default number of delegates the Working Groups (T) bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(82, 'participants', 'NoDelegatesWG_S', '0', '[int]', 'Default number of delegates the Working Groups (S) bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(83, 'participants', 'NoEnvoysAlumni', '0', '[int]', 'Default number of envoys the Alumni network bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(84, 'participants', 'NoEnvoysCD', '7', '[int]', 'Default number of envoys the Comit&eacute; Directeur bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '7', 'no'),
(85, 'participants', 'NoEnvoysCommissions', '-1', '[int]', 'Default number of envoys the Commissions bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(86, 'participants', 'NoEnvoysConnections', '-1', '[int]', 'Default number of envoys the Connections bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(87, 'participants', 'NoEnvoysContacts', '0', '[int]', 'Default number of envoys the Contacts bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(88, 'participants', 'NoEnvoysHonorary', '0', '[int]', 'Default number of envoys the Honorary Members bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(89, 'participants', 'NoEnvoysLiaison', '1', '[int]', 'Default number of envoys the Liaison Officers bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '1', 'no'),
(90, 'participants', 'NoEnvoysLocal_A', '0', '[int]', 'Default number of envoys the Locals (A) bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(91, 'participants', 'NoEnvoysLocal_CA', '-1', '[int]', 'Default number of envoys the Locals (CA) bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(92, 'participants', 'NoEnvoysProjects', '-1', '[int]', 'Default number of envoys the Projects bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(93, 'participants', 'NoEnvoysWG_A', '0', '[int]', 'Default number of envoys the Working Groups (A) bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(94, 'participants', 'NoEnvoysWG_T', '-1', '[int]', 'Default number of envoys the Working Groups (T) bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(95, 'participants', 'NoEnvoysWG_S', '-1', '[int]', 'Default number of envoys the Working Groups (S) bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(96, 'participants', 'NoObserversAlumni', '0', '[int]', 'Default number of observers the Alumni network bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(97, 'participants', 'NoObserversCD', '0', '[int]', 'Default number of observers the Comit&eacute; Directeur bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(98, 'participants', 'NoObserversCommissions', '0', '[int]', 'Default number of observers the Commissions bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(99, 'participants', 'NoObserversConnections', '0', '[int]', 'Default number of observers the Connections bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(100, 'participants', 'NoObserversContacts', '-1', '[int]', 'Default number of observers the Contacts bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(101, 'participants', 'NoObserversHonorary', '0', '[int]', 'Default number of observers the Honorary Members bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(102, 'participants', 'NoObserversLiaison', '0', '[int]', 'Default number of observers the Liaison Officers bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(103, 'participants', 'NoObserversLocal_A', '0', '[int]', 'Default number of observers the Locals (A) bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(104, 'participants', 'NoObserversLocal_CA', '0', '[int]', 'Default number of observers the Locals (CA) bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(105, 'participants', 'NoObserversProjects', '0', '[int]', 'Default number of observers the Projects bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(106, 'participants', 'NoObserversWG_A', '0', '[int]', 'Default number of observers the Working Groups (A) bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(107, 'participants', 'NoObserversWG_T', '0', '[int]', 'Default number of observers the Working Groups (T) bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(108, 'participants', 'NoObserversWG_S', '0', '[int]', 'Default number of observers the Working Groups (S) bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(109, 'participants', 'NoVisitorsAlumni', '-1', '[int]', 'Default number of visitors the Alumni network bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(110, 'participants', 'NoVisitorsCD', '0', '[int]', 'Default number of visitors the Comit&eacute; Directeur bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(111, 'participants', 'NoVisitorsCommissions', '0', '[int]', 'Default number of visitors the Commissions bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(112, 'participants', 'NoVisitorsConnections', '-1', '[int]', 'Default number of visitors the Connections bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(113, 'participants', 'NoVisitorsContacts', '-1', '[int]', 'Default number of visitors the Contacts bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(114, 'participants', 'NoVisitorsHonorary', '-1', '[int]', 'Default number of visitors the Honorary Members bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(115, 'participants', 'NoVisitorsLiaison', '0', '[int]', 'Default number of visitors the Liaison Officers bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(116, 'participants', 'NoVisitorsLocal_A', '-1', '[int]', 'Default number of visitors the Locals (A) bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(117, 'participants', 'NoVisitorsLocal_CA', '-1', '[int]', 'Default number of visitors the Locals (CA) bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(118, 'participants', 'NoVisitorsProjects', '-1', '[int]', 'Default number of visitors the Projects bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(119, 'participants', 'NoVisitorsWG_A', '-1', '[int]', 'Default number of visitors the Working Groups (A) bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(120, 'participants', 'NoVisitorsWG_T', '-1', '[int]', 'Default number of visitors the Working Groups (T) bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(121, 'participants', 'NoVisitorsWG_S', '-1', '[int]', 'Default number of visitors the Working Groups (S) bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(122, 'admin', 'MailABC', '', '[email]', 'E-mail address of ABC where we can send error reports of body e-mail addresses', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(124, 'admin', 'LoadNumMemDB1', '', '', 'The MySQL database on Robert where we should get the the number of members from. We look in table=finances; column=BodyCode/NoMembers. This one has priority over LoadNumMemDB2 (so make this latest Agora)', 'no', 'no', 'no', 'no', 'no', 'no', 'no', '', 'no'),
(125, 'admin', 'LoadNumMemDB2', '', '', 'Load the number of members from this database. This entry comes after LoadNumDB2, so make sure this is the one but latest agora', 'no', 'no', 'no', 'no', 'no', 'no', 'no', '', 'no'),
(126, 'preevent', 'EventPre3', '', '', 'Leave empty is non existent! For pre event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(136, 'application', 'ApplShowHasLaptop', 'false', '[bool]', 'Show the field ''HasLaptop'' in the application form', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(127, 'preevent', 'EventPre3Deadline', '', '[date]', 'Deadline for applying to the pre-event. After this date the interest checkbox in the application form is disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(128, 'preevent', 'EventPre3Email', '', '[email]', 'Leave empty is non existent! For pre event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(129, 'event', 'Remarks', '', '[text]', 'Free text to be shown on front page of the applications.', 'no', 'no', 'no', 'no', 'no', 'no', 'no', '', 'yes'),
(134, 'application', 'ApplShowExtraFee', 'false', '[bool]', 'Show the field ''ExtraFee'' in the application form', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(135, 'application', 'ApplShowHasMobile', 'false', '[bool]', 'Show the field ''HasMobile'' in the application form', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(130, 'deadline', 'EventDatePartTypeFix', '', '[date]', 'After this date participant types cannot be changed anymore for people where it is already set! This is also the deadline published in the reminders for approving participants.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(131, 'admin', 'MailallNextAllowedChair', '01.01.2000', '[date]', 'The date at which a mail to all participants can be sent again by chair', 'no', 'no', 'no', 'no', 'no', 'view', 'view', '01.01.2000', 'no'),
(132, 'admin', 'MailallDaysIntervalChair', '1', '[int]', 'How many days should there be between successive mails to participants by chair', 'no', 'no', 'no', 'no', 'no', 'view', 'view', '1', 'no'),
(133, 'selection', 'ShowParticipantList', 'true', '[bool]', 'Show the list of (accepted) participants online', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(138, 'application', 'ApplShowTShirtSize', '', '[bool]', 'Show the field ''TShirtSize'' in the application form', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(139, 'postevent', 'EventPost2', '', '', 'Leave empty is non existent! For POST event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(140, 'postevent', 'EventPost2Deadline', '', '[date]', 'Deadline for applying to the post-event. After this date the interest checkbox in the application form is disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(141, 'postevent', 'EventPost2Email', '', '[email]', 'Leave empty is non existent! For POST event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(142, 'postevent', 'EventPost3', '', '', 'Leave empty is non existent! For POST event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(143, 'postevent', 'EventPost3Deadline', '', '[date]', 'Deadline for applying to the post-event. After this date the interest checkbox in the application form is disabled', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(144, 'postevent', 'EventPost3Email', '', '[email]', 'Leave empty is non existent! For POST event only', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'yes'),
(145, 'application', 'ApplShowMotivation', 'true', '[bool]', 'Show the field ''Motivation'' in the application form', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', 'true', 'no'),
(146, 'application', 'ApplShowSubscribeAEGEE_L', 'true', '[bool]', 'Show the field ''Subscribe AEGEE-L'' in the application form', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(147, 'application', 'ApplShowSubscribeAGORA_L', 'true', '[bool]', 'Show the field ''Subscribe AGORA-L'' in the application form', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(148, 'admin', 'WebmasterName', 'Wim van Ravesteijn', '', 'The name of the webmaster', 'view', 'view', 'view', 'view', 'view', 'view', 'view', 'Wim van Ravesteijn', 'no'),
(149, 'application', 'ApplShowCSN', 'false', '[bool]', 'Show the field ''CSN (card serial number)'' in the application form', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'false', 'no'),
(150, 'application', 'ApplShowNameReadonly', 'true', '[bool]', 'When people log in fields will be pre-filled. Should the name be readonly in such cases?', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(151, 'application', 'InformMailBoardNew', 'true', '[bool]', 'Wether to send e-mail to sending local informing about their members participation or not', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(152, 'application', 'InformMailOrganiserNew', '', '[bool]', 'Wether to send e-mail to local organiser when a person applies or not', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(153, 'application', 'InformMailOrganiserVisaNew', '', '[bool]', 'Wether to send e-mail to organiser when a visa person applies or not', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(154, 'application', 'InformMailParticipantNew', 'true', '[bool]', 'Whether to send e-mail with application data to participant when applying or not', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(166, 'fee', 'DelegateLow', '', '[int]', 'The fee for a delegate from a non-EU country', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(155, 'application', 'ApplShowPhoto', 'false', '[bool]', 'Show the field ''photo'' in the application form', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', 'false', 'no'),
(156, 'application', 'PhotoMaxHeight', '150', '[int]', 'The maximum height of the saved photo in pixels. Photo''s are resized proportionally.', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '150', 'no'),
(157, 'application', 'PhotoMaxWidth', '150', '[int]', 'The maximum width of the saved photo in pixels. Photo''s are resized proportionally.', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '150', 'no'),
(158, 'application', 'PhotoMaxUploadSize', '768', '[int]', 'The maximum size an uploaded photo is allowed to be (in KB)', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '768', 'no'),
(159, 'selection', 'AutoSelection', '', '[bool]', 'Set if the application tool is allowed to do automatic selection of participants once per day', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(160, 'selection', 'SelectFromDate', '', '[date]', 'From which date on should the automatic selection of participants start. It will stop automatically when the event starts.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(161, 'selection', 'TotalPlaces', '', '[int]', 'The maximum number of places available. This is the total number of participants that will be automatically accepted. This will never reject participants that were already accepted, so in case it is lowered after participants have been accepted already, it will not replace people that cancel until there is again free places based on the new number.', 'view', 'view', 'view', 'view', 'view', 'edit', 'edit', '', 'no'),
(162, 'selection', 'LowerNotClaimed', '15', '[int]', 'When locals do not claim the number of members they have, we use the number of members paid for at last Agora (or the one before) lowered by this percentage (this to be fair to locals that filled in this value and to prevent locals not filling in anything when the number of members decreased)', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '15', 'no'),
(163, 'selection', 'UseFixedPlaces', 'true', '[bool]', 'Use the fixed places (delegate, envoy, observer) in calculating the places a body gets?', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(164, 'selection', 'SelectionFixedPlaces', '1', '[int]', 'The number of visitor places every local will get at least', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '1', 'no'),
(165, 'selection', 'SelectionExponentialPlaces', '50', '[int]', 'The exponential value (a) that arranges dividing of places between locals. It operates on the number of members (n) a local has: p = n^(a/100)\r\nFor a<100 this means doubling members gives less than double places, a=100 means linear distribution, and a>100 means doubling members gives more than double places.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '50', 'no'),
(167, 'fee', 'EnvoyLow', '', '[int]', 'The fee for a envoy/observer from a non-EU country', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(168, 'fee', 'VisitorLow', '', '[int]', 'The fee for a visitor from a non-EU country', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(169, 'fee', 'DelegateHigh', '', '[int]', 'The fee for a delegate from an EU country', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(170, 'fee', 'EnvoyHigh', '', '[int]', 'The fee for a envoy/observer from an EU country', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(171, 'fee', 'VisitorHigh', '', '[int]', 'The fee for a visitor from an EU country', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(172, 'application', 'ApplShowMemberType', 'true', '[bool]', 'Do members have to select their member type (board member, WG board, project team member, ....)', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(173, 'application', 'ApplShowWorkshopStrategy', 'false', '[bool]', 'Show the field ''Strategy meeting'' in the application form', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'false', 'no'),
(174, 'jc', 'CandidateStart', '', '[date]', 'This is the date from which candidates can post their candidatures.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '', 'no'),
(175, 'jc', 'CandidateDeadline', '', '[datetime]', 'This is the official deadline for candidatures. After this date, applications will only be available for positions that had vacant places after the deadline.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '', 'no'),
(176, 'jc', 'CandidateEndReal', '', '[datetime]', 'After this date, online applications will not be accepted anymore. This is typically few days before the Agora starts.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '', 'no'),
(177, 'jc', 'CandidatePublish', '', '[date]', 'Date from which on the approved applications will be visible online.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '', 'no'),
(178, 'jc', 'CandidateMailApplicantNew', 'true', '[bool]', 'Will the applicant get a confirmation by mail that his candidature was received.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(179, 'jc', 'CandidateMailApplicantStatus', 'true', '[bool]', 'Will the applicant get a mail informing him/her about a change of the status of his candidature (approved/disapproved).', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(180, 'jc', 'CandidateMailJcNew', 'true', '[bool]', 'Will the JC get a confirmation by mail that a candidature was received.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(181, 'jc', 'CandidateMailJcStatus', 'true', '[bool]', 'Will the JC get a mail informing her about a change of the status of a candidature (approved/disapproved).', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(182, 'jc', 'MailJc', '', '[email]', 'E-mail address where JC will get notifications (if enabled)', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '', 'no'),
(183, 'jc', 'MailSenderJc', '', '[email]', 'Sender address of mails related to candidatures. If people reply to a mail notification, mail will arrive to this address.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '', 'no'),
(184, 'jc', 'CandidateShowPending', 'true', '[bool]', 'Will the name of the ''pending'' candidates be visible after publishing date.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(185, 'admin', 'CandidateAdminOpen', 'false', '[bool]', 'This option can be used by the admin to lock the whole candidature part until the Setup has been finished correctly.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', 'false', 'no'),
(186, 'jc', 'CandidateMailApplicantEdit', 'true', '[bool]', 'Will the applicant get a confirmation by mail when his candidature has been edited.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(187, 'jc', 'CandidateMailJcEdit', 'true', '[bool]', 'Will the JC get a confirmation by mail when a candidature has been edited.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'true', 'no'),
(188, 'selection', 'MaxPlacesPerLocal', '5', '[int]', 'A maximum number of people that will be accepted for a local. If the resulting number from ''MaxPlacesPercentageOfMembers'' is higher, that one will be used.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '5', 'no'),
(189, 'selection', 'MaxPlacesPercentageOfMembers', '10', '[int]', 'The maximum number of people that will be accepted for a local based on this percentage of the number of members a local has. If ''MaxPlacesPerLocal'' is higher, that one will be used.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '10', 'no'),
(190, 'registration', 'RegistrationDesks', '5', '[int]', 'Number of registration desks that will be used. Up to this number of registration desks can be selected for registration.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '5', 'no'),
(191, 'selection', 'ShowWorkshopSelection', '', '[bool]', 'Show the list of workshop selection of the participants online', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '', 'no'),
(193, 'admin', 'MailChair', '', '[email]', 'E-mail address of chair where we can send error reports and which is used as sender for mails on behalf of chair', 'no', 'no', 'no', 'no', 'no', 'view', 'view', '', 'no'),
(194, 'application', 'ApplShowGym', 'false', '[bool]', 'Should the gym selection be visible in the participants list?', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(195, 'application', 'ApplShowLodgingNeeded', '', '[bool]', 'Show a checkbox where people can set they don''t need lodging (useful in case only lodging facilities are limiting the size of Agora)', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'no'),
(196, 'application', 'ApplShowAgoraVisited', 'true', '[bool]', 'Should people select at how many Agora they have been?', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(197, 'application', 'ApplShowIDRequired', 'false', '[bool]', 'Is an ID needed to apply? If yes, ID number, nationality and kind of ID will show and be required fields for everybody.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(198, 'registration', 'NumberOfGyms', '0', '[int]', 'In case people can select beforehand a gym where they will stay (in case of multiple gyms), fill in the number of gyms that are available. Maximum 10 gyms can be used.', 'view', 'view', 'no', 'view', 'no', 'edit', 'view', '0', 'no'),
(199, 'registration', 'CapacityGym1', '', '[int]', 'Number of places in gym 1', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(200, 'registration', 'CapacityGym2', '', '[int]', 'Number of places in gym 2', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(201, 'registration', 'CapacityGym3', '', '[int]', 'Number of places in gym 3', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(202, 'registration', 'CapacityGym4', '', '[int]', 'Number of places in gym 4', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(203, 'registration', 'CapacityGym5', '', '[int]', 'Number of places in gym 5', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(204, 'registration', 'CapacityGym6', '', '[int]', 'Number of places in gym 6', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(205, 'registration', 'CapacityGym7', '', '[int]', 'Number of places in gym 7', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(206, 'registration', 'CapacityGym8', '', '[int]', 'Number of places in gym 8', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(207, 'registration', 'CapacityGym9', '', '[int]', 'Number of places in gym 9', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(208, 'registration', 'CapacityGym10', '', '[int]', 'Number of places in gym 10', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(209, 'admin', 'CustViewCols', '7', '[int]', 'Number of columns to show in the custom view.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '7', 'no'),
(213, 'registration', 'CustLink1Name', '', '', 'Name of the custom link in the custom view.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(210, 'admin', 'MenuName', '', '', 'The name to be shown at the top of the page for going back and forth between the different statutory events. Example: Spring Agora 2009.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(211, 'application', 'ApplShowGymSelector', 'false', '[bool]', 'Allow people to select their gym (only visible after selection results are published, and the person is accepted)', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(212, 'application', 'ApplShowGymPreference', 'false', '[bool]', 'Allow people to select with who they want to be in a gym (only visible after selection results are published, and the person is accepted)', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(214, 'registration', 'CustLink1URL', '', '[url]', 'URL of the custom link in the custom view. One can add fields from the application by using %fieldname%. Use the mass mailer dropdown box to find the available fields.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(215, 'registration', 'CustLink2Name', '', '', 'Name of the custom link in the custom view.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(216, 'registration', 'CustLink2URL', '', '[url]', 'URL of the custom link in the custom view. One can add fields from the application by using %fieldname%. Use the mass mailer dropdown box to find the available fields.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(217, 'registration', 'CustLink3Name', '', '', 'Name of the custom link in the custom view.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(218, 'registration', 'CustLink3URL', '', '[url]', 'URL of the custom link in the custom view. One can add fields from the application by using %fieldname%. Use the mass mailer dropdown box to find the available fields.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(219, 'registration', 'CustLink4Name', '', '', 'Name of the custom link in the custom view.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(220, 'registration', 'CustLink4URL', '', '[url]', 'URL of the custom link in the custom view. One can add fields from the application by using %fieldname%. Use the mass mailer dropdown box to find the available fields.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(221, 'registration', 'CustRegistrationLinkName', '', '', 'Name of the custom link shown after successful registration of a participant.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(222, 'registration', 'CustRegistrationLinkURL', '', '[url]', 'URL of the custom link shown after successful registration of a participant. One can add fields from the application by using %fieldname%. Use the mass mailer dropdown box to find the available fields.', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', '', 'yes'),
(223, 'registration', 'CustRegistrationLinkAutoOpen', 'false', '[bool]', 'Should the custom registration link automatically open after successful registration of a participant', 'view', 'view', 'view', 'view', 'view', 'edit', 'view', 'false', 'no'),
(224, 'registration', 'RegisterAccepted', 'yes,confirmed', '/^(yes|confirmed|-|no|cancel|arrived)(,(yes|confirmed|-|no|cancel|arrived))*$/', 'Accepted status of participants that a ''register'' user can register. Comma-separated list containing the following values: yes,confirmed,-,no,cancel,arrived', 'no', 'no', 'no', 'no', 'view', 'edit', 'view', 'yes,confirmed', 'no'),
(225, 'registration', 'RegisterMaxFeeDifference', '0', '[int]', 'Maximum difference in fee paid compared to fee to be paid for a ''registration'' user to still be able to register a participant.', 'no', 'no', 'no', 'no', 'view', 'edit', 'view', '0', 'no'),
(226, 'registration', 'RegisterFeeCheck', '', '[bool]', 'Should the fee be checked when registering participants? If enabled, ''registration'' users are not able to register participants for whom the fee check fails, unless difference is less than RegisterMaxFeeDifference.', 'no', 'no', 'no', 'no', 'view', 'edit', 'view', '', 'no'),
(227, 'selection', 'WorkshopSelectFirstChoice', 'true', '[bool]', 'Should for accepted participants automatically their first workshop choice be selected if no workshop is selected yet? Only active when ''AutoSelection'' is enabled.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(228, 'admin', 'PromoteAnonymousApplication', 'true', '[bool]', 'Should anonymous applications be promoted. If yes, people will have option to log in or not, otherwise this option will be more hidden, and described on the frontpage in the how-to, which nobody reads anyway.\r\nThis option will also send out passwords to all bodies for member approval, instead of only to contacts.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', 'true', 'no'),
(229, 'admin', 'AuthSystem', 'None', '[None|Intranet]', 'The authentication system to use, or ''None'' for no external authentication.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'yes'),
(230, 'admin', 'ListservEmail', '', '[email]', 'The e-mail address of listserv. List subscriptions will be send to this address.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(231, 'admin', 'HeadofficeEmail', '', '[email]', 'The e-mail address of headoffice. Mails from website to headoffice will be send here.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(232, 'admin', 'MailallNextAllowedOrganiser', '01.01.2000', '[date]', 'The date at which a mail to all participants can be sent again by local organisers', 'no', 'no', 'no', 'no', 'no', 'view', 'view', '01.01.2000', 'no'),
(233, 'admin', 'MailallDaysIntervalOrganiser', '2', '[int]', 'How many days should there be between successive mails to participants by local organisers', 'no', 'no', 'no', 'no', 'no', 'view', 'view', '2', 'no'),
(234, 'jc', 'CloseWhenEnoughCandidates', 'false', '[bool]', 'When set, after the first deadline, candidating will only be possible for positions where there is not enough candidates yet. As soon as there is enough candidates, the list will close. Before the first deadline this setting has no effect, and everybody can candidate.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', 'false', 'no'),
(235, 'application', 'NoApplicationsReminder', '3', '[int]', 'Number of days before the application deadline a reminder is send to the locals that didn''t send participants yet. The reminder is only send to locals in case of Agora or EBM. To disable the reminder, put a value of 0.', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '3', 'yes'),
(236, 'admin', 'UploadMembersList', '', '[bool]', 'Should it be possible to upload members lists? If not, it will be possible to fill in the number of members by hand.', 'no', 'no', 'view', 'view', 'no', 'view', 'view', '', 'no'),
(237, 'admin', 'SendPasswordForMemListDate', '', '[date]', 'When locals have to hand in members lists, they need a password to do so. Starting at which date should passwords be send out to all bodies to do this? Already before this date all locals that have applications on their behalf will get a password, but from this date on, all locals will get one, reminding them they have to hand in the members list.', 'no', 'no', 'view', 'view', 'no', 'view', 'view', '', 'no'),
(238, 'admin', 'PreviousMemberlist', '', '', 'The MySQL database that contains the memberlist from previous Agora.', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '', 'no'),
(239, 'admin', 'ApplShowCommentBoard', '', '[bool]', 'Should the board comment field be displayed for applications?', 'no', 'no', 'no', 'no', 'no', 'no', 'edit', '', 'no'),
(240, 'admin', 'ApplShowCommentNetcom', '', '[bool]', 'Should the NetCom comment field be displayed for applications?', 'no', 'no', 'no', 'no', 'no', 'no', 'edit', '', 'no'),
(241, 'application', 'ApplShowSubscribeAEGEENEWS_L', 'true', '[bool]', 'Show the field ''Subscribe AEGEENEWS-L'' in the application form', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', 'true', 'no'),
(242, 'participants', 'NoDelegatesWG_I', '0', '[int]', 'Default number of delegates the Interest Groups bodies can send. -1 means we look at NoDelegatesDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(243, 'participants', 'NoEnvoysWG_I', '0', '[int]', 'Default number of envoys the Interest Groups bodies can send. -1 means we look at NoEnvoysDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(244, 'participants', 'NoObserversWG_I', '0', '[int]', 'Default number of observers the Interest Groups bodies can send. -1 means we look at NoObserversDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '0', 'no'),
(245, 'participants', 'NoVisitorsWG_I', '-1', '[int]', 'Default number of visitors the Interest Groups bodies can send. -1 means we look at NoVisitorsDefault', 'view', 'view', 'view', 'view', 'view', 'view', 'edit', '-1', 'no'),
(246, 'jc', 'CandidatePhotoMaxHeight', '500', '[int]', 'The maximum height of the saved photo in pixels. Photo''s are resized proportionally.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '500', 'no'),
(247, 'jc', 'CandidatePhotoMaxWidth', '500', '[int]', 'The maximum width of the saved photo in pixels. Photo''s are resized proportionally.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '500', 'no'),
(248, 'jc', 'CandidatePhotoMaxUploadSize', '2048', '[int]', 'The maximum size an uploaded photo is allowed to be (in KB)', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '2048', 'no');
