am_id_schema_migration.sql

ALTER TABLE "users" ALTER COLUMN "users_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "users_users_id_seq" AS integer;
ALTER TABLE "users" ALTER COLUMN "users_id" SET DEFAULT nextval('"users_users_id_seq"'::regclass);
ALTER SEQUENCE "users_users_id_seq" OWNED BY "users"."users_id";
SELECT setval('"users_users_id_seq"', (SELECT MAX("users_id") FROM "users"));

ALTER TABLE "sessions" ALTER COLUMN "sessions_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "sessions_sessions_id_seq" AS integer;
ALTER TABLE "sessions" ALTER COLUMN "sessions_id" SET DEFAULT nextval('"sessions_sessions_id_seq"'::regclass);
ALTER SEQUENCE "sessions_sessions_id_seq" OWNED BY "sessions"."sessions_id";
SELECT setval('"sessions_sessions_id_seq"', (SELECT MAX("sessions_id") FROM "sessions"));

ALTER TABLE "prefs" ALTER COLUMN "prefs_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "prefs_prefs_id_seq" AS integer;
ALTER TABLE "prefs" ALTER COLUMN "prefs_id" SET DEFAULT nextval('"prefs_prefs_id_seq"'::regclass);
ALTER SEQUENCE "prefs_prefs_id_seq" OWNED BY "prefs"."prefs_id";
SELECT setval('"prefs_prefs_id_seq"', (SELECT MAX("prefs_id") FROM "prefs"));

ALTER TABLE "machines" ALTER COLUMN "machines_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "machines_machines_id_seq" AS integer;
ALTER TABLE "machines" ALTER COLUMN "machines_id" SET DEFAULT nextval('"machines_machines_id_seq"'::regclass);
ALTER SEQUENCE "machines_machines_id_seq" OWNED BY "machines"."machines_id";
SELECT setval('"machines_machines_id_seq"', (SELECT MAX("machines_id") FROM "machines"));

ALTER TABLE "layouts" ALTER COLUMN "layouts_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "layouts_layouts_id_seq" AS integer;
ALTER TABLE "layouts" ALTER COLUMN "layouts_id" SET DEFAULT nextval('"layouts_layouts_id_seq"'::regclass);
ALTER SEQUENCE "layouts_layouts_id_seq" OWNED BY "layouts"."layouts_id";
SELECT setval('"layouts_layouts_id_seq"', (SELECT MAX("layouts_id") FROM "layouts"));

ALTER TABLE "last_updated" ALTER COLUMN "last_updated_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "last_updated_last_updated_id_seq" AS integer;
ALTER TABLE "last_updated" ALTER COLUMN "last_updated_id" SET DEFAULT nextval('"last_updated_last_updated_id_seq"'::regclass);
ALTER SEQUENCE "last_updated_last_updated_id_seq" OWNED BY "last_updated"."last_updated_id";
SELECT setval('"last_updated_last_updated_id_seq"', (SELECT MAX("last_updated_id") FROM "last_updated"));

ALTER TABLE "groups" ALTER COLUMN "groups_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "groups_groups_id_seq" AS integer;
ALTER TABLE "groups" ALTER COLUMN "groups_id" SET DEFAULT nextval('"groups_groups_id_seq"'::regclass);
ALTER SEQUENCE "groups_groups_id_seq" OWNED BY "groups"."groups_id";
SELECT setval('"groups_groups_id_seq"', (SELECT MAX("groups_id") FROM "groups"));

ALTER TABLE "glue42SystemConfig" ALTER COLUMN "glue42SystemConfig_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "glue42SystemConfig_glue42SystemConfig_id_seq" AS integer;
ALTER TABLE "glue42SystemConfig" ALTER COLUMN "glue42SystemConfig_id" SET DEFAULT nextval('"glue42SystemConfig_glue42SystemConfig_id_seq"'::regclass);
ALTER SEQUENCE "glue42SystemConfig_glue42SystemConfig_id_seq" OWNED BY "glue42SystemConfig"."glue42SystemConfig_id";
SELECT setval('"glue42SystemConfig_glue42SystemConfig_id_seq"', (SELECT MAX("glue42SystemConfig_id") FROM "glue42SystemConfig"));

