USE [master]
GO

CREATE DATABASE [mims] ON  PRIMARY 
( NAME = N'mims', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mims.mdf' , SIZE = 4096KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'mims_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mims_log.ldf' , SIZE = 3456KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

CREATE LOGIN [mims] WITH PASSWORD=N'mims', DEFAULT_DATABASE=[mims], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

USE [mims]
GO

CREATE USER [mims] FOR LOGIN [mims] WITH DEFAULT_SCHEMA=[mims]
GO

GRANT CONNECT, CREATE FUNCTION, CREATE PROCEDURE, CREATE TABLE, CREATE VIEW TO mims
GO

CREATE SCHEMA mims AUTHORIZATION mims