USE master;
GO

DECLARE @DB1 varchar(200); DECLARE @DB2 varchar(200); DECLARE @DB3 varchar(200); DECLARE @DB4 varchar(200);DECLARE @DB5 varchar(200); 
DECLARE @path varchar(200); DECLARE @RECOVERY varchar(50); DECLARE @CREATE1 varchar(1000); DECLARE @CREATE2 varchar(1000); 
DECLARE @CREATE3 varchar(1000); DECLARE @CREATE4 varchar(1000); DECLARE @CREATE5 varchar(1000); DECLARE @ZKRATKA_FIRMY varchar(100); 
DECLARE @PASS varchar(100);
DECLARE @CREATE_USER NVARCHAR(4000);
DECLARE @USR varchar(100);


--	****************	   	 NASTAVENI      	****************

SET @path = 'd:\MSSQL_DATA_DIR\';					-- Path to save MSSQL databases - Kam se mají data na serveru uložit
SET @PASS = 'XXXXXXXXX';							-- Password for user "pal" - Nastavte heslo pro uzivatele "pal"
SET @USR = 'pal';									-- !!!! DO NOT CHANGE - NEMENIT !!!!!
SET @DB1 = 'pal3g_attach';							-- database of attachment - databáze příloh
SET @DB2 = 'pal3g_qsd';								-- database of QSD - databáze modulu QSD
SET @DB3 = 'pal3g_archiv';							-- database of Archive - databáze modulu ARCHIV
SET @DB4 = 'pal3g_data';							-- main data database - hlavní datová databáze
SET @DB5 = 'pal3g_demodata';						-- demo database - jak se má jmenovat databáze DEMODATA
SET @RECOVERY = 'SIMPLE';
SET @ZKRATKA_FIRMY = '';							-- prefix for all databases

--	************************************************************


SET @CREATE_USER = 'CREATE LOGIN ' + @USR + ' WITH PASSWORD = '''+ @PASS +''',CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF';
EXECUTE(@CREATE_USER);



IF (@ZKRATKA_FIRMY != '') 
BEGIN
SET @DB1 = @ZKRATKA_FIRMY + '_' + @DB1;
SET @DB2 = @ZKRATKA_FIRMY + '_' + @DB2;
SET @DB3 = @ZKRATKA_FIRMY + '_' + @DB3;
SET @DB4 = @ZKRATKA_FIRMY + '_' + @DB4;
SET @DB5 = @ZKRATKA_FIRMY + '_' + @DB5;
END

SET @CREATE1 ='CREATE DATABASE ' + @DB1  + '
ON
( NAME = ' + @DB1 + ', FILENAME = ''' + @path + @DB1 + '.mdf'')
LOG ON
( NAME = ' + @DB1 + '_log, FILENAME = ''' + @path + @DB1 + '_log.ldf'')
COLLATE Czech_CS_AS
ALTER DATABASE ' + @DB1 + ' SET RECOVERY ' + @RECOVERY + ';'

SET @CREATE2 ='CREATE DATABASE ' + @DB2  + '
ON
( NAME = ' + @DB2 + ', FILENAME = ''' + @path + @DB2 + '.mdf'')
LOG ON
( NAME = ' + @DB2 + '_log, FILENAME = ''' + @path + @DB2 + '_log.ldf'')
COLLATE Czech_CS_AS
ALTER DATABASE ' + @DB2 + ' SET RECOVERY ' + @RECOVERY + ';'

SET @CREATE3 ='CREATE DATABASE ' + @DB3  + '
ON
( NAME = ' + @DB3 + ', FILENAME = ''' + @path + @DB3 + '.mdf'')
LOG ON
( NAME = ' + @DB3 + '_log, FILENAME = ''' + @path + @DB3 + '_log.ldf'')
COLLATE Czech_CS_AS
ALTER DATABASE ' + @DB3 + ' SET RECOVERY ' + @RECOVERY + ';'

SET @CREATE4 ='CREATE DATABASE ' + @DB4  + '
ON
( NAME = ' + @DB4 + ', FILENAME = ''' + @path + @DB4 + '.mdf'')
LOG ON
( NAME = ' + @DB4 + '_log, FILENAME = ''' + @path + @DB4 + '_log.ldf'')
COLLATE Czech_CS_AS
ALTER DATABASE ' + @DB4 + ' SET RECOVERY ' + @RECOVERY + ';'

SET @CREATE5 ='CREATE DATABASE ' + @DB5  + '
ON
( NAME = ' + @DB5 + ', FILENAME = ''' + @path + @DB5 + '.mdf'')
LOG ON
( NAME = ' + @DB5 + '_log, FILENAME = ''' + @path + @DB5 + '_log.ldf'')
COLLATE Czech_CS_AS
ALTER DATABASE ' + @DB5 + ' SET RECOVERY ' + @RECOVERY + ';'


EXECUTE (@CREATE1);
EXECUTE (@CREATE2);
EXECUTE (@CREATE3);
EXECUTE (@CREATE4);
EXECUTE (@CREATE5);



GO

USE 'pal3g_attach';
EXEC sp_changedbowner 'pal';

USE 'pal3g_qsd';
EXEC sp_changedbowner 'pal';

USE 'pal3g_archiv';
EXEC sp_changedbowner 'pal';

USE 'pal3g_data';
EXEC sp_changedbowner 'pal';

USE 'pal3g_demodata';
EXEC sp_changedbowner 'pal';

GO