-- iPad-Wagen Reservierungssystem · Supabase SQL Schema create table if not exists carts ( id bigserial primary key, name text not null, ipads int not null default 30, locked bool not null default false, sort_order int not null default 0 ); create table if not exists reservations ( id bigserial primary key, cart_id bigint references carts(id) on delete cascade, date_key text not null, period int not null, teacher text not null, subject text not null, unique(cart_id, date_key, period) ); create table if not exists damages ( id bigserial primary key, cart_id bigint references carts(id) on delete cascade, ipad_number int not null, type text not null, description text not null, reporter text not null, created_at timestamptz default now(), fixed bool not null default false ); create table if not exists ipad_labels ( id bigserial primary key, cart_id bigint references carts(id) on delete cascade, ipad_number int not null, label text not null, unique(cart_id, ipad_number) ); create table if not exists app_settings ( key text primary key, value jsonb ); -- Standard-Wagen einfügen insert into carts (name, ipads, sort_order) values ('iPad-Wagen 1', 30, 1), ('iPad-Wagen 2', 30, 2), ('iPad-Wagen 3', 30, 3) on conflict do nothing; -- Standard-Einstellungen insert into app_settings (key, value) values ('restrictions', '{"settingsAdminOnly":true,"exportAdminOnly":false,"lockAdminOnly":false,"delResAdminOnly":false}') on conflict do nothing; -- Realtime aktivieren alter publication supabase_realtime add table carts, reservations, damages, ipad_labels, app_settings;