use [webcollabodb]
GO

if not exists (select * from master.dbo.syslogins where loginname = N'sj3user')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'日本語'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'sj3user', 'sj3', @logindb, @loginlang
END
GO

if not exists (select * from dbo.sysusers where name = N'sj3user' and uid < 16382)
	EXEC sp_grantdbaccess N'sj3user', N'sj3user'
GO

exec sp_addrolemember N'db_owner', N'sj3user'
GO


if not exists (select * from master.dbo.syslogins where loginname = N'sj4user')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'日本語'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'sj4user', 'sj4', @logindb, @loginlang
END
GO

if not exists (select * from dbo.sysusers where name = N'sj4user' and uid < 16382)
	EXEC sp_grantdbaccess N'sj4user', N'sj4user'
GO

exec sp_addrolemember N'db_owner', N'sj4user'
GO


if not exists (select * from master.dbo.syslogins where loginname = N'ct21user')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'日本語'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'ct21user', 'ct21', @logindb, @loginlang
END
GO

if not exists (select * from dbo.sysusers where name = N'ct21user' and uid < 16382)
	EXEC sp_grantdbaccess N'ct21user', N'ct21user'
GO

exec sp_addrolemember N'db_owner', N'ct21user'
GO


if not exists (select * from master.dbo.syslogins where loginname = N'csuser')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'日本語'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'csuser', 'cs', @logindb, @loginlang
END
GO

if not exists (select * from dbo.sysusers where name = N'csuser' and uid < 16382)
	EXEC sp_grantdbaccess N'csuser', N'csuser'
GO

exec sp_addrolemember N'db_owner', N'csuser'
GO