Advertisement
Guest User

Untitled

a guest
Dec 1st, 2015
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. -- Table: public.config
  2.  
  3. -- DROP TABLE public.config;
  4.  
  5. CREATE TABLE public.config
  6. (
  7. id character varying(255) NOT NULL,
  8. dia_emision integer NOT NULL,
  9. dia_vencimiento integer NOT NULL,
  10. fecha_creacion timestamp with time zone,
  11. fecha_ultima_modificacion timestamp with time zone,
  12. CONSTRAINT config_pk PRIMARY KEY (id)
  13. )
  14. WITH (
  15. OIDS=FALSE
  16. );
  17. ALTER TABLE public.config
  18. OWNER TO postgres;
  19. COMMENT ON TABLE public.config
  20. IS 'Esta tabla solo puede contener un registro y solo uno';
  21.  
  22. -- Trigger: check_record on public.config
  23.  
  24. -- DROP TRIGGER check_record ON public.config;
  25.  
  26. CREATE TRIGGER check_record
  27. BEFORE INSERT
  28. ON public.config
  29. FOR EACH ROW
  30. EXECUTE PROCEDURE public.check_record();
  31.  
  32. -- Trigger: update_config on public.config
  33.  
  34. -- DROP TRIGGER update_config ON public.config;
  35.  
  36. CREATE TRIGGER update_config
  37. BEFORE UPDATE
  38. ON public.config
  39. FOR EACH ROW
  40. EXECUTE PROCEDURE public.update_config();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement