I downloaded 1.0.0 and ran the unit tests after creating the nhibernate database and changing the nhibernate.test.config file but still get errors which are apparently from the tests looking for specific tables and joins. Where are the scripts to generate the test database?

There are no SQL scripts for the tests since all table definitions etc. are created automagically from the mappings with SchemaExport.

Which errors do you get?

The errors might come from SchemaExport attempting to delete tables before it creates them, these errors may safely be ignored.

Not so much errors as not run (yellow in nunit gui)
Here is a little of the output from the console. There are many more messages. Some of this might be trace info? I just assumed (you know what they say) that all tests would be ran.

alter table A drop constraint FK2B5E47667213E
Unsuccessful: Cannot alter table 'A' because this table does not exist in database 'nhibernate'.
alter table A drop constraint FK2B5E42B5C6597297
Unsuccessful: Cannot alter table 'A' because this table does not exist in database 'nhibernate'.
alter table Map drop constraint FKB87C3D9B87C40A
Unsuccessful: Cannot alter table 'Map' because this table does not exist in database 'nhibernate'.
drop table A
Unsuccessful: Cannot drop the table 'A', because it does not exist in the system catalog.
drop table E
Unsuccessful: Cannot drop the table 'E', because it does not exist in the system catalog.
drop table D
Unsuccessful: Cannot drop the table 'D', because it does not exist in the system catalog.
drop table Map
Unsuccessful: Cannot drop the table 'Map', because it does not exist in the system catalog.
2005-11-29 20:21:18,062 [2752] INFO NHibernate.Cache.UpdateTimestampsCache - starting update timestamps cache at region: UpdateTimestampsCache
2005-11-29 20:21:18,062 [2752] INFO NHibernate.Cache.StandardQueryCache - starting query cache at region: NHibernate.Cache.StandardQueryCache
2005-11-29 20:21:18,359 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [E]
2005-11-29 20:21:18,359 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,359 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [E]
2005-11-29 20:21:18,359 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,359 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,796 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,796 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,796 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [Map]
2005-11-29 20:21:18,796 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,812 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [E]
2005-11-29 20:21:18,812 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [E]
2005-11-29 20:21:18,812 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,828 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]
2005-11-29 20:21:18,843 [2752] DEBUG NHibernate.Cache.UpdateTimestampsCache - Invalidating space [A]

As Sergey said, you can safely ignore these "errors".