------------------------------------------------------------------
--                                                              --
--  File:   CREATE_DATABASE.SQL                                 --
--          Microsoft TPC-E Benchmark Kit Ver. 1.12.0-1022      --
--          Copyright Microsoft  2008, 2009, 2010               --
--                                                              --
------------------------------------------------------------------

USE master
GO

--  create main database files
CREATE DATABASE tpce
ON PRIMARY
(	NAME		= MSSQL_tpce_root,
	FILENAME	= 'V:\MSSQL_tpce_root.mdf',
	SIZE		= 10MB,
	FILEGROWTH	= 10),

FILEGROUP	tpce_fg
(	NAME		= tpce1,
	FILENAME	= 'V:\Device\tpce_01\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce2,
	FILENAME	= 'V:\Device\tpce_02\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce3,
	FILENAME	= 'V:\Device\tpce_03\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce4,
	FILENAME	= 'V:\Device\tpce_04\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce5,
	FILENAME	= 'V:\Device\tpce_05\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce6,
	FILENAME	= 'V:\Device\tpce_06\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce7,
	FILENAME	= 'V:\Device\tpce_07\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce8,
	FILENAME	= 'V:\Device\tpce_08\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce9,
	FILENAME	= 'V:\Device\tpce_09\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce10,
	FILENAME	= 'V:\Device\tpce_10\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce11,
	FILENAME	= 'V:\Device\tpce_11\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce12,
	FILENAME	= 'V:\Device\tpce_12\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce13,
	FILENAME	= 'V:\Device\tpce_13\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce14,
	FILENAME	= 'V:\Device\tpce_14\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce15,
	FILENAME	= 'V:\Device\tpce_15\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce16,
	FILENAME	= 'V:\Device\tpce_16\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce17,
	FILENAME	= 'V:\Device\tpce_17\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce18,
	FILENAME	= 'V:\Device\tpce_18\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce19,
	FILENAME	= 'V:\Device\tpce_19\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce20,
	FILENAME	= 'V:\Device\tpce_20\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce21,
	FILENAME	= 'V:\Device\tpce_21\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0),
(	NAME		= tpce22,
	FILENAME	= 'V:\Device\tpce_22\',
	SIZE		= 1029000MB,
	FILEGROWTH	= 0)
LOG ON
(	NAME		= MSSQL_tpce_log,
	FILENAME	= 'V:\Device\TPCE_Log\',
	SIZE		= 972800MB,
	FILEGROWTH	= 0)
COLLATE Latin1_General_BIN
GO

alter database tpce
add file
(	NAME = tpceaddon01,
	FILENAME = 'V:\Device\tpceaddon01\tpceaddon01.ndf',
	SIZE		= 3145728MB,
	FILEGROWTH	= 0)
to filegroup tpce_fg
go
