--INSERT INTO TBDD_GUI_LANGUAGE_PHRASE (
--		MODULE,	INTERNAL,	OBJ_NAME,	TITLE,		LANGUAGE,CAPT_TYPE,	STRING1,String2)
--  VALUES
--	(	'MWF',	1,			'1',		'Title 1',	'de-DE','Title',	'VA Freigabe','Freigabe in Rolle Verantwortlich')
--GO
--INSERT INTO TBDD_GUI_LANGUAGE_PHRASE (
--		MODULE,	INTERNAL,	OBJ_NAME,	TITLE,		LANGUAGE,CAPT_TYPE,	STRING1,String2)
--  VALUES
--	(	'MWF',	1,			'3',		'Title 93',	'de-DE','Title',	'Finale Freigabe','Freigabe in Rolle Finaler Freigeber')
--GO
select * from TBMWF_PROFILE

INSERT INTO [dbo].[TBMWF_PROFILE]
           ([INTL_NAME]
           ,[PM_PROFILE_ID]
           ,[TYPE_ID]
           ,[ACTIVE]
           ,[FORE_COLOR]
           ,[BACK_COLOR]      )
     VALUES
           ('TEST PROFIL MobileWorkflow - '
           ,6
           ,1
           ,1
           ,'Yellow'
           ,'Black')
GO

INSERT INTO [dbo].[TBMWF_PROFILE]
           ([INTL_NAME]
           ,[PM_PROFILE_ID]
           ,[TYPE_ID]
           ,[ACTIVE]
           ,[FORE_COLOR]
           ,[BACK_COLOR]      )
     VALUES
           ('TEST PROFIL MobileWorkflow - Finale Freigabe'
           ,9
           ,1
           ,1
           ,'Green'
           ,'Black')
GO
select * from TBMWF_PROFILE_OBJ_STATE

INSERT INTO TBMWF_PROFILE_OBJ_STATE (MWF_PROFILE_ID,USR_ID,OBJ_ID,STATE_ID) VALUES
(1,1,12968,1);
DECLARE @GUID BIGINT 
SELECT @GUID = MAX(GUID) FROM TBMWF_PROFILE_OBJ_STATE;
INSERT INTO TBMWF_PROF_CONTROLS_TF (
		OBJ_STATE_ID,ATTR_NAME,	CTRL_TYPE,	CAPTION,			TEXT,				ICON,			MANDATORY,	CHOICE_LIST,	READ_ONLY,	SEQU)
VALUES	(@GUID,			'INV_NO',	'TXT',		'Rechnungs-Nummer',	'RE-4711',			'bookmark',		0,			'',				1,			0),
		(@GUID,			'CREDITOR',	'TXT',		'Kreditor-Name',	'Europcar GmbH',	'credit-card',	0,			'',				1,			1),
		(@GUID,			'Combobox1','CMB',		'Ein Combo-Feld:',	'',					'check2-circle',1,			'Eintrag1;Eintrag2',		0,			2),
		(@GUID,			'Comment','TXT',		'Bemerkung',		'',					'chat-square-text',			0,			'',				0,			3);


INSERT INTO TBMWF_PROFILE_USER (MWF_PROFILE_ID,USR_ID) VALUES (1,1),(2,1);
INSERT INTO [dbo].[TBMWF_PROF_BUTTONS]
           ([MWF_PROFILE_ID]
           ,[BTN_TYPE]
           ,[TEXT]
           ,[ICON]
           ,[FORE_COLOR]
           ,[BACK_COLOR]
           ,[COMMAND]
		   ,ADDED_WHO
           )
     VALUES
           (1
           ,1
           ,'Genehmigen'
           ,'check-square-fill'
           ,''
           ,'Green'
           ,'UPDATE TBMWF_PROFILE_OBJ_STATE SET STATE_ID = 3 WHERE GUID = @OBJ_STATE_ID '
           ,'DD-MS')
GO
INSERT INTO [dbo].[TBMWF_PROF_BUTTONS]
           ([MWF_PROFILE_ID]
           ,[BTN_TYPE]
           ,[TEXT]
           ,[ICON]
           ,[FORE_COLOR]
           ,[BACK_COLOR]
           ,[COMMAND]
		   ,ADDED_WHO
           )
     VALUES
           (1
           ,2
           ,'Ablehnen'
           ,'sign-stop-fill'
           ,''
           ,'Red'
           ,'UPDATE TBMWF_PROFILE_OBJ_STATE SET STATE_ID = 4 WHERE GUID = @OBJ_STATE_ID '
           ,'DD-MS')
GO