scimbosh / simple-spring-backend Goto Github PK

CREATE TABLE IF NOT EXISTS public.users
(
    id bigint PRIMARY KEY  NOT NULL DEFAULT nextval('users_seq'::regclass),
    username character varying(100) COLLATE pg_catalog."default" NOT null UNIQUE,
    password character varying(100) COLLATE pg_catalog."default" NOT NULL,
	roles character varying[] COLLATE pg_catalog."default" NOT NULL
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.users
    OWNER to postgres;

CREATE TABLE IF NOT EXISTS public.todos
(
    id integer PRIMARY KEY NOT NULL DEFAULT nextval('todos_seq'::regclass),
	userid bigint NOT NULL,
    username character varying(100),
    content character varying(1000) COLLATE pg_catalog."default",
    checked boolean
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.todos
    OWNER to postgres;