-- Fulltext Indexes erzeugen in der 8.4 Datenbank

CREATE INDEX ft_gin_access ON fulltext USING gin(to_tsvector('german', "access"));
CREATE INDEX ft_gin_akteinh ON fulltext USING gin(to_tsvector('german', akteinh));
CREATE INDEX ft_gin_bemerk ON fulltext USING gin(to_tsvector('german', bemerk));
CREATE INDEX ft_gin_dokinh ON fulltext USING gin(to_tsvector('german', dokinh));
CREATE INDEX ft_gin_entl ON fulltext USING gin(to_tsvector('german', entl));
CREATE INDEX ft_gin_hinwalak ON fulltext USING gin(to_tsvector('german', hinwalak));
-- CREATE INDEX ft_gin_hinweis ON fulltext USING gin(to_tsvector('german', hinweis));
CREATE INDEX ft_gin_standort ON fulltext USING gin(to_tsvector('german', standort));
CREATE INDEX ft_gin_stichwoa ON fulltext USING gin(to_tsvector('german', stichwoa));
CREATE INDEX ft_gin_stichwod ON fulltext USING gin(to_tsvector('german', stichwod));
CREATE INDEX ft_gin_urhebnam ON fulltext USING gin(to_tsvector('german', urhebnam));
CREATE INDEX ft_gin_volltext ON fulltext USING gin(to_tsvector('german', volltext));







--  Änderungen an der Datenbank Struktur

ALTER TABLE fulltext ALTER COLUMN gelid TYPE character varying(50);
ALTER TABLE fulltext ALTER COLUMN aendid TYPE character varying(50);



-- Änderungen im Standard Workflow



DELETE FROM WF_StateDescription WHERE WFState = 2 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (2
		   ,'Verteiler'
           ,'WFS_Verteiler("")'
           ,'Abgelehnt=28;Einreicher=26;Ablegen=3;Finished=5;Mitzeichnen=6;Stellungnahme=7;Kenntnisnahme=8;Wiedervorlage=9;Absendung=10;Schlusszeichnung=11;ZdA=12;Weiterleiten=27;Bearbeiten=30;Umlauf-Ende=31;Post-Absendung=38;Post-Beglaubigung=34;Post-Unterschrift=36;'
           ,1);

		   
DELETE FROM WF_StateDescription WHERE WFState = 10 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (10
		   ,'Absendung'
           ,'WFS_Absendung("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'Ok=17;deny=21'
           ,1);


DELETE FROM WF_StateDescription WHERE WFState = 18 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (18
		   ,'Weiterleiten'
           ,'WFS_Kenntnisnahme("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'OK=39;deny=21'
           ,1);


		   
DELETE FROM WF_StateDescription WHERE WFState = 19 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (19
		   ,'Abgelehnt'
           ,'WFS_Abgelehnt("cmdOK=Neustart;cmdDeny=Ablegen")'
           ,'OK=20;deny=25'
           ,1);
		   		   
		   
DELETE FROM WF_StateDescription WHERE WFState = 20 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (20
		   ,'Abgelegt'
           ,'WFS_Abgelegt("cmdOK=Neustart")'
           ,'OK=20;'
           ,1);
		   		   

DELETE FROM WF_StateDescription WHERE WFState = 21 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (21
		   ,'Bearbeiten'
           ,'WFS_Kenntnisnahme("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'OK=20;deny=21'
           ,1);

DELETE FROM WF_StateDescription WHERE WFState = 22 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (22
		   ,'Umlauf-Ende'
           ,'WFS_Kenntnisnahme("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'OK=20;deny=21'
           ,1);


DELETE FROM WF_StateDescription WHERE WFState = 23 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (23
		   ,''
           ,''
           ,'32'
           ,1);

DELETE FROM WF_StateDescription WHERE WFState = 24 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (24
		   ,'Post-Beglaubigung'
           ,'WFS_Absendung("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'Ok=35;deny=21'
           ,1);

		   
		   
DELETE FROM WF_StateDescription WHERE WFState = 25 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (25
		   ,'Post-Unterschrift'
           ,'WFS_Absendung("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'Ok=37;deny=21'
           ,1);

