MK SİGORTA

-- Ana veri tablosu
create table if not exists mk_database (
  id integer primary key default 1,
  data jsonb not null default '{}',
  updated_at timestamptz default now()
);
create unique index if not exists mk_database_single on mk_database (id);
alter table mk_database disable row level security;

-- Yedek tablosu
create table if not exists mk_backups (
  id text primary key,
  tarih text,
  saat text,
  data jsonb not null default '{}',
  created_at timestamptz default now()
);
alter table mk_backups disable row level security;

-- Ayarlar tablosu (şifre, kullanıcılar vb. cihazlar arası senkronizasyon)
create table if not exists mk_settings (
  key text primary key,
  value text not null default '',
  updated_at timestamptz default now()
);
alter table mk_settings disable row level security;

-- ════════════════════════════════════════
-- MK SİGORTA — VERİ YEDEKLEMİ 2
-- Proje: wgqxegfrufndxzaiumgp.supabase.co
-- ════════════════════════════════════════

-- 1) Ana veri tablosu (ikincil kopya)
create table if not exists mk_database (
  id integer primary key default 1,
  data jsonb not null default '{}',
  updated_at timestamptz default now()
);
create unique index if not exists mk_database_single on mk_database (id);
alter table mk_database disable row level security;

-- Otomatik updated_at trigger
create or replace function mk_set_updated_at()
returns trigger language plpgsql as $$
begin new.updated_at = now(); return new; end;
$$;
drop trigger if exists mk_database_updated_at on mk_database;
create trigger mk_database_updated_at
  before update on mk_database
  for each row execute procedure mk_set_updated_at();

-- 2) Yedek tablosu (manuel & otomatik yedekler)
create table if not exists mk_backups (
  id text primary key,
  tarih text,
  saat text,
  kaynak text default 'yedek2',
  aciklama text default '',
  data jsonb not null default '{}',
  created_at timestamptz default now()
);
alter table mk_backups disable row level security;

-- Fazla yedek otomatik temizleme (isteğe bağlı, en fazla 50 yedek)
create or replace function mk_trim_backups()
returns trigger language plpgsql as $$
begin
  delete from mk_backups
  where id in (
    select id from mk_backups
    order by created_at desc
    offset 50
  );
  return new;
end;
$$;
drop trigger if exists mk_backups_trim on mk_backups;
create trigger mk_backups_trim
  after insert on mk_backups
  for each row execute procedure mk_trim_backups();

-- 3) Ayarlar tablosu
create table if not exists mk_settings (
  key text primary key,
  value text not null default '',
  updated_at timestamptz default now()
);
alter table mk_settings disable row level security;

-- 4) Yedek2 özel log tablosu (senkron geçmişi)
create table if not exists mk_sync_log (
  id bigserial primary key,
  islem text not null,
  durum text not null,
  mesaj text default '',
  kayit_sayisi integer default 0,
  created_at timestamptz default now()
);
alter table mk_sync_log disable row level security;

-- Test verisi ekle (bağlantı doğrulama için)
insert into mk_database (id, data) values (1, '{"_init": true}')
on conflict (id) do nothing;

select 'MK Sigorta Yedek2 tabloları başarıyla oluşturuldu ✓' as sonuc;