· 8 years ago · Jun 03, 2018, 12:46 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.19
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jun 03, 2018 at 10:40 PM
7-- Server version: 5.1.73
8-- PHP Version: 5.3.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `nsingh37Ass3`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `COACH`
27--
28
29CREATE TABLE IF NOT EXISTS `COACH` (
30 `Coach_ID` varchar(3) NOT NULL DEFAULT '',
31 `Individual_Id` int(2) DEFAULT NULL,
32 `Certification_Level` int(1) DEFAULT NULL,
33 `Certification_Date` varchar(10) DEFAULT NULL,
34 `WWC_Check` varchar(10) DEFAULT NULL,
35 PRIMARY KEY (`Coach_ID`),
36 KEY `Individual_Id` (`Individual_Id`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39--
40-- Dumping data for table `COACH`
41--
42
43INSERT INTO `COACH` (`Coach_ID`, `Individual_Id`, `Certification_Level`, `Certification_Date`, `WWC_Check`) VALUES
44('C1', 46, 4, '05/09/2016', '10/30/2015'),
45('C10', 55, 5, '05/09/2016', '08/23/2016'),
46('C11', 56, 1, '08/19/2017', '03/28/2017'),
47('C12', 57, 3, '08/03/2016', '05/05/2017'),
48('C13', 58, 2, '04/13/2016', '02/06/2015'),
49('C14', 59, 2, '02/26/2016', '02/22/2017'),
50('C15', 60, 1, '09/25/2015', '02/01/2015'),
51('C16', 61, 2, '10/24/2016', '07/09/2017'),
52('C17', 62, 3, '08/22/2015', '09/23/2016'),
53('C18', 63, 3, '10/15/2015', '07/27/2016'),
54('C19', 64, 4, '01/18/2016', '06/13/2016'),
55('C2', 47, 3, '10/24/2016', '07/31/2015'),
56('C20', 65, 5, '12/11/2015', '09/29/2015'),
57('C21', 66, 2, '11/13/2016', '03/31/2016'),
58('C22', 67, 4, '12/30/2016', '06/30/2016'),
59('C23', 68, 3, '02/15/2017', '12/12/2015'),
60('C3', 48, 3, '03/29/2016', '03/07/2017'),
61('C4', 49, 3, '10/18/2016', '05/11/2017'),
62('C5', 50, 4, '08/03/2016', '08/07/2016'),
63('C6', 51, 4, '09/17/2015', '10/30/2015'),
64('C7', 52, 4, '02/25/2016', '08/18/2016'),
65('C8', 53, 5, '04/09/2017', '01/09/2015'),
66('C9', 54, 5, '10/05/2015', '07/13/2015');
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `COUNTRY`
72--
73
74CREATE TABLE IF NOT EXISTS `COUNTRY` (
75 `Country_Code` varchar(2) NOT NULL DEFAULT '',
76 `Country_Name` varchar(44) DEFAULT NULL,
77 PRIMARY KEY (`Country_Code`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8;
79
80--
81-- Dumping data for table `COUNTRY`
82--
83
84INSERT INTO `COUNTRY` (`Country_Code`, `Country_Name`) VALUES
85('AD', 'Andorra'),
86('AE', 'United Arab Emirates'),
87('AF', 'Afghanistan'),
88('AG', 'Antigua and Barbuda'),
89('AI', 'Anguilla'),
90('AL', 'Albania'),
91('AM', 'Armenia'),
92('AO', 'Angola'),
93('AQ', 'Antarctica'),
94('AR', 'Argentina'),
95('AS', 'American Samoa'),
96('AT', 'Austria'),
97('AU', 'Australia'),
98('AW', 'Aruba'),
99('AX', 'voland Islands'),
100('AZ', 'Azerbaijan'),
101('BA', 'Bosnia and Herzegovina'),
102('BB', 'Barbados'),
103('BD', 'Bangladesh'),
104('BE', 'Belgium'),
105('BF', 'Burkina Faso'),
106('BG', 'Bulgaria'),
107('BH', 'Bahrain'),
108('BI', 'Burundi'),
109('BJ', 'Benin'),
110('BL', 'Saint Barthalemy'),
111('BM', 'Bermuda'),
112('BN', 'Brunei Darussalam'),
113('BO', 'Bolivia, Plurinational State of'),
114('BQ', 'Bonaire, Sint Eustatius and Saba'),
115('BR', 'Brazil'),
116('BS', 'Bahamas'),
117('BT', 'Bhutan'),
118('BV', 'Bouvet Island'),
119('BW', 'Botswana'),
120('BY', 'Belarus'),
121('BZ', 'Belize'),
122('CA', 'Canada'),
123('CC', 'Cocos (Keeling) Islands'),
124('CD', 'Congo, the Democratic Republic of the'),
125('CF', 'Central African Republic'),
126('CG', 'Congo'),
127('CH', 'Switzerland'),
128('CI', 'Côte d''Ivoire'),
129('CK', 'Cook Islands'),
130('CL', 'Chile'),
131('CM', 'Cameroon'),
132('CN', 'China'),
133('CO', 'Colombia'),
134('CR', 'Costa Rica'),
135('CU', 'Cuba'),
136('CV', 'Cape Verde'),
137('CW', 'Curaçao'),
138('CX', 'Christmas Island'),
139('CY', 'Cyprus'),
140('CZ', 'Czech Republic'),
141('DE', 'Germany'),
142('DJ', 'Djibouti'),
143('DK', 'Denmark'),
144('DM', 'Dominica'),
145('DO', 'Dominican Republic'),
146('DZ', 'Algeria'),
147('EC', 'Ecuador'),
148('EE', 'Estonia'),
149('EG', 'Egypt'),
150('EH', 'Western Sahara'),
151('ER', 'Eritrea'),
152('ES', 'Spain'),
153('ET', 'Ethiopia'),
154('FI', 'Finland'),
155('FJ', 'Fiji'),
156('FK', 'Falkland Islands (Malvinas)'),
157('FM', 'Micronesia, Federated States of'),
158('FO', 'Faroe Islands'),
159('FR', 'France'),
160('GA', 'Gabon'),
161('GB', 'United Kingdom'),
162('GD', 'Grenada'),
163('GE', 'Georgia'),
164('GF', 'French Guiana'),
165('GG', 'Guernsey'),
166('GH', 'Ghana'),
167('GI', 'Gibraltar'),
168('GL', 'Greenland'),
169('GM', 'Gambia'),
170('GN', 'Guinea'),
171('GP', 'Guadeloupe'),
172('GQ', 'Equatorial Guinea'),
173('GR', 'Greece'),
174('GS', 'South Georgia and the South Sandwich Islands'),
175('GT', 'Guatemala'),
176('GU', 'Guam'),
177('GW', 'Guinea-Bissau'),
178('GY', 'Guyana'),
179('HK', 'Hong Kong'),
180('HM', 'Heard Island and McDonald Islands'),
181('HN', 'Honduras'),
182('HR', 'Croatia'),
183('HT', 'Haiti'),
184('HU', 'Hungary'),
185('ID', 'Indonesia'),
186('IE', 'Ireland'),
187('IL', 'Israel'),
188('IM', 'Isle of Man'),
189('IN', 'India'),
190('IO', 'British Indian Ocean Territory'),
191('IQ', 'Iraq'),
192('IR', 'Iran, Islamic Republic of'),
193('IS', 'Iceland'),
194('IT', 'Italy'),
195('JE', 'Jersey'),
196('JM', 'Jamaica'),
197('JO', 'Jordan'),
198('JP', 'Japan'),
199('KE', 'Kenya'),
200('KG', 'Kyrgyzstan'),
201('KH', 'Cambodia'),
202('KI', 'Kiribati'),
203('KM', 'Comoros'),
204('KN', 'Saint Kitts and Nevis'),
205('KP', 'Korea, Democratic People''s Republic of'),
206('KR', 'Korea, Republic of'),
207('KW', 'Kuwait'),
208('KY', 'Cayman Islands'),
209('KZ', 'Kazakhstan'),
210('LA', 'Lao People''s Democratic Republic'),
211('LB', 'Lebanon'),
212('LC', 'Saint Lucia'),
213('LI', 'Liechtenstein'),
214('LK', 'Sri Lanka'),
215('LR', 'Liberia'),
216('LS', 'Lesotho'),
217('LT', 'Lithuania'),
218('LU', 'Luxembourg'),
219('LV', 'Latvia'),
220('LY', 'Libya'),
221('MA', 'Morocco'),
222('MC', 'Monaco'),
223('MD', 'Moldova, Republic of'),
224('ME', 'Montenegro'),
225('MF', 'Saint Martin (French part)'),
226('MG', 'Madagascar'),
227('MH', 'Marshall Islands'),
228('MK', 'Macedonia, the Former Yugoslav Republic of'),
229('ML', 'Mali'),
230('MM', 'Myanmar'),
231('MN', 'Mongolia'),
232('MO', 'Macao'),
233('MP', 'Northern Mariana Islands'),
234('MQ', 'Martinique'),
235('MR', 'Mauritania'),
236('MS', 'Montserrat'),
237('MT', 'Malta'),
238('MU', 'Mauritius'),
239('MV', 'Maldives'),
240('MW', 'Malawi'),
241('MX', 'Mexico'),
242('MY', 'Malaysia'),
243('MZ', 'Mozambique'),
244('NA', 'Namibia'),
245('NC', 'New Caledonia'),
246('NE', 'Niger'),
247('NF', 'Norfolk Island'),
248('NG', 'Nigeria'),
249('NI', 'Nicaragua'),
250('NL', 'Netherlands'),
251('NO', 'Norway'),
252('NP', 'Nepal'),
253('NR', 'Nauru'),
254('NU', 'Niue'),
255('NZ', 'New Zealand'),
256('OM', 'Oman'),
257('PA', 'Panama'),
258('PE', 'Peru'),
259('PF', 'French Polynesia'),
260('PG', 'Papua New Guinea'),
261('PH', 'Philippines'),
262('PK', 'Pakistan'),
263('PL', 'Poland'),
264('PM', 'Saint Pierre and Miquelon'),
265('PN', 'Pitcairn'),
266('PR', 'Puerto Rico'),
267('PS', 'Palestine, State of'),
268('PT', 'Portugal'),
269('PW', 'Palau'),
270('PY', 'Paraguay'),
271('QA', 'Qatar'),
272('RE', 'Réunion'),
273('RO', 'Romania'),
274('RS', 'Serbia'),
275('RU', 'Russian Federation'),
276('RW', 'Rwanda'),
277('SA', 'Saudi Arabia'),
278('SB', 'Solomon Islands'),
279('SC', 'Seychelles'),
280('SD', 'Sudan'),
281('SE', 'Sweden'),
282('SG', 'Singapore'),
283('SH', 'Saint Helena, Ascension and Tristan da Cunha'),
284('SI', 'Slovenia'),
285('SJ', 'Svalbard and Jan Mayen'),
286('SK', 'Slovakia'),
287('SL', 'Sierra Leone'),
288('SM', 'San Marino'),
289('SN', 'Senegal'),
290('SO', 'Somalia'),
291('SR', 'Suriname'),
292('SS', 'South Sudan'),
293('ST', 'Sao Tome and Principe'),
294('SV', 'El Salvador'),
295('SX', 'Sint Maarten (Dutch part)'),
296('SY', 'Syrian Arab Republic'),
297('SZ', 'Swaziland'),
298('TC', 'Turks and Caicos Islands'),
299('TD', 'Chad'),
300('TF', 'French Southern Territories'),
301('TG', 'Togo'),
302('TH', 'Thailand'),
303('TJ', 'Tajikistan'),
304('TK', 'Tokelau'),
305('TL', 'Timor-Leste'),
306('TM', 'Turkmenistan'),
307('TN', 'Tunisia'),
308('TO', 'Tonga'),
309('TR', 'Turkey'),
310('TT', 'Trinidad and Tobago'),
311('TV', 'Tuvalu'),
312('TW', 'Taiwan, Province of China'),
313('TZ', 'Tanzania, United Republic of'),
314('UA', 'Ukraine'),
315('UG', 'Uganda'),
316('UM', 'United States Minor Outlying Islands'),
317('US', 'United States'),
318('UY', 'Uruguay'),
319('UZ', 'Uzbekistan'),
320('VA', 'Holy See (Vatican City State)'),
321('VC', 'Saint Vincent and the Grenadines'),
322('VE', 'Venezuela, Bolivarian Republic of'),
323('VG', 'Virgin Islands, British'),
324('VI', 'Virgin Islands, U.S.'),
325('VN', 'Viet Nam'),
326('VU', 'Vanuatu'),
327('WF', 'Wallis and Futuna'),
328('WS', 'Samoa'),
329('YE', 'Yemen'),
330('YT', 'Mayotte'),
331('ZA', 'South Africa'),
332('ZM', 'Zambia'),
333('ZW', 'Zimbabwe');
334
335-- --------------------------------------------------------
336
337--
338-- Table structure for table `EVENT`
339--
340
341CREATE TABLE IF NOT EXISTS `EVENT` (
342 `Event_Id` int(2) NOT NULL DEFAULT '0',
343 `Event_Name` varchar(100) DEFAULT NULL,
344 `Minimum_Qualifying_Time` double DEFAULT NULL,
345 PRIMARY KEY (`Event_Id`)
346) ENGINE=InnoDB DEFAULT CHARSET=utf8;
347
348--
349-- Dumping data for table `EVENT`
350--
351
352INSERT INTO `EVENT` (`Event_Id`, `Event_Name`, `Minimum_Qualifying_Time`) VALUES
353(1, '50m Backstroke - Men', 25.52),
354(2, '50m Backstroke - Women', 28.56),
355(3, '50m Breaststroke - Men', 27.74),
356(4, '50m Breaststroke - Women', 31.49),
357(5, '50m Butterfly - Men', 23.87),
358(6, '50m Butterfly - Women', 26.43),
359(7, '50m Freestyle - Men', 22.32),
360(8, '50m Freestyle - Women', 25.12),
361(9, '100m Backstroke - Men', 54.43),
362(10, '100m Backstroke - Women', 0),
363(11, '100m Breaststroke - Men', 0),
364(12, '100m Breaststroke - Women', 0),
365(13, '100m Butterfly - Men', 52.45),
366(14, '100m Butterfly - Women', 58.35),
367(15, '100m Freestyle - Men', 49.16),
368(16, '100m Freestyle - Women', 54.53),
369(17, '200m Backstroke - Men', 0),
370(18, '200m Backstroke - Women', 0),
371(19, '200m Breaststroke - Men', 0),
372(20, '200m Breaststroke - Women', 0),
373(21, '200m Butterfly - Men', 0),
374(22, '200m Butterfly - Women', 0),
375(23, '200m Freestyle - Men', 0),
376(24, '200m Freestyle - Women', 0),
377(25, '200m Individual Medley - Men', 0),
378(26, '200m Individual Medley - Women', 0),
379(27, '400m Freestyle - Men', 0),
380(28, '400m Freestyle - Women', 0),
381(29, '400m Individual Medley - Men', 0),
382(30, '400m Individual Medley - Women', 0),
383(31, '800m Freestyle - Men', 0),
384(32, '800m Freestyle - Women', 0),
385(33, '1500m Freestyle - Men', 0),
386(34, '1500m Freestyle - Women (!)', 0),
387(35, '4 x 100m Freestyle Relay - Men', 0),
388(36, '4 x 100m Freestyle Relay - Women', 0),
389(37, '4 x 100m Medley Relay - Men', 0),
390(38, '4 x 100m Medley Relay - Women', 0),
391(39, '4 x 200m Freestyle Relay - Men', 0),
392(40, '4 x 200m Freestyle Relay - Women', 0);
393
394-- --------------------------------------------------------
395
396--
397-- Table structure for table `EVENTSWIMMERREGISTRATION`
398--
399
400CREATE TABLE IF NOT EXISTS `EVENTSWIMMERREGISTRATION` (
401 `Event_ID` int(2) NOT NULL DEFAULT '0',
402 `Swimmer_ID` varchar(3) NOT NULL DEFAULT '',
403 `Qualifying_Time` double DEFAULT NULL,
404 `Qualifying_Date` varchar(100) DEFAULT NULL,
405 `Qualifying_Competition` varchar(100) DEFAULT NULL,
406 PRIMARY KEY (`Event_ID`,`Swimmer_ID`),
407 KEY `Swimmer_ID` (`Swimmer_ID`)
408) ENGINE=InnoDB DEFAULT CHARSET=utf8;
409
410--
411-- Dumping data for table `EVENTSWIMMERREGISTRATION`
412--
413
414INSERT INTO `EVENTSWIMMERREGISTRATION` (`Event_ID`, `Swimmer_ID`, `Qualifying_Time`, `Qualifying_Date`, `Qualifying_Competition`) VALUES
415(2, 'S13', 25.65, '6/10/17', 'Pan Pacific'),
416(2, 'S14', 27.39, '20/9/17', 'United States Swimming National Championships'),
417(2, 'S16', 26.22, '15/8/17', 'European Junior Swimming Championships'),
418(2, 'S21', 25.35, '2/1/17', 'World Junior Championships'),
419(2, 'S28', 25.92, '14/8/17', 'European Junior Swimming Championships'),
420(2, 'S5', 26.33, '15/8/17', 'European Junior Swimming Championships'),
421(7, 'S1', 25.59, '20/9/17', 'United States Swimming National Championships'),
422(7, 'S11', 21.92, '19/12/17', 'World Aquatics Championships'),
423(7, 'S27', 27.8, '2/1/17', 'World Junior Championships'),
424(7, 'S28', 21.92, '20/2/17', 'South East Asian Games (SEA)'),
425(7, 'S41', 22.4, '2/1/17', 'World Junior Championships'),
426(7, 'S42', 21.92, '18/11/17', 'World Aquatics Championships'),
427(8, 'S10', 24.53, '2/1/17', 'World Junior Championships'),
428(8, 'S12', 25.59, '2/1/17', 'World Junior Championships'),
429(8, 'S15', 26.03, '20/2/17', 'South East Asian Games (SEA)'),
430(8, 'S17', 24.12, '19/12/17', 'World Aquatics Championships'),
431(8, 'S18', 24.12, '18/11/17', 'World Aquatics Championships'),
432(8, 'S19', 24.72, '6/7/17', 'Pan Pacific'),
433(8, 'S2', 23.55, '8/7/17', 'Pan Pacific'),
434(8, 'S20', 24.2, '15/8/17', 'European Junior Swimming Championships'),
435(8, 'S22', 26.19, '20/9/17', 'United States Swimming National Championships'),
436(8, 'S23', 26.3, '18/11/17', 'World Aquatics Championships'),
437(8, 'S24', 25.13, '20/2/17', 'South East Asian Games (SEA)'),
438(8, 'S25', 25.02, '8/7/17', 'Pan Pacific'),
439(8, 'S27', 26.3, '18/11/17', 'World Aquatics Championships'),
440(8, 'S3', 24.53, '20/9/17', 'United States Swimming National Championships'),
441(8, 'S30', 27.09, '8/7/17', 'Pan Pacific'),
442(8, 'S31', 24.15, '6/10/17', 'Pan Pacific'),
443(8, 'S32', 24.45, '6/7/17', 'Pan Pacific'),
444(8, 'S33', 26.49, '15/8/17', 'European Junior Swimming Championships'),
445(8, 'S34', 24.2, '14/8/17', 'European Junior Swimming Championships'),
446(8, 'S35', 25.43, '6/10/17', 'Pan Pacific'),
447(8, 'S36', 25.73, '20/9/17', 'United States Swimming National Championships'),
448(8, 'S37', 24.75, '8/7/17', 'Pan Pacific'),
449(8, 'S38', 25.62, '15/8/17', 'European Junior Swimming Championships'),
450(8, 'S39', 25.05, '15/8/17', 'European Junior Swimming Championships'),
451(8, 'S40', 25.32, '8/7/17', 'Pan Pacific'),
452(8, 'S41', 26.79, '15/8/17', 'European Junior Swimming Championships'),
453(8, 'S43', 23.55, '18/11/17', 'World Aquatics Championships'),
454(8, 'S6', 24.42, '2/1/17', 'World Junior Championships'),
455(8, 'S7', 25.89, '2/1/17', 'World Junior Championships'),
456(8, 'S8', 24.83, '19/12/17', 'World Aquatics Championships'),
457(8, 'S9', 23.85, '20/9/17', 'United States Swimming National Championships'),
458(14, 'S34', 56.22, '8/7/17', 'Pan Pacific'),
459(17, 'S29', 53.5, '6/7/17', 'Pan Pacific'),
460(17, 'S42', 40.1, '14/8/17', 'European Junior Swimming Championships'),
461(18, 'S34', 49.02, '20/2/17', 'South East Asian Games (SEA)');
462
463-- --------------------------------------------------------
464
465--
466-- Table structure for table `INDIVIDUAL`
467--
468
469CREATE TABLE IF NOT EXISTS `INDIVIDUAL` (
470 `Individual_ID` int(2) NOT NULL DEFAULT '0',
471 `Individual_Type` varchar(14) DEFAULT NULL,
472 `Name` varchar(16) DEFAULT NULL,
473 `Country` varchar(2) DEFAULT NULL,
474 `Address` varchar(33) DEFAULT NULL,
475 `City` varchar(23) DEFAULT NULL,
476 `State` varchar(5) DEFAULT NULL,
477 `Postcode` int(4) DEFAULT NULL,
478 `Email` varchar(26) DEFAULT NULL,
479 `Contact_Mobile` varchar(12) DEFAULT NULL,
480 PRIMARY KEY (`Individual_ID`),
481 KEY `Country` (`Country`)
482) ENGINE=InnoDB DEFAULT CHARSET=utf8;
483
484--
485-- Dumping data for table `INDIVIDUAL`
486--
487
488INSERT INTO `INDIVIDUAL` (`Individual_ID`, `Individual_Type`, `Name`, `Country`, `Address`, `City`, `State`, `Postcode`, `Email`, `Contact_Mobile`) VALUES
489(1, 'Swimmer', 'Ella Cook', 'NZ', '673-4905 Donec Road', 'Spresiano', 'NT', 1028, 'Ella Cook@gmail.com', '0415 088 044'),
490(2, 'Swimmer', 'Indi Innes', 'IN', '831 Non Avenue', 'Kortrijk', 'NT', 1120, 'Indi Innes@gmail.com', '0415 234 573'),
491(3, 'Swimmer', 'Collette Dudley', 'AU', '6176 Nec Rd.', 'Bicester', 'NT', 1639, 'Collette Dudley@gmail.com', '0415 265 800'),
492(4, 'Swimmer', 'Bronte Connor', 'IO', '5515 Rutrum Street', 'Lublin', 'NT', 1765, 'Bronte Connor@gmail.com', '0415 496 955'),
493(5, 'Swimmer', 'Betty Blue', 'AU', '12 Potter Avenue', 'Pottsville', 'NSW', 2433, 'Betty Blue@gmail.com', '0423 777 555'),
494(6, 'Swimmer', 'Jazmin Slater', 'ZA', '8770 Pharetra Road', 'Oranienburg', 'NSW', 2956, 'Jazmin Slater@gmail.com', '0415 956 858'),
495(7, 'Swimmer', 'Colina Cannes', 'CA', '613-3725 Natoque St.', 'Red Deer', 'VIC', 3564, 'Colina Cannes@gmail.com', '0415 579 026'),
496(8, 'Swimmer', 'Justine Jetty', 'KE', '9120 Ut Ave', 'Mühlheim am Main', 'VIC', 3936, 'Justine Jetty@gmail.com', '0415 482 199'),
497(9, 'Swimmer', 'Emily Davies', 'TT', '7096 Malesuada Rd.', 'Doetinchem', 'QLD', 4053, 'Emily Davies@gmail.com', '0415 573 236'),
498(10, 'Swimmer', 'Jenny Myles', 'JM', '908-8505 Facilisis Avenue', 'Boston', 'QLD', 4404, 'Jenny Myles@gmail.com', '0415 904 871'),
499(11, 'Swimmer', 'Brittany Barratt', 'TO', '528-4851 Ut, Rd.', 'Goulburn', 'QLD', 4406, 'Brittany Barratt@gmail.com', '0415 488 077'),
500(12, 'Swimmer', 'Hannah Roy', 'AU', '7531 Hymenaeos. Rd.', 'Rankweil', 'SA', 5121, 'Hannah Roy@gmail.com', '0415 775 765'),
501(13, 'Swimmer', 'Hu Thompson', 'AU', '7566 At, Av.', 'Alto Hospicio', 'SA', 5971, 'Hu Thompson@gmail.com', '0415 131 096'),
502(14, 'Swimmer', 'Cat Cinchilla', 'CA', '585-4400 Libero. Rd.', 'Curaco de Vélez', 'WA', 6699, 'Cat Cinchilla@gmail.com', '0415 329 570'),
503(15, 'Swimmer', 'Bliss Brown', 'IO', '4892 Commodo Road', 'Stendal', 'TAS', 7512, 'Bliss Brown@gmail.com', '0415 133 547'),
504(16, 'Swimmer', 'Georgia Quigley', 'TT', '7517 Euismod St.', 'Arauco', 'TAS', 7873, 'Georgia Quigley@gmail.com', '0415 442 456'),
505(17, 'Swimmer', 'Bob Brown', 'BM', '4974 Ullamcorper. St.', 'Huntley', 'NSW', 2303, 'Bob Brown@gmail.com', '0415 696 122'),
506(18, 'Swimmer', 'India Woods', 'AU', '8464 Eu, Avenue', 'Wanzele', 'NSW', 2425, 'India Woods@gmail.com', '0415 727 415'),
507(19, 'Swimmer', 'Cate Crown', 'CA', '5950 Vestibulum St.', 'Cantalupo in Sabina', 'NSW', 2220, 'Cate Crown@gmail.com', '0415 336 747'),
508(20, 'Swimmer', 'Emma Patterson', 'TZ', '7266 Mauris Ave', 'Traiguén', 'NSW', 2017, 'Emma Patterson@gmail.com', '0415 117 691'),
509(21, 'Swimmer', 'Betina Black', 'IO', '9225 Libero. Rd.', 'Halifax', 'NSW', 2134, 'Betina Black@gmail.com', '0415 291 024'),
510(22, 'Swimmer', 'Jenny Jubes', 'JM', '8786 Maecenas Avenue', 'Fumal', 'NSW', 2222, 'Jenny Jubes@gmail.com', '0415 639 716'),
511(23, 'Swimmer', 'Francesca Hill', 'ZA', '7348 Sed St.', 'Liévin', 'NSW', 2302, 'Francesca Hill@gmail.com', '0415 361 193'),
512(24, 'Swimmer', 'Dane Potter', 'AU', '6335 Metus. Street', 'Spoleto', 'NSW', 2572, 'Dane Potter@gmail.com', '0415 218 972'),
513(25, 'Swimmer', 'Kathy Kenny', 'TO', 'Ap #748-5967 Non, Rd.', 'Giugliano in Campania', 'NSW', 2222, 'Kathy Kenny@gmail.com', '0415 697 935'),
514(26, 'Swimmer', 'Ken Stuart', 'IO', '976-9856 Et Street', 'Beaumont', 'NSW', 2233, 'Ken Stuart@gmail.com', '0415 035 497'),
515(27, 'Swimmer', 'Kimberley Kerr', 'ZA', 'Ap #814-3340 Risus. Ave', 'Portsmouth', 'VIC', 3079, 'Kimberley Kerr@gmail.com', '0415 394 622'),
516(28, 'Swimmer', 'Lauren Carlin', 'NZ', 'Ap #668-384 Arcu. St.', 'Heidenheim', 'VIC', 3850, 'Lauren Carlin@gmail.com', '0415 609 075'),
517(29, 'Swimmer', 'Lucas Morse', 'SG', 'Ap #110-3658 Sit Av.', 'Honolulu', 'VIC', 3990, 'Lucas Morse@gmail.com', '0415 861 965'),
518(30, 'Swimmer', 'Maddy Smith', 'IM', 'Ap #310-3654 Vel St.', 'WanfercŽe-Baulet', 'QLD', 4221, 'Maddy Smith@gmail.com', '0415 996 347'),
519(31, 'Swimmer', 'Mannie Minx', 'NL', 'Ap #454-980 Quam Road', 'Gravelbourg', 'QLD', 4556, 'Mannie Minx@gmail.com', '0415 230 233'),
520(32, 'Swimmer', 'Natalie North', 'PK', 'Ap #673-3582 Litora Road', 'Rishra', 'QLD', 4905, 'Natalie North@gmail.com', '0415 827 188'),
521(33, 'Swimmer', 'Peggy Stanley', 'AU', 'Ap #489-5714 Purus. St.', 'Alert Bay', 'SA', 5341, 'Peggy Stanley@gmail.com', '0415 714 286'),
522(34, 'Swimmer', 'Rebekah Riley', 'RW', 'Ap #618-7162 Id, St.', 'Price', 'SA', 5369, 'Rebekah Riley@gmail.com', '0415 067 644'),
523(35, 'Swimmer', 'Ronnie Wand', 'TO', '983-9568 Quisque St.', 'Nieuwmunster', 'WA', 6247, 'Ronnie Wand@gmail.com', '0415 493 139'),
524(36, 'Swimmer', 'Sally Sandman', 'TO', '938-1116 Primis Street', 'Castanhal', 'WA', 6606, 'Sally Sandman@gmail.com', '0415 240 109'),
525(37, 'Swimmer', 'Sandy Landy', 'SL', '958-9958 Et St.', 'Santa Bárbara', 'WA', 6904, 'Sandy Landy@gmail.com', '0415 076 091'),
526(38, 'Swimmer', 'Serra Land', 'SG', 'P.O. Box 100, 1262 Lectus. Avenue', 'Beerse', 'TAS', 7341, 'Serra Land@gmail.com', '0415 439 261'),
527(39, 'Swimmer', 'Singing Sue', 'SH', 'Ap #642-628 Felis. Rd.', 'San Rafael', 'TAS', 7946, 'Singing Sue@gmail.com', '0415 189 210'),
528(40, 'Swimmer', 'Special Harmon', 'TO', 'Ap #726-3521 Montes, St.', 'Matagami', 'TAS', 7984, 'Special Harmon@gmail.com', '0415 386 823'),
529(41, 'Swimmer', 'Sue Simpson', 'TT', 'Ap #226-7354 Porttitor Rd.', 'Campinas', 'NSW', 2201, 'Sue Simpson@gmail.com', '0415 937 104'),
530(42, 'Swimmer', 'Tony Ratcliffe', 'RW', 'Ap #958-523 Vitae Street', 'Hualpén', 'NSW', 2230, 'Tony Ratcliffe@gmail.com', '0415 349 532'),
531(43, 'Swimmer', 'Zorita Kim', 'RW', 'Ap #690-9016 Lectus. Road', 'GŽrouville', 'NSW', 2052, 'Zorita Kim@gmail.com', '0415 729 127'),
532(44, 'Swimmer', 'Barry White', 'IO', 'Ap #203-955 Sagittis Rd.', 'Alness', 'NSW', 2220, 'Barry White@gmail.com', '0415 257 351'),
533(45, 'Swimmer', 'Bob Brittany', 'IO', 'P.O. Box 120, 3134 At Avenue', 'Forchtenstein', 'SA', 5666, 'Bob Brittany@gmail.com', '0415 723 190'),
534(46, 'Coach', 'Jennifer Brown', 'AU', '3/73 Mauris Avenue', 'Evans Head', ' NSW ', 2473, 'Jennifer Brown@gmail.com', '0411 234567'),
535(47, 'Coach', 'Benjamin Yang', 'AU', '4816 Mauris St.', 'Beigem', 'WA', 6906, 'Benjamin Yang@gmail.com', '0415 330 183'),
536(48, 'Coach', 'Jonathan Singh', 'AU', '177-1765 Nunc Av.', 'Rauco', 'TAS', 7211, 'Jonathan Singh@gmail.com', '0415 783 240'),
537(49, 'Coach', 'Boogy Bermy', 'BM', '454-180 Ridiculus Avenue', 'Los Angeles', 'TAS', 7031, 'Boogy Bermy@gmail.com', '0415 581 322'),
538(50, 'Coach', 'Bill Brown', 'IO', '485-4275 Donec Rd.', 'Rae Lakes', 'TAS', 7479, 'Bill Brown@gmail.com', '0415 163 940'),
539(51, 'Coach', 'Cool Cat', 'CA', '2380 Ut St.', 'Hervey Bay', 'WA', 6528, 'Cool Cat@gmail.com', '0415 003 922'),
540(52, 'Coach', 'Innes Indy', 'IN', '241-8201 Eu Street', 'Gjoa Haven', ' NSW ', 2796, 'Innes Indy@gmail.com', '0415 243 270'),
541(53, 'Coach', 'Island Man', 'IM', '245-5949 Vehicula St.', 'Sant''Angelo a Fasanella', ' NSW ', 2652, 'Island Man@gmail.com', '0415 281 118'),
542(54, 'Coach', 'Jammin Juice', 'JM', '254-7049 Pede. Street', 'Chaitén', ' NSW ', 2994, 'Jammin Juice@gmail.com', '0415 184 363'),
543(55, 'Coach', 'Keith Kenyan', 'KE', '263-5742 Enim. St.', 'Lake Cowichan', 'WA', 6317, 'Keith Kenyan@gmail.com', '0415 742 477'),
544(56, 'Coach', 'Nelly Newzie', 'NZ', '1875 Nec Road', 'Leamington', 'WA', 6097, 'Nelly Newzie@gmail.com', '0415 993 093'),
545(57, 'Coach', 'Noddy North', 'NL', '271-5702 Consequat, Rd.', 'Sulzbach', ' NSW ', 2035, 'Noddy North@gmail.com', '0415 853 575'),
546(58, 'Coach', 'Peter Parker', 'PK', '2790 Facilisis Rd.', 'Francavilla in Sinni', 'VIC', 3759, 'Peter Parker@gmail.com', '0415 778 660'),
547(59, 'Coach', 'Rowie Roundtree', 'RW', '292-1554 Tempor Road', 'Gorzów Wielkopolski', 'TAS', 7663, 'Rowie Roundtree@gmail.com', '0415 175 638'),
548(60, 'Coach', 'Saint Helen', 'SH', '295 A Rd.', 'Auburn', 'SA', 5672, 'Saint Helen@gmail.com', '0415 986 775'),
549(61, 'Coach', 'Susan Scotty', 'TO', '2037 Risus Road', 'Hulshout', 'WA', 6599, 'Susan Scotty@gmail.com', '0415 676 292'),
550(62, 'Coach', 'Leonie Sera', 'SL', '3025 Luctus Road', 'Andernach', 'TAS', 7417, 'Leonie Sera@gmail.com', '0415 027 992'),
551(63, 'Coach', 'Steven Singh', 'SG', '3347 Euismod Ave', 'Quibby City', ' NSW ', 2242, 'Steven Singh@gmail.com', '0415 171 372'),
552(64, 'Coach', 'Suth Stevens', 'ZA', '345-3924 Fringilla Av.', 'Dufftown', ' NSW ', 2451, 'Suth Stevens@gmail.com', '0415 359 574'),
553(65, 'Coach', 'Tommy Tanny', 'TZ', '3459 Orci Avenue', 'Konin', 'SA', 5199, 'Tommy Tanny@gmail.com', '0415 328 722'),
554(66, 'Coach', 'Therese Tong', 'TO', '3672 Augue, Street', 'Uberaba', ' NSW ', 2826, 'Therese Tong@gmail.com', '0415 781 343'),
555(67, 'Coach', 'Tommy Taboggin', 'TT', '431-2939 Lorem, Rd.', 'Pune', ' NSW ', 2234, 'Tommy Taboggin@gmail.com', '0415 093 551'),
556(68, 'Coach', 'Trina Toga', 'TT', '378-7271 Amet Rd.', 'Bundaberg', 'WA', 6782, 'Trina Toga@gmail.com', '0415 165 402'),
557(69, 'MedicalOfficer', 'Kiona Sykes', 'AU', 'P.O. Box 206, 6847 A, Rd.', 'Tione di Trento', 'WA', 6915, 'Kiona Sykes@gmail.com', '0412 555 666'),
558(70, 'MedicalOfficer', 'Alan Ozzie', 'AU', 'P.O. Box 227, 1682 Cum St.', 'Landeck', 'NSW', 2666, 'Alan Ozzie@gmail.com', '0411 888 666'),
559(71, 'MedicalOfficer', 'Bobby Brown', 'IO', 'P.O. Box 255, 3251 Diam Av.', 'Großpetersdorf', 'NSW', 2444, 'Bobby Brown@gmail.com', '0414 333 234'),
560(72, 'MedicalOfficer', 'Sally Stuart', 'TO', 'P.O. Box 273, 7892 Aliquam Ave', 'Momignies', 'TAS', 7766, 'Sally Stuart@gmail.com', '0411 876 543'),
561(73, 'MedicalOfficer', 'Noddy Zimmer', 'NZ', 'P.O. Box 347, 6201 Sed Street', 'Candela', 'VIC', 3226, 'Noddy Zimmer@gmail.com', '0421 000 666'),
562(74, 'OtherContact', 'Jenny Myles', 'AU', 'P.O. Box 408, 798 Ornare, Av.', 'Roveredo in Piano', 'VIC', 3670, 'Jenny Myles@gmail.com', '0415 231 891');
563
564-- --------------------------------------------------------
565
566--
567-- Table structure for table `MEDICALOFFICER`
568--
569
570CREATE TABLE IF NOT EXISTS `MEDICALOFFICER` (
571 `Individual_Id` int(2) NOT NULL DEFAULT '0',
572 `Qualifications` varchar(4) DEFAULT NULL,
573 `Qualification Year` int(4) DEFAULT NULL,
574 `Specialisation` varchar(12) DEFAULT NULL,
575 PRIMARY KEY (`Individual_Id`)
576) ENGINE=InnoDB DEFAULT CHARSET=utf8;
577
578--
579-- Dumping data for table `MEDICALOFFICER`
580--
581
582INSERT INTO `MEDICALOFFICER` (`Individual_Id`, `Qualifications`, `Qualification Year`, `Specialisation`) VALUES
583(69, 'MD', 1996, 'Orthopaedics'),
584(70, 'MD', 2001, ''),
585(71, 'MD', 1978, ''),
586(72, 'MBBS', 1990, 'Surgery');
587
588-- --------------------------------------------------------
589
590--
591-- Table structure for table `OTHERCONTACT`
592--
593
594CREATE TABLE IF NOT EXISTS `OTHERCONTACT` (
595 `Individual_Id` int(2) NOT NULL,
596 `Contact_Type` varchar(20) NOT NULL,
597 PRIMARY KEY (`Individual_Id`)
598) ENGINE=InnoDB DEFAULT CHARSET=utf8;
599
600--
601-- Dumping data for table `OTHERCONTACT`
602--
603
604INSERT INTO `OTHERCONTACT` (`Individual_Id`, `Contact_Type`) VALUES
605(73, 'Team Manager');
606
607-- --------------------------------------------------------
608
609--
610-- Table structure for table `POOL`
611--
612
613CREATE TABLE IF NOT EXISTS `POOL` (
614 `Pool_ID` int(1) NOT NULL DEFAULT '0',
615 `Pool_Name` varchar(16) DEFAULT NULL,
616 `Lane_Count` varchar(3) DEFAULT NULL,
617 `Length` int(2) DEFAULT NULL,
618 PRIMARY KEY (`Pool_ID`)
619) ENGINE=InnoDB DEFAULT CHARSET=utf8;
620
621--
622-- Dumping data for table `POOL`
623--
624
625INSERT INTO `POOL` (`Pool_ID`, `Pool_Name`, `Lane_Count`, `Length`) VALUES
626(1, 'Competition Pool', '10', 50),
627(2, 'Training Pool', '8', 50),
628(3, 'Program pool', '7', 25),
629(4, 'Diving Pool', 'N/A', 33);
630
631-- --------------------------------------------------------
632
633--
634-- Table structure for table `RACE`
635--
636
637CREATE TABLE IF NOT EXISTS `RACE` (
638 `Race_ID` int(2) NOT NULL DEFAULT '0',
639 `Event_ID` int(1) DEFAULT NULL,
640 `Race_Name` varchar(12) DEFAULT NULL,
641 `Day` int(1) DEFAULT NULL,
642 `Start_Time` varchar(5) DEFAULT NULL,
643 `Location_Pool` int(1) DEFAULT NULL,
644 PRIMARY KEY (`Race_ID`),
645 KEY `Event_ID` (`Event_ID`),
646 KEY `Location_Pool` (`Location_Pool`)
647) ENGINE=InnoDB DEFAULT CHARSET=utf8;
648
649--
650-- Dumping data for table `RACE`
651--
652
653INSERT INTO `RACE` (`Race_ID`, `Event_ID`, `Race_Name`, `Day`, `Start_Time`, `Location_Pool`) VALUES
654(1, 8, 'Heat 1', 1, '10:15', 2),
655(2, 8, 'Heat 2', 1, '10:20', 2),
656(3, 8, 'Heat 3', 1, '10:25', 2),
657(4, 8, 'Heat 4', 1, '10:30', 2),
658(5, 8, 'Semi-Final 1', 1, '10:45', 1),
659(6, 8, 'Semi-Final 2', 1, '10:50', 1),
660(7, 8, 'Final', 1, '10:55', 1),
661(8, 7, 'Heat 1', 1, '11:15', 2),
662(9, 7, 'Heat 2', 1, '11:20', 2),
663(10, 7, 'Heat 3', 1, '11:25', 2),
664(11, 7, 'Heat 4', 1, '11:30', 2),
665(12, 7, 'Semi-Final 1', 1, '11:45', 1),
666(13, 7, 'Semi-Final 2', 1, '11:50', 1),
667(14, 7, 'Final', 1, '11:55', 1);
668
669-- --------------------------------------------------------
670
671--
672-- Table structure for table `RACESWIMMER`
673--
674
675CREATE TABLE IF NOT EXISTS `RACESWIMMER` (
676 `Race_Id` int(2) NOT NULL DEFAULT '0',
677 `Swimmer_Id` varchar(3) NOT NULL DEFAULT '',
678 `Lane` int(1) DEFAULT NULL,
679 `Recorded_Time` double DEFAULT NULL,
680 `Place` int(1) DEFAULT NULL,
681 PRIMARY KEY (`Race_Id`,`Swimmer_Id`),
682 KEY `Swimmer_Id` (`Swimmer_Id`)
683) ENGINE=InnoDB DEFAULT CHARSET=utf8;
684
685--
686-- Dumping data for table `RACESWIMMER`
687--
688
689INSERT INTO `RACESWIMMER` (`Race_Id`, `Swimmer_Id`, `Lane`, `Recorded_Time`, `Place`) VALUES
690(1, 'S10', 6, 25.23, 0),
691(1, 'S12', 5, 23, 1),
692(1, 'S17', 3, 24, 4),
693(1, 'S20', 7, 24.3, 0),
694(1, 'S23', 2, 23.55, 2),
695(1, 'S27', 8, 24.34, 0),
696(1, 'S34', 1, 23.96, 3),
697(1, 'S43', 4, 24.01, 0),
698(2, 'S1', 3, 24.03, 4),
699(2, 'S18', 1, 23.99, 3),
700(2, 'S2', 2, 23.58, 2),
701(2, 'S3', 4, 24.04, 0),
702(2, 'S6', 5, 23.03, 1),
703(2, 'S7', 7, 24.33, 0),
704(2, 'S8', 8, 24.37, 0),
705(2, 'S9', 6, 25.26, 0),
706(3, 'S19', 1, 24, 3),
707(3, 'S22', 3, 24.04, 4),
708(3, 'S24', 4, 24.05, 0),
709(3, 'S25', 5, 23.04, 1),
710(3, 'S31', 2, 23.59, 2),
711(3, 'S32', 6, 25.27, 0),
712(3, 'S33', 7, 24.34, 0),
713(3, 'S35', 8, 24.38, 0),
714(4, 'S15', 8, 24.4, 0),
715(4, 'S30', 7, 24.36, 0),
716(4, 'S36', 4, 24.07, 0),
717(4, 'S37', 2, 23.61, 2),
718(4, 'S38', 5, 23.06, 1),
719(4, 'S39', 6, 25.29, 0),
720(4, 'S40', 1, 24.02, 3),
721(4, 'S41', 3, 24.06, 4),
722(5, 'S1', 1, 24.005, 0),
723(5, 'S12', 4, 23.935, 5),
724(5, 'S17', 5, 23.965, 0),
725(5, 'S18', 6, 23.975, 0),
726(5, 'S2', 2, 22.975, 1),
727(5, 'S23', 7, 23.015, 3),
728(5, 'S34', 8, 23.005, 2),
729(5, 'S6', 3, 23.525, 4),
730(6, 'S19', 1, 24.035, 0),
731(6, 'S22', 2, 23.065, 2),
732(6, 'S25', 3, 23.555, 3),
733(6, 'S31', 4, 23.585, 5),
734(6, 'S37', 5, 24.015, 0),
735(6, 'S38', 6, 23.565, 4),
736(6, 'S40', 7, 23.035, 1),
737(6, 'S41', 8, 23.995, 0),
738(7, 'S12', 5, 23.035, 0),
739(7, 'S2', 1, 22.75, 1),
740(7, 'S22', 7, 23.555, 0),
741(7, 'S23', 3, 23.005, 2),
742(7, 'S25', 8, 23.565, 0),
743(7, 'S31', 10, 23.525, 0),
744(7, 'S34', 2, 23.015, 3),
745(7, 'S38', 9, 23.585, 0),
746(7, 'S40', 6, 23.065, 0),
747(7, 'S6', 4, 23.935, 0),
748(8, 'S11', 2, 0, 0),
749(8, 'S26', 3, 0, 0),
750(8, 'S29', 4, 0, 0),
751(8, 'S4', 1, 0, 0),
752(8, 'S41', 5, 0, 0),
753(8, 'S42', 6, 0, 0),
754(8, 'S44', 7, 0, 0),
755(8, 'S45', 8, 0, 0);
756
757-- --------------------------------------------------------
758
759--
760-- Table structure for table `SWIMMER`
761--
762
763CREATE TABLE IF NOT EXISTS `SWIMMER` (
764 `Swimmer_ID` varchar(3) NOT NULL DEFAULT '',
765 `Individual_ID` int(2) DEFAULT NULL,
766 `Swimmer_Name` varchar(16) DEFAULT NULL,
767 `Gender` varchar(6) DEFAULT NULL,
768 `Date_Of_Birth` varchar(10) DEFAULT NULL,
769 `Coach_ID` varchar(3) DEFAULT NULL,
770 PRIMARY KEY (`Swimmer_ID`),
771 KEY `Individual_ID` (`Individual_ID`,`Coach_ID`),
772 KEY `Coach_ID` (`Coach_ID`)
773) ENGINE=InnoDB DEFAULT CHARSET=utf8;
774
775--
776-- Dumping data for table `SWIMMER`
777--
778
779INSERT INTO `SWIMMER` (`Swimmer_ID`, `Individual_ID`, `Swimmer_Name`, `Gender`, `Date_Of_Birth`, `Coach_ID`) VALUES
780('S1', 1, 'Ella Cook', 'Female', '09/17/2000', 'C1'),
781('S10', 10, 'Jenny Myles', 'Female', '11/03/1995', 'C8'),
782('S11', 11, 'Brittany Barratt', 'Female', '03/30/1991', 'C19'),
783('S12', 12, 'Hannah Roy', 'Female', '12/19/2001', 'C2'),
784('S13', 13, 'Hu Thompson', 'Female', '07/01/1992', 'C2'),
785('S14', 14, 'Cat Cinchilla', 'Female', '12/31/2001', 'C5'),
786('S15', 15, 'Bliss Brown', 'Female', '10/24/1991', 'C4'),
787('S16', 16, 'Georgia Quigley', 'Female', '10/25/1992', 'C22'),
788('S17', 17, 'Bob Brown', 'Male', '08/17/2002', 'C3'),
789('S18', 18, 'India Woods', 'Female', '11/05/1993', 'C3'),
790('S19', 19, 'Cate Crown', 'Female', '10/18/1993', 'C5'),
791('S2', 2, 'Indi Innes', 'Female', '01/24/1991', 'C6'),
792('S20', 20, 'Emma Patterson', 'Female', '03/25/1998', 'C19'),
793('S21', 21, 'Betina Black', 'Female', '07/12/1995', 'C4'),
794('S22', 22, 'Jenny Jubes', 'Female', '08/08/1999', 'C8'),
795('S23', 23, 'Francesca Hill', 'Female', '12/13/1996', 'C18'),
796('S24', 24, 'Dane Potter', 'Male', '07/29/1998', 'C13'),
797('S25', 25, 'Kathy Kenny', 'Female', '04/09/1993', 'C15'),
798('S26', 26, 'Ken Stuart', 'Male', '10/31/1997', 'C4'),
799('S27', 27, 'Kimberley Kerr', 'Female', '07/27/1997', 'C18'),
800('S28', 28, 'Lauren Carlin', 'Female', '07/07/1991', 'C10'),
801('S29', 29, 'Lucas Morse', 'Male', '09/15/1998', 'C17'),
802('S3', 3, 'Collette Dudley', 'Female', '02/25/1995', 'C1'),
803('S30', 30, 'Maddy Smith', 'Female', '12/03/1994', 'C7'),
804('S31', 31, 'Mannie Minx', 'Female', '01/19/1991', 'C11'),
805('S32', 32, 'Natalie North', 'Female', '05/28/1991', 'C12'),
806('S33', 33, 'Peggy Stanley', 'Female', '08/08/1994', 'C1'),
807('S34', 34, 'Rebekah Riley', 'Female', '03/21/2001', 'C12'),
808('S35', 35, 'Ronnie Wand', 'Female', '12/13/1991', 'C15'),
809('S36', 36, 'Sally Sandman', 'Female', '03/07/1992', 'C15'),
810('S37', 37, 'Sandy Landy', 'Female', '08/12/1991', 'C16'),
811('S38', 38, 'Serra Land', 'Female', '03/29/1998', 'C17'),
812('S39', 39, 'Singing Sue', 'Female', '09/27/1994', 'C14'),
813('S4', 4, 'Bronte Connor', 'Female', '05/15/1992', 'C4'),
814('S40', 40, 'Special Harmon', 'Female', '08/21/1998', 'C15'),
815('S41', 41, 'Sue Simpson', 'Male', '03/07/1993', 'C22'),
816('S42', 42, 'Tony Ratcliffe', 'Male', '08/12/1992', 'C12'),
817('S43', 43, 'Zorita Kim', 'Female', '03/29/1999', 'C7'),
818('S44', 44, 'Barry White', 'Male', '09/27/1995', 'C4'),
819('S45', 45, 'Bob Brittany', 'Male', '08/21/1999', 'C4'),
820('S5', 5, 'Betty Blue', 'Female', '09/02/1993', 'C1'),
821('S6', 6, 'Jazmin Slater', 'Female', '03/05/2002', 'C18'),
822('S7', 7, 'Colina Cannes', 'Female', '05/31/1991', 'C5'),
823('S8', 8, 'Justine Jetty', 'Female', '09/04/1997', 'C4'),
824('S9', 9, 'Emily Davies', 'Female', '05/14/1997', 'C20');
825
826-- --------------------------------------------------------
827
828--
829-- Table structure for table `TEAM`
830--
831
832CREATE TABLE IF NOT EXISTS `TEAM` (
833 `Team_ID` varchar(3) NOT NULL DEFAULT '',
834 `Coach_ID` varchar(3) DEFAULT NULL,
835 `Medical_Officer` int(2) DEFAULT NULL,
836 `Team_Leader` varchar(3) DEFAULT NULL,
837 `Team_Manager` int(2) DEFAULT NULL,
838 PRIMARY KEY (`Team_ID`),
839 KEY `Coach_ID` (`Coach_ID`,`Medical_Officer`,`Team_Leader`,`Team_Manager`),
840 KEY `Team_Leader` (`Team_Leader`),
841 KEY `Team_Manager` (`Team_Manager`),
842 KEY `Medical_Officer` (`Medical_Officer`),
843 KEY `Coach_ID_2` (`Coach_ID`,`Medical_Officer`,`Team_Leader`,`Team_Manager`)
844) ENGINE=InnoDB DEFAULT CHARSET=utf8;
845
846--
847-- Dumping data for table `TEAM`
848--
849
850INSERT INTO `TEAM` (`Team_ID`, `Coach_ID`, `Medical_Officer`, `Team_Leader`, `Team_Manager`) VALUES
851('T1', '46', 69, 'S3', 30),
852('T2', '47', 70, 'S4', 31),
853('T3', '48', 71, 'S28', 32),
854('T4', '49', 72, 'S1', 33),
855('T5', '50', 73, 'S35', 34),
856('T6', '51', 69, 'S40', 35),
857('T7', '52', 70, 'S41', 36),
858('T8', '53', 71, 'S26', 37),
859('T9', '54', 72, 'S21', 38),
860('T10', '55', 73, 'S22', 39);
861
862-- --------------------------------------------------------
863
864--
865-- Table structure for table `TEAMSWIMMER`
866--
867
868CREATE TABLE IF NOT EXISTS `TEAMSWIMMER` (
869 `Team_ID` varchar(3) NOT NULL DEFAULT '',
870 `Swimmer_ID` varchar(3) NOT NULL DEFAULT '',
871 PRIMARY KEY (`Team_ID`,`Swimmer_ID`),
872 KEY `Swimmer_ID` (`Swimmer_ID`)
873) ENGINE=InnoDB DEFAULT CHARSET=utf8;
874
875--
876-- Dumping data for table `TEAMSWIMMER`
877--
878
879INSERT INTO `TEAMSWIMMER` (`Team_ID`, `Swimmer_ID`) VALUES
880('T1', 'S1'),
881('T2', 'S1'),
882('T9', 'S1'),
883('T6', 'S10'),
884('T2', 'S11'),
885('T2', 'S12'),
886('T5', 'S12'),
887('T6', 'S12'),
888('T8', 'S15'),
889('T1', 'S17'),
890('T3', 'S17'),
891('T2', 'S18'),
892('T9', 'S18'),
893('T4', 'S19'),
894('T5', 'S19'),
895('T1', 'S2'),
896('T10', 'S2'),
897('T8', 'S2'),
898('T7', 'S20'),
899('T2', 'S22'),
900('T6', 'S22'),
901('T7', 'S22'),
902('T3', 'S23'),
903('T4', 'S23'),
904('T9', 'S23'),
905('T8', 'S24'),
906('T2', 'S25'),
907('T7', 'S25'),
908('T9', 'S25'),
909('T1', 'S26'),
910('T8', 'S27'),
911('T2', 'S29'),
912('T2', 'S3'),
913('T1', 'S30'),
914('T7', 'S30'),
915('T10', 'S31'),
916('T6', 'S31'),
917('T8', 'S31'),
918('T10', 'S32'),
919('T1', 'S33'),
920('T1', 'S34'),
921('T2', 'S34'),
922('T4', 'S34'),
923('T2', 'S35'),
924('T4', 'S36'),
925('T2', 'S37'),
926('T9', 'S37'),
927('T10', 'S38'),
928('T5', 'S38'),
929('T9', 'S38'),
930('T6', 'S39'),
931('T1', 'S4'),
932('T1', 'S40'),
933('T3', 'S40'),
934('T6', 'S40'),
935('T2', 'S41'),
936('T3', 'S41'),
937('T4', 'S42'),
938('T4', 'S43'),
939('T5', 'S44'),
940('T6', 'S45'),
941('T1', 'S6'),
942('T4', 'S6'),
943('T3', 'S7'),
944('T4', 'S8'),
945('T2', 'S9');
946
947--
948-- Constraints for dumped tables
949--
950
951--
952-- Constraints for table `COACH`
953--
954ALTER TABLE `COACH`
955 ADD CONSTRAINT `COACH_ibfk_1` FOREIGN KEY (`Individual_Id`) REFERENCES `INDIVIDUAL` (`Individual_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
956
957--
958-- Constraints for table `EVENTSWIMMERREGISTRATION`
959--
960ALTER TABLE `EVENTSWIMMERREGISTRATION`
961 ADD CONSTRAINT `EVENTSWIMMERREGISTRATION_ibfk_3` FOREIGN KEY (`Event_ID`) REFERENCES `EVENT` (`Event_Id`),
962 ADD CONSTRAINT `EVENTSWIMMERREGISTRATION_ibfk_2` FOREIGN KEY (`Swimmer_ID`) REFERENCES `SWIMMER` (`Swimmer_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
963
964--
965-- Constraints for table `INDIVIDUAL`
966--
967ALTER TABLE `INDIVIDUAL`
968 ADD CONSTRAINT `INDIVIDUAL_ibfk_1` FOREIGN KEY (`Country`) REFERENCES `COUNTRY` (`Country_Code`);
969
970--
971-- Constraints for table `MEDICALOFFICER`
972--
973ALTER TABLE `MEDICALOFFICER`
974 ADD CONSTRAINT `MEDICALOFFICER_ibfk_1` FOREIGN KEY (`Individual_Id`) REFERENCES `INDIVIDUAL` (`Individual_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
975
976--
977-- Constraints for table `OTHERCONTACT`
978--
979ALTER TABLE `OTHERCONTACT`
980 ADD CONSTRAINT `OTHERCONTACT_ibfk_1` FOREIGN KEY (`Individual_Id`) REFERENCES `INDIVIDUAL` (`Individual_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
981
982--
983-- Constraints for table `RACE`
984--
985ALTER TABLE `RACE`
986 ADD CONSTRAINT `RACE_ibfk_3` FOREIGN KEY (`Event_ID`) REFERENCES `EVENT` (`Event_Id`),
987 ADD CONSTRAINT `RACE_ibfk_2` FOREIGN KEY (`Location_Pool`) REFERENCES `POOL` (`Pool_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
988
989--
990-- Constraints for table `RACESWIMMER`
991--
992ALTER TABLE `RACESWIMMER`
993 ADD CONSTRAINT `RACESWIMMER_ibfk_2` FOREIGN KEY (`Swimmer_Id`) REFERENCES `SWIMMER` (`Swimmer_ID`),
994 ADD CONSTRAINT `RACESWIMMER_ibfk_1` FOREIGN KEY (`Race_Id`) REFERENCES `RACE` (`Race_ID`);
995
996--
997-- Constraints for table `SWIMMER`
998--
999ALTER TABLE `SWIMMER`
1000 ADD CONSTRAINT `SWIMMER_ibfk_2` FOREIGN KEY (`Coach_ID`) REFERENCES `COACH` (`Coach_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
1001 ADD CONSTRAINT `SWIMMER_ibfk_1` FOREIGN KEY (`Individual_ID`) REFERENCES `INDIVIDUAL` (`Individual_ID`) ON DELETE CASCADE ON UPDATE CASCADE;
1002
1003--
1004-- Constraints for table `TEAM`
1005--
1006ALTER TABLE `TEAM`
1007 ADD CONSTRAINT `TEAM_ibfk_1` FOREIGN KEY (`Team_Leader`) REFERENCES `SWIMMER` (`Swimmer_ID`),
1008 ADD CONSTRAINT `TEAM_ibfk_2` FOREIGN KEY (`Team_Manager`) REFERENCES `INDIVIDUAL` (`Individual_ID`),
1009 ADD CONSTRAINT `TEAM_ibfk_3` FOREIGN KEY (`Medical_Officer`) REFERENCES `INDIVIDUAL` (`Individual_ID`);
1010
1011--
1012-- Constraints for table `TEAMSWIMMER`
1013--
1014ALTER TABLE `TEAMSWIMMER`
1015 ADD CONSTRAINT `TEAMSWIMMER_ibfk_2` FOREIGN KEY (`Team_ID`) REFERENCES `TEAM` (`Team_ID`),
1016 ADD CONSTRAINT `TEAMSWIMMER_ibfk_1` FOREIGN KEY (`Swimmer_ID`) REFERENCES `SWIMMER` (`Swimmer_ID`);
1017
1018/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1019/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1020/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;