I want to create a new database for the Discovery Service, can anyone tell me if there is a script provided for this in the SDL Web 8 installation media?
As mentioned in the documentation (http://docs.sdl.com/LiveContent/content/en-US/SDL%20Web-v1/GUID-654563D2-F38B-43C9-851C-0C1104FBA2AA), you can use PowerShell, and depending on your database navigate to one of the following folders on the installation media:
Then type the following command to create a new Discovery Service database:
& '.\Install Content Data Store.ps1'
If you manually want to run SQL scripts, see the following topic in the documentation http://docs.sdl.com/LiveContent/content/en-US/SDL%20Web-v1/GUID-40FA413B-E255-4F24-BF99-643C4124DC11