### php_university db set up script ### usage: mysql -u[root_username] -p[root_password] < php_univ.sql CREATE DATABASE IF NOT EXISTS php_university; GRANT ALL ON php_university.* to 'php'@'localhost' IDENTIFIED BY 'phpis2kool'; FLUSH PRIVILEGES; USE php_university; ########## -- MySQL dump 9.09 -- -- Host: localhost Database: php_university -- ------------------------------------------------------ -- Server version 4.0.16-standard -- -- Table structure for table `guestbook_comment` -- DROP TABLE IF EXISTS guestbook_comment; CREATE TABLE guestbook_comment ( posted_by varchar(30) NOT NULL default '', posted_on timestamp(14) NOT NULL, text varchar(255) NOT NULL default '', comment_type enum('praise','rant','question','other') NOT NULL default 'other', id smallint(5) unsigned NOT NULL auto_increment, PRIMARY KEY (id), UNIQUE KEY poster_text_idx (posted_by,text), KEY posted_on_idx (posted_on) ) TYPE=MyISAM; -- -- Dumping data for table `guestbook_comment` -- INSERT INTO guestbook_comment VALUES ('Mr. Bludgeon',20041027233140,'this is a comment','other',1); -- -- Table structure for table `instructor` -- DROP TABLE IF EXISTS instructor; CREATE TABLE instructor ( id smallint(5) unsigned NOT NULL auto_increment, lastname varchar(30) NOT NULL default '', firstname varchar(30) NOT NULL default '', middlename varchar(30) NOT NULL default '', email varchar(40) NOT NULL default '', bio text NOT NULL, lastmod timestamp(14) NOT NULL, PRIMARY KEY (id), KEY lastname (lastname) ) TYPE=MyISAM; -- -- Dumping data for table `instructor` -- INSERT INTO instructor VALUES (1,'Schlossnagle','George','','george@phpuniversity.edu','A world renowned PHP/Apache developer and author of \"Advanced PHP Programming\" George really knows a lot of interesting stuff',20041114165325); INSERT INTO instructor VALUES (2,'Sklar','David','','david.sklar@phpunviversity.edu','David is an exceeding clever lad and has also authored one of the funniest and most accessible PHP books of all time, \"Learning PHP 5\"',20041114165325); INSERT INTO instructor VALUES (3,'Shiflett','Chris','','shiflett@phpuniversity.edu','Chris Shiflett is a well-known author, developer, trainer, etc. Security is one of this main shticks.',20041114165325); INSERT INTO instructor VALUES (4,'Lerdorf','Rasmus','','rasmus@phpuniversity.edu','Rasmus is the guy. He oughta know.',20041114165325); INSERT INTO instructor VALUES (5,'Trachtenberg','Adam','','trachtenberg@phpuniversity.com','Author of the seminal text \"Upgrading to PHP\" and co-author of the ever-popular \"PHP Cookbook,\" Adam is justly venerated throughout the PHP world.',20041114165325); INSERT INTO instructor VALUES (6,'Zawodny','Jeremy','','zawodny@phpuniversity.edu','Zawodny knows from MySQL and oh so much more cool techno stuff.',20041114165325); -- -- Table structure for table `student` -- DROP TABLE IF EXISTS student; CREATE TABLE student ( id int(10) unsigned NOT NULL auto_increment, lastname varchar(36) NOT NULL default '', firstname varchar(36) NOT NULL default '', middlename varchar(36) NOT NULL default '', email varchar(50) NOT NULL default '', zip varchar(10) NOT NULL default '', lastmod timestamp(14) NOT NULL, password varchar(32) NOT NULL default 'php4all', PRIMARY KEY (id), UNIQUE KEY email_idx (email), KEY password (password) ) TYPE=MyISAM; -- -- Dumping data for table `student` -- INSERT INTO student VALUES (1555,'Enright','Pilar','Alava','pilar.enright@phpuniversity.edu','10463-7724',20041102121642,'php4all'); INSERT INTO student VALUES (1556,'Laurendeau','H�l�ne','','h�l�ne.laurendeau@phpuniversity.edu','07601',20041102121642,'php4all'); INSERT INTO student VALUES (1557,'Maleh','Graciela','H','graciela.maleh@phpuniversity.edu','1270',20041102121642,'php4all'); INSERT INTO student VALUES (1558,'Hu','Huixin','','huixin.hu@phpuniversity.edu','10036',20041102121642,'php4all'); INSERT INTO student VALUES (1559,'Bard','Judy','','judy.bard@phpuniversity.edu','11106',20041102121642,'php4all'); INSERT INTO student VALUES (1560,'Anderson','Glen','K','glen.anderson@phpuniversity.edu','07010',20041102121642,'php4all'); INSERT INTO student VALUES (1561,'Saslow','Pilar','','pilar.saslow@phpuniversity.edu','33186',20041102121642,'php4all'); INSERT INTO student VALUES (1562,'Chavel','Christine','M','christine.chavel@phpuniversity.edu','10538',20041102121642,'php4all'); INSERT INTO student VALUES (1563,'Hinkle','David','Wayne','david.hinkle@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1564,'Hsu','John','C','john.hsu@phpuniversity.edu','11364',20041102121642,'php4all'); INSERT INTO student VALUES (1565,'Molinero','Leticia','B','leticia.molinero@phpuniversity.edu','10012-4009',20041102121642,'php4all'); INSERT INTO student VALUES (1566,'L�pez','Mar�aCarolina','','mar�acarolina.l�pez@phpuniversity.edu','10017',20041102121642,'php4all'); INSERT INTO student VALUES (1567,'Perez-Santalla','Virginia','','virginia.perez-santalla@phpuniversity.edu','07092',20041102121642,'php4all'); INSERT INTO student VALUES (1568,'Loeb','J. Walter','','j._walter.loeb@phpuniversity.edu','08831',20041102121642,'php4all'); INSERT INTO student VALUES (1569,'Misch-Blum','Gisela','G.','gisela.misch-blum@phpuniversity.edu','10028-4702',20041102121642,'php4all'); INSERT INTO student VALUES (1570,'Elian','Marie-Nicole','J.','marie-nicole.elian@phpuniversity.edu','06068',20041102121642,'php4all'); INSERT INTO student VALUES (1571,'Casper','Ginny','','ginny.casper@phpuniversity.edu','12208',20041102121642,'php4all'); INSERT INTO student VALUES (1572,'Scala','Christopher','V.','christopher.scala@phpuniversity.edu','10024',20041102121642,'php4all'); INSERT INTO student VALUES (1573,'Bose','Leila','F.','leila.bose@phpuniversity.edu','11370',20041102121642,'php4all'); INSERT INTO student VALUES (1574,'Folaron','Deborah','A.','deborah.folaron@phpuniversity.edu','H3X 1V4',20041102121642,'php4all'); INSERT INTO student VALUES (1575,'Elterman','A.J.','','a.j..elterman@phpuniversity.edu','11709-2328',20041102121642,'php4all'); INSERT INTO student VALUES (1576,'Gonzalez','Maureen','','maureen.gonzalez@phpuniversity.edu','10463',20041102121642,'php4all'); INSERT INTO student VALUES (1577,'Buzack','Zilda','N.','zilda.buzack@phpuniversity.edu','07030',20041102121642,'php4all'); INSERT INTO student VALUES (1578,'Scardovi','Benedetta','','benedetta.scardovi@phpuniversity.edu','10040-2410',20041102121642,'php4all'); INSERT INTO student VALUES (1579,'Alves','Maria','L.','maria.alves@phpuniversity.edu','07032',20041102121642,'php4all'); INSERT INTO student VALUES (1580,'Bergman','Helene','D.','helene.bergman@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1581,'Garzon','Suzanne','C.','suzanne.garzon@phpuniversity.edu','10028',20041102121642,'php4all'); INSERT INTO student VALUES (1582,'Smith','Robert','Lee','robert.smith@phpuniversity.edu','12561-1003',20041102121642,'php4all'); INSERT INTO student VALUES (1583,'Laplante','Lisa','A.','lisa.laplante@phpuniversity.edu','07470-3526',20041102121642,'php4all'); INSERT INTO student VALUES (1584,'Fischer-Bockius','Heidi','','heidi.fischer-bockius@phpuniversity.edu','10034',20041102121642,'php4all'); INSERT INTO student VALUES (1585,'Picaronny','Fran�oise','','fran�oise.picaronny@phpuniversity.edu','08540',20041102121642,'php4all'); INSERT INTO student VALUES (1586,'Cefaratti','Nicholas','M.','nicholas.cefaratti@phpuniversity.edu','10023',20041102121642,'php4all'); INSERT INTO student VALUES (1587,'Frattalone','Frank','J.','frank.frattalone@phpuniversity.edu','11768',20041102121642,'php4all'); INSERT INTO student VALUES (1588,'Stone','Marilyn','','marilyn.stone@phpuniversity.edu','10024-6030',20041102121642,'php4all'); INSERT INTO student VALUES (1589,'Benarroch','Alicia','','alicia.benarroch@phpuniversity.edu','07920-3729',20041102121642,'php4all'); INSERT INTO student VALUES (1590,'Savova','Milena','V.','milena.savova@phpuniversity.edu','10012-2106',20041102121642,'php4all'); INSERT INTO student VALUES (1591,'Schwartz','Alexander','','alexander.schwartz@phpuniversity.edu','10463',20041102121642,'php4all'); INSERT INTO student VALUES (1592,'Martin-Valiquette','Louise','','louise.martin-valiquette@phpuniversity.edu','10562',20041102121642,'php4all'); INSERT INTO student VALUES (1593,'Hooker','Ellen','','ellen.hooker@phpuniversity.edu','SW7 1JR',20041102121642,'php4all'); INSERT INTO student VALUES (1594,'Greenfield','Marian','S.','marian.greenfield@phpuniversity.edu','07080',20041102121642,'php4all'); INSERT INTO student VALUES (1595,'Feuerle','Lois','M.','lois.feuerle@phpuniversity.edu','97214-4035',20041102121642,'php4all'); INSERT INTO student VALUES (1596,'Andrews','Elizabeth','Scott','elizabeth.andrews@phpuniversity.edu','07030',20041102121642,'php4all'); INSERT INTO student VALUES (1597,'Codina','Rosa','','rosa.codina@phpuniversity.edu','10017',20041102121642,'php4all'); INSERT INTO student VALUES (1598,'Bukhina','Olga','','olga.bukhina@phpuniversity.edu','10024',20041102121642,'php4all'); INSERT INTO student VALUES (1599,'Lomander Lopez','Susanne','','susanne.lomander_lopez@phpuniversity.edu','11756-0388',20041102121642,'php4all'); INSERT INTO student VALUES (1600,'Martin-Trigona','Roanna','Ines','roanna.martin-trigona@phpuniversity.edu','10022',20041102121642,'php4all'); INSERT INTO student VALUES (1601,'Ditaranto','Edna','H.M.','edna.ditaranto@phpuniversity.edu','07601',20041102121642,'php4all'); INSERT INTO student VALUES (1602,'Restrepo','Borney','','borney.restrepo@phpuniversity.edu','10018-1087',20041102121642,'php4all'); INSERT INTO student VALUES (1603,'Sanderson','Krystyna','','krystyna.sanderson@phpuniversity.edu','10009',20041102121642,'php4all'); INSERT INTO student VALUES (1604,'Salmeri Pherson','Anna Maria','','anna_maria.salmeri_pherson@phpuniversity.edu','06107',20041102121642,'php4all'); INSERT INTO student VALUES (1605,'Steiner','Susan','M.','susan.steiner@phpuniversity.edu','07963-0824',20041102121642,'php4all'); INSERT INTO student VALUES (1606,'Sochko','Mary','','mary.sochko@phpuniversity.edu','07110',20041102121642,'php4all'); INSERT INTO student VALUES (1607,'Freeman','Lester','','lester.freeman@phpuniversity.edu','11235',20041102121642,'php4all'); INSERT INTO student VALUES (1608,'Higuero','Arnoldo','','arnoldo.higuero@phpuniversity.edu','60610-4804',20041102121642,'php4all'); INSERT INTO student VALUES (1609,'Saphire','Marie-Madeleine','','marie-madeleine.saphire@phpuniversity.edu','10598',20041102121642,'php4all'); INSERT INTO student VALUES (1610,'Sherr','Daniel','','daniel.sherr@phpuniversity.edu','10014-4902',20041102121642,'php4all'); INSERT INTO student VALUES (1611,'Gereg','Joan','S.','joan.gereg@phpuniversity.edu','06804-1237',20041102121642,'php4all'); INSERT INTO student VALUES (1612,'Carlson','Geoffrey','A.','geoffrey.carlson@phpuniversity.edu','11104',20041102121642,'php4all'); INSERT INTO student VALUES (1613,'Uhlig','Elizabeth','G.','elizabeth.uhlig@phpuniversity.edu','11374',20041102121642,'php4all'); INSERT INTO student VALUES (1614,'De Caumont','Marie','','marie.de_caumont@phpuniversity.edu','10017',20041102121642,'php4all'); INSERT INTO student VALUES (1615,'Rubinstein','Chie','Hamaguchi','chie.rubinstein@phpuniversity.edu','10003-5944',20041102121642,'php4all'); INSERT INTO student VALUES (1616,'Deliyanidis','Monique','Christine','monique.deliyanidis@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1617,'Slaughter','Scholem','A.','scholem.slaughter@phpuniversity.edu','10027-3041',20041102121642,'php4all'); INSERT INTO student VALUES (1618,'Faidley','Julia','K.','julia.faidley@phpuniversity.edu','10003',20041102121642,'php4all'); INSERT INTO student VALUES (1619,'Lagus','Riitta','Kyllikki','riitta.lagus@phpuniversity.edu','10538',20041102121642,'php4all'); INSERT INTO student VALUES (1620,'Adlerblum','Armand','','armand.adlerblum@phpuniversity.edu','H1K 1Y9',20041102121642,'php4all'); INSERT INTO student VALUES (1621,'Markowitz','Wolf','','wolf.markowitz@phpuniversity.edu','11211',20041102121642,'php4all'); INSERT INTO student VALUES (1622,'Dechereux','Maurice','','maurice.dechereux@phpuniversity.edu','10022',20041102121642,'php4all'); INSERT INTO student VALUES (1623,'Hunt','Diane','Alynn','diane.hunt@phpuniversity.edu','10004-2619',20041102121642,'php4all'); INSERT INTO student VALUES (1624,'Wright','Nancy','E.','nancy.wright@phpuniversity.edu','10003-1825',20041102121642,'php4all'); INSERT INTO student VALUES (1625,'Witt-Greenberg','Anne','S.','anne.witt-greenberg@phpuniversity.edu','11023',20041102121642,'php4all'); INSERT INTO student VALUES (1626,'Warburton','Elizabeth','A.M.','elizabeth.warburton@phpuniversity.edu','10017-3428',20041102121642,'php4all'); INSERT INTO student VALUES (1627,'M�ndez','Gloria','F.','gloria.m�ndez@phpuniversity.edu','10452',20041102121642,'php4all'); INSERT INTO student VALUES (1628,'Ch�teauvert','Richard','','richard.ch�teauvert@phpuniversity.edu','10012-1321',20041102121642,'php4all'); INSERT INTO student VALUES (1629,'Bartholomew','Melly','','melly.bartholomew@phpuniversity.edu','10017',20041102121642,'php4all'); INSERT INTO student VALUES (1630,'Flack','Claire','P.','claire.flack@phpuniversity.edu','10009',20041102121642,'php4all'); INSERT INTO student VALUES (1631,'Dymerets','Jennifer','Falkove','jennifer.dymerets@phpuniversity.edu','10463',20041102121642,'php4all'); INSERT INTO student VALUES (1632,'Aslanian','Dr. Aslan','','dr._aslan.aslanian@phpuniversity.edu','91042',20041102121642,'php4all'); INSERT INTO student VALUES (1633,'Schmitt','Margaret','M.','margaret.schmitt@phpuniversity.edu','11375-2980',20041102121642,'php4all'); INSERT INTO student VALUES (1634,'Weltz','Richard','N.','richard.weltz@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1635,'Kilgour','Vajra','','vajra.kilgour@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1636,'Glasser','Susan','N.','susan.glasser@phpuniversity.edu','10025-4956',20041102121642,'php4all'); INSERT INTO student VALUES (1637,'Hanna','George','M.','george.hanna@phpuniversity.edu','10314',20041102121642,'php4all'); INSERT INTO student VALUES (1638,'Furio','Victoria','J','victoria.furio@phpuniversity.edu','10705',20041102121642,'php4all'); INSERT INTO student VALUES (1639,'Hurley','Elizabeth','M.','elizabeth.hurley@phpuniversity.edu','07302',20041102121642,'php4all'); INSERT INTO student VALUES (1640,'Crane','Shena','','shena.crane@phpuniversity.edu','07030',20041102121642,'php4all'); INSERT INTO student VALUES (1641,'Danilyants','Mary','','mary.danilyants@phpuniversity.edu','11235-8131',20041102121642,'php4all'); INSERT INTO student VALUES (1642,'Petit','Susana','','susana.petit@phpuniversity.edu','10036',20041102121642,'php4all'); INSERT INTO student VALUES (1643,'Jaffe','Jody','R.','jody.jaffe@phpuniversity.edu','11023',20041102121642,'php4all'); INSERT INTO student VALUES (1644,'Ramirez','A.','Gloria','a..ramirez@phpuniversity.edu','11372-6702',20041102121642,'php4all'); INSERT INTO student VALUES (1645,'Speckens','Eleonore','A.','eleonore.speckens@phpuniversity.edu','10017-6009',20041102121642,'php4all'); INSERT INTO student VALUES (1646,'San Sebastian','Lola','','lola.san_sebastian@phpuniversity.edu','07105-3271',20041102121642,'php4all'); INSERT INTO student VALUES (1647,'May','Virginia','M.','virginia.may@phpuniversity.edu','12603',20041102121642,'php4all'); INSERT INTO student VALUES (1648,'Cina','Soraya','','soraya.cina@phpuniversity.edu','11358',20041102121642,'php4all'); INSERT INTO student VALUES (1649,'Balke','Emilia','Ivanova','emilia.balke@phpuniversity.edu','91301',20041102121642,'php4all'); INSERT INTO student VALUES (1650,'Sandford','Luke','H.','luke.sandford@phpuniversity.edu','10002',20041102121642,'php4all'); INSERT INTO student VALUES (1651,'Mehrten','Gregory','F.','gregory.mehrten@phpuniversity.edu','10014-4108',20041102121642,'php4all'); INSERT INTO student VALUES (1652,'Arcidiacono','Carmelo','','carmelo.arcidiacono@phpuniversity.edu','10009-2909',20041102121642,'php4all'); INSERT INTO student VALUES (1653,'Irmscher','Anke','G.','anke.irmscher@phpuniversity.edu','10003-8250',20041102121642,'php4all'); INSERT INTO student VALUES (1654,'Daxland','Gloria','S.','gloria.daxland@phpuniversity.edu','11004',20041102121642,'php4all'); INSERT INTO student VALUES (1655,'Barling','Barbara','J.','barbara.barling@phpuniversity.edu','07042-4727',20041102121642,'php4all'); INSERT INTO student VALUES (1656,'Saleh','Jacques','A.','jacques.saleh@phpuniversity.edu','10011',20041102121642,'php4all'); INSERT INTO student VALUES (1657,'Pignatelli-Mercuri','Maria Rita','','maria_rita.pignatelli-mercuri@phpuniversity.edu','07076',20041102121642,'php4all'); INSERT INTO student VALUES (1658,'Moraru-Velinova','Milena','','milena.moraru-velinova@phpuniversity.edu','06905',20041102121642,'php4all'); INSERT INTO student VALUES (1659,'Jain','Dharm','','dharm.jain@phpuniversity.edu','M1P 3K2',20041102121642,'php4all'); INSERT INTO student VALUES (1660,'Riordan','Anne','','anne.riordan@phpuniversity.edu','10011',20041102121642,'php4all'); INSERT INTO student VALUES (1661,'Archiapatti','Laura','V.','laura.archiapatti@phpuniversity.edu','32118-7612',20041102121642,'php4all'); INSERT INTO student VALUES (1662,'Halusa','Dubravko','B.','dubravko.halusa@phpuniversity.edu','12144-9653',20041102121642,'php4all'); INSERT INTO student VALUES (1663,'Bouali','Boumedi�ne','','boumedi�ne.bouali@phpuniversity.edu','12047-2506',20041102121642,'php4all'); INSERT INTO student VALUES (1664,'Pokrovsky','Nikolai','','nikolai.pokrovsky@phpuniversity.edu','07043-1608',20041102121642,'php4all'); INSERT INTO student VALUES (1665,'Ackerman','Robert','A.','robert.ackerman@phpuniversity.edu','08805-1452',20041102121642,'php4all'); INSERT INTO student VALUES (1666,'Huhulea-Dinu','Roxana','','roxana.huhulea-dinu@phpuniversity.edu','11758',20041102121642,'php4all'); INSERT INTO student VALUES (1667,'Morin','Lucien','','lucien.morin@phpuniversity.edu','11791-3716',20041102121642,'php4all'); INSERT INTO student VALUES (1668,'Berelson','Carmen','E.','carmen.berelson@phpuniversity.edu','18901-2504',20041102121642,'php4all'); INSERT INTO student VALUES (1669,'Gluck','Karl','D.','karl.gluck@phpuniversity.edu','11355-3221',20041102121642,'php4all'); INSERT INTO student VALUES (1670,'Marquez de Camihort','Cristina','','cristina.marquez_de_camihort@phpuniversity.edu','12550-1442',20041102121642,'php4all'); INSERT INTO student VALUES (1671,'Shigematsu','Harumi','','harumi.shigematsu@phpuniversity.edu','10019',20041102121642,'php4all'); INSERT INTO student VALUES (1672,'Danford','Natalie','','natalie.danford@phpuniversity.edu','10003',20041102121642,'php4all'); INSERT INTO student VALUES (1673,'Sabin','Paul','V.','paul.sabin@phpuniversity.edu','12534',20041102121642,'php4all'); INSERT INTO student VALUES (1674,'Nunes','Joseph','C.','joseph.nunes@phpuniversity.edu','07204-1816',20041102121642,'php4all'); INSERT INTO student VALUES (1675,'Brockbank','Eileen','','eileen.brockbank@phpuniversity.edu','10027-3218',20041102121642,'php4all'); INSERT INTO student VALUES (1676,'Brimacombe','A.','Rebecca','a..brimacombe@phpuniversity.edu','11215',20041102121642,'php4all'); INSERT INTO student VALUES (1677,'Wochos','Julie','','julie.wochos@phpuniversity.edu','10002',20041102121642,'php4all'); INSERT INTO student VALUES (1678,'Welker','Betty','E.','betty.welker@phpuniversity.edu','10024-1007',20041102121642,'php4all'); INSERT INTO student VALUES (1679,'Blaker','Alex','','alex.blaker@phpuniversity.edu','11209',20041102121642,'php4all'); INSERT INTO student VALUES (1680,'Waldes','Teresa','S.','teresa.waldes@phpuniversity.edu','10101-1873',20041102121642,'php4all'); INSERT INTO student VALUES (1681,'Ventura','Cynthia','L.','cynthia.ventura@phpuniversity.edu','11222',20041102121642,'php4all'); INSERT INTO student VALUES (1682,'Baghdady','Mahmoud','M','mahmoud.baghdady@phpuniversity.edu','11235',20041102121642,'php4all'); INSERT INTO student VALUES (1683,'Steranka','Oksana','','oksana.steranka@phpuniversity.edu','07936-3309',20041102121642,'php4all'); INSERT INTO student VALUES (1684,'Shore','Marguerite','','marguerite.shore@phpuniversity.edu','10013-2920',20041102121642,'php4all'); INSERT INTO student VALUES (1685,'Khalil','Ossama','','ossama.khalil@phpuniversity.edu','11370',20041102121642,'php4all'); INSERT INTO student VALUES (1686,'Binn','Magdolna','Gyori','magdolna.binn@phpuniversity.edu','10583',20041102121642,'php4all'); INSERT INTO student VALUES (1687,'Roberts','Arturo','L.','arturo.roberts@phpuniversity.edu','07920',20041102121642,'php4all'); INSERT INTO student VALUES (1688,'Coccia Rahoy','Gabriella','','gabriella.coccia_rahoy@phpuniversity.edu','11432-2911',20041102121642,'php4all'); INSERT INTO student VALUES (1689,'Prener','Connie','','connie.prener@phpuniversity.edu','10510-2019',20041102121642,'php4all'); INSERT INTO student VALUES (1690,'Plohn','George','K.','george.plohn@phpuniversity.edu','07010-3215',20041102121642,'php4all'); INSERT INTO student VALUES (1691,'Pe�a','Vicky','','vicky.pe�a@phpuniversity.edu','10021-0919',20041102121642,'php4all'); INSERT INTO student VALUES (1692,'Pallud-Lucarelli','Fran�oise','M.','fran�oise.pallud-lucarelli@phpuniversity.edu','07704-3528',20041102121642,'php4all'); INSERT INTO student VALUES (1693,'Navarro','Carmen','Rosa','carmen.navarro@phpuniversity.edu','08820-1009',20041102121642,'php4all'); INSERT INTO student VALUES (2014,'Mintz','David','Gacker','david.mintz@phpuniversity.edu','07302-1603',20041114164653,'php4all'); INSERT INTO student VALUES (1695,'Marinelli','David','N.','david.marinelli@phpuniversity.edu','07732',20041102121642,'php4all'); INSERT INTO student VALUES (1696,'Manzo','Douglas','','douglas.manzo@phpuniversity.edu','11372',20041102121642,'php4all'); INSERT INTO student VALUES (1697,'Majka','Gerard','M.','gerard.majka@phpuniversity.edu','19608',20041102121642,'php4all'); INSERT INTO student VALUES (1698,'Maizell','Sylvia','','sylvia.maizell@phpuniversity.edu','10003',20041102121642,'php4all'); INSERT INTO student VALUES (1699,'Liesenfeld','Juliette','','juliette.liesenfeld@phpuniversity.edu','10522',20041102121642,'php4all'); INSERT INTO student VALUES (1700,'LaMothe','Albert','J.','albert.lamothe@phpuniversity.edu','10022-6034',20041102121642,'php4all'); INSERT INTO student VALUES (1701,'Korda','Louis','','louis.korda@phpuniversity.edu','07666',20041102121642,'php4all'); INSERT INTO student VALUES (1702,'Kohn','Ruth','','ruth.kohn@phpuniversity.edu','11367-2133',20041102121642,'php4all'); INSERT INTO student VALUES (1703,'Kheir','Fouad','K.','fouad.kheir@phpuniversity.edu','11102-2509',20041102121642,'php4all'); INSERT INTO student VALUES (1704,'Herzberg','Walter','J.','walter.herzberg@phpuniversity.edu','07410',20041102121642,'php4all'); INSERT INTO student VALUES (1705,'Hennessy','Eileen','B.','eileen.hennessy@phpuniversity.edu','10185-1470',20041102121642,'php4all'); INSERT INTO student VALUES (1706,'Hasselriis','Helen','','helen.hasselriis@phpuniversity.edu','11375-6033',20041102121642,'php4all'); INSERT INTO student VALUES (1707,'Gross','Alex','','alex.gross@phpuniversity.edu','10276',20041102121642,'php4all'); INSERT INTO student VALUES (1708,'Korovina','Galya','','galya.korovina@phpuniversity.edu','10023',20041102121642,'php4all'); INSERT INTO student VALUES (1709,'Greiss','Susana','','susana.greiss@phpuniversity.edu','11368-3820',20041102121642,'php4all'); INSERT INTO student VALUES (1710,'Greenberg','Phyliss','L.','phyliss.greenberg@phpuniversity.edu','07041-2035',20041102121642,'php4all'); INSERT INTO student VALUES (1711,'Grace','Judith','A.','judith.grace@phpuniversity.edu','07666-3413',20041102121642,'php4all'); INSERT INTO student VALUES (1712,'Giammanco Frongia','Rosanna','M.','rosanna.giammanco_frongia@phpuniversity.edu','10163-3944',20041102121642,'php4all'); INSERT INTO student VALUES (1713,'Gelb','Regina','','regina.gelb@phpuniversity.edu','10040-3656',20041102121642,'php4all'); INSERT INTO student VALUES (1714,'Frongia','Fabio','','fabio.frongia@phpuniversity.edu','10163-3944',20041102121642,'php4all'); INSERT INTO student VALUES (1715,'Foscolos','Panos','','panos.foscolos@phpuniversity.edu','10549',20041102121642,'php4all'); INSERT INTO student VALUES (1716,'Ford','Karin','H.','karin.ford@phpuniversity.edu','10025-8240',20041102121642,'php4all'); INSERT INTO student VALUES (1717,'Florence','Donald','F.','donald.florence@phpuniversity.edu','10011-8762',20041102121642,'php4all'); INSERT INTO student VALUES (1718,'Fitzgerald','Almut','','almut.fitzgerald@phpuniversity.edu','10463-1718',20041102121642,'php4all'); INSERT INTO student VALUES (1719,'Fichtner','Edward','G.','edward.fichtner@phpuniversity.edu','10016-1801',20041102121642,'php4all'); INSERT INTO student VALUES (1720,'Fernandez','Reynaldo','J.','reynaldo.fernandez@phpuniversity.edu','11373',20041102121642,'php4all'); INSERT INTO student VALUES (1721,'Eriksen','Vigdis','','vigdis.eriksen@phpuniversity.edu','11201',20041102121642,'php4all'); INSERT INTO student VALUES (1722,'Dembo','Margot','B.','margot.dembo@phpuniversity.edu','10024-3708',20041102121642,'php4all'); INSERT INTO student VALUES (1723,'de Jager','Marjolijn','R.','marjolijn.de_jager@phpuniversity.edu','06902-1112',20041102121642,'php4all'); INSERT INTO student VALUES (1724,'Deferrari','Matilde','Arditti','matilde.deferrari@phpuniversity.edu','10017',20041102121642,'php4all'); INSERT INTO student VALUES (1725,'Daigneault','Marie Jos�','','marie_jos�.daigneault@phpuniversity.edu','07079-2101',20041102121642,'php4all'); INSERT INTO student VALUES (1726,'Corretjer Lee','Consuelo','','consuelo.corretjer_lee@phpuniversity.edu','00907',20041102121642,'php4all'); INSERT INTO student VALUES (1727,'Cole','Mayumi','S.','mayumi.cole@phpuniversity.edu','19460',20041102121642,'php4all'); INSERT INTO student VALUES (1728,'Clinton','Eddy','','eddy.clinton@phpuniversity.edu','11230-2020',20041102121642,'php4all'); INSERT INTO student VALUES (1729,'Clark','William','F.','william.clark@phpuniversity.edu','11217',20041102121642,'php4all'); INSERT INTO student VALUES (1730,'Cambray','Raymond','D.','raymond.cambray@phpuniversity.edu','10019-5715',20041102121642,'php4all'); INSERT INTO student VALUES (1731,'Calder','Cynthia','F.','cynthia.calder@phpuniversity.edu','11201',20041102121642,'php4all'); INSERT INTO student VALUES (1732,'Brett','Gisela','','gisela.brett@phpuniversity.edu','10021-7503',20041102121642,'php4all'); INSERT INTO student VALUES (1733,'Berry Gruby','Eva','','eva.berry_gruby@phpuniversity.edu','08701',20041102121642,'php4all'); INSERT INTO student VALUES (1734,'Benezra','Ingrid','','ingrid.benezra@phpuniversity.edu','10010-4011',20041102121642,'php4all'); INSERT INTO student VALUES (1735,'Baumann','Edith','J.','edith.baumann@phpuniversity.edu','07010-3233',20041102121642,'php4all'); INSERT INTO student VALUES (1736,'Ball','Carla','','carla.ball@phpuniversity.edu','07601',20041102121642,'php4all'); INSERT INTO student VALUES (1737,'Balch','Trudy','','trudy.balch@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1738,'Aste�nza','Jos�','Ram�n','jos�.aste�nza@phpuniversity.edu','07081-2516',20041102121642,'php4all'); INSERT INTO student VALUES (1739,'Adelo','A.','Samuel','a..adelo@phpuniversity.edu','87501',20041102121642,'php4all'); INSERT INTO student VALUES (1740,'Valle','Rocio','M.','rocio.valle@phpuniversity.edu','94015',20041102121642,'php4all'); INSERT INTO student VALUES (1741,'Shatova','Ella','Valeryevna','ella.shatova@phpuniversity.edu','10032',20041102121642,'php4all'); INSERT INTO student VALUES (1742,'Ndiaye','Waly','Mody','waly.ndiaye@phpuniversity.edu','10026',20041102121642,'php4all'); INSERT INTO student VALUES (1743,'Stemberger','Marta','','marta.stemberger@phpuniversity.edu','10014',20041102121642,'php4all'); INSERT INTO student VALUES (1744,'Friedrich','Gabrielle','','gabrielle.friedrich@phpuniversity.edu','06759',20041102121642,'php4all'); INSERT INTO student VALUES (1745,'Montez','Margarite','Heintz','margarite.montez@phpuniversity.edu','10022',20041102121642,'php4all'); INSERT INTO student VALUES (1746,'Barragan','Gloria','','gloria.barragan@phpuniversity.edu','11590-4440',20041102121642,'php4all'); INSERT INTO student VALUES (1747,'Tavora-Jainchill','Barbara','','barbara.tavora-jainchill@phpuniversity.edu','11797',20041102121642,'php4all'); INSERT INTO student VALUES (1748,'Tono','Nahoko','','nahoko.tono@phpuniversity.edu','10011',20041102121642,'php4all'); INSERT INTO student VALUES (1749,'Anderson','Lisa','Barocas','lisa.anderson@phpuniversity.edu','10034',20041102121642,'php4all'); INSERT INTO student VALUES (1750,'Otake','Shizuka','','shizuka.otake@phpuniversity.edu','11372',20041102121642,'php4all'); INSERT INTO student VALUES (1751,'Logeais','Ren�','','ren�.logeais@phpuniversity.edu','07306',20041102121642,'php4all'); INSERT INTO student VALUES (1752,'Wanhamid','May','','may.wanhamid@phpuniversity.edu','11105',20041102121642,'php4all'); INSERT INTO student VALUES (1753,'Orme','Charles','H','charles.orme@phpuniversity.edu','10011',20041102121642,'php4all'); INSERT INTO student VALUES (1754,'Tsaplina','Yulia','','yulia.tsaplina@phpuniversity.edu','11201',20041102121642,'php4all'); INSERT INTO student VALUES (1755,'Heinen','Daniele','','daniele.heinen@phpuniversity.edu','H3B 3K3',20041102121642,'php4all'); INSERT INTO student VALUES (1756,'Labrador','Javier','','javier.labrador@phpuniversity.edu','07093',20041102121642,'php4all'); INSERT INTO student VALUES (1757,'Colman','Lori','B','lori.colman@phpuniversity.edu','10567',20041102121642,'php4all'); INSERT INTO student VALUES (1758,'Brown','Yvonne','E','yvonne.brown@phpuniversity.edu','12144',20041102121642,'php4all'); INSERT INTO student VALUES (1759,'Altieri','Margaret','','margaret.altieri@phpuniversity.edu','08742',20041102121642,'php4all'); INSERT INTO student VALUES (1760,'Najenson-Brzoska','Barbara','','barbara.najenson-brzoska@phpuniversity.edu','06907',20041102121642,'php4all'); INSERT INTO student VALUES (1761,'Eishima','Yoko','','yoko.eishima@phpuniversity.edu','10007',20041102121642,'php4all'); INSERT INTO student VALUES (1762,'Axenova','Olga','','olga.axenova@phpuniversity.edu','11235',20041102121642,'php4all'); INSERT INTO student VALUES (1763,'Dumitru Parcalaboiu','Andreea','','andreea.dumitru_parcalaboiu@phpuniversity.edu','11104',20041102121642,'php4all'); INSERT INTO student VALUES (1764,'Borio-Rom�n','Renee','','renee.borio-rom�n@phpuniversity.edu','10461',20041102121642,'php4all'); INSERT INTO student VALUES (1765,'Painter','Kirsten','','kirsten.painter@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1766,'Gallagher','Wendy','S.','wendy.gallagher@phpuniversity.edu','80211',20041102121642,'php4all'); INSERT INTO student VALUES (1767,'Ferailleur','Carline','','carline.ferailleur@phpuniversity.edu','11377-4831',20041102121642,'php4all'); INSERT INTO student VALUES (1768,'Laperri�re','Guylaine','','guylaine.laperri�re@phpuniversity.edu','10034',20041102121642,'php4all'); INSERT INTO student VALUES (1769,'Schlottmann','Kevin','W.','kevin.schlottmann@phpuniversity.edu','11103',20041102121642,'php4all'); INSERT INTO student VALUES (1770,'Barbetti Vros','Lida','C.','lida.barbetti_vros@phpuniversity.edu','07470',20041102121642,'php4all'); INSERT INTO student VALUES (1771,'Bethea','Elizabeth','A','elizabeth.bethea@phpuniversity.edu','13032',20041102121642,'php4all'); INSERT INTO student VALUES (1772,'Schaefer R.','Patricia','L.','patricia.schaefer_r.@phpuniversity.edu','10029',20041102121642,'php4all'); INSERT INTO student VALUES (1773,'Derkatsch','Erick','','erick.derkatsch@phpuniversity.edu','10007',20041102121642,'php4all'); INSERT INTO student VALUES (1774,'Gaetjens','Erica','','erica.gaetjens@phpuniversity.edu','07011',20041102121642,'php4all'); INSERT INTO student VALUES (1775,'Anderson','Belina','','belina.anderson@phpuniversity.edu','11215',20041102121642,'php4all'); INSERT INTO student VALUES (1776,'Katusak','Frank','J.','frank.katusak@phpuniversity.edu','10022',20041103225552,'php4all'); INSERT INTO student VALUES (1777,'Ferraro','Daniel','C','daniel.ferraro@phpuniversity.edu','06825',20041102121642,'php4all'); INSERT INTO student VALUES (1778,'Bokor','Gabe','','gabe.bokor@phpuniversity.edu','12603',20041102121642,'php4all'); INSERT INTO student VALUES (1779,'Turner','Meir','','meir.turner@phpuniversity.edu','10039-3031',20041102121642,'php4all'); INSERT INTO student VALUES (1780,'Dooley','Kathleen','M.','kathleen.dooley@phpuniversity.edu','10033',20041102121642,'php4all'); INSERT INTO student VALUES (1781,'Landman','Thomas','','thomas.landman@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1782,'Mata','Cecilia','','cecilia.mata@phpuniversity.edu','10012',20041102121642,'php4all'); INSERT INTO student VALUES (1783,'Lisa','Nicole','','nicole.lisa@phpuniversity.edu','11238',20041102121642,'php4all'); INSERT INTO student VALUES (1784,'Schechter','Karen','','karen.schechter@phpuniversity.edu','11236',20041102121642,'php4all'); INSERT INTO student VALUES (1785,'Katcher','Antje','','antje.katcher@phpuniversity.edu','11937',20041102121642,'php4all'); INSERT INTO student VALUES (1786,'Lipitz','Marjana','','marjana.lipitz@phpuniversity.edu','11209',20041102121642,'php4all'); INSERT INTO student VALUES (1787,'Niederlohner','Peter','','peter.niederlohner@phpuniversity.edu','11220',20041102121642,'php4all'); INSERT INTO student VALUES (1788,'Seiler','Sabine','H.','sabine.seiler@phpuniversity.edu','12534',20041102121642,'php4all'); INSERT INTO student VALUES (1789,'Mura','Stefano','N.','stefano.mura@phpuniversity.edu','10040-2460',20041102121642,'php4all'); INSERT INTO student VALUES (1790,'Wolfson','Laura','Esther','laura.wolfson@phpuniversity.edu','75008',20041102121642,'php4all'); INSERT INTO student VALUES (1791,'Fishman','Ellen','B.','ellen.fishman@phpuniversity.edu','10010-4059',20041102121642,'php4all'); INSERT INTO student VALUES (1792,'Hodge','Diane','P.','diane.hodge@phpuniversity.edu','97150',20041102121642,'php4all'); INSERT INTO student VALUES (1793,'Thompson','Julie','','julie.thompson@phpuniversity.edu','11239',20041102121642,'php4all'); INSERT INTO student VALUES (1794,'Lockhart','Deborah','A.','deborah.lockhart@phpuniversity.edu','10019',20041102121642,'php4all'); INSERT INTO student VALUES (1795,'Robberecht','Annie','','annie.robberecht@phpuniversity.edu','T6G 2T5',20041102121642,'php4all'); INSERT INTO student VALUES (1796,'Kj�k','Solveig','','solveig.kj�k@phpuniversity.edu','11222',20041102121642,'php4all'); INSERT INTO student VALUES (1797,'Calman','Rachel','','rachel.calman@phpuniversity.edu','07960',20041102121642,'php4all'); INSERT INTO student VALUES (1798,'Sappington','Kerilyn','A.','kerilyn.sappington@phpuniversity.edu','91377',20041102121642,'php4all'); INSERT INTO student VALUES (1799,'Palmer','Amy','M','amy.palmer@phpuniversity.edu','11021',20041102121642,'php4all'); INSERT INTO student VALUES (1800,'Pfeffer','Esther','','esther.pfeffer@phpuniversity.edu','07740',20041102121642,'php4all'); INSERT INTO student VALUES (1801,'Gallup','Alison','','alison.gallup@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1802,'Ataklo','Abra','A.','abra.ataklo@phpuniversity.edu','07607',20041102121642,'php4all'); INSERT INTO student VALUES (1803,'Wheeler','Peter','J','peter.wheeler@phpuniversity.edu','07871',20041102121642,'php4all'); INSERT INTO student VALUES (1804,'White','Sarah','Melhado','sarah.white@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1805,'Gimigliano','Marilyn','J.','marilyn.gimigliano@phpuniversity.edu','07860',20041102121642,'php4all'); INSERT INTO student VALUES (1806,'McAndrews','Louise','D.','louise.mcandrews@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1807,'Pease','Elizabeth','S.','elizabeth.pease@phpuniversity.edu','10162',20041102121642,'php4all'); INSERT INTO student VALUES (1808,'Mehta','Sabine','G','sabine.mehta@phpuniversity.edu','07853',20041102121642,'php4all'); INSERT INTO student VALUES (1809,'Niceforo','Nicole','C.','nicole.niceforo@phpuniversity.edu','10023',20041102121642,'php4all'); INSERT INTO student VALUES (1810,'Abdulkareem','Algaily','M.','algaily.abdulkareem@phpuniversity.edu','11201',20041102121642,'php4all'); INSERT INTO student VALUES (1811,'Brochet','Maurice','','maurice.brochet@phpuniversity.edu','11215',20041102121642,'php4all'); INSERT INTO student VALUES (1812,'Richardson','Samantha','L','samantha.richardson@phpuniversity.edu','06804',20041102121642,'php4all'); INSERT INTO student VALUES (1813,'Romi Frezza','Claudia','M.','claudia.romi_frezza@phpuniversity.edu','10703',20041102121642,'php4all'); INSERT INTO student VALUES (1814,'Zecevic-Pralica','Slavica','','slavica.zecevic-pralica@phpuniversity.edu','07030',20041102121642,'php4all'); INSERT INTO student VALUES (1815,'Choo-Wong','Kai','Christophe','kai.choo-wong@phpuniversity.edu','10150-7953',20041102121642,'php4all'); INSERT INTO student VALUES (1816,'Meilhac','Agnes','E.M.','agnes.meilhac@phpuniversity.edu','06820',20041102121642,'php4all'); INSERT INTO student VALUES (1817,'Ristich','Elizabeth','V.','elizabeth.ristich@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1818,'Smithies','Richard','HR','richard.smithies@phpuniversity.edu','10003',20041102121642,'php4all'); INSERT INTO student VALUES (1819,'Lim','Alicia','Rocha','alicia.lim@phpuniversity.edu','10562',20041102121642,'php4all'); INSERT INTO student VALUES (1820,'Lepore','Claudia','T.','claudia.lepore@phpuniversity.edu','10580-1218',20041102121642,'php4all'); INSERT INTO student VALUES (1821,'Garcia Vizcaino','Maria','J','maria.garcia_vizcaino@phpuniversity.edu','07042',20041102121642,'php4all'); INSERT INTO student VALUES (1822,'DiFranco','Carla','M','carla.difranco@phpuniversity.edu','98199',20041102121642,'php4all'); INSERT INTO student VALUES (1823,'Brown','Mayumi','','mayumi.brown@phpuniversity.edu','11219-6005',20041102121642,'php4all'); INSERT INTO student VALUES (1824,'Arnold','Cameron','','cameron.arnold@phpuniversity.edu','11222',20041102121642,'php4all'); INSERT INTO student VALUES (1825,'Guillinta','Virginia','Victoria','virginia.guillinta@phpuniversity.edu','11784',20041102121642,'php4all'); INSERT INTO student VALUES (1826,'Escobar-Godi','Alma','','alma.escobar-godi@phpuniversity.edu','12182',20041102121642,'php4all'); INSERT INTO student VALUES (1827,'Hill','Cayce','','cayce.hill@phpuniversity.edu','10128',20041102121642,'php4all'); INSERT INTO student VALUES (1828,'Fukuda','Eiko','','eiko.fukuda@phpuniversity.edu','11215',20041102121642,'php4all'); INSERT INTO student VALUES (1829,'Aguiar','Christiana','Horton','christiana.aguiar@phpuniversity.edu','07670',20041102121642,'php4all'); INSERT INTO student VALUES (1830,'Rios','Zoila','','zoila.rios@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1831,'Brasler','Charlotte','B','charlotte.brasler@phpuniversity.edu','19103',20041102121642,'php4all'); INSERT INTO student VALUES (1832,'Valbuena-M.','Arturo','R.','arturo.valbuena-m.@phpuniversity.edu','11372-1313',20041102121642,'php4all'); INSERT INTO student VALUES (1833,'Wurtzel','Carl','','carl.wurtzel@phpuniversity.edu','11050',20041102121642,'php4all'); INSERT INTO student VALUES (1834,'Primak','Gila','','gila.primak@phpuniversity.edu','11223',20041102121642,'php4all'); INSERT INTO student VALUES (1835,'Aquije','David','R.','david.aquije@phpuniversity.edu','10545',20041102121642,'php4all'); INSERT INTO student VALUES (1836,'Engida','Fisseha','B','fisseha.engida@phpuniversity.edu','20910',20041102121642,'php4all'); INSERT INTO student VALUES (1837,'Bresler','Laurence','','laurence.bresler@phpuniversity.edu','11557',20041102121642,'php4all'); INSERT INTO student VALUES (1838,'Mead','Michelle','Annette','michelle.mead@phpuniversity.edu','10022-6761',20041102121642,'php4all'); INSERT INTO student VALUES (1839,'Hayes','Douglas','J','douglas.hayes@phpuniversity.edu','11231',20041102121642,'php4all'); INSERT INTO student VALUES (1840,'Shapiro','Claudia','','claudia.shapiro@phpuniversity.edu','11050',20041102121642,'php4all'); INSERT INTO student VALUES (1841,'Ichai','Tova','','tova.ichai@phpuniversity.edu','ISRAEL',20041102121642,'php4all'); INSERT INTO student VALUES (1842,'Paternostro','J.','C.','j..paternostro@phpuniversity.edu','19147-3811',20041102121642,'php4all'); INSERT INTO student VALUES (1843,'Kilov','Shifra','','shifra.kilov@phpuniversity.edu','07946',20041102121642,'php4all'); INSERT INTO student VALUES (1844,'Yu','Ya-ning','H.','ya-ning.yu@phpuniversity.edu','10016',20041102121642,'php4all'); INSERT INTO student VALUES (1845,'Cappi','Alicia','','alicia.cappi@phpuniversity.edu','55113-5412',20041102121642,'php4all'); INSERT INTO student VALUES (1846,'Chirignan','Mireille','','mireille.chirignan@phpuniversity.edu','11788',20041102121642,'php4all'); INSERT INTO student VALUES (1847,'Ould Mamady','Abdel Ghader','','abdel_ghader.ould_mamady@phpuniversity.edu','10452',20041102121642,'php4all'); INSERT INTO student VALUES (1848,'Lieto-McKenna','Claudia','','claudia.lieto-mckenna@phpuniversity.edu','11105',20041102121642,'php4all'); INSERT INTO student VALUES (1849,'Brezler','David','A','david.brezler@phpuniversity.edu','10467',20041102121642,'php4all'); INSERT INTO student VALUES (1850,'Maurer','Nicole','D','nicole.maurer@phpuniversity.edu','10022',20041102121642,'php4all'); INSERT INTO student VALUES (1851,'Sharon-Schwartz','Nadia-Adinah','','nadia-adinah.sharon-schwartz@phpuniversity.edu','11235',20041102121642,'php4all'); INSERT INTO student VALUES (1852,'Liguori','Tomoko','M','tomoko.liguori@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1853,'Albin','Ver�nica','S.','ver�nica.albin@phpuniversity.edu','77401',20041102121642,'php4all'); INSERT INTO student VALUES (1854,'Schnall','Cornelia','','cornelia.schnall@phpuniversity.edu','10011',20041102121642,'php4all'); INSERT INTO student VALUES (1855,'Giudici','Leonor','M.','leonor.giudici@phpuniversity.edu','33008',20041102121642,'php4all'); INSERT INTO student VALUES (1856,'Giudici','Beatriz','S.','beatriz.giudici@phpuniversity.edu','33008',20041102121642,'php4all'); INSERT INTO student VALUES (1857,'Gomes','Sormane','P.','sormane.gomes@phpuniversity.edu','19106',20041102121642,'php4all'); INSERT INTO student VALUES (1858,'Yepes','Nora','I.','nora.yepes@phpuniversity.edu','11373',20041102121642,'php4all'); INSERT INTO student VALUES (1859,'Dajnowski','Esther','L.','esther.dajnowski@phpuniversity.edu','07307',20041102121642,'php4all'); INSERT INTO student VALUES (1860,'Kyrillidis','Helen','C','helen.kyrillidis@phpuniversity.edu','11105',20041102121642,'php4all'); INSERT INTO student VALUES (1861,'Robertshaw','Brigid','A.','brigid.robertshaw@phpuniversity.edu','07090',20041102121642,'php4all'); INSERT INTO student VALUES (1862,'Lopategui','Amparo','M','amparo.lopategui@phpuniversity.edu','07876',20041102121642,'php4all'); INSERT INTO student VALUES (1863,'Weirich','Emily','J','emily.weirich@phpuniversity.edu','10029',20041102121642,'php4all'); INSERT INTO student VALUES (1864,'Prieto','GUILLERMO','','guillermo.prieto@phpuniversity.edu','11103-1605',20041102121642,'php4all'); INSERT INTO student VALUES (1865,'Martinez','Victor','L.','victor.martinez@phpuniversity.edu','07977',20041102121642,'php4all'); INSERT INTO student VALUES (1866,'Galindo','Gladys','','gladys.galindo@phpuniversity.edu','10304',20041102121642,'php4all'); INSERT INTO student VALUES (1867,'Grunebaum','Jason','','jason.grunebaum@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1868,'Fernandez','Mevelyn','R','mevelyn.fernandez@phpuniversity.edu','10023',20041102121642,'php4all'); INSERT INTO student VALUES (1869,'Beliavsky','Ludmila','','ludmila.beliavsky@phpuniversity.edu','10954',20041102121642,'php4all'); INSERT INTO student VALUES (1870,'Mahony','Dennis','','dennis.mahony@phpuniversity.edu','10014',20041102121642,'php4all'); INSERT INTO student VALUES (1871,'Rodgers','Albert','B','albert.rodgers@phpuniversity.edu','07030',20041102121642,'php4all'); INSERT INTO student VALUES (1872,'Kelsey','Richard','','richard.kelsey@phpuniversity.edu','11105',20041102121642,'php4all'); INSERT INTO student VALUES (1873,'Slomanson','Peter','','peter.slomanson@phpuniversity.edu','10033',20041102121642,'php4all'); INSERT INTO student VALUES (1874,'Arias','Maria','R','maria.arias@phpuniversity.edu','10017',20041102121642,'php4all'); INSERT INTO student VALUES (1875,'Scheffel','Pablo','G.','pablo.scheffel@phpuniversity.edu','10011',20041102121642,'php4all'); INSERT INTO student VALUES (1876,'Benavides','Belinda','','belinda.benavides@phpuniversity.edu','10562',20041102121642,'php4all'); INSERT INTO student VALUES (1877,'Hunt','John','J','john.hunt@phpuniversity.edu','07031',20041102121642,'php4all'); INSERT INTO student VALUES (1878,'Otake','Hideko','','hideko.otake@phpuniversity.edu','10003',20041102121642,'php4all'); INSERT INTO student VALUES (1879,'Macedo','Celia','','celia.macedo@phpuniversity.edu','10031',20041102121642,'php4all'); INSERT INTO student VALUES (1880,'Harrison','Dina','A','dina.harrison@phpuniversity.edu','11209',20041102121642,'php4all'); INSERT INTO student VALUES (1881,'Anwar','Blandine','','blandine.anwar@phpuniversity.edu','11217',20041102121642,'php4all'); INSERT INTO student VALUES (1882,'Kim','Victoria','','victoria.kim@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1884,'Krup','Steven','Anthony','steven.krup@phpuniversity.edu','07006',20041102121642,'php4all'); INSERT INTO student VALUES (1885,'Trotta','Louisa','P','louisa.trotta@phpuniversity.edu','07538-8705',20041102121642,'php4all'); INSERT INTO student VALUES (1886,'Cipriano','Henrietta','','henrietta.cipriano@phpuniversity.edu','10552',20041102121642,'php4all'); INSERT INTO student VALUES (1887,'Juergen','Kuehn','','kuehn.juergen@phpuniversity.edu','06877',20041102121642,'php4all'); INSERT INTO student VALUES (1888,'Fan','Lan Ying','','lan_ying.fan@phpuniversity.edu','12143',20041102121642,'php4all'); INSERT INTO student VALUES (1889,'Pinto','Cesare','','cesare.pinto@phpuniversity.edu','08904',20041102121642,'php4all'); INSERT INTO student VALUES (1890,'Idrissi','Miyoko','','miyoko.idrissi@phpuniversity.edu','10034',20041102121642,'php4all'); INSERT INTO student VALUES (1892,'von Wietersheim','Ute','M','ute.von_wietersheim@phpuniversity.edu','11722',20041102121642,'php4all'); INSERT INTO student VALUES (1893,'Moore','Marie','B','marie.moore@phpuniversity.edu','10034',20041102121642,'php4all'); INSERT INTO student VALUES (1894,'Ross','Alex','','alex.ross@phpuniversity.edu','10012',20041102121642,'php4all'); INSERT INTO student VALUES (1895,'Toyoda','Masako','','masako.toyoda@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1896,'McFarlane','Barbara','O\'Day','barbara.mcfarlane@phpuniversity.edu','19105-3069',20041103233448,'php4all'); INSERT INTO student VALUES (1897,'Hayashi','Ayako','','ayako.hayashi@phpuniversity.edu','10128',20041102121642,'php4all'); INSERT INTO student VALUES (1898,'Leff','Katherine','','katherine.leff@phpuniversity.edu','10009',20041102121642,'php4all'); INSERT INTO student VALUES (1899,'Egana','Santiago','G.','santiago.egana@phpuniversity.edu','10543',20041102121642,'php4all'); INSERT INTO student VALUES (1900,'Golovenkov','Nikolai','','nikolai.golovenkov@phpuniversity.edu','10044',20041102121642,'php4all'); INSERT INTO student VALUES (1901,'Hecht','Eve','E','eve.hecht@phpuniversity.edu','07208',20041102121642,'php4all'); INSERT INTO student VALUES (1902,'Totz','Alexander','C','alexander.totz@phpuniversity.edu','10034-3076',20041102121642,'php4all'); INSERT INTO student VALUES (1903,'Braga','Tereza','D.','tereza.braga@phpuniversity.edu','75243',20041102121642,'php4all'); INSERT INTO student VALUES (1904,'Seflek','G�lin','','g�lin.seflek@phpuniversity.edu','81210',20041102121642,'php4all'); INSERT INTO student VALUES (1905,'Rompis','Oscar','','oscar.rompis@phpuniversity.edu','91761',20041102121642,'php4all'); INSERT INTO student VALUES (1906,'Sal','Gashi','','gashi.sal@phpuniversity.edu','07410',20041102121642,'php4all'); INSERT INTO student VALUES (1907,'Zhou','Xinfeng','','xinfeng.zhou@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1908,'isakov','dmitry','','dmitry.isakov@phpuniversity.edu','634034',20041102121642,'php4all'); INSERT INTO student VALUES (1909,'Bachmann','Heike','','heike.bachmann@phpuniversity.edu','10009',20041102121642,'php4all'); INSERT INTO student VALUES (1910,'Cohen','James','A.','james.cohen@phpuniversity.edu','11372',20041102121642,'php4all'); INSERT INTO student VALUES (1911,'Delgado','Arturo','A.','arturo.delgado@phpuniversity.edu','12533',20041102121642,'php4all'); INSERT INTO student VALUES (1912,'Carey','Tanyika','','tanyika.carey@phpuniversity.edu','10030',20041102121642,'php4all'); INSERT INTO student VALUES (1913,'Seito','Yuji','','yuji.seito@phpuniversity.edu','10009',20041102121642,'php4all'); INSERT INTO student VALUES (1914,'McEvoy','Benardette','G','benardette.mcevoy@phpuniversity.edu','11218',20041102121642,'php4all'); INSERT INTO student VALUES (1915,'Sowchek','Ellen','','ellen.sowchek@phpuniversity.edu','11710-3558',20041102121642,'php4all'); INSERT INTO student VALUES (1917,'cherry','frank','g.','frank.cherry@phpuniversity.edu','10044',20041102121642,'php4all'); INSERT INTO student VALUES (1918,'Simonot-Kahan','Elisa','','elisa.simonot-kahan@phpuniversity.edu','11211',20041102121642,'php4all'); INSERT INTO student VALUES (1919,'Catalano','Samantha','','samantha.catalano@phpuniversity.edu','10028',20041102121642,'php4all'); INSERT INTO student VALUES (1920,'Mariles','Althea','M','althea.mariles@phpuniversity.edu','11206',20041102121642,'php4all'); INSERT INTO student VALUES (1921,'Miranda','Carlos','R.','carlos.miranda@phpuniversity.edu','06413-1153',20041102121642,'php4all'); INSERT INTO student VALUES (1922,'Torres','Olga','','olga.torres@phpuniversity.edu','07093',20041102121642,'php4all'); INSERT INTO student VALUES (1923,'Riebling','Lucy','S','lucy.riebling@phpuniversity.edu','07920',20041102121642,'php4all'); INSERT INTO student VALUES (1924,'White','Gisela','M.','gisela.white@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1925,'Rubino','Ignazia','Nancy','ignazia.rubino@phpuniversity.edu','10040',20041102121642,'php4all'); INSERT INTO student VALUES (1926,'Ahmed','Mutasim','T','mutasim.ahmed@phpuniversity.edu','11218',20041102121642,'php4all'); INSERT INTO student VALUES (1927,'Bergnes','Linda','','linda.bergnes@phpuniversity.edu','10011-1463',20041102121642,'php4all'); INSERT INTO student VALUES (1928,'Galetta','Maria','','maria.galetta@phpuniversity.edu','10014-1947',20041102121642,'php4all'); INSERT INTO student VALUES (1929,'Schmiedel','Christine','K','christine.schmiedel@phpuniversity.edu','11220',20041102121642,'php4all'); INSERT INTO student VALUES (1930,'Brandstein','Sharon','','sharon.brandstein@phpuniversity.edu','10003-5454',20041102121642,'php4all'); INSERT INTO student VALUES (1931,'Berti','Berto','','berto.berti@phpuniversity.edu','06902',20041102121642,'php4all'); INSERT INTO student VALUES (1932,'Hasan','Hala','','hala.hasan@phpuniversity.edu','07030',20041102121642,'php4all'); INSERT INTO student VALUES (1933,'Pedersini','Elisabetta','','elisabetta.pedersini@phpuniversity.edu','33743',20041102121642,'php4all'); INSERT INTO student VALUES (1934,'Poirey','Thierry','','thierry.poirey@phpuniversity.edu','20011',20041102121642,'php4all'); INSERT INTO student VALUES (1935,'Treuhaft','Laurie','A.','laurie.treuhaft@phpuniversity.edu','11372',20041102121642,'php4all'); INSERT INTO student VALUES (1936,'Makeeva-Roylance','Alla','','alla.makeeva-roylance@phpuniversity.edu','11215',20041102121642,'php4all'); INSERT INTO student VALUES (1937,'Kaninya','John','','john.kaninya@phpuniversity.edu','93705',20041102121642,'php4all'); INSERT INTO student VALUES (1938,'Hild','Adelina','V.','adelina.hild@phpuniversity.edu','10589',20041102121642,'php4all'); INSERT INTO student VALUES (1939,'Brown','Molly Marie','','molly_marie.brown@phpuniversity.edu','11103-1911',20041102121642,'php4all'); INSERT INTO student VALUES (1940,'Askienazy','Bernard','','bernard.askienazy@phpuniversity.edu','10024',20041102121642,'php4all'); INSERT INTO student VALUES (1941,'Quiete Nester','Angela','','angela.quiete_nester@phpuniversity.edu','11365',20041102121642,'php4all'); INSERT INTO student VALUES (1942,'Ruiz','Sonia','','sonia.ruiz@phpuniversity.edu','07974',20041102121642,'php4all'); INSERT INTO student VALUES (1943,'Hoffman-Jedruch','Eva','C','eva.hoffman-jedruch@phpuniversity.edu','07901-1715',20041102121642,'php4all'); INSERT INTO student VALUES (1944,'Ranhe','Elisabeth','','elisabeth.ranhe@phpuniversity.edu','11103',20041102121642,'php4all'); INSERT INTO student VALUES (1945,'Brayton','Colin','E.','colin.brayton@phpuniversity.edu','11238',20041102121642,'php4all'); INSERT INTO student VALUES (1946,'Stara','Francesca','','francesca.stara@phpuniversity.edu','00135',20041102121642,'php4all'); INSERT INTO student VALUES (1947,'Fox','Jordan','','jordan.fox@phpuniversity.edu','10025',20041102121642,'php4all'); INSERT INTO student VALUES (1948,'Rohalska','Zhanna','Valeriivna','zhanna.rohalska@phpuniversity.edu','10024',20041102121642,'php4all'); INSERT INTO student VALUES (1950,'Killea','Bridget','E','bridget.killea@phpuniversity.edu','10028',20041102121642,'php4all'); INSERT INTO student VALUES (1951,'Campbell','Eugenia','T','eugenia.campbell@phpuniversity.edu','10021',20041102121642,'php4all'); INSERT INTO student VALUES (1952,'Demers','Guy','','guy.demers@phpuniversity.edu','G4R 2K8',20041102121642,'php4all'); INSERT INTO student VALUES (1953,'Martinez','Suzana','Daroca','suzana.martinez@phpuniversity.edu','07733',20041102121642,'php4all'); INSERT INTO student VALUES (1954,'Paraskevas','Katerina','','katerina.paraskevas@phpuniversity.edu','11377',20041102121642,'php4all'); INSERT INTO student VALUES (1956,'Ospina','Sandra','','sandra.ospina@phpuniversity.edu','10023',20041102121642,'php4all'); INSERT INTO student VALUES (1957,'Hatzis','Victoria','','victoria.hatzis@phpuniversity.edu','10026',20041102121642,'php4all'); INSERT INTO student VALUES (1958,'Casares','Clara','A','clara.casares@phpuniversity.edu','10016',20041102121642,'php4all'); INSERT INTO student VALUES (1959,'Ates','Erkan','','erkan.ates@phpuniversity.edu','K2B7S9',20041102121642,'php4all'); INSERT INTO student VALUES (1960,'Monteagudo','Mary Ann','Elsa','mary_ann.monteagudo@phpuniversity.edu','11',20041102121642,'php4all'); INSERT INTO student VALUES (1961,'Corriveau','Linda','','linda.corriveau@phpuniversity.edu','10704',20041102121642,'php4all'); INSERT INTO student VALUES (1962,'Nagano','Yumi','','yumi.nagano@phpuniversity.edu','10016',20041102121642,'php4all'); INSERT INTO student VALUES (1963,'Mefret-Norman','Nicole','a','nicole.mefret-norman@phpuniversity.edu','10036',20041102121642,'php4all'); INSERT INTO student VALUES (1964,'Morin','Leonard','T','leonard.morin@phpuniversity.edu','11211-2832',20041102121642,'php4all'); INSERT INTO student VALUES (1965,'Nystrom','Markus','P','markus.nystrom@phpuniversity.edu','10010',20041102121642,'php4all'); INSERT INTO student VALUES (1966,'Guzman','Luis','Alejandro','luis.guzman@phpuniversity.edu','11215',20041102121642,'php4all'); INSERT INTO student VALUES (1967,'Grossman','Sarah','','sarah.grossman@phpuniversity.edu','10538',20041102121642,'php4all'); INSERT INTO student VALUES (1969,'DeMarco','Gina','A','gina.demarco@phpuniversity.edu','19425',20041102121642,'php4all'); INSERT INTO student VALUES (1970,'Scott','Hui-feng','','hui-feng.scott@phpuniversity.edu','11372',20041102121642,'php4all'); INSERT INTO student VALUES (1971,'Ikehaha','Ariko','S','ariko.ikehaha@phpuniversity.edu','10029',20041102121642,'php4all'); INSERT INTO student VALUES (1972,'Reyes','Rosa','','rosa.reyes@phpuniversity.edu','08873',20041102121642,'php4all'); INSERT INTO student VALUES (1973,'Cesar','Aicha','','aicha.cesar@phpuniversity.edu','11415',20041102121642,'php4all'); INSERT INTO student VALUES (1974,'Yusr','Afrah','Mohamed\\M','afrah.yusr@phpuniversity.edu','11213',20041102121642,'php4all'); INSERT INTO student VALUES (1975,'Perez','Carmen','M','carmen.perez@phpuniversity.edu','10028',20041102121642,'php4all'); INSERT INTO student VALUES (1976,'Sasaki','Kana','','kana.sasaki@phpuniversity.edu','10016',20041102121642,'php4all'); INSERT INTO student VALUES (1977,'Tohmatsu','Akiko','J','akiko.tohmatsu@phpuniversity.edu','11790',20041102121642,'php4all'); INSERT INTO student VALUES (1978,'Tardone','Sergio','E.','sergio.tardone@phpuniversity.edu','11050',20041102121642,'php4all'); INSERT INTO student VALUES (1979,'Klein','Carina','','carina.klein@phpuniversity.edu','10001',20041102121642,'php4all'); INSERT INTO student VALUES (1980,'Granger','Brian','R','brian.granger@phpuniversity.edu','2315 KN',20041102121642,'php4all'); INSERT INTO student VALUES (1981,'Campos','Luis','S','luis.campos@phpuniversity.edu','10027',20041102121642,'php4all'); INSERT INTO student VALUES (1982,'Jacobs','Martin','','martin.jacobs@phpuniversity.edu','11235',20041102121642,'php4all'); INSERT INTO student VALUES (1983,'Chang','Maria','Cristina','maria.chang@phpuniversity.edu','11373',20041102121642,'php4all'); INSERT INTO student VALUES (1984,'Prempeh','Osei','','osei.prempeh@phpuniversity.edu','11216',20041102121642,'php4all'); INSERT INTO student VALUES (1985,'Mazibrada','Vedran','','vedran.mazibrada@phpuniversity.edu','11103',20041102121642,'php4all'); INSERT INTO student VALUES (1986,'Schoenberg','Christian','','christian.schoenberg@phpuniversity.edu','10023',20041102121642,'php4all'); INSERT INTO student VALUES (1987,'Coupet','Nathalie','P','nathalie.coupet@phpuniversity.edu','33186',20041102121642,'php4all'); INSERT INTO student VALUES (1988,'Rogoz','Renata','B.','renata.rogoz@phpuniversity.edu','11733',20041102121642,'php4all'); INSERT INTO student VALUES (1989,'Paciello','Young','E','young.paciello@phpuniversity.edu','11050',20041102121642,'php4all'); INSERT INTO student VALUES (1991,'Sun','John','J.','john.sun@phpuniversity.edu','07470',20041102121642,'php4all'); INSERT INTO student VALUES (1992,'Peyser','Diane','','diane.peyser@phpuniversity.edu','07081',20041102121642,'php4all'); INSERT INTO student VALUES (1993,'Kovacheva','Donna','','donna.kovacheva@phpuniversity.edu','22209',20041102121642,'php4all'); INSERT INTO student VALUES (1994,'Hosokawa','Midori','','midori.hosokawa@phpuniversity.edu','10036',20041102121642,'php4all'); INSERT INTO student VALUES (1995,'Luukkonen','Grace','','grace.luukkonen@phpuniversity.edu','10013',20041102121642,'php4all'); INSERT INTO student VALUES (1996,'Fahey','Kaoru','S.','kaoru.fahey@phpuniversity.edu','10591',20041102121642,'php4all'); INSERT INTO student VALUES (1997,'Koteas','Ellie','','ellie.koteas@phpuniversity.edu','11101',20041102121642,'php4all'); INSERT INTO student VALUES (1999,'Kirchoffer','Ann','','ann.kirchoffer@phpuniversity.edu','10014',20041102121642,'php4all'); INSERT INTO student VALUES (2000,'Fresco','Betsabe','','betsabe.fresco@phpuniversity.edu','11003',20041102121642,'php4all'); INSERT INTO student VALUES (2001,'Devroye','Maurice','J','maurice.devroye@phpuniversity.edu','07901',20041102121642,'php4all'); INSERT INTO student VALUES (2003,'Parnes','Gabrielle','','gabrielle.parnes@phpuniversity.edu','10044',20041102121642,'php4all'); INSERT INTO student VALUES (2004,'Almeida Jr','Hermes','Jose','hermes.almeida_jr@phpuniversity.edu','07043',20041102121642,'php4all'); INSERT INTO student VALUES (2005,'Lakomiak','Amii','V','amii.lakomiak@phpuniversity.edu','07042',20041102121642,'php4all'); INSERT INTO student VALUES (2006,'Brandkamp','Laura','I.','laura.brandkamp@phpuniversity.edu','11365-0624',20041102121642,'php4all'); INSERT INTO student VALUES (2007,'Chen','Ling','','ling.chen@phpuniversity.edu','11374',20041102121642,'php4all'); INSERT INTO student VALUES (2008,'%bludgeon','Vernon','T.','vernon.bludgeon@phpuniversity.edu','',20041102121642,'php4all'); INSERT INTO student VALUES (2015,'Scumbag','John','Z.','scum@bag.net','07302-1603',20041114165020,'php4all'); -- -- Table structure for table `test` -- DROP TABLE IF EXISTS test; CREATE TABLE test ( id smallint(6) NOT NULL default '0', lastname varchar(50) NOT NULL default '', firstname varchar(50) NOT NULL default '', PRIMARY KEY (id) ) TYPE=InnoDB; -- -- Dumping data for table `test` -- -- -- Table structure for table `workshop` -- DROP TABLE IF EXISTS workshop; CREATE TABLE workshop ( id smallint(5) unsigned NOT NULL auto_increment, name varchar(60) NOT NULL default '', description text NOT NULL, instructor_id smallint(6) NOT NULL default '0', date_time datetime NOT NULL default '0000-00-00 00:00:00', lastmod timestamp(14) NOT NULL, PRIMARY KEY (id), KEY name (name) ) TYPE=MyISAM; -- -- Dumping data for table `workshop` -- INSERT INTO workshop VALUES (1,'Web Services','Learn how to do cool stuff with XML-RPC, SOAP, amd more',2,'2005-01-15 14:00:00',20041104004417); INSERT INTO workshop VALUES (2,'Secure Web Applications','Evil people will walk all over your web app unless you take this workshop and learn how to stop them.',0,'2004-12-07 16:00:00',20041104030203); INSERT INTO workshop VALUES (3,'Tuning High End Mysql Apps','Learn to make your MySQL/PHP applications scream at this singularly cool workshop where all the cool kids become even cooler.',6,'2005-02-08 14:00:00',20041104012024); INSERT INTO workshop VALUES (6,'Grokking PHP 5','You know you\'ll love it.',5,'2005-03-24 10:00:00',20041104041601); -- -- Table structure for table `workshop_registration` -- DROP TABLE IF EXISTS workshop_registration; CREATE TABLE workshop_registration ( student_id smallint(5) unsigned NOT NULL default '0', workshop_id smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (student_id,workshop_id) ) TYPE=MyISAM; -- -- Dumping data for table `workshop_registration` -- INSERT INTO workshop_registration VALUES (2014,1); INSERT INTO workshop_registration VALUES (2014,2); INSERT INTO workshop_registration VALUES (2014,3);