I only want to search using company, position and country for now.
Code: Select all
<?php
$sql = array (
0 => 'Database worktest running on localhost
CREATE TABLE `company` (
`companyid` varchar(255) NOT NULL default \'\',
`type` int(11) default \'0\',
`name` varchar(255) default NULL,
`country` int(11) default \'0\',
`address` varchar(255) default NULL,
`suburb` varchar(255) default NULL,
`state` varchar(255) default NULL,
`postcode` varchar(255) default NULL,
`phone` varchar(255) default NULL,
`fax` varchar(255) default NULL,
`email` varchar(255) default NULL,
`url` varchar(255) default NULL,
`industry` int(11) default \'0\',
`description` varchar(255) default NULL,
`adlocs` varchar(255) default NULL,
`workexp` tinyint(1) default NULL,
`recruitcomp` varchar(255) default NULL,
`employees` varchar(255) default NULL,
PRIMARY KEY (`companyid`),
KEY `postcode` (`postcode`),
KEY `Reference` (`type`),
KEY `Reference1` (`country`),
KEY `Reference2` (`industry`),
CONSTRAINT `Reference` FOREIGN KEY (`type`) REFERENCES `reg_type` (`typeid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `Reference1` FOREIGN KEY (`country`) REFERENCES `countries` (`countryid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `Reference2` FOREIGN KEY (`industry`) REFERENCES `industries` (`industryid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8',
1 => 'CREATE TABLE `countries` (
`countryid` int(11) NOT NULL auto_increment,
`iso_code` varchar(255) default NULL,
`country` varchar(255) default NULL,
PRIMARY KEY (`countryid`),
KEY `Code` (`iso_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=246',
2 => 'INSERT INTO `countries` VALUES (1, \'AF\', \'Afghanistan\')',
3 => 'INSERT INTO `countries` VALUES (2, \'AL\', \'Albania\')',
4 => 'INSERT INTO `countries` VALUES (3, \'DZ\', \'Algeria\')',
5 => 'INSERT INTO `countries` VALUES (4, \'AS\', \'American Samoa\')',
6 => 'INSERT INTO `countries` VALUES (5, \'AD\', \'Andorra\')',
7 => 'INSERT INTO `countries` VALUES (6, \'AO\', \'Angola\')',
8 => 'INSERT INTO `countries` VALUES (7, \'AI\', \'Anguilla\')',
9 => 'INSERT INTO `countries` VALUES (8, \'AQ\', \'Antarctica\')',
10 => 'INSERT INTO `countries` VALUES (9, \'AG\', \'Antigua and Barbuda\')',
11 => 'INSERT INTO `countries` VALUES (10, \'AR\', \'Argentina\')',
12 => 'INSERT INTO `countries` VALUES (11, \'AM\', \'Armenia\')',
13 => 'INSERT INTO `countries` VALUES (12, \'AW\', \'Aruba\')',
14 => 'INSERT INTO `countries` VALUES (13, \'AU\', \'Australia\')',
15 => 'INSERT INTO `countries` VALUES (14, \'AT\', \'Austria\')',
16 => 'INSERT INTO `countries` VALUES (15, \'AZ\', \'Azerbaijan\')',
17 => 'INSERT INTO `countries` VALUES (16, \'BS\', \'Bahamas\')',
18 => 'INSERT INTO `countries` VALUES (17, \'BH\', \'Bahrain\')',
19 => 'INSERT INTO `countries` VALUES (18, \'BB\', \'Barbados\')',
20 => 'INSERT INTO `countries` VALUES (19, \'BD\', \'Bangladesh\')',
21 => 'INSERT INTO `countries` VALUES (20, \'BY\', \'Belarus\')',
22 => 'INSERT INTO `countries` VALUES (21, \'BE\', \'Belgium\')',
23 => 'INSERT INTO `countries` VALUES (22, \'BZ\', \'Belize\')',
24 => 'INSERT INTO `countries` VALUES (23, \'BJ\', \'Benin\')',
25 => 'INSERT INTO `countries` VALUES (24, \'BM\', \'Bermuda\')',
26 => 'INSERT INTO `countries` VALUES (25, \'BS\', \'Bahamas\')',
27 => 'INSERT INTO `countries` VALUES (26, \'BT\', \'Bhutan\')',
28 => 'INSERT INTO `countries` VALUES (27, \'BW\', \'Botswana\')',
29 => 'INSERT INTO `countries` VALUES (28, \'BO\', \'Bolivia\')',
30 => 'INSERT INTO `countries` VALUES (29, \'BA\', \'Bosnia and Herzegovina\')',
31 => 'INSERT INTO `countries` VALUES (30, \'BV\', \'Bouvet Island\')',
32 => 'INSERT INTO `countries` VALUES (31, \'BR\', \'Brazil\')',
33 => 'INSERT INTO `countries` VALUES (32, \'IO\', \'British Indian Ocean Territory\')',
34 => 'INSERT INTO `countries` VALUES (33, \'BN\', \'Brunei Darussalam\')',
35 => 'INSERT INTO `countries` VALUES (34, \'BG\', \'Bulgaria\')',
36 => 'INSERT INTO `countries` VALUES (35, \'BF\', \'Burkina Faso\')',
37 => 'INSERT INTO `countries` VALUES (36, \'BI\', \'Burundi\')',
38 => 'INSERT INTO `countries` VALUES (37, \'KH\', \'Cambodia\')',
39 => 'INSERT INTO `countries` VALUES (38, \'CM\', \'Cameroon\')',
40 => 'INSERT INTO `countries` VALUES (39, \'CA\', \'Canada\')',
41 => 'INSERT INTO `countries` VALUES (40, \'CV\', \'Cape Verde\')',
42 => 'INSERT INTO `countries` VALUES (41, \'KY\', \'Cayman Islands\')',
43 => 'INSERT INTO `countries` VALUES (42, \'CF\', \'Central African Republic\')',
44 => 'INSERT INTO `countries` VALUES (43, \'TD\', \'Chad\')',
45 => 'INSERT INTO `countries` VALUES (44, \'CL\', \'Chile\')',
46 => 'INSERT INTO `countries` VALUES (45, \'CN\', \'China\')',
47 => 'INSERT INTO `countries` VALUES (46, \'CX\', \'Christmas Island\')',
48 => 'INSERT INTO `countries` VALUES (47, \'CC\', \'Cocos (Keeling) Islands\')',
49 => 'INSERT INTO `countries` VALUES (48, \'CO\', \'Colombia\')',
50 => 'INSERT INTO `countries` VALUES (49, \'KM\', \'Comoros\')',
51 => 'INSERT INTO `countries` VALUES (50, \'CG\', \'Congo\')',
52 => 'INSERT INTO `countries` VALUES (51, \'CD\', \'Congo, Democratic Republic\')',
53 => 'INSERT INTO `countries` VALUES (52, \'CK\', \'Cook Islands\')',
54 => 'INSERT INTO `countries` VALUES (53, \'CR\', \'Costa Rica\')',
55 => 'INSERT INTO `countries` VALUES (55, \'HR\', \'Croatia (Hrvatska)\')',
56 => 'INSERT INTO `countries` VALUES (56, \'CU\', \'Cuba\')',
57 => 'INSERT INTO `countries` VALUES (57, \'CY\', \'Cyprus\')',
58 => 'INSERT INTO `countries` VALUES (58, \'CZ\', \'Czech Republic\')',
59 => 'INSERT INTO `countries` VALUES (59, \'CS\', \'Czechoslovakia (former)\')',
60 => 'INSERT INTO `countries` VALUES (60, \'DK\', \'Denmark\')',
61 => 'INSERT INTO `countries` VALUES (61, \'DJ\', \'Djibouti\')',
62 => 'INSERT INTO `countries` VALUES (62, \'DM\', \'Dominica\')',
63 => 'INSERT INTO `countries` VALUES (63, \'DO\', \'Dominican Republic\')',
64 => 'INSERT INTO `countries` VALUES (64, \'TP\', \'East Timor\')',
65 => 'INSERT INTO `countries` VALUES (65, \'EC\', \'Ecuador\')',
66 => 'INSERT INTO `countries` VALUES (66, \'EG\', \'Egypt\')',
67 => 'INSERT INTO `countries` VALUES (67, \'SV\', \'El Salvador\')',
68 => 'INSERT INTO `countries` VALUES (68, \'GQ\', \'Equatorial Guinea\')',
69 => 'INSERT INTO `countries` VALUES (69, \'ER\', \'Eritrea\')',
70 => 'INSERT INTO `countries` VALUES (70, \'EE\', \'Estonia\')',
71 => 'INSERT INTO `countries` VALUES (71, \'ET\', \'Ethiopia\')',
72 => 'INSERT INTO `countries` VALUES (72, \'FK\', \'Falkland Islands (Malvinas)\')',
73 => 'INSERT INTO `countries` VALUES (73, \'FO\', \'Faroe Islands\')',
74 => 'INSERT INTO `countries` VALUES (74, \'FJ\', \'Fiji\')',
75 => 'INSERT INTO `countries` VALUES (75, \'FI\', \'Finland\')',
76 => 'INSERT INTO `countries` VALUES (76, \'FR\', \'France\')',
77 => 'INSERT INTO `countries` VALUES (77, \'FX\', \'France, Metropolitan\')',
78 => 'INSERT INTO `countries` VALUES (78, \'GF\', \'French Guiana\')',
79 => 'INSERT INTO `countries` VALUES (79, \'PF\', \'French Polynesia\')',
80 => 'INSERT INTO `countries` VALUES (80, \'TF\', \'French Southern Territories\')',
81 => 'INSERT INTO `countries` VALUES (81, \'MK\', \'F.Y.R.O.M. (Macedonia)\')',
82 => 'INSERT INTO `countries` VALUES (82, \'GA\', \'Gabon\')',
83 => 'INSERT INTO `countries` VALUES (83, \'GM\', \'Gambia\')',
84 => 'INSERT INTO `countries` VALUES (84, \'GE\', \'Georgia\')',
85 => 'INSERT INTO `countries` VALUES (85, \'DE\', \'Germany\')',
86 => 'INSERT INTO `countries` VALUES (86, \'GH\', \'Ghana\')',
87 => 'INSERT INTO `countries` VALUES (87, \'GI\', \'Gibraltar\')',
88 => 'INSERT INTO `countries` VALUES (88, \'GB\', \'Great Britain (UK)\')',
89 => 'INSERT INTO `countries` VALUES (89, \'GR\', \'Greece\')',
90 => 'INSERT INTO `countries` VALUES (90, \'GL\', \'Greenland\')',
91 => 'INSERT INTO `countries` VALUES (91, \'GD\', \'Grenada\')',
92 => 'INSERT INTO `countries` VALUES (92, \'GP\', \'Guadeloupe\')',
93 => 'INSERT INTO `countries` VALUES (93, \'GU\', \'Guam\')',
94 => 'INSERT INTO `countries` VALUES (94, \'GT\', \'Guatemala\')',
95 => 'INSERT INTO `countries` VALUES (95, \'GN\', \'Guinea\')',
96 => 'INSERT INTO `countries` VALUES (96, \'GW\', \'Guinea-Bissau\')',
97 => 'INSERT INTO `countries` VALUES (97, \'GY\', \'Guyana\')',
98 => 'INSERT INTO `countries` VALUES (98, \'HT\', \'Haiti\')',
99 => 'INSERT INTO `countries` VALUES (99, \'HM\', \'Heard and McDonald Islands\')',
100 => 'INSERT INTO `countries` VALUES (100, \'HN\', \'Honduras\')',
101 => 'INSERT INTO `countries` VALUES (101, \'HK\', \'Hong Kong\')',
102 => 'INSERT INTO `countries` VALUES (102, \'HU\', \'Hungary\')',
103 => 'INSERT INTO `countries` VALUES (103, \'IS\', \'Iceland\')',
104 => 'INSERT INTO `countries` VALUES (104, \'IN\', \'India\')',
105 => 'INSERT INTO `countries` VALUES (105, \'ID\', \'Indonesia\')',
106 => 'INSERT INTO `countries` VALUES (106, \'IR\', \'Iran\')',
107 => 'INSERT INTO `countries` VALUES (107, \'IQ\', \'Iraq\')',
108 => 'INSERT INTO `countries` VALUES (108, \'IE\', \'Ireland\')',
109 => 'INSERT INTO `countries` VALUES (109, \'IL\', \'Israel\')',
110 => 'INSERT INTO `countries` VALUES (110, \'IT\', \'Italy\')',
111 => 'INSERT INTO `countries` VALUES (111, \'JM\', \'Jamaica\')',
112 => 'INSERT INTO `countries` VALUES (112, \'JP\', \'Japan\')',
113 => 'INSERT INTO `countries` VALUES (113, \'JO\', \'Jordan\')',
114 => 'INSERT INTO `countries` VALUES (114, \'KZ\', \'Kazakhstan\')',
115 => 'INSERT INTO `countries` VALUES (115, \'KE\', \'Kenya\')',
116 => 'INSERT INTO `countries` VALUES (116, \'KI\', \'Kiribati\')',
117 => 'INSERT INTO `countries` VALUES (117, \'KP\', \'Korea (North)\')',
118 => 'INSERT INTO `countries` VALUES (118, \'KR\', \'Korea (South)\')',
119 => 'INSERT INTO `countries` VALUES (119, \'KW\', \'Kuwait\')',
120 => 'INSERT INTO `countries` VALUES (120, \'KG\', \'Kyrgyzstan\')',
121 => 'INSERT INTO `countries` VALUES (121, \'LA\', \'Laos\')',
122 => 'INSERT INTO `countries` VALUES (122, \'LV\', \'Latvia\')',
123 => 'INSERT INTO `countries` VALUES (123, \'LB\', \'Lebanon\')',
124 => 'INSERT INTO `countries` VALUES (124, \'LI\', \'Liechtenstein\')',
125 => 'INSERT INTO `countries` VALUES (125, \'LR\', \'Liberia\')',
126 => 'INSERT INTO `countries` VALUES (126, \'LY\', \'Libya\')',
127 => 'INSERT INTO `countries` VALUES (127, \'LS\', \'Lesotho\')',
128 => 'INSERT INTO `countries` VALUES (128, \'LT\', \'Lithuania\')',
129 => 'INSERT INTO `countries` VALUES (129, \'LU\', \'Luxembourg\')',
130 => 'INSERT INTO `countries` VALUES (130, \'MO\', \'Macau\')',
131 => 'INSERT INTO `countries` VALUES (131, \'MG\', \'Madagascar\')',
132 => 'INSERT INTO `countries` VALUES (132, \'MW\', \'Malawi\')',
133 => 'INSERT INTO `countries` VALUES (133, \'MY\', \'Malaysia\')',
134 => 'INSERT INTO `countries` VALUES (134, \'MV\', \'Maldives\')',
135 => 'INSERT INTO `countries` VALUES (135, \'ML\', \'Mali\')',
136 => 'INSERT INTO `countries` VALUES (136, \'MT\', \'Malta\')',
137 => 'INSERT INTO `countries` VALUES (137, \'MH\', \'Marshall Islands\')',
138 => 'INSERT INTO `countries` VALUES (138, \'MQ\', \'Martinique\')',
139 => 'INSERT INTO `countries` VALUES (139, \'MR\', \'Mauritania\')',
140 => 'INSERT INTO `countries` VALUES (140, \'MU\', \'Mauritius\')',
141 => 'INSERT INTO `countries` VALUES (141, \'YT\', \'Mayotte\')',
142 => 'INSERT INTO `countries` VALUES (142, \'MX\', \'Mexico\')',
143 => 'INSERT INTO `countries` VALUES (143, \'FM\', \'Micronesia\')',
144 => 'INSERT INTO `countries` VALUES (144, \'MC\', \'Monaco\')',
145 => 'INSERT INTO `countries` VALUES (145, \'MD\', \'Moldova\')',
146 => 'INSERT INTO `countries` VALUES (146, \'MA\', \'Morocco\')',
147 => 'INSERT INTO `countries` VALUES (147, \'MN\', \'Mongolia\')',
148 => 'INSERT INTO `countries` VALUES (148, \'MS\', \'Montserrat\')',
149 => 'INSERT INTO `countries` VALUES (149, \'MZ\', \'Mozambique\')',
150 => 'INSERT INTO `countries` VALUES (150, \'MM\', \'Myanmar\')',
151 => 'INSERT INTO `countries` VALUES (151, \'NA\', \'Namibia\')',
152 => 'INSERT INTO `countries` VALUES (152, \'NR\', \'Nauru\')',
153 => 'INSERT INTO `countries` VALUES (153, \'NP\', \'Nepal\')',
154 => 'INSERT INTO `countries` VALUES (154, \'NL\', \'Netherlands\')',
155 => 'INSERT INTO `countries` VALUES (155, \'AN\', \'Netherlands Antilles\')',
156 => 'INSERT INTO `countries` VALUES (156, \'NT\', \'Neutral Zone\')',
157 => 'INSERT INTO `countries` VALUES (157, \'NC\', \'New Caledonia\')',
158 => 'INSERT INTO `countries` VALUES (158, \'NZ\', \'New Zealand (Aotearoa)\')',
159 => 'INSERT INTO `countries` VALUES (159, \'NI\', \'Nicaragua\')',
160 => 'INSERT INTO `countries` VALUES (160, \'NE\', \'Niger\')',
161 => 'INSERT INTO `countries` VALUES (161, \'NG\', \'Nigeria\')',
162 => 'INSERT INTO `countries` VALUES (162, \'NU\', \'Niue\')',
163 => 'INSERT INTO `countries` VALUES (163, \'NF\', \'Norfolk Island\')',
164 => 'INSERT INTO `countries` VALUES (164, \'MP\', \'Northern Mariana Islands\')',
165 => 'INSERT INTO `countries` VALUES (165, \'NO\', \'Norway\')',
166 => 'INSERT INTO `countries` VALUES (166, \'OM\', \'Oman\')',
167 => 'INSERT INTO `countries` VALUES (167, \'PK\', \'Pakistan\')',
168 => 'INSERT INTO `countries` VALUES (168, \'PW\', \'Palau\')',
169 => 'INSERT INTO `countries` VALUES (169, \'PA\', \'Panama\')',
170 => 'INSERT INTO `countries` VALUES (170, \'PG\', \'Papua New Guinea\')',
171 => 'INSERT INTO `countries` VALUES (171, \'PY\', \'Paraguay\')',
172 => 'INSERT INTO `countries` VALUES (172, \'PE\', \'Peru\')',
173 => 'INSERT INTO `countries` VALUES (173, \'PH\', \'Philippines\')',
174 => 'INSERT INTO `countries` VALUES (174, \'PN\', \'Pitcairn\')',
175 => 'INSERT INTO `countries` VALUES (175, \'PL\', \'Poland\')',
176 => 'INSERT INTO `countries` VALUES (176, \'PT\', \'Portugal\')',
177 => 'INSERT INTO `countries` VALUES (177, \'PR\', \'Puerto Rico\')',
178 => 'INSERT INTO `countries` VALUES (178, \'QA\', \'Qatar\')',
179 => 'INSERT INTO `countries` VALUES (179, \'RE\', \'Reunion\')',
180 => 'INSERT INTO `countries` VALUES (180, \'RO\', \'Romania\')',
181 => 'INSERT INTO `countries` VALUES (181, \'RU\', \'Russian Federation\')',
182 => 'INSERT INTO `countries` VALUES (182, \'RW\', \'Rwanda\')',
183 => 'INSERT INTO `countries` VALUES (183, \'GS\', \'S. Georgia and S. Sandwich Isls.\')',
184 => 'INSERT INTO `countries` VALUES (184, \'KN\', \'Saint Kitts and Nevis\')',
185 => 'INSERT INTO `countries` VALUES (185, \'LC\', \'Saint Lucia\')',
186 => 'INSERT INTO `countries` VALUES (186, \'VC\', \'Saint Vincent & the Grenadines\')',
187 => 'INSERT INTO `countries` VALUES (187, \'WS\', \'Samoa\')',
188 => 'INSERT INTO `countries` VALUES (188, \'SM\', \'San Marino\')',
189 => 'INSERT INTO `countries` VALUES (189, \'ST\', \'Sao Tome and Principe\')',
190 => 'INSERT INTO `countries` VALUES (190, \'SA\', \'Saudi Arabia\')',
191 => 'INSERT INTO `countries` VALUES (191, \'SN\', \'Senegal\')',
192 => 'INSERT INTO `countries` VALUES (192, \'SC\', \'Seychelles\')',
193 => 'INSERT INTO `countries` VALUES (193, \'SL\', \'Sierra Leone\')',
194 => 'INSERT INTO `countries` VALUES (194, \'SG\', \'Singapore\')',
195 => 'INSERT INTO `countries` VALUES (195, \'SI\', \'Slovenia\')',
196 => 'INSERT INTO `countries` VALUES (196, \'SK\', \'Slovak Republic\')',
197 => 'INSERT INTO `countries` VALUES (197, \'SB\', \'Solomon Islands\')',
198 => 'INSERT INTO `countries` VALUES (198, \'SO\', \'Somalia\')',
199 => 'INSERT INTO `countries` VALUES (199, \'ZA\', \'South Africa\')',
200 => 'INSERT INTO `countries` VALUES (200, \'ES\', \'Spain\')',
201 => 'INSERT INTO `countries` VALUES (201, \'LK\', \'Sri Lanka\')',
202 => 'INSERT INTO `countries` VALUES (202, \'SH\', \'St. Helena\')',
203 => 'INSERT INTO `countries` VALUES (203, \'PM\', \'St. Pierre and Miquelon\')',
204 => 'INSERT INTO `countries` VALUES (204, \'SD\', \'Sudan\')',
205 => 'INSERT INTO `countries` VALUES (205, \'SR\', \'Suriname\')',
206 => 'INSERT INTO `countries` VALUES (206, \'SJ\', \'Svalbard & Jan Mayen Islands\')',
207 => 'INSERT INTO `countries` VALUES (207, \'SZ\', \'Swaziland\')',
208 => 'INSERT INTO `countries` VALUES (208, \'SE\', \'Sweden\')',
209 => 'INSERT INTO `countries` VALUES (209, \'CH\', \'Switzerland\')',
210 => 'INSERT INTO `countries` VALUES (210, \'SY\', \'Syria\')',
211 => 'INSERT INTO `countries` VALUES (211, \'TW\', \'Taiwan\')',
212 => 'INSERT INTO `countries` VALUES (212, \'TJ\', \'Tajikistan\')',
213 => 'INSERT INTO `countries` VALUES (213, \'TZ\', \'Tanzania\')',
214 => 'INSERT INTO `countries` VALUES (214, \'TH\', \'Thailand\')',
215 => 'INSERT INTO `countries` VALUES (215, \'TG\', \'Togo\')',
216 => 'INSERT INTO `countries` VALUES (216, \'TK\', \'Tokelau\')',
217 => 'INSERT INTO `countries` VALUES (217, \'TO\', \'Tonga\')',
218 => 'INSERT INTO `countries` VALUES (218, \'TT\', \'Trinidad and Tobago\')',
219 => 'INSERT INTO `countries` VALUES (219, \'TN\', \'Tunisia\')',
220 => 'INSERT INTO `countries` VALUES (220, \'TR\', \'Turkey\')',
221 => 'INSERT INTO `countries` VALUES (221, \'TM\', \'Turkmenistan\')',
222 => 'INSERT INTO `countries` VALUES (222, \'TC\', \'Turks and Caicos Islands\')',
223 => 'INSERT INTO `countries` VALUES (223, \'TV\', \'Tuvalu\')',
224 => 'INSERT INTO `countries` VALUES (224, \'UG\', \'Uganda\')',
225 => 'INSERT INTO `countries` VALUES (225, \'UA\', \'Ukraine\')',
226 => 'INSERT INTO `countries` VALUES (226, \'AE\', \'United Arab Emirates\')',
227 => 'INSERT INTO `countries` VALUES (227, \'UK\', \'United Kingdom\')',
228 => 'INSERT INTO `countries` VALUES (228, \'US\', \'United States\')',
229 => 'INSERT INTO `countries` VALUES (229, \'UM\', \'US Minor Outlying Islands\')',
230 => 'INSERT INTO `countries` VALUES (230, \'UY\', \'Uruguay\')',
231 => 'INSERT INTO `countries` VALUES (231, \'SU\', \'USSR (former)\')',
232 => 'INSERT INTO `countries` VALUES (232, \'UZ\', \'Uzbekistan\')',
233 => 'INSERT INTO `countries` VALUES (233, \'VU\', \'Vanuatu\')',
234 => 'INSERT INTO `countries` VALUES (234, \'VA\', \'Vatican City State (Holy See)\')',
235 => 'INSERT INTO `countries` VALUES (235, \'VE\', \'Venezuela\')',
236 => 'INSERT INTO `countries` VALUES (236, \'VN\', \'Viet Nam\')',
237 => 'INSERT INTO `countries` VALUES (237, \'VG\', \'Virgin Islands (British)\')',
238 => 'INSERT INTO `countries` VALUES (238, \'VI\', \'Virgin Islands (U.S.)\')',
239 => 'INSERT INTO `countries` VALUES (239, \'WF\', \'Wallis and Futuna Islands\')',
240 => 'INSERT INTO `countries` VALUES (240, \'EH\', \'Western Sahara\')',
241 => 'INSERT INTO `countries` VALUES (241, \'YE\', \'Yemen\')',
242 => 'INSERT INTO `countries` VALUES (242, \'YU\', \'Yugoslavia\')',
243 => 'INSERT INTO `countries` VALUES (243, \'ZM\', \'Zambia\')',
244 => 'INSERT INTO `countries` VALUES (244, \'(ZR\', \'Zaire)\')',
245 => 'INSERT INTO `countries` VALUES (245, \'ZW\', \'Zimbabwe\')',
246 => 'CREATE TABLE `course_titles` (
`coursetitleid` int(11) NOT NULL auto_increment,
`course_title` varchar(255) default NULL,
`type` varchar(255) default NULL,
`length` varchar(255) default NULL,
PRIMARY KEY (`coursetitleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=624',
247 => 'INSERT INTO `course_titles` VALUES (1, \'Advanced Diploma in Farm Management (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
248 => 'INSERT INTO `course_titles` VALUES (2, \'Advanced Diploma in Horticulture (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
249 => 'INSERT INTO `course_titles` VALUES (3, \'Advanced Diploma of Business (Agricultural Commerce)\\r\\n\\r\\n(orange)\', \'Advanced Diploma\', \'104 weeks\')',
250 => 'INSERT INTO `course_titles` VALUES (4, \'Advanced Diploma of Equine Business Management (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
251 => 'INSERT INTO `course_titles` VALUES (5, \'Advanced Diploma of Horicultural Management (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
252 => 'INSERT INTO `course_titles` VALUES (6, \'Advanced Diploma of Horticulture (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
253 => 'INSERT INTO `course_titles` VALUES (7, \'Advanced Diploma of Land Management (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
254 => 'INSERT INTO `course_titles` VALUES (8, \'Advanced Diploma of Management (Orange)\', \'Advanced Diploma\', \'104 \\r\\n\\r\\nweeks\')',
255 => 'INSERT INTO `course_titles` VALUES (9, \'Advanced Diploma of Rural Business Administration (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
256 => 'INSERT INTO `course_titles` VALUES (10, \'Advanced Diploma of Viticultural Managemnent (Orange)\', \'Advanced \\r\\n\\r\\nDiploma\', \'104 weeks\')',
257 => 'INSERT INTO `course_titles` VALUES (11, \'Associate Degree (Ministry)\', \'Associate Degree\', \'104 weeks\')',
258 => 'INSERT INTO `course_titles` VALUES (12, \'Bach of Health Science (Aborig Health & Comm Devel) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
259 => 'INSERT INTO `course_titles` VALUES (13, \'Bachelor Health Science & Master Rehabilitation \\r\\n\\r\\nCounselling\', \'Bachelor Degree\', \'208 weeks\')',
260 => 'INSERT INTO `course_titles` VALUES (14, \'Bachelor of Accounting\', \'Masters Degree (Coursework)\', \'104 weeks\')',
261 => 'INSERT INTO `course_titles` VALUES (15, \'Bachelor of Agricultural Economics\', \'Bachelor Degree\', \'208 weeks\')',
262 => 'INSERT INTO `course_titles` VALUES (16, \'Bachelor of Animal and Veterinary Bioscience\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
263 => 'INSERT INTO `course_titles` VALUES (17, \'Bachelor of Animal Science\', \'Bachelor Degree\', \'208 weeks\')',
264 => 'INSERT INTO `course_titles` VALUES (18, \'Bachelor of Applied Geographical Information Systems\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
265 => 'INSERT INTO `course_titles` VALUES (19, \'Bachelor of Applied Geographical Information Systems \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'52 weeks\')',
266 => 'INSERT INTO `course_titles` VALUES (20, \'Bachelor of Applied Geospatial and Information Technology\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
267 => 'INSERT INTO `course_titles` VALUES (21, \'Bachelor of Applied Geospatial and Information Technology\\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'52 weeks\')',
268 => 'INSERT INTO `course_titles` VALUES (22, \'Bachelor of Applied Science (Disability Studies)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
269 => 'INSERT INTO `course_titles` VALUES (23, \'Bachelor of Applied Science (Disability Studies) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
270 => 'INSERT INTO `course_titles` VALUES (24, \'Bachelor of Applied Science (Exercise & Sport Science) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'52 weeks\')',
271 => 'INSERT INTO `course_titles` VALUES (25, \'Bachelor of Applied Science (Exercise & Sport Science)/Bachelor of \\r\\n\\r\\nScience (Nutrition)\', \'Bachelor Degree\', \'260 weeks\')',
272 => 'INSERT INTO `course_titles` VALUES (26, \'Bachelor of Applied Science (Exercise & Sport Science)/Master of \\r\\n\\r\\nNursing\', \'Bachelor Degree\', \'208 weeks\')',
273 => 'INSERT INTO `course_titles` VALUES (27, \'Bachelor of Applied Science (Exercise and Sport Science)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
274 => 'INSERT INTO `course_titles` VALUES (28, \'Bachelor of Applied Science (Exercise Sport Science and \\r\\n\\r\\nNutrition)\', \'Bachelor Degree\', \'208 weeks\')',
275 => 'INSERT INTO `course_titles` VALUES (29, \'Bachelor of Applied Science (Health Information \\r\\n\\r\\nManagement)\', \'Bachelor Degree\', \'208 weeks\')',
276 => 'INSERT INTO `course_titles` VALUES (30, \'Bachelor of Applied Science (Health Information Management) \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'104 weeks\')',
277 => 'INSERT INTO `course_titles` VALUES (31, \'Bachelor of Applied Science (Leisure & Health) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
278 => 'INSERT INTO `course_titles` VALUES (32, \'Bachelor of Applied Science (Leisure and Health)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
279 => 'INSERT INTO `course_titles` VALUES (33, \'Bachelor of Applied Science (Medical Radiation Science) - Diagnostic \\r\\n\\r\\nRadiography\', \'Bachelor Degree\', \'156 weeks\')',
280 => 'INSERT INTO `course_titles` VALUES (34, \'Bachelor of Applied Science (Medical Radiation Science) - Radiation \\r\\n\\r\\nTherapy\', \'Bachelor Degree\', \'156 weeks\')',
281 => 'INSERT INTO `course_titles` VALUES (35, \'Bachelor of Applied Science (Medical Radiation Sciences) \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'104 weeks\')',
282 => 'INSERT INTO `course_titles` VALUES (36, \'Bachelor of Applied Science (Medical Radiation Sciences) Nuc \\r\\n\\r\\nMed\', \'Bachelor Degree\', \'156 weeks\')',
283 => 'INSERT INTO `course_titles` VALUES (37, \'Bachelor of Applied Science (Occupational Therapy) \\r\\n\\r\\n(Honours)\', \'Bachelor Degree\', \'104 weeks\')',
284 => 'INSERT INTO `course_titles` VALUES (38, \'Bachelor of Applied Science (Occupational Therapy) 4 Yrs\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
285 => 'INSERT INTO `course_titles` VALUES (39, \'Bachelor of Applied Science (Orthoptics) 4 yrs\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
286 => 'INSERT INTO `course_titles` VALUES (40, \'Bachelor of Applied Science (Orthoptics) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
287 => 'INSERT INTO `course_titles` VALUES (41, \'Bachelor of Applied Science (Physiotheraphy)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
288 => 'INSERT INTO `course_titles` VALUES (42, \'Bachelor of Applied Science (Physiotherapy) (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
289 => 'INSERT INTO `course_titles` VALUES (43, \'Bachelor of Applied Science (Speech Pathology)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
290 => 'INSERT INTO `course_titles` VALUES (44, \'Bachelor of Applied Science (Speech Pathology) (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
291 => 'INSERT INTO `course_titles` VALUES (45, \'Bachelor of Applied Science MRS ( Nuclear Medicine Technology) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
292 => 'INSERT INTO `course_titles` VALUES (46, \'Bachelor of Applied Science MRS (Diagnostic Radiography)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
293 => 'INSERT INTO `course_titles` VALUES (47, \'Bachelor of Applied Science MRS (Diagnostic Radiography) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
294 => 'INSERT INTO `course_titles` VALUES (48, \'Bachelor of Applied Science MRS (Nuclear Medicine \\r\\n\\r\\nTechnology)\', \'Bachelor Degree\', \'156 weeks\')',
295 => 'INSERT INTO `course_titles` VALUES (49, \'Bachelor of Applied Science MRS(Radiation Therapy)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
296 => 'INSERT INTO `course_titles` VALUES (50, \'Bachelor of Applied Science MRS(Radiation Therapy) \\r\\n\\r\\nHonours\', \'Bachelor Degree\', \'208 weeks\')',
297 => 'INSERT INTO `course_titles` VALUES (51, \'Bachelor of Archaeology\', \'Bachelor Degree\', \'156 weeks\')',
298 => 'INSERT INTO `course_titles` VALUES (52, \'Bachelor of Archaeology (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
299 => 'INSERT INTO `course_titles` VALUES (53, \'Bachelor of Architecture\', \'Bachelor Degree\', \'286 weeks\')',
300 => 'INSERT INTO `course_titles` VALUES (54, \'Bachelor of Architecture\', \'Bachelor Degree\', \'104 weeks\')',
301 => 'INSERT INTO `course_titles` VALUES (55, \'Bachelor of Architecture / Bachelor of Law\', \'Bachelor Degree\', \'364 \\r\\n\\r\\nweeks\')',
302 => 'INSERT INTO `course_titles` VALUES (56, \'Bachelor of Architecture/Bachelor of Arts\', \'Bachelor Degree\', \'312 \\r\\n\\r\\nweeks\')',
303 => 'INSERT INTO `course_titles` VALUES (57, \'Bachelor of Architecture/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'312 weeks\')',
304 => 'INSERT INTO `course_titles` VALUES (58, \'Bachelor of Art Education\', \'Bachelor Degree\', \'208 weeks\')',
305 => 'INSERT INTO `course_titles` VALUES (59, \'Bachelor of Art Theory\', \'Bachelor Degree\', \'156 weeks\')',
306 => 'INSERT INTO `course_titles` VALUES (60, \'Bachelor of Art Theory/Bachelor of Arts\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
307 => 'INSERT INTO `course_titles` VALUES (61, \'Bachelor of Art Theory/Bachelor of Law\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
308 => 'INSERT INTO `course_titles` VALUES (62, \'Bachelor of Art Theory/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
309 => 'INSERT INTO `course_titles` VALUES (63, \'Bachelor of Arts\', \'Bachelor Degree\', \'156 weeks\')',
310 => 'INSERT INTO `course_titles` VALUES (64, \'Bachelor of Arts (Advanced)\', \'Bachelor Degree\', \'156 weeks\')',
311 => 'INSERT INTO `course_titles` VALUES (65, \'Bachelor of Arts (Advanced) (Honours)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
312 => 'INSERT INTO `course_titles` VALUES (66, \'Bachelor of Arts (Advanced) (Honours) / Bachelor of Medicine and \\r\\n\\r\\nBachelor\', \'Bachelor Degree\', \'364 weeks\')',
313 => 'INSERT INTO `course_titles` VALUES (67, \'Bachelor of Arts (Biblical Studies)\', \'Bachelor Degree\', \'156 weeks\')',
314 => 'INSERT INTO `course_titles` VALUES (68, \'Bachelor of Arts (Christian Studies)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
315 => 'INSERT INTO `course_titles` VALUES (69, \'Bachelor of Arts (Dance)/Bachelor of Education\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
316 => 'INSERT INTO `course_titles` VALUES (70, \'Bachelor of Arts (Digital Technology and Culture)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
317 => 'INSERT INTO `course_titles` VALUES (71, \'Bachelor of Arts (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
318 => 'INSERT INTO `course_titles` VALUES (72, \'Bachelor of Arts (Informatics)\', \'Bachelor Degree\', \'208 weeks\')',
319 => 'INSERT INTO `course_titles` VALUES (73, \'Bachelor of Arts (Intercultural Ministry)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
320 => 'INSERT INTO `course_titles` VALUES (74, \'Bachelor of Arts (Languages)\', \'Bachelor Degree\', \'208 weeks\')',
321 => 'INSERT INTO `course_titles` VALUES (75, \'Bachelor of Arts (Media & Communications)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
322 => 'INSERT INTO `course_titles` VALUES (76, \'Bachelor of Arts (Media and Communications)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
323 => 'INSERT INTO `course_titles` VALUES (77, \'Bachelor of Arts (Media and Communications) / LLB\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
324 => 'INSERT INTO `course_titles` VALUES (78, \'Bachelor of Arts (Ministry)\', \'Bachelor Degree\', \'156 weeks\')',
325 => 'INSERT INTO `course_titles` VALUES (79, \'Bachelor of Arts (Psychology)\', \'Bachelor Degree\', \'208 weeks\')',
326 => 'INSERT INTO `course_titles` VALUES (80, \'Bachelor of Arts / Bachelor of Commerce\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
327 => 'INSERT INTO `course_titles` VALUES (81, \'Bachelor of Arts / Bachelor of Laws\', \'Bachelor Degree\', \'260 weeks\')',
328 => 'INSERT INTO `course_titles` VALUES (82, \'Bachelor of Arts / Bachelor of Music\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
329 => 'INSERT INTO `course_titles` VALUES (83, \'Bachelor of Arts / Bachelor of Music Studies\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
330 => 'INSERT INTO `course_titles` VALUES (84, \'Bachelor of Arts / Bachelor of Social Work\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
331 => 'INSERT INTO `course_titles` VALUES (85, \'Bachelor of Arts / Bachelor of Theology\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
332 => 'INSERT INTO `course_titles` VALUES (86, \'Bachelor of Arts / Science\', \'Bachelor Degree\', \'260 weeks\')',
333 => 'INSERT INTO `course_titles` VALUES (87, \'Bachelor of Arts and Sciences\', \'Bachelor Degree\', \'156 weeks\')',
334 => 'INSERT INTO `course_titles` VALUES (88, \'Bachelor of Arts Informatics (Honours)\', \'Bachelor Degree\', \'52 \\r\\n\\r\\nweeks\')',
335 => 'INSERT INTO `course_titles` VALUES (89, \'Bachelor of Arts/Bachelor of Behavioural Science \\r\\n\\r\\n(Psychology)\', \'Bachelor Degree\', \'208 weeks\')',
336 => 'INSERT INTO `course_titles` VALUES (90, \'Bachelor of Arts/Bachelor of Education\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
337 => 'INSERT INTO `course_titles` VALUES (91, \'Bachelor of Arts/Bachelor of Law\', \'Bachelor Degree\', \'260 weeks\')',
338 => 'INSERT INTO `course_titles` VALUES (92, \'Bachelor of Arts/Bachelor of Laws and Legal Practice\', \'Bachelor \\r\\n\\r\\nDegree\', \'286 weeks\')',
339 => 'INSERT INTO `course_titles` VALUES (93, \'Bachelor of Arts/Master of Nursing\', \'Bachelor Degree\', \'208 weeks\')',
340 => 'INSERT INTO `course_titles` VALUES (94, \'Bachelor of Aviation (Flying)\', \'Bachelor Degree\', \'156 weeks\')',
341 => 'INSERT INTO `course_titles` VALUES (95, \'Bachelor of Aviation (Operations Management)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
342 => 'INSERT INTO `course_titles` VALUES (96, \'Bachelor of Banking and International Finance\', \'Bachelor \\r\\n\\r\\nDegree\', \'141 weeks\')',
343 => 'INSERT INTO `course_titles` VALUES (97, \'Bachelor of Banking and International Finance (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'39 weeks\')',
344 => 'INSERT INTO `course_titles` VALUES (98, \'Bachelor of Behavioural Health Science\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
345 => 'INSERT INTO `course_titles` VALUES (99, \'Bachelor of Behavioural Science (Psychology)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
346 => 'INSERT INTO `course_titles` VALUES (100, \'Bachelor of Behavioural Science (Psychology) (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
347 => 'INSERT INTO `course_titles` VALUES (101, \'Bachelor of Behavioural Science/Bachelor of Laws\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
348 => 'INSERT INTO `course_titles` VALUES (102, \'Bachelor of Behavioural Science/Bachelor of Laws and Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'286 weeks\')',
349 => 'INSERT INTO `course_titles` VALUES (103, \'Bachelor of Biotechnology (Honours)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
350 => 'INSERT INTO `course_titles` VALUES (104, \'Bachelor of Biotechnology Bachelor of Laws & Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'312 weeks\')',
351 => 'INSERT INTO `course_titles` VALUES (105, \'Bachelor of Biotechnology/Bachelor of Laws\', \'Bachelor Degree\', \'286 \\r\\n\\r\\nweeks\')',
352 => 'INSERT INTO `course_titles` VALUES (106, \'Bachelor of Business\', \'Bachelor Degree\', \'156 weeks\')',
353 => 'INSERT INTO `course_titles` VALUES (107, \'Bachelor of Business - Honours (Agric Commerce) Orange\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
354 => 'INSERT INTO `course_titles` VALUES (108, \'Bachelor of Business & Economics (Honours)\', \'Bachelor Degree\', \'39 \\r\\n\\r\\nweeks\')',
355 => 'INSERT INTO `course_titles` VALUES (109, \'Bachelor of Business (Agricultural Commerce)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
356 => 'INSERT INTO `course_titles` VALUES (110, \'Bachelor of Business and Economics\', \'Bachelor Degree\', \'141 weeks\')',
357 => 'INSERT INTO `course_titles` VALUES (111, \'Bachelor of Business and Economics/Bachelor of Laws and Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'276 weeks\')',
358 => 'INSERT INTO `course_titles` VALUES (112, \'Bachelor of Business Economics and Government\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
359 => 'INSERT INTO `course_titles` VALUES (113, \'Bachelor of Business/Bachelor of Arts\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
360 => 'INSERT INTO `course_titles` VALUES (114, \'Bachelor of Business/Bachelor of Environmental \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
361 => 'INSERT INTO `course_titles` VALUES (115, \'Bachelor of Business/Bachelor of Government and Public Management \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
362 => 'INSERT INTO `course_titles` VALUES (116, \'Bachelor of Business/Bachelor of Information Technology\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
363 => 'INSERT INTO `course_titles` VALUES (117, \'Bachelor of Business/Bachelor of International Studies\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
364 => 'INSERT INTO `course_titles` VALUES (118, \'Bachelor of Commerce\', \'Bachelor Degree\', \'156 weeks\')',
365 => 'INSERT INTO `course_titles` VALUES (119, \'Bachelor of Commerce\', \'Bachelor Degree\', \'141 weeks\')',
366 => 'INSERT INTO `course_titles` VALUES (120, \'Bachelor of Commerce (Accounting)\', \'Bachelor Degree\', \'156 weeks\')',
367 => 'INSERT INTO `course_titles` VALUES (121, \'Bachelor of Commerce (Accounting)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
368 => 'INSERT INTO `course_titles` VALUES (122, \'Bachelor of Commerce (Accounting)/Bachelor of Environmental \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
369 => 'INSERT INTO `course_titles` VALUES (123, \'Bachelor of Commerce (Accounting)/Bachelor of Government and Public \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
370 => 'INSERT INTO `course_titles` VALUES (124, \'Bachelor of Commerce (Accounting)/Bachelor of Information \\r\\n\\r\\nTechnology\', \'Bachelor Degree\', \'208 weeks\')',
371 => 'INSERT INTO `course_titles` VALUES (125, \'Bachelor of Commerce (Accounting)/Bachelor of International Studies \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
372 => 'INSERT INTO `course_titles` VALUES (126, \'Bachelor of Commerce (Accounting)/Bachelor of Laws\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
373 => 'INSERT INTO `course_titles` VALUES (127, \'Bachelor of Commerce (Accounting)/Bachelor of Laws and Legal \\r\\n\\r\\nPractice\', \'Bachelor Degree\', \'286 weeks\')',
374 => 'INSERT INTO `course_titles` VALUES (128, \'Bachelor of Commerce (All Majors) / Bachelor of Law\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
375 => 'INSERT INTO `course_titles` VALUES (129, \'Bachelor of Commerce (All specialisations)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
376 => 'INSERT INTO `course_titles` VALUES (130, \'Bachelor of Commerce (Finance)\', \'Bachelor Degree\', \'156 weeks\')',
377 => 'INSERT INTO `course_titles` VALUES (131, \'Bachelor of Commerce (Finance)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
378 => 'INSERT INTO `course_titles` VALUES (132, \'Bachelor of Commerce (Finance)/Bachelor of Environmental Management \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
379 => 'INSERT INTO `course_titles` VALUES (133, \'Bachelor of Commerce (Finance)/Bachelor of Government and Public \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'208 weeks\')',
380 => 'INSERT INTO `course_titles` VALUES (134, \'Bachelor of Commerce (Finance)/Bachelor of Information \\r\\n\\r\\nTechnology\', \'Bachelor Degree\', \'208 weeks\')',
381 => 'INSERT INTO `course_titles` VALUES (135, \'Bachelor of Commerce (Finance)/Bachelor of International Studies \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
382 => 'INSERT INTO `course_titles` VALUES (136, \'Bachelor of Commerce (Finance)/Bachelor of Laws\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
383 => 'INSERT INTO `course_titles` VALUES (137, \'Bachelor of Commerce (Finance)/Bachelor of Laws and Legal Practice \\r\\n\\r\\n\', \'Bachelor Degree\', \'286 weeks\')',
384 => 'INSERT INTO `course_titles` VALUES (138, \'Bachelor of Commerce (Honours)\', \'Bachelor Degree\', \'39 weeks\')',
385 => 'INSERT INTO `course_titles` VALUES (139, \'Bachelor of Commerce (International)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
386 => 'INSERT INTO `course_titles` VALUES (140, \'Bachelor of Commerce (Liberal Studies)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
387 => 'INSERT INTO `course_titles` VALUES (141, \'Bachelor of Commerce (Liberal Studies) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
388 => 'INSERT INTO `course_titles` VALUES (142, \'Bachelor of Commerce and Bachelor of Arts\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
389 => 'INSERT INTO `course_titles` VALUES (143, \'Bachelor of Commerce and Bachelor of Laws\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
390 => 'INSERT INTO `course_titles` VALUES (144, \'Bachelor of Commerce and Bachelor of Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
391 => 'INSERT INTO `course_titles` VALUES (145, \'Bachelor of Commerce Honours\', \'Bachelor Degree\', \'52 weeks\')',
392 => 'INSERT INTO `course_titles` VALUES (146, \'Bachelor of Commerce in Services Marketing - Tourism and \\r\\n\\r\\nHospitality\', \'Bachelor Degree\', \'208 weeks\')',
393 => 'INSERT INTO `course_titles` VALUES (147, \'Bachelor of Commerce(Accounting)/Bachelor of Health Sciences \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
394 => 'INSERT INTO `course_titles` VALUES (148, \'Bachelor of Commerce/Bachelor of Arts\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
395 => 'INSERT INTO `course_titles` VALUES (149, \'Bachelor of Commerce/Bachelor of Banking and International \\r\\n\\r\\nFinance\', \'Bachelor Degree\', \'192 weeks\')',
396 => 'INSERT INTO `course_titles` VALUES (150, \'Bachelor of Commerce/Bachelor of Economics\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
397 => 'INSERT INTO `course_titles` VALUES (151, \'Bachelor of Commerce/Bachelor of Environmental \\r\\n\\r\\nManagement\', \'Bachelor Degree\', \'192 weeks\')',
398 => 'INSERT INTO `course_titles` VALUES (152, \'Bachelor of Commerce/Bachelor of International Studies\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
399 => 'INSERT INTO `course_titles` VALUES (153, \'Bachelor of Commerce/Bachelor of Laws and Legal Practice\', \'Bachelor \\r\\n\\r\\nDegree\', \'276 weeks\')',
400 => 'INSERT INTO `course_titles` VALUES (154, \'Bachelor of Commerce/Bachelor of Science\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
401 => 'INSERT INTO `course_titles` VALUES (155, \'Bachelor of Commerce/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
402 => 'INSERT INTO `course_titles` VALUES (156, \'Bachelor of Communication and Information Technology\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
403 => 'INSERT INTO `course_titles` VALUES (157, \'Bachelor of Computer Science\', \'Masters Degree (Coursework)\', \'104 \\r\\n\\r\\nweeks\')',
404 => 'INSERT INTO `course_titles` VALUES (158, \'Bachelor of Computer Science & Technology (Advanced)\\r\\n\\r\\n(pass)\', \'Bachelor Degree\', \'156 weeks\')',
405 => 'INSERT INTO `course_titles` VALUES (159, \'Bachelor of Computer Science & Technology (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
406 => 'INSERT INTO `course_titles` VALUES (160, \'Bachelor of Computer Science and Technology\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
407 => 'INSERT INTO `course_titles` VALUES (161, \'Bachelor of Construction Management and Property\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
408 => 'INSERT INTO `course_titles` VALUES (162, \'Bachelor of Creative Arts (Creative Writing)\', \'Bachelor \\r\\n\\r\\nDegree\', \'156 weeks\')',
409 => 'INSERT INTO `course_titles` VALUES (163, \'Bachelor of Creative Arts (Digital Media)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
410 => 'INSERT INTO `course_titles` VALUES (164, \'Bachelor of Creative Arts (Drama)\', \'Bachelor Degree\', \'156 weeks\')',
411 => 'INSERT INTO `course_titles` VALUES (165, \'Bachelor of Creative Arts (Honours) (Creative Writing)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
412 => 'INSERT INTO `course_titles` VALUES (166, \'Bachelor of Creative Arts (Honours) (Digital Media)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
413 => 'INSERT INTO `course_titles` VALUES (167, \'Bachelor of Creative Arts (Honours) (Screen Studies/Drama) \\r\\n\\r\\n\', \'Bachelor Degree\', \'52 weeks\')',
414 => 'INSERT INTO `course_titles` VALUES (168, \'Bachelor of Creative Arts (Screen Studies)\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
415 => 'INSERT INTO `course_titles` VALUES (169, \'Bachelor of Cultural Tourism\', \'Bachelor Degree\', \'156 weeks\')',
416 => 'INSERT INTO `course_titles` VALUES (170, \'Bachelor of Dentistry\', \'Bachelor Degree\', \'208 weeks\')',
417 => 'INSERT INTO `course_titles` VALUES (171, \'Bachelor of Design\', \'Bachelor Degree\', \'208 weeks\')',
418 => 'INSERT INTO `course_titles` VALUES (172, \'Bachelor of Design\', \'Bachelor Degree\', \'156 weeks\')',
419 => 'INSERT INTO `course_titles` VALUES (173, \'Bachelor of Design (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
420 => 'INSERT INTO `course_titles` VALUES (174, \'Bachelor of Design Computing\', \'Bachelor Degree\', \'156 weeks\')',
421 => 'INSERT INTO `course_titles` VALUES (175, \'Bachelor of Design Computing (Honours)\', \'Bachelor Degree\', \'52 \\r\\n\\r\\nweeks\')',
422 => 'INSERT INTO `course_titles` VALUES (176, \'Bachelor of Design in Architecture\', \'Bachelor Degree\', \'156 weeks\')',
423 => 'INSERT INTO `course_titles` VALUES (177, \'Bachelor of Design in Architecture (Honours)\', \'Bachelor Degree\', \'52 \\r\\n\\r\\nweeks\')',
424 => 'INSERT INTO `course_titles` VALUES (178, \'Bachelor of Design/Bachelor of Art Education\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
425 => 'INSERT INTO `course_titles` VALUES (179, \'Bachelor of Digital Media\', \'Bachelor Degree\', \'208 weeks\')',
426 => 'INSERT INTO `course_titles` VALUES (180, \'Bachelor of Disability and Community Rehabilitation\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
427 => 'INSERT INTO `course_titles` VALUES (181, \'Bachelor of Economic and Social Science\', \'Bachelor Degree\', \'156 \\r\\n\\r\\nweeks\')',
428 => 'INSERT INTO `course_titles` VALUES (182, \'Bachelor of Economics\', \'Bachelor Degree\', \'156 weeks\')',
429 => 'INSERT INTO `course_titles` VALUES (183, \'Bachelor of Economics (All Majors)\', \'Bachelor Degree\', \'156 weeks\')',
430 => 'INSERT INTO `course_titles` VALUES (184, \'Bachelor of Economics (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
431 => 'INSERT INTO `course_titles` VALUES (185, \'Bachelor of Economics (Liberal Stuides)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
432 => 'INSERT INTO `course_titles` VALUES (186, \'Bachelor of Economics (Social Sciences) / Bachelor of \\r\\n\\r\\nLaws\', \'Bachelor Degree\', \'260 weeks\')',
433 => 'INSERT INTO `course_titles` VALUES (187, \'Bachelor of Economics (Social Sciences) Honours\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
434 => 'INSERT INTO `course_titles` VALUES (188, \'Bachelor of Economics and Bachelor of Laws\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
435 => 'INSERT INTO `course_titles` VALUES (189, \'Bachelor of Economics and Social Sciences (Honours)\', \'Bachelor \\r\\n\\r\\nDegree\', \'52 weeks\')',
436 => 'INSERT INTO `course_titles` VALUES (190, \'Bachelor of Economics Honours\', \'Bachelor Degree\', \'52 weeks\')',
437 => 'INSERT INTO `course_titles` VALUES (191, \'Bachelor of Economics/Bachelor of Arts\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
438 => 'INSERT INTO `course_titles` VALUES (192, \'Bachelor of Economics/Bachelor of Law\', \'Bachelor Degree\', \'260 \\r\\n\\r\\nweeks\')',
439 => 'INSERT INTO `course_titles` VALUES (193, \'Bachelor of Economics/Bachelor of Social Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
440 => 'INSERT INTO `course_titles` VALUES (194, \'Bachelor of Ecotourism\', \'Bachelor Degree\', \'156 weeks\')',
441 => 'INSERT INTO `course_titles` VALUES (195, \'Bachelor of Ecotourism (Honours)\', \'Bachelor Degree\', \'52 weeks\')',
442 => 'INSERT INTO `course_titles` VALUES (196, \'Bachelor of Education\', \'Bachelor Degree\', \'208 weeks\')',
443 => 'INSERT INTO `course_titles` VALUES (197, \'Bachelor of Education (Early Childhood) (Graduate Entry)\', \'Bachelor \\r\\n\\r\\nDegree\', \'104 weeks\')',
444 => 'INSERT INTO `course_titles` VALUES (198, \'Bachelor of Education (Early Childhood)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
445 => 'INSERT INTO `course_titles` VALUES (199, \'Bachelor of Education (Honours)\', \'Bachelor Degree\', \'39 weeks\')',
446 => 'INSERT INTO `course_titles` VALUES (200, \'Bachelor of Education (Junior Primary/Primary)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
447 => 'INSERT INTO `course_titles` VALUES (201, \'Bachelor of Education (Junior Primary/Primary) (Graduate Entry) \\r\\n\\r\\n\', \'Bachelor Degree\', \'104 weeks\')',
448 => 'INSERT INTO `course_titles` VALUES (202, \'Bachelor of Education (Junior Primary/Primary)/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'208 weeks\')',
449 => 'INSERT INTO `course_titles` VALUES (203, \'Bachelor of Education (Junior Primary/Primary)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'208 weeks\')',
450 => 'INSERT INTO `course_titles` VALUES (204, \'Bachelor of Education (Middle School)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
451 => 'INSERT INTO `course_titles` VALUES (205, \'Bachelor of Education (Middle School)/Bachelor of Health \\r\\n\\r\\nSciences\', \'Bachelor Degree\', \'208 weeks\')',
452 => 'INSERT INTO `course_titles` VALUES (206, \'Bachelor of Education (Middle School)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'208 weeks\')',
453 => 'INSERT INTO `course_titles` VALUES (207, \'Bachelor of Education (Middle School)/Health Sciences\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
454 => 'INSERT INTO `course_titles` VALUES (208, \'Bachelor of Education (Secondary Education:Humanities)/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
455 => 'INSERT INTO `course_titles` VALUES (209, \'Bachelor of Education (Secondary Education:Mathematics)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
456 => 'INSERT INTO `course_titles` VALUES (210, \'Bachelor of Education (Secondary Education:Science)/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
457 => 'INSERT INTO `course_titles` VALUES (211, \'Bachelor of Education (Secondary Humanities) B Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'260 weeks\')',
458 => 'INSERT INTO `course_titles` VALUES (212, \'Bachelor of Education (Secondary Mathematics) / Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
459 => 'INSERT INTO `course_titles` VALUES (213, \'Bachelor of Education (Secondary Science)\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
460 => 'INSERT INTO `course_titles` VALUES (214, \'Bachelor of Education (Secondary) (Graduate Entry)\', \'Masters \\r\\n\\r\\nDegree (Coursework)\', \'104 weeks\')',
461 => 'INSERT INTO `course_titles` VALUES (215, \'Bachelor of Education (Secondary) / Bachelor of Economics (Social \\r\\n\\r\\nScience)\', \'Bachelor Degree\', \'260 weeks\')',
462 => 'INSERT INTO `course_titles` VALUES (216, \'Bachelor of Education (Secondary) Human Movement and Health \\r\\n\\r\\nEducation\', \'Bachelor Degree\', \'208 weeks\')',
463 => 'INSERT INTO `course_titles` VALUES (217, \'Bachelor of Education (Secondary)/Bachelor of Arts\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
464 => 'INSERT INTO `course_titles` VALUES (218, \'Bachelor of Education (Secondary)/Bachelor of Health Sciences \\r\\n\\r\\n\', \'Bachelor Degree\', \'208 weeks\')',
465 => 'INSERT INTO `course_titles` VALUES (219, \'Bachelor of Education (Secondary)/Bachelor of Science\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
466 => 'INSERT INTO `course_titles` VALUES (220, \'Bachelor of Education (Secondary)/Health Sciences\', \'Bachelor \\r\\n\\r\\nDegree\', \'192 weeks\')',
467 => 'INSERT INTO `course_titles` VALUES (221, \'Bachelor of Education (Secondary:Humanities & Social Sciences)\\r\\n\\r\\nBachelor of Arts\', \'Bachelor Degree\', \'260 weeks\')',
468 => 'INSERT INTO `course_titles` VALUES (222, \'Bachelor of Education (Secondary:Science) / Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
469 => 'INSERT INTO `course_titles` VALUES (223, \'Bachelor of Education (Special Education)\', \'Masters Degree \\r\\n\\r\\n(Coursework)\', \'104 weeks\')',
470 => 'INSERT INTO `course_titles` VALUES (224, \'Bachelor of Education (Upper Primary/lower Secondary)\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
471 => 'INSERT INTO `course_titles` VALUES (225, \'Bachelor of Engineering\', \'Bachelor Degree\', \'208 weeks\')',
472 => 'INSERT INTO `course_titles` VALUES (226, \'Bachelor of Engineering - Aerospace Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
473 => 'INSERT INTO `course_titles` VALUES (227, \'Bachelor of Engineering - Aerospace Engineering/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
474 => 'INSERT INTO `course_titles` VALUES (228, \'Bachelor of Engineering - Aerospace Engineering/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
475 => 'INSERT INTO `course_titles` VALUES (229, \'Bachelor of Engineering - Bioinformatics\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
476 => 'INSERT INTO `course_titles` VALUES (230, \'Bachelor of Engineering - Bioinformatics/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
477 => 'INSERT INTO `course_titles` VALUES (231, \'Bachelor of Engineering - Bioinformatics/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
478 => 'INSERT INTO `course_titles` VALUES (232, \'Bachelor of Engineering - Ceramic Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
479 => 'INSERT INTO `course_titles` VALUES (233, \'Bachelor of Engineering - Chemical Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
480 => 'INSERT INTO `course_titles` VALUES (234, \'Bachelor of Engineering - Chemical Engineering/ Master of \\r\\n\\r\\nCommerce\', \'Bachelor Degree\', \'260 weeks\')',
481 => 'INSERT INTO `course_titles` VALUES (235, \'Bachelor of Engineering - Chemical Engineering/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
482 => 'INSERT INTO `course_titles` VALUES (236, \'Bachelor of Engineering - Chemical Engineering/Bachelor of Science \\r\\n\\r\\n- Computer Science\', \'Bachelor Degree\', \'260 weeks\')',
483 => 'INSERT INTO `course_titles` VALUES (237, \'Bachelor of Engineering - Chemical Engineering/Master of Biomedical \\r\\n\\r\\nEngineering\', \'Masters Degree (Coursework)\', \'260 weeks\')',
484 => 'INSERT INTO `course_titles` VALUES (238, \'Bachelor of Engineering - Civil Engineering\', \'Bachelor Degree\', \'208 \\r\\n\\r\\nweeks\')',
485 => 'INSERT INTO `course_titles` VALUES (239, \'Bachelor of Engineering - Civil Engineering / Bachelor of \\r\\n\\r\\nEngineering - Mining Engineering\', \'Bachelor Degree\', \'260 weeks\')',
486 => 'INSERT INTO `course_titles` VALUES (240, \'Bachelor of Engineering - Civil Engineering/Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
487 => 'INSERT INTO `course_titles` VALUES (241, \'Bachelor of Engineering - Civil Engineering/Bachelor of Engineering \\r\\n\\r\\n- Environmental Engineering\', \'Bachelor Degree\', \'260 weeks\')',
488 => 'INSERT INTO `course_titles` VALUES (242, \'Bachelor of Engineering - Civil Engineering/Bachelor of \\r\\n\\r\\nLaw\', \'Bachelor Degree\', \'312 weeks\')',
489 => 'INSERT INTO `course_titles` VALUES (243, \'Bachelor of Engineering - Civil Engineering/Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
490 => 'INSERT INTO `course_titles` VALUES (244, \'Bachelor of Engineering - Computer Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
491 => 'INSERT INTO `course_titles` VALUES (245, \'Bachelor of Engineering - Computer Engineering / Bachelor of \\r\\n\\r\\nArts\', \'Bachelor Degree\', \'260 weeks\')',
492 => 'INSERT INTO `course_titles` VALUES (246, \'Bachelor of Engineering - Computer Engineering / Bachelor of \\r\\n\\r\\nScience\', \'Bachelor Degree\', \'260 weeks\')',
493 => 'INSERT INTO `course_titles` VALUES (247, \'Bachelor of Engineering - Computer Engineering / Master of \\r\\n\\r\\nBiomedical Engineering\', \'Masters Degree (Coursework)\', \'260 weeks\')',
494 => 'INSERT INTO `course_titles` VALUES (248, \'Bachelor of Engineering - Electrical Engineering\', \'Bachelor \\r\\n\\r\\nDegree\', \'208 weeks\')',
495 => 'INSERT INTO `c