13 lines
367 B
MySQL
13 lines
367 B
MySQL
|
-- AP0.1: minimale Schema-Vorbereitung (keine Tenant/User/Actor-Fachlogik)
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS kairo_app_meta (
|
||
|
|
id SERIAL PRIMARY KEY,
|
||
|
|
key VARCHAR(128) UNIQUE NOT NULL,
|
||
|
|
value TEXT NOT NULL,
|
||
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
||
|
|
);
|
||
|
|
|
||
|
|
INSERT INTO kairo_app_meta (key, value)
|
||
|
|
VALUES ('schema_phase', 'ap0.1')
|
||
|
|
ON CONFLICT (key) DO NOTHING;
|