CREATE TABLE IF NOT EXISTS public.dsm_user(
  uid bigint NOT NULL,
  name text NOT NULL
);
ALTER TABLE public.dsm_user DROP CONSTRAINT IF EXISTS dsm_user_pkey;
ALTER TABLE public.dsm_user ADD CONSTRAINT dsm_user_pkey PRIMARY KEY (uid);
CREATE INDEX IF NOT EXISTS dsm_user_name_idx ON public.dsm_user
  USING btree(name);
CREATE TABLE IF NOT EXISTS public.dsm_group(
  gid bigint NOT NULL,
  name text NOT NULL
);
ALTER TABLE public.dsm_group DROP CONSTRAINT IF EXISTS dsm_group_pkey;
ALTER TABLE public.dsm_group ADD CONSTRAINT dsm_group_pkey PRIMARY KEY (gid);
CREATE INDEX IF NOT EXISTS dsm_group_name_idx ON public.dsm_group
  USING btree(name);
DROP INDEX IF EXISTS public.takentime_month_idx;
CREATE INDEX IF NOT EXISTS takentime_month_idx ON public.takentime
  USING btree
  (
    takentime_month
  );
ALTER TABLE public.folder
  ADD COLUMN IF NOT EXISTS normalized_name text NOT NULL DEFAULT '';
CREATE INDEX IF NOT EXISTS folder_normalized_name_idx ON public.folder
  USING btree(normalized_name);