Run #5

{
  "ok": false,
  "failed": [
    "hallucinated_tables:kind"
  ],
  "hallucinated": [
    "kind"
  ],
  "context_errors": []
}

{
  "specs": "Add column entity_score numeric default 0 with index DESC for ranking",
  "tables": [
    "memory_entities",
    "memory_relations"
  ]
}

Tu es DBA senior Postgres. Genere migration SQL idempotente.

TABLE agencecom.memory_entities :
  id uuid NOT NULL DEFAULT gen_random_uuid()
  kind USER-DEFINED NOT NULL
  name text NOT NULL
  slug text
  description text
  props jsonb NOT NULL DEFAULT '{}'::jsonb
  tags ARRAY DEFAULT '{}'::text[]
  active boolean NOT NULL DEFAULT true
  source_file_id uuid
  created_at timestamp with time zone NOT NULL DEFAULT now()
  updated_at timestamp with time zone NOT NULL DEFAULT now()

TABLE agencecom.memory_relations :
  id uuid NOT NULL DEFAULT gen_random_uuid()
  src_id uuid NOT NULL
  dst_id uuid NOT NULL
  relation text NOT NULL
  props jsonb DEFAULT '{}'::jsonb
  created_at timestamp with time zone NOT NULL DEFAULT now()

SPECS:
[missing:specs]

REGLES: schema prefix agencecom., IF NOT EXISTS, DO blocks idempotence, DROP IF EXISTS sur policies avant recreate, jamais DROP TABLE sans IF EXISTS et review DG.

REPONDS UNIQUEMENT bloc sql.

```sql
-- Création du type enum "kind" s'il n'existe pas (supposé par la colonne "kind")
DO $$
BEGIN
    IF NOT EXISTS (
        SELECT 1
        FROM pg_type t
        JOIN pg_namespace n ON n.oid = t.typnamespace
        WHERE t.typname = 'kind' AND n.nspname = 'agencecom'
    ) THEN
        CREATE TYPE agencecom.kind AS ENUM ();
    END IF;
END$$;

-- Table memory_entities
CREATE TABLE IF NOT EXISTS agencecom.memory_entities (
    id uuid NOT NULL DEFAULT gen_random_uuid(),
    kind agencecom.kind NOT NULL,
    name text NOT NULL,
    slug text,
    description text,
    props jsonb NOT NULL DEFAULT '{}'::jsonb,
    tags text[] DEFAULT '{}'::text[],
    active boolean NOT NULL DEFAULT true,
    source_file_id uuid,
    created_at timestamptz NOT NULL DEFAULT now(),
    updated_at timestamptz NOT NULL DEFAULT now(),
    CONSTRAINT memory_entities_pkey PRIMARY KEY (id)
);

-- Table memory_relations
CREATE TABLE IF NOT EXISTS agencecom.memory_relations (
    id uuid NOT NULL DEFAULT gen_random_uuid(),
    src_id uuid NOT NULL,
    dst_id uuid NOT NULL,
    relation text NOT NULL,
    props jsonb DEFAULT '{}'::jsonb,
    created_at timestamptz NOT NULL DEFAULT now(),
    CONSTRAINT memory_relations_pkey PRIMARY KEY (id)
);

-- Ajout idempotent de la contrainte de clé primaire si la table a été créée sans elle auparavant
DO $$
BEGIN
    IF NOT EXISTS (
        SELECT 1
        FROM pg_constraint c
        JOIN pg_namespace n ON n.oid = c.connamespace
        WHERE c.conname = 'memory_entities_pkey' AND n.nspname = 'agencecom'
    ) THEN
        ALTER TABLE agencecom.memory_entities ADD CONSTRAINT memory_entities_pkey PRIMARY KEY (id);
    END IF;
END$$;

DO $$
BEGIN
    IF NOT EXISTS (
        SELECT 1
        FROM pg_constraint c
        JOIN pg_namespace n ON n.oid = c.connamespace
        WHERE c.conname = 'memory_relations_pkey' AND n.nspname = 'agencecom'
    ) THEN
        ALTER TABLE agencecom.memory_relations ADD CONSTRAINT memory_relations_pkey PRIMARY KEY (id);
    END IF;
END$$;
```