ALTER TABLE "feedback" ALTER COLUMN "feedback_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "feedback_feedback_id_seq" AS integer;
ALTER TABLE "feedback" ALTER COLUMN "feedback_id" SET DEFAULT nextval('"feedback_feedback_id_seq"'::regclass);
ALTER SEQUENCE "feedback_feedback_id_seq" OWNED BY "feedback"."feedback_id";
SELECT setval('"feedback_feedback_id_seq"', (SELECT MAX("feedback_id") FROM "feedback"));

ALTER TABLE "crashes" ALTER COLUMN "crashes_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "crashes_crashes_id_seq" AS integer;
ALTER TABLE "crashes" ALTER COLUMN "crashes_id" SET DEFAULT nextval('"crashes_crashes_id_seq"'::regclass);
ALTER SEQUENCE "crashes_crashes_id_seq" OWNED BY "crashes"."crashes_id";
SELECT setval('"crashes_crashes_id_seq"', (SELECT MAX("crashes_id") FROM "crashes"));

ALTER TABLE "commands_for_version" ALTER COLUMN "commands_for_version_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "commands_for_version_commands_for_version_id_seq" AS integer;
ALTER TABLE "commands_for_version" ALTER COLUMN "commands_for_version_id" SET DEFAULT nextval('"commands_for_version_commands_for_version_id_seq"'::regclass);
ALTER SEQUENCE "commands_for_version_commands_for_version_id_seq" OWNED BY "commands_for_version"."commands_for_version_id";
SELECT setval('"commands_for_version_commands_for_version_id_seq"', (SELECT MAX("commands_for_version_id") FROM "commands_for_version"));

ALTER TABLE "commands" ALTER COLUMN "commands_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "commands_commands_id_seq" AS integer;
ALTER TABLE "commands" ALTER COLUMN "commands_id" SET DEFAULT nextval('"commands_commands_id_seq"'::regclass);
ALTER SEQUENCE "commands_commands_id_seq" OWNED BY "commands"."commands_id";
SELECT setval('"commands_commands_id_seq"', (SELECT MAX("commands_id") FROM "commands"));

ALTER TABLE "blobs" ALTER COLUMN "blobs_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "blobs_blobs_id_seq" AS integer;
ALTER TABLE "blobs" ALTER COLUMN "blobs_id" SET DEFAULT nextval('"blobs_blobs_id_seq"'::regclass);
ALTER SEQUENCE "blobs_blobs_id_seq" OWNED BY "blobs"."blobs_id";
SELECT setval('"blobs_blobs_id_seq"', (SELECT MAX("blobs_id") FROM "blobs"));

ALTER TABLE "audit" ALTER COLUMN "audit_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "audit_audit_id_seq" AS integer;
ALTER TABLE "audit" ALTER COLUMN "audit_id" SET DEFAULT nextval('"audit_audit_id_seq"'::regclass);
ALTER SEQUENCE "audit_audit_id_seq" OWNED BY "audit"."audit_id";
SELECT setval('"audit_audit_id_seq"', (SELECT MAX("audit_id") FROM "audit"));

ALTER TABLE "app" ALTER COLUMN "app_id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "app_app_id_seq" AS integer;
ALTER TABLE "app" ALTER COLUMN "app_id" SET DEFAULT nextval('"app_app_id_seq"'::regclass);
ALTER SEQUENCE "app_app_id_seq" OWNED BY "app"."app_id";
SELECT setval('"app_app_id_seq"', (SELECT MAX("app_id") FROM "app"));

-- If using knex migrations


ALTER TABLE "knex_migrations_lock" ALTER COLUMN "index" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "knex_migrations_lock_index_seq" AS integer;
ALTER TABLE "knex_migrations_lock" ALTER COLUMN "index" SET DEFAULT nextval('"knex_migrations_lock_index_seq"'::regclass);
ALTER SEQUENCE "knex_migrations_lock_index_seq" OWNED BY "knex_migrations_lock"."index";
SELECT setval('"knex_migrations_lock_index_seq"', (SELECT MAX("index") FROM "knex_migrations_lock"));

ALTER TABLE "knex_migrations" ALTER COLUMN "id" DROP IDENTITY IF EXISTS;
CREATE SEQUENCE IF NOT EXISTS "knex_migrations_id_seq" AS integer;
ALTER TABLE "knex_migrations" ALTER COLUMN "id" SET DEFAULT nextval('"knex_migrations_id_seq"'::regclass);
ALTER SEQUENCE "knex_migrations_id_seq" OWNED BY "knex_migrations"."id";
SELECT setval('"knex_migrations_id_seq"', (SELECT MAX("id") FROM "knex_migrations"));