BEGIN TRANSACTION
CREATE TABLE dbo.MachineLocations (
	MachineLocationID uniqueidentifier PRIMARY KEY NOT NULL,
	Machine nvarchar(50) NOT NULL,
	Location nvarchar(50) NOT NULL,
	CONSTRAINT IX_MachineLocations UNIQUE(Machine));
GO
INSERT INTO Auth_Roles (RoleID, Name) VALUES ('f12b573f-edcb-490d-91c3-fa76f6502ffd', 'Machines');
COMMIT