· 6 years ago · Mar 17, 2019, 02:04 AM
1CREATE SEQUENCE IF NOT EXISTS user_iduser_seq;
2CREATE TABLE IF NOT EXISTS public.user
3 (iduser serial NOT NULL,
4 firebaseid varchar NULL,
5 zipcode varchar NULL,
6 usertype varchar NULL,
7 CONSTRAINT user_pk PRIMARY KEY (iduser));
8ALTER SEQUENCE user_iduser_seq OWNED BY public.user.iduser;
9ALTER TABLE ONLY public.user ALTER COLUMN iduser SET DEFAULT nextval('user_iduser_seq'::regclass);