DELETE FROM WF_StateDescription WHERE WFState = 26 AND WFID = 1;
INSERT INTO WF_StateDescription (WFState ,WFName ,WFStatement ,WFParams  ,WFID) VALUES
           (26
		   ,'Post-Absendung'
           ,'WFS_Absendung("cmdOK=OK;cmdDeny=Ablehnen")'
           ,'Ok=38;deny=21'
           ,1);

-- WF_Action		   
		   
		   

DELETE FROM WF_Action WHERE WFActionID = 1 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (1, 'WFC_Anlegen("")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 2 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (2, '', 9, 1);

DELETE FROM WF_Action WHERE WFActionID = 3 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (3, '', 3, 1);

DELETE FROM WF_Action WHERE WFActionID = 4 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (4, '', 4, 1);

DELETE FROM WF_Action WHERE WFActionID = 5 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (5, 'WFC_EinreicherAktivieren("Einreicher")', 14, 1);

DELETE FROM WF_Action WHERE WFActionID = 6 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (6, '', 6, 1);

DELETE FROM WF_Action WHERE WFActionID = 7 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (7, '', 7, 1);

DELETE FROM WF_Action WHERE WFActionID = 8 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (8, '', 8, 1);

DELETE FROM WF_Action WHERE WFActionID = 9 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (9, '', 9, 1);

DELETE FROM WF_Action WHERE WFActionID = 10 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (10, '', 10, 1);

DELETE FROM WF_Action WHERE WFActionID = 11 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (11, '', 11, 1);

DELETE FROM WF_Action WHERE WFActionID = 12 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (12, '', 12, 1);

DELETE FROM WF_Action WHERE WFActionID = 13 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (13, 'WFC_Log("Mitzeichnung bestätigt")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 14 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (14, 'WFC_Log("Stellungnahme abgegeben")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 15 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (15, 'WFC_Log("Kenntnisnahme erfolgt")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 16 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (16, 'WFC_Log("Wiedervorlage")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 17 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (17, 'WFC_Log("Absendung erfolgt")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 18 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (18, 'WFC_Log("Schlusszeichnung erfolgt")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 19 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (19, 'WFC_ZdA("ZdA")', 20, 1);

DELETE FROM WF_Action WHERE WFActionID = 20 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (20, 'WFC_WFRestart("Vorgang wurde neu gestartet")', 2, 1);

DELETE FROM WF_Action WHERE WFActionID = 21 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (21, 'WFC_Log("Abgelehnt")', 16, 1);

DELETE FROM WF_Action WHERE WFActionID = 22 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (22, 'WFC_EinreicherAktivieren("Abgelehnt")', 19, 1);

DELETE FROM WF_Action WHERE WFActionID = 25 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (25, 'WFC_Ablegen("abgelegt")', 20, 1);

DELETE FROM WF_Action WHERE WFActionID = 26 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (26, '', 14, 1);

DELETE FROM WF_Action WHERE WFActionID = 27 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (27, '', 18, 1);

DELETE FROM WF_Action WHERE WFActionID = 28 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
 (28, '', 19, 1);
		   
		   

DELETE FROM WF_Action WHERE WFActionID = 29 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (29
           ,'WFC_Log("Bearbeiten")'
           ,2
           ,1);
	
DELETE FROM WF_Action WHERE WFActionID = 30 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (30
           ,''
           ,21
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 31 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (31
           ,''
           ,22
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 32 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (32
           ,'WFC_UmlaufEnde("Umlauf-Ende")'
           ,20
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 33 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (33
           ,'WFC_Log("Umlauf-Ende")'
           ,23
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 34 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (34
           ,''
           ,24
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 35 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (35
           ,'WFC_Log("Absendung mit Beglaubigung erfolgt")'
           ,2
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 36 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (36
           ,''
           ,25
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 37 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (37
           ,'WFC_Log("Absendung mit Unterschrift erfolgt")'
           ,2
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 38 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (38
           ,'WFC_Log("Post Absendung erfolgt")'
           ,2
           ,1);

DELETE FROM WF_Action WHERE WFActionID = 39 AND WFID = 1;
INSERT INTO WF_Action (WFActionID ,WFCommand, WFNextState, WFID) VALUES
           (39
           ,'WFC_Log("Weiterleitung")'
           ,2
           ,1);