· 10 years ago · Mar 01, 2016, 12:57 AM
1#
2# DUMP FILE
3#
4# Database is ported from MS Access
5#------------------------------------------------------------------
6# Created using "MS Access to MySQL" form http://www.bullzip.com
7# Program Version 5.4.274
8#
9# OPTIONS:
10# sourcefilename=C:\Users\slyfr\Downloads\TCCOfficeHoursDatabase.accdb
11# sourceusername=
12# sourcepassword=
13# sourcesystemdatabase=
14# destinationdatabase=movedb
15# storageengine=MyISAM
16# dropdatabase=0
17# createtables=1
18# unicode=1
19# autocommit=1
20# transferdefaultvalues=1
21# transferindexes=1
22# transferautonumbers=1
23# transferrecords=1
24# columnlist=1
25# tableprefix=
26# negativeboolean=0
27# ignorelargeblobs=0
28# memotype=LONGTEXT
29# datetimetype=DATETIME
30#
31
32CREATE DATABASE IF NOT EXISTS `movedb`;
33USE `movedb`;
34
35#
36# Table structure for table 'Courses'
37#
38
39DROP TABLE IF EXISTS `Courses`;
40
41CREATE TABLE `Courses` (
42 `Class` INTEGER NOT NULL DEFAULT 5,
43 `Section` VARCHAR(3) NOT NULL,
44 `Course Number` INTEGER NOT NULL DEFAULT 0,
45 `First Name` LONGTEXT NOT NULL,
46 `Last Name` VARCHAR(20) NOT NULL,
47 `Term` VARCHAR(11) DEFAULT 'Spring 2016',
48 `Campus` VARCHAR(15) DEFAULT 'Virginia Beach',
49 INDEX (`Class`),
50 PRIMARY KEY (`Class`)
51) ENGINE=myisam DEFAULT CHARSET=utf8;
52
53SET autocommit=1;
54
55#
56# Dumping data for table 'Courses'
57#
58
59INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29201, 'ITE', 141, 'Frank', 'Scott', 'Spring 2016', 'Virginia Beach');
60INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29202, 'ITE', 151, 'Frank', 'Scott', 'Spring 2016', 'Virginia Beach');
61INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29204, 'ITE', 119, 'Frank', 'Futyma', 'Spring 2016', 'Virginia Beach');
62INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29205, 'ITE', 119, 'Frank', 'Futyma', 'Spring 2016', 'Virginia Beach');
63INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29206, 'ITE', 119, 'Frank', 'Futyma', 'Spring 2016', 'Virginia Beach');
64INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29207, 'ITE', 130, 'William', 'McNamara', 'Spring 2016', 'Virginia Beach');
65INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29208, 'ITE', 130, 'William', 'McNamara', 'Spring 2016', 'Virginia Beach');
66INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29209, 'ITE', 140, 'Susan', 'Dozier', 'Spring 2016', 'Virginia Beach');
67INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29210, 'ITE', 150, 'Susan', 'Dozier', 'Spring 2016', 'Virginia Beach');
68INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29211, 'ITE', 215, 'Susan', 'Dozier', 'Spring 2016', 'Virginia Beach');
69INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29212, 'ITE', 115, 'Audrey', 'Lawrence', 'Spring 2016', 'Virginia Beach');
70INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29213, 'ITE', 115, 'Kimberly', 'Adams', 'Spring 2016', 'Virginia Beach');
71INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29214, 'ITE', 115, 'Mary', 'Froehler', 'Spring 2016', 'Virginia Beach');
72INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29215, 'ITE', 115, 'Joanne', 'Jennings', 'Spring 2016', 'Virginia Beach');
73INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29220, 'ITE', 115, 'Brenda', 'Sedlacek', 'Spring 2016', 'Virginia Beach');
74INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29221, 'ITE', 115, 'Michael', 'Adams', 'Spring 2016', 'Virginia Beach');
75INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29223, 'ITE', 115, 'Audrey', 'Lawrence', 'Spring 2016', 'Virginia Beach');
76INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29225, 'ITE', 115, 'Thomas', 'Goldsberry', 'Spring 2016', 'Virginia Beach');
77INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29226, 'ITE', 115, 'Cheryl', 'Rome', 'Spring 2016', 'Virginia Beach');
78INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29228, 'ITE', 115, 'Debra', 'Benham', 'Spring 2016', 'Virginia Beach');
79INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29231, 'ITE', 115, 'Debra', 'Benham', 'Spring 2016', 'Virginia Beach');
80INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29234, 'ITE', 115, 'Linda', 'Lavender', 'Spring 2016', 'Virginia Beach');
81INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29241, 'ITE', 115, 'Debra', 'Benham', 'Spring 2016', 'Virginia Beach');
82INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29242, 'ITE', 115, 'Michael', 'Adams', 'Spring 2016', 'Virginia Beach');
83INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29244, 'ITE', 115, 'Rory', 'Fitzpatrick', 'Spring 2016', 'Virginia Beach');
84INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29250, 'ITE', 115, 'Patricia', 'Knight', 'Spring 2016', 'Virginia Beach');
85INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29252, 'ITE', 115, 'Lisa', 'Carrington', 'Spring 2016', 'Virginia Beach');
86INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29260, 'ITE', 115, 'Theresa', 'Dyson-Roby', 'Spring 2016', 'Virginia Beach');
87INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (29261, 'ITE', 119, 'Frank', 'Futyma', 'Spring 2016', 'Virginia Beach');
88INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45121, 'ITE', 115, 'Laura', 'Hennessy', 'Spring 2016', 'Virginia Beach');
89INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45397, 'CSC', 110, 'Scott', 'Davis', 'Spring 2016', 'Virginia Beach');
90INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45398, 'CSC', 110, 'Scott', 'Davis', 'Spring 2016', 'Virginia Beach');
91INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45399, 'CSC', 110, 'Thelma', 'Looms', 'Spring 2016', 'Virginia Beach');
92INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45402, 'CSC', 201, 'Scott', 'Davis', 'Spring 2016', 'Virginia Beach');
93INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45403, 'CSC', 201, 'Scott', 'Davis', 'Spring 2016', 'Virginia Beach');
94INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45405, 'CSC', 210, 'Scott', 'Davis', 'Spring 2016', 'Virginia Beach');
95INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45407, 'CSC', 215, 'Charles', 'Cartledge', 'Spring 2016', 'Virginia Beach');
96INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45585, 'ITD', 110, 'Debra', 'Benham', 'Spring 2016', 'Virginia Beach');
97INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45586, 'ITD', 110, 'Theresa', 'Dyson-Roby', 'Spring 2016', 'Virginia Beach');
98INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45587, 'ITD', 112, 'William', 'Clement', 'Spring 2016', 'Virginia Beach');
99INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45589, 'ITD', 132, 'Susan', 'Dozier', 'Spring 2016', 'Virginia Beach');
100INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45590, 'ITD', 132, 'Mary', 'Gable', 'Spring 2016', 'Virginia Beach');
101INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45591, 'ITD', 134, 'Mary', 'Gable', 'Spring 2016', 'Virginia Beach');
102INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45592, 'ITD', 136, 'Mary', 'Gable', 'Spring 2016', 'Virginia Beach');
103INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45597, 'ITD', 250, 'Mary', 'Gable', 'Spring 2016', 'Virginia Beach');
104INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45601, 'ITD', 260, 'John', 'Clary', 'Spring 2016', 'Virginia Beach');
105INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45609, 'ITN', 101, 'Carl', 'Tennefoss', 'Spring 2016', 'Virginia Beach');
106INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45610, 'ITN', 101, 'Eugene', 'Kirby', 'Spring 2016', 'Virginia Beach');
107INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45611, 'ITN', 101, 'Carl', 'Tennefoss', 'Spring 2016', 'Virginia Beach');
108INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45612, 'ITE', 109, 'Audrey', 'Lawrence', 'Spring 2016', 'Virginia Beach');
109INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (45613, 'ITE', 109, 'Mary', 'Froehler', 'Spring 2016', 'Virginia Beach');
110INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47966, 'ITN', 106, 'Gary', 'Noah', 'Spring 2016', 'Virginia Beach');
111INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47967, 'ITN', 106, 'Thomas', 'Goldsberry', 'Spring 2016', 'Virginia Beach');
112INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47968, 'ITN', 106, 'William', 'McNamara', 'Spring 2016', 'Virginia Beach');
113INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47969, 'ITN', 106, 'Kimberly', 'Perez', 'Spring 2016', 'Virginia Beach');
114INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47970, 'ITN', 106, 'Kimberly', 'Perez', 'Spring 2016', 'Virginia Beach');
115INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47971, 'ITN', 107, 'Carl', 'Tennefoss', 'Spring 2016', 'Virginia Beach');
116INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47972, 'ITN', 107, 'William', 'McNamara', 'Spring 2016', 'Virginia Beach');
117INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47974, 'ITN', 107, 'William', 'McNamara', 'Spring 2016', 'Virginia Beach');
118INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (47975, 'ITN', 107, 'Michael', 'Crocker', 'Spring 2016', 'Virginia Beach');
119INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48086, 'ITN', 110, 'Joanne', 'Jennings', 'Spring 2016', 'Virginia Beach');
120INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48087, 'ITN', 110, 'Linda', 'Lavender', 'Spring 2016', 'Virginia Beach');
121INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48090, 'ITN', 111, 'Gary', 'Noah', 'Spring 2016', 'Virginia Beach');
122INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48091, 'ITN', 111, 'Gary', 'Noah', 'Spring 2016', 'Virginia Beach');
123INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48092, 'ITN', 113, 'Gary', 'Noah', 'Spring 2016', 'Virginia Beach');
124INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48093, 'ITN', 154, 'Carl', 'Tennefoss', 'Spring 2016', 'Virginia Beach');
125INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48094, 'ITN', 154, 'Carl', 'Tennefoss', 'Spring 2016', 'Virginia Beach');
126INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48096, 'ITN', 155, 'John', 'Nelson', 'Spring 2016', 'Virginia Beach');
127INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48097, 'ITN', 171, 'David', 'Hopper', 'Spring 2016', 'Virginia Beach');
128INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48098, 'ITN', 171, 'David', 'Hopper', 'Spring 2016', 'Virginia Beach');
129INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48105, 'ITN', 260, 'Kimberly', 'Perez', 'Spring 2016', 'Virginia Beach');
130INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48117, 'ITN', 267, 'Kimberly', 'Perez', 'Spring 2016', 'Virginia Beach');
131INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48127, 'ITP', 100, 'Thelma', 'Looms', 'Spring 2016', 'Virginia Beach');
132INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48128, 'ITP', 100, 'Abraham', 'Goldstein', 'Spring 2016', 'Virginia Beach');
133INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48129, 'ITP', 100, 'Lisa', 'Carter', 'Spring 2016', 'Virginia Beach');
134INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48130, 'ITP', 100, 'Jared', 'Oliverio', 'Spring 2016', 'Virginia Beach');
135INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48131, 'ITP', 100, 'Jared', 'Oliverio', 'Spring 2016', 'Virginia Beach');
136INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48132, 'ITP', 100, 'Jared', 'Oliverio', 'Spring 2016', 'Virginia Beach');
137INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48133, 'ITP', 100, 'Lisa', 'Carter', 'Spring 2016', 'Virginia Beach');
138INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48136, 'ITP', 120, 'Lisa', 'Carter', 'Spring 2016', 'Virginia Beach');
139INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48146, 'ITP', 132, 'Lisa', 'Carter', 'Spring 2016', 'Virginia Beach');
140INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (48154, 'ITP', 232, 'Lisa', 'Carter', 'Spring 2016', 'Virginia Beach');
141INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (49102, 'ITN', 224, 'Cesar', 'Barieri', 'Spring 2016', 'Virginia Beach');
142INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (49133, 'ITN', 218, 'Gary', 'Noah', 'Spring 2016', 'Virginia Beach');
143INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (49657, 'ITE', 115, 'Kimberly', 'Perez', 'Spring 2016', 'Virginia Beach');
144INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (52839, 'ITN', 154, 'John', 'Nelson', 'Spring 2016', 'Virginia Beach');
145INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (60277, 'ITP', 193, 'Jared', 'Oliverio', 'Spring 2016', 'Virginia Beach');
146INSERT INTO `Courses` (`Class`, `Section`, `Course Number`, `First Name`, `Last Name`, `Term`, `Campus`) VALUES (60282, 'ITP', 226, 'Jared', 'Oliverio', 'Spring 2016', 'Virginia Beach');
147# 88 records
148
149#
150# Table structure for table 'Professors'
151#
152
153DROP TABLE IF EXISTS `Professors`;
154
155CREATE TABLE `Professors` (
156 `ID` INTEGER NOT NULL AUTO_INCREMENT,
157 `First Name` VARCHAR(20),
158 `Last Name` VARCHAR(20),
159 `Room Number` VARCHAR(4),
160 `Telephone Number` VARCHAR(10),
161 `eMail Address` VARCHAR(255),
162 `Monday` VARCHAR(24),
163 `Tuesday` VARCHAR(24),
164 `Wednesday` VARCHAR(24),
165 `Thursday` VARCHAR(24),
166 `Friday` VARCHAR(24),
167 PRIMARY KEY (`ID`)
168) ENGINE=myisam DEFAULT CHARSET=utf8;
169
170SET autocommit=1;
171
172#
173# Dumping data for table 'Professors'
174#
175
176INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (1, 'Jared', 'Oliverio', 'H237', '7578227036', 'jOliverio@tcc.edu', '1730183022002230', '1600183022002230', '1700183022002230', '1530143022002230', NULL);
177INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (2, 'Lisa', 'Carter', 'H238', '7578227384', 'lCarter@tcc.edu', '100011001230183020302100', NULL, '1000110012301330', NULL, NULL);
178INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (3, NULL, 'Benham', 'H236', '7578227380', 'DBenham@tcc.edu', '080010001601900', NULL, '080010001630190022002230', NULL, NULL);
179INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (4, 'Cynthia', 'Bird', 'H243', '7578227416', 'Cbird@tcc.edu', '18001900', '0900093011301430', '09001430', '0900093011300230', NULL);
180INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (5, 'Amy', 'Bohrer', 'H231', NULL, NULL, '084509301045110012151330', '1530163019101945', '084509301045110012151330', NULL, NULL);
181INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (6, 'Scott', 'Davis', NULL, '7578227003', 'SCDavis@tcc.edu', '11001300', '1100130016301830', '11001300', '11001300', NULL);
182INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (7, 'Susan', 'Dozier', NULL, '7578227048', 'Sdozier@tcc.edu', '07001300', NULL, '15001800', NULL, NULL);
183INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (8, 'Mary', 'Gable', 'H233', NULL, 'Mgable@tcc.edu', '18302200', '1700183022002330', '12001330', '1500163020302330', NULL);
184INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (9, NULL, 'Hamm', 'G117', '7578227052', 'Eham@tcc.edu', '0930110012151330', NULL, '0930110012151330', NULL, '08000900');
185INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (10, 'William', 'Jenkins', 'G112', '7578227201', 'Wjenkins@tcc.edu', '1215130014151530', '12151515', '1215130014151530', '12151530', NULL);
186INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (11, 'Valerie', 'Jones', 'G131', '7578227037', 'Vjones@tcc.edu', '09301100', '0900093013301630', '09301100', '09000930', NULL);
187INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (12, 'Peter', 'Kane', NULL, '7578227173', 'Pkane@tcc.edu', '0800093013151515', '12151515', '0800093013151515', NULL, NULL);
188INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (13, NULL, 'Leporte', 'H232', '7578227420', 'lleporte@tcc.edu', NULL, '0800093012151515', '19102030', '0815093012151515', NULL);
189INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (14, 'Claudia', 'Macon', 'G133', '7578227055', NULL, NULL, '1215133014451645', NULL, '1215133014451645', NULL);
190INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (15, 'Bill', 'McNamara', 'H245', '7578227314', 'bmcnamara@tcc.edu', '1640191521002200', '1210141022002300', '1640174020002200', '12101340', NULL);
191INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (16, 'Gary', 'Noah', NULL, '7578227142', 'gnaoh@tcc.edu', '100011001300140017001830', '16001730', '100011001300140017001830', '17001830', NULL);
192INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (17, NULL, 'Perez', NULL, NULL, NULL, '1600183021302200', '13001410', '16001830', '16001830', '13001410');
193INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (18, 'Debbie', 'Porter', 'H230', '7578227081', 'dporter@tcc.edu', '0815093012151400', NULL, '0815093012151315', '08151300', NULL);
194INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (19, 'James', 'Roberts', 'D120', NULL, 'jroberts@tcc.edu', NULL, '14001900', NULL, '14001900', NULL);
195INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (20, 'Gregg', 'Tennefoss', NULL, NULL, NULL, '10451130', '11301800', '10451145', '11151145', NULL);
196INSERT INTO `Professors` (`ID`, `First Name`, `Last Name`, `Room Number`, `Telephone Number`, `eMail Address`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`) VALUES (21, 'Jackie', 'Warren', 'H234', '7578227043', 'jwarren@tcc.edu', '0800093012151300', '0930110012151500', '0800093012151500', '0930110012151500', NULL);
197# 21 records