Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Table: public.config
- -- DROP TABLE public.config;
- CREATE TABLE public.config
- (
- id character varying(255) NOT NULL,
- dia_emision integer NOT NULL,
- dia_vencimiento integer NOT NULL,
- fecha_creacion timestamp with time zone,
- fecha_ultima_modificacion timestamp with time zone,
- CONSTRAINT config_pk PRIMARY KEY (id)
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE public.config
- OWNER TO postgres;
- COMMENT ON TABLE public.config
- IS 'Esta tabla solo puede contener un registro y solo uno';
- -- Trigger: check_record on public.config
- -- DROP TRIGGER check_record ON public.config;
- CREATE TRIGGER check_record
- BEFORE INSERT
- ON public.config
- FOR EACH ROW
- EXECUTE PROCEDURE public.check_record();
- -- Trigger: update_config on public.config
- -- DROP TRIGGER update_config ON public.config;
- CREATE TRIGGER update_config
- BEFORE UPDATE
- ON public.config
- FOR EACH ROW
- EXECUTE PROCEDURE public.update_config();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement