Build and Populate the two tables: project and drawings
dropped s09project OK
created s09project OK
dropped s09drawings OK
created s09drawings OK
Bulk Inserts for the project table:
sql=INSERT into s09project (proj_id,proj_name) VALUES (1,'The John and Mary House') OK
sql=INSERT into s09project (proj_id,proj_name) VALUES (2,'Jones Hall') OK
sql=INSERT into s09project (proj_id,proj_name) VALUES (3,'The Big New Airport') OK
sql=INSERT into s09project (proj_id,proj_name) VALUES (4,'Little White House') OK
Bulk Inserts for the drawings table:
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (1,'A','J&M Architecture Plans','C:\jmh.dwg','11/23/2009 5:56:35 AM',71) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (1,'M','J&M Plumbing Plans','C:\plumb.dwg','11/23/2009 5:56:35 AM',53) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (1,'E','J&M Electrical Plans','C:\jmelec.dwg','11/23/2009 5:56:35 AM',58) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (2,'L','Jones Land','C:\jland.dwg','11/23/2009 5:56:35 AM',29) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (2,'A','Jones Plans','C:\jplans.dwg','11/23/2009 5:56:35 AM',30) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (2,'L','Jones Trees','C:\jtree.dwg','11/23/2009 5:56:35 AM',77) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (3,'L','Airports Trees','C:\atrees.dwg','11/23/2009 5:56:35 AM',1) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (3,'E','Airport Electrical','C:\airelec.dwg','11/23/2009 5:56:35 AM',76) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (3,'M','Airport Pipes','C:\airpipe.dwg','11/23/2009 5:56:35 AM',81) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (4,'A','Little Plans','C:\lwhplans.dwg','11/23/2009 5:56:35 AM',71) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (4,'M','Little Mechanical','C:\lwhmech.dwg','11/23/2009 5:56:35 AM',5) OK
sql=INSERT into s09drawings (proj_id,drawing_type,drawing_desc,drawing_file,drawing_date,drawing_version) VALUES (4,'L','Little Trees','C:\lwhtrees.dwg','11/23/2009 5:56:35 AM',41) OK
Normal Termination at: 11/23/2009 5:56:35 AM