-- Drop if exist
if @@trancount > 0 begin rollback end
use tempdb
go
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'RatchetTest')
	DROP DATABASE [RatchetTest]
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'RatchetLive')
	DROP DATABASE [RatchetLive]
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'RatchetDev')
	DROP DATABASE RatchetDev

GO
--Create the databases
CREATE DATABASE RatchetTest
CREATE DATABASE RatchetLive
CREATE DATABASE RatchetDev