All pastes #1951800 Raw Edit

Stuff

public sql v1 · immutable
#1951800 ·published 2010-09-30 12:55 UTC
rendered paste body
CREATE TABLE user_data (    id bigint NOT NULL,    email character varying(128) NOT NULL,    created timestamp with time zone DEFAULT now());ALTER TABLE public.user_data OWNER TO postgres;CREATE SEQUENCE user_id_seq    INCREMENT BY 1    NO MAXVALUE    NO MINVALUE    CACHE 1;ALTER TABLE public.user_id_seq OWNER TO postgres;ALTER SEQUENCE user_id_seq OWNED BY user_data.id;ALTER TABLE user_data ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);CREATE VIEW "user" AS    SELECT user_data.id, user_data.email, user_data.created FROM user_data;ALTER TABLE public."user" OWNER TO postgres;ALTER TABLE "user" ALTER COLUMN created SET DEFAULT now();CREATE RULE on_delete AS ON DELETE TO "user" DO INSTEAD DELETE FROM user_data WHERE (user_data.id = old.id);CREATE RULE on_insert AS ON INSERT TO "user" DO INSTEAD (INSERT INTO user_data (id, email, created) VALUES (new.id, new.email, new.created));CREATE RULE on_update AS ON UPDATE TO "user" DO INSTEAD (UPDATE user_data SET id = new.id, email = new.email, created = new.created WHERE (user_data.id = old.id));