1
CREATE TABLE user_data (
3
email character varying(128) NOT NULL,
4
created timestamp with time zone DEFAULT now()
7
ALTER TABLE public.user_data OWNER TO postgres;
9
CREATE SEQUENCE user_id_seq
15
ALTER TABLE public.user_id_seq OWNER TO postgres;
17
ALTER SEQUENCE user_id_seq OWNED BY user_data.id;
19
ALTER TABLE user_data ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);
22
SELECT user_data.id, user_data.email, user_data.created FROM user_data;
24
ALTER TABLE public."user" OWNER TO postgres;
25
ALTER VIEW public."user" OWNER TO postgres;
27
ALTER TABLE "user" ALTER COLUMN created SET DEFAULT now();
28
ALTER VIEW "user" ALTER COLUMN created SET DEFAULT now();
30
CREATE RULE on_delete AS ON DELETE TO "user" DO INSTEAD DELETE FROM user_data WHERE (user_data.id = old.id);
31
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));
32
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));
b'\\ No newline at end of file'