-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 20, 2010 at 02:39 PM -- Server version: 5.1.40 -- PHP Version: 5.2.6 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: `bmcforu_transfer` -- -- -------------------------------------------------------- -- -- Table structure for table `profilefield` -- CREATE TABLE IF NOT EXISTS `profilefield` ( `profilefieldid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `required` smallint(6) NOT NULL DEFAULT '0', `hidden` smallint(6) NOT NULL DEFAULT '0', `maxlength` smallint(6) NOT NULL DEFAULT '250', `size` smallint(6) NOT NULL DEFAULT '25', `displayorder` smallint(6) NOT NULL DEFAULT '0', `editable` smallint(6) NOT NULL DEFAULT '1', `type` enum('input','select','radio','textarea','checkbox','select_multiple') NOT NULL DEFAULT 'input', `data` mediumtext NOT NULL, `height` smallint(6) NOT NULL DEFAULT '0', `def` smallint(6) NOT NULL DEFAULT '0', `optional` smallint(5) unsigned NOT NULL DEFAULT '0', `searchable` smallint(6) NOT NULL DEFAULT '0', `memberlist` smallint(6) NOT NULL DEFAULT '0', `regex` varchar(255) NOT NULL DEFAULT '', `form` smallint(6) NOT NULL DEFAULT '0', `html` smallint(6) NOT NULL DEFAULT '0', `perline` smallint(5) unsigned NOT NULL DEFAULT '0', `profilefieldcategoryid` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`profilefieldid`), KEY `editable` (`editable`), KEY `profilefieldcategoryid` (`profilefieldcategoryid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=100 ; -- -- Dumping data for table `profilefield` -- INSERT INTO `profilefield` (`profilefieldid`, `required`, `hidden`, `maxlength`, `size`, `displayorder`, `editable`, `type`, `data`, `height`, `def`, `optional`, `searchable`, `memberlist`, `regex`, `form`, `html`, `perline`, `profilefieldcategoryid`) VALUES (1, 2, 0, 100, 25, 31, 1, 'textarea', '', 4, 0, 0, 0, 0, '', 0, 0, 0, 0), (3, 2, 0, 100, 25, 32, 1, 'textarea', '', 4, 0, 0, 0, 0, '', 0, 0, 0, 0), (4, 2, 0, 100, 25, 30, 1, 'input', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (5, 0, 0, 100, 25, 5, 0, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (6, 2, 0, 100, 25, 2, 1, 'input', '', 0, 0, 0, 1, 0, '', 0, 0, 0, 0), (7, 2, 0, 100, 25, 3, 1, 'input', '', 0, 0, 0, 1, 0, '', 0, 0, 0, 0), (8, 2, 0, 100, 25, 6, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (13, 1, 0, 100, 25, 9, 1, 'select', 'a:276:{i:0;s:11:"Undisclosed";i:1;s:13:"United States";i:2;s:6:"Canada";i:3;s:7:"Vietnam";i:4;s:9:"Abu Dhabi";i:5;s:11:"Afghanistan";i:6;s:5:"Ajman";i:7;s:13:"Aland Islands";i:8;s:7:"Albania";i:9;s:8:"Alderney";i:10;s:7:"Algeria";i:11;s:14:"American Samoa";i:12;s:7:"Andorra";i:13;s:6:"Angola";i:14;s:8:"Anguilla";i:15;s:10:"Antarctica";i:16;s:19:"Antigua and Barbuda";i:17;s:9:"Argentina";i:18;s:7:"Armenia";i:19;s:5:"Aruba";i:20;s:20:"Australia-Aboriginal";i:21;s:9:"Australia";i:22;s:7:"Austria";i:23;s:10:"Azerbaijan";i:24;s:6:"Azores";i:25;s:7:"Bahamas";i:26;s:7:"Bahrain";i:27;s:16:"Balearic Islands";i:28;s:10:"Bangladesh";i:29;s:8:"Barbados";i:30;s:7:"Belarus";i:31;s:7:"Belgium";i:32;s:6:"Belize";i:33;s:5:"Benin";i:34;s:7:"Bermuda";i:35;s:6:"Bhutan";i:36;s:7:"Bolivia";i:37;s:22:"Bosnia and Herzegovina";i:38;s:8:"Botswana";i:39;s:13:"Bouvet Island";i:40;s:6:"Brazil";i:41;s:27:"British Antarctic Territory";i:42;s:30:"British Indian Ocean Territory";i:43;s:22:"British Virgin Islands";i:44;s:6:"Brunei";i:45;s:8:"Bulgaria";i:46;s:12:"Burkina Faso";i:47;s:7:"Burundi";i:48;s:8:"Cambodia";i:49;s:8:"Cameroon";i:50;s:14:"Canary Islands";i:51;s:10:"Cape Verde";i:52;s:14:"Cayman Islands";i:53;s:24:"Central African Republic";i:54;s:4:"Chad";i:55;s:5:"Chile";i:56;s:5:"China";i:57;s:16:"Christmas Island";i:58;s:13:"Cocos Islands";i:59;s:8:"Colombia";i:60;s:7:"Comoros";i:61;s:17:"Congo-Brazzaville";i:62;s:14:"Congo-Kinshasa";i:63;s:12:"Cook Islands";i:64;s:17:"Coral Sea Islands";i:65;s:10:"Costa Rica";i:66;s:12:"Cote DIvoire";i:67;s:7:"Croatia";i:68;s:4:"Cuba";i:69;s:6:"Cyprus";i:70;s:14:"Czech Republic";i:71;s:7:"Denmark";i:72;s:8:"Djibouti";i:73;s:8:"Dominica";i:74;s:18:"Dominican Republic";i:75;s:5:"Dubai";i:76;s:10:"East Timor";i:77;s:7:"Ecuador";i:78;s:5:"Egypt";i:79;s:11:"El Salvador";i:80;s:7:"England";i:81;s:17:"Equatorial Guinea";i:82;s:7:"Eritrea";i:83;s:7:"Estonia";i:84;s:8:"Ethiopia";i:85;s:16:"Falkland Islands";i:86;s:13:"Faroe Islands";i:87;s:4:"Fiji";i:88;s:7:"Finland";i:89;s:6:"France";i:90;s:28:"French Guiana Independentist";i:91;s:13:"French Guiana";i:92;s:16:"French Polynesia";i:93;s:8:"Fujairah";i:94;s:5:"Gabon";i:95;s:6:"Gambia";i:96;s:7:"Georgia";i:97;s:7:"Germany";i:98;s:5:"Ghana";i:99;s:9:"Gibraltar";i:100;s:6:"Greece";i:101;s:9:"Greenland";i:102;s:7:"Grenada";i:103;s:10:"Guadeloupe";i:104;s:4:"Guam";i:105;s:9:"Guatemala";i:106;s:8:"Guernsey";i:107;s:13:"Guinea-Bissau";i:108;s:6:"Guinea";i:109;s:6:"Guyana";i:110;s:5:"Haiti";i:111;s:26:"Heard and McDonald Islands";i:112;s:8:"Honduras";i:113;s:9:"Hong Kong";i:114;s:7:"Hungary";i:115;s:7:"Iceland";i:116;s:5:"India";i:117;s:9:"Indonesia";i:118;s:4:"Iran";i:119;s:4:"Iraq";i:120;s:7:"Ireland";i:121;s:11:"Isle of Man";i:122;s:6:"Israel";i:123;s:5:"Italy";i:124;s:7:"Jamaica";i:125;s:5:"Japan";i:126;s:6:"Jersey";i:127;s:6:"Jordan";i:128;s:10:"Kazakhstan";i:129;s:5:"Kenya";i:130;s:8:"Kiribati";i:131;s:6:"Kuwait";i:132;s:10:"Kyrgyzstan";i:133;s:4:"Laos";i:134;s:6:"Latvia";i:135;s:7:"Lebanon";i:136;s:7:"Lesotho";i:137;s:7:"Liberia";i:138;s:5:"Libya";i:139;s:13:"Liechtenstein";i:140;s:9:"Lithuania";i:141;s:16:"Lord Howe Island";i:142;s:10:"Luxembourg";i:143;s:5:"Macao";i:144;s:9:"Macedonia";i:145;s:10:"Madagascar";i:146;s:7:"Madeira";i:147;s:6:"Malawi";i:148;s:8:"Malaysia";i:149;s:8:"Maldives";i:150;s:4:"Mali";i:151;s:5:"Malta";i:152;s:16:"Marshall Islands";i:153;s:10:"Martinique";i:154;s:10:"Mauritania";i:155;s:9:"Mauritius";i:156;s:7:"Mayotte";i:157;s:6:"Mexico";i:158;s:10:"Micronesia";i:159;s:14:"Midway Islands";i:160;s:7:"Moldova";i:161;s:6:"Monaco";i:162;s:8:"Mongolia";i:163;s:10:"Montenegro";i:164;s:10:"Montserrat";i:165;s:7:"Morocco";i:166;s:10:"Mozambique";i:167;s:7:"Myanmar";i:168;s:7:"Namibia";i:169;s:5:"Nauru";i:170;s:5:"Nepal";i:171;s:20:"Netherlands Antilles";i:172;s:11:"Netherlands";i:173;s:13:"New Caledonia";i:174;s:17:"New Zealand-Maori";i:175;s:11:"New Zealand";i:176;s:9:"Nicaragua";i:177;s:5:"Niger";i:178;s:7:"Nigeria";i:179;s:4:"Niue";i:180;s:14:"Norfolk Island";i:181;s:11:"North Korea";i:182;s:15:"Northern Cyprus";i:183;s:16:"Northern Ireland";i:184;s:17:"Northern Marianas";i:185;s:6:"Norway";i:186;s:4:"Oman";i:187;s:14:"Orkney Islands";i:188;s:8:"Pakistan";i:189;s:5:"Palau";i:190;s:9:"Palestine";i:191;s:6:"Panama";i:192;s:16:"Papua New Guinea";i:193;s:8:"Paraguay";i:194;s:4:"Peru";i:195;s:10:"Philippine";i:196;s:16:"Pitcairn Islands";i:197;s:6:"Poland";i:198;s:8:"Portugal";i:199;s:11:"Puerto Rico";i:200;s:5:"Qatar";i:201;s:14:"Ras al-Khaimah";i:202;s:7:"Reunion";i:203;s:7:"Romania";i:204;s:18:"Russian Federation";i:205;s:6:"Rwanda";i:206;s:4:"Sami";i:207;s:5:"Samoa";i:208;s:10:"San Marino";i:209;s:19:"Sao Tome e Principe";i:210;s:4:"Sark";i:211;s:12:"Saudi Arabia";i:212;s:8:"Scotland";i:213;s:7:"Seborga";i:214;s:7:"Senegal";i:215;s:6:"Serbia";i:216;s:10:"Seychelles";i:217;s:7:"Sharjah";i:218;s:16:"Shetland Islands";i:219;s:12:"Sierra Leone";i:220;s:6:"Sikkim";i:221;s:9:"Singapore";i:222;s:8:"Slovakia";i:223;s:8:"Slovenia";i:224;s:15:"Solomon Islands";i:225;s:7:"Somalia";i:226;s:10:"Somaliland";i:227;s:12:"South Africa";i:228;s:11:"South Korea";i:229;s:5:"Spain";i:230;s:9:"Sri Lanka";i:231;s:9:"St Helena";i:232;s:18:"St Kitts and Nevis";i:233;s:8:"St Lucia";i:234;s:22:"St Pierre and Miquelon";i:235;s:29:"St Vincent and the Grenadines";i:236;s:5:"Sudan";i:237;s:8:"Suriname";i:238;s:9:"Swaziland";i:239;s:6:"Sweden";i:240;s:11:"Switzerland";i:241;s:5:"Syria";i:242;s:6:"Tahiti";i:243;s:6:"Taiwan";i:244;s:9:"Tajikstan";i:245;s:8:"Tanzania";i:246;s:8:"Thailand";i:247;s:5:"Tibet";i:248;s:4:"Togo";i:249;s:7:"Tokelau";i:250;s:5:"Tonga";i:251;s:19:"Trinidad and Tobago";i:252;s:8:"Tromelin";i:253;s:7:"Tunisia";i:254;s:6:"Turkey";i:255;s:12:"Turkmenistan";i:256;s:6:"Tuvalu";i:257;s:17:"US Virgin Islands";i:258;s:6:"Uganda";i:259;s:7:"Ukraine";i:260;s:13:"Umm al-Qaiwan";i:261;s:14:"United Kingdom";i:262;s:14:"United Nations";i:263;s:7:"Uruguay";i:264;s:10:"Uzbekistan";i:265;s:7:"Vanuatu";i:266;s:18:"Vatican City State";i:267;s:9:"Venezuela";i:268;s:11:"Wake Island";i:269;s:5:"Wales";i:270;s:19:"Wallis & Futuna";i:271;s:14:"Western Sahara";i:272;s:5:"Yemen";i:273;s:10:"Yugoslavia";i:274;s:6:"Zambia";i:275;s:8:"Zimbabwe";}', 0, 2, 0, 1, 1, '', 0, 0, 0, 0), (10, 1, 0, 100, 25, 21, 1, 'select', 'a:47:{i:0;s:4:"2010";i:1;s:4:"2009";i:2;s:4:"2008";i:3;s:4:"2007";i:4;s:4:"2006";i:5;s:4:"2005";i:6;s:4:"2004";i:7;s:4:"2003";i:8;s:4:"2002";i:9;s:4:"2001";i:10;s:4:"2000";i:11;s:4:"1999";i:12;s:4:"1998";i:13;s:4:"1997";i:14;s:4:"1996";i:15;s:4:"1995";i:16;s:4:"1994";i:17;s:4:"1993";i:18;s:4:"1992";i:19;s:4:"1991";i:20;s:4:"1990";i:21;s:4:"1989";i:22;s:4:"1988";i:23;s:4:"1987";i:24;s:4:"1986";i:25;s:4:"1985";i:26;s:4:"1984";i:27;s:4:"1983";i:28;s:4:"1982";i:29;s:4:"1981";i:30;s:4:"1980";i:31;s:4:"1979";i:32;s:4:"1978";i:33;s:4:"1977";i:34;s:4:"1976";i:35;s:4:"1975";i:36;s:4:"1974";i:37;s:4:"1973";i:38;s:4:"1972";i:39;s:4:"1971";i:40;s:4:"1970";i:41;s:4:"1969";i:42;s:4:"1968";i:43;s:4:"1967";i:44;s:4:"1966";i:45;s:4:"1965";i:46;s:8:"1964 1/2";}', 0, 1, 0, 1, 1, '', 0, 0, 0, 0), (11, 1, 0, 100, 25, 22, 1, 'select', 'a:62:{i:0;s:8:"V6 Coupe";i:1;s:14:"V6 Convertible";i:2;s:8:"LX Coupe";i:3;s:14:"LX Convertible";i:4;s:8:"LX Hatch";i:5;s:8:"GT Coupe";i:6;s:14:"GT Convertible";i:7;s:8:"GT Hatch";i:8;s:3:"GTS";i:9;s:25:"GT Coupe 35th Anniversary";i:10;s:31:"GT Convertible 35th Anniversary";i:11;s:15:"GLX Convertible";i:12;s:15:"SVT Cobra Coupe";i:13;s:15:"SVT Cobra Hatch";i:14;s:21:"SVT Cobra Convertible";i:15;s:33:"SVT Cobra Convertible w/ Hard top";i:16;s:32:"SVT Cobra Coupe 10th Anniversary";i:17;s:38:"SVT Cobra Convertible 10th Anniversary";i:18;s:3:"SVO";i:19;s:0:"";i:20;s:13:"Shelby GT-500";i:21;s:11:"Shelby GT-H";i:22;s:9:"Shelby GT";i:23;s:0:"";i:24;s:7:"Bullitt";i:25;s:6:"Mach 1";i:26;s:0:"";i:27;s:21:"Centennial Edition GT";i:28;s:33:"Centennial Edition GT Convertible";i:29;s:0:"";i:30;s:16:"I6 Classic Coupe";i:31;s:22:"I6 Classic Convertible";i:32;s:16:"V8 Classic Coupe";i:33;s:19:"V8 Classic Fastback";i:34;s:22:"V8 Classic Convertible";i:35;s:8:"Cobra II";i:36;s:18:"California Special";i:37;s:6:"Sprint";i:38;s:0:"";i:39;s:19:"Roush Stage 1 Coupe";i:40;s:25:"Roush Stage 1 Convertible";i:41;s:19:"Roush Stage 2 Coupe";i:42;s:25:"Roush Stage 2 Convertible";i:43;s:19:"Roush Stage 3 Coupe";i:44;s:25:"Roush Stage 3 Convertible";i:45;s:5:"Roush";i:46;s:0:"";i:47;s:10:"Saleen 281";i:48;s:13:"Saleen 281 SC";i:49;s:25:"Saleen 281 SC Convertible";i:50;s:13:"Saleen 351 SC";i:51;s:25:"Saleen 351 SC Convertible";i:52;s:9:"Saleen SA";i:53;s:6:"Saleen";i:54;s:18:"Saleen Convertible";i:55;s:0:"";i:56;s:11:"Steeda Q400";i:57;s:6:"Steeda";i:58;s:0:"";i:59;s:8:"Maclaren";i:60;s:0:"";i:61;s:5:"Other";}', 0, 1, 0, 1, 1, '', 0, 0, 0, 0), (12, 2, 0, 100, 25, 23, 1, 'input', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (50, 0, 0, 20, 20, 50, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (51, 0, 0, 6, 6, 57, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (52, 0, 0, 5, 5, 58, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (53, 0, 0, 6, 6, 59, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (54, 0, 0, 6, 6, 60, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (55, 0, 0, 6, 6, 61, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (56, 0, 0, 6, 6, 62, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (57, 0, 0, 100, 25, 65, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (58, 0, 0, 10, 10, 56, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (59, 0, 0, 7, 7, 63, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (60, 0, 0, 35, 25, 64, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (61, 0, 0, 20, 20, 51, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (62, 0, 0, 70, 25, 53, 1, 'input', '', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (63, 0, 0, 15, 15, 54, 1, 'select', 'a:3:{i:0;s:6:"Manual";i:1;s:9:"Automatic";i:2;s:6:"Hybrid";}', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (64, 0, 0, 15, 15, 55, 1, 'select', 'a:4:{i:0;s:14:"Street Radials";i:1;s:12:"Drag Radials";i:2;s:10:"DOT Slicks";i:3;s:6:"Slicks";}', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (65, 0, 0, 15, 15, 52, 1, 'select', 'a:6:{i:0;s:3:"N/A";i:1;s:5:"Turbo";i:2;s:3:"S/C";i:3;s:7:"Nitrous";i:4;s:15:"Turbo + Nitrous";i:5;s:13:"S/C + Nitrous";}', 0, 0, 0, 0, 0, '0', 0, 0, 0, 0), (66, 1, 0, 100, 25, 3, 2, 'input', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (67, 2, 0, 10, 25, 33, 1, 'input', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (68, 2, 0, 100, 25, 25, 1, 'input', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (69, 2, 0, 100, 25, 26, 1, 'textarea', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (70, 2, 0, 100, 25, 27, 1, 'textarea', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (79, 0, 0, 100, 25, 4, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (85, 0, 0, 550, 70, 42, 1, 'textarea', '', 10, 0, 0, 0, 0, '', 0, 0, 0, 0), (78, 1, 0, 100, 25, 20, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (77, 0, 0, 100, 25, 10, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (96, 0, 0, 100, 25, 43, 1, 'input', 'http://', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (83, 1, 0, 100, 25, 41, 1, 'select', 'a:3:{i:0;s:11:"Undisclosed";i:1;s:4:"Male";i:2;s:6:"Female";}', 0, 2, 0, 1, 1, '', 0, 0, 0, 0), (87, 2, 0, 50, 25, 43, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (89, 1, 0, 100, 25, 7, 1, 'select', 'a:62:{i:0;s:7:"Alabama";i:1;s:6:"Alaska";i:2;s:7:"Arizona";i:3;s:8:"Arkansas";i:4;s:10:"California";i:5;s:8:"Colorado";i:6;s:11:"Connecticut";i:7;s:8:"Delaware";i:8;s:20:"District of Columbia";i:9;s:7:"Florida";i:10;s:7:"Georgia";i:11;s:6:"Hawaii";i:12;s:5:"Idaho";i:13;s:8:"Illinois";i:14;s:7:"Indiana";i:15;s:4:"Iowa";i:16;s:6:"Kansas";i:17;s:8:"Kentucky";i:18;s:9:"Louisiana";i:19;s:5:"Maine";i:20;s:8:"Maryland";i:21;s:13:"Massachusetts";i:22;s:8:"Michigan";i:23;s:9:"Minnesota";i:24;s:11:"Mississippi";i:25;s:8:"Missouri";i:26;s:7:"Montana";i:27;s:8:"Nebraska";i:28;s:6:"Nevada";i:29;s:13:"New Hampshire";i:30;s:10:"New Jersey";i:31;s:10:"New Mexico";i:32;s:8:"New York";i:33;s:14:"North Carolina";i:34;s:12:"North Dakota";i:35;s:4:"Ohio";i:36;s:8:"Oklahoma";i:37;s:6:"Oregon";i:38;s:12:"Pennsylvania";i:39;s:12:"Rhode Island";i:40;s:14:"South Carolina";i:41;s:12:"South Dakota";i:42;s:9:"Tennessee";i:43;s:5:"Texas";i:44;s:4:"Utah";i:45;s:7:"Vermont";i:46;s:8:"Virginia";i:47;s:10:"Washington";i:48;s:13:"West Virginia";i:49;s:9:"Wisconsin";i:50;s:7:"Wyoming";i:51;s:0:"";i:52;s:7:"Alberta";i:53;s:16:"British Columbia";i:54;s:8:"Manitoba";i:55;s:13:"New Brunswick";i:56;s:25:"Newfoundland and Labrador";i:57;s:11:"Nova Scotia";i:58;s:7:"Ontario";i:59;s:20:"Prince Edward Island";i:60;s:6:"Quebec";i:61;s:12:"Saskatchewan";}', 0, 1, 0, 1, 1, '', 0, 0, 0, 0), (90, 2, 0, 0, 0, 46, 1, 'input', 'http://', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (92, 0, 0, 0, 0, 48, 1, 'input', 'http://', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (93, 0, 1, 100, 25, 49, 0, 'input', '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0), (98, 0, 0, 100, 25, 44, 1, 'input', 'http://', 0, 0, 0, 1, 1, '', 0, 0, 0, 0), (99, 2, 0, 100, 25, 45, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0, 0);