cli:franke:autoautopausa

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Nuova Autopausa=====
<code sql>
alter table tmprog add column dow integer;
alter table tmprog add column codpauper integer DEFAULT 1;
alter table tmprog add column lockubi integer DEFAULT 0;

CREATE TABLE public.pauper (
    codice integer NOT NULL,
    tmbgn double precision,
    descrizio character varying(256)
);

ALTER TABLE public.pauper OWNER TO postgres;

COMMENT ON TABLE public.pauper IS 'Definisce i periodi di validita'' delle pause programmate (tmprog)';

COMMENT ON COLUMN public.pauper.codice IS 'codice univoco';

COMMENT ON COLUMN public.pauper.tmbgn IS 'Istante temporale di inizio della validita'' delle configurazioni associate';

COMMENT ON COLUMN public.pauper.descrizio IS 'descrizione del periodo';

ALTER TABLE ONLY public.pauper ADD CONSTRAINT ix_pauper_codice PRIMARY KEY (codice);

ALTER TABLE ONLY public.pauper ADD CONSTRAINT uk_pauper_tmbgn UNIQUE (tmbgn);

INSERT INTO public.pauper VALUES (1, 0, 'Default');
update tmprog set dow=1;

ALTER TABLE ONLY public.tmprog ADD CONSTRAINT ix_tmprog_codpauper FOREIGN KEY (codpauper) REFERENCES public.pauper(codice) ON UPDATE CASCADE ON DELETE CASCADE;
</code>

====Libreria dedicata:====
{{ :cli:franke:autopausa.tar.gz |}}

====Piattaforma:====
<code xml>
		<!-- Agente che gestisce l'autopausa  -->
		<agent lib="/usr/lib/libautopausa.so.0.0.0" create="agentAutoPausa" live="1" name="autopausa_FFU">
			<param name="agdb" value="tpevodb_nolog" />
			<param name="agweblog" value="weblog_FFU" />
			<param name="agfermi" value="fermistp_FFU" />
			<param name="caufm" value="pausa" />
			<param name="tiposet" value="P" />
			<param name="usepauper" value="1" />

			<param name="pparam" value="0" />
			<param name="tm" value="1000" />
		</agent>
		<!-- Agente che si occupa di scrivere su weblog  -->
		<agent lib="/usr/lib/libremotecs.so.0.0.0" create="agentWebLog" live="1" name="weblog_FFU">
			<param name="agdb" value="tpevodb" />
		</agent>
</code>

====Modidica menù====
	* #tmprog diventa -> #tmprog-weekly