The newbie strikes back !

Hi,

I know christmas is over, i'm looking for a complete exemple of
script to create a database.
As possible an exemple : domain, table with check, maybe some
insertion or stored procedure....
I know, this is quit big but i came from MS sql-server so....

thanks

Akim